home page   logout
home | message board | shared documents | data catalog | calendar | edit profile |

Dataset: zipbusiness_94_04.dta

Description: Number of employees and establishments by industry code for each tract

File Location

  home
         Business
                Zip Code Business Patterns
                       zipbusiness_94_04.dta

Dataset Information

Source ZCBP and ESRI
Geographic Detail Census Tract
Geographic Coverage Chicago, Cleveland, Dallas, Seattle
Year Coverage 1994-2004
Restrictions None
Comments Data goes back to 1994, but GIS boundary info only goes bact to 1996 (see documentation)

Click here for additional dataset information

Dataset Summary

Data Dictionary
Number of Rows: 16588
Number of Columns: 36
Column # Variable Variable Description Data Type No. Missing Min Value Max Value
1 fips census geography (2000) character 0 NA NA
2 year year numeric 0 1994 2004
3 ZIPBP_zipcode Closest Zip Code attributed to tract numeric 0 44102 98199
4 ZIPBP_n_establishments # of establishments numeric 6 19 3379
5 ZIPBP_flag_suppressed Boolean: there is a zip code within zipcode with employee but no payroll info character 0 NA NA
6 ZIPBP_n_employees # of emplyees in mid-March numeric 6 0 133216
7 ZIPBP_tot_payroll_q1 Total first quarter payroll numeric 5 0 3101834
8 ZIPBP_tot_payroll_annual Total annual payroll numeric 5 0 10001493
9 ZIPBP_n_sic07 # SIC07 - Agricultural Services, forestry and fishing numeric 11147 1 61
10 ZIPBP_n_sic10 # SIC10 - Mining numeric 15047 1 116
11 ZIPBP_n_sic15 # SIC15 - Construction industries numeric 10561 1 217
12 ZIPBP_n_sic20 # SIC20 - Manufacturing numeric 10564 1 222
13 ZIPBP_n_sic40 # SIC40 - Transportation, communications, and utilities numeric 10574 1 158
14 ZIPBP_n_sic50 # SIC50 - Wholesale trade numeric 10562 1 466
15 ZIPBP_n_sic52 # SIC52 - Retail trade numeric 22 0 963
16 ZIPBP_n_sic60 # SIC60 - Financial, insurance, and real estate industries numeric 10562 1 1067
17 ZIPBP_n_sic70 # SIC70 - Service industries numeric 10558 8 1533
18 ZIPBP_n_sic99 # SIC99 - Unclassified Establishments numeric 3685 0 46
19 ZIPBP_n_naics11 # NAICS11 - Agriculture, foresty, fishing and hunting numeric 13040 0 55
20 ZIPBP_n_naics21 # NAICS21 - Mining numeric 12994 0 83
21 ZIPBP_n_naics22 # NAICS22 - Utilities numeric 11664 0 53
22 ZIPBP_n_naics23 # NAICS23 - Construction numeric 6069 0 287
23 ZIPBP_n_naics31 # NAICS31 - Manufacturing numeric 6084 0 215
24 ZIPBP_n_naics42 # NAICS42 - Wholesale Trade numeric 6067 0 516
25 ZIPBP_n_naics44 # NAICS44 - Retail Trade numeric 6036 3 512
26 ZIPBP_n_naics48 # NAICS48 - Transportation and Warehousing numeric 6135 0 165
27 ZIPBP_n_naics51 # NAICS51 - Information numeric 6259 0 191
28 ZIPBP_n_naics53 # NAICS53 - Real Estate and rental and leasing numeric 6055 0 215
29 ZIPBP_n_naics54 # NAICS54 - Professional, scientific, and technical services numeric 6036 1 1022
30 ZIPBP_n_naics55 # NAICS55 - Management of companies and enterprises numeric 6985 0 95
31 ZIPBP_n_naics56 # NAICS56 - Administrative and support, waste management, remediation svc numeric 6053 1 247
32 ZIPBP_n_naics61 # NAICS61 - Educational services numeric 6141 0 46
33 ZIPBP_n_naics62 # NAICS62 - Health care and social assistance numeric 6055 0 381
34 ZIPBP_n_naics71 # NAICS71 - Arts, entertainment and recreation numeric 6391 0 74
35 ZIPBP_n_naics72 # NAICS72 - Accomodation and foodservices numeric 6037 1 328
36 ZIPBP_n_naics81 # NAICS81 - Other services (except public administration) numeric 6036 1 423


Data coverage by Census Tract / Year
Each cell count is the number of observations within the state/county, per year
State ID State County ID County y94 y95 y96 y97 y98 y99 y00 y01 y02 y03 y04
17 Illinois 865 865 865 865 865 865 865 865 865 865 865
17031 Cook 865 865 865 865 865 865 865 865 865 865 865
39 Ohio 224 224 224 224 224 224 224 224 224 224 224
39035 Cuyahoga 224 224 224 224 224 224 224 224 224 224 224
48 Texas 294 294 294 294 294 294 294 294 294 294 294
48085 Collin 9 9 9 9 9 9 9 9 9 9 9
48113 Dallas 282 282 282 282 282 282 282 282 282 282 282
48121 Denton 3 3 3 3 3 3 3 3 3 3 3
53 Washington 125 125 125 125 125 125 125 125 125 125 125
53033 King 125 125 125 125 125 125 125 125 125 125 125