Country Profile Overview
@owid.overview
@owid.overview
CREATE TABLE owid_overview_gabon (
"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_gambia (
"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_georgia (
"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_germany (
"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_ghana (
"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_gibraltar (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" INTEGER,
"share_pop_using_internet" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_greece (
"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_greenland (
"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
);
CREATE TABLE owid_overview_grenada (
"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_guadeloupe (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" UINTEGER,
"life_expectancy_at_birth" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT
);
CREATE TABLE owid_overview_guam (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"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_guatemala (
"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_guernsey (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" UINTEGER,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_guinea (
"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_guinea_bissau (
"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_guyana (
"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_haiti (
"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_honduras (
"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_hong_kong (
"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,
"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_hungary (
"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_iceland (
"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_india (
"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_indonesia (
"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_iran (
"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_iraq (
"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
);
Anyone who has the link will be able to view this.