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:

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

Notes:

The data on numbers of retired persons are experimental, and
probably require revision; the 1951 data seem to give much higher rates.

The data here for 1991 include those on government training schemes with the unemployed.

Indices:

Index

Type

Column(s) indexed

work_redistricted_pkey

Primary key

g_unit, year

Constraints:

The table has the following associated constraints:

Constraint

Type

Details

work_redistricted_pkey

Primary Key

See details above for primary key index

Columns within table:

Column

Type

Contents

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.