Baselight

College Majors And Earnings Dataset

College Majors, Employment Rates, and Earnings Data in the U.S.

@fivethirtyeight.college_majors

Recent College Graduates Employment And Earnings
@fivethirtyeight.college_majors.recent_grads

Column Description
Rank Ranking of the major based on total number of graduates
Major_code Major code
Major Name of the major
Major_category Category of the major
Total Total number of graduates
Men Number of male graduates
Women Number of female graduates
ShareWomen Proportion of women graduates
Sample_size Sample size used for estimates
Employed Number of employed graduates
Full_time Number of graduates employed full-time
Part_time Number of graduates employed part-time
Full_time_year_round Number of graduates employed full-time and year-round
Unemployed Number of unemployed graduates
Unemployment_rate Unemployment rate
Median Median earnings of full-time employed graduates
P25th 25th percentile of earnings
P75th 75th percentile of earnings
College_jobs Number of graduates in jobs requiring a college degree
Non_college_jobs Number of graduates in jobs not requiring a college degree
Low_wage_jobs Number of graduates in low-wage service jobs
  • 35.29 KB
  • 173 rows
  • 21 columns
rank

Rank

major_code

Major Code

major

Major

total

Total

men

Men

women

Women

major_category

Major Category

sharewomen

ShareWomen

sample_size

Sample Size

employed

Employed

full_time

Full Time

part_time

Part Time

full_time_year_round

Full Time Year Round

unemployed

Unemployed

unemployment_rate

Unemployment Rate

median

Median

p25th

P25th

p75th

P75th

college_jobs

College Jobs

non_college_jobs

Non College Jobs

low_wage_jobs

Low Wage Jobs

12419PETROLEUM ENGINEERING23392057282Engineering0.12056434436197618492701207370.018380527110000950001250001534364193
22416MINING AND MINERAL ENGINEERING75667977Engineering0.1018518527640556170388850.11724137975000550009000035025750
32415METALLURGICAL ENGINEERING856725131Engineering0.1530373833648558133340160.0240963867300050000105000456176
42417NAVAL ARCHITECTURE AND MARINE ENGINEERING12581123135Engineering0.107313196167581069150692400.050125313700004300080000529102
52405CHEMICAL ENGINEERING322602123911021Engineering0.341630502289256942317051801669716720.061097712650005000075000183144440972
62418NUCLEAR ENGINEERING25732200373Engineering0.144966965171857203826414494000.17722640765000500001020001142657244
76202ACTUARIAL SCIENCE377721101667Business0.441355573512912292429624823080.0956521746200053000720001768314259
85001ASTRONOMY AND ASTROPHYSICS1792832960Physical Sciences0.5357142861015261085553827330.0211674156200031500109000972500220
92414MECHANICAL ENGINEERING912278032010907Engineering0.11955890310297644271298131015463946500.05734227860000480007000052844163843253
102408ELECTRICAL ENGINEERING815276551116016Engineering0.1964502566316192855450126954141338950.05917384560000450007200045829108743170

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
);

Share link

Anyone who has the link will be able to view this.