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

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

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
);