This dataset contains 3,222 US county-level labor market records with 8 columns covering county identifiers (FIPS, name, state) and workforce statistics (labor force, total 16+, unemployed, unemployment rate, participation rate). The unemployment rate averages 5.13% with a median of 4.69%, ranging up to 31.99%, so the right tail is worth inspecting for distressed counties. Population-based counts (labor_force, total_16_plus, unemployed) are extremely right-skewed (skew >13) with hundreds of outliers — expected when a few large metros sit alongside small rural counties, but it means you should likely log-transform before modeling. Texas (254), Georgia (159), and Virginia (133) contribute the most counties, reflecting state geography rather than any sampling bias. County names show a 39% duplicate rate driven by repeated names like Washington, Jefferson, and Franklin Counties across states — join on FIPS, not name.
saturn
/home/coolhand/datasets/us-inequality-atlas/economic/unemployment_by_county.csv 3,222 rows sample n=3,222 seed 42 2026-05-01T17:08:56+00:00
Overview
| Source | /home/coolhand/datasets/us-inequality-atlas/economic/unemployment_by_county.csv |
| Total rows | 3,222 |
| Profiled sample | 3,222 |
| Columns | 8 |
| Generated | 2026-05-01T17:08:56+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 U.S. county FIPS code, evidenced by every one of the 3222 rows being unique with no nulls and values spanning 1001 to 72153 — the standard 5-digit state+county encoding. The distribution is essentially uniform across the FIPS range (skew 0.16, kurtosis -0.63, no outliers), which is expected for an identifier rather than a measured quantity.
This column holds US county-level place names: 3,222 rows with 1,960 unique values, all between 10 and 46 characters and averaging ~2 words. The vocabulary is dominated by 'county' (2,999 occurrences) but also includes 'municipio' (78, Puerto Rico), 'parish' (64, Louisiana), and 'city' (47), so the field mixes several jurisdiction types. Note the 39.2% duplicate rate — recurring names like Washington County (30), Jefferson County (25), and Franklin County (24) appear across many states, so this name alone does not uniquely identify a county.
Two-letter US state/territory codes across 3,222 rows with 52 distinct values and no nulls — consistent with the 50 states plus DC and likely Puerto Rico. Distribution tracks county counts rather than population: TX leads at 254 (7.88%), followed by GA (159), VA (133) and KY (120), suggesting one row per county/equivalent. High entropy ratio (0.93) confirms a fairly even spread across states.
This is a numeric population-style count of people aged 16+, with 3222 non-null rows and 3148 unique values spanning 50 to 8,086,852. The distribution is severely right-skewed (skew 13.49, kurtosis 305.88): the median is 21,167.5 but the mean is 83,549.93 and 13.7% of rows (443) flag as outliers. The std of 265,514 dwarfs the IQR of 45,507.75, consistent with a long upper tail typical of geographic aggregates.
This column appears to be the size of the labor force per record, likely at a US county or similar geographic unit given the 3,222 rows and 3,099 unique values. The distribution is severely right-skewed (skew 13.29, kurtosis 295.22) with a median of 11,608.5 but a max of 5,240,842, and 14.2% of values flagged as outliers. No nulls or zeros, but the gap between Q3 (31,930.5) and the maximum signals a long tail of very large jurisdictions.
This is a numeric count of unemployed persons per record, with 3222 rows, no nulls, and 1859 unique values. The distribution is severely right-skewed (skew 16.82, kurtosis 450.4): the median is 589 while the mean is 2827 and the max reaches 365544, and 417 rows (12.9%) flag as outliers. Only 0.56% of records are zero, so sparsity is not the issue—a few extreme values are.
Numeric column capturing labor force participation rate, almost certainly expressed as a percentage given the 18.63 to 84.04 range and mean of 57.89. The distribution is moderately left-skewed (-0.58) with a tight IQR of 10.695 around a median of 58.72, and only 1.18% of values flagged as outliers. No nulls or zeros across 3,222 rows, and 1,944 unique values suggest a continuous measurement rather than a coded category.
This is a county- or region-level unemployment rate expressed as a percentage, with values from 0.0 to 31.99 and a median of 4.69. The distribution is heavily right-skewed (skew 2.55, kurtosis 12.81) with 154 outliers (4.78%) pulling the mean above the median, and a small share of zero readings (0.56%).
Numeric correlation
fips numeric
county_name text
Sample values (first 10)
- Bibb County
- Cheatham County
- Piute County
- Lamb County
- Martin County
- Sheridan County
- Chickasaw County
- Rockingham County
- Liberty County
- Clark 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