Urbanization

entity Entity	code Code	year Year	urban_population_long_run_with_2050_projections_owid Urban Population Long-run With 2050 Projections (OWID)	rural_population_long_run_with_2050_projections_owid Rural Population Long-run With 2050 Projections (OWID)
Afghanistan	AFG	1950	465000	7287000
Afghanistan	AFG	1951	487000	7353000
Afghanistan	AFG	1952	510000	7425000
Afghanistan	AFG	1953	534000	7505000
Afghanistan	AFG	1954	560000	7590000
Afghanistan	AFG	1955	588000	7683000
Afghanistan	AFG	1956	617000	7782000
Afghanistan	AFG	1957	649000	7887000
Afghanistan	AFG	1958	682000	7999000
Afghanistan	AFG	1959	718000	8117000


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
);