urbanization-index/urbanization-census-tract

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

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
);
Powered by Datasette · Query took 1251.979ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub