Country Profile Overview - Gabon

@owid.overview.owid_overview_gabon

22.24 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  -- 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 - Gambia

@owid.overview.owid_overview_gambia

21.77 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  -- 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 - Georgia

@owid.overview.owid_overview_georgia

22.27 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  -- 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 - Germany

@owid.overview.owid_overview_germany

33.01 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  -- 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 - Ghana

@owid.overview.owid_overview_ghana

22.09 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  -- 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 - Gibraltar

@owid.overview.owid_overview_gibraltar

8.54 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.96 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  -- 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 - Greenland

@owid.overview.owid_overview_greenland

14.27 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  -- Deaths, Interpersonal Violence, Sex, Both, Age, All Ages, Rate
);

Country Profile Overview - Grenada

@owid.overview.owid_overview_grenada

18.38 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  -- 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 - Guadeloupe

@owid.overview.owid_overview_guadeloupe

8.67 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  -- Child Mortality, Select Gapminder, V10, 2017
);

Country Profile Overview - Guam

@owid.overview.owid_overview_guam

11.57 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  -- 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 - Guatemala

@owid.overview.owid_overview_guatemala

23.07 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  -- 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 - Guernsey

@owid.overview.owid_overview_guernsey

6.95 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

22.02 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  -- 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 - Guinea-Bissau

@owid.overview.owid_overview_guinea_bissau

21.56 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  -- 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 - Guyana

@owid.overview.owid_overview_guyana

22.41 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  -- 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 - Haiti

@owid.overview.owid_overview_haiti

22.67 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  -- 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 - Honduras

@owid.overview.owid_overview_honduras

22.56 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  -- 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 - Hong Kong

@owid.overview.owid_overview_hong_kong

28.06 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  -- 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,
  "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 - Hungary

@owid.overview.owid_overview_hungary

32.28 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  -- 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 - Iceland

@owid.overview.owid_overview_iceland

31.02 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  -- 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 - India

@owid.overview.owid_overview_india

32.26 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  -- 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 - Indonesia

@owid.overview.owid_overview_indonesia

31.02 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  -- 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 - Iran

@owid.overview.owid_overview_iran

30.14 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  -- 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 - Iraq

@owid.overview.owid_overview_iraq

29.56 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  -- 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

About this Dataset