David Autor

Autor (2010): CAP/Hamilton Paper

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

Downloads

Cleaning/Prep Files:

Acemoglu and Autor (2010) Data Archive

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