------------------------------------------------------------------------------- log: d:\a_data\proj\union\geo_spill\dat_public\nlrb_cbp_contents_summar > y.log log type: text opened on: 19 Jan 2006, 11:20:04 . clear; . set memory 1000m; Current memory allocation current memory usage settable value description (1M = 1024k) -------------------------------------------------------------------- set maxvar 5000 max. variables allowed 1.733M set memory 1000M max. data space 1,000.000M set matsize 400 max. RHS vars in models 1.254M ----------- 1,002.987M . set more off; . program drop _all; . use d:\a_data\proj\union\geo_spill\dat_public\nlrb_cbp_dat; (NLRB/CBP data used for geo_spill paper, Jan 2006) . desc; Contains data from d:\a_data\proj\union\geo_spill\dat_public\nlrb_cbp_dat.dta obs: 831,237 NLRB/CBP data used for geo_spill paper, Jan 2006 vars: 54 18 Jan 2006 17:45 size: 257,683,470 (75.4% of memory free) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- sic3 str3 %3s 3 digit SIC from NLRB st str2 %2s state FIPS code county str3 %3s county FIPS code employer_name~e str40 %40s Employer name from NLRB eligiblemax int %8.0g Eligbile voters from NLRB nlrbcount byte %8.0g Total number of RC elections in NLRB file for this establishment wincount byte %8.0g Total number of union wins in NLRB file for this establishment uswacount byte %8.0g Total number of USWA elections for this establishment umwcount byte %8.0g Total number of UMW elections for this establishment emphatnlrb int %8.0g Estimated establishment employment=2*eligiblemax cat_match byte %8.0g Type of match of NLRB record to CBP record empcat str2 %2s emp category in CBP data that this establishment is assigned to sic str4 %4s 4 digit SIC sic3text str36 %36s text for sic3 msacmsa str4 %4s msa or cmsa 2000 cmsa str2 %2s 2000 cmsa pmsa str4 %4s 2000 pmsa necma str4 %4s 2000 necma (New England County equivalent) sttext str2 %2s cntytext str27 %27s County Text pop60 double %10.0g County population, 1960. from City, County, Data Base ICPSR totemp60 double %10.0g County Total Emp, 1960 (var 170 from city/count data base 1944-77,ICPSR 7736 emp10 float %9.0g county sic10 employment, 1958 Census (metal mining), estimated using cell counts est10 float %9.0g county sic10 number of establishments, 1958 Census (metal mining) emp11 float %9.0g county sic11 employment, 1958 Census (anthracite mining) estimated using cell co est11 int %8.0g county sic11 number of establishments, 1958 Census (antracite mining) emp12 float %9.0g county sic12 employment, 1958 Census (bituminous coal) estimated using cell coun est12 int %8.0g county sic12 number of establishments, 1958 Census (bituminous) emp33 float %9.0g county sic33 employment, 1958 Census (primary metal) estimated using cell counts est33 int %8.0g county sic33 number of establishments, 1958 Census (primary metal) pop2000 long %12.0g population census 2000 land float %9.0g land area, sq miles, census 2000 ng_land float %9.0g total land, counties within 30 miles ng_pop2000 long %12.0g total pop2000, counties within 30 miles ng_pop60 double %10.0g total pop60, counties within 30 miles ng_totemp60 double %10.0g total totemp60, counties within 30 miles ng_emp10 float %9.0g total emp10, counties within 30 miles ng_est10 float %9.0g total est10, counties within 30 miles ng_emp11 float %9.0g total emp10, counties within 30 miles ng_est11 int %8.0g total est11, counties within 30 miles ng_emp12 float %9.0g total emp12, counties within 30 miles ng_est12 int %8.0g total est12, counties within 30 miles ng_emp33 double %10.0g total emp33, counties within 30 miles ng_est33 int %8.0g total est33, counties within 30 miles neig_num byte %8.0g number of neighboring counties within 30 miles, including county itself s_par_native float %9.0g share of county white population, 1910 Census, both parents native, from ICPSR s_foreign float %9.0g share of county white population, 1910 Census, foreign born, from ICPSR s_par_foreign float %9.0g share of county white population, 1910 Census, native born, for parents, from IC s_par_mixed float %9.0g share of county white population, 1910 Census, native born, one for parent, from s_black float %9.0g share of county population that is black, 1910 Census from ICPSR name str27 %27s county text pci long %12.0g County per capita income from 2000 Census s_black2000 float %9.0g Share of county population that is black, 2000 Census sharedem1988 float %9.0g County 1988 pres. elect voting dem, as % of number voting dem or rep, ICPSR 0013 ------------------------------------------------------------------------------- Sorted by: . sum; Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- sic3 | 0 st | 0 county | 0 employer_n~e | 0 eligiblemax | 11011 68.98556 141.3887 1 4455 -------------+-------------------------------------------------------- nlrbcount | 831237 .0159666 .1565817 0 17 wincount | 831237 .0086233 .1097714 0 15 uswacount | 831237 .0003405 .0219064 0 6 umwcount | 831237 .0000265 .0053733 0 2 emphatnlrb | 11011 137.9711 282.7773 2 8910 -------------+-------------------------------------------------------- cat_match | 11011 1.141858 .5164345 1 4 empcat | 0 sic | 0 sic3text | 0 msacmsa | 0 -------------+-------------------------------------------------------- cmsa | 0 pmsa | 0 necma | 0 sttext | 0 cntytext | 0 -------------+-------------------------------------------------------- pop60 | 831237 537061 1109436 0 6038771 totemp60 | 831237 206257.2 442598.8 0 2373691 emp10 | 831237 59.09022 394.3322 0 7237.417 est10 | 831237 1.775699 5.05482 0 94 emp11 | 831237 21.77259 419.4513 0 10569.35 -------------+-------------------------------------------------------- est11 | 831237 .7750846 15.86295 0 580 emp12 | 831237 68.9354 479.1378 0 8405.19 est12 | 831237 2.023032 13.32753 0 456 emp33 | 831237 3380.862 8899.442 0 56120.7 est33 | 831237 28.07443 77.77598 0 443 -------------+-------------------------------------------------------- pop2000 | 831237 861689.1 1604681 356 9519338 land | 831237 1260.767 2085.851 1.985728 20052.5 ng_land | 831237 3050.27 1840.386 151.5887 20052.5 ng_pop2000 | 831237 2274993 3196821 356 1.54e+07 ng_pop60 | 831237 1627449 2852073 619 1.41e+07 -------------+-------------------------------------------------------- ng_totemp60 | 831237 636563.5 1169949 241 5782545 ng_emp10 | 831237 121.5993 477.5734 0 7237.417 ng_est10 | 831237 3.206567 7.152937 0 141 ng_emp11 | 831237 78.35547 1004.416 0 23070.22 ng_est11 | 831237 3.536635 46.62376 0 1082 -------------+-------------------------------------------------------- ng_emp12 | 831237 248.1735 1482.265 0 25768.8 ng_est12 | 831237 7.99758 47.05439 0 1183 ng_emp33 | 831237 9796.702 17884.04 0 111562.4 ng_est33 | 831237 76.99942 141.2387 0 598 neig_num | 831237 4.889009 3.23867 1 16 -------------+-------------------------------------------------------- s_par_native | 831237 .627151 .2439718 .065011 .9991007 s_foreign | 831237 .157267 .1152193 0 .4882023 s_par_fore~n | 831237 .1423651 .100913 0 .4499159 s_par_mixed | 831237 .0732169 .0405457 0 .21744 s_black | 831237 .1092503 .1643885 0 .8693761 -------------+-------------------------------------------------------- name | 0 pci | 831237 21867.29 5383.689 5213 44962 s_black2000 | 831237 .1120539 .12569 0 .8612936 sharedem1988 | 831237 .4483931 .1043775 0 .8524575 . log close; log: d:\a_data\proj\union\geo_spill\dat_public\nlrb_cbp_contents_summar > y.log log type: text closed on: 19 Jan 2006, 11:20:22 -------------------------------------------------------------------------------