CHAPTER V Census of Retail Trade--Establishment and Firm Size Abstract V-3 Introduction V-5 File Specifications V-7 File Layout V-9 Database Structures V-13 User Notes V-15 CENSUS OF RETAIL TRADE ESTABLISHMENT AND FIRM SIZE Abstract CONTENTS Citation V-3 Type of File V-3 Universe Description V-3 Subject-Matter Description V 3 Geographic Coverage V-3 Technical Description V-3 Reference Materials V-3 Related Printed Reports V-4 Related Machine-Readable Data Files V-4 Availability V-4 CITATION Census of Retail Trade on CD-ROM, 1987: Establishment and Firm Size [machine-readable data file] / prepared by the Bureau of the Census. Wash-ington: The Bureau [producer and distributor], 1990. Type of File: Summary statistics. Universe Description: The universe is all retail trade establishments with payroll. Subject-Matter Description: Data are presented cross tabulated by the size of establishment, size of company or firm, and by legal form of organization. Establishment statistics are presented by sales size and by employment size; statistics for firms, by sales size (including concentration by largest firms), by employment size, and by number of establishments operated (single units and multiunits). Statistics are presented for establishments with payroll by kind of business on the number of establishments, sales, payroll, and employment. Geographic Coverage: Data are provided for the United States. Technical Description: File Structure: dBase III+ The file has one dBase ".NDX" index file and one several label files that can be linked to it. File sequence, available indexes, and linkable label files: RC87S1 1. File Sequence: Table number by kind of business by one of several table-specific size codes 2. Available index: RC87S1 By table number by kind of business code 3. Linkable label files: a. RTL87KB (kind-of-business labels) b. SIZECODE (labels for table number and each of the size codes presented in the file) 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 CD- ROM 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, Establishment and Firm Size. Presents data based on size of company and firm, and legal form of organization. Establishment statistics are presented by sales size and by employment size; statistics for firms, by sales size (including concentration by largest firms), by employment size, and by number of establishment operated (single units and multiunits). Statistics are presented for establishment with payroll by kind-of-business on the number of establishment, sales, payroll and employment for the United States. Related Machine-Readable Data Files: Census of Retail Trade on CD-ROM, 1987: Geographic Area Series. Presents data for establishments with payroll by SIC categories and includes sales, payroll and employees. Census of Retail Trade on CD-ROM, 1987: Nonemployer Statistics. Presents the number of establishments and sales by kind of business for establishments with no payroll a universe not covered in the size tabulations. Census of Retail Trade on CD-ROM, 1987: Merchandise Line Sales. Presents data on major categories of merchandise sold by retail establishments with payroll by kinds of business for the U.S. each State, and each MSA. Census of Retail Trade on CD-ROM, 1987: ZIP Code Statistics. Shows the number of establish-ments 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. (On Economic Censuses CD- ROM 2A) 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 ESTABLISHMENT AND FIRM SIZE Introduction CONTENTS Size of Establishment V-5 Size of Firm V-5 Legal Form of Organization V-5 Geographic Area Covered V-5 This file represents a recompilation of data collected in the 1987 census of retail trade and is divided into three categories: size of establishment, size of firm, and legal form of organization. Size of establishment Only establishments which operated the entire year have been classified into the various size groups used in the establishment size tables. An establishment is classified as "operated entire year" if it operated 10 months or more during the year. Data for establishments which reported that they were in operation fewer than 10 months are separately summarized as "not operated entire year." Sales size Data in table 1 are classified into 12 sales size groups depending on the value of sales and other receipts reported for the year 1987. Employment size Data in table 2 are classified into 11 employment size groups depending on the number of employees on the payroll during the pay period including March 12. Proprietors and unpaid family workers were not regarded as employees in determining the employment size of an establishment. Size of firm A firm may be either a single establishment (single unit) firm or a multiestablishment (multiunit) firm. Firm size groups are based on aggregate data for all establishments operated by the same firm in the kind-of-business classification, group, or total for which data are presented. For example, a firm operates three retail establishments: a department store (SIC 531), a variety store (SIC 533), and a grocery store (SIC 541). At the most detailed level of classification, each of the establishments is a single unit operated by a multi-establishment firm. At the general merchandise group level (SIC 53), it is a two-establishment multiunit. At the retail trade total level, it is a three-establishment multiunit. Data are presented based on sales size of firms, employment size of firms, and concentration by largest firms, as well as for single units and multiunits (by number of establishments operated). Single units and multiunits Data in table 3 are classified into 10 firm size groups based on the number of establishments operated. A single unit is a firm with only one establishment engaged in economic activities. A multiunit (multiestablishment) is a firm with two establishments or more engaged in economic activities. A multiestablishment firm may, however, operate as few as one establishment classified in retail trade. Sales size Data in table 4 are classified into 11 sales size groups depending on the value of sales and other receipts reported for 1987. Employment size Data in table 5 are classified into 9 employment size groups depending on the number of employees on the payroll during the pay period including March 12. Proprietors and unpaid family workers were not regarded as employees in determining the employment size of a firm. Concentration of largest firms Data in table 6 are presented separately for the 4, 8, 20, and 50 largest firms based on total sales Legal form of organization Data in the file are presented for individual establishments and firms by legal form of organization for four separate categories. For the method of assigning legal form, see the Glossary entry for legal form of organization. Geographic Areas Covered This series presents data by kind of business for the United States as a whole. CENSUS OF RETAIL TRADE ESTABLISHMENT AND FIRM SIZE File Specifications CONTENTS General Data Specifications V-7 File Layout V-7 GENERAL DATA SPECIFICATIONS Data Fields. This file is are recorded in dBase III+ format. Numeric data fields contain no alphabetic information. A few fields (those in percentage form) have explicit decimals, unlike corresponding data on tape, which carry only implied decimals. On the other hand, many data items are scaled in thousands or millions, and this is noted only in the file layouts. Any data field which is subject to any special conditions (e.g., suppression to avoid disclosure, not applicable) is preceded by an information flag field which contains explanatory codes. Kind-of-Business and Size Code Labels. Records in the files are specific to a particular kind of business, as identified by the RTL87KB code. The term "kind of business" is used instead of "standard industrial classification" (SIC) because some kind-of-business categories represent either combinations or subdivisions of SIC categories. Titles for each kind of business are available in Appendix A, and also in the file RTL87KB.dbf on the CD-ROM. Kind-of-business and size code titles can be linked to data files using the dBase SET RELATION command. Index Files. This data file has one index file which can be used quickly to jump to desired records (e.g., using the dBase FIND command) or to change the sequence of access. Available index files are listed in the abstract. Where noted in the abstract that an index is to the "first record for" a particular type of area, the index can be used during dBase FINDs, but the index must be shut off with SET INDEX TO in order to get access to records other than the first for each area. FILE LAYOUT Most data items have an associated "flag" to describe any special conditions applicable. Flags 1, 2, and 3 indicate that the data are not shown and the corresponding data fields contain zeroes. Flags 3 and 4 correspond to categories which are bracketed in the corresponding printed report. Records with flag 4 carry data summarizing the current record and one or more preceding records which carry a flag of 3. The codes are the same for all flags, but are listed in the record layout only for the first flag. In the geographic identification field in each file, NA fields contain either all zeroes or all 9's. See Geographic Code Structure. For those data fields that are always NA for certain types of records (as shown in the record layout), both the data field and the corresponding information flag contain zeroes. Census of Retail Trade, 1987 Establishment and Firm Size FILE LAYOUT --------------------------------------------------------------------------- Mnemonic Record Type File Description --------------------------------------------------------------------------- Num of Chars US --------------------------------------------------------------------------- RTL87KB 3 Data Kind-of-Business Code (Table Stub Line˙Number) e.g. 001 Total ˙ Retail Trade RECTYPE 2 01 Record Type Code: US TABLE_RS 2 Data Table Identifier 01 Sales Size of Establishments, 1987 02 Employment Size of Establishments, 1987 03 Single Units and Multiunits, 1987 04 Sales Size of Firms, 1987 05 Employment Size of Firms, 1987 06 Concentration by Largest Firms, 1987 07 Legal Form of Organization, 1987 SALESEST 2 Data Sales Size of Establishments, 1987 01 All Establishments 02 Establishments operated entire year With annual sales of 03 $25,000,000 or more 04 $10,000,000 to $24,999,999 05 $5,000,000 to $9,999,999 06 $2,500,000 to $4,999,999 07 $1,000,000 to $2,499,999 08 $500,000 to $999,999 09 $250,000 to $499,999 10 $100,000 to $249,999 11 $50,000 to $99,999 12 $25,000 to $49,999 13 $10,000 to $24,999 14 Less than $10,000 15 Establishments not operated entire year 99 Not applicable to this record (Tables 2-7) EMPLEST 2 Data Employment Size of Establishments, 1987 01 All Establishments 02 Establishments Operated Entire Year 03 No employees 04 1 employee 05 2 employees 06 3 or 4 employees 07 5 or 6 employees 08 7 to 9 employees 09 10 to 14 employees 10 15 to 19 employees 11 20 to 49 employees 12 50 to 99 employees 13 100 employees or more 14 Establishments not operated entire year 99 Not applicable to this record (Tables 1, 3-7) UNITS 2 Data Single unit/multiunit number of establishments in firm, 1987 01 All Firms 02 Single units 03 Multiunits 04 1 establishment 05 2 establishments 06 3 or 4 establishments 07 5 to 9 establishments 08 10 to 24 establishments 09 25 to 49 establishments 10 50 to 99 establishments 11 100 establishments or more 99 Not applicable to this record (Tables 1,2,4-7) SALESFRM 2 Data Sales Size of Firms, 1987 01 All Firms 02 Firms Operated Entire Year With annual sales of 03 $250,000,000 or more 04 $100,000,000 to $249,999,999 05 $50,000,000 to $99,999,999 06 $25,000,000 to $49,999,999 07 $10,000,000 to $24,999,999 08 $5,000,000 to $9,999,999 09 $2,500,000 to $4,999,999 10 $1,000,000 to $2,499,999 11 $500,000 to $999,999 12 $250,000 to $499,999 13 Less than $250,000 14 Firms not operated entire year 99 Not applicable to this record (Tables 1-3,5-7) EMPLFIRM 2 Data Employment Size of Firms, 1987 01 All Firms 02 Firms Operated Entire Year 03 Less than 5 employees 04 5-9 employees 05 10-19 employees 06 20 to 49 employees 07 50 to 99 employees 08 100 to 249 employees 09 250 to 499 employees 10 500 to 999 employees 11 1,000 employees or more 12 Firms not operated entire year 99 Not applicable to this record (Tables 1-4,6,7) CONCENTR 2 Data Concentration by Largest Firms, 1987 01 All Firms 02 4 Largest Firms 03 8 Largest Firms 04 20 Largest Firms 05 50 Largest Firms 99 Not applicable to this record (Tables 1-5 and 7) LEGAL 2 Data Legal Form of Organization, 1987 01 All types 02 Corporations 03 Individual Proprietorships 04 Partnerships 05 Other 99 Not applicable to this record (Tables 1-6) FIRMSF 1 Data Data Flag 0 No suppression 1 Data are withheld to avoid disclosing data for individual companies 2 Data not available (NA)(1) 3 Data bracketed, total shown on subsequent record 4 Data bracketed, total shown on this record FIRMS 7 Data/NA Number of Firms, 1987 (NA for Tables 1, 2, and 6) ESTABF 1 Data Data Flag ESTAB 7 Data Number of establishments, 1987 SALESF 1 Data Data Flag SALES 10 Data Sales, 1987 ($1,000) SALEPCTF 1 Data Data Flag SALEPCT 5 Data/NA Sales as a percent of total sales (1 explicit decimal) (NA for Tables 1-5 and 7) PAYROLLF 1 Data Data Flag PAYROLL 9 Data Annual payroll, 1987 ($1,000) PAYSALEF 1 Data Data Flag PAYSALE 5 Data/NA Annual payroll as a percent of sales, 1987 (1 explicit decimal) (NA for Tables 4 and 5) PAYRO1QF 1 Data Data Flag PAYRO1Q 8 Data First quarter payroll ($1,000) EMPLOYEF 1 Data Data Flag EMPLOYE 8 Data Paid employees for pay period including March 12 (number) The record size is 88 characters. (1)This code is used as a flag when the variable is not applicable to a particular table. For example, Table 1, which is identified in position 85 as 01, has no data for firms. The number of firms field will have a flag of 2 for this record. 12/01/89 Census of Retail Trade, 1987 Establishment and Firm Size on CD-ROM DATABASE STRUCTURE --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- RTL87KB C 3 0 Retail Trade Kind-of-Business Code (001=Total Retail Trade) RECTYPE C 2 0 Record Type (10=State tables 1&2, 11=table 3, 12=table 4) TABLE_RS C 2 0 Table Identifier (01=U.S.) SALESEST C 2 0 Sales Size of Establishment Code EMPLEST C 2 0 Employment Size of Establishments Code UNITS C 2 0 Single Unit/Multiunit Number of Establishments in Firm Code SALESFRM C 2 0 Sales Size of Firm Code EMPLFRM C 2 0 Employment Size of Firm Code CONCENTR C 2 0 Concentration of Largest Firms Code LEGAL C 2 0 Legal Form of Organization Code FIRMSF N 1 0 Flag for FIRMS (0=data, 1-disclosure, 2=NA, 3=}, 4=}total) FIRMS N 7 0 Number of firms, 1987 ESTABF N 1 0 Flag for ESTAB (0=data, 3=}, 4=}total) ESTAB N 7 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES (0=data, 1=disclosure, 2=NA, 3=}, 4=}total) SALES N 10 0 Sales ($1,000), 1987 SALEPCTF N 1 0 Flag for SALEPCT (0=data, 1=disclosure, 2=NA, 3=}, 4=}total) SALEPCT N 5 1 Sales as a percent of total for this RTL87KB, 1987 (Tab 6 only) PAYROLLF N 1 0 Flag for PAYROLL (0=data, 1-disclosure, 2=NA, 3=}, 4=}total) PAYROLL N 9 0 Payroll entire year ($1,000), 1987 PAYSALEF N 1 0 Flag for PAYSALE (0=data, 1-disclosure, 2=NA, 3=}, 4=}total) PAYSALE N 5 1 Payroll entire year as a percent of sales (NA for tabs 4-5) PAYRO1QF N 1 0 Flag for PAYRO1Q (0=data, 1-disclosure, 2=NA, 3=}, 4=}total) PAYRO1Q N 8 0 Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYE (0=data, 1-disclosure, 2=NA, 3=}, 4=}total) EMPLOYE N 8 0 Number of paid employees for pay period including March 12, 1987 Total Size 88 CENSUS OF RETAIL TRADE--Establishment and Firm Sizes 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.