Country Profile Overview - Ireland

@owid.overview.owid_overview_ireland

31.21 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,
  "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.37 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

29.44 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,
  "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

32.34 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,
  "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.1 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,
  "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

31.38 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,
  "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.77 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.28 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,
  "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

29.57 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,
  "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

21.78 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,
  "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.39 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,
  "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.3 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

27.7 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,
  "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

21.72 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,
  "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.15 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,
  "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

29.76 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,
  "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.29 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,
  "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

20.97 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,
  "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

21.61 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,
  "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.16 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,
  "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.04 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
);

Country Profile Overview - Lithuania

@owid.overview.owid_overview_lithuania

29.75 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,
  "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

29.73 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,
  "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

15.87 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,
  "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.32 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,
  "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

About this Dataset