Country Profile Overview
@owid.overview
@owid.overview
CREATE TABLE owid_overview_rwanda (
"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_saint_barthelemy (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_saint_helena (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"emissions_total_per_capita" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_saint_kitts_and_nevis (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"emissions_total_per_capita" FLOAT,
"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,
"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_saint_lucia (
"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,
"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_saint_martin_french_part (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_saint_pierre_and_miquelon (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"emissions_total_per_capita" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_saint_vincent_and_the_grenadines (
"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,
"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_samoa (
"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,
"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_san_marino (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"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_sao_tome_and_principe (
"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_saudi_arabia (
"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_senegal (
"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_serbia (
"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_seychelles (
"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
);
CREATE TABLE owid_overview_sierra_leone (
"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_singapore (
"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
);
CREATE TABLE owid_overview_sint_maarten_dutch_part (
"country" VARCHAR,
"year" INTEGER,
"index" UINTEGER,
"population" INTEGER,
"emissions_total_per_capita" FLOAT,
"gdp_per_capita" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_slovakia (
"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,
"biofuels_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_slovenia (
"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,
"biofuels_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_solomon_islands (
"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_somalia (
"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
);
CREATE TABLE owid_overview_south_africa (
"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,
"biofuels_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_south_korea (
"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,
"biofuels_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_south_sudan (
"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
);
Anyone who has the link will be able to view this.