Dataset: Cervical Cancer & HPV Vaccines

About this Dataset

Cervical Cancer & HPV Vaccines

The Economist's Cervical Cancer & HPV Vaccines data used in the article: article: https://www.economist.com/graphic-detail/2023/05/31/cheap-single-dose-hpv-vaccines-could-save-millions-of-lives
author: Daniella Raz

Sources

The World Health Organization / UNICEF
Papillomavirus Rapid Interface for Modelling and Economics (PRIME): London School of Hygiene & Tropical Medicine, Mark Jit, Marc Brisson, Kaja Abbas, and Han Fu

Variable definitions

by age 15, first dose:

by age 15, last dose:

coverage, first dose, females:

coverage, last dose, females:

country = country code

cohort_size = total number of girls who are in the cohort that should be getting vaccinated

current_cov = coverage in X year

curr_vacc_cohort_size = number vaccinated in that cohort

future_cov = 90% coverage rate

future_vacc_cohort_size = number vaccinated in cohort under new coverage rate

curr_cc_prev: cervical cancer cases prevented under the current coverage

curr_mort_prev: deaths from cervical cancer prevented under the current coverage

curr_cost: current cost of the program

curr_cost_prev: current costs prevented by reducing cervical cancer

proj_cc_prev, proj_mort_prev, proj_cost, proj_cost_prev are the same as above but under the "projected" 90% coverage rate the WHO says is necessary for elimination of cervical cancer

Tables

Hpv 2020s Results

@kaggle.joebeachcapital_cervical_cancer_and_hpv_vaccines.hpv_2020s_results

90.47 KB
3520 rows
11 columns


CREATE TABLE hpv_2020s_results (
  "country_name" VARCHAR,
  "region" VARCHAR,
  "income_group" VARCHAR,
  "year" BIGINT,
  "cohort_size" DOUBLE,
  "coverage" DOUBLE,
  "cancer_prevented" DOUBLE,
  "deaths_prevented" DOUBLE,
  "assumption_type" VARCHAR,
  "possible_cancer_cases" DOUBLE,
  "possible_cancer_deaths" DOUBLE
);

Hpv Past Results

@kaggle.joebeachcapital_cervical_cancer_and_hpv_vaccines.hpv_past_results

50.1 KB
2112 rows
10 columns


CREATE TABLE hpv_past_results (
  "country_name" VARCHAR,
  "region" VARCHAR,
  "income_group" VARCHAR,
  "year" BIGINT,
  "coverage" DOUBLE,
  "cancer_prevented" DOUBLE,
  "deaths_prevented" DOUBLE,
  "assumption_type" VARCHAR,
  "possible_cancer_cases" DOUBLE,
  "possible_cancer_deaths" DOUBLE
);

Mixed Results

@kaggle.joebeachcapital_cervical_cancer_and_hpv_vaccines.mixed_results

31.07 KB
176 rows
20 columns


CREATE TABLE mixed_results (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "cohort_size" DOUBLE,
  "current_cov" DOUBLE,
  "curr_vacc_cohort_size" DOUBLE,
  "future_cov" DOUBLE,
  "future_vacc_cohort_size" DOUBLE,
  "curr_cc_prev" DOUBLE,
  "curr_mort_prev" DOUBLE,
  "curr_cost" DOUBLE,
  "curr_cost_prev" DOUBLE,
  "proj_cc_prev" DOUBLE,
  "proj_mort_prev" DOUBLE,
  "proj_cost" DOUBLE,
  "proj_cost_prev" DOUBLE,
  "year" BIGINT,
  "current_net_cost" DOUBLE,
  "country_name" VARCHAR,
  "region" VARCHAR,
  "income_group" VARCHAR
);

Results 2021

@kaggle.joebeachcapital_cervical_cancer_and_hpv_vaccines.results_2021

39.19 KB
176 rows
24 columns


CREATE TABLE results_2021 (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "cohort_size" DOUBLE,
  "current_cov" DOUBLE,
  "curr_vacc_cohort_size" DOUBLE,
  "future_cov" DOUBLE,
  "future_vacc_cohort_size" DOUBLE,
  "curr_cc_prev" DOUBLE,
  "curr_mort_prev" DOUBLE,
  "curr_cost" DOUBLE,
  "curr_cost_prev" DOUBLE,
  "proj_cc_prev" DOUBLE,
  "proj_mort_prev" DOUBLE,
  "proj_cost" DOUBLE,
  "proj_cost_prev" DOUBLE,
  "year" BIGINT,
  "cancer_prevented" DOUBLE,
  "deaths_prevented" DOUBLE,
  "current_net_cost" DOUBLE,
  "future_net_cost" DOUBLE,
  "additional_cost" DOUBLE,
  "country_name" VARCHAR,
  "region" VARCHAR,
  "income_group" VARCHAR
);