Socio-Economic Country Profiles

CREATE TABLE soci_econ_country_profiles (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "country" VARCHAR,
  "region" VARCHAR,
  "surface_area_km2" BIGINT  -- Surface Area (km2),
  "population_in_thousands_2017" BIGINT  -- Population In Thousands (2017),
  "population_density_per_km2_2017" DOUBLE  -- Population Density (per Km2, 2017),
  "sex_ratio_m_per_100_f_2017" DOUBLE  -- Sex Ratio (m Per 100 F, 2017),
  "gdp_gross_domestic_product_million_current_us" BIGINT  -- GDP: Gross Domestic Product (million Current US$),
  "gdp_growth_rate_annual_const_2005_prices" DOUBLE  -- GDP Growth Rate (annual %, Const. 2005 Prices),
  "gdp_per_capita_current_us" DOUBLE  -- GDP Per Capita (current US$),
  "economy_agriculture_of_gva" VARCHAR  -- Economy: Agriculture (% Of GVA),
  "economy_industry_of_gva" DOUBLE  -- Economy: Industry (% Of GVA),
  "economy_services_and_other_activity_of_gva" DOUBLE  -- Economy: Services And Other Activity (% Of GVA),
  "employment_agriculture_of_employed" DOUBLE  -- Employment: Agriculture (% Of Employed),
  "employment_industry_of_employed" DOUBLE  -- Employment: Industry (% Of Employed),
  "employment_services_of_employed" DOUBLE  -- Employment: Services (% Of Employed),
  "unemployment_of_labour_force" DOUBLE  -- Unemployment (% Of Labour Force),
  "labour_force_participation_female_male_pop" VARCHAR  -- Labour Force Participation (female/male Pop. %),
  "agricultural_production_index_2004_2006_100" BIGINT  -- Agricultural Production Index (2004-2006\u003d100),
  "food_production_index_2004_2006_100" BIGINT  -- Food Production Index (2004-2006\u003d100),
  "international_trade_exports_million_us" BIGINT  -- International Trade: Exports (million US$),
  "international_trade_imports_million_us" BIGINT  -- International Trade: Imports (million US$),
  "international_trade_balance_million_us" BIGINT  -- International Trade: Balance (million US$),
  "balance_of_payments_current_account_million_us" BIGINT  -- Balance Of Payments, Current Account (million US$),
  "population_growth_rate_average_annual" VARCHAR  -- Population Growth Rate (average Annual %),
  "urban_population_of_total_population_x" DOUBLE  -- Urban Population (% Of Total Population) X,
  "urban_population_growth_rate_average_annual" VARCHAR  -- Urban Population Growth Rate (average Annual %),
  "fertility_rate_total_live_births_per_woman" DOUBLE  -- Fertility Rate, Total (live Births Per Woman),
  "population_age_distribution_0_14_60_years" VARCHAR  -- Population Age Distribution (0-14 / 60+ Years, %),
  "international_migrant_stock_000_of_total_pop" VARCHAR  -- International Migrant Stock (000/% Of Total Pop.),
  "refugees_and_others_of_concern_to_unhcr_in_thousands" VARCHAR  -- Refugees And Others Of Concern To UNHCR (in Thousands),
  "infant_mortality_rate_per_1000_live_births" DOUBLE  -- Infant Mortality Rate (per 1000 Live Births,
  "health_total_expenditure_of_gdp" DOUBLE  -- Health: Total Expenditure (% Of GDP),
  "health_physicians_per_1000_pop" VARCHAR  -- Health: Physicians (per 1000 Pop.),
  "education_government_expenditure_of_gdp" VARCHAR  -- Education: Government Expenditure (% Of GDP),
  "education_primary_gross_enrol_ratio_f_m_per_100_pop" VARCHAR  -- Education: Primary Gross Enrol. Ratio (f/m Per 100 Pop.),
  "education_secondary_gross_enrol_ratio_f_m_per_100_pop" VARCHAR  -- Education: Secondary Gross Enrol. Ratio (f/m Per 100 Pop.),
  "education_tertiary_gross_enrol_ratio_f_m_per_100_pop" VARCHAR  -- Education: Tertiary Gross Enrol. Ratio (f/m Per 100 Pop.),
  "seats_held_by_women_in_national_parliaments" DOUBLE  -- Seats Held By Women In National Parliaments %,
  "mobile_cellular_subscriptions_per_100_inhabitants" DOUBLE  -- Mobile-cellular Subscriptions (per 100 Inhabitants),
  "mobile_cellular_subscriptions_per_100_inhabitants_1" DOUBLE  -- Mobile-cellular Subscriptions (per 100 Inhabitants).1,
  "individuals_using_the_internet_per_100_inhabitants" BIGINT  -- Individuals Using The Internet (per 100 Inhabitants),
  "threatened_species_number" DOUBLE  -- Threatened Species (number),
  "forested_area_of_land_area" VARCHAR  -- Forested Area (% Of Land Area),
  "co2_emission_estimates_million_tons_tons_per_capita" BIGINT  -- CO2 Emission Estimates (million Tons/tons Per Capita),
  "energy_production_primary_petajoules" BIGINT  -- Energy Production, Primary (Petajoules),
  "energy_supply_per_capita_gigajoules" VARCHAR  -- Energy Supply Per Capita (Gigajoules),
  "pop_using_improved_drinking_water_urban_rural" VARCHAR  -- Pop. Using Improved Drinking Water (urban/rural, %),
  "pop_using_improved_sanitation_facilities_urban_rural" VARCHAR  -- Pop. Using Improved Sanitation Facilities (urban/rural, %),
  "net_official_development_assist_received_of_gni" BIGINT  -- Net Official Development Assist. Received (% Of GNI),
  "quality_of_life_index" DOUBLE,
  "purchasing_power_index" DOUBLE,
  "safety_index" DOUBLE,
  "health_care_index" DOUBLE,
  "cost_of_living" DOUBLE,
  "property_price_to_income_ratio" DOUBLE,
  "traffic_commute_time_index" DOUBLE,
  "pollution_index" DOUBLE,
  "climate_index" DOUBLE,
  "gross_rental_yield_city_center" DOUBLE,
  "gross_rental_yield_outside_center" DOUBLE,
  "property_price_to_rent_ratio_city_center" DOUBLE,
  "property_price_to_rent_ratio_outside_center" DOUBLE,
  "mortgate_as_percentage_of_income" DOUBLE,
  "affordability_index" DOUBLE,
  "cost_of_living_index" DOUBLE,
  "rent_index" DOUBLE,
  "cost_of_living_plus_rent_index" DOUBLE,
  "grocery_index" DOUBLE,
  "restaurant_price_index" DOUBLE,
  "local_purchasing_power_index" DOUBLE,
  "access_to_electricity_of_population" DOUBLE  -- Access To Electricity (% Of Population),
  "adjusted_net_national_income_per_capita_constant_2010_us" DOUBLE  -- Adjusted Net National Income Per Capita (constant 2010 US$),
  "age_dependency_ratio_of_working_age_population" DOUBLE  -- Age Dependency Ratio (% Of Working-age Population),
  "air_transport_freight_million_ton_km" DOUBLE  -- Air Transport, Freight (million Ton-km),
  "air_transport_passengers_carried" DOUBLE  -- Air Transport, Passengers Carried,
  "commercial_service_exports_current_us" DOUBLE  -- Commercial Service Exports (current US$),
  "commercial_service_imports_current_us" DOUBLE  -- Commercial Service Imports (current US$),
  "consumer_price_index_2010_100" DOUBLE  -- Consumer Price Index (2010 \u003d 100),
  "current_account_balance_of_gdp" DOUBLE  -- Current Account Balance (% Of GDP),
  "current_health_expenditure_of_gdp" DOUBLE  -- Current Health Expenditure (% Of GDP),
  "exports_of_goods_and_services_of_gdp" DOUBLE  -- Exports Of Goods And Services (% Of GDP),
  "gross_domestic_savings_of_gdp" DOUBLE  -- Gross Domestic Savings (% Of GDP),
  "high_technology_exports_current_us" DOUBLE  -- High-technology Exports (current US$),
  "human_capital_index_hci_scale_0_1" DOUBLE  -- Human Capital Index (HCI) (scale 0-1),
  "imports_of_goods_and_services_of_gdp" DOUBLE  -- Imports Of Goods And Services (% Of GDP),
  "inflation_consumer_prices_annual" DOUBLE  -- Inflation, Consumer Prices (annual %),
  "life_expectancy_at_birth_female_years" DOUBLE  -- Life Expectancy At Birth, Female (years),
  "life_expectancy_at_birth_male_years" DOUBLE  -- Life Expectancy At Birth, Male (years),
  "life_expectancy_at_birth_total_years" DOUBLE  -- Life Expectancy At Birth, Total (years),
  "military_expenditure_of_gdp" DOUBLE  -- Military Expenditure (% Of GDP),
  "population_female" DOUBLE  -- Population, Female,
  "population_male" DOUBLE  -- Population, Male,
  "tax_revenue_of_gdp" DOUBLE  -- Tax Revenue (% Of GDP),
  "taxes_on_income_profits_and_capital_gains_of_revenue" DOUBLE  -- Taxes On Income, Profits And Capital Gains (% Of Revenue),
  "urban_population_of_total_population_y" DOUBLE  -- Urban Population (% Of Total Population) Y
);