urbanization-index: urbanization-state.csv

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

56 rows

View and edit SQL

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

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "urbanization-index/urbanization-state" (
"state" TEXT,
  "urbanindex" REAL
);
Powered by Datasette · Query took 15.7ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub