Data

Served tables

Tables
781
With columns
764
With a card
118grain, traps, filters
Catalog
2026-11-09
find_data_sources(query="...")                 # which table
describe_data_source(source_fqn="<fqn>")       # the card: grain, traps, required filters
query_substrate(sql="SELECT ... FROM <fqn> WHERE <state or year> LIMIT 100")

Medicare Advantage, Part D, Medicaid (379)

TableRowsColumnsLatestCardStatus
Medicare IPPS inpatient acuity (MS-DRG relative weights)
drug_silver.dim_msdrg
76425N/Acolumns onlylive
MA plan networks: plan year x CMS plan x NPI x listed location (2026, 2027)
medicare_bronze.ma_directory_plan_npi_site_v1
N/A18N/Acolumns onlypartial
Vlada locked 2027 allowance dollars like for like by company (v20261007a), same members 2026 vs 2027, dental / hearing / OTC / eyewear / flex card
medicare_semantic.benefit_company_cells_sd_v20261007a
138,01428N/Acolumns onlylive
Vlada locked 2027 benefit tables by company (v20261007a), national / state / county x product type x plan type x parent, 2026 all members, 2026 continuing members and the same members in 2027, every benefit as weighted sums
medicare_semantic.benefit_company_cells_v20261007a
427,355488N/Acolumns onlylive
Vlada locked benefit engine atoms, version v20261005 (the table behind vw_benefit_engine_atoms)
medicare_semantic.benefit_engine_atoms_v20261005
802,687269N/Acolumns onlylive
Vlada locked benefit engine atoms, version v20261006 (the table behind vw_benefit_engine_atoms)
medicare_semantic.benefit_engine_atoms_v20261006
802,687269N/Acolumns onlylive
Vlada locked benefit engine atoms, version v20261006b (the table behind vw_benefit_engine_atoms)
medicare_semantic.benefit_engine_atoms_v20261006b
802,687269N/Acolumns onlylive
Vlada locked benefit engine atoms, version v20261006c (the table behind vw_benefit_engine_atoms)
medicare_semantic.benefit_engine_atoms_v20261006c
802,687269N/Acolumns onlylive
Vlada locked benefit engine atoms, version v20261007a (the table behind vw_benefit_engine_atoms)
medicare_semantic.benefit_engine_atoms_v20261007a
802,687270N/Acolumns onlylive
Vlada locked benefit engine atoms, version v20261008a (the table behind vw_benefit_engine_atoms)
medicare_semantic.benefit_engine_atoms_v20261008a
824,757270N/Acolumns onlylive
Vlada County Volatility Index v4 by county and product type (Report 2's audited table): members, plan ended, moved, material cut, stable and gains, 2016-2027
medicare_semantic.cvi_county_v4
140,77526N/Acolumns onlylive
Vlada County Volatility Index v4 by plan and county: each MA plan's September members and what happened to them the next plan year (plan ended, moved, material cut, stable), 2016-2027
medicare_semantic.cvi_plan_county_v4
691,98226N/Acolumns onlylive
MA parent alias dictionary, every CMS parent_org_raw string mapped to a canonical parent, effective-dated and cited
medicare_semantic.dim_parent_alias_v1
1,07621N/Acolumns onlylive
Vlada Stars measure spine, one row per Star measure identity per rating year 2015 to 2027, with that year's code and cut points
medicare_semantic.dim_stars_measure_identity_v7
58347N/Acolumns onlylive
Vlada Landscape benefit change at county grain, the same members' plan design in year Y and year Y+1, 2023 to 2027
medicare_semantic.fact_landscape_benefits_county_v1
419,954159N/Acolumns onlylive
Vlada Landscape benefit change at county grain, the same members' plan design in year Y and year Y+1, 2023 to 2027
medicare_semantic.fact_landscape_benefits_county_v2
N/A159N/Acolumns onlylive
Vlada Landscape benefit change, the same members' plan design in year Y and year Y+1, 2023 to 2027
medicare_semantic.fact_landscape_benefits_v1
N/A158N/Acolumns onlylive
Vlada Landscape benefit change, the same members' plan design in year Y and year Y+1, 2023 to 2027
medicare_semantic.fact_landscape_benefits_v2
N/A158N/Acolumns onlylive
Vlada Landscape disposition, every September member placed against next year's Landscape file, 2023 to 2027
medicare_semantic.fact_landscape_disposition_v1
419,95415N/Acolumns onlylive
MA parent lineage events, acquisitions, mergers, novations, renames and divestitures with a citation and what the CMS file measured
medicare_semantic.fact_parent_lineage_event_v1
5821N/Acolumns onlylive
MA spine: enrollment per plan x county x month (known counts)
medicare_semantic.ma_spine_enroll_plan_county_v20261012a
N/A14N/Acolumns onlypartial
MA spine: parent per contract x month (as was, as now)
medicare_semantic.ma_spine_parent_month_v20261017a
N/A16N/Acolumns onlypartial
MA spine: plan-year keys (market, product, Part D, parent, lineage)
medicare_semantic.ma_spine_plan_year_v20261012c
N/A27N/Acolumns onlypartial
Vlada Plan Value v18 parent shelf + ranking (who cut, who added), national / state / county x product type x parent
medicare_semantic.plan_value_shelf_v18
80,16030N/Acolumns onlylive
Vlada Plan Value v18 parent shelf + ranking, v18b (who cut, who added; new contracts rolled into their parent), national / state / county x product type x parent
medicare_semantic.plan_value_shelf_v18b
80,01230N/Acolumns onlylive
Vlada Plan Value v19d parent shelf + ranking (Method Lock 1.0; who cut, who added; new contracts rolled into their parent), national / state / county x product type x parent
medicare_semantic.plan_value_shelf_v19d
80,00230N/Acolumns onlylive
Vlada Plan Value v19e parent shelf + ranking (Method Lock 1.0 + PV-55; who cut, who added; new contracts rolled into their parent), national / state / county x product type x parent
medicare_semantic.plan_value_shelf_v19e
80,00230N/Acolumns onlylive
Vlada benefit reading by contract (edition v20261018b): every benefit number by national / state / county x product type x plan type x the member's base contract
medicare_semantic.vw_benefit_contract_cells
1,429,127709N/Acolumns onlylive
Vlada benefit reading, each contract's closest contracts by footprint (edition v20261018b)
medicare_semantic.vw_benefit_contract_match
15,18018N/Acolumns onlylive
Vlada locked benefit engine atoms (pointer view), every county x plan segment's benefits 2022 to 2027, its members followed to next year's plan
medicare_semantic.vw_benefit_engine_atoms
802,687344N/Acolumns onlylive
Vlada benefit engine atoms (edition v20261018b): one plan segment in one county in one year, every benefit reading column (the drill)
medicare_semantic.vw_benefit_reading_atoms
824,757344N/Acolumns onlylive
Vlada benefit reading cells (edition v20261018b): every benefit number by national / state / county x product type x plan type x parent x base year x view, as weighted sums
medicare_semantic.vw_benefit_reading_cells
2,115,880708N/Acolumns onlylive
Vlada benefit reading, allowance dollars like for like (edition v20261018b), same members base -> next year
medicare_semantic.vw_benefit_reading_cells_sd
691,43830N/Acolumns onlylive
Vlada benefit reading, a contract against its closest contracts on their shared counties (edition v20261018b)
medicare_semantic.vw_benefit_reading_matched
33,306787N/Acolumns onlylive
Vlada benefit reading, the simple average across plans (edition v20261018b): each plan segment counted once per cell
medicare_semantic.vw_benefit_reading_simple
2,115,880667N/Acolumns onlylive
Vlada benefit reading, design transitions (edition v20261018b): members by base-year design x next-year design per benefit, same members
medicare_semantic.vw_benefit_reading_transitions
17,670,14430N/Acolumns onlylive
Vlada benefit vector, every MA plan's filed benefit design, one row per plan-segment-year, 2015 to 2026
medicare_semantic.vw_benefit_vector
72,414261N/Acolumns onlylive
Vlada benefit vector v2 extension, 191 more benefit columns per plan-segment-year with a catalog status each
medicare_semantic.vw_benefit_vector_v2_ext
90,464195N/Acolumns onlylive
Each D-SNP plan segment x state with its integration status and the state's Medicaid wrap (dental, eyeglasses, hearing, NEMT, overriding SMAC rules)
medicare_semantic.vw_dsnp_medicaid_wrap_v5
4,79537N/Acolumns onlylive
MA/Part D enrollment, CPSC county grain, parent names as CMS wrote them
medicare_semantic.vw_enrollment_monthly_county_v2
629,025,62824N/Acolumns onlylive
MA/Part D enrollment, CPSC county grain, every published row with the revision-3 flag
medicare_semantic.vw_enrollment_monthly_county_v3
630,792,94826N/Acolumns onlylive
MA monthly enrollment by contract and plan, names as CMS wrote them
medicare_semantic.vw_enrollment_monthly_plan_v2
1,416,62029N/Acolumns onlylive
HCC risk-model coefficients, current posting per payment year, package-labelled
medicare_semantic.vw_hcc_coefficients_current_v2
52,46329N/Acolumns onlylive
MA HEDIS contract file (general sheet), documented names
medicare_semantic.vw_hedis_general_v2
3,54922N/Acolumns onlylive
MA HEDIS national benchmark rates, documented names
medicare_semantic.vw_hedis_national_rates_v2
47116N/Acolumns onlylive
MA HEDIS contract service area, documented names
medicare_semantic.vw_hedis_service_area_v2
2,453,36617N/Acolumns onlylive
Medicare HOS public use files, respondent level (documented names), cohorts 18-27
medicare_semantic.vw_hos_puf_respondent_v2
2,712,105178N/Acolumns onlylive
ICD-10 to HCC / RxHCC crosswalk, current edition per payment year
medicare_semantic.vw_icd10_hcc_crosswalk_current_v1
457,91720N/Acolumns onlylive
MA county ratebook, exact cents, one state key, territory rows kept
medicare_semantic.vw_ma_county_ratebook_v3
42,21820N/Acolumns onlylive
MA contract enrollment by month with the canonical parent as of that month (the parent series spine)
medicare_semantic.vw_ma_parent_resolved_v1
203,75519N/Acolumns onlylive
MA State/County Penetration, county codes at their documented width
medicare_semantic.vw_ma_state_county_penetration_v2
707,50025N/Acolumns onlylive
MA State/County Penetration with blank cells, Pending rows and combined territory figures marked
medicare_semantic.vw_ma_state_county_penetration_v3
707,50034N/Acolumns onlylive
MA State/County Penetration over the reconciled parse, with Pending rows, blank cells and combined territory figures marked
medicare_semantic.vw_ma_state_county_penetration_v4
709,49034N/Acolumns onlylive
USPCC (United States Per Capita Costs), one series key per CMS series, rate years 2003-2027
medicare_semantic.vw_ma_uspcc_v2
6,03329N/Acolumns onlylive
MA monthly enrollment by contract, names as CMS wrote them
medicare_semantic.vw_monthly_contract_enrollment_summary_v2
203,75834N/Acolumns onlylive
PBP ambulance cost share (cleaned view)
medicare_semantic.vw_pbp_ambulance
289,48646N/Acolumns onlylive
PBP b19 combined package (cleaned view)
medicare_semantic.vw_pbp_b19_combined_package
N/A862026 (report_year); NOTE a gap — 2023 is absent. Present years: 2021, 2022, 2024, 2025, 2026. quarter is constant = 1 and is NOT a real time axis.cardpartial
PBP cardiac pulmonary rehab (cleaned view)
medicare_semantic.vw_pbp_cardiac_pulmonary_rehab
N/A642026 Q1 (report_year=2026, quarter=1); 16 distinct (report_year, quarter) snapshots total, irregularly released — 2019 has only Q1, 2023 has Q1-Q4, 2025 and 2026 only Q1 so far. Each snapshot is one CMS PBP PUF zip.cardlive
PBP clinical diagnostic therapeutic (cleaned view)
medicare_semantic.vw_pbp_clinical_diagnostic_therapeutic
N/A642026 (report_year; latest snapshot 2026 Q1)cardlive
PBP combined benefit groups (cleaned view)
medicare_semantic.vw_pbp_combined_benefits_group
62,62619N/Acolumns onlylive
PBP combined supplemental limit (cleaned view)
medicare_semantic.vw_pbp_combined_supplemental
62,702116N/Acolumns onlylive
PBP dental (cleaned view)
medicare_semantic.vw_pbp_dental
N/A107report_year 2026 (quarter 1) — 26 distinct benefit years 2001-2026cardlive
PBP dme (cleaned view)
medicare_semantic.vw_pbp_dme
N/A512026 (report_year 2026, Q1 — next plan year, already published)cardlive
PBP D-SNP cost-share flag (cleaned view)
medicare_semantic.vw_pbp_dsnp_cost_share
18,87461N/Acolumns onlylive
PBP emergency urgent (cleaned view)
medicare_semantic.vw_pbp_emergency_urgent
N/A712026 (report_year 2026, Q1)cardlive
PBP fitness benefit (cleaned view)
medicare_semantic.vw_pbp_fitness
171,47944N/Acolumns onlylive
PBP health professionals (cleaned view)
medicare_semantic.vw_pbp_health_professionals
N/A762026 (report_year 2026, Q1)cardlive
PBP hearing (cleaned view)
medicare_semantic.vw_pbp_hearing
N/A832026cardlive
PBP home health (cleaned view)
medicare_semantic.vw_pbp_home_health
N/A492026 (report_year=2026)cardlive
PBP inpatient hospital (cleaned view)
medicare_semantic.vw_pbp_inpatient_hospital
N/A1892026 Q1cardlive
PBP inpatient psychiatric (cleaned view)
medicare_semantic.vw_pbp_inpatient_psychiatric
N/A1732026 (report_year)cardlive
PBP meals benefit (cleaned view)
medicare_semantic.vw_pbp_meals
201,48879N/Acolumns onlylive
PBP moop (cleaned view)
medicare_semantic.vw_pbp_moop
N/A642026 (report_year, Q1)cardlive
PBP optional supplemental packages (cleaned view)
medicare_semantic.vw_pbp_optional_package
51,69480N/Acolumns onlylive
PBP optional supplemental premium and MOOP (cleaned view)
medicare_semantic.vw_pbp_optional_supplemental
40,96824N/Acolumns onlylive
PBP otc (cleaned view)
medicare_semantic.vw_pbp_otc
N/A1032026cardlive
PBP outpatient hospital (cleaned view)
medicare_semantic.vw_pbp_outpatient_hospital
N/A672026cardlive
PBP partb rx drugs (cleaned view)
medicare_semantic.vw_pbp_partb_rx_drugs
N/A662026 (report_year)cardlive
PBP partd drugs (cleaned view)
medicare_semantic.vw_pbp_partd_drugs
N/A932026 (report_year); note gap year 2020 absentcardpartial
PBP partd tier (cleaned view)
medicare_semantic.vw_pbp_partd_tier
N/A1782026 (report_year 2026, Q1)cardpartial
PBP partial hospitalization (cleaned view)
medicare_semantic.vw_pbp_partial_hospitalization
N/A57report_year 2026 (Q1)cardlive
PBP plan deductible (cleaned view)
medicare_semantic.vw_pbp_plan_deductible
163,67096N/Acolumns onlylive
Plan premium by year, from the CMS Landscape (cleaned view)
medicare_semantic.vw_pbp_plan_premium
81,37569N/Acolumns onlylive
PBP preventive (cleaned view)
medicare_semantic.vw_pbp_preventive
N/A592026 Q1 (18 distinct report_years 2007-2026; 32 distinct year x quarter snapshots; 2007-2017 are Q1-only and later years add only some quarters — e.g. 2020 = Q1/Q2/Q4 no Q3, 2021 = Q1 only, 2025/2026 = Q1 only so far, so the quarterly cadence is irregular/partial)cardlive
PBP renal dialysis (cleaned view)
medicare_semantic.vw_pbp_renal_dialysis
N/A502026cardlive
PBP section c pos oon (cleaned view)
medicare_semantic.vw_pbp_section_c_pos_oon
N/A112report_year 2026cardlive
PBP snf (cleaned view)
medicare_semantic.vw_pbp_snf
N/A121report_year 2026 (quarter 1)cardlive
PBP supplemental other (cleaned view)
medicare_semantic.vw_pbp_supplemental_other
N/A502026 annual (report_year=2026, quarter=1; source pbp-benefits-2026.zip)cardpartial
PBP supplemental services (cleaned view)
medicare_semantic.vw_pbp_supplemental_services
486,40372N/Acolumns onlylive
PBP transportation (cleaned view)
medicare_semantic.vw_pbp_transportation
N/A85report_year 2026cardlive
PBP vision (cleaned view)
medicare_semantic.vw_pbp_vision
N/A1022026 (report_year)cardlive
PBP worldwide emergency, urgent care and transport benefit (cleaned view)
medicare_semantic.vw_pbp_worldwide
100,80524N/Acolumns onlylive
Vlada Plan Value (Method Lock 1.0 + PV-55, signed 2026-10-17; served build v19e) market cells, national / state / county x product type x plan type x parent, 2026 and 2027 levels
medicare_semantic.vw_plan_value_cells
129,36374N/Acolumns onlylive
Vlada Plan Value, county basis (formerly BenVAT) with per-benefit values and real county enrollment
medicare_semantic.vw_plan_value_county
445,77176N/Acolumns onlylive
Vlada Plan Value, national basis (formerly BenVAT) per contract x plan x segment x county x benefit year
medicare_semantic.vw_plan_value_national
9,948,02043N/Acolumns onlylive
Vlada Plan Value (Method Lock 1.0 + PV-55, signed 2026-10-17; served build v19e) same-member change 2026 -> 2027, national / state / county x product type x plan type x parent
medicare_semantic.vw_plan_value_pairs
117,83674N/Acolumns onlylive
Vlada Plan Value (Method Lock 1.0 + PV-55, signed 2026-10-17; served build v19e) per plan-segment, 2026 and 2027, five legs, range ends, card bounds, D-SNP two columns
medicare_semantic.vw_plan_value_plans
8,709106N/Acolumns onlylive
Special Needs Plans by plan and month, Plan ID at three digits
medicare_semantic.vw_snp_data_v2
194,93024N/Acolumns onlylive
Special Needs Plans by plan and month, current CMS vintage, with D-SNP integration status, small-cell bounds and Under-11 rows
medicare_semantic.vw_snp_data_v3
195,62830N/Acolumns onlylive
States W4 Medicare in the state: vw_state_medicare_al_v1
medicare_semantic.vw_state_medicare_al_v1
455,94726N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ar_v1
medicare_semantic.vw_state_medicare_ar_v1
509,89426N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_az_v1
medicare_semantic.vw_state_medicare_az_v1
106,29726N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ca_v1
medicare_semantic.vw_state_medicare_ca_v1
397,36126N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_co_v1
medicare_semantic.vw_state_medicare_co_v1
423,51726N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ct_v1
medicare_semantic.vw_state_medicare_ct_v1
59,97826N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_fl_v1
medicare_semantic.vw_state_medicare_fl_v1
479,33426N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ga_v1
medicare_semantic.vw_state_medicare_ga_v1
1,123,96726N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ia_v1
medicare_semantic.vw_state_medicare_ia_v1
659,13026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_il_v1
medicare_semantic.vw_state_medicare_il_v1
708,10626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_in_v1
medicare_semantic.vw_state_medicare_in_v1
635,65426N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ks_v1
medicare_semantic.vw_state_medicare_ks_v1
688,23526N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ky_v1
medicare_semantic.vw_state_medicare_ky_v1
819,15426N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_la_v1
medicare_semantic.vw_state_medicare_la_v1
446,30626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ma_v1
medicare_semantic.vw_state_medicare_ma_v1
101,49626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_md_v1
medicare_semantic.vw_state_medicare_md_v1
163,04726N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_mi_v1
medicare_semantic.vw_state_medicare_mi_v1
563,46626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_mn_v1
medicare_semantic.vw_state_medicare_mn_v1
575,85026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_mo_v1
medicare_semantic.vw_state_medicare_mo_v1
777,06926N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ms_v1
medicare_semantic.vw_state_medicare_ms_v1
545,65626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_nc_v1
medicare_semantic.vw_state_medicare_nc_v1
703,32626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_nj_v1
medicare_semantic.vw_state_medicare_nj_v1
149,82026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_nv_v1
medicare_semantic.vw_state_medicare_nv_v1
117,65526N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ny_v1
medicare_semantic.vw_state_medicare_ny_v1
438,27026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_oh_v1
medicare_semantic.vw_state_medicare_oh_v1
628,00126N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ok_v1
medicare_semantic.vw_state_medicare_ok_v1
513,75926N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_or_v1
medicare_semantic.vw_state_medicare_or_v1
242,38026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_pa_v1
medicare_semantic.vw_state_medicare_pa_v1
492,39426N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_sc_v1
medicare_semantic.vw_state_medicare_sc_v1
325,93726N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_tn_v1
medicare_semantic.vw_state_medicare_tn_v1
651,28326N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_tx_v1
medicare_semantic.vw_state_medicare_tx_v1
1,782,13826N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_ut_v1
medicare_semantic.vw_state_medicare_ut_v1
193,22626N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_va_v1
medicare_semantic.vw_state_medicare_va_v1
928,54026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_wa_v1
medicare_semantic.vw_state_medicare_wa_v1
262,25026N/Acolumns onlypartial
States W4 Medicare in the state: vw_state_medicare_wi_v1
medicare_semantic.vw_state_medicare_wi_v1
493,45826N/Acolumns onlypartial
Publisher-native state quality measures
medicare_semantic.vw_state_quality_publisher
596,76223N/Acolumns onlylive
CMS provider and clinician state quality distributions
medicare_semantic.vw_state_quality_rollup
259,83825N/Acolumns onlylive
AHRQ CCSR category hierarchy
medicare_silver.ahrq_ccsr_category
13,88627N/Acolumns onlylive
AHRQ CCSR diagnosis and procedure mappings
medicare_silver.ahrq_ccsr_mapping
5,851,11031N/Acolumns onlylive
AHRQ Quality Indicator national benchmark tables
medicare_silver.ahrq_qi_benchmark
7,03137N/Acolumns onlylive
AHRQ Quality Indicator public SAS value-set rules
medicare_silver.ahrq_qi_value_set
10,020,21833N/Acolumns onlylive
AHRQ clinical-reference governed source-asset ledger
medicare_silver.ahrq_source_asset
17632N/Acolumns onlylive
CMS Basic Stand Alone sample claims: carrier (physician) line items
medicare_silver.cms_bsa_carrier_line_item
70,536,73529N/Acolumns onlylive
CMS Basic Stand Alone sample claims: chronic conditions
medicare_silver.cms_bsa_chronic_condition
43,36729N/Acolumns onlylive
CMS Basic Stand Alone sample claims: DME line items
medicare_silver.cms_bsa_dme_line_item
5,246,16629N/Acolumns onlylive
CMS Basic Stand Alone sample claims: the field dictionary
medicare_silver.cms_bsa_field
N/A27N/Acolumns onlylive
CMS Basic Stand Alone sample claims: home health beneficiary summaries
medicare_silver.cms_bsa_hha_beneficiary
135,36829N/Acolumns onlylive
CMS Basic Stand Alone sample claims: hospice beneficiary summaries
medicare_silver.cms_bsa_hospice_beneficiary
55,47329N/Acolumns onlylive
CMS Basic Stand Alone sample claims: inpatient claims
medicare_silver.cms_bsa_inpatient_claim
588,41529N/Acolumns onlylive
CMS Basic Stand Alone sample claims: institutional provider beneficiary summaries
medicare_silver.cms_bsa_institutional_provider_beneficiary_summary
N/A29N/Acolumns onlylive
CMS Basic Stand Alone sample claims: outpatient procedures
medicare_silver.cms_bsa_outpatient_procedure
33,086,68729N/Acolumns onlylive
CMS Basic Stand Alone sample claims: physician/supplier beneficiary summaries
medicare_silver.cms_bsa_physician_supplier_beneficiary_summary
N/A29N/Acolumns onlylive
CMS Basic Stand Alone sample claims: Part D prescription drug events
medicare_silver.cms_bsa_prescription_drug_event
50,325,98829N/Acolumns onlylive
CMS Basic Stand Alone sample claims: Part D beneficiary drug profiles
medicare_silver.cms_bsa_prescription_drug_profile
N/A29N/Acolumns onlylive
CMS Basic Stand Alone sample claims: SNF beneficiary summaries
medicare_silver.cms_bsa_snf_beneficiary
64,88629N/Acolumns onlylive
CMS Basic Stand Alone sample claims: the source-asset ledger
medicare_silver.cms_bsa_source_asset
N/A36N/Acolumns onlylive
CMS MMCO Integration Status for Contract Year D-SNPs, every edition CY2021-2027
medicare_silver.cms_dsnp_integration_status_list_v1
6,78334N/Acolumns onlylive
CMS D-SNP look-alike lists CY2022-2026 (plan-level % dual eligible)
medicare_silver.cms_dsnp_lookalike_list_v1
10818N/Acolumns onlylive
CMS CSSC acceptable physician specialty history
medicare_silver.cssc_acceptable_specialty
79428N/Acolumns onlylive
CMS CSSC public EDPS, RAPS, and FERAS operational edits
medicare_silver.cssc_operational_edit
67935N/Acolumns onlylive
CMS CSSC resource attachment-link index
medicare_silver.cssc_operations_attachment
1,00233N/Acolumns onlylive
CMS CSSC Part C article, listserv, job-aid, and video history
medicare_silver.cssc_operations_resource
91134N/Acolumns onlylive
CMS CSSC Part C operations governed source-asset ledger
medicare_silver.cssc_operations_source_asset
3835N/Acolumns onlylive
CMS CSSC Supplemental Benefit Service Category submission codes
medicare_silver.cssc_sbsc_code
40330N/Acolumns onlylive
CMS Anesthesia Base Units (00100-01999)
medicare_silver.dim_anesthesia_base_unit
1,93318N/Acolumns onlylive
HCC risk-model coefficients (reference)
medicare_silver.dim_hcc_coefficients
8,805112027cardlive
HCC risk-model coefficients, every CMS posting and package 2016-2027 (v2)
medicare_silver.dim_hcc_coefficients_v2
75,52123N/Acolumns onlylive
ICD-10 to HCC crosswalk (reference)
medicare_silver.dim_icd10_hcc_crosswalk
171,676102027 (provisional — 2027 mappings are byte-identical to 2026; see gotchas)cardlive
ICD-10 to HCC / RxHCC crosswalk, every CMS edition (v3)
medicare_silver.dim_icd10_hcc_crosswalk_v3
707,82120N/Acolumns onlylive
MA network intelligence: NUCC taxonomy -> normalized specialty (CMS MA network-adequacy types)
medicare_silver.dim_network_specialty_v1
N/A8N/Acolumns onlypartial
MA Star Ratings — cross-year measure crosswalk
medicare_silver.dim_stars_measure_crosswalk
N/A92025 (from_rating_year); maps forward to 2026 (to_rating_year)cardpartial
MA Star Ratings — measure dimension
medicare_silver.dim_stars_measures
N/A22rating_year 2026 (latest data window 'MY2024 Q1-Q3 (Q4 excluded)')cardlive
MA Star Ratings — methodology dimension
medicare_silver.dim_stars_methodology
N/A132027 (rating_year; 2027 is a not-yet-finalized projection with is_current=FALSE — latest FINALIZED year is 2026)cardlive
D-SNP integration status (FIDE / HIDE / CO / CO-P, AIP, zero-dollar cost sharing, dual categories) by plan segment and state, CY2023-2027
medicare_silver.dsnp_integration_status_v1
4,79547N/Acolumns onlylive
MA/Part D enrollment — CPSC county grain
medicare_silver.enrollment_monthly_county
N/A22N/Acolumns onlylive
MA/Part D enrollment, CPSC county grain, every row CMS publishes (parse revision 4)
medicare_silver.enrollment_monthly_county_v4
630,792,94823N/Acolumns onlylive
MA/Part D enrollment — plan grain
medicare_silver.enrollment_monthly_plan
N/A24N/Acolumns onlylive
CMS Accountable Care Organization (ACO) Participants — Shared Savings Program
medicare_silver.fact_aco_participant
183,71031N/Acolumns onlylive
AHRQ NHQDR national and state quality estimates
medicare_silver.fact_ahrq_nhqdr_quality
855,29251N/Acolumns onlylive
CMS Medicare Ambulance Fee Schedule (AFS) Public Use File
medicare_silver.fact_ambulance_fee_schedule
29,16027N/Acolumns onlylive
Medicare ASC (Ambulatory Surgery Center) rates
medicare_silver.fact_asc_addendum
462,34348N/Acolumns onlylive
CMS Clinical Laboratory Fee Schedule national limitation amounts, quarterly releases 2019-2026, stamped
medicare_silver.fact_clfs_national_rate
55,11624N/Acolumns onlylive
Medicare CLFS preliminary CY2027 rates (PAMA weighted medians, raw vs trimmed, capped)
medicare_silver.fact_clfs_preliminary_rate
1,92420N/Acolumns onlylive
Medicare CLFS Private Payer Rates and Volumes (PAMA)
medicare_silver.fact_clfs_private_payer_rate
7,515,43220N/Acolumns onlylive
Medicare DME, Devices & Supplies — by Supplier and Service (granular supplier price)
medicare_silver.fact_dme_by_supplier_service
463,78435N/Acolumns onlylive
Medicare DME by Geography & Service (avg allowed/payment per HCPCS)
medicare_silver.fact_dme_payment_by_geo
38,67533N/Acolumns onlylive
Medicare DMEPOS fee schedule, every release October 1998 - October 2026
medicare_silver.fact_dmepos_fee_schedule
14,503,02441N/Acolumns onlylive
CMS ESRD QIP Total Performance Score (dialysis pay-for-performance)
medicare_silver.fact_esrd_qip
7,55826N/Acolumns onlylive
Facility cost reports — HHA supplies/drugs/devices cost-to-charge rows, stamped
medicare_silver.fact_facility_cost_report_ccr
29,69237N/Acolumns onlylive
Facility cost reports — non-acute unit-cost metrics, stamped (HHA/hospice/ESRD/FQHC/RHC)
medicare_silver.fact_facility_cost_report_unit
1,046,00738N/Acolumns onlylive
CMS FQHC PPS Base Payment Rate
medicare_silver.fact_fqhc_pps_rate
217N/Acolumns onlylive
CMS Care Compare HCAHPS — Hospital patient-experience survey
medicare_silver.fact_hcahps
4,208,68932N/Acolumns onlylive
CMS Home Health PDGM Case-Mix Weights
medicare_silver.fact_hh_pdgm_weight
43222N/Acolumns onlylive
CMS Care Compare Home Health Agencies — per-agency quality
medicare_silver.fact_home_health_quality
12,39250N/Acolumns onlylive
CMS Hospice PPS Per-Diem Rates (Federal Register final rule)
medicare_silver.fact_hospice_pps_rate
16423N/Acolumns onlylive
CMS Care Compare Hospice provider-quality measures
medicare_silver.fact_hospice_quality
459,08427N/Acolumns onlylive
Medicare Inpatient Hospitals — by Provider and Service (granular DRG price)
medicare_silver.fact_inpatient_by_provider_service
2,451,94427N/Acolumns onlylive
Medicare IPPS Base Rate (operating + capital standardized amounts)
medicare_silver.fact_ipps_base_rate
6630N/Acolumns onlylive
Medicare IPPS Wage Index (geographic wage adjustment)
medicare_silver.fact_ipps_wage_index
84,74628N/Acolumns onlylive
CMS IRF PPS CMG Relative Weights (rule data files)
medicare_silver.fact_irf_pps_cmg_weight
8,44322N/Acolumns onlylive
CMS LTCH PPS MS-LTC-DRG Relative Weights (Table 11)
medicare_silver.fact_ltch_pps_drg_weight
77221N/Acolumns onlylive
MA Claims Processing Contacts, 2011-2026
medicare_silver.fact_ma_claims_processing_contact
50,45046N/Acolumns onlylive
Medicare Advantage Geographic Variation, national and state, 2016-2023
medicare_silver.fact_ma_geographic_variation
43279N/Acolumns onlylive
CMS MA / Part D Landscape, every era CY2006-CY2027, stamped
medicare_silver.fact_ma_landscape
1,684,15887N/Acolumns onlylive
CMS MA / Part D Landscape, EVERY edition held (Wayback originals + revisions + served copy), one partition per publisher zip
medicare_silver.fact_ma_landscape_edition
6,066,77880N/Acolumns onlylive
CMS MA / Part D Medical Loss Ratio public-use files CY2014-CY2023, stamped
medicare_silver.fact_ma_mlr
4,98480N/Acolumns onlylive
CMS MA / Part D Medical Loss Ratio public-use files CY2014-CY2023, loader revision 2 (every report line)
medicare_silver.fact_ma_mlr_v2
4,984119N/Acolumns onlylive
MA and Part D Ad-Hoc Corrective Action Plans, 2014-2026
medicare_silver.fact_ma_part_d_corrective_action_plan
67,20641N/Acolumns onlylive
CMS MA and Part D warning letters, September 2024 - September 2026
medicare_silver.fact_ma_part_d_warning_letter
3,07943N/Acolumns onlylive
CMS Market Saturation & Utilization (provider competition by county × service)
medicare_silver.fact_market_saturation
2,455,33033N/Acolumns onlylive
CMS Medicaid/CHIP Child and Adult Core Set State Quality
medicare_silver.fact_medicaid_core_set_quality
31,34449N/Acolumns onlylive
CMS Medicaid Managed Care (utilization by MCO × county)
medicare_silver.fact_medicaid_managed_care
19,55927N/Acolumns onlylive
CMS Medicare Geographic Variation (per-capita cost + utilization by geography)
medicare_silver.fact_medicare_geo_variation
37,00048N/Acolumns onlylive
Medicare Monthly Enrollment (national, state, county), 2013-2026
medicare_silver.fact_medicare_monthly_enrollment
583,78079N/Acolumns onlylive
MSSP ACO performance year financial and quality results, PY2013-PY2024
medicare_silver.fact_mssp_aco_performance_cell
878,57435N/Acolumns onlylive
MSSP county expenditure and risk of assignable beneficiaries, CY2019-2025
medicare_silver.fact_mssp_county_expenditure_risk
45,15444N/Acolumns onlylive
CMS Care Compare Nursing Home (Provider Information) — 5-star quality
medicare_silver.fact_nursing_home_quality
14,69566N/Acolumns onlylive
Medicare Plan Finder Online Enrollment Center requests, monthly, 2014-2026
medicare_silver.fact_oec_monthly_enrollment
20537N/Acolumns onlylive
Medicare OPPS (hospital outpatient)
medicare_silver.fact_opps_addendum_b
1,290,79934N/Acolumns onlylive
Medicare Outpatient Hospitals — by Provider and Service (granular APC price)
medicare_silver.fact_outpatient_by_provider_service
1,008,97530N/Acolumns onlylive
CMS PFS Geographic Practice Cost Indices by locality, every RVU release CY2017-2026, stamped
medicare_silver.fact_pfs_gpci_locality
1,11127N/Acolumns onlylive
CMS PFS locality configuration (LOCCO), every RVU release CY2003-2026, stamped
medicare_silver.fact_pfs_locality_config
2,38126N/Acolumns onlylive
Medicare Physician Fee Schedule (PFS)
medicare_silver.fact_pfs_rvu
642,30743N/Acolumns onlylive
Medicare Physician & Other Practitioners — by Provider and Service (granular price)
medicare_silver.fact_physician_by_provider_service
116,297,40737N/Acolumns onlylive
Medicare Physician & Other Practitioners by Geography (avg allowed/payment per HCPCS)
medicare_silver.fact_physician_payment_by_geo
268,35031N/Acolumns onlylive
MA and PDP Plan Directories (contract roster), 2007-2026
medicare_silver.fact_plan_directory_contract
59,96355N/Acolumns onlylive
Medicare Post-Acute Care Utilization — by Provider (SNF/HHA/Hospice/IRF/LTCH)
medicare_silver.fact_post_acute_utilization
14,21437N/Acolumns onlylive
CMS Physician/Supplier Procedure Summary (PSPS) — granular Part B allowed
medicare_silver.fact_psps
14,377,29334N/Acolumns onlylive
CMS Quality Payment Program (QPP/MIPS) Experience — clinician scores
medicare_silver.fact_qpp_experience
503,91737N/Acolumns onlylive
Medicare Part D Retiree Drug Subsidy sponsors, payment years 2006-2024
medicare_silver.fact_retiree_drug_subsidy_sponsor
45,76922N/Acolumns onlylive
CMS SNF PPS PDPM Case-Mix-Adjusted Rates (urban & rural)
medicare_silver.fact_snf_pdpm_rate
35030N/Acolumns onlylive
HCPCS/CPT -> HCRIS cost-center crosswalk (the precision layer)
medicare_silver.hcpcs_cost_center_crosswalk
28,32811N/Acolumns onlylive
MA hedis hos frm
medicare_silver.hedis_hos_frm
N/A142025cardlive
MA hedis hos mui
medicare_silver.hedis_hos_mui
N/A152025cardlive
MA hedis hos oto
medicare_silver.hedis_hos_oto
N/A132021cardlive
MA hedis hos pao
medicare_silver.hedis_hos_pao
N/A142025 (report_year; effective_period_start 2025-01-01)cardlive
MA HEDIS measures (restated v2)
medicare_silver.hedis_measures_v2
2,058,56821N/Acolumns onlylive
MA hedis national rates
medicare_silver.hedis_national_rates
N/A162025cardlive
MA hedis rau measures
medicare_silver.hedis_rau_measures
N/A202025cardlive
CMS HCRIS Hospital complete alpha cell ledger (ALPHA)
medicare_silver.hospital_cost_report_alpha_cell
55,578,53531N/Acolumns onlylive
Hospital cost report — department cost-to-charge (HCRIS 2552-10 Worksheet C)
medicare_silver.hospital_cost_report_dept
1,474,9519N/Acolumns onlylive
CMS HCRIS Hospital financial statements (Worksheets G-2/G-3)
medicare_silver.hospital_cost_report_financial
2,486,70538N/Acolumns onlylive
CMS HCRIS Hospital complete numeric cell ledger (NMRC)
medicare_silver.hospital_cost_report_numeric_cell
296,823,69632N/Acolumns onlylive
Hospital cost report — whole-hospital cost-to-charge (HCRIS 2552-10)
medicare_silver.hospital_cost_report_overall
81,36812N/Acolumns onlylive
CMS HCRIS Hospital gross patient revenue by payer
medicare_silver.hospital_cost_report_payer_revenue
91,82745N/Acolumns onlylive
CMS HCRIS CCN-level hospital operating profile
medicare_silver.hospital_cost_report_profile
90,68049N/Acolumns onlylive
CMS HCRIS Hospital report ledger (RPT)
medicare_silver.hospital_cost_report_report
91,82738N/Acolumns onlylive
CMS HCRIS Hospital utilization (Worksheet S-3 Part I)
medicare_silver.hospital_cost_report_utilization
2,462,44248N/Acolumns onlylive
Hospital outpatient facility VOLUME (Medicare, by provider & service)
medicare_silver.hospital_outpatient_volume
892,79311N/Acolumns onlylive
CMS inpatient Provider Specific File effective records
medicare_silver.inpatient_psf_provider_record
3,161,16264N/Acolumns onlylive
CMS IPPS Impact physical provider rows
medicare_silver.ipps_impact_provider_row
428,43253N/Acolumns onlylive
CMS IPPS Impact and inpatient PSF source/document inventory
medicare_silver.ipps_payment_source_asset
42136N/Acolumns onlylive
LIS Contract Enrollment by County, 2009-2026
medicare_silver.lis_contract_county
1,927,34929N/Acolumns onlylive
LIS Enrollment by Plan, 2006-2026
medicare_silver.lis_enrollment_plan
102,49531N/Acolumns onlylive
MA ma contract service area
medicare_silver.ma_contract_service_area
N/A212026-04cardlive
MA contract service area (revision 2)
medicare_silver.ma_contract_service_area_v2
89,865,22222N/Acolumns onlylive
MA county ratebook — CMS plan payment rates by county
medicare_silver.ma_county_ratebook
42,20017N/Acolumns onlylive
CMS MA / Part D Landscape edition ledger (one row per publisher CSV member parsed, per edition)
medicare_silver.ma_landscape_edition_ledger
27628N/Acolumns onlylive
CMS MA / Part D Landscape member ledger (one row per publisher CSV member parsed)
medicare_silver.ma_landscape_member_ledger
16927N/Acolumns onlylive
MA network intelligence: active grade per listed provider (Medicare billing and enrollment)
medicare_silver.ma_network_active_v1
N/A8N/Acolumns onlypartial
MA network intelligence: 2026 -> 2027 network change per contract x health system / specialty
medicare_silver.ma_network_change_v1
N/A15N/Acolumns onlypartial
MA network intelligence: each contract's network by billing group and health system (share of each listed)
medicare_silver.ma_network_contract_group_v1
N/A8N/Acolumns onlypartial
MA network intelligence: network breadth per plan x county x specialty vs the county's rivals
medicare_silver.ma_network_plan_county_v1
N/A21N/Acolumns onlypartial
MA network intelligence: hospitals in each plan's published network, with evidence (CCN)
medicare_silver.ma_network_plan_hospital_v1
N/A15N/Acolumns onlypartial
MA network intelligence: plan x NPI x listed ZIP with normalized specialty and county (2026, 2027)
medicare_silver.ma_network_provider_v1
N/A18N/Acolumns onlypartial
MA regional benchmarks and Part D national and LIS benchmarks, CY2006-2027
medicare_silver.ma_part_d_benchmark_figure
3,11121N/Acolumns onlylive
CMS MA / Part D agent and broker compensation limits (FMV initial and renewal caps, referral fee caps), CY2019-CY2027
medicare_silver.ma_partd_agent_broker_compensation_limit_v1
11829N/Acolumns onlylive
CMS MA and PDP Enrollment by State/County/Contract (SCC), full version
medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1
143,610,80927N/Acolumns onlylive
CMS MA and PDP Enrollment by State/County/Plan Type (SCP)
medicare_silver.ma_pdp_enrollment_by_state_county_plan_type_v1
3,048,09724N/Acolumns onlylive
CMS Monthly Enrollment by State: Medicare eligibles and MA, other and PDP enrollment by state
medicare_silver.ma_pdp_enrollment_by_state_v1
6,56529N/Acolumns onlylive
MA plan payment — county rollup
medicare_silver.ma_plan_payment_county
140,291142024cardlive
MA plan payment, county rollup, parser 0.4.0
medicare_silver.ma_plan_payment_county_v2
232,36815N/Acolumns onlylive
MA plan payment — Part C (contract x plan x year)
medicare_silver.ma_plan_payment_part_c
40,014132024cardlive
MA plan payment, Part C (contract x plan x year), parser 0.4.0
medicare_silver.ma_plan_payment_part_c_v2
65,87215N/Acolumns onlylive
MA plan payment — Part D (plan x year)
medicare_silver.ma_plan_payment_part_d
48,455142024cardlive
MA plan payment, Part D (plan x year), parser 0.4.0
medicare_silver.ma_plan_payment_part_d_v2
84,46615N/Acolumns onlylive
MA Rate Calculation Data: how CMS computed each county's MA rate, 1999-2027
medicare_silver.ma_rate_calculation_cell
8,268,67325N/Acolumns onlylive
MA Rate Calculation Data, parse revision 2: one measure_key per column, 1999-2027
medicare_silver.ma_rate_calculation_cell_v2
8,268,67327N/Acolumns onlylive
MA rate notices CY2000-2027: the call letter MOOP, cost-sharing and MLR tables
medicare_silver.ma_rate_notice_call_letter
2,25923N/Acolumns onlylive
MA rate notices CY2000-2027: the pinned documents (PDF, ZIP, HTML)
medicare_silver.ma_rate_notice_document
12418N/Acolumns onlylive
MA rate notices CY2000-2027: documents, every printed number, curated figures
medicare_silver.ma_rate_notice_figure
69721N/Acolumns onlylive
MA rate notices CY2000-2027: the Part D benefit parameters by year
medicare_silver.ma_rate_notice_part_d_parameter
3,38821N/Acolumns onlylive
MA rate notices CY2000-2027: the MA payment parameter tables
medicare_silver.ma_rate_notice_payment_parameter
1,97823N/Acolumns onlylive
MA rate notices CY2000-2027: the projection and trend-basis tables
medicare_silver.ma_rate_notice_projection
17,35823N/Acolumns onlylive
MA rate notices CY2000-2027: every printed risk model factor
medicare_silver.ma_rate_notice_risk_model_cell
57,19426N/Acolumns onlylive
MA rate notices CY2000-2027: how each Advance Notice figure moved to the final
medicare_silver.ma_rate_notice_stage_change
37419N/Acolumns onlylive
MA rate notices CY2000-2027: the per capita cost (USPCC) history
medicare_silver.ma_rate_notice_uspcc_estimate
5,57122N/Acolumns onlylive
MA rate notices CY2000-2027: every printed number with its verbatim line
medicare_silver.ma_rate_notice_value
209,39821N/Acolumns onlylive
MA ma state county penetration
medicare_silver.ma_state_county_penetration
N/A242026-04-01cardlive
USPCC (United States Per Capita Costs), rate years 2003-2027
medicare_silver.ma_uspcc
6,03328N/Acolumns onlylive
CMS Medicare Coverage Database public documents
medicare_silver.mcd_document
5,36543N/Acolumns onlylive
CMS Medicare Coverage Database public document components
medicare_silver.mcd_document_component
89943N/Acolumns onlylive
CMS Medicare Coverage Database document relationships
medicare_silver.mcd_document_relationship
2,96543N/Acolumns onlylive
CMS Medicare Coverage Database reference metadata
medicare_silver.mcd_reference
27043N/Acolumns onlylive
Clinical Laboratory Fee Schedule, local amounts by carrier locality
medicare_silver.medicare_clfs_locality_rates
1,051,93926N/Acolumns onlylive
Medicare PFS Conversion Factor (by effective period)
medicare_silver.medicare_conversion_factor
27252026cardlive
CMS PFS Payment-Policy Indicators (PPRRVU)
medicare_silver.medicare_pfs_indicators
19,35624N/Acolumns onlylive
CMS ZIP5 → PFS Locality Crosswalk (authoritative)
medicare_silver.medicare_zip5_locality
687,05323N/Acolumns onlylive
Legacy Medicare ZIP → Payment Locality Crosswalk (superseded)
medicare_silver.medicare_zip_to_locality
31,913172025cardlive
MedPAC Data Book workbook exhibit index
medicare_silver.medpac_databook_exhibit
5644N/Acolumns onlylive
MedPAC Data Book numeric metric observations
medicare_silver.medpac_databook_metric_observation
5,56753N/Acolumns onlylive
MedPAC annual Data Book page evidence
medicare_silver.medpac_databook_page
5,09134N/Acolumns onlylive
MedPAC annual Data Book source asset inventory
medicare_silver.medpac_databook_source_asset
4335N/Acolumns onlylive
MedPAC Data Book supporting workbook cells
medicare_silver.medpac_databook_workbook_cell
7,86239N/Acolumns onlylive
MA enrollment — monthly contract summary
medicare_silver.monthly_contract_enrollment_summary
198,91730N/Acolumns onlylive
MA mpf benefit summary annual
medicare_silver.mpf_benefit_summary_annual
N/A222026 (contract_year 2026; effective_period 2026-01-01 to 2026-12-31)cardlive
Medicare Plan Finder — optional supplemental benefits (annual)
medicare_silver.mpf_optional_supplemental_annual
N/A222026 (contract_year 2026 / effective_period 2026-01-01). NOTE: 2024 is MISSING — years present are 2020, 2021, 2022, 2023, 2025, 2026 (the cy-2024 CMS file was not ingested).cardlive
CMS NPPES Deactivated NPI Report: every deactivated NPI with its date, one partition per monthly report
medicare_silver.nppes_deactivated_npi_v1
N/A6N/Acolumns onlypartial
MA pbp changelog
medicare_silver.pbp_changelog
N/A16"2026 (report_year 2026; effective_period_start 2026-01-01). 26 annual benefit years, one calendar year apart (avg gap ~365 days)."cardpartial
MA pbp field dictionary
medicare_silver.pbp_field_dictionary
N/A222026 (effective_period_start 2026-01-01); 26 benefit years 2001-2026cardpartial
MA pbp mrx
medicare_silver.pbp_mrx
N/A3802026cardpartial
MA pbp mrx gap coverage
medicare_silver.pbp_mrx_gap_coverage
N/A312024-01-01cardpartial
MA pbp mrx p
medicare_silver.pbp_mrx_p
N/A402026 (report_year 2026 / effective_period_start 2026-01-01)cardpartial
MA pbp mrx tier
medicare_silver.pbp_mrx_tier
N/A3092026 (contract year 2026, effective_period_start 2026-01-01)cardpartial
MA pbp plan area
medicare_silver.pbp_plan_area
N/A272026-01-01cardpartial
MA pbp plan region area
medicare_silver.pbp_plan_region_area
N/A272026cardpartial
MA pbp sas schema
medicare_silver.pbp_sas_schema
N/A172026 (report_year; effective_period_start 2026-01-01)cardpartial
MA pbp section a
medicare_silver.pbp_section_a
N/A1522026 (report_year 2026, quarter 1)cardpartial
MA pbp section b10 amb trans
medicare_silver.pbp_section_b10_amb_trans
N/A1182026 (report_year 2026, effective_period_start 2026-01-01)cardpartial
MA pbp section b11 dme prosth orth sup
medicare_silver.pbp_section_b11_dme_prosth_orth_sup
N/A2002026 (report_year 2026 / effective_period_start 2026-01-01)cardpartial
MA pbp section b12 renal dialysis
medicare_silver.pbp_section_b12_renal_dialysis
N/A522026 (report_year 2026 / effective_period_start 2026-01-01)cardpartial
PBP Section B13 — Other Services (silver)
medicare_silver.pbp_section_b13_other_services
N/A1151N/Acolumns onlypartial
MA pbp section b14 preventive
medicare_silver.pbp_section_b14_preventive
N/A8252026-01-01cardpartial
MA pbp section b15 partb rx drugs
medicare_silver.pbp_section_b15_partb_rx_drugs
N/A2322026cardpartial
PBP Section B16 — Dental (silver)
medicare_silver.pbp_section_b16_dental
N/A565N/Acolumns onlypartial
PBP Section B17 — Eye Exams / Eyewear (silver)
medicare_silver.pbp_section_b17_eye_exams_wear
N/A258N/Acolumns onlypartial
PBP Section B18 — Hearing Exams / Aids (silver)
medicare_silver.pbp_section_b18_hearing_exams_aids
N/A250N/Acolumns onlypartial
MA pbp section b19 model test
medicare_silver.pbp_section_b19_model_test
N/A1142026 (report_year; effective_period_start 2026-01-01). Years present: 2017, 2021, 2022, 2024, 2025, 2026 — 2018/2019/2020/2023 absent.cardpartial
MA pbp section b1a inpat hosp
medicare_silver.pbp_section_b1a_inpat_hosp
N/A4922026 (report_year 2026, effective_period_start 2026-01-01)cardpartial
MA pbp section b1b inpat hosp psych
medicare_silver.pbp_section_b1b_inpat_hosp_psych
N/A3922026 (report_year 2026, Q1). 25 distinct report_years; 39 distinct year x quarter release snapshots. effective_period_start spans 2002-01-01 to 2026-01-01.cardpartial
MA pbp section b20
medicare_silver.pbp_section_b20
N/A2992026-01-01cardpartial
MA pbp section b2 snf
medicare_silver.pbp_section_b2_snf
N/A3862026 (report_year=2026 / effective_period_start 2026-01-01)cardpartial
MA pbp section b3 cardiac rehab
medicare_silver.pbp_section_b3_cardiac_rehab
N/A1112026-01-01cardpartial
MA pbp section b3 corf
medicare_silver.pbp_section_b3_corf
N/A982018-01-01 (benefit year 2018; latest PUF release = 2018 Q4)cardpartial
MA pbp section b4 emerg urgent
medicare_silver.pbp_section_b4_emerg_urgent
N/A1632026-01-01cardpartial
MA pbp section b5 partial hosp
medicare_silver.pbp_section_b5_partial_hosp
N/A742026-01-01cardpartial
MA pbp section b6 home health
medicare_silver.pbp_section_b6_home_health
N/A1652026cardpartial
MA pbp section b7 health prof
medicare_silver.pbp_section_b7_health_prof
N/A3152026 (benefit year; effective_period_start 2026-01-01)cardpartial
MA pbp section b8 clin diag ther
medicare_silver.pbp_section_b8_clin_diag_ther
N/A1592026 (report_year 2026, effective_period_start 2026-01-01)cardpartial
MA pbp section b9 outpat hosp
medicare_silver.pbp_section_b9_outpat_hosp
N/A2362026 (report_year 2026, plan year effective 2026-01-01)cardpartial
MA pbp section c
medicare_silver.pbp_section_c
N/A4652026 (benefit year; effective_period_start 2026-01-01). 21 distinct benefit years present; years 2007-2011 are entirely missing (data jumps 2006 -> 2012), and 2020 is missing its Q3 release.cardpartial
MA pbp section c oon
medicare_silver.pbp_section_c_oon
N/A502026 (report_year=2026, effective_period_start 2026-01-01; only Q1 present so far, 192,364 rows across 20 bid versions)cardpartial
MA pbp section c pos
medicare_silver.pbp_section_c_pos
N/A462026 (report_year 2026, effective_period_start 2026-01-01)cardpartial
MA pbp section d
medicare_silver.pbp_section_d
N/A6562026 (report_year 2026 / effective_period_start 2026-01-01)cardpartial
MA pbp section d oon
medicare_silver.pbp_section_d_oon
N/A312026cardpartial
MA pbp section d opt
medicare_silver.pbp_section_d_opt
N/A362026 (effective_period_start 2026-01-01)cardpartial
MA pbp vbid overlay
medicare_silver.pbp_vbid_overlay
N/A162026 (report_year; benefit window 2026-01-01..2026-12-31)cardpartial
PDP Contract Service Area by State/County, 2007-2026
medicare_silver.pdp_contract_service_area
47,691,96721N/Acolumns onlylive
PDP State/County Penetration, 2008-2026
medicare_silver.pdp_state_county_penetration
712,76824N/Acolumns onlylive
MA plan crosswalk — annual lineage (silver)
medicare_silver.plan_crosswalks_annual
N/A27N/Acolumns onlypartial
CMS QualityNet methodology document and archive-member inventory
medicare_silver.qualitynet_methodology_document
42735N/Acolumns onlylive
CMS QualityNet searchable methodology document text
medicare_silver.qualitynet_methodology_document_text
7,32029N/Acolumns onlylive
CMS QualityNet readmission-methodology source assets
medicare_silver.qualitynet_methodology_source_asset
6935N/Acolumns onlylive
CMS QualityNet readmission-methodology spreadsheet rows
medicare_silver.qualitynet_methodology_table_row
2,498,68242N/Acolumns onlylive
CMS NCCI Procedure-to-Procedure (PTP) edits — quarterly editions, practitioner and hospital, stamped
medicare_silver.ref_ncci_ptp_edit
4,506,52728N/Acolumns onlylive
CMS public Medicare claim reference codes
medicare_silver.resdac_claim_code
38232N/Acolumns onlylive
ResDAC / CMS claim-reference governed source-asset ledger
medicare_silver.resdac_claim_reference_source_asset
4335N/Acolumns onlylive
CMS Medicare specialty to provider taxonomy crosswalk history
medicare_silver.resdac_specialty_taxonomy_crosswalk
12,90029N/Acolumns onlylive
SNF cost reports, by department
medicare_silver.snf_cost_report_dept
101,7178N/Acolumns onlylive
SNF cost reports, overall
medicare_silver.snf_cost_report_overall
14,69812N/Acolumns onlylive
MA snp data
medicare_silver.snp_data
N/A222026-04cardlive
Special Needs Plans by plan and month, parse revision 3 (D-SNP integration status, small-cell bounds, Under-11 rows)
medicare_silver.snp_data_v2
195,62831N/Acolumns onlylive
SNP HEDIS general file (plan x report year), 2019-2025
medicare_silver.snp_hedis_general
4,93631N/Acolumns onlylive
SNP HEDIS measure rates (plan x indicator), 2019-2025
medicare_silver.snp_hedis_measures
211,29921N/Acolumns onlylive
SNP HEDIS risk-adjusted utilization (plan x indicator), 2021-2025
medicare_silver.snp_hedis_rau_measures
52,66820N/Acolumns onlylive
SNP HEDIS service area (plan x county), 2019-2025
medicare_silver.snp_hedis_service_area
124,27317N/Acolumns onlylive
MA Star Ratings — Categorical Adjustment Index
medicare_silver.stars_cai
N/A21rating_year 2026 (effective_period_start 2025-10-10)cardlive
MA Star Ratings — contract metadata
medicare_silver.stars_contracts
N/A25RY2026 (effective_period_start 2025-10-10)cardlive
MA Star Ratings — measure cut points
medicare_silver.stars_cutpoints
N/A24rating_year 2026 (effective_period_start 2025-10-10)cardlive
Part C and D Star Ratings Display Measures, per contract and measure, RY2012-2026
medicare_silver.stars_display_measures
549,60527N/Acolumns onlylive
MA Star Ratings — per-measure value + star
medicare_silver.stars_ratings_measure
N/A26RY2026 (effective_period_start 2025-10-10; performance_year 2024). Coverage: 2007, 2008, then 2014-2026 continuous (2009-2013 absent).cardlive
Medicare Advantage Star Ratings (summary)
medicare_silver.stars_ratings_summary
29,28223N/Acolumns onlylive
State Service Area (every contract by state), 2006-2026
medicare_silver.state_service_area
2,311,99519N/Acolumns onlylive
CMS MA / Part D Landscape with the true contract year (corrected Plan and Premium year)
medicare_silver.vw_ma_landscape_contract_year_v20261013a
2,880,98590N/Acolumns onlylive
MA pbp mrx, current parse revision per year and quarter
medicare_silver.vw_pbp_mrx_current_v20261013a
270,466368N/Acolumns onlypartial
X12 healthcare code-list source-limit ledger
medicare_silver.x12_code_list_asset
1635N/Acolumns onlylive
Medicare contract dimension
vlada_curated.dim_contract
2,16614N/Acolumns onlylive
IPPS hospital base payment per DRG weight, by hospital and fiscal year
vlada_curated.vw_ipps_hospital_base
81,02910N/Acolumns onlylive
Medicare benchmark view (allowed by code × class)
vlada_curated.vw_medicare_benchmark
N/A5N/Acolumns onlylive
Medicare benchmark, effective-dated (what Medicare would have paid on a date)
vlada_curated.vw_medicare_benchmark_effective
1,077,58215N/Acolumns onlylive

Hospital price transparency (23)

TableRowsColumnsLatestCardStatus
CMS Care Compare Hospital General Information (overall star rating per CCN)
medicare_silver.dim_hospital_quality
5,43229N/Acolumns onlylive
CMS Hospital-Acquired Condition Reduction Program (HACRP)
medicare_silver.fact_hacrp
3,05551N/Acolumns onlylive
CMS Care Compare Hospital Quality Measures (mortality / readmissions / timely / infections / imaging / maternal)
medicare_silver.fact_hospital_quality_measure
510,08433N/Acolumns onlylive
CMS Hospital Service Area (referral geography by CCN × ZIP)
medicare_silver.fact_hospital_service_area
1,155,77721N/Acolumns onlylive
CMS Hospital Readmissions Reduction Program (HRRP)
medicare_silver.fact_hrrp
245,91428N/Acolumns onlylive
CMS Hospital Value-Based Purchasing (HVBP) Total Performance Score
medicare_silver.fact_hvbp
2,45529N/Acolumns onlylive
Medicare Inpatient Hospitals by Geography (avg payments per MS-DRG)
medicare_silver.fact_inpatient_payment_by_geo
331,46425N/Acolumns onlylive
Medicare Outpatient Hospitals by Geography (avg payments per APC/HCPCS)
medicare_silver.fact_outpatient_payment_by_geo
758,77631N/Acolumns onlylive
States W2 Facilities, ownership + finances: state_facility_v1
medicare_silver.state_facility_v1
239,61648N/Acolumns onlypartial
Raw HPT machine-readable files (bronze)
s3://vlada-platform-raw/hospital
N/AN/AN/Acolumns onlylive
Hospital chargemaster + payer-specific rates (HPT)
vlada_curated.fact_hospital_chargemaster
4,350,000,00098N/Acolumns onlylive
Hospital price rollup by code x state x payer parent x line of business
vlada_curated.mart_code_state_payer_rollup
N/A17N/Acolumns onlylive
Hospital price rollup by code x state x line of business
vlada_curated.mart_code_state_rollup
N/A17N/Acolumns onlylive
Hospital price-cell mart
vlada_curated.mart_hospital_cell
N/A29N/Acolumns onlylive
Hospital department cost ratios from Medicare cost reports (latest fiscal year per department)
vlada_curated.mart_hospital_dept_ccr
138,4586N/Acolumns onlylive
Hospital department cost ratio history from Medicare cost reports (FY2011-2024)
vlada_curated.mart_hospital_dept_ccr_history
1,359,0257N/Acolumns onlylive
States W3 Networks + affiliations: state_affiliation_edge_v1
vlada_curated.state_affiliation_edge_v1
7,013,68526N/Acolumns onlypartial
States W5 Pricing coverage: state_pricing_coverage_v1
vlada_curated.state_pricing_coverage_v1
256,22331N/Acolumns onlypartial
States W6 Quality: state_quality_v1
vlada_curated.state_quality_v1
538,61634N/Acolumns onlypartial
Hospital chargemaster — canonical view
vlada_curated.vw_fact_hospital_chargemaster_canonical
N/A43N/Acolumns onlylive
Hospital chargemaster — comparable view (real-negotiated, classified)
vlada_curated.vw_fact_hospital_chargemaster_comparable
N/A33N/Acolumns onlylive
Hospital chargemaster — current (full, wide) view
vlada_curated.vw_fact_hospital_chargemaster_current
N/A98N/Acolumns onlylive
Hospital price comparison mart (answered layer)
vlada_curated.vw_hospital_comparison_mart
N/A60N/Acolumns onlylive

Insurer negotiated rates (92)

TableRowsColumnsLatestCardStatus
Covered California enrollment profiles — state publisher history
ca_covered_california_enrollment_profiles
13,941N/AN/Acolumns onlypartial
CMS independent State-based Exchange QHP PUF packages - plan, benefit and premium detail for the states not on HealthCare.gov (PY2016-PY2026)
cms_independent_sbe_packages
20,911,204N/AN/Acolumns onlylive
Commercial Insurer MLR — issuer identity / NAIC crosswalk (CMS MLR PUF)
insurer_silver.dim_insurer_mlr_identity
20,33629N/Acolumns onlylive
Commercial Insurer MLR — financial facts (CMS MLR PUF)
insurer_silver.fact_insurer_mlr
27,25439N/Acolumns onlylive
Commercial Insurer MLR: current read surface (financials joined to issuer identity)
insurer_silver.vw_insurer_mlr_current
18,81842N/Acolumns onlylive
Kentucky KHBE Governor's Metrics — monthly state publisher history
ky_khbe_governors_metrics
159,920N/AN/Acolumns onlypartial
HHS risk adjustment transfers by issuer, one report revision per benefit year and appendix (current view)
medicare_semantic.vw_aca_risk_adjustment_transfer_current_v1
14,41543N/Acolumns onlypartial
CMS CCIIO Benefits & Cost Sharing PUF — Marketplace benefit-template history
medicare_semantic.vw_benefits_cost_sharing_current
19,692,05143N/Acolumns onlylive
CMS CCIIO Business Rules PUF — Marketplace rating-rule history
medicare_semantic.vw_business_rules_puf_current
N/A27N/Acolumns onlylive
CMS QHP Enrollee Survey PUF: current read surface (one CMS artifact per plan year)
medicare_semantic.vw_enrollee_survey_puf_current_v1
1,58639N/Acolumns onlylive
Marketplace premium tax credit by county, age and income (vw_hix_after_credit_v1)
medicare_semantic.vw_hix_after_credit_v1
N/A17N/Acolumns onlypartial
Marketplace benchmark change, every year pair (vw_hix_benchmark_change_v1)
medicare_semantic.vw_hix_benchmark_change_v1
N/A34N/Acolumns onlypartial
Marketplace county benchmark at every age (vw_hix_county_benchmark_ages_v1)
medicare_semantic.vw_hix_county_benchmark_ages_v1
N/A17N/Acolumns onlypartial
Marketplace county benchmark: lowest and second-lowest silver (vw_hix_county_benchmark_v1)
medicare_semantic.vw_hix_county_benchmark_v1
N/A24N/Acolumns onlypartial
Marketplace market structure by parent and county (vw_hix_market_structure_v1)
medicare_semantic.vw_hix_market_structure_v1
N/A17N/Acolumns onlypartial
Marketplace plans sold in each county (vw_hix_plan_county_v1)
medicare_semantic.vw_hix_plan_county_v1
N/A11N/Acolumns onlypartial
Marketplace premiums by plan, rating area and age (vw_hix_plan_premium_v1)
medicare_semantic.vw_hix_plan_premium_v1
N/A18N/Acolumns onlypartial
Marketplace plans, every jurisdiction and year (vw_hix_plan_v1)
medicare_semantic.vw_hix_plan_v1
N/A28N/Acolumns onlypartial
State-based exchange enrollment observations - seven state marketplaces' own published figures, one view
medicare_semantic.vw_hix_state_enrollment_observation_v1
232,58949N/Acolumns onlypartial
CMS CCIIO Machine Readable URL PUF, redacted: issuer index URLs per plan year, no contact fields
medicare_semantic.vw_machine_readable_url_puf_redacted_v1
4,04527N/Acolumns onlylive
Marketplace enrollment by parent company (state, national, federal vs SBM)
medicare_semantic.vw_marketplace_enrollment_by_parent_v1
10,35319N/Acolumns onlylive
CMS Nationwide QRS PUF: current read surface (one CMS artifact per plan year)
medicare_semantic.vw_nationwide_qrs_puf_current
1,98639N/Acolumns onlylive
CMS CCIIO Network PUF — issuer network metadata history
medicare_semantic.vw_network_puf_current
N/A24N/Acolumns onlylive
CMS CCIIO Plan Attributes PUF — Marketplace plan definition history
medicare_semantic.vw_plan_attributes_puf_current
N/A31N/Acolumns onlylive
CMS CCIIO Plan ID Crosswalk PUF — directed plan-year continuity history
medicare_semantic.vw_plan_id_crosswalk_puf_current
N/A37N/Acolumns onlylive
CMS Marketplace Quality PUF: current read surface (one CMS artifact per plan year)
medicare_semantic.vw_quality_puf_current
35,75239N/Acolumns onlylive
States K2 Rate filing book: vw_rate_filing_market_v1
medicare_semantic.vw_rate_filing_market_v1
12,967100N/Acolumns onlypartial
States K2 Rate filing book: vw_rate_filing_yoy_drivers_v1
medicare_semantic.vw_rate_filing_yoy_drivers_v1
11,18757N/Acolumns onlypartial
CMS CCIIO Rate PUF: current read surface (one CMS ZIP revision per plan year)
medicare_semantic.vw_rate_puf_current
36,535,87233N/Acolumns onlylive
States K2 Rate filing book: vw_rate_review_puf_current_v1
medicare_semantic.vw_rate_review_puf_current_v1
1,030,34853N/Acolumns onlypartial
CMS CCIIO Service Area PUF — Marketplace plan geography history
medicare_semantic.vw_service_area_puf_current
N/A26N/Acolumns onlylive
HHS risk adjustment transfers by issuer (summary report appendices C and D), BY2021-BY2025
medicare_silver.fact_aca_risk_adjustment_transfer_history
17,32243N/Acolumns onlypartial
CMS QHP Enrollee Survey PUF — nationwide reporting-unit survey history
medicare_silver.fact_enrollee_survey_puf_history
1,58639N/Acolumns onlylive
Exchange Plan Profile — composed ACA marketplace plan brain
medicare_silver.fact_exchange_plan_profile
60,59135N/Acolumns onlylive
Exchange Plan Profile v2: composed ACA marketplace plan brain, rebuilt from the CMS Rate PUF ZIPs
medicare_silver.fact_exchange_plan_profile_v2
60,59135N/Acolumns onlylive
CMS Federal IDR Air Ambulance determinations
medicare_silver.fact_idr_air_ambulance_determination
104,38377N/Acolumns onlylive
CMS Federal IDR (No Surprises Act) bi-monthly operations reports: disputes initiated and closed
medicare_silver.fact_idr_bimonthly_status
16933N/Acolumns onlylive
CMS Federal IDR (No Surprises Act) Determinations — OON arbitration fair price
medicare_silver.fact_idr_determination
8,233,90377N/Acolumns onlylive
CMS Federal IDR QPA and offers
medicare_silver.fact_idr_qpa_offer
11,346,21955N/Acolumns onlylive
CMS Federal IDR Supplemental top disputing parties
medicare_silver.fact_idr_supplemental_party
48040N/Acolumns onlylive
CMS Federal IDR prevailing offers by QPA cost band
medicare_silver.fact_idr_supplemental_qpa_band
7230N/Acolumns onlylive
CMS Federal IDR prevailing offers by specialty
medicare_silver.fact_idr_supplemental_specialty
32131N/Acolumns onlylive
CMS Federal IDR Supplemental initiations by state
medicare_silver.fact_idr_supplemental_state
67229N/Acolumns onlylive
CMS Federal IDR Supplemental summary and outcome tables
medicare_silver.fact_idr_supplemental_summary
40935N/Acolumns onlylive
CMS CCIIO Machine Readable URL PUF — restricted issuer URL assertion history
medicare_silver.fact_machine_readable_url_puf_history
N/A37N/Acolumns onlylive
CMS Marketplace issuer geography enrollment measure history
medicare_silver.fact_marketplace_issuer_geography_enrollment_measure_history
3,296,58440N/Acolumns onlylive
CMS Marketplace monthly effectuated enrollment release history
medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history
6,58827N/Acolumns onlylive
CMS Marketplace issuer and plan enrollment measure history
medicare_silver.fact_marketplace_plan_enrollment_measure_history
233,90640N/Acolumns onlylive
CMS Nationwide QRS PUF — Exchange reporting-unit quality history
medicare_silver.fact_nationwide_qrs_puf_history
1,98639N/Acolumns onlylive
CMS CCIIO Quality PUF — Marketplace QHP quality star ratings
medicare_silver.fact_quality_puf_history
35,75239N/Acolumns onlylive
CMS CCIIO Rate PUF — ACA Marketplace QHP plan premium rates
medicare_silver.fact_rate_puf
32,902,28335N/Acolumns onlylive
CMS CCIIO Rate PUF: lossless revision history from the CMS ZIPs, PY2014-2026
medicare_silver.fact_rate_puf_history
36,535,87257N/Acolumns onlylive
CCIIO Unified Rate Review PUF (URRT Part I) - filings, plans and rating-area factors, PY2024-PY2026
medicare_silver.fact_rate_review_puf_history
285,55453N/Acolumns onlypartial
CMS independent state-based exchange Benefits and Cost Sharing PUF: lossless history, PY2016-2026
medicare_silver.fact_sbe_benefits_cost_sharing_puf_history
8,401,52475N/Acolumns onlylive
CMS independent state-based exchange Business Rules PUF: lossless history, PY2016-2026
medicare_silver.fact_sbe_business_rules_puf_history
219,04745N/Acolumns onlylive
CMS independent state-based exchange Network PUF: lossless history, PY2016-2026
medicare_silver.fact_sbe_network_puf_history
5,29250N/Acolumns onlylive
CMS independent state-based exchange Plan Attributes PUF: lossless history, PY2016-2026
medicare_silver.fact_sbe_plan_attributes_puf_history
113,00551N/Acolumns onlylive
CMS independent state-based exchange Rate PUF: lossless history, PY2016-2026
medicare_silver.fact_sbe_rate_puf_history
12,056,66457N/Acolumns onlylive
CMS independent state-based exchange Service Area PUF: lossless history, PY2016-2026
medicare_silver.fact_sbe_service_area_puf_history
115,67257N/Acolumns onlylive
CMS Transparency in QHP Coverage PUF — partial Individual QHP serving derivative
medicare_silver.fact_tc_puf_issuer_claims
25,66660N/Acolumns onlylive
CMS CCIIO Transparency in Coverage PUF — QHP claims transparency (multi-sheet XLSX)
medicare_silver.fact_transparency_in_coverage_puf_history
40,22237N/Acolumns onlylive
CMS rate review site (ratereview.healthcare.gov): ACA individual and small-group rate filings, requested and final average rate change, PY2019-2027
medicare_silver.fact_urr_submission_history
11,09554N/Acolumns onlylive
Virginia BOI balance billing arbitration reports: state IDR outcomes, offers, awards, OON claims
medicare_silver.fact_va_boi_balance_billing_arbitration
1,63742N/Acolumns onlylive
Marketplace products, published CSV behind vw_hix_benchmark_change_v1 (hix_benchmark_change_v1)
medicare_silver.hix_benchmark_change_v1
N/A34N/Acolumns onlypartial
Marketplace products, published CSV behind vw_hix_county_benchmark_ages_v1 (hix_county_benchmark_ages_v1)
medicare_silver.hix_county_benchmark_ages_v1
N/A17N/Acolumns onlypartial
Marketplace products, published CSV behind vw_hix_county_benchmark_v1 (hix_county_benchmark_v1)
medicare_silver.hix_county_benchmark_v1
N/A24N/Acolumns onlypartial
Premium tax credit applicable percentages 2014-2027 (hix_credit_schedule_v1)
medicare_silver.hix_credit_schedule_v1
N/A8N/Acolumns onlypartial
Marketplace products, published CSV behind vw_hix_market_structure_v1 (hix_market_structure_v1)
medicare_silver.hix_market_structure_v1
N/A17N/Acolumns onlypartial
Marketplace products, published CSV behind vw_hix_plan_county_v1 (hix_plan_county_v1)
medicare_silver.hix_plan_county_v1
N/A11N/Acolumns onlypartial
HHS poverty guidelines 2013-2026 (hix_poverty_guidelines_v1)
medicare_silver.hix_poverty_guidelines_v1
N/A6N/Acolumns onlypartial
Marketplace products, published CSV behind vw_hix_plan_premium_v1 (2027 state-run rows) (hix_sbe2027_state_rates_v1)
medicare_silver.hix_sbe2027_state_rates_v1
N/A16N/Acolumns onlypartial
Marketplace products, published CSV behind vw_hix_plan_county_v1 (2027 state-run rows) (hix_sbe2027_state_service_area_v1)
medicare_silver.hix_sbe2027_state_service_area_v1
N/A8N/Acolumns onlypartial
States K8 Forward exposure: marketplace_forward_exposure_v1
medicare_silver.marketplace_forward_exposure_v1
19,53033N/Acolumns onlypartial
Marketplace issuer-to-parent bridge (effective-dated, as-was and as-now)
medicare_silver.marketplace_issuer_parent_bridge_v1
8,67639N/Acolumns onlylive
States K5 Ownership / affiliation / delegation: marketplace_issuer_parent_v1
medicare_silver.marketplace_issuer_parent_v1
8,67642N/Acolumns onlypartial
States K6 Premium + benefit book: marketplace_sbe_slcsp_county_v1
medicare_silver.marketplace_sbe_slcsp_county_v1
1,73846N/Acolumns onlypartial
States K1H SBM enrollment history: marketplace_sbm_issuer_enrollment_history_v1
medicare_silver.marketplace_sbm_issuer_enrollment_history_v1
1,71526N/Acolumns onlypartial
States K3 Rate review cycle + state rules: marketplace_state_calendar_rule_v1
medicare_silver.marketplace_state_calendar_rule_v1
3,50920N/Acolumns onlypartial
States K4 Participation / certification tracker: marketplace_state_participation_event_v1
medicare_silver.marketplace_state_participation_event_v1
2,74027N/Acolumns onlypartial
States K3 Rate review cycle + state rules: marketplace_state_rate_decision_v1
medicare_silver.marketplace_state_rate_decision_v1
16,00131N/Acolumns onlypartial
Texas TDI Independent Dispute Resolution (SB 1264) summary data: monthly mediation and arbitration counts, every captured daily edition
medicare_silver.vw_fact_tx_tdi_idr_summary
5,25432N/Acolumns onlylive
New Jersey DOBI IHC enrollment — on/off-exchange history
nj_dobi_ihc_enrollment
30,198N/AN/Acolumns onlypartial
Get Covered New Jersey enrollment — state exchange history
nj_getcoverednj_enrollment
863N/AN/Acolumns onlypartial
NY State of Health enrollment reports — direct publisher history
ny_nysoh_enrollment_data
25,191N/AN/Acolumns onlypartial
Raw TiC machine-readable files (bronze)
s3://vlada-platform-raw/commercial_v2
N/AN/AN/Acolumns onlypartial
Virginia Insurance Marketplace enrollment metrics — state publisher history
va_vim_enrollment_metrics
286N/AN/Acolumns onlypartial
Payer dimension + carrier hierarchy
vlada_curated.dim_payer
N/A68N/Acolumns onlylive
Commercial negotiated rates (TiC)
vlada_curated.fact_rate
N/A54N/Acolumns onlypartial
Canonical-graph rate lookup index
vlada_curated.idx_rate_lookup
N/AN/AN/Acolumns onlypartial
Commercial gold mart — rate by entity
vlada_curated.mart_rate_by_entity
N/A162026-04 (single snapshot; loaded_at is a single constant 2026-04-23 18:07:41 UTC for all 140.36M rows)cardlive
Commercial rate ↔ provider (NPI) edge
vlada_curated.rate_provider_edge
N/A132026-04-23 (loaded_at); data vintage version_id=2026-04cardlive
Washington Health Benefit Exchange enrollment reports — state publisher history
wa_hbe_enrollment_reports
2,190N/AN/Acolumns onlypartial

Provider identity (39)

TableRowsColumnsLatestCardStatus
NLM AccessGUDID — Device Identity (FDA Global UDI Database)
drug_silver.dim_device_udi
5,129,24141N/Acolumns onlylive
CMS Facility Affiliation (Doctors & Clinicians) — NPI→CCN bridge
drug_silver.dim_facility_affiliation
N/A252026-05-19cardlive
HHS-OIG Corporate Integrity Agreements (CIA)
drug_silver.dim_hhs_oig_cia
N/A222026-05-04 (latest CIA effective_date); snapshot observed/scraped 2026-05-19cardlive
HRSA 340B Covered Entity Registry (OPAIS)
drug_silver.dim_hrsa_covered_entity
92,814332026-05-15cardlive
NUCC Healthcare Provider Taxonomy Code Set
drug_silver.dim_nucc_taxonomy
N/A232026-05-18 (current ingestion; is_current=true). Both snapshots are the SAME NUCC release v251 — same sha256 content hash — so there is no real time series, just two load dates.cardlive
OIG List of Excluded Individuals/Entities (LEIE)
drug_silver.dim_oig_leie
249,886352026-05-18 (observed_period of the current snapshot, is_current=true). Only 2 snapshots exist and they are content-identical.cardlive
HRSA 340B Covered Entity → NPI bridge
drug_silver.fact_hrsa_ce_npi
N/A182026-05-15 (single snapshot)cardlive
CMS Dialysis Facility quality (five-star + facility attributes)
medicare_silver.dim_dialysis_facility_quality
7,55730N/Acolumns onlylive
CMS POS Federally Qualified Health Center Roster
medicare_silver.dim_fqhc
15,32426N/Acolumns onlylive
CMS POS Home Health Agency Roster
medicare_silver.dim_hha
23,56226N/Acolumns onlylive
CMS POS Hospice Roster
medicare_silver.dim_hospice
9,24026N/Acolumns onlylive
CMS PECOS Public Provider Enrollment — IDTF (imaging) Roster
medicare_silver.dim_imaging_facility
N/A26N/Acolumns onlylive
CMS POS Inpatient Rehabilitation Facility Roster
medicare_silver.dim_irf
66626N/Acolumns onlylive
CMS POS Long-Term Care Hospital Roster
medicare_silver.dim_ltch
65526N/Acolumns onlylive
Medicare Diabetes Prevention Program (MDPP) Suppliers
medicare_silver.dim_mdpp_supplier
1,03727N/Acolumns onlylive
CMS POS Rural Health Clinic Roster
medicare_silver.dim_rhc
12,86426N/Acolumns onlylive
CMS POS Skilled Nursing Facility Roster
medicare_silver.dim_snf
17,06726N/Acolumns onlylive
CMS Facility Organization NPI to CCN Crosswalk
medicare_silver.facility_npi_ccn_xref
N/A22N/Acolumns onlylive
HRSA Health Professional Shortage Areas (HPSA) — PC / Dental / Mental Health
medicare_silver.fact_hpsa
1,040,13844N/Acolumns onlylive
CMS Medicare FFS Public Provider Enrollment (PECOS NPI↔enrollment bridge)
medicare_silver.fact_pecos_enrollment
2,981,79926N/Acolumns onlylive
CMS Provider of Services (POS) File — facility characteristics + bed counts
medicare_silver.fact_provider_of_services
44,42944N/Acolumns onlylive
CMS PECOS Provider Ownership ("All Owners", PE-rollup layer)
medicare_silver.fact_provider_ownership
814,24256N/Acolumns onlylive
Care-site geography (CCN → CBSA/county/ZIP)
vlada_curated.care_site_geo
N/A9N/Acolumns onlylive
CMS POS Ambulatory Surgical Center Roster
vlada_curated.dim_asc
N/A27N/Acolumns onlylive
Care-Site Spine (NPI/CCN-keyed facility identity)
vlada_curated.dim_care_site
N/A30N/Acolumns onlylive
CCN → CBSA + Wage Index crosswalk
vlada_curated.dim_ccn_cbsa
N/A4N/Acolumns onlylive
CMS POS-CLIA Clinical Laboratory Roster
vlada_curated.dim_clia_lab
N/A29N/Acolumns onlylive
CMS Medicare Dialysis Facilities Roster
vlada_curated.dim_dialysis_facility
125,40826N/Acolumns onlylive
Facility dimension
vlada_curated.dim_facility
N/A112N/Acolumns onlypartial
Health System list
vlada_curated.dim_health_system
N/A4N/Acolumns onlylive
Hospital Identity Crosswalk — CCN ↔ NPI ↔ EIN bridge
vlada_curated.dim_hospital_external
N/A40N/Acolumns onlylive
Hospital System Hierarchy (parent / ultimate parent / ownership)
vlada_curated.dim_hospital_system
N/A35static (single 2023-vintage snapshot)cardlive
NPPES provider directory
vlada_curated.dim_provider
9,798,75817N/Acolumns onlylive
Medicare provider CCN dimension (all provider types)
vlada_curated.dim_provider_ccn
101,5285N/Acolumns onlylive
Provider → Facility affiliation (curated)
vlada_curated.dim_provider_facility_affiliation
N/A5N/Acolumns onlylive
Medicare PUF (NPI x HCPCS utilization)
vlada_curated.dim_provider_service
14,161,97415N/Acolumns onlylive
Care-site verification (county-fleet promoted truth)
vlada_curated.fact_care_site_verification
N/A11N/Acolumns onlylive
CCN <-> NPI facility bridge
vlada_curated.provider_facility_xref
N/A8N/Acolumns onlylive
Care-site verified view (enriched)
vlada_curated.vw_care_site_verified
N/A12N/Acolumns onlylive

Drugs and formularies (65)

TableRowsColumnsLatestCardStatus
FDA Drug Master Files (DMF)
drug_silver.dim_dmf
N/A212026-05-18 (current snapshot; latest submit_date 2026-03-31)cardlive
FDA NDC Directory (drug product dimension)
drug_silver.dim_drug
N/A382026-06-01cardlive
FDA Drug Applications (NDA/ANDA/BLA dimension)
drug_silver.dim_drug_application
N/A232026-05-28cardlive
FDA Structured Product Labels (SPL) — drug label dimension
drug_silver.dim_drug_label
N/A30Label-content: 2027-01-27 (future-dated labels exist). Latest snapshot (observed_period / vintage): 2026-05-28.cardlive
FDA Orange Book (patents + exclusivity)
drug_silver.dim_orange_book_product
N/A30N/Acolumns onlypartial
Part D plan dimension (CMS SPUF)
drug_silver.dim_part_d_plan
160,92229N/Acolumns onlylive
FDA Purple Book — licensed biologics + biosimilars (silver)
drug_silver.dim_purple_book_product
N/A38N/Acolumns onlypartial
NLM RxClass — drug class dimension
drug_silver.dim_rxclass_class
N/A182026-06-03cardlive
ASP NDC-HCPCS Crosswalk — Medicare Part B drug-identity bridge (raw CMS drop)
drug_silver.fact_asp_ndc_hcpcs_crosswalk
7,36627N/Acolumns onlylive
NADAC — National Average Drug Acquisition Cost
drug_silver.fact_drug_acquisition_cost
16,260,11529N/Acolumns onlylive
ASP Pricing File — Medicare Part B quarterly ASP (raw CMS drop)
drug_silver.fact_drug_asp_quarterly
18,02727N/Acolumns onlylive
ASP — Medicare Part B drug Average Sales Price
drug_silver.fact_drug_asp_quarterly#drug_asp
18,027N/AN/Acolumns onlylive
ASP Pricing File, Medicare Part B quarterly payment limits (parse revision 2, every CMS revision kept)
drug_silver.fact_drug_asp_quarterly_v2
55,03531N/Acolumns onlylive
Clinical Trials (ClinicalTrials.gov, drug-regulated)
drug_silver.fact_drug_clinical_trial
N/A34study_first_post_date 2026-06-02 (data_year 2026). Single ingest snapshot taken 2026-06-03 (observed_period/asserted_at).cardlive
Consumer cash-price reference (Cost Plus Drugs snapshot)
drug_silver.fact_drug_consumer_price
2,38633N/Acolumns onlypartial
CMS Medicare Part B Discarded Drug Units (JW/JZ waste)
drug_silver.fact_drug_discarded_units
82424N/Acolumns onlylive
Part D formulary coverage (CMS SPUF)
drug_silver.fact_drug_formulary
42,858,10628N/Acolumns onlylive
Part D formulary exclusion list (CMS SPUF)
drug_silver.fact_drug_formulary_excluded
355,14027N/Acolumns onlylive
Part D excluded-drug coverage in the coverage gap (GAP_COV), CMS SPUF sidecar, 2019-Q1 to 2024-Q3
drug_silver.fact_drug_formulary_excluded_gap_coverage
268,56721N/Acolumns onlylive
Part D excluded drugs covered as a supplemental benefit, monthly (CMS)
drug_silver.fact_drug_formulary_excluded_monthly
1,103,41528N/Acolumns onlylive
WAC increases — California HCAI SB 17 notices
drug_silver.fact_drug_hcai_sb17_wac_increase
N/A49N/Acolumns onlypartial
Medicaid Drug Rebate Program — product file
drug_silver.fact_drug_medicaid_rebate_product
N/A392026-01-01 (2026 Q1)cardlive
Medicaid State Drug Utilization (by state × NDC × quarter)
drug_silver.fact_drug_medicaid_utilization
N/A302024-Q4 (effective_period_start 2024-10-01); 20 consecutive quarters, ~1.2-1.3M rows eachcardlive
CMS Open Payments (Sunshine Act)
drug_silver.fact_drug_payment_to_prescriber
56,372,43827N/Acolumns onlylive
FDA Drug Recalls (Enforcement Reports)
drug_silver.fact_drug_recall
N/A452026-05-27 (latest report_date; latest recall_initiation_date 2026-05-12) — data as of the single snapshot asserted_at 2026-06-02cardlive
IRA Maximum Fair Price (CMS-negotiated)
drug_silver.fact_drug_reimbursement#ira_mfp
N/AN/AN/Acolumns onlylive
FDA Drug Shortages
drug_silver.fact_drug_shortage
1,733302026-06-01cardlive
Medicare Part B Drug Spending (by HCPCS × year)
drug_silver.fact_drug_spending_part_b
3,164312023cardlive
Medicare Part D Spending by Drug (PUF)
drug_silver.fact_drug_spending_part_d
N/A302023cardlive
VA Federal Supply Schedule (FSS) drug prices
drug_silver.fact_drug_va_fss_price
N/A332026-03-02cardlive
FDA FAERS — Adverse-Event Drug Involvement (DRUG file)
drug_silver.fact_faers_drug
11,131,45335N/Acolumns onlylive
FDA Warning Letters
drug_silver.fact_fda_warning_letter
3,673232026-04-21 (latest letter_issue_date; posted_date extends to 2026-04-28)cardlive
Form 5500 filings (DOL EFAST2 main filing)
drug_silver.fact_form5500_filing
4,330,52572N/Acolumns onlylive
Form 5500 Schedule H plan financials (claims paid, admin expenses, assets)
drug_silver.fact_form5500_financials
1,513,01933N/Acolumns onlylive
Form 5500 Schedule A insurance contracts (carrier, premiums, broker totals)
drug_silver.fact_form5500_insurance
5,112,37343N/Acolumns onlylive
Form 5500 Schedule A named brokers (per-broker commission and fees paid)
drug_silver.fact_form5500_insurance_broker
6,733,60626N/Acolumns onlylive
Form 5500 Schedule C service providers (PBM compensation)
drug_silver.fact_form5500_service_provider
4,147,90728N/Acolumns onlylive
Form 5500 — service provider codes (Schedule C)
drug_silver.fact_form5500_service_provider_code
10,564,656202024 (plan_year 2024 / effective_period_start 2024-01-01)cardlive
FDA Orange Book — exclusivity
drug_silver.fact_orange_book_exclusivity
N/A202026-04-01cardlive
FDA Orange Book — patents
drug_silver.fact_orange_book_patent
N/A252026-04-01cardlive
Part D indication-based coverage (CMS SPUF member), 2020-Q1 to 2026-Q2
drug_silver.fact_part_d_indication_based_coverage
10,66920N/Acolumns onlylive
Part D insulin beneficiary cost sharing (CMS SPUF member), 2023-Q4 to 2026-Q2
drug_silver.fact_part_d_insulin_cost_share
441,00629N/Acolumns onlylive
Part D pharmacy networks and dispensing fees, CMS SPUF member, 2019-Q1 to 2026-Q3
drug_silver.fact_part_d_pharmacy_network
10,248,730,90036N/Acolumns onlylive
Part D plan cost-share (CMS SPUF)
drug_silver.fact_part_d_plan_cost_share
4,939,68941N/Acolumns onlylive
Part D tier coverage in the coverage gap (GAP_COV_TIER), CMS SPUF sidecar, 2019-Q1 to 2024-Q3
drug_silver.fact_part_d_plan_cost_share_gap_coverage
3,933,14923N/Acolumns onlylive
Part D plan beneficiary cost sharing, monthly (CMS)
drug_silver.fact_part_d_plan_cost_share_monthly
15,305,64742N/Acolumns onlylive
Part D plan drug pricing (CMS SPUF)
drug_silver.fact_part_d_plan_drug_pricing
1,593,644,61123N/Acolumns onlylive
Part D plan initial coverage limit (ICL), CMS SPUF sidecar, 2019-Q1 to 2024-Q3
drug_silver.fact_part_d_plan_initial_coverage_limit
127,08620N/Acolumns onlylive
Part D plan service area (CMS SPUF)
drug_silver.fact_part_d_plan_service_area
2,387,49921N/Acolumns onlylive
Part D plan service area (geographic locator), monthly (CMS)
drug_silver.fact_part_d_plan_service_area_monthly
7,581,44822N/Acolumns onlylive
Medicare Part D Prescriber PUF (prescribing by provider × drug × year)
drug_silver.fact_part_d_prescriber
103,105,990382023 (effective_period 2023-01-01 to 2023-12-31)cardlive
NLM RxClass — drug → class membership
drug_silver.fact_rxclass_membership
N/A22static (single snapshot, vintage rxclass_2026-06-03)cardlive
Part D plan dimension, monthly (CMS), plan type from CMS's organization type
drug_silver.vw_dim_part_d_plan_monthly_v3
499,05034N/Acolumns onlylive
Part D plan dimension, monthly (CMS), plan type from CMS's organization type, names as CMS wrote them
drug_silver.vw_dim_part_d_plan_monthly_v4
499,05036N/Acolumns onlylive
Part D plan dimension (CMS SPUF), plan type from CMS's organization type
drug_silver.vw_dim_part_d_plan_v3
166,44033N/Acolumns onlylive
Part D plan dimension (CMS SPUF), plan type from CMS's organization type, names as CMS wrote them
drug_silver.vw_dim_part_d_plan_v4
166,44035N/Acolumns onlylive
Part D formulary coverage, monthly (CMS), selected-drug flag only where CMS published it
drug_silver.vw_fact_drug_formulary_monthly_v2
130,452,18029N/Acolumns onlylive
Part D formulary coverage (CMS SPUF), selected-drug flag only where CMS published it
drug_silver.vw_fact_drug_formulary_v2
43,982,69229N/Acolumns onlylive
Medicare Part D Spending by Drug (PUF), the file's change and CAGR columns named for their window
drug_silver.vw_fact_drug_spending_part_d_v2
71,85336N/Acolumns onlylive
Part D plan cost share (CMS SPUF), days supply in days, era by contract year, catastrophic statutory-minimum tokens
drug_silver.vw_fact_part_d_plan_cost_share_v3
5,112,33153N/Acolumns onlylive
Part D plan drug pricing (CMS SPUF), per-unit price with the CY2019 cost-per-fill set apart and the era by contract year
drug_silver.vw_fact_part_d_plan_drug_pricing_v2
1,647,406,67529N/Acolumns onlylive
Medicare Part D Opioid Prescribing Rates by Geography, 2013-2024
medicare_silver.fact_part_d_opioid_prescribing_geo
359,13934N/Acolumns onlylive
Medicare Part D Prescribers by Provider (NPI x year), 2013-2024
medicare_silver.fact_part_d_prescriber_by_provider
14,636,994101N/Acolumns onlylive
Medicare Quarterly Part D Spending by Drug (preliminary), 2025-2026
medicare_silver.fact_part_d_spending_by_drug_quarterly
27,74831N/Acolumns onlylive
States W7 Employer coverage: state_employer_plan_v1
vlada_curated.state_employer_plan_v1
138,48849N/Acolumns onlypartial

State programs (156)

TableRowsColumnsLatestCardStatus
States M7 Forward exposure: vw_az_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_az_medicaid_mco_rate_procurement_exposure_v1
649N/Acolumns onlypartial
States M7 Forward exposure: vw_ca_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_ca_medicaid_mco_rate_procurement_exposure_v1
2243N/Acolumns onlypartial
States M7 Forward exposure: vw_fl_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_fl_medicaid_mco_rate_procurement_exposure_v1
2751N/Acolumns onlypartial
States M7 Forward exposure: vw_ga_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_ga_medicaid_mco_rate_procurement_exposure_v1
348N/Acolumns onlypartial
States M7 Forward exposure: vw_il_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_il_medicaid_mco_rate_procurement_exposure_v1
546N/Acolumns onlypartial
States M7 Forward exposure: vw_in_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_in_medicaid_mco_rate_procurement_exposure_v1
1247N/Acolumns onlypartial
States M7 Forward exposure: vw_ky_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_ky_medicaid_mco_rate_procurement_exposure_v1
550N/Acolumns onlypartial
States M7 Forward exposure: vw_la_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_la_medicaid_mco_rate_procurement_exposure_v1
558N/Acolumns onlypartial
Arizona Medicaid (AHCCCS) hospital payments, actual: inpatient, outpatient, DSH, GME, CAH, Prop202 and other components by hospital and year (FFY2019-2024)
medicare_semantic.vw_medicaid_az_provider_actual_payments_v1
4,46122N/Acolumns onlypartial
Louisiana Medicaid hospital payments, actual: DSH and supplemental payments by hospital, year-to-date snapshots (LDH legislative report item F, SFY2023-2026)
medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1
11933N/Acolumns onlypartial
States M1L Limited benefit plans: vw_medicaid_limited_benefit_parent_state_month_v1
medicare_semantic.vw_medicaid_limited_benefit_parent_state_month_v1
30,22513N/Acolumns onlypartial
National Medicaid MCO enrollment ledger - every state's reported plan enrollment observations, one view
medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v5
2,895,71932N/Acolumns onlypartial
National Medicaid MCO enrollment ledger - every state's reported plan enrollment observations, one view
medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6
2,900,49432N/Acolumns onlypartial
National Medicaid MCO enrollment ledger - every state's reported plan enrollment observations, one view
medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v7
N/A32N/Acolumns onlypartial
States M1 Enrollment tracker: vw_medicaid_mco_enrollment_tracker_v2_parent_dated_national_month
medicare_semantic.vw_medicaid_mco_enrollment_tracker_v2_parent_dated_national_month
30,06314N/Acolumns onlypartial
States M1 Enrollment tracker: vw_medicaid_mco_enrollment_tracker_v2_parent_dated_state_month
medicare_semantic.vw_medicaid_mco_enrollment_tracker_v2_parent_dated_state_month
52,96824N/Acolumns onlypartial
States M1 Enrollment tracker: vw_medicaid_mco_enrollment_tracker_v2_parent_national_month
medicare_semantic.vw_medicaid_mco_enrollment_tracker_v2_parent_national_month
29,02514N/Acolumns onlypartial
States M1 Enrollment tracker: vw_medicaid_mco_enrollment_tracker_v2_parent_state_month
medicare_semantic.vw_medicaid_mco_enrollment_tracker_v2_parent_state_month
51,87524N/Acolumns onlypartial
States M1 Enrollment tracker: vw_medicaid_mco_enrollment_tracker_v2_sec_tieout
medicare_semantic.vw_medicaid_mco_enrollment_tracker_v2_sec_tieout
684N/Acolumns onlypartial
States M6 Ownership + subcontracting: vw_medicaid_mco_ownership_bridge_v1
medicare_semantic.vw_medicaid_mco_ownership_bridge_v1
57723N/Acolumns onlypartial
Medicaid managed care market share by parent company, monthly, per state (component sums, not totals)
medicare_semantic.vw_medicaid_mco_parent_share_monthly
28,97029N/Acolumns onlypartial
Medicaid MCO parent share, monthly - build definition v3 (current; not door-served)
medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3
28,97028N/Acolumns onlypartial
Medicaid managed care rate timing by certified cycle and amendment
medicare_semantic.vw_medicaid_mco_rate_timing_v1
N/A24N/Acolumns onlypartial
Medicaid managed care upcoming rate-cycle events, next 18 months
medicare_semantic.vw_medicaid_mco_upcoming_rate_events_v1
N/A14N/Acolumns onlypartial
States M8 Federal reports + payments: vw_medicaid_mcpar_pdf_source_2025_v1
medicare_semantic.vw_medicaid_mcpar_pdf_source_2025_v1
1209N/Acolumns onlypartial
Medicaid plan appeals, State Fair Hearings, grievances and prior authorization by plan (CMS MCPAR, PY2023-2024)
medicare_semantic.vw_medicaid_mcpar_plan_appeals_v1
1,380101N/Acolumns onlylive
States M8 Federal reports + payments: vw_medicaid_mcpar_plan_pdf_2025_v1
medicare_semantic.vw_medicaid_mcpar_plan_pdf_2025_v1
40,59015N/Acolumns onlypartial
States M8 Federal reports + payments: vw_medicaid_mlr_plan_v1
medicare_semantic.vw_medicaid_mlr_plan_v1
1,92621N/Acolumns onlypartial
Oklahoma Medicaid provider payments, actual: DSH, practitioner PIP and FFS hospital access by provider and period (OHCA, 2021-2026)
medicare_semantic.vw_medicaid_ok_provider_actual_payments_v1
20,41326N/Acolumns onlypartial
Medicaid managed-care plan quality (HEDIS) by plan, 15 states, the newest three measurement years each publishes
medicare_semantic.vw_medicaid_plan_quality_measure_v1
5,69628N/Acolumns onlypartial
States M5 RFP / procurement tracker: vw_medicaid_procurement_contract_runway
medicare_semantic.vw_medicaid_procurement_contract_runway
22038N/Acolumns onlypartial
Medicaid managed-care procurement open and upcoming watch, sourced partial tracker
medicare_semantic.vw_medicaid_procurement_open_now
2214N/Acolumns onlypartial
Medicaid state directed payments, national: certified program-year amounts, operative version (42 CFR 438.6(c) preprints, 32 states)
medicare_semantic.vw_medicaid_sdp_program_year_operative_v1
72953N/Acolumns onlypartial
Texas directed-payment reconciliation calculations (TIPPS, DPP-BHS, RAPPS) by NPI, plan and state fiscal year: NOT payments
medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1
42,50337N/Acolumns onlypartial
Utah Medicaid provider payments, actual: DSH and nursing-facility / outpatient UPL by provider and period (DHHS, 2018-2026)
medicare_semantic.vw_medicaid_ut_provider_actual_payments_v1
2,06124N/Acolumns onlypartial
Utah Medicaid ACO directed payments to the University of Utah Medical Group, actual, by plan and service month (2021-2022)
medicare_semantic.vw_medicaid_ut_uumg_medical_group_payments_v1
7924N/Acolumns onlypartial
Virginia Medicaid hospital payments, actual: DSH, medical education, UPL and private-acute enhanced payments by hospital and state fiscal year (DMAS reports, SFY2016-2025)
medicare_semantic.vw_medicaid_va_hospital_actual_payments_v1
1,83140N/Acolumns onlypartial
Washington Medicaid provider payments, actual: DSH, HSNA, SDP managed-care / DPH and trauma payments by provider and period (HCA)
medicare_semantic.vw_medicaid_wa_provider_actual_payments_v1
8,70226N/Acolumns onlypartial
States M7 Forward exposure: vw_mi_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_mi_medicaid_mco_rate_procurement_exposure_v1
946N/Acolumns onlypartial
States M7 Forward exposure: vw_mn_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_mn_medicaid_mco_rate_procurement_exposure_v1
3243N/Acolumns onlypartial
States M7 Forward exposure: vw_mo_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_mo_medicaid_mco_rate_procurement_exposure_v1
345N/Acolumns onlypartial
States M7 Forward exposure: vw_ms_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_ms_medicaid_mco_rate_procurement_exposure_v1
346N/Acolumns onlypartial
States M7 Forward exposure: vw_nc_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_nc_medicaid_mco_rate_procurement_exposure_v1
850N/Acolumns onlypartial
States M7 Forward exposure: vw_nj_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_nj_medicaid_mco_rate_procurement_exposure_v1
549N/Acolumns onlypartial
New York Medicaid managed-care enrollment source-native observation projection
medicare_semantic.vw_ny_medicaid_mco_enrollment_tracker_reported_observation_v7_candidate_20261023t221902z_c5e4c8dc
66,70232N/Acolumns onlypartial
States M7 Forward exposure: vw_ny_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_ny_medicaid_mco_rate_procurement_exposure_v1
1243N/Acolumns onlypartial
States M7 Forward exposure: vw_oh_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_oh_medicaid_mco_rate_procurement_exposure_v1
643N/Acolumns onlypartial
States M7 Forward exposure: vw_ok_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_ok_medicaid_mco_rate_procurement_exposure_v1
351N/Acolumns onlypartial
States M7 Forward exposure: vw_pa_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_pa_medicaid_mco_rate_procurement_exposure_v1
745N/Acolumns onlypartial
States M7 Forward exposure: vw_tx_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_tx_medicaid_mco_rate_procurement_exposure_v1
3243N/Acolumns onlypartial
States M7 Forward exposure: vw_va_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_va_medicaid_mco_rate_procurement_exposure_v1
548N/Acolumns onlypartial
States M7 Forward exposure: vw_wa_medicaid_mco_rate_procurement_exposure_v1
medicare_semantic.vw_wa_medicaid_mco_rate_procurement_exposure_v1
547N/Acolumns onlypartial
California CalAIM 1915(b) physical PDF-page evidence
medicare_silver.ca_calaim_1915b_pdf_page
2,83927N/Acolumns onlylive
California CalAIM 1915(b) official source occurrences
medicare_silver.ca_calaim_1915b_source_occurrence
2747N/Acolumns onlylive
California CalAIM 1915(b) physical workbook-cell evidence
medicare_silver.ca_calaim_1915b_workbook_cell
19,94138N/Acolumns onlylive
California Medi-Cal managed-care contract index snapshots
medicare_silver.ca_medi_cal_managed_care_contract_index_snapshot
435N/Acolumns onlylive
California Medi-Cal managed-care contract index text
medicare_silver.ca_medi_cal_managed_care_contract_index_snapshot_text
428N/Acolumns onlylive
California Medi-Cal managed-care contract PDF-page evidence
medicare_silver.ca_medi_cal_managed_care_contract_pdf_page
3,82230N/Acolumns onlylive
California Medi-Cal managed-care contract source occurrences
medicare_silver.ca_medi_cal_managed_care_contract_source_occurrence
3159N/Acolumns onlylive
California Medi-Cal county-plan program-delivery roster
medicare_silver.ca_medi_cal_mcp_county_plan_roster
21839N/Acolumns onlylive
California Medi-Cal managed-care roster PDF-page evidence
medicare_silver.ca_medi_cal_mcp_roster_pdf_page
51529N/Acolumns onlylive
California Medi-Cal managed-care roster source occurrences
medicare_silver.ca_medi_cal_mcp_roster_source_occurrence
1546N/Acolumns onlylive
California legacy SMHS 1915(b) authority-period history
medicare_silver.ca_smhs_1915b_legacy_history_period
1329N/Acolumns onlylive
California legacy SMHS 1915(b) physical PDF-page evidence
medicare_silver.ca_smhs_1915b_legacy_pdf_page
1,35627N/Acolumns onlylive
California legacy SMHS 1915(b) official source occurrences
medicare_silver.ca_smhs_1915b_legacy_source_occurrence
3849N/Acolumns onlylive
CMS monthly state Medicaid and CHIP enrollment operations
medicare_silver.cms_medicaid_chip_enrollment_monthly_state
11,11866N/Acolumns onlylive
CMS Medicaid and CHIP monthly-enrollment source asset inventory
medicare_silver.cms_medicaid_chip_enrollment_source_asset
20431N/Acolumns onlylive
CMS Medicaid and CHIP historical report workbook cells
medicare_silver.cms_medicaid_chip_enrollment_workbook_cell
158,17537N/Acolumns onlylive
CMS Medicaid managed-care enrollment by program and plan
medicare_silver.cms_medicaid_managed_care_plan_enrollment
7,80435N/Acolumns onlylive
CMS Medicaid managed-care plan-enrollment source inventory
medicare_silver.cms_medicaid_managed_care_plan_source_asset
331N/Acolumns onlylive
District of Columbia Medicaid monthly enrollment report history
medicare_silver.dc_medicaid_enrollment_history_observation
53,27437N/Acolumns onlylive
California DHCS Medi-Cal managed-care enrollment
medicare_silver.fact_ca_medi_cal_managed_care_enrollment
31,17836N/Acolumns onlylive
CDC NHSN National and State HAI Progress Data
medicare_silver.fact_cdc_nhsn_state_hai
40,79253N/Acolumns onlylive
CMS Medicaid Health Home Program Quality
medicare_silver.fact_medicaid_health_home_quality
12,97937N/Acolumns onlylive
Medicaid MCO parent share, monthly - materialization of 2026-09-27T02:18Z (current, read through the serving pointer)
medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z
28,97028N/Acolumns onlypartial
States M1S SFY final enrollment by parent: fact_tx_medicaid_mco_parent_share_sfy_final_v1
medicare_silver.fact_tx_medicaid_mco_parent_share_sfy_final_v1
78129N/Acolumns onlypartial
MACPAC MACStats workbook exhibit index
medicare_silver.macpac_macstats_exhibit
86441N/Acolumns onlylive
MACPAC MACStats exact metric observations
medicare_silver.macpac_macstats_metric_observation
240,07454N/Acolumns onlylive
MACPAC MACStats full-edition page evidence
medicare_silver.macpac_macstats_page
2,37534N/Acolumns onlylive
MACPAC MACStats source asset inventory
medicare_silver.macpac_macstats_source_asset
53638N/Acolumns onlylive
MACPAC MACStats lossless workbook cells
medicare_silver.macpac_macstats_workbook_cell
383,79740N/Acolumns onlylive
Medicaid managed care capitation rates by rate cell, 28 jurisdictions (cross-state layer v1), PMPM, rating periods 2018-2027
medicare_silver.medicaid_capitation_rate_cell_v1
54,98116N/Acolumns onlypartial
Medicaid managed care capitation rates by rate cell, 28 jurisdictions (cross-state layer), PMPM, rating periods 2018-2027
medicare_silver.medicaid_capitation_rate_cell_v2
53,65116N/Acolumns onlypartial
Medicaid managed care capitation rate cycle, every state (cross-state layer v1), rating periods 2018-2027
medicare_silver.medicaid_capitation_rate_cycle_v1
34416N/Acolumns onlypartial
Medicaid managed care capitation rate cycle, every state (cross-state layer), rating periods 2018-2027
medicare_silver.medicaid_capitation_rate_cycle_v2
34716N/Acolumns onlypartial
States M1L Limited benefit plans: medicaid_limited_benefit_plan_enrollment_v1
medicare_silver.medicaid_limited_benefit_plan_enrollment_v1
52,58929N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_m1_program_observation_v1
medicare_silver.medicaid_m1_program_observation_v1
41,36839N/Acolumns onlypartial
States M1D Duals bridge: medicaid_mco_duals_bridge_v1
medicare_silver.medicaid_mco_duals_bridge_v1
253,98427N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_enrollment_assumption_v1
medicare_silver.medicaid_mco_enrollment_assumption_v1
95213N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_enrollment_assumptions_v1
medicare_silver.medicaid_mco_enrollment_assumptions_v1
417N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_enrollment_tracker_v2
medicare_silver.medicaid_mco_enrollment_tracker_v2
69,98742N/Acolumns onlypartial
Medicaid MCO public-parent forward exposure, partial v7 cohort
medicare_silver.medicaid_mco_forward_exposure_v1
21626N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_plan_enrollment_hunt_cogank_v1
medicare_silver.medicaid_mco_plan_enrollment_hunt_cogank_v1
5,49837N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_plan_enrollment_hunt_v1
medicare_silver.medicaid_mco_plan_enrollment_hunt_v1
1,78131N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_sec_tieout_v2
medicare_silver.medicaid_mco_sec_tieout_v2
684N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mco_state_month_reconciliation_mat_v1
medicare_silver.medicaid_mco_state_month_reconciliation_mat_v1
3,738130N/Acolumns onlypartial
States M1 Enrollment tracker: medicaid_mcpar_plan_avg_enrollment_v1
medicare_silver.medicaid_mcpar_plan_avg_enrollment_v1
2,01830N/Acolumns onlypartial
Medicaid MCPAR plan-ID crosswalk v1 (PUF plan name to canonical Medicaid plan id)
medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1
78612N/Acolumns onlylive
Medicaid MCPAR question dictionary (CMS MCPAR form template label, hint and type per question and edition)
medicare_silver.medicaid_mcpar_puf_question_v1
45411N/Acolumns onlylive
Medicaid MCPAR public use file, every line of every state's Managed Care Program Annual Report (PY2023-2024)
medicare_silver.medicaid_mcpar_puf_v1
348,33828N/Acolumns onlylive
Medicaid plan-to-parent ownership crosswalk v2 - effective-dated edges from state plan keys to parent companies (current)
medicare_silver.medicaid_plan_parent_crosswalk_v2
1,08718N/Acolumns onlypartial
Medicaid managed-care plan quality (HEDIS) by plan, the parsed fact without the plan crosswalk
medicare_silver.medicaid_plan_quality_measure_v1
5,69622N/Acolumns onlypartial
Medicaid plan quality plan-ID crosswalk v1 (publisher plan name to canonical Medicaid plan id)
medicare_silver.medicaid_plan_quality_plan_xwalk_v1
37212N/Acolumns onlypartial
States M6 Ownership + subcontracting: medicaid_plan_subcontract_v1
medicare_silver.medicaid_plan_subcontract_v1
37841N/Acolumns onlypartial
States M1T State-published totals: medicaid_state_monthly_total_recent_v1
medicare_silver.medicaid_state_monthly_total_recent_v1
49415N/Acolumns onlypartial
New York Medicaid parent enrollment by native product, September 2026
medicare_silver.ny_medicaid_parent_native_product_component_202609_v1
3320N/Acolumns onlypartial
States M6 Ownership + subcontracting: org_control_disclosure
medicare_silver.org_control_disclosure
1,66323N/Acolumns onlypartial
Medicaid managed-care subcontract and delegated-function observations
medicare_silver.org_subcontract
50637N/Acolumns onlypartial
States M1 Enrollment tracker: pa_medicaid_chc_enrollment_mco_population_v1
medicare_silver.pa_medicaid_chc_enrollment_mco_population_v1
99013N/Acolumns onlypartial
States W1 Coverage map: state_coverage_block_v1
medicare_silver.state_coverage_block_v1
330,72016N/Acolumns onlypartial
State duals knowledge base v5: benefit coverage
medicare_silver.state_duals_kb_benefit_coverage_v5
81922N/Acolumns onlylive
State duals knowledge base v5: change log
medicare_silver.state_duals_kb_change_log_v5
22614N/Acolumns onlylive
State duals knowledge base v5: cost sharing
medicare_silver.state_duals_kb_cost_sharing_v5
24719N/Acolumns onlylive
State duals knowledge base v5: dsnp requirement
medicare_silver.state_duals_kb_dsnp_requirement_v5
32718N/Acolumns onlylive
State duals knowledge base: filing patterns (how a state rule shows up in CY2027 D-SNP filings)
medicare_silver.state_duals_kb_filing_patterns_v2
4925N/Acolumns onlylive
State duals knowledge base v5: msp limits
medicare_silver.state_duals_kb_msp_limits_v5
21721N/Acolumns onlylive
State duals knowledge base v5: open question
medicare_silver.state_duals_kb_open_question_v5
22414N/Acolumns onlylive
State duals knowledge base v5: payer chain
medicare_silver.state_duals_kb_payer_chain_v5
2,17119N/Acolumns onlylive
State duals knowledge base v5: plan effective benefit
medicare_silver.state_duals_kb_plan_effective_benefit_v5
54025N/Acolumns onlylive
State duals knowledge base v5: rule
medicare_silver.state_duals_kb_rule_v5
1,58221N/Acolumns onlylive
State duals knowledge base v5: source
medicare_silver.state_duals_kb_source_v5
63219N/Acolumns onlylive
State duals knowledge base v5: state program
medicare_silver.state_duals_kb_state_program_v5
27022N/Acolumns onlylive
States M1 Enrollment tracker: tx_medicaid_mco_enrollment_other_sources_v1
medicare_silver.tx_medicaid_mco_enrollment_other_sources_v1
3,44227N/Acolumns onlypartial
States M1 Enrollment tracker: tx_medicaid_mco_fsr_member_months_v1
medicare_silver.tx_medicaid_mco_fsr_member_months_v1
26,59540N/Acolumns onlypartial
CT OHS Hospital Cost-to-Charge Ratios
vlada_curated.fact_ct_hospital_cost_to_charge
N/A8N/Acolumns onlylive
CT Medicaid DRG Weights
vlada_curated.fact_ct_medicaid_drg_weight
N/A11N/Acolumns onlylive
CT Medicaid Inpatient Hospital Base Rates
vlada_curated.fact_ct_medicaid_provider_rate
N/A11N/Acolumns onlylive
MA CHIA Relative Price (commercial price variation)
vlada_curated.fact_ma_chia_relative_price
N/A21N/Acolumns onlylive
MA CHIA Revenue-to-Cost Ratio by Payer
vlada_curated.fact_ma_chia_revenue_cost_ratio
N/A13N/Acolumns onlylive
MD HSCRC Monthly Revenue & Volumes
vlada_curated.fact_md_hscrc_monthly_rev_vol
N/A14N/Acolumns onlylive
MD HSCRC All-Payer Hospital Unit Rates
vlada_curated.fact_md_hscrc_unit_rate
22,58812N/Acolumns onlylive
NJ DOH Hospital Financial Transparency
vlada_curated.fact_nj_hospital_financials
N/A14N/Acolumns onlylive
State Medicaid Fee Schedule (rate per CPT/HCPCS)
vlada_curated.fact_state_medicaid_rate
N/A9N/Acolumns onlylive
States W8 Parent book of business: parent_book_az_v1
vlada_curated.parent_book_az_v1
87,92026N/Acolumns onlypartial
States W8 Parent book of business: parent_book_ca_v1
vlada_curated.parent_book_ca_v1
382,23326N/Acolumns onlypartial
States W8 Parent book of business: parent_book_fl_v1
vlada_curated.parent_book_fl_v1
418,68026N/Acolumns onlypartial
States W8 Parent book of business: parent_book_ga_v1
vlada_curated.parent_book_ga_v1
949,71526N/Acolumns onlypartial
States W8 Parent book of business: parent_book_il_v1
vlada_curated.parent_book_il_v1
606,48326N/Acolumns onlypartial
States W8 Parent book of business: parent_book_mi_v1
vlada_curated.parent_book_mi_v1
470,82626N/Acolumns onlypartial
States W8 Parent book of business: parent_book_nc_v1
vlada_curated.parent_book_nc_v1
592,18926N/Acolumns onlypartial
States W8 Parent book of business: parent_book_nj_v1
vlada_curated.parent_book_nj_v1
123,76126N/Acolumns onlypartial
States W8 Parent book of business: parent_book_ny_v1
vlada_curated.parent_book_ny_v1
383,01826N/Acolumns onlypartial
States W8 Parent book of business: parent_book_oh_v1
vlada_curated.parent_book_oh_v1
530,37626N/Acolumns onlypartial
States W8 Parent book of business: parent_book_pa_v1
vlada_curated.parent_book_pa_v1
428,14129N/Acolumns onlypartial
States W8 Parent book of business: parent_book_tn_v1
vlada_curated.parent_book_tn_v1
546,06926N/Acolumns onlypartial
States W8 Parent book of business: parent_book_tx_v1
vlada_curated.parent_book_tx_v1
1,524,02926N/Acolumns onlypartial
States W8 Parent book of business: parent_book_va_v1
vlada_curated.parent_book_va_v1
788,18526N/Acolumns onlypartial
States W8 Parent book of business: parent_book_wa_v1
vlada_curated.parent_book_wa_v1
216,63626N/Acolumns onlypartial
States M2 home care: reviewed home health and private duty nursing rates (vw_state_medicaid_homecare_v1)
vlada_curated.vw_state_medicaid_homecare_v1
N/A33N/Acolumns onlypartial
States M2 J-code book: measured pricing basis per state (vw_state_medicaid_jcode_basis_v1)
vlada_curated.vw_state_medicaid_jcode_basis_v1
N/A15N/Acolumns onlypartial
States M2 J-code book: rates computed by published rule, FL + MA (vw_state_medicaid_jcode_computed_v1)
vlada_curated.vw_state_medicaid_jcode_computed_v1
N/A18N/Acolumns onlypartial
States M2 J-code book: Medicaid J-code rates vs Medicare ASP (vw_state_medicaid_jcode_vs_asp_v1)
vlada_curated.vw_state_medicaid_jcode_vs_asp_v1
N/A28N/Acolumns onlypartial
States M2 FFS rate book: vw_state_medicaid_rate_change_v1
vlada_curated.vw_state_medicaid_rate_change_v1
N/A27N/Acolumns onlypartial
States M2 FFS rate book: vw_state_medicaid_rate_compare_v1
vlada_curated.vw_state_medicaid_rate_compare_v1
N/A27N/Acolumns onlypartial
States M2 FFS rate book: vw_state_medicaid_rate_v2
vlada_curated.vw_state_medicaid_rate_v2
294,25429N/Acolumns onlypartial
States M2 FFS rate book: vw_state_medicaid_rate_vs_medicare_v1
vlada_curated.vw_state_medicaid_rate_vs_medicare_v1
N/A21N/Acolumns onlypartial

Curated datasets (22)

TableRowsColumnsLatestCardStatus
ICD-10-CM Diagnosis Code Dimension
drug_silver.dim_icd10cm
1,490,532212026-05-18cardlive
ICD-10-PCS Inpatient Procedure Code Dimension
drug_silver.dim_icd10pcs
1,221,44417FY2026 (same single vintage; current copy ingested 2026-05-18)cardlive
CPT/HCPCS → modal UB-04 Revenue Code mapping
medicare_silver.cpt_revcode_modal
N/A5N/Acolumns onlylive
Code Vintage Validity (which years a billing code is valid)
medicare_silver.dim_code_validity
20,5235N/Acolumns onlylive
Care-site × payer coverage aggregate
vlada_curated.agg_care_site_payer_coverage
N/A10N/Acolumns onlylive
County intelligence aggregate (supply by class)
vlada_curated.agg_county_intelligence
N/A9N/Acolumns onlylive
County × payer landscape aggregate
vlada_curated.agg_county_payer_landscape
N/A5N/Acolumns onlylive
State × payer roster aggregate
vlada_curated.agg_state_payer_roster
N/A8N/Acolumns onlylive
Billing Code Vocabulary (HCPCS/CPT/etc.)
vlada_curated.dim_code
20,19692026 (source_year; effective_start 2026-01-01; single loaded_at snapshot 2026-04-17)cardlive
Billing-code institutional-vs-professional class
vlada_curated.dim_code_billing_class
N/A7N/Acolumns onlylive
Geography Hierarchy (ZIP → county → CBSA → CSA → state)
vlada_curated.dim_geography
33,79135static (single snapshot, source_version='2020')cardlive
HCPCS code dimension
vlada_curated.dim_hcpcs
24,8555N/Acolumns onlylive
US state and territory dimension
vlada_curated.dim_state
566N/Acolumns onlylive
State Metrics (demographics / health context, integrated)
vlada_curated.dim_state_metric
N/A11N/Acolumns onlylive
Provider-type → procedure (HCPCS) profile
vlada_curated.dim_taxonomy_procedures
N/A5static (blended CMS data years 2021-2023; no time column persisted)cardlive
Policy document chunks (retrieval units with citations)
vlada_curated.fact_policy_doc_chunk
N/A8N/Acolumns onlylive
Policy document corpus (state/federal regulation docs)
vlada_curated.fact_policy_document
N/A15N/Acolumns onlylive
Vlada ontology layer one (edge)
vlada_ontology.l1_edge
279,51516N/Acolumns onlylive
Vlada ontology layer one (entity)
vlada_ontology.l1_entity
153,6816N/Acolumns onlylive
Vlada ontology layer one (event)
vlada_ontology.l1_event
56510N/Acolumns onlylive
Vlada ontology layer one (evidence)
vlada_ontology.l1_evidence
14,2104N/Acolumns onlylive
Vlada ontology layer one (identifier)
vlada_ontology.l1_identifier
4,7167N/Acolumns onlylive

Provenance (5)

TableRowsColumnsLatestCardStatus
Hospital MRF version ledger
dim_mrf_version
N/AN/AN/Acolumns onlylive
Unified substrate MRF version ledger
dim_substrate_mrf_version
N/AN/AN/Acolumns onlylive
Drug source registry cache
drug_source_registry_cache
N/AN/AN/Acolumns onlylive
State Marketplace content-addressed artifact history
medicare_silver.fact_hix_state_artifact_revision_history
52419N/Acolumns onlypartial
Medicare source registry cache
medicare_source_registry_cache
N/AN/AN/Acolumns onlylive

This page as markdown: /docs-md/recipes.md · every page in one file: /llms-full.txt