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	6	94
Afghanistan	AFG	1951	6.208	93.792
Afghanistan	AFG	1952	6.422	93.578003
Afghanistan	AFG	1953	6.643	93.357002
Afghanistan	AFG	1954	6.872	93.127998
Afghanistan	AFG	1955	7.107	92.892998
Afghanistan	AFG	1956	7.351	92.649002
Afghanistan	AFG	1957	7.601	92.399002
Afghanistan	AFG	1958	7.86	92.139999
Afghanistan	AFG	1959	8.126	91.874001


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