Data on new occupation titles and codes in the Dictionary of Occupational Titles, 1964, 1977, 1991, and the US Census, 1980, 1990, and 2000

About the data and citation

The data available for download on this page identify new occupational categories in the Dictionary of Occupation Titles of 1977 and 1991 and the occupation classification system used by the U.S. Census in 1980, 1990, and 2000. I used these data to identify which workers in census microdata performed the new combinations of activities or techniques that emerged in the U.S. economy in response to new technologies. Please cite the following paper if you find the data here useful.

Alternatively, the data are also available on the IQSS Dataverse Network.

Lin, Jeffrey. "Technological Adaptation, Cities, and New Work" (May 2011). Review of Economics and Statistics 93 (2); 554-574. [doi:10.1162/REST_a_00079]

Data sources and documentation

Replication files: Processed data and code used in the paper

  • New work by census detailed occupation code: Census detailed occupation codes in 1980, 1990, and 2000, with matched new-title counts (Stata dta). These files are ready to merge on detailed occupation code with IPUMS extracts from 1980 (5%), 1990 (1%), and 2000 (5% or 1% unweighted). Each file contains the number of occupation titles and the share of new occupation titles for each detailed occupation. These files are created by collapsing the raw title lists above. Stata code and crosswalks used to generate these files are available by request.
  • Geographic data: Data for county-based aggregates, 1970–1990 (Stata dta), created by collapsing IPUMS extracts, census summary files, and county data books. Here is a crosswalk between county-based aggregates and the variable CONSPUMA in IPUMS extracts (Stata dta). With the crosswalk, it is possible to match raw IPUMS data to the county-based aggregate data.
  • Data processing: Code (Stata do) for processing raw IPUMS extracts, merging new work variables and city data, and creating regression-ready files. Finished Stata dta file is approximately 2.4 gigabytes. Some changes may be required to get these scripts to work properly on your computer (e.g., changing file paths and commenting out parts that create the occupation and geographic data).
  • Code (Stata do) for running first-step regressions to estimate city-year dummies.
  • Code (Stata do) for figures and tables.

Last updated May 15, 2012

Home URL:

The views expressed on this site are those of the author and do not necessarily represent the views of the Federal Reserve Bank of Philadelphia or the Federal Reserve System.