Validated boundaries to government unit incident density comparison

The backing theory for this notebook is proving that we will be able to use the highest-density (fire count vs government unit area) government unit to determine a department's boundary for departments that do not have boundaries.


In [1]:
import psycopg2
from psycopg2.extras import RealDictCursor
import pandas as pd
# import geopandas as gpd
# from shapely import wkb
# from shapely.geometry import mapping as to_geojson
# import folium

pd.options.display.max_columns = None
pd.options.display.max_rows = None
#pd.set_option('display.float_format', lambda x: '%.3f' % x)

%matplotlib inline


/Users/joe/.pyenv/versions/2.7.14/envs/firecares-data/lib/python2.7/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
/Users/joe/.pyenv/versions/2.7.14/envs/firecares-data/lib/python2.7/site-packages/matplotlib/font_manager.py:280: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.
  'Matplotlib is building the font cache using fc-list. '

In [2]:
conn = psycopg2.connect('service=firecares')
nfirs = psycopg2.connect('service=nfirs')

DB migration/setup


In [6]:
# Create materialized view of all usgs govt units in FireCARES

q = """
create materialized view if not exists usgs_governmentunits as
(
    select id, population, county_name as name, 'countyorequivalent' as source, geom from usgs_countyorequivalent where geom is not null
    union
    select id, population, place_name as name, 'incorporatedplace' as source, geom from usgs_incorporatedplace where geom is not null
    union
    select id, population, minorcivildivision_name as name, 'minorcivildivision' as source, geom from usgs_minorcivildivision where geom is not null
    union
    select id, population, name, 'nativeamericanarea' as source, geom  from usgs_nativeamericanarea where geom is not null
    union
    select id, 0 as population, name, 'reserve' as source, geom  from usgs_reserve where geom is not null
    union
    select id, population, state_name as name, 'stateorterritoryhigh' as source, geom from usgs_stateorterritoryhigh where geom is not null
    union
    select id, population, place_name as name, 'unincorporatedplace' as source, geom from usgs_unincorporatedplace where geom is not null
);

create unique index on usgs_governmentunits (id, source);
create index on usgs_governmentunits using gist (geom);
"""
    
with conn.cursor() as c:
    c.execute(q)
    
conn.commit()

In [7]:
# Link remote firecares usgs_governmentunits view to nfirs-local usgs_government units

q = """
create foreign table usgs_governmentunits (id integer, population integer, name character varying(120), source text, geom geometry)
server firecares
options (table_name 'usgs_governmentunits');
"""

with nfirs.cursor() as c:
    c.execute(q)
    
nfirs.commit()

In [11]:
# Old nfirs.firestation_firedepartment foreign table columns needed to be synced

q = """
alter foreign TABLE firestation_firedepartment add column archived boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column domain_name character varying(255);
alter foreign TABLE firestation_firedepartment add column owned_tracts_geom public.geometry(MultiPolygon,4326);
alter foreign TABLE firestation_firedepartment add column display_metrics boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column boundary_verified boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column cfai_accredited boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column ems_transport boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column staffing_verified boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column stations_verified boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column census_override boolean NOT NULL;
alter foreign TABLE firestation_firedepartment add column additional_fdids character varying(255);
"""

with nfirs.cursor() as c:
    c.execute(q)
nfirs.commit()

In [12]:
q = """
create foreign table if not exists firecares_core_address (id integer NOT NULL,
    address_line1 character varying(100) NOT NULL,
    address_line2 character varying(100),
    city character varying(50) NOT NULL,
    state_province character varying(40) NOT NULL,
    postal_code character varying(10) NOT NULL,
    geom public.geometry(Point,4326),
    geocode_results text,
    country_id character varying(2) NOT NULL)
server firecares
options (table_name 'firecares_core_address');
"""

with nfirs.cursor() as c:
    c.execute(q)
nfirs.commit()

Processing


In [5]:
q = """
select id, fdid, state, name
from firestation_firedepartment
where boundary_verified = true;
"""

with nfirs.cursor(cursor_factory=RealDictCursor) as c:
    c.execute(q)
    fds = c.fetchall()

In [29]:
q = """
with fires as (select * from joint_buildingfires
    inner join joint_incidentaddress
    using (fdid, inc_no, inc_date, state, exp_no)
    where state = %(state)s and fdid = %(fdid)s
),
govt_units as (
    select gu.name, gu.source, gu.id, gu.geom, fd.id as fc_id, fd.geom as fd_geom, ST_Distance(addr.geom, ST_Centroid(gu.geom)) as distance_to_headquarters
    from firestation_firedepartment fd
    inner join firecares_core_address addr
        on addr.id = fd.headquarters_address_id
    join usgs_governmentunits gu
    on ST_Intersects(ST_Buffer(addr.geom, 0.05), gu.geom)
    where 
        fd.fdid = %(fdid)s and fd.state = %(state)s and source != 'stateorterritoryhigh'
    )
select gu.fc_id, count(fires) / ST_Area(gu.geom) as density, count(fires), ST_Area(ST_SymDifference(gu.fd_geom, gu.geom)) / ST_Area(gu.fd_geom) as percent_difference_to_verified_boundary, ST_Area(gu.geom), gu.distance_to_headquarters, gu.name, gu.id, gu.source from fires
inner join govt_units gu
on ST_Intersects(fires.geom, gu.geom)
group by gu.name, gu.id, gu.geom, gu.source, gu.distance_to_headquarters, gu.fd_geom, gu.fc_id
order by ST_Area(gu.geom) / count(fires) asc;
"""

for fd in fds:
    with nfirs.cursor(cursor_factory=RealDictCursor) as c:
        print 'Analyzing: {} (id: {} fdid: {} {})'.format(fd['name'], fd['id'], fd['fdid'], fd['state'])
        c.execute(q, dict(fdid=fd['fdid'], state=fd['state']))
        items = c.fetchall()
        df = pd.DataFrame(items)
        df.to_csv('./boundary-analysis-{}.csv'.format(fd['id']))


Analyzing: Southington Fire Department (id: 95681 fdid: 02230 CT)

Results


In [5]:
from glob import glob

In [6]:
df = None
for f in glob("boundary-analysis*.csv"):
    if df is not None:
        df = df.append(pd.read_csv(f))
    else:
        df = pd.read_csv(f)

In [7]:
df.rename(columns={'Unnamed: 0': 'rank'}, inplace=True)
selected_government_units = df[df['rank'] == 0].set_index('fc_id')
total_validated_department_count = len(selected_government_units)
perfect_fits = len(selected_government_units[selected_government_units['percent_difference_to_verified_boundary'] == 0])

In [8]:
print 'Perfect fits: {}/{} ({:.2%})'.format(perfect_fits, total_validated_department_count, float(perfect_fits) / total_validated_department_count)
print 'Machine-selected government unit area difference mean: {:.2%}'.format(df[df['rank'] == 0].percent_difference_to_verified_boundary.mean())


Perfect fits: 25/71 (35.21%)
Machine-selected government unit area difference mean: 40.29%

In [9]:
selected_government_units['percent_difference_to_verified_boundary'].hist(bins=50)


Out[9]:
<matplotlib.axes._subplots.AxesSubplot at 0x10feda410>

In [33]:
selected_government_units


Out[33]:
rank count density distance_to_headquarters id name percent_difference_to_verified_boundary source st_area
fc_id
78801 0 585 99716.978516 0.011408 11589 Corsicana 0.000000e+00 incorporatedplace 0.005867
85026 0 3 22941.311075 0.007315 5560 Isleton 1.959799e-01 incorporatedplace 0.000131
78578 0 372 19210.181569 0.018676 18456 Concord 0.000000e+00 incorporatedplace 0.019365
77887 0 492 411712.758527 0.010133 2042 Somerville 0.000000e+00 minorcivildivision 0.001195
83442 0 387 41660.471964 0.029491 43286 Hamden 0.000000e+00 minorcivildivision 0.009289
81727 0 107 65950.416117 0.076698 6626 Cumming 9.740965e-01 incorporatedplace 0.001622
81531 0 29 1254.014221 0.068297 7956 Palm Coast 8.129361e-01 incorporatedplace 0.023126
78792 0 3067 36616.371421 0.094370 45799 Corpus Christi 9.758430e-01 minorcivildivision 0.083760
89555 0 121 35694.222690 0.017323 13985 Murray 0.000000e+00 incorporatedplace 0.003390
79671 0 1894 230033.036127 0.092844 10570 Des Moines 6.754758e-01 minorcivildivision 0.008234
73375 0 487 117226.959850 0.039507 962 Alexandria 0.000000e+00 countyorequivalent 0.004154
81646 0 24 3683.634692 0.019080 6573 Folsom 1.989530e-01 incorporatedplace 0.006515
81134 0 572 35931.287606 0.070830 9263 Fairbanks 1.636272e+00 incorporatedplace 0.015919
81083 0 55 62330.674745 0.013787 3714 Marlton 8.910430e-01 unincorporatedplace 0.000882
97144 0 465 55713.807202 0.049072 5969 Davie 2.309553e-02 incorporatedplace 0.008346
98703 0 169 44570.682378 0.027857 9608 Wauwatosa 0.000000e+00 incorporatedplace 0.003792
78423 0 292 73221.399628 0.020073 4999 Collinsville 0.000000e+00 incorporatedplace 0.003988
83122 0 19 5772.177368 0.024143 9569 Greenfield 0.000000e+00 incorporatedplace 0.003292
93480 0 1 28.974344 0.015611 36080 Isleton 3.470353e+00 minorcivildivision 0.034513
99191 0 65 28955.239927 0.010647 16256 West Warwick 0.000000e+00 minorcivildivision 0.002245
77263 0 228 34765.445609 0.011000 1299 Chelmsford 0.000000e+00 minorcivildivision 0.006558
93456 0 436 16390.472516 0.067698 16564 Rio Rancho 0.000000e+00 incorporatedplace 0.026601
77563 0 221 44018.694737 0.016071 36694 Beloit 8.064430e-02 minorcivildivision 0.005021
91031 0 6027 165634.613560 0.105513 18656 Omaha 0.000000e+00 incorporatedplace 0.036387
91743 0 241 74792.081702 0.021430 11236 Pendleton 8.782634e-01 incorporatedplace 0.003222
83153 0 1565 144147.869234 0.037916 30370 Gilmer 6.830613e-01 minorcivildivision 0.010857
86361 0 106 354716.218751 0.002133 17500 Larchmont 0.000000e+00 incorporatedplace 0.000299
84012 0 265 25978.706569 0.019475 31131 Henrietta 7.032039e-09 minorcivildivision 0.010201
75808 0 413 120345.874485 0.029862 1039 Bristol 0.000000e+00 countyorequivalent 0.003432
93595 0 5127 481513.367546 0.017422 17926 Rochester 1.577109e-01 incorporatedplace 0.010648
91180 0 102 44904.643441 0.005796 1242 Orono 6.068044e-01 unincorporatedplace 0.002271
80460 0 702 79309.854459 0.002641 38261 Eau Claire 1.722006e-01 minorcivildivision 0.008851
74913 0 17 10993.465002 0.022096 4268 Oakhurst 9.339606e-01 unincorporatedplace 0.001546
74867 0 83 48014.754997 0.009581 31385 Berkeley Heights 0.000000e+00 minorcivildivision 0.001729
79600 0 278 107020.055328 0.027164 2434 Waverly 7.252662e-01 unincorporatedplace 0.002598
95681 0 331 32299.333543 0.004489 41084 Southington 0.000000e+00 minorcivildivision 0.010248
73310 0 767 147143.347114 0.012786 13076 Albany 7.817522e-01 incorporatedplace 0.005213
77599 0 621 100428.175657 0.027382 35516 Champaign City 1.806437e-12 minorcivildivision 0.006184
74286 0 7459 299610.202417 0.010716 764 Baltimore 1.173964e-01 incorporatedplace 0.024896
97886 0 113 8573.335642 0.016241 5210 Vallejo 0.000000e+00 incorporatedplace 0.013180
84030 0 4 1898.144305 0.008800 3585 Herald 9.155666e-01 unincorporatedplace 0.002107
86381 0 3123 88533.359291 0.132850 18787 Las Vegas 9.430606e-02 incorporatedplace 0.035275
76927 0 1251 61706.609379 0.022190 2402 Cedar Rapids 1.983832e-12 incorporatedplace 0.020273
77971 0 174 44497.445626 0.003224 12235 Claremore 5.705466e-01 incorporatedplace 0.003910
77030 0 29 1659.108357 0.108231 16221 Coventry 8.130265e-03 minorcivildivision 0.017479
89517 0 1061 153477.698912 0.009821 19265 City of Muncie 9.955738e-02 incorporatedplace 0.006913
81163 0 149 14851.169743 0.004371 4924 Fairfield 3.780732e-01 incorporatedplace 0.010033
78074 0 65 97933.514700 0.008745 18638 Clayton 0.000000e+00 incorporatedplace 0.000664
81599 0 517 77056.331484 0.031957 5164 Florence 1.459299e-01 incorporatedplace 0.006709
77197 0 5772 74189.876612 0.022302 28860 1, Charlotte 0.000000e+00 minorcivildivision 0.077800
91406 0 496 30866.656524 0.015807 42127 Palm Bay 3.513172e-01 minorcivildivision 0.016069
94144 0 111 64779.407794 0.030951 4595 Mandeville 9.055801e-01 incorporatedplace 0.001714
81159 0 331 37952.187544 0.040709 35587 Fairfield 0.000000e+00 minorcivildivision 0.008721
92130 0 14 13539.631770 0.073424 7594 Pingree Grove 9.010110e-01 incorporatedplace 0.001034
83388 0 190 40301.937746 0.006925 8059 Haines City 0.000000e+00 incorporatedplace 0.004714
78884 0 3 6245.294723 0.014198 9026 Courtland 9.463378e-01 unincorporatedplace 0.000480
77989 0 308 273562.998430 0.030587 1954 Winchester 9.994213e-01 unincorporatedplace 0.001126
97577 0 12 149575.143957 0.015105 8590 Twinsburg Heights 1.020869e+00 unincorporatedplace 0.000080
96872 0 168 45426.778637 0.001659 6647 Thomasville 0.000000e+00 incorporatedplace 0.003698
87956 0 109 31956.376680 0.003401 46155 Marshfield 1.394359e-01 minorcivildivision 0.003411
95940 0 371 115706.712512 0.022130 490 St. Louis Park 1.662714e-12 incorporatedplace 0.003206
77286 0 58 34337.398125 0.027801 5616 Holly Springs 9.846589e-01 incorporatedplace 0.001689
91878 0 606 99455.971303 0.028927 46938 Petersburg 0.000000e+00 minorcivildivision 0.006093
92633 0 6 398.309173 0.056015 46744 4 7.825700e-01 minorcivildivision 0.015064
88441 0 2 242248.355439 0.044803 38006 Milwaukee 1.000803e+00 minorcivildivision 0.000008
82342 0 100 129837.644744 0.044383 5062 North Gates 8.664626e-01 unincorporatedplace 0.000770
78827 0 126 11165.623937 0.052474 6574 Elk Grove 7.320594e-01 incorporatedplace 0.011285
78400 0 401 52205.082374 0.060030 46465 Bryan-College Station 1.152629e+00 minorcivildivision 0.007681
88532 0 4248 325100.124768 0.007207 6003 Miami 5.785100e-01 incorporatedplace 0.013067
81258 0 1600 141880.735351 0.026199 2560 Fall River 4.364164e-02 minorcivildivision 0.011277
86287 0 375 186597.718720 0.007590 17056 Lancaster 0.000000e+00 minorcivildivision 0.002010

In [8]:
df.set_index('fc_id')


Out[8]:
rank count density distance_to_headquarters id name percent_difference_to_verified_boundary source st_area
fc_id
78801 0 585 99716.978516 0.011408 11589 Corsicana 0.000000e+00 incorporatedplace 0.005867
78801 1 617 6956.982835 0.049155 40009 Corsicana 1.411741e+01 minorcivildivision 0.088688
78801 2 620 2308.610455 0.046837 2605 Navarro 4.477773e+01 countyorequivalent 0.268560
85026 0 3 22941.311075 0.007315 5560 Isleton 1.959799e-01 incorporatedplace 0.000131
85026 1 3 86.923032 0.015528 36080 Isleton 2.839006e+02 minorcivildivision 0.034513
85026 2 3 11.288303 0.393362 2521 Sacramento 2.192813e+03 countyorequivalent 0.265762
78578 0 372 19210.181569 0.018676 18456 Concord 0.000000e+00 incorporatedplace 0.019365
78578 1 372 19210.181569 0.018676 30145 Concord 0.000000e+00 minorcivildivision 0.019365
78578 2 373 1357.456627 0.156079 1813 Merrimack 1.318964e+01 countyorequivalent 0.274779
77887 0 492 411712.758527 0.010133 2042 Somerville 0.000000e+00 minorcivildivision 0.001195
77887 1 492 411712.758527 0.010133 1517 Somerville 0.000000e+00 incorporatedplace 0.001195
77887 2 12 5964.478376 0.031102 2027 Cambridge 2.683596e+00 incorporatedplace 0.002012
77887 3 12 5964.478376 0.031102 2016 Cambridge 2.683596e+00 minorcivildivision 0.002012
77887 4 506 2106.446964 0.315218 2244 Middlesex 2.000153e+02 countyorequivalent 0.240215
77887 5 2 815.332877 0.036952 1539 Medford 3.052694e+00 incorporatedplace 0.002453
77887 6 2 815.332877 0.036952 1722 Medford 3.052694e+00 minorcivildivision 0.002453
77887 7 1 39.432999 0.095002 1564 Boston 2.222117e+01 incorporatedplace 0.025359
77887 8 1 39.432999 0.095002 2402 Boston 2.222117e+01 minorcivildivision 0.025359
77887 9 1 29.395339 0.113664 1712 Suffolk 2.946759e+01 countyorequivalent 0.034019
83442 0 387 41660.471964 0.029491 43286 Hamden 0.000000e+00 minorcivildivision 0.009289
83442 1 444 1848.318459 0.081168 2282 New Haven 2.485946e+01 countyorequivalent 0.240218
83442 2 3 509.609601 0.083484 1128 North Haven 1.633719e+00 unincorporatedplace 0.005887
83442 3 3 509.609601 0.083484 43250 North Haven 1.633719e+00 minorcivildivision 0.005887
83442 4 1 166.779401 0.064188 35740 Bethany 1.645462e+00 minorcivildivision 0.005996
83442 5 1 107.262109 0.090355 36054 Cheshire 2.003614e+00 minorcivildivision 0.009323
83442 6 1 89.860200 0.129566 43829 Wallingford 2.197970e+00 minorcivildivision 0.011128
81727 0 107 65950.416117 0.076698 6626 Cumming 9.740965e-01 incorporatedplace 0.001622
81727 1 564 19095.228686 0.072461 42689 Cumming 5.284300e-01 minorcivildivision 0.029536
81727 2 1009 16109.539393 0.056274 1468 Forsyth 0.000000e+00 countyorequivalent 0.062634
81727 3 133 11345.180412 0.063114 42688 Silver City 8.128317e-01 minorcivildivision 0.011723
81727 4 100 9823.683918 0.088605 42690 Chestatee 8.374760e-01 minorcivildivision 0.010179
81531 0 29 1254.014221 0.068297 7956 Palm Coast 8.129361e-01 incorporatedplace 0.023126
81531 1 106 770.831161 0.047294 2591 Flagler 1.308237e-01 countyorequivalent 0.137514
81531 2 75 699.235919 0.088284 42121 Bunnell 1.190632e-01 minorcivildivision 0.107260
81531 3 23 688.903639 0.093834 7957 Bunnell 7.256013e-01 incorporatedplace 0.033386
78792 0 3067 36616.371421 0.094370 45799 Corpus Christi 9.758430e-01 minorcivildivision 0.083760
78792 1 3154 27174.119424 0.149747 14022 Corpus Christi 0.000000e+00 incorporatedplace 0.116066
78792 2 3180 11509.122911 0.116860 3171 Nueces 1.580866e+00 countyorequivalent 0.276303
78792 3 70 969.215515 0.225959 45780 Port Aransas 5.864821e-01 minorcivildivision 0.072223
89555 0 121 35694.222690 0.017323 13985 Murray 0.000000e+00 incorporatedplace 0.003390
89555 1 35 21492.711615 0.052182 13192 Midvale 1.480385e+00 incorporatedplace 0.001628
89555 2 9 3008.346095 0.059993 13173 Taylorsville 1.882526e+00 incorporatedplace 0.002992
89555 3 197 2193.350754 0.034171 36344 Salt Lake City 2.549541e+01 minorcivildivision 0.089817
89555 4 7 1858.352424 0.065920 3079 Millcreek 2.111175e+00 unincorporatedplace 0.003767
89555 5 206 925.023140 0.033858 2428 Salt Lake 6.469422e+01 countyorequivalent 0.222697
89555 6 2 916.002913 0.067270 13191 Holladay 1.644089e+00 incorporatedplace 0.002183
89555 7 18 583.118099 0.118310 13987 Salt Lake City 1.010602e+01 incorporatedplace 0.030869
89555 8 2 223.613326 0.128260 13174 West Jordan 3.638426e+00 incorporatedplace 0.008944
79671 0 1894 230033.036127 0.092844 10570 Des Moines 6.754758e-01 minorcivildivision 0.008234
79671 1 1391 193364.143301 0.006304 8786 Lee 7.164638e-01 minorcivildivision 0.007194
79671 2 3876 152771.061951 0.049763 1160 Des Moines 0.000000e+00 incorporatedplace 0.025371
79671 3 485 61414.315009 0.120182 11100 Bloomfield 9.069495e-01 minorcivildivision 0.007897
79671 4 3888 23466.949955 0.095099 1543 Polk 5.672208e+00 countyorequivalent 0.165680
79671 5 15 3475.138046 0.094185 8819 Saylor 1.162768e+00 minorcivildivision 0.004316
79671 6 15 3008.289264 0.068737 11122 Delaware 1.119843e+00 minorcivildivision 0.004986
79671 7 7 1721.120479 0.084673 11086 Allen 1.043381e+00 minorcivildivision 0.004067
79671 8 1 385.068180 0.064628 1915 Pleasant Hill 1.102358e+00 incorporatedplace 0.002597
79671 9 2 373.912367 0.088354 9333 Four Mile 1.210823e+00 minorcivildivision 0.005349
73375 0 487 117226.959850 0.039507 962 Alexandria 0.000000e+00 countyorequivalent 0.004154
73375 1 487 117226.959850 0.039507 14393 Alexandria 0.000000e+00 incorporatedplace 0.004154
73375 2 487 117226.959850 0.039507 36573 Alexandria 0.000000e+00 minorcivildivision 0.004154
73375 3 3 9879.903548 0.037054 9915 Huntington 1.073092e+00 unincorporatedplace 0.000304
73375 4 4 3377.886917 0.075601 4674 Groveton 1.285045e+00 unincorporatedplace 0.001184
73375 5 16 2282.037137 0.082572 46547 Arlington 2.687702e+00 minorcivildivision 0.007011
73375 6 16 2282.037137 0.082572 1773 Arlington 2.687702e+00 unincorporatedplace 0.007011
73375 7 16 2282.037137 0.082572 2082 Arlington 2.687702e+00 countyorequivalent 0.007011
73375 8 5 1771.883715 0.107766 86037 George Washington Memorial Parkway 1.623647e+00 reserve 0.002822
73375 9 1 1303.512306 0.040447 3491 Belle Haven 1.184664e+00 unincorporatedplace 0.000767
73375 10 2 1189.849825 0.081166 395 Fort Hunt 1.404610e+00 unincorporatedplace 0.001681
73375 11 7 877.492815 0.108719 36632 Lee 2.920229e+00 minorcivildivision 0.007977
73375 12 1 667.873413 0.068467 966 Rose Hill 1.360416e+00 unincorporatedplace 0.001497
73375 13 9 482.368208 0.163884 36630 Mount Vernon 5.491200e+00 minorcivildivision 0.018658
73375 14 24 219.913828 0.230237 2382 Fairfax 2.726983e+01 countyorequivalent 0.109134
73375 15 1 54.404531 0.093494 2636 District of Columbia 5.424493e+00 countyorequivalent 0.018381
73375 16 1 54.404531 0.093494 8586 Washington 5.424493e+00 incorporatedplace 0.018381
73375 17 1 54.404531 0.093494 35662 Washington 5.424493e+00 minorcivildivision 0.018381
81646 0 24 3683.634692 0.019080 6573 Folsom 1.989530e-01 incorporatedplace 0.006515
81646 1 24 2999.677695 0.023788 40995 Folsom 1.293226e-02 minorcivildivision 0.008001
81646 2 24 90.306426 0.282723 2521 Sacramento 3.193298e+01 countyorequivalent 0.265762
81134 0 572 35931.287606 0.070830 9263 Fairbanks 1.636272e+00 incorporatedplace 0.015919
81134 1 163 18486.792632 0.056939 31371 NaN 1.817228e+00 reserve 0.008817
81134 2 49 12628.511233 0.064480 18617 NaN 1.312660e+00 reserve 0.003880
81134 3 3 719.386319 0.069369 8453 South Van Horn 1.690598e+00 unincorporatedplace 0.004170
81134 4 5 531.497856 0.101724 7355 College 2.557883e+00 unincorporatedplace 0.009407
81134 5 606 166.506201 1.161507 43531 Fairbanks North Star 6.017107e+02 minorcivildivision 3.639504
81134 6 606 166.506201 1.161507 3129 Fairbanks North Star 6.017107e+02 countyorequivalent 3.639504
81134 7 1 93.070000 0.071105 3657 Farmers Loop 2.779332e+00 unincorporatedplace 0.010745
81134 8 12 17.034910 0.410944 86572 Fort Wainwright 1.174334e+02 reserve 0.704436
81134 9 606 6.042289 2.212025 610 Doyon Alaska Native Regional Corporation 1.660778e+04 nativeamericanarea 100.293110
81083 0 55 62330.674745 0.013787 3714 Marlton 8.910430e-01 unincorporatedplace 0.000882
81083 1 162 20003.650573 0.040419 30022 Evesham 0.000000e+00 minorcivildivision 0.008099
81083 2 12 1814.535715 0.075821 31620 Cherry Hill 1.816601e+00 minorcivildivision 0.006613
81083 3 164 733.610331 0.251992 775 Burlington 2.660404e+01 countyorequivalent 0.223552
81083 4 16 258.432544 0.096890 799 Camden 8.644816e+00 countyorequivalent 0.061912
81083 5 1 166.751513 0.058548 30697 Mount Laurel 1.740499e+00 minorcivildivision 0.005997
97144 0 465 55713.807202 0.049072 5969 Davie 2.309553e-02 incorporatedplace 0.008346
97144 1 484 24608.876418 0.101499 41280 Davie 1.407121e+00 minorcivildivision 0.019668
97144 2 16 8188.399081 0.051839 5972 Cooper City 1.226153e+00 incorporatedplace 0.001954
97144 3 12 2341.155903 0.062605 5311 Plantation 1.599819e+00 incorporatedplace 0.005126
97144 4 514 1661.955600 0.232465 2941 Broward 3.574529e+01 countyorequivalent 0.309274
97144 5 13 1047.975517 0.086688 41182 Plantation 2.457296e+00 minorcivildivision 0.012405
97144 6 11 633.478165 0.110823 41266 Hollywood 3.027079e+00 minorcivildivision 0.017364
97144 7 1 511.440055 0.076121 5970 Dania Beach 1.229228e+00 incorporatedplace 0.001955
97144 8 4 471.411574 0.118498 5959 Fort Lauderdale 2.007747e+00 incorporatedplace 0.008485
97144 9 5 314.615621 0.120584 41183 Miramar-Pembroke Pines 2.870921e+00 minorcivildivision 0.015892
97144 10 2 278.880163 0.083310 5938 Hollywood 1.851429e+00 incorporatedplace 0.007172
97144 11 1 122.961027 0.113332 5288 Pembroke Pines 1.965700e+00 incorporatedplace 0.008133
97144 12 1 48.398715 0.144073 41278 Fort Lauderdale 3.454307e+00 minorcivildivision 0.020662
98703 0 169 44570.682378 0.027857 9608 Wauwatosa 0.000000e+00 incorporatedplace 0.003792
98703 1 169 44570.682378 0.027857 39847 Wauwatosa 0.000000e+00 minorcivildivision 0.003792
98703 2 177 520.294565 0.429854 2839 Milwaukee 8.871944e+01 countyorequivalent 0.340192
98703 3 1 306.482166 0.048851 39756 West Allis 1.860513e+00 minorcivildivision 0.003263
98703 4 1 306.482166 0.048851 9609 West Allis 1.860513e+00 incorporatedplace 0.003263
98703 5 7 252.851922 0.043818 39930 Milwaukee 8.301202e+00 minorcivildivision 0.027684
98703 6 7 252.579989 0.043740 9896 Milwaukee 8.309063e+00 incorporatedplace 0.027714
78423 0 292 73221.399628 0.020073 4999 Collinsville 0.000000e+00 incorporatedplace 0.003988
78423 1 296 30889.743830 0.033008 8841 Collinsville 1.832355e+00 minorcivildivision 0.009582
78423 2 6 4128.381041 0.061733 6934 Maryville 1.364441e+00 incorporatedplace 0.001453
78423 3 25 2658.318678 0.054299 9665 Caseyville 3.169861e+00 minorcivildivision 0.009404
78423 4 308 1547.923106 0.180484 2385 Madison 4.921336e+01 countyorequivalent 0.198976
78423 5 1 296.749830 0.089498 6932 Pontoon Beach 1.845016e+00 incorporatedplace 0.003370
78423 6 32 177.571551 0.207005 2409 St. Clair 4.587048e+01 countyorequivalent 0.180209
83122 0 19 5772.177368 0.024143 9569 Greenfield 0.000000e+00 incorporatedplace 0.003292
83122 1 19 5772.177368 0.024143 40038 Greenfield 0.000000e+00 minorcivildivision 0.003292
83122 2 19 55.850829 0.451075 2839 Milwaukee 1.023499e+02 countyorequivalent 0.340192
93480 0 1 28.974344 0.015611 36080 Isleton 3.470353e+00 minorcivildivision 0.034513
93480 1 1 3.762768 0.401068 2521 Sacramento 3.340125e+01 countyorequivalent 0.265762
99191 0 65 28955.239927 0.010647 16256 West Warwick 0.000000e+00 minorcivildivision 0.002245
99191 1 68 1290.801934 0.065244 706 Kent 2.246730e+01 countyorequivalent 0.052680
99191 2 2 143.349941 0.102625 14832 Warwick 7.215074e+00 incorporatedplace 0.013952
99191 3 2 143.349941 0.102625 16189 Warwick 7.215074e+00 minorcivildivision 0.013952
99191 4 1 57.210633 0.138810 16221 Coventry 8.786406e+00 minorcivildivision 0.017479
99191 5 2 16.343976 0.173982 635 Providence 5.551124e+01 countyorequivalent 0.122369
77263 0 228 34765.445609 0.011000 1299 Chelmsford 0.000000e+00 minorcivildivision 0.006558
77263 1 237 986.616463 0.119495 2244 Middlesex 3.562798e+01 countyorequivalent 0.240215
77263 2 3 726.514194 0.050785 2026 Lowell 1.629637e+00 incorporatedplace 0.004129
77263 3 3 726.514194 0.050785 2387 Lowell 1.629637e+00 minorcivildivision 0.004129
77263 4 2 267.734974 0.093729 1688 Billerica 2.139037e+00 minorcivildivision 0.007470
93456 0 436 16390.472516 0.067698 16564 Rio Rancho 0.000000e+00 incorporatedplace 0.026601
93456 1 471 4410.983578 0.120777 27653 Rio Rancho 3.356640e+00 minorcivildivision 0.106779
93456 2 6 2161.896016 0.032745 16565 Corrales 1.104333e+00 incorporatedplace 0.002775
93456 3 480 500.895241 0.481909 651 Sandoval 3.532715e+01 countyorequivalent 0.958284
93456 4 1 100.238192 0.088513 69 Sandia Pueblo 1.375035e+00 nativeamericanarea 0.009976
77563 0 221 44018.694737 0.016071 36694 Beloit 8.064430e-02 minorcivildivision 0.005021
77563 1 221 44018.694737 0.016071 10073 Beloit 8.064430e-02 incorporatedplace 0.005021
77563 2 224 1084.646488 0.167419 2767 Rock 4.065087e+01 countyorequivalent 0.206519
77563 3 1 339.541884 0.086570 7730 Roscoe 1.593975e+00 incorporatedplace 0.002945
77563 4 2 262.010741 0.064325 36693 Beloit 2.526538e+00 minorcivildivision 0.007633
77563 5 1 94.287310 0.092490 10477 Rockton 3.138908e+00 minorcivildivision 0.010606
77563 6 1 6.807011 0.218898 2387 Winnebago 3.062792e+01 countyorequivalent 0.146907
91031 0 6027 165634.613560 0.105513 18656 Omaha 0.000000e+00 incorporatedplace 0.036387
91031 1 6027 165634.613560 0.105513 34883 Omaha 0.000000e+00 minorcivildivision 0.036387
91031 2 6328 66974.530378 0.221692 1643 Douglas 1.596610e+00 countyorequivalent 0.094484
91031 3 1 1779.292981 0.038991 2129 Carter Lake 1.015446e+00 incorporatedplace 0.000562
91031 4 1 197.288445 0.071692 12157 Kane 1.139299e+00 minorcivildivision 0.005069
91031 5 1 3.742254 0.402553 1987 Pottawattamie 8.343730e+00 countyorequivalent 0.267219
91743 0 241 74792.081702 0.021430 11236 Pendleton 8.782634e-01 incorporatedplace 0.003222
91743 1 270 1028.695376 0.194801 22144 Pendleton 4.035100e+01 minorcivildivision 0.262468
91743 2 274 283.927139 0.098442 437 Umatilla 1.507934e+02 countyorequivalent 0.965036
83153 0 1565 144147.869234 0.037916 30370 Gilmer 6.830613e-01 minorcivildivision 0.010857
83153 1 3594 104917.340475 0.045056 15085 Greensboro 0.000000e+00 incorporatedplace 0.034256
83153 2 2029 86714.472611 0.083209 30341 Morehead 3.169387e-01 minorcivildivision 0.023399
83153 3 3739 21940.199056 0.018845 1520 Guilford 3.974897e+00 countyorequivalent 0.170418
83153 4 37 3239.725451 0.110950 30344 Jefferson 1.333398e+00 minorcivildivision 0.011421
83153 5 7 968.341653 0.104297 30342 Monroe 1.211027e+00 minorcivildivision 0.007229
86361 0 106 354716.218751 0.002133 17500 Larchmont 0.000000e+00 incorporatedplace 0.000299
86361 1 108 27733.097176 0.011367 29070 Mamaroneck 1.203168e+01 minorcivildivision 0.003894
86361 2 108 777.470159 0.224171 448 Westchester 4.638525e+02 countyorequivalent 0.138912
84012 0 265 25978.706569 0.019475 31131 Henrietta 7.032039e-09 minorcivildivision 0.010201
84012 1 10 2240.638996 0.078569 5917 Brighton 1.437522e+00 unincorporatedplace 0.004463
84012 2 10 2240.638996 0.078569 30522 Brighton 1.437522e+00 minorcivildivision 0.004463
84012 3 9 845.254595 0.100707 17926 Rochester 2.043822e+00 incorporatedplace 0.010648
84012 4 9 845.254595 0.100707 30521 Rochester 2.043822e+00 minorcivildivision 0.010648
84012 5 290 738.457129 0.237685 568 Monroe 3.749855e+01 countyorequivalent 0.392711
75808 0 413 120345.874485 0.029862 1039 Bristol 0.000000e+00 countyorequivalent 0.003432
75808 1 413 120345.874485 0.029862 10694 Bristol 0.000000e+00 incorporatedplace 0.003432
75808 2 413 120345.874485 0.029862 37462 Bristol 0.000000e+00 minorcivildivision 0.003432
93595 0 5127 481513.367546 0.017422 17926 Rochester 1.577109e-01 incorporatedplace 0.010648
93595 1 5127 481513.367546 0.017422 30521 Rochester 1.577109e-01 minorcivildivision 0.010648
93595 2 5189 13213.289796 0.171517 568 Monroe 3.182556e+01 countyorequivalent 0.392711
93595 3 23 5153.469691 0.044468 5917 Brighton 1.145465e+00 unincorporatedplace 0.004463
93595 4 23 5153.469691 0.044468 30522 Brighton 1.145465e+00 minorcivildivision 0.004463
93595 5 14 2898.849830 0.071351 31231 Irondequoit 1.396483e+00 minorcivildivision 0.004830
93595 6 14 2898.849830 0.071351 4828 Irondequoit 1.396483e+00 unincorporatedplace 0.004830
93595 7 3 684.966692 0.101370 30523 Gates 1.363100e+00 minorcivildivision 0.004380
93595 8 3 262.838343 0.157612 31475 Chili 1.926219e+00 minorcivildivision 0.011414
91180 0 102 44904.643441 0.005796 1242 Orono 6.068044e-01 unincorporatedplace 0.002271
91180 1 115 19906.620607 0.043241 896 Orono 0.000000e+00 minorcivildivision 0.005777
91180 2 2 156.587539 0.084116 897 Old Town 3.210917e+00 minorcivildivision 0.012772
91180 3 2 156.587539 0.084116 3063 Old Town 3.210917e+00 incorporatedplace 0.012772
91180 4 119 112.396473 0.518612 1234 Penobscot 1.822711e+02 countyorequivalent 1.058752
80460 0 702 79309.854459 0.002641 38261 Eau Claire 1.722006e-01 minorcivildivision 0.008851
80460 1 728 72374.224039 0.009047 9797 Eau Claire 7.339930e-02 incorporatedplace 0.010059
80460 2 26 21532.613515 0.056059 36974 Eau Claire 9.011987e-01 minorcivildivision 0.001207
80460 3 713 3755.965227 0.228295 3051 Eau Claire 1.858140e+01 countyorequivalent 0.189831
80460 4 8 493.525419 0.114069 37709 Washington 2.633092e+00 minorcivildivision 0.016210
80460 5 2 247.049130 0.103221 37710 Union 1.814295e+00 minorcivildivision 0.008096
80460 6 30 97.354737 0.337282 3122 Chippewa 3.217805e+01 countyorequivalent 0.308151
74913 0 17 10993.465002 0.022096 4268 Oakhurst 9.339606e-01 unincorporatedplace 0.001546
74913 1 2 369.962171 0.076324 18440 Sand Springs 2.133643e+00 incorporatedplace 0.005406
74913 2 35 317.361942 0.108083 24604 Tulsa 2.896339e+01 minorcivildivision 0.110284
74913 3 35 229.959427 0.117915 516 Tulsa 4.035177e+01 countyorequivalent 0.152201
74913 4 3 57.533207 0.156373 18445 Tulsa 1.516196e+01 incorporatedplace 0.052144
74913 5 35 28.367408 0.449126 398 Creek OTSA 3.342159e+02 nativeamericanarea 1.233810
74867 0 83 48014.754997 0.009581 31385 Berkeley Heights 0.000000e+00 minorcivildivision 0.001729
74867 1 83 2855.219217 0.126596 143 Union 1.581649e+01 countyorequivalent 0.029070
79600 0 278 107020.055328 0.027164 2434 Waverly 7.252662e-01 unincorporatedplace 0.002598
79600 1 334 35324.738659 0.013665 7947 Delta 0.000000e+00 minorcivildivision 0.009455
79600 2 4 4850.050565 0.052538 4996 Lansing 1.087226e+00 minorcivildivision 0.000825
79600 3 23 2258.798236 0.070787 4897 Watertown 2.076919e+00 minorcivildivision 0.010182
79600 4 343 2083.762975 0.229011 2333 Eaton 1.640918e+01 countyorequivalent 0.164606
79600 5 12 1150.120728 0.109199 91 Lansing 2.103495e+00 incorporatedplace 0.010434
79600 6 36 219.343195 0.210000 2285 Clinton 1.835845e+01 countyorequivalent 0.164126
95681 0 331 32299.333543 0.004489 41084 Southington 0.000000e+00 minorcivildivision 0.010248
95681 1 341 1618.982084 0.245160 641 Hartford 1.955313e+01 countyorequivalent 0.210626
95681 2 1 365.107719 0.068356 36272 Plainville 1.267267e+00 minorcivildivision 0.002739
95681 3 1 133.177350 0.095478 6359 Bristol 1.732715e+00 incorporatedplace 0.007509
95681 4 1 133.177350 0.095478 41101 Bristol 1.732715e+00 minorcivildivision 0.007509
95681 5 6 24.977276 0.261066 2282 New Haven 2.444076e+01 countyorequivalent 0.240218
73310 0 767 147143.347114 0.012786 13076 Albany 7.817522e-01 incorporatedplace 0.005213
73310 1 34 24733.752557 0.056886 11190 Millersburg 1.010990e+00 incorporatedplace 0.001375
73310 2 127 21317.965074 0.049596 21682 North Albany 7.515723e-01 minorcivildivision 0.005957
73310 3 747 18402.307691 0.032746 22123 Albany 1.566131e+00 minorcivildivision 0.040593
73310 4 756 1117.420409 0.591143 327 Linn 2.799422e+01 countyorequivalent 0.676558
73310 5 129 648.721092 0.352950 574 Benton 8.676782e+00 countyorequivalent 0.198853
77599 0 621 100428.175657 0.027382 35516 Champaign City 1.806437e-12 minorcivildivision 0.006184
77599 1 621 100428.175657 0.027382 8542 Champaign 1.806437e-12 incorporatedplace 0.006184
77599 2 635 2323.693901 0.053241 2878 Champaign 4.319354e+01 countyorequivalent 0.273272
77599 3 6 1846.661827 0.048359 43327 Cunningham 1.525446e+00 minorcivildivision 0.003249
77599 4 6 1846.661827 0.048359 5122 Urbana 1.525446e+00 incorporatedplace 0.003249
77599 5 7 1378.022907 0.067110 35517 Champaign 1.821496e+00 minorcivildivision 0.005080
77599 6 1 121.050339 0.089198 43524 Hensley 2.335974e+00 minorcivildivision 0.008261
74286 0 7459 299610.202417 0.010716 764 Baltimore 1.173964e-01 incorporatedplace 0.024896
74286 1 7459 299610.202417 0.010716 2401 Baltimore 1.173964e-01 countyorequivalent 0.024896
74286 2 7459 299610.202417 0.010716 2732 Baltimore 1.173964e-01 minorcivildivision 0.024896
97886 0 113 8573.335642 0.016241 5210 Vallejo 0.000000e+00 incorporatedplace 0.013180
97886 1 119 4116.547787 0.046265 40579 Vallejo 1.230566e+00 minorcivildivision 0.028908
97886 2 119 492.526738 0.367575 2514 Solano 1.733110e+01 countyorequivalent 0.241611
84030 0 4 1898.144305 0.008800 3585 Herald 9.155666e-01 unincorporatedplace 0.002107
84030 1 6 109.964183 0.050931 36078 Galt 1.216894e+00 minorcivildivision 0.054563
84030 2 6 22.576606 0.187226 2521 Sacramento 9.678897e+00 countyorequivalent 0.265762
86381 0 3123 88533.359291 0.132850 18787 Las Vegas 9.430606e-02 incorporatedplace 0.035275
86381 1 3300 26704.625688 0.051649 30496 Las Vegas 2.831487e+00 minorcivildivision 0.123574
86381 2 5 4440.957767 0.039875 1954 Winchester 1.030465e+00 unincorporatedplace 0.001126
86381 3 27 3120.937736 0.091616 7875 Sunrise Manor 1.234459e+00 unincorporatedplace 0.008651
86381 4 54 2037.096531 0.126214 18786 North Las Vegas 1.717699e+00 incorporatedplace 0.026508
86381 5 3 1850.157655 0.266381 333 Las Vegas Indian Colony 1.040286e+00 nativeamericanarea 0.001621
86381 6 3329 1590.908828 0.133128 2531 Clark 5.574585e+01 countyorequivalent 2.092515
86381 7 14 1156.415731 0.094514 7942 Paradise 1.328253e+00 unincorporatedplace 0.012106
76927 0 1251 61706.609379 0.022190 2402 Cedar Rapids 1.983832e-12 incorporatedplace 0.020273
76927 1 1251 61706.609379 0.022190 12747 Cedar Rapids 1.983832e-12 minorcivildivision 0.020273
76927 2 1261 6176.601400 0.115652 1577 Linn 9.070241e+00 countyorequivalent 0.204158
76927 3 4 543.285715 0.133850 12717 Bertram 1.363167e+00 minorcivildivision 0.007363
77971 0 174 44497.445626 0.003224 12235 Claremore 5.705466e-01 incorporatedplace 0.003910
77971 1 217 3678.808859 0.048976 20565 Claremore 8.854198e+00 minorcivildivision 0.058986
77971 2 223 1205.047643 0.060509 450 Rogers 2.991501e+01 countyorequivalent 0.185055
77971 3 1 433.831537 0.052046 4253 Justice 1.367359e+00 unincorporatedplace 0.002305
77971 4 223 123.358666 0.436250 250 Cherokee OTSA 3.009979e+02 nativeamericanarea 1.807737
77030 0 29 1659.108357 0.108231 16221 Coventry 8.130265e-03 minorcivildivision 0.017479
77030 1 30 569.471441 0.024542 706 Kent 2.021010e+00 countyorequivalent 0.052680
77030 2 1 71.674970 0.137000 14832 Warwick 1.799829e+00 incorporatedplace 0.013952
77030 3 1 71.674970 0.137000 16189 Warwick 1.799829e+00 minorcivildivision 0.013952
89517 0 1061 153477.698912 0.009821 19265 City of Muncie 9.955738e-02 incorporatedplace 0.006913
89517 1 1064 111793.680356 0.004354 13568 Center 4.540970e-01 minorcivildivision 0.009518
89517 2 1110 10230.196781 0.038061 2854 Delaware 1.337462e+01 countyorequivalent 0.108502
89517 3 13 1567.464239 0.079745 13094 Monroe 2.098759e+00 minorcivildivision 0.008294
89517 4 5 612.295522 0.077487 13040 Hamilton 2.061478e+00 minorcivildivision 0.008166
81163 0 149 14851.169743 0.004371 4924 Fairfield 3.780732e-01 incorporatedplace 0.010033
81163 1 153 2373.269966 0.061684 40582 Fairfield-Suisun City 6.233082e+00 minorcivildivision 0.064468
81163 2 1 901.152636 0.035144 5212 Suisun City 1.122881e+00 incorporatedplace 0.001110
81163 3 153 633.248664 0.101583 2514 Solano 2.598460e+01 countyorequivalent 0.241611
78074 0 65 97933.514700 0.008745 18638 Clayton 0.000000e+00 incorporatedplace 0.000664
78074 1 34 23096.504331 0.024193 31563 Hadley 2.279837e+00 minorcivildivision 0.001472
78074 2 35 8076.376872 0.040228 34931 Clayton 6.467450e+00 minorcivildivision 0.004334
78074 3 1 631.825376 0.015896 19357 University City 3.384630e+00 incorporatedplace 0.001583
78074 4 76 542.235673 0.107575 1872 St. Louis 2.101755e+02 countyorequivalent 0.140160
78074 5 1 508.477316 0.028257 32241 University 3.963101e+00 minorcivildivision 0.001967
78074 6 1 436.383382 0.046921 15005 Ladue 4.452628e+00 incorporatedplace 0.002292
78074 7 1 56.513948 0.092343 2111 St. Louis 2.766013e+01 countyorequivalent 0.017695
78074 8 1 56.513948 0.092343 18508 St. Louis 2.766013e+01 incorporatedplace 0.017695
78074 9 1 56.513948 0.092343 33173 St. Louis 2.766013e+01 minorcivildivision 0.017695
81599 0 517 77056.331484 0.031957 5164 Florence 1.459299e-01 incorporatedplace 0.006709
81599 1 519 19940.260357 0.095420 41521 Florence 2.651716e+00 minorcivildivision 0.026028
81599 2 1 9767.942737 0.043100 88306 NaN 9.860600e-01 reserve 0.000102
81599 3 524 2850.756578 0.104297 966 Lauderdale 2.403570e+01 countyorequivalent 0.183811
81599 4 5 183.491186 0.142346 41510 Oakland 4.609777e+00 minorcivildivision 0.027249
77197 0 5772 74189.876612 0.022302 28860 1, Charlotte 0.000000e+00 minorcivildivision 0.077800
77197 1 5772 74189.876612 0.022302 17675 Charlotte 0.000000e+00 incorporatedplace 0.077800
77197 2 6041 43147.601931 0.017857 3070 Mecklenburg 7.995773e-01 countyorequivalent 0.140008
91406 0 496 30866.656524 0.015807 42127 Palm Bay 3.513172e-01 minorcivildivision 0.016069
91406 1 495 30259.288058 0.017387 6821 Palm Bay 3.208722e-01 incorporatedplace 0.016359
91406 2 5 21194.226159 0.053879 85512 Malabar Transmitter Annex 9.901282e-01 reserve 0.000236
91406 3 513 1382.835615 0.327120 2593 Brevard 1.452351e+01 countyorequivalent 0.370977
91406 4 1 317.790229 0.070408 7914 Malabar 1.130672e+00 incorporatedplace 0.003147
91406 5 3 147.176206 0.108801 42150 Malabar 1.727221e+00 minorcivildivision 0.020384
91406 6 1 139.443712 0.093826 6780 Grant-Valkaria 1.299395e+00 incorporatedplace 0.007171
94144 0 111 64779.407794 0.030951 4595 Mandeville 9.055801e-01 incorporatedplace 0.001714
94144 1 52 16659.808008 0.054555 288 5 9.380757e-01 minorcivildivision 0.003121
94144 2 142 16552.587778 0.076353 294 10 1.268721e+00 minorcivildivision 0.008579
94144 3 117 6674.972831 0.089768 292 4 1.587563e+00 minorcivildivision 0.017528
94144 4 102 2351.395482 0.090716 290 7 2.231449e+00 minorcivildivision 0.043378
94144 5 420 1583.133720 0.119043 748 St. Tammany 1.363509e+01 countyorequivalent 0.265297
81159 0 331 37952.187544 0.040709 35587 Fairfield 0.000000e+00 minorcivildivision 0.008721
81159 1 10 36307.296022 0.031535 1115 Southport 9.684198e-01 unincorporatedplace 0.000275
81159 2 10 1851.896274 0.077905 6445 Bridgeport 1.619145e+00 incorporatedplace 0.005400
81159 3 10 1851.896274 0.077905 40352 Bridgeport 1.619145e+00 minorcivildivision 0.005400
81159 4 431 1851.285131 0.143227 557 Fairfield 2.569395e+01 countyorequivalent 0.232811
92130 0 14 13539.631770 0.073424 7594 Pingree Grove 9.010110e-01 incorporatedplace 0.001034
92130 1 19 2013.505228 0.058923 12436 Plato 9.662764e-02 minorcivildivision 0.009436
92130 2 20 1954.343721 0.077028 12435 Rutland 1.786449e+00 minorcivildivision 0.010234
92130 3 14 1526.329436 0.059155 14711 Elgin 1.878104e+00 minorcivildivision 0.009172
92130 4 15 1405.674027 0.054216 8268 Elgin 1.751493e+00 incorporatedplace 0.010671
92130 5 1 639.654870 0.066907 7630 Gilberts 1.149665e+00 incorporatedplace 0.001563
92130 6 65 440.994568 0.116170 1256 Kane 1.311062e+01 countyorequivalent 0.147394
83388 0 190 40301.937746 0.006925 8059 Haines City 0.000000e+00 incorporatedplace 0.004714
83388 1 199 2074.790507 0.042519 42635 Haines City 1.940713e+01 minorcivildivision 0.095913
83388 2 2 2040.899360 0.062266 8365 Lake Hamilton 1.207865e+00 incorporatedplace 0.000980
83388 3 204 427.225387 0.177613 2606 Polk 1.002851e+02 countyorequivalent 0.477500
83388 4 5 156.151417 0.158660 42632 Winter Haven-Auburndale 7.729548e+00 minorcivildivision 0.032020
78884 0 3 6245.294723 0.014198 9026 Courtland 9.463378e-01 unincorporatedplace 0.000480
78884 1 7 202.820408 0.167876 36080 Isleton 3.597146e+00 minorcivildivision 0.034513
78884 2 9 33.864910 0.256400 2521 Sacramento 2.870234e+01 countyorequivalent 0.265762
78884 3 2 19.546437 0.261119 36076 Sacramento 1.170236e+01 minorcivildivision 0.102320
77989 0 308 273562.998430 0.030587 1954 Winchester 9.994213e-01 unincorporatedplace 0.001126
77989 1 2071 171066.927037 0.036404 7942 Paradise 9.937944e-01 unincorporatedplace 0.012106
77989 2 5546 44879.955777 0.038040 30496 Las Vegas 1.012710e+00 minorcivildivision 0.123574
77989 3 405 33682.378077 0.115689 9488 Enterprise 9.938130e-01 unincorporatedplace 0.012024
77989 4 219 6208.391189 0.159031 18787 Las Vegas 1.017195e+00 incorporatedplace 0.035275
77989 5 6036 2884.567643 0.170421 2531 Clark 7.872406e-02 countyorequivalent 2.092515
97577 0 12 149575.143957 0.015105 8590 Twinsburg Heights 1.020869e+00 unincorporatedplace 0.000080
97577 1 151 39278.627215 0.005394 16518 Twinsburg 0.000000e+00 incorporatedplace 0.003844
97577 2 151 39278.627215 0.005394 18478 Twinsburg 0.000000e+00 minorcivildivision 0.003844
97577 3 42 22930.315604 0.034160 18446 Twinsburg 1.476451e+00 minorcivildivision 0.001832
97577 4 195 1671.248139 0.209921 2065 Summit 2.935100e+01 countyorequivalent 0.116679
97577 5 1 669.243928 0.078359 27043 Northfield Center 1.388682e+00 minorcivildivision 0.001494
97577 6 1 138.994985 0.079608 16465 Hudson 2.871459e+00 incorporatedplace 0.007195
97577 7 1 138.994985 0.079608 19219 Hudson 2.871459e+00 minorcivildivision 0.007195
96872 0 168 45426.778637 0.001659 6647 Thomasville 0.000000e+00 incorporatedplace 0.003698
96872 1 180 3524.580564 0.038975 42695 Thomasville 1.280917e+01 minorcivildivision 0.051070
96872 2 180 1334.458015 0.064754 1616 Thomas 3.547290e+01 countyorequivalent 0.134886
87956 0 109 31956.376680 0.003401 46155 Marshfield 1.394359e-01 minorcivildivision 0.003411
87956 1 111 28005.106770 0.002602 9539 Marshfield 0.000000e+00 incorporatedplace 0.003964
87956 2 2 3618.841964 0.036645 47076 Marshfield 8.605641e-01 minorcivildivision 0.000553
87956 3 111 468.291439 0.243576 2844 Wood 5.908160e+01 countyorequivalent 0.237032
87956 4 2 416.253001 0.064979 46127 Marshfield 2.212235e+00 minorcivildivision 0.004805
87956 5 2 4.299965 0.474649 3115 Marathon 1.180701e+02 countyorequivalent 0.465120
95940 0 371 115706.712512 0.022130 490 St. Louis Park 1.662714e-12 incorporatedplace 0.003206
95940 1 371 115706.712512 0.022130 33207 St. Louis Park 1.662714e-12 minorcivildivision 0.003206
95940 2 381 2124.957628 0.145399 2612 Hennepin 5.491899e+01 countyorequivalent 0.179298
95940 3 8 471.259486 0.076644 1126 Minneapolis 6.294373e+00 incorporatedplace 0.016976
95940 4 8 471.259486 0.076644 32808 Minneapolis 6.294373e+00 minorcivildivision 0.016976
77286 0 58 34337.398125 0.027801 5616 Holly Springs 9.846589e-01 incorporatedplace 0.001689
77286 1 270 18083.452651 0.047005 42640 Holly Springs 8.643940e-01 minorcivildivision 0.014931
77286 2 84 17689.751569 0.052595 5617 Canton 9.568725e-01 incorporatedplace 0.004749
77286 3 1385 12579.006431 0.052642 1898 Cherokee 0.000000e+00 countyorequivalent 0.110104
77286 4 225 10210.022714 0.048440 42641 Canton 7.998515e-01 minorcivildivision 0.022037
91878 0 606 99455.971303 0.028927 46938 Petersburg 0.000000e+00 minorcivildivision 0.006093
91878 1 606 99455.971303 0.028927 13385 Petersburg 0.000000e+00 incorporatedplace 0.006093
91878 2 606 99455.971303 0.028927 1853 Petersburg 0.000000e+00 countyorequivalent 0.006093
91878 3 11 15411.607338 0.062342 7191 Matoaca 1.117139e+00 unincorporatedplace 0.000714
91878 4 1 1261.709613 0.027186 4983 Ettrick 1.130076e+00 unincorporatedplace 0.000793
91878 5 3 1089.906048 0.123074 37459 2 1.451742e+00 minorcivildivision 0.002753
91878 6 12 200.762243 0.284793 38698 Matoaca 1.080974e+01 minorcivildivision 0.059772
91878 7 2 162.343671 0.112517 37458 3 3.021868e+00 minorcivildivision 0.012320
91878 8 12 104.228711 0.234883 1070 Chesterfield 1.989523e+01 countyorequivalent 0.115131
91878 9 4 53.999535 0.186242 2115 Prince George 1.315705e+01 countyorequivalent 0.074075
91878 10 5 37.562563 0.274124 1036 Dinwiddie 2.284606e+01 countyorequivalent 0.133111
92633 0 6 398.309173 0.056015 46744 4 7.825700e-01 minorcivildivision 0.015064
92633 1 24 346.417531 0.006830 1851 Powhatan 0.000000e+00 countyorequivalent 0.069281
92633 2 6 244.808961 0.100218 46745 5 6.462369e-01 minorcivildivision 0.024509
92633 3 2 240.073730 0.050555 46743 3 8.797531e-01 minorcivildivision 0.008331
88441 0 2 242248.355439 0.044803 38006 Milwaukee 1.000803e+00 minorcivildivision 0.000008
88441 1 186 19484.168257 0.037756 11096 Menomonee Falls 7.158873e-02 incorporatedplace 0.009546
88441 2 186 19484.168257 0.037756 44316 Menomonee Falls 7.158873e-02 minorcivildivision 0.009546
88441 3 189 1138.213094 0.257795 1225 Waukesha 1.515545e+01 countyorequivalent 0.166050
88441 4 2 253.519766 0.097446 44025 Brookfield 1.767220e+00 minorcivildivision 0.007889
88441 5 2 253.519766 0.097446 11163 Brookfield 1.767220e+00 incorporatedplace 0.007889
88441 6 1 101.162247 0.088300 38157 Germantown 1.961049e+00 minorcivildivision 0.009885
88441 7 1 101.162247 0.088300 11138 Germantown 1.961049e+00 incorporatedplace 0.009885
88441 8 2 72.165711 0.148362 9896 Milwaukee 3.691985e+00 incorporatedplace 0.027714
88441 9 3 23.938056 0.259266 2786 Washington 1.319186e+01 countyorequivalent 0.125323
82342 0 100 129837.644744 0.044383 5062 North Gates 8.664626e-01 unincorporatedplace 0.000770
82342 1 49 85850.476307 0.028275 362 Gates 9.010405e-01 unincorporatedplace 0.000571
82342 2 286 65300.157979 0.028646 30523 Gates 2.441468e-01 minorcivildivision 0.004380
82342 3 29 2540.770647 0.073443 31475 Chili 2.644571e+00 minorcivildivision 0.011414
82342 4 20 1878.343544 0.089032 30521 Rochester 2.709148e+00 minorcivildivision 0.010648
82342 5 20 1878.343544 0.089032 17926 Rochester 2.709148e+00 incorporatedplace 0.010648
82342 6 346 881.055747 0.181044 568 Monroe 6.708901e+01 countyorequivalent 0.392711
82342 7 1 224.063900 0.112515 30522 Brighton 1.770432e+00 minorcivildivision 0.004463
82342 8 1 224.063900 0.112515 5917 Brighton 1.770432e+00 unincorporatedplace 0.004463
78827 0 126 11165.623937 0.052474 6574 Elk Grove 7.320594e-01 incorporatedplace 0.011285
78827 1 83 5721.806996 0.070829 36079 Elk Grove 9.226545e-01 minorcivildivision 0.014506
78827 2 148 556.889624 0.078724 2521 Sacramento 5.317606e+00 countyorequivalent 0.265762
78827 3 48 469.114500 0.188831 36076 Sacramento 2.463076e+00 minorcivildivision 0.102320
78827 4 16 293.237821 0.151243 36078 Galt 1.688721e+00 minorcivildivision 0.054563
78400 0 401 52205.082374 0.060030 46465 Bryan-College Station 1.152629e+00 minorcivildivision 0.007681
78400 1 497 40190.049403 0.021216 12860 College Station 2.704600e-02 incorporatedplace 0.012366
78400 2 515 3573.425485 0.054989 2560 Brazos 1.088136e+01 countyorequivalent 0.144119
78400 3 103 2048.430789 0.117816 46463 South Brazos 3.749570e+00 minorcivildivision 0.050282
78400 4 11 997.798214 0.088266 12859 Bryan 1.906712e+00 incorporatedplace 0.011024
78400 5 9 390.366210 0.172950 46462 West Brazos 2.777183e+00 minorcivildivision 0.023055
88532 0 4248 325100.124768 0.007207 6003 Miami 5.785100e-01 incorporatedplace 0.013067
88532 1 4447 129741.341065 0.049638 43331 Miami 3.208120e+00 minorcivildivision 0.034276
88532 2 33 62082.709630 0.049766 488 Brownsville 1.064092e+00 unincorporatedplace 0.000532
88532 3 4546 8033.736465 0.332285 2483 Miami-Dade 6.727197e+01 countyorequivalent 0.565864
88532 4 54 6214.050744 0.109485 5188 Coral Gables 2.048119e+00 incorporatedplace 0.008690
88532 5 19 5355.747359 0.082945 6004 Miami Beach 1.428020e+00 incorporatedplace 0.003548
88532 6 20 985.146447 0.129137 43352 Miami Beach 3.449400e+00 minorcivildivision 0.020302
88532 7 8 867.372091 0.103401 43371 Key Biscayne 2.040097e+00 minorcivildivision 0.009223
81258 0 1600 141880.735351 0.026199 2560 Fall River 4.364164e-02 minorcivildivision 0.011277
81258 1 1600 141880.735351 0.026199 2661 Fall River 4.364164e-02 incorporatedplace 0.011277
81258 2 1633 8425.553631 0.034000 1713 Bristol 1.644974e+01 countyorequivalent 0.193815
81258 3 10 2999.232637 0.046271 2416 Somerset 1.299802e+00 minorcivildivision 0.003334
81258 4 10 2999.232637 0.046271 5747 Somerset 1.299802e+00 unincorporatedplace 0.003334
81258 5 8 783.603382 0.105533 2530 Freetown 1.914921e+00 minorcivildivision 0.010209
81258 6 11 608.799191 0.161433 2404 Westport 2.618340e+00 minorcivildivision 0.018068
81258 7 1 141.040019 0.099162 2415 Swansea 1.638298e+00 minorcivildivision 0.007090
86287 0 375 186597.718720 0.007590 17056 Lancaster 0.000000e+00 minorcivildivision 0.002010
86287 1 375 186597.718720 0.007590 12888 Lancaster 0.000000e+00 incorporatedplace 0.002010
86287 2 382 1420.611750 0.058554 1001 Lancaster 1.328021e+02 countyorequivalent 0.268898
86287 3 1 604.465162 0.022057 17055 Lancaster 1.823197e+00 minorcivildivision 0.001654
86287 4 3 550.289527 0.089755 17094 East Lampeter 3.712721e+00 minorcivildivision 0.005452
86287 5 2 303.744124 0.058771 16230 Manheim 4.276402e+00 minorcivildivision 0.006584
86287 6 1 220.329467 0.064929 16182 West Lampeter 3.258408e+00 minorcivildivision 0.004539

In [9]:
df.to_csv('./validated-boundary-vs-government-unit-density.csv')

In [11]:
pd.read_csv('./validated-boundary-vs-government-unit-density.csv')


Out[11]:
Unnamed: 0 rank count density distance_to_headquarters fc_id id name percent_difference_to_verified_boundary source st_area
0 0 0 585 99716.978516 0.011408 78801 11589 Corsicana 0.000000e+00 incorporatedplace 0.005867
1 1 1 617 6956.982835 0.049155 78801 40009 Corsicana 1.411741e+01 minorcivildivision 0.088688
2 2 2 620 2308.610455 0.046837 78801 2605 Navarro 4.477773e+01 countyorequivalent 0.268560
3 0 0 3 22941.311075 0.007315 85026 5560 Isleton 1.959799e-01 incorporatedplace 0.000131
4 1 1 3 86.923032 0.015528 85026 36080 Isleton 2.839006e+02 minorcivildivision 0.034513
5 2 2 3 11.288303 0.393362 85026 2521 Sacramento 2.192813e+03 countyorequivalent 0.265762
6 0 0 372 19210.181569 0.018676 78578 18456 Concord 0.000000e+00 incorporatedplace 0.019365
7 1 1 372 19210.181569 0.018676 78578 30145 Concord 0.000000e+00 minorcivildivision 0.019365
8 2 2 373 1357.456627 0.156079 78578 1813 Merrimack 1.318964e+01 countyorequivalent 0.274779
9 0 0 492 411712.758527 0.010133 77887 2042 Somerville 0.000000e+00 minorcivildivision 0.001195
10 1 1 492 411712.758527 0.010133 77887 1517 Somerville 0.000000e+00 incorporatedplace 0.001195
11 2 2 12 5964.478376 0.031102 77887 2027 Cambridge 2.683596e+00 incorporatedplace 0.002012
12 3 3 12 5964.478376 0.031102 77887 2016 Cambridge 2.683596e+00 minorcivildivision 0.002012
13 4 4 506 2106.446964 0.315218 77887 2244 Middlesex 2.000153e+02 countyorequivalent 0.240215
14 5 5 2 815.332877 0.036952 77887 1539 Medford 3.052694e+00 incorporatedplace 0.002453
15 6 6 2 815.332877 0.036952 77887 1722 Medford 3.052694e+00 minorcivildivision 0.002453
16 7 7 1 39.432999 0.095002 77887 1564 Boston 2.222117e+01 incorporatedplace 0.025359
17 8 8 1 39.432999 0.095002 77887 2402 Boston 2.222117e+01 minorcivildivision 0.025359
18 9 9 1 29.395339 0.113664 77887 1712 Suffolk 2.946759e+01 countyorequivalent 0.034019
19 0 0 387 41660.471964 0.029491 83442 43286 Hamden 0.000000e+00 minorcivildivision 0.009289
20 1 1 444 1848.318459 0.081168 83442 2282 New Haven 2.485946e+01 countyorequivalent 0.240218
21 2 2 3 509.609601 0.083484 83442 1128 North Haven 1.633719e+00 unincorporatedplace 0.005887
22 3 3 3 509.609601 0.083484 83442 43250 North Haven 1.633719e+00 minorcivildivision 0.005887
23 4 4 1 166.779401 0.064188 83442 35740 Bethany 1.645462e+00 minorcivildivision 0.005996
24 5 5 1 107.262109 0.090355 83442 36054 Cheshire 2.003614e+00 minorcivildivision 0.009323
25 6 6 1 89.860200 0.129566 83442 43829 Wallingford 2.197970e+00 minorcivildivision 0.011128
26 0 0 107 65950.416117 0.076698 81727 6626 Cumming 9.740965e-01 incorporatedplace 0.001622
27 1 1 564 19095.228686 0.072461 81727 42689 Cumming 5.284300e-01 minorcivildivision 0.029536
28 2 2 1009 16109.539393 0.056274 81727 1468 Forsyth 0.000000e+00 countyorequivalent 0.062634
29 3 3 133 11345.180412 0.063114 81727 42688 Silver City 8.128317e-01 minorcivildivision 0.011723
30 4 4 100 9823.683918 0.088605 81727 42690 Chestatee 8.374760e-01 minorcivildivision 0.010179
31 0 0 29 1254.014221 0.068297 81531 7956 Palm Coast 8.129361e-01 incorporatedplace 0.023126
32 1 1 106 770.831161 0.047294 81531 2591 Flagler 1.308237e-01 countyorequivalent 0.137514
33 2 2 75 699.235919 0.088284 81531 42121 Bunnell 1.190632e-01 minorcivildivision 0.107260
34 3 3 23 688.903639 0.093834 81531 7957 Bunnell 7.256013e-01 incorporatedplace 0.033386
35 0 0 3067 36616.371421 0.094370 78792 45799 Corpus Christi 9.758430e-01 minorcivildivision 0.083760
36 1 1 3154 27174.119424 0.149747 78792 14022 Corpus Christi 0.000000e+00 incorporatedplace 0.116066
37 2 2 3180 11509.122911 0.116860 78792 3171 Nueces 1.580866e+00 countyorequivalent 0.276303
38 3 3 70 969.215515 0.225959 78792 45780 Port Aransas 5.864821e-01 minorcivildivision 0.072223
39 0 0 121 35694.222690 0.017323 89555 13985 Murray 0.000000e+00 incorporatedplace 0.003390
40 1 1 35 21492.711615 0.052182 89555 13192 Midvale 1.480385e+00 incorporatedplace 0.001628
41 2 2 9 3008.346095 0.059993 89555 13173 Taylorsville 1.882526e+00 incorporatedplace 0.002992
42 3 3 197 2193.350754 0.034171 89555 36344 Salt Lake City 2.549541e+01 minorcivildivision 0.089817
43 4 4 7 1858.352424 0.065920 89555 3079 Millcreek 2.111175e+00 unincorporatedplace 0.003767
44 5 5 206 925.023140 0.033858 89555 2428 Salt Lake 6.469422e+01 countyorequivalent 0.222697
45 6 6 2 916.002913 0.067270 89555 13191 Holladay 1.644089e+00 incorporatedplace 0.002183
46 7 7 18 583.118099 0.118310 89555 13987 Salt Lake City 1.010602e+01 incorporatedplace 0.030869
47 8 8 2 223.613326 0.128260 89555 13174 West Jordan 3.638426e+00 incorporatedplace 0.008944
48 0 0 1894 230033.036127 0.092844 79671 10570 Des Moines 6.754758e-01 minorcivildivision 0.008234
49 1 1 1391 193364.143301 0.006304 79671 8786 Lee 7.164638e-01 minorcivildivision 0.007194
50 2 2 3876 152771.061951 0.049763 79671 1160 Des Moines 0.000000e+00 incorporatedplace 0.025371
51 3 3 485 61414.315009 0.120182 79671 11100 Bloomfield 9.069495e-01 minorcivildivision 0.007897
52 4 4 3888 23466.949955 0.095099 79671 1543 Polk 5.672208e+00 countyorequivalent 0.165680
53 5 5 15 3475.138046 0.094185 79671 8819 Saylor 1.162768e+00 minorcivildivision 0.004316
54 6 6 15 3008.289264 0.068737 79671 11122 Delaware 1.119843e+00 minorcivildivision 0.004986
55 7 7 7 1721.120479 0.084673 79671 11086 Allen 1.043381e+00 minorcivildivision 0.004067
56 8 8 1 385.068180 0.064628 79671 1915 Pleasant Hill 1.102358e+00 incorporatedplace 0.002597
57 9 9 2 373.912367 0.088354 79671 9333 Four Mile 1.210823e+00 minorcivildivision 0.005349
58 0 0 487 117226.959850 0.039507 73375 962 Alexandria 0.000000e+00 countyorequivalent 0.004154
59 1 1 487 117226.959850 0.039507 73375 14393 Alexandria 0.000000e+00 incorporatedplace 0.004154
60 2 2 487 117226.959850 0.039507 73375 36573 Alexandria 0.000000e+00 minorcivildivision 0.004154
61 3 3 3 9879.903548 0.037054 73375 9915 Huntington 1.073092e+00 unincorporatedplace 0.000304
62 4 4 4 3377.886917 0.075601 73375 4674 Groveton 1.285045e+00 unincorporatedplace 0.001184
63 5 5 16 2282.037137 0.082572 73375 46547 Arlington 2.687702e+00 minorcivildivision 0.007011
64 6 6 16 2282.037137 0.082572 73375 1773 Arlington 2.687702e+00 unincorporatedplace 0.007011
65 7 7 16 2282.037137 0.082572 73375 2082 Arlington 2.687702e+00 countyorequivalent 0.007011
66 8 8 5 1771.883715 0.107766 73375 86037 George Washington Memorial Parkway 1.623647e+00 reserve 0.002822
67 9 9 1 1303.512306 0.040447 73375 3491 Belle Haven 1.184664e+00 unincorporatedplace 0.000767
68 10 10 2 1189.849825 0.081166 73375 395 Fort Hunt 1.404610e+00 unincorporatedplace 0.001681
69 11 11 7 877.492815 0.108719 73375 36632 Lee 2.920229e+00 minorcivildivision 0.007977
70 12 12 1 667.873413 0.068467 73375 966 Rose Hill 1.360416e+00 unincorporatedplace 0.001497
71 13 13 9 482.368208 0.163884 73375 36630 Mount Vernon 5.491200e+00 minorcivildivision 0.018658
72 14 14 24 219.913828 0.230237 73375 2382 Fairfax 2.726983e+01 countyorequivalent 0.109134
73 15 15 1 54.404531 0.093494 73375 2636 District of Columbia 5.424493e+00 countyorequivalent 0.018381
74 16 16 1 54.404531 0.093494 73375 8586 Washington 5.424493e+00 incorporatedplace 0.018381
75 17 17 1 54.404531 0.093494 73375 35662 Washington 5.424493e+00 minorcivildivision 0.018381
76 0 0 24 3683.634692 0.019080 81646 6573 Folsom 1.989530e-01 incorporatedplace 0.006515
77 1 1 24 2999.677695 0.023788 81646 40995 Folsom 1.293226e-02 minorcivildivision 0.008001
78 2 2 24 90.306426 0.282723 81646 2521 Sacramento 3.193298e+01 countyorequivalent 0.265762
79 0 0 572 35931.287606 0.070830 81134 9263 Fairbanks 1.636272e+00 incorporatedplace 0.015919
80 1 1 163 18486.792632 0.056939 81134 31371 NaN 1.817228e+00 reserve 0.008817
81 2 2 49 12628.511233 0.064480 81134 18617 NaN 1.312660e+00 reserve 0.003880
82 3 3 3 719.386319 0.069369 81134 8453 South Van Horn 1.690598e+00 unincorporatedplace 0.004170
83 4 4 5 531.497856 0.101724 81134 7355 College 2.557883e+00 unincorporatedplace 0.009407
84 5 5 606 166.506201 1.161507 81134 43531 Fairbanks North Star 6.017107e+02 minorcivildivision 3.639504
85 6 6 606 166.506201 1.161507 81134 3129 Fairbanks North Star 6.017107e+02 countyorequivalent 3.639504
86 7 7 1 93.070000 0.071105 81134 3657 Farmers Loop 2.779332e+00 unincorporatedplace 0.010745
87 8 8 12 17.034910 0.410944 81134 86572 Fort Wainwright 1.174334e+02 reserve 0.704436
88 9 9 606 6.042289 2.212025 81134 610 Doyon Alaska Native Regional Corporation 1.660778e+04 nativeamericanarea 100.293110
89 0 0 55 62330.674745 0.013787 81083 3714 Marlton 8.910430e-01 unincorporatedplace 0.000882
90 1 1 162 20003.650573 0.040419 81083 30022 Evesham 0.000000e+00 minorcivildivision 0.008099
91 2 2 12 1814.535715 0.075821 81083 31620 Cherry Hill 1.816601e+00 minorcivildivision 0.006613
92 3 3 164 733.610331 0.251992 81083 775 Burlington 2.660404e+01 countyorequivalent 0.223552
93 4 4 16 258.432544 0.096890 81083 799 Camden 8.644816e+00 countyorequivalent 0.061912
94 5 5 1 166.751513 0.058548 81083 30697 Mount Laurel 1.740499e+00 minorcivildivision 0.005997
95 0 0 465 55713.807202 0.049072 97144 5969 Davie 2.309553e-02 incorporatedplace 0.008346
96 1 1 484 24608.876418 0.101499 97144 41280 Davie 1.407121e+00 minorcivildivision 0.019668
97 2 2 16 8188.399081 0.051839 97144 5972 Cooper City 1.226153e+00 incorporatedplace 0.001954
98 3 3 12 2341.155903 0.062605 97144 5311 Plantation 1.599819e+00 incorporatedplace 0.005126
99 4 4 514 1661.955600 0.232465 97144 2941 Broward 3.574529e+01 countyorequivalent 0.309274
100 5 5 13 1047.975517 0.086688 97144 41182 Plantation 2.457296e+00 minorcivildivision 0.012405
101 6 6 11 633.478165 0.110823 97144 41266 Hollywood 3.027079e+00 minorcivildivision 0.017364
102 7 7 1 511.440055 0.076121 97144 5970 Dania Beach 1.229228e+00 incorporatedplace 0.001955
103 8 8 4 471.411574 0.118498 97144 5959 Fort Lauderdale 2.007747e+00 incorporatedplace 0.008485
104 9 9 5 314.615621 0.120584 97144 41183 Miramar-Pembroke Pines 2.870921e+00 minorcivildivision 0.015892
105 10 10 2 278.880163 0.083310 97144 5938 Hollywood 1.851429e+00 incorporatedplace 0.007172
106 11 11 1 122.961027 0.113332 97144 5288 Pembroke Pines 1.965700e+00 incorporatedplace 0.008133
107 12 12 1 48.398715 0.144073 97144 41278 Fort Lauderdale 3.454307e+00 minorcivildivision 0.020662
108 0 0 169 44570.682378 0.027857 98703 9608 Wauwatosa 0.000000e+00 incorporatedplace 0.003792
109 1 1 169 44570.682378 0.027857 98703 39847 Wauwatosa 0.000000e+00 minorcivildivision 0.003792
110 2 2 177 520.294565 0.429854 98703 2839 Milwaukee 8.871944e+01 countyorequivalent 0.340192
111 3 3 1 306.482166 0.048851 98703 39756 West Allis 1.860513e+00 minorcivildivision 0.003263
112 4 4 1 306.482166 0.048851 98703 9609 West Allis 1.860513e+00 incorporatedplace 0.003263
113 5 5 7 252.851922 0.043818 98703 39930 Milwaukee 8.301202e+00 minorcivildivision 0.027684
114 6 6 7 252.579989 0.043740 98703 9896 Milwaukee 8.309063e+00 incorporatedplace 0.027714
115 0 0 292 73221.399628 0.020073 78423 4999 Collinsville 0.000000e+00 incorporatedplace 0.003988
116 1 1 296 30889.743830 0.033008 78423 8841 Collinsville 1.832355e+00 minorcivildivision 0.009582
117 2 2 6 4128.381041 0.061733 78423 6934 Maryville 1.364441e+00 incorporatedplace 0.001453
118 3 3 25 2658.318678 0.054299 78423 9665 Caseyville 3.169861e+00 minorcivildivision 0.009404
119 4 4 308 1547.923106 0.180484 78423 2385 Madison 4.921336e+01 countyorequivalent 0.198976
120 5 5 1 296.749830 0.089498 78423 6932 Pontoon Beach 1.845016e+00 incorporatedplace 0.003370
121 6 6 32 177.571551 0.207005 78423 2409 St. Clair 4.587048e+01 countyorequivalent 0.180209
122 0 0 19 5772.177368 0.024143 83122 9569 Greenfield 0.000000e+00 incorporatedplace 0.003292
123 1 1 19 5772.177368 0.024143 83122 40038 Greenfield 0.000000e+00 minorcivildivision 0.003292
124 2 2 19 55.850829 0.451075 83122 2839 Milwaukee 1.023499e+02 countyorequivalent 0.340192
125 0 0 1 28.974344 0.015611 93480 36080 Isleton 3.470353e+00 minorcivildivision 0.034513
126 1 1 1 3.762768 0.401068 93480 2521 Sacramento 3.340125e+01 countyorequivalent 0.265762
127 0 0 65 28955.239927 0.010647 99191 16256 West Warwick 0.000000e+00 minorcivildivision 0.002245
128 1 1 68 1290.801934 0.065244 99191 706 Kent 2.246730e+01 countyorequivalent 0.052680
129 2 2 2 143.349941 0.102625 99191 14832 Warwick 7.215074e+00 incorporatedplace 0.013952
130 3 3 2 143.349941 0.102625 99191 16189 Warwick 7.215074e+00 minorcivildivision 0.013952
131 4 4 1 57.210633 0.138810 99191 16221 Coventry 8.786406e+00 minorcivildivision 0.017479
132 5 5 2 16.343976 0.173982 99191 635 Providence 5.551124e+01 countyorequivalent 0.122369
133 0 0 228 34765.445609 0.011000 77263 1299 Chelmsford 0.000000e+00 minorcivildivision 0.006558
134 1 1 237 986.616463 0.119495 77263 2244 Middlesex 3.562798e+01 countyorequivalent 0.240215
135 2 2 3 726.514194 0.050785 77263 2026 Lowell 1.629637e+00 incorporatedplace 0.004129
136 3 3 3 726.514194 0.050785 77263 2387 Lowell 1.629637e+00 minorcivildivision 0.004129
137 4 4 2 267.734974 0.093729 77263 1688 Billerica 2.139037e+00 minorcivildivision 0.007470
138 0 0 436 16390.472516 0.067698 93456 16564 Rio Rancho 0.000000e+00 incorporatedplace 0.026601
139 1 1 471 4410.983578 0.120777 93456 27653 Rio Rancho 3.356640e+00 minorcivildivision 0.106779
140 2 2 6 2161.896016 0.032745 93456 16565 Corrales 1.104333e+00 incorporatedplace 0.002775
141 3 3 480 500.895241 0.481909 93456 651 Sandoval 3.532715e+01 countyorequivalent 0.958284
142 4 4 1 100.238192 0.088513 93456 69 Sandia Pueblo 1.375035e+00 nativeamericanarea 0.009976
143 0 0 221 44018.694737 0.016071 77563 36694 Beloit 8.064430e-02 minorcivildivision 0.005021
144 1 1 221 44018.694737 0.016071 77563 10073 Beloit 8.064430e-02 incorporatedplace 0.005021
145 2 2 224 1084.646488 0.167419 77563 2767 Rock 4.065087e+01 countyorequivalent 0.206519
146 3 3 1 339.541884 0.086570 77563 7730 Roscoe 1.593975e+00 incorporatedplace 0.002945
147 4 4 2 262.010741 0.064325 77563 36693 Beloit 2.526538e+00 minorcivildivision 0.007633
148 5 5 1 94.287310 0.092490 77563 10477 Rockton 3.138908e+00 minorcivildivision 0.010606
149 6 6 1 6.807011 0.218898 77563 2387 Winnebago 3.062792e+01 countyorequivalent 0.146907
150 0 0 6027 165634.613560 0.105513 91031 18656 Omaha 0.000000e+00 incorporatedplace 0.036387
151 1 1 6027 165634.613560 0.105513 91031 34883 Omaha 0.000000e+00 minorcivildivision 0.036387
152 2 2 6328 66974.530378 0.221692 91031 1643 Douglas 1.596610e+00 countyorequivalent 0.094484
153 3 3 1 1779.292981 0.038991 91031 2129 Carter Lake 1.015446e+00 incorporatedplace 0.000562
154 4 4 1 197.288445 0.071692 91031 12157 Kane 1.139299e+00 minorcivildivision 0.005069
155 5 5 1 3.742254 0.402553 91031 1987 Pottawattamie 8.343730e+00 countyorequivalent 0.267219
156 0 0 241 74792.081702 0.021430 91743 11236 Pendleton 8.782634e-01 incorporatedplace 0.003222
157 1 1 270 1028.695376 0.194801 91743 22144 Pendleton 4.035100e+01 minorcivildivision 0.262468
158 2 2 274 283.927139 0.098442 91743 437 Umatilla 1.507934e+02 countyorequivalent 0.965036
159 0 0 1565 144147.869234 0.037916 83153 30370 Gilmer 6.830613e-01 minorcivildivision 0.010857
160 1 1 3594 104917.340475 0.045056 83153 15085 Greensboro 0.000000e+00 incorporatedplace 0.034256
161 2 2 2029 86714.472611 0.083209 83153 30341 Morehead 3.169387e-01 minorcivildivision 0.023399
162 3 3 3739 21940.199056 0.018845 83153 1520 Guilford 3.974897e+00 countyorequivalent 0.170418
163 4 4 37 3239.725451 0.110950 83153 30344 Jefferson 1.333398e+00 minorcivildivision 0.011421
164 5 5 7 968.341653 0.104297 83153 30342 Monroe 1.211027e+00 minorcivildivision 0.007229
165 0 0 106 354716.218751 0.002133 86361 17500 Larchmont 0.000000e+00 incorporatedplace 0.000299
166 1 1 108 27733.097176 0.011367 86361 29070 Mamaroneck 1.203168e+01 minorcivildivision 0.003894
167 2 2 108 777.470159 0.224171 86361 448 Westchester 4.638525e+02 countyorequivalent 0.138912
168 0 0 265 25978.706569 0.019475 84012 31131 Henrietta 7.032039e-09 minorcivildivision 0.010201
169 1 1 10 2240.638996 0.078569 84012 5917 Brighton 1.437522e+00 unincorporatedplace 0.004463
170 2 2 10 2240.638996 0.078569 84012 30522 Brighton 1.437522e+00 minorcivildivision 0.004463
171 3 3 9 845.254595 0.100707 84012 17926 Rochester 2.043822e+00 incorporatedplace 0.010648
172 4 4 9 845.254595 0.100707 84012 30521 Rochester 2.043822e+00 minorcivildivision 0.010648
173 5 5 290 738.457129 0.237685 84012 568 Monroe 3.749855e+01 countyorequivalent 0.392711
174 0 0 413 120345.874485 0.029862 75808 1039 Bristol 0.000000e+00 countyorequivalent 0.003432
175 1 1 413 120345.874485 0.029862 75808 10694 Bristol 0.000000e+00 incorporatedplace 0.003432
176 2 2 413 120345.874485 0.029862 75808 37462 Bristol 0.000000e+00 minorcivildivision 0.003432
177 0 0 5127 481513.367546 0.017422 93595 17926 Rochester 1.577109e-01 incorporatedplace 0.010648
178 1 1 5127 481513.367546 0.017422 93595 30521 Rochester 1.577109e-01 minorcivildivision 0.010648
179 2 2 5189 13213.289796 0.171517 93595 568 Monroe 3.182556e+01 countyorequivalent 0.392711
180 3 3 23 5153.469691 0.044468 93595 5917 Brighton 1.145465e+00 unincorporatedplace 0.004463
181 4 4 23 5153.469691 0.044468 93595 30522 Brighton 1.145465e+00 minorcivildivision 0.004463
182 5 5 14 2898.849830 0.071351 93595 31231 Irondequoit 1.396483e+00 minorcivildivision 0.004830
183 6 6 14 2898.849830 0.071351 93595 4828 Irondequoit 1.396483e+00 unincorporatedplace 0.004830
184 7 7 3 684.966692 0.101370 93595 30523 Gates 1.363100e+00 minorcivildivision 0.004380
185 8 8 3 262.838343 0.157612 93595 31475 Chili 1.926219e+00 minorcivildivision 0.011414
186 0 0 102 44904.643441 0.005796 91180 1242 Orono 6.068044e-01 unincorporatedplace 0.002271
187 1 1 115 19906.620607 0.043241 91180 896 Orono 0.000000e+00 minorcivildivision 0.005777
188 2 2 2 156.587539 0.084116 91180 897 Old Town 3.210917e+00 minorcivildivision 0.012772
189 3 3 2 156.587539 0.084116 91180 3063 Old Town 3.210917e+00 incorporatedplace 0.012772
190 4 4 119 112.396473 0.518612 91180 1234 Penobscot 1.822711e+02 countyorequivalent 1.058752
191 0 0 702 79309.854459 0.002641 80460 38261 Eau Claire 1.722006e-01 minorcivildivision 0.008851
192 1 1 728 72374.224039 0.009047 80460 9797 Eau Claire 7.339930e-02 incorporatedplace 0.010059
193 2 2 26 21532.613515 0.056059 80460 36974 Eau Claire 9.011987e-01 minorcivildivision 0.001207
194 3 3 713 3755.965227 0.228295 80460 3051 Eau Claire 1.858140e+01 countyorequivalent 0.189831
195 4 4 8 493.525419 0.114069 80460 37709 Washington 2.633092e+00 minorcivildivision 0.016210
196 5 5 2 247.049130 0.103221 80460 37710 Union 1.814295e+00 minorcivildivision 0.008096
197 6 6 30 97.354737 0.337282 80460 3122 Chippewa 3.217805e+01 countyorequivalent 0.308151
198 0 0 17 10993.465002 0.022096 74913 4268 Oakhurst 9.339606e-01 unincorporatedplace 0.001546
199 1 1 2 369.962171 0.076324 74913 18440 Sand Springs 2.133643e+00 incorporatedplace 0.005406
200 2 2 35 317.361942 0.108083 74913 24604 Tulsa 2.896339e+01 minorcivildivision 0.110284
201 3 3 35 229.959427 0.117915 74913 516 Tulsa 4.035177e+01 countyorequivalent 0.152201
202 4 4 3 57.533207 0.156373 74913 18445 Tulsa 1.516196e+01 incorporatedplace 0.052144
203 5 5 35 28.367408 0.449126 74913 398 Creek OTSA 3.342159e+02 nativeamericanarea 1.233810
204 0 0 83 48014.754997 0.009581 74867 31385 Berkeley Heights 0.000000e+00 minorcivildivision 0.001729
205 1 1 83 2855.219217 0.126596 74867 143 Union 1.581649e+01 countyorequivalent 0.029070
206 0 0 278 107020.055328 0.027164 79600 2434 Waverly 7.252662e-01 unincorporatedplace 0.002598
207 1 1 334 35324.738659 0.013665 79600 7947 Delta 0.000000e+00 minorcivildivision 0.009455
208 2 2 4 4850.050565 0.052538 79600 4996 Lansing 1.087226e+00 minorcivildivision 0.000825
209 3 3 23 2258.798236 0.070787 79600 4897 Watertown 2.076919e+00 minorcivildivision 0.010182
210 4 4 343 2083.762975 0.229011 79600 2333 Eaton 1.640918e+01 countyorequivalent 0.164606
211 5 5 12 1150.120728 0.109199 79600 91 Lansing 2.103495e+00 incorporatedplace 0.010434
212 6 6 36 219.343195 0.210000 79600 2285 Clinton 1.835845e+01 countyorequivalent 0.164126
213 0 0 331 32299.333543 0.004489 95681 41084 Southington 0.000000e+00 minorcivildivision 0.010248
214 1 1 341 1618.982084 0.245160 95681 641 Hartford 1.955313e+01 countyorequivalent 0.210626
215 2 2 1 365.107719 0.068356 95681 36272 Plainville 1.267267e+00 minorcivildivision 0.002739
216 3 3 1 133.177350 0.095478 95681 6359 Bristol 1.732715e+00 incorporatedplace 0.007509
217 4 4 1 133.177350 0.095478 95681 41101 Bristol 1.732715e+00 minorcivildivision 0.007509
218 5 5 6 24.977276 0.261066 95681 2282 New Haven 2.444076e+01 countyorequivalent 0.240218
219 0 0 767 147143.347114 0.012786 73310 13076 Albany 7.817522e-01 incorporatedplace 0.005213
220 1 1 34 24733.752557 0.056886 73310 11190 Millersburg 1.010990e+00 incorporatedplace 0.001375
221 2 2 127 21317.965074 0.049596 73310 21682 North Albany 7.515723e-01 minorcivildivision 0.005957
222 3 3 747 18402.307691 0.032746 73310 22123 Albany 1.566131e+00 minorcivildivision 0.040593
223 4 4 756 1117.420409 0.591143 73310 327 Linn 2.799422e+01 countyorequivalent 0.676558
224 5 5 129 648.721092 0.352950 73310 574 Benton 8.676782e+00 countyorequivalent 0.198853
225 0 0 621 100428.175657 0.027382 77599 35516 Champaign City 1.806437e-12 minorcivildivision 0.006184
226 1 1 621 100428.175657 0.027382 77599 8542 Champaign 1.806437e-12 incorporatedplace 0.006184
227 2 2 635 2323.693901 0.053241 77599 2878 Champaign 4.319354e+01 countyorequivalent 0.273272
228 3 3 6 1846.661827 0.048359 77599 43327 Cunningham 1.525446e+00 minorcivildivision 0.003249
229 4 4 6 1846.661827 0.048359 77599 5122 Urbana 1.525446e+00 incorporatedplace 0.003249
230 5 5 7 1378.022907 0.067110 77599 35517 Champaign 1.821496e+00 minorcivildivision 0.005080
231 6 6 1 121.050339 0.089198 77599 43524 Hensley 2.335974e+00 minorcivildivision 0.008261
232 0 0 7459 299610.202417 0.010716 74286 764 Baltimore 1.173964e-01 incorporatedplace 0.024896
233 1 1 7459 299610.202417 0.010716 74286 2401 Baltimore 1.173964e-01 countyorequivalent 0.024896
234 2 2 7459 299610.202417 0.010716 74286 2732 Baltimore 1.173964e-01 minorcivildivision 0.024896
235 0 0 113 8573.335642 0.016241 97886 5210 Vallejo 0.000000e+00 incorporatedplace 0.013180
236 1 1 119 4116.547787 0.046265 97886 40579 Vallejo 1.230566e+00 minorcivildivision 0.028908
237 2 2 119 492.526738 0.367575 97886 2514 Solano 1.733110e+01 countyorequivalent 0.241611
238 0 0 4 1898.144305 0.008800 84030 3585 Herald 9.155666e-01 unincorporatedplace 0.002107
239 1 1 6 109.964183 0.050931 84030 36078 Galt 1.216894e+00 minorcivildivision 0.054563
240 2 2 6 22.576606 0.187226 84030 2521 Sacramento 9.678897e+00 countyorequivalent 0.265762
241 0 0 3123 88533.359291 0.132850 86381 18787 Las Vegas 9.430606e-02 incorporatedplace 0.035275
242 1 1 3300 26704.625688 0.051649 86381 30496 Las Vegas 2.831487e+00 minorcivildivision 0.123574
243 2 2 5 4440.957767 0.039875 86381 1954 Winchester 1.030465e+00 unincorporatedplace 0.001126
244 3 3 27 3120.937736 0.091616 86381 7875 Sunrise Manor 1.234459e+00 unincorporatedplace 0.008651
245 4 4 54 2037.096531 0.126214 86381 18786 North Las Vegas 1.717699e+00 incorporatedplace 0.026508
246 5 5 3 1850.157655 0.266381 86381 333 Las Vegas Indian Colony 1.040286e+00 nativeamericanarea 0.001621
247 6 6 3329 1590.908828 0.133128 86381 2531 Clark 5.574585e+01 countyorequivalent 2.092515
248 7 7 14 1156.415731 0.094514 86381 7942 Paradise 1.328253e+00 unincorporatedplace 0.012106
249 0 0 1251 61706.609379 0.022190 76927 2402 Cedar Rapids 1.983832e-12 incorporatedplace 0.020273
250 1 1 1251 61706.609379 0.022190 76927 12747 Cedar Rapids 1.983832e-12 minorcivildivision 0.020273
251 2 2 1261 6176.601400 0.115652 76927 1577 Linn 9.070241e+00 countyorequivalent 0.204158
252 3 3 4 543.285715 0.133850 76927 12717 Bertram 1.363167e+00 minorcivildivision 0.007363
253 0 0 174 44497.445626 0.003224 77971 12235 Claremore 5.705466e-01 incorporatedplace 0.003910
254 1 1 217 3678.808859 0.048976 77971 20565 Claremore 8.854198e+00 minorcivildivision 0.058986
255 2 2 223 1205.047643 0.060509 77971 450 Rogers 2.991501e+01 countyorequivalent 0.185055
256 3 3 1 433.831537 0.052046 77971 4253 Justice 1.367359e+00 unincorporatedplace 0.002305
257 4 4 223 123.358666 0.436250 77971 250 Cherokee OTSA 3.009979e+02 nativeamericanarea 1.807737
258 0 0 29 1659.108357 0.108231 77030 16221 Coventry 8.130265e-03 minorcivildivision 0.017479
259 1 1 30 569.471441 0.024542 77030 706 Kent 2.021010e+00 countyorequivalent 0.052680
260 2 2 1 71.674970 0.137000 77030 14832 Warwick 1.799829e+00 incorporatedplace 0.013952
261 3 3 1 71.674970 0.137000 77030 16189 Warwick 1.799829e+00 minorcivildivision 0.013952
262 0 0 1061 153477.698912 0.009821 89517 19265 City of Muncie 9.955738e-02 incorporatedplace 0.006913
263 1 1 1064 111793.680356 0.004354 89517 13568 Center 4.540970e-01 minorcivildivision 0.009518
264 2 2 1110 10230.196781 0.038061 89517 2854 Delaware 1.337462e+01 countyorequivalent 0.108502
265 3 3 13 1567.464239 0.079745 89517 13094 Monroe 2.098759e+00 minorcivildivision 0.008294
266 4 4 5 612.295522 0.077487 89517 13040 Hamilton 2.061478e+00 minorcivildivision 0.008166
267 0 0 149 14851.169743 0.004371 81163 4924 Fairfield 3.780732e-01 incorporatedplace 0.010033
268 1 1 153 2373.269966 0.061684 81163 40582 Fairfield-Suisun City 6.233082e+00 minorcivildivision 0.064468
269 2 2 1 901.152636 0.035144 81163 5212 Suisun City 1.122881e+00 incorporatedplace 0.001110
270 3 3 153 633.248664 0.101583 81163 2514 Solano 2.598460e+01 countyorequivalent 0.241611
271 0 0 65 97933.514700 0.008745 78074 18638 Clayton 0.000000e+00 incorporatedplace 0.000664
272 1 1 34 23096.504331 0.024193 78074 31563 Hadley 2.279837e+00 minorcivildivision 0.001472
273 2 2 35 8076.376872 0.040228 78074 34931 Clayton 6.467450e+00 minorcivildivision 0.004334
274 3 3 1 631.825376 0.015896 78074 19357 University City 3.384630e+00 incorporatedplace 0.001583
275 4 4 76 542.235673 0.107575 78074 1872 St. Louis 2.101755e+02 countyorequivalent 0.140160
276 5 5 1 508.477316 0.028257 78074 32241 University 3.963101e+00 minorcivildivision 0.001967
277 6 6 1 436.383382 0.046921 78074 15005 Ladue 4.452628e+00 incorporatedplace 0.002292
278 7 7 1 56.513948 0.092343 78074 2111 St. Louis 2.766013e+01 countyorequivalent 0.017695
279 8 8 1 56.513948 0.092343 78074 18508 St. Louis 2.766013e+01 incorporatedplace 0.017695
280 9 9 1 56.513948 0.092343 78074 33173 St. Louis 2.766013e+01 minorcivildivision 0.017695
281 0 0 517 77056.331484 0.031957 81599 5164 Florence 1.459299e-01 incorporatedplace 0.006709
282 1 1 519 19940.260357 0.095420 81599 41521 Florence 2.651716e+00 minorcivildivision 0.026028
283 2 2 1 9767.942737 0.043100 81599 88306 NaN 9.860600e-01 reserve 0.000102
284 3 3 524 2850.756578 0.104297 81599 966 Lauderdale 2.403570e+01 countyorequivalent 0.183811
285 4 4 5 183.491186 0.142346 81599 41510 Oakland 4.609777e+00 minorcivildivision 0.027249
286 0 0 5772 74189.876612 0.022302 77197 28860 1, Charlotte 0.000000e+00 minorcivildivision 0.077800
287 1 1 5772 74189.876612 0.022302 77197 17675 Charlotte 0.000000e+00 incorporatedplace 0.077800
288 2 2 6041 43147.601931 0.017857 77197 3070 Mecklenburg 7.995773e-01 countyorequivalent 0.140008
289 0 0 496 30866.656524 0.015807 91406 42127 Palm Bay 3.513172e-01 minorcivildivision 0.016069
290 1 1 495 30259.288058 0.017387 91406 6821 Palm Bay 3.208722e-01 incorporatedplace 0.016359
291 2 2 5 21194.226159 0.053879 91406 85512 Malabar Transmitter Annex 9.901282e-01 reserve 0.000236
292 3 3 513 1382.835615 0.327120 91406 2593 Brevard 1.452351e+01 countyorequivalent 0.370977
293 4 4 1 317.790229 0.070408 91406 7914 Malabar 1.130672e+00 incorporatedplace 0.003147
294 5 5 3 147.176206 0.108801 91406 42150 Malabar 1.727221e+00 minorcivildivision 0.020384
295 6 6 1 139.443712 0.093826 91406 6780 Grant-Valkaria 1.299395e+00 incorporatedplace 0.007171
296 0 0 111 64779.407794 0.030951 94144 4595 Mandeville 9.055801e-01 incorporatedplace 0.001714
297 1 1 52 16659.808008 0.054555 94144 288 5 9.380757e-01 minorcivildivision 0.003121
298 2 2 142 16552.587778 0.076353 94144 294 10 1.268721e+00 minorcivildivision 0.008579
299 3 3 117 6674.972831 0.089768 94144 292 4 1.587563e+00 minorcivildivision 0.017528
300 4 4 102 2351.395482 0.090716 94144 290 7 2.231449e+00 minorcivildivision 0.043378
301 5 5 420 1583.133720 0.119043 94144 748 St. Tammany 1.363509e+01 countyorequivalent 0.265297
302 0 0 331 37952.187544 0.040709 81159 35587 Fairfield 0.000000e+00 minorcivildivision 0.008721
303 1 1 10 36307.296022 0.031535 81159 1115 Southport 9.684198e-01 unincorporatedplace 0.000275
304 2 2 10 1851.896274 0.077905 81159 6445 Bridgeport 1.619145e+00 incorporatedplace 0.005400
305 3 3 10 1851.896274 0.077905 81159 40352 Bridgeport 1.619145e+00 minorcivildivision 0.005400
306 4 4 431 1851.285131 0.143227 81159 557 Fairfield 2.569395e+01 countyorequivalent 0.232811
307 0 0 14 13539.631770 0.073424 92130 7594 Pingree Grove 9.010110e-01 incorporatedplace 0.001034
308 1 1 19 2013.505228 0.058923 92130 12436 Plato 9.662764e-02 minorcivildivision 0.009436
309 2 2 20 1954.343721 0.077028 92130 12435 Rutland 1.786449e+00 minorcivildivision 0.010234
310 3 3 14 1526.329436 0.059155 92130 14711 Elgin 1.878104e+00 minorcivildivision 0.009172
311 4 4 15 1405.674027 0.054216 92130 8268 Elgin 1.751493e+00 incorporatedplace 0.010671
312 5 5 1 639.654870 0.066907 92130 7630 Gilberts 1.149665e+00 incorporatedplace 0.001563
313 6 6 65 440.994568 0.116170 92130 1256 Kane 1.311062e+01 countyorequivalent 0.147394
314 0 0 190 40301.937746 0.006925 83388 8059 Haines City 0.000000e+00 incorporatedplace 0.004714
315 1 1 199 2074.790507 0.042519 83388 42635 Haines City 1.940713e+01 minorcivildivision 0.095913
316 2 2 2 2040.899360 0.062266 83388 8365 Lake Hamilton 1.207865e+00 incorporatedplace 0.000980
317 3 3 204 427.225387 0.177613 83388 2606 Polk 1.002851e+02 countyorequivalent 0.477500
318 4 4 5 156.151417 0.158660 83388 42632 Winter Haven-Auburndale 7.729548e+00 minorcivildivision 0.032020
319 0 0 3 6245.294723 0.014198 78884 9026 Courtland 9.463378e-01 unincorporatedplace 0.000480
320 1 1 7 202.820408 0.167876 78884 36080 Isleton 3.597146e+00 minorcivildivision 0.034513
321 2 2 9 33.864910 0.256400 78884 2521 Sacramento 2.870234e+01 countyorequivalent 0.265762
322 3 3 2 19.546437 0.261119 78884 36076 Sacramento 1.170236e+01 minorcivildivision 0.102320
323 0 0 308 273562.998430 0.030587 77989 1954 Winchester 9.994213e-01 unincorporatedplace 0.001126
324 1 1 2071 171066.927037 0.036404 77989 7942 Paradise 9.937944e-01 unincorporatedplace 0.012106
325 2 2 5546 44879.955777 0.038040 77989 30496 Las Vegas 1.012710e+00 minorcivildivision 0.123574
326 3 3 405 33682.378077 0.115689 77989 9488 Enterprise 9.938130e-01 unincorporatedplace 0.012024
327 4 4 219 6208.391189 0.159031 77989 18787 Las Vegas 1.017195e+00 incorporatedplace 0.035275
328 5 5 6036 2884.567643 0.170421 77989 2531 Clark 7.872406e-02 countyorequivalent 2.092515
329 0 0 12 149575.143957 0.015105 97577 8590 Twinsburg Heights 1.020869e+00 unincorporatedplace 0.000080
330 1 1 151 39278.627215 0.005394 97577 16518 Twinsburg 0.000000e+00 incorporatedplace 0.003844
331 2 2 151 39278.627215 0.005394 97577 18478 Twinsburg 0.000000e+00 minorcivildivision 0.003844
332 3 3 42 22930.315604 0.034160 97577 18446 Twinsburg 1.476451e+00 minorcivildivision 0.001832
333 4 4 195 1671.248139 0.209921 97577 2065 Summit 2.935100e+01 countyorequivalent 0.116679
334 5 5 1 669.243928 0.078359 97577 27043 Northfield Center 1.388682e+00 minorcivildivision 0.001494
335 6 6 1 138.994985 0.079608 97577 16465 Hudson 2.871459e+00 incorporatedplace 0.007195
336 7 7 1 138.994985 0.079608 97577 19219 Hudson 2.871459e+00 minorcivildivision 0.007195
337 0 0 168 45426.778637 0.001659 96872 6647 Thomasville 0.000000e+00 incorporatedplace 0.003698
338 1 1 180 3524.580564 0.038975 96872 42695 Thomasville 1.280917e+01 minorcivildivision 0.051070
339 2 2 180 1334.458015 0.064754 96872 1616 Thomas 3.547290e+01 countyorequivalent 0.134886
340 0 0 109 31956.376680 0.003401 87956 46155 Marshfield 1.394359e-01 minorcivildivision 0.003411
341 1 1 111 28005.106770 0.002602 87956 9539 Marshfield 0.000000e+00 incorporatedplace 0.003964
342 2 2 2 3618.841964 0.036645 87956 47076 Marshfield 8.605641e-01 minorcivildivision 0.000553
343 3 3 111 468.291439 0.243576 87956 2844 Wood 5.908160e+01 countyorequivalent 0.237032
344 4 4 2 416.253001 0.064979 87956 46127 Marshfield 2.212235e+00 minorcivildivision 0.004805
345 5 5 2 4.299965 0.474649 87956 3115 Marathon 1.180701e+02 countyorequivalent 0.465120
346 0 0 371 115706.712512 0.022130 95940 490 St. Louis Park 1.662714e-12 incorporatedplace 0.003206
347 1 1 371 115706.712512 0.022130 95940 33207 St. Louis Park 1.662714e-12 minorcivildivision 0.003206
348 2 2 381 2124.957628 0.145399 95940 2612 Hennepin 5.491899e+01 countyorequivalent 0.179298
349 3 3 8 471.259486 0.076644 95940 1126 Minneapolis 6.294373e+00 incorporatedplace 0.016976
350 4 4 8 471.259486 0.076644 95940 32808 Minneapolis 6.294373e+00 minorcivildivision 0.016976
351 0 0 58 34337.398125 0.027801 77286 5616 Holly Springs 9.846589e-01 incorporatedplace 0.001689
352 1 1 270 18083.452651 0.047005 77286 42640 Holly Springs 8.643940e-01 minorcivildivision 0.014931
353 2 2 84 17689.751569 0.052595 77286 5617 Canton 9.568725e-01 incorporatedplace 0.004749
354 3 3 1385 12579.006431 0.052642 77286 1898 Cherokee 0.000000e+00 countyorequivalent 0.110104
355 4 4 225 10210.022714 0.048440 77286 42641 Canton 7.998515e-01 minorcivildivision 0.022037
356 0 0 606 99455.971303 0.028927 91878 46938 Petersburg 0.000000e+00 minorcivildivision 0.006093
357 1 1 606 99455.971303 0.028927 91878 13385 Petersburg 0.000000e+00 incorporatedplace 0.006093
358 2 2 606 99455.971303 0.028927 91878 1853 Petersburg 0.000000e+00 countyorequivalent 0.006093
359 3 3 11 15411.607338 0.062342 91878 7191 Matoaca 1.117139e+00 unincorporatedplace 0.000714
360 4 4 1 1261.709613 0.027186 91878 4983 Ettrick 1.130076e+00 unincorporatedplace 0.000793
361 5 5 3 1089.906048 0.123074 91878 37459 2 1.451742e+00 minorcivildivision 0.002753
362 6 6 12 200.762243 0.284793 91878 38698 Matoaca 1.080974e+01 minorcivildivision 0.059772
363 7 7 2 162.343671 0.112517 91878 37458 3 3.021868e+00 minorcivildivision 0.012320
364 8 8 12 104.228711 0.234883 91878 1070 Chesterfield 1.989523e+01 countyorequivalent 0.115131
365 9 9 4 53.999535 0.186242 91878 2115 Prince George 1.315705e+01 countyorequivalent 0.074075
366 10 10 5 37.562563 0.274124 91878 1036 Dinwiddie 2.284606e+01 countyorequivalent 0.133111
367 0 0 6 398.309173 0.056015 92633 46744 4 7.825700e-01 minorcivildivision 0.015064
368 1 1 24 346.417531 0.006830 92633 1851 Powhatan 0.000000e+00 countyorequivalent 0.069281
369 2 2 6 244.808961 0.100218 92633 46745 5 6.462369e-01 minorcivildivision 0.024509
370 3 3 2 240.073730 0.050555 92633 46743 3 8.797531e-01 minorcivildivision 0.008331
371 0 0 2 242248.355439 0.044803 88441 38006 Milwaukee 1.000803e+00 minorcivildivision 0.000008
372 1 1 186 19484.168257 0.037756 88441 11096 Menomonee Falls 7.158873e-02 incorporatedplace 0.009546
373 2 2 186 19484.168257 0.037756 88441 44316 Menomonee Falls 7.158873e-02 minorcivildivision 0.009546
374 3 3 189 1138.213094 0.257795 88441 1225 Waukesha 1.515545e+01 countyorequivalent 0.166050
375 4 4 2 253.519766 0.097446 88441 44025 Brookfield 1.767220e+00 minorcivildivision 0.007889
376 5 5 2 253.519766 0.097446 88441 11163 Brookfield 1.767220e+00 incorporatedplace 0.007889
377 6 6 1 101.162247 0.088300 88441 38157 Germantown 1.961049e+00 minorcivildivision 0.009885
378 7 7 1 101.162247 0.088300 88441 11138 Germantown 1.961049e+00 incorporatedplace 0.009885
379 8 8 2 72.165711 0.148362 88441 9896 Milwaukee 3.691985e+00 incorporatedplace 0.027714
380 9 9 3 23.938056 0.259266 88441 2786 Washington 1.319186e+01 countyorequivalent 0.125323
381 0 0 100 129837.644744 0.044383 82342 5062 North Gates 8.664626e-01 unincorporatedplace 0.000770
382 1 1 49 85850.476307 0.028275 82342 362 Gates 9.010405e-01 unincorporatedplace 0.000571
383 2 2 286 65300.157979 0.028646 82342 30523 Gates 2.441468e-01 minorcivildivision 0.004380
384 3 3 29 2540.770647 0.073443 82342 31475 Chili 2.644571e+00 minorcivildivision 0.011414
385 4 4 20 1878.343544 0.089032 82342 30521 Rochester 2.709148e+00 minorcivildivision 0.010648
386 5 5 20 1878.343544 0.089032 82342 17926 Rochester 2.709148e+00 incorporatedplace 0.010648
387 6 6 346 881.055747 0.181044 82342 568 Monroe 6.708901e+01 countyorequivalent 0.392711
388 7 7 1 224.063900 0.112515 82342 30522 Brighton 1.770432e+00 minorcivildivision 0.004463
389 8 8 1 224.063900 0.112515 82342 5917 Brighton 1.770432e+00 unincorporatedplace 0.004463
390 0 0 126 11165.623937 0.052474 78827 6574 Elk Grove 7.320594e-01 incorporatedplace 0.011285
391 1 1 83 5721.806996 0.070829 78827 36079 Elk Grove 9.226545e-01 minorcivildivision 0.014506
392 2 2 148 556.889624 0.078724 78827 2521 Sacramento 5.317606e+00 countyorequivalent 0.265762
393 3 3 48 469.114500 0.188831 78827 36076 Sacramento 2.463076e+00 minorcivildivision 0.102320
394 4 4 16 293.237821 0.151243 78827 36078 Galt 1.688721e+00 minorcivildivision 0.054563
395 0 0 401 52205.082374 0.060030 78400 46465 Bryan-College Station 1.152629e+00 minorcivildivision 0.007681
396 1 1 497 40190.049403 0.021216 78400 12860 College Station 2.704600e-02 incorporatedplace 0.012366
397 2 2 515 3573.425485 0.054989 78400 2560 Brazos 1.088136e+01 countyorequivalent 0.144119
398 3 3 103 2048.430789 0.117816 78400 46463 South Brazos 3.749570e+00 minorcivildivision 0.050282
399 4 4 11 997.798214 0.088266 78400 12859 Bryan 1.906712e+00 incorporatedplace 0.011024
400 5 5 9 390.366210 0.172950 78400 46462 West Brazos 2.777183e+00 minorcivildivision 0.023055
401 0 0 4248 325100.124768 0.007207 88532 6003 Miami 5.785100e-01 incorporatedplace 0.013067
402 1 1 4447 129741.341065 0.049638 88532 43331 Miami 3.208120e+00 minorcivildivision 0.034276
403 2 2 33 62082.709630 0.049766 88532 488 Brownsville 1.064092e+00 unincorporatedplace 0.000532
404 3 3 4546 8033.736465 0.332285 88532 2483 Miami-Dade 6.727197e+01 countyorequivalent 0.565864
405 4 4 54 6214.050744 0.109485 88532 5188 Coral Gables 2.048119e+00 incorporatedplace 0.008690
406 5 5 19 5355.747359 0.082945 88532 6004 Miami Beach 1.428020e+00 incorporatedplace 0.003548
407 6 6 20 985.146447 0.129137 88532 43352 Miami Beach 3.449400e+00 minorcivildivision 0.020302
408 7 7 8 867.372091 0.103401 88532 43371 Key Biscayne 2.040097e+00 minorcivildivision 0.009223
409 0 0 1600 141880.735351 0.026199 81258 2560 Fall River 4.364164e-02 minorcivildivision 0.011277
410 1 1 1600 141880.735351 0.026199 81258 2661 Fall River 4.364164e-02 incorporatedplace 0.011277
411 2 2 1633 8425.553631 0.034000 81258 1713 Bristol 1.644974e+01 countyorequivalent 0.193815
412 3 3 10 2999.232637 0.046271 81258 2416 Somerset 1.299802e+00 minorcivildivision 0.003334
413 4 4 10 2999.232637 0.046271 81258 5747 Somerset 1.299802e+00 unincorporatedplace 0.003334
414 5 5 8 783.603382 0.105533 81258 2530 Freetown 1.914921e+00 minorcivildivision 0.010209
415 6 6 11 608.799191 0.161433 81258 2404 Westport 2.618340e+00 minorcivildivision 0.018068
416 7 7 1 141.040019 0.099162 81258 2415 Swansea 1.638298e+00 minorcivildivision 0.007090
417 0 0 375 186597.718720 0.007590 86287 17056 Lancaster 0.000000e+00 minorcivildivision 0.002010
418 1 1 375 186597.718720 0.007590 86287 12888 Lancaster 0.000000e+00 incorporatedplace 0.002010
419 2 2 382 1420.611750 0.058554 86287 1001 Lancaster 1.328021e+02 countyorequivalent 0.268898
420 3 3 1 604.465162 0.022057 86287 17055 Lancaster 1.823197e+00 minorcivildivision 0.001654
421 4 4 3 550.289527 0.089755 86287 17094 East Lampeter 3.712721e+00 minorcivildivision 0.005452
422 5 5 2 303.744124 0.058771 86287 16230 Manheim 4.276402e+00 minorcivildivision 0.006584
423 6 6 1 220.329467 0.064929 86287 16182 West Lampeter 3.258408e+00 minorcivildivision 0.004539

In [ ]: