Dataset: Worldbank Economics/Demographics Data (2020)

About this Dataset

Worldbank Economics/Demographics Data (2020)

Context

2020 World fact sheet, fun to link with other datasets.

Content

Information on population, region, GDP, consumption, and more.

Acknowledgements

This dataset was downloaded from the World bank Data: https://data.worldbank.org/

Inspiration

When making visualisations related to countries, sometimes it is interesting to group them by attributes such as region, or weigh their importance by population, GDP or other variables.

Tables

Final Demographics Data

@kaggle.sagarnildass_worldbank_economicsdemographics_data.final_demographics_data

79.78 KB
57 rows
61 columns


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_49_newly_infected_with_hiv" DOUBLE,
  "age_dependency_ratio_of_working_age_population" DOUBLE,
  "age_dependency_ratio_old_of_working_age_population" DOUBLE,
  "age_dependency_ratio_young_of_working_age_population" DOUBLE,
  "arms_exports_sipri_trend_indicator_values" DOUBLE,
  "arms_imports_sipri_trend_indicator_values" DOUBLE,
  "automated_teller_machines_atms_per_100_000_adults" DOUBLE,
  "average_transaction_cost_of_sending_remittances_from_a_d015a4a6" DOUBLE,
  "average_transaction_cost_of_sending_remittances_to_a_s_f096409f" DOUBLE,
  "bank_capital_to_assets_ratio" DOUBLE,
  "bank_liquid_reserves_to_bank_assets_ratio" DOUBLE,
  "bank_nonperforming_loans_to_total_gross_loans" DOUBLE,
  "charges_for_the_use_of_intellectual_property_payments__2682eefc" DOUBLE,
  "charges_for_the_use_of_intellectual_property_receipts__a8a5d234" DOUBLE,
  "commercial_bank_branches_per_100_000_adults" DOUBLE,
  "computer_communications_and_other_services_of_commerci_88b175e4" DOUBLE,
  "computer_communications_and_other_services_of_commerci_d4edcb1f" DOUBLE,
  "consumer_price_index_2010_100" DOUBLE,
  "domestic_credit_provided_by_financial_sector_of_gdp" DOUBLE,
  "domestic_credit_to_private_sector_of_gdp" DOUBLE,
  "domestic_credit_to_private_sector_by_banks_of_gdp" DOUBLE,
  "employment_to_population_ratio_15_female_national_estimate" DOUBLE,
  "employment_to_population_ratio_15_male_national_estimate" DOUBLE,
  "employment_to_population_ratio_15_total_national_estimate" DOUBLE,
  "employment_to_population_ratio_ages_15_24_female_natio_5a9b19b6" DOUBLE,
  "employment_to_population_ratio_ages_15_24_male_nationa_930e7489" DOUBLE,
  "employment_to_population_ratio_ages_15_24_total_nation_d7de6c25" DOUBLE,
  "final_consumption_expenditure_of_gdp" DOUBLE,
  "final_consumption_expenditure_annual_growth" DOUBLE,
  "final_consumption_expenditure_constant_2010_us" DOUBLE,
  "final_consumption_expenditure_constant_lcu" DOUBLE,
  "final_consumption_expenditure_current_lcu" DOUBLE,
  "final_consumption_expenditure_current_us" DOUBLE,
  "fixed_broadband_subscriptions" DOUBLE,
  "fixed_broadband_subscriptions_per_100_people" DOUBLE,
  "fixed_telephone_subscriptions" DOUBLE,
  "fixed_telephone_subscriptions_per_100_people" DOUBLE,
  "gdp_constant_2010_us" DOUBLE,
  "gdp_growth_annual" DOUBLE,
  "gdp_per_capita_constant_2010_us" DOUBLE,
  "gni_constant_2010_us" DOUBLE,
  "gni_growth_annual" DOUBLE,
  "gni_per_capita_constant_2010_us" DOUBLE,
  "high_technology_exports_current_us" DOUBLE,
  "human_capital_index_hci_scale_0_1" DOUBLE,
  "individuals_using_the_internet_of_population" DOUBLE,
  "labor_force_total" BIGINT,
  "military_expenditure_of_gdp" DOUBLE,
  "population_density_people_per_sq_km_of_land_area" DOUBLE,
  "population_growth_annual" DOUBLE,
  "population_female" BIGINT,
  "population_male" BIGINT,
  "population_total" BIGINT,
  "ratio_of_female_to_male_labor_force_participation_rate_92ac1b7d" DOUBLE,
  "total_reserves_includes_gold_current_us" DOUBLE,
  "unemployment_total_of_total_labor_force_modeled_ilo_estimate" DOUBLE,
  "urban_population" BIGINT,
  "women_business_and_the_law_index_score_scale_1_100" DOUBLE
);