World Urbanization Prospects Dataset - Urban And Rural Population

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_rural_population__580ac240" FLOAT,
  "average_annual_rate_of_change_of_the_total_population__e8ae912a" FLOAT,
  "average_annual_rate_of_change_of_the_percentage_urban__3f7ece5c" FLOAT,
  "average_annual_rate_of_change_of_the_percentage_rural__e4c3eaf1" FLOAT,
  "annual_urban_population_at_mid_year_by_region_subregio_354b4cf7" FLOAT,
  "annual_rural_population_at_mid_year_by_region_subregio_d3c4bffe" FLOAT,
  "annual_percentage_of_population_at_mid_year_residing_i_5a262d04" FLOAT,
  "average_annual_rate_of_change_of_the_urban_population__1c81e0b4" FLOAT,
  "average_annual_rate_of_change_of_the_rural_population__ed6ef13d" FLOAT,
  "average_annual_rate_of_change_of_the_total_population__e72dca42" FLOAT,
  "average_annual_rate_of_change_of_the_percentage_urban__242b2fd5" FLOAT,
  "average_annual_rate_of_change_of_the_percentage_rural__9356e7cc" FLOAT,
  "annual_urban_population_at_mid_year_by_region_subregio_16ca0389" FLOAT,
  "annual_rural_population_at_mid_year_by_region_subregio_d843befc" FLOAT,
  "annual_percentage_of_population_at_mid_year_residing_i_cdccd498" FLOAT
);