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

New occupation titles

  • Explanation: These are processed data files that measure new occupational classifications at the "title" level, in the 2000 Census, the 1991 DOT, and the 1977 DOT. 
  • Documentation: The construction of these data is described in the article's data appendix. Unfortunately, detailed documentation is not available at this time. They are in Stata .dta format. 
  • New titles in the 2000 Census --- new_lin and new_cenx are the measures used and described in the article.
  • New titles in the 1991 DOT --- new_convt is the measure used and described in the article. 
  • New titles in the 1977 DOT--- newmaster is the measure used and described in the article. 

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 July 19, 2018 

Home URL: http://jlin.org/

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.