CHAPTER XII Census of Wholesale Trade Geographic Area Series Abstract.......................... XII-3 File Specifications............... XII-7 File Layouts................ XII-9 Database Structures.......... XII-17 User Notes........................ XII-25 CENSUS OF WHOLESALE TRADE . GEOGRAPHIC AREA SERIES Abstract CONTENTS Citation............................... XII-3 Type of File........................... XII-3 Universe Description................... XII-3 Subject-Matter Description............. XII-3 Geographic Coverage.................... XII-3 Technical Description.................. XII-3 Reference Materials.................... XII-4 Related Printed Reports................ XII-4 Related Machine-Readable Data Files.... XII-4 Availability........................... XII-5 CITATION Census of Wholesale Trade on CD-ROM, 1987: Geographic Area Series [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 is all wholesale trade establishments with payroll. Subject-Matter Description: This series of three files provides 1987 data by SIC category for the following: Number of establishments Sales Payroll entire year Payroll first quarter Number of paid employees for pay period including March 12, 1987 Sales per establishment Sales per employee Annual payroll per employee Employees per establishment Annual payroll as a percent of operating expenses End-of-1986 inventories End-of-1987 inventories Operating expenses as a percent of sales End-of-1987 inventories as a percent of sales Data are also available on volume of sales ranking of geographic areas within state, and percent of state total sales. 1982 figures and percent change 1987-82 data are provided for number of establishments, sales, payroll entire year, and number of paid employees. Statistics are provided for all types of wholesale operations as well for merchant wholesalers; manufacturers' sales branches and offices; agents, brokers, and commission merchants; and all operating types except merchant wholesalers. These data are exactly the same as shown in the printed report series of the same name, WC87-A-1 to 52. Geographic Coverage: Data are provided for U.S., States, Metropolitan Statistical Areas (MSA), Consolidated Metropolitan Statistical Areas (CMSA), Primary Metropolitan Statistical Areas (PMSA), the non-MSA part of each State, counties with 200 or more establishments and places with 200 or more establishments. Selected data are also provided for all counties and for all places with populations of 2500 or more. Technical Description: File Structure: dBASE III+ Most files have also have dBASE ".NDX" index files and one or more label files that can be linked to them. Data for each state and the U.S. summary are structured as separate files within each of the groups listed below. Each file name consists of the group name (e.g. WC87A1) plus the two-character postal abbreviation (e.g. AL), with the extension .DBF. File Size: Approximate size in kilobytes is shown on page vii at the end of the introduction. Record size is shown in the File Layout and Database Structure sections of this chapter. Exact record counts and file size can be retrieved by way of the dBASE "DIR" command or various external utilities. File sequence, available indexes and linkable index files: WC87A1: 1. File Sequence: State and counties with places within the county (total data but not data by SIC), followed by places which have SIC-level data, followed by counties which have SIC-level data, followed by non-MSA records. (Corresponds to report tables 5-9.) 2. Available indexes: a. WC87K1: By kind of business, record type and geography b. WC87C1: First record for each county c. WC87M1: First record for each MSA or CMSA d. WC87N1: First record for each PMSA e. WC87P1: First record for each Place 3. Linkable label files: a. WHS87KB (kind of business code) b. RECTYPE (record type labels) c. STCODE (state names) d. STCOUNTY (county names) e. STPLACE (place names) f. MSA (MSA, CMSA, and PMSA titles) WC87A2: 1. File Sequence: Data for states; all record type 2 records followed by all record type 10 records followed by all record type 12 records. (Corresponds to report tables 1-4.) 2. Available indexes: a. WC87R2: First record for each record type 3. Linkable label files: a. WHS87KB (kind of business code) b. RECTYPE (record type labels) c. STCODE (state names) WC87A3: 1. File Sequence: Data for Place records, followed by county records. (Corresponds to report tables 10-11.) 2. Available indexes: a. WC87C3: By record type, county and place b. WC87M3: By MSA 3. Linkable label files: a. MSA (MSA, CMSA, and PMSA titles) WC87A4: 1. Available indexes: a. WC87R4: First record for each record type 2. File Sequence: Data for U.S. records, followed by State records, then MSA/CMSA/PMSA records Abbreviated State, county and place data from the 1982 and 1977 censuses of retail trade, wholesale trade and service industries support the study of change in economic characteristics over time. The data in these files are as originally published, without adjustment for comparability with statistics from the 1987 Economic Censuses. (Changes in the Standard Industrial Classification system, the definition of establishment counts, and boundaries of some geographic areas are discussed in Chapter 7 of the Guide to the 1987 Economic Censuses and Related Statistics.) Reference Materials: Census of Wholesale Trade, 1987: Geographic Area Series Technical Documentation. This documentation has general information, a glossary, record layouts for all files, a questionnaire facsimile 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. Single copies are 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. GPO Stock No. 041-001-00314-2. Price is $24. Related Printed Reports: 1987 Census of Wholesale Trade, Geographic Area Series (WC87-A-1 to 52). One publication for each State, the District of Columbia, and a U.S. Summary. For sale by the Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. For information about availability and prices for individual reports, contact Customer Services, Data User Services Division, Bureau of the Census, Washington, DC 20233. Phone: (301) 763-4100. Related Machine-Readable Data Files: Census of Wholesale Trade, 1987, Commodity Lines Sales. Provides number of establishments and sales for by kind of business for broad and detailed commodity lines. Data are shown for merchant wholesalers; manufacturers' sales branches and offices; and agents, brokers, and commission merchants for the U.S., 15 selected States and 15 selected MSAs. (Available late 1990.) Availability: The full data set for all states is 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 WHOLESALE TRADE--GEOGRAPHIC AREA SERIES File Specifications CONTENTS General Data Specifications.... XII-7 File Layout.................... XII-7 General Data Specifications Data Fields. All files 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. Record Sequence and Geographic Coding. Records are arranged with like records together (e.g., State records, followed by all county records, if any; followed by place records; MSA records, if any; and non-MSA records). The presentation of each type of geography is exhaustive in scope--county records include single-county MSA records and the MSA record contains a duplicate record for that single-county MSA. City records include records for independent cities and cities coextensive with counties. Records also contain all applicable geocodes county records for MSA counties carry both an MSA code and a county code. Place records contain a county code; the county code `000' and the MSA and PMSA codes of `0000' are used if the place crosses county boundaries. Place records contain both the census place code and the FIPS state code. See the Geographic Code Structure section of this chapter on page 59. Names for geographic variables are carried in files separate from the data files. Each is indexed, so that geographic names can be accessed in conjunction with the corresponding data values. See the Introduction to this CD-ROM for more information on geographic variables. Kind-of-Business Labels. Records in the WC87A1 and WC87A2 files are specific to a particular kind of business, as identified by the WHS87KB 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 E, in this chapter, and also in the file WHS87KB.dbf on the CD-ROM. Kind-of-business titles can be linked to data files using the dBase SET RELATION command. Index Files. Each data file has one or more index files which can be used quickly 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. All flags other than `0' indicate that the data are not shown and the corresponding data fields contain zeroes. 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 in files WC87A2 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 Wholesale Trade, 1987 Geographic Area Series FILE 1 LAYOUT State, Metropolitan, Non-Metropolitan, Counties, and Places (Totals) --------------------------------------------------------------------------- File Record Type Description --------------------------------------------------------------------------- Field Field State Name Size or MSA/ Non-MSA County(1) Places(1) U.S. CMSA/ PMSA --------------------------------------------------------------------------- ST 2 Data NA Data Data Data FIPS State Code MSA 4 NA Data NA Data/NA(2) Data/NA(3) MSA/CMSA Code(4) PMSA 4 NA Data/NA NA Data/NA(2) Data/NA(3) PMSA Code(5) COUNTY 3 NA NA NA Data Data FIPS County Code PLACE 4 NA NA NA NA Data Census Place Code PLACEFIP 5 NA NA NA NA Data FIPS Place Code RECTYPE 2 02,01 04 05 06(6) 07(7) Record Type Code WHS87KB 3 Data Data Data Data Data Kind-of-Business Code (Table Stub Line Number) e.g. 001=Total Wholesale Trade ESTAB 7 Data Data Data Data Data Number of establishments, 1987 SALESF 1 Data Data Data Data Data Data Flag SALES 10 Data Data Data Data Data Sales ($1,000), 1987 PAYROLLF 1 Data Data Data Data Data Data Flag PAYROLL 9 Data/NA Data/NA Data/NA Data/NA Data/NA Payroll entire year ($1,000), 1987(8) EMPLOYEF 1 Data Data Data Data Data Data Flag EMPLOYE 8 Data/NA Data/NA Data/NA Data/NA Data/NA Number of paid employees for pay period including March 12, 1987(8) ESTAMER 7 Data/NA Data/NA Data/NA Data/NA Data/NA Number of merchant wholesaler establishments, 1987 SALEMERF 1 Data Data Data Data Data Data Flag SALEMER 10 Data/NA Data/NA Data/NA Data/NA Data/NA Sales of merchant wholesalers ($1,000), 1987 PAYRMERF 1 Data Data Data Data Data Data Flag PAYRMER 9 Data/NA Data/NA Data/NA Data/NA Data/NA Payroll entire year of merchant wholesalers ($1,000), 1987 EMPLMERF 1 Data Data Data Data Data Data Flag EMPLMER 8 Data/NA Data/NA Data/NA Data/NA Data/NA Number of paid employees of merchant wholesalers for pay period including March 12, 1987 ESTAOTH 7 Data/NA Data/NA Data/NA Data/NA Data/NA Number of establishments of other operating types, 1987 SALEOTHF 1 Data Data Data Data Data Data Flag SALEOTH 10 Data/NA Data/NA Data/NA Data/NA Data/Na Sales of other operating types ($1,000), 1987 Record size is 119 characters. Equivalent printed report tables are 5,6,7,8, and 9 in the geographic area series publications. 1. Total figures are provided for all counties and all places with a population of 2500+. Kind-of-business data are available for counties and places with 200 or more establishments. 2. New England county records have MSA and PMSA codes of 0000; non-New England, non-MSA counties have MSA and PMSA codes of 9999. 3. Places which cross county boundaries are assigned MSA/PMSA codes of `0000'. 4. Areas not in MSA's have codes of 9999. 5. Areas not in PMSA's have codes of 9999. 6. Record type 6 contains total figures for all counties with a population of 25000+. 7. Record type 7 contains total figures for all places with a population of 2500+. 8. Data are not available in this field for Type of Operation code 50. Census of Wholesale Trade, 1987 Geographic Area Series FILE 2 LAYOUT State Totals, Ratios, and Comparative Statistics ----------------------------------------------------------------------------- Record Type File Description ----------------------------------------------------------------------------- Field Field State, State, State, State, Name Size U.S. U.S. U.S. SICs 1972 Totals 1987 Changeed Bridge Table1 Ratios 1972-1987 Tables Table2 Table4 Table3 ----------------------------------------------------------------------------- ST 2 Data Data Data Data FIPS State Code RECTYPE 2 02,01 10,20 12,22 11,21 Record Type Code WHS87KB 3 Data Data Data Data Kind-of-Business Code/ Type of Operation Code (Table Stub Line Number e.g. 001=Total Wholesale Trade) OPTYPE 2 Data Data Data Data Type of Operation 00 All Types of Operation 10 Merchant Wholesalers 11 Wholesale distributors and jobbers 12 Importers 13 Exporters 15 Terminal grain elevators 17 Country grain elevators 19 Assemblers of farm products, except country grain elevators 20 Manufacturers' Sales Branches and Offices 21 Sales branches (with stock) 22 Sales offices 40 Agents, brokers, and commission merchants 41 Auction companies 42 Brokers 43 Commission merchants 44 Import agents 45 Export agents 46 Manufacturers' agents 50 All operating types except merchant wholesalers ESTAB 7 Data Data Data Data Number of establishments, 1987 ESTAB82F 1 Data Data Data Data Data Flag ESTAB82 7 NA NA NA Data Number of establishments, 1982 SALESF 1 Data Data Data Data Data Flag SALES 10 Data Data Data Data Sales ($1,000), 1987 SALES82F 1 Data Data Data Data Data Flag SALES82 10 NA NA NA Data Sales ($1,000), 1982 SALESCHF 1 Data Data Data Data Data Flag SALESCH 8 NA NA NA Data Sales percent change 1982-1987 (1 implied decimal) PAYROLLF 1 Data Data Data Data Data Flag PAYROLL 8 Data Data Data Data Payroll entire year ($1,000), 1987 PAYRO82F 1 Data Data Data Data Data Flag PAYRO82 8 NA NA NA Data Payroll entire year ($1,000), 1982 PAYROCHF 1 Data Data Data Data Data Flag PAYROCH 8 NA NA NA Data Payroll entire year, percent change, 1982-1987 (1 implied decimal) PAYRO1QF 1 Data Data Data Data Data Flag PAYRO1Q 8 NA Data Data NA Payroll first quarter ($1,000), 1987 EMPLOYEF 1 Data Data Data Data Data Flag EMPLOYE 8 Data NA Data Data Number of paid employees for pay period including March 12, 1987 EMPLO82F 1 Data Data Data Data Data Flag EMPLO82 8 NA NA NA Data Number of paid employees for pay period including March 12, 1982 SALESESF 1 Data Data Data Data Data Flag SALESES 8 NA Data NA NA Sales per establishment (In $), 1987 SALESEMF 1 Data Data Data Data Data Flag SALESEM 7 NA Data NA NA Sales per employee ($), 1987 PAYEMPF 1 Data Data Data Data Data Flag PAYEMP 6 NA Data NA NA Annual payroll per employee ($), 1987 EMPESTF 1 Data Data Data Data Data Flag EMPEST 4 NA Data NA NA Employees per establishment, 1987 (whole number) PAYEXPF 1 Data Data Data Data Data Flag PAYEXP 8 NA Data NA NA Annual payroll as a percent of operating expenses, 1987 EXPENSEF 1 Data Data Data Data Data Flag EXPENSE 10 NA Data Data NA Operating expenses ($1,000), 1987 INVEN86F 1 Data Data Data Data Data Flag INVEN86 10 NA Data Data NA End of 1986 inventories ($1,000) INVEN87F 1 Data Data Data Data Data Flag INVEN87 10 NA Data Data NA End of 1987 inventories ($1,000) EXPSALF 1 Data Data Data Data Data Flag EXPSAL 8 NA Data NA NA Operating expenses as a percent of sales, 1987 INVSALF 1 Data Data Data Data Data Flag INVSAL 8 NA Data NA NA End-of-1987 inventories as a percent of sales Record size is 195 characters. Equivalent printed report tables are 1, 2, 3, and 4 in the geographic area series publications. This record combines various types of state data into a single file in an effort to reduce the number of files. Sequence should be all "02" records followed by all "10" records, followed by all "11" records, then all "12" records. Census of Wholesale Trade, 1987 Geographic Area Series FILE 3 LAYOUT Counties and Places with a Population of 2500 or More --------------------------------------------------------------------------------------------- Record Type File Description --------------------------------------------------------------------------------------------- Field Field Name Size State MSA/ Non- County(1) Places(1) CMSA/ MSA PMSA --------------------------------------------------------------------------------------------- ST 2 Data NA Data Data Data FIPS State Code MSA 4 NA Data NA Data/NA(2) Data/NA(3) MSA/CMSA Code4 PMSA 4 NA Data/NA NA Data/NA(2) Data/NA(3) PMSA Code5 COUNTY 3 NA NA NA Data Data FIPS County Code PLACE 4 NA NA NA NA Data Census Place Code PLACEFIP 5 NA NA NA NA Data FIPS Place Code GEOTEXT 20 Data Data Data Data Data Alphabetic Geographic Description RECTYPE 2 02 04 05 16(6) 17(7) Record Type Code ESTAB 7 Data Data Data Data Data Number of establishments, 1987 SALESF 1 Data Data Data Data Data Data Flag SALES 10 Data Data Data Data Data Sales ($1,000), 1987 PAYROLLF 1 Data Data Data Data Data Data Flag PAYROLL 9 Data/NA Data/NA Data/NA Data/NA Data/NA Payroll entire year ($1,000), 19878 EMPLOYEF 1 Data Data Data Data Data Data Flag EMPLOYE 8 Data/NA Data/NA Data/NA Data/NA Data/NA Number of paid employees for pay period including March 12, 19878 ESTAMER 7 Data/NA Data/NA Data/NA Data/NA Data/NA Number of merchant wholesaler establishments, 1987 SALEMERF 1 Data Data Data Data Data Data Flag SALEMER 10 Data/NA Data/NA Data/NA Data/NA Data/NA Sales of merchant wholesalers ($1,000), 1987 PAYRMERF 1 Data Data Data Data Data Data Flag PAYRMER 9 Data/NA Data/NA Data/NA Data/NA Data/NA Payroll entire year of merchant wholesalers ($1,000), 1987 EMPLMERF 1 Data Data Data Data Data Data Flag EMPLMER 8 Data/NA Data/NA Data/NA Data/NA Data/NA Number of paid employees of merchant wholesalers for pay period including March 12, 1987 ESTAOTH 7 Data/NA Data/NA Data/NA Data/NA Data/NA Number of establishments of other operating types, 1987 SALEOTHF 1 Data Data Data Data Data Data Flag SALEOTH 10 Data/NA Data/NA Data/NA Data/NA Data/NA Sales of other operating types ($1,000), 1987 Record size is 136 characters. Equivalent printed report tables are 5,6,7,8, and 9 in the geographic area series publications. 1. Total figures are provided for all counties and all places with a population of 2500+. Kind-of-business data are available for counties and places with 200 or more establishments. 2. New England county records have MSA and PMSA codes of 0000; non- New England, non-MSA counties have MSA and PMSA codes of 9999. 3. Places which cross-county boundaries are assigned MSA/PMSA codes of `0000'. 4. Areas not in MSA's have codes of 9999. 5. Areas not in PMSA's have codes of 9999. 6. Record type 16 contains the kind-of-business data for counties with 200 or more establishments. 7. Record type 17 contains the kind-of-business data for places with 200 or more establishments. 8. Data are not available in this field for Type of Operation code 50. Notes: The repeated information for merchant wholesalers and other operating types which is on the printed table header is shown in a separate record. These records are uniquely identified by the code for type of operation. Census of Wholesale Trade, 1987 Geographic Area Series FILE 4 LAYOUT State Rankings Files: Counties and Places 2500 and Over U.S. Rankings Files: MSAs and CMSAs, 250 largest Counties, 250 Largest Cities --------------------------------------------------------------------------- Record Type File Description --------------------------------------------------------------------------- Field Field Name Size County Places 2500+ 2500+ --------------------------------------------------------------------------- ST 2 Data Data FIPS State Code MSA 4 Data/NA(1) Data/NA(2) MSA/CMSA Code(3) PMSA 4 Data/NA(1) Data/NA(2) PMSA Code(4) COUNTY 3 Data Data FIPS County Code PLACE 4 NA Data Census Place Code PLACEFIP 5 NA Data FIPS Place Code GEOTEXT 20 Data Data Alphabetic Geographic Description RECTYPE 2 06 07 Record Type Code SALESF 1 Data Data Data Flag 0 No suppression 1 Data are withheld to avoid disclosing data for individual companies (D) 2 Data not available (NA) 3 Data not comparable (NC) 5 Data not applicable (X) 6 1982 figure is revised since 1982 publications (R) SALES 10 Data Data Sales ($1,000), 1987 SALRANKF 1 Data Data Data Flag SALRANK 3 Data Data Volume of Sales Ranking within State CUMSALEF 1 Data Data Data Flag CUMSALE 10 Data Data Cumulative Sales ($1,000) within State for all areas with this rank or higher CUMPCTF 1 Data Data Data Flag CUMPCT 6 Data Data Cumulative percent of State total sales ($1,000) for all areas with this rank or higher Record size is 78 characters. Equivalent printed report tables are 10 and 11. (1)New England county records have MSA and PMSA codes of 0000; non-New England, non-MSA counties have MSA and PMSA codes of 9999. (2)Places which cross county boundaries have MSA and PMSA codes of `0000'. (3)Areas not in MSA's have codes of 9999. (4)Areas not in PMSA's have codes of 9999. Census of Wholesale Trade, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 1 State, Metropolitan, Non-Metropolitan, Counties and Places (Totals) --------------------------------------------------------------------------- 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 RECTYPE C 2 0 Record Type (02=State,04=MSA,05=non- MSA,06=County,07=Place) WHS87KB C 3 0 Wholesale Kind-of-Business Code (001=Total Wholesale Trade) ESTAB N 7 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES ---------- (flags: 0=data, 1=D, 2=NA, 3=NC, 5=X) SALES N 10 0 Sales ($1,000), 1987 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 9 0 Payroll entire year ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYEES EMPLOYE N 8 0 Number of paid employees for March 12, 1987 ---------- Merchant wholesalers ESTAMER N 7 0 Number of merchant wholesaler establishments, 1987 SALEMERF N 1 0 Flag for SALEMER SALEMER N 10 0 Sales of merchant wholesalers ($1,000), 1987 PAYRMERF N 1 0 Flag for PAYRMER PAYRMER N 9 0 Payroll entire year of merchant wholesalers ($1,000), 1987 EMPLMERF N 1 0 Flag for EMPLMER EMPLMER N 8 0 Number of paid employees of merchant wholesalers, March 12, 1987 ---------- Other operating types ESTAOTH N 7 0 Number of establishments of other operating types, 1987 SALEOTHF N 1 0 Flag for SALEOTH SALEOTH N 10 0 Sales of other operating types ($1,000), 1987 Total Size 119 Census of Wholesale Trade, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 2 State Totals, Ratios and Comparative Statistics --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- ST C 2 0 FIPS State Code RECTYPE C 2 0 Record Type (10=State tables 1&2, 11=table 3, 12=table 4) WHS87KB C 3 0 Wholesale Trade Kind-of-Business Code (001=Total Wholesale) ---------- (for text, incl. SIC code, Add Labels) OPTYPE C 2 0 Wholesale Type of Operation (00=total,10=Merchant Whsr,etc.) ESTAB N 7 0 Number of establishments, 1987 ESTAB82F N 1 0 Flag for ESTAB82 ---------- (flags: 0=data, 1=D, 2=NA, 3=NC, 5=X) ESTAB82 N 7 0 Number of establishments, 1982 SALESF N 1 0 Flag for SALES SALES N 10 0 Sales ($1,000), 1987 SALES82F N 1 0 Flag for SALES82 SALES82 N 10 0 Sales ($1,000), 1982 SALESCHF N 1 0 Flag for SALESCH SALESCH N 8 1 Percent change in sales, 1982-1987 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 8 0 Payroll entire year ($1,000), 1987 PAYRO82F N 1 0 Flag for PAYRO82 PAYRO82 N 8 0 Payroll entire year ($1,000), 1982 PAYROCHF N 1 0 Flag for PAYROCH PAYROCH N 8 1 Percent change in payroll entire year, 1982- 1987 PAYRO1QF N 1 0 Flag for PAYRO1Q PAYRO1Q N 8 0 Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYE EMPLOYE N 8 0 Number of paid employees for pay period including March 12, 1987 EMPLO82F N 1 0 Flag for EMPLO82 EMPLO82 N 8 0 Number of paid employees for pay period including March 12, 1982 SALESESF N 1 0 Flag for SALESES SALESES N 8 0 Sales per establishment ($), 1987 SALESEMF N 1 0 Flag for SALESEM SALESEM N 7 0 Sales per employee ($), 1987 PAYEMPF N 1 0 Flag for PAYEMP PAYEMP N 6 0 Annual payroll per employee ($), 1987 EMPESTF N 1 0 Flag for EMPEST EMPEST N 4 0 Employees per establishment, 1987 (whole number) PAYEXPF N 1 0 Flag for PAYEXP PAYEXP N 5 1 Annual payroll as a percent of operating expenses, 1987 EXPENSEF N 1 0 Flag for EXPENSE EXPENSE N 10 0 Operating expenses ($1,000), 1987 INVEN86F N 1 0 Flag for INVEN86 INVEN86 N 10 0 End of 1986 inventories ($1,000) INVEN87F N 1 0 Flag for INVEN87 INVEN87 N 10 0 End of 1987 inventories ($1,000) EXPSALF N 1 0 Flag for EXPSAL EXPSAL N 8 1 Operating expenses as a percent of sales, 1987 INVSALF N 1 0 Flag for INVSAL INVSAL N 8 1 End of 1987 inventories as a percent of sales, 1987 Total Size 195 Census of Wholesale Trade, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 3 Detailed Kind of Business for States, Counties, and Places --------------------------------------------------------------------------- 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) RECTYPE C 2 0 Record Type (02=State,04=MSA,05=non- MSA,06=County,07=Place) ESTAB N 7 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES --------- (flags: 0=data, 1=D, 2=NA, 3=NC, 5=X) SALES N 10 0 Sales ($1,000), 1987 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 9 0 Payroll entire year ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYEES EMPLOYE N 8 0 Number of paid employees for March 12, 1987 ---------- Merchant wholesalers ESTAMER N 7 0 Number of merchant wholesaler establishments, 1987 SALEMERF N 1 0 Flag for SALEMER SALEMER N 10 0 Sales of merchant wholesalers ($1,000), 1987 PAYRMERF N 1 0 Flag for PAYRMER PAYRMER N 9 0 Payroll entire year of merchant wholesalers ($1,000), 1987 EMPLMERF N 1 0 Flag for EMPLMER EMPLMER N 8 0 Number of paid employees of merchant wholesalers, March 12, 1987 ---------- Other operating types ESTAOTH N 7 0 Number of establishments of other operating types, 1987 SALEOTHF N 1 0 Flag for SALEOTH SALEOTH N 10 0 Sales of other operating types ($1,000), 1987 Total Size 136 Census of Wholesale Trade, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 4 State Rankings Files: Counties and Places 2500 and Over U.S. Rankings Files: MSAs and CMSAs, 250 Largest Counties, 250 Largest Cities --------------------------------------------------------------------------- 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) RECTYPE C 2 0 Record Type (02=State,04=MSA,05=Non- MSA,06=County,07=Place) SALESF N 1 0 Flag for SALES ------ (flags: 0=data, 1=D, 2=NA, 3=NC, 5=X) SALES N 10 0 Sales ($1,000), 1987 SALRANKF N 1 0 Flag for SALRANK SALRANK N 3 0 Sales rank within state CUMSALEF N 1 0 Flag for CUMSALE CUMSALE N 10 0 Cumulative sales ($1,000) for areas with this rank or higher CUMPCTF N 1 0 Flag for CUMPCT CUMPCT N 6 0 Cumulative percent of state sales for areas this rank or higher Total Size 78 CENSUS OF WHOLESALE TRADE--GEOGRAPHIC AREA SERIES User Notes This section will contain information relevant to the 1987 Census of Wholesale Trade: Geographic Area Series 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.