Substrate catalog
Every source in the substrate, with its provenance. The Vlada substrate is the agent-ready layer of US healthcare cost data. This catalog lists each source — what it is, its grain, where to query it, what it does not yet cover — and the tools registered against it. Generated from catalog.json by scripts/build_catalog.py.
Generated Jun 1, 2026 · Catalog v1.0 · Glue skipped / Postgres skipped
Context docs and provenance refs are repository paths (e.g. docs/context_library/…), not links — read them in the repo for the full source contract.
1 catalog warning
live inspection disabled via --no-live Domain Commercial6 Curated1 Drug22 Hospital3 Medicare15 Provenance4 Provider Identity4
Status Live27 Partial23 Design locked1 Planned4
Stage curated3 dim6 index1 mart3 raw2 reference2 registry4 semantic_view1 silver33
Payer dimension + carrier hierarchy vlada_curated.dim_payer
Commercial dim Live ⚑ 1 gap
▸ Part D plan dimension (CMS SPUF) drug_silver.dim_part_d_plan
Drug silver Live 10 tools 160.9K rows ⚑ 3 gaps
▸ ASP Pricing File — Medicare Part B quarterly ASP (raw CMS drop) drug_silver.fact_drug_asp_quarterly
Drug silver Live 2 tools ⚑ 3 gaps
▸ Part D formulary coverage (CMS SPUF) drug_silver.fact_drug_formulary
Drug silver Live 7 tools 42.9M rows ⚑ 3 gaps
▸ Part D formulary exclusion list (CMS SPUF) drug_silver.fact_drug_formulary_excluded
Drug silver Live 2 tools 355.1K rows ⚑ 2 gaps
▸ IRA Maximum Fair Price (CMS-negotiated) drug_silver.fact_drug_reimbursement#ira_mfp
Drug silver Live 6 tools ⚑ 2 gaps
▸ Form 5500 filings (DOL EFAST2 main filing) drug_silver.fact_form5500_filing
Drug silver Live 3 tools 1.2M rows ⚑ 3 gaps
▸ Form 5500 Schedule C service providers (PBM compensation) drug_silver.fact_form5500_service_provider
Drug silver Live 3 tools 1.4M rows ⚑ 4 gaps
▸ Part D plan cost-share (CMS SPUF) drug_silver.fact_part_d_plan_cost_share
Drug silver Live 5 tools 4.9M rows ⚑ 3 gaps
▸ Part D plan drug pricing (CMS SPUF) drug_silver.fact_part_d_plan_drug_pricing
Drug silver Live 6 tools 1.6B rows ⚑ 4 gaps
▸ Part D plan service area (CMS SPUF) drug_silver.fact_part_d_plan_service_area
Drug silver Live 1 tool 2.4M rows ⚑ 3 gaps
▸ Raw HPT machine-readable files (bronze) s3://vlada-platform-raw/hospital
Hospital raw Live ⚑ 1 gap
▸ Hospital chargemaster + payer-specific rates (HPT) vlada_curated.fact_hospital_chargemaster
Hospital curated Live 4 tools 4.3B rows ⚑ 3 gaps
▸ Medicare IPPS (hospital inpatient, MS-DRG) medicare_silver.dim_medicare_ipps
Medicare silver Live ⚑ 1 gap
▸ Medicare OPPS (hospital outpatient) medicare_silver.dim_medicare_opps
Medicare silver Live ⚑ 1 gap
▸ Medicare Physician Fee Schedule (PFS) medicare_silver.dim_medicare_pfs
Medicare silver Live ⚑ 2 gaps
▸ MA plan crosswalk / lineage medicare_silver.dim_plan_crosswalk
Medicare dim Live
▸ MA/Part D enrollment — CPSC county grain medicare_silver.enrollment_monthly_county
Medicare silver Live 8 tools ⚑ 3 gaps
▸ Medicare Advantage enrollment (monthly) medicare_silver.fact_ma_enrollment
Medicare silver Live ⚑ 1 gap
▸ Medicare Advantage Star Ratings medicare_silver.fact_ma_plan_stars
Medicare silver Live ⚑ 1 gap
▸ Hospital MRF version ledger dim_mrf_version
Provenance registry Live ⚑ 1 gap
▸ Unified substrate MRF version ledger dim_substrate_mrf_version
Provenance registry Live ⚑ 1 gap
▸ Drug source registry cache drug_source_registry_cache
Provenance registry Live
▸ Medicare source registry cache medicare_source_registry_cache
Provenance registry Live
▸ NPPES provider directory vlada_curated.dim_provider
Provider Identity dim Live ⚑ 1 gap
▸ Medicare PUF (NPI x HCPCS utilization) vlada_curated.dim_provider_service
Provider Identity dim Live 14.2M rows ⚑ 1 gap
▸ CCN <-> NPI facility bridge vlada_curated.provider_facility_xref
Provider Identity curated Live ⚑ 1 gap
▸ Raw TiC machine-readable files (bronze) s3://vlada-platform-raw/commercial_v2
Commercial raw Partial ⚑ 1 gap
▸ Commercial negotiated rates (TiC) vlada_curated.fact_rate
Commercial curated Partial 3 tools 853M rows ⚑ 3 gaps
▸ Canonical-graph rate lookup index vlada_curated.idx_rate_lookup
Commercial index Partial ⚑ 1 gap
▸ Code-keyed commercial rate serving mart vlada_curated.mart_rate_by_code
Commercial mart Partial 2 tools ⚑ 4 gaps
▸ NPI-resolved commercial rate serving mart vlada_curated.mart_rate_by_npi
Commercial mart Partial 3 tools ⚑ 1 gap
▸ DEA controlled-substance schedule by NDC (silver) drug_silver.dim_dea_ndc_schedule
Drug silver Partial 1 tool ⚑ 2 gaps
▸ FDA Orange Book (patents + exclusivity) drug_silver.dim_orange_book_product
Drug silver Partial 4 tools ⚑ 1 gap
▸ FDA Purple Book — licensed biologics + biosimilars (silver) drug_silver.dim_purple_book_product
Drug silver Partial 1 tool ⚑ 2 gaps
▸ NADAC — National Average Drug Acquisition Cost drug_silver.fact_drug_acquisition_cost
Drug silver Partial 6 tools ⚑ 2 gaps
▸ Consumer cash-price reference (Cost Plus Drugs snapshot) drug_silver.fact_drug_consumer_price
Drug silver Partial 4 tools 2.4K rows ⚑ 6 gaps
▸ WAC increases — California HCAI SB 17 notices drug_silver.fact_drug_hcai_sb17_wac_increase
Drug silver Partial 3 tools ⚑ 2 gaps
▸ ASP — Medicare Part B drug Average Sales Price drug_silver.fact_drug_reimbursement#asp
Drug silver Partial 6 tools ⚑ 2 gaps
▸ WAC list price — Texas DSHS Annual WAC Report drug_silver.fact_drug_wac_annual_tx
Drug silver Partial 6 tools ⚑ 3 gaps
▸ Hospital identity spine vlada_curated.dim_hospital_identity
Hospital dim Partial ⚑ 1 gap
▸ MA Plan Benefit Package (PBP) — semantic view medicare_semantic.vw_pbp_benefits
Medicare semantic_view Partial ⚑ 1 gap
▸ MA/Part D enrollment — plan grain medicare_silver.enrollment_monthly_plan
Medicare silver Partial 3 tools ⚑ 1 gap
▸ MA enrollment — monthly contract summary medicare_silver.monthly_contract_enrollment_summary
Medicare silver Partial 3 tools ⚑ 1 gap
▸ PBP Section B13 — Other Services (silver) medicare_silver.pbp_section_b13_other_services
Medicare silver Partial 6 tools ⚑ 3 gaps
▸ PBP Section B16 — Dental (silver) medicare_silver.pbp_section_b16_dental
Medicare silver Partial 7 tools ⚑ 3 gaps
▸ PBP Section B17 — Eye Exams / Eyewear (silver) medicare_silver.pbp_section_b17_eye_exams_wear
Medicare silver Partial 6 tools ⚑ 3 gaps
▸ PBP Section B18 — Hearing Exams / Aids (silver) medicare_silver.pbp_section_b18_hearing_exams_aids
Medicare silver Partial 6 tools ⚑ 3 gaps
▸ MA plan crosswalk — annual lineage (silver) medicare_silver.plan_crosswalks_annual
Medicare silver Partial 4 tools ⚑ 1 gap
▸ Facility dimension vlada_curated.dim_facility
Provider Identity dim Partial
▸ Hospital x commercial unified pricing mart vlada_curated.mart_unified_pricing
Curated mart Design locked 3 tools ⚑ 2 gaps
▸ Drug formulary coverage (original scaffold — superseded) drug_silver.fact_drug_formulary_coverage
Drug silver Planned ⚑ 2 gaps
▸ CMS Open Payments (Sunshine Act) drug_silver.fact_drug_payment_to_prescriber
Drug silver Planned 6 tools ⚑ 1 gap
▸ DEA Controlled Substance Schedules drug.dea_controlled_substances
Drug reference Planned ⚑ 1 gap
▸ FDA Purple Book (biosimilars + reference products) drug.purple_book
Drug reference Planned ⚑ 2 gaps
▸