Country Profile Overview - Rwanda

@owid.overview.owid_overview_rwanda

21.73 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Saint Barthelemy

@owid.overview.owid_overview_saint_barthelemy

7.03 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

8.09 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

18.13 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Saint Lucia

@owid.overview.owid_overview_saint_lucia

18.34 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Saint Martin (French Part)

@owid.overview.owid_overview_saint_martin_french_part

7.84 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.73 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.49 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Samoa

@owid.overview.owid_overview_samoa

18.32 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - San Marino

@owid.overview.owid_overview_san_marino

13.73 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate
);

Country Profile Overview - Sao Tome And Principe

@owid.overview.owid_overview_sao_tome_and_principe

21.34 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Saudi Arabia

@owid.overview.owid_overview_saudi_arabia

28.39 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  -- Hydro, Twh, Direct,
  "nuclear_twh_direct" FLOAT  -- Nuclear, Twh, Direct,
  "solar_twh_direct" FLOAT  -- Solar, Twh, Direct,
  "wind_twh_direct" FLOAT  -- Wind, Twh, Direct,
  "other_renewables_twh_direct" FLOAT  -- Other Renewables, Twh, Direct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "oil_twh" FLOAT  -- Oil, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "fossil_fuels_twh" FLOAT  -- Fossil Fuels, Twh,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Senegal

@owid.overview.owid_overview_senegal

21.83 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Serbia

@owid.overview.owid_overview_serbia

22.76 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  -- Nuclear, Twh, Direct,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Seychelles

@owid.overview.owid_overview_seychelles

19.62 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018
);

Country Profile Overview - Sierra Leone

@owid.overview.owid_overview_sierra_leone

22.34 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Singapore

@owid.overview.owid_overview_singapore

27.91 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  -- Hydro, Twh, Direct,
  "nuclear_twh_direct" FLOAT  -- Nuclear, Twh, Direct,
  "solar_twh_direct" FLOAT  -- Solar, Twh, Direct,
  "wind_twh_direct" FLOAT  -- Wind, Twh, Direct,
  "other_renewables_twh_direct" FLOAT  -- Other Renewables, Twh, Direct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "oil_twh" FLOAT  -- Oil, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "fossil_fuels_twh" FLOAT  -- Fossil Fuels, Twh,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018
);

Country Profile Overview - Sint Maarten (Dutch Part)

@owid.overview.owid_overview_sint_maarten_dutch_part

9.9 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

31.53 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  -- Hydro, Twh, Direct,
  "nuclear_twh_direct" FLOAT  -- Nuclear, Twh, Direct,
  "solar_twh_direct" FLOAT  -- Solar, Twh, Direct,
  "wind_twh_direct" FLOAT  -- Wind, Twh, Direct,
  "other_renewables_twh_direct" FLOAT  -- Other Renewables, Twh, Direct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "oil_twh" FLOAT  -- Oil, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "biofuels_twh" FLOAT  -- Biofuels, Twh,
  "fossil_fuels_twh" FLOAT  -- Fossil Fuels, Twh,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Slovenia

@owid.overview.owid_overview_slovenia

30.19 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  -- Hydro, Twh, Direct,
  "nuclear_twh_direct" FLOAT  -- Nuclear, Twh, Direct,
  "solar_twh_direct" FLOAT  -- Solar, Twh, Direct,
  "wind_twh_direct" FLOAT  -- Wind, Twh, Direct,
  "other_renewables_twh_direct" FLOAT  -- Other Renewables, Twh, Direct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "oil_twh" FLOAT  -- Oil, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "biofuels_twh" FLOAT  -- Biofuels, Twh,
  "fossil_fuels_twh" FLOAT  -- Fossil Fuels, Twh,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Solomon Islands

@owid.overview.owid_overview_solomon_islands

21.54 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - Somalia

@owid.overview.owid_overview_somalia

19.67 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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018
);

Country Profile Overview - South Africa

@owid.overview.owid_overview_south_africa

31.13 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  -- Hydro, Twh, Direct,
  "nuclear_twh_direct" FLOAT  -- Nuclear, Twh, Direct,
  "solar_twh_direct" FLOAT  -- Solar, Twh, Direct,
  "wind_twh_direct" FLOAT  -- Wind, Twh, Direct,
  "other_renewables_twh_direct" FLOAT  -- Other Renewables, Twh, Direct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "oil_twh" FLOAT  -- Oil, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "biofuels_twh" FLOAT  -- Biofuels, Twh,
  "fossil_fuels_twh" FLOAT  -- Fossil Fuels, Twh,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - South Korea

@owid.overview.owid_overview_south_korea

31.24 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  -- Hydro, Twh, Direct,
  "nuclear_twh_direct" FLOAT  -- Nuclear, Twh, Direct,
  "solar_twh_direct" FLOAT  -- Solar, Twh, Direct,
  "wind_twh_direct" FLOAT  -- Wind, Twh, Direct,
  "other_renewables_twh_direct" FLOAT  -- Other Renewables, Twh, Direct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "oil_twh" FLOAT  -- Oil, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "biofuels_twh" FLOAT  -- Biofuels, Twh,
  "fossil_fuels_twh" FLOAT  -- Fossil Fuels, Twh,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT  -- Daily Caloric Supply, Owid Based On Un Fao, And, Historical Sources
);

Country Profile Overview - South Sudan

@owid.overview.owid_overview_south_sudan

20.32 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  -- Nuclear, Twh, Direct,
  "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  -- Child Mortality, Select Gapminder, V10, 2017,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018
);

Country Profile Overview

About this Dataset