library(tidyverse)Migration
load the libraries
Set the working directory and load the data
setwd("C:/Users/rsaidi/Dropbox/Rachel/MontColl/Datasets/migration")
m23 <- read_csv("State_to_State_Migration_Table_2023_T13.csv") |>
mutate(year = 2023)
m22 <- read_csv("State_to_State_Migration_Table_2022_T13.csv") |>
mutate(year = 2022)
m21 <- read_csv("State_to_State_Migrations_Table_2021.csv") |>
mutate(year = 2021)
m19 <- read_csv("State_to_State_Migrations_Table_2019.csv") |>
mutate(year = 2019)
m18 <- read_csv("State_to_State_Migrations_Table_2018.csv") |>
mutate(year = 2018)
m17 <- read_csv("State_to_State_Migrations_Table_2017.csv") |>
mutate(year = 2017)
m16 <- read_csv("State_to_State_Migrations_Table_2016.csv") |>
mutate(year = 2016)
m15 <- read_csv("State_to_State_Migrations_Table_2015.csv") |>
mutate(year = 2015)
m14 <- read_csv("State_to_State_Migrations_Table_2014.csv") |>
mutate(year = 2014)
m13 <- read_csv("state_to_state_migrations_table_2013.csv") |>
mutate(year = 2013)Top 20 states for migration in 2023
top23 <- m23 |>
arrange(desc(Total)) |>
head(20)
top23# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.55e6 99,663 35,800 193,670 63,179 690,127 211,370 91,384
2 Flori… 6.37e5 13,789 2,280 8,361 4,025 39,052 13,264 15,743
3 Texas 6.12e5 7,781 4,688 19,900 10,833 93,970 25,369 2,645
4 Calif… 4.22e5 2,123 1,210 21,152 2,092 N/A 14,784 3,113
5 North… 3.39e5 5,582 606 6,443 891 21,084 4,393 4,284
6 Georg… 3.10e5 17,506 1,028 2,706 2,912 20,191 5,154 3,380
7 New Y… 3.03e5 1,389 445 3,934 649 31,097 5,110 15,165
8 Virgi… 2.76e5 3,475 796 4,091 142 21,771 4,924 3,179
9 Arizo… 2.56e5 1,373 2,017 N/A 1,896 54,222 8,344 1,085
10 Penns… 2.38e5 1,733 595 3,773 776 11,590 3,234 3,619
11 Color… 2.33e5 3,745 1,452 12,378 1,435 26,148 N/A 1,875
12 Washi… 2.13e5 926 3,098 10,675 1,093 40,858 7,250 620
13 Illin… 2.04e5 1,375 30 4,417 2,189 16,460 5,827 863
14 South… 2.04e5 3,422 842 2,578 1,633 7,108 3,444 2,047
15 Tenne… 2.03e5 6,537 536 3,907 2,485 23,961 6,148 2,170
16 Ohio 1.85e5 1,421 547 4,352 929 12,197 3,393 1,361
17 Maryl… 1.63e5 431 142 2,202 128 10,051 1,276 1,908
18 New J… 1.56e5 178 54 1,140 165 9,431 2,332 2,483
19 India… 1.51e5 2,206 818 2,123 754 7,740 3,164 427
20 Massa… 1.45e5 97 0 1,427 50 12,160 2,017 10,437
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration in 2022
top22 <- m22 |>
arrange(desc(Total)) |>
head(20)
top22# A tibble: 20 × 56
...1 Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 8.23e6 102,894 32,755 204,734 74,408 817,669 239,200 88,733
2 Flori… 7.39e5 14,734 1,418 11,901 3,204 50,701 20,980 13,620
3 Texas 6.68e5 8,618 3,943 22,634 18,562 102,442 24,511 4,973
4 Calif… 4.76e5 5,204 2,040 27,412 963 N/A 19,970 4,977
5 North… 3.42e5 3,872 1,900 5,619 2,057 22,891 7,298 4,250
6 Georg… 3.28e5 21,031 210 1,798 531 25,960 5,419 2,526
7 New Y… 3.01e5 804 387 4,661 430 34,681 5,720 14,981
8 Arizo… 2.83e5 727 2,091 N/A 1,147 74,157 12,232 339
9 Virgi… 2.67e5 1,794 1,513 3,478 301 19,036 4,485 1,792
10 Penns… 2.63e5 775 519 5,561 624 16,336 3,840 2,816
11 Washi… 2.48e5 488 3,048 7,237 1,105 49,968 9,396 795
12 Color… 2.30e5 700 1,961 7,386 2,557 33,213 N/A 653
13 Illin… 2.28e5 2,389 434 5,377 1,468 20,573 6,720 474
14 Tenne… 2.26e5 9,375 1,025 4,584 7,202 22,565 4,105 936
15 South… 2.20e5 1,438 332 2,628 819 15,035 2,472 4,437
16 Ohio 2.01e5 3,028 168 5,224 1,804 11,924 4,849 675
17 New J… 1.75e5 565 0 1,077 221 6,543 1,905 1,417
18 Massa… 1.71e5 1,082 154 2,251 904 18,543 2,186 9,503
19 Misso… 1.63e5 570 414 3,576 9,590 12,107 8,042 203
20 Michi… 1.58e5 1,846 487 3,772 640 13,939 4,589 1,038
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration in 2021
top21 <- m21 |>
arrange(desc(Total)) |>
head(20)
top21# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.86e6 104,481 42,291 176,783 62,338 841,065 246,177 96,578
2 Flori… 6.75e5 15,159 2,938 6,607 4,804 37,464 18,468 15,801
3 Texas 5.91e5 9,389 2,587 17,609 13,613 107,546 30,262 2,506
4 Calif… 4.33e5 2,710 3,049 27,449 2,576 N/A 20,353 5,189
5 North… 3.37e5 3,276 1,730 5,929 3,063 22,507 6,549 4,741
6 Georg… 3.03e5 22,228 2,178 3,194 1,236 28,908 5,259 513
7 New Y… 2.87e5 1,930 1,036 2,472 1,935 31,335 6,112 12,538
8 Virgi… 2.73e5 1,878 1,532 5,698 742 21,052 5,002 3,396
9 Arizo… 2.65e5 1,485 3,586 N/A 178 69,432 10,035 2,705
10 Penns… 2.62e5 585 917 2,626 737 14,867 4,692 3,973
11 Color… 2.50e5 2,192 3,692 11,880 171 33,648 N/A 1,773
12 Washi… 2.25e5 1,064 2,242 10,300 782 57,576 7,452 1,536
13 Tenne… 2.21e5 9,869 456 3,625 3,161 22,901 5,383 1,462
14 South… 1.96e5 1,472 222 4,696 134 11,884 3,873 2,836
15 New J… 1.96e5 246 0 456 0 8,629 4,712 2,061
16 Illin… 1.95e5 614 618 4,126 824 20,488 6,060 1,778
17 Ohio 1.84e5 2,258 197 2,770 1,252 12,849 2,726 1,166
18 Misso… 1.66e5 1,362 414 4,226 7,506 13,726 5,441 151
19 Maryl… 1.60e5 906 1,201 1,744 203 8,406 2,776 1,999
20 Massa… 1.58e5 1,056 161 791 0 15,040 2,756 12,795
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration in 2019
top19 <- m19 |>
arrange(desc(Total)) |>
head(20)
top19# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.40e6 98,704 50,134 173,631 64,524 653,551 198,416 105,243
2 Flori… 6.02e5 15,153 4,906 7,054 3,544 28,628 13,656 13,227
3 Texas 5.60e5 8,791 4,622 21,205 12,341 82,235 18,189 2,085
4 Calif… 4.80e5 3,310 5,064 28,226 3,104 N/A 15,085 4,067
5 North… 3.15e5 4,697 1,568 5,319 1,976 18,023 6,089 5,840
6 Georg… 2.85e5 14,169 1,378 2,362 3,322 15,437 2,904 2,927
7 Penns… 2.67e5 1,898 1,008 3,104 502 13,048 1,631 4,853
8 Virgi… 2.65e5 4,028 1,256 2,513 1,011 16,994 4,588 2,838
9 New Y… 2.55e5 851 596 2,185 1,130 24,332 5,754 15,040
10 Arizo… 2.53e5 1,750 1,561 N/A 1,022 59,713 14,684 895
11 Color… 2.41e5 3,422 862 10,616 1,022 29,350 N/A 942
12 Washi… 2.32e5 1,060 4,255 8,263 83 46,791 6,829 3,098
13 Ohio 2.06e5 1,203 468 3,591 1,195 12,277 3,905 3,076
14 Tenne… 1.97e5 6,294 1,506 1,457 5,252 11,874 4,674 740
15 Illin… 1.91e5 1,658 135 5,054 1,202 14,692 3,455 1,783
16 South… 1.76e5 873 680 1,704 579 7,785 1,506 2,880
17 Misso… 1.52e5 2,246 927 3,184 4,768 7,970 4,032 997
18 India… 1.51e5 1,481 184 4,067 1,056 7,255 2,050 2,165
19 New J… 1.49e5 357 457 806 261 9,155 3,314 3,484
20 Massa… 1.44e5 1,099 553 1,228 0 11,430 2,094 11,690
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration for 2018
top18 <- m18 |>
arrange(desc(Total)) |>
head(20)
top18# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.57e6 98,194 39,246 179,586 69,724 691,145 203,460 114,235
2 Flori… 5.87e5 12,870 1,388 4,542 3,239 26,888 15,746 18,291
3 Texas 5.64e5 5,945 2,375 18,628 14,377 86,164 21,509 3,762
4 Calif… 5.01e5 4,591 2,155 33,670 2,573 N/A 18,755 6,366
5 North… 3.19e5 3,287 1,562 2,622 1,897 17,536 5,471 2,702
6 Georg… 2.74e5 15,589 917 2,255 1,900 16,745 3,497 5,574
7 Virgi… 2.74e5 3,426 1,235 4,162 1,002 21,210 4,557 3,254
8 Arizo… 2.74e5 2,801 2,743 N/A 1,487 68,516 11,517 503
9 Washi… 2.61e5 495 3,520 14,252 953 55,467 10,122 1,785
10 New Y… 2.54e5 1,395 415 3,541 52 25,255 4,553 14,420
11 Penns… 2.54e5 1,202 553 3,269 1,486 11,568 4,822 3,891
12 Color… 2.39e5 3,597 2,102 7,987 1,442 28,288 N/A 1,498
13 Tenne… 2.09e5 8,547 1,137 2,886 4,841 9,682 5,410 1,784
14 Illin… 2.07e5 1,280 1,400 5,818 1,188 16,518 3,208 1,911
15 Ohio 1.98e5 1,744 1,200 2,432 583 8,799 2,216 2,510
16 South… 1.87e5 4,636 715 1,460 1,382 12,103 1,622 6,800
17 Maryl… 1.63e5 647 485 2,240 785 7,924 1,168 1,890
18 New J… 1.60e5 147 67 1,626 0 9,613 1,505 2,187
19 Misso… 1.52e5 2,378 882 2,009 8,166 8,156 8,782 361
20 India… 1.45e5 966 138 3,009 1,271 6,811 4,695 722
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration for 2017
top17 <- m17 |>
arrange(desc(Total)) |>
head(20)
top17# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.47e6 101,466 42,972 163,214 69,850 661,026 194,296 98,971
2 Flori… 5.66e5 9,389 1,400 5,577 3,028 30,919 12,061 11,249
3 Texas 5.25e5 10,235 3,543 14,875 14,222 63,174 20,023 2,363
4 Calif… 5.23e5 3,715 2,606 26,907 3,471 N/A 25,038 5,935
5 North… 3.14e5 4,526 1,401 5,624 747 22,469 4,021 5,780
6 New Y… 2.85e5 1,849 1,049 3,826 1,209 24,982 3,104 17,340
7 Georg… 2.79e5 15,270 986 6,218 2,055 12,052 4,981 2,216
8 Arizo… 2.62e5 1,337 2,255 N/A 1,763 59,233 12,810 730
9 Washi… 2.61e5 1,605 7,532 11,733 1,074 52,484 8,473 1,310
10 Virgi… 2.50e5 2,341 736 2,587 1,184 14,509 4,644 3,368
11 Penns… 2.50e5 1,416 294 3,266 292 10,995 2,786 3,937
12 Color… 2.27e5 3,120 2,030 6,765 1,356 27,014 N/A 1,800
13 Ohio 1.99e5 2,487 79 3,143 683 11,286 3,209 2,478
14 Illin… 1.95e5 1,682 270 4,159 2,591 16,046 5,172 1,860
15 Tenne… 1.92e5 9,523 417 2,522 5,843 7,879 1,823 2,013
16 South… 1.67e5 2,133 0 2,380 232 7,618 1,756 3,427
17 Maryl… 1.66e5 644 961 1,689 410 8,994 2,182 1,726
18 Misso… 1.65e5 2,518 1,224 2,820 6,560 10,918 4,275 425
19 New J… 1.52e5 169 610 898 175 7,968 1,099 5,324
20 Oregon 1.50e5 179 2,808 6,938 526 50,109 3,185 355
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration for 2016
top16 <- m16 |>
arrange(desc(Total)) |>
head(20)
top16# A tibble: 20 × 56
...1 Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.55e6 99,892 42,074 192,103 72,033 657,690 193,179 112,914
2 Flori… 6.05e5 11,353 1,852 10,312 4,136 28,420 9,880 15,285
3 Texas 5.32e5 6,915 2,257 20,322 11,986 69,945 21,596 1,834
4 Calif… 5.15e5 3,045 4,206 33,757 4,282 N/A 22,540 2,932
5 North… 3.31e5 3,491 2,059 3,539 1,135 17,653 4,285 7,425
6 Georg… 3.05e5 18,276 1,287 3,901 2,388 18,948 3,337 6,077
7 Arizo… 2.73e5 894 1,946 N/A 1,205 64,756 11,895 1,596
8 Virgi… 2.64e5 2,424 1,624 3,584 519 17,473 3,269 5,158
9 New Y… 2.61e5 402 421 4,971 755 22,626 3,463 16,339
10 Washi… 2.58e5 1,465 5,374 12,801 823 51,485 13,012 1,309
11 Penns… 2.52e5 1,978 820 2,076 979 12,381 3,434 6,629
12 Color… 2.23e5 2,328 1,698 13,015 808 26,909 N/A 2,882
13 Illin… 2.04e5 2,022 578 5,251 1,288 15,163 3,257 1,297
14 Ohio 1.95e5 3,101 169 2,620 873 11,777 3,265 1,340
15 Tenne… 1.71e5 7,683 1,141 1,449 5,583 7,996 1,692 2,042
16 South… 1.65e5 2,823 411 1,708 581 4,846 1,947 2,941
17 Misso… 1.63e5 2,283 1,288 2,958 8,523 7,037 4,960 445
18 Maryl… 1.59e5 1,241 53 940 349 6,348 2,210 707
19 Michi… 1.56e5 2,287 285 4,061 806 8,001 2,120 912
20 Massa… 1.49e5 681 115 2,511 388 12,831 3,046 11,229
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration for 2015
top15 <- m15 |>
arrange(desc(Total)) |>
head(20)
top15# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.53e6 100,809 40,552 184,476 76,673 643,710 182,945 103,343
2 Flori… 5.85e5 15,449 1,553 7,168 6,850 21,217 9,206 14,887
3 Texas 5.53e5 7,167 2,573 16,067 14,539 65,546 22,587 3,973
4 Calif… 5.14e5 5,273 6,022 34,204 2,867 N/A 21,157 6,205
5 North… 3.11e5 3,733 578 5,963 707 16,985 3,634 6,709
6 Georg… 2.83e5 16,372 669 1,713 1,668 15,675 4,456 1,995
7 Virgi… 2.78e5 2,888 1,221 2,181 856 24,500 3,804 3,594
8 New Y… 2.58e5 850 1,020 5,993 1,054 25,510 3,101 11,684
9 Arizo… 2.53e5 607 2,519 N/A 553 54,646 11,039 2,417
10 Penns… 2.33e5 1,663 368 2,921 765 10,249 3,115 5,967
11 Washi… 2.31e5 580 3,911 9,860 1,146 45,609 7,258 586
12 Color… 2.27e5 2,392 1,653 10,254 1,527 29,029 N/A 2,253
13 Illin… 2.10e5 1,853 350 6,776 1,452 18,953 3,998 1,473
14 Ohio 2.03e5 2,038 1,330 4,257 1,404 11,145 3,137 2,126
15 Tenne… 1.96e5 10,291 624 2,513 6,071 10,032 1,722 995
16 South… 1.70e5 1,854 250 900 1,612 5,915 2,725 3,355
17 Maryl… 1.69e5 1,526 361 2,649 54 10,859 3,002 2,006
18 Misso… 1.59e5 1,449 920 3,305 7,887 9,646 4,791 268
19 India… 1.48e5 2,130 0 2,871 640 6,407 2,271 681
20 New J… 1.44e5 250 839 1,521 243 5,447 768 2,781
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration for 2014
top14 <- m14 |>
arrange(desc(Total)) |>
head(20)
top14# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.33e6 111,655 92,637 203,810 65,198 593,308 173,332 95,501
2 Flori… 5.47e5 15,731 7,883 7,902 1,911 23,239 9,260 12,944
3 Texas 5.39e5 6,437 8,487 18,001 11,926 63,591 18,277 3,110
4 Calif… 5.14e5 10,439 7,098 35,200 1,570 N/A 17,500 5,994
5 North… 2.87e5 4,264 2,467 2,246 571 16,448 5,108 4,754
6 Georg… 2.74e5 18,778 3,804 6,629 1,793 13,978 5,629 3,248
7 Virgi… 2.62e5 2,654 2,656 3,605 57 16,013 5,487 2,185
8 New Y… 2.59e5 1,662 3,180 7,696 611 22,241 2,148 14,649
9 Arizo… 2.50e5 785 3,140 N/A 1,180 57,446 9,663 458
10 Penns… 2.33e5 1,535 2,361 1,735 549 9,151 2,615 2,670
11 Washi… 2.20e5 1,640 7,216 8,931 1,406 40,085 6,779 1,400
12 Color… 2.19e5 1,004 2,696 12,304 1,956 24,506 N/A 832
13 Illin… 2.10e5 1,566 3,205 2,834 1,234 15,669 4,066 1,386
14 Ohio 1.97e5 1,189 1,455 3,348 1,467 7,793 3,917 1,251
15 Tenne… 1.82e5 9,640 837 2,605 7,625 8,847 2,482 390
16 South… 1.72e5 3,219 1,225 2,298 991 5,826 3,455 4,030
17 Maryl… 1.57e5 770 657 2,018 500 7,073 1,834 1,784
18 Misso… 1.53e5 2,807 1,013 3,741 8,043 6,925 2,959 225
19 Michi… 1.50e5 2,362 2,119 6,338 788 9,754 1,938 1,124
20 Massa… 1.47e5 519 1,874 1,011 234 14,490 3,008 13,287
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …Top 20 states for migration for 2013
top13 <- m13 |>
arrange(desc(Total)) |>
head(20)
top13# A tibble: 20 × 56
State Total Alabama Alaska Arizona Arkansas California Colorado Connecticut
<chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Unite… 7.21e6 97,219 99,931 183,178 76,963 581,679 166,348 91,600
2 Texas 5.48e5 8,404 7,252 19,224 16,844 66,318 18,979 2,129
3 Flori… 5.29e5 10,281 10,876 7,553 1,577 26,690 7,608 8,709
4 Calif… 4.85e5 2,958 8,457 36,567 3,687 N/A 16,151 5,145
5 Georg… 2.79e5 18,739 3,143 3,464 1,685 13,792 5,704 4,838
6 North… 2.76e5 3,268 4,199 4,437 1,350 14,315 4,554 3,918
7 New Y… 2.72e5 1,648 6,790 3,642 699 23,533 4,058 14,393
8 Virgi… 2.66e5 4,894 2,226 3,518 790 16,513 4,048 4,448
9 Arizo… 2.36e5 2,140 4,418 N/A 310 47,959 8,325 1,029
10 Penns… 2.24e5 720 667 2,189 1,971 7,269 2,039 5,411
11 Illin… 2.24e5 2,044 2,624 5,598 1,586 18,305 2,992 1,824
12 Washi… 2.08e5 686 3,422 10,591 2,088 37,150 5,420 814
13 Color… 2.07e5 2,926 1,606 8,798 1,235 23,714 N/A 861
14 Tenne… 1.87e5 8,500 2,079 3,787 4,753 7,988 1,570 233
15 Ohio 1.86e5 1,318 663 2,793 738 9,126 3,654 1,365
16 South… 1.66e5 1,715 1,128 2,054 1,970 9,781 2,570 3,174
17 Maryl… 1.62e5 1,918 1,589 1,515 203 8,255 2,081 1,118
18 Misso… 1.60e5 1,004 438 3,763 8,024 6,832 4,218 723
19 Michi… 1.44e5 2,517 4,783 3,372 2,628 10,087 2,508 1,202
20 Oregon 1.44e5 704 3,439 7,611 608 31,380 6,024 251
# ℹ 47 more variables: Delaware <chr>, `District of Columbia` <chr>,
# Florida <chr>, Georgia <chr>, Hawaii <chr>, Idaho <chr>, Illinois <chr>,
# Indiana <chr>, Iowa <chr>, Kansas <chr>, Kentucky <chr>, Louisiana <chr>,
# Maine <chr>, Maryland <chr>, Massachusetts <chr>, Michigan <chr>,
# Minnesota <chr>, Mississippi <chr>, Missouri <chr>, Montana <chr>,
# Nebraska <chr>, Nevada <chr>, `New Hampshire` <chr>, `New Jersey` <chr>,
# `New Mexico` <chr>, `New York` <chr>, `North Carolina` <chr>, …join 2013-2019, and 2021-2023 (there is no 2020 likely due to covid)
full <- bind_rows(m23, m22, m21, m19, m18, m17, m16, m15, m14, m13)
dim(full)[1] 530 58write_csv(full, "migration.csv")