Baselight

Tobacco Use And Mortality, 2004-2015

Hospital admissions, prescriptions, and fatalities in England

@kaggle.nhs_tobacco_use

Prescriptions
@kaggle.nhs_tobacco_use.prescriptions

  • 9.35 KB
  • 11 rows
  • 9 columns
year

Year

all_pharmacotherapy_prescriptions

All Pharmacotherapy Prescriptions

nicotine_replacement_therapy_nrt_prescriptions

Nicotine Replacement Therapy (NRT) Prescriptions

bupropion_zyban_prescriptions

Bupropion (Zyban) Prescriptions

varenicline_champix_prescriptions

Varenicline (Champix) Prescriptions

net_ingredient_cost_of_all_pharmacotherapies

Net Ingredient Cost Of All Pharmacotherapies

net_ingredient_cost_of_nicotine_replacement_therapies_nrt

Net Ingredient Cost Of Nicotine Replacement Therapies (NRT)

net_ingredient_cost_of_bupropion_zyban

Net Ingredient Cost Of Bupropion (Zyban)

net_ingredient_cost_of_varenicline_champix

Net Ingredient Cost Of Varenicline (Champix)

2014/15134876621561381451820880719129
2013/141778105922697487672425786523646
2012/132203131826859581212806999429058
2011/1225321545309576455230951121632385
2010/1125641541369876588330808158133494
2009/1024831559478776342531429206029936
2008/0922631492587145752030683214324694
2007/08247517561076126147935883388221714
2006/07207919381192244817397434315760
2005/062205207612948092434654627

CREATE TABLE prescriptions (
  "year" VARCHAR,
  "all_pharmacotherapy_prescriptions" BIGINT,
  "nicotine_replacement_therapy_nrt_prescriptions" BIGINT,
  "bupropion_zyban_prescriptions" BIGINT,
  "varenicline_champix_prescriptions" DOUBLE,
  "net_ingredient_cost_of_all_pharmacotherapies" BIGINT,
  "net_ingredient_cost_of_nicotine_replacement_therapies_nrt" BIGINT,
  "net_ingredient_cost_of_bupropion_zyban" BIGINT,
  "net_ingredient_cost_of_varenicline_champix" DOUBLE
);

Share link

Anyone who has the link will be able to view this.