Country Profile Overview - New Zealand

@owid.overview.owid_overview_new_zealand

30.61 KB
316 rows
26 columns


CREATE TABLE owid_overview_new_zealand (
  "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 - Nicaragua

@owid.overview.owid_overview_nicaragua

22.18 KB
338 rows
16 columns


CREATE TABLE owid_overview_nicaragua (
  "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 - Niger

@owid.overview.owid_overview_niger

21.3 KB
338 rows
16 columns


CREATE TABLE owid_overview_niger (
  "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 - Nigeria

@owid.overview.owid_overview_nigeria

22.02 KB
338 rows
17 columns


CREATE TABLE owid_overview_nigeria (
  "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 - Niue

@owid.overview.owid_overview_niue

10.87 KB
251 rows
8 columns


CREATE TABLE owid_overview_niue (
  "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,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - Northern Mariana Islands

@owid.overview.owid_overview_northern_mariana_islands

10.33 KB
153 rows
9 columns


CREATE TABLE owid_overview_northern_mariana_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,
  "deaths_interpersonal_violence_sex_both_age_all_ages_rate" FLOAT
);

Country Profile Overview - North Korea

@owid.overview.owid_overview_north_korea

18.93 KB
348 rows
14 columns


CREATE TABLE owid_overview_north_korea (
  "country" VARCHAR,
  "year" INTEGER,
  "index" INTEGER,
  "population" UINTEGER,
  "emissions_total_per_capita" FLOAT,
  "share_pop_using_internet" 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,
  "daily_caloric_supply_owid_based_on_un_fao_and_historic_031ed125" FLOAT
);

Country Profile Overview - North Macedonia

@owid.overview.owid_overview_north_macedonia

29.17 KB
348 rows
26 columns


CREATE TABLE owid_overview_north_macedonia (
  "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 - Norway

@owid.overview.owid_overview_norway

32.33 KB
348 rows
26 columns


CREATE TABLE owid_overview_norway (
  "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 - Oman

@owid.overview.owid_overview_oman

27.29 KB
348 rows
25 columns


CREATE TABLE owid_overview_oman (
  "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 - Pakistan

@owid.overview.owid_overview_pakistan

29.65 KB
338 rows
25 columns


CREATE TABLE owid_overview_pakistan (
  "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 - Palau

@owid.overview.owid_overview_palau

15.8 KB
301 rows
12 columns


CREATE TABLE owid_overview_palau (
  "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,
  "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 - Palestine

@owid.overview.owid_overview_palestine

17.82 KB
301 rows
15 columns


CREATE TABLE owid_overview_palestine (
  "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
);

Country Profile Overview - Panama

@owid.overview.owid_overview_panama

21.8 KB
338 rows
16 columns


CREATE TABLE owid_overview_panama (
  "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 - Papua New Guinea

@owid.overview.owid_overview_papua_new_guinea

20.97 KB
383 rows
16 columns


CREATE TABLE owid_overview_papua_new_guinea (
  "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 - Paraguay

@owid.overview.owid_overview_paraguay

22.21 KB
338 rows
16 columns


CREATE TABLE owid_overview_paraguay (
  "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 - Peru

@owid.overview.owid_overview_peru

31.35 KB
348 rows
26 columns


CREATE TABLE owid_overview_peru (
  "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 - Philippines

@owid.overview.owid_overview_philippines

30.42 KB
338 rows
26 columns


CREATE TABLE owid_overview_philippines (
  "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 - Poland

@owid.overview.owid_overview_poland

31.09 KB
344 rows
26 columns


CREATE TABLE owid_overview_poland (
  "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 - Portugal

@owid.overview.owid_overview_portugal

31.27 KB
348 rows
26 columns


CREATE TABLE owid_overview_portugal (
  "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 - Puerto Rico

@owid.overview.owid_overview_puerto_rico

12.12 KB
199 rows
10 columns


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

@owid.overview.owid_overview_qatar

25.5 KB
338 rows
24 columns


CREATE TABLE owid_overview_qatar (
  "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
);

Country Profile Overview - Reunion

@owid.overview.owid_overview_reunion

9.33 KB
186 rows
7 columns


CREATE TABLE owid_overview_reunion (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT,
  "average_total_years_of_schooling_for_adult_population__c18deea2" FLOAT
);

Country Profile Overview - Romania

@owid.overview.owid_overview_romania

31.1 KB
348 rows
26 columns


CREATE TABLE owid_overview_romania (
  "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 - Russia

@owid.overview.owid_overview_russia

29.94 KB
348 rows
26 columns


CREATE TABLE owid_overview_russia (
  "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