Layout of mandat_naics2 file
(sas version and csv
format)
Aug 1, 2012
Description of Supplementary
Files for “An Alternative Theory of the Plant Size Distribution, with Geography
and Intra- and International Trade”
by
Thomas J. Holmes (University of
Minnesota, Federal Reserve Bank of Minneapolis, and NBER)
and
John J. Stevens (Board of
Governors of Federal Reserve System)
Note: The statistics
reported in this file are all derived from public Census data
Description of File:
These files contain industry
level variables constructed with publicly available information, for the 473
NAICS manufacturing industries for 1997.
Variable |
Description |
NAICS |
6 digit NAICS |
sal97 |
Census 1997 sales revenue
(published value) |
est97 |
Census 1997 establishment
count (published value) |
emp97 |
Census 1997 employment
(published value) |
naicstext |
NAICS description |
prodsal97 |
Census 1997 published
product revenue for this NAICS product |
emphat_lm97 |
Estimate of employment for
industry, obtained by using the cell counts from the location of
manufacturing for the 1997 Census, |
empcbp06 |
Industry employment from
2006 County Business Patterns (CBP) |
estcbp06 |
Industry plant counts from
2006 County Business Patterns (CBP) |
emphatcbp06 |
Employment estimate for
industry, if you the cell counts by detailed size class and take average
employment by size class to construct an estimate. |
emp_asm06 |
2006 employment for Annual
Survey of Manufactures (ASM) |
sal_asm06 |
2006 industry sales from
ASM |
prodsal_asm06 |
2006 product sales from
ASM |
impWorld97 |
1997 imports from all
locations. This is custom value of
imports for consumption, obtained from United States International Trade
Commission web site. (Note in the few
cases where the ITC data is at the 5-digit level rather than the 6-digit
level, the 5-digit imports across 6-digit NAICS in proportion to the domestic
6-digit shipments relative to the 5-digit level. |
impWorld06 |
Same as above for 2006 |
impWorld07 |
Same as above for 2007 |
impChina97 |
Same as above for 1997 and
from China |
impChina07 |
Same as above for 2007 and
from China |
expWorld97 |
exports to world, 1997 |
expWorld07 |
exports to world, 2007 |
China_shr97 |
China share of imports for
1997 |
China_shr07 |
China share of imports for
2007 |
naics_itc |
naics |
naicstext_itc |
naics from ITC (International Trade Commission). Note that a few have “x” in the 6th
position and this means the data from the ITC is at the 5-digit level. As discussed above, in this case, the
import data is allocated across the 6-digit industries for the given 5-digit. |
empcbp07 |
employment for industry
from CBP 2007 |
estcbp07 |
plants counts for industry
from CBP 2007 |
flag_empcbp07 |
a flag if the industry
total for empcbp07 uses the cell counts to produce an estimate (because the
Census is not disclosing the industry total) |
sal07 |
Sales revenue for industry
from 2007 Economic Census |
emp07 |
Employment for industry
from 2007 Economic Census |
est07 |
Establishment Counts from
2007 Economic Census |
prodsal07 |
Product shipments for this
6-digit NAICS product from 2007 Census |
naicsindex |
Number for 1 to 473,
indexing the NAICS industries as sorted by NAICS. |