home / fivethirtyeight

college-majors/all-ages

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

173 rows

View and edit SQL

Link rowid Major_code Major Major_category Total Employed Employed_full_time_year_round Unemployed Unemployment_rate Median P25th P75th
101 4101 PHYSICAL FITNESS PARKS RECREATION AND LEISURE Industrial Arts & Consumer Services 350409 286683 204242 14108 0.046902999 44000 30000 60000
102 4801 PHILOSOPHY AND RELIGIOUS STUDIES Humanities & Liberal Arts 205763 138734 95429 11252 0.075020335 45000 30000 70000
103 4901 THEOLOGY AND RELIGIOUS VOCATIONS Humanities & Liberal Arts 232865 164827 121606 7317 0.042505112000000005 40000 27000 56000
104 5000 PHYSICAL SCIENCES Physical Sciences 8856 5872 4961 238 0.038952537 60000 38000 89000
105 5001 ASTRONOMY AND ASTROPHYSICS Physical Sciences 4700 3400 2447 320 0.086021505 80000 40000 106000
106 5002 ATMOSPHERIC SCIENCES AND METEOROLOGY Physical Sciences 14051 11252 9098 429 0.036726308 60000 39000 90000
107 5003 CHEMISTRY Physical Sciences 308062 198075 153308 11468 0.054728624000000003 59000 38700 90000
108 5004 GEOLOGY AND EARTH SCIENCE Physical Sciences 107902 75698 59262 5272 0.065110535 65000 42000 100000
109 5005 GEOSCIENCES Physical Sciences 8267 6129 5020 274 0.042792440999999994 57000 36000 80000
110 5006 OCEANOGRAPHY Physical Sciences 10741 7882 6508 449 0.053895091 55000 40000 90000
111 5007 PHYSICS Physical Sciences 122620 80797 60812 4440 0.052090055 70000 40000 110000
112 5008 MATERIALS SCIENCE Engineering 7208 5866 4505 134 0.022333332999999997 75000 60000 100000
113 5098 MULTI-DISCIPLINARY OR GENERAL SCIENCE Physical Sciences 427953 308461 238933 14613 0.045231124000000004 56000 38000 85000
114 5102 NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL TECHNOLOGIES Physical Sciences 12166 9560 7238 718 0.069857949 62000 45000 80000
115 5200 PSYCHOLOGY Psychology & Social Work 1484075 1055854 736817 79066 0.069666584 45000 31000 68000
116 5201 EDUCATIONAL PSYCHOLOGY Psychology & Social Work 14041 8751 5763 716 0.07563114 40000 33000 70000
117 5202 CLINICAL PSYCHOLOGY Psychology & Social Work 7638 5128 3297 587 0.102712161 45000 26100 62000
118 5203 COUNSELING PSYCHOLOGY Psychology & Social Work 17633 13071 8888 954 0.06802139 39000 25000 50000
119 5205 INDUSTRIAL AND ORGANIZATIONAL PSYCHOLOGY Psychology & Social Work 17969 11878 8631 1084 0.08362907 62000 40000 84000
120 5206 SOCIAL PSYCHOLOGY Psychology & Social Work 10871 6897 5226 660 0.087336245 47000 35000 70000
121 5299 MISCELLANEOUS PSYCHOLOGY Psychology & Social Work 34102 23921 15688 2137 0.082009364 45000 30000 70000
122 5301 CRIMINAL JUSTICE AND FIRE PROTECTION Law & Public Policy 757141 613369 517599 35037 0.054035589 50000 35000 74000
123 5401 PUBLIC ADMINISTRATION Law & Public Policy 54636 37879 31262 2836 0.069654918 56000 40000 85000
124 5402 PUBLIC POLICY Law & Public Policy 14782 11147 8196 959 0.079216917 60000 38000 90000
125 5403 HUMAN SERVICES AND COMMUNITY ORGANIZATION Psychology & Social Work 81786 61402 44959 4794 0.072421294 38000 29000 52000
126 5404 SOCIAL WORK Psychology & Social Work 319163 225081 164020 14208 0.059375900999999995 40000 30000 53000
127 5500 GENERAL SOCIAL SCIENCES Social Science 127363 80165 57036 6132 0.07105693099999999 50000 35000 75000
128 5501 ECONOMICS Social Science 757616 535446 430580 34974 0.061312717 69000 42000 110000
129 5502 ANTHROPOLOGY AND ARCHEOLOGY Humanities & Liberal Arts 143087 102399 66046 8684 0.078175778 43000 30000 68000
130 5503 CRIMINOLOGY Social Science 75085 59534 48763 4106 0.06451917 49000 35000 72000
131 5504 GEOGRAPHY Social Science 115423 83671 63070 6202 0.06900849 54000 38300 78000
132 5505 INTERNATIONAL RELATIONS Social Science 77371 56564 42091 4278 0.07031327 55000 40000 89000
133 5506 POLITICAL SCIENCE AND GOVERNMENT Social Science 748956 541630 421761 40376 0.069373855 58000 38000 90000
134 5507 SOCIOLOGY Social Science 674558 459174 336515 32344 0.06580430400000001 47000 33000 70000
135 5599 MISCELLANEOUS SOCIAL SCIENCES Social Science 15882 12307 9444 708 0.054398771 52000 40000 80000
136 5601 CONSTRUCTION SERVICES Industrial Arts & Consumer Services 92346 79055 65916 4257 0.051097080999999996 65000 45000 95000
137 5701 ELECTRICAL, MECHANICAL, AND PRECISION TECHNOLOGIES AND PRODUCTION Industrial Arts & Consumer Services 15726 12607 10453 692 0.052033987999999996 48000 32000 75000
138 5901 TRANSPORTATION SCIENCES AND TECHNOLOGIES Industrial Arts & Consumer Services 126639 98814 83519 4902 0.047263682 67000 42500 98000
139 6000 FINE ARTS Arts 571961 386961 256747 29912 0.071753268 45000 30000 70000
140 6001 DRAMA AND THEATER ARTS Arts 174817 135071 81519 11789 0.08027373 42000 29000 62000
141 6002 MUSIC Arts 276262 192704 116142 11155 0.054719193 45000 30000 67000
142 6003 VISUAL AND PERFORMING ARTS Arts 55141 41098 23479 4297 0.09465800199999999 40000 27000 59000
143 6004 COMMERCIAL ART AND GRAPHIC DESIGN Arts 504657 379980 266671 30330 0.07391971900000001 46600 32000 70000
144 6005 FILM VIDEO AND PHOTOGRAPHIC ARTS Arts 133508 107651 69303 10080 0.08561891099999999 47000 30000 70000
145 6006 ART HISTORY AND CRITICISM Humanities & Liberal Arts 90852 61295 38989 4185 0.063912645 44500 30000 70000
146 6007 STUDIO ARTS Arts 81008 58799 36943 5372 0.083713827 37600 24900 58000
147 6099 MISCELLANEOUS FINE ARTS Arts 8511 6431 3802 1190 0.156147487 45000 30000 60000
148 6100 GENERAL MEDICAL AND HEALTH SERVICES Health 104516 78198 53746 4525 0.054700627 50000 35000 73000
149 6102 COMMUNICATION DISORDERS SCIENCES AND SERVICES Health 74977 49393 26085 2407 0.046467180999999996 42000 30000 60000
150 6103 HEALTH AND MEDICAL ADMINISTRATIVE SERVICES Health 108510 85360 67294 5160 0.057003977000000004 50000 35000 75000
151 6104 MEDICAL ASSISTING SERVICES Health 64316 51279 25118 1660 0.031356845 55000 37000 75000
152 6105 MEDICAL TECHNOLOGIES TECHNICIANS Health 164990 121479 92128 4564 0.036209865 60000 45000 76000
153 6106 HEALTH AND MEDICAL PREPARATORY PROGRAMS Health 32514 19009 13147 1431 0.070009785 50000 34000 85000
154 6107 NURSING Health 1769892 1325711 947546 36503 0.026796817999999997 62000 48000 80000
155 6108 PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTRATION Health 180084 124058 89234 4414 0.034357681 106000 78000 125000
156 6109 TREATMENT THERAPY PROFESSIONS Health 252138 199174 128115 5378 0.026291602999999997 61000 40000 80000
157 6110 COMMUNITY AND PUBLIC HEALTH Health 56741 42543 28912 3032 0.06652770200000001 47000 32800 70000
158 6199 MISCELLANEOUS HEALTH MEDICAL PROFESSIONS Health 77647 52610 35676 2978 0.053572714 45000 32000 62000
159 6200 GENERAL BUSINESS Business 2148712 1580978 1304646 85626 0.051377532000000004 60000 40000 95000
160 6201 ACCOUNTING Business 1779219 1335825 1095027 75379 0.053414672999999996 65000 42500 100000
161 6202 ACTUARIAL SCIENCE Business 9763 7846 6880 466 0.056063523 72000 53000 115000
162 6203 BUSINESS MANAGEMENT AND ADMINISTRATION Business 3123510 2354398 1939384 147261 0.058865337000000004 58000 39500 86000
163 6204 OPERATIONS LOGISTICS AND E-COMMERCE Business 57200 47341 41104 2141 0.043268259 65000 45000 90000
164 6205 BUSINESS ECONOMICS Business 75547 57983 48471 3816 0.061748572 65000 45000 100000
165 6206 MARKETING AND MARKETING RESEARCH Business 1114624 890125 704912 51839 0.055032889 56000 38500 90000
166 6207 FINANCE Business 816548 670681 561073 34166 0.048472931 65000 45000 100000
167 6209 HUMAN RESOURCES AND PERSONNEL MANAGEMENT Business 187274 142879 116466 9241 0.060748094 54000 38000 80000
168 6210 INTERNATIONAL BUSINESS Business 86064 66453 51012 5106 0.071353708 54000 38600 80000
169 6211 HOSPITALITY MANAGEMENT Business 200854 163393 122499 8862 0.051446982999999995 49000 33000 70000
170 6212 MANAGEMENT INFORMATION SYSTEMS AND STATISTICS Business 156673 134478 118249 6186 0.043977137 72000 50000 100000
171 6299 MISCELLANEOUS BUSINESS & MEDICAL ADMINISTRATION Business 102753 77471 61603 4308 0.052678561 53000 36000 83000
172 6402 HISTORY Humanities & Liberal Arts 712509 478416 354163 33725 0.06585100599999999 50000 35000 80000
173 6403 UNITED STATES HISTORY Humanities & Liberal Arts 17746 11887 8204 943 0.07349961 50000 39000 81000

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "college-majors/all-ages" (
"Major_code" INTEGER,
  "Major" TEXT,
  "Major_category" TEXT,
  "Total" INTEGER,
  "Employed" INTEGER,
  "Employed_full_time_year_round" INTEGER,
  "Unemployed" INTEGER,
  "Unemployment_rate" REAL,
  "Median" INTEGER,
  "P25th" INTEGER,
  "P75th" INTEGER
)
Powered by Datasette · Query took 10.144ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub