Local Authority travel to work data for the UK in 2011

Table ID:

TRAV_2011_UK     (62736)

Contents:

Local Authority travel to work data for the UK in 2011

Approx. number of rows:

489,648

Table type:

Raw Data

Documentation Author:

Paula Aucott

Geography:

Reporting units are identified by:
   Local Government District Type

Chronology:

The data cover the period 1881 to 1911.

Sources:

1. These data were obtained from table "WU01UK - Location of usual residence and place of work by sex" for Local Authorities from the 2011 Census of Population. The data was downloaded on 12th November 2015 in spreadsheet format from the Census part of the Topics section on the Neighbourhood Statistics website operated by the Office for National Statistics. The data are under Crown Copyright, but are made available for use under an Open Government Licence.

---

Notes:

1. The data contained a caveat about accuracy due to data protection. This may affect results from the check sums: "In order to protect against disclosure of personal information from the 2011 Census, there has been swapping of records in the Census database between different geographic areas, and so some counts will be affected. In the main, the greatest effects will be at the lowest geographies, since the record swapping is targeted towards those households with unusual characteristics in small areas. More details on the ONS Census disclosure control strategy may be found at Census Results / Statistical Disclosure Control.
2. This dataset covers the whole of the UK including Northern Ireland.
3. The original data was downloaded as three separate data matrices (Males, Females and All Persons) with local authority of residence identified in rows and local authority where employed identified in columns, producing 404 columns by 404 rows of data for each dataset. This data was loaded into a temporary table and then converted into a simplified table with a single count per row and a distinct row for each relationship between the local authority of residence and the place of work, resulting in 489,648 rows of data (404 x 404 x 3) in the final table.
4. Northern Ireland Local Authorities have not yet been added to the AUO gazetteer. Therefore any data relating to them have no g_unit or g_rel_to_unit values.

---

Checking:

1. The statistical data have not been checked.
2. The geographical units have been cross-checked against the GBHGIS administrative unit gazetteer to ensure that all units are correctly identified. The unit names and types have been standardised. Each unit has a unique unit ID assigned to it and this can be used to cross-reference against other data-sets.

---

Indices:

Index	Type	Column(s) indexed
trav_2011_uk_pkey	Primary key	rec_num

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
trav_2011_uk_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
lau_code	Text string (max.len.=24).	ONS Code for the Local Authority as it appeared in the original table.
lau_name	Text string (max.len.=104).	Name of the Local Authority as it appeared in the original table.
lg_type	Text string (max.len.=16).	Type of unit.
g_unit	Integer number.	Unique ID number for local authority unit from the auo gazetteer.
g_name	Text string (max.len.=104).	Standardised name of local authority (preferred English name as given in the auo gazetteer).
g_rel_to_dist	Text string (max.len.=104).	Standardised name of local authority which a person travelled to for their work purposes.
g_rel_to_unit	Integer number.	Unique ID number for local authority unit from the auo gazetteer.
sex	Text string (max.len.=8).	Gender of all usual residents aged 16 and over in employment the week before the census: M = "Males", F = "Females" and T = "All people".
commuters	Integer number.	Count of the people living in the Local Authority named in the g_name column and working in the Local Authority named in the g_rel_to_dist column.
notes	Text string (max.len.=1004).	Comments relating to individual rows of data.
rec_num	Integer number.	Unique number identifying row in table.