GB Historical DB

Statistics for Scottish parishes, burghs and County Districts taken from the 1921 census

Table ID:
PAR_1921_S     (1252518)
Contents:
Statistics for Scottish parishes, burghs and County Districts taken from the 1921 census
Approx. number of rows:
1,308
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1911 to 1921.

Sources:

  1. This table holds an almost complete transcription of Table 1, "Population of Burghs, County Districts, and Civil Parishes in 1921 and in 1911.", in the County Reports of the 1921 Census of Scotland. The only data not included are some sub-totals e.g. for all burghs in a county, which can easily be computed from the data here.
  2. The data were mostly originally transcribed by the Centre for Data Digitisation and Analysis at the Queen's University of Belfast, in 2001, but with certain gaps. The data were completely re-organised, re-checked and missing data added by Humphrey Southall and Paula Aucott at Portsmouth in February 2016.
  3. The additional data entry included adding county totals and an overall Scotland total from Table 1, "Population of Scotland by Counties and Cities", in Volume II of the 1921 Scottish Report, Population, ages, conjugal condition, orphanhood, birthplaces, Gaelic-speaking, housing, which contains exactly the same columns.

Notes:

  1. The following types of unit appear in the table and have been systematically matched to the AUO (the counts exclude rows with exclude_city = Y or data_1921 = Y):
    • Nation (1 area): totals for Scotland, as entered from Vol. II of the Report.
    • County (33 areas).
    • City (4 areas): Aberdeen, Dundee, Edinburgh, Glasgow.
    • Burgh (229 areas): NB this report makes no distinction between types of burgh.
    • Parish (882 areas).
    The table as held here also includes other types of area, which have not been matched to the AUO:
    • County District (112 areas): these are quite substantially different from the Districts of County listed in 1931, and simply fewer. This unit type is not currently in the AUO.
    • Whole Parish (6 areas): Including these would duplicate the rows where they are separated into parts by county.
    • Burgh (1 area): Renfrew in Renfrewshire which was partly in Lanark. That other part was actually in the City of Glasgow. In 1931 the report treats the whole burgh as part of the City of Glasgow and only that row contributes to overall totoals. It needs to be confirmed whether this is also true for 1921.

Checking:

  1. Numbers of females and males correctly sum to total population for both 1921 and 1931 for all areas.
  2. All counts for Burghs and County Districts were summed by county and compared with the published county totals.
  3. Similar checking against county totals was carried out for parishes.
  4. The above checking against county totals could not be done for rows excluded to avoid double counting of City populations, or holding data for units as defined in 1911. The data in the final six columns, holding rates or inter-censal changes, have not been checked but rather replaced by new values computed from other columns.
  5. At the time of writing, a substantial number of rows fail the above checks, and more cleaning work is needed.

Indices:

IndexTypeColumn(s) indexed
par_1921_s_pkey Primary key rec_num
par_1921_s_idx Unique sco_cnty, sco_type, sco_area, rec_num

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
par_1921_s_pkey Primary Key See details above for primary key index


Columns within table:

ColumnTypeContents
area_num Integer number. [No description available]
sco_cnty Text string (max.len.=24). Name of the county; the data are from the County Reports, so this is part of the volume title.
sco_area Text string (max.len.=54). Name of Burgh, County District, or Civil Parish. The various county totals all have area_name = 'TOTAL'.
sco_type Text string (max.len.=34). Type of area; these actually appear above the start of each type of area name. See above notes for the values appearing here.
cnty_unit Integer number. Unit ID for the county containing the current area, as defined in the AUO. Note that the table includes rows for county totals, with g_unit set to the county ID, whereas summing the data by cnty_unit will produce massive over-counting.
g_unit Integer number. Unit ID for the current unit, which may be the nation, a county, a city, a Burgh or a Parish. Deliberately unset for various totals, and for rows which would cause double-counting (see above).
area_note Text string (max.len.=84). Text immediately following area name. This includes dates of boundary changes, within brackets.
part_of Text string (max.len.=6). Flag: "Y" if area is labellled as "Part of". Usually means the remainder is in another county but sometimes parts are inside and outside cities.
exclude_city Text string (max.len.=6). Flag: "Y" indicates rows withing county listings which duplicate data included in the reports for cities, which should be excluded to avoid double counting. These rows all have null values of g_unit.
data_are_for_1911 Text string (max.len.=6). Flag: "Y" indicates the row is for the population of the unit as defined in 1911. These rows all have null values of g_unit.
pop_1921 Integer number. Original column heading: '1921: Population: Both Sexes'.
male_1921 Integer number. Original column heading: '1921: Population: Males'.
fem_1921 Integer number. Original column heading: '1921: Population: Females'.
sep_occ_1921 Integer number. Original column heading: '1921: Separate Occupiers'.
hous_occ_1921 Integer number. Original column heading: '1921: Houses: Occupied'.
hous_unoc_1921 Integer number. Original column heading: '1921: Houses: Unoccupied'.
hous_bdg_1921 Integer number. Original column heading: '1921: Houses: Building'.
room_1921 Integer number. Original column heading: '1921: Windowed Rooms (Occupied Houses only)'.
pop_1911 Integer number. Original column heading: '1911: Population: Both Sexes'.
male_1911 Integer number. Original column heading: '1911: Population: Males'.
fem_1911 Integer number. Original column heading: '1911: Population: Females'.
sep_occ_1911 Integer number. Original column heading: '1911: Separate Occupiers'.
hous_occ_1911 Integer number. Original column heading: '1911: Houses: Occupied'.
hous_unoc_1911 Integer number. Original column heading: '1911: Houses: Unoccupied'.
hous_bdg_1911 Integer number. Original column heading: '1911: Houses: Building'.
room_1911 Integer number. Original column heading: '1911: Windowed Rooms (Occupied Houses only)'.
area_1921 Integer number. Original column heading: 'Area in Acres (1921)'.
pop_acre_1921 Integer number. Original column heading: 'Population in 1921: Per 100 Acres'.
pop_room_1921 Integer number. Original column heading: 'Population in 1921: Per 100 Rooms'.
inc_1121_num Integer number. Original column heading: 'Inter-censal Change of Population 1911-1921: Increase: Actual'.
inc_1121_pc Floating point number. Original column heading: 'Inter-censal Change of Population 1911-1921: Increase: Per Cent'.
dec_1121_num Integer number. Original column heading: 'Inter-censal Change of Population 1911-1921: Decrease: Actual'.
dec_1121_pc Floating point number. Original column heading: 'Inter-censal Change of Population 1911-1921: Decrease: Per Cent'.
notes Text string (max.len.=1004). Footnotes transcribed from the report.
rec_num Integer number. Sequence number keeping rows in order.