1971 Industry Statistics reorganised to 2007 Standard Industrial Classification

Table ID:
IND_1971_SIC2007     (6565697)
Contents:
1971 Industry Statistics reorganised to 2007 Standard Industrial Classification
Approx. number of rows:
87,424
Table type:
Derived
Documentation Author:
Humphrey Southall
Geography:
Reporting units are identified by:
   Administrative County
   Local Government District
   Local Government District Type
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The contents of this table are entirely derived from:
    • 1971 industry data, transcribed from Table 3 in the Economic Activity County Leaflets. NB this means that there are data only for County Boroughs and all other towns over 50,000 population, plus the potential to compute residuals from the county totals to cover all other districts. There are data in the 1971 Small Area Statistics which suggest a potential for improving estimates for the other districts.
    • 1971 Industry Codebook, used to re-allocate the data to the 2007 Standardised Industrial Classification.
    • 1971 age- and gender-structure table, listing all local government districts and providing the numbers of males and of females aged 15 or over. NB this table is currently also problematic, as it contains a transcription of the published 1971 table only for the West Riding, data for all other areas having been computed from Small Area Statistics which in fact relate to wards as defined in 1981.


Notes:

  1. The data held here were computed in two different ways:
    • For all County Boroughs, all London Boroughs and those Municipal Boroughs and Urban Districts with total populations over 50,000 the data are exact counts, based on re-classifying 1971 industry data, based on SIC 1968, to SIC 2007. They have however all been multiplied by 10 as they come from a 10% sample.
    • Data for all other units are based on this procedure:
      1. Extract a list of all districts plus male and female total populations from pop_lgd_1971_ew, which is a direct transcription of a 1971 table.
      2. Subtract from these total populations numbers aged from 0 to 14 as listed in age_lgd_1971, which holds somewhat more problematic estimates, to get numbers of men and of women aged 15 and over.
      3. For each district which does not have data in the Industry table, add the totals for men and for women for all such districts within the relevant county.
      4. From the Industry data, add the total numbers of men and of women "In Employment" in the county residuals, and use this to compute ratios of all men and all women in employment to all men and all women aged 15 and over. Use this to compute estimated numbers of men and of women in employment in each districts.
      5. Finally, use combone the ratios of each gender/SIC Division combination for each county residual with the estimated numbers in employment for each district to calculate district numbers for each SIC Division.
  2. One clear problem is that the industry data are based on place of work while the age structure data used in the estimation process count people by place of residence. However, note that:
    • The data for all the largest cities, including the whole of Greater London, are taken directly from the industry tables and area therefore all based on place of work.
    • The adjustment process described above means that counties with large outflows of commuters, such as Surrey, will have especially low ratios of persons in employment to resident population over 15; so at county level this problem is fully adjusted for.


Checking:

  1. Visual checks were made on sample data at various stages in the calculations.


Indices:

IndexTypeColumn(s) indexed
ind_1971_sic2007_pkey Primary key g_unit, sic_division


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
ind_1971_sic2007_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
adm_cnty Text string (max.len.=48). Name of the Administrative County to which the data relate.
lg_dist Text string (max.len.=68). Name of the local government district to which the data relate.
lg_type Text string (max.len.=20). Type of local government district.
admc_unit Integer number. ID number for Administrative County containing the unit, as defined in the AUO. Set for all reporting areas except the England and Wales totals.
g_unit Integer number. ID number for the reporting area, as defined in the AUO.
sic_division Integer number. Number identifying the Division within the 2007 Standard Industrial Classification.
sic_division_name Text string (max.len.=154). Name of the SIC 2007 Division.
males Floating point number. Number of males in this area and SIC Division.
females Floating point number. Number of females in this area and SIC Division.
rec_num Integer number. Sequence number keeping rows in order they were loaded in.