Baselight

College Majors And Earnings Dataset

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

@fivethirtyeight.college_majors

Graduate Students Employment And Earnings
@fivethirtyeight.college_majors.grad_students

Column Description
Major_code Major code
Major Name of the major
Major_category Category of the major
Grad_total Total number of graduate students
Grad_sample_size Sample size for graduate students
Grad_employed Number of graduate students employed
Grad_full_time_year_round Graduate students employed full-time year-round
Grad_unemployed Number of unemployed graduate students
Grad_unemployment_rate Unemployment rate among graduate students
Grad_median Median earnings for graduate students
Grad_P25 25th percentile of graduate student earnings
Grad_P75 75th percentile of graduate student earnings
Nongrad_total Total number of non-graduate students
Nongrad_employed Number of non-graduate students employed
Nongrad_full_time_year_round Non-graduates employed full-time year-round
Nongrad_unemployed Number of unemployed non-graduates
Nongrad_unemployment_rate Unemployment rate among non-graduates
Nongrad_median Median earnings for non-graduate students
Nongrad_P25 25th percentile of non-graduate earnings
Nongrad_P75 75th percentile of non-graduate earnings
Grad_share Share of graduates who are graduate degree holders
Grad_premium Earnings premium of graduate degree holders over non-graduates
  • 37.55 KB
  • 173 rows
  • 22 columns
major_code

Major Code

major

Major

major_category

Major Category

grad_total

Grad Total

grad_sample_size

Grad Sample Size

grad_employed

Grad Employed

grad_full_time_year_round

Grad Full Time Year Round

grad_unemployed

Grad Unemployed

grad_unemployment_rate

Grad Unemployment Rate

grad_median

Grad Median

grad_p25

Grad P25

grad_p75

Grad P75

nongrad_total

Nongrad Total

nongrad_employed

Nongrad Employed

nongrad_full_time_year_round

Nongrad Full Time Year Round

nongrad_unemployed

Nongrad Unemployed

nongrad_unemployment_rate

Nongrad Unemployment Rate

nongrad_median

Nongrad Median

nongrad_p25

Nongrad P25

nongrad_p75

Nongrad P75

grad_share

Grad Share

grad_premium

Grad Premium

5601CONSTRUCTION SERVICESIndustrial Arts & Consumer Services9173200709865116810.087543386750005300011000086062736076243539280.0506609926500047000980000.096319630.153846154
6004COMMERCIAL ART AND GRAPHIC DESIGNArts53864882404922955324820.057755852600004000089000461977347166250596254840.0683858854800034000710000.1044197730.25
6211HOSPITALITY MANAGEMENTBusiness24417437183681478414650.073866788650004500010000017933514559711357974090.0484229385000035000750000.119836860.3
2201COSMETOLOGY SERVICES AND CULINARY ARTSIndustrial Arts & Consumer Services541172359027013160.08090117847000245008500037575297382324916610.0528997744160029000600000.1258781930.129807692
2001COMMUNICATION TECHNOLOGIESComputers & Mathematics9109171751256224660.05841062957000406008370053819431633423133890.0728003095200036000780000.1447527330.096153846
3201COURT REPORTINGLaw & Public Policy154222100886075000550001200008921696760635180.0692050775000034000750000.1473764690.5
6206MARKETING AND MARKETING RESEARCHBusiness190996373815157012304583240.05205948980000500001200001029181817906662346455190.0527191136000040000915000.1565313880.333333333
1101AGRICULTURE PRODUCTION AND MANAGEMENTAgriculture & Natural Resources1748838613104112074730.03483833670004160010000089169717816133518690.0253767825500038000800000.1639648590.218181818
2101COMPUTER PROGRAMMING AND DATA PROCESSINGComputers & Mathematics561198471639811190.024612203850005600011400028314220241838122220.0916439836000040000850000.1653942520.416666667
1904ADVERTISING AND PUBLIC RELATIONSCommunications & Journalism3392868828517225238990.03056159960000430009000016343512783210033087060.0637624695100037800780000.1719065880.176470588

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

Share link

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