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

Table ID:

MIG_1861_S     (1251486)

Contents:

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

Approx. number of rows:

1,353

Table type:

Raw Data

Documentation Author:

Paul Ell

Geography:

Reporting units are identified by:
   Unspecified County

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 the Counties of Scotland' in the 1861 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 (which include summary data for Scotland, the Northern and Southern Portions, and for the 8 Scottish census divisions).

---

Notes:

1. The original table was organised with columns giving the county of birth and rows giving the county of residence, 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', 'Ireland', 'Man, Guernsey, and Jersey', 'British Colonies', 'British Subjects Born in Foreign Parts', 'Foreigners', and 'Born at Sea, British'.
3. We are currently unsure of the census geography used in this table.

---

Checking:

1. The original tables contains a column giving the total population residing in each county. These data were compared to the summed birthplace values for each county.
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_s_pkey	Primary key	rec_num
mig_1861_s_idx	Unique	birthplace, x_county, rec_num

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
mig_1861_s_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
x_cou_no	Integer number.	Number of County
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.