Birth-Places of the Inhabitants of the Counties of Scotland in 1921

Table ID:
MIG_1921_S     (1251571)
Contents:
Birth-Places of the Inhabitants of the Counties of Scotland in 1921
Approx. number of rows:
1,122
Table type:
Raw Data
Documentation Author:
Paul Ell
Geography:
Reporting units are identified by:
   Unspecified County
Chronology:
The data are for the single year 1921.

Sources:

  1. This table was transcribed from 'Table 51. - County of Birth of Persons born in Scotland'.
  2. These data were computerised by the Centre for Data Digitisation and Analysis.
  3. The table does not include footnotes or endnotes.
  4. This is a full transcription of the printed table except for a total given for the whole of Scotland (used in verification) and data for the cities of Edinburgh, Glasgow, Dundee and Aberdeen.


Notes:

  1. The original table was organised with columns giving the county of birth and rows giving the county of enumeration, but have been re-organised here so that both counties appear as values in columns.
  2. The birthplace field contains a limited amount of information. Only those born in Scotland are recorded by county of birth together with a final column for those born in Scotland with no county stated.
  3. Data is included in the printed table for those enumerated in Edinburgh, Glasgow, Dundee and Aberdeen. We have excluded these data. County figures include those enumerated in the 4 cities.
  4. We are currently unsure of the census geography used in this table.
  5. This table originally had the birthplace and location columns identified the wrng way round. Now checked against the original reports and amended to be correct.


Checking:

  1. In the original table, the top row of the table gave the total number of inhabitants born in each county in Scotland, and this was used to check the numbers listed as being enumerated .
  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:

IndexTypeColumn(s) indexed
mig_1921_s_pkey Primary key rec_num
mig_1921_s_idx Unique birthplace, x_county, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
mig_1921_s_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
birthplace Text string (max.len.=154). Place of birth
x_county Text string (max.len.=104). Name of x_county
m_u_20 Integer number. Males under 20 years
m_20_up Integer number. Males 20 years and upwards
f_u_20 Integer number. Females under 20 years
f_20_up Integer number. Females 20 years and upwards
notes Text string (max.len.=258). Notes added after data capture
rec_num Integer number. Unique number identifying row in table.