Baselight

College Majors And Earnings Dataset

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

@fivethirtyeight.college_majors

All Ages College Graduates Employment And Earnings
@fivethirtyeight.college_majors.all_ages

Column Description
Major_code Major code
Major Name of the major
Major_category Category of the major
Total Total number of graduates
Employed Number of employed graduates
Employed_full_time_year_round Number employed full-time, 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
  • 19.2 KB
  • 173 rows
  • 11 columns
major_code

Major Code

major

Major

major_category

Major Category

total

Total

employed

Employed

employed_full_time_year_round

Employed Full Time Year Round

unemployed

Unemployed

unemployment_rate

Unemployment Rate

median

Median

p25th

P25th

p75th

P75th

1100GENERAL AGRICULTUREAgriculture & Natural Resources128148902457407824230.026147106500003400080000
1101AGRICULTURE PRODUCTION AND MANAGEMENTAgriculture & Natural Resources95326768656424022660.028636059540003600080000
1102AGRICULTURAL ECONOMICSAgriculture & Natural Resources3395526321228108210.030248324630004000098000
1103ANIMAL SCIENCESAgriculture & Natural Resources103549811776493736190.0426789460003000072000
1104FOOD SCIENCEAgriculture & Natural Resources2428017281127228940.049188446620003850090000
1105PLANT SCIENCE AND AGRONOMYAgriculture & Natural Resources79409630435107720700.031790887500003500075000
1106SOIL SCIENCEAgriculture & Natural Resources6586492640422640.050867052630003940088000
1199MISCELLANEOUS AGRICULTUREAgriculture & Natural Resources8549639250742610.039230422520003500075000
1301ENVIRONMENTAL SCIENCEBiology & Life Science106106876026523847360.051289827520003800075000
1302FORESTRYAgriculture & Natural Resources69447482283961321440.042563329580004050080000

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

Share link

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