This dataset links 3,235 U.S. counties (by FIPS code) to their nearest geological mineral or fuel deposit, including the deposit's type, era, state, and distance. Coal dominates deposit_type at roughly 42% of rows, with Copper, Iron, and Oil rounding out the major categories — worth checking whether this reflects true geological prevalence or sampling bias. The distance_to_deposit column is heavily right-skewed (skew ~7.5, max 5652 vs. median 152), so a small number of remote counties pull the mean far above typical values and deserve a closer look. Deposit eras span nine geological periods led by Pennsylvanian (~23%), and deposit_state concentrates in Missouri, Ohio, and Alabama even though counties themselves are spread across all 56 state codes.
saturn
/home/coolhand/html/datavis/data_trove/geographic/fips_county/geology_counties.csv 3,235 rows sample n=3,235 seed 42 2026-05-01T17:27:52+00:00
Overview
| Source | /home/coolhand/html/datavis/data_trove/geographic/fips_county/geology_counties.csv |
| Total rows | 3,235 |
| Profiled sample | 3,235 |
| Columns | 9 |
| Generated | 2026-05-01T17:27:52+00:00 |
Insights opt-in
Model-generated narrative. These are opinions, not facts — the stats below are what saturn measured. Generated by: anthropic:claude-opus-4-7.
This is the FIPS code identifying U.S. counties (or equivalent geographies), with all 3235 values unique and no nulls. Values span 1001 to 78030, consistent with state-prefixed county codes, and the distribution is broad (IQR 27090) rather than meaningfully skewed (skew 0.17). Treat the numeric stats as incidental — magnitude has no quantitative meaning here.
This column holds US county-level place names, with 1,973 unique values across 3,235 rows and almost every entry containing the word 'county' (2,999 occurrences) alongside Louisiana 'parish' (64) and Puerto Rico 'municipio' (78) variants. Names repeat heavily — duplicate rate is 39% with classics like 'Washington County' (30), 'Jefferson County' (25), and 'Franklin County' (24) topping the list, which is expected since the same county name recurs across states. Entries are short (mean 14.2 chars, ~2 words) and there are no nulls or empties.
This is a US state code column with 56 unique values — more than the 50 states, suggesting territories or codes like DC, PR, or military designations are included. The distribution is fairly even (entropy ratio 0.92), with TX leading at 7.9% (254 of 3235 rows) followed by GA, VA, KY, and MO, consistent with a county- or jurisdiction-level dataset where larger states contribute more rows. No nulls.
This column holds U.S. state names, almost certainly one row per county or county-equivalent given the 3,235 total rows and 56 distinct values (the 50 states plus territories/DC). Texas dominates at 254 rows (7.85%), followed by Georgia (159) and Virginia (133), which matches the known county-count ranking. Distribution is highly even across categories (entropy ratio 0.92) with no nulls.
Numeric feature measuring distance to a deposit, likely in metres, with all 3235 rows populated and 2202 distinct values. The distribution is severely right-skewed (skew 7.51, kurtosis 77.6): the median is 152.0 while the mean is 230.12 and the max stretches to 5652.4, more than 14x the Q3 of 235.75. About 4.9% of rows (159) flag as outliers, and there are no zeros or nulls.
This column names the nearest mineral deposit for each record, with 97 distinct sites across 3,235 rows and no nulls. Distribution is moderately concentrated: "Hatchet Creek Copper" alone accounts for 13.4% (434 rows), and the top three deposits cover roughly 30% of the data, yet entropy ratio of 0.76 indicates the long tail still carries meaningful spread. Names mix mine types (copper, clay, sulfur), pits, banks, quads, and districts, suggesting heterogeneous source nomenclature rather than a clean controlled vocabulary.
Categorical label identifying the type of mineral or fuel deposit, with 10 distinct values across 3235 rows and no nulls. Coal dominates at 41.6% (1345 rows), followed by Copper, Iron, and Oil, while Zinc (23) and Silver (21) are rare. Entropy ratio of 0.76 indicates a moderately concentrated distribution skewed toward fossil/base resources rather than precious metals.
Categorical geological era/period label for deposits, spanning 9 distinct values across 3235 complete rows. Distribution is unusually flat for a categorical (entropy_ratio 0.945) — Pennsylvanian leads at only 22.6% (732 rows) and even the smallest, Permian, holds 95 rows. Note the mixed granularity: broad eras (Paleozoic, Precambrian) sit alongside specific periods (Devonian, Miocene), so categories are not mutually exclusive in geological time.
`deposit_state` is a categorical US-state field with 25 distinct values across 3,235 rows and no nulls. Distribution is fairly even (entropy ratio 0.83); the top state Missouri accounts for only 14.8%, followed closely by Ohio (448) and Alabama (434). Coverage is partial — only half the US states appear — so this is not a nationwide sample.
Numeric correlation
fips numeric
county_name text
Sample values (first 10)
- Pickens County
- Knox County
- Alpine County
- Ozaukee County
- Keokuk County
- Rush County
- DeKalb County
- Butler County
- Dewey County
- Hartley County
state categorical
Top values (rank 1–20)
- TX — 254
- GA — 159
- VA — 133
- KY — 120
- MO — 115
- KS — 105
- IL — 102
- NC — 100
- IA — 99
- TN — 95
- NE — 93
- IN — 92
- OH — 88
- MN — 87
- MI — 83
- MS — 82
- PR — 78
- OK — 77
- AR — 75
- WI — 72
state_name categorical
Top values (rank 1–20)
- Texas — 254
- Georgia — 159
- Virginia — 133
- Kentucky — 120
- Missouri — 115
- Kansas — 105
- Illinois — 102
- North Carolina — 100
- Iowa — 99
- Tennessee — 95
- Nebraska — 93
- Indiana — 92
- Ohio — 88
- Minnesota — 87
- Michigan — 83
- Mississippi — 82
- Puerto Rico — 78
- Oklahoma — 77
- Arkansas — 75
- Wisconsin — 72
distance_to_deposit numeric
nearest_deposit categorical
Top values (rank 1–20)
- Hatchet Creek Copper — 434
- Chaney No 1 Clay Mine — 302
- Cardonia Pit — 263
- Hager Mine — 179
- Lodgepole Quad — 171
- Cooper Mine — 164
- Stewart May — 161
- Main Pass Sulfur Mine — 115
- Dunn Bank — 101
- Batesville District — 96
- Unknown - Coal & Zn — 90
- Tole and Thorp Fireclay Mine — 89
- Ventech Gas Processors Sulfur Plant — 84
- Midland Farms Sulfur Plant — 66
- Belden Pit — 65
- Afc Pit — 45
- Iron Mine Hill Deposit — 43
- Butte Valley, Alamo #1 — 42
- Santa Rosa Tar Sands — 41
- Old Leyden Mine — 39
deposit_type categorical
Top values (rank 1–20)
- Coal — 1,345
- Copper — 485
- Iron — 403
- Oil — 400
- Natural Gas — 235
- Lead — 170
- Phosphate — 81
- Gold — 72
- Zinc — 23
- Silver — 21
deposit_era categorical
Top values (rank 1–20)
- Pennsylvanian — 732
- Devonian — 422
- Paleozoic — 419
- Tertiary — 401
- Mississippian — 401
- Precambrian — 327
- Cretaceous — 289
- Miocene — 149
- Permian — 95
deposit_state categorical
Top values (rank 1–20)
- Missouri — 478
- Ohio — 448
- Alabama — 434
- Indiana — 263
- Arkansas — 257
- South Dakota — 210
- New Jersey — 179
- Texas — 170
- Colorado — 144
- Louisiana — 115
- New York — 99
- Oregon — 71
- California — 68
- Idaho — 54
- New Mexico — 51
- Washington — 47
- Rhode Island — 43
- Montana — 37
- Utah — 30
- Arizona — 16