| Name |
prescription-drug-wholesale-acquisition-cost-wac-increases |
|---|
| Updated |
2025-06-06 |
|---|
| 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
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-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 |
|
|---|