urbanization-index: urbanization-census-tract.csv

Table actions

This table contains the data behind the story How Urban Or Rural Is Your State? And What Does That Mean For The 2020 Election?

urbanization-state.csv contains FiveThirtyEight's urbanization index for every state. This number is calculated as the natural logarithm of the average number of people living within a five-mile radius of a given resident in each census tract in that state.

urbanization-census-tract.csv contains FiveThirtyEight's urbanization index for every census tract.

Column Description
statefips FIPS code for each state
state Name of state
gisjoin Geographic Identifier for the census tract from the 2010 census
lat_tract Latitude of the center of the census tract
long_tract Longitude of the center of the census tract
population Number of people living in the census tract according to 5-year American Community Survey data from 2017
adj_radiuspop_5 Estimate of the number of people within a 5-mile radius of a census tract. For a census tract that is more than 5 miles away any other census tract (centroid to centroid), this number is decreased based on the minimum distance to the nearest census tract
urbanindex A calculation of how urban or rural a given area is; calculated as the natural logarithm of adj_radiuspop_5

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

73,280 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ statefips state gisjoin lat_tract long_tract population adj_radiuspop_5 urbanindex
1 1 1 Alabama G0100010020100 32.47718 -86.49007 1845 44076.0 10.69367
2 2 1 Alabama G0100010020200 32.47425 -86.47337 2172 43008.0 10.66914
3 3 1 Alabama G0100010020300 32.47543 -86.46019 3385 38987.0 10.57098
4 4 1 Alabama G0100010020400 32.472 -86.44363 4267 43131.0 10.672
5 5 1 Alabama G0100010020500 32.45883 -86.42266 9965 43131.0 10.672
6 6 1 Alabama G0100010020600 32.44254 -86.47874 3620 34588.0 10.45126
7 7 1 Alabama G0100010020700 32.42722 -86.44111 3420 35819.0 10.48623
8 8 1 Alabama G0100010020801 32.41334 -86.526 2913 8466.0 9.043814
9 9 1 Alabama G0100010020802 32.53476 -86.51258 11333 7018.0 8.856234
10 10 1 Alabama G0100010020900 32.64296 -86.52377 6167 1332.457 7.194779
11 11 1 Alabama G0100010021000 32.60894 -86.75631 2796 660.4769 6.492962
12 12 1 Alabama G0100010021100 32.45603 -86.73222 3153 660.4769 6.492962
13 13 1 Alabama G0100030010100 31.11277 -87.78622 3988 425.6363 6.053585
14 14 1 Alabama G0100030010200 30.94277 -87.68169 3259 1937.661 7.569237
15 15 1 Alabama G0100030010300 30.83641 -87.86559 9056 2187.826 7.690664
16 16 1 Alabama G0100030010400 30.71634 -87.61627 4810 664.1141 6.498454
17 17 1 Alabama G0100030010500 30.89814 -87.77287 5038 6419.0 8.767017
18 18 1 Alabama G0100030010600 30.84935 -87.76804 3418 11457.0 9.346356
19 19 1 Alabama G0100030010701 30.73802 -87.94836 8068 2300.371 7.740826
20 20 1 Alabama G0100030010703 30.64168 -87.83762 17748 31775.0 10.36644
21 21 1 Alabama G0100030010704 30.64807 -87.88297 5883 43835.0 10.68819
22 22 1 Alabama G0100030010705 30.63121 -87.89408 9704 43835.0 10.68819
23 23 1 Alabama G0100030010800 30.5941 -87.89883 7499 48971.0 10.79898
24 24 1 Alabama G0100030010903 30.60644 -87.77778 5688 20749.0 9.940253
25 25 1 Alabama G0100030010904 30.56635 -87.57658 6342 1726.328 7.453752
26 26 1 Alabama G0100030010905 30.53607 -87.75676 8009 8474.0 9.044758
27 27 1 Alabama G0100030010906 30.56411 -87.68736 5473 16483.0 9.710085
28 28 1 Alabama G0100030011000 30.49075 -87.68093 4072 9335.0 9.141526
29 29 1 Alabama G0100030011101 30.52315 -87.84189 10485 18612.0 9.831562
30 30 1 Alabama G0100030011102 30.47419 -87.84103 4296 28671.0 10.26364
31 31 1 Alabama G0100030011201 30.53859 -87.88712 5136 27164.0 10.20965
32 32 1 Alabama G0100030011202 30.50448 -87.90434 6179 29097.0 10.27839
33 33 1 Alabama G0100030011300 30.43409 -87.87724 4710 7297.0 8.895219
34 34 1 Alabama G0100030011401 30.38245 -87.76666 10180 2210.915 7.701162
35 35 1 Alabama G0100030011403 30.31725 -87.6667 10050 18133.0 9.805489
36 36 1 Alabama G0100030011405 30.29111 -87.53783 4386 2169.485 7.682245
37 37 1 Alabama G0100030011406 30.27341 -87.63423 3331 13051.0 9.47662
38 38 1 Alabama G0100030011407 30.25334 -87.75371 5123 1615.196 7.387212
39 39 1 Alabama G0100030011408 30.23766 -87.91702 708 779.9971 6.65929
40 40 1 Alabama G0100030011501 30.431 -87.68128 6334 18874.0 9.845541
41 41 1 Alabama G0100030011502 30.38069 -87.66895 11801 31186.0 10.34772
42 42 1 Alabama G0100030011601 30.41511 -87.55853 7131 2156.127 7.676069
43 43 1 Alabama G0100030011602 30.41795 -87.45958 5455 6252.0 8.740657
44 44 1 Alabama G0100050950100 32.04077 -85.24 3071 1569.777 7.358689
45 45 1 Alabama G0100050950200 31.9204 -85.45376 4291 637.8283 6.458069
46 46 1 Alabama G0100050950300 31.80016 -85.57256 1813 972.854 6.880234
47 47 1 Alabama G0100050950400 31.67312 -85.56811 3721 972.854 6.880234
48 48 1 Alabama G0100050950500 31.77363 -85.28558 3365 1421.959 7.259791
49 49 1 Alabama G0100050950600 31.87747 -85.26624 2120 4776.0 8.471358
50 50 1 Alabama G0100050950700 31.94257 -85.26261 1775 6896.0 8.838696
51 51 1 Alabama G0100050950800 31.91231 -85.1694 2157 6889.0 8.837681
52 52 1 Alabama G0100050950900 31.85276 -85.15821 3888 9046.0 9.110078
53 53 1 Alabama G0100070010001 33.08372 -87.17618 2643 1180.748 7.073903
54 54 1 Alabama G0100070010002 33.1774 -87.09578 6201 1327.337 7.19093
55 55 1 Alabama G0100070010003 32.96144 -87.00937 5032 597.762 6.393193
56 56 1 Alabama G0100070010004 32.94538 -87.27499 8704 604.4114 6.404255
57 57 1 Alabama G0100090050101 33.87502 -86.46404 7532 2570.81 7.851976
58 58 1 Alabama G0100090050102 33.9532 -86.4654 7285 2570.81 7.851976
59 59 1 Alabama G0100090050200 33.99907 -86.544 3572 2473.796 7.813509
60 60 1 Alabama G0100090050300 34.0758 -86.3909 4937 1331.509 7.194068
61 61 1 Alabama G0100090050400 34.16515 -86.48807 4637 1087.352 6.991501
62 62 1 Alabama G0100090050500 34.03273 -86.63589 7526 2266.201 7.72586
63 63 1 Alabama G0100090050601 33.86888 -86.89559 4146 10158.0 9.226017
64 64 1 Alabama G0100090050602 33.90698 -86.77242 9317 1437.253 7.270489
65 65 1 Alabama G0100090050700 33.84809 -86.6435 8715 1516.092 7.323891
66 66 1 Alabama G0100110952100 32.10967 -85.52205 1488 598.3858 6.394236
67 67 1 Alabama G0100110952200 32.15463 -85.70591 5608 883.1474 6.783492
68 68 1 Alabama G0100110952500 32.06815 -85.82582 3382 883.1474 6.783492
69 69 1 Alabama G0100130952700 31.90332 -86.58842 2089 2883.316 7.966696
70 70 1 Alabama G0100130952800 31.83773 -86.62832 1284 8436.0 9.040263
71 71 1 Alabama G0100130952900 31.84835 -86.67632 2351 9720.0 9.181941
72 72 1 Alabama G0100130953000 31.87619 -86.79442 1523 1450.231 7.279479
73 73 1 Alabama G0100130953100 31.79658 -86.65336 3084 6636.0 8.800264
74 74 1 Alabama G0100130953200 31.77762 -86.52411 3957 1371.905 7.223956
75 75 1 Alabama G0100130953300 31.71867 -86.74747 1869 1259.958 7.138834
76 76 1 Alabama G0100130953400 31.60538 -86.80727 2695 1018.844 6.926424
77 77 1 Alabama G0100130953500 31.57846 -86.61581 1274 575.2166 6.354747
78 78 1 Alabama G0100150000200 33.67378 -85.81657 2488 44007.0 10.6921
79 79 1 Alabama G0100150000300 33.67639 -85.83154 2579 46495.0 10.7471
80 80 1 Alabama G0100150000400 33.67729 -85.85847 2810 44686.0 10.70742
81 81 1 Alabama G0100150000500 33.66263 -85.8452 1275 50651.0 10.83271
82 82 1 Alabama G0100150000600 33.64285 -85.84158 2005 48044.0 10.77987
83 83 1 Alabama G0100150000700 33.70848 -85.79171 2832 33871.0 10.43031
84 84 1 Alabama G0100150000800 33.64547 -85.82706 1197 50876.0 10.83715
85 85 1 Alabama G0100150000900 33.64793 -85.79314 3665 40159.0 10.6006
86 86 1 Alabama G0100150001000 33.63021 -85.78615 5965 32405.0 10.38607
87 87 1 Alabama G0100150001100 33.59142 -85.78589 7046 26063.0 10.16827
88 88 1 Alabama G0100150001201 33.6107 -85.84956 3184 49477.0 10.80926
89 89 1 Alabama G0100150001202 33.60906 -85.88011 4156 27734.0 10.23041
90 90 1 Alabama G0100150001300 33.64396 -85.87331 2112 35033.0 10.46405
91 91 1 Alabama G0100150001400 33.66168 -85.89824 3053 36594.0 10.50764
92 92 1 Alabama G0100150001500 33.62231 -85.96935 5218 11280.0 9.330787
93 93 1 Alabama G0100150001600 33.70496 -85.85986 3508 30173.0 10.3147
94 94 1 Alabama G0100150001700 33.72823 -85.84659 6821 31841.0 10.36851
95 95 1 Alabama G0100150001800 33.76315 -85.78949 6527 26206.0 10.17374
96 96 1 Alabama G0100150002000 33.73687 -85.67775 6962 1908.777 7.554218
97 97 1 Alabama G0100150002101 33.83821 -85.77185 3621 17886.0 9.791774
98 98 1 Alabama G0100150002102 33.83635 -85.73773 3208 21507.0 9.976133
99 99 1 Alabama G0100150002103 33.79745 -85.75901 7025 23382.0 10.05972
100 100 1 Alabama G0100150002200 33.89867 -85.60645 3378 6541.0 8.785846

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "urbanization-index/urbanization-census-tract" (
"statefips" INTEGER,
  "state" TEXT,
  "gisjoin" TEXT,
  "lat_tract" REAL,
  "long_tract" REAL,
  "population" INTEGER,
  "adj_radiuspop_5" REAL,
  "urbanindex" REAL
);