Global Health Observatory - World Health Organization

CREATE TABLE owid_low_birth_weight_prevalence_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "low_birth_weight_prevalence_pct" FLOAT  -- Low Birth Weight Prevalence, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_low_birth_weight_prevalence_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "low_birth_weight_prevalence_pct" FLOAT  -- Low Birth Weight Prevalence, Pct,
  "low_birth_weight_prevalence_pct_low" FLOAT  -- Low Birth Weight Prevalence, Pct Low,
  "low_birth_weight_prevalence_pct_high" FLOAT  -- Low Birth Weight Prevalence, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_lx_number_of_people_left_alive_at_age_x_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lx_number_of_people_left_alive_at_age_x" FLOAT  -- Lx, Number Of People Left Alive At Age X
);

CREATE TABLE owid_lx_number_of_people_left_alive_at_age_x_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "lx_number_of_people_left_alive_at_age_x" FLOAT  -- Lx, Number Of People Left Alive At Age X,
  "lx_number_of_people_left_alive_at_age_x_low" VARCHAR  -- Lx, Number Of People Left Alive At Age X Low,
  "lx_number_of_people_left_alive_at_age_x_high" VARCHAR  -- Lx, Number Of People Left Alive At Age X High,
  "comments" VARCHAR
);

CREATE TABLE owid_magnetic_flux_density_microt_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "comments" VARCHAR,
  "magnetic_flux_density_microt" VARCHAR  -- Magnetic Flux Density, Microt
);

CREATE TABLE owid_magnetic_flux_density_microt_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "magnetic_flux_density_microt" VARCHAR  -- Magnetic Flux Density, Microt,
  "magnetic_flux_density_microt_low" VARCHAR  -- Magnetic Flux Density, Microt Low,
  "magnetic_flux_density_microt_high" VARCHAR  -- Magnetic Flux Density, Microt High,
  "comments" VARCHAR
);

CREATE TABLE owid_main_sector_for_treatment_for_alcohol_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "main_sector_for_treatment_for_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_main_sector_for_treatment_for_alcohol_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "main_sector_for_treatment_for_alcohol_use_disorders" VARCHAR,
  "main_sector_for_treatment_for_alcohol_use_disorders_low" VARCHAR,
  "main_sector_for_treatment_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_main_sector_for_treatment_for_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "main_sector_for_treatment_for_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_main_sector_for_treatment_for_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "main_sector_for_treatment_for_drug_use_disorders" VARCHAR,
  "main_sector_for_treatment_for_drug_use_disorders_low" VARCHAR,
  "main_sector_for_treatment_for_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_main_substance_at_treatment_entry_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_main_substance_at_treatment" VARCHAR,
  "main_substance_at_treatment_entry" VARCHAR
);

CREATE TABLE owid_main_substance_at_treatment_entry_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_main_substance_at_treatment" VARCHAR,
  "main_substance_at_treatment_entry" VARCHAR,
  "main_substance_at_treatment_entry_low" VARCHAR,
  "main_substance_at_treatment_entry_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_activities_of_daily_living_s_645df168 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_activities_of_daily_living_suppor_4ec7a32f" VARCHAR  -- Majority Provider Of Activities Of Daily Living Support Services In Community For Dementia, Public, Private,
  "majority_provider_of_activities_of_daily_living_suppor_a2d659c0" VARCHAR  -- Majority Provider Of Activities Of Daily Living Support Services In Community For Dementia, Public, Private Low,
  "majority_provider_of_activities_of_daily_living_suppor_6c418b58" VARCHAR  -- Majority Provider Of Activities Of Daily Living Support Services In Community For Dementia, Public, Private High,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_activities_of_daily_living_s_6eaddcb7 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_activities_of_daily_living_suppor_4ec7a32f" VARCHAR  -- Majority Provider Of Activities Of Daily Living Support Services In Community For Dementia, Public, Private
);

CREATE TABLE owid_majority_provider_of_behaviour_and_psychological__1540d78b (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_behaviour_and_psychological_manag_091a742e" VARCHAR  -- Majority Provider Of Behaviour And Psychological Management In Community For Dementia, Public, Private
);

CREATE TABLE owid_majority_provider_of_behaviour_and_psychological__cf3c8466 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_behaviour_and_psychological_manag_091a742e" VARCHAR  -- Majority Provider Of Behaviour And Psychological Management In Community For Dementia, Public, Private,
  "majority_provider_of_behaviour_and_psychological_manag_4a0b93dc" VARCHAR  -- Majority Provider Of Behaviour And Psychological Management In Community For Dementia, Public, Private Low,
  "majority_provider_of_behaviour_and_psychological_manag_6ec08854" VARCHAR  -- Majority Provider Of Behaviour And Psychological Management In Community For Dementia, Public, Private High,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_dementia_carer_training_and__24109758 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_dementia_carer_training_and_education_ngo" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Ngo
);

CREATE TABLE owid_majority_provider_of_dementia_carer_training_and__3c737dac (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_dementia_carer_training_and_education_ngo" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Ngo,
  "majority_provider_of_dementia_carer_training_and_educa_cb2839c6" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Ngo Low,
  "majority_provider_of_dementia_carer_training_and_educa_26803eb9" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Ngo High,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_dementia_carer_training_and__75ce8b92 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_dementia_carer_training_and_educa_39ccd398" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Private Sector
);

CREATE TABLE owid_majority_provider_of_dementia_carer_training_and__b75562d5 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_dementia_carer_training_and_educa_7d6e365c" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Public Sector
);

CREATE TABLE owid_majority_provider_of_dementia_carer_training_and__cbd4343c (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_dementia_carer_training_and_educa_39ccd398" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Private Sector,
  "majority_provider_of_dementia_carer_training_and_educa_721e6c75" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Private Sector Low,
  "majority_provider_of_dementia_carer_training_and_educa_30503e2e" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Private Sector High,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_dementia_carer_training_and__f75b560d (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_dementia_carer_training_and_educa_7d6e365c" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Public Sector,
  "majority_provider_of_dementia_carer_training_and_educa_e6a430b9" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Public Sector Low,
  "majority_provider_of_dementia_carer_training_and_educa_47416df1" VARCHAR  -- Majority Provider Of Dementia Carer Training And Education, Public Sector High,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_diagnostic_services_in_commu_9033def3 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_diagnostic_services_in_community__cfca389c" VARCHAR  -- Majority Provider Of Diagnostic Services In Community For Dementia, Public, Private,
  "majority_provider_of_diagnostic_services_in_community__7a3f1d44" VARCHAR  -- Majority Provider Of Diagnostic Services In Community For Dementia, Public, Private Low,
  "majority_provider_of_diagnostic_services_in_community__f0d9a3e3" VARCHAR  -- Majority Provider Of Diagnostic Services In Community For Dementia, Public, Private High,
  "comments" VARCHAR
);

CREATE TABLE owid_majority_provider_of_diagnostic_services_in_commu_da0929f6 (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_diagnostic_services_in_community__cfca389c" VARCHAR  -- Majority Provider Of Diagnostic Services In Community For Dementia, Public, Private
);

CREATE TABLE owid_majority_provider_of_information_on_financial_ben_0afff12b (
  "year" INTEGER,
  "country" VARCHAR,
  "majority_provider_of_information_on_financial_benefits_341cdf4b" VARCHAR  -- Majority Provider Of Information On Financial Benefits Social Protection For Dementia Carers, Ngo
);