About this Dataset

Census 2021 - Country Of Birth

The census is undertaken by the Office for National Statistics every 10 years and gives us a picture of all the people and households in England and Wales. The most recent census took place in March of 2021.

The census asks every household questions about the people who live there and the type of home they live in. In doing so, it helps to build a detailed snapshot of society. Information from the census helps the government and local authorities to plan and fund local services, such as education, doctors' surgeries and roads.

Key census statistics for Leicester are published on the open data platform to make information accessible to local services, voluntary and community groups, and residents.

Further information about the census and full datasets can be found on the ONS website - https://www.ons.gov.uk/census/aboutcensus/censusproducts

Country of birth

This dataset provides Census 2021 estimates that classify usual residents in England and Wales by their country of birth. The estimates are as at Census Day, 21 March 2021.

Definition: The country in which a person was born. For people not born in one of in the four parts of the UK, there was an option to select "elsewhere". People who selected "elsewhere" were asked to write in the current name for their country of birth.
Publisher name: Leicester City Council
Last updated: 2023-04-07T04:00:04Z

Tables

Table 1

@ukgov.census_2021_country_of_birth.table_1

25.38 MB
44 rows
37222 columns


CREATE TABLE table_1 (
  "e92000001_england_non_uk_the_americas_and_the_caribbea_c7191289" VARCHAR,
  "n__49_465725002" VARCHAR,
  "n__54_698557095" VARCHAR,
  "n__49_407660223" VARCHAR,
  "n__54_749908007" VARCHAR,
  "n__49_424261786" VARCHAR,
  "n__54_740386523" VARCHAR,
  "n__49_458889065" VARCHAR,
  "n__54_699696418" VARCHAR,
  "n__49_47260163" VARCHAR,
  "n__54_656890429" VARCHAR,
  "n__49_465725002_fce745" VARCHAR,
  "n__54_276763476" VARCHAR,
  "n__49_575588283" VARCHAR,
  "n__54_291981575" VARCHAR,
  "n__49_587388414" VARCHAR,
  "n__54_307484504" VARCHAR,
  "n__49_67177969" VARCHAR,
  "n__54_244048632" VARCHAR,
  "n__49_726060289" VARCHAR,
  "n__54_197621223" VARCHAR,
  "n__49_705267645" VARCHAR,
  "n__54_150461392" VARCHAR,
  "n__49_753729559" VARCHAR,
  "n__54_092030403" VARCHAR,
  "n__49_750474351" VARCHAR,
  "n__54_033111132" VARCHAR,
  "n__49_708970445" VARCHAR,
  "n__54_016509569" VARCHAR,
  "n__49_667792059" VARCHAR,
  "n__54_115712043" VARCHAR,
  "n__49_616522528" VARCHAR,
  "n__54_170969205" VARCHAR,
  "n__49_609686591" VARCHAR,
  "n__54_276763476_3a3ef2" VARCHAR,
  "n__49_575588283_2f807b" VARCHAR,
  "n__54_883452929" VARCHAR,
  "n__49_555080471" VARCHAR,
  "n__54_893177864" VARCHAR,
  "n__49_58197663" VARCHAR,
  "n__54_835682746" VARCHAR,
  "n__49_603461005" VARCHAR,
  "n__54_780629036" VARCHAR,
  "n__49_595892645" VARCHAR,
  "n__54_795277473" VARCHAR,
  "n__49_563625393" VARCHAR,
  "n__54_732655403" VARCHAR,
  "n__49_555080471_1" VARCHAR,
  "n__54_67292233" VARCHAR,
  "n__49_578680731" VARCHAR,
  "n__54_649240689" VARCHAR,
  "n__49_62490469" VARCHAR,
  "n__54_614084439" VARCHAR,
  "n__49_616115627" VARCHAR,
  "n__54_557932095" VARCHAR,
  "n__49_653509833" VARCHAR,
  "n__54_530873176" VARCHAR,
  "n__49_615423895" VARCHAR,
  "n__54_546050585" VARCHAR,
  "n__49_584784247" VARCHAR,
  "n__54_607736783" VARCHAR,
  "n__49_560736395" VARCHAR,
  "n__54_699330207" VARCHAR,
  "n__49_541896877" VARCHAR,
  "n__54_781076627" VARCHAR,
  "n__49_499823309" VARCHAR,
  "n__54_852365689" VARCHAR,
  "n__49_486517645" VARCHAR,
  "n__54_840402799" VARCHAR,
  "n__49_529771226" VARCHAR,
  "n__54_883452929_b158b3" VARCHAR,
  "n__49_555080471_3f36ce" VARCHAR,
  "n__52_956475296" VARCHAR,
  "n__47_654806363" VARCHAR,
  "n__52_916443423" VARCHAR,
  "n__47_634455575" VARCHAR,
  "n__52_976501744" VARCHAR,
  "n__47_596866105" VARCHAR,
  "n__53_019183904" VARCHAR,
  "n__47_619039947" VARCHAR,
  "n__52_956475296_cab64a" VARCHAR,
  "n__47_654806363_2c6351" VARCHAR,
  "n__53_56769772" VARCHAR,
  "n__48_190822658" VARCHAR,
  "n__53_524077929" VARCHAR,
  "n__48_14451732" VARCHAR,
  "n__53_565500455" VARCHAR,
  "n__48_08218008" VARCHAR,
  "n__53_618804491" VARCHAR,
  "n__48_0820987" VARCHAR,
  "n__53_718413866" VARCHAR,
  "n__48_101996161" VARCHAR,
  "n__53_810943163" VARCHAR,
  "n__48_095200914" VARCHAR,
  "n__53_875233528" VARCHAR,
  "n__48_106512762" VARCHAR,
  "n__53_889759895" VARCHAR,
  "n__48_143622137" VARCHAR,
  "n__53_928374804" VARCHAR,
  "n__48_183335679" VARCHAR
);