Industry statistics for counties, cities and large burghs in Scotland for 1951

Table ID:
IND_1951_S     (6565655)
Contents:
Industry statistics for counties, cities and large burghs in Scotland for 1951
Approx. number of rows:
11,658
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The data were transcribed from Table 13, 'Industries of Occupied Population aged 15 and over by Place of Work. Scotland, Cities, Counties and Large Burghs' pp. 434-69 in Census 1951: Scotland: Industry Tables (Edinburgh: HMSO, 1957).
  2. This is a full transcription of all numerical data in the table with the sole exception of the column for 'Both Sexes' in the national totals (which is included in our spreadsheet transcription, but did not justify adding a column here).
  3. This table is the product of work by Humphrey Southall in August 2015, using Finreader OCR software.


Notes:

  1. The table contains data for the following area types, all of which have been matched to the AUO:
    • Nation (1 area): Total for Scotland.
    • County (33 areas): Includes Burghs but excludes Cities.
    • City (4 areas): Aberdeen, Dundee, Edinburgh and Glasgow.
    • Burgh (20 areas): NB these are only the Large Burghs, while other Scotland 1951 tables cover 190 Burghs.


Checking:

  1. As the data were input, these checks were made:
    • That the sum Employers, Employees and "Working on own account" matched "ALL INDUSTRIES".
    • That the sum of the various kinds of employees, including managers, matched "Employees".
    • That the sum of the Order totals matched "ALL INDUSTRIES".
    • That the sum of the individual categories matched the listed total for each Order.
  2. The above checks do not prevent errors (a) in the three groups itemised within employees, i.e. "Apprentices and Articled Employees", "Part-time workers" and "Unpaid Family Workers", or (b) through numbers within checksum groupings being input into the wrong rows. However, additional check-sums were computed comparing the national totals with the sum of the counties and cities. Those row-based checksums do not cover the Burgh data, but their figures for the three employee sub-groups were carefully proof-read.
  3. All the above checksums are met, so the data are believed to be substantially error-free.


Indices:

IndexTypeColumn(s) indexed
ind_1951_s_idx Unique col_seq, sco_row


Columns within table:

ColumnTypeContents
col_seq Integer number. Number placing units in the order in which they appear in the original table.
area_name Text string (max.len.=42). Name of the area the data are for.
area_type Text string (max.len.=10). Type of area. These are 'Nation', 'County', 'City' and 'Burgh'.
g_unit Integer number. ID number of the reporting area, as defined in the GBHGIS AUO.
sco_row Integer number. Sequence number identifying the different rows for each unit, and placing them in the correct order. Called 'sco_row' because the England and Wales industry table has a different order.
industry Text string (max.len.=84). Label identifying the row, as printed in the original report. These are a mixture of Order names, more detailed categories and the "Status Aggregates" at the top of the table, so for more systematic analysis this table should be linked to the ind_1951_codebook table, which also has an sco_row column.
males Integer number. Number of males employed.
females Integer number. Number of females employed.