Name: College Majors And Earnings Dataset
Creator: FiveThirtyEight
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

College Majors And Earnings Dataset

This dataset contains data from the American Community Survey (2010-2012) Public Use Microdata Series on college majors and their corresponding earnings, unemployment rates, and employment outcomes in the United States.

It includes tables for all ages, recent graduates, graduate students, and a majors list with FOD1P codes.

The dataset provides detailed breakdowns of labor force status, earnings, and gender distribution across major fields of study.

Tables

All Ages College Graduates Employment And Earnings

@fivethirtyeight.college_majors.all_ages

19.2 KB
173 rows
11 columns


CREATE TABLE all_ages (
  "major_code" BIGINT,
  "major" VARCHAR,
  "major_category" VARCHAR,
  "total" BIGINT,
  "employed" BIGINT,
  "employed_full_time_year_round" BIGINT,
  "unemployed" BIGINT,
  "unemployment_rate" DOUBLE,
  "median" BIGINT,
  "p25th" BIGINT,
  "p75th" DOUBLE
);

Graduate Students Employment And Earnings

@fivethirtyeight.college_majors.grad_students

37.55 KB
173 rows
22 columns


CREATE TABLE grad_students (
  "major_code" BIGINT,
  "major" VARCHAR,
  "major_category" VARCHAR,
  "grad_total" BIGINT,
  "grad_sample_size" BIGINT,
  "grad_employed" BIGINT,
  "grad_full_time_year_round" BIGINT,
  "grad_unemployed" BIGINT,
  "grad_unemployment_rate" DOUBLE,
  "grad_median" DOUBLE,
  "grad_p25" BIGINT,
  "grad_p75" DOUBLE,
  "nongrad_total" BIGINT,
  "nongrad_employed" BIGINT,
  "nongrad_full_time_year_round" BIGINT,
  "nongrad_unemployed" BIGINT,
  "nongrad_unemployment_rate" DOUBLE,
  "nongrad_median" DOUBLE,
  "nongrad_p25" BIGINT,
  "nongrad_p75" DOUBLE,
  "grad_share" DOUBLE,
  "grad_premium" DOUBLE
);

College Majors And Categories List

@fivethirtyeight.college_majors.majors_list

7.03 KB
174 rows
3 columns


CREATE TABLE majors_list (
  "fod1p" VARCHAR,
  "major" VARCHAR,
  "major_category" VARCHAR
);

Recent College Graduates Employment And Earnings

@fivethirtyeight.college_majors.recent_grads

35.29 KB
173 rows
21 columns


CREATE TABLE recent_grads (
  "rank" BIGINT,
  "major_code" BIGINT,
  "major" VARCHAR,
  "total" DOUBLE,
  "men" DOUBLE,
  "women" DOUBLE,
  "major_category" VARCHAR,
  "sharewomen" DOUBLE,
  "sample_size" BIGINT,
  "employed" BIGINT,
  "full_time" BIGINT,
  "part_time" BIGINT,
  "full_time_year_round" BIGINT,
  "unemployed" BIGINT,
  "unemployment_rate" DOUBLE,
  "median" BIGINT,
  "p25th" BIGINT,
  "p75th" BIGINT,
  "college_jobs" BIGINT,
  "non_college_jobs" BIGINT,
  "low_wage_jobs" BIGINT
);

Women In STEM Majors

@fivethirtyeight.college_majors.women_stem

11.05 KB
76 rows
9 columns


CREATE TABLE women_stem (
  "rank" BIGINT,
  "major_code" BIGINT,
  "major" VARCHAR,
  "major_category" VARCHAR,
  "total" BIGINT,
  "men" BIGINT,
  "women" BIGINT,
  "sharewomen" DOUBLE,
  "median" BIGINT
);