Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_existence_of_standards_guidelines_protocols_for_t_7b89f92d (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_for_treatm_d0e203d3" VARCHAR -- Existence Of Standards, Guidelines, Protocols For Treatment And Support Of Carers And Families Of People With Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_of_ca_cab10c79 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_of_care_in_e3db1201" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Hospital For People With Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_of_ca_d126e731 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_of_care_in_c7dca798" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Nursing, And, Residential Care Facilities For People With Dementia,
"existence_of_standards_guidelines_protocols_of_care_in_8717a72e" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Nursing, And, Residential Care Facilities For People With Dementia Low,
"existence_of_standards_guidelines_protocols_of_care_in_a496b285" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Nursing, And, Residential Care Facilities For People With Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_of_ca_e3a4cdcb (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_of_care_in_c7dca798" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Nursing, And, Residential Care Facilities For People With Dementia
);
CREATE TABLE owid_existence_of_standards_guidelines_protocols_of_ca_e7fc0045 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_standards_guidelines_protocols_of_care_in_e3db1201" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Hospital For People With Dementia,
"existence_of_standards_guidelines_protocols_of_care_in_aed3fcf7" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Hospital For People With Dementia Low,
"existence_of_standards_guidelines_protocols_of_care_in_ab167299" VARCHAR -- Existence Of Standards, Guidelines, Protocols Of Care In Hospital For People With Dementia High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_subnational_regulation_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_subnational_regulation" VARCHAR
);
CREATE TABLE owid_existence_of_subnational_regulation_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_subnational_regulation" VARCHAR,
"existence_of_subnational_regulation_low" VARCHAR,
"existence_of_subnational_regulation_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_tax_incentives_to_promote_physical_activity_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_tax_incentives_to_promote_physical_activity" VARCHAR
);
CREATE TABLE owid_existence_of_tax_incentives_to_promote_physical_activity_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_tax_incentives_to_promote_physical_activity" VARCHAR,
"existence_of_tax_incentives_to_promote_physical_activity_low" VARCHAR,
"existence_of_tax_incentives_to_promote_physical_activity_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_tax_on_foods_high_in_fat_sugars_or_salt_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_tax_on_foods_high_in_fat_sugars_or_salt" VARCHAR -- Existence Of Tax On Foods High In Fat, Sugars Or Salt
);
CREATE TABLE owid_existence_of_tax_on_foods_high_in_fat_sugars_or_salt_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_tax_on_foods_high_in_fat_sugars_or_salt" VARCHAR -- Existence Of Tax On Foods High In Fat, Sugars Or Salt,
"existence_of_tax_on_foods_high_in_fat_sugars_or_salt_low" VARCHAR -- Existence Of Tax On Foods High In Fat, Sugars Or Salt Low,
"existence_of_tax_on_foods_high_in_fat_sugars_or_salt_high" VARCHAR -- Existence Of Tax On Foods High In Fat, Sugars Or Salt High,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_tax_on_sugar_sweetened_beverages_1 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_tax_on_sugar_sweetened_beverages" VARCHAR
);
CREATE TABLE owid_existence_of_tax_on_sugar_sweetened_beverages_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_tax_on_sugar_sweetened_beverages" VARCHAR,
"existence_of_tax_on_sugar_sweetened_beverages_low" VARCHAR,
"existence_of_tax_on_sugar_sweetened_beverages_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_existence_of_training_for_mitigation_providers_1 (
"year" INTEGER,
"country" VARCHAR,
"comments" VARCHAR,
"existence_of_training_for_mitigation_providers" VARCHAR
);
CREATE TABLE owid_existence_of_training_for_mitigation_providers_2 (
"year" INTEGER,
"country" VARCHAR,
"existence_of_training_for_mitigation_providers" VARCHAR,
"existence_of_training_for_mitigation_providers_low" VARCHAR,
"existence_of_training_for_mitigation_providers_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_exports_of_beer_barley_in_1000s_hectolitres_1 (
"year" INTEGER,
"country" VARCHAR,
"exports_of_beer_barley_in_1000s_hectolitres" FLOAT -- Exports Of Beer, Barley, In 1000s Hectolitres
);
CREATE TABLE owid_exports_of_beer_barley_in_1000s_hectolitres_2 (
"year" INTEGER,
"country" VARCHAR,
"exports_of_beer_barley_in_1000s_hectolitres" FLOAT -- Exports Of Beer, Barley, In 1000s Hectolitres,
"exports_of_beer_barley_in_1000s_hectolitres_low" VARCHAR -- Exports Of Beer, Barley, In 1000s Hectolitres Low,
"exports_of_beer_barley_in_1000s_hectolitres_high" VARCHAR -- Exports Of Beer, Barley, In 1000s Hectolitres High,
"comments" VARCHAR
);
CREATE TABLE owid_exports_of_spirits_in_1000s_hectolitres_1 (
"year" INTEGER,
"country" VARCHAR,
"exports_of_spirits_in_1000s_hectolitres" FLOAT
);
CREATE TABLE owid_exports_of_spirits_in_1000s_hectolitres_2 (
"year" INTEGER,
"country" VARCHAR,
"exports_of_spirits_in_1000s_hectolitres" FLOAT,
"exports_of_spirits_in_1000s_hectolitres_low" VARCHAR,
"exports_of_spirits_in_1000s_hectolitres_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_exports_of_wine_grape_in_1000s_hectolitres_1 (
"year" INTEGER,
"country" VARCHAR,
"exports_of_wine_grape_in_1000s_hectolitres" FLOAT -- Exports Of Wine, Grape, In 1000s Hectolitres
);
CREATE TABLE owid_exports_of_wine_grape_in_1000s_hectolitres_2 (
"year" INTEGER,
"country" VARCHAR,
"exports_of_wine_grape_in_1000s_hectolitres" FLOAT -- Exports Of Wine, Grape, In 1000s Hectolitres,
"exports_of_wine_grape_in_1000s_hectolitres_low" VARCHAR -- Exports Of Wine, Grape, In 1000s Hectolitres Low,
"exports_of_wine_grape_in_1000s_hectolitres_high" VARCHAR -- Exports Of Wine, Grape, In 1000s Hectolitres High,
"comments" VARCHAR
);
CREATE TABLE owid_extent_of_implementation_of_child_protection_services_1 (
"year" INTEGER,
"country" VARCHAR,
"extent_of_implementation_of_child_protection_services" VARCHAR
);
CREATE TABLE owid_extent_of_implementation_of_child_protection_services_2 (
"year" INTEGER,
"country" VARCHAR,
"extent_of_implementation_of_child_protection_services" VARCHAR,
"extent_of_implementation_of_child_protection_services_low" VARCHAR,
"extent_of_implementation_of_child_protection_services_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_extent_of_implementation_of_medico_legal_services_abfec964 (
"year" INTEGER,
"country" VARCHAR,
"extent_of_implementation_of_medico_legal_services_for__4466f590" VARCHAR -- Extent Of Implementation Of Medico Legal Services For Victims Of Sexual Violence
);
CREATE TABLE owid_extent_of_implementation_of_medico_legal_services_bca9195b (
"year" INTEGER,
"country" VARCHAR,
"extent_of_implementation_of_medico_legal_services_for__4466f590" VARCHAR -- Extent Of Implementation Of Medico Legal Services For Victims Of Sexual Violence,
"extent_of_implementation_of_medico_legal_services_for__aeadbffe" VARCHAR -- Extent Of Implementation Of Medico Legal Services For Victims Of Sexual Violence Low,
"extent_of_implementation_of_medico_legal_services_for__70da8b00" VARCHAR -- Extent Of Implementation Of Medico Legal Services For Victims Of Sexual Violence High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.