GB Historical DB

Industry statistics for all local authority districts in England and Wales, based on place of work.

Table ID:
IND_REDISTRICTED_WPLACE     (1251151)
Contents:
Industry statistics for all local authority districts in England and Wales, based on place of work.
Approx. number of rows:
348
Table type:
Derived
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1841 to 2011.

Sources:

  1. Data have been assembled from other tables in this section of the database.

Notes:

  1. This table holds information for all Districts and Unitary Authorities in England and Wales, but not for higher level units (or for Scotland).
  2. The major limitation of this table is that it does not break the workforce down by gender, but it is based on places of work.
  3. This table is based on SIC 2007, but using only the Sections, not the Divisions, and merges Sections R and S, and T and U.

Checking:

  1. Derived data; no additional checking.

Indices:

IndexTypeColumn(s) indexed
ind_redistricted_wplace_pkey Primary key g_unit

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
ind_redistricted_wplace_pkey Primary Key See details above for primary key index


Columns within table:

ColumnTypeContents
row_type Text string (max.len.=12). [No description available]
area_code Text string (max.len.=18). Code number as defined by the cenusus offices. The numbers for areas within England and Wales formed part of the download from ONS and are included here unchanged.
mod_dist_name Text string (max.len.=40). Name of the District or Unitary Authority.
g_unit Integer number. ID number of the local government district, county, region or nation as defined in the GBHGIS AUO. NB all rows in the table have a unit ID.
total_1841 Floating point number. SIC2007 Section All categories: Industry. Data from 1841 census.
a_agric_1841 Floating point number. SIC2007 Section A Agriculture, forestry and fishing. Data from 1841 census.
b_mining_1841 Floating point number. SIC2007 Section B Mining and quarrying. Data from 1841 census.
c_manuf_1841 Floating point number. SIC2007 Section C Manufacturing. Data from 1841 census.
d_power_1841 Floating point number. SIC2007 Section D Electricity, gas, steam and air conditioning supply. Data from 1841 census.
e_water_1841 Floating point number. SIC2007 Section E Water supply, sewerage, waste management and remediation activities. Data from 1841 census.
f_const_1841 Floating point number. SIC2007 Section F Construction. Data from 1841 census.
g_trade_1841 Floating point number. SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles. Data from 1841 census.
h_transp_1841 Floating point number. SIC2007 Section H Transport and storage. Data from 1841 census.
i_accom_1841 Floating point number. SIC2007 Section I Accommodation and food service activities. Data from 1841 census.
j_infocom_1841 Floating point number. SIC2007 Section J Information and communication. Data from 1841 census.
k_finance_1841 Floating point number. SIC2007 Section K Financial and insurance activities. Data from 1841 census.
l_estate_1841 Floating point number. SIC2007 Section L Real estate activities. Data from 1841 census.
m_prof_1841 Floating point number. SIC2007 Section M Professional, scientific and technical activities. Data from 1841 census.
n_admin_1841 Floating point number. SIC2007 Section N Administrative and support service activities. Data from 1841 census.
o_public_1841 Floating point number. SIC2007 Section O Public administration and defence; compulsory social security. Data from 1841 census.
p_educ_1841 Floating point number. SIC2007 Section P Education. Data from 1841 census.
q_health_1841 Floating point number. SIC2007 Section Q Human health and social work activities. Data from 1841 census.
rstu_other_1841 Floating point number. SIC2007 Sections 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) and U (Activities of extraterritorial organisations and bodies). Data from 1841 census.
sector_prim_manuf_1841 Floating point number. Primary and Manufacturing in 1841. Simplified sector defined by project, covering SIC Sections A (Agriculture), B (Mining) and C (Manufacturing).
sector_util_tran_const_1841 Floating point number. Utilities, Transport and Construction in 1841. Simplified sector defined by project, covering SIC Sections D (Electricity, gas, steam and air conditioning supply), E (Water supply, sewerage, waste management and remediation activities), F (Construction) and H (Transport and storage).
sector_consumer_serv_1841 Floating point number. Consumer Services in 1841. Simplified sector defined by project, covering SIC Sections G (Wholesale and retail trade; repair of motor vehicles and motor cycles), I (Accommodation and food service activities) and RSTU (Other services).
sector_finance_bus_1841 Floating point number. Finance and Business Services in 1841. Simplified sector defined by project, covering SIC Sections J (Information and communication), K (Financial and insurance activities), L (Real estate activities), M (Professional, scientific and technical activities) and N (Administrative and support service activities).
sector_public_hlth_edu_1841 Floating point number. Public Administration, Health and Education in 1841. Simplified sector defined by project, covering SIC Sections O (Public administration and defence; compulsory social security), P (Education) and Q (Human health and social work activities).
total_1881 Floating point number. SIC2007 Section All categories: Industry. Data from 1881 census.
a_agric_1881 Floating point number. SIC2007 Section A Agriculture, forestry and fishing. Data from 1881 census.
b_mining_1881 Floating point number. SIC2007 Section B Mining and quarrying. Data from 1881 census.
c_manuf_1881 Floating point number. SIC2007 Section C Manufacturing. Data from 1881 census.
d_power_1881 Floating point number. SIC2007 Section D Electricity, gas, steam and air conditioning supply. Data from 1881 census.
e_water_1881 Floating point number. SIC2007 Section E Water supply, sewerage, waste management and remediation activities. Data from 1881 census.
f_const_1881 Floating point number. SIC2007 Section F Construction. Data from 1881 census.
g_trade_1881 Floating point number. SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles. Data from 1881 census.
h_transp_1881 Floating point number. SIC2007 Section H Transport and storage. Data from 1881 census.
i_accom_1881 Floating point number. SIC2007 Section I Accommodation and food service activities. Data from 1881 census.
j_infocom_1881 Floating point number. SIC2007 Section J Information and communication. Data from 1881 census.
k_finance_1881 Floating point number. SIC2007 Section K Financial and insurance activities. Data from 1881 census.
l_estate_1881 Floating point number. SIC2007 Section L Real estate activities. Data from 1881 census.
m_prof_1881 Floating point number. SIC2007 Section M Professional, scientific and technical activities. Data from 1881 census.
n_admin_1881 Floating point number. SIC2007 Section N Administrative and support service activities. Data from 1881 census.
o_public_1881 Floating point number. SIC2007 Section O Public administration and defence; compulsory social security. Data from 1881 census.
p_educ_1881 Floating point number. SIC2007 Section P Education. Data from 1881 census.
q_health_1881 Floating point number. SIC2007 Section Q Human health and social work activities. Data from 1881 census.
rstu_other_1881 Floating point number. SIC2007 Sections 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) and U (Activities of extraterritorial organisations and bodies). Data from 1881 census.
sector_prim_manuf_1881 Floating point number. Primary and Manufacturing in 1881. Simplified sector defined by project, covering SIC Sections A (Agriculture), B (Mining) and C (Manufacturing).
sector_util_tran_const_1881 Floating point number. Utilities, Transport and Construction in 1881. Simplified sector defined by project, covering SIC Sections D (Electricity, gas, steam and air conditioning supply), E (Water supply, sewerage, waste management and remediation activities), F (Construction) and H (Transport and storage).
sector_consumer_serv_1881 Floating point number. Consumer Services in 1881. Simplified sector defined by project, covering SIC Sections G (Wholesale and retail trade; repair of motor vehicles and motor cycles), I (Accommodation and food service activities) and RSTU (Other services).
sector_finance_bus_1881 Floating point number. Finance and Business Services in 1881. Simplified sector defined by project, covering SIC Sections J (Information and communication), K (Financial and insurance activities), L (Real estate activities), M (Professional, scientific and technical activities) and N (Administrative and support service activities).
sector_public_hlth_edu_1881 Floating point number. Public Administration, Health and Education in 1881. Simplified sector defined by project, covering SIC Sections O (Public administration and defence; compulsory social security), P (Education) and Q (Human health and social work activities).
total_1931 Floating point number. SIC2007 Section All categories: Industry. Data from 1931 census.
a_agric_1931 Floating point number. SIC2007 Section A Agriculture, forestry and fishing. Data from 1931 census.
b_mining_1931 Floating point number. SIC2007 Section B Mining and quarrying. Data from 1931 census.
c_manuf_1931 Floating point number. SIC2007 Section C Manufacturing. Data from 1931 census.
d_power_1931 Floating point number. SIC2007 Section D Electricity, gas, steam and air conditioning supply. Data from 1931 census.
e_water_1931 Floating point number. SIC2007 Section E Water supply, sewerage, waste management and remediation activities. Data from 1931 census.
f_const_1931 Floating point number. SIC2007 Section F Construction. Data from 1931 census.
g_trade_1931 Floating point number. SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles. Data from 1931 census.
h_transp_1931 Floating point number. SIC2007 Section H Transport and storage. Data from 1931 census.
i_accom_1931 Floating point number. SIC2007 Section I Accommodation and food service activities. Data from 1931 census.
j_infocom_1931 Floating point number. SIC2007 Section J Information and communication. Data from 1931 census.
k_finance_1931 Floating point number. SIC2007 Section K Financial and insurance activities. Data from 1931 census.
l_estate_1931 Floating point number. SIC2007 Section L Real estate activities. Data from 1931 census.
m_prof_1931 Floating point number. SIC2007 Section M Professional, scientific and technical activities. Data from 1931 census.
n_admin_1931 Floating point number. SIC2007 Section N Administrative and support service activities. Data from 1931 census.
o_public_1931 Floating point number. SIC2007 Section O Public administration and defence; compulsory social security. Data from 1931 census.
p_educ_1931 Floating point number. SIC2007 Section P Education. Data from 1931 census.
q_health_1931 Floating point number. SIC2007 Section Q Human health and social work activities. Data from 1931 census.
rstu_other_1931 Floating point number. SIC2007 Sections 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) and U (Activities of extraterritorial organisations and bodies). Data from 1931 census.
sector_prim_manuf_1931 Floating point number. Primary and Manufacturing in 1931. Simplified sector defined by project, covering SIC Sections A (Agriculture), B (Mining) and C (Manufacturing).
sector_util_tran_const_1931 Floating point number. Utilities, Transport and Construction in 1931. Simplified sector defined by project, covering SIC Sections D (Electricity, gas, steam and air conditioning supply), E (Water supply, sewerage, waste management and remediation activities), F (Construction) and H (Transport and storage).
sector_consumer_serv_1931 Floating point number. Consumer Services in 1931. Simplified sector defined by project, covering SIC Sections G (Wholesale and retail trade; repair of motor vehicles and motor cycles), I (Accommodation and food service activities) and RSTU (Other services).
sector_finance_bus_1931 Floating point number. Finance and Business Services in 1931. Simplified sector defined by project, covering SIC Sections J (Information and communication), K (Financial and insurance activities), L (Real estate activities), M (Professional, scientific and technical activities) and N (Administrative and support service activities).
sector_public_hlth_edu_1931 Floating point number. Public Administration, Health and Education in 1931. Simplified sector defined by project, covering SIC Sections O (Public administration and defence; compulsory social security), P (Education) and Q (Human health and social work activities).
total_1951 Floating point number. SIC2007 Section All categories: Industry. Data from 1951 census.
a_agric_1951 Floating point number. SIC2007 Section A Agriculture, forestry and fishing. Data from 1951 census.
b_mining_1951 Floating point number. SIC2007 Section B Mining and quarrying. Data from 1951 census.
c_manuf_1951 Floating point number. SIC2007 Section C Manufacturing. Data from 1951 census.
d_power_1951 Floating point number. SIC2007 Section D Electricity, gas, steam and air conditioning supply. Data from 1951 census.
e_water_1951 Floating point number. SIC2007 Section E Water supply, sewerage, waste management and remediation activities. Data from 1951 census.
f_const_1951 Floating point number. SIC2007 Section F Construction. Data from 1951 census.
g_trade_1951 Floating point number. SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles. Data from 1951 census.
h_transp_1951 Floating point number. SIC2007 Section H Transport and storage. Data from 1951 census.
i_accom_1951 Floating point number. SIC2007 Section I Accommodation and food service activities. Data from 1951 census.
j_infocom_1951 Floating point number. SIC2007 Section J Information and communication. Data from 1951 census.
k_finance_1951 Floating point number. SIC2007 Section K Financial and insurance activities. Data from 1951 census.
l_estate_1951 Floating point number. SIC2007 Section L Real estate activities. Data from 1951 census.
m_prof_1951 Floating point number. SIC2007 Section M Professional, scientific and technical activities. Data from 1951 census.
n_admin_1951 Floating point number. SIC2007 Section N Administrative and support service activities. Data from 1951 census.
o_public_1951 Floating point number. SIC2007 Section O Public administration and defence; compulsory social security. Data from 1951 census.
p_educ_1951 Floating point number. SIC2007 Section P Education. Data from 1951 census.
q_health_1951 Floating point number. SIC2007 Section Q Human health and social work activities. Data from 1951 census.
rstu_other_1951 Floating point number. SIC2007 Sections 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) and U (Activities of extraterritorial organisations and bodies). Data from 1951 census.
sector_prim_manuf_1951 Floating point number. Primary and Manufacturing in 1951. Simplified sector defined by project, covering SIC Sections A (Agriculture), B (Mining) and C (Manufacturing).
sector_util_tran_const_1951 Floating point number. Utilities, Transport and Construction in 1951. Simplified sector defined by project, covering SIC Sections D (Electricity, gas, steam and air conditioning supply), E (Water supply, sewerage, waste management and remediation activities), F (Construction) and H (Transport and storage).
sector_consumer_serv_1951 Floating point number. Consumer Services in 1951. Simplified sector defined by project, covering SIC Sections G (Wholesale and retail trade; repair of motor vehicles and motor cycles), I (Accommodation and food service activities) and RSTU (Other services).
sector_finance_bus_1951 Floating point number. Finance and Business Services in 1951. Simplified sector defined by project, covering SIC Sections J (Information and communication), K (Financial and insurance activities), L (Real estate activities), M (Professional, scientific and technical activities) and N (Administrative and support service activities).
sector_public_hlth_edu_1951 Floating point number. Public Administration, Health and Education in 1951. Simplified sector defined by project, covering SIC Sections O (Public administration and defence; compulsory social security), P (Education) and Q (Human health and social work activities).
total_1971 Floating point number. SIC2007 Section All categories: Industry. Data from 1971 census.
a_agric_1971 Floating point number. SIC2007 Section A Agriculture, forestry and fishing. Data from 1971 census.
b_mining_1971 Floating point number. SIC2007 Section B Mining and quarrying. Data from 1971 census.
c_manuf_1971 Floating point number. SIC2007 Section C Manufacturing. Data from 1971 census.
d_power_1971 Floating point number. SIC2007 Section D Electricity, gas, steam and air conditioning supply. Data from 1971 census.
e_water_1971 Floating point number. SIC2007 Section E Water supply, sewerage, waste management and remediation activities. Data from 1971 census.
f_const_1971 Floating point number. SIC2007 Section F Construction. Data from 1971 census.
g_trade_1971 Floating point number. SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles. Data from 1971 census.
h_transp_1971 Floating point number. SIC2007 Section H Transport and storage. Data from 1971 census.
i_accom_1971 Floating point number. SIC2007 Section I Accommodation and food service activities. Data from 1971 census.
j_infocom_1971 Floating point number. SIC2007 Section J Information and communication. Data from 1971 census.
k_finance_1971 Floating point number. SIC2007 Section K Financial and insurance activities. Data from 1971 census.
l_estate_1971 Floating point number. SIC2007 Section L Real estate activities. Data from 1971 census.
m_prof_1971 Floating point number. SIC2007 Section M Professional, scientific and technical activities. Data from 1971 census.
n_admin_1971 Floating point number. SIC2007 Section N Administrative and support service activities. Data from 1971 census.
o_public_1971 Floating point number. SIC2007 Section O Public administration and defence; compulsory social security. Data from 1971 census.
p_educ_1971 Floating point number. SIC2007 Section P Education. Data from 1971 census.
q_health_1971 Floating point number. SIC2007 Section Q Human health and social work activities. Data from 1971 census.
rstu_other_1971 Floating point number. SIC2007 Sections 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) and U (Activities of extraterritorial organisations and bodies). Data from 1971 census.
sector_prim_manuf_1971 Floating point number. Primary and Manufacturing in 1971. Simplified sector defined by project, covering SIC Sections A (Agriculture), B (Mining) and C (Manufacturing).
sector_util_tran_const_1971 Floating point number. Utilities, Transport and Construction in 1971. Simplified sector defined by project, covering SIC Sections D (Electricity, gas, steam and air conditioning supply), E (Water supply, sewerage, waste management and remediation activities), F (Construction) and H (Transport and storage).
sector_consumer_serv_1971 Floating point number. Consumer Services in 1971. Simplified sector defined by project, covering SIC Sections G (Wholesale and retail trade; repair of motor vehicles and motor cycles), I (Accommodation and food service activities) and RSTU (Other services).
sector_finance_bus_1971 Floating point number. Finance and Business Services in 1971. Simplified sector defined by project, covering SIC Sections J (Information and communication), K (Financial and insurance activities), L (Real estate activities), M (Professional, scientific and technical activities) and N (Administrative and support service activities).
sector_public_hlth_edu_1971 Floating point number. Public Administration, Health and Education in 1971. Simplified sector defined by project, covering SIC Sections O (Public administration and defence; compulsory social security), P (Education) and Q (Human health and social work activities).
total_2011 Floating point number. SIC2007 Section All categories: Industry. Data from 2011 census.
a_agric_2011 Floating point number. SIC2007 Section A Agriculture, forestry and fishing. Data from 2011 census.
b_mining_2011 Floating point number. SIC2007 Section B Mining and quarrying. Data from 2011 census.
c_manuf_2011 Floating point number. SIC2007 Section C Manufacturing. Data from 2011 census.
d_power_2011 Floating point number. SIC2007 Section D Electricity, gas, steam and air conditioning supply. Data from 2011 census.
e_water_2011 Floating point number. SIC2007 Section E Water supply, sewerage, waste management and remediation activities. Data from 2011 census.
f_const_2011 Floating point number. SIC2007 Section F Construction. Data from 2011 census.
g_trade_2011 Floating point number. SIC2007 Section G Wholesale and retail trade; repair of motor vehicles and motor cycles. Data from 2011 census.
h_transp_2011 Floating point number. SIC2007 Section H Transport and storage. Data from 2011 census.
i_accom_2011 Floating point number. SIC2007 Section I Accommodation and food service activities. Data from 2011 census.
j_infocom_2011 Floating point number. SIC2007 Section J Information and communication. Data from 2011 census.
k_finance_2011 Floating point number. SIC2007 Section K Financial and insurance activities. Data from 2011 census.
l_estate_2011 Floating point number. SIC2007 Section L Real estate activities. Data from 2011 census.
m_prof_2011 Floating point number. SIC2007 Section M Professional, scientific and technical activities. Data from 2011 census.
n_admin_2011 Floating point number. SIC2007 Section N Administrative and support service activities. Data from 2011 census.
o_public_2011 Floating point number. SIC2007 Section O Public administration and defence; compulsory social security. Data from 2011 census.
p_educ_2011 Floating point number. SIC2007 Section P Education. Data from 2011 census.
q_health_2011 Floating point number. SIC2007 Section Q Human health and social work activities. Data from 2011 census.
rstu_other_2011 Floating point number. SIC2007 Sections 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) and U (Activities of extraterritorial organisations and bodies). Data from 2011 census.
sector_prim_manuf_2011 Floating point number. Primary and Manufacturing in 2011. Simplified sector defined by project, covering SIC Sections A (Agriculture), B (Mining) and C (Manufacturing).
sector_util_tran_const_2011 Floating point number. Utilities, Transport and Construction in 2011. Simplified sector defined by project, covering SIC Sections D (Electricity, gas, steam and air conditioning supply), E (Water supply, sewerage, waste management and remediation activities), F (Construction) and H (Transport and storage).
sector_consumer_serv_2011 Floating point number. Consumer Services in 2011. Simplified sector defined by project, covering SIC Sections G (Wholesale and retail trade; repair of motor vehicles and motor cycles), I (Accommodation and food service activities) and RSTU (Other services).
sector_finance_bus_2011 Floating point number. Finance and Business Services in 2011. Simplified sector defined by project, covering SIC Sections J (Information and communication), K (Financial and insurance activities), L (Real estate activities), M (Professional, scientific and technical activities) and N (Administrative and support service activities).
sector_public_hlth_edu_2011 Floating point number. Public Administration, Health and Education in 2011. Simplified sector defined by project, covering SIC Sections O (Public administration and defence; compulsory social security), P (Education) and Q (Human health and social work activities).
g_foot_gb geometry Boundary polgon, in OS National Grid copied across from GBHDB table gis_gb2011_lau
g_foot_etrs geometry Boundary polgon, transformed into etrs 89 projection in postgres copied across from GBHDB table gis_gb2011_lau.