cms-medicaid · saturn notebook

Overview

Source: /home/coolhand/datasets/accessibility-atlas/cms_medicaid_enrollment_2026.csv

Saturn profiled 10,302 rows across 44 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/datasets/accessibility-atlas/cms_medicaid_enrollment_2026.csv",
    "--findings", "cms-medicaid.json",
    "--llm", "anthropic:claude-opus-4-7",
])

Summary confidence: high

This dataset captures monthly state-level Medicaid and CHIP performance reports (10,302 rows × 44 columns) covering enrollment counts, application volumes, eligibility determinations by processing-time bucket, and call-center metrics across all 51 state jurisdictions. The reporting structure is clean and balanced — each state contributes 202 rows, and the Final Report and Preliminary/Updated flags split exactly 50/50 — but most numeric metrics are heavily right-skewed and riddled with outliers, since large states like California dwarf smaller ones (e.g., Total Medicaid Enrollment ranges from 0 to 13.2M with skew 3.6). Two things deserve a closer look first: the very high null rates on operational metrics (Total Adult Medicaid Enrollment is 85% null; call-center fields ~70% null), which suggests many states simply don't report these, and the Medicaid-expansion split (73% Y vs 27% N) which is a natural lens for comparing enrollment and processing outcomes. The free-text 'footnotes' columns are also worth scanning — they reveal systematic data-quality caveats (e.g., 'Incorrectly reporting processing time at application level') that should temper any cross-state comparison.

citing: row_count · column_count · Total Medicaid Enrollment · Total Medicaid and CHIP Enrollment · Total Adult Medicaid Enrollment · State Expanded Medicaid · State Abbreviation · Final Report · Preliminary or Updated · Average Call Center Wait Time (Minutes) · Average Call Center Abandonment Rate · Reporting Period

Out[4]:

saturn.schema() · 44 columns

column	kind	n	null%	unique	alerts
State Abbreviation	categorical	10,302	0.0%	51
State Name	categorical	10,302	0.0%	51
Reporting Period	numeric	10,302	0.0%	102
State Expanded Medicaid	categorical	10,302	0.0%	2
Preliminary or Updated	categorical	10,302	0.0%	2
Final Report	categorical	10,302	0.0%	2
New Applications Submitted to Medicaid and CHIP Agencies	numeric	10,302	0.5%	5,378	high_skew outliers
New Applications Submitted to Medicaid and CHIP Agencies - footnotes	categorical	10,302	76.6%	18	null_rate
Applications for Financial Assistance Submitted to the State Based Marketplace	numeric	10,302	0.5%	1,373	high_skew outliers
Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes	categorical	10,302	97.4%	3	null_rate
Total Applications for Financial Assistance Submitted at State Level	numeric	10,302	0.5%	5,591	high_skew outliers
Total Applications for Financial Assistance Submitted at State Level - footnotes	categorical	10,302	73.4%	17	null_rate
Individuals Determined Eligible for Medicaid at Application	numeric	10,302	0.5%	5,568	high_skew outliers
Individuals Determined Eligible for Medicaid at Application - footnotes	categorical	10,302	72.8%	18	null_rate
Individuals Determined Eligible for CHIP at Application	numeric	10,302	0.5%	3,064	high_skew outliers
Individuals Determined Eligible for CHIP at Application - footnotes	categorical	10,302	91.0%	7	null_rate
Total Medicaid and CHIP Determinations	numeric	10,302	0.5%	5,587	high_skew outliers
Total Medicaid and CHIP Determinations - footnotes	categorical	10,302	81.6%	12	null_rate
Medicaid and CHIP Child Enrollment	numeric	10,302	0.5%	8,094	high_skew outliers
Medicaid and CHIP Child Enrollment - footnotes	categorical	10,302	92.2%	7	null_rate
Total Medicaid and CHIP Enrollment	numeric	10,302	0.0%	8,309	high_skew outliers
Total Medicaid and CHIP Enrollment - footnotes	categorical	10,302	93.1%	9	null_rate
Total Medicaid Enrollment	numeric	10,302	0.5%	8,221	high_skew outliers
Total Medicaid Enrollment - footnotes	categorical	10,302	93.2%	7	null_rate
Total CHIP Enrollment	numeric	10,302	0.5%	7,918	high_skew outliers
Total CHIP Enrollment - footnotes	categorical	10,302	95.9%	4	null_rate
Total Adult Medicaid Enrollment	numeric	10,302	84.7%	1,415	high_skew null_rate
Total Adult Medicaid Enrollment - footnotes	categorical	10,302	98.8%	4	null_rate
Total Medicaid and CHIP Determinations Processed in Less than 24 Hours	numeric	10,302	43.1%	2,701	high_skew outliers null_rate
Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes	categorical	10,302	89.2%	20	null_rate
Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days	numeric	10,302	43.1%	2,559	high_skew outliers null_rate
Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes	categorical	10,302	89.2%	21	null_rate
Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days	numeric	10,302	43.1%	2,608	high_skew outliers null_rate
Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes	categorical	10,302	89.3%	16	null_rate
Total Medicaid and CHIP Determinations Processed between 31 days and 45 days	numeric	10,302	43.1%	1,923	high_skew outliers null_rate
Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes	categorical	10,302	89.3%	15	null_rate
Total Medicaid and CHIP Determinations Processed in More than 45 Days	numeric	10,302	43.1%	1,691	high_skew outliers null_rate
Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes	categorical	10,302	89.3%	15	null_rate
Total Call Center Volume (Number of Calls)	numeric	10,302	69.5%	1,592	high_skew outliers null_rate
Total Call Center Volume (Number of Calls) - footnotes	categorical	10,302	71.0%	27	null_rate
Average Call Center Wait Time (Minutes)	numeric	10,302	69.5%	63	null_rate
Average Call Center Wait Time (Minutes) - footnotes	categorical	10,302	69.7%	44	null_rate
Average Call Center Abandonment Rate	numeric	10,302	69.5%	408	null_rate
Average Call Center Abandonment Rate - footnotes	categorical	10,302	69.7%	36	null_rate

Fig 1.

Total Medicaid and CHIP Enrollment · Shows the heavy right-skew of state enrollment totals, ranging from near-zero up to ~14.5M.

Show data table

Histogram bins for Total Medicaid and CHIP Enrollment (median: 1031822.0).
bin	count
0 – 3.616e+05	2640
3.616e+05 – 7.231e+05	1192
7.231e+05 – 1.085e+06	1581
1.085e+06 – 1.446e+06	1149
1.446e+06 – 1.808e+06	1171
1.808e+06 – 2.169e+06	726
2.169e+06 – 2.531e+06	291
2.531e+06 – 2.893e+06	207
2.893e+06 – 3.254e+06	331
3.254e+06 – 3.616e+06	143
3.616e+06 – 3.977e+06	175
3.977e+06 – 4.339e+06	106
4.339e+06 – 4.7e+06	84
4.7e+06 – 5.062e+06	42
5.062e+06 – 5.423e+06	26
5.423e+06 – 5.785e+06	19
5.785e+06 – 6.147e+06	75
6.147e+06 – 6.508e+06	20
6.508e+06 – 6.87e+06	51
6.87e+06 – 7.231e+06	35
7.231e+06 – 7.593e+06	32
7.593e+06 – 7.954e+06	3
7.954e+06 – 8.316e+06	0
8.316e+06 – 8.678e+06	0
8.678e+06 – 9.039e+06	0
9.039e+06 – 9.401e+06	0
9.401e+06 – 9.762e+06	0
9.762e+06 – 1.012e+07	0
1.012e+07 – 1.049e+07	0
1.049e+07 – 1.085e+07	0
1.085e+07 – 1.121e+07	0
1.121e+07 – 1.157e+07	6
1.157e+07 – 1.193e+07	35
1.193e+07 – 1.229e+07	38
1.229e+07 – 1.265e+07	11
1.265e+07 – 1.302e+07	10
1.302e+07 – 1.338e+07	23
1.338e+07 – 1.374e+07	39
1.374e+07 – 1.41e+07	21
1.41e+07 – 1.446e+07	18

Fig 2.

State Expanded Medicaid · Roughly 73% of rows come from Medicaid-expansion states, a key segmentation variable.

Show data table

Top values for State Expanded Medicaid (2 unique shown, of 2 total).
value	count	share
Y	7475	72.6%
N	2827	27.4%

Fig 3.

Average Call Center Wait Time (Minutes) · Median wait is 5 minutes but the tail extends to 72 — useful for spotting service-level outliers.

Show data table

Histogram bins for Average Call Center Wait Time (Minutes) (median: 5.0).
bin	count
0 – 1.8	942
1.8 – 3.6	417
3.6 – 5.4	329
5.4 – 7.2	188
7.2 – 9	80
9 – 10.8	116
10.8 – 12.6	168
12.6 – 14.4	103
14.4 – 16.2	106
16.2 – 18	43
18 – 19.8	86
19.8 – 21.6	75
21.6 – 23.4	73
23.4 – 25.2	50
25.2 – 27	20
27 – 28.8	44
28.8 – 30.6	48
30.6 – 32.4	47
32.4 – 34.2	38
34.2 – 36	15
36 – 37.8	28
37.8 – 39.6	28
39.6 – 41.4	6
41.4 – 43.2	15
43.2 – 45	12
45 – 46.8	14
46.8 – 48.6	10
48.6 – 50.4	2
50.4 – 52.2	4
52.2 – 54	2
54 – 55.8	0
55.8 – 57.6	10
57.6 – 59.4	12
59.4 – 61.2	3
61.2 – 63	2
63 – 64.8	2
64.8 – 66.6	4
66.6 – 68.4	0
68.4 – 70.2	0
70.2 – 72	3

Fig 4.

Reporting Period · Confirms time coverage from Sept 2013 through 2025, roughly uniform across 102 monthly periods.

Show data table

Histogram bins for Reporting Period (median: 202107.5).
bin	count
2.013e+05 – 2.013e+05	51
2.013e+05 – 2.014e+05	0
2.014e+05 – 2.014e+05	0
2.014e+05 – 2.014e+05	0
2.014e+05 – 2.015e+05	0
2.015e+05 – 2.015e+05	0
2.015e+05 – 2.015e+05	0
2.015e+05 – 2.015e+05	0
2.015e+05 – 2.016e+05	0
2.016e+05 – 2.016e+05	0
2.016e+05 – 2.016e+05	0
2.016e+05 – 2.017e+05	0
2.017e+05 – 2.017e+05	0
2.017e+05 – 2.017e+05	714
2.017e+05 – 2.018e+05	0
2.018e+05 – 2.018e+05	0
2.018e+05 – 2.018e+05	1224
2.018e+05 – 2.018e+05	0
2.018e+05 – 2.019e+05	0
2.019e+05 – 2.019e+05	918
2.019e+05 – 2.019e+05	306
2.019e+05 – 2.02e+05	0
2.02e+05 – 2.02e+05	0
2.02e+05 – 2.02e+05	1224
2.02e+05 – 2.021e+05	0
2.021e+05 – 2.021e+05	0
2.021e+05 – 2.021e+05	1224
2.021e+05 – 2.021e+05	0
2.021e+05 – 2.022e+05	0
2.022e+05 – 2.022e+05	918
2.022e+05 – 2.022e+05	306
2.022e+05 – 2.023e+05	0
2.023e+05 – 2.023e+05	0
2.023e+05 – 2.023e+05	1224
2.023e+05 – 2.024e+05	0
2.024e+05 – 2.024e+05	0
2.024e+05 – 2.024e+05	1224
2.024e+05 – 2.024e+05	0
2.024e+05 – 2.025e+05	0
2.025e+05 – 2.025e+05	969

Fig 5.

State Abbreviation · Verifies balanced coverage — every one of the 51 jurisdictions contributes exactly 202 rows.

Show data table

Top values for State Abbreviation (20 unique shown, of 51 total).
value	count	share
AK	202	2.0%
AL	202	2.0%
AR	202	2.0%
AZ	202	2.0%
CA	202	2.0%
CO	202	2.0%
CT	202	2.0%
DC	202	2.0%
DE	202	2.0%
FL	202	2.0%
GA	202	2.0%
HI	202	2.0%
IA	202	2.0%
ID	202	2.0%
IL	202	2.0%
IN	202	2.0%
KS	202	2.0%
KY	202	2.0%
LA	202	2.0%
MA	202	2.0%

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.
column	kind	null %
State Abbreviation	categorical	0.0%
State Name	categorical	0.0%
Reporting Period	numeric	0.0%
State Expanded Medicaid	categorical	0.0%
Preliminary or Updated	categorical	0.0%
Final Report	categorical	0.0%
New Applications Submitted to Medicaid and CHIP Agencies	numeric	0.5%
New Applications Submitted to Medicaid and CHIP Agencies - footnotes	categorical	76.6%
Applications for Financial Assistance Submitted to the State Based Marketplace	numeric	0.5%
Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes	categorical	97.4%
Total Applications for Financial Assistance Submitted at State Level	numeric	0.5%
Total Applications for Financial Assistance Submitted at State Level - footnotes	categorical	73.4%
Individuals Determined Eligible for Medicaid at Application	numeric	0.5%
Individuals Determined Eligible for Medicaid at Application - footnotes	categorical	72.8%
Individuals Determined Eligible for CHIP at Application	numeric	0.5%
Individuals Determined Eligible for CHIP at Application - footnotes	categorical	91.0%
Total Medicaid and CHIP Determinations	numeric	0.5%
Total Medicaid and CHIP Determinations - footnotes	categorical	81.6%
Medicaid and CHIP Child Enrollment	numeric	0.5%
Medicaid and CHIP Child Enrollment - footnotes	categorical	92.2%
Total Medicaid and CHIP Enrollment	numeric	0.0%
Total Medicaid and CHIP Enrollment - footnotes	categorical	93.1%
Total Medicaid Enrollment	numeric	0.5%
Total Medicaid Enrollment - footnotes	categorical	93.2%
Total CHIP Enrollment	numeric	0.5%
Total CHIP Enrollment - footnotes	categorical	95.9%
Total Adult Medicaid Enrollment	numeric	84.7%
Total Adult Medicaid Enrollment - footnotes	categorical	98.8%
Total Medicaid and CHIP Determinations Processed in Less than 24 Hours	numeric	43.1%
Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes	categorical	89.2%
Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days	numeric	43.1%
Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes	categorical	89.2%
Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days	numeric	43.1%
Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes	categorical	89.3%
Total Medicaid and CHIP Determinations Processed between 31 days and 45 days	numeric	43.1%
Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes	categorical	89.3%
Total Medicaid and CHIP Determinations Processed in More than 45 Days	numeric	43.1%
Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes	categorical	89.3%
Total Call Center Volume (Number of Calls)	numeric	69.5%
Total Call Center Volume (Number of Calls) - footnotes	categorical	71.0%
Average Call Center Wait Time (Minutes)	numeric	69.5%
Average Call Center Wait Time (Minutes) - footnotes	categorical	69.7%
Average Call Center Abandonment Rate	numeric	69.5%
Average Call Center Abandonment Rate - footnotes	categorical	69.7%

Fig 7.

Pearson correlation across numeric columns (sampled, bounded).

Show data table

Pearson correlation across 12 numeric columns (values clipped to 2 decimals).
	Reporting Period	New Applications Submitted to Medicaid and CHIP Agencies	Applications for Financial Assistance Submitted to the State Based Marketplace	Total Applications for Financial Assistance Submitted at State Level	Individuals Determined Eligible for Medicaid at Application	Individuals Determined Eligible for CHIP at Application	Total Medicaid and CHIP Determinations	Medicaid and CHIP Child Enrollment	Total Medicaid and CHIP Enrollment	Total Medicaid Enrollment	Total CHIP Enrollment	Total Adult Medicaid Enrollment
Reporting Period	+1.00	-0.03	+0.09	+0.06	+0.07	+0.05	+0.07	+0.11	+0.11	+0.11	+0.07	+0.06
New Applications Submitted to Medicaid and CHIP Agencies	-0.03	+1.00	-0.07	+0.49	+0.60	+0.62	+0.61	+0.70	+0.59	+0.62	+0.52	+0.37
Applications for Financial Assistance Submitted to the State Based Marketplace	+0.09	-0.07	+1.00	+0.83	+0.25	+0.11	+0.24	+0.24	+0.27	+0.30	+0.29	+0.08
Total Applications for Financial Assistance Submitted at State Level	+0.06	+0.49	+0.83	+1.00	+0.55	+0.44	+0.54	+0.60	+0.56	+0.61	+0.54	+0.27
Individuals Determined Eligible for Medicaid at Application	+0.07	+0.60	+0.25	+0.55	+1.00	+0.89	+1.00	+0.65	+0.61	+0.64	+0.63	+0.38
Individuals Determined Eligible for CHIP at Application	+0.05	+0.62	+0.11	+0.44	+0.89	+1.00	+0.91	+0.55	+0.46	+0.48	+0.50	+0.27
Total Medicaid and CHIP Determinations	+0.07	+0.61	+0.24	+0.54	+1.00	+0.91	+1.00	+0.65	+0.60	+0.63	+0.62	+0.38
Medicaid and CHIP Child Enrollment	+0.11	+0.70	+0.24	+0.60	+0.65	+0.55	+0.65	+1.00	+0.94	+0.96	+0.92	+0.61
Total Medicaid and CHIP Enrollment	+0.11	+0.59	+0.27	+0.56	+0.61	+0.46	+0.60	+0.94	+1.00	+0.98	+0.95	+0.68
Total Medicaid Enrollment	+0.11	+0.62	+0.30	+0.61	+0.64	+0.48	+0.63	+0.96	+0.98	+1.00	+0.96	+0.69
Total CHIP Enrollment	+0.07	+0.52	+0.29	+0.54	+0.63	+0.50	+0.62	+0.92	+0.95	+0.96	+1.00	+0.68
Total Adult Medicaid Enrollment	+0.06	+0.37	+0.08	+0.27	+0.38	+0.27	+0.38	+0.61	+0.68	+0.69	+0.68	+1.00

State Abbreviation categorical feature

Two-letter US state abbreviation, with 51 distinct values (the 50 states plus DC) and zero nulls across 10,302 rows. The distribution is perfectly uniform: every state appears exactly 202 times, and entropy_ratio is 1.0, indicating this column was constructed as a balanced grid rather than sampled from real-world frequencies.

Treatment: One-hot or target-encode for modelling; useful as a join key on state-level lookups.

anthropic:claude-opus-4-7 · confidence high

Out[13]:

saturn.columns["State Abbreviation"].stats

stat	value
n	10,302
nulls	0 (0.0%)
unique	51
top_value	AK
top_rate	0.01961
cardinality	51
entropy	5.672
entropy_ratio	1

Fig 8.

Top values for State Abbreviation.

Show data table

Top values for State Abbreviation (20 unique shown, of 51 total).
value	count	share
AK	202	2.0%
AL	202	2.0%
AR	202	2.0%
AZ	202	2.0%
CA	202	2.0%
CO	202	2.0%
CT	202	2.0%
DC	202	2.0%
DE	202	2.0%
FL	202	2.0%
GA	202	2.0%
HI	202	2.0%
IA	202	2.0%
ID	202	2.0%
IL	202	2.0%
IN	202	2.0%
KS	202	2.0%
KY	202	2.0%
LA	202	2.0%
MA	202	2.0%

State Name categorical feature

This column holds US state names, with 51 distinct values (the 50 states plus District of Columbia) and zero nulls across 10,302 rows. The distribution is perfectly uniform: every state appears exactly 202 times, yielding a top_rate of 0.0196 and an entropy_ratio of 1.0. That balance suggests the dataset was constructed as a state-by-something grid rather than sampled from real-world frequencies.

Treatment: use as a categorical grouping key; one-hot or target-encode for modelling.

anthropic:claude-opus-4-7 · confidence high

Out[16]:

saturn.columns["State Name"].stats

stat	value
n	10,302
nulls	0 (0.0%)
unique	51
top_value	Alaska
top_rate	0.01961
cardinality	51
entropy	5.672
entropy_ratio	1

Fig 9.

Top values for State Name.

Show data table

Top values for State Name (20 unique shown, of 51 total).
value	count	share
Alaska	202	2.0%
Alabama	202	2.0%
Arkansas	202	2.0%
Arizona	202	2.0%
California	202	2.0%
Colorado	202	2.0%
Connecticut	202	2.0%
District of Columbia	202	2.0%
Delaware	202	2.0%
Florida	202	2.0%
Georgia	202	2.0%
Hawaii	202	2.0%
Iowa	202	2.0%
Idaho	202	2.0%
Illinois	202	2.0%
Indiana	202	2.0%
Kansas	202	2.0%
Kentucky	202	2.0%
Louisiana	202	2.0%
Massachusetts	202	2.0%

Reporting Period numeric timestamp

This column encodes a year-month reporting period as a packed integer (YYYYMM), spanning 201309 to 202510 across 102 distinct values with no nulls. Values cluster between Q1 201906 and Q3 202309, consistent with monthly reporting cadence rather than a true continuous numeric. The 'std' of 249.6 and IQR of 403 are artifacts of the YYYYMM encoding (gaps between ..12 and ..01) and should not be read as a real numeric spread.

Treatment: Parse YYYYMM into a proper month/date type before any time-series analysis.

anthropic:claude-opus-4-7 · confidence high

Out[19]:

saturn.columns["Reporting Period"].stats

stat	value
n	10,302
nulls	0 (0.0%)
unique	102
min	201,309
max	202,510
mean	2.021e+05
median	2.021e+05
std	249.6
q1	201,906
q3	202,309
iqr	403
skew	-0.1301
kurtosis	-0.8155
n_outliers	0
outlier_rate	0
zero_rate	0

Fig 10.

Distribution of Reporting Period. Vertical dash marks the median.

Show data table

Histogram bins for Reporting Period (median: 202107.5).
bin	count
2.013e+05 – 2.013e+05	51
2.013e+05 – 2.014e+05	0
2.014e+05 – 2.014e+05	0
2.014e+05 – 2.014e+05	0
2.014e+05 – 2.015e+05	0
2.015e+05 – 2.015e+05	0
2.015e+05 – 2.015e+05	0
2.015e+05 – 2.015e+05	0
2.015e+05 – 2.016e+05	0
2.016e+05 – 2.016e+05	0
2.016e+05 – 2.016e+05	0
2.016e+05 – 2.017e+05	0
2.017e+05 – 2.017e+05	0
2.017e+05 – 2.017e+05	714
2.017e+05 – 2.018e+05	0
2.018e+05 – 2.018e+05	0
2.018e+05 – 2.018e+05	1224
2.018e+05 – 2.018e+05	0
2.018e+05 – 2.019e+05	0
2.019e+05 – 2.019e+05	918
2.019e+05 – 2.019e+05	306
2.019e+05 – 2.02e+05	0
2.02e+05 – 2.02e+05	0
2.02e+05 – 2.02e+05	1224
2.02e+05 – 2.021e+05	0
2.021e+05 – 2.021e+05	0
2.021e+05 – 2.021e+05	1224
2.021e+05 – 2.021e+05	0
2.021e+05 – 2.022e+05	0
2.022e+05 – 2.022e+05	918
2.022e+05 – 2.022e+05	306
2.022e+05 – 2.023e+05	0
2.023e+05 – 2.023e+05	0
2.023e+05 – 2.023e+05	1224
2.023e+05 – 2.024e+05	0
2.024e+05 – 2.024e+05	0
2.024e+05 – 2.024e+05	1224
2.024e+05 – 2.024e+05	0
2.024e+05 – 2.025e+05	0
2.025e+05 – 2.025e+05	969

State Expanded Medicaid categorical feature

Binary Y/N flag indicating whether the state expanded Medicaid, fully populated across 10302 rows. The split is imbalanced: 72.6% 'Y' versus 2827 'N' records, but entropy ratio of 0.85 shows both classes are well represented. No nulls or unexpected categories.

Treatment: Encode as a 0/1 indicator for modelling.

anthropic:claude-opus-4-7 · confidence high

Out[22]:

saturn.columns["State Expanded Medicaid"].stats

stat	value
n	10,302
nulls	0 (0.0%)
unique	2
top_value	Y
top_rate	0.7256
cardinality	2
entropy	0.8477
entropy_ratio	0.8477

Fig 11.

Top values for State Expanded Medicaid.

Show data table

Top values for State Expanded Medicaid (2 unique shown, of 2 total).
value	count	share
Y	7475	72.6%
N	2827	27.4%

Preliminary or Updated categorical feature

Binary flag distinguishing 'Preliminary' (P) from 'Updated' (U) records, with exactly 5151 of each across 10302 rows. The perfectly even 50/50 split (entropy_ratio 1.0) is unusual for a real-world status field and suggests the dataset was constructed by pairing each preliminary record with its updated counterpart. No nulls.

Treatment: Encode as a binary indicator; consider whether to filter to only 'U' rows to avoid double-counting paired records.

anthropic:claude-opus-4-7 · confidence high

Out[25]:

saturn.columns["Preliminary or Updated"].stats

stat	value
n	10,302
nulls	0 (0.0%)
unique	2
top_value	U
top_rate	0.5
cardinality	2
entropy	1
entropy_ratio	1

Fig 12.

Top values for Preliminary or Updated.

Show data table

Top values for Preliminary or Updated (2 unique shown, of 2 total).
value	count	share
U	5151	50.0%
P	5151	50.0%

Final Report categorical label

Binary Y/N flag indicating whether a final report exists, with no nulls across 10302 rows. The split is exactly balanced at 5151 each, yielding maximum entropy (1.0) — this perfect 50/50 is unusual in real-world reporting data and suggests deliberate stratified sampling or class balancing.

Treatment: Encode as 0/1 and use directly as a binary target or stratification key.

anthropic:claude-opus-4-7 · confidence high

Out[28]:

saturn.columns["Final Report"].stats

stat	value
n	10,302
nulls	0 (0.0%)
unique	2
top_value	Y
top_rate	0.5
cardinality	2
entropy	1
entropy_ratio	1

Fig 13.

Top values for Final Report.

Show data table

Top values for Final Report (2 unique shown, of 2 total).
value	count	share
Y	5151	50.0%
N	5151	50.0%

New Applications Submitted to Medicaid and CHIP Agencies numeric feature

This column counts new Medicaid/CHIP applications submitted to state agencies, with 10,302 rows and 5,378 unique values. The distribution is heavily right-skewed (skew 4.08, kurtosis 23.5): the median is 14,644 but the mean is 29,897 and the max reaches 733,651, with 11.5% of values flagged as outliers and 4% exact zeros. The 0.5% null rate is negligible, but the spread between Q1 (4,511) and Q3 (29,973) confirms wide cross-state or cross-period variation.

Treatment: Apply a log1p transform before modelling to tame the skew and outliers.

anthropic:claude-opus-4-7 · confidence high

Out[31]:

saturn.columns["New Applications Submitted to Medicaid and CHIP Agencies"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	5,378
min	0
max	733,651
mean	2.99e+04
median	14,644
std	4.911e+04
q1	4,511
q3	29,973
iqr	25,462
skew	4.077
kurtosis	23.55
n_outliers	1,175
outlier_rate	0.1146
zero_rate	0.04019
alert: high_skew	skew=+4.08
alert: outliers	11.5% rows beyond 1.5 IQR

Fig 14.

Distribution of New Applications Submitted to Medicaid and CHIP Agencies. Vertical dash marks the median.

Show data table

Histogram bins for New Applications Submitted to Medicaid and CHIP Agencies (median: 14644.0).
bin	count
0 – 1.834e+04	5923
1.834e+04 – 3.668e+04	2165
3.668e+04 – 5.502e+04	640
5.502e+04 – 7.337e+04	475
7.337e+04 – 9.171e+04	348
9.171e+04 – 1.1e+05	193
1.1e+05 – 1.284e+05	106
1.284e+05 – 1.467e+05	96
1.467e+05 – 1.651e+05	50
1.651e+05 – 1.834e+05	34
1.834e+05 – 2.018e+05	4
2.018e+05 – 2.201e+05	6
2.201e+05 – 2.384e+05	20
2.384e+05 – 2.568e+05	29
2.568e+05 – 2.751e+05	50
2.751e+05 – 2.935e+05	34
2.935e+05 – 3.118e+05	18
3.118e+05 – 3.301e+05	30
3.301e+05 – 3.485e+05	16
3.485e+05 – 3.668e+05	6
3.668e+05 – 3.852e+05	2
3.852e+05 – 4.035e+05	4
4.035e+05 – 4.218e+05	0
4.218e+05 – 4.402e+05	0
4.402e+05 – 4.585e+05	0
4.585e+05 – 4.769e+05	0
4.769e+05 – 4.952e+05	0
4.952e+05 – 5.136e+05	0
5.136e+05 – 5.319e+05	0
5.319e+05 – 5.502e+05	0
5.502e+05 – 5.686e+05	0
5.686e+05 – 5.869e+05	0
5.869e+05 – 6.053e+05	0
6.053e+05 – 6.236e+05	0
6.236e+05 – 6.419e+05	0
6.419e+05 – 6.603e+05	0
6.603e+05 – 6.786e+05	0
6.786e+05 – 6.97e+05	0
6.97e+05 – 7.153e+05	0
7.153e+05 – 7.337e+05	2

New Applications Submitted to Medicaid and CHIP Agencies - footnotes categorical metadata

This is a free-form footnotes/caveats field annotating Medicaid/CHIP application counts, explaining what each state's submission does or does not include (e.g., renewals, administrative transfers, other programs). It is sparsely populated with a 0.766 null rate, and across 10302 rows only 18 distinct notes appear; the most common, 'Includes Renewals and/or Redeterminations', covers 27% of non-null entries. High entropy ratio (0.84) indicates the remaining notes are spread fairly evenly, suggesting heterogeneous reporting practices across states.

Treatment: Treat as data-quality caveat flags; split on ';' and one-hot encode the component clauses rather than modelling the raw string.

anthropic:claude-opus-4-7 · confidence high

Out[34]:

saturn.columns["New Applications Submitted to Medicaid and CHIP Agencies - footnotes"].stats

stat	value
n	10,302
nulls	7,891 (76.6%)
unique	18
top_value	Includes Renewals and/or Redeterminations
top_rate	0.27
cardinality	18
entropy	3.502
entropy_ratio	0.8399
alert: null_rate	76.6% null

Fig 15.

Top values for New Applications Submitted to Medicaid and CHIP Agencies - footnotes.

Show data table

Top values for New Applications Submitted to Medicaid and CHIP Agencies - footnotes (18 unique shown, of 18 total).
value	count	share
Includes Renewals and/or Redeterminations	651	6.3%
Does Not Include All Non-MAGI Applications Submitted to Medicaid and CHIP Agencies	245	2.4%
Includes Renewals and/or Redeterminations; Includes Administrative Data Transfers	197	1.9%
Includes Applications for Other Programs (e.g, QHPs, SNAP, etc.)	193	1.9%
Includes Applications for Other Programs (e.g, QHPs, SNAP, etc.); Includes Accounts Transferred from FFM	192	1.9%
Does Not Include All Applications for Limited-Benefit Programs Submitted to Medicaid and CHIP Agencies	190	1.8%
Includes Administrative Data Transfers; Does Not Include All Medicaid Applications Submitted to Medicaid and CHIP Agencies	161	1.6%
Does Not Include All Medicaid Applications Submitted to Medicaid and CHIP Agencies	112	1.1%
Includes SBM data	99	1.0%
Includes Accounts Transferred from FFM; Does Not Include All Applications for Limited-Benefit Programs Submitted to Medicaid and CHIP Agencies	97	0.9%
Includes Accounts Transferred from FFM; Does Not Include All Medicaid Applications Submitted to Medicaid and CHIP Agencies; Does Not Include All CHIP Applications Submitted to Medicaid and CHIP Agencies; Includes Administrative Data Transfers	91	0.9%
Includes Administrative Data Transfers; Includes Accounts Transferred from FFM; Does Not Include All Medicaid Applications Submitted to Medicaid and CHIP Agencies; Does Not Include All CHIP Applications Submitted to Medicaid and CHIP Agencies	67	0.7%
Does Not Include All Medicaid Applications Submitted to Medicaid and CHIP Agencies; Includes Administrative Data Transfers	34	0.3%
Includes Duplicates	26	0.3%
Count is of individuals as opposed to applications	21	0.2%
Does Not Include All Medicaid Applications Submitted to Medicaid and CHIP Agencies; Includes Duplicates	19	0.2%
Includes Accounts Transferred from FFM	8	0.1%
Includes Administrative Data Transfers; Includes Accounts Transferred from FFM	8	0.1%

Applications for Financial Assistance Submitted to the State Based Marketplace numeric feature

This column appears to be a count of applications for financial assistance submitted to a state-based health insurance marketplace, recorded across 10,302 rows. The distribution is extremely sparse and skewed: 77% of values are zero, the median and IQR are both 0, yet the maximum reaches 762,069 with a mean of 11,228 and std of 55,394. Skew (8.41) and kurtosis (82.6) are severe, and 23% of rows are flagged as outliers, indicating a small set of very large submission counts dominate the signal.

Treatment: Consider a zero-vs-nonzero indicator plus log1p transform before modelling, given 77% zeros and heavy right tail.

anthropic:claude-opus-4-7 · confidence high

Out[37]:

saturn.columns["Applications for Financial Assistance Submitted to the State Based Marketplace"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	1,373
min	0
max	762,069
mean	1.123e+04
median	0
std	5.539e+04
q1	0
q3	0
iqr	0
skew	8.415
kurtosis	82.64
n_outliers	2,357
outlier_rate	0.2299
zero_rate	0.7701
alert: high_skew	skew=+8.41
alert: outliers	23.0% rows beyond 1.5 IQR

Fig 16.

Distribution of Applications for Financial Assistance Submitted to the State Based Marketplace. Vertical dash marks the median.

Show data table

Histogram bins for Applications for Financial Assistance Submitted to the State Based Marketplace (median: 0.0).
bin	count
0 – 1.905e+04	9479
1.905e+04 – 3.81e+04	115
3.81e+04 – 5.716e+04	57
5.716e+04 – 7.621e+04	139
7.621e+04 – 9.526e+04	141
9.526e+04 – 1.143e+05	73
1.143e+05 – 1.334e+05	77
1.334e+05 – 1.524e+05	25
1.524e+05 – 1.715e+05	14
1.715e+05 – 1.905e+05	12
1.905e+05 – 2.096e+05	4
2.096e+05 – 2.286e+05	2
2.286e+05 – 2.477e+05	2
2.477e+05 – 2.667e+05	0
2.667e+05 – 2.858e+05	6
2.858e+05 – 3.048e+05	6
3.048e+05 – 3.239e+05	8
3.239e+05 – 3.429e+05	4
3.429e+05 – 3.62e+05	8
3.62e+05 – 3.81e+05	10
3.81e+05 – 4.001e+05	4
4.001e+05 – 4.191e+05	4
4.191e+05 – 4.382e+05	4
4.382e+05 – 4.572e+05	0
4.572e+05 – 4.763e+05	0
4.763e+05 – 4.953e+05	0
4.953e+05 – 5.144e+05	10
5.144e+05 – 5.334e+05	6
5.334e+05 – 5.525e+05	7
5.525e+05 – 5.716e+05	4
5.716e+05 – 5.906e+05	2
5.906e+05 – 6.097e+05	6
6.097e+05 – 6.287e+05	4
6.287e+05 – 6.478e+05	4
6.478e+05 – 6.668e+05	4
6.668e+05 – 6.859e+05	0
6.859e+05 – 7.049e+05	2
7.049e+05 – 7.24e+05	2
7.24e+05 – 7.43e+05	4
7.43e+05 – 7.621e+05	2

Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes categorical metadata

This is a footnotes/qualifier column attached to SBM financial-assistance application counts, carrying free-form caveats about what the underlying figures include. It's almost entirely empty (97.43% null) with only 3 distinct annotations across 10,302 rows; when present, 83% read 'Includes Renewals and/or Redeterminations'. The notes warn that some counts mix in renewals, duplicates, or exclude certain Medicaid applications — material caveats for anyone aggregating the parent metric.

Treatment: Keep as a qualifier flag joined to the parent metric; do not model directly.

anthropic:claude-opus-4-7 · confidence high

Out[40]:

saturn.columns["Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes"].stats

stat	value
n	10,302
nulls	10,037 (97.4%)
unique	3
top_value	Includes Renewals and/or Redeterminations
top_rate	0.8302
cardinality	3
entropy	0.8241
entropy_ratio	0.52
alert: null_rate	97.4% null

Fig 17.

Top values for Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes.

Show data table

Top values for Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes (3 unique shown, of 3 total).
value	count	share
Includes Renewals and/or Redeterminations	220	2.1%
Includes Duplicates; Includes Renewals and/or Redeterminations	26	0.3%
Does Not Include All Medicaid Applications Received By the SBM; Includes Duplicates; Includes Renewals and/or Redeterminations	19	0.2%

Total Applications for Financial Assistance Submitted at State Level numeric feature

Numeric count of financial-assistance applications aggregated to the state level, with 10,302 records and 5,591 unique values. The distribution is severely right-skewed (skew 4.40, kurtosis 26.4): the median is 18,257 but the mean is 41,125 and the max reaches 762,069, with 12.2% of rows flagged as outliers. About 2% of values are zero and 0.5% are null, so a long tail of high-volume states dominates the spread (std 72,081 vs IQR 33,613).

Treatment: Apply a log1p transform before modelling to tame the heavy right tail.

anthropic:claude-opus-4-7 · confidence high

Out[43]:

saturn.columns["Total Applications for Financial Assistance Submitted at State Level"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	5,591
min	0
max	762,069
mean	4.113e+04
median	18,257
std	7.208e+04
q1	6,494
q3	40,107
iqr	33,613
skew	4.396
kurtosis	26.4
n_outliers	1,249
outlier_rate	0.1218
zero_rate	0.02039
alert: high_skew	skew=+4.40
alert: outliers	12.2% rows beyond 1.5 IQR

Fig 18.

Distribution of Total Applications for Financial Assistance Submitted at State Level. Vertical dash marks the median.

Show data table

Histogram bins for Total Applications for Financial Assistance Submitted at State Level (median: 18257.0).
bin	count
0 – 1.905e+04	5336
1.905e+04 – 3.81e+04	2304
3.81e+04 – 5.716e+04	717
5.716e+04 – 7.621e+04	403
7.621e+04 – 9.526e+04	332
9.526e+04 – 1.143e+05	257
1.143e+05 – 1.334e+05	204
1.334e+05 – 1.524e+05	139
1.524e+05 – 1.715e+05	112
1.715e+05 – 1.905e+05	54
1.905e+05 – 2.096e+05	37
2.096e+05 – 2.286e+05	28
2.286e+05 – 2.477e+05	20
2.477e+05 – 2.667e+05	51
2.667e+05 – 2.858e+05	60
2.858e+05 – 3.048e+05	30
3.048e+05 – 3.239e+05	36
3.239e+05 – 3.429e+05	28
3.429e+05 – 3.62e+05	12
3.62e+05 – 3.81e+05	16
3.81e+05 – 4.001e+05	8
4.001e+05 – 4.191e+05	4
4.191e+05 – 4.382e+05	4
4.382e+05 – 4.572e+05	0
4.572e+05 – 4.763e+05	0
4.763e+05 – 4.953e+05	0
4.953e+05 – 5.144e+05	10
5.144e+05 – 5.334e+05	6
5.334e+05 – 5.525e+05	7
5.525e+05 – 5.716e+05	4
5.716e+05 – 5.906e+05	2
5.906e+05 – 6.097e+05	6
6.097e+05 – 6.287e+05	4
6.287e+05 – 6.478e+05	4
6.478e+05 – 6.668e+05	4
6.668e+05 – 6.859e+05	0
6.859e+05 – 7.049e+05	2
7.049e+05 – 7.24e+05	2
7.24e+05 – 7.43e+05	6
7.43e+05 – 7.621e+05	2

Total Applications for Financial Assistance Submitted at State Level - footnotes categorical metadata

Free-form footnote annotations qualifying state-level application counts, drawn from a small controlled vocabulary of 17 caveat strings (often semicolon-concatenated combinations). 73.44% of rows are null, and among the 2,737 populated rows the single value "Includes Renewals and/or Redeterminations" accounts for 42.5%, signalling that most states append the same scope caveat. Entropy ratio of 0.73 confirms the long tail is thin — these are methodology flags, not data.

Treatment: Keep as a qualifier when interpreting the parent metric; split on ';' into boolean flags rather than modelling as a feature.

anthropic:claude-opus-4-7 · confidence high

Out[46]:

saturn.columns["Total Applications for Financial Assistance Submitted at State Level - footnotes"].stats

stat	value
n	10,302
nulls	7,566 (73.4%)
unique	17
top_value	Includes Renewals and/or Redeterminations
top_rate	0.4251
cardinality	17
entropy	2.977
entropy_ratio	0.7283
alert: null_rate	73.4% null

Fig 19.

Top values for Total Applications for Financial Assistance Submitted at State Level - footnotes.

Show data table

Top values for Total Applications for Financial Assistance Submitted at State Level - footnotes (17 unique shown, of 17 total).
value	count	share
Includes Renewals and/or Redeterminations	1163	11.3%
Does Not Include All Non-MAGI Applications	245	2.4%
Includes Renewals and/or Redeterminations; Includes Administrative Data Transfers	197	1.9%
Includes Applications for Other Programs (e.g, QHPs, SNAP, etc.)	193	1.9%
Includes Applications for Other Programs (e.g, QHPs, SNAP, etc.); Includes Accounts Transferred from FFM	192	1.9%
Does Not Include All Applications for Limited-Benefit Programs	190	1.8%
Includes Administrative Data Transfers; Does Not Include All Medicaid Applications; Does Not Include All CHIP Applications	161	1.6%
Includes Accounts Transferred from FFM; Does Not Include All Applications for Limited-Benefit Programs	97	0.9%
Includes Accounts Transferred from FFM; Does Not Include All Medicaid Applications; Does Not Include All CHIP Applications; Includes Administrative Data Transfers	91	0.9%
Includes Administrative Data Transfers; Includes Accounts Transferred from FFM; Does Not Include All Medicaid Applications; Does Not Include All CHIP Applications	67	0.7%
Does Not Include All Medicaid Applications; Does Not Include All CHIP Applications; Includes Administrative Data Transfers	34	0.3%
Includes Duplicates	26	0.3%
Does Not Include All Medicaid Applications	24	0.2%
Count is of individuals as opposed to applications	21	0.2%
Does Not Include All Medicaid Applications; Includes Duplicates	19	0.2%
Includes Accounts Transferred from FFM	8	0.1%
Includes Administrative Data Transfers; Includes Accounts Transferred from FFM	8	0.1%

Individuals Determined Eligible for Medicaid at Application numeric feature

This column counts individuals determined eligible for Medicaid at application, likely aggregated per reporting unit (state/month). The distribution is heavily right-skewed (skew 2.93, kurtosis 11.06) with a median of 11,008 but a max of 435,560, and roughly 10.3% of rows flagged as outliers. About 5.9% of values are zero and 0.5% are null, so a small but non-trivial share of records report no eligibility activity.

Treatment: Log1p-transform before modelling to tame skew and outliers.

anthropic:claude-opus-4-7 · confidence high

Out[49]:

saturn.columns["Individuals Determined Eligible for Medicaid at Application"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	5,568
min	0
max	435,560
mean	2.744e+04
median	11,008
std	4.159e+04
q1	4,344
q3	32,631
iqr	28,287
skew	2.932
kurtosis	11.06
n_outliers	1,051
outlier_rate	0.1025
zero_rate	0.05863
alert: high_skew	skew=+2.93
alert: outliers	10.3% rows beyond 1.5 IQR

Fig 20.

Distribution of Individuals Determined Eligible for Medicaid at Application. Vertical dash marks the median.

Show data table

Histogram bins for Individuals Determined Eligible for Medicaid at Application (median: 11008.0).
bin	count
0 – 1.089e+04	5085
1.089e+04 – 2.178e+04	1748
2.178e+04 – 3.267e+04	862
3.267e+04 – 4.356e+04	850
4.356e+04 – 5.444e+04	382
5.444e+04 – 6.533e+04	138
6.533e+04 – 7.622e+04	144
7.622e+04 – 8.711e+04	146
8.711e+04 – 9.8e+04	136
9.8e+04 – 1.089e+05	135
1.089e+05 – 1.198e+05	107
1.198e+05 – 1.307e+05	72
1.307e+05 – 1.416e+05	54
1.416e+05 – 1.524e+05	77
1.524e+05 – 1.633e+05	62
1.633e+05 – 1.742e+05	74
1.742e+05 – 1.851e+05	49
1.851e+05 – 1.96e+05	40
1.96e+05 – 2.069e+05	16
2.069e+05 – 2.178e+05	27
2.178e+05 – 2.287e+05	7
2.287e+05 – 2.396e+05	11
2.396e+05 – 2.504e+05	6
2.504e+05 – 2.613e+05	6
2.613e+05 – 2.722e+05	3
2.722e+05 – 2.831e+05	4
2.831e+05 – 2.94e+05	0
2.94e+05 – 3.049e+05	2
3.049e+05 – 3.158e+05	0
3.158e+05 – 3.267e+05	0
3.267e+05 – 3.376e+05	1
3.376e+05 – 3.484e+05	3
3.484e+05 – 3.593e+05	0
3.593e+05 – 3.702e+05	0
3.702e+05 – 3.811e+05	0
3.811e+05 – 3.92e+05	0
3.92e+05 – 4.029e+05	0
4.029e+05 – 4.138e+05	0
4.138e+05 – 4.247e+05	2
4.247e+05 – 4.356e+05	2

Individuals Determined Eligible for Medicaid at Application - footnotes categorical metadata

This is a footnotes/caveats column annotating Medicaid eligibility determination counts, with 18 distinct qualifier strings (often semicolon-concatenated combinations like 'Includes Renewals and/or Redeterminations; Includes CHIP'). 72.8% of rows are null, meaning most records carry no caveat, but where present the top note 'Includes Renewals and/or Redeterminations' covers 28.1% of non-null entries. High entropy ratio (0.82) across only 18 values indicates the caveats are spread fairly evenly, signalling that the underlying count column is not measured consistently across reporters.

Treatment: Split on '; ' into boolean caveat flags and use them to qualify or filter the associated count column.

anthropic:claude-opus-4-7 · confidence high

Out[52]:

saturn.columns["Individuals Determined Eligible for Medicaid at Application - footnotes"].stats

stat	value
n	10,302
nulls	7,500 (72.8%)
unique	18
top_value	Includes Renewals and/or Redeterminations
top_rate	0.2812
cardinality	18
entropy	3.41
entropy_ratio	0.8178
alert: null_rate	72.8% null

Fig 21.

Top values for Individuals Determined Eligible for Medicaid at Application - footnotes.

Show data table

Top values for Individuals Determined Eligible for Medicaid at Application - footnotes (18 unique shown, of 18 total).
value	count	share
Includes Renewals and/or Redeterminations	788	7.6%
Does Not Include All Medicaid Determinations Made At Application	386	3.7%
Includes Renewals and/or Redeterminations; Includes CHIP	260	2.5%
Includes Renewals and/or Redeterminations; Does Not Include All Medicaid Determinations Made At Application	216	2.1%
Count is of Households, Not Individuals	203	2.0%
Includes CHIP	192	1.9%
Includes Renewals and/or Redeterminations; Does Not Include All MAGI Determinations Made At Application	180	1.7%
Includes CHIP; Includes Renewals and/or Redeterminations	102	1.0%
Does Not Include All Determinations for Limited-Benefit Programs Made At Application	97	0.9%
Count is of Households, Not Individuals; Includes Renewals and/or Redeterminations	83	0.8%
Includes CHIP; Count is of Households, Not Individuals; Includes Renewals and/or Redeterminations	77	0.7%
Count is of Households, Not Individuals; Does Not Include All Non-MAGI Determinations Made At Application	74	0.7%
Count is of Households, Not Individuals; Includes Renewals and/or Redeterminations; Includes CHIP	67	0.7%
Includes Renewals and/or Redeterminations; Count is of Households, Not Individuals	25	0.2%
Includes Conditional Eligibility Determinations; Includes Presumptive Eligibility Determinations; Does Not Include All CHIP Determinations Made At Application	21	0.2%
Includes Final Eligibility Determinations Made by FFM; Includes Conditional Eligibility Determinations; Includes Presumptive Eligibility Determinations	15	0.1%
Does Not Include All MAGI Determinations Made At Application; Includes Renewals and/or Redeterminations	9	0.1%
Does Not Include All Non-MAGI Determinations Made At Application	7	0.1%

Individuals Determined Eligible for CHIP at Application numeric feature

Monthly or periodic count of individuals determined eligible for CHIP (Children's Health Insurance Program) at the application stage, reported per submitting entity. The distribution is heavily right-skewed (skew 3.31, kurtosis 13.83) with a median of 679 but mean 2374.6 and max 44,881, and 11.4% of rows are exact zeros. Roughly 12.6% of values (1,295 rows) flag as outliers, suggesting a long tail of very large reporting units alongside many small or inactive ones.

Treatment: Apply a log1p transform before modelling and consider modelling the zero-mass separately.

anthropic:claude-opus-4-7 · confidence high

Out[55]:

saturn.columns["Individuals Determined Eligible for CHIP at Application"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	3,064
min	0
max	44,881
mean	2375
median	679
std	4296
q1	142
q3	2,421
iqr	2,279
skew	3.31
kurtosis	13.83
n_outliers	1,295
outlier_rate	0.1263
zero_rate	0.1137
alert: high_skew	skew=+3.31
alert: outliers	12.6% rows beyond 1.5 IQR

Fig 22.

Distribution of Individuals Determined Eligible for CHIP at Application. Vertical dash marks the median.

Show data table

Histogram bins for Individuals Determined Eligible for CHIP at Application (median: 679.0).
bin	count
0 – 1122	6282
1122 – 2244	1289
2244 – 3366	774
3366 – 4488	376
4488 – 5610	207
5610 – 6732	198
6732 – 7854	187
7854 – 8976	159
8976 – 1.01e+04	171
1.01e+04 – 1.122e+04	83
1.122e+04 – 1.234e+04	94
1.234e+04 – 1.346e+04	80
1.346e+04 – 1.459e+04	63
1.459e+04 – 1.571e+04	42
1.571e+04 – 1.683e+04	25
1.683e+04 – 1.795e+04	36
1.795e+04 – 1.907e+04	22
1.907e+04 – 2.02e+04	20
2.02e+04 – 2.132e+04	26
2.132e+04 – 2.244e+04	33
2.244e+04 – 2.356e+04	19
2.356e+04 – 2.468e+04	19
2.468e+04 – 2.581e+04	8
2.581e+04 – 2.693e+04	8
2.693e+04 – 2.805e+04	2
2.805e+04 – 2.917e+04	3
2.917e+04 – 3.029e+04	3
3.029e+04 – 3.142e+04	2
3.142e+04 – 3.254e+04	8
3.254e+04 – 3.366e+04	6
3.366e+04 – 3.478e+04	4
3.478e+04 – 3.59e+04	0
3.59e+04 – 3.703e+04	0
3.703e+04 – 3.815e+04	0
3.815e+04 – 3.927e+04	0
3.927e+04 – 4.039e+04	0
4.039e+04 – 4.151e+04	0
4.151e+04 – 4.264e+04	0
4.264e+04 – 4.376e+04	0
4.376e+04 – 4.488e+04	2

Individuals Determined Eligible for CHIP at Application - footnotes categorical metadata

Free-text footnote annotations qualifying CHIP eligibility counts at application, populated only when a caveat applies. The column is 90.99% null with just 7 distinct notes across 10,302 rows; among the 928 populated cells, 'Includes Renewals and/or Redeterminations' dominates at 46.55%. The notes flag methodology caveats (renewals mixed in, household vs individual counts, incomplete determinations) that materially affect comparability of the numeric column they annotate.

Treatment: Keep as a caveat flag; binarize or one-hot the handful of footnote categories before comparing the associated count column across rows.

anthropic:claude-opus-4-7 · confidence high

Out[58]:

saturn.columns["Individuals Determined Eligible for CHIP at Application - footnotes"].stats

stat	value
n	10,302
nulls	9,374 (91.0%)
unique	7
top_value	Includes Renewals and/or Redeterminations
top_rate	0.4655
cardinality	7
entropy	1.939
entropy_ratio	0.6905
alert: null_rate	91.0% null

Fig 23.

Top values for Individuals Determined Eligible for CHIP at Application - footnotes.

Show data table

Top values for Individuals Determined Eligible for CHIP at Application - footnotes (7 unique shown, of 7 total).
value	count	share
Includes Renewals and/or Redeterminations	432	4.2%
Includes Renewals and/or Redeterminations; Does Not Include All CHIP Determinations Made At Application	216	2.1%
Does Not Include All CHIP Determinations Made At Application	200	1.9%
Count is of Households, Not Individuals	37	0.4%
Includes Conditional Eligibility Determinations; Includes Presumptive Eligibility Determinations; Does Not Include All CHIP Determinations Made At Application	21	0.2%
Includes Final Eligibility Determinations Made by FFM; Includes Conditional Eligibility Determinations; Includes Presumptive Eligibility Determinations	15	0.1%
Count is of Households, Not Individuals; Includes Renewals and/or Redeterminations	7	0.1%

Total Medicaid and CHIP Determinations numeric feature

This is a numeric feature recording total Medicaid and CHIP eligibility determinations, likely aggregated per state-month or similar reporting unit. The distribution is heavily right-skewed (skew 2.92, kurtosis 10.77) with a median of 11,977 against a mean of 29,811 and a max of 467,780, and roughly 10.5% of rows flagged as outliers. About 5.5% of values are zero and 0.5% are null, suggesting some non-reporting or inactive periods.

Treatment: Log-transform (log1p) before modelling to tame the heavy right tail.

anthropic:claude-opus-4-7 · confidence high

Out[61]:

saturn.columns["Total Medicaid and CHIP Determinations"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	5,587
min	0
max	467,780
mean	2.981e+04
median	11,977
std	4.535e+04
q1	4,739
q3	35,059
iqr	30,320
skew	2.922
kurtosis	10.77
n_outliers	1,076
outlier_rate	0.105
zero_rate	0.05492
alert: high_skew	skew=+2.92
alert: outliers	10.5% rows beyond 1.5 IQR

Fig 24.

Distribution of Total Medicaid and CHIP Determinations. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Determinations (median: 11977.0).
bin	count
0 – 1.169e+04	5036
1.169e+04 – 2.339e+04	1757
2.339e+04 – 3.508e+04	896
3.508e+04 – 4.678e+04	844
4.678e+04 – 5.847e+04	386
5.847e+04 – 7.017e+04	137
7.017e+04 – 8.186e+04	137
8.186e+04 – 9.356e+04	131
9.356e+04 – 1.053e+05	147
1.053e+05 – 1.169e+05	149
1.169e+05 – 1.286e+05	120
1.286e+05 – 1.403e+05	60
1.403e+05 – 1.52e+05	52
1.52e+05 – 1.637e+05	65
1.637e+05 – 1.754e+05	64
1.754e+05 – 1.871e+05	64
1.871e+05 – 1.988e+05	51
1.988e+05 – 2.105e+05	43
2.105e+05 – 2.222e+05	26
2.222e+05 – 2.339e+05	33
2.339e+05 – 2.456e+05	11
2.456e+05 – 2.573e+05	9
2.573e+05 – 2.69e+05	11
2.69e+05 – 2.807e+05	4
2.807e+05 – 2.924e+05	2
2.924e+05 – 3.041e+05	6
3.041e+05 – 3.158e+05	0
3.158e+05 – 3.274e+05	2
3.274e+05 – 3.391e+05	0
3.391e+05 – 3.508e+05	0
3.508e+05 – 3.625e+05	4
3.625e+05 – 3.742e+05	0
3.742e+05 – 3.859e+05	0
3.859e+05 – 3.976e+05	0
3.976e+05 – 4.093e+05	0
4.093e+05 – 4.21e+05	0
4.21e+05 – 4.327e+05	0
4.327e+05 – 4.444e+05	1
4.444e+05 – 4.561e+05	1
4.561e+05 – 4.678e+05	2

Total Medicaid and CHIP Determinations - footnotes categorical metadata

Free-form footnote annotations attached to state Medicaid/CHIP determination counts, describing caveats like inclusion of renewals or exclusions of certain determination types. The column is 81.58% null, leaving only ~1,900 populated rows across 12 distinct caveat strings, with 'Includes Renewals and/or Redeterminations' alone covering 47.1% of non-null entries. Several values are semicolon-concatenated combinations of base caveats, so the 12-way cardinality understates the underlying flag set.

Treatment: Split on '; ' into boolean caveat flags rather than treating as a single categorical.

anthropic:claude-opus-4-7 · confidence high

Out[64]:

saturn.columns["Total Medicaid and CHIP Determinations - footnotes"].stats

stat	value
n	10,302
nulls	8,404 (81.6%)
unique	12
top_value	Includes Renewals and/or Redeterminations
top_rate	0.471
cardinality	12
entropy	2.42
entropy_ratio	0.675
alert: null_rate	81.6% null

Fig 25.

Top values for Total Medicaid and CHIP Determinations - footnotes.

Show data table

Top values for Total Medicaid and CHIP Determinations - footnotes (12 unique shown, of 12 total).
value	count	share
Includes Renewals and/or Redeterminations	894	8.7%
Does Not Include All Medicaid Determinations Made At Application; Does Not Include All CHIP Determinations Made At Application	334	3.2%
Includes Renewals and/or Redeterminations; Does Not Include All Medicaid Determinations Made At Application; Does Not Include All CHIP Determinations Made At Application	216	2.1%
Count is of Households, Not Individuals; Includes Renewals and/or Redeterminations	151	1.5%
Does Not Include All Determinations for Limited-Benefit Programs Made At Application	97	0.9%
Does Not Include All Non-MAGI Determinations Made At Application	81	0.8%
Does Not Include All Medicaid Determinations Made At Application	49	0.5%
Includes Renewals and/or Redeterminations; Count is of Households, Not Individuals	25	0.2%
Includes Conditional Eligibility Determinations; Includes Presumptive Eligibility Determinations; Does Not Include All CHIP Determinations Made At Application	21	0.2%
Includes Final Eligibility Determinations Made by FFM; Includes Conditional Eligibility Determinations; Includes Presumptive Eligibility Determinations	15	0.1%
Count is of Households, Not Individuals	12	0.1%
Does Not Include All Non-MAGI Determinations Made At Application; Does Not Include All Medicaid Determinations Made At Application; Does Not Include All CHIP Determinations Made At Application	3	0.0%

Medicaid and CHIP Child Enrollment numeric feature

This column reports counts of Medicaid and CHIP child enrollees, with 10,302 rows and 8,094 unique values spanning 0 to 5,339,904. The distribution is heavily right-skewed (skew 2.80, kurtosis 8.85) with a mean of 740,683 well above the median of 511,370, and roughly 7.8% of values flagged as outliers. About 2.1% of rows are exactly zero and 0.5% are null, suggesting a mix of small and very large reporting units.

Treatment: Log-transform (log1p) before modelling to tame the heavy right tail.

anthropic:claude-opus-4-7 · confidence high

Out[67]:

saturn.columns["Medicaid and CHIP Child Enrollment"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	8,094
min	0
max	5.34e+06
mean	7.407e+05
median	511,370
std	9.294e+05
q1	156,330
q3	836,539
iqr	680,209
skew	2.799
kurtosis	8.851
n_outliers	804
outlier_rate	0.07843
zero_rate	0.02127
alert: high_skew	skew=+2.80
alert: outliers	7.8% rows beyond 1.5 IQR

Fig 26.

Distribution of Medicaid and CHIP Child Enrollment. Vertical dash marks the median.

Show data table

Histogram bins for Medicaid and CHIP Child Enrollment (median: 511370.0).
bin	count
0 – 1.335e+05	2347
1.335e+05 – 2.67e+05	1120
2.67e+05 – 4.005e+05	1049
4.005e+05 – 5.34e+05	815
5.34e+05 – 6.675e+05	1121
6.675e+05 – 8.01e+05	986
8.01e+05 – 9.345e+05	783
9.345e+05 – 1.068e+06	174
1.068e+06 – 1.201e+06	94
1.201e+06 – 1.335e+06	316
1.335e+06 – 1.468e+06	404
1.468e+06 – 1.602e+06	196
1.602e+06 – 1.735e+06	31
1.735e+06 – 1.869e+06	11
1.869e+06 – 2.002e+06	0
2.002e+06 – 2.136e+06	0
2.136e+06 – 2.269e+06	0
2.269e+06 – 2.403e+06	22
2.403e+06 – 2.536e+06	217
2.536e+06 – 2.67e+06	95
2.67e+06 – 2.803e+06	20
2.803e+06 – 2.937e+06	24
2.937e+06 – 3.07e+06	20
3.07e+06 – 3.204e+06	16
3.204e+06 – 3.337e+06	55
3.337e+06 – 3.471e+06	28
3.471e+06 – 3.604e+06	30
3.604e+06 – 3.738e+06	6
3.738e+06 – 3.871e+06	12
3.871e+06 – 4.005e+06	20
4.005e+06 – 4.138e+06	16
4.138e+06 – 4.272e+06	6
4.272e+06 – 4.405e+06	16
4.405e+06 – 4.539e+06	0
4.539e+06 – 4.672e+06	0
4.672e+06 – 4.806e+06	8
4.806e+06 – 4.939e+06	40
4.939e+06 – 5.073e+06	62
5.073e+06 – 5.206e+06	58
5.206e+06 – 5.34e+06	33

Medicaid and CHIP Child Enrollment - footnotes categorical metadata

This column holds free-form footnotes annotating the Medicaid and CHIP child enrollment counts, explaining caveats like enrollment-period basis or data completeness. It is null 92.19% of the time, and among the 805 populated rows there are only 7 distinct messages, with 'Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)' covering 49.57% of them. The presence of 'Unable to provide data due to system limitations' (218 rows) is a meaningful data-quality flag tied to specific reporters.

Treatment: Keep as a qualifier flag joined to the enrollment metric; do not model directly.

anthropic:claude-opus-4-7 · confidence high

Out[70]:

saturn.columns["Medicaid and CHIP Child Enrollment - footnotes"].stats

stat	value
n	10,302
nulls	9,497 (92.2%)
unique	7
top_value	Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)
top_rate	0.4957
cardinality	7
entropy	1.854
entropy_ratio	0.6605
alert: null_rate	92.2% null

Fig 27.

Top values for Medicaid and CHIP Child Enrollment - footnotes.

Show data table

Top values for Medicaid and CHIP Child Enrollment - footnotes (7 unique shown, of 7 total).
value	count	share
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)	399	3.9%
Unable to provide data due to system limitations	218	2.1%
Includes Retroactive Enrollments	120	1.2%
Does Not Include All Full-Benefit Child Medicaid enrollees	42	0.4%
Does Not Include All Full-Benefit MAGI Child enrollees	11	0.1%
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count); Includes Retroactive Enrollments	8	0.1%
Does Not Include All Full-Benefit Child Medicaid enrollees; Does Not Include All CHIP enrollees	7	0.1%

Total Medicaid and CHIP Enrollment numeric feature

State-level (or similar geographic) totals of Medicaid and CHIP enrollees, ranging from 0 to about 14.46M with a median of roughly 1.03M and mean of 1.57M. The distribution is heavily right-skewed (skew 3.67, kurtosis 16.6) with 692 outliers (6.7%), consistent with a few very large states dominating the tail. Nulls and zeros are negligible (0.02% and 0.03%).

Treatment: Log-transform before modelling to tame the heavy right tail.

anthropic:claude-opus-4-7 · confidence high

Out[73]:

saturn.columns["Total Medicaid and CHIP Enrollment"].stats

stat	value
n	10,302
nulls	2 (0.0%)
unique	8,309
min	0
max	1.446e+07
mean	1.567e+06
median	1.032e+06
std	2.054e+06
q1	349,361
q3	1.805e+06
iqr	1.455e+06
skew	3.67
kurtosis	16.57
n_outliers	692
outlier_rate	0.06718
zero_rate	0.0002913
alert: high_skew	skew=+3.67
alert: outliers	6.7% rows beyond 1.5 IQR

Fig 28.

Distribution of Total Medicaid and CHIP Enrollment. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Enrollment (median: 1031822.0).
bin	count
0 – 3.616e+05	2640
3.616e+05 – 7.231e+05	1192
7.231e+05 – 1.085e+06	1581
1.085e+06 – 1.446e+06	1149
1.446e+06 – 1.808e+06	1171
1.808e+06 – 2.169e+06	726
2.169e+06 – 2.531e+06	291
2.531e+06 – 2.893e+06	207
2.893e+06 – 3.254e+06	331
3.254e+06 – 3.616e+06	143
3.616e+06 – 3.977e+06	175
3.977e+06 – 4.339e+06	106
4.339e+06 – 4.7e+06	84
4.7e+06 – 5.062e+06	42
5.062e+06 – 5.423e+06	26
5.423e+06 – 5.785e+06	19
5.785e+06 – 6.147e+06	75
6.147e+06 – 6.508e+06	20
6.508e+06 – 6.87e+06	51
6.87e+06 – 7.231e+06	35
7.231e+06 – 7.593e+06	32
7.593e+06 – 7.954e+06	3
7.954e+06 – 8.316e+06	0
8.316e+06 – 8.678e+06	0
8.678e+06 – 9.039e+06	0
9.039e+06 – 9.401e+06	0
9.401e+06 – 9.762e+06	0
9.762e+06 – 1.012e+07	0
1.012e+07 – 1.049e+07	0
1.049e+07 – 1.085e+07	0
1.085e+07 – 1.121e+07	0
1.121e+07 – 1.157e+07	6
1.157e+07 – 1.193e+07	35
1.193e+07 – 1.229e+07	38
1.229e+07 – 1.265e+07	11
1.265e+07 – 1.302e+07	10
1.302e+07 – 1.338e+07	23
1.338e+07 – 1.374e+07	39
1.374e+07 – 1.41e+07	21
1.41e+07 – 1.446e+07	18

Total Medicaid and CHIP Enrollment - footnotes categorical metadata

Footnote annotations qualifying the Total Medicaid and CHIP Enrollment figure for each row, drawn from a controlled vocabulary of just 9 phrases. The column is sparse — 93.11% null — and when present is dominated by a single caveat, "Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)", which accounts for 56.19% of non-null values (399 of ~710). The remaining notes flag scope exclusions or retroactive counts that materially affect comparability across states or months.

Treatment: Keep as a qualifier flag joined to the enrollment figure; do not model directly, but filter or stratify analyses by these caveats.

anthropic:claude-opus-4-7 · confidence high

Out[76]:

saturn.columns["Total Medicaid and CHIP Enrollment - footnotes"].stats

stat	value
n	10,302
nulls	9,592 (93.1%)
unique	9
top_value	Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)
top_rate	0.562
cardinality	9
entropy	1.832
entropy_ratio	0.578
alert: null_rate	93.1% null

Fig 29.

Top values for Total Medicaid and CHIP Enrollment - footnotes.

Show data table

Top values for Total Medicaid and CHIP Enrollment - footnotes (9 unique shown, of 9 total).
value	count	share
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)	399	3.9%
Includes Enrollees in Other Financial Assistance Programs Not Enrolled in Medicaid or CHIP	135	1.3%
Includes Retroactive Enrollments	120	1.2%
Does Not Include All Full-Benefit Medicaid enrollees; Does Not Include All CHIP enrollees	19	0.2%
Does Not Include All Full-Benefit Non-MAGI enrollees	11	0.1%
Does Not Include All Full-Benefit Medicaid enrollees	10	0.1%
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count); Includes Limited-Benefit Enrollees; Includes Retroactive Enrollments	8	0.1%
Does Not Include All Individuals Conditionally Eligible	5	0.0%
Unable to Provide Data due to System Limitations	3	0.0%

Total Medicaid Enrollment numeric feature

Counts of Medicaid enrollees, almost certainly aggregated by state-month or similar reporting unit (10,302 rows, 8,221 unique values, near-zero nulls). The distribution is heavily right-skewed (skew 3.61, kurtosis 16.1) with a median of 949,244 but a max of 13,160,563, and 691 rows (6.7%) flagged as outliers — consistent with a few very large states dominating the tail. Minimum is 0 but only 0.03% of rows are zero, so true empties are rare.

Treatment: log-transform before regression to tame the right skew.

anthropic:claude-opus-4-7 · confidence high

Out[79]:

saturn.columns["Total Medicaid Enrollment"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	8,221
min	0
max	1.316e+07
mean	1.433e+06
median	949,244
std	1.865e+06
q1	319,127
q3	1.647e+06
iqr	1.328e+06
skew	3.613
kurtosis	16.11
n_outliers	691
outlier_rate	0.06741
zero_rate	0.0002927
alert: high_skew	skew=+3.61
alert: outliers	6.7% rows beyond 1.5 IQR

Fig 30.

Distribution of Total Medicaid Enrollment. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid Enrollment (median: 949244.0).
bin	count
0 – 3.29e+05	2655
3.29e+05 – 6.58e+05	1219
6.58e+05 – 9.87e+05	1452
9.87e+05 – 1.316e+06	1130
1.316e+06 – 1.645e+06	1219
1.645e+06 – 1.974e+06	738
1.974e+06 – 2.303e+06	276
2.303e+06 – 2.632e+06	180
2.632e+06 – 2.961e+06	355
2.961e+06 – 3.29e+06	147
3.29e+06 – 3.619e+06	171
3.619e+06 – 3.948e+06	137
3.948e+06 – 4.277e+06	54
4.277e+06 – 4.606e+06	42
4.606e+06 – 4.935e+06	38
4.935e+06 – 5.264e+06	14
5.264e+06 – 5.593e+06	78
5.593e+06 – 5.922e+06	39
5.922e+06 – 6.251e+06	37
6.251e+06 – 6.58e+06	26
6.58e+06 – 6.909e+06	30
6.909e+06 – 7.238e+06	13
7.238e+06 – 7.567e+06	0
7.567e+06 – 7.896e+06	0
7.896e+06 – 8.225e+06	0
8.225e+06 – 8.554e+06	0
8.554e+06 – 8.883e+06	0
8.883e+06 – 9.212e+06	0
9.212e+06 – 9.541e+06	0
9.541e+06 – 9.87e+06	0
9.87e+06 – 1.02e+07	3
1.02e+07 – 1.053e+07	27
1.053e+07 – 1.086e+07	35
1.086e+07 – 1.119e+07	20
1.119e+07 – 1.152e+07	10
1.152e+07 – 1.184e+07	11
1.184e+07 – 1.217e+07	24
1.217e+07 – 1.25e+07	34
1.25e+07 – 1.283e+07	21
1.283e+07 – 1.316e+07	16

Total Medicaid Enrollment - footnotes categorical metadata

Footnote annotations qualifying the Total Medicaid Enrollment figures, drawn from a small controlled vocabulary of 7 distinct caveats. The column is 93.21% null, so only 700 of 10302 rows carry any note, and 57% of those flag that the count includes individuals enrolled at any time in the month rather than a point-in-time count. A handful of rows even disclose 'Unable to Provide Data due to System Limitations', which materially affects how the paired enrollment number should be read.

Treatment: Keep as a qualifier flag joined to the enrollment value; do not impute, and exclude or footnote rows with the system-limitation note when aggregating.

anthropic:claude-opus-4-7 · confidence high

Out[82]:

saturn.columns["Total Medicaid Enrollment - footnotes"].stats

stat	value
n	10,302
nulls	9,602 (93.2%)
unique	7
top_value	Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)
top_rate	0.57
cardinality	7
entropy	1.725
entropy_ratio	0.6144
alert: null_rate	93.2% null

Fig 31.

Top values for Total Medicaid Enrollment - footnotes.

Show data table

Top values for Total Medicaid Enrollment - footnotes (7 unique shown, of 7 total).
value	count	share
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)	399	3.9%
Includes Enrollees in Other Financial Assistance Programs Not Enrolled in Medicaid or CHIP	135	1.3%
Includes Retroactive Enrollments	120	1.2%
Does Not Include All Full-Benefit Medicaid enrollees	24	0.2%
Does Not Include All Full-Benefit Non-MAGI enrollees	11	0.1%
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count); Includes Limited-Benefit Enrollees; Includes Retroactive Enrollments	8	0.1%
Unable to Provide Data due to System Limitations	3	0.0%

Total CHIP Enrollment numeric feature

Likely a count of children enrolled in CHIP (Children's Health Insurance Program), probably aggregated by state and time period across 10,302 rows. The distribution is heavily right-skewed (skew 3.90, kurtosis 18.21) with the mean (136,663) far above the median (78,933) and a max of 1,317,347, plus 542 outliers (5.3%). Near-zero zero_rate (0.03%) and low null_rate (0.5%) indicate the field is consistently populated.

Treatment: log-transform before regression to tame the heavy right tail.

anthropic:claude-opus-4-7 · confidence high

Out[85]:

saturn.columns["Total CHIP Enrollment"].stats

stat	value
n	10,302
nulls	51 (0.5%)
unique	7,918
min	0
max	1.317e+06
mean	1.367e+05
median	78,933
std	2.026e+05
q1	26,056
q3	172,021
iqr	145,965
skew	3.897
kurtosis	18.21
n_outliers	542
outlier_rate	0.05287
zero_rate	0.0002927
alert: high_skew	skew=+3.90
alert: outliers	5.3% rows beyond 1.5 IQR

Fig 32.

Distribution of Total CHIP Enrollment. Vertical dash marks the median.

Show data table

Histogram bins for Total CHIP Enrollment (median: 78933.0).
bin	count
0 – 3.293e+04	2984
3.293e+04 – 6.587e+04	1521
6.587e+04 – 9.88e+04	1323
9.88e+04 – 1.317e+05	963
1.317e+05 – 1.647e+05	780
1.647e+05 – 1.976e+05	717
1.976e+05 – 2.305e+05	428
2.305e+05 – 2.635e+05	359
2.635e+05 – 2.964e+05	303
2.964e+05 – 3.293e+05	186
3.293e+05 – 3.623e+05	137
3.623e+05 – 3.952e+05	10
3.952e+05 – 4.281e+05	12
4.281e+05 – 4.611e+05	8
4.611e+05 – 4.94e+05	8
4.94e+05 – 5.269e+05	21
5.269e+05 – 5.599e+05	65
5.599e+05 – 5.928e+05	112
5.928e+05 – 6.257e+05	67
6.257e+05 – 6.587e+05	18
6.587e+05 – 6.916e+05	28
6.916e+05 – 7.245e+05	0
7.245e+05 – 7.575e+05	0
7.575e+05 – 7.904e+05	0
7.904e+05 – 8.233e+05	0
8.233e+05 – 8.563e+05	0
8.563e+05 – 8.892e+05	0
8.892e+05 – 9.221e+05	0
9.221e+05 – 9.551e+05	0
9.551e+05 – 9.88e+05	0
9.88e+05 – 1.021e+06	0
1.021e+06 – 1.054e+06	0
1.054e+06 – 1.087e+06	0
1.087e+06 – 1.12e+06	0
1.12e+06 – 1.153e+06	0
1.153e+06 – 1.186e+06	0
1.186e+06 – 1.219e+06	0
1.219e+06 – 1.251e+06	36
1.251e+06 – 1.284e+06	15
1.284e+06 – 1.317e+06	150

Total CHIP Enrollment - footnotes categorical metadata

This is a sparse footnote/qualifier column annotating CHIP enrollment counts, present on only ~4% of rows (null_rate 0.9592). Among the 420 non-null entries, four distinct notes appear, dominated by 'Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)' at 75.95%, with smaller mentions of retroactive enrollments, incomplete coverage, and system-limitation gaps. These notes signal that the accompanying enrollment numbers are not methodologically uniform across rows.

Treatment: Keep as a caveat flag joined to the enrollment column; do not use as a modelling feature.

anthropic:claude-opus-4-7 · confidence high

Out[88]:

saturn.columns["Total CHIP Enrollment - footnotes"].stats

stat	value
n	10,302
nulls	9,882 (95.9%)
unique	4
top_value	Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)
top_rate	0.7595
cardinality	4
entropy	1.033
entropy_ratio	0.5167
alert: null_rate	95.9% null

Fig 33.

Top values for Total CHIP Enrollment - footnotes.

Show data table

Top values for Total CHIP Enrollment - footnotes (4 unique shown, of 4 total).
value	count	share
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)	319	3.1%
Includes Retroactive Enrollments	73	0.7%
Does Not Include All CHIP enrollees	25	0.2%
Unable to Provide Data due to System Limitations	3	0.0%

Total Adult Medicaid Enrollment numeric feature

Counts of adult Medicaid enrollees, almost certainly aggregated by state and reporting period. Coverage is sparse — 84.65% of rows are null — and the populated values are heavily right-skewed (skew 4.56, kurtosis 23.38) with a mean of 810,066 sitting well above the median of 551,447 and a max of 8,497,290. Only 1,415 distinct values across 10,302 rows suggests repeated state-level totals, and 62 outliers (3.9%) likely correspond to the largest states.

Treatment: Impute or filter the 84.65% nulls and log-transform before any regression.

anthropic:claude-opus-4-7 · confidence high

Out[91]:

saturn.columns["Total Adult Medicaid Enrollment"].stats

stat	value
n	10,302
nulls	8,721 (84.7%)
unique	1,415
min	0
max	8.497e+06
mean	8.101e+05
median	551,447
std	1.269e+06
q1	168,141
q3	951,232
iqr	783,091
skew	4.556
kurtosis	23.38
n_outliers	62
outlier_rate	0.03922
zero_rate	0.001898
alert: high_skew	skew=+4.56
alert: null_rate	84.7% null

Fig 34.

Distribution of Total Adult Medicaid Enrollment. Vertical dash marks the median.

Show data table

Histogram bins for Total Adult Medicaid Enrollment (median: 551447.0).
bin	count
0 – 2.179e+05	490
2.179e+05 – 4.358e+05	238
4.358e+05 – 6.536e+05	209
6.536e+05 – 8.715e+05	183
8.715e+05 – 1.089e+06	203
1.089e+06 – 1.307e+06	23
1.307e+06 – 1.525e+06	80
1.525e+06 – 1.743e+06	74
1.743e+06 – 1.961e+06	19
1.961e+06 – 2.179e+06	0
2.179e+06 – 2.397e+06	0
2.397e+06 – 2.615e+06	0
2.615e+06 – 2.832e+06	0
2.832e+06 – 3.05e+06	0
3.05e+06 – 3.268e+06	0
3.268e+06 – 3.486e+06	0
3.486e+06 – 3.704e+06	0
3.704e+06 – 3.922e+06	0
3.922e+06 – 4.14e+06	15
4.14e+06 – 4.358e+06	16
4.358e+06 – 4.575e+06	0
4.575e+06 – 4.793e+06	0
4.793e+06 – 5.011e+06	0
5.011e+06 – 5.229e+06	0
5.229e+06 – 5.447e+06	0
5.447e+06 – 5.665e+06	0
5.665e+06 – 5.883e+06	0
5.883e+06 – 6.101e+06	0
6.101e+06 – 6.318e+06	0
6.318e+06 – 6.536e+06	0
6.536e+06 – 6.754e+06	0
6.754e+06 – 6.972e+06	0
6.972e+06 – 7.19e+06	0
7.19e+06 – 7.408e+06	0
7.408e+06 – 7.626e+06	0
7.626e+06 – 7.844e+06	0
7.844e+06 – 8.062e+06	0
8.062e+06 – 8.279e+06	2
8.279e+06 – 8.497e+06	29

Total Adult Medicaid Enrollment - footnotes categorical metadata

This is a footnotes/caveats column accompanying Total Adult Medicaid Enrollment, holding methodological annotations rather than data values. It is 98.79% null with only 4 distinct notes across 10,302 rows; the dominant note (56% of non-nulls, 70 occurrences) flags that counts include anyone enrolled at any time in the month rather than a point-in-time count, while 3 rows admit data could not be provided due to system limitations.

Treatment: Keep as a qualitative caveat lookup; do not use as a model feature given the 98.79% null rate.

anthropic:claude-opus-4-7 · confidence high

Out[94]:

saturn.columns["Total Adult Medicaid Enrollment - footnotes"].stats

stat	value
n	10,302
nulls	10,177 (98.8%)
unique	4
top_value	Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)
top_rate	0.56
cardinality	4
entropy	1.382
entropy_ratio	0.6908
alert: null_rate	98.8% null

Fig 35.

Top values for Total Adult Medicaid Enrollment - footnotes.

Show data table

Top values for Total Adult Medicaid Enrollment - footnotes (4 unique shown, of 4 total).
value	count	share
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count)	70	0.7%
Includes Retroactive Enrollments	44	0.4%
Includes Individuals Enrolled At Any Time in Month (Not a Point-in-Time Count); Includes Limited-Benefit Enrollees; Includes Retroactive Enrollments	8	0.1%
Unable to Provide Data due to System Limitations	3	0.0%

Total Medicaid and CHIP Determinations Processed in Less than 24 Hours numeric feature

This column counts Medicaid/CHIP determinations processed in under 24 hours per reporting unit, with values ranging from 0 to 791,175 and a median of just 3,470. It is severely right-skewed (skew 6.44, kurtosis 47.28) with mean 22,240 dwarfing the median, 699 outliers (11.9%), and a 43.07% null rate that an analyst should not ignore. About 2.1% of records are zero, suggesting some agencies report no fast-track determinations.

Treatment: Impute or flag the 43% missing, then log-transform before any modelling to tame the skew.

anthropic:claude-opus-4-7 · confidence high

Out[97]:

saturn.columns["Total Medicaid and CHIP Determinations Processed in Less than 24 Hours"].stats

stat	value
n	10,302
nulls	4,437 (43.1%)
unique	2,701
min	0
max	791,175
mean	2.224e+04
median	3,470
std	7.333e+04
q1	932
q3	12,172
iqr	11,240
skew	6.441
kurtosis	47.28
n_outliers	699
outlier_rate	0.1192
zero_rate	0.02148
alert: high_skew	skew=+6.44
alert: outliers	11.9% rows beyond 1.5 IQR
alert: null_rate	43.1% null

Fig 36.

Distribution of Total Medicaid and CHIP Determinations Processed in Less than 24 Hours. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Determinations Processed in Less than 24 Hours (median: 3470.0).
bin	count
0 – 1.978e+04	4914
1.978e+04 – 3.956e+04	349
3.956e+04 – 5.934e+04	102
5.934e+04 – 7.912e+04	136
7.912e+04 – 9.89e+04	43
9.89e+04 – 1.187e+05	69
1.187e+05 – 1.385e+05	68
1.385e+05 – 1.582e+05	35
1.582e+05 – 1.78e+05	12
1.78e+05 – 1.978e+05	14
1.978e+05 – 2.176e+05	4
2.176e+05 – 2.374e+05	8
2.374e+05 – 2.571e+05	2
2.571e+05 – 2.769e+05	8
2.769e+05 – 2.967e+05	6
2.967e+05 – 3.165e+05	4
3.165e+05 – 3.362e+05	4
3.362e+05 – 3.56e+05	2
3.56e+05 – 3.758e+05	8
3.758e+05 – 3.956e+05	2
3.956e+05 – 4.154e+05	4
4.154e+05 – 4.351e+05	4
4.351e+05 – 4.549e+05	4
4.549e+05 – 4.747e+05	2
4.747e+05 – 4.945e+05	0
4.945e+05 – 5.143e+05	10
5.143e+05 – 5.34e+05	6
5.34e+05 – 5.538e+05	9
5.538e+05 – 5.736e+05	4
5.736e+05 – 5.934e+05	4
5.934e+05 – 6.132e+05	6
6.132e+05 – 6.329e+05	4
6.329e+05 – 6.527e+05	4
6.527e+05 – 6.725e+05	2
6.725e+05 – 6.923e+05	0
6.923e+05 – 7.121e+05	2
7.121e+05 – 7.318e+05	2
7.318e+05 – 7.516e+05	4
7.516e+05 – 7.714e+05	2
7.714e+05 – 7.912e+05	2

Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes categorical metadata

Footnote/caveat field annotating data-quality issues with the 'Total Medicaid and CHIP Determinations Processed in Less than 24 Hours' metric. It is null 89.21% of the time, with only 20 distinct values across 10,302 rows; the most common note, appearing 420 times (37.77% of non-nulls), flags reporting at application rather than individual level. Several entries are semicolon-concatenated combinations of caveats, suggesting a multi-label field flattened into strings.

Treatment: Keep as a caveat flag; split on ';' into boolean indicators if you need to filter unreliable rows from the paired metric.

anthropic:claude-opus-4-7 · confidence high

Out[100]:

saturn.columns["Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes"].stats

stat	value
n	10,302
nulls	9,190 (89.2%)
unique	20
top_value	Incorrectly reporting processing time at application level, as opposed to the individual level
top_rate	0.3777
cardinality	20
entropy	2.968
entropy_ratio	0.6867
alert: null_rate	89.2% null

Fig 37.

Top values for Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes.

Show data table

Top values for Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes (20 unique shown, of 20 total).
value	count	share
Incorrectly reporting processing time at application level, as opposed to the individual level	420	4.1%
Incorrectly includes redeterminations	177	1.7%
Does not include all MAGI determinations on applications	143	1.4%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level	90	0.9%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	70	0.7%
Incorrectly includes redeterminations; Does not include all MAGI determinations on applications	57	0.6%
Unable to provide data due to system limitations	39	0.4%
Includes some non-MAGI determinations on applications	24	0.2%
Includes some non-MAGI determinations on applications; Incorrectly includes redeterminations	18	0.2%
Reflects incorrect start dates for processing time on some reopened applications	10	0.1%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	10	0.1%
Includes some non-Medicaid or CHIP determinations on applications; Reflects incorrect start dates for processing time on some reopened applications	8	0.1%
Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	8	0.1%
Includes some non-MAGI determinations on applications; Does not include all MAGI determinations on applications	6	0.1%
Includes some non-MAGI determinations on applications; Incorrectly reporting processing time at application level, as opposed to the individual level	6	0.1%
Determinations conducted in less than 24 hours are reported under the 1-7 days category	6	0.1%
Incorrectly includes reinstatements	6	0.1%
Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	6	0.1%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly includes redeterminations	6	0.1%
Includes some non-Medicaid or CHIP determinations on applications	2	0.0%

Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days numeric feature

This column counts state-level Medicaid and CHIP eligibility determinations processed in the 24-hour to 7-day window. Values are heavily right-skewed (skew 4.39, kurtosis 29.5) with a median of 2,312 but a max of 133,996, and 10.3% of values flag as outliers — consistent with a few large states dominating volumes. Note that 43.1% of rows are null and 2.7% are exact zeros, so coverage is partial.

Treatment: Log-transform and impute or flag missingness before modelling.

anthropic:claude-opus-4-7 · confidence high

Out[103]:

saturn.columns["Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days"].stats

stat	value
n	10,302
nulls	4,437 (43.1%)
unique	2,559
min	0
max	133,996
mean	5465
median	2,312
std	9481
q1	723
q3	5,802
iqr	5,079
skew	4.392
kurtosis	29.55
n_outliers	602
outlier_rate	0.1026
zero_rate	0.02677
alert: high_skew	skew=+4.39
alert: outliers	10.3% rows beyond 1.5 IQR
alert: null_rate	43.1% null

Fig 38.

Distribution of Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days (median: 2312.0).
bin	count
0 – 3350	3582
3350 – 6700	1036
6700 – 1.005e+04	405
1.005e+04 – 1.34e+04	240
1.34e+04 – 1.675e+04	119
1.675e+04 – 2.01e+04	74
2.01e+04 – 2.345e+04	109
2.345e+04 – 2.68e+04	93
2.68e+04 – 3.015e+04	53
3.015e+04 – 3.35e+04	31
3.35e+04 – 3.685e+04	18
3.685e+04 – 4.02e+04	19
4.02e+04 – 4.355e+04	11
4.355e+04 – 4.69e+04	10
4.69e+04 – 5.025e+04	7
5.025e+04 – 5.36e+04	9
5.36e+04 – 5.695e+04	11
5.695e+04 – 6.03e+04	12
6.03e+04 – 6.365e+04	2
6.365e+04 – 6.7e+04	8
6.7e+04 – 7.035e+04	2
7.035e+04 – 7.37e+04	4
7.37e+04 – 7.705e+04	0
7.705e+04 – 8.04e+04	0
8.04e+04 – 8.375e+04	4
8.375e+04 – 8.71e+04	2
8.71e+04 – 9.045e+04	0
9.045e+04 – 9.38e+04	0
9.38e+04 – 9.715e+04	0
9.715e+04 – 1.005e+05	0
1.005e+05 – 1.038e+05	2
1.038e+05 – 1.072e+05	0
1.072e+05 – 1.105e+05	0
1.105e+05 – 1.139e+05	0
1.139e+05 – 1.172e+05	0
1.172e+05 – 1.206e+05	0
1.206e+05 – 1.239e+05	0
1.239e+05 – 1.273e+05	0
1.273e+05 – 1.306e+05	0
1.306e+05 – 1.34e+05	2

Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes categorical metadata

Footnote annotations describing data quality caveats for the Medicaid/CHIP 24h-7d determinations metric. The column is 89.21% null, leaving only ~1,111 populated rows across 21 distinct caveat strings, with the top note ('Incorrectly reporting processing time at application level...') covering 37.77% of the non-null entries. Many values are semicolon-concatenated combinations of caveats, indicating multiple data quality issues stacked per row.

Treatment: Keep as a qualitative caveat flag; split on ';' to derive boolean data-quality indicators rather than modelling directly.

anthropic:claude-opus-4-7 · confidence high

Out[106]:

saturn.columns["Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes"].stats

stat	value
n	10,302
nulls	9,190 (89.2%)
unique	21
top_value	Incorrectly reporting processing time at application level, as opposed to the individual level
top_rate	0.3777
cardinality	21
entropy	3.026
entropy_ratio	0.689
alert: null_rate	89.2% null

Fig 39.

Top values for Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes.

Show data table

Top values for Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes (20 unique shown, of 21 total).
value	count	share
Incorrectly reporting processing time at application level, as opposed to the individual level	420	4.1%
Incorrectly includes redeterminations	177	1.7%
Does not include all MAGI determinations on applications	143	1.4%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level; MAGI determinations conducted in 6-7 days are reported under the 8-30 days category	72	0.7%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	70	0.7%
Incorrectly includes redeterminations; Does not include all MAGI determinations on applications	57	0.6%
Unable to provide data due to system limitations	39	0.4%
Includes some non-MAGI determinations on applications	24	0.2%
Includes some non-MAGI determinations on applications; Incorrectly includes redeterminations	18	0.2%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level	18	0.2%
Reflects incorrect start dates for processing time on some reopened applications	10	0.1%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	10	0.1%
Includes some non-Medicaid or CHIP determinations on applications; Reflects incorrect start dates for processing time on some reopened applications	8	0.1%
Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	8	0.1%
Includes some non-MAGI determinations on applications; Does not include all MAGI determinations on applications	6	0.1%
Includes some non-MAGI determinations on applications; Incorrectly reporting processing time at application level, as opposed to the individual level	6	0.1%
Determinations conducted in less than 24 hours are reported under the 1-7 days category	6	0.1%
Incorrectly includes reinstatements	6	0.1%
Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	6	0.1%
Determinations conducted in less than 24 hours are reported under the 1-7 days category; Incorrectly includes redeterminations	6	0.1%

Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days numeric feature

Numeric count of Medicaid/CHIP eligibility determinations processed in the 8-30 day window, likely reported per state-month. Distribution is heavily right-skewed (skew 3.98, kurtosis 19.86) with median 2528 but max 155529, and 10.2% of values flagged as outliers. Notably, 43.1% of rows are null, suggesting many reporting periods or jurisdictions did not submit this metric.

Treatment: Impute or filter the 43% nulls and log-transform before any modelling.

anthropic:claude-opus-4-7 · confidence high

Out[109]:

saturn.columns["Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days"].stats

stat	value
n	10,302
nulls	4,437 (43.1%)
unique	2,608
min	0
max	155,529
mean	7967
median	2,528
std	1.528e+04
q1	624
q3	7,866
iqr	7,242
skew	3.975
kurtosis	19.86
n_outliers	601
outlier_rate	0.1025
zero_rate	0.02643
alert: high_skew	skew=+3.98
alert: outliers	10.2% rows beyond 1.5 IQR
alert: null_rate	43.1% null

Fig 40.

Distribution of Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days (median: 2528.0).
bin	count
0 – 3888	3532
3888 – 7776	853
7776 – 1.166e+04	492
1.166e+04 – 1.555e+04	228
1.555e+04 – 1.944e+04	177
1.944e+04 – 2.333e+04	62
2.333e+04 – 2.722e+04	74
2.722e+04 – 3.111e+04	64
3.111e+04 – 3.499e+04	39
3.499e+04 – 3.888e+04	48
3.888e+04 – 4.277e+04	44
4.277e+04 – 4.666e+04	43
4.666e+04 – 5.055e+04	51
5.055e+04 – 5.444e+04	31
5.444e+04 – 5.832e+04	17
5.832e+04 – 6.221e+04	11
6.221e+04 – 6.61e+04	8
6.61e+04 – 6.999e+04	6
6.999e+04 – 7.388e+04	6
7.388e+04 – 7.776e+04	10
7.776e+04 – 8.165e+04	6
8.165e+04 – 8.554e+04	8
8.554e+04 – 8.943e+04	4
8.943e+04 – 9.332e+04	2
9.332e+04 – 9.721e+04	6
9.721e+04 – 1.011e+05	10
1.011e+05 – 1.05e+05	13
1.05e+05 – 1.089e+05	6
1.089e+05 – 1.128e+05	2
1.128e+05 – 1.166e+05	2
1.166e+05 – 1.205e+05	2
1.205e+05 – 1.244e+05	2
1.244e+05 – 1.283e+05	2
1.283e+05 – 1.322e+05	2
1.322e+05 – 1.361e+05	0
1.361e+05 – 1.4e+05	0
1.4e+05 – 1.439e+05	0
1.439e+05 – 1.478e+05	0
1.478e+05 – 1.516e+05	0
1.516e+05 – 1.555e+05	2

Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes categorical metadata

This is a footnotes/caveats column attached to a Medicaid & CHIP determination-processing metric, recording data-quality disclaimers per row. It is overwhelmingly empty (null_rate 0.8926), and among the 1,106 populated rows the 16 distinct notes are dominated by 'Incorrectly reporting processing time at application level, as opposed to the individual level' at 39.6%, with several entries being semicolon-concatenated combinations of base notes. The notes describe known reporting errors (redeterminations included, missing MAGI determinations, system limitations), so any downstream use of the associated metric should treat flagged rows as suspect.

Treatment: Keep as a data-quality flag; split on ';' into boolean caveat indicators rather than modelling as a single category.

anthropic:claude-opus-4-7 · confidence high

Out[112]:

saturn.columns["Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes"].stats

stat	value
n	10,302
nulls	9,196 (89.3%)
unique	16
top_value	Incorrectly reporting processing time at application level, as opposed to the individual level
top_rate	0.396
cardinality	16
entropy	2.818
entropy_ratio	0.7045
alert: null_rate	89.3% null

Fig 41.

Top values for Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes.

Show data table

Top values for Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes (16 unique shown, of 16 total).
value	count	share
Incorrectly reporting processing time at application level, as opposed to the individual level	438	4.3%
Incorrectly includes redeterminations	183	1.8%
Does not include all MAGI determinations on applications	143	1.4%
Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	76	0.7%
Incorrectly reporting processing time at application level, as opposed to the individual level; MAGI determinations conducted in 6-7 days are reported under the 8-30 days category	72	0.7%
Incorrectly includes redeterminations; Does not include all MAGI determinations on applications	57	0.6%
Unable to provide data due to system limitations	39	0.4%
Includes some non-MAGI determinations on applications	24	0.2%
Includes some non-MAGI determinations on applications; Incorrectly includes redeterminations	18	0.2%
Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	18	0.2%
Reflects incorrect start dates for processing time on some reopened applications	10	0.1%
Includes some non-Medicaid or CHIP determinations on applications; Reflects incorrect start dates for processing time on some reopened applications	8	0.1%
Includes some non-MAGI determinations on applications; Does not include all MAGI determinations on applications	6	0.1%
Includes some non-MAGI determinations on applications; Incorrectly reporting processing time at application level, as opposed to the individual level	6	0.1%
Incorrectly includes reinstatements	6	0.1%
Includes some non-Medicaid or CHIP determinations on applications	2	0.0%

Total Medicaid and CHIP Determinations Processed between 31 days and 45 days numeric feature

This is a numeric operational metric counting Medicaid and CHIP determinations processed in a 31-45 day window, almost certainly reported per state and reporting period. The distribution is severely right-skewed (skew 4.90, kurtosis 31.95) with a median of 693 but a mean of 2917 and a max of 81475, and 12.75% of rows flagged as outliers. Notably, 43.07% of values are null and 6.63% are zero, so under half of rows carry a usable signal.

Treatment: Log-transform after imputing or flagging the 43% nulls before any modelling.

anthropic:claude-opus-4-7 · confidence high

Out[115]:

saturn.columns["Total Medicaid and CHIP Determinations Processed between 31 days and 45 days"].stats

stat	value
n	10,302
nulls	4,437 (43.1%)
unique	1,923
min	0
max	81,475
mean	2917
median	693
std	6725
q1	106
q3	2,322
iqr	2,216
skew	4.899
kurtosis	31.95
n_outliers	748
outlier_rate	0.1275
zero_rate	0.06633
alert: high_skew	skew=+4.90
alert: outliers	12.8% rows beyond 1.5 IQR
alert: null_rate	43.1% null

Fig 42.

Distribution of Total Medicaid and CHIP Determinations Processed between 31 days and 45 days. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Determinations Processed between 31 days and 45 days (median: 693.0).
bin	count
0 – 2037	4225
2037 – 4074	690
4074 – 6111	267
6111 – 8148	154
8148 – 1.018e+04	87
1.018e+04 – 1.222e+04	68
1.222e+04 – 1.426e+04	54
1.426e+04 – 1.63e+04	45
1.63e+04 – 1.833e+04	55
1.833e+04 – 2.037e+04	35
2.037e+04 – 2.241e+04	26
2.241e+04 – 2.444e+04	26
2.444e+04 – 2.648e+04	42
2.648e+04 – 2.852e+04	14
2.852e+04 – 3.055e+04	13
3.055e+04 – 3.259e+04	12
3.259e+04 – 3.463e+04	4
3.463e+04 – 3.666e+04	0
3.666e+04 – 3.87e+04	0
3.87e+04 – 4.074e+04	8
4.074e+04 – 4.277e+04	0
4.277e+04 – 4.481e+04	4
4.481e+04 – 4.685e+04	6
4.685e+04 – 4.888e+04	2
4.888e+04 – 5.092e+04	4
5.092e+04 – 5.296e+04	2
5.296e+04 – 5.5e+04	6
5.5e+04 – 5.703e+04	2
5.703e+04 – 5.907e+04	6
5.907e+04 – 6.111e+04	2
6.111e+04 – 6.314e+04	0
6.314e+04 – 6.518e+04	0
6.518e+04 – 6.722e+04	2
6.722e+04 – 6.925e+04	0
6.925e+04 – 7.129e+04	0
7.129e+04 – 7.333e+04	2
7.333e+04 – 7.536e+04	0
7.536e+04 – 7.74e+04	0
7.74e+04 – 7.944e+04	0
7.944e+04 – 8.148e+04	2

Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes categorical metadata

Footnote/caveat field annotating data quality issues for the 31-45 day Medicaid/CHIP determination processing metric. 89.26% of rows are null, and among the 15 distinct notes one dominates: 46.11% of non-null entries flag 'Incorrectly reporting processing time at application level, as opposed to the individual level', with semicolon-delimited combinations indicating multiple concurrent caveats per row.

Treatment: Keep as a data-quality flag; split on ';' into multi-hot indicators when auditing the paired metric.

anthropic:claude-opus-4-7 · confidence high

Out[118]:

saturn.columns["Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes"].stats

stat	value
n	10,302
nulls	9,196 (89.3%)
unique	15
top_value	Incorrectly reporting processing time at application level, as opposed to the individual level
top_rate	0.4611
cardinality	15
entropy	2.547
entropy_ratio	0.652
alert: null_rate	89.3% null

Fig 43.

Top values for Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes.

Show data table

Top values for Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes (15 unique shown, of 15 total).
value	count	share
Incorrectly reporting processing time at application level, as opposed to the individual level	510	5.0%
Incorrectly includes redeterminations	183	1.8%
Does not include all MAGI determinations on applications	143	1.4%
Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	76	0.7%
Incorrectly includes redeterminations; Does not include all MAGI determinations on applications	57	0.6%
Unable to provide data due to system limitations	39	0.4%
Includes some non-MAGI determinations on applications	24	0.2%
Includes some non-MAGI determinations on applications; Incorrectly includes redeterminations	18	0.2%
Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	18	0.2%
Reflects incorrect start dates for processing time on some reopened applications	10	0.1%
Includes some non-Medicaid or CHIP determinations on applications; Reflects incorrect start dates for processing time on some reopened applications	8	0.1%
Includes some non-MAGI determinations on applications; Does not include all MAGI determinations on applications	6	0.1%
Includes some non-MAGI determinations on applications; Incorrectly reporting processing time at application level, as opposed to the individual level	6	0.1%
Incorrectly includes reinstatements	6	0.1%
Includes some non-Medicaid or CHIP determinations on applications	2	0.0%

Total Medicaid and CHIP Determinations Processed in More than 45 Days numeric feature

This is a state/period-level operational metric counting Medicaid and CHIP eligibility determinations that exceeded the 45-day processing target. The distribution is severely right-skewed (skew 5.26, kurtosis 37.4) with a median of 395 but a max of 106,943 and std of 8,135, and roughly 15.4% of values flagged as outliers. Notably, 43.1% of rows are null and another 10% are exact zeros, so most of the variance comes from a small tail of jurisdictions or reporting periods with large backlogs.

Treatment: Log1p-transform and add a missing-value indicator before modelling.

anthropic:claude-opus-4-7 · confidence high

Out[121]:

saturn.columns["Total Medicaid and CHIP Determinations Processed in More than 45 Days"].stats

stat	value
n	10,302
nulls	4,437 (43.1%)
unique	1,691
min	0
max	106,943
mean	3028
median	395
std	8135
q1	90
q3	1,545
iqr	1,455
skew	5.264
kurtosis	37.42
n_outliers	902
outlier_rate	0.1538
zero_rate	0.1001
alert: high_skew	skew=+5.26
alert: outliers	15.4% rows beyond 1.5 IQR
alert: null_rate	43.1% null

Fig 44.

Distribution of Total Medicaid and CHIP Determinations Processed in More than 45 Days. Vertical dash marks the median.

Show data table

Histogram bins for Total Medicaid and CHIP Determinations Processed in More than 45 Days (median: 395.0).
bin	count
0 – 2674	4746
2674 – 5347	361
5347 – 8021	146
8021 – 1.069e+04	138
1.069e+04 – 1.337e+04	80
1.337e+04 – 1.604e+04	77
1.604e+04 – 1.872e+04	54
1.872e+04 – 2.139e+04	45
2.139e+04 – 2.406e+04	34
2.406e+04 – 2.674e+04	31
2.674e+04 – 2.941e+04	29
2.941e+04 – 3.208e+04	18
3.208e+04 – 3.476e+04	20
3.476e+04 – 3.743e+04	18
3.743e+04 – 4.01e+04	8
4.01e+04 – 4.278e+04	4
4.278e+04 – 4.545e+04	8
4.545e+04 – 4.812e+04	6
4.812e+04 – 5.08e+04	8
5.08e+04 – 5.347e+04	10
5.347e+04 – 5.615e+04	0
5.615e+04 – 5.882e+04	2
5.882e+04 – 6.149e+04	4
6.149e+04 – 6.417e+04	0
6.417e+04 – 6.684e+04	2
6.684e+04 – 6.951e+04	2
6.951e+04 – 7.219e+04	4
7.219e+04 – 7.486e+04	0
7.486e+04 – 7.753e+04	0
7.753e+04 – 8.021e+04	2
8.021e+04 – 8.288e+04	0
8.288e+04 – 8.555e+04	2
8.555e+04 – 8.823e+04	4
8.823e+04 – 9.09e+04	0
9.09e+04 – 9.358e+04	0
9.358e+04 – 9.625e+04	0
9.625e+04 – 9.892e+04	0
9.892e+04 – 1.016e+05	0
1.016e+05 – 1.043e+05	0
1.043e+05 – 1.069e+05	2

Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes categorical metadata

Footnote/caveat field annotating data-quality issues on the '45+ day determinations' metric. 89.26% null suggests footnotes are only attached when a state reports a known issue; among the 1,104 populated rows, 46.11% flag the same problem ('Incorrectly reporting processing time at application level, as opposed to the individual level'), and several values are semicolon-concatenated combinations rather than atomic codes.

Treatment: Split on '; ' into a multi-label flag set and use as data-quality filters, not as a model feature.

anthropic:claude-opus-4-7 · confidence high

Out[124]:

saturn.columns["Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes"].stats

stat	value
n	10,302
nulls	9,196 (89.3%)
unique	15
top_value	Incorrectly reporting processing time at application level, as opposed to the individual level
top_rate	0.4611
cardinality	15
entropy	2.547
entropy_ratio	0.652
alert: null_rate	89.3% null

Fig 45.

Top values for Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes.

Show data table

Top values for Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes (15 unique shown, of 15 total).
value	count	share
Incorrectly reporting processing time at application level, as opposed to the individual level	510	5.0%
Incorrectly includes redeterminations	183	1.8%
Does not include all MAGI determinations on applications	143	1.4%
Incorrectly reporting processing time at application level, as opposed to the individual level; Incorrectly includes redeterminations	76	0.7%
Incorrectly includes redeterminations; Does not include all MAGI determinations on applications	57	0.6%
Unable to provide data due to system limitations	39	0.4%
Includes some non-MAGI determinations on applications	24	0.2%
Includes some non-MAGI determinations on applications; Incorrectly includes redeterminations	18	0.2%
Incorrectly reporting processing time at application level, as opposed to the individual level; Does not include all MAGI determinations on applications	18	0.2%
Reflects incorrect start dates for processing time on some reopened applications	10	0.1%
Includes some non-Medicaid or CHIP determinations on applications; Reflects incorrect start dates for processing time on some reopened applications	8	0.1%
Includes some non-MAGI determinations on applications; Does not include all MAGI determinations on applications	6	0.1%
Includes some non-MAGI determinations on applications; Incorrectly reporting processing time at application level, as opposed to the individual level	6	0.1%
Incorrectly includes reinstatements	6	0.1%
Includes some non-Medicaid or CHIP determinations on applications	2	0.0%

Total Call Center Volume (Number of Calls) numeric feature

Numeric volume of calls handled by a call center, almost certainly an aggregate per row (e.g., monthly or per-center totals). Nearly 70% of rows are null (null_rate 0.6949), so this column is sparsely populated. The distribution is heavily right-skewed (skew 4.66, kurtosis 25.1) with a median of 73,754 but a max of 2,615,575 and 223 outliers (7.1%), indicating a small number of very high-volume reporters dominate the tail.

Treatment: Log-transform and impute or flag the 69% missing before modelling.

anthropic:claude-opus-4-7 · confidence high

Out[127]:

saturn.columns["Total Call Center Volume (Number of Calls)"].stats

stat	value
n	10,302
nulls	7,159 (69.5%)
unique	1,592
min	5,750
max	2.616e+06
mean	1.723e+05
median	73,754
std	3.191e+05
q1	31,323
q3	180,553
iqr	149,230
skew	4.656
kurtosis	25.11
n_outliers	223
outlier_rate	0.07095
zero_rate	0
alert: high_skew	skew=+4.66
alert: outliers	7.1% rows beyond 1.5 IQR
alert: null_rate	69.5% null

Fig 46.

Distribution of Total Call Center Volume (Number of Calls). Vertical dash marks the median.

Show data table

Histogram bins for Total Call Center Volume (Number of Calls) (median: 73754.0).
bin	count
5750 – 7.1e+04	1556
7.1e+04 – 1.362e+05	576
1.362e+05 – 2.015e+05	313
2.015e+05 – 2.667e+05	235
2.667e+05 – 3.32e+05	167
3.32e+05 – 3.972e+05	69
3.972e+05 – 4.625e+05	26
4.625e+05 – 5.277e+05	6
5.277e+05 – 5.93e+05	10
5.93e+05 – 6.582e+05	23
6.582e+05 – 7.235e+05	24
7.235e+05 – 7.887e+05	25
7.887e+05 – 8.539e+05	6
8.539e+05 – 9.192e+05	10
9.192e+05 – 9.844e+05	8
9.844e+05 – 1.05e+06	6
1.05e+06 – 1.115e+06	4
1.115e+06 – 1.18e+06	10
1.18e+06 – 1.245e+06	6
1.245e+06 – 1.311e+06	4
1.311e+06 – 1.376e+06	0
1.376e+06 – 1.441e+06	0
1.441e+06 – 1.506e+06	2
1.506e+06 – 1.572e+06	2
1.572e+06 – 1.637e+06	0
1.637e+06 – 1.702e+06	4
1.702e+06 – 1.767e+06	0
1.767e+06 – 1.833e+06	6
1.833e+06 – 1.898e+06	3
1.898e+06 – 1.963e+06	8
1.963e+06 – 2.028e+06	6
2.028e+06 – 2.094e+06	4
2.094e+06 – 2.159e+06	2
2.159e+06 – 2.224e+06	2
2.224e+06 – 2.289e+06	6
2.289e+06 – 2.355e+06	2
2.355e+06 – 2.42e+06	2
2.42e+06 – 2.485e+06	2
2.485e+06 – 2.55e+06	4
2.55e+06 – 2.616e+06	4

Total Call Center Volume (Number of Calls) - footnotes categorical metadata

This column holds free-text footnotes qualifying the 'Total Call Center Volume' metric, explaining caveats like excluded after-hours calls or inclusion of other benefit programs. 71% of rows are null, and only 27 distinct footnote strings cover the remaining 2,993 records, with the top note appearing 601 times (20% of non-nulls). The values are semicolon-concatenated combinations of a small set of standard caveats, so this is metadata about measurement methodology rather than a feature.

Treatment: Keep as methodological annotation; if used in modelling, parse into binary flags for each underlying caveat rather than treating as a categorical.

anthropic:claude-opus-4-7 · confidence high

Out[130]:

saturn.columns["Total Call Center Volume (Number of Calls) - footnotes"].stats

stat	value
n	10,302
nulls	7,310 (71.0%)
unique	27
top_value	Does not include all calls received after business hours; Includes calls for other benefit programs
top_rate	0.2009
cardinality	27
entropy	3.742
entropy_ratio	0.787
alert: null_rate	71.0% null

Fig 47.

Top values for Total Call Center Volume (Number of Calls) - footnotes.

Show data table

Top values for Total Call Center Volume (Number of Calls) - footnotes (20 unique shown, of 27 total).
value	count	share
Does not include all calls received after business hours; Includes calls for other benefit programs	601	5.8%
Includes calls for other benefit programs	435	4.2%
Does not include all calls received after business hours	418	4.1%
Does not include all calls received by call centers; Does not include all calls received after business hours	303	2.9%
Includes calls for other benefit programs; Includes only calls transferred to a live agent	187	1.8%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent	132	1.3%
Does not include all calls received by call centers	110	1.1%
Does not include all calls received by call centers; Includes calls for other benefit programs	83	0.8%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes calls for other benefit programs	74	0.7%
Does not include all calls received after business hours; Includes only calls transferred to a live agent	63	0.6%
Includes state-based marketplace (SBM) data	63	0.6%
Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	63	0.6%
Does not include all calls received by call centers; Includes calls for other benefit programs; Includes state-based marketplace (SBM) data	63	0.6%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes calls for other benefit programs; Includes state-based marketplace (SBM) data	63	0.6%
Does not include all calls received by call centers; Includes only calls transferred to a live agent	63	0.6%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes state-based marketplace (SBM) data	63	0.6%
Does not operate a call center	63	0.6%
Does not include all calls received after business hours; Includes calls for other benefit programs; Includes state-based marketplace (SBM) data	63	0.6%
Does not include all calls received after business hours; Includes state-based marketplace (SBM) data	60	0.6%
Did not report data because of technical reasons	5	0.0%

Average Call Center Wait Time (Minutes) numeric feature

Average call-centre wait time in minutes, recorded for only about 30% of rows (null_rate 0.6947). Distribution is right-skewed (skew 1.78, kurtosis 3.29) with median 5 minutes versus mean 9.95 and a max of 72; 11.6% of observed values are exactly zero and 145 outliers (4.6%) sit above the q3+IQR fence. Heavy missingness suggests the metric is only captured for cases that involved a call.

Treatment: Impute or add a missingness indicator and log-transform before modelling.

anthropic:claude-opus-4-7 · confidence high

Out[133]:

saturn.columns["Average Call Center Wait Time (Minutes)"].stats

stat	value
n	10,302
nulls	7,157 (69.5%)
unique	63
min	0
max	72
mean	9.945
median	5
std	12.2
q1	1
q3	15
iqr	14
skew	1.78
kurtosis	3.29
n_outliers	145
outlier_rate	0.0461
zero_rate	0.1161
alert: null_rate	69.5% null

Fig 48.

Distribution of Average Call Center Wait Time (Minutes). Vertical dash marks the median.

Show data table

Histogram bins for Average Call Center Wait Time (Minutes) (median: 5.0).
bin	count
0 – 1.8	942
1.8 – 3.6	417
3.6 – 5.4	329
5.4 – 7.2	188
7.2 – 9	80
9 – 10.8	116
10.8 – 12.6	168
12.6 – 14.4	103
14.4 – 16.2	106
16.2 – 18	43
18 – 19.8	86
19.8 – 21.6	75
21.6 – 23.4	73
23.4 – 25.2	50
25.2 – 27	20
27 – 28.8	44
28.8 – 30.6	48
30.6 – 32.4	47
32.4 – 34.2	38
34.2 – 36	15
36 – 37.8	28
37.8 – 39.6	28
39.6 – 41.4	6
41.4 – 43.2	15
43.2 – 45	12
45 – 46.8	14
46.8 – 48.6	10
48.6 – 50.4	2
50.4 – 52.2	4
52.2 – 54	2
54 – 55.8	0
55.8 – 57.6	10
57.6 – 59.4	12
59.4 – 61.2	3
61.2 – 63	2
63 – 64.8	2
64.8 – 66.6	4
66.6 – 68.4	0
68.4 – 70.2	0
70.2 – 72	3

Average Call Center Wait Time (Minutes) - footnotes categorical metadata

Free-form footnote annotations qualifying the 'Average Call Center Wait Time' metric, describing measurement caveats like callback handling, after-hours exclusions, and inclusion of other benefit programs. 69.73% of rows are null and the remaining values spread across 44 semicolon-concatenated combinations with very high entropy ratio (0.918), so even the most common footnote covers only 7.89% of non-nulls. The values are clearly composed from a small set of reusable phrases joined with semicolons rather than free prose.

Treatment: Split on '; ' and one-hot encode the underlying caveat phrases rather than treating each combination as a distinct category.

anthropic:claude-opus-4-7 · confidence high

Out[136]:

saturn.columns["Average Call Center Wait Time (Minutes) - footnotes"].stats

stat	value
n	10,302
nulls	7,184 (69.7%)
unique	44
top_value	Call centers offer callbacks; Includes calls for other benefit programs; Includes only calls transferred to a live agent
top_rate	0.0789
cardinality	44
entropy	5.013
entropy_ratio	0.9183
alert: null_rate	69.7% null

Fig 49.

Top values for Average Call Center Wait Time (Minutes) - footnotes.

Show data table

Top values for Average Call Center Wait Time (Minutes) - footnotes (20 unique shown, of 44 total).
value	count	share
Call centers offer callbacks; Includes calls for other benefit programs; Includes only calls transferred to a live agent	246	2.4%
Does not include all calls received after business hours; Includes only calls transferred to a live agent	184	1.8%
Includes calls for other benefit programs; Includes only calls transferred to a live agent	171	1.7%
Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	140	1.4%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent	132	1.3%
Call centers offer callbacks; Does not include all calls received after business hours	128	1.2%
Does not include all calls received after business hours; Includes calls for other benefit programs	126	1.2%
Call centers offer callbacks; Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	126	1.2%
Callbacks are included; Call centers offer callbacks; Does not include all calls received after business hours; Includes only calls transferred to a live agent	126	1.2%
Callbacks are included; Call centers offer callbacks; Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent	109	1.1%
Callbacks are included; Call centers offer callbacks; Does not include all calls received after business hours; Includes calls for other benefit programs	99	1.0%
Call centers offer callbacks; Does not include all calls received after business hours; Includes only calls transferred to a live agent	98	1.0%
Callbacks are included; Call centers offer callbacks; Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	98	1.0%
Call centers offer callbacks; Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent	87	0.8%
Callbacks are included; Call centers offer callbacks; Does not include all calls received by call centers; Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	70	0.7%
Call centers offer callbacks; Does not include all calls received by call centers	69	0.7%
Call centers offer callbacks; Does not include all calls received after business hours; Includes only calls transferred to a live agent; Includes state-based marketplace (SBM) data	63	0.6%
Callbacks are included; Call centers offer callbacks; Includes calls for other benefit programs; Includes only calls transferred to a live agent	63	0.6%
Callbacks are included; Call centers offer callbacks; Includes calls for other benefit programs	63	0.6%
Callbacks are included; Call centers offer callbacks; Does not include all calls received by call centers; Includes calls for other benefit programs; Includes only calls transferred to a live agent; Includes state-based marketplace (SBM) data	63	0.6%

Average Call Center Abandonment Rate numeric feature

Numeric metric capturing the share of inbound calls abandoned at a contact center, expressed as a proportion between 0 and 0.652. Distribution is right-skewed (skew 1.22) with median 0.088 well below mean 0.132, and 54 outliers (1.7%) sit in the upper tail. The dominant concern is coverage: 69.49% of rows are null, so the column is populated for less than a third of records.

Treatment: Impute or add a missingness indicator before modelling, and consider a log or sqrt transform to tame the right skew.

anthropic:claude-opus-4-7 · confidence high

Out[139]:

saturn.columns["Average Call Center Abandonment Rate"].stats

stat	value
n	10,302
nulls	7,159 (69.5%)
unique	408
min	0
max	0.652
mean	0.1321
median	0.088
std	0.1291
q1	0.024
q3	0.212
iqr	0.188
skew	1.222
kurtosis	1.146
n_outliers	54
outlier_rate	0.01718
zero_rate	0.0009545
alert: null_rate	69.5% null

Fig 50.

Distribution of Average Call Center Abandonment Rate. Vertical dash marks the median.

Show data table

Histogram bins for Average Call Center Abandonment Rate (median: 0.088).
bin	count
0 – 0.0163	594
0.0163 – 0.0326	328
0.0326 – 0.0489	200
0.0489 – 0.0652	193
0.0652 – 0.0815	202
0.0815 – 0.0978	129
0.0978 – 0.1141	123
0.1141 – 0.1304	120
0.1304 – 0.1467	92
0.1467 – 0.163	106
0.163 – 0.1793	87
0.1793 – 0.1956	104
0.1956 – 0.2119	79
0.2119 – 0.2282	122
0.2282 – 0.2445	108
0.2445 – 0.2608	68
0.2608 – 0.2771	65
0.2771 – 0.2934	40
0.2934 – 0.3097	39
0.3097 – 0.326	45
0.326 – 0.3423	43
0.3423 – 0.3586	26
0.3586 – 0.3749	50
0.3749 – 0.3912	24
0.3912 – 0.4075	14
0.4075 – 0.4238	28
0.4238 – 0.4401	18
0.4401 – 0.4564	20
0.4564 – 0.4727	16
0.4727 – 0.489	2
0.489 – 0.5053	10
0.5053 – 0.5216	10
0.5216 – 0.5379	8
0.5379 – 0.5542	4
0.5542 – 0.5705	8
0.5705 – 0.5868	0
0.5868 – 0.6031	4
0.6031 – 0.6194	2
0.6194 – 0.6357	6
0.6357 – 0.652	6

Average Call Center Abandonment Rate - footnotes categorical metadata

This is a free-text footnote field qualifying the 'Average Call Center Abandonment Rate' metric, with 36 distinct semicolon-joined caveat combinations describing measurement scope (e.g., excluded after-hours calls, inclusion of other benefit programs, live-agent-only counts). It is missing for 69.73% of rows, and even the most common note covers only 12.54% of present values, with entropy ratio 0.833 indicating the remaining caveats are spread fairly evenly. The recurring phrases suggest these are reusable methodology disclaimers attached per reporter rather than free prose.

Treatment: Keep as documentation; if needed for modelling, split on ';' and one-hot the individual caveat flags.

anthropic:claude-opus-4-7 · confidence high

Out[142]:

saturn.columns["Average Call Center Abandonment Rate - footnotes"].stats

stat	value
n	10,302
nulls	7,184 (69.7%)
unique	36
top_value	Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent
top_rate	0.1254
cardinality	36
entropy	4.307
entropy_ratio	0.8332
alert: null_rate	69.7% null

Fig 51.

Top values for Average Call Center Abandonment Rate - footnotes.

Show data table

Top values for Average Call Center Abandonment Rate - footnotes (20 unique shown, of 36 total).
value	count	share
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent	391	3.8%
Includes calls for other benefit programs; Includes only calls transferred to a live agent	354	3.4%
Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	308	3.0%
Does not include all calls received after business hours; Includes only calls transferred to a live agent	210	2.0%
Includes calls for other benefit programs	205	2.0%
Does not include all calls received after business hours	200	1.9%
Does not include all calls received after business hours; Includes calls for other benefit programs	170	1.7%
Does not include all calls received by call centers; Includes only calls transferred to a live agent	124	1.2%
Does not include all calls received after business hours; Includes only calls transferred to a live agent; Includes state-based marketplace (SBM) data	123	1.2%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent	113	1.1%
Does not include all calls received by call centers; Includes calls for other benefit programs; Includes only calls transferred to a live agent	83	0.8%
Callbacks are included; Does not include all calls received after business hours; Includes calls for other benefit programs	78	0.8%
Callbacks are included; Includes calls for other benefit programs; Includes only calls transferred to a live agent	63	0.6%
Does not include all calls received by call centers; Includes calls for other benefit programs; Includes only calls transferred to a live agent; Includes state-based marketplace (SBM) data	63	0.6%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes calls for other benefit programs; Includes state-based marketplace (SBM) data	63	0.6%
Does not include all calls received by call centers; Does not include all calls received after business hours; Includes only calls transferred to a live agent; Includes state-based marketplace (SBM) data	63	0.6%
Callbacks are included; Does not include all calls received after business hours; Includes only calls transferred to a live agent	63	0.6%
Does not operate a call center	63	0.6%
Callbacks are included; Does not include all calls received after business hours	63	0.6%
Does not include all calls received after business hours; Includes calls for other benefit programs; Includes only calls transferred to a live agent; Includes state-based marketplace (SBM) data	63	0.6%

Overview

Summary confidence: high

State Abbreviation categorical feature

State Name categorical feature

Reporting Period numeric timestamp

State Expanded Medicaid categorical feature

Preliminary or Updated categorical feature

Final Report categorical label

New Applications Submitted to Medicaid and CHIP Agencies numeric feature

New Applications Submitted to Medicaid and CHIP Agencies - footnotes categorical metadata

Applications for Financial Assistance Submitted to the State Based Marketplace numeric feature

Applications for Financial Assistance Submitted to the State Based Marketplace - footnotes categorical metadata

Total Applications for Financial Assistance Submitted at State Level numeric feature

Total Applications for Financial Assistance Submitted at State Level - footnotes categorical metadata

Individuals Determined Eligible for Medicaid at Application numeric feature

Individuals Determined Eligible for Medicaid at Application - footnotes categorical metadata

Individuals Determined Eligible for CHIP at Application numeric feature

Individuals Determined Eligible for CHIP at Application - footnotes categorical metadata

Total Medicaid and CHIP Determinations numeric feature

Total Medicaid and CHIP Determinations - footnotes categorical metadata

Medicaid and CHIP Child Enrollment numeric feature

Medicaid and CHIP Child Enrollment - footnotes categorical metadata

Total Medicaid and CHIP Enrollment numeric feature

Total Medicaid and CHIP Enrollment - footnotes categorical metadata

Total Medicaid Enrollment numeric feature

Total Medicaid Enrollment - footnotes categorical metadata

Total CHIP Enrollment numeric feature

Total CHIP Enrollment - footnotes categorical metadata

Total Adult Medicaid Enrollment numeric feature

Total Adult Medicaid Enrollment - footnotes categorical metadata

Total Medicaid and CHIP Determinations Processed in Less than 24 Hours numeric feature

Total Medicaid and CHIP Determinations Processed in Less than 24 Hours - footnotes categorical metadata

Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days numeric feature

Total Medicaid and CHIP Determinations Processed Between 24 Hours and 7 Days - footnotes categorical metadata

Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days numeric feature

Total Medicaid and CHIP Determinations Processed Between 8 Days and 30 Days - footnotes categorical metadata

Total Medicaid and CHIP Determinations Processed between 31 days and 45 days numeric feature

Total Medicaid and CHIP Determinations Processed between 31 days and 45 days - footnotes categorical metadata

Total Medicaid and CHIP Determinations Processed in More than 45 Days numeric feature

Total Medicaid and CHIP Determinations Processed in More than 45 Days - footnotes categorical metadata

Total Call Center Volume (Number of Calls) numeric feature

Total Call Center Volume (Number of Calls) - footnotes categorical metadata

Average Call Center Wait Time (Minutes) numeric feature

Average Call Center Wait Time (Minutes) - footnotes categorical metadata

Average Call Center Abandonment Rate numeric feature

Average Call Center Abandonment Rate - footnotes categorical metadata

How to cite