Provenance

Medicare source registry cache

medicare_source_registry_cache·live·registry

Rows

N/A

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1Postgres mirror of the medicare_silver source-registry Iceberg table — bronze manifest in queryable form for restatement detection + replay.

Grain

Key	Grain
N/A	1One row per (source_id, observed_period, s3_object).

Columns (0)

Columns are not in the catalog for this source; describe_data_source("medicare_source_registry_cache") reads them live.

Query it

describe_data_source(source_fqn="medicare_source_registry_cache")     # the card, live
query_substrate(sql="SELECT * FROM medicare_source_registry_cache WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id`
Join	`how_to_join(source_fqn="medicare_source_registry_cache")`
Raw door	Postgres vlada_enterprise: medicare_source_registry_cache
Note	Tracks cms_vintage_sequence + parse_revision + restatement chain.

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