urbanization-index: urbanization-state.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

56 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ state urbanindex
1 1 Alabama 9.605935
2 2 Alaska 8.735964
3 3 American Samoa 11.08593
4 4 Arizona 11.29971
5 5 Arkansas 9.259444
6 6 California 12.19028
7 7 Colorado 11.15445
8 8 Connecticut 11.40968
9 9 Delaware 11.00999
10 10 District of Columbia 13.44057
11 11 Florida 11.46484
12 12 Georgia 10.55233
13 13 Guam 11.08593
14 14 Hawaii 11.08621
15 15 Idaho 9.593634
16 16 Illinois 11.62372
17 17 Indiana 10.4105
18 18 Iowa 9.593525
19 19 Kansas 10.12044
20 20 Kentucky 9.789536
21 21 Louisiana 10.17518
22 22 Maine 9.037091
23 23 Maryland 11.71105
24 24 Massachusetts 11.83973
25 25 Michigan 10.80559
26 26 Minnesota 10.45684
27 27 Mississippi 8.910859
28 28 Missouri 10.20212
29 29 Montana 8.470226
30 30 Nebraska 10.19912
31 31 Nevada 11.76972
32 32 New Hampshire 9.917139
33 33 New Jersey 12.23565
34 34 New Mexico 9.896993
35 35 New York 12.55857
36 36 North Carolina 10.32481
37 37 North Dakota 9.054678
38 38 Northern Marianas 11.08593
39 39 Ohio 10.87687
40 40 Oklahoma 9.93928
41 41 Oregon 10.71233
42 42 Pennsylvania 11.14623
43 43 Puerto Rico 11.57168
44 44 Rhode Island 11.72124
45 45 South Carolina 10.11142
46 46 South Dakota 8.728642
47 47 Tennessee 10.19729
48 48 Texas 11.17488
49 49 Utah 10.96281
50 50 Vermont 8.843222
51 51 Virgin Islands 11.08593
52 52 Virginia 10.90625
53 53 Washington 11.11933
54 54 West Virginia 9.111112
55 55 Wisconsin 10.19131
56 56 Wyoming 8.256294

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "urbanization-index/urbanization-state" (
"state" TEXT,
  "urbanindex" REAL
);