| Name |
prescription-drugs-introduced-to-market |
|---|
| Updated |
2025-06-06 |
|---|
| Current |
False |
|---|
| Tables |
| monthly_update_prescription_drugs_intro_to_the_market_excel | |
manufacturer_name - varchar(35)
ndc_number - varchar(11)
drug_product_description - varchar(238)
date_introduced_to_market - varchar(10)
wac_at_introduction - varchar(11)
marketing_pricing_plan_description - varchar(3378)
marketing_pricing_plan_non_public_indicator - varchar(1)
estimated_number_of_patients - varchar(8)
breakthrough_therapy_indicator - varchar(1)
priority_review_indicator - varchar(1)
acquisition_date - varchar(10)
acquisition_price - varchar(14)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(1224)
general_comments - varchar(3560)
supporting_documents - varchar(154)
|
| monthly_update_prescription_drugs_introduced | |
oshpd_id - varchar(9)
manufacturer_name - varchar(37)
date_reported - varchar(13)
ndc_number - varchar(11)
drug_product_description - varchar(246)
wac_effective_date - varchar(18)
wac_increase_amount - varchar(19)
wac_after_increase - varchar(18)
patent_expiration_date - varchar(22)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(23)
unit_sales_volume_non_public_indicator - varchar(38)
gross_sales_us_dollars - varchar(24)
gross_sales_us_dollars_non_public_indicator - varchar(45)
cost_increase_factors - varchar(3707)
cost_increase_factors_non_public_indicator - varchar(42)
change_improvement_description - varchar(779)
change_improvement_non_public_indicator - varchar(39)
acquisition_date - varchar(16)
company_acquired_from - varchar(39)
acquisition_price - varchar(17)
acquisition_price_non_public_indicator - varchar(38)
acquisition_price_comment - varchar(673)
wac_at_acquisition - varchar(18)
wac_year_prior_to_acquisition - varchar(29)
year_drug_introduced_to_market - varchar(30)
wac_at_intro_to_market - varchar(22)
supporting_documents - varchar(76)
general_comments - varchar(1686)
|
| q1_q4_2019_prescription_drugs_intro_to_market | |
manufacturer_name - varchar(42)
ndc_number - varchar(11)
drug_product_description - varchar(227)
date_introduced_to_market - varchar(10)
wac_at_introduction - varchar(12)
marketing_pricing_plan_description - varchar(4607)
marketing_pricing_plan_non_public_indicator - varchar(399)
estimated_number_of_patients - varchar(1383)
breakthrough_therapy_indicator - varchar(700)
priority_review_indicator - varchar(1)
acquisition_date - varchar(10)
acquisition_price - varchar(15)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(897)
general_comments - varchar(2567)
supporting_documents - varchar(324)
|
| q1_q4_2020_prescription_drugs_intro_to_market | |
manufacturer_name - varchar(60)
ndc_number - varchar(11)
drug_product_description - varchar(253)
date_introduced_to_market - varchar(10)
wac_at_introduction - varchar(11)
marketing_pricing_plan_description - varchar(3255)
marketing_pricing_plan_non_public_indicator - varchar(1)
estimated_number_of_patients - varchar(8)
breakthrough_therapy_indicator - varchar(1)
priority_review_indicator - varchar(1)
acquisition_date - varchar(10)
acquisition_price - varchar(16)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(887)
general_comments - varchar(2558)
supporting_documents - varchar(154)
|
| q1_q4_2021_prescription_drugs_intro_to_market | |
manufacturer_name - varchar(138)
ndc_number - varchar(11)
drug_product_description - varchar(255)
date_introduced_to_market - varchar(10)
wac_at_introduction - varchar(11)
marketing_pricing_plan_description - varchar(2819)
marketing_pricing_plan_non_public_indicator - varchar(1)
estimated_number_of_patients - varchar(8)
breakthrough_therapy_indicator - varchar(1)
priority_review_indicator - varchar(1)
acquisition_date - varchar(10)
acquisition_price - varchar(16)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(541)
general_comments - varchar(2648)
supporting_documents - varchar(154)
|
| q1_q4_2022_prescription_drugs_intro_to_market | |
manufacturer_name - varchar(60)
ndc_number - varchar(11)
drug_product_description - varchar(254)
date_introduced_to_market - varchar(10)
wac_at_introduction - varchar(12)
marketing_pricing_plan_description - varchar(3814)
marketing_pricing_plan_non_public_indicator - varchar(1)
estimated_number_of_patients - varchar(8)
breakthrough_therapy_indicator - varchar(1)
priority_review_indicator - varchar(1)
acquisition_date - varchar(10)
acquisition_price - varchar(16)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(936)
general_comments - varchar(3310)
supporting_documents - varchar(76)
|
| q1_q4_2023_prescription_drugs_intro_to_market | |
manufacturer_name - varchar(37)
ndc_number - varchar(11)
drug_product_description - varchar(255)
drug_category - varchar(13)
drug_category_source - varchar(13)
date_introduced_to_market - varchar(10)
wac_at_introduction - varchar(12)
marketing_pricing_plan_description - varchar(3013)
marketing_pricing_plan_non_public_indicator - varchar(1)
estimated_number_of_patients - varchar(9)
breakthrough_therapy_indicator - varchar(1)
priority_review_indicator - varchar(1)
acquisition_date - varchar(10)
acquisition_price - varchar(15)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(1548)
general_comments - varchar(4982)
supporting_documents - varchar(75)
|
|
|---|
| Sources |
data-dictionary-prescription-drugs-introduced-to-market.csv --> None
may-monthly-update-prescription-drugs-introduced-to-the-market-excel.xlsx --> monthly_update_prescription_drugs_intro_to_the_market_excel
may-monthly-update-prescription-drugs-introduced-to-the-market-.csv --> monthly_update_prescription_drugs_introduced
q1-q4-2019-prescription-drugs-introduced-to-market.xlsx --> q1_q4_2019_prescription_drugs_intro_to_market
q1-q4-2020-prescription-drugs-introduced-to-market.xlsx --> q1_q4_2020_prescription_drugs_intro_to_market
q1-q4-2021-prescription-drugs-introduced-to-market.xlsx --> q1_q4_2021_prescription_drugs_intro_to_market
q1-q4-2022-prescription-drugs-introduced-to-market.xlsx --> q1_q4_2022_prescription_drugs_intro_to_market
q1-q4-2023-prescription-drugs-introduced-to-market.xlsx --> q1_q4_2023_prescription_drugs_intro_to_market
|
|---|
| Updates |
| 2025-06-06 12:16:27 |
|
0 |
| 2025-04-11 11:35:49 |
|
1 |
| 2025-03-15 10:15:03 |
|
1 |
| 2025-02-08 14:23:44 |
|
0 |
| 2025-02-02 18:53:08 |
|
0 |
| 2025-01-19 13:53:25 |
|
0 |
| 2025-01-17 06:08:45 |
|
1 |
| 2025-01-17 06:08:43 |
|
0 |
| 2025-01-16 19:50:42 |
|
1 |
| 2025-01-16 19:50:41 |
|
0 |
| 2025-01-14 11:41:50 |
|
0 |
| 2025-01-14 11:37:00 |
|
0 |
| 2025-01-14 11:36:19 |
|
0 |
| 2025-01-14 11:33:47 |
|
0 |
| 2025-01-14 11:19:01 |
|
0 |
| 2025-01-10 13:06:07 |
|
0 |
| 2025-01-10 12:47:06 |
|
0 |
| 2025-01-10 12:40:38 |
|
1 |
| 2025-01-10 11:23:01 |
|
1 |
| 2024-12-27 18:59:05 |
|
0 |
| 2024-12-14 17:15:46 |
|
0 |
| 2024-12-04 16:49:57 |
|
None |
| 2024-09-18 13:18:28 |
|
None |
| 2024-09-09 15:56:27 |
|
None |
| 2024-09-09 13:44:53 |
|
None |
|
|---|