Country Profile Overview
@owid.overview
@owid.overview
CREATE TABLE owid_overview_cuba (
"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_curacao (
"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,
"child_mortality_select_gapminder_v10_2017" FLOAT
);
CREATE TABLE owid_overview_cyprus (
"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_czechia (
"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_democratic_republic_of_congo (
"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_denmark (
"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_djibouti (
"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_dominica (
"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_dominican_republic (
"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_east_timor (
"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_ecuador (
"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_egypt (
"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_el_salvador (
"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_equatorial_guinea (
"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_eritrea (
"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_estonia (
"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_eswatini (
"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_ethiopia (
"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_falkland_islands (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" INTEGER,
"life_expectancy_at_birth" FLOAT
);
CREATE TABLE owid_overview_faroe_islands (
"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
);
CREATE TABLE owid_overview_fiji (
"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_finland (
"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_france (
"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_french_guiana (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" UINTEGER,
"life_expectancy_at_birth" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT
);
CREATE TABLE owid_overview_french_polynesia (
"country" VARCHAR,
"year" INTEGER,
"index" INTEGER,
"population" UINTEGER,
"emissions_total_per_capita" FLOAT,
"share_pop_using_internet" FLOAT,
"share_electricity_access" FLOAT,
"life_expectancy_at_birth" FLOAT,
"child_mortality_select_gapminder_v10_2017" FLOAT,
"daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);
Anyone who has the link will be able to view this.