Country Profile Overview
@owid.overview
@owid.overview
CREATE TABLE owid_overview_united_states_virgin_islands (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);
CREATE TABLE owid_overview_uruguay (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_uzbekistan (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"hydro_twh_direct" FLOAT,
"nuclear_twh_direct" FLOAT,
"solar_twh_direct" FLOAT,
"wind_twh_direct" FLOAT,
"other_renewables_twh_direct" FLOAT,
"coal_twh" FLOAT,
"oil_twh" FLOAT,
"gas_twh" FLOAT,
"fossil_fuels_twh" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_vanuatu (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_venezuela (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"hydro_twh_direct" FLOAT,
"nuclear_twh_direct" FLOAT,
"solar_twh_direct" FLOAT,
"wind_twh_direct" FLOAT,
"other_renewables_twh_direct" FLOAT,
"coal_twh" FLOAT,
"oil_twh" FLOAT,
"gas_twh" FLOAT,
"fossil_fuels_twh" FLOAT,
"share_pop_using_internet" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_vietnam (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"hydro_twh_direct" FLOAT,
"nuclear_twh_direct" FLOAT,
"solar_twh_direct" FLOAT,
"wind_twh_direct" FLOAT,
"other_renewables_twh_direct" FLOAT,
"coal_twh" FLOAT,
"oil_twh" FLOAT,
"gas_twh" FLOAT,
"fossil_fuels_twh" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_wallis_and_futuna (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"emissions_total_per_capita" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_western_sahara (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"life_expectancy_at_birth" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT
);
CREATE TABLE owid_overview_yemen (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"nuclear_twh_direct" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_zambia (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"nuclear_twh_direct" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_zimbabwe (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"nuclear_twh_direct" FLOAT,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"electdem_vdem_high_owid" FLOAT,
"electdem_vdem_low_owid" FLOAT,
"electdem_vdem_owid" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
Anyone who has the link will be able to view this.