Medicaid data: what we have and what we don't
Plain answers about the Medicaid records behind RepVector's papers and reports. For links to every original file, see paper data sources.
Medicaid buyer FAQ: pricing and Word deliveryWhich Medicaid files does RepVector have?
HHS Medicaid Provider Spending (from T-MSIS): official yearly totals for 2022–2024 by provider NPI, billing code and month — claim counts, beneficiary counts and amounts paid. We store the code groups our papers use: psychiatric and psychotherapy services, substance use treatment levels (detox, residential, PHP/day, IOP, OTP/MAT, drug testing) and ABA autism therapy.
CMS Medicaid Financial Management (CMS-64) reports: state-level yearly spending by service category. We use the official Total Net Expenditures line only.
NPPES provider registry: used to place each NPI in a state and specialty. It is today's registry, applied back to earlier years.
Which Medicaid data is withheld or missing?
Small counts: HHS hides provider/code/month cells with very few claims to protect patient privacy. Those rows are not in the file, so totals are floors, not complete counts. We never fill them in or treat them as zero.
Patient-level and visit-level records: the full T-MSIS research files (TAF) are only available to approved researchers under a signed data-use agreement. RepVector does not have them.
Managed care detail: payment amounts for services paid through Medicaid managed care plans may be missing or incomplete for some states.
Most recent year: 2024 coverage is preliminary and may change when HHS updates the file.
Withheld facility rows: some RepVector reports show only totals and a short preview until the paper is purchased. That is a paywall, not missing data.
Why can't you show autism, depression or anxiety visit counts?
The public Medicaid Provider Spending file has no diagnosis codes. Each row is a provider, a billing code and a month — not a visit — so there is no way to see why a patient was seen.
Billing codes describe the service (for example a psychotherapy session), not the condition. We do not guess diagnoses from code names.
Diagnosis-linked counts would need the restricted TAF research files or an official published diagnosis table. Until we have one, those counts are shown as “unavailable”, never as zero or as an estimate.
Why can't you tell what share of 90833 add-ons go with each visit?
The file reports yearly or monthly totals per code, with no visit IDs linking one code to another. Ratios we show between 90833 and office-visit codes are simple comparisons of totals, not same-visit percentages.
Is Medicaid ever added to Medicare or VA numbers?
No. Medicaid, Medicare and VA use different payments, units and identifiers, so we show them side by side and never add them together. Medicare outlier flags are not applied to Medicaid rows.
Do Medicaid payments equal what a provider earned?
No. Amounts are Medicaid payments for the selected codes credited to the listed NPI. They are not total provider revenue and do not include other payers.