Birthplace statistics for residents of England and Wales in 1931

Table ID:

MIG_1931_EW     (1251579)

Contents:

Birthplace statistics for residents of England and Wales in 1931

Approx. number of rows:

19,352

Table type:

Raw Data

Documentation Author:

Paula Aucott

Geography:

Reporting units are identified by:
   Unspecified District

Chronology:

The data are for the single year 1931.

Sources:

1. This table was found on the Oracle server as a spreadsheet called MIG1931_NAMED. The server file indicates it was last modified on 01-01-1985. No documentation accompanied the file and as yet the source table is unidentified.
2. The rec_num is included in the index as there are repeated rows in terms of birthplace, district and type. Until the source is identified no editing of the table can be done

---

Checking:

1. 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_1931_ew_pkey	Primary key	rec_num
mig_1931_ew_idx	Unique	birthplace, x_district, x_dis_type, rec_num

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
birthplace	Text string (max.len.=254).	Place of birth.
x_district	Text string (max.len.=104).	Local Government District (town, city, borough) resident in at enumeration.
x_dis_type	Text string (max.len.=12).	Local Government District type resident in at enumeration.
tot_male	Integer number.	Total number of males.
tot_fem	Integer number.	Total number of females.
notes	Text string (max.len.=258).	Notes added following data capture.
rec_num	Integer number.	Unique number identifying row in table.