Country Profile Overview - Ireland

@owid.overview.owid_overview_ireland

31.96 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  -- 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 - Isle Of Man

@owid.overview.owid_overview_isle_of_man

8.57 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

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

@owid.overview.owid_overview_italy

33.12 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  -- 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 - Jamaica

@owid.overview.owid_overview_jamaica

22.64 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  -- 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 - Japan

@owid.overview.owid_overview_japan

32.13 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  -- 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 - Jersey

@owid.overview.owid_overview_jersey

6.93 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.79 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  -- 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 - Kazakhstan

@owid.overview.owid_overview_kazakhstan

30.28 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  -- 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 - Kenya

@owid.overview.owid_overview_kenya

22.3 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  -- 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 - Kiribati

@owid.overview.owid_overview_kiribati

17.81 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  -- 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 - Kosovo

@owid.overview.owid_overview_kosovo

12.6 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

28.36 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  -- 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 - Kyrgyzstan

@owid.overview.owid_overview_kyrgyzstan

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

@owid.overview.owid_overview_laos

21.66 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  -- 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 - Latvia

@owid.overview.owid_overview_latvia

30.48 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  -- 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 - Lebanon

@owid.overview.owid_overview_lebanon

21.8 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  -- 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 - Lesotho

@owid.overview.owid_overview_lesotho

21.47 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  -- 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 - Liberia

@owid.overview.owid_overview_liberia

22.13 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  -- 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 - Libya

@owid.overview.owid_overview_libya

20.64 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  -- 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 - Liechtenstein

@owid.overview.owid_overview_liechtenstein

14.38 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  -- Average Total Years Of Schooling For Adult Population, Lee Lee, 2016, Barro Lee, 2018, And Undp, 2018
);

Country Profile Overview - Lithuania

@owid.overview.owid_overview_lithuania

30.46 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  -- 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 - Luxembourg

@owid.overview.owid_overview_luxembourg

30.44 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  -- 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 - Macao

@owid.overview.owid_overview_macao

16.25 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  -- 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 - Madagascar

@owid.overview.owid_overview_madagascar

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

About this Dataset