Baselight

Urbanization

To all those who said I couldn't make jokes about blind people...watch me.

@kaggle.programmerrdai_urbanization

About this Dataset

Urbanization

Urbanization refers to the population shift from rural to urban areas, the corresponding decrease in the proportion of people living in rural areas, and the ways in which societies adapt to this change. Wikipedia

Tables

Capital City Population

@kaggle.programmerrdai_urbanization.capital_city_population
  • 8.88 KB
  • 232 rows
  • 4 columns
Loading...

CREATE TABLE capital_city_population (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "capital_city_population_un_urbanization_prospects_2018" BIGINT
);

City Populations To 2035

@kaggle.programmerrdai_urbanization.city_populations_to_2035
  • 9.1 KB
  • 540 rows
  • 5 columns
Loading...

CREATE TABLE city_populations_to_2035 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "city_population_un_urbanization_prospects_2018" DOUBLE,
  "projected_city_population_un_urbanization_prospects_2018" DOUBLE
);

Employment In Agri Vs Urban Pop

@kaggle.programmerrdai_urbanization.employment_in_agri_vs_urban_pop
  • 157.14 KB
  • 9079 rows
  • 7 columns
Loading...

CREATE TABLE employment_in_agri_vs_urban_pop (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "share_employed_agri" DOUBLE,
  "urban_population_of_total_population" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

Long Term Urban Population Region

@kaggle.programmerrdai_urbanization.long_term_urban_population_region
  • 5.15 KB
  • 324 rows
  • 4 columns
Loading...

CREATE TABLE long_term_urban_population_region (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "historical_urban_fraction_estimate_per_region_hyde_3_1_2010" DOUBLE
);

Population In The Largest City

@kaggle.programmerrdai_urbanization.population_in_the_largest_city
  • 85.39 KB
  • 10383 rows
  • 4 columns
Loading...

CREATE TABLE population_in_the_largest_city (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "population_in_the_largest_city_of_urban_population" DOUBLE
);

Population Threshold For Urban Area 1

@kaggle.programmerrdai_urbanization.population_threshold_for_urban_area_1
  • 5.38 KB
  • 99 rows
  • 4 columns
Loading...

CREATE TABLE population_threshold_for_urban_area_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "minimum_population_threshold_for_urban_area_un_2018" BIGINT
);

Population Threshold For Urban Area

@kaggle.programmerrdai_urbanization.population_threshold_for_urban_area
  • 5.38 KB
  • 99 rows
  • 4 columns
Loading...

CREATE TABLE population_threshold_for_urban_area (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "minimum_population_threshold_for_urban_area_un_2018" BIGINT
);

Share Of Population Urban

@kaggle.programmerrdai_urbanization.share_of_population_urban
  • 106.06 KB
  • 14021 rows
  • 4 columns
Loading...

CREATE TABLE share_of_population_urban (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_of_total_population" DOUBLE
);

Share Of Urban Population Living In Slums

@kaggle.programmerrdai_urbanization.share_of_urban_population_living_in_slums
  • 10.05 KB
  • 683 rows
  • 4 columns
Loading...

CREATE TABLE share_of_urban_population_living_in_slums (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "population_living_in_slums_of_urban_population" DOUBLE
);

Urban Agglomerations 1 Million Percent

@kaggle.programmerrdai_urbanization.urban_agglomerations_1_million_percent
  • 70.1 KB
  • 8305 rows
  • 4 columns
Loading...

CREATE TABLE urban_agglomerations_1_million_percent (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "population_in_urban_agglomerations_of_more_than_1_mill_ac591a7c" DOUBLE
);

Urban And Rural Population 1

@kaggle.programmerrdai_urbanization.urban_and_rural_population_1
  • 200.3 KB
  • 13988 rows
  • 5 columns
Loading...

CREATE TABLE urban_and_rural_population_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population" BIGINT,
  "rural_population" BIGINT
);

Urban And Rural Population 2050

@kaggle.programmerrdai_urbanization.urban_and_rural_population_2050
  • 252.7 KB
  • 27668 rows
  • 5 columns
Loading...

CREATE TABLE urban_and_rural_population_2050 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_with_2050_projections_owid" DOUBLE,
  "rural_population_long_run_with_2050_projections_owid" DOUBLE
);

Urban And Rural Population

@kaggle.programmerrdai_urbanization.urban_and_rural_population
  • 200.3 KB
  • 13988 rows
  • 5 columns
Loading...

CREATE TABLE urban_and_rural_population (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population" BIGINT,
  "rural_population" BIGINT
);

Urban Pop In Out Of Slums

@kaggle.programmerrdai_urbanization.urban_pop_in_out_of_slums
  • 15.74 KB
  • 620 rows
  • 5 columns
Loading...

CREATE TABLE urban_pop_in_out_of_slums (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_living_in_slums" BIGINT,
  "urban_population_not_living_in_slums" BIGINT
);

Urban Population Share 2050

@kaggle.programmerrdai_urbanization.urban_population_share_2050
  • 194.39 KB
  • 27977 rows
  • 4 columns
Loading...

CREATE TABLE urban_population_share_2050 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_with_2050_projections_owid" DOUBLE
);

Urban Share European Commission

@kaggle.programmerrdai_urbanization.urban_share_european_commission
  • 3.6 KB
  • 7 rows
  • 4 columns
Loading...

CREATE TABLE urban_share_european_commission (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "degree_of_urbanization_of_population" DOUBLE
);

Urban Vs Rural Majority

@kaggle.programmerrdai_urbanization.urban_vs_rural_majority
  • 382.99 KB
  • 27977 rows
  • 5 columns
Loading...

CREATE TABLE urban_vs_rural_majority (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_with_2050_projections_owid" DOUBLE,
  "rural_population_long_run_with_2050_projections_owid" DOUBLE
);

Urbanization Last 500 Years

@kaggle.programmerrdai_urbanization.urbanization_last_500_years
  • 137.58 KB
  • 18695 rows
  • 4 columns
Loading...

CREATE TABLE urbanization_last_500_years (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_to_2016_owid" DOUBLE
);

Urbanization Vs Gdp

@kaggle.programmerrdai_urbanization.urbanization_vs_gdp
  • 637.54 KB
  • 62445 rows
  • 8 columns
Loading...

CREATE TABLE urbanization_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_to_2016_owid" DOUBLE,
  "gdp_per_capita" DOUBLE,
  "n_417485_annotations" VARCHAR,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);