Baselight

Urbanization

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

@kaggle.programmerrdai_urbanization

Loading...
Loading...

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
  • 9.1 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  -- Capital City Population (UN Urbanization Prospects, 2018)
);

City Populations To 2035

@kaggle.programmerrdai_urbanization.city_populations_to_2035
  • 9.32 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  -- City Population (UN Urbanization Prospects, 2018),
  "projected_city_population_un_urbanization_prospects_2018" DOUBLE  -- Projected City Population (UN Urbanization Prospects, 2018)
);

Employment In Agri Vs Urban Pop

@kaggle.programmerrdai_urbanization.employment_in_agri_vs_urban_pop
  • 160.91 kB
  • 9,079 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  -- Urban Population (% Of Total Population),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Long Term Urban Population Region

@kaggle.programmerrdai_urbanization.long_term_urban_population_region
  • 5.28 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  -- Historical Urban Fraction Estimate Per Region (HYDE 3.1 (2010))
);

Population In The Largest City

@kaggle.programmerrdai_urbanization.population_in_the_largest_city
  • 87.44 kB
  • 10,383 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 In The Largest City (% Of Urban Population)
);

Population Threshold For Urban Area

@kaggle.programmerrdai_urbanization.population_threshold_for_urban_area
  • 5.51 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  -- Minimum Population Threshold For Urban Area (UN; 2018)
);

Population Threshold For Urban Area 1

@kaggle.programmerrdai_urbanization.population_threshold_for_urban_area_1
  • 5.51 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  -- Minimum Population Threshold For Urban Area (UN; 2018)
);

Share Of Population Urban

@kaggle.programmerrdai_urbanization.share_of_population_urban
  • 108.6 kB
  • 14,021 rows
  • 4 columns
Loading...
CREATE TABLE share_of_population_urban (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_of_total_population" DOUBLE  -- Urban Population (% Of Total Population)
);

Share Of Urban Population Living In Slums

@kaggle.programmerrdai_urbanization.share_of_urban_population_living_in_slums
  • 10.29 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  -- Population Living In Slums (% Of Urban Population)
);

Urban Agglomerations 1 Million Percent

@kaggle.programmerrdai_urbanization.urban_agglomerations_1_million_percent
  • 71.78 kB
  • 8,305 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  -- Population In Urban Agglomerations Of More Than 1 Million (% Of Total Population)
);

Urban And Rural Population

@kaggle.programmerrdai_urbanization.urban_and_rural_population
  • 205.11 kB
  • 13,988 rows
  • 5 columns
Loading...
CREATE TABLE urban_and_rural_population (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population" BIGINT,
  "rural_population" BIGINT
);

Urban And Rural Population 1

@kaggle.programmerrdai_urbanization.urban_and_rural_population_1
  • 205.11 kB
  • 13,988 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
  • 258.77 kB
  • 27,668 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  -- Urban Population Long-run With 2050 Projections (OWID),
  "rural_population_long_run_with_2050_projections_owid" DOUBLE  -- Rural Population Long-run With 2050 Projections (OWID)
);

Urbanization Last 500 Years

@kaggle.programmerrdai_urbanization.urbanization_last_500_years
  • 140.88 kB
  • 18,695 rows
  • 4 columns
Loading...
CREATE TABLE urbanization_last_500_years (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_to_2016_owid" DOUBLE  -- Urban Population (%) Long-run To 2016 (OWID)
);

Urbanization Vs Gdp

@kaggle.programmerrdai_urbanization.urbanization_vs_gdp
  • 652.84 kB
  • 62,445 rows
  • 8 columns
Loading...
CREATE TABLE urbanization_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "urban_population_long_run_to_2016_owid" DOUBLE  -- Urban Population (%) Long-run To 2016 (OWID),
  "gdp_per_capita" DOUBLE,
  "n_417485_annotations" VARCHAR  -- 417485-annotations,
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Urban Pop In Out Of Slums

@kaggle.programmerrdai_urbanization.urban_pop_in_out_of_slums
  • 16.12 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
  • 199.06 kB
  • 27,977 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 Population (%) Long-run With 2050 Projections (OWID)
);

Urban Share European Commission

@kaggle.programmerrdai_urbanization.urban_share_european_commission
  • 3.68 kB
  • 7 rows
  • 4 columns
Loading...
CREATE TABLE urban_share_european_commission (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "degree_of_urbanization_of_population" DOUBLE  -- Degree Of Urbanization (% Of Population)
);

Urban Vs Rural Majority

@kaggle.programmerrdai_urbanization.urban_vs_rural_majority
  • 392.19 kB
  • 27,977 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  -- Urban Population (%) Long-run With 2050 Projections (OWID),
  "rural_population_long_run_with_2050_projections_owid" DOUBLE  -- Rural Population (%) Long-run With 2050 Projections (OWID)
);

Share link

Anyone who has the link will be able to view this.