All categories in the 1951 Industrial Classification with mappings to other classifications

Table ID:
IND_1951_CODEBOOK     (6565640)
Contents:
All categories in the 1951 Industrial Classification with mappings to other classifications
Approx. number of rows:
204
Table type:
Codebook
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The list of "industries" is taken from Table 2, 'INDUSTRIES (Minimum List) and Status Aggregates, OCCUPIED MALES and FEMALES aged 15 and over' for 'Conurbations, Administrative Counties, County Boroughs, Metropolitan Boroughs and Urban Areas with 50,000 Population or more', pp. 12-113 in Census 1951: England and Wales: Industry Tables (London: HMSO, 1957), and should exactly match the industries listed in our table ind_1951_lg_t.
  2. An additional seven rows are included because they appear in the equivalent Scottish table, 'Industries of Occupied Population aged 15 and over by Place of Work. Scotland, Cities, Counties and Large Burghs', table 13 in 'Indsutry Tables'.
  3. The individual 1951 industrial "Units" have been assigned to the 2007 Standard Industrial Clasification using information available from UK Standard Industrial Classification of Economic Activities 2007 (UK SIC 2007) (http://www.ons.gov.uk/ons/guide-method/classifications/current-standard-classifications/standard-industrial-classification/index.html), and especially on the 'Summary of Structure' (http://www.ons.gov.uk/ons/guide-method/classifications/current-standard-classifications/standard-industrial-classification/sic-2007-summary-of-structure.xls, accessed 19th December 2014).
  4. This codebook was originally created by Humphrey Southall in spring 2015 to assist with research funded by the Greater London Authority.


Notes:

  1. The first two columns, 'rec_num' and 'industry', are identical to the columns of the same name in 'ind_1951_lg_t', and the next five columns hold the information in 'industry' in a more structured way, to aid analysis. The remaining columns link to other classifications.
  2. The Scottish table is based on exactly the same classification as the England and Wales table. However, the three pairs of units which are listed together in the England and Wales table are listed separately in the Scottish: "31,33. Chemicals, dyes, explosives, fireworks", "57,69. Other non-electrical engineering" and "82,83. Manufacture of aircraft; vehicle parts". The labels for other units in the Scottish table are often slightly longer and with more words capitalised, but no attempt has been made to capture those differences here.


Checking:

  1. The 1951 information was manuallyinput by Humphrey Southall and fairly carefully checked. The 2007 labels were cut and pasted from the ONS listing, but their assignment is of course a matter of judgement.


Indices:

IndexTypeColumn(s) indexed
ind_1951_codebook_pkey Primary key rec_num
ind_1951_codebook_idx_ew Unique ew_row, rec_num
ind_1951_codebook_idx_sco Unique sco_row, rec_num
ind_1951_codebook_idx_sic Unique sic_section, sic_division, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
ind_1951_codebook_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
rec_num Integer number. Sequence number identifying the different rows in the codebook, and placing them in the correct order.
ew_row Integer number. Number placing the row in the order in which it appears in the 'Large Towns' table for England and Wales. Null for rows which appear only in the Scottish table.
sco_row Integer number. Number placing the row in the order in which it appears in the 'Large Towns' table for Scotland. Null for rows which appear only in the England and Wales table.
industry Text string (max.len.=79). The row label as printed in the original table, and as held in the ind_1951_lg_t table. These contain the names of the Orders and Units within the Industrial Classification, and also twelve initial rows, mostly 'Status Aggregates':
  • Total - All industries
  • Married women (included in Total)
  • Employers
  • Managers - general managers, directors, etc.
  • Managers - of branch or primary departments
  • Managers - of office or subsidiary departments
  • Operatives - in Social Classes I and II
  • Operatives - others
  • Included in Operatives - Articled clerks and apprentices.
  • Included in Operatives - Part-time workers.
  • Included in Operatives - Unpaid assistants.
  • Working on own account.
The Scottish table lists the above rows in a slightly different order, and also includes a row giving overall totals for 'Employees'.
row_level Integer number. Number between 1 and 3 identfying the row's level in the classifcation: "Total - All industries" is level 1, Order totals and the rows in the 'Status Aggregates' which sum to the overall total are level 2, and the individual Units are level 3. The rows for 'Mariied women' and 'Included in Operatives' are not assigned to a level.
order_number Integer number. Number from 1 to 25 identifying the industrial 'Order'. For industries 1 to 24 these are equivalent to the roman numbers from I to XXIV used in the original report, and we assign "Not stated and ill-defined industry" to industry 25. This value is held for all rows at level 2 or 3, so it assigns the Units to Orders.
order_name Text string (max.len.=79). Name of the industrial 'Order', as listed in the original table. This is again held for all rows at level 2 or 3.
unit_number Text string (max.len.=12). The number of the industry "Group", held only for rows with level = 2. This has to be held as a character string because three of the values are pairs of numbers: "31,33. Chemicals, dyes, explosives, fireworks", "57,69. Other non-electrical engineering" and "82,83. Manufacture of aircraft; vehicle parts".
unit_name Text string (max.len.=79). Name of the Unit, or detailed industrial category. This is held only for rows with level = 2, and for these rows will be identical to 'industry' except that the initial numbers are stripped off and held in unit_number.
small_row_seq Integer number. The corresponding row in Table 3 of the 1951 Industry Tables, for small towns and Rural Districts, as identified by the row_seq column in the ind_1951_small table. NB in some cases the rows in that table hold groupings of the Units used in the large towns table, so in these cases more than one row here has the same value of small_row_seq; for example, both row 157 ("221. Tramway and omnibus service") and 158 ("222. Other road passenger transport" are mapped to row 62 in the small towns table as that holds data for "221,222. Road passenger transport". This column is included to assist in consistency checking and other calculations linking the two tables, and ALL rows that can be matched are, including the initial rows listing 'status aggregates'.
sic_query Text string (max.len.=6). This is a flag column which holds 'Q' if our assignment of the 1951 Unit to the 2007 SIC was seen as especially problematic; otherwise empty.
sic_section Text string (max.len.=6). Letter code, running from A to U, assigning the 1951 Unit to a 'Section' in the 2007 SIC. NB only rows with level = 2 are assigned to the 2007 SIC.
sic_section_name Text string (max.len.=126). Name of the 2007 SIC 'Section'. For example, 'A' is 'AGRICULTURE, FORESTRY AND FISHING' and 'T' is 'ACTIVITIES OF HOUSEHOLDS AS EMPLOYERS; UNDIFFERENTIATED GOODS-AND SERVICES-PRODUCING ACTIVITIES OF HOUSEHOLDS FOR OWN USE'. The only significance of the letters is to provide an ordering.
sic_division Integer number. Integer number identifying the 2007 SIC 'Division' to which we have assigned the 1951 Unit. These form a single sequence running from 1 to 99.
sic_division_name Text string (max.len.=134). Name of the 2007 SIC 'Division'. For example, 'AGRICULTURE, FORESTRY AND FISHING' is divided into (01) 'Crop and animal production, hunting and related service activities', (02) 'Forestry and logging', and (03) 'Fishing and aquaculture'. Some Sections contain only one division.