Country Profile Overview - Spain

@owid.overview.owid_overview_spain

32.33 KB
348 rows
26 columns


CREATE TABLE owid_overview_spain (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Sri Lanka

@owid.overview.owid_overview_sri_lanka

28.72 KB
338 rows
25 columns


CREATE TABLE owid_overview_sri_lanka (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Sudan

@owid.overview.owid_overview_sudan

22.14 KB
338 rows
17 columns


CREATE TABLE owid_overview_sudan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Suriname

@owid.overview.owid_overview_suriname

21.03 KB
338 rows
16 columns


CREATE TABLE owid_overview_suriname (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Sweden

@owid.overview.owid_overview_sweden

33.48 KB
383 rows
26 columns


CREATE TABLE owid_overview_sweden (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Switzerland

@owid.overview.owid_overview_switzerland

31.68 KB
340 rows
26 columns


CREATE TABLE owid_overview_switzerland (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Syria

@owid.overview.owid_overview_syria

21.18 KB
348 rows
16 columns


CREATE TABLE owid_overview_syria (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Taiwan

@owid.overview.owid_overview_taiwan

26.7 KB
348 rows
22 columns


CREATE TABLE owid_overview_taiwan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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,
  "life_expectancy_at_birth" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_owid" 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 - Tajikistan

@owid.overview.owid_overview_tajikistan

21.66 KB
338 rows
16 columns


CREATE TABLE owid_overview_tajikistan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Tanzania

@owid.overview.owid_overview_tanzania

21.27 KB
338 rows
16 columns


CREATE TABLE owid_overview_tanzania (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Thailand

@owid.overview.owid_overview_thailand

30.38 KB
348 rows
26 columns


CREATE TABLE owid_overview_thailand (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Togo

@owid.overview.owid_overview_togo

21.33 KB
338 rows
16 columns


CREATE TABLE owid_overview_togo (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Tokelau

@owid.overview.owid_overview_tokelau

7.92 KB
156 rows
6 columns


CREATE TABLE owid_overview_tokelau (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" INTEGER,
  "life_expectancy_at_birth" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Tonga

@owid.overview.owid_overview_tonga

16.63 KB
329 rows
12 columns


CREATE TABLE owid_overview_tonga (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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
);

Country Profile Overview - Trinidad And Tobago

@owid.overview.owid_overview_trinidad_and_tobago

28.72 KB
323 rows
25 columns


CREATE TABLE owid_overview_trinidad_and_tobago (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Tunisia

@owid.overview.owid_overview_tunisia

22.3 KB
348 rows
17 columns


CREATE TABLE owid_overview_tunisia (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Turkey

@owid.overview.owid_overview_turkey

30.99 KB
348 rows
26 columns


CREATE TABLE owid_overview_turkey (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Turkmenistan

@owid.overview.owid_overview_turkmenistan

27.76 KB
338 rows
25 columns


CREATE TABLE owid_overview_turkmenistan (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Turks And Caicos Islands

@owid.overview.owid_overview_turks_and_caicos_islands

10.58 KB
185 rows
9 columns


CREATE TABLE owid_overview_turks_and_caicos_islands (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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
);

Country Profile Overview - Tuvalu

@owid.overview.owid_overview_tuvalu

15.06 KB
351 rows
11 columns


CREATE TABLE owid_overview_tuvalu (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Uganda

@owid.overview.owid_overview_uganda

21.4 KB
338 rows
16 columns


CREATE TABLE owid_overview_uganda (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - Ukraine

@owid.overview.owid_overview_ukraine

29.29 KB
338 rows
26 columns


CREATE TABLE owid_overview_ukraine (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - United Arab Emirates

@owid.overview.owid_overview_united_arab_emirates

27.3 KB
338 rows
25 columns


CREATE TABLE owid_overview_united_arab_emirates (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - United Kingdom

@owid.overview.owid_overview_united_kingdom

34.41 KB
430 rows
26 columns


CREATE TABLE owid_overview_united_kingdom (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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 - United States

@owid.overview.owid_overview_united_states

33.3 KB
348 rows
26 columns


CREATE TABLE owid_overview_united_states (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "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

About this Dataset