GB Historical DB

Parish-level statistics of age, gender and marital status for Scotland in 1911.

Table ID:
AGE_SCOT_PAR     (1246628)
Contents:
Parish-level statistics of age, gender and marital status for Scotland in 1911.
Approx. number of rows:
8,863
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data are for the single year 1911.

Sources:

  1. This table holds a complete transcription of Table 20A in the separate County Reports of the 1911 Census of Scotland, "Population of the county and its civil parishes by sex and conjugal condition in quinquennial age-groups".
  2. It also holds national totals taken from Table 24, "Population of the Counties by Sex and Conjugal Condition, in Quninquennial Age Groups", in volume II of the 1911 reports for Scotland, Population, ages, conjugal condition, occupations, birthplaces, housing, Gaelic-speaking. In practice, our table includes the whole of Table 24, as its data for individual counties duplicate the county totals listed in Table 20A. Table 24 does not provide a breakdown of the individual ages under 5, so the national totals for these have been added from Table 23, "Scotland. Age-distribution and conjugal condition of population".
  3. These data were all computerised by the Centre for Data Digitisation and Analysis, as part of the Historical Population Reports project, and were downloaded as a large set of Excel spreadsheets from the Histpop web site on October 14th-15th, 2016. They have been assembled into a single dataset, and further checked and corrected, by the GB Historical GIS Project.

Notes:

  1. This table provides very detailed data on demographic structure, breaking population down by gender and marital status as well as age, and consequently there are at least nine rows of data for each area: these start with the numbers of males, females and 'both sexes' regardless of marital status, followed by rows for numbers of males broken down by marital status, and terminatng with rows for numbers of females broken down by marital status.
  2. The tables in the City reports for Dundee and Glasgow provide data for multiple parishes within these cities. However, the tables in the City reports for Edinburgh and Aberdeen list only overall totals plus, for Aberdeen, data for the parts of the city in Aberdeenshire and Kincardine. To make the table complete, copies of the data for the cities of Edinburgh and Aberdeen have been added and given the IDs of the parishes of the same name.
  3. In addition to the data for parishes, counties and the national total, all of which have been assigned unit IDs from the AUO, the table also includes totals for:
    1. County totals including associated cities, for the relevant counties. These are identified by the exclude_city flag.
    2. For the city of Aberdeen, figures for the parts in Aberdeenshire and Kincardine. These are also identified by the exclude_city flag.
    3. For Linlithgowshire and Ross and Cromarty only, data for the 'Naval Population'. For Linlithgow this is associated with 'PARISH of DALMENY & BURGH of QUEENSFERRY', and for Ross and Cromarty data are given, separately, for 'PARISH OF CROMARTY' and 'BURGH OF CROMARTY'. In each case, the data provided are limited, with no breakdown by gender or for the individual years under 5. However, NB the checks listed below on parishes adding up to county totals and counties adding up to the national totals are met without including these numbers, so they can be ignored.
    These data always have g_unit left empty.

Checking:

  1. Simple single-row check sums were added to the down-loaded spreadsheets and found a significant number of inconsistencies due either to transcriptions errors or printing errors in the original reports. These were all corrected by cross-checking the different rows for the same unit, enabling formal check constraints to be added to the table.
  2. Cross-checks within areas between rows were run to confirm that for all areas assigned unit IDs:
    • For the overall totals ignoring marital status, the sum of 'Males' and 'Females' equalled 'Both Sexes'.
    • The sum of the male marital status categories matched the reported total for 'Males'.
    • The sum of the female marital status categories matched the reported total for 'Females'.
  3. Cross-checks between areas were run to confirm that for all areas assigned unit IDs:
    • The sum of the county population totals matched the reported total for Scotland.
    • For all counties, the sum of the parish population totals matched the reported total for Scotland.
    • All counties with listed totals had associated parishes, and vice-versa.

Indices:

IndexTypeColumn(s) indexed
age_scot_par_pkey Primary key rec_num

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
age_scot_par_pkey Primary Key See details above for primary key index
check_age Check (((((((((((((((((((((((a_0_4 + a_5_9) + a_10_14) + a_15_19) + a_20_24) + a_25_29) + a_30_34) + a_35_39) + a_40_44) + a_45_49) + a_50_54) + a_55_59) + a_60_64) + a_65_69) + a_70_74) + a_75_79) + a_80_84) + a_85_89) + a_90_94) + a_95_99) + a_100_up) + a_ns) = total))
check_under5 Check ((((((a_0 + a_1) + a_2) + a_3) + a_4) = a_0_4))


Columns within table:

ColumnTypeContents
cnty_unit Integer number. ID number for the county containing the unit, as defined in the AUO. This has been set for all rows except the national totals, as all other rows come from a particular county report, but should not be used to extract county totals. Instead, use g_unit where g_unit = cnty_unit.
g_unit Integer number. ID number for the unit the data are for, as defined in the AUO. This will be identical to cnty_unit for county and city totals. It will be empty for rows where exclude_city = Y.
sco_cnty Text string (max.len.=34). Name of the county, as extracted from the title of the particular table the row of data was extracted from.
page_number Integer number. Number of the page within the report from which this row of data was extracted.
area_label Text string (max.len.=94). The full text of the 'Parish' column in the original report. For parishes this is usually just the parish name preceded by a number placing it in sequence within the county, but sometimes additional information is given.
area_name Text string (max.len.=64). Name of the parish, or a label indicating another type of area.
part_of Text string (max.len.=5). Flag, holding 'P' where the data cover only part of the unit concerned, usually because a parish was divided between two different counties, or between a county and a city.
exclude_city Text string (max.len.=5). Flag, usually empty but 'Y' for rows which should be excluded to avoid double-counting the populations of the four Scottish cities. These are usually county totals.
gender Text string (max.len.=14). Gender: The following strings appear:-
  • Females
  • Males
  • Both Sexes
mar_status Text string (max.len.=14). Marital Status: The following strings appear:-
  • Single
  • Married
  • Widowed [NB appears for both males and females]
  • Not Stated [appears only for some areas]
  • Total [appears only in connection with the 'Naval Populations']
total Integer number. Number of persons of all ages.
a_0 Integer number. Number of persons aged under 1 year.
a_1 Integer number. Number of persons aged 1.
a_2 Integer number. Number of persons aged 2.
a_3 Integer number. Number of persons aged 3.
a_4 Integer number. Number of persons aged 4.
a_0_4 Integer number. Number of persons aged under 5.
a_5_9 Integer number. Number of persons aged 5 to 9.
a_10_14 Integer number. Number of persons aged 10 to 14.
a_15_19 Integer number. Number of persons aged 15 to 19.
a_20_24 Integer number. Number of persons aged 20 to 44.
a_25_29 Integer number. Number of persons aged 25 to 29.
a_30_34 Integer number. Number of persons aged 30 to 34.
a_35_39 Integer number. Number of persons aged 35 to 39.
a_40_44 Integer number. Number of persons aged 40 to 44.
a_45_49 Integer number. Number of persons aged 45 to 49.
a_50_54 Integer number. Number of persons aged 50 to 54.
a_55_59 Integer number. Number of persons aged 55 to 59.
a_60_64 Integer number. Number of persons aged 60 to 64.
a_65_69 Integer number. Number of persons aged 65 to 69.
a_70_74 Integer number. Number of persons aged 70 to 74.
a_75_79 Integer number. Number of persons aged 75 to 79.
a_80_84 Integer number. Number of persons aged 80 to 84.
a_85_89 Integer number. Number of persons aged 85 to 89.
a_90_94 Integer number. Number of persons aged 90 to 94.
a_95_99 Integer number. Number of persons aged 95 to 99.
a_100_up Integer number. Number of persons aged 100 and above.
a_ns Integer number. Number of persons with age not stated.
rec_num Integer number. Sequence number keeping the rows in order.