Baselight

Census 2021 - Country Of Birth

Leicester City Council

@ukgov.census_2021_country_of_birth

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

E06000016LeicesterNon-UKAfricaSouth and Eastern AfricaKenya64171.74KEN{"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
E06000016LeicesterNon-UKAfricaSouth and Eastern AfricaSouth Africa7320.2ZAF{"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
E06000016LeicesterNon-UKAntarctica and OceaniaOther Oceania and AntarcticaOther Oceania and Antarctica2620.07
E06000016LeicesterNon-UKAntarctica and OceaniaAustralasiaAustralia1680.05AUS{"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
E06000016LeicesterUnited KingdomEuropeUnited KingdomEngland21355557.94GBR{"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
E06000016LeicesterNon-UKEuropeOther EuropePoland89242.42POL{"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
E06000016LeicesterNon-UKEuropeOther EuropeTurkey7530.2TUR{"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
E06000016LeicesterUnited KingdomEuropeUnited KingdomNorthern Ireland5900.16GBR{"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
E06000016LeicesterUnited KingdomEuropeUnited KingdomUnited Kingdom not otherwise specified340.01GBR{"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
E06000016LeicesterNon-UKMiddle East and AsiaMiddle EastIraq15380.42IRQ{"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
);

Share link

Anyone who has the link will be able to view this.