Data Archive

Data Archive By Topic

The following papers cannot be made available for Public Use

Macroeconomics, Labor Economics, Public Economics, Political Economy

Does Job Testing Harm Minority Workers? Evidence from Retail Establishments

The Quarterly Journal of Economics, 123(1), 219–277
David H. Autor, David Scarborough
February 2008
" "
Labor Economics, Macroeconomics, Political Economy, Public Economics

Do Temporary Help Jobs Improve Labor Market Outcomes for Low-Skilled Workers? Evidence from 'Work First'

American Economic Journal: Applied Economics, 2(3), 96–128
David H. Autor, Susan N. Houseman
July 2010
Macroeconomics, Labor Economics, Public Economics, Political Economy

Why Do Temporary Help Firms Provide Free General Skills Training?

The Quarterly Journal of Economics, 116 (4), 1409–1448
David H. Autor
November 2001
" "
Labor Economics, Macroeconomics, Political Economy, Public Economics

Does Employment Protection Reduce Productivity? Evidence from US States

Economic Journal, 117, F189–F219
David H. Autor, William R. Kerr, Adriana D. Kugler
June 2007

Inequality and Technological Change

Evaluating Econometric Evaluations of Post-Secondary Aid
Joshua Angrist, David Autor, Sally Hudson and Amanda Pallais
American Economic Review: Papers & Proceedings, 2015, 105(5): 502-507.

Downloads:

File package containing do-files (zipped)

Import Competition and the Great U.S. Employment Sag of the 2000s
Daron Acemoglu, David Autor, David Dorn, Gordon H. Hanson, and Brendan Price
Journal of Labor Economics, forthcoming.

Downloads:

Replication files and instructions

File package containing datasets, and do-files (zipped)

Computing Inequality: Have Computers Changed the Labor Market?
David Autor, Lawrence Katz and Alan Krueger
Quarterly Journal of Economics, November 1998, 113 (4), 1169-1214.

Downloads (all datasets, do-files, log files, and graphs zipped):

Tables:

Table 1. Levels and Changes in the Educational Composition of Employment and the College+/High School Wage Premium, 1940-1996 (excel)

Table 2. College and College Equivalent Wage-Bill Shares, Supply and Demand Shifts, 1940-1996 (excel)

Table 3. Between- and Within- Industry Decomposition of the Increase in the Share of College Graduates in Employment, 1960 - 1996 (excel)

Table 4. Percent of Workers in Various Categories Who Directly Use a Computer at Work (excel)

Table 5. OLS First-Difference Panel Estimates of the Relationship Between Computerization and Educational Upgrading in 3-Digit Industries Between 1979 and 1993

Table 6. OLS First-Difference Estimates of the Relationship Between Computerization 1984 - 1993 and Growth in the College Wage-Bill Share in 3-Digit Industries 1960 - 1996

Table 7. Computers, Capital Intensity, R&D, and Skill Upgrading, 1960 - 1990 in Non-agricultural, Predominantly Private Sector Industries

Table 8. Change in the Nonproduction Worker Share of the Wage Bill in 450 Four-Digit Manufacturing Industries, 1959 - 1989*

Figures:

Figure 1. Changes in Computer Use and Industry Work-Force Educational Shares

*Note on Table 8: Unfortunately, the variable dexpsh that is needed to generate columns 4-8 was lost in the process of compiling the table 8 materials. Therefore, the do-file only generates columns 1 through 3. See tab8.log for the columns tab8.do generates, and tab8_full.log for all the Table 8 columns (1-8).

Women, War and Wages: The Effect of Female Labor Supply on the Wage Structure at Mid-Century
David Autor, Daron Acemoglu and David Lyle
Journal of Political Economy, June 2004,112(3).

Downloads (all datasets, do-files, and log files zipped):

List of State Mobilization Rates (excel file)

Tables:

Table 1. Characteristics of U.S. State Residents in Low-, Medium-, and High-Mobilization Rate States, 1940, 1950, and 1960 (datasets) (do and log files)

Table 3. OLS Estimates of Impact f Female Labor Supply on Earnings: 1940-90 at Various Time Intervals (datasets) (do and log files)

Table 4. 1940 State-Level Determinants of WWII Mobilization Rates (datasets) (do and log files)

Table 5. Impact of WWII Mobilization Rates on Labor Supply, 1940-50 (datasets) (do and log files)

Table 6. Impact of WWII Mobilization Rates on Female Labor Supply, 1940-50, Controlling for the Fraction of Males in Occupations and Industries in 1940 (datasets) (do and log files)

Table 7. Instrumental Variables Estimates of the Impact of WWII Mobilization Rates (datasets) (do and log files)

Table 8. Impact of WWII Mobilization Rates on Female Labor Supply, 1940-50, 1950-60, and 1930-40 (datasets) (do and log files)

Table 9. Instrumental Variables Specifications: Impact of Female Labor Supply on Female and Male Earnings, 1940-50 (datasets) (do and log files)

Table 10. Impact of Female Labor Supply on Female/Male Earnings Differential, 1940-50 (datasets) (do and log files)

Table 11. Impact of Female Labor Supply on Female and Male Full-Time Weekly Earnings, 1940-50 (datasets) (do and log files)

Table 12. Impact of Female Labor Supply on Male Education Earnings Differential, 1940-50 (datasets) (do and log files)

Table A1. Impact of WWII Mobilization Rates on Female Labor Supply by Age, Education, and Cohort, 1940-50 (datasets) (do and log files)

The Polarization of the U.S. Labor Market
David H. Autor, Lawrence F. Katz and Melissa S. Kearney
American Economic Review Papers and Proceedings, May 2006, 96(2), 189-194.

NBER working paper version (pdf file)


Downloads (all datasets, do-files, log files, and graphs zipped):

Cleaning Programs

calc-occ-educ-meds (datasets) (do and log files)
calc-occ-wage-meds (datasets) (do and log files)
2000 Census (datasets) (do and log files)
1990 Census (datasets) (do and log files)
1980 Census (datasets) (do and log files)


Figures:

Figure 1. Male and Female Log Hourly 90/50 and 50/10 Earnings Ratios (datasets) (do and log files) (graphs)

Figure 2. Changes in Male and Female Log Real Hourly Earnings by Percentile, 1973–1988 and 1988–2004

Figure 3. Smoothed Changes in Occupational Employment Shares 1980-2000, with Occupations Ranked by Their 1980 Median Wage (datasets) (do and log files) (graphs)

Figure 4. Smoothed Changes in Occupational Employment Shares 1980-2000, with Occupations Ranked by Their 1980 Average Years of Schooling. (datasets) (do and log files

Trends in U.S. Wage Inequality: Revising the Revisionists
David H. Autor, Lawrence F. Katz and Melissa S. Kearney
Review of Economics and Statistics, May 2008.
 

Downloads (all datasets, do-files, and log files zipped):

Figure 1. Change in Log Real Weekly Wage by Percentile, Fulltime Workers, 1963-2005

Figure 2. Three Measures of Wage Inequality: College/High School Premium, Male 90/10 Overall Inequality, and Male 90/10 Residual Inequality (excel)


May/ORG files

Source data
out00-occ 79-occ 90-occ may73
out01-occ 80-occ 91-occ may74
out02-occ 81-occ 92-occ may75
out03-occ 82-occ 93-occ may76
out04-occ 83-occ 94-occ may77
out05-occ 84-occ 95-occ may78
out06-occ 85-occ 96-occ
                 86-occ 97-occ
                 87-occ 98-occ
                 88-occ 99-occ
                 89-occ

Cleaning programs
 

Working data sets:

morg_cleaned_1973
morg_cleaned_1974
morg_cleaned_1975
morg_cleaned_1976
morg_cleaned_1977
morg_cleaned_1978
morg_cleaned_1979
morg_cleaned_1980
morg_cleaned_1981
morg_cleaned_1982
morg_cleaned_1983
morg_cleaned_1984
morg_cleaned_1985
morg_cleaned_1986
morg_cleaned_1987
morg_cleaned_1988
morg_cleaned_1989
morg_cleaned_1990
morg_cleaned_1991
morg_cleaned_1992
morg_cleaned_1993
morg_cleaned_1994
morg_cleaned_1995
morg_cleaned_1996
morg_cleaned_1997
morg_cleaned_1998
morg_cleaned_1999
morg_cleaned_2000
morg_cleaned_2001
morg_cleaned_2002
morg_cleaned_2003
morg_cleaned_2004
morg_cleaned_2005
morg_cleaned_2006


March CPS files:

Source data
mar00 mar62 mar70 mar80 mar90
mar01 mar63 mar71 mar81 mar91
mar02 mar64 mar72 mar82 mar92
mar03 mar65 mar73 mar83 mar93
mar04 mar66 mar74 mar84 mar94
mar05 mar67 mar75 mar85 mar95
mar06 mar68 mar76 mar86 mar96
mar07 mar69 mar77 mar87 mar97
                        mar78 mar88 mar98
                        mar79 mar88b mar99
                                   mar89

Cleaning programs


Working data sets:

mar00 mar62 mar70 mar80 mar90
mar01 mar64 mar71 mar81 mar91
mar02 mar65 mar72 mar82 mar92
mar03 mar66 mar73 mar83 mar93
mar04 mar67 mar74 mar84 mar94
mar05 mar68 mar75 mar85 mar95
mar06 mar69 mar76 mar86 mar96
mar07             mar77 mar87 mar97
                       mar78 mar88 mar98
                       mar79 mar89 mar99

Figures:

Figure 3. 90/50 and 50/10 Weekly Wage Inequality In March (Full-Time Workers) and Hourly Wage Inequality in May/ORG (All Workers) CPS Series, 1963–2005

Figure 5. Trends in Composition-Adjusted Real Log Weekly Full-Time Wages By Gender and Education, 1963–2005 (March CPS)

Tables:

Table 1. Changes in Real, Composition-Adjusted Log Weekly Wages for Full-Time, Full-Year Workers, 1963–2005. (100 X Change in Mean Log Real Weekly Wages)

Table 2. Regression Models for the College/High School Log Wage Gap, 1963-2005

Table 3. Regression Models for the College/High School Log Wage Gap by Potential Experience Group, 1963-2005, Males and Females Pooled

Table 4. 100 X Observed and Composition-Constant Changes in Overall and Residual Hourly Inequality Measures (May/ORG CPS 1973, 1989, and 2005)

The Polarization of Job Opportunities in the U.S. Labor Market: Implications for Employment and Earnings
David H. Autor
Center for American Progress and The Hamilton Project, May 2010


Downloads:

Cleaning/Prep Files:

Please see "Skills, Tasks and Technologies: Implications for Employment and Earnings" for data.

Additional May/ORG Prep Files

Additional Census-ACS Prep Files

Crosswalks:

10 Broad Occupation Categories (converted from occ1990dd)

Figures:

Figure 1 - Smoothed Changes in Employment by Occupational Skill Percentile, 1979-2007 (Acemoglu and Autor (2010) Figure 10)

Figure 2 - Percent Changes in Male and Female Hourly Wages Relative to the Median

Figure 3 - Percentage Point Change in Employment by Occupation, 1979-2009 (Acemoglu and Autor (2010) Figure 12)

* Figure 4 - Changes in Occupational Employment Shares by Education and Sex, 1979-2007

Figure 5a/b - United States and European Union Occupation Percentages (Acemoglu and Autor (2010) Figure 15)

Figure 6 - Change in Employment Shares by Occupation in 16 European Countries (Acemoglu and Autor (2010) Figure 11)

Figure 7 - Employment to Population Rates among Black and White Males and Females, ages 20+, 1973-2010

* Figure 8a/b - Changes in Employment to Population Rates by Education and Sex, 1979-2007; Changes in Male Employment to Population Rates by Race Group

Figure 9 - College Degree vs. High School Diploma Log Relative Supply, 1963-2008

Figure 10 - College Degree vs. High School Diploma Weekly Wage Ratio, 1963-2008

Figure 11 - Detrended Changes in College Degree vs. High School Diploma Relative Supply and Relative Wages

** Figure 12 - College Completion Rates of Young Adults, Ages 25-34, by Gender and Race, 1970-2008

** Figure 13 - Percent Changes in Real Hourly Earnings by Education, 1979-2007

Figure 14 - Median Hourly Wage Gain by Years of Schooling, 1973-2007

Appendix Figure 1a/b - Percent Changes in Real Hourly Earnings by Education and Race, 1979-2007 Males/Females

Appendix Figure 2a/b - Changes in Occupational Employment Shares by Education and Race, 1979-2007 Males/Females 

Appendix Figure 3a/b - Change in Occupation Share by Country, 1992-2008 Males/Females

Tables:

Table 1 - Regression Results: Relationship between the change in Employment to Population Ratios and Changes in Real Log Hourly Wages, 1979-2009

Table 2 - Regression Results: Relationship between Employment to Population Ratios and Wages by Demographic Group, 1979-2009

* May/ORG prep files listed above are needed for this figure/table in addition to those in the Acemoglu and Autor (2010) Data Archive

** Census-ACS prep files listed above are needed for this figure/table in addition to those in the Acemoglu and Autor (2010) Data Archive

Skills, Tasks and Technologies: Implications for Employment and Earnings [contains color figures: not B&W printer friendly]
Daron Acemoglu and David H. Autor
Handbook of Labor Economics Volume 4, 2010, Orley Ashenfelter and David E. Card (eds.), Amsterdam: Elsevier.

[Optional: Black and white version of paper for non-color printers]


Downloads:

Census/ACS

Cleaners: Census cleaners

Cleaned .dta files: 1960  1970 1980 1990 2000 2008

Preparation files: Census preparation files


May/ORG

Cleaners: May ORG cleaners

Cleaned .dta files (all years):

1973        1979        1985        1991        1997        2003        2009

1974        1980        1986        1992        1998        2004

1975        1981        1987        1993        1999        2005

1976        1982        1988        1994        2000        2006

1977        1983        1989        1995        2001        2007

1978        1984        1990        1996        2002        2008

Preparation files: May ORG wage preparation files


March CPS

Cleaners: March cleaners

Cleaned .dta files (all years):

1962        1969        1975        1981        1987        1993        1999        2005

1964        1970        1976        1982        1988        1994        2000        2006

1965        1971        1977        1983        1989        1995        2001        2007

1966        1972        1978        1984        1990        1996        2002        2008

1967        1973        1979        1985        1991        1997        2003        2009

1968        1974        1980        1986        1992        1998        2004

Preparation files: Supply, Wages


Additional

Task measure construction

Crosswalks

Eurostat


Figures:

Figure 1 - Composition Adjusted College/High-School Log Weekly Wage Ratio, 1963-2008

Figure 2 - College/High-School Log Relative Supply, 1963-2008

Figure 3a/b - College/High-School Log Relative Supply, 1963-2008 0-9 Years Experience/20-29 Years Experience

Figure 4a/b - Real, Composition-Adjusted Log Weekly Wages for Full-Time Full-Year Workers, 1963-2008 M/F

Figure 5a/b - Predicted Log Hourly Wages by Years of Education, Education Quadratic M/F

Figure 6a/b - Predicted Log Hourly Wages by Years of Education, Education Dummies M/F

Figure 7a/b/c - Cumulative Log Change in Real Weekly Earnings at the 90th, 50th and 10th Wage Percentiles, 1963-2008 MF/M/F

Figure 8a/b/c - Cumulative Log Change in Real Hourly Earnings at the 90th, 50th and 10th Wage Percentiles, 1963-2008 MF/M/F

Figure 9a/b/c - Change in Log Hourly Wages by Percentile Relative to the Median MF/M/F

Figure 10 - Smoothed Changes in Employment by Occupational Skill Percentile 1979-2007

Figure 11 - Change in Employment Shares by Occupation 1993-2006 in 16 European Countries

Figure 12 - Percent Change in Employment by Occupation, 1979-2009

Figure 13a/b/c - Employment Shares by Major Occupation Groups, 1959-2007 MF/M/F

Figure 14a/b - Changes in Employment Shares 1959-2007 in Major Occupations by Educational Category M/F

Figure 15 - U.S. and European Union Occupation Percentages, Age 39 or Less

Figure 16a/b - Change in Employment Shares of Young Workers (Age

Figure 17a/b - Partial R-Squared Net of Experience Quartic, 1959-2007 (Education, Occupation, Industry) M/F

Figure 18a/b - Partial R-Squared Net of Experience Quartic, 1959-2007 (Education, Occupation, Task) M/F

Figure 19 - Katz-Murphy Prediction Model for the College/High-School Wage GapFigure 20 - Detrended Changes in College/High-School Relative Supply and Relative Wages

Figure 20 - Detrended Changes in College/High-School Relative Supply and Relative Wages

Figure 21a/b - Log College/High-School Weekly Wage Ratio, 1963-2008 0-9 Years Experience/20-29 Years Experience


Tables:

Table 1a/b - Changes in Real, Composition-Adjusted Log Weekly Wages for Full-Time Full-Year Workers, 1963-2008: By Educational Category and Sex/By Experience and Educational Category, by Sex

Table 2 - Employment and Wages in Ten Broad Occupations, 1959-2007

Table 3a/b - Employment Shares in Four Broad Occupational Categories (%), 1959-2007; Mean Log Full-Time, Full-Year Weekly and All Hourly Earnings in Four Broad Occupation Categories, 1959-2007 (Census) and 1973-2009 (May/ORG)

Table 4 - Education Distribution by Occupation and Gender in 1979 (Census Data)

Table 5a/b - Means and Standard Deviations of DOT and O*NET Task Measures for Four Broad Occupational Groups in 1979 Census / By Education Level

Table 6 - Decomposition of Changes in the Share of Employment in Four Occupational Categories by Decade due to Changes in Industry Shares and Changes in Occupational Shares within Industries, 1959-2007

Table 7 - Partial R-Squared Values of DOT and O*NET Task and Offshorability Measures, Net of Quartic in Potential Experience

Table 8 - Regression Models for the College/High-School Log Wage Gap, 1963-2008

Table 9 - Regression Models for the College/High-School Log Wage Gap by Potential Experience Group, 1963-2008

Table 10 - OLS Stacked First-Difference Estimates of the Relationship between Demographic Group Occupational Distributions in 1959 and Subsequent Changes in Demographic Groups' Means Log Wages by Decade, 1959-2007

Return of the Solow Paradox? IT, Productivity, and Employment in U.S. Manufacturing
(links to data page of David Dorn)
Daron Acemoglu, David Autor, David Dorn, Gordon Hanson, and Brendan Price
American Economic Review Papers & Proceedings, 2014, 104(5), 394-399.

Downloads:

File package containing datasets, do-files, and log files (zipped)

Untangling Trade and Technology: Evidence from Local Labor Markets
David Autor, David Dorn, Gordon Hanson
The Economic Journal, May 2015, 125, 621-646.

Downloads:

Replication Package: Data, Code, Log Files, and Readme file

Labor Market Intermediation

Disability and Labor Force Participation

The Rise in the Disability Rolls and the Decline in Unemployment
Quarterly Journal of Economics, February 2003, 118(1), 157-206.

Downloads:

Tables:

Table 1. Potential DI Income as a Percentage of Current Earnings for Nonelderly Males at Various Percentiles of the Wage Distribution, 1979 and 1999 (excel)

Table 2. DI Receipt and Labor Force Participation by Gender, Education, and Age 1979, 1984, AND 1999 (excel)

Table 3. Distribution of Qualifying Impairments of DI Awardees at Five-Year Intervals, 1983-1999 (excel)

Table 4. Change in DI Rolls and Labor Force Participation of Nonelderly Adults: OLS and Instrumental Variables Estimates (zip)

Table 5. Impact of Employment Losses on DI Applications Flows 1978-1998: Reduced-Form and Instrumental Variables Estimates (zip)

Table 6. Instrumental Variables Estimates of the Impact of Employment Losses on Labor Force Exit of High School Dropouts, 1979–1998

Table 7. Determinants of Growth in DI Rolls, 1984 –1998

Table 8. Determinants of Change in High School Dropout Labor Force Participation, 1984–1998

Figures:

Figure 1. DI Termination Rates per 1000 Beneficiaries by Reason, 1978–2000 (excel)

Figure 2. The Choice of Disability Applicant Status—Immediately, Conditional, Never—as a Function of Earnings and Health (excel)

Figure 3. Impact of Projected Log Employment Shocks on Disability Applications per 1000 Nonelderly Adults at Five-Year Intervals, 1979–1998

Figure 4. DI Awards and Current and Steady State Recipients per Nonelderly Adult Population, 1976–2001 (excel)
 

Download supplementary materials:

SSDI and SSI recipients, applicants and awards by state and year (excel)

Labor Market Impacts of Wrongful Discharge Protections

The Costs of Wrongful-Discharge Laws
David H. Autor, John J. Donohue III and Stewart J. Schwab
Review of Economics and Statistics, May 2006, 88(2), 211-231.


Downloads:

Tables:

Table 1. Difference-in-Differences Estimates of the Impact of Wrongful Discharge Laws on State Employment-to-Population Ratio and Hourly Earnings: Contrasting Outcomes in Years 2 and 3 Following Adoption with Years 1 and 2 Preceding Adoption

Table 2. Difference-in-Differences Estimates of the Impact of Wrongful-Discharge Laws on Employment and Hourly Wages, 1978–1999: Contrasting the Impact of any Impact of any Doctrine Versus Specific Doctrines

Table 3. Difference-in-Differences Estimates of the Impact of Wrongful Discharge Laws on Employment-to-Population Ratios: Estimates by Adopter Cohorts, 1978-1999

Table 4. Difference-in-Differences Estimates of the Impact of Wrongful-Discharge Laws on Log Employment-to-Population Ratios for Years 1978-1999: Testing Sensitivity to Selection of Pre- and Post-Adoption Treatment Periods

Table 5. Estimates of the Impact of Wrongful-Discharge Laws on Log Employment-to-Population Ratios by Gender, Age and Education Subgroups, 1978-1999

Table 6. Difference-in-Differences Estimates of the Impact of Wrongful-Discharge Laws on Employment Levels, 1970-1999: Annual Estimates from the Current Population Survey and Current Employment Statistics

Table 7. Estimated Impact of Wrongful-Discharge Laws on Annual Job Flows in Manufacturing, 1973 to 1988

Table A1. Wrongful-Discharge Laws by Region, State, and Year (See downloads for wrongful-discharge legal data)

Table A2. Difference-in-Differences Estimates of the Impact of Wrongful-Discharge Laws on State Employment-to-Population Ratio and Hourly Earnings, 1978–1999: Models Excluding Previously Treated State-Month Observations from the Control Sample

Table A3. Relationship Between Job Creation and Destruction and Employment in Manufacturing, 1973 to 1988

Figures:

Figure 1. State Log Employment-to-Population Ratios Before and After Adoption of Implied-Contract Exception: Monthly Leads and Lags from 4 Years Before to 8 Years After Adoption

Figure 2. State Log Employment-to-Population Ratios Before and After Adoption of Public Policy Exception: Monthly Leads and Lags from 4 Years Before to 8 Years After Adoption

Figure 3. State Log Employment-to-Population Ratios Before and After Adoption of Good-Faith Exception: Monthly Leads and Lags from 4 Years Before to 8 Years After Adoption

 

Download wrongful-discharge legal data (not zipped):

Case law (MSWord file)
Appendix Table A1 (MSExcel file)
Law dataset (dta file)