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

Table ID:

WORK_REDISTRICTED     (1253573)

Contents:

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

Approx. number of rows:

3,440

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:

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
work_redistricted_area_type_check	Check	((((area_type)::text = 'COUNTRY'::text) OR ((area_type)::text = 'DISTRICT'::text) OR ((area_type)::text = 'GOR'::text) OR ((area_type)::text = 'MOD_REG'::text) OR ((area_type)::text = 'MOD_CNTY'::text) OR ((area_type)::text = 'NATION'::text)))
work_redistricted_nat_source_check	Check	((((nat_source)::text = 'Reported_total'::text) OR ((nat_source)::text = 'Sum_of_redist'::text) OR ((nat_source)::text = 'Sum_of_raw_EnumD'::text) OR ((nat_source)::text = 'Sum_of_raw_Par'::text) OR ((nat_source)::text = 'Sum_of_raw_Ward'::text) OR ((nat_source)::text = 'Sum_of_EW_and_Scot'::text)))

---

Columns within table:

Column	Type	Contents
area_type	Text string (max.len.=16).	[No description available]
area_code	Text string (max.len.=18).	ONS code for the District or Unitary Authority.
nation	Text string (max.len.=6).	Nation identifier. Current only 'S' = Scotland appears, rows for England and Wales being null.
nat_source	Text string (max.len.=28).	[No description available]
area_name	Text string (max.len.=40).	Name of the reporting area.
g_unit	Integer number.	ID number of the District or Unitary Authority as defined in the GBHGIS AUO.
year	Integer number.	Date of the census.
geogcode_1991	Text string (max.len.=9).	ONS code for local authority districts in the 1991 census, enabling data to be directly inserted for 1991 areas which have not subsequently changed.
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.