Census unemployment in 1931 plus explanatory variables

Table ID:

UNEM_1931     (28492)

Contents:

Census unemployment in 1931 plus explanatory variables

Approx. number of rows:

1,800

Table type:

Derived

Documentation Author:

Humphrey Southall

Geography:

Reporting units are identified by:
   Local Government District
   Local Government District Type
   National Grid Easting
   National Grid Northing

Chronology:

The data are for the single year 1931.

Sources:

1. The contents of this table is entirely derived from other parts of the database, notably including the 1931 occupational statistics. Some data are inserted from the main g_data table.

---

Notes:

1. Total area and total acreage for units in England and Wales come from the 1931 parish-level table. One unit, 'Nottingham Rural District', has no acreage, but this has a population of 4 and seems to have consisted solely of the County Hall.
2. For 1,789 out of 1,800 units in England and Wales, the centroid has been set specifically from the boundaries in force in 1931. For another 6 units, the centroid was set from a boundary polygon for the unit which did not cover 1931, and for another 4 from the boundary polygons for component parishes. That left just Nottingham Rural District (see above) without a centroid.

---

Indices:

Index	Type	Column(s) indexed
unem_1931_pkey	Primary key	g_unit

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
unem_1931_pkey	Primary Key	See details above for primary key index
enforce_dims_g_centroid	Check	(public.ndims(g_centroid) = 2)
enforce_geotype_g_centroid	Check	((public.geometrytype(g_centroid) = 'POINT'::text) OR (g_centroid IS NULL))
enforce_srid_g_centroid	Check	(public.srid(g_centroid) = 3034)

---

Columns within table:

Column	Type	Contents
g_unit	Integer number.	GBH AUO identifier for the district.
lg_dist	Text string (max.len.=44).	Name of the district.
lg_type	Text string (max.len.=12).	Status of the district: 'UD'=Urban District, etc.
gr_east	Floating point number.	Ordnance Survey National Grid easting.
gr_north	Floating point number.	Ordnance Survey National Grid easting.
area_a	Integer number.	Area in acres, as reported by the 1931 census.
tot_pop	Integer number.	Total population in 1931.
agriculture	Integer number.	Total number of workers in the 'Agriculture' sector, as defined by the Cambridge Group.
light	Integer number.	Total number of workers in the 'Light Industry' sector, as defined by the Cambridge Group.
staple	Integer number.	Total number of workers in the 'Staple Industry' sector, as defined by the Cambridge Group.
professional	Integer number.	Total number of workers in the 'Professional' sector, as defined by the Cambridge Group.
m_activ	Integer number.	Number of economically active males in 1931.
m_unem	Integer number.	Number of unemployed males, according to the 1931 census.
f_activ	Integer number.	Number of economically active females in 1931.
f_unem	Integer number.	Number of unemployed females, according to the 1931 census.
g_centroid	geometry	Unit centroid.