STORY 1
##collect resources
library(readxl)
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.4.4 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(dplyr)
library(hrbrthemes)
## NOTE: Either Arial Narrow or Roboto Condensed fonts are required to use these themes.
## Please use hrbrthemes::import_roboto_condensed() to install Roboto Condensed and
## if Arial Narrow is not on your system, please see https://bit.ly/arialnarrow
library(knitr)
p <- read_excel("IIJA FUNDING AS OF MARCH 2023(1) copy.xlsx")
es <- read_csv("NST-EST2022-ALLDATA (1).csv")
## Rows: 66 Columns: 45
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (5): SUMLEV, REGION, DIVISION, STATE, NAME
## dbl (40): ESTIMATESBASE2020, POPESTIMATE2020, POPESTIMATE2021, POPESTIMATE20...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
votes <- read_csv("votes.csv")
## New names:
## Rows: 52 Columns: 7
## ── Column specification
## ──────────────────────────────────────────────────────── Delimiter: "," chr
## (7): STATE, ELECTORAL VOTE...2, ELECTORAL VOTE...3, POPULAR VOTE...4, PO...
## ℹ Use `spec()` to retrieve the full column specification for this data. ℹ
## Specify the column types or set `show_col_types = FALSE` to quiet this message.
## • `ELECTORAL VOTE` -> `ELECTORAL VOTE...2`
## • `ELECTORAL VOTE` -> `ELECTORAL VOTE...3`
## • `POPULAR VOTE` -> `POPULAR VOTE...4`
## • `POPULAR VOTE` -> `POPULAR VOTE...5`
## • `POPULAR VOTE` -> `POPULAR VOTE...6`
## • `POPULAR VOTE` -> `POPULAR VOTE...7`
kable(p)
| ALABAMA |
3.0000 |
| ALASKA |
3.7000 |
| AMERICAN SAMOA |
0.0686 |
| ARIZONA |
3.5000 |
| ARKANSAS |
2.8000 |
| CALIFORNIA |
18.4000 |
| COLORADO |
3.2000 |
| CONNECTICUT |
2.5000 |
| DELEWARE |
0.7920 |
| DISTRICT OF COLUMBIA |
1.1000 |
| FLORIDA |
8.2000 |
| GEORGIA |
5.0000 |
| GUAM |
0.1426 |
| HAWAII |
1.0000 |
| IDAHO |
1.2000 |
| ILLINOIS |
8.4000 |
| INDIANA |
3.4000 |
| IOWA |
2.4000 |
| KANSAS |
1.5000 |
| KENTUCKY |
3.9000 |
| LOUISIANA |
4.3000 |
| MAINE |
1.1000 |
| MARYLAND |
2.7000 |
| MASSACHUSETTS |
3.6000 |
| MICHIGAN |
5.2000 |
| MINNESOTA |
2.7000 |
| MISSISSIPPI |
2.3000 |
| MISSOURI |
3.8000 |
| MONTANA |
3.3000 |
| NEBRASKA |
1.3000 |
| NEVADA |
1.7000 |
| NEW HAMPSHIRE |
0.7518 |
| NEW JERSEY |
5.1000 |
| NEW MEXICO |
2.6000 |
| NEW YORK |
10.1000 |
| NORTH CAROLINA |
4.5000 |
| NORTH DAKOTA |
1.8000 |
| NORTHERN MARIANA ISLANDS |
0.0833 |
| OHIO |
6.6000 |
| OKLAHOMA |
2.9000 |
| OREGON |
2.3000 |
| PENNSYLVANIA |
8.1000 |
| PUERTO RICO |
0.9937 |
| RHODE ISLAND |
1.1000 |
| SOUTH CAROLINA |
2.3000 |
| SOUTH DAKOTA |
1.3000 |
| TENNESSEE |
3.7000 |
| TEXAS |
14.2000 |
| TRIBAL COMMUNITIES |
3.0000 |
| US VIRGIN ISLANDS |
0.1483 |
| UTAH |
1.8000 |
| VERMONT |
0.8521 |
| VIRGINIA |
4.5000 |
| WASHINGTON |
4.0000 |
| WEST VIRGINIA |
2.0000 |
| WISCONSIN |
2.8000 |
| WYOMING |
2.3000 |
kable(es)
| 010 |
0 |
0 |
00 |
United States |
331449520 |
331511512 |
332031554 |
333287557 |
61992 |
520042 |
1256003 |
894123 |
3582436 |
3688179 |
852024 |
3438423 |
3443099 |
42099 |
144013 |
245080 |
19893 |
376029 |
1010923 |
0 |
0 |
0 |
19893 |
376029 |
1010923 |
0 |
0 |
0 |
10.797901 |
11.086947 |
10.363828 |
10.350218 |
0.4340728 |
0.7367292 |
1.1333974 |
3.0389117 |
0.0000000 |
0.0000000 |
1.1333974 |
3.0389117 |
| 020 |
1 |
0 |
00 |
Northeast Region |
57609156 |
57448898 |
57259257 |
57040406 |
-160258 |
-189641 |
-218851 |
146120 |
572782 |
593222 |
192891 |
560931 |
564007 |
-46771 |
11851 |
29215 |
4429 |
80451 |
214464 |
-113328 |
-278474 |
-460736 |
-108899 |
-198023 |
-246272 |
-4588 |
-3469 |
-1794 |
9.986770 |
10.380118 |
9.780142 |
9.868918 |
0.2066287 |
0.5112001 |
1.4027076 |
3.7526620 |
-4.8553479 |
-8.0618960 |
-3.4526403 |
-4.3092341 |
| 030 |
1 |
1 |
00 |
New England |
15116206 |
15074473 |
15121745 |
15129548 |
-41733 |
47272 |
7803 |
35417 |
139206 |
146423 |
46182 |
143894 |
149549 |
-10765 |
-4688 |
-3126 |
1560 |
26735 |
70412 |
-30001 |
23342 |
-56991 |
-28441 |
50077 |
13421 |
-2527 |
1883 |
-2492 |
9.220095 |
9.680446 |
9.530598 |
9.887115 |
-0.3105025 |
-0.2066689 |
1.7707516 |
4.6551399 |
1.5460214 |
-3.7678389 |
3.3167730 |
0.8873009 |
| 030 |
1 |
2 |
00 |
Middle Atlantic |
42492950 |
42374425 |
42137512 |
41910858 |
-118525 |
-236913 |
-226654 |
110703 |
433576 |
446799 |
146709 |
417037 |
414458 |
-36006 |
16539 |
32341 |
2869 |
53716 |
144052 |
-83327 |
-301816 |
-403745 |
-80458 |
-248100 |
-259693 |
-2061 |
-5352 |
698 |
10.260704 |
10.631949 |
9.869304 |
9.862369 |
0.3914003 |
0.7695807 |
1.2712050 |
3.4278357 |
-7.1425650 |
-9.6074439 |
-5.8713599 |
-6.1796082 |
| 020 |
2 |
0 |
00 |
Midwest Region |
68985537 |
68961043 |
68836505 |
68787595 |
-24494 |
-124538 |
-48910 |
190131 |
747700 |
759934 |
186324 |
761965 |
768572 |
3807 |
-14265 |
-8638 |
3070 |
55306 |
145268 |
-39524 |
-182263 |
-174049 |
-36454 |
-126957 |
-28781 |
8153 |
16684 |
-11491 |
10.852153 |
11.043618 |
11.059195 |
11.169148 |
-0.2070429 |
-0.1255303 |
0.8027138 |
2.1110837 |
-2.6453736 |
-2.5293390 |
-1.8426598 |
-0.4182552 |
| 030 |
2 |
3 |
00 |
East North Central |
47368637 |
47338744 |
47181948 |
47097779 |
-29893 |
-156796 |
-84169 |
127378 |
500167 |
508030 |
133459 |
529543 |
535923 |
-6081 |
-29376 |
-27893 |
1991 |
37015 |
98117 |
-31782 |
-175642 |
-146416 |
-29791 |
-138627 |
-48299 |
5979 |
11207 |
-7977 |
10.583228 |
10.777078 |
11.204806 |
11.368786 |
-0.6215782 |
-0.5917073 |
0.7832147 |
2.0814019 |
-3.7164772 |
-3.1059912 |
-2.9332625 |
-1.0245893 |
| 030 |
2 |
4 |
00 |
West North Central |
21616900 |
21622299 |
21654557 |
21689816 |
5399 |
32258 |
35259 |
62753 |
247533 |
251904 |
52865 |
232422 |
232649 |
9888 |
15111 |
19255 |
1079 |
18291 |
47151 |
-7742 |
-6621 |
-27633 |
-6663 |
11670 |
19518 |
2174 |
5477 |
-3514 |
11.439509 |
11.623377 |
10.741168 |
10.734911 |
0.6983409 |
0.8884660 |
0.8453017 |
2.1756457 |
-0.3059834 |
-1.2750444 |
0.5393183 |
0.9006013 |
| 020 |
3 |
0 |
00 |
South Region |
126266262 |
126450613 |
127346029 |
128716192 |
184351 |
895416 |
1370163 |
348206 |
1425940 |
1476296 |
314775 |
1403963 |
1406198 |
33431 |
21977 |
70098 |
8957 |
155222 |
414740 |
147114 |
722926 |
867935 |
156071 |
878148 |
1282675 |
-5151 |
-4709 |
17390 |
11.236871 |
11.530760 |
11.063685 |
10.983252 |
0.1731859 |
0.5475076 |
1.2231998 |
3.2393689 |
5.6968918 |
6.7790945 |
6.9200916 |
10.0184634 |
| 030 |
3 |
5 |
00 |
South Atlantic |
66089861 |
66164801 |
66666348 |
67452940 |
74940 |
501547 |
786592 |
172099 |
699565 |
727568 |
168663 |
727277 |
738452 |
3436 |
-27712 |
-10884 |
6001 |
97735 |
260228 |
72783 |
437217 |
523687 |
78784 |
534952 |
783915 |
-7280 |
-5693 |
13561 |
10.533147 |
10.849566 |
10.950398 |
11.011869 |
-0.4172515 |
-0.1623033 |
1.4715675 |
3.8805455 |
6.5830493 |
7.8092720 |
8.0546168 |
11.6898175 |
| 030 |
3 |
6 |
00 |
East South Central |
19402323 |
19422567 |
19474372 |
19578002 |
20244 |
51805 |
103630 |
54200 |
222808 |
227806 |
56664 |
258082 |
258921 |
-2464 |
-35274 |
-31115 |
517 |
7300 |
18741 |
22052 |
77441 |
114959 |
22569 |
84741 |
133700 |
139 |
2338 |
1045 |
11.456326 |
11.666692 |
13.270042 |
13.260193 |
-1.8137160 |
-1.5935011 |
0.3753509 |
0.9597880 |
3.9818557 |
5.8874270 |
4.3572066 |
6.8472150 |
| 030 |
3 |
7 |
00 |
West South Central |
40774078 |
40863245 |
41205309 |
41685250 |
89167 |
342064 |
479941 |
121907 |
503567 |
520922 |
89448 |
418604 |
408825 |
32459 |
84963 |
112097 |
2439 |
50187 |
135771 |
52279 |
208268 |
229289 |
54718 |
258455 |
365060 |
1990 |
-1354 |
2784 |
12.271862 |
12.568910 |
10.201325 |
9.864211 |
2.0705373 |
2.7046989 |
1.2230507 |
3.2759099 |
5.0754641 |
5.5323309 |
6.2985148 |
8.8082408 |
| 020 |
4 |
0 |
00 |
West Region |
78588565 |
78650958 |
78589763 |
78743364 |
62393 |
-61195 |
153601 |
209666 |
836014 |
858727 |
158034 |
711564 |
704322 |
51632 |
124450 |
154405 |
3437 |
85050 |
236451 |
5738 |
-262189 |
-233150 |
9175 |
-177139 |
3301 |
1586 |
-8506 |
-4105 |
10.633556 |
10.916035 |
9.050633 |
8.953257 |
1.5829233 |
1.9627780 |
1.0817808 |
3.0057370 |
-3.3348740 |
-2.9637751 |
-2.2530932 |
0.0419619 |
| 030 |
4 |
8 |
00 |
Mountain |
24919131 |
24996513 |
25268390 |
25514320 |
77382 |
271877 |
245930 |
68918 |
276639 |
283386 |
54872 |
241602 |
249091 |
14046 |
35037 |
34295 |
1024 |
21406 |
58042 |
63531 |
214914 |
152329 |
64555 |
236320 |
210371 |
-1219 |
520 |
1264 |
11.007243 |
11.160728 |
9.613149 |
9.810071 |
1.3940940 |
1.3506566 |
0.8517275 |
2.2858961 |
8.5512549 |
5.9992466 |
9.4029824 |
8.2851427 |
| 030 |
4 |
9 |
00 |
Pacific |
53669434 |
53654445 |
53321373 |
53229044 |
-14989 |
-333072 |
-92329 |
140748 |
559375 |
575341 |
103162 |
469962 |
455231 |
37586 |
89413 |
120110 |
2413 |
63644 |
178409 |
-57793 |
-477103 |
-385479 |
-55380 |
-413459 |
-207070 |
2805 |
-9026 |
-5369 |
10.457971 |
10.799413 |
8.786322 |
8.544894 |
1.6716488 |
2.2545196 |
1.1898764 |
3.3488184 |
-8.9198290 |
-7.2356169 |
-7.7299526 |
-3.8867985 |
| 040 |
3 |
6 |
01 |
Alabama |
5024356 |
5031362 |
5049846 |
5074296 |
7006 |
18484 |
24450 |
13867 |
57112 |
58280 |
15165 |
69056 |
66870 |
-1298 |
-11944 |
-8590 |
127 |
1805 |
4597 |
9042 |
27704 |
28609 |
9169 |
29509 |
33206 |
-865 |
919 |
-166 |
11.330388 |
11.513074 |
13.699946 |
13.210008 |
-2.3695573 |
-1.6969339 |
0.3580920 |
0.9081263 |
5.4961667 |
5.6516394 |
5.8542587 |
6.5597658 |
| 040 |
4 |
9 |
02 |
Alaska |
733378 |
732923 |
734182 |
733583 |
-455 |
1259 |
-599 |
2406 |
9461 |
9488 |
1163 |
5364 |
6396 |
1243 |
4097 |
3092 |
58 |
877 |
2371 |
-1716 |
-3570 |
-6126 |
-1658 |
-2693 |
-3755 |
-40 |
-145 |
64 |
12.897509 |
12.928500 |
7.312360 |
8.715292 |
5.5851490 |
4.2132085 |
1.1955518 |
3.2307624 |
-4.8667273 |
-8.3473853 |
-3.6711755 |
-5.1166229 |
| 040 |
4 |
8 |
04 |
Arizona |
7151507 |
7179943 |
7264877 |
7359197 |
28436 |
84934 |
94320 |
18110 |
75384 |
78763 |
18030 |
80430 |
79329 |
80 |
-5046 |
-566 |
251 |
8019 |
22219 |
29567 |
81811 |
70984 |
29818 |
89830 |
93203 |
-1462 |
150 |
1683 |
10.437513 |
10.771691 |
11.136172 |
10.849097 |
-0.6986588 |
-0.0774066 |
1.1102942 |
3.0386881 |
11.3273824 |
9.7078283 |
12.4376766 |
12.7465165 |
| 040 |
3 |
7 |
05 |
Arkansas |
3011555 |
3014195 |
3028122 |
3045637 |
2640 |
13927 |
17515 |
8508 |
35115 |
36251 |
8493 |
40174 |
40187 |
15 |
-5059 |
-3936 |
94 |
1346 |
3314 |
2406 |
17440 |
18209 |
2500 |
18786 |
21523 |
125 |
200 |
-72 |
11.623025 |
11.936924 |
13.297548 |
13.232991 |
-1.6745232 |
-1.2960672 |
0.4455245 |
1.0912517 |
5.7726200 |
5.9959574 |
6.2181445 |
7.0872091 |
| 040 |
4 |
9 |
06 |
California |
39538245 |
39501653 |
39142991 |
39029342 |
-36592 |
-358662 |
-113649 |
103123 |
412194 |
424652 |
74463 |
345550 |
318497 |
28660 |
66644 |
106155 |
1387 |
44121 |
125715 |
-68946 |
-458951 |
-343230 |
-67559 |
-414830 |
-217515 |
2307 |
-10476 |
-2289 |
10.482443 |
10.864509 |
8.787630 |
8.148586 |
1.6948134 |
2.7159225 |
1.1220345 |
3.2163553 |
-11.6715132 |
-8.7813677 |
-10.5494787 |
-5.5650124 |
| 040 |
4 |
8 |
08 |
Colorado |
5773733 |
5784865 |
5811297 |
5839926 |
11132 |
26432 |
28629 |
15589 |
62064 |
63086 |
11904 |
46644 |
49381 |
3685 |
15420 |
13705 |
242 |
3914 |
10366 |
6918 |
5690 |
5376 |
7160 |
9604 |
15742 |
287 |
1408 |
-818 |
10.704231 |
10.829078 |
8.044731 |
8.476535 |
2.6595006 |
2.3525427 |
0.6750509 |
1.7793840 |
0.9813592 |
0.9228216 |
1.6564101 |
2.7022056 |
| 040 |
1 |
1 |
09 |
Connecticut |
3605942 |
3597362 |
3623355 |
3626205 |
-8580 |
25993 |
2850 |
8465 |
33896 |
35818 |
11915 |
34649 |
34902 |
-3450 |
-753 |
916 |
410 |
6217 |
16296 |
-5548 |
19019 |
-13547 |
-5138 |
25236 |
2749 |
8 |
1510 |
-815 |
9.388541 |
9.881427 |
9.597108 |
9.628722 |
-0.2085665 |
0.2527050 |
1.7219897 |
4.4957211 |
5.2678979 |
-3.7373303 |
6.9898876 |
0.7583909 |
| 040 |
3 |
5 |
10 |
Delaware |
989957 |
992114 |
1004807 |
1018396 |
2157 |
12693 |
13589 |
2579 |
10220 |
10744 |
2950 |
11230 |
11462 |
-371 |
-1010 |
-718 |
64 |
939 |
2451 |
2512 |
12781 |
11826 |
2576 |
13720 |
14277 |
-48 |
-17 |
30 |
10.235758 |
10.620783 |
11.247315 |
11.330549 |
-1.0115573 |
-0.7097657 |
0.9404478 |
2.4228908 |
12.8007067 |
11.6903741 |
13.7411545 |
14.1132650 |
| 040 |
3 |
5 |
11 |
District of Columbia |
689546 |
670868 |
668791 |
671803 |
-18678 |
-2077 |
3012 |
2187 |
8304 |
8096 |
2005 |
5832 |
5556 |
182 |
2472 |
2540 |
50 |
1746 |
4558 |
-15939 |
-6624 |
-3647 |
-15889 |
-4878 |
911 |
-2971 |
329 |
-439 |
12.397185 |
12.078228 |
8.706693 |
8.288863 |
3.6904914 |
3.7893650 |
2.6066335 |
6.7999708 |
-9.8890837 |
-5.4408717 |
-7.2824502 |
1.3590990 |
| 040 |
3 |
5 |
12 |
Florida |
21538226 |
21589602 |
21828069 |
22244823 |
51376 |
238467 |
416754 |
50292 |
207964 |
220578 |
56302 |
250785 |
260794 |
-6010 |
-42821 |
-40216 |
2842 |
46862 |
125629 |
59688 |
243933 |
318855 |
62530 |
290795 |
444484 |
-5144 |
-9507 |
12486 |
9.579694 |
10.009690 |
11.552209 |
11.834667 |
-1.9725148 |
-1.8249767 |
2.1586602 |
5.7009647 |
11.2365769 |
14.4694385 |
13.3952372 |
20.1704032 |
| 040 |
3 |
5 |
13 |
Georgia |
10711937 |
10729828 |
10788029 |
10912876 |
17891 |
58201 |
124847 |
29842 |
121391 |
125538 |
24818 |
109531 |
109357 |
5024 |
11860 |
16181 |
732 |
10160 |
27285 |
11226 |
35457 |
81406 |
11958 |
45617 |
108691 |
909 |
724 |
-25 |
11.282815 |
11.569840 |
10.180475 |
10.078566 |
1.1023403 |
1.4912742 |
0.9443320 |
2.5146417 |
3.2955884 |
7.5025442 |
4.2399204 |
10.0171859 |
| 040 |
4 |
9 |
15 |
Hawaii |
1455273 |
1451043 |
1447154 |
1440196 |
-4230 |
-3889 |
-6958 |
3835 |
15518 |
15788 |
2838 |
12133 |
13328 |
997 |
3385 |
2460 |
120 |
2048 |
5785 |
-4993 |
-9479 |
-15212 |
-4873 |
-7431 |
-9427 |
-354 |
157 |
9 |
10.708727 |
10.935979 |
8.372792 |
9.231995 |
2.3359351 |
1.7039846 |
1.4132925 |
4.0071346 |
-6.5413083 |
-10.5369976 |
-5.1280158 |
-6.5298630 |
| 040 |
4 |
8 |
16 |
Idaho |
1839092 |
1849202 |
1904314 |
1939033 |
10110 |
55112 |
34719 |
5467 |
21872 |
22524 |
3628 |
17084 |
18838 |
1839 |
4788 |
3686 |
58 |
697 |
1844 |
8669 |
51339 |
28639 |
8727 |
52036 |
30483 |
-456 |
-1712 |
550 |
11.654140 |
11.721034 |
9.102932 |
9.802914 |
2.5512080 |
1.9181198 |
0.3713851 |
0.9595803 |
27.3551518 |
14.9031560 |
27.7265369 |
15.8627363 |
| 040 |
2 |
3 |
17 |
Illinois |
12812545 |
12786580 |
12686469 |
12582032 |
-25965 |
-100111 |
-104437 |
33454 |
131658 |
131491 |
35347 |
128282 |
126625 |
-1893 |
3376 |
4866 |
507 |
11436 |
31529 |
-24768 |
-115624 |
-141656 |
-24261 |
-104188 |
-110127 |
189 |
701 |
824 |
10.337043 |
10.407503 |
10.071978 |
10.022360 |
0.2650645 |
0.3851435 |
0.8978902 |
2.4955180 |
-9.0781437 |
-11.2120620 |
-8.1802536 |
-8.7165440 |
| 040 |
2 |
3 |
18 |
Indiana |
6785668 |
6788799 |
6813532 |
6833037 |
3131 |
24733 |
19505 |
19443 |
77543 |
80214 |
19156 |
77603 |
79190 |
287 |
-60 |
1024 |
342 |
6065 |
15490 |
1385 |
16079 |
5230 |
1727 |
22144 |
20720 |
1117 |
2649 |
-2239 |
11.401428 |
11.755922 |
11.410250 |
11.605848 |
-0.0088220 |
0.1500744 |
0.8917589 |
2.2701677 |
2.3641536 |
0.7664930 |
3.2559125 |
3.0366607 |
| 040 |
2 |
4 |
19 |
Iowa |
3190372 |
3190571 |
3197689 |
3200517 |
199 |
7118 |
2828 |
9103 |
36021 |
36928 |
8074 |
35560 |
35369 |
1029 |
461 |
1559 |
199 |
3701 |
9348 |
-1392 |
1807 |
-7292 |
-1193 |
5508 |
2056 |
363 |
1149 |
-787 |
11.277249 |
11.543236 |
11.132922 |
11.055912 |
0.1443273 |
0.4873241 |
1.1586880 |
2.9220691 |
0.5657253 |
-2.2793889 |
1.7244132 |
0.6426802 |
| 040 |
2 |
4 |
20 |
Kansas |
2937847 |
2937919 |
2937922 |
2937150 |
72 |
3 |
-772 |
8510 |
34281 |
34968 |
6990 |
32746 |
32960 |
1520 |
1535 |
2008 |
128 |
2069 |
5484 |
-2008 |
-4975 |
-7409 |
-1880 |
-2906 |
-1925 |
432 |
1374 |
-855 |
11.668457 |
11.903854 |
11.145979 |
11.220288 |
0.5224784 |
0.6835661 |
0.7042396 |
1.8668707 |
-1.6933746 |
-2.5221819 |
-0.9891350 |
-0.6553111 |
| 040 |
3 |
6 |
21 |
Kentucky |
4505893 |
4507445 |
4506589 |
4512310 |
1552 |
-856 |
5721 |
12580 |
51453 |
52496 |
12816 |
58285 |
60854 |
-236 |
-6832 |
-8358 |
119 |
1754 |
4455 |
919 |
2763 |
10420 |
1038 |
4517 |
14875 |
750 |
1459 |
-796 |
11.416198 |
11.641332 |
12.932057 |
13.494774 |
-1.5158585 |
-1.8534413 |
0.3891709 |
0.9879255 |
0.6130441 |
2.3107033 |
1.0022150 |
3.2986288 |
| 040 |
3 |
7 |
22 |
Louisiana |
4657749 |
4651664 |
4627098 |
4590241 |
-6085 |
-24566 |
-36857 |
13555 |
57123 |
57152 |
14831 |
56590 |
55995 |
-1276 |
533 |
1157 |
192 |
3183 |
8106 |
-5318 |
-28288 |
-46672 |
-5126 |
-25105 |
-38566 |
317 |
6 |
552 |
12.312634 |
12.400976 |
12.197748 |
12.149927 |
0.1148860 |
0.2510486 |
0.6860829 |
1.7588590 |
-6.0973651 |
-10.1270009 |
-5.4112822 |
-8.3681418 |
| 040 |
1 |
1 |
23 |
Maine |
1362341 |
1363557 |
1377238 |
1385340 |
1216 |
13681 |
8102 |
2997 |
11580 |
12030 |
3713 |
16100 |
17973 |
-716 |
-4520 |
-5943 |
58 |
1012 |
2525 |
1738 |
17304 |
11600 |
1796 |
18316 |
14125 |
136 |
-115 |
-80 |
8.450103 |
8.709256 |
11.748416 |
13.011759 |
-3.2983131 |
-4.3025030 |
0.7384719 |
1.8280027 |
12.6269933 |
8.3979529 |
13.3654651 |
10.2259556 |
| 040 |
3 |
5 |
24 |
Maryland |
6177213 |
6173205 |
6174610 |
6164660 |
-4008 |
1405 |
-9950 |
17156 |
67441 |
69130 |
16908 |
58911 |
57567 |
248 |
8530 |
11563 |
506 |
9038 |
23756 |
-5489 |
-17697 |
-45101 |
-4983 |
-8659 |
-21345 |
727 |
1534 |
-168 |
10.923552 |
11.204877 |
9.541931 |
9.330698 |
1.3816210 |
1.8741789 |
1.4639027 |
3.8504709 |
-2.8664181 |
-7.3101569 |
-1.4025153 |
-3.4596860 |
| 040 |
1 |
1 |
25 |
Massachusetts |
7029949 |
6995729 |
6989690 |
6981974 |
-34220 |
-6039 |
-7716 |
17112 |
66541 |
70019 |
22124 |
61675 |
63716 |
-5012 |
4866 |
6303 |
907 |
16476 |
43880 |
-26857 |
-26717 |
-57292 |
-25950 |
-10241 |
-13412 |
-3258 |
-664 |
-607 |
9.515768 |
10.023001 |
8.819900 |
9.120746 |
0.6958676 |
0.9022547 |
2.3561682 |
6.2812847 |
-3.8206935 |
-8.2011706 |
-1.4645253 |
-1.9198858 |
| 040 |
2 |
3 |
26 |
Michigan |
10077325 |
10069577 |
10037504 |
10034113 |
-7748 |
-32073 |
-3391 |
26586 |
102739 |
105157 |
31049 |
115020 |
117639 |
-4463 |
-12281 |
-12482 |
409 |
7044 |
18812 |
-5140 |
-29566 |
-8482 |
-4731 |
-22522 |
10330 |
1446 |
2730 |
-1239 |
10.219186 |
10.478179 |
11.440746 |
11.721925 |
-1.2215597 |
-1.2437463 |
0.7006487 |
1.8744877 |
-2.9408545 |
-0.8451736 |
-2.2402058 |
1.0293142 |
| 040 |
2 |
4 |
27 |
Minnesota |
5706504 |
5709852 |
5711471 |
5717184 |
3348 |
1619 |
5713 |
16461 |
63068 |
64821 |
12756 |
51473 |
53204 |
3705 |
11595 |
11617 |
295 |
5523 |
14194 |
-1665 |
-16312 |
-19400 |
-1370 |
-10789 |
-5206 |
1013 |
813 |
-698 |
11.043905 |
11.343592 |
9.013492 |
9.310632 |
2.0304128 |
2.0329601 |
0.9671384 |
2.4839318 |
-2.8564116 |
-3.3949752 |
-1.8892732 |
-0.9110433 |
| 040 |
3 |
6 |
28 |
Mississippi |
2961288 |
2958141 |
2949586 |
2940057 |
-3147 |
-8555 |
-9529 |
8503 |
34972 |
35060 |
9743 |
41379 |
40014 |
-1240 |
-6407 |
-4954 |
62 |
628 |
1593 |
-2216 |
-3476 |
-5716 |
-2154 |
-2848 |
-4123 |
247 |
700 |
-452 |
11.839410 |
11.905645 |
14.008433 |
13.587920 |
-2.1690237 |
-1.6822751 |
0.2126029 |
0.5409496 |
-1.1767639 |
-1.9410345 |
-0.9641610 |
-1.4000849 |
| 040 |
2 |
4 |
29 |
Missouri |
6154920 |
6153998 |
6169823 |
6177957 |
-922 |
15825 |
8134 |
17238 |
68778 |
69255 |
16792 |
75425 |
75249 |
446 |
-6647 |
-5994 |
270 |
3862 |
10058 |
-1607 |
16816 |
5024 |
-1337 |
20678 |
15082 |
-31 |
1794 |
-954 |
11.161798 |
11.217401 |
12.240522 |
12.188264 |
-1.0787239 |
-0.9708628 |
0.6267537 |
1.6291188 |
2.7290237 |
0.8137495 |
3.3557774 |
2.4428683 |
| 040 |
4 |
8 |
30 |
Montana |
1084197 |
1087075 |
1106227 |
1122867 |
2878 |
19152 |
16640 |
2812 |
10806 |
11173 |
2527 |
12115 |
12859 |
285 |
-1309 |
-1686 |
43 |
713 |
1801 |
2668 |
20370 |
16003 |
2711 |
21083 |
17804 |
-118 |
-622 |
522 |
9.853636 |
10.024701 |
11.047270 |
11.537423 |
-1.1936341 |
-1.5127222 |
0.6501613 |
1.6159031 |
18.5747334 |
14.3582998 |
19.2248947 |
15.9742030 |
| 040 |
2 |
4 |
31 |
Nebraska |
1961489 |
1962642 |
1963554 |
1967923 |
1153 |
912 |
4369 |
6046 |
24260 |
24376 |
4472 |
19535 |
19271 |
1574 |
4725 |
5105 |
95 |
1581 |
4018 |
-844 |
-5994 |
-4270 |
-749 |
-4413 |
-252 |
328 |
600 |
-484 |
12.358018 |
12.400429 |
9.951108 |
9.803440 |
2.4069099 |
2.5969884 |
0.8053597 |
2.0440155 |
-3.0533371 |
-2.1722116 |
-2.2479774 |
-0.1281961 |
| 040 |
4 |
8 |
32 |
Nevada |
3104624 |
3115648 |
3146402 |
3177772 |
11024 |
30754 |
31370 |
8166 |
33289 |
33784 |
7016 |
32428 |
33392 |
1150 |
861 |
392 |
134 |
3614 |
10163 |
10089 |
25447 |
20781 |
10223 |
29061 |
30944 |
-349 |
832 |
34 |
10.631982 |
10.684083 |
10.356992 |
10.560114 |
0.2749898 |
0.1239688 |
1.1542546 |
3.2140166 |
8.1273704 |
6.5719254 |
9.2816250 |
9.7859420 |
| 040 |
1 |
1 |
33 |
New Hampshire |
1377518 |
1378587 |
1387505 |
1395231 |
1069 |
8918 |
7726 |
2994 |
12107 |
12670 |
3477 |
13693 |
14700 |
-483 |
-1586 |
-2030 |
88 |
1542 |
3900 |
1223 |
8512 |
6303 |
1311 |
10054 |
10203 |
241 |
450 |
-447 |
8.753867 |
9.106146 |
9.900611 |
10.565142 |
-1.1467442 |
-1.4589958 |
1.1149304 |
2.8029968 |
6.1545314 |
4.5300740 |
7.2694618 |
7.3330708 |
| 040 |
1 |
2 |
34 |
New Jersey |
9289031 |
9271689 |
9267961 |
9261699 |
-17342 |
-3728 |
-6262 |
24719 |
97795 |
102555 |
33957 |
84110 |
82804 |
-9238 |
13685 |
19751 |
901 |
14748 |
39388 |
-9775 |
-33743 |
-64231 |
-8874 |
-18995 |
-24843 |
770 |
1582 |
-1170 |
10.549822 |
11.069280 |
9.073526 |
8.937455 |
1.4762954 |
2.1318254 |
1.5909685 |
4.2513462 |
-3.6400903 |
-6.9327770 |
-2.0491217 |
-2.6814307 |
| 040 |
4 |
8 |
35 |
New Mexico |
2117527 |
2118390 |
2116677 |
2113344 |
863 |
-1713 |
-3333 |
5328 |
21322 |
20955 |
5509 |
24691 |
25250 |
-181 |
-3369 |
-4295 |
159 |
2259 |
5893 |
653 |
-1207 |
-4504 |
812 |
1052 |
1389 |
232 |
604 |
-427 |
10.069262 |
9.907752 |
11.660264 |
11.938475 |
-1.5910020 |
-2.0307228 |
1.0668072 |
2.7862746 |
-0.5700028 |
-2.1295403 |
0.4968044 |
0.6567343 |
| 040 |
1 |
2 |
36 |
New York |
20201230 |
20108296 |
19857492 |
19677151 |
-92934 |
-250804 |
-180341 |
53083 |
205802 |
212145 |
72523 |
177143 |
176534 |
-19440 |
28659 |
35611 |
1343 |
28770 |
77923 |
-69544 |
-295820 |
-299557 |
-68201 |
-267050 |
-221634 |
-5293 |
-12413 |
5682 |
10.298909 |
10.732107 |
8.864732 |
8.930598 |
1.4341767 |
1.8015086 |
1.4397314 |
3.9420111 |
-14.8036616 |
-15.1541523 |
-13.3639302 |
-11.2121412 |
| 040 |
3 |
5 |
37 |
North Carolina |
10439414 |
10449445 |
10565885 |
10698973 |
10031 |
116440 |
133088 |
28675 |
116827 |
122179 |
25879 |
115142 |
115720 |
2796 |
1685 |
6459 |
674 |
9927 |
26430 |
7614 |
104457 |
99796 |
8288 |
114384 |
126226 |
-1053 |
371 |
403 |
11.118265 |
11.491165 |
10.957906 |
10.883684 |
0.1603591 |
0.6074811 |
0.9447389 |
2.4857913 |
9.9410288 |
9.3860020 |
10.8857677 |
11.8717934 |
| 040 |
2 |
4 |
38 |
North Dakota |
779091 |
779518 |
777934 |
779261 |
427 |
-1584 |
1327 |
2563 |
10058 |
10164 |
1758 |
7816 |
7365 |
805 |
2242 |
2799 |
29 |
455 |
1268 |
-482 |
-3994 |
-2710 |
-453 |
-3539 |
-1442 |
75 |
-287 |
-30 |
12.915968 |
13.054242 |
10.036906 |
9.459316 |
2.8790614 |
3.5949255 |
0.5842877 |
1.6285693 |
-5.1288900 |
-3.4806174 |
-4.5446023 |
-1.8520481 |
| 040 |
2 |
3 |
39 |
Ohio |
11799374 |
11797517 |
11764342 |
11756058 |
-1857 |
-33175 |
-8284 |
32341 |
128220 |
129529 |
33744 |
146833 |
149072 |
-1403 |
-18613 |
-19543 |
518 |
9281 |
24112 |
-3120 |
-27630 |
-9165 |
-2602 |
-18349 |
14947 |
2148 |
3787 |
-3688 |
10.883691 |
11.014183 |
12.463618 |
12.675975 |
-1.5799263 |
-1.6617915 |
0.7877986 |
2.0503053 |
-2.3453158 |
-0.7793235 |
-1.5575172 |
1.2709818 |
| 040 |
3 |
7 |
40 |
Oklahoma |
3959346 |
3964912 |
3991225 |
4019800 |
5566 |
26313 |
28575 |
11579 |
47369 |
48107 |
10380 |
50720 |
51390 |
1199 |
-3351 |
-3283 |
177 |
2186 |
5737 |
3721 |
26295 |
26791 |
3898 |
28481 |
32528 |
469 |
1183 |
-670 |
11.907538 |
12.010198 |
12.749906 |
12.829819 |
-0.8423686 |
-0.8196205 |
0.5495129 |
1.4322761 |
6.6099918 |
6.6885324 |
7.1595047 |
8.1208085 |
| 040 |
4 |
9 |
41 |
Oregon |
4237291 |
4244795 |
4256301 |
4240137 |
7504 |
11506 |
-16164 |
10280 |
39736 |
41143 |
9533 |
41956 |
46232 |
747 |
-2220 |
-5089 |
177 |
2609 |
7026 |
6270 |
10285 |
-17331 |
6447 |
12894 |
-10305 |
310 |
832 |
-770 |
9.348442 |
9.684764 |
9.870727 |
10.882678 |
-0.5222856 |
-1.1979138 |
0.6138032 |
1.6538695 |
2.4196880 |
-4.0795919 |
3.0334912 |
-2.4257224 |
| 040 |
1 |
2 |
42 |
Pennsylvania |
13002689 |
12994440 |
13012059 |
12972008 |
-8249 |
17619 |
-40051 |
32901 |
129979 |
132099 |
40229 |
155784 |
155120 |
-7328 |
-25805 |
-23021 |
625 |
10198 |
26741 |
-4008 |
27747 |
-39957 |
-3383 |
37945 |
-13216 |
2462 |
5479 |
-3814 |
9.995886 |
10.167692 |
11.980390 |
11.939624 |
-1.9845039 |
-1.7719320 |
0.7842655 |
2.0582613 |
2.1338512 |
-3.0755001 |
2.9181167 |
-1.0172388 |
| 040 |
1 |
1 |
44 |
Rhode Island |
1097371 |
1096345 |
1096985 |
1093734 |
-1026 |
640 |
-3251 |
2546 |
10013 |
10544 |
3388 |
11348 |
11110 |
-842 |
-1335 |
-566 |
76 |
1073 |
2799 |
-474 |
389 |
-5196 |
-398 |
1462 |
-2397 |
214 |
513 |
-288 |
9.130409 |
9.626063 |
10.347736 |
10.142789 |
-1.2173271 |
-0.5167253 |
0.9784209 |
2.5553254 |
0.3547118 |
-4.7436481 |
1.3331327 |
-2.1883226 |
| 040 |
3 |
5 |
45 |
South Carolina |
5118429 |
5131848 |
5193266 |
5282634 |
13419 |
61418 |
89368 |
13492 |
55591 |
57071 |
14077 |
65128 |
64531 |
-585 |
-9537 |
-7460 |
337 |
4026 |
10654 |
14409 |
67509 |
84030 |
14746 |
71535 |
94684 |
-742 |
-580 |
2144 |
10.768114 |
10.895675 |
12.615454 |
12.319896 |
-1.8473404 |
-1.4242213 |
0.7798461 |
2.0340019 |
13.0766595 |
16.0425357 |
13.8565056 |
18.0765376 |
| 040 |
2 |
4 |
46 |
South Dakota |
886677 |
887799 |
896164 |
909824 |
1122 |
8365 |
13660 |
2832 |
11067 |
11392 |
2023 |
9867 |
9231 |
809 |
1200 |
2161 |
63 |
1100 |
2781 |
256 |
6031 |
8424 |
319 |
7131 |
11205 |
-6 |
34 |
294 |
12.407208 |
12.615809 |
11.061889 |
10.222659 |
1.3453194 |
2.3931499 |
1.2332094 |
3.0797547 |
6.7613510 |
9.3289656 |
7.9945604 |
12.4087203 |
| 040 |
3 |
6 |
47 |
Tennessee |
6910786 |
6925619 |
6968351 |
7051339 |
14833 |
42732 |
82988 |
19250 |
79271 |
81970 |
18940 |
89362 |
91183 |
310 |
-10091 |
-9213 |
209 |
3113 |
8096 |
14307 |
50450 |
81646 |
14516 |
53563 |
89742 |
7 |
-740 |
2459 |
11.410849 |
11.693554 |
12.863422 |
13.007848 |
-1.4525726 |
-1.3142944 |
0.4481081 |
1.1549471 |
7.2621432 |
11.6473331 |
7.7102513 |
12.8022802 |
| 040 |
3 |
7 |
48 |
Texas |
29145428 |
29232474 |
29558864 |
30029572 |
87046 |
326390 |
470708 |
88265 |
363960 |
379412 |
55744 |
271120 |
261253 |
32521 |
92840 |
118159 |
1976 |
43472 |
118614 |
51470 |
192821 |
230961 |
53446 |
236293 |
349575 |
1079 |
-2743 |
2974 |
12.381416 |
12.734417 |
9.223127 |
8.768581 |
3.1582884 |
3.9658366 |
1.4788573 |
3.9811080 |
6.5595037 |
7.7518732 |
8.0383610 |
11.7329812 |
| 040 |
4 |
8 |
49 |
Utah |
3271614 |
3283785 |
3339113 |
3380800 |
12171 |
55328 |
41687 |
11862 |
45745 |
46912 |
4958 |
22016 |
23363 |
6904 |
23729 |
23549 |
118 |
2055 |
5414 |
4548 |
29679 |
12898 |
4666 |
31734 |
18312 |
601 |
-135 |
-174 |
13.814194 |
13.962086 |
6.648449 |
6.953364 |
7.1657453 |
7.0087217 |
0.6205743 |
1.6113304 |
8.9625418 |
3.8387402 |
9.5831160 |
5.4500706 |
| 040 |
1 |
1 |
50 |
Vermont |
643085 |
642893 |
646972 |
647064 |
-192 |
4079 |
92 |
1303 |
5069 |
5342 |
1565 |
6429 |
7148 |
-262 |
-1360 |
-1806 |
21 |
415 |
1012 |
-83 |
4835 |
1141 |
-62 |
5250 |
2153 |
132 |
189 |
-255 |
7.859737 |
8.256339 |
9.968485 |
11.047606 |
-2.1087478 |
-2.7912670 |
0.6434782 |
1.5640987 |
7.4969086 |
1.7634749 |
8.1403868 |
3.3275736 |
| 040 |
3 |
5 |
51 |
Virginia |
8631384 |
8636471 |
8657365 |
8683619 |
5087 |
20894 |
26254 |
23580 |
94523 |
96748 |
19817 |
83281 |
83823 |
3763 |
11242 |
12925 |
760 |
14310 |
37692 |
-358 |
-5465 |
-23952 |
402 |
8845 |
13740 |
922 |
807 |
-411 |
10.931409 |
11.158306 |
9.631293 |
9.667618 |
1.3001164 |
1.4906882 |
1.6549249 |
4.3471582 |
-0.6320171 |
-2.7624730 |
1.0229078 |
1.5846852 |
| 040 |
4 |
9 |
53 |
Washington |
7705247 |
7724031 |
7740745 |
7785786 |
18784 |
16714 |
45041 |
21104 |
82466 |
84270 |
15165 |
64959 |
70778 |
5939 |
17507 |
13492 |
671 |
13989 |
37512 |
11592 |
-15388 |
-3580 |
12263 |
-1399 |
33932 |
582 |
606 |
-2383 |
10.665011 |
10.854968 |
8.400898 |
9.117040 |
2.2641130 |
1.7379285 |
1.8091436 |
4.8319873 |
-1.9900709 |
-0.4611461 |
-0.1809273 |
4.3708411 |
| 040 |
3 |
5 |
54 |
West Virginia |
1793755 |
1791420 |
1785526 |
1775156 |
-2335 |
-5894 |
-10370 |
4296 |
17304 |
17484 |
5907 |
27437 |
29642 |
-1611 |
-10133 |
-12158 |
36 |
727 |
1773 |
-880 |
2866 |
474 |
-844 |
3593 |
2247 |
120 |
646 |
-459 |
9.675293 |
9.820590 |
15.341020 |
16.649619 |
-5.6657271 |
-6.8290288 |
0.4064920 |
0.9958766 |
1.6024844 |
0.2662411 |
2.0089764 |
1.2621178 |
| 040 |
2 |
3 |
55 |
Wisconsin |
5893725 |
5896271 |
5880101 |
5892539 |
2546 |
-16170 |
12438 |
15554 |
60007 |
61639 |
14163 |
61805 |
63397 |
1391 |
-1798 |
-1758 |
215 |
3189 |
8174 |
-139 |
-18901 |
7657 |
76 |
-15712 |
15831 |
1079 |
1340 |
-1635 |
10.191084 |
10.471568 |
10.496441 |
10.770227 |
-0.3053572 |
-0.2986586 |
0.5415929 |
1.3886435 |
-3.2099869 |
1.3008127 |
-2.6683940 |
2.6894562 |
| 040 |
4 |
8 |
56 |
Wyoming |
576837 |
577605 |
579483 |
581381 |
768 |
1878 |
1898 |
1584 |
6157 |
6189 |
1300 |
6194 |
6679 |
284 |
-37 |
-490 |
19 |
135 |
342 |
419 |
1785 |
2152 |
438 |
1920 |
2494 |
46 |
-5 |
-106 |
10.642233 |
10.662748 |
10.706187 |
11.506947 |
-0.0639536 |
-0.8441988 |
0.2333444 |
0.5892163 |
3.0853315 |
3.7075833 |
3.3186758 |
4.2967996 |
| 040 |
X |
X |
72 |
Puerto Rico |
3285874 |
3281557 |
3262693 |
3221789 |
-4317 |
-18864 |
-40904 |
4545 |
18794 |
19645 |
7301 |
33341 |
34102 |
-2756 |
-14547 |
-14457 |
-1561 |
-4317 |
-26447 |
0 |
0 |
0 |
-1561 |
-4317 |
-26447 |
0 |
0 |
0 |
5.743668 |
6.059081 |
10.189403 |
10.518034 |
-4.4457348 |
-4.4589529 |
-1.3193261 |
-8.1570124 |
0.0000000 |
0.0000000 |
-1.3193261 |
-8.1570124 |
kable(votes)
| NA |
Biden (D) |
Trunp (R) |
Biden (D) |
Trunp (R) |
All Others |
Total Vote |
| ALABAMA |
NA |
9 |
849,624 |
1,441,170 |
32,488 |
2,323,282 |
| ALASKA |
NA |
3 |
153,778 |
189,951 |
15,801 |
359,530 |
| ARIZONA |
11 |
NA |
1,672,143 |
1,661,686 |
53,497 |
3,387,326 |
| ARKANSAS |
NA |
6 |
423,932 |
760,647 |
34,490 |
1,219,069 |
| CALIFORNIA |
55 |
NA |
11,110,639 |
6,006,518 |
384,223 |
17,501,380 |
| COLORADO |
9 |
NA |
1,804,352 |
1,364,607 |
88,021 |
3,256,980 |
| CONNECTICUT |
7 |
NA |
1,080,831 |
714,717 |
28,309 |
1,823,857 |
| DELAWARE |
3 |
NA |
296,268 |
200,603 |
7,475 |
504,346 |
| DISTRIC OF COLOMBIA |
3 |
NA |
317,323 |
18,586 |
8,447 |
344,356 |
| FLORIDA |
NA |
29 |
5,297,045 |
5,668,731 |
101,680 |
11,067,456 |
| GEORGIA |
16 |
NA |
2,473,633 |
2,461,854 |
64,473 |
4,999,960 |
| HAWAII |
4 |
NA |
366,130 |
196,864 |
11,475 |
574,469 |
| IDAHO |
NA |
4 |
287,021 |
554,119 |
26,794 |
867,934 |
| ILLINOIS |
20 |
NA |
3,471,915 |
2,446,891 |
114,938 |
6,033,744 |
| INDIANA |
NA |
11 |
1,242,498 |
1,729,857 |
60,855 |
3,033,210 |
| IOWA |
NA |
6 |
759,061 |
897,672 |
34,138 |
1,690,871 |
| KANSAS |
NA |
6 |
570,323 |
771,406 |
32,257 |
1,373,986 |
| KENTUCKY |
NA |
8 |
772,474 |
1,326,646 |
37,648 |
2,136,768 |
| LOUISANA |
NA |
8 |
856,034 |
1,255,776 |
36,252 |
2,148,062 |
| MAINE |
3 |
1 |
435,072 |
360,737 |
23,652 |
819,461 |
| MARYLAND |
10 |
NA |
1,985,023 |
976,414 |
75,593 |
3,037,030 |
| MASSACHUSETTS |
11 |
NA |
2,382,202 |
1,167,202 |
81,998 |
3,631,402 |
| MICHIGAN |
16 |
NA |
2,804,040 |
2,649,852 |
85,410 |
5,539,302 |
| MINNESOTA |
10 |
NA |
1,717,077 |
1,484,065 |
76,029 |
3,277,171 |
| MISSISSIPPI |
NA |
6 |
539,398 |
756,764 |
17,597 |
1,313,759 |
| MONTANA |
NA |
10 |
1,253,014 |
1,718,736 |
54,212 |
3,025,962 |
| MONTANA |
NA |
3 |
244,786 |
343,602 |
15,286 |
603,674 |
| NEBRASKA |
1 |
4 |
374,583 |
556,846 |
24,954 |
956,383 |
| NEVADA |
6 |
NA |
703,486 |
669,890 |
32,000 |
1,405,376 |
| NEW HAMPSHIRE |
4 |
NA |
424,937 |
365,660 |
15,608 |
806,205 |
| NEW JERSEY |
14 |
NA |
2,608,400 |
1,883,313 |
57,744 |
4,549,457 |
| NEW MEXICO |
5 |
NA |
501,614 |
401,894 |
20,457 |
923,965 |
| NEW YORK |
29 |
NA |
5,244,886 |
3,251,997 |
119,978 |
8,616,861 |
| NORTH CAROLINA |
NA |
15 |
2,684,292 |
2,758,775 |
81,737 |
5,524,804 |
| NORTH DAKOTA |
NA |
3 |
115,042 |
235,751 |
11,231 |
362,024 |
| OHIO |
NA |
18 |
2,679,165 |
3,154,834 |
88,203 |
5,922,202 |
| OKLAHOMA |
NA |
7 |
503,890 |
1,020,280 |
36,529 |
1,560,699 |
| OREGON |
7 |
NA |
1,340,383 |
958,448 |
75,490 |
2,374,321 |
| PENNSYLVANIA |
20 |
NA |
3,458,229 |
3,377,674 |
101,073 |
6,936,976 |
| RHODE ISLAND |
4 |
NA |
307,486 |
199,922 |
10,349 |
517,757 |
| SOUTH CAROLINA |
NA |
9 |
1,091,541 |
1,385,103 |
36,685 |
2,513,329 |
| SOUTH DAKOTA |
NA |
3 |
150,471 |
261,043 |
11,095 |
422,609 |
| TENNESSEE |
NA |
11 |
1,143,711 |
1,852,475 |
57,665 |
3,053,851 |
| TEXAS |
NA |
38 |
5,259,126 |
5,890,347 |
165,583 |
11,315,056 |
| UTAH |
NA |
6 |
560,282 |
865,140 |
62,867 |
1,488,289 |
| VERMONT |
3 |
NA |
242,820 |
112,704 |
11,904 |
367,428 |
| VIRGINIA |
13 |
NA |
2,413,568 |
1,962,430 |
84,526 |
4,460,524 |
| WASHINGTON |
12 |
NA |
2,369,612 |
1,584,651 |
133,368 |
4,087,631 |
| WEST VIRGINIA |
NA |
5 |
235,984 |
545,382 |
13,365 |
794,731 |
| WISCONSIN |
10 |
NA |
1,630,866 |
1,610,184 |
56,991 |
3,298,041 |
| WYOMING |
NA |
3 |
73,491 |
193,559 |
9,715 |
276,765 |
Modify Tables and Joins
#Capitalize states
es <- es |> mutate(NAME = toupper(NAME))
#convert dataset column STATE to doulble
es <- transform(es, STATE = as.double(STATE))
#get a subset of only states
es <- es |> filter(STATE > 0)
#clean names
es <- es |> janitor::clean_names()
p <- p |> janitor::clean_names()
#join tables
joint <- inner_join(p, es, by=c("state_teritory_or_tribal_nation" = "name"))
#convert the estimate of 2020 in a double
joint <- transform(joint, popestimate2020 = as.double(popestimate2020) )
#amount spend divided by population
joint <- joint |> mutate(pop_spent = round(total_billions/(popestimate2020 * 0.000001),3))
#arrange in descendent order
joint <- joint |> arrange(desc(pop_spent))
#joint voest with graphas
joint1 <- merge(joint, votes, by.x= "state_teritory_or_tribal_nation", by.y= "STATE", all = TRUE)
#eliminate na
joint1 <- joint1 |> drop_na(state)
#clean names
joint1 <- joint1 |> janitor::clean_names()
#append column to show where biden won
joint1 <- joint1 |> mutate(won = if_else(is.na(electoral_vote_2), "Lost or no electorial college", "Won"))
#eliminate duplicate
joint1 <- joint1 |> distinct(state_teritory_or_tribal_nation, .keep_all = TRUE)
kable(joint1)
| ALABAMA |
3.0000 |
040 |
3 |
6 |
1 |
5024356 |
5031362 |
5049846 |
5074296 |
7006 |
18484 |
24450 |
13867 |
57112 |
58280 |
15165 |
69056 |
66870 |
-1298 |
-11944 |
-8590 |
127 |
1805 |
4597 |
9042 |
27704 |
28609 |
9169 |
29509 |
33206 |
-865 |
919 |
-166 |
11.330388 |
11.513074 |
13.699946 |
13.210008 |
-2.3695573 |
-1.6969339 |
0.3580920 |
0.9081263 |
5.4961667 |
5.6516394 |
5.8542587 |
6.5597658 |
0.596 |
NA |
9 |
849,624 |
1,441,170 |
32,488 |
2,323,282 |
Lost or no electorial college |
| ALASKA |
3.7000 |
040 |
4 |
9 |
2 |
733378 |
732923 |
734182 |
733583 |
-455 |
1259 |
-599 |
2406 |
9461 |
9488 |
1163 |
5364 |
6396 |
1243 |
4097 |
3092 |
58 |
877 |
2371 |
-1716 |
-3570 |
-6126 |
-1658 |
-2693 |
-3755 |
-40 |
-145 |
64 |
12.897509 |
12.928500 |
7.312360 |
8.715292 |
5.5851490 |
4.2132085 |
1.1955518 |
3.2307624 |
-4.8667273 |
-8.3473853 |
-3.6711755 |
-5.1166229 |
5.048 |
NA |
3 |
153,778 |
189,951 |
15,801 |
359,530 |
Lost or no electorial college |
| ARIZONA |
3.5000 |
040 |
4 |
8 |
4 |
7151507 |
7179943 |
7264877 |
7359197 |
28436 |
84934 |
94320 |
18110 |
75384 |
78763 |
18030 |
80430 |
79329 |
80 |
-5046 |
-566 |
251 |
8019 |
22219 |
29567 |
81811 |
70984 |
29818 |
89830 |
93203 |
-1462 |
150 |
1683 |
10.437513 |
10.771691 |
11.136172 |
10.849097 |
-0.6986588 |
-0.0774066 |
1.1102942 |
3.0386881 |
11.3273824 |
9.7078283 |
12.4376766 |
12.7465165 |
0.487 |
11 |
NA |
1,672,143 |
1,661,686 |
53,497 |
3,387,326 |
Won |
| ARKANSAS |
2.8000 |
040 |
3 |
7 |
5 |
3011555 |
3014195 |
3028122 |
3045637 |
2640 |
13927 |
17515 |
8508 |
35115 |
36251 |
8493 |
40174 |
40187 |
15 |
-5059 |
-3936 |
94 |
1346 |
3314 |
2406 |
17440 |
18209 |
2500 |
18786 |
21523 |
125 |
200 |
-72 |
11.623025 |
11.936924 |
13.297548 |
13.232991 |
-1.6745232 |
-1.2960672 |
0.4455245 |
1.0912517 |
5.7726200 |
5.9959574 |
6.2181445 |
7.0872091 |
0.929 |
NA |
6 |
423,932 |
760,647 |
34,490 |
1,219,069 |
Lost or no electorial college |
| CALIFORNIA |
18.4000 |
040 |
4 |
9 |
6 |
39538245 |
39501653 |
39142991 |
39029342 |
-36592 |
-358662 |
-113649 |
103123 |
412194 |
424652 |
74463 |
345550 |
318497 |
28660 |
66644 |
106155 |
1387 |
44121 |
125715 |
-68946 |
-458951 |
-343230 |
-67559 |
-414830 |
-217515 |
2307 |
-10476 |
-2289 |
10.482443 |
10.864509 |
8.787630 |
8.148586 |
1.6948134 |
2.7159225 |
1.1220345 |
3.2163553 |
-11.6715132 |
-8.7813677 |
-10.5494787 |
-5.5650124 |
0.466 |
55 |
NA |
11,110,639 |
6,006,518 |
384,223 |
17,501,380 |
Won |
| COLORADO |
3.2000 |
040 |
4 |
8 |
8 |
5773733 |
5784865 |
5811297 |
5839926 |
11132 |
26432 |
28629 |
15589 |
62064 |
63086 |
11904 |
46644 |
49381 |
3685 |
15420 |
13705 |
242 |
3914 |
10366 |
6918 |
5690 |
5376 |
7160 |
9604 |
15742 |
287 |
1408 |
-818 |
10.704231 |
10.829078 |
8.044731 |
8.476535 |
2.6595006 |
2.3525427 |
0.6750509 |
1.7793840 |
0.9813592 |
0.9228216 |
1.6564101 |
2.7022056 |
0.553 |
9 |
NA |
1,804,352 |
1,364,607 |
88,021 |
3,256,980 |
Won |
| CONNECTICUT |
2.5000 |
040 |
1 |
1 |
9 |
3605942 |
3597362 |
3623355 |
3626205 |
-8580 |
25993 |
2850 |
8465 |
33896 |
35818 |
11915 |
34649 |
34902 |
-3450 |
-753 |
916 |
410 |
6217 |
16296 |
-5548 |
19019 |
-13547 |
-5138 |
25236 |
2749 |
8 |
1510 |
-815 |
9.388541 |
9.881427 |
9.597108 |
9.628722 |
-0.2085665 |
0.2527050 |
1.7219897 |
4.4957211 |
5.2678979 |
-3.7373303 |
6.9898876 |
0.7583909 |
0.695 |
7 |
NA |
1,080,831 |
714,717 |
28,309 |
1,823,857 |
Won |
| DISTRICT OF COLUMBIA |
1.1000 |
040 |
3 |
5 |
11 |
689546 |
670868 |
668791 |
671803 |
-18678 |
-2077 |
3012 |
2187 |
8304 |
8096 |
2005 |
5832 |
5556 |
182 |
2472 |
2540 |
50 |
1746 |
4558 |
-15939 |
-6624 |
-3647 |
-15889 |
-4878 |
911 |
-2971 |
329 |
-439 |
12.397185 |
12.078228 |
8.706693 |
8.288863 |
3.6904914 |
3.7893650 |
2.6066335 |
6.7999708 |
-9.8890837 |
-5.4408717 |
-7.2824502 |
1.3590990 |
1.640 |
NA |
NA |
NA |
NA |
NA |
NA |
Lost or no electorial college |
| FLORIDA |
8.2000 |
040 |
3 |
5 |
12 |
21538226 |
21589602 |
21828069 |
22244823 |
51376 |
238467 |
416754 |
50292 |
207964 |
220578 |
56302 |
250785 |
260794 |
-6010 |
-42821 |
-40216 |
2842 |
46862 |
125629 |
59688 |
243933 |
318855 |
62530 |
290795 |
444484 |
-5144 |
-9507 |
12486 |
9.579694 |
10.009690 |
11.552209 |
11.834667 |
-1.9725148 |
-1.8249767 |
2.1586602 |
5.7009647 |
11.2365769 |
14.4694385 |
13.3952372 |
20.1704032 |
0.380 |
NA |
29 |
5,297,045 |
5,668,731 |
101,680 |
11,067,456 |
Lost or no electorial college |
| GEORGIA |
5.0000 |
040 |
3 |
5 |
13 |
10711937 |
10729828 |
10788029 |
10912876 |
17891 |
58201 |
124847 |
29842 |
121391 |
125538 |
24818 |
109531 |
109357 |
5024 |
11860 |
16181 |
732 |
10160 |
27285 |
11226 |
35457 |
81406 |
11958 |
45617 |
108691 |
909 |
724 |
-25 |
11.282815 |
11.569840 |
10.180475 |
10.078566 |
1.1023403 |
1.4912742 |
0.9443320 |
2.5146417 |
3.2955884 |
7.5025442 |
4.2399204 |
10.0171859 |
0.466 |
16 |
NA |
2,473,633 |
2,461,854 |
64,473 |
4,999,960 |
Won |
| HAWAII |
1.0000 |
040 |
4 |
9 |
15 |
1455273 |
1451043 |
1447154 |
1440196 |
-4230 |
-3889 |
-6958 |
3835 |
15518 |
15788 |
2838 |
12133 |
13328 |
997 |
3385 |
2460 |
120 |
2048 |
5785 |
-4993 |
-9479 |
-15212 |
-4873 |
-7431 |
-9427 |
-354 |
157 |
9 |
10.708727 |
10.935979 |
8.372792 |
9.231995 |
2.3359351 |
1.7039846 |
1.4132925 |
4.0071346 |
-6.5413083 |
-10.5369976 |
-5.1280158 |
-6.5298630 |
0.689 |
4 |
NA |
366,130 |
196,864 |
11,475 |
574,469 |
Won |
| IDAHO |
1.2000 |
040 |
4 |
8 |
16 |
1839092 |
1849202 |
1904314 |
1939033 |
10110 |
55112 |
34719 |
5467 |
21872 |
22524 |
3628 |
17084 |
18838 |
1839 |
4788 |
3686 |
58 |
697 |
1844 |
8669 |
51339 |
28639 |
8727 |
52036 |
30483 |
-456 |
-1712 |
550 |
11.654140 |
11.721034 |
9.102932 |
9.802914 |
2.5512080 |
1.9181198 |
0.3713851 |
0.9595803 |
27.3551518 |
14.9031560 |
27.7265369 |
15.8627363 |
0.649 |
NA |
4 |
287,021 |
554,119 |
26,794 |
867,934 |
Lost or no electorial college |
| ILLINOIS |
8.4000 |
040 |
2 |
3 |
17 |
12812545 |
12786580 |
12686469 |
12582032 |
-25965 |
-100111 |
-104437 |
33454 |
131658 |
131491 |
35347 |
128282 |
126625 |
-1893 |
3376 |
4866 |
507 |
11436 |
31529 |
-24768 |
-115624 |
-141656 |
-24261 |
-104188 |
-110127 |
189 |
701 |
824 |
10.337043 |
10.407503 |
10.071978 |
10.022360 |
0.2650645 |
0.3851435 |
0.8978902 |
2.4955180 |
-9.0781437 |
-11.2120620 |
-8.1802536 |
-8.7165440 |
0.657 |
20 |
NA |
3,471,915 |
2,446,891 |
114,938 |
6,033,744 |
Won |
| INDIANA |
3.4000 |
040 |
2 |
3 |
18 |
6785668 |
6788799 |
6813532 |
6833037 |
3131 |
24733 |
19505 |
19443 |
77543 |
80214 |
19156 |
77603 |
79190 |
287 |
-60 |
1024 |
342 |
6065 |
15490 |
1385 |
16079 |
5230 |
1727 |
22144 |
20720 |
1117 |
2649 |
-2239 |
11.401428 |
11.755922 |
11.410250 |
11.605848 |
-0.0088220 |
0.1500744 |
0.8917589 |
2.2701677 |
2.3641536 |
0.7664930 |
3.2559125 |
3.0366607 |
0.501 |
NA |
11 |
1,242,498 |
1,729,857 |
60,855 |
3,033,210 |
Lost or no electorial college |
| IOWA |
2.4000 |
040 |
2 |
4 |
19 |
3190372 |
3190571 |
3197689 |
3200517 |
199 |
7118 |
2828 |
9103 |
36021 |
36928 |
8074 |
35560 |
35369 |
1029 |
461 |
1559 |
199 |
3701 |
9348 |
-1392 |
1807 |
-7292 |
-1193 |
5508 |
2056 |
363 |
1149 |
-787 |
11.277249 |
11.543236 |
11.132922 |
11.055912 |
0.1443273 |
0.4873241 |
1.1586880 |
2.9220691 |
0.5657253 |
-2.2793889 |
1.7244132 |
0.6426802 |
0.752 |
NA |
6 |
759,061 |
897,672 |
34,138 |
1,690,871 |
Lost or no electorial college |
| KANSAS |
1.5000 |
040 |
2 |
4 |
20 |
2937847 |
2937919 |
2937922 |
2937150 |
72 |
3 |
-772 |
8510 |
34281 |
34968 |
6990 |
32746 |
32960 |
1520 |
1535 |
2008 |
128 |
2069 |
5484 |
-2008 |
-4975 |
-7409 |
-1880 |
-2906 |
-1925 |
432 |
1374 |
-855 |
11.668457 |
11.903854 |
11.145979 |
11.220288 |
0.5224784 |
0.6835661 |
0.7042396 |
1.8668707 |
-1.6933746 |
-2.5221819 |
-0.9891350 |
-0.6553111 |
0.511 |
NA |
6 |
570,323 |
771,406 |
32,257 |
1,373,986 |
Lost or no electorial college |
| KENTUCKY |
3.9000 |
040 |
3 |
6 |
21 |
4505893 |
4507445 |
4506589 |
4512310 |
1552 |
-856 |
5721 |
12580 |
51453 |
52496 |
12816 |
58285 |
60854 |
-236 |
-6832 |
-8358 |
119 |
1754 |
4455 |
919 |
2763 |
10420 |
1038 |
4517 |
14875 |
750 |
1459 |
-796 |
11.416198 |
11.641332 |
12.932057 |
13.494774 |
-1.5158585 |
-1.8534413 |
0.3891709 |
0.9879255 |
0.6130441 |
2.3107033 |
1.0022150 |
3.2986288 |
0.865 |
NA |
8 |
772,474 |
1,326,646 |
37,648 |
2,136,768 |
Lost or no electorial college |
| LOUISIANA |
4.3000 |
040 |
3 |
7 |
22 |
4657749 |
4651664 |
4627098 |
4590241 |
-6085 |
-24566 |
-36857 |
13555 |
57123 |
57152 |
14831 |
56590 |
55995 |
-1276 |
533 |
1157 |
192 |
3183 |
8106 |
-5318 |
-28288 |
-46672 |
-5126 |
-25105 |
-38566 |
317 |
6 |
552 |
12.312634 |
12.400976 |
12.197748 |
12.149927 |
0.1148860 |
0.2510486 |
0.6860829 |
1.7588590 |
-6.0973651 |
-10.1270009 |
-5.4112822 |
-8.3681418 |
0.924 |
NA |
NA |
NA |
NA |
NA |
NA |
Lost or no electorial college |
| MAINE |
1.1000 |
040 |
1 |
1 |
23 |
1362341 |
1363557 |
1377238 |
1385340 |
1216 |
13681 |
8102 |
2997 |
11580 |
12030 |
3713 |
16100 |
17973 |
-716 |
-4520 |
-5943 |
58 |
1012 |
2525 |
1738 |
17304 |
11600 |
1796 |
18316 |
14125 |
136 |
-115 |
-80 |
8.450103 |
8.709256 |
11.748416 |
13.011759 |
-3.2983131 |
-4.3025030 |
0.7384719 |
1.8280027 |
12.6269933 |
8.3979529 |
13.3654651 |
10.2259556 |
0.807 |
3 |
1 |
435,072 |
360,737 |
23,652 |
819,461 |
Won |
| MARYLAND |
2.7000 |
040 |
3 |
5 |
24 |
6177213 |
6173205 |
6174610 |
6164660 |
-4008 |
1405 |
-9950 |
17156 |
67441 |
69130 |
16908 |
58911 |
57567 |
248 |
8530 |
11563 |
506 |
9038 |
23756 |
-5489 |
-17697 |
-45101 |
-4983 |
-8659 |
-21345 |
727 |
1534 |
-168 |
10.923552 |
11.204877 |
9.541931 |
9.330698 |
1.3816210 |
1.8741789 |
1.4639027 |
3.8504709 |
-2.8664181 |
-7.3101569 |
-1.4025153 |
-3.4596860 |
0.437 |
10 |
NA |
1,985,023 |
976,414 |
75,593 |
3,037,030 |
Won |
| MASSACHUSETTS |
3.6000 |
040 |
1 |
1 |
25 |
7029949 |
6995729 |
6989690 |
6981974 |
-34220 |
-6039 |
-7716 |
17112 |
66541 |
70019 |
22124 |
61675 |
63716 |
-5012 |
4866 |
6303 |
907 |
16476 |
43880 |
-26857 |
-26717 |
-57292 |
-25950 |
-10241 |
-13412 |
-3258 |
-664 |
-607 |
9.515768 |
10.023001 |
8.819900 |
9.120746 |
0.6958676 |
0.9022547 |
2.3561682 |
6.2812847 |
-3.8206935 |
-8.2011706 |
-1.4645253 |
-1.9198858 |
0.515 |
11 |
NA |
2,382,202 |
1,167,202 |
81,998 |
3,631,402 |
Won |
| MICHIGAN |
5.2000 |
040 |
2 |
3 |
26 |
10077325 |
10069577 |
10037504 |
10034113 |
-7748 |
-32073 |
-3391 |
26586 |
102739 |
105157 |
31049 |
115020 |
117639 |
-4463 |
-12281 |
-12482 |
409 |
7044 |
18812 |
-5140 |
-29566 |
-8482 |
-4731 |
-22522 |
10330 |
1446 |
2730 |
-1239 |
10.219186 |
10.478179 |
11.440746 |
11.721925 |
-1.2215597 |
-1.2437463 |
0.7006487 |
1.8744877 |
-2.9408545 |
-0.8451736 |
-2.2402058 |
1.0293142 |
0.516 |
16 |
NA |
2,804,040 |
2,649,852 |
85,410 |
5,539,302 |
Won |
| MINNESOTA |
2.7000 |
040 |
2 |
4 |
27 |
5706504 |
5709852 |
5711471 |
5717184 |
3348 |
1619 |
5713 |
16461 |
63068 |
64821 |
12756 |
51473 |
53204 |
3705 |
11595 |
11617 |
295 |
5523 |
14194 |
-1665 |
-16312 |
-19400 |
-1370 |
-10789 |
-5206 |
1013 |
813 |
-698 |
11.043905 |
11.343592 |
9.013492 |
9.310632 |
2.0304128 |
2.0329601 |
0.9671384 |
2.4839318 |
-2.8564116 |
-3.3949752 |
-1.8892732 |
-0.9110433 |
0.473 |
10 |
NA |
1,717,077 |
1,484,065 |
76,029 |
3,277,171 |
Won |
| MISSISSIPPI |
2.3000 |
040 |
3 |
6 |
28 |
2961288 |
2958141 |
2949586 |
2940057 |
-3147 |
-8555 |
-9529 |
8503 |
34972 |
35060 |
9743 |
41379 |
40014 |
-1240 |
-6407 |
-4954 |
62 |
628 |
1593 |
-2216 |
-3476 |
-5716 |
-2154 |
-2848 |
-4123 |
247 |
700 |
-452 |
11.839410 |
11.905645 |
14.008433 |
13.587920 |
-2.1690237 |
-1.6822751 |
0.2126029 |
0.5409496 |
-1.1767639 |
-1.9410345 |
-0.9641610 |
-1.4000849 |
0.778 |
NA |
6 |
539,398 |
756,764 |
17,597 |
1,313,759 |
Lost or no electorial college |
| MISSOURI |
3.8000 |
040 |
2 |
4 |
29 |
6154920 |
6153998 |
6169823 |
6177957 |
-922 |
15825 |
8134 |
17238 |
68778 |
69255 |
16792 |
75425 |
75249 |
446 |
-6647 |
-5994 |
270 |
3862 |
10058 |
-1607 |
16816 |
5024 |
-1337 |
20678 |
15082 |
-31 |
1794 |
-954 |
11.161798 |
11.217401 |
12.240522 |
12.188264 |
-1.0787239 |
-0.9708628 |
0.6267537 |
1.6291188 |
2.7290237 |
0.8137495 |
3.3557774 |
2.4428683 |
0.617 |
NA |
NA |
NA |
NA |
NA |
NA |
Lost or no electorial college |
| MONTANA |
3.3000 |
040 |
4 |
8 |
30 |
1084197 |
1087075 |
1106227 |
1122867 |
2878 |
19152 |
16640 |
2812 |
10806 |
11173 |
2527 |
12115 |
12859 |
285 |
-1309 |
-1686 |
43 |
713 |
1801 |
2668 |
20370 |
16003 |
2711 |
21083 |
17804 |
-118 |
-622 |
522 |
9.853636 |
10.024701 |
11.047270 |
11.537423 |
-1.1936341 |
-1.5127222 |
0.6501613 |
1.6159031 |
18.5747334 |
14.3582998 |
19.2248947 |
15.9742030 |
3.036 |
NA |
3 |
244,786 |
343,602 |
15,286 |
603,674 |
Lost or no electorial college |
| NEBRASKA |
1.3000 |
040 |
2 |
4 |
31 |
1961489 |
1962642 |
1963554 |
1967923 |
1153 |
912 |
4369 |
6046 |
24260 |
24376 |
4472 |
19535 |
19271 |
1574 |
4725 |
5105 |
95 |
1581 |
4018 |
-844 |
-5994 |
-4270 |
-749 |
-4413 |
-252 |
328 |
600 |
-484 |
12.358018 |
12.400429 |
9.951108 |
9.803440 |
2.4069099 |
2.5969884 |
0.8053597 |
2.0440155 |
-3.0533371 |
-2.1722116 |
-2.2479774 |
-0.1281961 |
0.662 |
1 |
4 |
374,583 |
556,846 |
24,954 |
956,383 |
Won |
| NEVADA |
1.7000 |
040 |
4 |
8 |
32 |
3104624 |
3115648 |
3146402 |
3177772 |
11024 |
30754 |
31370 |
8166 |
33289 |
33784 |
7016 |
32428 |
33392 |
1150 |
861 |
392 |
134 |
3614 |
10163 |
10089 |
25447 |
20781 |
10223 |
29061 |
30944 |
-349 |
832 |
34 |
10.631982 |
10.684083 |
10.356992 |
10.560114 |
0.2749898 |
0.1239688 |
1.1542546 |
3.2140166 |
8.1273704 |
6.5719254 |
9.2816250 |
9.7859420 |
0.546 |
6 |
NA |
703,486 |
669,890 |
32,000 |
1,405,376 |
Won |
| NEW HAMPSHIRE |
0.7518 |
040 |
1 |
1 |
33 |
1377518 |
1378587 |
1387505 |
1395231 |
1069 |
8918 |
7726 |
2994 |
12107 |
12670 |
3477 |
13693 |
14700 |
-483 |
-1586 |
-2030 |
88 |
1542 |
3900 |
1223 |
8512 |
6303 |
1311 |
10054 |
10203 |
241 |
450 |
-447 |
8.753867 |
9.106146 |
9.900611 |
10.565142 |
-1.1467442 |
-1.4589958 |
1.1149304 |
2.8029968 |
6.1545314 |
4.5300740 |
7.2694618 |
7.3330708 |
0.545 |
4 |
NA |
424,937 |
365,660 |
15,608 |
806,205 |
Won |
| NEW JERSEY |
5.1000 |
040 |
1 |
2 |
34 |
9289031 |
9271689 |
9267961 |
9261699 |
-17342 |
-3728 |
-6262 |
24719 |
97795 |
102555 |
33957 |
84110 |
82804 |
-9238 |
13685 |
19751 |
901 |
14748 |
39388 |
-9775 |
-33743 |
-64231 |
-8874 |
-18995 |
-24843 |
770 |
1582 |
-1170 |
10.549822 |
11.069280 |
9.073526 |
8.937455 |
1.4762954 |
2.1318254 |
1.5909685 |
4.2513462 |
-3.6400903 |
-6.9327770 |
-2.0491217 |
-2.6814307 |
0.550 |
14 |
NA |
2,608,400 |
1,883,313 |
57,744 |
4,549,457 |
Won |
| NEW MEXICO |
2.6000 |
040 |
4 |
8 |
35 |
2117527 |
2118390 |
2116677 |
2113344 |
863 |
-1713 |
-3333 |
5328 |
21322 |
20955 |
5509 |
24691 |
25250 |
-181 |
-3369 |
-4295 |
159 |
2259 |
5893 |
653 |
-1207 |
-4504 |
812 |
1052 |
1389 |
232 |
604 |
-427 |
10.069262 |
9.907752 |
11.660264 |
11.938475 |
-1.5910020 |
-2.0307228 |
1.0668072 |
2.7862746 |
-0.5700028 |
-2.1295403 |
0.4968044 |
0.6567343 |
1.227 |
5 |
NA |
501,614 |
401,894 |
20,457 |
923,965 |
Won |
| NEW YORK |
10.1000 |
040 |
1 |
2 |
36 |
20201230 |
20108296 |
19857492 |
19677151 |
-92934 |
-250804 |
-180341 |
53083 |
205802 |
212145 |
72523 |
177143 |
176534 |
-19440 |
28659 |
35611 |
1343 |
28770 |
77923 |
-69544 |
-295820 |
-299557 |
-68201 |
-267050 |
-221634 |
-5293 |
-12413 |
5682 |
10.298909 |
10.732107 |
8.864732 |
8.930598 |
1.4341767 |
1.8015086 |
1.4397314 |
3.9420111 |
-14.8036616 |
-15.1541523 |
-13.3639302 |
-11.2121412 |
0.502 |
29 |
NA |
5,244,886 |
3,251,997 |
119,978 |
8,616,861 |
Won |
| NORTH CAROLINA |
4.5000 |
040 |
3 |
5 |
37 |
10439414 |
10449445 |
10565885 |
10698973 |
10031 |
116440 |
133088 |
28675 |
116827 |
122179 |
25879 |
115142 |
115720 |
2796 |
1685 |
6459 |
674 |
9927 |
26430 |
7614 |
104457 |
99796 |
8288 |
114384 |
126226 |
-1053 |
371 |
403 |
11.118265 |
11.491165 |
10.957906 |
10.883684 |
0.1603591 |
0.6074811 |
0.9447389 |
2.4857913 |
9.9410288 |
9.3860020 |
10.8857677 |
11.8717934 |
0.431 |
NA |
15 |
2,684,292 |
2,758,775 |
81,737 |
5,524,804 |
Lost or no electorial college |
| NORTH DAKOTA |
1.8000 |
040 |
2 |
4 |
38 |
779091 |
779518 |
777934 |
779261 |
427 |
-1584 |
1327 |
2563 |
10058 |
10164 |
1758 |
7816 |
7365 |
805 |
2242 |
2799 |
29 |
455 |
1268 |
-482 |
-3994 |
-2710 |
-453 |
-3539 |
-1442 |
75 |
-287 |
-30 |
12.915968 |
13.054242 |
10.036906 |
9.459316 |
2.8790614 |
3.5949255 |
0.5842877 |
1.6285693 |
-5.1288900 |
-3.4806174 |
-4.5446023 |
-1.8520481 |
2.309 |
NA |
3 |
115,042 |
235,751 |
11,231 |
362,024 |
Lost or no electorial college |
| OHIO |
6.6000 |
040 |
2 |
3 |
39 |
11799374 |
11797517 |
11764342 |
11756058 |
-1857 |
-33175 |
-8284 |
32341 |
128220 |
129529 |
33744 |
146833 |
149072 |
-1403 |
-18613 |
-19543 |
518 |
9281 |
24112 |
-3120 |
-27630 |
-9165 |
-2602 |
-18349 |
14947 |
2148 |
3787 |
-3688 |
10.883691 |
11.014183 |
12.463618 |
12.675975 |
-1.5799263 |
-1.6617915 |
0.7877986 |
2.0503053 |
-2.3453158 |
-0.7793235 |
-1.5575172 |
1.2709818 |
0.559 |
NA |
18 |
2,679,165 |
3,154,834 |
88,203 |
5,922,202 |
Lost or no electorial college |
| OKLAHOMA |
2.9000 |
040 |
3 |
7 |
40 |
3959346 |
3964912 |
3991225 |
4019800 |
5566 |
26313 |
28575 |
11579 |
47369 |
48107 |
10380 |
50720 |
51390 |
1199 |
-3351 |
-3283 |
177 |
2186 |
5737 |
3721 |
26295 |
26791 |
3898 |
28481 |
32528 |
469 |
1183 |
-670 |
11.907538 |
12.010198 |
12.749906 |
12.829819 |
-0.8423686 |
-0.8196205 |
0.5495129 |
1.4322761 |
6.6099918 |
6.6885324 |
7.1595047 |
8.1208085 |
0.731 |
NA |
7 |
503,890 |
1,020,280 |
36,529 |
1,560,699 |
Lost or no electorial college |
| OREGON |
2.3000 |
040 |
4 |
9 |
41 |
4237291 |
4244795 |
4256301 |
4240137 |
7504 |
11506 |
-16164 |
10280 |
39736 |
41143 |
9533 |
41956 |
46232 |
747 |
-2220 |
-5089 |
177 |
2609 |
7026 |
6270 |
10285 |
-17331 |
6447 |
12894 |
-10305 |
310 |
832 |
-770 |
9.348442 |
9.684764 |
9.870727 |
10.882678 |
-0.5222856 |
-1.1979138 |
0.6138032 |
1.6538695 |
2.4196880 |
-4.0795919 |
3.0334912 |
-2.4257224 |
0.542 |
7 |
NA |
1,340,383 |
958,448 |
75,490 |
2,374,321 |
Won |
| PENNSYLVANIA |
8.1000 |
040 |
1 |
2 |
42 |
13002689 |
12994440 |
13012059 |
12972008 |
-8249 |
17619 |
-40051 |
32901 |
129979 |
132099 |
40229 |
155784 |
155120 |
-7328 |
-25805 |
-23021 |
625 |
10198 |
26741 |
-4008 |
27747 |
-39957 |
-3383 |
37945 |
-13216 |
2462 |
5479 |
-3814 |
9.995886 |
10.167692 |
11.980390 |
11.939624 |
-1.9845039 |
-1.7719320 |
0.7842655 |
2.0582613 |
2.1338512 |
-3.0755001 |
2.9181167 |
-1.0172388 |
0.623 |
20 |
NA |
3,458,229 |
3,377,674 |
101,073 |
6,936,976 |
Won |
| PUERTO RICO |
0.9937 |
040 |
X |
X |
72 |
3285874 |
3281557 |
3262693 |
3221789 |
-4317 |
-18864 |
-40904 |
4545 |
18794 |
19645 |
7301 |
33341 |
34102 |
-2756 |
-14547 |
-14457 |
-1561 |
-4317 |
-26447 |
0 |
0 |
0 |
-1561 |
-4317 |
-26447 |
0 |
0 |
0 |
5.743668 |
6.059081 |
10.189403 |
10.518034 |
-4.4457348 |
-4.4589529 |
-1.3193261 |
-8.1570124 |
0.0000000 |
0.0000000 |
-1.3193261 |
-8.1570124 |
0.303 |
NA |
NA |
NA |
NA |
NA |
NA |
Lost or no electorial college |
| RHODE ISLAND |
1.1000 |
040 |
1 |
1 |
44 |
1097371 |
1096345 |
1096985 |
1093734 |
-1026 |
640 |
-3251 |
2546 |
10013 |
10544 |
3388 |
11348 |
11110 |
-842 |
-1335 |
-566 |
76 |
1073 |
2799 |
-474 |
389 |
-5196 |
-398 |
1462 |
-2397 |
214 |
513 |
-288 |
9.130409 |
9.626063 |
10.347736 |
10.142789 |
-1.2173271 |
-0.5167253 |
0.9784209 |
2.5553254 |
0.3547118 |
-4.7436481 |
1.3331327 |
-2.1883226 |
1.003 |
4 |
NA |
307,486 |
199,922 |
10,349 |
517,757 |
Won |
| SOUTH CAROLINA |
2.3000 |
040 |
3 |
5 |
45 |
5118429 |
5131848 |
5193266 |
5282634 |
13419 |
61418 |
89368 |
13492 |
55591 |
57071 |
14077 |
65128 |
64531 |
-585 |
-9537 |
-7460 |
337 |
4026 |
10654 |
14409 |
67509 |
84030 |
14746 |
71535 |
94684 |
-742 |
-580 |
2144 |
10.768114 |
10.895675 |
12.615454 |
12.319896 |
-1.8473404 |
-1.4242213 |
0.7798461 |
2.0340019 |
13.0766595 |
16.0425357 |
13.8565056 |
18.0765376 |
0.448 |
NA |
9 |
1,091,541 |
1,385,103 |
36,685 |
2,513,329 |
Lost or no electorial college |
| SOUTH DAKOTA |
1.3000 |
040 |
2 |
4 |
46 |
886677 |
887799 |
896164 |
909824 |
1122 |
8365 |
13660 |
2832 |
11067 |
11392 |
2023 |
9867 |
9231 |
809 |
1200 |
2161 |
63 |
1100 |
2781 |
256 |
6031 |
8424 |
319 |
7131 |
11205 |
-6 |
34 |
294 |
12.407208 |
12.615809 |
11.061889 |
10.222659 |
1.3453194 |
2.3931499 |
1.2332094 |
3.0797547 |
6.7613510 |
9.3289656 |
7.9945604 |
12.4087203 |
1.464 |
NA |
3 |
150,471 |
261,043 |
11,095 |
422,609 |
Lost or no electorial college |
| TENNESSEE |
3.7000 |
040 |
3 |
6 |
47 |
6910786 |
6925619 |
6968351 |
7051339 |
14833 |
42732 |
82988 |
19250 |
79271 |
81970 |
18940 |
89362 |
91183 |
310 |
-10091 |
-9213 |
209 |
3113 |
8096 |
14307 |
50450 |
81646 |
14516 |
53563 |
89742 |
7 |
-740 |
2459 |
11.410849 |
11.693554 |
12.863422 |
13.007848 |
-1.4525726 |
-1.3142944 |
0.4481081 |
1.1549471 |
7.2621432 |
11.6473331 |
7.7102513 |
12.8022802 |
0.534 |
NA |
11 |
1,143,711 |
1,852,475 |
57,665 |
3,053,851 |
Lost or no electorial college |
| TEXAS |
14.2000 |
040 |
3 |
7 |
48 |
29145428 |
29232474 |
29558864 |
30029572 |
87046 |
326390 |
470708 |
88265 |
363960 |
379412 |
55744 |
271120 |
261253 |
32521 |
92840 |
118159 |
1976 |
43472 |
118614 |
51470 |
192821 |
230961 |
53446 |
236293 |
349575 |
1079 |
-2743 |
2974 |
12.381416 |
12.734417 |
9.223127 |
8.768581 |
3.1582884 |
3.9658366 |
1.4788573 |
3.9811080 |
6.5595037 |
7.7518732 |
8.0383610 |
11.7329812 |
0.486 |
NA |
38 |
5,259,126 |
5,890,347 |
165,583 |
11,315,056 |
Lost or no electorial college |
| UTAH |
1.8000 |
040 |
4 |
8 |
49 |
3271614 |
3283785 |
3339113 |
3380800 |
12171 |
55328 |
41687 |
11862 |
45745 |
46912 |
4958 |
22016 |
23363 |
6904 |
23729 |
23549 |
118 |
2055 |
5414 |
4548 |
29679 |
12898 |
4666 |
31734 |
18312 |
601 |
-135 |
-174 |
13.814194 |
13.962086 |
6.648449 |
6.953364 |
7.1657453 |
7.0087217 |
0.6205743 |
1.6113304 |
8.9625418 |
3.8387402 |
9.5831160 |
5.4500706 |
0.548 |
NA |
6 |
560,282 |
865,140 |
62,867 |
1,488,289 |
Lost or no electorial college |
| VERMONT |
0.8521 |
040 |
1 |
1 |
50 |
643085 |
642893 |
646972 |
647064 |
-192 |
4079 |
92 |
1303 |
5069 |
5342 |
1565 |
6429 |
7148 |
-262 |
-1360 |
-1806 |
21 |
415 |
1012 |
-83 |
4835 |
1141 |
-62 |
5250 |
2153 |
132 |
189 |
-255 |
7.859737 |
8.256339 |
9.968485 |
11.047606 |
-2.1087478 |
-2.7912670 |
0.6434782 |
1.5640987 |
7.4969086 |
1.7634749 |
8.1403868 |
3.3275736 |
1.325 |
3 |
NA |
242,820 |
112,704 |
11,904 |
367,428 |
Won |
| VIRGINIA |
4.5000 |
040 |
3 |
5 |
51 |
8631384 |
8636471 |
8657365 |
8683619 |
5087 |
20894 |
26254 |
23580 |
94523 |
96748 |
19817 |
83281 |
83823 |
3763 |
11242 |
12925 |
760 |
14310 |
37692 |
-358 |
-5465 |
-23952 |
402 |
8845 |
13740 |
922 |
807 |
-411 |
10.931409 |
11.158306 |
9.631293 |
9.667618 |
1.3001164 |
1.4906882 |
1.6549249 |
4.3471582 |
-0.6320171 |
-2.7624730 |
1.0229078 |
1.5846852 |
0.521 |
13 |
NA |
2,413,568 |
1,962,430 |
84,526 |
4,460,524 |
Won |
| WASHINGTON |
4.0000 |
040 |
4 |
9 |
53 |
7705247 |
7724031 |
7740745 |
7785786 |
18784 |
16714 |
45041 |
21104 |
82466 |
84270 |
15165 |
64959 |
70778 |
5939 |
17507 |
13492 |
671 |
13989 |
37512 |
11592 |
-15388 |
-3580 |
12263 |
-1399 |
33932 |
582 |
606 |
-2383 |
10.665011 |
10.854968 |
8.400898 |
9.117040 |
2.2641130 |
1.7379285 |
1.8091436 |
4.8319873 |
-1.9900709 |
-0.4611461 |
-0.1809273 |
4.3708411 |
0.518 |
12 |
NA |
2,369,612 |
1,584,651 |
133,368 |
4,087,631 |
Won |
| WEST VIRGINIA |
2.0000 |
040 |
3 |
5 |
54 |
1793755 |
1791420 |
1785526 |
1775156 |
-2335 |
-5894 |
-10370 |
4296 |
17304 |
17484 |
5907 |
27437 |
29642 |
-1611 |
-10133 |
-12158 |
36 |
727 |
1773 |
-880 |
2866 |
474 |
-844 |
3593 |
2247 |
120 |
646 |
-459 |
9.675293 |
9.820590 |
15.341020 |
16.649619 |
-5.6657271 |
-6.8290288 |
0.4064920 |
0.9958766 |
1.6024844 |
0.2662411 |
2.0089764 |
1.2621178 |
1.116 |
NA |
5 |
235,984 |
545,382 |
13,365 |
794,731 |
Lost or no electorial college |
| WISCONSIN |
2.8000 |
040 |
2 |
3 |
55 |
5893725 |
5896271 |
5880101 |
5892539 |
2546 |
-16170 |
12438 |
15554 |
60007 |
61639 |
14163 |
61805 |
63397 |
1391 |
-1798 |
-1758 |
215 |
3189 |
8174 |
-139 |
-18901 |
7657 |
76 |
-15712 |
15831 |
1079 |
1340 |
-1635 |
10.191084 |
10.471568 |
10.496441 |
10.770227 |
-0.3053572 |
-0.2986586 |
0.5415929 |
1.3886435 |
-3.2099869 |
1.3008127 |
-2.6683940 |
2.6894562 |
0.475 |
10 |
NA |
1,630,866 |
1,610,184 |
56,991 |
3,298,041 |
Won |
| WYOMING |
2.3000 |
040 |
4 |
8 |
56 |
576837 |
577605 |
579483 |
581381 |
768 |
1878 |
1898 |
1584 |
6157 |
6189 |
1300 |
6194 |
6679 |
284 |
-37 |
-490 |
19 |
135 |
342 |
419 |
1785 |
2152 |
438 |
1920 |
2494 |
46 |
-5 |
-106 |
10.642233 |
10.662748 |
10.706187 |
11.506947 |
-0.0639536 |
-0.8441988 |
0.2333444 |
0.5892163 |
3.0853315 |
3.7075833 |
3.3186758 |
4.2967996 |
3.982 |
NA |
3 |
73,491 |
193,559 |
9,715 |
276,765 |
Lost or no electorial college |
Graph
#rafactoredgraph
ggplot(joint1, aes(x=reorder(state_teritory_or_tribal_nation, +pop_spent), y = pop_spent, group = 1, fill = won)) + geom_bar(stat="identity", width = 0.8) + coord_flip() + theme_ipsum() + scale_x_discrete(guide = guide_axis(angle = 10)) + geom_text(
aes(label = pop_spent),
colour = "white", size = 2.4,
vjust =0.45,hjust = 1.2, position = position_dodge(0.1)
) + labs(title = "Analyzing Equity and Political Implications", subtitle = "Infrastructure Investment and Jobs Act Funding Allocation By State and Territory", y= "Allocation Of Insfastructure and Job Act Funding Per Person(Thousand)", x = "States", fill = "Biden's Electorial Votes") + theme(axis.title = element_text(family = "Helvetica", size = (20), colour = "steelblue4", face = "bold.italic"), plot.title = element_text(family = "Helvetica", size = (20), colour = "steelblue4", face = "bold.italic"), plot.subtitle = element_text(family = "Helvetica", size = (12), colour = "lightblue3", face = "bold.italic"))
