CHAPTER IV Census of Retail Trade--Nonemployer Statistics Abstract IV-3 Introduction IV-5 File Specifications IV-7 File Layouts IV-9 Database Structures IV-15 User Notes IV-21 CENSUS OF RETAIL TRADE--NONEMPLOYER STATISTICS Abstract CONTENTS Citation IV-3 Type of File IV-3 Universe Description IV-3 Subject-Matter Description IV-3 Geographic Coverage IV-3 Technical Description IV-3 Reference Materials IV-4 Related Printed Reports IV-4 Related Machine-Readable Data Files IV-4 Availability IV-4 CITATION Census of Retail Trade on CD-ROM, 1987: Non-employer Statistics [machine- readable data files] / prepared by the Bureau of the Census. Washington: The Bureau [producer and distributor], 1990. Type of File: Summary statistics. Universe Description: The universe of the first file is all retail trade establishments with or without payroll. The second and third files are confined to retail establishments without payroll. Subject-Matter Description: This series of three files provides 1987 statistics for establishments without payroll (nonemployers), designed to complement the statistics on establishments with payroll (employers) as published in the Geographic Area Series. The number of nonemployer establishments and their sales is reported by kind of business and by geographic area. One file also compares nonemployer, employer, and all-establishments statistics by kind of business in terms of the number of establishments, sales, and number of unincorporated businesses (sole proprietorships and partnerships) at the national level. Geographic Coverage: Data are provided for the United States, States, Metropolitan Statistical Areas (MSA's), Consolidated Metropolitan Statistical (CMSA's), Primary Metropolitan Areas (PMSA's), counties, and places with 2,500 inhabitants or more. Technical Description: File Structure: dBase III+ Each file has one or more ".NDX" index files and one or more label files that can be linked to it. In the RC87N3 files listed below, data for each State are available structured as separate files or together in a single cross-State file (XS). Each file name consists of the group name (RC87N3) plus the two-character postal abbreviation (e.g., AL), with the extension .DBF. For other State abbreviations, see Table 2 in the first section of this document. RC87N1US.dbf 1. File Sequence: Kind of business by employer/nonemployer status for the nation. 2. Available index: a. RC87N1US: By kind of business by employer/nonemployer status RC87N2XS.dbf 1. File sequence: State by kind of business followed by MSA by kind of business 2. Available indexes: a. RC87N2K: By kind of business by State, MSA, and PMSA b. RC87N2S: First record for each State c. RC87N2M: First record for each MSA or PMSA 3. Linkable label files: a. RTL87KB (kind-of-business titles, including SIC code) b. MISCCODE (record type labels) c. STCODE (State names) d. MSA (MSA, CMSA, and PMSA titles) RC87N3xx.dbf (xx=AL to WY, and XS) 1. File sequence: State by county by place, with State and county totals interspersed. Same sequence as RC87A3 files. 2. Available indexes: a. RC87NCxx: By record type by state by place by county b. RC87NMxx: By MSA by PMSA 3. Linkable label files: a. MSA (MSA, CMSA, and PMSA titles) Reference Materials: 1987 Economic Census CD-ROM Volume 1: Report Series, Release 1C Technical Documentation. This documentation has general information, record layouts for all files, and other reference material. One copy accompanies each tape order. Additional copies are available for $5 from Customer Services, Data User Services Division, Bureau of the Census, Washington, DC 20233. Guide to the 1987 Economic Censuses and Related Statistics. Describes the scope, coverage, classification systems, data items, and data products for each of the economic censuses and related surveys. Data comparability and uses are also discussed. Available single copies free from Customer Services, Data Users Services Division, Bureau of the Census, Washington, DC 20233. Standard Industrial Classification Manual 1987. Prepared by the Executive Office of the President, Office of Management and Budget and available from Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. Price is $24. Related Printed Reports: 1987 Census of Retail Trade, Nonemployer Statistics (RC87-N-1-4). Four separate reports, each containing data for the states located in one of the four different regions. Data are the same as in the CD-ROM files. For sale by the Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. For information about availability and prices of individual reports, contact Customer Services, Data User Services Division, Bureau of the Census, Washington, DC 20233. Related Machine-Readable Data Files: Census of Retail Trade on CD-ROM, 1987: Establishment and Firm Size. Presents national data for establishments with payroll by employment size of establishment (e.g., 1 employee, 2 employees, 3-4, etc.) and other detail. Nonemployer files supplement this report by giving complementary numbers on firms with no employees. Census of Retail Trade on CD-ROM, 1987: Merchandise Line Sales. Presents data by kind of business on major categories of merchandise sold by retail establishments with payroll. Geographic coverage includes the U.S. each State, and each MSA. (Available mid 1990) Census of Retail Trade on CD-ROM, 1987: Geographic Area Series. Presents data for establishments with payroll by SIC category and includes the number of establishments, sales, payroll, and employees for the U.S., States, metropolitan areas, counties, and places 2500+. These data for employers can be readily combined with nonemployer statistics to derive totals for all establishments. Census of Retail Trade on CD-ROM, 1987: ZIP Code Statistics. Shows the number of establishments with payroll by kind of business by employment- size class and by sales-size class for each ZIP code area. Also shown are total employment, payroll and sales by ZIP Code. Availability: The data are available on one CD-ROM for microcomputers. The subscription price of $475 includes up to 7 successive editions of discs as reissued every 3 to 4 months. Individual discs are $150. CENSUS OF RETAIL TRADE--NONEMPLOYER STATISTICS Introduction CONTENTS Background IV-5 Geographic Areas Covered IV-5 Background Since the 1954 Census of Business, data for individual proprietors and partnership businesses have been obtained from administrative records of the Internal Revenue Service (IRS). For tax year 1982, major changes in IRS processing procedures substantially reduced the quality of Principal Business Activity (PBA) codes assigned by IRS clerks to the records based on taxpayers descriptions of business activity, particularly for individual proprietor returns (form 1040, Schedule C), making it impossible for the Census Bureau to publish data nonemployer firms as planned for the 1982 Census of Retail Trade. In cooperation with the IRS, a subsequent "recovery" operation, using more reliable 1981 codes where available, permitting the publication of limited supplemental data for nonemployer firms, but only at the national level. Improvements in data collection and processing of nonemployer records for the 1987 Economic Censuses To improve classification deficiencies for the individual proprietor returns, a self-classification inquiry (included as part of Form 1040, Schedule C) was developed jointly by the Census Bureau and IRS, with advice from consultants from the Committee on National Statistics of the National Academy of Sciences. The objective of the modified form is to obtain complete codes for as high a percentage of returns as possible, while identifying those returns requiring further classification (i.e., those which are unclassified or in various miscellaneous or "basket" categories). The resulting form, similar in design to the form used for partnerships, was introduced by IRS for tax year 1985. Subsequent studies have shown that classifications derived from self-coding by taxpayers on the new form are superior to classifications based on clerical coding of the taxpayers' descriptions of business activity. Classification coding improvements gained by the introduction of the modified self-coding tax form have been augmented by the use of automated name-coding programs and clerical processing routines developed by the Census Bureau. Implementing these improvements has made it possible to publish useful data for nonemployer businesses at the national, State, and local levels as part of the 1987 Census of Retail Trade. Geographic Areas Covered This series presents data for the following areas: 1. The United States as a whole. 2. Each State and the District of Columbia. 3. Each consolidated metropolitan statistical area (CMSA) and primary metropolitan statistical area (PMSA) defined by the Office of Management and Budget as of June 30, 1987. A CMSA is an area used to facilitate the presentation and analysis of data for large concentrations of metropolitan populations. It includes two or more contiguous PMSA's which have a population of at least 1,000,000(1) and which meet specific criteria of urban character and of social and economic integration. 4. Each metropolitan statistical area (MSA) defined by the Office of Management and Budget as of June 30, 1987. An MSA is an integrated economic and social unit with a population nucleus of at least 50,000 inhabitants.(1) Each MSA consists of one or more counties meeting standards of metropolitan character; in New England, cities and towns rather than counties are the component geographic units. 5. Each county or county equivalent.(2) 6. Each municipality of 2,500 inhabitants or more incorporated as a city, borough, village, or town.(1)(2) For the economic censuses, census areas and borough in Alaska, boroughs in New York, and towns in New York and Wisconsin are not included in this category. 7. Special economic urban areas (SEUA's), which include townships in New Jersey and Pennsylvania and towns in New England with 10,000 inhabitants or more.(1) (1)According to 1980 Census of Population or subsequent special census. (2)Those defined as of January 1, 1987. Census of Retail Trade, 1987 Geographic Area Series Nonemployer Statistics FILE 1 LAYOUT --------------------------------------------------------------------------- Record Type File Description Field Num of Name Char US (Table 1) --------------------------------------------------------------------------- BUSTEXT 60 Data Alphabetic Kind-of-Business Description SICLIST 16 Data Listing of SIC Codes included in Kind-of-Business RTL87KB 3 Data Kind-of-Business Code (Table Stub Line Number) e.g. 001=Total Retail Trade EMPSTAT 1 Data Employer/Nonemployer Status `0' All establishments `1' Establishments with paid employees `2' Establishments with no paid employees RECTYPE 2 01 Record Type Code ESTABF 1 Data Data Flag `0' No suppression `5' Data not applicable (X) ESTAB 7 Data Number of establishments, 1987 SALESF 1 Data Data Flag SALES 10 Data Sales ($1,000), 1987 SOLEPROF 1 Data Data Flag SOLEPRO 7 Data Unincorporated businesses-Number of individual proprietorships, 1987 PARTSHPF 1 Data Data Flag PARTSHP 6 Data Unincorporated businesses-Number of partnerships, 1987 Record size is 116 characters. Equivalent printed report table is 1 in the nonemployer statistics publications. Census of Retail Trade, 1987 Nonemployer Statistics FILE 2 LAYOUT States and MSAs --------------------------------------------------------------------------- Record Type File Description Field Field Name Size State MSA/ or U.S. CMSA/ (Table 2) PMSA (Table 3) --------------------------------------------------------------------------- ST 2 Data NA FIPS State Code MSA 4 NA Data MSA/CMSA Code PMSA 4 NA Data/NA PMSA Code RECTYPE 2 02,01 04 Record Type Code RTL87KB 3 Data Data Kind-of-Business Code (Table Stub Line Number) e.g. 001=Total Retail Trade EMPSTAT 1 Data Data Employer/Nonemployer Status `2' Establhments with no paid employees ESTAB 7 Data Data Number of Establishments, 1987 SALESF 1 Data Data Data Flag SALES 10 Data Data Sales ($1,000), 1987 Record size is 34 characters. Equivalent printed report tables are 3 and 3 in the nonemployer statistics publications. Census of Retail Trade, 1987 Nonemployer Statistics FILE 3 LAYOUT Counties and Places with a Population of 2500 and Over --------------------------------------------------------------------------- Record Type File Description --------------------------------------------------------------------------- Field Field Name Size State County Places 2500+ 2500+ --------------------------------------------------------------------------- ST 2 Data Data Data FIPS State Code MSA 4 NA Data(1) Data(2) MSA/CMSA Code(3) PMSA 4 NA Data(1) Data(2) PMSA Code(4) COUNTY 3 NA Data Data FIPS Place Code PLACE 4 NA NA Data Census Place Code PLACEFIP 5 NA NA Data FIPS Place Code GEOTEXT 20 Data Data Data Alphabetic Geographic Description EMPSTAT 1 Data Data Data Employer/Nonemployer Status `2' Establishments with no paid employees RECTYPE 2 02 06 07 Record Type Code ESTAB 7 Data Data Data Number of establishments, 1987 SALESF 1 Data Data Data Data Flag SALES 10 Data Data Data Sales ($1,000), 1987 Kind-of-Business Groups ESTAB52 6 Data Data Data Building materials and garden supplies stores (SIC 52): Number SALES52F 1 Data Data Data Data Flag SALES52 9 Data Data Data Building materials and garden supplies stores (SIC 52): Sales ($1,000) ESTAB53 6 Data Data Data General Merchandise stores (SIC 53): Number SALES53F 1 Data Data Data Data Flag SALES53 9 Data Data Data General Merchandise stores (SIC 53): Sales ($1,000) ESTAB54 6 Data Data Data Food stores (SIC 54): Number SALES54F 1 Data Data Data Data Flag SALES54 9 Data Data Data Food stores (SIC 54): Sales ($,000) whole number) ESTA55X 6 Data Data Data Automotive dealers (SIC 55 ex. 554) Number SALE55XF 1 Data Data Data Data Flag SALE55X 9 Data Data Data Automotive dealers (SIC 55 ex. 554): Sales ($1,000) ESTA554 6 Data Data Data Gasoline service stations (SIC 554): Number SALE55F 1 Data Data Data Data Flag SALE55 9 Data Data Data Gasoline service stations (SIC 554): Sales ($1,000) ESTAB56 6 Data Data Data Apparel and accessory stores (SIC 56): Number SALES56F 1 Data Data Data Data Flag SALES56 9 Data Data Data Apparel and accessory stores (SIC 56): Sales ($1,000) ESTAB57 6 Data Data Data Furniture and homefurnishings stores (SIC 57): Number SALES57F 1 Data Data Data Data Flag SALES57 9 Data Data Data Furniture and homefurnishings stores (SIC 57): Sales ($1,000) ESTAB58 6 Data Data Data Eating and drinking places (SIC 58): Number SALES58F 1 Data Data Data Data Flag SALES58 9 Data Data Data Eating and drinking places (SIC 58): Sales ($1,000) ESTA591 6 Data Data Data Drug and proprietary stores (SIC 591): Number SALE591F 1 Data Data Data Data Flag SALE591 9 Data Data Data Drug and proprietary stores (SIC 591): Sales ($1,000) ESTA59X 6 Data Data Data Miscellaneous retail stores (SIC 59 ex.591): Number SALE59XF 1 Data Data Data Data Flag SALE59X 9 Data Data Data Miscellaneous retail stores (SIC 59 EX. 591): Sales ($1,000) Record size is 223 characters. Equivalent printed report table is 5 in the nonemployer statistics reports. (1) New England counties are coded `0000'; non-New England, non-MSA counties are coded `9999'. (2)Places which cross county boundaries have MSA and PMSA codes of `0000'. (3)Areas not in a MSA have codes of `9999'. (4)Areas not in a PMSA have codes of `9999'. Census of Retail Trade, 1987 Nonemployer Statistics on CD-ROM DATABASE STRUCTURE FILE 1 --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- BUSTEXT C 60 0 Alphabetic Kind-of-Business Description SICLIST C 16 0 Listing of SIC Codes Included in Kind of Business RTL87KB C 3 0 Retail Kind-of-Business Code (001=Total Retail Trade) EMPSTAT C 1 0 Employer/Nonemployer Status (0=total, 1=employer, 2=nonemployer) RECTYPE C 2 0 Record Type (01=U.S.) ESTABF N 1 0 Flag for ESTAB (0=data, 5=not available) ESTAB N 7 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES (0=data, 1=disclosure, 5=not available) SALES N 10 0 Sales ($1,000), 1987 SOLEPROF N 1 0 Flag for SOLEPRO (0=data, 5=not available) SOLEPRO N 7 0 Unincorporated businesses: Number of sole proprietorships, 1987 PARTSHPF N 1 0 Flag for PARTSHP (0=data, 5=not available) PARTSHP N 6 0 Unincorporated businesses: Number of partnerships, 1987 Total Size 116 Census of Retail Trade, 1987 Nonemployer Statistics on CD-ROM DATABASE STRUCTURE FILE 2 States and MSAs --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- ST C 2 0 FIPS State Code MSA C 4 0 MSA or CMSA Code (9999=not in MSA, 0000 in New England) PMSA C 4 0 PMSA Code (9999=not in PMSA) RECTYPE C 2 0 Record Type (02=State, 04=MSA) RTL87KB C 3 0 Retail Kind-of-Business Code (000=Total Retail Trade) EMPSTAT C 1 0 Employer/Nonemployer Status (0=total, 1=employer, 2=nonemployer) ESTAB N 7 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES (0=data, 1=disclosure) SALES N 10 0 Sales ($1,000), 1987 Total Size 34 Census of Retail Trade, 1987 Nonemployer Statistics on CD-ROM DATABASE STRUCTURE FILE 3 States Counties and Places with a Population of 2500 and Over --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- ST C 2 0 FIPS State Code MSA C 4 0 MSA or CMSA Code (9999=not in MSA, 0000 in New England) PMSA C 4 0 PMSA Code (9999=not in PMSA) COUNTY C 3 0 FIPS County Code PLACE C 4 0 Census Place Code PLACEFIP C 5 0 FIPS Place Code GEOTEXT C 20 0 Alpha Geographic Description (truncated to 20 characters) EMPSTAT C 1 0 Employer/Nonemployer Status (0=total, 1=employer, 2=nonemployer) RECTYPE C 2 0 Record Type (02=State, 06=County,07=Place) ESTAB N 7 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES (0=data, 1=disclosure) SALES N 10 0 Sales ($1,000), 1987 ---------- Kind-of-Business Groups ---------- ESTAB52 N 6 0 52 Building materials and garden supplies stores SALES52F N 1 0 Flag for SALES52 SALES52 N 9 0 52 Building materials and garden supplies store: Sales($1000) ESTAB53 N 6 0 53 General merchandise stores SALES53F N 1 0 Flag for SALES53 SALES53 N 9 0 53 General merchandise stores: Sales ($1,000) ESTAB54 N 6 0 54 Food stores SALES54F N 1 0 Flag for SALES54 SALES54 N 9 0 54 Food stores: Sales ($1,000) ESTA55X N 6 0 55 ex. 554 Automotive dealers SALE55XF N 1 0 Flag for SALE55X SALE55X N 9 0 55 ex. 554 Automotive dealers: Sales ($1,000) ESTA554 N 6 0 554 Gasoline service stations SALE554F N 1 0 Flag for SALE554 SALE554 N 9 0 554 Gasoline service stations: Sales ($1,000) ESTAB56 N 6 0 56 Apparel and accessory stores SALES56F N 1 0 Flag for SALES56 SALES56 N 9 0 56 Apparel and accessory stores: Sales ($1,000) ESTAB57 N 6 0 57 Furniture and homefurnishings stores SALES57F N 1 0 Flag for SALES57 SALES57 N 9 0 57 Furniture and homefurnishings stores: Sales ($1,000) ESTAB58 N 6 0 58 Eating and drinking places SALES58F N 1 0 Flag for SALES58 SALES58 N 9 0 58 Eating and drinking places: Sales ($1,000) ESTA591 N 6 0 591 Drug and proprietary stores SALE591F N 1 0 Flag for SALE591 SALE591 N 9 0 591 Drug and proprietary stores: Sales ($1,000) ESTA59X N 6 0 59 ex. 591 Miscellaneous retail stores SALE59XF N 1 0 Flag for SALE59X SALE59X N 9 0 59 ex. 591 Miscellaneous retail stores: Sales ($1,000) Total Size 223 CENSUS OF RETAIL TRADE--NONEMPLOYER STATISTICS User Notes This section will contain information relevant to the 1987 Census of Retail Trade: Nonemployer Statistics on CD-ROM that indicates specific problems with the data, or that becomes available after the file is released. The cover letter to the updated information should be filed behind this page. User Notes will be sent to all users who (1) purchased their file (or technical documentation) from the Census Bureau and (2) returned the coupon following the CD-ROM File Information.