List of Divisions from the 2007 Standard Industrial Classification with associated Sections

Table ID:
SIC2007     (6567198)
Contents:
List of Divisions from the 2007 Standard Industrial Classification with associated Sections
Approx. number of rows:
89
Table type:
Codebook
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. This list of Divisions and Sections was abstracted from 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).
  2. The census labels were extracted from Key Statistics table KS606, for males, as downloaded from http://www.ons.gov.uk/ons/rel/census/2011-census/key-statistics-for-local-authorities-in-england-and-wales/rft-table-ks606ew.xls on 2nd June 2015.


Notes:

  1. This table simply lists the 'Orders' in SIC 2007, providing them with labels, and assigns each to one of the higher-level 'Sections', which are also provided with labels.
  2. The census sections are identical except that Sections R to U are merged into one, covering:
    • R ARTS, ENTERTAINMENT AND RECREATION
    • S OTHER SERVICE ACTIVITIES
    • T ACTIVITIES OF HOUSEHOLDS AS EMPLOYERS; UNDIFFERENTIATED GOODS-AND SERVICES-PRODUCING ACTIVITIES OF HOUSEHOLDS FOR OWN USE
    • U ACTIVITIES OF EXTRATERRITORIAL ORGANISATIONS AND BODIES
    Although we do not include a separate ID letter or number for these, each starts with the letter identifying the Section, the final one being listed as 'R Other'.
  3. One example of its possible use is as follows: the historical data for 1971 are linked to the 1971-specific codebook to assign 1971 categories to 2007 Divisions, but they are then further linked to this table to aggregate them into the simplified Sections used by the 2011 census:

    select sic.census_section, sum(data.males)*10, sum(data.females)*10
    from gbhdb.ind_1971_lg_t data, gbhdb.ind_1971_codebook code, gbhdb.sic2007 sic
    where code.row_seq = data.row_seq and
    sic.sic_division = code.sic_division and
    data.g_unit=10108664
    group by sic.census_section
    order by sic.census_section
  4. This codebook also includes a set of highly simplified Sectors that we have defined:
    1. Agriculture
    2. Mining [and quarrying]
    3. Manufacturing
    4. Utilities, Transport and Construction
    5. Consumer Services
    6. Business Services
    7. Public Services [including Health and Education]
    8. Unclassified


Checking:

  1. Downloaded information; no checking possible.


Indices:

IndexTypeColumn(s) indexed
sic2007_pkey Primary key sic_division


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
sic2007_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
sic_division Integer number. Integer number identifying the 2007 SIC 'Division'. These form a single sequence running from 1 to 99, but we have added 100 to cover unclassifiable workers.
sic_division_name Text string (max.len.=134). Name of the 2007 SIC 'Division'.
sic_section Text string (max.len.=6). Capital Letter identifying the SIC 'Section'. These form a single sequence running from A to U, but we have added X to cover unclassifiable workers.
sic_section_name Text string (max.len.=126). Name of the 2007 SIC 'Section'. These are all in capital letters, as listed in the source.
census_section Text string (max.len.=76). Name of the Section as listed in the 2011 Census tabulations providing the most detailed industrial listing broken down by sex (see above). These are mainly in lowe case and group together the four final Sections.
gbh_sector Integer number. Number from 1 to 8 identifying a set of highly simplified Sectors defined by the project.
gbh_sector_name Text string (max.len.=24). Name of the Sector, as defined by the project.