Country Profile Overview
@owid.overview
@owid.overview
CREATE TABLE owid_overview_afghanistan (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_albania (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_algeria (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_american_samoa (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" INTEGER,
"share_pop_using_internet" FLOAT,
"gdp_per_capita" FLOAT,
"life_expectancy_at_birth" FLOAT,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);
CREATE TABLE owid_overview_andorra (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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
);
CREATE TABLE owid_overview_angola (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_anguilla (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" INTEGER,
"emissions_total_per_capita" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_antigua_and_barbuda (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_argentina (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_armenia (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_aruba (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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
);
CREATE TABLE owid_overview_australia (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_austria (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_azerbaijan (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_bahamas (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_bahrain (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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
);
CREATE TABLE owid_overview_bangladesh (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_barbados (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_belarus (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_belgium (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_belize (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_benin (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_bermuda (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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,
"deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
CREATE TABLE owid_overview_bhutan (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_bolivia (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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.