Name: World Urbanization Prospects Dataset - Urban And Rural Population
Creator: Our World In Data
License: https://creativecommons.org/publicdomain/

About this Dataset

World Urbanization Prospects Dataset - Urban And Rural Population

This dataset is derived from the World Urbanization Prospects, providing comprehensive data on global urbanization trends, including population figures, urban and rural population distributions, and projections for future urban growth.

Tables

World Urbanization Prospects Dataset

@owid.urbanization_urban_rural.owid_urbanization_urban_rural

1.43 MB
39,261 rows
22 columns

CREATE TABLE owid_urbanization_urban_rural (
  "country" VARCHAR,
  "year" INTEGER,
  "urbc_c_share" FLOAT,
  "urbc_c" FLOAT,
  "rurc_c" FLOAT,
  "rurc_c_share" FLOAT,
  "average_annual_rate_of_change_of_the_urban_population__85705fa4" FLOAT  -- Average Annual Rate Of Change Of The Urban Population By Region, Subregion And Country, Percent Estimates,
  "average_annual_rate_of_change_of_the_rural_population__580ac240" FLOAT  -- Average Annual Rate Of Change Of The Rural Population By Region, Subregion And Country, Percent Estimates,
  "average_annual_rate_of_change_of_the_total_population__e8ae912a" FLOAT  -- Average Annual Rate Of Change Of The Total Population By Region, Subregion And Country, Percent Estimates,
  "average_annual_rate_of_change_of_the_percentage_urban__3f7ece5c" FLOAT  -- Average Annual Rate Of Change Of The Percentage Urban By Region, Subregion And Country, Percent Estimates,
  "average_annual_rate_of_change_of_the_percentage_rural__e4c3eaf1" FLOAT  -- Average Annual Rate Of Change Of The Percentage Rural By Region, Subregion And Country, Percent Estimates,
  "annual_urban_population_at_mid_year_by_region_subregio_354b4cf7" FLOAT  -- Annual Urban Population At Mid Year By Region, Subregion And Country Estimates,
  "annual_rural_population_at_mid_year_by_region_subregio_d3c4bffe" FLOAT  -- Annual Rural Population At Mid Year By Region, Subregion And Country Estimates,
  "annual_percentage_of_population_at_mid_year_residing_i_5a262d04" FLOAT  -- Annual Percentage Of Population At Mid Year Residing In Urban Areas By Region, Subregion And Country Estimates,
  "average_annual_rate_of_change_of_the_urban_population__1c81e0b4" FLOAT  -- Average Annual Rate Of Change Of The Urban Population By Region, Subregion And Country, Percent Projections,
  "average_annual_rate_of_change_of_the_rural_population__ed6ef13d" FLOAT  -- Average Annual Rate Of Change Of The Rural Population By Region, Subregion And Country, Percent Projections,
  "average_annual_rate_of_change_of_the_total_population__e72dca42" FLOAT  -- Average Annual Rate Of Change Of The Total Population By Region, Subregion And Country, Percent Projections,
  "average_annual_rate_of_change_of_the_percentage_urban__242b2fd5" FLOAT  -- Average Annual Rate Of Change Of The Percentage Urban By Region, Subregion And Country, Percent Projections,
  "average_annual_rate_of_change_of_the_percentage_rural__9356e7cc" FLOAT  -- Average Annual Rate Of Change Of The Percentage Rural By Region, Subregion And Country, Percent Projections,
  "annual_urban_population_at_mid_year_by_region_subregio_16ca0389" FLOAT  -- Annual Urban Population At Mid Year By Region, Subregion And Country Projections,
  "annual_rural_population_at_mid_year_by_region_subregio_d843befc" FLOAT  -- Annual Rural Population At Mid Year By Region, Subregion And Country Projections,
  "annual_percentage_of_population_at_mid_year_residing_i_cdccd498" FLOAT  -- Annual Percentage Of Population At Mid Year Residing In Urban Areas By Region, Subregion And Country Projections
);