Baselight

Country Profile Overview

@owid.overview

Loading...
Loading...

About this Dataset

Country Profile Overview

Key metrics for understanding the state of the world.

Tables

Country Profile Overview - Ireland

@owid.overview.owid_overview_ireland
  • 31.96 kB
  • 348 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_ireland (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Isle Of Man

@owid.overview.owid_overview_isle_of_man
  • 8.57 kB
  • 153 rows
  • 7 columns
Loading...

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
Loading...

CREATE TABLE owid_overview_israel (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Italy

@owid.overview.owid_overview_italy
  • 33.12 kB
  • 338 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_italy (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Jamaica

@owid.overview.owid_overview_jamaica
  • 22.64 kB
  • 331 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_jamaica (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Japan

@owid.overview.owid_overview_japan
  • 32.13 kB
  • 348 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_japan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Jersey

@owid.overview.owid_overview_jersey
  • 6.93 kB
  • 153 rows
  • 5 columns
Loading...

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
Loading...

CREATE TABLE owid_overview_jordan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Kazakhstan

@owid.overview.owid_overview_kazakhstan
  • 30.28 kB
  • 348 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_kazakhstan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Kenya

@owid.overview.owid_overview_kenya
  • 22.3 kB
  • 338 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_kenya (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Kiribati

@owid.overview.owid_overview_kiribati
  • 17.81 kB
  • 301 rows
  • 13 columns
Loading...

CREATE TABLE owid_overview_kiribati (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Kosovo

@owid.overview.owid_overview_kosovo
  • 12.6 kB
  • 153 rows
  • 12 columns
Loading...

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
Loading...

CREATE TABLE owid_overview_kuwait (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Kyrgyzstan

@owid.overview.owid_overview_kyrgyzstan
  • 22.24 kB
  • 338 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_kyrgyzstan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Laos

@owid.overview.owid_overview_laos
  • 21.66 kB
  • 348 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_laos (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Latvia

@owid.overview.owid_overview_latvia
  • 30.48 kB
  • 348 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_latvia (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Lebanon

@owid.overview.owid_overview_lebanon
  • 21.8 kB
  • 338 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_lebanon (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Lesotho

@owid.overview.owid_overview_lesotho
  • 21.47 kB
  • 338 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_lesotho (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Liberia

@owid.overview.owid_overview_liberia
  • 22.13 kB
  • 338 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_liberia (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Libya

@owid.overview.owid_overview_libya
  • 20.64 kB
  • 348 rows
  • 16 columns
Loading...

CREATE TABLE owid_overview_libya (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT
);

Country Profile Overview - Liechtenstein

@owid.overview.owid_overview_liechtenstein
  • 14.38 kB
  • 338 rows
  • 10 columns
Loading...

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

Country Profile Overview - Lithuania

@owid.overview.owid_overview_lithuania
  • 30.46 kB
  • 343 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_lithuania (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Luxembourg

@owid.overview.owid_overview_luxembourg
  • 30.44 kB
  • 338 rows
  • 26 columns
Loading...

CREATE TABLE owid_overview_luxembourg (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "hydro_twh_direct" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "solar_twh_direct" FLOAT,
  "wind_twh_direct" FLOAT,
  "other_renewables_twh_direct" FLOAT,
  "coal_twh" FLOAT,
  "oil_twh" FLOAT,
  "gas_twh" FLOAT,
  "biofuels_twh" FLOAT,
  "fossil_fuels_twh" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Macao

@owid.overview.owid_overview_macao
  • 16.25 kB
  • 353 rows
  • 12 columns
Loading...

CREATE TABLE owid_overview_macao (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - Madagascar

@owid.overview.owid_overview_madagascar
  • 22.86 kB
  • 338 rows
  • 17 columns
Loading...

CREATE TABLE owid_overview_madagascar (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "nuclear_twh_direct" FLOAT,
  "share_pop_using_internet" FLOAT,
  "gdp_per_capita" FLOAT,
  "share_electricity_access" FLOAT,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Share link

Anyone who has the link will be able to view this.