This dataset contains 3,222 rows covering U.S. counties, with three columns: a county name, a FIPS code, and median household income. The income column is the headline issue — it has a minimum of -666,666,666 and a mean of roughly -144,603 against a median of 60,458, indicating a sentinel value (likely a missing-data placeholder) that is dragging the distribution into nonsense. About 5.8% of records (188 rows) are flagged as outliers and skew is extreme (-56.7), so any analysis should filter these sentinels before computing summary stats. County names are essentially unique row labels, while FIPS codes look clean and well-distributed across the expected national range.
saturn
/home/coolhand/html/datavis/data_trove/cache/median_income.parquet 3,222 rows sample n=3,222 seed 42 2026-05-01T16:55:05+00:00
Overview
| Source | /home/coolhand/html/datavis/data_trove/cache/median_income.parquet |
| Total rows | 3,222 |
| Profiled sample | 3,222 |
| Columns | 3 |
| Generated | 2026-05-01T16:55:05+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 column is a FIPS county/area code—every one of the 3222 rows is unique with no nulls, and the values span 1001 to 72153, the canonical FIPS range covering U.S. states and territories. The distribution is nearly symmetric (skew 0.157, kurtosis -0.631) with no outliers, consistent with a structured geographic identifier rather than a measured quantity. Treat it as a key, not a numeric feature.
This column holds full US county identifiers (e.g., 'X County,
County-level median household income in dollars, with 3099 distinct values across 3222 rows and no nulls. The minimum of -666666666 is a clear sentinel for missing data, dragging the mean to -144603 even though the median is 60458.5 and Q1-Q3 sit between 51814.75 and 70376.25. This sentinel produces the extreme skew (-56.74) and kurtosis (3216.99), and 188 outliers (5.83%) are flagged.
Numeric correlation
fips numeric
county_name text
Sample values (first 10)
- Bibb County, Alabama
- Cheatham County, Tennessee
- Piute County, Utah
- Lamb County, Texas
- Martin County, Minnesota
- Sheridan County, Wyoming
- Chickasaw County, Mississippi
- Rockingham County, Virginia
- Liberty County, Texas
- Clark County, Arkansas