saturn·

data trove us county state boundaries geojson

saturn notebook · generated 2026-06-22 Report Notebook

Overview

Source: /home/coolhand/html/datavis/data_trove/geographic/counties_simplified.geojson

Saturn profiled 3,234 rows across 18 columns. The stats below are deterministic and machine-readable; the prose is a language-model interpretation of those stats (opt-in, added after the fact, never sees raw rows).

[2]:
!pip install saturn-dissect
import subprocess
subprocess.run([
    "saturn", "analyze", "/home/coolhand/html/datavis/data_trove/geographic/counties_simplified.geojson",
    "--findings", "data-trove-us-county-state-boundaries-geojson.json",
    "--llm", "anthropic:default",
])

Summary confidence: high

This dataset is a US county-level geographic reference file containing 3,234 county (and county-equivalent) records across 56 state FIPS codes, with spatial attributes, area measurements, and metropolitan area classifications. The most notable pattern is that roughly 41% of counties share a name with at least one other county — 'Washington' alone appears 31 times — reflecting the historic reuse of patriotic and presidential names across states. Two numeric columns, ALAND (land area) and AWATER (water area), show extreme right skew with over 11–14% outliers, meaning a small number of counties are vastly larger or wetter than the median, which warrants attention in any area-weighted analysis. Additionally, over 40% of counties have no CBSAFP code (no core-based statistical area assignment), indicating a large rural, non-metro population of counties that could easily be overlooked in urban-focused analyses.

citing: row_count · column_count · NAME.n_unique · NAME.top_values · NAME.n_duplicates · ALAND.skew · ALAND.outlier_rate · AWATER.outlier_rate · CBSAFP.null_rate · STATEFP.n_unique · NAMELSAD.top_words · CLASSFP.top_rate

Out[4]:

saturn.schema() · 18 columns

column kind n null% unique alerts
STATEFP categorical 3,234 0.0% 56
COUNTYFP categorical 3,234 0.0% 330
COUNTYNS text 3,234 0.0% 3,234 near_unique one_word allcaps short_text
GEOID text 3,234 0.0% 3,234 near_unique one_word allcaps short_text
NAME text 3,234 0.0% 1,923 one_word short_text duplicates
NAMELSAD text 3,234 0.0% 1,969 short_text duplicates
LSAD categorical 3,234 0.0% 11
CLASSFP categorical 3,234 0.0% 5 imbalance
MTFCC categorical 3,234 0.0% 1 imbalance
CSAFP categorical 3,234 61.2% 175 null_rate
CBSAFP categorical 3,234 40.8% 939 long_tail null_rate
METDIVFP categorical 3,234 96.6% 31 null_rate
FUNCSTAT categorical 3,234 0.0% 7 imbalance
ALAND numeric 3,234 0.0% 3,234 high_skew outliers
AWATER numeric 3,234 0.0% 3,234 high_skew outliers
INTPTLAT text 3,234 0.0% 3,234 near_unique one_word allcaps short_text
INTPTLON text 3,234 0.0% 3,234 near_unique one_word allcaps short_text
geometry_type categorical 3,234 0.0% 2 imbalance
Fig 1.
NAME · Look for the top repeated county names — 'Washington' (31), 'Jefferson' (26), and 'Franklin' (26) reveal how heavily historical naming conventions cluster across states.
Show data table
Character-length distribution for NAME (mean: 7.0395794681508965).
charscount
3 – 327
3 – 40
4 – 4257
4 – 50
5 – 5470
5 – 60
6 – 6696
6 – 70
7 – 7614
7 – 80
8 – 80
8 – 8501
8 – 90
9 – 9292
9 – 100
10 – 10211
10 – 110
11 – 1160
11 – 120
12 – 120
12 – 1248
12 – 130
13 – 1322
13 – 140
14 – 1414
14 – 150
15 – 158
15 – 160
16 – 165
16 – 160
16 – 170
17 – 173
17 – 180
18 – 181
18 – 190
19 – 191
19 – 200
20 – 203
20 – 210
21 – 211
Fig 2.
STATEFP · Texas (FIPS 48) dominates with 254 counties, nearly double the next largest state, highlighting how county counts vary dramatically by state.
Show data table
Top values for STATEFP (20 unique shown, of 56 total).
valuecountshare
482547.9%
131594.9%
511334.1%
211203.7%
291153.6%
201053.2%
171023.2%
371003.1%
19993.1%
47952.9%
31932.9%
18922.8%
39882.7%
27872.7%
26832.6%
28822.5%
72782.4%
40772.4%
05752.3%
55722.2%
Fig 3.
ALAND · The extreme right skew (skew = 27.1) shows most counties are modest in land area while a handful of outliers are orders of magnitude larger — check these before any area-weighted calculation.
Show data table
Histogram bins for ALAND (median: 1563349650.5).
bincount
8.209e+04 – 9.426e+093096
9.426e+09 – 1.885e+1097
1.885e+10 – 2.828e+1022
2.828e+10 – 3.77e+103
3.77e+10 – 4.713e+104
4.713e+10 – 5.656e+103
5.656e+10 – 6.598e+105
6.598e+10 – 7.541e+100
7.541e+10 – 8.483e+100
8.483e+10 – 9.426e+101
9.426e+10 – 1.037e+110
1.037e+11 – 1.131e+111
1.131e+11 – 1.225e+110
1.225e+11 – 1.32e+110
1.32e+11 – 1.414e+110
1.414e+11 – 1.508e+110
1.508e+11 – 1.602e+110
1.602e+11 – 1.697e+110
1.697e+11 – 1.791e+110
1.791e+11 – 1.885e+110
1.885e+11 – 1.979e+110
1.979e+11 – 2.074e+110
2.074e+11 – 2.168e+110
2.168e+11 – 2.262e+110
2.262e+11 – 2.356e+111
2.356e+11 – 2.451e+110
2.451e+11 – 2.545e+110
2.545e+11 – 2.639e+110
2.639e+11 – 2.734e+110
2.734e+11 – 2.828e+110
2.828e+11 – 2.922e+110
2.922e+11 – 3.016e+110
3.016e+11 – 3.111e+110
3.111e+11 – 3.205e+110
3.205e+11 – 3.299e+110
3.299e+11 – 3.393e+110
3.393e+11 – 3.488e+110
3.488e+11 – 3.582e+110
3.582e+11 – 3.676e+110
3.676e+11 – 3.77e+111
Fig 4.
CBSAFP · About 41% of counties have no CBSAFP code, meaning they fall outside any core-based statistical area — a large rural segment that metro-focused analysis would miss.
Show data table
Top values for CBSAFP (20 unique shown, of 939 total).
valuecountshare
41980401.2%
12060290.9%
47900250.8%
35620230.7%
47260190.6%
40060170.5%
17140160.5%
33460150.5%
41180150.5%
16980140.4%
28140140.4%
34980130.4%
16740110.3%
37980110.3%
19100110.3%
26900110.3%
19740100.3%
18140100.3%
12940100.3%
31140100.3%
Fig 5.
LSAD · LSAD code '06' (standard county) accounts for 93% of records, with smaller slices for municipios, parishes, and independent cities worth isolating for jurisdiction-type comparisons.
Show data table
Top values for LSAD (11 unique shown, of 11 total).
valuecountshare
06300793.0%
13782.4%
15642.0%
25401.2%
04130.4%
05110.3%
1260.2%
0050.2%
0340.1%
1030.1%
0730.1%
Fig 6.
Per-column null rate across the corpus. Columns are ordered by input position.
Show data table
Per-column null rate across the corpus.
columnkindnull %
STATEFPcategorical0.0%
COUNTYFPcategorical0.0%
COUNTYNStext0.0%
GEOIDtext0.0%
NAMEtext0.0%
NAMELSADtext0.0%
LSADcategorical0.0%
CLASSFPcategorical0.0%
MTFCCcategorical0.0%
CSAFPcategorical61.2%
CBSAFPcategorical40.8%
METDIVFPcategorical96.6%
FUNCSTATcategorical0.0%
ALANDnumeric0.0%
AWATERnumeric0.0%
INTPTLATtext0.0%
INTPTLONtext0.0%
geometry_typecategorical0.0%
Fig 7.
Pearson correlation across numeric columns (sampled, bounded).
Show data table
Pearson correlation across 2 numeric columns (values clipped to 2 decimals).
ALANDAWATER
ALAND+1.00+0.58
AWATER+0.58+1.00

STATEFP categorical label

STATEFP is the U.S. Census Bureau FIPS state code, a two-digit numeric string identifying each U.S. state or territory. With exactly 56 unique values and 3,234 rows it likely represents one record per county or similar sub-state geographic unit. The top value '48' (Texas, 254 rows) alone accounts for 7.85% of all records — consistent with Texas having the most counties of any U.S. state — while values like '13' (Georgia, 159) and '51' (Virginia, 133) also rank high, reflecting those states' large county counts. The entropy ratio of 0.919 indicates a fairly even spread across states despite Texas's dominance.

Treatment: Use as a categorical grouping key or left-join with a FIPS lookup table to enrich with state names and region attributes; do not treat as numeric.

anthropic:default · confidence high
Out[13]:

saturn.columns["STATEFP"].stats

statvalue
n3,234
nulls0 (0.0%)
unique56
top_value 48
top_rate 0.07854
cardinality 56
entropy 5.337
entropy_ratio 0.919
Fig 8.
Top values for STATEFP.
Show data table
Top values for STATEFP (20 unique shown, of 56 total).
valuecountshare
482547.9%
131594.9%
511334.1%
211203.7%
291153.6%
201053.2%
171023.2%
371003.1%
19993.1%
47952.9%
31932.9%
18922.8%
39882.7%
27872.7%
26832.6%
28822.5%
72782.4%
40772.4%
05752.3%
55722.2%

COUNTYFP categorical foreign_key

COUNTYFP is a FIPS county code — a standardized 3-digit zero-padded numeric string used in US geographic identifiers. With 330 unique values across 3,234 rows and a high entropy ratio of 0.85, codes are broadly distributed with near-uniform frequency: the most common value ('003') appears only 50 times (~1.5% top_rate). The sequential odd-number pattern in top values (001, 003, 005, 007…) is characteristic of FIPS county numbering conventions, confirming this is a geographic lookup key rather than a raw feature.

Treatment: Left-join on COUNTYFP (combined with state FIPS) to enrich with county-level attributes; do not encode ordinally.

anthropic:default · confidence high
Out[16]:

saturn.columns["COUNTYFP"].stats

statvalue
n3,234
nulls0 (0.0%)
unique330
top_value 003
top_rate 0.01546
cardinality 330
entropy 7.118
entropy_ratio 0.8508
Fig 9.
Top values for COUNTYFP.
Show data table
Top values for COUNTYFP (20 unique shown, of 330 total).
valuecountshare
003501.5%
001501.5%
005501.5%
009491.5%
007481.5%
013481.5%
011471.5%
015471.5%
019461.4%
017461.4%
027451.4%
023451.4%
021451.4%
025431.3%
031421.3%
029421.3%
033411.3%
037401.2%
035401.2%
039391.2%

COUNTYNS text identifier

COUNTYNS is a FIPS-style county National Standard (ANSI/GNIS) code — an 8-character, zero-padded numeric identifier assigned by the U.S. Geological Survey to uniquely identify counties. Every one of the 3,234 rows carries a distinct value (duplicate_rate 0.0, n_unique 3,234) with no nulls, and all values are exactly 8 characters long (len_min = len_max = 8), consistent with the fixed-width GNIS format. The perfect uniqueness and fixed length make this a reliable surrogate key for county-level joins to official geographic reference tables.

Treatment: Use as a join key against TIGER/GNIS county reference data; do not encode or embed.

anthropic:default · confidence high
Out[19]:

saturn.columns["COUNTYNS"].stats

statvalue
n3,234
nulls0 (0.0%)
unique3,234
len_min 8
len_max 8
len_mean 8
len_median 8
len_p95 8
word_mean 1
word_median 1
n_empty 0
n_duplicates 0
duplicate_rate 0
vocab_size 3,234
readability_flesch_mean 121.2
emoji_rate 0
url_rate 0
one_word_rate 1
allcaps_rate 1
boilerplate_rate 0
alert: near_unique100.0% of rows are unique strings
alert: one_word100.0% rows are a single word
alert: allcaps100.0% rows are all-caps
alert: short_text95th-percentile length under 20 chars
Fig 10.
Character-length distribution for COUNTYNS.
Show data table
Character-length distribution for COUNTYNS (mean: 8.0).
charscount
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 83234
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80
8 – 80

GEOID text identifier

GEOID is a US Census geographic identifier column containing 5-digit FIPS county codes (e.g., '06091', '48327'), where the first two digits encode state and the last three encode county. Every value is exactly 5 characters long (len_min=5, len_max=5, len_mean=5.0), perfectly unique across all 3,234 rows with zero nulls or duplicates, confirming this is a primary key for county-level geographic records. The allcaps_rate of 1.0 is a classifier artifact — these are numeric strings, not alphabetic text. The vocab_size of 3,234 matching n_unique=3,234 means this dataset likely covers a near-complete set of US counties (there are ~3,243 counties/equivalents in the US).

Treatment: Use as a primary key for joining to Census TIGER shapefiles or other county-level datasets; zero-pad-preserve when merging (already 5 chars).

anthropic:default · confidence high
Out[22]:

saturn.columns["GEOID"].stats

statvalue
n3,234
nulls0 (0.0%)
unique3,234
len_min 5
len_max 5
len_mean 5
len_median 5
len_p95 5
word_mean 1
word_median 1
n_empty 0
n_duplicates 0
duplicate_rate 0
vocab_size 3,234
readability_flesch_mean 121.2
emoji_rate 0
url_rate 0
one_word_rate 1
allcaps_rate 1
boilerplate_rate 0
alert: near_unique100.0% of rows are unique strings
alert: one_word100.0% rows are a single word
alert: allcaps100.0% rows are all-caps
alert: short_text95th-percentile length under 20 chars
Fig 11.
Character-length distribution for GEOID.
Show data table
Character-length distribution for GEOID (mean: 5.0).
charscount
4 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 53234
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 50
5 – 60

NAME text label

This column contains names of U.S. counties or county-equivalent administrative divisions, dominated by patriotic/presidential surnames (Washington, Jefferson, Franklin, Lincoln, Jackson, Madison) and geographic terms (Union, Lake, Montgomery, Marion). The duplicate rate of 40.5% (1,311 out of 3,234 rows) is expected given that common county names repeat across states, but analysts should note this column alone cannot serve as a unique identifier. The vocabulary of 1,958 tokens across 3,234 rows and a median length of 7 characters confirms these are short, single-word labels in most cases (93.1% one-word rate).

Treatment: Combine with a state column to form a composite key before joining or aggregating.

anthropic:default · confidence high
Out[25]:

saturn.columns["NAME"].stats

statvalue
n3,234
nulls0 (0.0%)
unique1,923
len_min 3
len_max 21
len_mean 7.04
len_median 7
len_p95 11
word_mean 1.074
word_median 1
n_empty 0
n_duplicates 1,311
duplicate_rate 0.4054
vocab_size 1,958
readability_flesch_mean 31.97
emoji_rate 0
url_rate 0
one_word_rate 0.9307
allcaps_rate 0
boilerplate_rate 0
alert: one_word93.1% rows are a single word
alert: short_text95th-percentile length under 20 chars
alert: duplicates40.5% duplicate strings
Fig 12.
Character-length distribution for NAME.
Show data table
Character-length distribution for NAME (mean: 7.0395794681508965).
charscount
3 – 327
3 – 40
4 – 4257
4 – 50
5 – 5470
5 – 60
6 – 6696
6 – 70
7 – 7614
7 – 80
8 – 80
8 – 8501
8 – 90
9 – 9292
9 – 100
10 – 10211
10 – 110
11 – 1160
11 – 120
12 – 120
12 – 1248
12 – 130
13 – 1322
13 – 140
14 – 1414
14 – 150
15 – 158
15 – 160
16 – 165
16 – 160
16 – 170
17 – 173
17 – 180
18 – 181
18 – 190
19 – 191
19 – 200
20 – 203
20 – 210
21 – 211

NAMELSAD text label

NAMELSAD is a US Census Legal/Statistical Area Description field containing the full human-readable name of county-equivalent geographic units (e.g., 'Washington County', 'Jefferson Parish'). The word 'county' appears in 3,007 of 3,234 rows, with 'municipio' (78) and 'parish' (64) indicating Puerto Rico and Louisiana records respectively. The 39.1% duplicate rate (1,265 duplicates across 1,969 unique values) is fully expected — common county names like 'Washington County' (30 occurrences) repeat across different US states. The multi-word structure (mean 2.08 words) and short length (median 14 chars) are consistent with standardized geographic labels.

Treatment: Use as a display label; join on a GEOID/FIPS key for spatial analysis rather than matching on this name alone due to cross-state duplicates.

anthropic:default · confidence high
Out[28]:

saturn.columns["NAMELSAD"].stats

statvalue
n3,234
nulls0 (0.0%)
unique1,969
len_min 4
len_max 33
len_mean 14.12
len_median 14
len_p95 18
word_mean 2.079
word_median 2
n_empty 0
n_duplicates 1,265
duplicate_rate 0.3912
vocab_size 1,965
readability_flesch_mean 32.29
emoji_rate 0
url_rate 0
one_word_rate 0.0003092
allcaps_rate 0
boilerplate_rate 0
alert: short_text95th-percentile length under 20 chars
alert: duplicates39.1% duplicate strings
Fig 13.
Character-length distribution for NAMELSAD.
Show data table
Character-length distribution for NAMELSAD (mean: 14.122758194186765).
charscount
4 – 51
5 – 50
5 – 60
6 – 70
7 – 80
8 – 80
8 – 90
9 – 100
10 – 1129
11 – 11256
11 – 120
12 – 13465
13 – 13683
13 – 14590
14 – 150
15 – 16496
16 – 16297
16 – 17223
17 – 180
18 – 1867
18 – 1951
19 – 200
20 – 2123
21 – 2116
21 – 2214
22 – 230
23 – 247
24 – 244
24 – 255
25 – 260
26 – 262
26 – 271
27 – 280
28 – 291
29 – 291
29 – 300
30 – 310
31 – 321
32 – 320
32 – 331

LSAD categorical label

LSAD (Legal/Statistical Area Description) is a Census Bureau code that classifies geographic entities by type — values like '06' (county), '13', '15', '25' are standard LSAD codes. The distribution is severely dominated by code '06', which accounts for 3,007 of 3,234 rows (92.98%), indicating this dataset is overwhelmingly composed of one entity type (most likely counties). With only 11 unique values and near-zero entropy ratio (0.156), this column carries very little discriminative information despite being semantically meaningful.

Treatment: Use as a stratification or filter variable; consider one-hot encoding if modelling across entity types, but note extreme class imbalance driven by code '06'.

anthropic:default · confidence high
Out[31]:

saturn.columns["LSAD"].stats

statvalue
n3,234
nulls0 (0.0%)
unique11
top_value 06
top_rate 0.9298
cardinality 11
entropy 0.5394
entropy_ratio 0.1559
Fig 14.
Top values for LSAD.
Show data table
Top values for LSAD (11 unique shown, of 11 total).
valuecountshare
06300793.0%
13782.4%
15642.0%
25401.2%
04130.4%
05110.3%
1260.2%
0050.2%
0340.1%
1030.1%
0730.1%

CLASSFP categorical label

CLASSFP is the FIPS functional classification code for geographic/administrative entities, almost certainly places in a US Census dataset. The distribution is severely imbalanced: 'H1' (incorporated places) accounts for 96.3% of the 3,234 rows, with the remaining four codes (C7, H6, H4, H5) collectively covering only 119 records. The entropy ratio of 0.128 confirms near-minimal informational content, meaning this column carries little discriminatory power as a feature in its current form.

Treatment: Treat as a near-constant; consider dropping or collapsing into a binary flag (H1 vs. other) if used in modelling, given 96.3% dominance of a single class.

anthropic:default · confidence high
Out[34]:

saturn.columns["CLASSFP"].stats

statvalue
n3,234
nulls0 (0.0%)
unique5
top_value H1
top_rate 0.9632
cardinality 5
entropy 0.2962
entropy_ratio 0.1276
alert: imbalancetop value is 96.3% of rows
Fig 15.
Top values for CLASSFP.
Show data table
Top values for CLASSFP (5 unique shown, of 5 total).
valuecountshare
H1311596.3%
C7411.3%
H6381.2%
H4290.9%
H5110.3%

MTFCC categorical label

MTFCC is a MAF/TIGER Feature Class Code, a U.S. Census Bureau classification code for geographic features. Every single one of the 3,234 rows carries the identical value 'G4020' (which corresponds to a local road/street segment), with zero nulls and an entropy of 0.0 — this column is entirely constant across the dataset. It carries no discriminatory signal whatsoever.

Treatment: Drop before modelling; zero-variance constant column adds no information.

anthropic:default · confidence high
Out[37]:

saturn.columns["MTFCC"].stats

statvalue
n3,234
nulls0 (0.0%)
unique1
top_value G4020
top_rate 1
cardinality 1
entropy 0
entropy_ratio 0
alert: imbalancetop value is 100.0% of rows
Fig 16.
Top values for MTFCC.
Show data table
Top values for MTFCC (1 unique shown, of 1 total).
valuecountshare
G40203234100.0%

CSAFP categorical feature

CSAFP is likely a Combined Statistical Area FIPS (or similar geographic area code), given the numeric-string values in the hundreds range and cardinality of 175 — consistent with a US metropolitan/micropolitan area classification code. The most alarming signal is a 61.16% null rate, meaning nearly two-thirds of the 3,234 rows carry no value, which likely indicates records that do not belong to any defined statistical area. The distribution is nearly flat across all 175 codes (entropy ratio 0.936, top value '490' appears only 3.8% of the time), suggesting no single area dominates.

Treatment: Impute nulls with a sentinel 'none/rural' category before use; treat as nominal categorical and one-hot or target-encode given 175 levels.

anthropic:default · confidence medium
Out[40]:

saturn.columns["CSAFP"].stats

statvalue
n3,234
nulls1,978 (61.2%)
unique175
top_value 490
top_rate 0.03822
cardinality 175
entropy 6.977
entropy_ratio 0.9364
alert: null_rate61.2% null
Fig 17.
Top values for CSAFP.
Show data table
Top values for CSAFP (20 unique shown, of 175 total).
valuecountshare
490481.5%
122421.3%
548411.3%
408311.0%
545220.7%
312220.7%
378210.6%
176190.6%
148190.6%
206190.6%
178180.6%
294180.6%
198170.5%
476170.5%
170160.5%
428160.5%
400160.5%
350150.5%
184140.4%
174140.4%

CBSAFP categorical foreign_key

CBSAFP is a Core Based Statistical Area (CBSA) FIPS code, a U.S. Census geographic identifier linking records to metropolitan or micropolitan statistical areas. With 939 unique codes across 3,234 rows, the distribution is notably flat (entropy_ratio 0.94), meaning records are spread thinly across many areas rather than concentrated. The null rate of 40.75% is a significant concern — likely representing locations outside any defined CBSA (rural areas), which is a meaningful geographic signal rather than simple missingness. The most frequent value '41980' (San Jose-Sunnyvale-Santa Clara, CA) appears only 40 times (~2.1%), confirming no single area dominates.

Treatment: Treat nulls as a distinct 'non-CBSA/rural' category; left-join to CBSA reference table for region labels, then encode as categorical feature.

anthropic:default · confidence high
Out[43]:

saturn.columns["CBSAFP"].stats

statvalue
n3,234
nulls1,318 (40.8%)
unique939
top_value 41980
top_rate 0.02088
cardinality 939
entropy 9.278
entropy_ratio 0.9395
alert: long_tail602 singleton categories
alert: null_rate40.8% null
Fig 18.
Top values for CBSAFP.
Show data table
Top values for CBSAFP (20 unique shown, of 939 total).
valuecountshare
41980401.2%
12060290.9%
47900250.8%
35620230.7%
47260190.6%
40060170.5%
17140160.5%
33460150.5%
41180150.5%
16980140.4%
28140140.4%
34980130.4%
16740110.3%
37980110.3%
19100110.3%
26900110.3%
19740100.3%
18140100.3%
12940100.3%
31140100.3%

METDIVFP categorical

Out[46]:

saturn.columns["METDIVFP"].stats

statvalue
n3,234
nulls3,124 (96.6%)
unique31
top_value 47894
top_rate 0.2091
cardinality 31
entropy 4.361
entropy_ratio 0.8802
alert: null_rate96.6% null
Fig 19.
Top values for METDIVFP.
Show data table
Top values for METDIVFP (20 unique shown, of 31 total).
valuecountshare
47894230.7%
35614110.3%
1912470.2%
3508460.2%
1698450.2%
4766450.2%
2384440.1%
2310440.1%
3515440.1%
1445430.1%
1580430.1%
4886430.1%
2099430.1%
3387430.1%
3500420.1%
3796420.1%
2940420.1%
4188420.1%
2322420.1%
3608420.1%

FUNCSTAT categorical label

FUNCSTAT is a U.S. Census functional status code, classifying geographic or administrative entities by their operational state (e.g., 'A' = active, 'F' = fictitious, 'C' = consolidated). The distribution is severely imbalanced: 'A' accounts for 96.35% of the 3,234 records, while the remaining 6 categories together cover only 118 rows — with 'G' appearing just once. Entropy ratio of 0.107 confirms near-minimal informational diversity. Minority classes may warrant special handling but will be extremely difficult to model as targets.

Treatment: One-hot encode with caution; collapse rare categories (F, C, N, S, B, G — totalling 118 rows) into an 'other' bucket or treat as a filter/stratification variable rather than a model feature.

anthropic:default · confidence high
Out[49]:

saturn.columns["FUNCSTAT"].stats

statvalue
n3,234
nulls0 (0.0%)
unique7
top_value A
top_rate 0.9635
cardinality 7
entropy 0.3005
entropy_ratio 0.107
alert: imbalancetop value is 96.4% of rows
Fig 20.
Top values for FUNCSTAT.
Show data table
Top values for FUNCSTAT (7 unique shown, of 7 total).
valuecountshare
A311696.4%
F431.3%
C331.0%
N270.8%
S110.3%
B30.1%
G10.0%

ALAND numeric feature

ALAND is a US Census land area field (measured in square metres), representing the land area of each geographic entity — likely counties or census tracts given n=3,234. The distribution is extremely right-skewed (skew=27.13, kurtosis=976.66): while the median is ~1.56 billion m², the max reaches 377 billion m², roughly 241× the median, indicating a small number of very large geographic units (e.g., western US counties). 362 values (11.2%) are flagged as outliers, consistent with the well-known size disparity between densely subdivided eastern counties and sprawling western ones.

Treatment: Log-transform before use in any distance-based or linear model to reduce skew from 27.13; consider using as a normalisation denominator for density features.

anthropic:default · confidence high
Out[52]:

saturn.columns["ALAND"].stats

statvalue
n3,234
nulls0 (0.0%)
unique3,234
min 82,093
max 3.77e+11
mean 2.833e+09
median 1.563e+09
std 9.186e+09
q1 1.079e+09
q3 2.368e+09
iqr 1.29e+09
skew 27.13
kurtosis 976.7
n_outliers 362
outlier_rate 0.1119
zero_rate 0
alert: high_skewskew=+27.13
alert: outliers11.2% rows beyond 1.5 IQR
Fig 21.
Distribution of ALAND. Vertical dash marks the median.
Show data table
Histogram bins for ALAND (median: 1563349650.5).
bincount
8.209e+04 – 9.426e+093096
9.426e+09 – 1.885e+1097
1.885e+10 – 2.828e+1022
2.828e+10 – 3.77e+103
3.77e+10 – 4.713e+104
4.713e+10 – 5.656e+103
5.656e+10 – 6.598e+105
6.598e+10 – 7.541e+100
7.541e+10 – 8.483e+100
8.483e+10 – 9.426e+101
9.426e+10 – 1.037e+110
1.037e+11 – 1.131e+111
1.131e+11 – 1.225e+110
1.225e+11 – 1.32e+110
1.32e+11 – 1.414e+110
1.414e+11 – 1.508e+110
1.508e+11 – 1.602e+110
1.602e+11 – 1.697e+110
1.697e+11 – 1.791e+110
1.791e+11 – 1.885e+110
1.885e+11 – 1.979e+110
1.979e+11 – 2.074e+110
2.074e+11 – 2.168e+110
2.168e+11 – 2.262e+110
2.262e+11 – 2.356e+111
2.356e+11 – 2.451e+110
2.451e+11 – 2.545e+110
2.545e+11 – 2.639e+110
2.639e+11 – 2.734e+110
2.734e+11 – 2.828e+110
2.828e+11 – 2.922e+110
2.922e+11 – 3.016e+110
3.016e+11 – 3.111e+110
3.111e+11 – 3.205e+110
3.205e+11 – 3.299e+110
3.299e+11 – 3.393e+110
3.393e+11 – 3.488e+110
3.488e+11 – 3.582e+110
3.582e+11 – 3.676e+110
3.676e+11 – 3.77e+111

AWATER numeric feature

AWATER is almost certainly a US Census TIGER/Line water area field, representing the total water surface area (in square meters) of a geographic unit such as a county or census tract. All 3,234 rows are unique and non-null, consistent with one record per geographic entity. The distribution is extremely right-skewed (skew 13.33, kurtosis 215.85): the median is ~19.5 million m² while the mean balloons to ~220 million m², and the maximum reaches ~26 billion m² — about 14× the mean — with 456 outliers (14.1% of rows) driven by large water-heavy units like coastal counties or Great Lakes-adjacent areas. Only 1 record has a zero value, which is plausible for fully land-locked units.

Treatment: Log-transform (log1p to handle the single zero) before regression or clustering to reduce extreme skew.

anthropic:default · confidence high
Out[55]:

saturn.columns["AWATER"].stats

statvalue
n3,234
nulls0 (0.0%)
unique3,234
min 0
max 2.599e+10
mean 2.202e+08
median 1.951e+07
std 1.226e+09
q1 7.044e+06
q3 6.12e+07
iqr 5.416e+07
skew 13.33
kurtosis 215.9
n_outliers 456
outlier_rate 0.141
zero_rate 0.0003092
alert: high_skewskew=+13.33
alert: outliers14.1% rows beyond 1.5 IQR
Fig 22.
Distribution of AWATER. Vertical dash marks the median.
Show data table
Histogram bins for AWATER (median: 19505620.5).
bincount
0 – 6.497e+083040
6.497e+08 – 1.299e+0992
1.299e+09 – 1.949e+0930
1.949e+09 – 2.599e+0925
2.599e+09 – 3.249e+0914
3.249e+09 – 3.898e+093
3.898e+09 – 4.548e+093
4.548e+09 – 5.198e+097
5.198e+09 – 5.848e+091
5.848e+09 – 6.497e+093
6.497e+09 – 7.147e+091
7.147e+09 – 7.797e+090
7.797e+09 – 8.447e+091
8.447e+09 – 9.096e+090
9.096e+09 – 9.746e+090
9.746e+09 – 1.04e+100
1.04e+10 – 1.105e+101
1.105e+10 – 1.17e+101
1.17e+10 – 1.235e+100
1.235e+10 – 1.299e+102
1.299e+10 – 1.364e+100
1.364e+10 – 1.429e+103
1.429e+10 – 1.494e+102
1.494e+10 – 1.559e+101
1.559e+10 – 1.624e+100
1.624e+10 – 1.689e+100
1.689e+10 – 1.754e+100
1.754e+10 – 1.819e+100
1.819e+10 – 1.884e+100
1.884e+10 – 1.949e+100
1.949e+10 – 2.014e+100
2.014e+10 – 2.079e+100
2.079e+10 – 2.144e+101
2.144e+10 – 2.209e+100
2.209e+10 – 2.274e+101
2.274e+10 – 2.339e+100
2.339e+10 – 2.404e+100
2.404e+10 – 2.469e+100
2.469e+10 – 2.534e+101
2.534e+10 – 2.599e+101

INTPTLAT text feature

INTPTLAT is the internal point latitude coordinate for geographic entities (a standard Census Bureau field name), stored as a fixed-width text string rather than a numeric type. Every one of the 3,234 rows is unique, all values are exactly 11 characters long (e.g. '+41.9158651'), and the duplicate rate is 0.0, confirming these are precise geographic identifiers. The surprising signal is that a coordinate stored as text with 'allcaps' and 'one_word' alerts was profiled as a string column — it should be numeric but the leading '+' sign likely forced text treatment.

Treatment: Strip leading '+', cast to float64, and use as a numeric geographic coordinate in modelling or spatial joins.

anthropic:default · confidence high
Out[58]:

saturn.columns["INTPTLAT"].stats

statvalue
n3,234
nulls0 (0.0%)
unique3,234
len_min 11
len_max 11
len_mean 11
len_median 11
len_p95 11
word_mean 1
word_median 1
n_empty 0
n_duplicates 0
duplicate_rate 0
vocab_size 3,234
readability_flesch_mean 121.2
emoji_rate 0
url_rate 0
one_word_rate 1
allcaps_rate 1
boilerplate_rate 0
alert: near_unique100.0% of rows are unique strings
alert: one_word100.0% rows are a single word
alert: allcaps100.0% rows are all-caps
alert: short_text95th-percentile length under 20 chars
Fig 23.
Character-length distribution for INTPTLAT.
Show data table
Character-length distribution for INTPTLAT (mean: 11.0).
charscount
10 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 113234
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 110
11 – 120

INTPTLON text feature

INTPTLON is the internal point longitude field, a standard Census Bureau coordinate column storing the longitude of a representative point within each geographic entity. Every one of the 3,234 rows is unique, all values are exactly 12 characters long (mean, median, min, and max all equal 12), and the duplicate rate is 0.0 — consistent with precise decimal-degree coordinates stored as fixed-format strings. All values appear to be negative (Western Hemisphere), ranging roughly from -065 to -123 degrees, aligning with US continental and territory coverage.

Treatment: Parse to float64 for geospatial use; pair with INTPTLAT to form a coordinate pair for mapping or spatial joins.

anthropic:default · confidence high
Out[61]:

saturn.columns["INTPTLON"].stats

statvalue
n3,234
nulls0 (0.0%)
unique3,234
len_min 12
len_max 12
len_mean 12
len_median 12
len_p95 12
word_mean 1
word_median 1
n_empty 0
n_duplicates 0
duplicate_rate 0
vocab_size 3,234
readability_flesch_mean 121.2
emoji_rate 0
url_rate 0
one_word_rate 1
allcaps_rate 1
boilerplate_rate 0
alert: near_unique100.0% of rows are unique strings
alert: one_word100.0% rows are a single word
alert: allcaps100.0% rows are all-caps
alert: short_text95th-percentile length under 20 chars
Fig 24.
Character-length distribution for INTPTLON.
Show data table
Character-length distribution for INTPTLON (mean: 12.0).
charscount
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 123234
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120
12 – 120

geometry_type categorical feature

This column classifies the geometric representation type of spatial features, distinguishing between 'Polygon' and 'MultiPolygon' geometries across 3,234 records. The severe class imbalance is the standout signal: 'Polygon' dominates at 98.36% (3,181 records), leaving 'MultiPolygon' as a rare minority at only 53 occurrences (1.64%). The near-zero entropy (0.121) confirms this column carries almost no information variance, which limits its predictive utility.

Treatment: Flag MultiPolygon rows for geometry normalisation (explode to single polygons) before spatial analysis; otherwise low entropy makes this near-useless as a model feature.

anthropic:default · confidence high
Out[64]:

saturn.columns["geometry_type"].stats

statvalue
n3,234
nulls0 (0.0%)
unique2
top_value Polygon
top_rate 0.9836
cardinality 2
entropy 0.1207
entropy_ratio 0.1207
alert: imbalancetop value is 98.4% of rows
Fig 25.
Top values for geometry_type.
Show data table
Top values for geometry_type (2 unique shown, of 2 total).
valuecountshare
Polygon318198.4%
MultiPolygon531.6%

How to cite

click to copy

BibTeX
@misc{saturn-data-trove-us-county-state-boundaries-geojson-2026,
  author       = {Steuber, Luke},
  title        = {Saturn reading: data trove us county state boundaries geojson},
  year         ={2026},
  howpublished = {\url{https://dr.eamer.dev/saturn/view/data-trove-us-county-state-boundaries-geojson}},
  note         = {Profiled with saturn-dissect v0.2.0, prompt saturn-insight-v2, model anthropic:default},
}
APA
Steuber, L. (2026). Saturn reading: data trove us county state boundaries geojson. Source: /home/coolhand/html/datavis/data_trove/geographic/counties_simplified.geojson. Profiled with saturn-dissect v0.2.0 (saturn-insight-v2, anthropic:default). Retrieved from https://dr.eamer.dev/saturn/view/data-trove-us-county-state-boundaries-geojson