Global Health Observatory - World Health Organization

CREATE TABLE owid_dementia_nongovernmental_organization_staff_prima_f5415cac (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_nongovernmental_organization_staff_primarily__c0c14f1c" VARCHAR  -- Dementia Nongovernmental Organization Staff Primarily Salaried Volunteer,
  "dementia_nongovernmental_organization_staff_primarily__534bd459" VARCHAR  -- Dementia Nongovernmental Organization Staff Primarily Salaried Volunteer Low,
  "dementia_nongovernmental_organization_staff_primarily__b331355e" VARCHAR  -- Dementia Nongovernmental Organization Staff Primarily Salaried Volunteer High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_specific_adult_day_centre_places_per_10__4920c36e (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_adult_day_centre_places_per_10_000_population" INTEGER  -- Dementia Specific Adult Day Centre Places, Per 10–000 Population
);

CREATE TABLE owid_dementia_specific_adult_day_centre_places_per_10__becb76df (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_adult_day_centre_places_per_10_000_population" INTEGER  -- Dementia Specific Adult Day Centre Places, Per 10–000 Population,
  "dementia_specific_adult_day_centre_places_per_10_000_p_879b0900" VARCHAR  -- Dementia Specific Adult Day Centre Places, Per 10–000 Population Low,
  "dementia_specific_adult_day_centre_places_per_10_000_p_9c892a20" VARCHAR  -- Dementia Specific Adult Day Centre Places, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_specific_hospice_care_beds_per_10_000_po_234d4ea9 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_hospice_care_beds_per_10_000_population" INTEGER  -- Dementia Specific Hospice Care Beds, Per 10–000 Population,
  "dementia_specific_hospice_care_beds_per_10_000_population_low" VARCHAR  -- Dementia Specific Hospice Care Beds, Per 10–000 Population Low,
  "dementia_specific_hospice_care_beds_per_10_000_population_high" VARCHAR  -- Dementia Specific Hospice Care Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_specific_hospice_care_beds_per_10_000_po_fea80d08 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_hospice_care_beds_per_10_000_population" INTEGER  -- Dementia Specific Hospice Care Beds, Per 10–000 Population
);

CREATE TABLE owid_dementia_specific_hospital_beds_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_hospital_beds_per_10_000_population" INTEGER  -- Dementia Specific Hospital Beds, Per 10–000 Population
);

CREATE TABLE owid_dementia_specific_hospital_beds_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_hospital_beds_per_10_000_population" INTEGER  -- Dementia Specific Hospital Beds, Per 10–000 Population,
  "dementia_specific_hospital_beds_per_10_000_population_low" VARCHAR  -- Dementia Specific Hospital Beds, Per 10–000 Population Low,
  "dementia_specific_hospital_beds_per_10_000_population_high" VARCHAR  -- Dementia Specific Hospital Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_dementia_specific_residential_long_term_care_beds_a1653d23 (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_residential_long_term_care_beds_per__f4c3f3c9" UINTEGER  -- Dementia Specific Residential Long Term Care Beds, Per 10–000 Population
);

CREATE TABLE owid_dementia_specific_residential_long_term_care_beds_d15d2deb (
  "year" INTEGER,
  "country" VARCHAR,
  "dementia_specific_residential_long_term_care_beds_per__f4c3f3c9" UINTEGER  -- Dementia Specific Residential Long Term Care Beds, Per 10–000 Population,
  "dementia_specific_residential_long_term_care_beds_per__91082a2e" VARCHAR  -- Dementia Specific Residential Long Term Care Beds, Per 10–000 Population Low,
  "dementia_specific_residential_long_term_care_beds_per__4cac2998" VARCHAR  -- Dementia Specific Residential Long Term Care Beds, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_density_of_adult_day_centres_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_adult_day_centres_per_100_000_population" INTEGER  -- Density Of Adult Day Centres, Per 100–000 Population
);

CREATE TABLE owid_density_of_adult_day_centres_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_adult_day_centres_per_100_000_population" INTEGER  -- Density Of Adult Day Centres, Per 100–000 Population,
  "density_of_adult_day_centres_per_100_000_population_low" VARCHAR  -- Density Of Adult Day Centres, Per 100–000 Population Low,
  "density_of_adult_day_centres_per_100_000_population_high" VARCHAR  -- Density Of Adult Day Centres, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_density_of_hospice_centres_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_hospice_centres_per_100_000_population" INTEGER  -- Density Of Hospice Centres, Per 100–000 Population
);

CREATE TABLE owid_density_of_hospice_centres_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_hospice_centres_per_100_000_population" INTEGER  -- Density Of Hospice Centres, Per 100–000 Population,
  "density_of_hospice_centres_per_100_000_population_low" VARCHAR  -- Density Of Hospice Centres, Per 100–000 Population Low,
  "density_of_hospice_centres_per_100_000_population_high" VARCHAR  -- Density Of Hospice Centres, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_density_of_outpatient_health_centres_per_100_000__963cbd7d (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_outpatient_health_centres_per_100_000_population" FLOAT  -- Density Of Outpatient Health Centres, Per 100–000 Population,
  "density_of_outpatient_health_centres_per_100_000_population_low" VARCHAR  -- Density Of Outpatient Health Centres, Per 100–000 Population Low,
  "density_of_outpatient_health_centres_per_100_000_popul_c2fa6893" VARCHAR  -- Density Of Outpatient Health Centres, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_density_of_outpatient_health_centres_per_100_000__a4866668 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_outpatient_health_centres_per_100_000_population" FLOAT  -- Density Of Outpatient Health Centres, Per 100–000 Population
);

CREATE TABLE owid_density_of_outpatient_social_centres_per_100_000__36aa8ce6 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_outpatient_social_centres_per_100_000_population" INTEGER  -- Density Of Outpatient Social Centres, Per 100–000 Population,
  "density_of_outpatient_social_centres_per_100_000_population_low" VARCHAR  -- Density Of Outpatient Social Centres, Per 100–000 Population Low,
  "density_of_outpatient_social_centres_per_100_000_popul_1e393a1d" VARCHAR  -- Density Of Outpatient Social Centres, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_density_of_outpatient_social_centres_per_100_000__c54d4e57 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_outpatient_social_centres_per_100_000_population" INTEGER  -- Density Of Outpatient Social Centres, Per 100–000 Population
);

CREATE TABLE owid_density_of_residential_long_term_care_facilities__098bc64f (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_residential_long_term_care_facilities_per_1_a48839c6" INTEGER  -- Density Of Residential Long Term Care Facilities, Per 100–000 Population,
  "density_of_residential_long_term_care_facilities_per_1_7e9732e1" VARCHAR  -- Density Of Residential Long Term Care Facilities, Per 100–000 Population Low,
  "density_of_residential_long_term_care_facilities_per_1_5e4ef6b2" VARCHAR  -- Density Of Residential Long Term Care Facilities, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_density_of_residential_long_term_care_facilities__426b4772 (
  "year" INTEGER,
  "country" VARCHAR,
  "density_of_residential_long_term_care_facilities_per_1_a48839c6" INTEGER  -- Density Of Residential Long Term Care Facilities, Per 100–000 Population
);

CREATE TABLE owid_dental_assistants_and_therapists_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dental_assistants_and_therapists_number" UINTEGER  -- Dental Assistants And Therapists, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_dental_assistants_and_therapists_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dental_assistants_and_therapists_number" UINTEGER  -- Dental Assistants And Therapists, Number,
  "dental_assistants_and_therapists_number_low" VARCHAR  -- Dental Assistants And Therapists, Number Low,
  "dental_assistants_and_therapists_number_high" VARCHAR  -- Dental Assistants And Therapists, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_dental_prosthetic_technicians_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dental_prosthetic_technicians_number" UINTEGER  -- Dental Prosthetic Technicians, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_dental_prosthetic_technicians_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dental_prosthetic_technicians_number" UINTEGER  -- Dental Prosthetic Technicians, Number,
  "dental_prosthetic_technicians_number_low" VARCHAR  -- Dental Prosthetic Technicians, Number Low,
  "dental_prosthetic_technicians_number_high" VARCHAR  -- Dental Prosthetic Technicians, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_dental_prosthetic_technicians_per_10_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "dental_prosthetic_technicians_per_10_000_population" FLOAT  -- Dental Prosthetic Technicians, Per 10–000 Population
);

CREATE TABLE owid_dental_prosthetic_technicians_per_10_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "dental_prosthetic_technicians_per_10_000_population" FLOAT  -- Dental Prosthetic Technicians, Per 10–000 Population,
  "dental_prosthetic_technicians_per_10_000_population_low" VARCHAR  -- Dental Prosthetic Technicians, Per 10–000 Population Low,
  "dental_prosthetic_technicians_per_10_000_population_high" VARCHAR  -- Dental Prosthetic Technicians, Per 10–000 Population High,
  "comments" VARCHAR
);