Census 2021 - Country Of Birth

Leicester City Council

@ukgov.census_2021_country_of_birth

Table List

1 table(1.15 MB)

Table 1

@ukgov.census_2021_country_of_birth.table_1

Census 2021 - Country of birth (csv)

1.15 MB
118 rows
11 columns

area_code Area Code	area Area	uk_non_uk Uk Non Uk	continent Continent	region Region	country Country	residents Residents	percentage_of_leicester_population Percentage Of Leicester Population	iso3_country_code Iso3 Country Code	geom Geom	centroid Centroid
E06000016	Leicester	Non-UK	Africa	South and Eastern Africa	Kenya	6417	1.74	KEN	{"coordinates": [[[[41.053965691, -2.049574477], [41.09278405, -2.038018488], [41.14332116, -2.059502863], [41.16277103, -2.090915623], [41.15528405, -2.112074477], [41.050791863, -2.129489842], [40.986175977, -2.165948175], [40.957367384, -2.151299738], [40.982920769, -2.097344659], [41.045176629, …	0.550766077, 37.822439906
E06000016	Leicester	Non-UK	Africa	South and Eastern Africa	South Africa	732	0.2	ZAF	{"coordinates": [[[[37.662445509, -46.828545831], [37.728526238, -46.825290623], [37.821055535, -46.844170831], [37.868418816, -46.882094008], [37.884938998, -46.916436456], [37.836436394, -46.958672784], [37.618825717, -46.954359633], [37.587412957, -46.938409113], [37.575368686, -46.903497003], [3…	-29.001032178, 25.087364435
E06000016	Leicester	Non-UK	Antarctica and Oceania	Other Oceania and Antarctica	Other Oceania and Antarctica	262	0.07
E06000016	Leicester	Non-UK	Antarctica and Oceania	Australasia	Australia	168	0.05	AUS	{"coordinates": [[[[158.89340254, -54.510837498], [158.963226759, -54.489190363], [158.955577019, -54.551202081], [158.915537957, -54.650974217], [158.892588738, -54.686944269], [158.880544467, -54.745700779], [158.838226759, -54.750420831], [158.832367384, -54.711683852], [158.856455925, -54.603773…	-25.734205884, 134.486261392
E06000016	Leicester	United Kingdom	Europe	United Kingdom	England	213555	57.94	GBR	{"coordinates": [[[[-27.252919075, -59.458265883], [-27.231312629, -59.438246352], [-27.136830207, -59.437188409], [-27.152943489, -59.470798435], [-27.252919075, -59.458265883]]], [[[-26.629750129, -59.005954685], [-26.562652148, -59.00790781], [-26.499379036, -59.033135675], [-26.595570442, -59.06…	54.314093329, -1.9116522
E06000016	Leicester	Non-UK	Europe	Other Europe	Poland	8924	2.42	POL	{"coordinates": [[[[18.833196249, 49.510260722], [18.834539836, 49.547622782], [18.773458293, 49.675832011], [18.727672974, 49.668907369], [18.682404418, 49.695779114], [18.63734257, 49.70032664], [18.566752564, 49.80476471], [18.559207804, 49.907187398], [18.481796509, 49.896645407], [18.368831827,…	52.124771819, 19.39432214
E06000016	Leicester	Non-UK	Europe	Other Europe	Turkey	753	0.2	TUR	{"coordinates": [[[[26.012217644, 40.166571356], [26.012217644, 40.146063544], [25.96778405, 40.130764065], [25.900401238, 40.122748114], [25.856293165, 40.107855536], [25.765961134, 40.097154039], [25.663259311, 40.126166083], [25.68620853, 40.160834052], [25.759043816, 40.206732489], [25.82691491,…	39.061080588, 35.167239403
E06000016	Leicester	United Kingdom	Europe	United Kingdom	Northern Ireland	590	0.16	GBR	{"coordinates": [[[[-27.252919075, -59.458265883], [-27.231312629, -59.438246352], [-27.136830207, -59.437188409], [-27.152943489, -59.470798435], [-27.252919075, -59.458265883]]], [[[-26.629750129, -59.005954685], [-26.562652148, -59.00790781], [-26.499379036, -59.033135675], [-26.595570442, -59.06…	54.314093329, -1.9116522
E06000016	Leicester	United Kingdom	Europe	United Kingdom	United Kingdom not otherwise specified	34	0.01	GBR	{"coordinates": [[[[-27.252919075, -59.458265883], [-27.231312629, -59.438246352], [-27.136830207, -59.437188409], [-27.152943489, -59.470798435], [-27.252919075, -59.458265883]]], [[[-26.629750129, -59.005954685], [-26.562652148, -59.00790781], [-26.499379036, -59.033135675], [-26.595570442, -59.06…	54.314093329, -1.9116522
E06000016	Leicester	Non-UK	Middle East and Asia	Middle East	Iraq	1538	0.42	IRQ	{"coordinates": [[[[44.766135295, 37.141920065], [44.752544393, 37.113136292], [44.766548706, 37.078952332], [44.811197144, 37.041926168], [44.847577352, 37.044044901], [44.880753622, 37.024924622], [44.869178101, 36.967357076], [44.888815145, 36.910926412], [44.883440796, 36.886845195], [44.8341414…	33.039803777, 43.744977021


CREATE TABLE table_1 (
  "area_code" VARCHAR,
  "area" VARCHAR,
  "uk_non_uk" VARCHAR,
  "continent" VARCHAR,
  "region" VARCHAR,
  "country" VARCHAR,
  "residents" BIGINT,
  "percentage_of_leicester_population" DOUBLE,
  "iso3_country_code" VARCHAR,
  "geom" VARCHAR,
  "centroid" VARCHAR
);