Drugs and formularies

Consumer cash-price reference (Cost Plus Drugs snapshot)

drug_silver.fact_drug_consumer_price·partial·silver·Consumer cash-price reference (Cost Plus Drugs snapshot)

Rows

2,386

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Consumer cash-price reference table; currently a single snapshot of the Cost Plus Drugs (Mark Cuban CPD) public catalog (source='costplusdrugs').
2Columns: source, ndc11, total_price_usd, quantity, retail_comparison_price_usd, drug_name, unit, source_captured_at.
3Read by employer_cpd_carve_out for the CPD reprice demo.

Grain

Key	Grain
N/A	1One row per consumer cash-price SKU (source x sku x quantity); current snapshot includes Cost Plus Drugs plus a second consumer-price source.

Columns (33)

Column	Type	Meaning
`source`	string
`sku`	string
`quantity`	int
`product_name`	string
`variant_name`	string
`slug`	string
`total_price_usd`	double
`manufacturing_cost_usd`	double
`markup_usd`	double
`markup_percent`	double
`labor_usd`	double
`shipping_usd`	double
`retail_comparison_price_usd`	double
`is_generic`	boolean
`stock_status`	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
`pharmacy_name`	string	per-pharmacy source
`price_tier`	string	coupon/companion_subscription/online_only/cpd_full_price
`zip_code`	string	GoodRx ZIP-context

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ndc11`
Join	`how_to_join(source_fqn="drug_silver.fact_drug_consumer_price")`
Raw door	Athena: drug_silver.fact_drug_consumer_price (filter source; employer_cpd_carve_out uses source = 'costplusdrugs')
Note	Linked tool employer_cpd_carve_out (#23 only; pbm_compensation_rollup does not read it). Source-surface catalogue only - pricing is CPD's published consumer price, not a Vlada claim.

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