Drugs and formularies

FDA Orange Book (patents + exclusivity)

drug_silver.dim_orange_book_product·partial·silver·FDA Orange Book

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1FDA approved-drug products with therapeutic-equivalence, patent, and exclusivity metadata.
2Drives generic-launch timing queries.

Grain

Key	Grain
N/A	1One row per (application_number, product_id, observed_month).

Columns (30)

Column	Type	Meaning
`appl_type`	string
`appl_no`	string
`product_no`	string
`ingredient`	string
`dosage_form`	string
`route`	string
`trade_name`	string
`applicant_short`	string
`applicant_full_name`	string
`strength`	string
`te_code`	string
`approval_date_text`	string
`rld`	boolean
`rs`	boolean
`product_type`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`application_number`
Join	`how_to_join(source_fqn="drug_silver.dim_orange_book_product")`
Raw door	Tool: prove_drug_patent_status; Athena: drug_silver.dim_orange_book_product
Note	Companion facts fact_orange_book_patent + fact_orange_book_exclusivity.

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