saturn

/home/coolhand/html/datavis/data_trove/data/urban/food_deserts/snap_gap_states.json 20 rows sample n=20 seed 42 2026-06-21T23:48:01+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/urban/food_deserts/snap_gap_states.json
Total rows20
Profiled sample20
Columns6
Generated2026-06-21T23:48:01+00:00
Show data table
Per-column null rate across the corpus.
columnkindnull %
state_namecategorical0.0%
snap_eligible_estnumeric0.0%
snap_participants_estnumeric0.0%
snap_gapnumeric0.0%
snap_gap_pctnumeric0.0%
snap_enrollment_ratenumeric0.0%

Insights opt-in

Model-generated narrative. These are opinions, not facts — the stats below are what saturn measured. Generated by: anthropic:default.

Dataset high anthropic:default

This dataset tracks SNAP (food stamp) program enrollment across 20 U.S. states, capturing estimated eligible populations, actual participants, and the resulting coverage gap. Two things stand out immediately: first, the enrollment rate and gap percentage are constant across all states (67% enrolled, 33% gap), suggesting these are summary-level figures rather than state-specific calculations — they should not be used for cross-state comparison. Second, the three population-count columns (eligible, participants, gap) are all heavily right-skewed with 2 outliers each, pointing to a small number of very large states — likely California and/or Florida — that dwarf the rest and will dominate any totals-based analysis.

snap_eligible_est high anthropic:default

This column represents estimated counts of SNAP-eligible individuals, likely at a geographic unit level (e.g., county or district). Values span a wide range from 75,227 to 4,685,272, with a median of 507,917 well below the mean of 857,172.75 — a classic signature of population-size data. The distribution is heavily right-skewed (skew = 2.42, kurtosis = 5.58) with 2 outliers (10% of rows), almost certainly large urban jurisdictions pulling the tail sharply upward.

snap_gap medium anthropic:default

snap_gap is a numeric column likely representing some form of gap or interval measurement (e.g., a time delta, distance, or capacity gap between snapshots). With only 20 rows and 20 unique values, every observation is distinct. The distribution is heavily right-skewed (skew = 2.42, kurtosis = 5.58): the median is 167,613 while the mean is pulled to 282,866 by a long upper tail, and 2 outliers (10% of rows) push up to a maximum of 1,546,138 — roughly 25× the minimum of 24,824. The IQR of 222,841 spans a wide range relative to Q1 of 61,204, signalling high dispersion.

snap_participants_est high anthropic:default

This column represents estimated SNAP (Supplemental Nutrition Assistance Program) participant counts, likely at the state or large geographic-unit level given the scale of values ranging from 50,403 to 3,139,134. With only 20 rows and 20 unique values, each record appears to represent a distinct entity (e.g., a U.S. state or territory). The distribution is heavily right-skewed (skew = 2.42, kurtosis = 5.58) with 2 outliers (10% of the dataset), suggesting a small number of very large states—likely California or Texas—dominate the upper tail, while the median (340,304) sits well below the mean (574,306).

snap_enrollment_rate high anthropic:default

This column represents a SNAP (Supplemental Nutrition Assistance Program) enrollment rate, likely expressed as a percentage. Every single one of the 20 rows holds the identical value of 67.0, with zero variance, zero IQR, and a standard deviation of 0.0 — the column is perfectly constant. This is a strong signal that the value was hardcoded, imputed with a single figure, or the dataset captures a single geographic/temporal stratum where this rate was applied uniformly. It carries no predictive or descriptive information across rows.

snap_gap_pct high anthropic:default

This column appears to represent a snapshot gap percentage, likely a configuration or policy parameter defining some threshold or interval (e.g., 33%). Across all 20 rows the value is identically 33.0 with zero variance, zero nulls, and a single unique value — making it a degenerate constant with no discriminative power whatsoever.

state_name high anthropic:default

This column contains US state (and territory) names, with exactly 20 unique values across 20 rows — every row holds a distinct state name, yielding a perfect entropy ratio of 1.0 and a top_rate of 0.05. The dataset appears to be a small, deduplicated lookup or summary table with one row per geographic unit rather than a transactional dataset. The 'long_tail' alert is a statistical artifact of the perfectly uniform distribution, not a genuine skew concern.

Numeric correlation

Show data table
Pearson correlation across 5 numeric columns (values clipped to 2 decimals).
snap_eligible_estsnap_participants_estsnap_gapsnap_gap_pctsnap_enrollment_rate
snap_eligible_est+1.00+1.00+1.00+nan+nan
snap_participants_est+1.00+1.00+1.00+nan+nan
snap_gap+1.00+1.00+1.00+nan+nan
snap_gap_pct+nan+nan+nan+nan+nan
snap_enrollment_rate+nan+nan+nan+nan+nan

state_name categorical

20 singleton categories
rows20
null0 (0.0%)
unique20
top_valueAlabama
top_rate0.050
cardinality20
entropy4.322
entropy_ratio1.000
Show data table
Top values for state_name (20 unique shown, of 20 total).
valuecountshare
Alabama15.0%
Alaska15.0%
Arizona15.0%
Arkansas15.0%
California15.0%
Colorado15.0%
Connecticut15.0%
Delaware15.0%
District of Columbia15.0%
Florida15.0%
Georgia15.0%
Hawaii15.0%
Idaho15.0%
Illinois15.0%
Indiana15.0%
Iowa15.0%
Kansas15.0%
Kentucky15.0%
Louisiana15.0%
Maine15.0%
Top values (rank 1–20)
  1. Alabama — 1
  2. Alaska — 1
  3. Arizona — 1
  4. Arkansas — 1
  5. California — 1
  6. Colorado — 1
  7. Connecticut — 1
  8. Delaware — 1
  9. District of Columbia — 1
  10. Florida — 1
  11. Georgia — 1
  12. Hawaii — 1
  13. Idaho — 1
  14. Illinois — 1
  15. Indiana — 1
  16. Iowa — 1
  17. Kansas — 1
  18. Kentucky — 1
  19. Louisiana — 1
  20. Maine — 1

snap_eligible_est numeric

skew=+2.42 10.0% rows beyond 1.5 IQR
rows20
null0 (0.0%)
unique20
min75,227
max4,685,272
mean857,173
median507,917
std1,103,022
q1185,464
q3860,748
iqr675,284
skew2.421
kurtosis5.577
n_outliers2
outlier_rate0.100
zero_rate0.000
Show data table
Histogram bins for snap_eligible_est (median: 507917.0).
bincount
7.523e+04 – 9.972e+0516
9.972e+05 – 1.919e+062
1.919e+06 – 2.841e+061
2.841e+06 – 3.763e+060
3.763e+06 – 4.685e+061

snap_participants_est numeric

skew=+2.42 10.0% rows beyond 1.5 IQR
rows20
null0 (0.0%)
unique20
min50,403
max3,139,134
mean574,306
median340,304
std739,025
q1124,260
q3576,702
iqr452,443
skew2.421
kurtosis5.577
n_outliers2
outlier_rate0.100
zero_rate0.000
Show data table
Histogram bins for snap_participants_est (median: 340304.0).
bincount
5.04e+04 – 6.681e+0516
6.681e+05 – 1.286e+062
1.286e+06 – 1.904e+061
1.904e+06 – 2.521e+060
2.521e+06 – 3.139e+061

snap_gap numeric

skew=+2.42 10.0% rows beyond 1.5 IQR
rows20
null0 (0.0%)
unique20
min24,824
max1,546,138
mean282,866
median167,613
std363,997
q161,204
q3284,045
iqr222,841
skew2.421
kurtosis5.577
n_outliers2
outlier_rate0.100
zero_rate0.000
Show data table
Histogram bins for snap_gap (median: 167613.0).
bincount
2.482e+04 – 3.291e+0516
3.291e+05 – 6.333e+052
6.333e+05 – 9.376e+051
9.376e+05 – 1.242e+060
1.242e+06 – 1.546e+061

snap_gap_pct numeric

only one distinct value
rows20
null0 (0.0%)
unique1
min33.000
max33.000
mean33.000
median33.000
std0.000
q133.000
q333.000
iqr0.000
skew0.000
kurtosis0.000
n_outliers0
outlier_rate0.000
zero_rate0.000
Show data table
Histogram bins for snap_gap_pct (median: 33.0).
bincount
32.5 – 32.70
32.7 – 32.90
32.9 – 33.120
33.1 – 33.30
33.3 – 33.50

snap_enrollment_rate numeric

only one distinct value
rows20
null0 (0.0%)
unique1
min67.000
max67.000
mean67.000
median67.000
std0.000
q167.000
q367.000
iqr0.000
skew0.000
kurtosis0.000
n_outliers0
outlier_rate0.000
zero_rate0.000
Show data table
Histogram bins for snap_enrollment_rate (median: 67.0).
bincount
66.5 – 66.70
66.7 – 66.90
66.9 – 67.120
67.1 – 67.30
67.3 – 67.50