Making Public Health
Data Accessible
Ask questions in plain English about Medicaid claims, Medicare physician spending, and population health surveys. AI translates your words into SQL and returns real answers from federal datasets.
Type a question in plain English — no need to pick a dataset. AI automatically identifies which of the seven datasets to query, including cross-dataset questions that span multiple sources.
Claude identifies the right dataset, builds an analysis plan, and generates precise DuckDB SQL — including cross-dataset JOINs when your question spans multiple sources.
View tables, charts, and AI-generated insights from your query. Cross-dataset results are synthesized into a single narrative. Export to CSV or refine with follow-ups.
Medicaid Provider Spending
Analyze provider spending patterns across Medicaid fee-for-service claims. Explore by procedure code, provider, state, and time period.
Try asking
- “Which states spend the most on telehealth per capita?”
- “Top 10 highest-paid Medicaid providers nationwide”
- “How did COVID change procedure spending patterns?”
Medicare Outpatient Spend
Analyze Medicare Part B fee-for-service physician spending by provider, specialty, procedure, state, and place of service across 11 years.
Try asking
- “Which specialties have the biggest gap between charges and payments?”
- “How has opioid prescribing changed since 2015?”
- “Compare average cost per beneficiary by state and specialty”
Medicare Inpatient Spend
Analyze Medicare Part A inpatient hospital spending by hospital, DRG, state, and year. Compare hospital charges, Medicare payments, and beneficiary costs across 3,000+ IPPS hospitals.
Try asking
- “Which hospitals charge the most for hip replacement (DRG 470)?”
- “Top 10 most expensive DRGs by total Medicare spending”
- “How did COVID-19 change inpatient hospital spending in 2020?”
Medicare Prescription Drug Spend
Analyze Medicare Part D prescription drug spending by prescriber, drug, specialty, state, and year. Compare brand vs generic costs, track opioid trends, and identify top-prescribed medications.
Try asking
- “What are the top 10 most prescribed drugs in Medicare?”
- “How has opioid prescribing changed since 2013?”
- “Which specialties prescribe the most expensive drugs?”
Medicare Clinician Directory
Look up any Medicare-enrolled clinician by NPI, specialty, location, or group practice. Analyze workforce distribution, telehealth adoption, and specialty demographics.
Try asking
- “How many cardiologists are in each state?”
- “What is the gender breakdown across surgical specialties?”
- “Which medical schools produce the most active clinicians?”
BRFSS Health Survey
Explore population health trends, risk factors, chronic conditions, SDOH, ACEs, and demographics across all 50 states and DC over 9 survey years.
Try asking
- “Which states saw the biggest rise in obesity since 2014?”
- “How does childhood adversity (ACEs) correlate with depression?”
- “Diabetes rates by income level and race across all states”
NHANES Clinical Survey
Explore clinical lab results, blood pressure, BMI, depression scores, and health questionnaires from a nationally representative in-person survey.
Try asking
- “What % of undiagnosed diabetics have normal A1C but elevated glucose?”
- “Average blood lead levels by age group and poverty status”
- “How does sleep duration relate to BMI, blood pressure, and depression?”