Provenance

Drug source registry cache

drug_source_registry_cache·live·registry

Rows

N/A

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1Drug-side mirror of medicare_source_registry_cache. source_publication_date generalizes cms_publication_date (FDA / DOL / NLM / HRSA / SEC / state DOIs).

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("drug_source_registry_cache") reads them live.

Query it

describe_data_source(source_fqn="drug_source_registry_cache")     # the card, live
query_substrate(sql="SELECT * FROM drug_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="drug_source_registry_cache")`
Raw door	Postgres vlada_enterprise: drug_source_registry_cache
Note	Same column shape as migration 031, drug-specific natural-key naming.

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