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

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

Sources:

  1. This table was transcribed from the table entitled 'Birth-places of the Inhabitants of the Counties of Scotland' in the 1851 census reports.
  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 totals.


Notes:

  1. The original table was organised with columns giving the county of residence in 1851 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 Scotland together with 'England', 'Wales', 'Islands in the British Seas', 'Ireland', 'British Colonies and East Indies', 'Foreign Parts - British Subjects', 'Foreign Parts - Foreigners', and 'Born at Sea'.
  3. We are currently unsure of the census geography used in this table.


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:

IndexTypeColumn(s) indexed
mig_1851_s_pkey Primary key rec_num
mig_1851_s_idx Unique birthplace, x_county, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
mig_1851_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_cou_no Integer number. Number of County
x_county Text string (max.len.=104). Name of x_county
t_u_20 Integer number. Total persons under 20 years
t_20_up Integer number. Total persons 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.