CHAPTER VIII 1987 Census of Service Industries--Geographic Area Series Abstract VIII-3 File Specifications VIII-7 File Layouts VIII-9 Database Structures VIII-17 User Notes VIII-25 CENSUS OF SERVICE INDUSTRIES--GEOGRAPHIC AREA SERIES Abstract CONTENTS Citation VIII-3 Type of File VIII-3 Universe Description VIII-3 Subject-Matter Description VIII-3 Geographic Coverage VIII-3 Technical Description VIII-3 Reference Materials VIII-4 Related Printed Reports VIII-4 Related Machine-Readable Data Files VIII-5 Availability VIII-5 CITATION Census of Service Industries 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 service industry establishments with payroll which are covered in the 1987 Census of Service Industries. Subject-Matter Description: This series of four files provides 1987 data by SIC category for the following: Number of establishments Number of paid employees for pay period including March 12, 1987 Number of partnerships for unincorporated business Number of sole proprietorships for unincorporated business Payroll entire year Payroll first quarter Receipts (for firms subject to Federal Income Tax) Revenues and expenses (for firms subject to Federal Income Tax) Receipts/revenue per establishment Receipts/revenue per employee Annual payroll per employee Employees per establishment Expenses (for firms exempt from Federal Income Tax) Expenses per employee Expenses per establishment 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, receipts or revenues, payroll entire year, and number of paid employees. These data are exactly the same as shown in the printed report series of the same name, SC87-A-1 to 51. Each record layout indicates which printed tables correspond to that file. 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, and counties and places with 350 or more service establishments with payroll subject to Federal Income Tax. 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 a separate file within each of the groups listed below. Each file name consists of the group name (e.g. SC87A1) plus the two-character postal abbreviation (e.g. AL), with the extension .DBF. File Size: Approximate size in kilobytes is shown on page vii. 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 label files: SC87A1: 1. File Sequence: State records, followed by records for Places 2500+, counties, MSA/CMSA/PMSAs, then non-MSA records 2. Available indexes: a. SC87K1: By kind of business, record type and geography b. SC87C1: First record for each county c. SC87M1: First record for each MSA or CMSA d. SC87N1: First record for each PMSA e. SC87P1: First record for each Place 3. Linkable label files: a. SVC87KB (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) SC87A2: 1. File Sequence: All record type 10 records followed by all record type 11 records followed by all record type 12 records 2. Available indexes: a. SC87R2: First record for each record type 3. Linkable label files: a. SVC87KB (kind of business code) b. RECTYPE (record type labels) c. STCODE (state names) SC87A3: 1. File Sequence: State record, followed by county record, followed by records for places within the county 2. Available indexes: a. SC87C3: By record type, county and place b. SC87M3: By MSA 3. Linkable label files: a. MSA (MSA, CMSA, and PMSA titles) SC87A4: 1. File Sequence: All Places 2500+ in rank order, followed by all Counties 2500+ in rank order 2. Available indexes: a. SC87R4: First record for each record type 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: 1987 Economic Censuses: Geographic Area Series on CD-ROM 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 CD-ROM order. Additional copies are available for $5 from Customer Services, Bureau of the Census, Washington, DC 20233. CENSUS OF SERVICE INDUSTRIES--GEOGRAPHIC AREA SERIES File Specifications CONTENTS General Data Specifications VIII-7 File Layout VIII-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 77. 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 SC87A1 and SC87A2 files are specific to a particular kind of business, as identified by the SVC87KB 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 C, and also in the file SVC87KB.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 SC87A2 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 Service Industries, 1987 Geographic Area Series FILE 1 LAYOUT General Statistics --------------------------------------------------------------------------- Record Type File Description --------------------------------------------------------------------------- Field Field Name Size State MSA/ Non-MSA County Places or U.S. CMSA/ 350+ Est(1) 350+ Est(1) PMSA (Tables (Tables (Tables (Table 7) (Table 6) 1a,1b) 8a,8b) 9a,9b) --------------------------------------------------------------------------- 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/NA(3) 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 07 Record Type Code TAXSTAT 1 NA Data Data Data Data Tax Status of Service Industries on this record 0 Subject to Federal Income Tax 1 Exempt from Federal Income Tax SVC87KB 3 Data Data Data Data Data Kind-of-Business Code (Table Stub Line Number) e.g. 101=Total Taxable Service Industries ESTAB 7 Data Data Data Data Data Number of establishments, 1987 RCPTFF 1 Data Data Data Data Data Data Flag RCPTF 10 Data Data Data Data Data Receipts (Revenues for tax-exempt firms) ($1,000), 1987 PAYROLLF 1 Data Data Data Data Data Data Flag PAYROLL 9 Data Data Data Data Data Payroll entire year ($1,000), 1987 EMPLOYEF 1 Data Data Data Data Data Data Flag EMPLOYE 8 Data Data Data Data Data Number of paid employees for pay period including March 12, 1987 SOLEPRO 6 Data/NA Data/NA Data/NA Data/NA Data/NA Unincorporated businesses-Number of sole proprietorships, 1987 PARTSHP 6 Data/NA Data/NA Data/NA Data/NA Data/NA Unincorporated businesses-Number of partnerships, 1987 Record size is 86 characters. Equivalent printed report tables are 1a, 1b, 6, 7, 8a, 8b, 9a, and 9b in the geographic area series publications. (1)Data are available only for establishments subject to Federal income tax. (2)NA code (`0000') appears in New England; non-MSA counties are coded `9999'. (3)Places which cross county boundaries have county codes of `000' and MSA and PMSA codes of `0000'. (4)Areas not in a MSA have codes of `9999'. (5)Areas not in a PMSA have codes of `9999'. Census of Service Industries, 1987 Geographic Area Series FILE 2 LAYOUT Ratios and Comparative Statistics U.S. and States --------------------------------------------------------------------------- Record Type File Description --------------------------------------------------------------------------- Field Field Name Size (Tables (Tables (Tables 2,2b) 3a,3b) 4a,4b) State, U.S. State, U.S. State, U.S. (Ratios) (Bridge (SIC's that Tables) Changed 1972-1987) --------------------------------------------------------------------------- ST 2 Data Data Data FIPS State Code RECTYPE 2 10, 20 11, 21 12, 22 Record Type Code TAXSTAT 1 Data Data Data Tax Status of Service Industries on this record 0 Subject to Federal Income Tax 1 Exempt from Federal Income Tax SVC87KB 3 Data Data Data Kind-of-Business Code (Table Stub Line Number e.g. 101=Total Taxable Service Industries) ESTAB 7 NA Data Data Number of establishments, 1987 ESTAB82F 1 Data Data Data Data Flag ESTAB82 7 NA Data Data Number of establishments, 1982 RCPTF 1 Data Data Data Data Flag RCPT 10 NA Data/NA Data Receipts (Revenue for establishments exempt from Federal Income Tax) ($1,000), 1987 RCPT82F 1 Data Data Data Data Flag RCPT82 10 NA Data/NA NA Receipts (Revenue for establishments exempt from Federal Income Tax) ($1,000), 1982 RCPTCHGF 1 Data Data Data Data Flag RCPTCHG 8 NA Data NA Receipts (Revenues for tax-exempt establishments) percent change 1982- 1987 (1 implied decimal) PAYROLLF 1 Data Data Data Data Flag PAYROLL 9 NA Data Data Payroll entire year ($1,000), 1987 PAYRO82F 1 Data Data Data Data Flag PAYRO82 9 NA Data Data Payroll entire year ($1,000), 1982 PAYROCHF 1 Data Data Data Data Flag PAYROCH 8 NA Data NA Payroll entire year, percent change, 1982- 1987 (1 implied decimal) PAYRO1QF 1 Data Data Data Data Flag PAYRO1Q 8 NA NA Data Payroll first quarter ($1,000), 1987 EMPLOYEF 1 Data Data Data Data Flag EMPLOYE 8 Data Data Data Number of paid employees for pay period including March 12, 1987 EMPLO82F 1 Data Data Data Data Flag EMPLO82 8 NA Data NA Number of paid employees for pay period including March 12, 1987 EXPENSEF 1 Data Data Data Data Flag EXPENSE 9 NA Data/NA NA Expenses (applicable only for firms exempt from Federal Income Tax) ($1,000), 1987 EXPEN82F 1 Data Data Data Data Flag EXPEN82 8 NA Data/NA NA Expenses (applicable only for firms exempt from Federal Income Tax) ($1,000), 1982 EXPCHGF 1 Data Data Data Data Flag EXPCHG 8 NA Data/NA NA Expenses (per cent change) (applicable only for firms exempt from Federal Income Tax), 1982 to 1987 (one implied decimal) RCPTESTF 1 Data Data Data Data Flag RCPTEST 8 Data NA NA Receipts (Revenues for tax-exempt firms) per establishment (In $), 1987 RCPTEMPF 1 Data Data Data Data Flag RCPTEMP 6 Data NA NA Receipts (Revenues for tax-exempt firms) per employee ($), 1987 PAYEMPF 1 Data Data Data Data Flag PAYEMP 6 Data NA NA Annual payroll per employeee ($), 1987 EMPESTF 1 Data Data Data Data Flag EMPESTF 4 Data NA NA Employees per establishment (whole number), 1987 EXPESTF 1 Data Data Data Data Flag EXPEST 8 Data/NA NA NA Expenses per establishment (applicable only for firms exempt from Federal Inceom Tax) (In $), 1987 EXPEMPF 1 Data Data Data Data Flag EXPEMP 6 Data/NA NA NA Expenses per employee (applicable only for exempt from Federal Income Tax) (In $), 1987 Record size is 182 characters. Equivalent printed report tables are 2a, 2b, 3a, 3b, 4a, and 4b in the geographic area series publications. Census of Service Industries, 1987 Geographic Area Series FILE 3 LAYOUT Counties and Places with a Population of 2500 and Over (For Firms Subject to Federal Income Tax) --------------------------------------------------------------------------- Record Type File Description --------------------------------------------------------------------------- Field Field Name Size State County(1) Places(1) (Table 5) 2500+ 2500+ (Table 5) --------------------------------------------------------------------------- ST 2 Data Data Data FIPS State Code MSA 4 NA Data/NA(2) Data/NA(3) MSA/CMSA Code(4) MSA 4 NA Data/NA(2) Data/NA(3) PMSA Code(5) COUNTY 3 NA Data Data(3) FIPS County Code PLACE 4 NA NA Data Census Place Code (balance of county coded `9999') PLACEFIP 5 NA NA Data/NA FIPS Place Code GEOTEXT 20 Data Data Data Alphabetic Geographic Description RECTYPE 2 02 06 07 Record Type Code ESTAB 7 Data Data Data Number of establishments, 1987 RCPTF 1 Data Data Data Data Flag RCPT 10 Data Data Data Receipts ($1,000), 1987 PAYROLLF 1 Data Data Data Data Flag PAYROLL 9 Data Data Data Payroll entire year ($1,000), 1987 PAYRO1QF 1 Data Data Data Data Flag PAYRO1Q 8 Data Data Data First quarter payroll ($1,000), 1987 EMPLOYEF 1 Data Data Data Data Flag EMPLOYE 8 Data Data Data Number of paid employees for pay period including March 12, 1987 SOLEPRO 6 Data Data Data Unincorporated businesses or operations  Number of sole proprietorships, 1987 PARTSHP 6 Data Data Data Unincorporated businesses or operations  Number of partnerships, 1987 Kind-of-Business Groups ESTAB70 6 Data Data Data Hotels, rooming houses, camps, and other lodging places (except membership lodging (SIC 70, ex. 704): Number of establishments, 1987 RCPT70F 1 Data Data Data Data Flag RCPT70 9 Data Data Data Hotels, rooming houses, camps, and other lodging places (except membership lodging (SIC 70, ex. 704): Receipts, 1987 ($1,000) ESTAB72 6 Data Data Data Personal Service (SIC 72): Number of establishments Number of establishments RCPT72F 1 Data Data Data Data Flag RCPT72F 9 Data Data Data Personal Services (SIC 72): Receipts ($1,000) ESTAB73 6 Data Data Data Business Services (SIC 73): Number of establishments RCPT73F 1 Data Data Data Data Flag RCPT73 9 Data Data Data Business Services (SIC 73): Receipts ($1,000) ESTAB75 6 Data Data Data Automotive repair, service, and parking (SIC 75): Number of establishments RCPT75F 1 Data Data Data Data Flag RCPT75 9 Data Data Data Automotive repair, service, and parking (SIC 75): Receipts ($1,000) ESTAB76 6 Data Data Data Miscellaneous repair services (SIC 76): Number of establishments RCPT76F 1 Data Data Data Data Flag RCPT76 9 Data Data Data Miscellaneous repair services (SIC 76): Receipts ($1,000) ESTA78P 6 Data Data Data Amusement and recreation services, including motion pictures and museums (SIC 78,79,84): Number of establishments RCPT78PF 1 Data Data Data Data Flag RCPT78P 9 Data Data Data Amusement and recreation services, including motion pictures and museums (SIC 78,79,84): Receipts ($1,000) ESTAB80 6 Data Data Data Health services (SIC 80): Number of establishments RCPT80F 1 Data Data Data Data Flag RCPT80 9 Data Data Data Health services (SIC 80): Receipts ($1,000) ESTAB81 6 Data Data Data Legal serices (SIC 81): Number of establishments RCPT81F 1 Data Data Data Data Flag RCPT81 9 Data Data Data Legal services (SIC 81): Receipts ($1,000) ESTAB83 6 Data Data Data Social services (SIC 83): Number of establishments RCPT83F 1 Data Data Data Data Flag RCPT83 9 Data Data Data Social services (SIC 83): Receipts ($1,000) ESTA87X 6 Data Data Data Engineering, accounting, research, management, and related technical services (except noncommercial research organizations) (SIC 87 ex. 8733): Number of establishments RCPT87XF 1 Data Data Data Data Flag RCPT87X 9 Data Data Data Engineering, accounting, research, management, and related technical services (except noncommercial research organizations) (SIC 87 ex. 8733): Receipts ($1,000) Sales ($1,000) Record size is 262 characters. Equivalent printed report table is 5. (1)Data are available only for establishments subject to Federal Income Tax. (2)NA Code (`0000') appears in New England; non-MSA counties are coded `9999'. (3)Places which cross county boundaries have county codes of `000', and MSA and PMSA codes of `0000'. (4)Areas not in a MSA have codes of `9999'. (5)Areas not in a PMSA have codes of `9999'. Census of Service Industries, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 1 General Statistics --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- ST C 2 0 FIPS State Code MSA C 4 0 MSA or CMSA Code (0000=not in MSA, blank in New England) PMSA C 4 0 PMSA Code (0000=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) TAXSTAT C 1 0 Tax Status (0=Subject to Federal Income Tax, 1=Exempt) SVC87KB C 3 0 Service Kind-of-Business Code (001=Total Service Industries) ESTAB N 7 0 Number of establishments, 1987 RCPTF N 1 0 Flag for RCPT ---------- (flags: 0=data, 1=D, 2=NA, 3=NC, 5=X) RCPT N 10 0 Receipts ($1,000), 1987 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 9 0 Payroll entire year ($1,000), 1987 PAYRO1QF N 1 0 Flag for PAYRO1Q PAYRO1Q N 8 0 Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYEES EMPLOYE N 8 0 Number of paid employees for pay period including March 12, 1987 SOLEPRO N 6 0 Unincorporated businesses: Number of sole proprietorships, 1987 PARTSHP N 6 0 Unincorporated businesses: Number of partnerships, 1987 Total Size 86 Census of Service Industries, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 2 Ratios and Comparative Statistics States --------------------------------------------------------------------------- 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 2a/2b, 11=3a/3b, 12=4a/4b) TAXSTAT C 1 0 Tax Status (0=Subject to Federal Income Tax, 1=Exempt) SVC87KB C 3 0 Service Kind-of-Business Code (001=Total Service Industries) 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 RCPTF N 1 0 Flag for RCPT RCPT N 10 0 Receipts (Revenues of tax-exempts) ($1,000), 1987 RCPT82F N 1 0 Flag for RCPT82 RCPT82 N 10 0 Receipts (revenues of tax-exempts) ($1,000), 1982 RCPTCHGF N 1 0 Flag for RCPTCHG RCPTCHG N 8 1 Percent change in receipts (revenues of exempts), 1982-1987 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 9 0 Payroll entire year ($1,000), 1987 PAYRO82F N 1 0 Flag for PAYRO82 PAYRO82 N 9 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 EXPENSEF N 1 0 Flag for EXPENSE EXPENSE N 9 0 Expenses ($1,000), 1987 (tax-exempt firms only) EXPEN82F N 1 0 Flag for EXPEN82 EXPEN82 N 8 0 Expenses ($1,000), 1982 (tax-exempt firms only) EXPCHGF N 1 0 Flag for EXPCHG EXPCHG N 8 1 Percent change in expenses, 1982 to 1987 (tax-exempts only) RCPTESTF N 1 0 Flag for RCPTEST RCPTEST N 8 0 Receipts (revenues) per establishment ($), 1987 RCPTEMPF N 1 0 Flag for RCPTEMP RCPTEMP N 6 0 Receipts (revenues) 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) EXPESTF N 1 0 Flag for EXPEST EXPEST N 8 0 Expenses per establishment ($), 1987 (tax- exempts only) EXPEMPF N 1 0 Flag for EXPEMP EXPEMP N 6 0 Expenses per employee ($), 1987 (tax-exempts only) Total Size 182 Census of Service Industries, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 3 Counties and Places with a Population of 2500 and Over (For Firms Subject to Federal Income Tax) --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- ST C 2 0 FIPS State Code MSA C 4 0 MSA or CMSA Code (0000=not in MSA, blank in New England) PMSA C 4 0 PMSA Code (0000=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,06=County,07=Place) ESTAB N 7 0 Number of establishments, 1987 RCPTF N 1 0 Flag for RCPTS ---------- (flags: 0=data, 1=D, 2=NA, 3=NC, 5=X) RCPT N 10 0 Receipts ($1,000), 1987 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 9 0 Payroll entire year ($1,000), 1987 PAYRO1QF N 1 0 Flag for PAYROLL1Q PAYRO1Q N 8 0 Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYEES EMPLOYE N 8 0 Number of paid employees for pay period including March 12, 1987 SOLEPRO N 6 0 Number of sole proprietorships, 1987 (n/a for tax-exempts) PARTSHP N 6 0 Number of partnerships, 1987 (n/a for tax-exempts) --------- Kind-of-Business Groups: ESTAB70 N 6 0 70 ex. 704 Hotels, rooming houses, camps, and other lodging RCPT70F N 1 0 Flag for RCPT70 RCPT70 N 9 0 70 ex. 704 Hotels and other lodging places: Receipts ($1000) ESTAB72 N 6 0 72 Personal services RCPT72F N 1 0 Flag for RCPT72 RCPT72 N 9 0 72 Personal services: Receipts ($1,000) ESTAB73 N 6 0 73 Business services RCPT73F N 1 0 Flag for RCPT73 RCPT73 N 9 0 73 Business services: Receipts ($1,000) ESTAB75 N 6 0 75 Automotive repair, services, and parking RCPT75F N 1 0 Flag for RCPT75 RCPT75 N 9 0 75 Automotive repair, services, & parking: Receipts ($1,000) ESTAB76 N 6 0 76 Miscellaneous repair services RCPT76F N 1 0 Flag for RCPT76 RCPT76 N 9 0 76 Miscellaneous repair services: Receipts ($1,000) ESTA78P N 6 0 78,79,84 Amusement & recreation services, including motion pictures. RCPT78PF N 1 0 Flag for RCPT78P RCPT78P N 9 0 78,79,84 Amusement & recreation services: Receipts ($1,000) ESTAB80 N 6 0 80 Health services RCPT80F N 1 0 Flag for RCPT80 RCPT80 N 9 0 80 Health services: Receipts ($1,000) ESTAB81 N 6 0 81 Legal services RCPT81F N 1 0 Flag for RCPT81 RCPT81 N 9 0 81 Legal services: Receipts ($1,000) ESTAB83 N 6 0 83 Social services RCPT83F N 1 0 Flag for RCPT83 RCPT83 N 9 0 83 Social services: Receipts ($1,000) ESTA87X N 6 0 87 ex. 8733 Engineering, accounting, management services RCPT87XF N 1 0 Flag for RCPT87X RCPT87X N 9 0 87 ex. 8733 Engineering, accounting, management services: Receipts ($1,000) Total Size 262 Census of Service Industries, 1987 Geographic Area Series on CD-ROM DATABASE STRUCTURE FILE 4 State Rankings Files: Counties and Places with a Population of 2500 and Over U.S. Rankings File: MSAs and CMSAs, 250 Largest Counties, 250 Largest Cities (Firms Subject to Federal Income Tax Only) --------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- ST C 2 0 FIPS State Code MSA C 4 0 MSA or CMSA Code (0000=not in MSA, blank in New England) PMSA C 4 0 PMSA Code (0000=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 (06=County,07=Place) RCPTF N 1 0 Flag for RCPT RCPT N 10 0 Receipts ($1,000), 1987 RCPRANKF N 1 0 Flag for RCPTRNK RCPRANK N 3 0 Rank in the state in terms of receipts, 1987 CUMRCPTF N 1 0 Flag for CUMRCPT CUMRCPT N 10 0 Cumulative 1987 receipts (largest through current rank) CUMPCTF N 1 0 Flag for CUMPCT CUMPCT N 6 1 Percent of state in cumulative total-1987 receipts Total 77 CENSUS OF SERVICE INDUSTRIES--GEOGRAPHIC AREA SERIES User Notes This section will contain information relevant to the 1987 Census of Service Industries: 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.