Data on employment and unemployment from multipled years redistricted to 2011 geography

Table ID:
WORK_REDISTRICTED     (6567683)
Contents:
Data on employment and unemployment from multipled years redistricted to 2011 geography
Approx. number of rows:
3,432
Table type:
Derived
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1931 to 2011.
Dates and times are identified by:
   Year

Sources:

  1. This table is constructed entirely from other tables in this database.


Notes:

  1. The data on numbers of retired persons are experimental, and probably require revision; the 1951 data seem to give much higher rates.
  2. The data here for 1991 include those on government training schemes with the unemployed.


Indices:

IndexTypeColumn(s) indexed
work_redistricted_pkey Primary key g_unit, year


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
work_redistricted_pkey 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.
nation Text string (max.len.=10). Nation identifier. Current only 'S' = Scotland appears, rows for England and Wales being null.
area_code Text string (max.len.=22). ONS code for the District or Unitary Authority.
area_name Text string (max.len.=44). Name of the reporting area.
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.=13). ONS code for local authority districts in the 1991 census, enabling data to be directly inserted for 1991 areas which have not subsequently changed.
year Integer number. Date of the census.
m_working_age Floating point number. Number of males of working age. NB the cut-off age varies: 14 and over in 1931, 15 and over in 1951, and 16 and over for all later censuses.
m_econ_active Floating point number. Number of economically active males.
m_self_empl Floating point number. Number of self-employed males.
m_unemployed Floating point number. Number of unemployed males.
m_retired Floating point number. Number of retired males.
f_working_age Floating point number. Number of females of working age. NB the cut-off age varies: 14 and over in 1931, 15 and over in 1951, and 16 and over for all later censuses.
f_econ_active Floating point number. Number of economically active females.
f_self_empl Floating point number. Number of self-employed females.
f_unemployed Floating point number. Number of unemployed females.
f_retired Floating point number. Number of retired females.
g_authority Text string (max.len.=28). Source identifier. Currently set to 'CEN' for all rows.
g_auth_note Text string (max.len.=408). Details of source. Currently null for all rows.
g_data_precision Text string (max.len.=16). Precision code. Currently set to 'GBR', meaning data redistricted by the GBH GIS, for all rows except for (a) 2011 and (b) for 1991 for those districts whose boundaries did not change between then and 2011; for these rows, it is set to 'E' for Exact counts.
g_data_status Text string (max.len.=13). Flag identifying data status. Set to 'P' for public for all rows.
g_credit Text string (max.len.=32). Credit identifier, used to acknowledge outside assistance. Currently null for all rows.
rec_num Integer number. Sequence numbers keeping rows in order loaded.