knitr::opts_chunk$set(echo = TRUE)
library(ggplot2)
library(dplyr)
library(here)
here::i_am("dc_historical_census_tracts.Rmd")Files on the Census tracts from various historical periods are uploaded from DC Open Data. Additional data files can be accessed from the DC Open Data webiste here and include KML, GeoJSON, and shapefies.
We load the data for historical tracts for DC to utilize and combine with other data.
dc.tracts.1940 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_1940.csv")
head(dc.tracts.1940)## OBJECTID NHGISST NHGISCTY GISJOIN GISJOIN2 SQMI CENSUS_YEAR
## 1 1 110 10 G11000100016 11000100016 1.044000 1940
## 2 2 110 10 G11000100015 11000100015 1.828470 1940
## 3 3 110 10 G11000100017 11000100017 0.603301 1940
## 4 4 110 10 G11000100018 11000100018 0.889919 1940
## 5 5 110 10 G11000100040 11000100040 0.184525 1940
## 6 6 110 10 G11000100003 11000100003 0.376909 1940
## STATE_NAME TRACT_NUMBER
## 1 District Of Columbia 16
## 2 District Of Columbia 15
## 3 District Of Columbia 17
## 4 District Of Columbia 18
## 5 District Of Columbia 40
## 6 District Of Columbia 3
## TRACT_NAME BUB01 BUJ01 BUJ02 BUJ03 BUJ04
## 1 STCTY-11001 TRACT- 0016 IN WASHINGTON DC 3684 174 211 227 279
## 2 STCTY-11001 TRACT- 0015 IN WASHINGTON DC 3921 287 295 342 288
## 3 STCTY-11001 TRACT- 0017 IN WASHINGTON DC 5251 301 278 320 417
## 4 STCTY-11001 TRACT- 0018 IN WASHINGTON DC 5204 321 201 196 321
## 5 STCTY-11001 TRACT- 0040 IN WASHINGTON DC 8528 244 223 242 441
## 6 STCTY-11001 TRACT- 0003 IN WASHINGTON DC 6117 375 354 420 469
## BUJ05 BUJ06 BUJ07 BUJ08 BUJ09 BUJ10 BUJ11 BUJ12 BUJ13 BUJ14 BUJ15 BUJ16 BUJ17
## 1 278 285 291 297 387 333 316 207 167 99 68 65 334
## 2 216 188 334 386 491 357 246 164 115 79 72 61 266
## 3 443 459 447 486 464 396 335 272 257 164 97 115 518
## 4 761 874 634 455 412 352 245 159 115 66 50 42 231
## 5 887 1102 912 691 709 658 595 483 425 385 263 268 1073
## 6 499 593 688 553 581 448 370 256 214 134 84 79 432
## BUJ18 BUJ19 BUJ20 BVS001 BVS001P BVS002 BVS002P BUQ001 BUQ001P BUQ002 BUQ002P
## 1 9.1 167 4.5 1646 44.7 2038 55.3 3494 94.8 190 5.2
## 2 6.8 151 3.9 1808 46.1 2113 53.9 3807 97.1 114 2.9
## 3 9.9 261 5.0 2423 46.1 2828 53.9 5047 96.1 204 3.9
## 4 4.4 116 2.2 2643 50.8 2561 49.2 4954 95.2 250 4.8
## 5 12.6 648 7.6 3401 39.9 5127 60.1 6992 82.0 1536 18.0
## 6 7.1 218 3.6 2823 46.2 3294 53.8 6074 99.3 43 0.7
## BUP1 BUP1P BUP2 BUP2P BU1001 BU6001 BU6002 BU6003 BU6004 BU6005 BU6006 BU6007
## 1 3289 94.1 205 5.9 996 815 1 22 24 0 60 5
## 2 3635 95.5 172 4.5 1081 1076 0 2 2 0 0 0
## 3 4734 93.8 313 6.2 1617 846 1 66 136 42 12 15
## 4 4519 91.2 435 8.8 1542 332 174 110 42 36 108 26
## 5 6525 93.3 467 6.7 3050 137 295 6 58 81 64 21
## 6 5753 94.7 321 5.3 1842 530 769 20 60 15 96 7
## BU6008 BU6009 BU6010 BU6011 BVP001 BU7001 BU7002 BU7003 BU7004 BU7005 BU7006
## 1 10 16 43 0 950 11 203 241 233 132 78
## 2 0 0 0 1 1027 13 218 251 296 141 67
## 3 64 57 367 11 1515 72 438 373 322 149 89
## 4 30 366 318 0 1432 59 587 353 224 105 57
## 5 249 449 1689 1 2744 529 1022 557 256 139 73
## 6 207 73 64 1 1715 42 457 478 399 184 94
## BU7007 BU7008 BU7009 BU7010 BU7011 BVQ001 BU4001 BU4002 BU2001 BU2001P BU2002
## 1 35 11 3 2 1 3.88 46 0 739 77.8 211
## 2 26 9 2 3 1 3.82 45 9 869 84.6 158
## 3 39 12 4 9 8 3.47 95 7 703 46.4 812
## 4 22 17 2 3 3 3.63 104 6 454 31.7 978
## 5 43 34 23 15 53 3.11 239 67 268 9.8 2476
## 6 39 14 4 2 2 3.57 112 15 889 51.8 826
## BU2002P BVC001 BVJ001 BUH01 BUH02 BUH03 BUH04 BUH05 BUH06 BUH07 BUH08 BUH09
## 1 22.2 15235 55.50 2515 11 36 68 463 346 701 350 522
## 2 15.4 12561 10.00 2493 9 17 47 243 267 636 492 762
## 3 53.6 9230 53.69 3492 18 83 156 670 572 987 438 545
## 4 68.3 11227 56.46 3404 11 58 95 581 517 1044 494 572
## 5 90.2 12122 57.94 6491 47 128 205 940 847 1756 1080 1398
## 6 48.2 8178 61.42 4000 17 37 118 739 552 1108 627 788
## BUH10 BUW0 BUW1 BUW2 BUX1 BUX2 BUX3 BUX4 BUX5 BUX6 BUX7 BUX8 BUZ01 BUZ02 BU1
## 1 18 3118 1744 1374 1701 5 38 806 324 73 0 171 38 1.2 1701
## 2 20 3064 1616 1448 1576 10 30 913 335 66 15 119 30 1.0 1576
## 3 23 4419 2543 1876 2422 28 93 1108 416 142 0 210 93 2.1 2422
## 4 32 4527 3179 1348 3093 27 59 909 267 54 0 118 59 1.3 3093
## 5 90 7874 5288 2586 4998 88 202 1485 452 287 0 362 202 2.6 4998
## 6 14 5065 2945 2120 2746 63 136 1248 518 90 83 181 136 2.7 2746
## BU2 BU3 BU4 BU5 BU6 BU7 BU8 BU9 BU10 BU11 GIS_ID CREATOR CREATED
## 1 342 42 290 598 97 49 219 56 1 7 Tract40Ply_1 NA NA
## 2 439 29 328 528 58 24 129 17 10 14 Tract40Ply_2 NA NA
## 3 391 59 248 997 260 179 74 173 32 9 Tract40Ply_3 NA NA
## 4 551 160 336 1208 206 136 81 372 30 13 Tract40Ply_4 NA NA
## 5 743 68 386 2178 172 275 403 646 90 37 Tract40Ply_5 NA NA
## 6 484 99 297 1255 217 157 67 142 16 12 Tract40Ply_6 NA NA
## EDITOR EDITED SHAPEAREA SHAPELEN
## 1 NA NA 0 0
## 2 NA NA 0 0
## 3 NA NA 0 0
## 4 NA NA 0 0
## 5 NA NA 0 0
## 6 NA NA 0 0dc.tracts.1950 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_1950.csv")
head(dc.tracts.1950)## OBJECTID NHGISST NHGISCTY GISJOIN GISJOIN2 SQMI GISJOIN_1
## 1 1 110 10 G11000100016 11000100016 1.044000 G11000100016
## 2 2 110 10 G11000100015 11000100015 1.828470 G11000100015
## 3 3 110 10 G11000100017 11000100017 0.603301 G11000100017
## 4 4 110 10 G11000100018 11000100018 0.889919 G11000100018
## 5 5 110 10 G11000100033 11000100033 0.248911 G11000100033
## 6 6 110 10 G11000100037 11000100037 0.103725 G11000100037
## CENSUS_YEAR STATE_NAME TRACT_NUMBER
## 1 1950 District Of Columbia 16
## 2 1950 District Of Columbia 15
## 3 1950 District Of Columbia 17
## 4 1950 District Of Columbia 18
## 5 1950 District Of Columbia 33
## 6 1950 District Of Columbia 37
## TRACT_NAME BZ801 BZ802 BZ803 BZ804 BZ805
## 1 STCTY-11001 TRACT- 0016 IN WASHINGTON DC 4686 280 307 268 440
## 2 STCTY-11001 TRACT- 0015 IN WASHINGTON DC 5427 349 547 442 320
## 3 STCTY-11001 TRACT- 0017 IN WASHINGTON DC 6845 712 494 301 351
## 4 STCTY-11001 TRACT- 0018 IN WASHINGTON DC 8823 616 431 324 604
## 5 STCTY-11001 TRACT- 0033 IN WASHINGTON DC 9650 776 422 394 503
## 6 STCTY-11001 TRACT- 0037 IN WASHINGTON DC 6579 356 194 146 225
## BZ806 BZ807 BZ808 BZ809 BZ810 BZ811 BZ812 BZ813 BZ814 BZ815 BZ816 BZ817 BZ818
## 1 324 255 246 331 384 392 421 352 228 191 127 123 17
## 2 227 196 268 429 571 527 527 372 239 158 109 118 28
## 3 444 652 630 557 500 492 418 406 310 223 160 161 34
## 4 918 968 970 921 827 639 545 412 259 172 116 91 10
## 5 999 1155 945 873 753 653 566 451 396 328 219 182 35
## 6 592 800 715 680 625 539 487 370 309 222 162 136 21
## BZ819 BZ820 BZ821 BZ822 BZ823 BZ824 BZ825 BZ826 BOA01 BOA02 BOA03 BOA04
## 1 686 14.6 458 9.8 2078 44.3 2608 55.7 4566 97.4 112 2.4
## 2 652 12.0 413 7.6 2457 45.3 2970 54.7 5327 98.2 86 1.6
## 3 888 13.0 578 8.4 3123 45.6 3722 54.4 6726 98.3 87 1.3
## 4 648 7.3 389 4.4 4753 53.9 4070 46.1 8471 96.0 333 3.8
## 5 1160 12.0 764 7.9 4539 47.0 5111 53.0 2796 29.0 6819 70.7
## 6 850 12.9 541 8.2 2549 38.7 4030 61.3 5872 89.3 672 10.2
## B0J001 B0J001P B0J002 B0J002P B0J003 B0J003P B1K001 B0S001 B0W001 B0W002
## 1 8 0.2 545 1283 1073 4 33 26 77 70
## 2 14 0.3 365 1540 1532 1 3 4 0 0
## 3 32 0.5 565 2109 806 180 272 140 90 621
## 4 19 0.2 993 2456 502 131 156 38 154 1475
## 5 35 0.4 197 2327 7 1166 46 358 406 344
## 6 35 0.5 498 2264 36 143 13 92 203 1777
## B0W003 B0W004 B0W005 B0W006 B0Z001 B00001 B00002 B00003 B00004 B00005 B00006
## 1 1258 62 290 306 291 259 50 18 7 1051 207
## 2 1498 39 407 349 352 297 54 21 21 1370 128
## 3 2075 200 573 502 439 296 65 22 12 1062 1013
## 4 2421 253 937 576 387 228 40 29 6 703 1718
## 5 2278 171 565 506 384 425 227 26 23 1091 1187
## 6 2227 623 861 367 200 118 58 24 13 185 2042
## B0T003 B0T004 B0T001 B0T002 B0U001 B1J001 B1M001 BZ9001 B09001 B05001 B0B
## 1 1257 1100 595 20000 55.03 0 3010 25 120 75 90
## 2 1496 1310 315 20000 100.00 3 3615 10 30 80 40
## 3 2071 1715 610 15811 57.33 9 4570 45 125 145 155
## 4 2425 2080 2390 20000 64.34 0 6000 50 155 200 155
## 5 2276 2185 1650 14284 55.32 0 6540 40 400 495 435
## 6 2226 1425 2255 0 57.91 40 5035 20 140 255 175
## B0B001 B0B002 B0B003 B0B004 B0B005 B0B006 B0B007 B0B008 B0B009 B0B010 BON01
## 1 250 340 915 405 715 75 1800 3875 1994 1881 1927
## 2 220 305 905 595 1345 85 1725 4181 2202 1979 2094
## 3 505 780 1445 640 655 75 2485 5392 3157 2235 3012
## 4 525 820 1615 1125 1110 245 4600 7503 5227 2276 3356
## 5 840 1050 1375 605 820 480 4205 8137 5113 3024 4926
## 6 445 690 1540 765 695 310 3985 5917 4207 1710 4028
## BON02 BON03 BOP01 BOP02 BOP03 BOR01 BOR02 BOR03 BOR04 BOR05 BOR06 BOR07
## 1 37 1927 450 520 438 179 90 48 118 57 6 21
## 2 36 2094 726 498 463 128 71 27 109 40 10 22
## 3 60 3012 595 435 922 318 325 171 34 140 39 33
## 4 81 3356 671 709 987 412 203 121 49 157 14 33
## 5 157 4926 479 111 1262 156 441 639 406 1006 340 86
## 6 132 4028 613 249 1771 275 343 190 73 360 61 93
## B0D001 B0E001 B0E002 B0E003 B0E004 B0E005 B0E006 B0E007 B0E008 B0E009 B0E010
## 1 1800 245 75 125 60 40 40 75 85 35 25
## 2 1725 85 70 65 40 15 35 30 25 40 60
## 3 2485 135 50 80 110 160 150 290 175 170 140
## 4 4600 325 240 375 235 165 280 295 225 165 165
## 5 4205 420 280 390 370 500 465 330 190 140 125
## 6 3985 290 140 185 195 395 475 585 340 260 155
## B0E011 B0E012 B0E013 B0E014 B0E015 B0E016 GIS_ID CREATOR CREATED EDITOR
## 1 70 95 220 495 115 5536 Tract50Ply_1 NA NA NA
## 2 110 100 410 475 165 7768 Tract50Ply_2 NA NA NA
## 3 265 220 235 180 125 4088 Tract50Ply_3 NA NA NA
## 4 370 310 480 315 655 3628 Tract50Ply_4 NA NA NA
## 5 180 120 90 20 585 2350 Tract50Ply_5 NA NA NA
## 6 185 140 160 70 410 3092 Tract50Ply_6 NA NA NA
## EDITED SHAPEAREA SHAPELEN
## 1 NA 0 0
## 2 NA 0 0
## 3 NA 0 0
## 4 NA 0 0
## 5 NA 0 0
## 6 NA 0 0dc.tracts.1960 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_1960.csv")
head(dc.tracts.1960)## OBJECTID NHGISST NHGISCTY GISJOIN GISJOIN2 SQMI CENSUS_YEAR
## 1 1 110 10 G11000100016 11000100016 1.044000 1960
## 2 2 110 10 G11000100015 11000100015 1.828470 1960
## 3 3 110 10 G11000100017 11000100017 0.603301 1960
## 4 4 110 10 G11000100018 11000100018 0.889919 1960
## 5 5 110 10 G11000100090 11000100090 1.220630 1960
## 6 6 110 10 G11000100034 11000100034 0.421264 1960
## STATE_NAME TRACT_NUMBER TRACT_SUFFIX TRACT_NAME CA4001 B6H1 B6H2
## 1 District Of Columbia 16 NA TRACT 16 5458 258 377
## 2 District Of Columbia 15 NA TRACT 15 6177 353 532
## 3 District Of Columbia 17 NA TRACT 17 5871 492 433
## 4 District Of Columbia 18 NA TRACT 18 9281 477 330
## 5 District Of Columbia 90 NA TRACT 90 2388 205 205
## 6 District Of Columbia 34 NA TRACT 34 6867 592 523
## B6H3 B6H4 B6H5 B6H6 B6H7 B6H8 B6H9 B6H10 B6H11 B6H12 B6H13 B6H14 B6H15 B6H16
## 1 455 638 290 162 218 305 420 525 453 382 333 258 185 100
## 2 588 498 204 142 242 320 464 569 609 487 464 288 180 131
## 3 389 345 329 350 327 364 391 417 408 400 374 292 253 168
## 4 425 530 1008 699 585 614 733 747 847 679 624 450 296 141
## 5 177 595 106 113 144 130 149 117 113 95 83 70 43 16
## 6 395 949 1075 483 365 361 332 356 355 283 229 189 150 137
## B6H17 B6H18 B58001 B58002 B58003 B58004 B58005 B58006 B58007 B58008 B58009
## 1 61 38 1389 25.4 975 17.9 642 11.8 2483 45.5 2975
## 2 64 42 1827 29.6 1169 18.9 705 11.4 2844 46.0 3333
## 3 92 47 1562 26.6 1226 20.9 852 14.5 2634 44.9 3237
## 4 64 32 1481 16.0 1607 17.3 983 10.6 4529 48.8 4752
## 5 16 11 1039 43.5 239 10.0 156 6.5 1432 60.0 956
## 6 57 36 1782 26.0 798 11.6 569 8.3 3363 49.0 3504
## B58010 B58011 B58012 B58013 B58014 B58015 B58016 CA7001 CA7002 B8J001 B7D01
## 1 54.5 5344 97.9 93 1.7 21 0.4 9 0.2 905 1610
## 2 54.0 6035 97.7 44 0.7 98 1.6 0 0.0 662 1889
## 3 55.1 4788 81.6 1028 17.5 55 0.9 46 0.8 648 2086
## 4 51.2 8114 87.4 1081 11.6 86 0.9 62 0.7 1609 3664
## 5 40.0 1321 55.3 1064 44.6 3 0.1 19 0.8 50 513
## 6 51.0 61 0.9 6762 98.5 44 0.6 24 0.3 271 1685
## B7D001 B7D002 B7D003 B7D004 B7D005 CAS001 CAS002 CAS003 CAS004 CAS005 CAS006
## 1 1455 29 58 25 43 1572 134 452 332 313 196
## 2 1884 0 0 0 5 1858 115 581 444 353 203
## 3 1273 95 64 111 543 2046 462 627 358 283 164
## 4 838 72 174 106 2474 3480 888 1412 633 321 128
## 5 494 10 9 0 0 502 51 134 100 77 45
## 6 912 108 214 177 274 1619 413 416 261 170 123
## CAS007 CAS008 CAS009 CAS010 B9O001 B9O002 B9R001 B9R002 B9R003 B78001 B78002
## 1 93 31 21 3.3 1344 228 19 10 9 0 0
## 2 94 42 26 3.3 1691 167 4 5 22 0 3
## 3 76 39 37 2.8 1130 916 11 22 7 0 17
## 4 53 23 22 2.4 803 2677 7 164 13 0 7
## 5 37 23 35 3.7 363 139 0 11 0 0 26
## 6 96 57 83 3.1 375 1244 0 55 11 2 69
## B78003 B78004 B78005 B78006 CAR001 CAR002 CAR003 CAR004 CAR005 CAR006 CAR007
## 1 22 143 324 848 0 0 0 0 4 16 46
## 2 28 132 468 1058 0 0 3 0 0 0 0
## 3 362 454 103 31 0 8 0 27 39 93 179
## 4 62 362 255 79 8 4 8 16 29 107 386
## 5 200 108 6 7 0 0 4 0 5 8 8
## 6 196 74 8 7 4 25 78 113 260 169 222
## CAR008 CAR009 CAR010 CAR011 CAR012 CAR013 B54001 B8O001 B8O002 B8O003 B8O004
## 1 32 21 26 8 20 34 234 53 53 699 521
## 2 0 0 4 4 42 92 51 111 67 889 575
## 3 182 125 91 63 58 10 66 73 62 630 520
## 4 606 350 525 247 260 72 1055 32 32 600 386
## 5 22 20 22 22 8 4 524 13 4 371 311
## 6 156 82 76 51 0 0 1794 86 86 810 778
## B8R001 B8R002 B8R003 B8R004 B8R005 B8R006 B8R007 B8R008 B8201 B8202 B8203
## 1 74 81 144 344 499 918 574 812 2307 44 41
## 2 12 21 91 190 406 877 861 1545 2512 24 28
## 3 66 99 323 526 660 1019 588 577 2613 59 99
## 4 188 159 468 774 1042 1696 934 1232 4302 55 1350
## 5 33 77 182 161 251 223 92 79 865 21 0
## 6 50 228 546 471 604 626 381 362 2270 120 8
## B8204 B9B01 B9B02 B9B03 B9B04 B9B05 B9B06 B9B07 B9B08 B9B09 B9B10 B9B11 B9B12
## 1 2077 460 4 492 150 160 104 37 8 40 0 12 53
## 2 2268 703 0 460 176 118 77 20 8 22 0 22 62
## 3 1861 348 0 202 251 105 254 200 0 149 0 49 192
## 4 2429 649 0 430 264 294 302 167 0 234 0 41 122
## 5 953 75 0 52 122 18 133 107 0 105 0 73 67
## 6 3013 272 0 37 494 46 232 399 44 558 0 294 206
## B9F001 B9F002 B9F003 B9F004 B9F005 B9F006 B9F007 B9F008 B9F009 B9F010 B9F011
## 1 0 128 13 20 13 4 9 17 4 40 8
## 2 0 76 4 3 16 8 4 12 0 91 4
## 3 0 114 5 14 34 0 4 48 0 125 12
## 4 0 122 0 20 25 0 16 24 0 94 8
## 5 0 49 0 14 6 4 4 3 5 54 8
## 6 0 117 0 5 4 0 0 29 0 38 4
## B9F012 B9F013 B9F014 B9F015 B9F016 B9F017 B9F018 B9F019 B9F020 B9F021 B9F022
## 1 8 16 14 78 68 493 48 123 63 27 151
## 2 24 15 65 48 40 183 60 102 28 16 190
## 3 17 24 77 51 72 350 66 45 107 122 117
## 4 4 96 32 148 115 876 132 31 100 186 253
## 5 15 25 7 20 37 128 26 39 43 24 30
## 6 17 59 40 9 114 166 77 292 225 120 210
## B9F023 B9F024 B9F025 B6X001 B6X002 B6X003 B6X004 B6X005 B6X006 B6X007 B6X008
## 1 336 395 231 1505 3 0 410 130 25 141 86
## 2 406 833 284 1690 0 0 456 49 60 158 86
## 3 181 651 377 1410 4 5 687 228 54 62 210
## 4 342 1237 441 2436 4 0 1465 775 90 78 247
## 5 36 189 99 449 0 0 240 60 7 0 80
## 6 105 374 265 558 0 0 1114 329 26 98 113
## CAN001 CAN002 CAN003 CAN004 B8W001 B8W002 B8W003 B8W004 B8W005 B8W006 B8W007
## 1 151 662 633 126 16 11 23 39 60 48 62
## 2 72 1016 704 66 28 40 12 33 59 52 55
## 3 681 1105 228 32 31 54 65 128 209 108 115
## 4 1140 1944 320 76 55 66 106 181 217 188 245
## 5 121 289 87 5 11 8 15 35 61 58 55
## 6 1042 530 47 0 78 143 174 165 144 128 96
## B8W008 B8W009 B8W010 B8W011 B8W012 B8W013 GIS_ID CREATOR CREATED EDITOR
## 1 55 73 50 427 326 226 Tract60Ply_1 NA NA NA
## 2 96 39 99 522 494 191 Tract60Ply_2 NA NA NA
## 3 140 108 117 289 138 24 Tract60Ply_3 NA NA NA
## 4 218 249 215 568 207 31 Tract60Ply_4 NA NA NA
## 5 44 48 39 53 14 3 Tract60Ply_5 NA NA NA
## 6 48 35 8 73 10 0 Tract60Ply_6 NA NA NA
## EDITED SHAPEAREA SHAPELEN
## 1 NA 0 0
## 2 NA 0 0
## 3 NA 0 0
## 4 NA 0 0
## 5 NA 0 0
## 6 NA 0 0dc.tracts.1970 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_1970.csv")
head(dc.tracts.1970)## OBJECTID NHGISST NHGISCTY GISJOIN GISJOIN2 SQMI CENSUS_YEAR
## 1 1 110 10 G11000100016 1.10001e+10 1.044000 1970
## 2 2 110 10 G11000100015 1.10001e+10 1.824130 1970
## 3 3 110 10 G11000100017 1.10001e+10 0.602730 1970
## 4 4 110 10 G1100010001801 1.10001e+12 0.193392 1970
## 5 5 110 10 G11000100029 1.10001e+10 0.117777 1970
## 6 6 110 10 G11000100031 1.10001e+10 0.117279 1970
## STATE TRACT_NUMBER TRACT_NAME CY7001 C1U01 C1U02 C1U03
## 1 District Of Columbia 16.00 Tract 16 5913 320 489 575
## 2 District Of Columbia 15.00 Tract 15 6225 430 454 562
## 3 District Of Columbia 17.00 Tract 17 5856 366 482 533
## 4 District Of Columbia 18.01 Tract 18.01 2019 72 12 9
## 5 District Of Columbia 29.00 Tract 29 5189 408 361 468
## 6 District Of Columbia 31.00 Tract 31 3726 305 291 402
## C1U04 C1U05 C1U06 C1U07 C1U08 C1U09 C1U10 C1U11 C1U12 C1U13 C1U14 C1U15 C1U16
## 1 321 400 125 53 139 152 276 417 422 419 388 444 152
## 2 355 153 57 13 170 270 383 376 293 381 382 392 178
## 3 283 216 79 80 223 328 289 490 443 369 374 303 103
## 4 0 141 236 395 547 265 105 70 70 22 36 30 0
## 5 298 160 98 103 243 359 273 274 360 416 405 312 129
## 6 267 128 43 29 153 205 181 214 177 243 192 228 70
## C1U17 C1U18 C1U19 C1U20 C1U21 C1U22 C1U23 C1U24 C1U25 C1U26 C1U27 C1U28 C1U29
## 1 192 273 197 159 1705 28.8 973 16.5 629 10.6 2643 44.7 3270
## 2 282 289 240 565 1801 28.9 1554 25.0 1094 17.6 2802 45.0 3423
## 3 188 205 167 335 1664 28.4 998 17.0 707 12.1 2698 46.1 3158
## 4 4 0 5 0 93 4.6 9 0.4 5 0.2 1715 84.9 304
## 5 69 203 120 130 1535 29.6 651 12.5 453 8.7 2382 45.9 2807
## 6 126 181 147 144 1265 34.0 668 17.9 472 12.7 1725 46.3 2001
## C1U30 CEB01 CEB02 CEB03 CEB04 CEB05 CEB06 CEB07 CEB08 CEB09 CEB10 CEB11 CEB12
## 1 55.3 3009 50.9 2855 48.3 11 0.2 9 0.2 7 0.1 4 0.1
## 2 55.0 5946 95.5 169 2.7 6 0.1 13 0.2 32 0.5 0 0.0
## 3 53.9 2035 34.8 3727 63.6 15 0.3 7 0.1 19 0.3 26 0.4
## 4 15.1 1731 83.2 344 16.5 0 0.0 1 0.0 0 0.0 0 0.0
## 5 54.1 143 2.8 5022 96.8 5 0.1 0 0.0 4 0.1 2 0.0
## 6 53.7 28 0.8 3670 98.5 12 0.3 0 0.0 1 0.0 1 0.0
## CEB13 CEB14 CEB15 CEB16 CEB17 CEB18 CY9001 CY9002 C1001 C1002 C1003 CZQ001
## 1 1 0 3 0.1 14 0.2 17 0.3 5466 447 7.6 1744
## 2 0 0 1 0.0 58 0.9 203 3.3 5624 601 9.7 1941
## 3 0 0 2 0.0 25 0.4 161 2.7 5553 303 5.2 2135
## 4 0 0 0 0.0 5 0.2 107 5.3 2070 19 0.9 53
## 5 0 0 1 0.0 12 0.2 45 0.9 5129 60 1.2 1888
## 6 0 0 0 0.0 14 0.4 34 0.9 3641 85 2.3 1194
## C0L001 C0L002 C0L003 C0L004 C0L005 C0L006 C0L007 C0L008 C0L009 CE9001 CFG001
## 1 1480 33 15 58 0 82 39 0 0 1707 1419
## 2 1879 0 5 5 0 0 0 10 0 1899 1701
## 3 879 281 59 71 102 151 238 257 5 2043 1062
## 4 10 0 0 0 10 33 0 0 0 54 0
## 5 86 622 90 177 205 226 200 137 5 1748 531
## 6 74 658 49 66 54 186 46 11 0 1144 415
## CFG002 CE9002 CE9003 CE9004 CE9005 CE9006 CE9007 CFD001 CFD002 CFD003 CFD004
## 1 288 37 4 18 1 3 11 195 513 342 296
## 2 198 42 13 11 5 7 6 208 649 356 344
## 3 981 80 43 17 11 8 1 549 563 319 280
## 4 54 0 0 0 0 0 0 1 10 15 13
## 5 1217 134 94 2 28 2 8 485 478 270 199
## 6 729 50 40 6 0 1 3 272 299 170 120
## CFD005 CFD006 CFD007 CFD008 CFD009 CFD010 CEC01 CEC02 CEC03 CEC04 CEC05 CEC06
## 1 203 78 47 19 14 3.2 1311 36 132 748 50.6 134
## 2 190 90 35 15 12 3.1 1472 38 148 803 48.4 111
## 3 148 91 39 32 22 2.8 1137 54 216 737 52.4 110
## 4 6 6 1 1 1 0.0 53 0 0 38 71.7 1
## 5 116 77 52 50 21 2.9 733 68 359 613 52.8 78
## 6 100 58 51 54 20 3.2 499 48 246 436 55.0 81
## CEC07 CG7001 CG7002 CG7003 CG7004 CG7005 CG7006 CG7007 CG7008 CG7009 CG7010
## 1 9.1 0 0 1 1 4 1 18 58 376 561
## 2 6.7 0 2 0 4 18 45 65 115 441 712
## 3 7.8 1 1 2 9 33 85 165 324 301 64
## 4 1.9 -1 NA NA NA NA NA NA NA NA NA
## 5 6.7 2 5 8 18 59 126 127 85 19 1
## 6 10.2 0 14 36 51 67 99 75 39 8 2
## CG7011 CHA001 CHA002 CHA003 CHA004 CHA005 CHA006 CHA007 CHA008 CHA009 CHA010
## 1 366 2 0 1 2 4 2 26 57 32 46
## 2 276 4 0 0 8 1 0 1 3 3 11
## 3 7 8 1 1 3 31 29 118 136 233 189
## 4 NA 0 0 0 0 0 1 0 0 0 0
## 5 1 6 3 15 30 70 154 216 274 276 103
## 6 0 11 1 6 20 48 160 167 80 117 64
## CHA011 CHA012 CHA013 CHA014 CHA015 C2001 C2I01 C2I02 C2I03 C2I04 C2I05 C2I06
## 1 33 18 22 19 24 371 2028 83 66 921 392 566
## 2 41 28 28 54 14 291 1718 147 98 800 498 175
## 3 161 27 8 1 28 81 1633 67 56 944 297 269
## 4 0 0 0 0 53 1811 341 14 0 30 17 280
## 5 47 1 0 0 14 124 1319 13 18 752 357 179
## 6 27 4 0 0 13 36 1064 54 51 538 268 153
## C2M01 C2M02 C2M03 C2M04 C2M05 C2M06 C2M07 C2M08 C2M09 C2M10 C2M11 C07001
## 1 3491 30 35 111 39 143 278 810 551 551 943 45
## 2 4031 0 47 32 25 233 302 873 685 742 1092 13
## 3 3594 46 87 150 132 322 553 1071 544 355 334 46
## 4 607 0 6 20 0 45 60 200 145 71 60 1859
## 5 3050 35 160 382 217 245 870 744 221 114 62 0
## 6 2108 26 204 235 143 226 498 471 152 84 69 10
## C07002 C07003 C07004 C07005 C27001 C27002 C27003 C27004 C27005 C27006 C27007
## 1 2462 45 1.8 1586 1083 429 164 494 106 23 24
## 2 2246 60 2.6 2121 1059 409 204 427 45 22 29
## 3 2419 91 3.6 1283 662 179 105 850 295 102 81
## 4 0 6 100.0 53 0 0 0 0 0 0 0
## 5 2046 67 3.2 971 203 75 96 515 201 105 276
## 6 1145 48 4.0 807 164 42 24 421 97 73 124
## C27008 C27009 C27010 C27011 C3B001 C3B002 C3B003 C3B004 C3B005 C3B006 C3B007
## 1 30 4 226 63 4 0 59 5 5 0 0
## 2 14 0 72 73 8 0 51 0 0 0 20
## 3 86 11 349 53 18 0 103 0 0 8 0
## 4 3 0 0 0 0 0 0 0 0 0 0
## 5 191 0 595 273 0 4 189 0 0 7 0
## 6 143 0 333 118 0 0 77 0 8 0 0
## C3B008 C3B009 C3B010 C3B011 C3B012 C3B013 C3B014 C3B015 C3B016 C3B017 C3B018
## 1 0 0 6 12 0 66 0 25 0 10 10
## 2 5 0 0 6 0 55 0 3 10 4 24
## 3 0 0 10 5 5 57 14 17 0 22 47
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 0 5 0 11 0 34 4 19 9 75 91
## 6 0 0 0 0 0 18 0 59 0 10 16
## C3B019 C3B020 C3B021 C3B022 C3B023 C3B024 C3B025 C3B026 C3B027 C3B028 C3B029
## 1 31 20 38 16 40 70 15 148 18 73 62
## 2 29 9 43 27 33 34 16 145 39 154 79
## 3 23 56 33 40 57 51 18 145 3 67 64
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 14 95 35 10 54 60 10 187 10 44 48
## 6 18 54 87 25 39 25 0 41 11 48 29
## C3B030 C3B031 C3B032 C3B033 C3B034 C3B035 C3B036 C3B037 C3B038 C3B039 C3B040
## 1 16 56 127 20 100 134 306 137 26 116 200
## 2 18 62 27 10 44 147 108 88 16 157 259
## 3 74 37 117 28 195 79 225 43 44 102 107
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 39 219 274 32 89 67 35 24 9 33 108
## 6 26 86 138 41 67 38 79 20 9 29 107
## C3B041 C2G001 C2G002 C2G003 C2G004 C2G005 C2G006 C2G007 C2G008 C2G009 C21001
## 1 675 1694 221 390 0 0 14 112 16 123 2565
## 2 624 1471 342 334 0 0 7 34 64 68 3477
## 3 859 1522 325 694 7 0 33 181 22 22 3226
## 4 3 441 12 51 117 0 0 980 237 36 1588
## 5 586 672 253 1249 0 0 61 71 16 38 2484
## 6 334 453 147 692 0 20 44 111 24 43 1993
## C21002 C2H001 C2H002 CRZ001 CRZ002 CRZ003 CRZ004 C3T001 C3T002 C3T003 C3T004
## 1 154 1887 884 224 665 652 166 8 5 22 22
## 2 302 1989 1094 86 832 816 165 9 6 4 11
## 3 305 1965 967 618 912 448 65 23 10 9 30
## 4 739 23 15 0 44 14 0 0 0 0 0
## 5 179 1729 797 997 634 97 20 78 49 75 75
## 6 319 1085 365 581 462 90 11 43 45 44 52
## C3T005 C3T006 C3T007 C3T008 C3T009 C3T010 C3T011 C3T012 C3T013 C3T014 C3T015
## 1 11 18 25 20 47 35 98 94 558 457 74
## 2 17 6 15 47 18 21 140 141 513 549 127
## 3 84 38 88 81 71 65 153 195 496 57 7
## 4 0 0 12 0 5 0 23 3 5 10 0
## 5 60 75 139 100 81 57 129 126 122 14 6
## 6 51 65 49 69 42 36 98 78 135 3 0
## C36001 C36002 C36003 C36004 C3501 C35001 GIS_ID CREATOR CREATED EDITOR
## 1 83 100 183 40 1494 25 Tract70Ply_1 NA NA NA
## 2 30 29 59 5 1624 15 Tract70Ply_2 NA NA NA
## 3 121 221 342 36 1407 45 Tract70Ply_3 NA NA NA
## 4 0 0 0 0 58 0 Tract70Ply_4 NA NA NA
## 5 721 279 1000 374 1186 218 Tract70Ply_5 NA NA NA
## 6 569 178 747 307 810 148 Tract70Ply_6 NA NA NA
## EDITED SHAPEAREA SHAPELEN
## 1 NA 0 0
## 2 NA 0 0
## 3 NA 0 0
## 4 NA 0 0
## 5 NA 0 0
## 6 NA 0 0dc.tracts.1980 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_1980.csv")
head(dc.tracts.1980)## OBJECTID NHGISST NHGISCTY GISJOIN GISJOIN2 SQMI CENSUS_YEAR
## 1 1 110 10 G11000100016 1.10001e+10 1.044000 1980
## 2 2 110 10 G11000100015 1.10001e+10 1.824130 1980
## 3 3 110 10 G11000100017 1.10001e+10 0.602730 1980
## 4 4 110 10 G1100010001801 1.10001e+12 0.193392 1980
## 5 5 110 10 G1100010002701 1.10001e+12 0.170549 1980
## 6 6 110 10 G11000100028 1.10001e+10 0.147531 1980
## STATE_NAME TRACT_NUMBER TRACT_NAME C7L001 C67001 C67002 C67003
## 1 District Of Columbia 16 Tract 16 5101 44 68 88
## 2 District Of Columbia 15 Tract 15 5579 43 109 110
## 3 District Of Columbia 17 Tract 17 6042 63 123 90
## 4 District Of Columbia 1801 Tract 18.01 724 0 0 0
## 5 District Of Columbia 2701 Tract 27.01 4575 54 96 62
## 6 District Of Columbia 28 Tract 28 6492 122 197 118
## C67004 C67005 C67006 C67007 C67008 C67009 C67010 C67011 C67012 C67013 C67014
## 1 46 56 186 317 94 97 98 115 78 68 75
## 2 64 62 239 350 79 86 68 73 47 36 42
## 3 60 58 198 327 92 89 112 111 108 88 101
## 4 0 1 3 2 0 0 1 1 52 101 64
## 5 34 37 103 132 37 32 35 37 46 74 137
## 6 79 45 208 289 78 69 88 98 74 120 113
## C67015 C67016 C67017 C67018 C67019 C67020 C67021 C67022 C67023 C67024 C67025
## 1 78 196 248 304 739 767 371 135 172 431 179
## 2 36 180 255 409 873 576 325 113 178 642 447
## 3 100 345 553 503 824 773 353 143 160 427 179
## 4 82 176 128 53 46 13 1 0 0 0 0
## 5 145 363 725 651 555 383 191 90 106 272 142
## 6 140 508 823 670 768 670 306 113 169 426 162
## C67026 C67027 C67028 C67029 C67030 C67031 C67032 C9C001 C9C002 C9C003 C9C004
## 1 51 1209 23.7 968 19.0 661 13.0 2415 47.3 2686 52.7
## 2 137 1283 23.0 1517 27.2 1226 22.0 2511 45.0 3068 55.0
## 3 62 1323 21.9 971 16.1 668 11.1 2782 46.0 3260 54.0
## 4 0 8 1.1 0 0.0 0 0.0 492 68.0 232 32.0
## 5 36 659 14.4 646 14.1 450 9.8 2185 47.8 2390 52.2
## 6 39 1391 21.4 909 14.0 627 9.7 3121 48.1 3371 51.9
## C9D001 C9D002 C9D003 C9D004 C9D005 C9D006 C9D007 C9D008 C9D009 C9D010 C9D011
## 1 1627 31.9 3373 66.1 8 0.2 43 0.8 50 1.0 81
## 2 4892 87.7 511 9.2 2 0.0 118 2.1 56 1.0 128
## 3 1057 17.5 4799 79.4 23 0.4 74 1.2 89 1.5 117
## 4 353 48.8 314 43.4 2 0.3 23 3.2 32 4.4 48
## 5 1799 39.3 2302 50.3 13 0.3 175 3.8 286 6.3 361
## 6 614 9.5 5293 81.5 12 0.2 78 1.2 495 7.6 786
## C9D012 DG6001 DG6002 C8Y001 DEG001 DEG002 DEG003 DEG004 DEG005 DEG006 C75001
## 1 1.6 4786 315 1738 1482 75 0 41 140 0 1696
## 2 2.3 5136 443 2259 1882 60 19 0 298 0 2186
## 3 1.9 5586 456 2410 885 497 21 26 973 8 2316
## 4 6.6 649 94 34 24 0 0 0 0 0 31
## 5 7.9 3817 758 2591 79 415 33 56 2008 0 2232
## 6 12.1 5069 1423 3336 36 386 78 58 2778 0 2930
## C7W001 C7W002 C7W003 C7W004 C7U01 C7U001 C7U002 C7U003 C7U004 C8A001 C8A002
## 1 1477 87.1 219 12.9 40 7 2 7 24 241 520
## 2 1811 82.8 375 17.2 73 15 20 6 32 550 719
## 3 1237 53.4 1079 46.6 94 15 45 0 34 714 631
## 4 3 9.7 28 90.3 3 0 3 0 0 24 2
## 5 464 20.8 1768 79.2 356 42 256 0 58 1140 551
## 6 329 11.2 2601 88.8 400 57 239 1 103 1376 715
## C8A003 C8A004 C8A005 C8A006 C8D001 DFK001 C8J001 C7N001 C7G001 C7G002 C7G003
## 1 362 309 158 106 3.01 0 132048 1369 1369 1132 2010
## 2 370 338 148 61 2.54 0 142802 1521 1521 1306 1757
## 3 380 300 123 168 2.61 171 69753 1461 1461 1000 2337
## 4 2 3 0 0 23.35 0 0 6 6 6 8
## 5 237 152 72 80 2.04 282 101866 732 732 456 1056
## 6 341 206 113 179 2.22 201 65152 1319 1319 613 2266
## C7G004 C7G005 C7G006 C7G007 C7G008 DHI001 DHI002 DHI003 DHI004 DHM001 DHM002
## 1 113 132 195 149 1 65 628 472 422 154 221
## 2 106 159 506 224 0 65 750 342 368 116 100
## 3 155 346 509 226 8 72 669 411 510 418 570
## 4 0 10 15 1 678 0 12 0 43 0 8
## 5 116 724 776 608 107 40 287 140 832 409 235
## 6 252 839 772 372 59 94 648 336 725 1250 711
## DHM003 DHM004 DHM005 DGZ01 DGZ02 DGZ03 DHX01 DHX02 DHX03 DHX04 DHX05 DIA001
## 1 662 647 1713 4585 318 36 0 2659 150 1267 5.3 6
## 2 582 633 2519 4895 435 52 5 2475 80 1868 3.1 25
## 3 1208 875 906 5313 454 87 89 3112 148 1648 4.5 8
## 4 121 65 68 590 153 11 723 8 0 0 0.0 0
## 5 673 527 1316 3587 779 169 7 2718 160 1115 5.6 0
## 6 1153 514 516 4720 1342 434 5 3058 245 1952 7.4 10
## DIA002 DIA003 DIA004 DIA005 DIA006 DIA007 DIA008 DIA009 DIA010 DIA011 DIA012
## 1 41 50 54 89 22 30 255 125 211 123 231
## 2 54 97 21 26 50 27 153 224 216 91 196
## 3 61 167 33 149 69 28 249 208 227 161 351
## 4 0 0 0 0 0 0 0 0 0 8 0
## 5 76 72 22 85 68 0 288 249 156 206 213
## 6 121 66 15 129 38 89 376 246 132 520 269
## DIA013 DIA014 DIA015 DIB001 DIB002 DIB003 DIB004 DIB005 DIB006 DHD001 DHD002
## 1 422 294 706 1616 705 176 13 82 67 1301 564
## 2 289 383 623 1700 552 103 8 79 33 1149 558
## 3 397 175 829 1016 1243 449 7 153 244 1222 693
## 4 0 0 0 0 0 8 0 0 0 76 9
## 5 226 373 684 1155 875 404 0 156 128 651 344
## 6 189 262 596 566 899 1077 24 133 359 655 338
## DHD003 DHD004 DHD005 DHD006 DHE001 DHE002 DHE003 DHE004 DHE005 DHE006 DHE007
## 1 638 75 32 21 41 74 214 330 603 1071 123
## 2 536 41 54 104 17 71 227 214 719 793 318
## 3 1042 194 5 8 0 153 310 294 669 1136 248
## 4 34 594 11 7 71 407 116 70 54 0 0
## 5 1407 156 58 43 88 129 132 356 597 770 197
## 6 1763 201 0 22 0 94 36 374 720 1114 397
## DHE008 DHV01 DHV02 DHV03 DHT01 DHT02 DID001 DID002 DID003 DID004 DID005
## 1 171 3415 245 7.2 4076 867 20 28 34 61 23
## 2 206 3213 125 3.9 4423 896 51 73 31 83 64
## 3 166 4329 355 8.2 4908 904 106 76 106 222 174
## 4 0 731 93 12.7 8 0 0 9 0 0 0
## 5 262 3568 184 5.2 3993 462 273 139 156 209 190
## 6 235 4621 438 9.5 5255 578 411 299 407 423 343
## DID006 DID007 DID008 DID009 DID010 DID011 DID012 DID013 DID014 DID015 DID016
## 1 41 44 46 61 50 44 54 146 107 243 452
## 2 55 102 102 74 42 40 30 126 157 343 534
## 3 150 191 139 130 140 105 55 250 110 177 161
## 4 0 0 0 0 0 0 0 5 0 0 0
## 5 251 173 64 66 95 78 96 59 41 177 133
## 6 239 158 133 112 94 50 32 87 29 42 14
## DID017 DIE001 DIK001 DIK002 DIK003 DIK004 DIK005 DIK006 DIK007 DIK008 DIK009
## 1 235 43519 14 8 6 12 5 27 12 26 48
## 2 268 41676 8 26 0 0 33 9 45 53 28
## 3 27 19919 55 30 25 97 102 55 98 85 74
## 4 0 4444 0 0 0 0 0 0 0 0 0
## 5 40 14024 24 32 35 87 49 64 26 49 28
## 6 30 9477 106 83 198 161 187 123 75 52 66
## DIK010 DIK011 DIK012 DIK013 DIK014 DIK015 DIK016 DIK017 DIL001 DFD001 DFG001
## 1 33 44 31 144 83 221 435 221 48688 151 513
## 2 36 33 6 119 114 294 485 237 48605 263 822
## 3 99 92 51 203 115 160 135 26 25842 460 1079
## 4 0 0 0 5 0 0 0 0 32500 0 19
## 5 34 42 25 25 23 82 87 21 20045 1076 817
## 6 55 32 42 54 20 35 13 11 11451 1818 876
## DFG002 DFG003 DI8001 DI8002 DI8003 DI8004 GIS_ID CREATOR CREATED EDITOR
## 1 667 365 4933 162 49 20 Tract80Ply_1 NA NA NA
## 2 895 206 5403 168 0 23 Tract80Ply_2 NA NA NA
## 3 595 182 5487 499 102 95 Tract80Ply_3 NA NA NA
## 4 0 0 25 9 0 0 Tract80Ply_4 NA NA NA
## 5 286 53 3621 941 137 77 Tract80Ply_5 NA NA NA
## 6 188 48 4886 1563 324 246 Tract80Ply_6 NA NA NA
## EDITED SHAPEAREA SHAPELEN
## 1 NA 0 0
## 2 NA 0 0
## 3 NA 0 0
## 4 NA 0 0
## 5 NA 0 0
## 6 NA 0 0Data for the year 1990 was not available.
dc.tracts.2000 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_2000.csv")
head(dc.tracts.2000)## OBJECTID FEDTRACTNO TRACTNO AREASQMI POPDENSITY TOTAL NAME
## 1 1 18.04 18.4 0.23232 17889.12 4156 2000 Tract 18.04
## 2 2 92.04 92.4 0.10855 21391.06 2322 2000 Tract 92.04
## 3 3 40.01 40.1 0.10548 32935.15 3474 2000 Tract 40.01
## 4 4 3.00 3.0 0.40656 14034.83 5706 2000 Tract 3
## 5 5 37.00 37.0 0.11311 44116.35 4990 2000 Tract 37
## 6 6 33.01 33.1 0.16974 15947.92 2707 2000 Tract 33.01
## FULLTOTAL AGE0_17 AGE0_17PCT AGE18PLUS AGE18PLUSP CHTOTAL CHWHITE CHBLACK
## 1 1774 932 0.22425 3224 0.77574 -81 208 -697
## 2 1089 627 0.27002 1695 0.72997 -107 10 -144
## 3 2346 163 0.04691 3311 0.95308 449 353 19
## 4 2784 489 0.08569 5217 0.91430 -32 -161 3
## 5 1792 1163 0.23306 3827 0.76693 -450 679 -1084
## 6 1030 547 0.20206 2160 0.79793 -394 -12 -375
## CHAMERIND CHASIAN CHHISP CHOTHER TOTALPERC TOTAL90 TOTAL00 TOTPOPCHG
## 1 11 43 541 527 -1.912 4237 4156 -81
## 2 11 6 57 30 -4.405 2429 2322 -107
## 3 12 105 -23 40 14.843 3025 3474 449
## 4 20 191 40 74 -0.558 5738 5706 -32
## 5 22 60 437 53 -8.272 5440 4990 -450
## 6 12 13 32 29 -12.706 3101 2707 -394
## TOTPOPCHGP WHITE BLACK AMERIND ASIAN HAWAIIAN OTHER HISPANIC OCCUPIEDHO
## 1 -0.01911 95 2897 3 35 1 16 1003 578
## 2 -0.04405 29 2163 7 8 0 0 101 126
## 3 0.14842 2779 171 6 151 2 13 289 1028
## 4 -0.00557 4727 170 7 327 2 17 324 1331
## 5 -0.08272 428 2729 13 93 0 20 1629 161
## 6 -0.12705 154 2400 2 14 0 6 84 647
## PCTOWNEROC TRACT90 COMMENT_ MRDCHREL MRDCHRELNO MHHCHREL MHHCHRELNO
## 1 0.32581 18.4 210 284 44 71
## 2 0.11570 92.4 60 81 22 21
## 3 0.43819 40.1 85 335 7 10
## 4 0.47808 3.1 Number Change 261 506 12 35
## 5 0.08984 37.0 174 138 41 76
## 6 0.62815 33.1 77 125 19 51
## FMHHCHREL FMHHCHRELN MARRIED TOTHOUSEUN SINGLEFAMI MULTIUNIT CONSTRCOST
## 1 182 211 494 0 0 0 0
## 2 173 114 141 0 0 0 0
## 3 26 26 420 0 0 0 0
## 4 52 67 767 1 1 0 188876
## 5 309 140 312 0 0 0 0
## 6 86 150 202 0 0 0 0
## SINGLECOST MULTICOST MULTIPERSO SINGLEPERS FAGI_TOTAL_2005 FAGI_MEAN_2005
## 1 0 0 128 644 69985531 35168.61
## 2 0 0 81 537 18104527 27265.85
## 3 0 0 368 1489 186187073 100424.53
## 4 188876 0 674 1177 269137973 104560.21
## 5 0 0 220 694 64438008 36099.72
## 6 0 0 166 356 55946734 50814.47
## FAGI_MEDIAN_2005 DCGIS_TRACT00PLY_AREA DCGIS_TRACT00PLY_LEN FAGI_TOTAL_2006
## 1 26205.5 0 0 65111551
## 2 22258.5 0 0 16019683
## 3 59553.5 0 0 178056584
## 4 52394.0 0 0 271067501
## 5 26428.0 0 0 58389340
## 6 36331.0 0 0 53007004
## FAGI_MEDIAN_2006 GIS_ID CREATOR CREATED EDITOR EDITED SHAPEAREA
## 1 29408.0 Tract00Ply_1 NA NA NA NA 0
## 2 26279.0 Tract00Ply_3 NA NA NA NA 0
## 3 72633.5 Tract00Ply_4 NA NA NA NA 0
## 4 64574.0 Tract00Ply_5 NA NA NA NA 0
## 5 30778.5 Tract00Ply_69 NA NA NA NA 0
## 6 44326.0 Tract00Ply_70 NA NA NA NA 0
## SHAPELEN
## 1 0
## 2 0
## 3 0
## 4 0
## 5 0
## 6 0dc.tracts.2010 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_2010.csv")
head(dc.tracts.2010)## OBJECTID TRACT GEOID P0010001 P0010002 P0010003 P0010004 P0010005
## 1 1 2102 11001002102 4648 4523 398 3583 15
## 2 2 9508 11001009508 3290 3240 257 2821 11
## 3 3 1200 11001001200 5008 4850 4073 272 18
## 4 4 9503 11001009503 2910 2810 432 2301 4
## 5 5 9501 11001009501 5797 5595 2128 2827 36
## 6 6 9509 11001009509 2940 2888 165 2592 5
## P0010006 P0010007 P0010008 OP000001 OP000002 OP000003 OP000004 P0020002
## 1 27 0 500 110 47 15 3 724
## 2 30 0 121 38 24 11 2 235
## 3 388 3 96 57 23 76 5 399
## 4 41 0 32 84 50 22 4 113
## 5 108 10 486 99 49 58 15 831
## 6 33 0 93 48 7 14 3 169
## P0020005 P0020006 P0020007 P0020008 P0020009 P0020010 OP00005 OP00006 OP00007
## 1 278 3512 12 27 0 13 76 37 8
## 2 182 2793 6 29 0 3 36 22 11
## 3 3805 263 9 385 3 14 46 22 73
## 4 377 2276 3 41 0 7 79 48 21
## 5 1926 2778 21 102 5 9 78 42 54
## 6 124 2565 2 33 0 13 33 4 8
## OP00008 P0030001 P0030003 P0030004 P0030005 P0030006 P0030007 P0030008
## 1 3 3652 334 2881 7 23 0 322
## 2 1 2785 227 2394 7 27 0 90
## 3 4 4338 3531 239 15 355 3 79
## 4 4 2433 384 1917 4 36 0 22
## 5 12 5099 2093 2351 27 105 8 347
## 6 3 2400 142 2126 4 30 0 66
## OP00009 OP00010 OP00011 OP00012 P0040002 P0040005 P0040006 P0040007 P0040008
## 1 73 35 12 3 476 252 2834 6 23
## 2 30 22 7 2 171 170 2376 5 26
## 3 47 21 51 4 350 3293 230 7 352
## 4 59 42 11 4 83 342 1898 3 36
## 5 73 43 55 12 636 1916 2311 19 99
## 6 29 6 10 3 116 112 2114 2 30
## P0040009 P0040010 OP000013 OP000014 OP000015 OP000016 H0010001 H0010002
## 1 0 4 51 28 7 3 2173 1900
## 2 0 3 28 20 7 1 1742 1578
## 3 3 8 38 21 48 3 2633 2516
## 4 0 6 56 40 10 4 1256 1200
## 5 3 9 59 36 51 9 1954 1802
## 6 0 5 20 4 7 3 1320 1258
## H0010003 ACRES SQ_MILES FAGI_TOTAL_2010 FAGI_MEDIAN_2010 FAGI_TOTAL_2011
## 1 273 179.3649 0.2802576 92766960 32803 103545279
## 2 164 231.9180 0.3623719 67315109 38902 70488991
## 3 117 300.9976 0.4703087 284024809 79665 315822137
## 4 56 351.7481 0.5496064 103688476 55760 91164685
## 5 152 393.9403 0.6155317 54810127 28094 60953895
## 6 62 159.5540 0.2493031 75556930 44708 78005645
## FAGI_MEDIAN_2011 FAGI_TOTAL_2012 FAGI_MEDIAN_2012 FAGI_TOTAL_2013
## 1 33094.0 107590365 34640.0 113649527
## 2 37979.0 74847040 37529.0 74438514
## 3 74448.0 334717360 75515.0 304763968
## 4 52882.0 103746641 55310.5 93340693
## 5 28147.0 64279289 27023.0 66633720
## 6 45617.5 80688699 44771.0 83396856
## FAGI_MEDIAN_2013 FAGI_TOTAL_2014 FAGI_MEDIAN_2014 FAGI_TOTAL_2015
## 1 33861.5 119845798 36433.5 130031411
## 2 36844.0 76756174 38133.5 82172651
## 3 74166.5 314255746 91068.5 340349324
## 4 55128.0 108517270 56626.5 113767916
## 5 28334.0 62507128 27422.5 71687637
## 6 45890.0 90266682 48269.0 94453371
## FAGI_MEDIAN_2015 GIS_ID CREATOR CREATED EDITOR EDITED SHAPEAREA SHAPELEN
## 1 38248.0 TractPly_1 NA NA NA NA 0 0
## 2 38670.5 TractPly_2 NA NA NA NA 0 0
## 3 89304.0 TractPly_3 NA NA NA NA 0 0
## 4 60025.0 TractPly_4 NA NA NA NA 0 0
## 5 29720.5 TractPly_5 NA NA NA NA 0 0
## 6 50505.0 TractPly_6 NA NA NA NA 0 0dc.tracts.2020 <- read.csv("../data/dc_historical_tracts/Census_Tracts_in_2020.csv")
head(dc.tracts.2020)## TRACT GEOID P0010001 P0010002 P0010003 P0010004 P0010005 P0010006
## 1 2002 1.1001e+10 4072 3647 1116 1751 27 84
## 2 2101 1.1001e+10 5687 5071 1037 2642 86 120
## 3 2102 1.1001e+10 5099 4599 901 2910 50 87
## 4 2201 1.1001e+10 3485 3138 973 1722 21 94
## 5 2202 1.1001e+10 3339 2957 619 1636 48 57
## 6 101 1.1001e+10 1406 1259 1083 47 5 92
## P0010007 P0010008 P0020002 P0020005 P0020006 P0020007 P0020008 P0020009
## 1 0 669 1022 1033 1722 4 83 0
## 2 1 1185 1868 885 2586 20 115 1
## 3 0 651 1074 805 2856 14 83 0
## 4 2 326 683 864 1687 3 85 2
## 5 3 594 1003 548 1594 8 54 0
## 6 1 31 140 1054 47 4 90 1
## P0020010 P0030001 P0030003 P0030004 P0030005 P0030006 P0030007 P0030008
## 1 21 3198 855 1505 24 71 0 470
## 2 39 4375 827 2149 58 100 1 816
## 3 40 3984 741 2340 44 79 0 433
## 4 14 2755 742 1444 13 75 2 248
## 5 22 2556 496 1310 38 57 3 393
## 6 3 1288 1005 39 2 90 1 27
## P0040002 P0040005 P0040006 P0040007 P0040008 P0040009 P0040010 H0010001
## 1 701 805 1490 4 70 0 8 1532
## 2 1277 731 2110 16 95 1 25 2335
## 3 735 674 2300 13 75 0 28 2221
## 4 485 671 1427 1 73 2 11 1229
## 5 672 452 1285 8 54 0 17 1454
## 6 123 977 39 2 88 1 3 999
## H0010002 H0010003 ALAND AWATER STUSAB SUMLEV GEOCODE STATE
## 1 1394 138 849376 0 DC 140 1.1001e+10 11
## 2 2107 228 600992 0 DC 140 1.1001e+10 11
## 3 1959 262 725975 0 DC 140 1.1001e+10 11
## 4 1141 88 415173 0 DC 140 1.1001e+10 11
## 5 1273 181 698895 566 DC 140 1.1001e+10 11
## 6 865 134 199776 5261 DC 140 1.1001e+10 11
## NAME POP100 HU100 P0010009 P0010010 P0010011 P0010012 P0010013
## 1 Census Tract 20.02 4072 1532 425 392 61 33 38
## 2 Census Tract 21.01 5687 2335 616 572 42 11 37
## 3 Census Tract 21.02 5099 2221 500 451 69 11 41
## 4 Census Tract 22.01 3485 1229 347 310 40 8 50
## 5 Census Tract 22.02 3339 1454 382 356 44 8 21
## 6 Census Tract 1.01 1406 999 147 135 17 8 22
## P0010014 P0010015 P0010016 P0010017 P0010018 P0010019 P0010020 P0010021
## 1 0 183 15 13 4 38 0 0
## 2 0 339 30 19 0 68 0 0
## 3 2 189 23 9 0 73 2 0
## 4 0 165 4 1 0 37 0 0
## 5 0 212 13 5 3 38 0 0
## 6 2 86 0 0 0 0 0 0
## P0010022 P0010023 P0010024 P0010025 P0010026 P0010027 P0010028 P0010029
## 1 0 1 4 2 32 19 1 0
## 2 23 2 1 0 41 10 4 0
## 3 27 1 2 2 41 6 6 0
## 4 1 2 2 0 33 6 0 0
## 5 12 0 0 0 14 2 5 0
## 6 0 0 0 0 11 2 1 1
## P0010030 P0010031 P0010032 P0010033 P0010034 P0010035 P0010036 P0010037
## 1 2 0 0 7 0 1 0 2
## 2 4 1 0 17 0 4 0 0
## 3 12 0 0 14 1 2 0 0
## 4 6 0 0 10 1 3 0 0
## 5 1 1 0 2 0 0 0 0
## 6 0 0 0 4 1 1 0 0
## P0010038 P0010039 P0010040 P0010041 P0010042 P0010043 P0010044 P0010045
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 1 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 3 0 0 1 0 0 0
## 5 0 3 0 0 0 0 0 0
## 6 0 0 0 1 0 0 0 0
## P0010046 P0010047 P0010048 P0010049 P0010050 P0010051 P0010052 P0010053
## 1 0 1 0 0 0 0 0 0
## 2 0 3 1 0 1 0 0 0
## 3 0 8 6 0 2 0 0 0
## 4 3 3 0 0 3 0 0 0
## 5 0 12 1 0 11 0 0 0
## 6 0 1 0 0 1 0 0 0
## P0010054 P0010055 P0010056 P0010057 P0010058 P0010059 P0010060 P0010061
## 1 0 0 0 0 0 1 0 0
## 2 0 0 0 1 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0010062 P0010063 P0010064 P0010065 P0010066 P0010067 P0010068 P0010069
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 1 1 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0010070 P0010071 P0020001 P0020003 P0020004 P0020011 P0020012 P0020013
## 1 0 0 4072 3050 2863 187 169 59
## 2 0 0 5687 3819 3646 173 160 39
## 3 0 0 5099 4025 3798 227 197 66
## 4 0 0 3485 2802 2655 147 131 40
## 5 0 0 3339 2336 2226 110 100 41
## 6 0 0 1406 1266 1199 67 61 16
## P0020014 P0020015 P0020016 P0020017 P0020018 P0020019 P0020020 P0020021
## 1 9 36 0 16 15 13 4 16
## 2 8 35 0 11 29 14 0 22
## 3 4 39 2 16 23 9 0 33
## 4 3 49 0 18 4 1 0 12
## 5 2 21 0 6 13 3 3 9
## 6 5 22 1 17 0 0 0 0
## P0020022 P0020023 P0020024 P0020025 P0020026 P0020027 P0020028 P0020029
## 1 0 0 0 1 0 0 18 14
## 2 0 0 0 2 0 0 13 6
## 3 2 0 0 1 2 0 23 6
## 4 0 0 0 2 2 0 15 6
## 5 0 0 2 0 0 0 8 1
## 6 0 0 0 0 0 0 5 2
## P0020030 P0020031 P0020032 P0020033 P0020034 P0020035 P0020036 P0020037
## 1 1 0 0 0 0 1 0 0
## 2 4 0 1 0 0 0 0 1
## 3 6 0 10 0 0 0 1 0
## 4 0 0 5 0 0 0 1 2
## 5 5 0 1 1 0 0 0 0
## 6 1 1 0 0 0 0 1 0
## P0020038 P0020039 P0020040 P0020041 P0020042 P0020043 P0020044 P0020045
## 1 0 2 0 0 0 0 0 0
## 2 0 0 0 0 0 0 1 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 1 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0020046 P0020047 P0020048 P0020049 P0020050 P0020051 P0020052 P0020053
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 7 5 0 2 0
## 4 0 0 0 1 0 0 1 0
## 5 0 0 0 2 1 0 1 0
## 6 0 0 0 1 0 0 1 0
## P0020054 P0020055 P0020056 P0020057 P0020058 P0020059 P0020060 P0020061
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0020062 P0020063 P0020064 P0020065 P0020066 P0020067 P0020068 P0020069
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0020070 P0020071 P0020072 P0020073 P0030002 P0030009 P0030010 P0030011
## 1 0 0 0 0 2925 273 245 36
## 2 0 0 0 0 3951 424 392 23
## 3 0 0 0 0 3637 347 307 38
## 4 0 0 0 0 2524 231 201 17
## 5 0 0 0 0 2297 259 242 23
## 6 0 0 0 0 1164 124 116 17
## P0030012 P0030013 P0030014 P0030015 P0030016 P0030017 P0030018 P0030019
## 1 15 17 0 124 8 6 4 28
## 2 7 21 0 238 18 14 0 57
## 3 10 27 2 124 17 5 0 56
## 4 7 23 0 122 0 1 0 26
## 5 4 14 0 142 9 2 3 33
## 6 8 11 2 78 0 0 0 0
## P0030020 P0030021 P0030022 P0030023 P0030024 P0030025 P0030026 P0030027
## 1 0 0 0 1 4 2 27 16
## 2 0 0 11 2 1 0 30 8
## 3 2 0 22 0 2 2 32 6
## 4 0 0 1 2 2 0 26 6
## 5 0 0 12 0 0 0 7 1
## 6 0 0 0 0 0 0 8 2
## P0030028 P0030029 P0030030 P0030031 P0030032 P0030033 P0030034 P0030035
## 1 1 0 0 0 0 7 0 1
## 2 4 0 1 0 0 16 0 1
## 3 5 0 11 0 0 7 1 2
## 4 0 0 5 0 0 10 1 1
## 5 0 0 0 1 0 2 0 0
## 6 1 1 0 0 0 3 1 0
## P0030036 P0030037 P0030038 P0030039 P0030040 P0030041 P0030042 P0030043
## 1 0 2 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0
## 5 0 0 0 3 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0030044 P0030045 P0030046 P0030047 P0030048 P0030049 P0030050 P0030051
## 1 0 0 0 1 0 0 0 0
## 2 0 0 0 2 0 0 1 0
## 3 0 0 0 8 6 0 2 0
## 4 0 0 3 3 0 0 3 0
## 5 0 0 0 10 0 0 10 0
## 6 0 0 0 0 0 0 0 0
## P0030052 P0030053 P0030054 P0030055 P0030056 P0030057 P0030058 P0030059
## 1 0 0 0 0 0 0 0 1
## 2 0 0 0 0 0 1 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0030060 P0030061 P0030062 P0030063 P0030064 P0030065 P0030066 P0030067
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 1 1 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0030068 P0030069 P0030070 P0030071 P0040001 P0040003 P0040004 P0040011
## 1 0 0 0 0 3198 2497 2377 120
## 2 0 0 0 0 4375 3098 2978 120
## 3 0 0 0 0 3984 3249 3090 159
## 4 0 0 0 0 2755 2270 2185 85
## 5 0 0 0 0 2556 1884 1816 68
## 6 0 0 0 0 1288 1165 1110 55
## P0040012 P0040013 P0040014 P0040015 P0040016 P0040017 P0040018 P0040019
## 1 105 36 5 17 0 16 8 6
## 2 109 23 5 20 0 11 17 14
## 3 130 38 4 27 2 9 17 5
## 4 71 17 3 22 0 15 0 1
## 5 66 23 2 14 0 6 9 0
## 6 50 16 5 11 1 17 0 0
## P0040020 P0040021 P0040022 P0040023 P0040024 P0040025 P0040026 P0040027
## 1 4 12 0 0 0 1 0 0
## 2 0 17 0 0 0 2 0 0
## 3 0 24 2 0 0 0 2 0
## 4 0 9 0 0 0 2 2 0
## 5 3 7 0 0 2 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0040028 P0040029 P0040030 P0040031 P0040032 P0040033 P0040034 P0040035
## 1 15 11 1 0 0 0 0 1
## 2 11 5 4 0 1 0 0 0
## 3 22 6 5 0 10 0 0 0
## 4 13 6 0 0 5 0 0 0
## 5 1 0 0 0 0 1 0 0
## 6 5 2 1 1 0 0 0 0
## P0040036 P0040037 P0040038 P0040039 P0040040 P0040041 P0040042 P0040043
## 1 0 0 0 2 0 0 0 0
## 2 0 1 0 0 0 0 0 0
## 3 1 0 0 0 0 0 0 0
## 4 1 1 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 1 0 0 0 0 0 0 0
## P0040044 P0040045 P0040046 P0040047 P0040048 P0040049 P0040050 P0040051
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 7 5 0
## 4 0 0 0 0 0 1 0 0
## 5 0 0 0 0 0 1 0 0
## 6 0 0 0 0 0 0 0 0
## P0040052 P0040053 P0040054 P0040055 P0040056 P0040057 P0040058 P0040059
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 2 0 0 0 0 0 0 0
## 4 1 0 0 0 0 0 0 0
## 5 1 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0040060 P0040061 P0040062 P0040063 P0040064 P0040065 P0040066 P0040067
## 1 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0
## P0040068 P0040069 P0040070 P0040071 P0040072 P0040073 P0050001 P0050002
## 1 0 0 0 0 0 0 32 0
## 2 0 0 0 0 0 0 31 0
## 3 0 0 0 0 0 0 145 0
## 4 0 0 0 0 0 0 6 6
## 5 0 0 0 0 0 0 4 0
## 6 0 0 0 0 0 0 0 0
## P0050003 P0050004 P0050005 P0050006 P0050007 P0050008 P0050009 P0050010
## 1 0 0 0 0 32 0 0 32
## 2 0 0 0 0 31 0 0 31
## 3 0 0 0 0 145 0 0 145
## 4 0 6 0 0 0 0 0 0
## 5 0 0 0 0 4 0 0 4
## 6 0 0 0 0 0 0 0 0
## OBJECTID SHAPEAREA SHAPELEN
## 1 1 0 0
## 2 2 0 0
## 3 3 0 0
## 4 4 0 0
## 5 5 0 0
## 6 6 0 0