Home

Dataset:

Name prescription-drug-wholesale-acquisition-cost-wac-increases
Updated 2025-07-08
CA Dataset link
Current True
Tables
diabetes_ndcs_wac_increases_5_year_history     year - int
oshpd_id - varchar(9)
manufacturer_name - varchar(33)
date_reported - varchar(10)
ndc_number - varchar(11)
drug_product_description - varchar(75)
wac_effective_date - varchar(10)
wac_increase_amount - varchar(8)
wac_after_increase - varchar(9)
patent_expiration_date - varchar(10)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(10)
unit_sales_volume_non_public_indicator - varchar(1)
cost_increase_factors - varchar(2488)
cost_increase_factors_non_public_indicator - varchar(1)
change_improvement_description - varchar(605)
change_improvement_non_public_indicator - varchar(1)
acquisition_date - varchar(10)
company_acquired_from - varchar(24)
acquisition_price - varchar(10)
acquisition_price_non_public_indicator - varchar(0)
acquisition_price_comment - varchar(413)
wac_at_acquisition - varchar(6)
wac_year_prior_to_acquisition - varchar(6)
year_drug_introduced_to_market - varchar(4)
wac_at_intro_to_market - varchar(6)
supporting_documents - varchar(76)
general_comments - varchar(1229)
monthly_update_prescription_drug_wac_inc     oshpd_id - varchar(9)
manufacturer_name - varchar(56)
date_reported - varchar(13)
ndc_number - varchar(11)
drug_product_description - varchar(255)
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(1311)
cost_increase_factors_non_public_indicator - varchar(42)
change_improvement_description - varchar(410)
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(20)
general_comments - varchar(1442)
monthly_update_prescription_drug_wac_increases_5_year_hist     manufacturer_name - varchar(56)
ndc_number - varchar(11)
effective_date - varchar(14)
history_effective_date - varchar(22)
wac_increase_amount - varchar(19)
wac_amount - varchar(11)
q1_q4_2019_prescription_drugs_wac_increases     oshpd_id - varchar(9)
manufacturer_name - varchar(42)
date_reported - varchar(10)
ndc_number - varchar(11)
drug_product_description - varchar(252)
wac_effective_date - varchar(10)
wac_increase_amount - varchar(8)
wac_after_increase - varchar(9)
patent_expiration_date - varchar(10)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(10)
unit_sales_volume_non_public_indicator - varchar(1)
cost_increase_factors - varchar(3068)
cost_increase_factors_non_public_indicator - varchar(1)
change_improvement_description - varchar(787)
change_improvement_non_public_indicator - varchar(1)
acquisition_date - varchar(10)
company_acquired_from - varchar(53)
acquisition_price - varchar(10)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(862)
wac_at_acquisition - varchar(8)
wac_year_prior_to_acquisition - varchar(8)
year_drug_introduced_to_market - varchar(4)
wac_at_intro_to_market - varchar(8)
supporting_documents - varchar(154)
general_comments - varchar(2006)
q1_q4_2019_prescription_drugs_wac_increases_5_year_history     manufacturer_name - varchar(42)
ndc_number - varchar(11)
effective_date - varchar(19)
history_effective_date - varchar(19)
wac_increase_amount - varchar(7)
wac_amount - varchar(8)
q1_q4_2020_prescription_drugs_wac_increases     oshpd_id - varchar(9)
manufacturer_name - varchar(42)
date_reported - varchar(10)
ndc_number - varchar(11)
drug_product_description - varchar(248)
wac_effective_date - varchar(10)
wac_increase_amount - varchar(8)
wac_after_increase - varchar(8)
patent_expiration_date - varchar(10)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(10)
unit_sales_volume_non_public_indicator - varchar(1)
cost_increase_factors - varchar(3129)
cost_increase_factors_non_public_indicator - varchar(1)
change_improvement_description - varchar(3125)
change_improvement_non_public_indicator - varchar(1)
acquisition_date - varchar(10)
company_acquired_from - varchar(46)
acquisition_price - varchar(10)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(934)
wac_at_acquisition - varchar(8)
wac_year_prior_to_acquisition - varchar(8)
year_drug_introduced_to_market - varchar(4)
wac_at_intro_to_market - varchar(8)
supporting_documents - varchar(154)
general_comments - varchar(1784)
q1_q4_2020_prescription_drugs_wac_increases_5_year_history     manufacturer_name - varchar(42)
ndc_number - varchar(11)
effective_date - varchar(19)
history_effective_date - varchar(19)
wac_increase_amount - varchar(7)
wac_amount - varchar(8)
q1_q4_2021_prescription_drug_wac_increases     oshpd_id - varchar(9)
manufacturer_name - varchar(138)
date_reported - varchar(10)
ndc_number - varchar(11)
drug_product_description - varchar(248)
wac_effective_date - varchar(10)
wac_increase_amount - varchar(7)
wac_after_increase - varchar(9)
patent_expiration_date - varchar(10)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(10)
unit_sales_volume_non_public_indicator - varchar(1)
cost_increase_factors - varchar(3433)
cost_increase_factors_non_public_indicator - varchar(1)
change_improvement_description - varchar(3125)
change_improvement_non_public_indicator - varchar(1)
acquisition_date - varchar(10)
company_acquired_from - varchar(37)
acquisition_price - varchar(11)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(787)
wac_at_acquisition - varchar(8)
wac_year_prior_to_acquisition - varchar(8)
year_drug_introduced_to_market - varchar(4)
wac_at_intro_to_market - varchar(8)
supporting_documents - varchar(154)
general_comments - varchar(1630)
q1_q4_2021_prescription_drug_wac_increases_5_year_history     manufacturer_name - varchar(138)
ndc_number - varchar(11)
effective_date - varchar(19)
history_effective_date - varchar(19)
wac_increase_amount - varchar(7)
wac_amount - varchar(8)
q1_q4_2022_prescription_drug_wac_increases     oshpd_id - varchar(9)
manufacturer_name - varchar(138)
date_reported - varchar(10)
ndc_number - varchar(11)
drug_product_description - varchar(377)
wac_effective_date - varchar(10)
wac_increase_amount - varchar(8)
wac_after_increase - varchar(9)
patent_expiration_date - varchar(10)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(10)
unit_sales_volume_non_public_indicator - varchar(1)
cost_increase_factors - varchar(2832)
cost_increase_factors_non_public_indicator - varchar(1)
change_improvement_description - varchar(562)
change_improvement_non_public_indicator - varchar(1)
acquisition_date - varchar(10)
company_acquired_from - varchar(31)
acquisition_price - varchar(11)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(787)
wac_at_acquisition - varchar(8)
wac_year_prior_to_acquisition - varchar(8)
year_drug_introduced_to_market - varchar(4)
wac_at_intro_to_market - varchar(8)
supporting_documents - varchar(154)
general_comments - varchar(1630)
q1_q4_2022_prescription_drug_wac_increases_5_year_history     manufacturer_name - varchar(138)
ndc_number - varchar(11)
effective_date - varchar(19)
history_effective_date - varchar(19)
wac_increase_amount - varchar(9)
wac_amount - varchar(8)
q1_q4_2023_prescription_drug_wac_increases     oshpd_id - varchar(9)
manufacturer_name - varchar(138)
date_reported - varchar(10)
ndc_number - varchar(11)
drug_product_description - varchar(252)
drug_category - varchar(7)
drug_category_source - varchar(8)
wac_effective_date - varchar(10)
wac_increase_amount - varchar(8)
wac_after_increase - varchar(9)
patent_expiration_date - varchar(10)
drug_source_type - varchar(34)
unit_sales_volume_in_us - varchar(10)
unit_sales_volume_non_public_indicator - varchar(1)
cost_increase_factors - varchar(2391)
cost_increase_factors_non_public_indicator - varchar(1)
change_improvement_description - varchar(527)
change_improvement_non_public_indicator - varchar(1)
acquisition_date - varchar(10)
company_acquired_from - varchar(29)
acquisition_price - varchar(11)
acquisition_price_non_public_indicator - varchar(1)
acquisition_price_comment - varchar(722)
wac_at_acquisition - varchar(8)
wac_year_prior_to_acquisition - varchar(8)
year_drug_introduced_to_market - varchar(4)
wac_at_intro_to_market - varchar(8)
supporting_documents - varchar(75)
general_comments - varchar(1630)
q1_q4_2023_prescription_drug_wac_increases_5_year_history     manufacturer_name - varchar(138)
ndc_number - varchar(11)
effective_date - varchar(19)
history_effective_date - varchar(19)
wac_increase_amount - varchar(8)
wac_amount - varchar(9)
Sources
prescription-drugs-wac-increases-5-year-history-data-dictionary.csv - None
prescription-drugs-wac-increases-data-dictionary.csv - None
july-monthly-update-prescription-drug-wac-increases-excel.xlsx - None
july-monthly-update-prescription-drug-wac-increases-.csv - None
july-monthly-update-prescription-drug-wac-increases-5-year-history-excel.xlsx - None
july-monthly-update-prescription-drug-wac-increases-5-year-history-.csv - None
datapackage.json - None
diabetes-ndcs-wac-increases.xlsx - diabetes_ndcs_wac_increases_5_year_history
june-monthly-update-prescription-drug-wac-increases-excel.xlsx - monthly_update_prescription_drug_wac_inc
june-monthly-update-prescription-drug-wac-increases-.csv - monthly_update_prescription_drug_wac_inc
june-monthly-update-prescription-drug-wac-increases-5-year-history-excel.xlsx - monthly_update_prescription_drug_wac_increases_5_year_hist
june-monthly-update-prescription-drug-wac-increases-5-year-history-.csv - monthly_update_prescription_drug_wac_increases_5_year_hist
q1-q4-2019-prescription-drugs-wac-increases.xlsx - q1_q4_2019_prescription_drugs_wac_increases
q1-q4-2019-prescription-drugs-wac-increases-5-year-history.xlsx - q1_q4_2019_prescription_drugs_wac_increases_5_year_history
q1-q4-2020-prescription-drugs-wac-increases.xlsx - q1_q4_2020_prescription_drugs_wac_increases
q1-q4-2020-prescription-drugs-wac-increases-5-year-history.xlsx - q1_q4_2020_prescription_drugs_wac_increases_5_year_history
q1-q4-2021-prescription-drug-wac-increases.xlsx - q1_q4_2021_prescription_drug_wac_increases
q1-q4-2021-prescription-drug-wac-increases-5-year-history.xlsx - q1_q4_2021_prescription_drug_wac_increases_5_year_history
q1-q4-2022-prescription-drug-wac-increases.xlsx - q1_q4_2022_prescription_drug_wac_increases
q1-q4-2022-prescription-drug-wac-increases-5-year-history.xlsx - q1_q4_2022_prescription_drug_wac_increases_5_year_history
q1-q4-2023-prescription-drug-wac-increases.xlsx - q1_q4_2023_prescription_drug_wac_increases
q1-q4-2023-prescription-drug-wac-increases-5-year-history.xlsx - q1_q4_2023_prescription_drug_wac_increases_5_year_history
Updates
2025-07-11 17:44:27      None
2025-06-25 18:53:16      0
2025-06-25 18:50:47      0
2025-06-25 18:39:15      0
2025-06-25 18:33:57      0
2025-06-06 12:16:10      0
2025-04-11 11:35:36      1
2025-03-15 10:14:55      1
2025-02-08 14:23:32      0
2025-02-02 18:52:55      0
2025-01-19 13:22:11      0
2025-01-19 13:21:36      0
2025-01-17 06:09:09      1
2025-01-17 06:08:54      0
2025-01-16 19:51:00      1
2025-01-16 19:50:50      0
2025-01-15 13:41:53      0
2025-01-15 13:41:24      0
2025-01-15 13:40:38      0
2025-01-15 13:40:37      0
2025-01-15 13:40:03      0
2025-01-15 13:40:02      0
2025-01-15 13:36:17      0
2025-01-15 13:36:15      0
2025-01-15 13:20:06      0
2025-01-15 13:19:07      0
2025-01-10 12:39:53      0
2025-01-10 12:33:20      1
2025-01-10 11:22:56      1
2024-12-27 18:59:13      0
2024-12-14 17:15:52      0
2024-12-04 16:50:03      None
2024-09-18 13:18:31      None
2024-09-09 15:56:31      None
2024-09-09 13:44:56      None