Global Health Observatory - World Health Organization

CREATE TABLE owid_primary_data_availability_for_uhc_service_coverag_edf58794 (
  "year" INTEGER,
  "country" VARCHAR,
  "primary_data_availability_for_uhc_service_coverage_ind_bd31a3f6" FLOAT  -- Primary Data Availability For Uhc Service Coverage Index, Sdg 3–8 1, Pct,
  "primary_data_availability_for_uhc_service_coverage_ind_5a0de436" VARCHAR  -- Primary Data Availability For Uhc Service Coverage Index, Sdg 3–8 1, Pct Low,
  "primary_data_availability_for_uhc_service_coverage_ind_f5d52389" VARCHAR  -- Primary Data Availability For Uhc Service Coverage Index, Sdg 3–8 1, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_priorities_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "priorities" VARCHAR
);

CREATE TABLE owid_priorities_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "priorities" VARCHAR,
  "priorities_low" VARCHAR,
  "priorities_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_privacy_and_security_laws_need_to_be_in_place_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "privacy_and_security_laws_need_to_be_in_place" VARCHAR
);

CREATE TABLE owid_privacy_and_security_laws_need_to_be_in_place_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "privacy_and_security_laws_need_to_be_in_place" VARCHAR,
  "privacy_and_security_laws_need_to_be_in_place_low" VARCHAR,
  "privacy_and_security_laws_need_to_be_in_place_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_private_funding_for_ehealth_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "private_funding_for_ehealth" VARCHAR
);

CREATE TABLE owid_private_funding_for_ehealth_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "private_funding_for_ehealth" VARCHAR,
  "private_funding_for_ehealth_low" VARCHAR,
  "private_funding_for_ehealth_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_probability_pct_of_dying_between_age_30_and_exact_1432ba33 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "probability_pct_of_dying_between_age_30_and_exact_age__648ab74e" FLOAT  -- Probability, Pct, Of Dying Between Age 30 And Exact Age 70 From Any Of Cardiovascular Disease, Cancer, Diabetes, Or Chronic Respiratory Disease,
  "probability_pct_of_dying_between_age_30_and_exact_age__efa61b3a" FLOAT  -- Probability, Pct, Of Dying Between Age 30 And Exact Age 70 From Any Of Cardiovascular Disease, Cancer, Diabetes, Or Chronic Respiratory Disease Low,
  "probability_pct_of_dying_between_age_30_and_exact_age__9715333e" FLOAT  -- Probability, Pct, Of Dying Between Age 30 And Exact Age 70 From Any Of Cardiovascular Disease, Cancer, Diabetes, Or Chronic Respiratory Disease High,
  "comments" VARCHAR
);

CREATE TABLE owid_probability_pct_of_dying_between_age_30_and_exact_9793edce (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "probability_pct_of_dying_between_age_30_and_exact_age__648ab74e" FLOAT  -- Probability, Pct, Of Dying Between Age 30 And Exact Age 70 From Any Of Cardiovascular Disease, Cancer, Diabetes, Or Chronic Respiratory Disease,
  "comments" VARCHAR
);

CREATE TABLE owid_process_evaluation_was_employed_to_assess_impleme_4114d953 (
  "year" INTEGER,
  "country" VARCHAR,
  "process_evaluation_was_employed_to_assess_implementati_99e64a2c" VARCHAR  -- Process Evaluation Was Employed To Assess Implementation Of The Campaign,
  "process_evaluation_was_employed_to_assess_implementati_f327e674" VARCHAR  -- Process Evaluation Was Employed To Assess Implementation Of The Campaign Low,
  "process_evaluation_was_employed_to_assess_implementati_4a02a9e6" VARCHAR  -- Process Evaluation Was Employed To Assess Implementation Of The Campaign High,
  "comments" VARCHAR
);

CREATE TABLE owid_process_evaluation_was_employed_to_assess_impleme_ba7177ca (
  "year" INTEGER,
  "country" VARCHAR,
  "process_evaluation_was_employed_to_assess_implementati_99e64a2c" VARCHAR  -- Process Evaluation Was Employed To Assess Implementation Of The Campaign
);

CREATE TABLE owid_procurement_of_medical_devices_carried_out_at_the_0110e315 (
  "year" INTEGER,
  "country" VARCHAR,
  "procurement_of_medical_devices_carried_out_at_the_nati_572b4197" INTEGER  -- Procurement Of Medical Devices Carried Out At The National Level,
  "comments" VARCHAR
);

CREATE TABLE owid_procurement_of_medical_devices_carried_out_at_the_b86da73b (
  "year" INTEGER,
  "country" VARCHAR,
  "procurement_of_medical_devices_carried_out_at_the_nati_572b4197" INTEGER  -- Procurement Of Medical Devices Carried Out At The National Level,
  "procurement_of_medical_devices_carried_out_at_the_nati_38b8c493" VARCHAR  -- Procurement Of Medical Devices Carried Out At The National Level Low,
  "procurement_of_medical_devices_carried_out_at_the_nati_96bb6546" VARCHAR  -- Procurement Of Medical Devices Carried Out At The National Level High,
  "comments" VARCHAR
);

CREATE TABLE owid_production_in_1000s_hectolitres_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "production_in_1000s_hectolitres" FLOAT
);

CREATE TABLE owid_production_in_1000s_hectolitres_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "production_in_1000s_hectolitres" FLOAT,
  "production_in_1000s_hectolitres_low" VARCHAR,
  "production_in_1000s_hectolitres_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_programmes_diverting_clients_from_the_justice_sys_81ed11d4 (
  "year" INTEGER,
  "country" VARCHAR,
  "programmes_diverting_clients_from_the_justice_system_t_a95ab7a7" VARCHAR  -- Programmes Diverting Clients From The Justice System Towards Treatment
);

CREATE TABLE owid_programmes_diverting_clients_from_the_justice_sys_c424c74d (
  "year" INTEGER,
  "country" VARCHAR,
  "programmes_diverting_clients_from_the_justice_system_t_a95ab7a7" VARCHAR  -- Programmes Diverting Clients From The Justice System Towards Treatment,
  "programmes_diverting_clients_from_the_justice_system_t_9cf704de" VARCHAR  -- Programmes Diverting Clients From The Justice System Towards Treatment Low,
  "programmes_diverting_clients_from_the_justice_system_t_9c4e6f97" VARCHAR  -- Programmes Diverting Clients From The Justice System Towards Treatment High,
  "comments" VARCHAR
);

CREATE TABLE owid_programmes_for_the_prevention_of_substance_use_di_bccee0cd (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_special_populations" VARCHAR,
  "programmes_for_the_prevention_of_substance_use_disorde_418e5256" VARCHAR  -- Programmes For The Prevention Of Substance Use Disorders For Special Populations,
  "programmes_for_the_prevention_of_substance_use_disorde_6822986e" VARCHAR  -- Programmes For The Prevention Of Substance Use Disorders For Special Populations Low,
  "programmes_for_the_prevention_of_substance_use_disorde_0abf7574" VARCHAR  -- Programmes For The Prevention Of Substance Use Disorders For Special Populations High,
  "comments" VARCHAR
);

CREATE TABLE owid_programmes_for_the_prevention_of_substance_use_di_f1193f7f (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_special_populations" VARCHAR,
  "programmes_for_the_prevention_of_substance_use_disorde_418e5256" VARCHAR  -- Programmes For The Prevention Of Substance Use Disorders For Special Populations
);

CREATE TABLE owid_programmes_readily_available_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "programmes_readily_available" VARCHAR
);

CREATE TABLE owid_programmes_readily_available_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "programmes_readily_available" VARCHAR,
  "programmes_readily_available_low" VARCHAR,
  "programmes_readily_available_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_projection_of_deaths_per_100_000_population (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "causes" VARCHAR,
  "projection_of_deaths_per_100_000_population" FLOAT,
  "projection_of_deaths_per_100_000_population_low" VARCHAR,
  "projection_of_deaths_per_100_000_population_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_projection_of_number_of_deaths (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "causes" VARCHAR,
  "projection_of_number_of_deaths" UINTEGER,
  "projection_of_number_of_deaths_low" VARCHAR,
  "projection_of_number_of_deaths_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_promoting_standards_and_interoperability_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "promoting_standards_and_interoperability" VARCHAR
);

CREATE TABLE owid_promoting_standards_and_interoperability_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "promoting_standards_and_interoperability" VARCHAR,
  "promoting_standards_and_interoperability_low" VARCHAR,
  "promoting_standards_and_interoperability_high" VARCHAR,
  "comments" VARCHAR
);