GB Historical DB

Industrial structure data from various dates reclassified to SIC2007 and redistricted to 2011 Local Authority Districts

Table ID:
IND_REDISTRICTED     (1251106)
Contents:
Industrial structure data from various dates reclassified to SIC2007 and redistricted to 2011 Local Authority Districts
Approx. number of rows:
7,293
Table type:
Derived
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1841 to 2011.
Dates and times are identified by:
   Year

Sources:

  1. This table was generated partly from data from various years held in tables in this 'cen_ind' section, but also from earlier data on occupations.
  2. The areas covered by the table vary by date. It currently provides complete coverage of Britain for 1841, 1931, 1951, 1971, 1991 and 2011, and complete coverage of England and Wales for 1861, 1881 and 1911.

Notes:

  1. The columns of this table are those of 2011 census table WP605EW, Industry by Workplace, whose data is not broken down by gender (so sex = 'A', for all). However, we have added to it data from earlier censuses and for these there are two rows per district, for males and females.
  2. The table includes columns enabling various items of metadata needed by the g_data table to be pre-set here, as the data from different dates will have different sources, acknowledgment requirements, etc.
  3. The data held here are based on place of work for 1951 and 1971, on place of usual residence for 2011 (see above), and on location on census night for 1931 and all earlier dates.

Checking:

  1. Derived data: the scripts used to generate these data have been checked carefully.

Indices:

IndexTypeColumn(s) indexed
ind_redistricted_pkey Primary key g_unit, year, sex

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
ind_redistricted_pkey Primary Key See details above for primary key index


Columns within table:

ColumnTypeContents
row_type Text string (max.len.=14). Type of row: 'DISTRICT' = data are for a Local Authority District, 'GOR' = data are for a Government Office Region, 'E&W' = data are overall totals for England and Wales, 'CAZ' = data are for the Central Activity Zone as defined by the Greater London Authority.
area_code Text string (max.len.=18). ONS code for the District or Unitary Authority.
area_name Text string (max.len.=52). Name of the reporting area.
nation Text string (max.len.=8). [No description available]
region Text string (max.len.=28). Name of the (government office) Region containing the District or Unitary Authority. Null for national totals.
reg_unit Integer number. ID number of the (government office) Region containing the District or Unitary Authority as defined in the GBHGIS AUO. Null for national totals.
cnty_unit Integer number. [No description available]
g_unit Integer number. ID number of the District or Unitary Authority as defined in the GBHGIS AUO.
lb_unit Integer number. [No description available]
geogcode_1991 Text string (max.len.=9). [No description available]
year Integer number. Date of the census.
sex Text string (max.len.=6). Gender: 'A' means all, i.e. males and females combined. 'F' means females, and 'M' means males.
total Floating point number. Total of persons in all industries.
a_agric Floating point number. Persons in SIC2007 Section A Agriculture, forestry and fishing.
b_mining Floating point number. Persons in SIC2007 Section B Mining and quarrying.
c_manuf Floating point number. Persons in SIC2007 Section C Manufacturing.
d_power Floating point number. Persons in SIC2007 Section D Electricity, gas, steam and air conditioning supply.
e_water Floating point number. Persons in SIC2007 Section E Water supply, sewerage, waste management and remediation activities.
f_const Floating point number. Persons in SIC2007 Section F Construction.
g_trade Floating point number. Persons in SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles.
h_transp Floating point number. Persons in SIC2007 Section H Transport and storage.
i_accom Floating point number. Persons in SIC2007 Section I Accommodation and food service activities.
j_infocom Floating point number. Persons in SIC2007 Section J Information and communication. Not identifiable within 1951 data, so always zero for that year.
k_finance Floating point number. Persons in SIC2007 Section K Financial and insurance activities.
l_estate Floating point number. Persons in SIC2007 Section L Real estate activities. Not identifiable within 1951 data, so always zero for that year.
m_prof Floating point number. Persons in SIC2007 Section M Professional, scientific and technical activities.
n_admin Floating point number. Persons in SIC2007 Section N Administrative and support service activities. Not identifiable within 1931 or 1951 data, so always zero for those years.
o_public Floating point number. Persons in SIC2007 Section O Public administration and defence; compulsory social security.
p_educ Floating point number. Persons in SIC2007 Section P Education.
q_health Floating point number. Persons in SIC2007 Section Q Human health and social work activities.
rs_leisure Floating point number. Persons in SIC2007 Section R Arts, Entertainment and Recreation, and S, Other Services.
t_hhold Floating point number. Persons in SIC2007 Section T Activities of households as employers; undifferentiated goods - and services - producing activities of households for own use.
u_extra Floating point number. Persons in SIC2007 Section U Activities of extraterritorial organisations and bodies. Not identifiable within 1951 data, so always zero for that year.
rstu_other Floating point number. Persons in SIC2007 Sections R, S, T and U. This is the only data available for these Sections in the 2011 data for Scotland, but for all other areas and dates it has been calculated from other columns in the table.
c_manuf_food Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 10-12 Food, beverages and tobacco.
c_manuf_cloth Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 13-15 Textiles, wearing apparel and leather and related products.
c_manuf_wood Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 16,17 Wood, paper and paper products.
c_manuf_chem Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 19-22 Chemicals, chemical products, rubber and plastic.
c_manuf_low Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 23-25 Low tech.
c_manuf_high Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 26-30 High tech.
c_manuf_other Floating point number. Persons in SIC2007 Section C Manufacturing, Divisions 18, 31, 32 Other.
tress_index Floating point number. Tress Index, as defined in Tress, R.C., "Unemployment and the diversification of industry", The Manchester School, 9 (1938), pp.140-152. It is computed here from the 18 SIC Sections listed here (treating R/S/T/U as a single Section). The result varies between zero, when all categories in a district contain equal numbers of workers, and one, when all workers are in just one category.
g_authority Text string (max.len.=24). Source of information, as defined in the auo.g_authority table. This has the default value 'CEN', meaning the Census of Population generically, but more precise information should be included if possible.
g_auth_note Text string (max.len.=404). Additional detail of the source. If g_authority = 'SRC', g_auth_note should be a source table identifier.
cellref_start Text string (max.len.=34). First part of cellRef: INDUSTRY_GEN_SEX:female/, INDUSTRY_GEN: or INDUSTRY_GEN_SEX:male/ depending on values of sex
g_data_precision Text string (max.len.=12). 'Precision' of the data. This has the default value 'GBR', as most data in this table will have been Redistricted by the GB Historical GIS.
g_data_status Text string (max.len.=9). Status of the data. The default is 'P', i.e. the data can be made entirely public.
g_credit Text string (max.len.=28). Credit string, linking to the Credits sub-system and so allowing acknowledgment of external contributors.
hh_index Floating point number. Herfindahl-Hirschman Index, as defined in Palan, Nicole (2010), Measurement of Specialization: The Choice of Indices, FIW Working Paper, No. 62, Forschungsschwerpunkt Internationale Wirtschaft (Research Centre in International Economics), Vienna. It is computed here from the 18 SIC Sections listed here (treating R/S/T/U as a single Section). The result varies from zero, meaning totally diverse, to 10,000, meaning that all employment is in a single industry.