Birthplace statistics for residents of England and Wales in 1861

Table ID:

MIG_1861_EW     (1251478)

Contents:

Birthplace statistics for residents of England and Wales in 1861

Approx. number of rows:

40,054

Table type:

Raw Data

Documentation Author:

Paul Ell

Geography:

Reporting units are identified by:
   Registration County
   Registration District
   Registration District Number
   Suffix to Registration District Number

Chronology:

The data are for the single year 1861.

Sources:

1. This table was transcribed from the table entitled 'Birth-places of the Inhabitants of 'Census Division Name' - In Superintendent Registrars' Divisions' in the divisional sections of the 1861 census reports.
2. These data were computerised by the Centre for Data Digitisation and Analysis.
3. There are 11 tables, one for each of the census divisions in England and Wales.
4. The table does not include footnotes or endnotes.

---

Notes:

1. The original table was organised with columns giving the county of residence in 1861 and rows giving the birthplace, but have been re-organised here so that both counties appear as values in columns.
2. The birthplace field contains a variety of spatial units. Counties are listed for England and Wales but it is unclear whether these are registration counties of administrative counties. The Welsh data also includes an entry for 'WALES (County not stated)'. Figures for those born in Scotland and Ireland are not broken down into smaller units. Nor are those for people born in 'Islands in the British Seas'. Those born outside the United Kingdom of Britain and Ireland are recorded under the following - 'British Colonies and East Indies', 'Foreign Parts - British Subjects', 'Foreign Parts - Foreigners', and 'Born at Sea'.
3. A further set of tables provides a detailed breakdown of place of birth of those born abroad together with their occupations and ages. These tables have not been computerised.
4. Table was renamed from mig_1861 when transferred from the Oracle server.

---

Checking:

1. In the original table, the top row of the table gave the total number of inhabitants in each county of residence, and this was used to check the numbers listed as having been born in each county of birth.
2. No matching to the AUO gazetteer has been attempted. These files have been altered to run on Postgres, but otherwise are exactly the same as they were on the oracle server.

---

Indices:

Index	Type	Column(s) indexed
mig_1861_ew_pkey	Primary key	rec_num
mig_1861_ew_idx1	Unique	reg_dist, reg_cnty, birthplace
mig_1861_ew_idx2	Unique	birthplace, reg_dist, reg_cnty

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
mig_1861_ew_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
birthplace	Text string (max.len.=154).	Place of birth.
reg_cnty	Text string (max.len.=104).	Registration county resident in at enumeration.
reg_dist	Text string (max.len.=104).	Registration district resident in at enumeration.
reg_num	Integer number.	Registration district number as given in the printed report.
reg_sfx	Text string (max.len.=8).	Registration district number suffix given in the printed report for a small number of districts.
m_u_20	Integer number.	Total number of males aged under 20 years.
m_20_up	Integer number.	Total number of males aged 20 years and over.
f_u_20	Integer number.	Total number of females aged under 20 years.
f_20_up	Integer number.	Total number of females aged 20 years and over.
notes	Text string (max.len.=258).	Notes added following data capture.
rec_num	Integer number.	Unique number identifying row in table.