Ad-hoc Explorer
RFI Scenario 5 · Self-service exploration across every dataset in the HSMN model · no IT ticket required
Ask Flex AI
Natural-language queries across every HSMN dataset · AI generates visuals & tables you can pin.
No PHI/PII sent · Metadata only · Not used for training
Outcomes
Operations
Data quality
“Show me late-entry participants by coalition for FY26, with preterm rate.”
Late-entry intakes (enrollment ≥ 28 wk gestation) are concentrated in three coalitions:
Miami-Dade, Glades, and Monroe — together driving 61% of statewide late entries
while representing only 22% of active participants. Preterm rate in these three is 13.8%
vs 9.2% in the rest of the state. The strongest single driver is Miami-Dade, where late
entries have trended up +2.1 points month-over-month for the past quarter.
Late-entry participants by coalition · April 2026
Detailed breakdown by coalition & month
Showing 1–12 of 247 rows
Key finding · 3 coalitions drive 61% of late entries
Try a follow-up:
My pinboard 4 pinned
Build dashboard from pins →Preterm birth rate · statewide
Last 12 months · pinned 3 days ago
9.8%
EPDS positivity by coalition
Postpartum screens · pinned 1 wk ago
14.5%
Referral ack within 72h
Statewide SLA · pinned 2 wk ago
84%
Infant follow-up 6-mo compliance
Statewide · pinned today
48%
Manual query builder Power users · filters, dimensions, measures, raw SQL
Filters
Period: FY26 YTD
Gestational age at entry: ≥ 28 weeks
Participant status: Active OR Delivered
Risk tier: High OR Medium
Add filter
Group by (dimensions)
Coalition
Month of intake
Add dimension
Measures
Count participants
% of all intakes
Count — delivered
Preterm %
Add measure
Visualization
Table
Bar
Line
Pie
Heatmap
Map
SELECT coalition_name, DATE_TRUNC('month', intake_date) AS month,
COUNT(*) AS participants,
COUNT(*) * 100.0 / SUM(COUNT(*)) OVER (PARTITION BY coalition_name) AS pct_of_intakes,
COUNT(CASE WHEN delivered_at IS NOT NULL THEN 1 END) AS delivered,
AVG(CASE WHEN gestational_age_at_birth < 37 THEN 1.0 ELSE 0 END) AS preterm_rate
FROM participants
WHERE program_year = 'FY2026'
AND gestational_age_at_intake >= 28
AND status IN ('active', 'delivered')
AND risk_tier IN ('high', 'medium')
GROUP BY coalition_name, month
ORDER BY coalition_name, month;
COUNT(*) AS participants,
COUNT(*) * 100.0 / SUM(COUNT(*)) OVER (PARTITION BY coalition_name) AS pct_of_intakes,
COUNT(CASE WHEN delivered_at IS NOT NULL THEN 1 END) AS delivered,
AVG(CASE WHEN gestational_age_at_birth < 37 THEN 1.0 ELSE 0 END) AS preterm_rate
FROM participants
WHERE program_year = 'FY2026'
AND gestational_age_at_intake >= 28
AND status IN ('active', 'delivered')
AND risk_tier IN ('high', 'medium')
GROUP BY coalition_name, month
ORDER BY coalition_name, month;