Skip to content

Instantly share code, notes, and snippets.

@lazarogamio

lazarogamio/clean-energy-jobs.csv

Created March 3, 2017 16:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lazarogamio/e772d64310a686535ba0739af7dee371 to your computer and use it in GitHub Desktop.
Save lazarogamio/e772d64310a686535ba0739af7dee371 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clean-energy-jobs.csv
state j_energy_efficiency j_solar j_wind j_hydro j_natural j_coal j_other_fossil j_other j_sum j_total_energy j_total result_2016 dem_prez_2016 gop_prez_2016 lib_prez_2016 other_prez_2016
Alabama 30203 760 1077 350 1657 1529 204 3468 9045 49320 32040 r 729547 1318255 44467 31103
Alaska 4421 98 37 469 293 88 151 188 1324 21027 4556 r 116454 163387 18725 20042
Arizona 40663 9774 694 151 3649 6060 154 781 21263 42761 51131 r 1161167 1252401 106327 84762
Arkansas 14883 339 825 33 329 311 0 1320 3157 25964 16047 r 380494 684872 29829 35440
California 301348 152947 4635 11890 16960 864 696 15277 203269 427614 458930 d 8753788 4483810 478500 521786
Colorado 29756 8027 7124 1014 486 3812 316 4316 25095 90113 44907 d 1338870 1202484 144121 94772
Connecticut 33948 2927 11 17 742 0 0 1507 5204 18619 36886 d 897572 673215 48676 25457
DC 11982 1581 83 35 114 14 0 134 1961 6145 13646 d 282830 12723 4906 10809
Delaware 12232 486 0 118 257 0 0 0 861 4504 12718 d 235603 185127 14757 8327
Florida 108670 11074 3584 132 12261 3143 195 18819 49208 118879 123328 r 4504975 4617886 207043 173051
Georgia 57443 5261 483 731 1223 944 368 3459 12469 58542 63187 r 1877963 2089104 125306 49072
Hawaii 5117 4883 159 0 0 405 1723 178 7348 16983 10159 d 266891 128847 15954 17245
Idaho 7606 816 829 151 18 0 0 20 1834 13468 9251 r 189765 409055 28331 63282
Illinois 83987 5325 8321 617 3727 2660 518 7266 28434 110819 97633 d 3090729 2146015 209596 148086
Indiana 52578 3866 6250 17 1378 3964 1531 216 17222 57760 62694 r 1033126 1557286 133993 33423
Iowa 18845 745 3859 13 233 2140 27 619 7636 31983 23449 r 653669 800983 59186 52193
Kansas 16339 618 1981 112 4339 3070 2229 3572 15921 48552 18938 r 427005 671018 55406 41326
Kentucky 23681 1722 0 13 482 2261 19 287 4784 46840 25403 r 628854 1202971 53752 38572
Louisiana 19657 3648 132 32 1408 203 461 1290 7174 113217 23437 r 780154 1178638 37978 32262
Maine 8084 770 1234 163 150 2 12 207 2538 8060 10088 d 357735 335593 38105 16494
Maryland 67061 7279 630 3 1369 2415 51 1307 13054 28929 74970 d 1677928 943169 79605 80744
Massachusetts 80373 19635 1652 1738 3720 1573 460 9603 38381 63374 101660 d 1995196 1090893 138018 100939
Michigan 87013 5898 4559 6856 2746 3694 67 3930 27750 85920 97470 r 2268839 2279543 172136 104024
Minnesota 43808 3800 1966 946 412 1722 9 2186 11041 43698 49574 d 1367825 1323232 112984 141192
Mississippi 15039 1266 103 26 1302 141 1 620 3459 26660 16408 r 485131 700714 14435 10808
Missouri 37834 3148 1035 293 361 2856 29 1591 9313 45630 42017 r 1071068 1594511 97359 64735
Montana 8049 225 43 434 17 481 20 4 1224 15043 8317 r 177709 279240 28037 16836
Nebraska 12660 2096 500 179 263 802 0 1403 5243 23663 15256 r 284494 495961 38946 24826
Nevada 9559 11192 1 0 1462 37 0 1084 13776 28892 20752 d 539260 512058 37384 36683
New Hampshire 10869 1594 1120 252 708 0 788 1182 5644 10130 13583 d 348526 345790 30777 19203
New Jersey 31679 9239 500 71 1355 1778 1 7801 20745 59856 41418 d 2148278 1601933 72477 84035
New Mexico 4487 3916 1038 0 92 222 214 142 5624 40206 9441 d 385234 319667 74541 18877
New York 110582 12411 2855 5859 4066 253 711 17871 44026 127137 125848 d 4556124 2819534 176598 169197
North Carolina 80971 9535 594 526 2181 2115 480 3621 19052 51317 91100 r 2189316 2362631 130126 59491
North Dakota 4763 250 1740 0 39 1252 1 13 3295 31615 6753 r 93758 216794 21434 12374
Ohio 78764 8350 819 70 2477 16376 125 1967 30184 99698 87933 r 2394164 2841005 174498 126861
Oklahoma 12294 1016 1798 381 1254 1250 120 0 5819 92282 15108 r 420375 949136 83481 0
Oregon 41869 6892 1190 1577 258 39 7 256 10219 26705 49951 d 1002106 782403 94231 122596
Pennsylvania 62431 4670 2467 182 2083 1270 222 5556 16450 103907 69568 r 2926441 2970733 146715 122821
Rhode Island 10606 1584 1403 84 152 0 1 114 3338 5885 13593 d 252525 180543 14746 16330
South Carolina 29756 3716 1415 10504 2576 3906 9 6869 28995 48379 34887 r 855373 1155389 49204 43061
South Dakota 7202 632 1482 22 121 53 11 0 2321 8314 9316 r 117458 227721 20850 4064
Tennessee 50451 5085 142 5274 212 463 28 81 11285 53051 55678 r 870695 1522925 70397 44010
Texas 146722 11729 24374 1259 4911 3428 445 2649 48795 583404 182825 r 3877868 4685047 283492 122819
Utah 9651 5894 318 337 2147 860 8 87 9651 27985 15863 r 310676 515231 39608 278086
Vermont 10918 2379 328 111 0 0 4 257 3079 6135 13625 d 178573 95369 10078 31047
Virginia 75552 4338 1260 496 1126 916 281 4617 13034 50467 81150 d 1981473 1769443 118274 113562
Washington 61889 5627 3092 2460 257 127 71 2943 14577 54515 70608 d 1742718 1221747 160879 191652
West Virginia 6352 510 460 132 122 2516 53 121 3914 37173 7322 r 188794 489371 23004 20062
Wisconsin 62289 4029 1462 114 717 2692 13 1154 10181 38110 67780 r 1382536 1405284 106674 81656
Wyoming 7200 204 75 11 26 1330 2 0 1648 31398 7479 r 55973 174419 13287 12170
@lazarogamio
Copy link
Author

Jobs data from U.S. department of Energy -> https://energy.gov/sites/prod/files/2017/01/f34/2017%20US%20Energy%20and%20Jobs%20Report%20State%20Charts%202_0.pdf

Election data from Dave Leip's Election Atlas -> http://uselectionatlas.org/RESULTS/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment