1987 CENSUS OF RETAIL TRADE Abstract =>CITATION Census of Retail Trade on CD-ROM, 1987: Geographic Area Series / prepared by the Bureau of the Census. Washington: The Bureau [producer and distributor], 1995. =>TYPE OF FILE Summary statistics =>UNIVERSE DESCRIPTION The universe is all retail trade establishments with payroll. Establishments with no paid employees, for example, "mom and pop" stores, are not included in the 1987 Geographic Area Series files, but are included in the 1987 Nonemployer Statistic Series publications and 1987 Economic Census CD-ROM 1E. =>SUBJECT-MATTER DESCRIPTION The information included on the 1987 Geographic Area Series file of this CD-ROM is the same as that shown in the printed Geographic Area Series, RC87-A-1 to 52, except that employment and payroll figures appear by kind of business for small counties and places on CD-ROM but not in the corresponding printed tables. This file (RC87A1.dbf) provides selected 1987 data by SIC category. Data items include: Establishments, Sales, Annual payroll, First quarter payroll, and Employment. =>GEOGRAPHIC COVERAGE Data are provided for the following geographic levels: U.S., States, Metropolitan Statistical Areas (MSAs), Consolidated Metropolitan Statistical Areas (CMSAs), Primary Metropolitan Statistical Areas (PMSAs), Area Outside Metropolitan Areas by State (non-MA), Counties, and Places with populations of 2,500 or more as defined for the 1987 Economic Census. =>SIC/KIND-OF-BUSINESS DETAIL The 1987 Census of Retail Trade covers retail trade as defined in the 1987 Standard Industrial Classification (SIC) Manual. This includes establishments classified in Major Groups 52-59. The census includes liquor stores operated by State and local governments; however, all other government-operated businesses are excluded. The Geographic Area Series presents data for selected SIC or kind-of- business (KB) codes. The level of KB detail varies by geography. The KB codes included in each "stub" may be compared in SICKEY87.dbf. GEOGRAPHY NUMBER OF KBs STUB US 121 A States 106 B MSAs, CMSAs, PMSAs, non-MAs, counties and places with: 10,000 or more retail establishments 106 B 2,000 to 9,999 retail establishments 100 C MSAs with: Fewer than 2,000 retail establishments 54 D Counties and places with: 500 to 1,999 retail establishments 54 D Fewer than 500 retail establishments 11 E Note: SICKEY codes used for 1987 are not the same as those used for 1992. Nonetheless SICKEY92.dbf shows the 1987 SICKEY corresponding to each 1992 code. =>SOFTWARE ACCESS EXTRACT This software system, included on this CD-ROM, provides access to every file discussed in the Technical Description section of this abstract. =>FILE CHARACTERISTICS => RC87A1.dbf - General Statistics: Sales, Payroll, and Employment File sequence: US records followed by records for States, counties, places, MSA/CMSA/PMSAs, and the nonmetropolitian area in each State; by kind of business. Available indexes: RC87A1GS.ndx: Type of geography by State, place and county; by kind of business RC87A1CO.ndx: First record for each State and county (Retail Trade totals only) RC87A1MA.ndx: Metropolitan area by kind of business RC87A1KS.ndx: Kind of business by State by county by place RC87A1KM.ndx: Kind of business by metropolitan area Linkable label files: SICKEY87.dbf (kind-of-business codes) GEOREF87.dbf (geographic area names) EC87MISC.dbf (descriptions for data flags and types of geography)