Country Profile Overview - Bonaire Sint Eustatius And Saba

@owid.overview.owid_overview_bonaire_sint_eustatius_and_saba

8.44 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.92 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  -- 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 - Botswana

@owid.overview.owid_overview_botswana

21.79 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  -- 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 - Brazil

@owid.overview.owid_overview_brazil

32.45 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  -- 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 - British Virgin Islands

@owid.overview.owid_overview_british_virgin_islands

9.87 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.62 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  -- Nuclear, Twh, Direct,
  "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 - Bulgaria

@owid.overview.owid_overview_bulgaria

31.78 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  -- 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 - Burkina Faso

@owid.overview.owid_overview_burkina_faso

21.78 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  -- 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 - Burundi

@owid.overview.owid_overview_burundi

20.31 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  -- 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 - Cambodia

@owid.overview.owid_overview_cambodia

21.44 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  -- 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 - Cameroon

@owid.overview.owid_overview_cameroon

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

@owid.overview.owid_overview_canada

32.74 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  -- 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 - Cape Verde

@owid.overview.owid_overview_cape_verde

20.9 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  -- 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 - Cayman Islands

@owid.overview.owid_overview_cayman_islands

9.37 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.91 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  -- 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 - Chad

@owid.overview.owid_overview_chad

22.21 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  -- 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 - Chile

@owid.overview.owid_overview_chile

31.86 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  -- 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 - China

@owid.overview.owid_overview_china

31.32 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  -- 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 - Colombia

@owid.overview.owid_overview_colombia

32.16 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  -- 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 - Comoros

@owid.overview.owid_overview_comoros

19.78 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  -- 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 - Congo

@owid.overview.owid_overview_congo

22.3 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  -- 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 - Cook Islands

@owid.overview.owid_overview_cook_islands

11.47 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  -- 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 - Costa Rica

@owid.overview.owid_overview_costa_rica

22.67 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  -- 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 - Cote D'Ivoire

@owid.overview.owid_overview_cote_divoire

22.4 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  -- 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 - Croatia

@owid.overview.owid_overview_croatia

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

About this Dataset