Long-run industrial structure data, simplified but with additional classification of areas

Table ID:
IND_REDISTRICTED_ANAL     (1251121)
Contents:
Long-run industrial structure data, simplified but with additional classification of areas
Approx. number of rows:
3,528
Table type:
Derived
Documentation Author:
Humphrey Southall
Geography:
Reporting units are identified by:
   National Grid Easting
   National Grid Northing
Chronology:
The data cover the period 1841 to 2011.
Dates and times are identified by:
   Year

Sources:

  1. This table is created primarily from ind_redistricted, but also includes data from several other tables within GBHDB which are used to define classifications.


Notes:

  1. The industry data here have been simplified relative to the data in ind_redistricted by making them more closely match the limitations of the data published for 2011: there is no break-down by gender, and SIC2007 Sections R, S, T and U are always merged. However, the sub-division of Manufacturing into six categories is retained ever though these data are not available for Scotland in 2011.
  2. The SIC Sections are grouped into the same seven "Sectors" used in Vision of Britain; these are defined by us.
  3. Three classifications of areas are currently included, and in most cases this table also uses various intermediate variables used to assign areas to these classifications:
    • Distance Band (dist_band): How far the local authority is from London, measured by the centroid of its 2011 boundaries.
    • Area Type (area_type): Currently a four-way classification based partly on population density in 2011 and partly on how the local authority is classified by the Centre for Cities.
    • Voting in 2016 EU Referendum (brexit): Whether the area voted Leave or Remain.


Checking:

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


Indices:

IndexTypeColumn(s) indexed
ind_redistricted_anal_pk Primary key g_unit, year


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
ind_redistricted_anal_pk Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
row_type Text string (max.len.=16). 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.
area_code Text string (max.len.=18). Alpha-numeric ID for the District or Unitary Authority as defined by the census offices. Missing for regions and national totals.
area_name Text string (max.len.=52). Name of the District or Unitary Authority.
nation Text string (max.len.=8). Single-letter code identifying nation within the UK: 'E' = England, 'S' = Scotland, 'W' = Wales.
region Text string (max.len.=28). Name of the (government office) Region containing the District or Unitary Authority.
reg_unit Integer number. ID number of the (government office) Region containing the District or Unitary Authority as defined in the GBHGIS AUO.
g_unit Integer number. ID number of the District or Unitary Authority as defined in the GBHGIS AUO.
gr_east Floating point number. OSGB National Grid easting, measured in metres from grid origin, for the centroid of the District or Unitary Authority in our 2011 boundary polygons.
gr_north Floating point number. OSGB National Grid northing, measured in metres from grid origin, for the centroid of the District or Unitary Authority in our 2011 boundary polygons.
dist_london Floating point number. Distance from London (actually Trafalgar Square) to the District or Unitary Authority's centroid, measured in kilometers.
dist_band Text string (max.len.=14). Four distance bands based on dist_london: '0_99', '100_199', '200_299' and '300_up'.
area_h Integer number. Area of the local authority in hectares, taken from 'lau_2011_ew' and 'lau_2011_s'.
tot_pop_2011 Integer number. Population of the local authority in 2011 (Persons Usually Resident), taken from 'lau_2011_ew' and 'lau_2011_s'.
pop_dens_2011 Floating point number. Population density (persons per hectare) of the local authority in 2011.
cfc_city Text string (max.len.=20). Name of the city, or 'Primary Urban Area' as defined by the Centre for Cities. Null if the authority was not assigned to a city. These definitions are held within the AUO.
area_type Text string (max.len.=16). Area Type:
  • LONDON: authority is defined by the CfC as part of London, which includes some authorities which are outside the Greater London Authority.
  • OTHER CITY: authority is assigned by the CfC to another city.
  • INTERMEDIATE: authority is not assigned by the CfC and has a population density of two persons or more per hectare.
  • RURAL: authority is not assigned by the CfC and has a population density under two persons per hectare.
brexit Text string (max.len.=11). Based on data held in 'referendum_2016:
  • REMAIN if 50% or more of valid votes in the referendum were to remain in the EU.
  • LEAVE otherwise.
.
year Integer number. Date of the census.
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.
rstu_other Floating point number. Persons in SIC2007 Sections R (Arts, Entertainment and Recreation), S (Other Services), 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).
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.
agriculture Floating point number. Persons in Agriculture, i.e. Section A (so this is simply the same number again).
manuf_mining Floating point number. Manufacturing and Mining, i.e. Sections B and C.
serv_util Floating point number. Services and Utilities, but NB this includes ALL Sections except A, B and C.
consumer_serv Floating point number. Consumer Services: Sections G, I and R/S/T/U.
business_serv Floating point number. Business/Producer Services: Sections J, K, L, M and N.
public_serv Floating point number. Public Services: Sections O, P and Q.
tress_index Floating point number. Tress Index computed from the 18 SIC Sections, or aggregates of them, listed here.
tress_index_man Floating point number. Tress Index computed from 17 SIC Sections, or aggregates of them, listed here but excluding manufacturing, plus the six sub-divisions of manufacturing.
hh_index Floating point number. [No description available]