Dataset: Country Profile Overview

Country Profile Overview - Afghanistan

@owid.overview.owid_overview_afghanistan

21.29 KB
348 rows
16 columns


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
);

Country Profile Overview - Albania

@owid.overview.owid_overview_albania

21.32 KB
338 rows
16 columns


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
);

Country Profile Overview - Algeria

@owid.overview.owid_overview_algeria

29.01 KB
338 rows
25 columns


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
);

Country Profile Overview - American Samoa

@owid.overview.owid_overview_american_samoa

10.05 KB
193 rows
8 columns


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
);

Country Profile Overview - Andorra

@owid.overview.owid_overview_andorra

16.71 KB
383 rows
12 columns


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
);

Country Profile Overview - Angola

@owid.overview.owid_overview_angola

21.2 KB
338 rows
17 columns


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
);

Country Profile Overview - Anguilla

@owid.overview.owid_overview_anguilla

8.46 KB
203 rows
6 columns


CREATE TABLE owid_overview_anguilla (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Antigua And Barbuda

@owid.overview.owid_overview_antigua_and_barbuda

17.78 KB
338 rows
13 columns


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
);

Country Profile Overview - Argentina

@owid.overview.owid_overview_argentina

31.95 KB
348 rows
26 columns


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
);

Country Profile Overview - Armenia

@owid.overview.owid_overview_armenia

21.44 KB
338 rows
16 columns


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
);

Country Profile Overview - Aruba

@owid.overview.owid_overview_aruba

11.96 KB
211 rows
10 columns


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
);

Country Profile Overview - Australia

@owid.overview.owid_overview_australia

32.4 KB
383 rows
26 columns


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
);

Country Profile Overview - Austria

@owid.overview.owid_overview_austria

31.96 KB
348 rows
26 columns


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
);

Country Profile Overview - Azerbaijan

@owid.overview.owid_overview_azerbaijan

28.51 KB
338 rows
25 columns


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
);

Country Profile Overview - Bahamas

@owid.overview.owid_overview_bahamas

17.96 KB
338 rows
13 columns


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
);

Country Profile Overview - Bahrain

@owid.overview.owid_overview_bahrain

20.07 KB
338 rows
16 columns


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
);

Country Profile Overview - Bangladesh

@owid.overview.owid_overview_bangladesh

29.45 KB
348 rows
25 columns


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
);

Country Profile Overview - Barbados

@owid.overview.owid_overview_barbados

21.21 KB
334 rows
16 columns


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
);

Country Profile Overview - Belarus

@owid.overview.owid_overview_belarus

29.44 KB
343 rows
26 columns


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
);

Country Profile Overview - Belgium

@owid.overview.owid_overview_belgium

32.81 KB
348 rows
26 columns


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
);

Country Profile Overview - Belize

@owid.overview.owid_overview_belize

18.33 KB
338 rows
13 columns


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
);

Country Profile Overview - Benin

@owid.overview.owid_overview_benin

21.33 KB
338 rows
16 columns


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
);

Country Profile Overview - Bermuda

@owid.overview.owid_overview_bermuda

13.08 KB
167 rows
11 columns


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
);

Country Profile Overview - Bhutan

@owid.overview.owid_overview_bhutan

19.75 KB
383 rows
15 columns


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
);

Country Profile Overview - Bolivia

@owid.overview.owid_overview_bolivia

23.28 KB
338 rows
17 columns


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
);

Country Profile Overview - Bonaire Sint Eustatius And Saba

@owid.overview.owid_overview_bonaire_sint_eustatius_and_saba

8.25 KB
175 rows
6 columns


CREATE TABLE owid_overview_bonaire_sint_eustatius_and_saba (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Bosnia And Herzegovina

@owid.overview.owid_overview_bosnia_and_herzegovina

21.41 KB
348 rows
16 columns


CREATE TABLE owid_overview_bosnia_and_herzegovina (
  "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
);

Country Profile Overview - Botswana

@owid.overview.owid_overview_botswana

21.28 KB
338 rows
16 columns


CREATE TABLE owid_overview_botswana (
  "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
);

Country Profile Overview - Brazil

@owid.overview.owid_overview_brazil

31.69 KB
348 rows
26 columns


CREATE TABLE owid_overview_brazil (
  "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
);

Country Profile Overview - British Virgin Islands

@owid.overview.owid_overview_british_virgin_islands

9.64 KB
160 rows
8 columns


CREATE TABLE owid_overview_british_virgin_islands (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Brunei

@owid.overview.owid_overview_brunei

19.16 KB
383 rows
14 columns


CREATE TABLE owid_overview_brunei (
  "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,
  "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
);

Country Profile Overview - Bulgaria

@owid.overview.owid_overview_bulgaria

31.03 KB
348 rows
26 columns


CREATE TABLE owid_overview_bulgaria (
  "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
);

Country Profile Overview - Burkina Faso

@owid.overview.owid_overview_burkina_faso

21.27 KB
338 rows
16 columns


CREATE TABLE owid_overview_burkina_faso (
  "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
);

Country Profile Overview - Burundi

@owid.overview.owid_overview_burundi

19.84 KB
338 rows
15 columns


CREATE TABLE owid_overview_burundi (
  "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
);

Country Profile Overview - Cambodia

@owid.overview.owid_overview_cambodia

20.94 KB
338 rows
16 columns


CREATE TABLE owid_overview_cambodia (
  "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
);

Country Profile Overview - Cameroon

@owid.overview.owid_overview_cameroon

21.05 KB
338 rows
16 columns


CREATE TABLE owid_overview_cameroon (
  "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
);

Country Profile Overview - Canada

@owid.overview.owid_overview_canada

31.97 KB
352 rows
26 columns


CREATE TABLE owid_overview_canada (
  "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
);

Country Profile Overview - Cape Verde

@owid.overview.owid_overview_cape_verde

20.41 KB
312 rows
16 columns


CREATE TABLE owid_overview_cape_verde (
  "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
);

Country Profile Overview - Cayman Islands

@owid.overview.owid_overview_cayman_islands

9.15 KB
157 rows
8 columns


CREATE TABLE owid_overview_cayman_islands (
  "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
);

Country Profile Overview - Central African Republic

@owid.overview.owid_overview_central_african_republic

21.39 KB
338 rows
16 columns


CREATE TABLE owid_overview_central_african_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
);

Country Profile Overview - Chad

@owid.overview.owid_overview_chad

21.69 KB
338 rows
17 columns


CREATE TABLE owid_overview_chad (
  "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
);

Country Profile Overview - Chile

@owid.overview.owid_overview_chile

31.11 KB
348 rows
25 columns


CREATE TABLE owid_overview_chile (
  "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
);

Country Profile Overview - China

@owid.overview.owid_overview_china

30.59 KB
348 rows
26 columns


CREATE TABLE owid_overview_china (
  "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
);

Country Profile Overview - Colombia

@owid.overview.owid_overview_colombia

31.4 KB
348 rows
26 columns


CREATE TABLE owid_overview_colombia (
  "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
);

Country Profile Overview - Comoros

@owid.overview.owid_overview_comoros

19.32 KB
319 rows
15 columns


CREATE TABLE owid_overview_comoros (
  "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
);

Country Profile Overview - Congo

@owid.overview.owid_overview_congo

21.78 KB
338 rows
17 columns


CREATE TABLE owid_overview_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,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Cook Islands

@owid.overview.owid_overview_cook_islands

11.2 KB
254 rows
8 columns


CREATE TABLE owid_overview_cook_islands (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Costa Rica

@owid.overview.owid_overview_costa_rica

22.14 KB
338 rows
16 columns


CREATE TABLE owid_overview_costa_rica (
  "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
);

Country Profile Overview - Cote D'Ivoire

@owid.overview.owid_overview_cote_divoire

21.87 KB
383 rows
16 columns


CREATE TABLE owid_overview_cote_divoire (
  "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
);

Country Profile Overview - Croatia

@owid.overview.owid_overview_croatia

28.68 KB
338 rows
26 columns


CREATE TABLE owid_overview_croatia (
  "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
);

Country Profile Overview - Cuba

@owid.overview.owid_overview_cuba

22.81 KB
348 rows
17 columns


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
);

Country Profile Overview - Curacao

@owid.overview.owid_overview_curacao

12.26 KB
175 rows
11 columns


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
);

Country Profile Overview - Cyprus

@owid.overview.owid_overview_cyprus

28.62 KB
338 rows
26 columns


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
);

Country Profile Overview - Czechia

@owid.overview.owid_overview_czechia

30.9 KB
348 rows
26 columns


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
);

Country Profile Overview - Democratic Republic Of Congo

@owid.overview.owid_overview_democratic_republic_of_congo

20.83 KB
338 rows
16 columns


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
);

Country Profile Overview - Denmark

@owid.overview.owid_overview_denmark

31.96 KB
349 rows
26 columns


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
);

Country Profile Overview - Djibouti

@owid.overview.owid_overview_djibouti

20.66 KB
338 rows
16 columns


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
);

Country Profile Overview - Dominica

@owid.overview.owid_overview_dominica

17.9 KB
336 rows
13 columns


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
);

Country Profile Overview - Dominican Republic

@owid.overview.owid_overview_dominican_republic

22.56 KB
348 rows
16 columns


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
);

Country Profile Overview - East Timor

@owid.overview.owid_overview_east_timor

20.24 KB
338 rows
16 columns


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
);

Country Profile Overview - Ecuador

@owid.overview.owid_overview_ecuador

30.65 KB
338 rows
26 columns


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
);

Country Profile Overview - Egypt

@owid.overview.owid_overview_egypt

29.55 KB
348 rows
25 columns


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
);

Country Profile Overview - El Salvador

@owid.overview.owid_overview_el_salvador

22.03 KB
338 rows
16 columns


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
);

Country Profile Overview - Equatorial Guinea

@owid.overview.owid_overview_equatorial_guinea

20.01 KB
338 rows
16 columns


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
);

Country Profile Overview - Eritrea

@owid.overview.owid_overview_eritrea

19.07 KB
338 rows
15 columns


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
);

Country Profile Overview - Estonia

@owid.overview.owid_overview_estonia

29.78 KB
348 rows
26 columns


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
);

Country Profile Overview - Eswatini

@owid.overview.owid_overview_eswatini

21.09 KB
338 rows
16 columns


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
);

Country Profile Overview - Ethiopia

@owid.overview.owid_overview_ethiopia

20.43 KB
348 rows
16 columns


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
);

Country Profile Overview - Falkland Islands

@owid.overview.owid_overview_falkland_islands

7.15 KB
179 rows
5 columns


CREATE TABLE owid_overview_falkland_islands (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Faroe Islands

@owid.overview.owid_overview_faroe_islands

10.96 KB
203 rows
9 columns


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
);

Country Profile Overview - Fiji

@owid.overview.owid_overview_fiji

21.36 KB
329 rows
16 columns


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
);

Country Profile Overview - Finland

@owid.overview.owid_overview_finland

32.12 KB
352 rows
26 columns


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
);

Country Profile Overview - France

@owid.overview.owid_overview_france

33.58 KB
349 rows
26 columns


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
);

Country Profile Overview - French Guiana

@owid.overview.owid_overview_french_guiana

8.49 KB
203 rows
6 columns


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
);

Country Profile Overview - French Polynesia

@owid.overview.owid_overview_french_polynesia

11.85 KB
160 rows
10 columns


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
);

Country Profile Overview - Gabon

@owid.overview.owid_overview_gabon

21.72 KB
338 rows
17 columns


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
);

Country Profile Overview - Gambia

@owid.overview.owid_overview_gambia

21.26 KB
338 rows
16 columns


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
);

Country Profile Overview - Georgia

@owid.overview.owid_overview_georgia

21.75 KB
338 rows
16 columns


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
);

Country Profile Overview - Germany

@owid.overview.owid_overview_germany

32.23 KB
348 rows
26 columns


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
);

Country Profile Overview - Ghana

@owid.overview.owid_overview_ghana

21.57 KB
338 rows
16 columns


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
);

Country Profile Overview - Gibraltar

@owid.overview.owid_overview_gibraltar

8.34 KB
153 rows
7 columns


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
);

Country Profile Overview - Greece

@owid.overview.owid_overview_greece

31.21 KB
348 rows
26 columns


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
);

Country Profile Overview - Greenland

@owid.overview.owid_overview_greenland

13.94 KB
363 rows
10 columns


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
);

Country Profile Overview - Grenada

@owid.overview.owid_overview_grenada

17.95 KB
338 rows
13 columns


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
);

Country Profile Overview - Guadeloupe

@owid.overview.owid_overview_guadeloupe

8.47 KB
203 rows
6 columns


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
);

Country Profile Overview - Guam

@owid.overview.owid_overview_guam

11.3 KB
161 rows
10 columns


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
);

Country Profile Overview - Guatemala

@owid.overview.owid_overview_guatemala

22.53 KB
348 rows
16 columns


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
);

Country Profile Overview - Guernsey

@owid.overview.owid_overview_guernsey

6.78 KB
153 rows
5 columns


CREATE TABLE owid_overview_guernsey (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Guinea

@owid.overview.owid_overview_guinea

21.51 KB
383 rows
16 columns


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
);

Country Profile Overview - Guinea-Bissau

@owid.overview.owid_overview_guinea_bissau

21.05 KB
338 rows
16 columns


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
);

Country Profile Overview - Guyana

@owid.overview.owid_overview_guyana

21.88 KB
338 rows
16 columns


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
);

Country Profile Overview - Haiti

@owid.overview.owid_overview_haiti

22.14 KB
348 rows
16 columns


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
);

Country Profile Overview - Honduras

@owid.overview.owid_overview_honduras

22.03 KB
338 rows
16 columns


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
);

Country Profile Overview - Hong Kong

@owid.overview.owid_overview_hong_kong

27.4 KB
338 rows
25 columns


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
);

Country Profile Overview - Hungary

@owid.overview.owid_overview_hungary

31.52 KB
348 rows
26 columns


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
);

Country Profile Overview - Iceland

@owid.overview.owid_overview_iceland

30.29 KB
338 rows
26 columns


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
);

Country Profile Overview - India

@owid.overview.owid_overview_india

31.5 KB
348 rows
26 columns


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
);

Country Profile Overview - Indonesia

@owid.overview.owid_overview_indonesia

30.29 KB
338 rows
26 columns


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
);

Country Profile Overview - Iran

@owid.overview.owid_overview_iran

29.44 KB
348 rows
25 columns


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
);

Country Profile Overview - Iraq

@owid.overview.owid_overview_iraq

28.87 KB
348 rows
25 columns


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
);

Country Profile Overview - Ireland

@owid.overview.owid_overview_ireland

31.21 KB
348 rows
26 columns


CREATE TABLE owid_overview_ireland (
  "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
);

Country Profile Overview - Isle Of Man

@owid.overview.owid_overview_isle_of_man

8.37 KB
153 rows
7 columns


CREATE TABLE owid_overview_isle_of_man (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Israel

@owid.overview.owid_overview_israel

29.44 KB
348 rows
26 columns


CREATE TABLE owid_overview_israel (
  "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
);

Country Profile Overview - Italy

@owid.overview.owid_overview_italy

32.34 KB
338 rows
26 columns


CREATE TABLE owid_overview_italy (
  "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
);

Country Profile Overview - Jamaica

@owid.overview.owid_overview_jamaica

22.1 KB
331 rows
16 columns


CREATE TABLE owid_overview_jamaica (
  "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
);

Country Profile Overview - Japan

@owid.overview.owid_overview_japan

31.38 KB
348 rows
26 columns


CREATE TABLE owid_overview_japan (
  "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
);

Country Profile Overview - Jersey

@owid.overview.owid_overview_jersey

6.77 KB
153 rows
5 columns


CREATE TABLE owid_overview_jersey (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Jordan

@owid.overview.owid_overview_jordan

21.28 KB
338 rows
16 columns


CREATE TABLE owid_overview_jordan (
  "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
);

Country Profile Overview - Kazakhstan

@owid.overview.owid_overview_kazakhstan

29.57 KB
348 rows
26 columns


CREATE TABLE owid_overview_kazakhstan (
  "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
);

Country Profile Overview - Kenya

@owid.overview.owid_overview_kenya

21.78 KB
338 rows
16 columns


CREATE TABLE owid_overview_kenya (
  "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
);

Country Profile Overview - Kiribati

@owid.overview.owid_overview_kiribati

17.39 KB
301 rows
13 columns


CREATE TABLE owid_overview_kiribati (
  "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
);

Country Profile Overview - Kosovo

@owid.overview.owid_overview_kosovo

12.3 KB
153 rows
12 columns


CREATE TABLE owid_overview_kosovo (
  "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
);

Country Profile Overview - Kuwait

@owid.overview.owid_overview_kuwait

27.7 KB
348 rows
25 columns


CREATE TABLE owid_overview_kuwait (
  "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
);

Country Profile Overview - Kyrgyzstan

@owid.overview.owid_overview_kyrgyzstan

21.72 KB
338 rows
16 columns


CREATE TABLE owid_overview_kyrgyzstan (
  "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
);

Country Profile Overview - Laos

@owid.overview.owid_overview_laos

21.15 KB
348 rows
16 columns


CREATE TABLE owid_overview_laos (
  "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
);

Country Profile Overview - Latvia

@owid.overview.owid_overview_latvia

29.76 KB
348 rows
26 columns


CREATE TABLE owid_overview_latvia (
  "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
);

Country Profile Overview - Lebanon

@owid.overview.owid_overview_lebanon

21.29 KB
338 rows
16 columns


CREATE TABLE owid_overview_lebanon (
  "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
);

Country Profile Overview - Lesotho

@owid.overview.owid_overview_lesotho

20.97 KB
338 rows
16 columns


CREATE TABLE owid_overview_lesotho (
  "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
);

Country Profile Overview - Liberia

@owid.overview.owid_overview_liberia

21.61 KB
338 rows
16 columns


CREATE TABLE owid_overview_liberia (
  "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
);

Country Profile Overview - Libya

@owid.overview.owid_overview_libya

20.16 KB
348 rows
16 columns


CREATE TABLE owid_overview_libya (
  "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
);

Country Profile Overview - Liechtenstein

@owid.overview.owid_overview_liechtenstein

14.04 KB
338 rows
10 columns


CREATE TABLE owid_overview_liechtenstein (
  "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,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT
);

Country Profile Overview - Lithuania

@owid.overview.owid_overview_lithuania

29.75 KB
343 rows
26 columns


CREATE TABLE owid_overview_lithuania (
  "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
);

Country Profile Overview - Luxembourg

@owid.overview.owid_overview_luxembourg

29.73 KB
338 rows
26 columns


CREATE TABLE owid_overview_luxembourg (
  "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
);

Country Profile Overview - Macao

@owid.overview.owid_overview_macao

15.87 KB
353 rows
12 columns


CREATE TABLE owid_overview_macao (
  "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,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Madagascar

@owid.overview.owid_overview_madagascar

22.32 KB
338 rows
17 columns


CREATE TABLE owid_overview_madagascar (
  "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
);

Country Profile Overview - Malawi

@owid.overview.owid_overview_malawi

21.2 KB
338 rows
16 columns


CREATE TABLE owid_overview_malawi (
  "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
);

Country Profile Overview - Malaysia

@owid.overview.owid_overview_malaysia

29.68 KB
338 rows
26 columns


CREATE TABLE owid_overview_malaysia (
  "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
);

Country Profile Overview - Maldives

@owid.overview.owid_overview_maldives

20.13 KB
301 rows
16 columns


CREATE TABLE owid_overview_maldives (
  "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
);

Country Profile Overview - Mali

@owid.overview.owid_overview_mali

21.15 KB
338 rows
16 columns


CREATE TABLE owid_overview_mali (
  "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
);

Country Profile Overview - Malta

@owid.overview.owid_overview_malta

21.19 KB
338 rows
16 columns


CREATE TABLE owid_overview_malta (
  "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
);

Country Profile Overview - Marshall Islands

@owid.overview.owid_overview_marshall_islands

15.85 KB
301 rows
12 columns


CREATE TABLE owid_overview_marshall_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,
  "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
);

Country Profile Overview - Martinique

@owid.overview.owid_overview_martinique

8.36 KB
197 rows
6 columns


CREATE TABLE owid_overview_martinique (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT
);

Country Profile Overview - Mauritania

@owid.overview.owid_overview_mauritania

21.68 KB
383 rows
16 columns


CREATE TABLE owid_overview_mauritania (
  "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
);

Country Profile Overview - Mauritius

@owid.overview.owid_overview_mauritius

21.43 KB
311 rows
16 columns


CREATE TABLE owid_overview_mauritius (
  "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
);

Country Profile Overview - Mayotte

@owid.overview.owid_overview_mayotte

7.98 KB
177 rows
6 columns


CREATE TABLE owid_overview_mayotte (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT
);

Country Profile Overview - Mexico

@owid.overview.owid_overview_mexico

31.74 KB
348 rows
26 columns


CREATE TABLE owid_overview_mexico (
  "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
);

Country Profile Overview - Micronesia (country)

@owid.overview.owid_overview_micronesia_country

15.79 KB
301 rows
12 columns


CREATE TABLE owid_overview_micronesia_country (
  "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
);

Country Profile Overview - Moldova

@owid.overview.owid_overview_moldova

21.77 KB
348 rows
16 columns


CREATE TABLE owid_overview_moldova (
  "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
);

Country Profile Overview - Monaco

@owid.overview.owid_overview_monaco

13.52 KB
301 rows
10 columns


CREATE TABLE owid_overview_monaco (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "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
);

Country Profile Overview - Mongolia

@owid.overview.owid_overview_mongolia

21.76 KB
338 rows
17 columns


CREATE TABLE owid_overview_mongolia (
  "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
);

Country Profile Overview - Montenegro

@owid.overview.owid_overview_montenegro

19.93 KB
312 rows
16 columns


CREATE TABLE owid_overview_montenegro (
  "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
);

Country Profile Overview - Montserrat

@owid.overview.owid_overview_montserrat

8.37 KB
191 rows
6 columns


CREATE TABLE owid_overview_montserrat (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Morocco

@owid.overview.owid_overview_morocco

29.24 KB
348 rows
25 columns


CREATE TABLE owid_overview_morocco (
  "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
);

Country Profile Overview - Mozambique

@owid.overview.owid_overview_mozambique

21.81 KB
338 rows
17 columns


CREATE TABLE owid_overview_mozambique (
  "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
);

Country Profile Overview - Myanmar

@owid.overview.owid_overview_myanmar

22.38 KB
348 rows
17 columns


CREATE TABLE owid_overview_myanmar (
  "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
);

Country Profile Overview - Namibia

@owid.overview.owid_overview_namibia

21.01 KB
338 rows
16 columns


CREATE TABLE owid_overview_namibia (
  "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
);

Country Profile Overview - Nauru

@owid.overview.owid_overview_nauru

14.49 KB
301 rows
11 columns


CREATE TABLE owid_overview_nauru (
  "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,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Nepal

@owid.overview.owid_overview_nepal

21.43 KB
348 rows
16 columns


CREATE TABLE owid_overview_nepal (
  "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
);

Country Profile Overview - Netherlands

@owid.overview.owid_overview_netherlands

32.7 KB
348 rows
26 columns


CREATE TABLE owid_overview_netherlands (
  "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
);

Country Profile Overview - New Caledonia

@owid.overview.owid_overview_new_caledonia

13.92 KB
203 rows
12 columns


CREATE TABLE owid_overview_new_caledonia (
  "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,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - New Zealand

@owid.overview.owid_overview_new_zealand

30.61 KB
316 rows
26 columns


CREATE TABLE owid_overview_new_zealand (
  "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
);

Country Profile Overview - Nicaragua

@owid.overview.owid_overview_nicaragua

22.18 KB
338 rows
16 columns


CREATE TABLE owid_overview_nicaragua (
  "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
);

Country Profile Overview - Niger

@owid.overview.owid_overview_niger

21.3 KB
338 rows
16 columns


CREATE TABLE owid_overview_niger (
  "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
);

Country Profile Overview - Nigeria

@owid.overview.owid_overview_nigeria

22.02 KB
338 rows
17 columns


CREATE TABLE owid_overview_nigeria (
  "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
);

Country Profile Overview - Niue

@owid.overview.owid_overview_niue

10.87 KB
251 rows
8 columns


CREATE TABLE owid_overview_niue (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - North Korea

@owid.overview.owid_overview_north_korea

18.93 KB
348 rows
14 columns


CREATE TABLE owid_overview_north_korea (
  "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,
  "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,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - North Macedonia

@owid.overview.owid_overview_north_macedonia

29.17 KB
348 rows
26 columns


CREATE TABLE owid_overview_north_macedonia (
  "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
);

Country Profile Overview - Northern Mariana Islands

@owid.overview.owid_overview_northern_mariana_islands

10.33 KB
153 rows
9 columns


CREATE TABLE owid_overview_northern_mariana_islands (
  "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,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Norway

@owid.overview.owid_overview_norway

32.33 KB
348 rows
26 columns


CREATE TABLE owid_overview_norway (
  "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
);

Country Profile Overview - Oman

@owid.overview.owid_overview_oman

27.29 KB
348 rows
25 columns


CREATE TABLE owid_overview_oman (
  "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
);

Country Profile Overview - Pakistan

@owid.overview.owid_overview_pakistan

29.65 KB
338 rows
25 columns


CREATE TABLE owid_overview_pakistan (
  "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
);

Country Profile Overview - Palau

@owid.overview.owid_overview_palau

15.8 KB
301 rows
12 columns


CREATE TABLE owid_overview_palau (
  "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,
  "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
);

Country Profile Overview - Palestine

@owid.overview.owid_overview_palestine

17.82 KB
301 rows
15 columns


CREATE TABLE owid_overview_palestine (
  "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
);

Country Profile Overview - Panama

@owid.overview.owid_overview_panama

21.8 KB
338 rows
16 columns


CREATE TABLE owid_overview_panama (
  "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
);

Country Profile Overview - Papua New Guinea

@owid.overview.owid_overview_papua_new_guinea

20.97 KB
383 rows
16 columns


CREATE TABLE owid_overview_papua_new_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
);

Country Profile Overview - Paraguay

@owid.overview.owid_overview_paraguay

22.21 KB
338 rows
16 columns


CREATE TABLE owid_overview_paraguay (
  "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
);

Country Profile Overview - Peru

@owid.overview.owid_overview_peru

31.35 KB
348 rows
26 columns


CREATE TABLE owid_overview_peru (
  "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
);

Country Profile Overview - Philippines

@owid.overview.owid_overview_philippines

30.42 KB
338 rows
26 columns


CREATE TABLE owid_overview_philippines (
  "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
);

Country Profile Overview - Poland

@owid.overview.owid_overview_poland

31.09 KB
344 rows
26 columns


CREATE TABLE owid_overview_poland (
  "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
);

Country Profile Overview - Portugal

@owid.overview.owid_overview_portugal

31.27 KB
348 rows
26 columns


CREATE TABLE owid_overview_portugal (
  "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
);

Country Profile Overview - Puerto Rico

@owid.overview.owid_overview_puerto_rico

12.12 KB
199 rows
10 columns


CREATE TABLE owid_overview_puerto_rico (
  "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
);

Country Profile Overview - Qatar

@owid.overview.owid_overview_qatar

25.5 KB
338 rows
24 columns


CREATE TABLE owid_overview_qatar (
  "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
);

Country Profile Overview - Reunion

@owid.overview.owid_overview_reunion

9.33 KB
186 rows
7 columns


CREATE TABLE owid_overview_reunion (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT
);

Country Profile Overview - Romania

@owid.overview.owid_overview_romania

31.1 KB
348 rows
26 columns


CREATE TABLE owid_overview_romania (
  "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
);

Country Profile Overview - Russia

@owid.overview.owid_overview_russia

29.94 KB
348 rows
26 columns


CREATE TABLE owid_overview_russia (
  "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
);

Country Profile Overview - Rwanda

@owid.overview.owid_overview_rwanda

21.22 KB
338 rows
16 columns


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
);

Country Profile Overview - Saint Barthelemy

@owid.overview.owid_overview_saint_barthelemy

6.87 KB
155 rows
5 columns


CREATE TABLE owid_overview_saint_barthelemy (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" INTEGER,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Saint Helena

@owid.overview.owid_overview_saint_helena

7.9 KB
163 rows
6 columns


CREATE TABLE owid_overview_saint_helena (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" INTEGER,
  "emissions_total_per_capita" FLOAT,
  "life_expectancy_at_birth" FLOAT
);

Country Profile Overview - Saint Kitts And Nevis

@owid.overview.owid_overview_saint_kitts_and_nevis

17.7 KB
327 rows
13 columns


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
);

Country Profile Overview - Saint Lucia

@owid.overview.owid_overview_saint_lucia

17.91 KB
338 rows
13 columns


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
);

Country Profile Overview - Saint Martin (French Part)

@owid.overview.owid_overview_saint_martin_french_part

7.66 KB
153 rows
6 columns


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
);

Country Profile Overview - Saint Pierre And Miquelon

@owid.overview.owid_overview_saint_pierre_and_miquelon

8.53 KB
189 rows
6 columns


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
);

Country Profile Overview - Saint Vincent And The Grenadines

@owid.overview.owid_overview_saint_vincent_and_the_grenadines

18.06 KB
328 rows
13 columns


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
);

Country Profile Overview - Samoa

@owid.overview.owid_overview_samoa

17.89 KB
328 rows
13 columns


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
);

Country Profile Overview - San Marino

@owid.overview.owid_overview_san_marino

13.41 KB
301 rows
10 columns


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
);

Country Profile Overview - Sao Tome And Principe

@owid.overview.owid_overview_sao_tome_and_principe

20.83 KB
338 rows
16 columns


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
);

Country Profile Overview - Saudi Arabia

@owid.overview.owid_overview_saudi_arabia

27.73 KB
348 rows
25 columns


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
);

Country Profile Overview - Senegal

@owid.overview.owid_overview_senegal

21.32 KB
338 rows
16 columns


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
);

Country Profile Overview - Serbia

@owid.overview.owid_overview_serbia

22.22 KB
348 rows
17 columns


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
);

Country Profile Overview - Seychelles

@owid.overview.owid_overview_seychelles

19.16 KB
301 rows
15 columns


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
);

Country Profile Overview - Sierra Leone

@owid.overview.owid_overview_sierra_leone

21.82 KB
383 rows
16 columns


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
);

Country Profile Overview - Singapore

@owid.overview.owid_overview_singapore

27.25 KB
383 rows
24 columns


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
);

Country Profile Overview - Sint Maarten (Dutch Part)

@owid.overview.owid_overview_sint_maarten_dutch_part

9.67 KB
175 rows
8 columns


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
);

Country Profile Overview - Slovakia

@owid.overview.owid_overview_slovakia

30.79 KB
348 rows
26 columns


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
);

Country Profile Overview - Slovenia

@owid.overview.owid_overview_slovenia

29.48 KB
338 rows
26 columns


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
);

Country Profile Overview - Solomon Islands

@owid.overview.owid_overview_solomon_islands

21.04 KB
338 rows
16 columns


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
);

Country Profile Overview - Somalia

@owid.overview.owid_overview_somalia

19.21 KB
338 rows
15 columns


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
);

Country Profile Overview - South Africa

@owid.overview.owid_overview_south_africa

30.4 KB
338 rows
26 columns


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
);

Country Profile Overview - South Korea

@owid.overview.owid_overview_south_korea

30.51 KB
348 rows
26 columns


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
);

Country Profile Overview - South Sudan

@owid.overview.owid_overview_south_sudan

19.84 KB
303 rows
16 columns


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
);

Country Profile Overview - Spain

@owid.overview.owid_overview_spain

32.33 KB
348 rows
26 columns


CREATE TABLE owid_overview_spain (
  "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
);

Country Profile Overview - Sri Lanka

@owid.overview.owid_overview_sri_lanka

28.72 KB
338 rows
25 columns


CREATE TABLE owid_overview_sri_lanka (
  "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
);

Country Profile Overview - Sudan

@owid.overview.owid_overview_sudan

22.14 KB
338 rows
17 columns


CREATE TABLE owid_overview_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,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Suriname

@owid.overview.owid_overview_suriname

21.03 KB
338 rows
16 columns


CREATE TABLE owid_overview_suriname (
  "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
);

Country Profile Overview - Sweden

@owid.overview.owid_overview_sweden

33.48 KB
383 rows
26 columns


CREATE TABLE owid_overview_sweden (
  "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
);

Country Profile Overview - Switzerland

@owid.overview.owid_overview_switzerland

31.68 KB
340 rows
26 columns


CREATE TABLE owid_overview_switzerland (
  "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
);

Country Profile Overview - Syria

@owid.overview.owid_overview_syria

21.18 KB
348 rows
16 columns


CREATE TABLE owid_overview_syria (
  "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
);

Country Profile Overview - Taiwan

@owid.overview.owid_overview_taiwan

26.7 KB
348 rows
22 columns


CREATE TABLE owid_overview_taiwan (
  "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,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" 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
);

Country Profile Overview - Tajikistan

@owid.overview.owid_overview_tajikistan

21.66 KB
338 rows
16 columns


CREATE TABLE owid_overview_tajikistan (
  "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
);

Country Profile Overview - Tanzania

@owid.overview.owid_overview_tanzania

21.27 KB
338 rows
16 columns


CREATE TABLE owid_overview_tanzania (
  "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
);

Country Profile Overview - Thailand

@owid.overview.owid_overview_thailand

30.38 KB
348 rows
26 columns


CREATE TABLE owid_overview_thailand (
  "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
);

Country Profile Overview - Togo

@owid.overview.owid_overview_togo

21.33 KB
338 rows
16 columns


CREATE TABLE owid_overview_togo (
  "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
);

Country Profile Overview - Tokelau

@owid.overview.owid_overview_tokelau

7.92 KB
156 rows
6 columns


CREATE TABLE owid_overview_tokelau (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" INTEGER,
  "life_expectancy_at_birth" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Tonga

@owid.overview.owid_overview_tonga

16.63 KB
329 rows
12 columns


CREATE TABLE owid_overview_tonga (
  "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
);

Country Profile Overview - Trinidad And Tobago

@owid.overview.owid_overview_trinidad_and_tobago

28.72 KB
323 rows
25 columns


CREATE TABLE owid_overview_trinidad_and_tobago (
  "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
);

Country Profile Overview - Tunisia

@owid.overview.owid_overview_tunisia

22.3 KB
348 rows
17 columns


CREATE TABLE owid_overview_tunisia (
  "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
);

Country Profile Overview - Turkey

@owid.overview.owid_overview_turkey

30.99 KB
348 rows
26 columns


CREATE TABLE owid_overview_turkey (
  "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
);

Country Profile Overview - Turkmenistan

@owid.overview.owid_overview_turkmenistan

27.76 KB
338 rows
25 columns


CREATE TABLE owid_overview_turkmenistan (
  "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
);

Country Profile Overview - Turks And Caicos Islands

@owid.overview.owid_overview_turks_and_caicos_islands

10.58 KB
185 rows
9 columns


CREATE TABLE owid_overview_turks_and_caicos_islands (
  "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
);

Country Profile Overview - Tuvalu

@owid.overview.owid_overview_tuvalu

15.06 KB
351 rows
11 columns


CREATE TABLE owid_overview_tuvalu (
  "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
);

Country Profile Overview - Uganda

@owid.overview.owid_overview_uganda

21.4 KB
338 rows
16 columns


CREATE TABLE owid_overview_uganda (
  "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
);

Country Profile Overview - Ukraine

@owid.overview.owid_overview_ukraine

29.29 KB
338 rows
26 columns


CREATE TABLE owid_overview_ukraine (
  "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
);

Country Profile Overview - United Arab Emirates

@owid.overview.owid_overview_united_arab_emirates

27.3 KB
338 rows
25 columns


CREATE TABLE owid_overview_united_arab_emirates (
  "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
);

Country Profile Overview - United Kingdom

@owid.overview.owid_overview_united_kingdom

34.41 KB
430 rows
26 columns


CREATE TABLE owid_overview_united_kingdom (
  "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
);

Country Profile Overview - United States

@owid.overview.owid_overview_united_states

33.3 KB
348 rows
26 columns


CREATE TABLE owid_overview_united_states (
  "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
);

Country Profile Overview - United States Virgin Islands

@owid.overview.owid_overview_united_states_virgin_islands

11.86 KB
191 rows
10 columns


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
);

Country Profile Overview - Uruguay

@owid.overview.owid_overview_uruguay

22.73 KB
338 rows
16 columns


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
);

Country Profile Overview - Uzbekistan

@owid.overview.owid_overview_uzbekistan

28.31 KB
348 rows
25 columns


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
);

Country Profile Overview - Vanuatu

@owid.overview.owid_overview_vanuatu

20.51 KB
328 rows
16 columns


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
);

Country Profile Overview - Venezuela

@owid.overview.owid_overview_venezuela

29.47 KB
348 rows
24 columns


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
);

Country Profile Overview - Vietnam

@owid.overview.owid_overview_vietnam

28.66 KB
338 rows
25 columns


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
);

Country Profile Overview - Wallis And Futuna

@owid.overview.owid_overview_wallis_and_futuna

7.75 KB
153 rows
6 columns


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
);

Country Profile Overview - Western Sahara

@owid.overview.owid_overview_western_sahara

8.38 KB
196 rows
6 columns


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
);

Country Profile Overview - Yemen

@owid.overview.owid_overview_yemen

22.04 KB
348 rows
17 columns


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
);

Country Profile Overview - Zambia

@owid.overview.owid_overview_zambia

22.27 KB
338 rows
17 columns


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
);

Country Profile Overview - Zimbabwe

@owid.overview.owid_overview_zimbabwe

22.37 KB
338 rows
17 columns


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
);