Worldbank Economics/Demographics Data (2020)

CREATE TABLE final_demographics_data (
  "country" VARCHAR,
  "region" VARCHAR,
  "adults_ages_15_and_children_ages_0_14_newly_infected_with_hiv" DOUBLE  -- Adults (ages 15+) And Children (ages 0-14) Newly Infected With HIV,
  "adults_ages_15_49_newly_infected_with_hiv" DOUBLE  -- Adults (ages 15-49) Newly Infected With HIV,
  "age_dependency_ratio_of_working_age_population" DOUBLE  -- Age Dependency Ratio (% Of Working-age Population),
  "age_dependency_ratio_old_of_working_age_population" DOUBLE  -- Age Dependency Ratio, Old (% Of Working-age Population),
  "age_dependency_ratio_young_of_working_age_population" DOUBLE  -- Age Dependency Ratio, Young (% Of Working-age Population),
  "arms_exports_sipri_trend_indicator_values" DOUBLE  -- Arms Exports (SIPRI Trend Indicator Values),
  "arms_imports_sipri_trend_indicator_values" DOUBLE  -- Arms Imports (SIPRI Trend Indicator Values),
  "automated_teller_machines_atms_per_100_000_adults" DOUBLE  -- Automated Teller Machines (ATMs) (per 100,000 Adults),
  "average_transaction_cost_of_sending_remittances_from_a_d015a4a6" DOUBLE  -- Average Transaction Cost Of Sending Remittances From A Specific Country (%),
  "average_transaction_cost_of_sending_remittances_to_a_s_f096409f" DOUBLE  -- Average Transaction Cost Of Sending Remittances To A Specific Country (%),
  "bank_capital_to_assets_ratio" DOUBLE  -- Bank Capital To Assets Ratio (%),
  "bank_liquid_reserves_to_bank_assets_ratio" DOUBLE  -- Bank Liquid Reserves To Bank Assets Ratio (%),
  "bank_nonperforming_loans_to_total_gross_loans" DOUBLE  -- Bank Nonperforming Loans To Total Gross Loans (%),
  "charges_for_the_use_of_intellectual_property_payments__2682eefc" DOUBLE  -- Charges For The Use Of Intellectual Property, Payments (BoP, Current US$),
  "charges_for_the_use_of_intellectual_property_receipts__a8a5d234" DOUBLE  -- Charges For The Use Of Intellectual Property, Receipts (BoP, Current US$),
  "commercial_bank_branches_per_100_000_adults" DOUBLE  -- Commercial Bank Branches (per 100,000 Adults),
  "computer_communications_and_other_services_of_commerci_88b175e4" DOUBLE  -- Computer, Communications And Other Services (% Of Commercial Service Exports),
  "computer_communications_and_other_services_of_commerci_d4edcb1f" DOUBLE  -- Computer, Communications And Other Services (% Of Commercial Service Imports),
  "consumer_price_index_2010_100" DOUBLE  -- Consumer Price Index (2010 \u003d 100),
  "domestic_credit_provided_by_financial_sector_of_gdp" DOUBLE  -- Domestic Credit Provided By Financial Sector (% Of GDP),
  "domestic_credit_to_private_sector_of_gdp" DOUBLE  -- Domestic Credit To Private Sector (% Of GDP),
  "domestic_credit_to_private_sector_by_banks_of_gdp" DOUBLE  -- Domestic Credit To Private Sector By Banks (% Of GDP),
  "employment_to_population_ratio_15_female_national_estimate" DOUBLE  -- Employment To Population Ratio, 15+, Female (%) (national Estimate),
  "employment_to_population_ratio_15_male_national_estimate" DOUBLE  -- Employment To Population Ratio, 15+, Male (%) (national Estimate),
  "employment_to_population_ratio_15_total_national_estimate" DOUBLE  -- Employment To Population Ratio, 15+, Total (%) (national Estimate),
  "employment_to_population_ratio_ages_15_24_female_natio_5a9b19b6" DOUBLE  -- Employment To Population Ratio, Ages 15-24, Female (%) (national Estimate),
  "employment_to_population_ratio_ages_15_24_male_nationa_930e7489" DOUBLE  -- Employment To Population Ratio, Ages 15-24, Male (%) (national Estimate),
  "employment_to_population_ratio_ages_15_24_total_nation_d7de6c25" DOUBLE  -- Employment To Population Ratio, Ages 15-24, Total (%) (national Estimate),
  "final_consumption_expenditure_of_gdp" DOUBLE  -- Final Consumption Expenditure (% Of GDP),
  "final_consumption_expenditure_annual_growth" DOUBLE  -- Final Consumption Expenditure (annual % Growth),
  "final_consumption_expenditure_constant_2010_us" DOUBLE  -- Final Consumption Expenditure (constant 2010 US$),
  "final_consumption_expenditure_constant_lcu" DOUBLE  -- Final Consumption Expenditure (constant LCU),
  "final_consumption_expenditure_current_lcu" DOUBLE  -- Final Consumption Expenditure (current LCU),
  "final_consumption_expenditure_current_us" DOUBLE  -- Final Consumption Expenditure (current US$),
  "fixed_broadband_subscriptions" DOUBLE,
  "fixed_broadband_subscriptions_per_100_people" DOUBLE  -- Fixed Broadband Subscriptions (per 100 People),
  "fixed_telephone_subscriptions" DOUBLE,
  "fixed_telephone_subscriptions_per_100_people" DOUBLE  -- Fixed Telephone Subscriptions (per 100 People),
  "gdp_constant_2010_us" DOUBLE  -- GDP (constant 2010 US$),
  "gdp_growth_annual" DOUBLE  -- GDP Growth (annual %),
  "gdp_per_capita_constant_2010_us" DOUBLE  -- GDP Per Capita (constant 2010 US$),
  "gni_constant_2010_us" DOUBLE  -- GNI (constant 2010 US$),
  "gni_growth_annual" DOUBLE  -- GNI Growth (annual %),
  "gni_per_capita_constant_2010_us" DOUBLE  -- GNI Per Capita (constant 2010 US$),
  "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),
  "individuals_using_the_internet_of_population" DOUBLE  -- Individuals Using The Internet (% Of Population),
  "labor_force_total" BIGINT  -- Labor Force, Total,
  "military_expenditure_of_gdp" DOUBLE  -- Military Expenditure (% Of GDP),
  "population_density_people_per_sq_km_of_land_area" DOUBLE  -- Population Density (people Per Sq. Km Of Land Area),
  "population_growth_annual" DOUBLE  -- Population Growth (annual %),
  "population_female" BIGINT  -- Population, Female,
  "population_male" BIGINT  -- Population, Male,
  "population_total" BIGINT  -- Population, Total,
  "ratio_of_female_to_male_labor_force_participation_rate_92ac1b7d" DOUBLE  -- Ratio Of Female To Male Labor Force Participation Rate (%) (national Estimate),
  "total_reserves_includes_gold_current_us" DOUBLE  -- Total Reserves (includes Gold, Current US$),
  "unemployment_total_of_total_labor_force_modeled_ilo_estimate" DOUBLE  -- Unemployment, Total (% Of Total Labor Force) (modeled ILO Estimate),
  "urban_population" BIGINT,
  "women_business_and_the_law_index_score_scale_1_100" DOUBLE  -- Women Business And The Law Index Score (scale 1-100)
);