Country Profile Overview

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

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

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

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

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

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

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

CREATE TABLE owid_overview_western_sahara (
  "country" VARCHAR,
  "year" INTEGER,
  "index" UINTEGER,
  "population" UINTEGER,
  "life_expectancy_at_birth" FLOAT,
  "child_mortality_select_gapminder_v10_2017" FLOAT  -- Child Mortality, Select Gapminder, V10, 2017
);

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

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

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