Urbanization

entity Entity	code Code	year Year	share_employed_agri Share Employed Agri	urban_population_of_total_population Urban Population (% Of Total Population)	population_historical_estimates Population (historical Estimates)	continent Continent
Abkhazia	OWID_ABK	2015				Asia
Afghanistan	AFG	1991	63.43000031	21.266000747680664	13299016	nan
Afghanistan	AFG	1992	63.65000153	21.354999542236328	14485543	nan
Afghanistan	AFG	1993	64.41000366	21.444000244140625	15816601	nan
Afghanistan	AFG	1994	64.44000244	21.53400039672852	17075728	nan
Afghanistan	AFG	1995	64.30000305	21.624000549316406	18110662	nan
Afghanistan	AFG	1996	64.68000031	21.714000701904297	18853444	nan
Afghanistan	AFG	1997	64.98000336	21.80500030517578	19357126	nan
Afghanistan	AFG	1998	65.19999695	21.895000457763672	19737770	nan
Afghanistan	AFG	1999	65.45999908	21.98600006103516	20170847	nan


CREATE TABLE employment_in_agri_vs_urban_pop (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "share_employed_agri" DOUBLE,
  "urban_population_of_total_population" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);