Drugs and formularies

FDA Purple Book — licensed biologics + biosimilars (silver)

drug_silver.dim_purple_book_product·partial·silver·FDA Purple Book — licensed biologics + biosimilars

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The promoted silver Purple Book: FDA licensed biological products with license_type (351(a) reference biologic vs 351(k) biosimilar / interchangeable), reference-product linkage, and exclusivity dates.
2The biosimilar-substitution lens behind the biosimilar_window MCP tool.

Grain

Key	Grain
N/A	1One row per (bla_number, product_number) per snapshot.

Columns (38)

Column	Type	Meaning
`bla_number`	string
`product_number`	string
`applicant`	string
`proprietary_name`	string
`proper_name`	string
`license_type`	string	351(a) original biologic, 351(k) Biosimilar / 351(k) Interchangeable
`strength`	string
`dosage_form`	string
`route_of_administration`	string
`product_presentation`	string
`marketing_status`	string
`licensure_status`	string
`approval_date`	date
`ref_product_proper_name`	string
`ref_product_proprietary_name`	string
`submission_type`	string
`license_number`	string
`center`	string
`date_of_first_licensure`	date
`exclusivity_expiration_date`	date
`ref_product_exclusivity_exp_date`	date
`orphan_exclusivity_exp_date`	date
`patent_list_provided`	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_purple_book_product")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.dim_purple_book_product WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`bla_number`
Join	`how_to_join(source_fqn="drug_silver.dim_purple_book_product")`
Raw door	Tool: biosimilar_window; Athena: drug_silver.dim_purple_book_product
Note	Promoted silver behind the planned reference entry drug_purple_book (drug_silver.dim_purple_book_product); biosimilar_window also overlays fact_drug_spending_part_d (not catalogued in this lane).

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