NBER-CES Manufacturing Industry Database

Eric J. Bartelsman, Randy A. Becker, and Wayne B. Gray

June 2000

This database is a joint effort between the National Bureau of Economic Research (NBER) and U.S. Census Bureau's Center for Economic Studies (CES), containing annual industry-level data on output, employment, payroll and other input costs, investment, capital stocks, TFP, and various industry-specific price indexes. The database covers all 4-digit manufacturing industries from 1958-1996, in two versions: 1987 SIC codes (459 industries) and 1972 SIC codes (448 industries).

The NBER-CES Manufacturing Industry Database (1958-1996)

(the database includes mostly blank 1997 records, with price deflators for shipments and materials)



1987 SIC version: Stata SAS transport dBase Excel Ascii comma-delimited



1972 SIC version: Stata SAS transport dBase Excel Ascii comma-delimited



We ask that you please not forward this data on to others. Instead, please refer interested parties to this website. This ensures that everyone receives the latest version of the data that's available.



Standard Industrial Classification (SIC) information



1987 SIC industry list: Excel Ascii 1987 SIC descriptions: PDF Link

1972 SIC industry list: Excel Ascii

1987-1972 SIC concordance: Excel Ascii Stata



Documentation

Documentation for the 1958-1991 version: NBER Technical Working Paper No. 205

We will eventually update this documentation to reflect issues that have arisen in subsequent versions of the database

Contents

The basic database contains the following variables:

sic Standard Industrial Classification {4-digit manufacturing}

year Year ranges from 58 to 97

emp Total employment in 1000s

pay Total payroll in $1,000,000

prode Production workers in 1000s

prodh Production worker hours in 1,000,000

prodw Production worker wages in $1,000,000

vship Total value of shipments in $1,000,000

matcost Total cost of materials in $1,000,000

vadd Total value added in $1,000,000

invest Total capital expenditure in $1,000,000

invent End-of-year inventories in $1,000,000

energy Cost of electric & fuels in $1,000,000

cap Total real capital stock in $1,000,000

equip Real capital: equipment in $1,000,000

plant Real capital: structures in $1,000,000

piship Deflator for VSHIP 1987=1.000

pimat Deflator for MATCOST 1987=1.000

piinv Deflator for INVEST 1987=1.000

pien Deflator for ENERGY 1987=1.000

dtfp5 5-factor TFP annual growth rate

tfp5 5-factor TFP index 1987=1.000

dtfp4 4-factor TFP annual growth rate

tfp4 4-factor TFP index 1987=1.000



Contact information

Please forward all inquiries to:

Randy Becker, Center for Economic Studies, U.S. Bureau of the Census, randy.a.becker@census.gov

or

Wayne Gray, Clark University and NBER, wgray@clarku.edu





Future updates

To receive notification of future updates and revisions, please leave us your email address: