Home

Dataset:

Name	prescription-drug-wholesale-acquisition-cost-wac-increases
Updated	2025-08-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) july_mon_update_presc_drug_wac_increases_5_year_history_     july_mon_update_presc_drug_wac_increases_5_year_history_excel     july_monthly_update_prescription_drug_wac_increases_     july_monthly_update_prescription_drug_wac_increases_excel     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  -    prescription-drugs-wac-increases-data-dictionary.csv  -    datapackage.json  -    diabetes-ndcs-wac-increases.xlsx  -  Table: diabetes_ndcs_wac_increases_5_year_history Sheet: diabetes_ndcs_wac_increases_5_year_history Updated: 2025-10-13 july-monthly-update-prescription-drug-wac-increases-5-year-history-.csv  -  Table: july_mon_update_presc_drug_wac_increases_5_year_history_   Fails: 2 july-monthly-update-prescription-drug-wac-increases-5-year-history-excel.xlsx  -  Table: july_mon_update_presc_drug_wac_increases_5_year_history_excel   Fails: 2 july-monthly-update-prescription-drug-wac-increases-.csv  -  Table: july_monthly_update_prescription_drug_wac_increases_   Fails: 2 july-monthly-update-prescription-drug-wac-increases-excel.xlsx  -  Table: july_monthly_update_prescription_drug_wac_increases_excel   Fails: 2 june-monthly-update-prescription-drug-wac-increases-excel.xlsx  -  Table: monthly_update_prescription_drug_wac_inc   Fails: 10 june-monthly-update-prescription-drug-wac-increases-5-year-history-excel.xlsx  -  Table: monthly_update_prescription_drug_wac_increases_5_year_hist   Fails: 10 q1-q4-2019-prescription-drugs-wac-increases.xlsx  -  Table: q1_q4_2019_prescription_drugs_wac_increases   Updated: 2025-10-13 q1-q4-2019-prescription-drugs-wac-increases-5-year-history.xlsx  -  Table: q1_q4_2019_prescription_drugs_wac_increases_5_year_history   Updated: 2025-10-13 q1-q4-2020-prescription-drugs-wac-increases.xlsx  -  Table: q1_q4_2020_prescription_drugs_wac_increases   Updated: 2025-10-13 q1-q4-2020-prescription-drugs-wac-increases-5-year-history.xlsx  -  Table: q1_q4_2020_prescription_drugs_wac_increases_5_year_history   Updated: 2025-10-13 q1-q4-2021-prescription-drug-wac-increases.xlsx  -  Table: q1_q4_2021_prescription_drug_wac_increases   Updated: 2025-10-13 q1-q4-2021-prescription-drug-wac-increases-5-year-history.xlsx  -  Table: q1_q4_2021_prescription_drug_wac_increases_5_year_history   Updated: 2025-10-13 q1-q4-2022-prescription-drug-wac-increases.xlsx  -  Table: q1_q4_2022_prescription_drug_wac_increases   Updated: 2025-10-13 q1-q4-2022-prescription-drug-wac-increases-5-year-history.xlsx  -  Table: q1_q4_2022_prescription_drug_wac_increases_5_year_history   Updated: 2025-10-13 q1-q4-2023-prescription-drug-wac-increases.xlsx  -  Table: q1_q4_2023_prescription_drug_wac_increases   Updated: 2025-10-13 q1-q4-2023-prescription-drug-wac-increases-5-year-history.xlsx  -  Table: q1_q4_2023_prescription_drug_wac_increases_5_year_history   Updated: 2025-10-13
Updated