GB Historical DB

Travel to work Statistics from the 1951 Census.

Table ID:
TRAV_1951_EW     (1253260)
Contents:
Travel to work Statistics from the 1951 Census.
Approx. number of rows:
12,149
Table type:
Raw Data
Documentation Author:
Paula Aucott
Geography:
Reporting units are identified by:
   Local Government District Type
   Unspecified Place
Chronology:
The data are for the single year 1951.

Sources:

  1. This table was transcribed from table 5 in the county reports of the 1951 census, 'Persons Resident in one area and working in another area'.

Notes:

  1. This transcription is partial because it only covers certain counties. However, those counties do contain all information given in the oriignal table. Where counties are complete they include all the Local Government districts within that particular county. These were all input by Harold Price at Portsmouth.
    • Completed counties currently include:
    • Bedfordshire, Berkshire, Buckinghamshire, Cambridgeshire and Isle of Ely, Essex, Hampshire, Hertfordshire, Kent, Surrey, Sussex and Suffolk all added in autumn 2015
    • Lincolnshire, London, Middlesex, Northumberland, Northamptonshire, Soke of Peterborough and Nottinghamshire all added in Spring 2018.
    • Partially completed counties currently include:
    • Leicestershire and Oxfordshire which were added in Spring 2018
  2. This data relates to England and Wales only.
  3. The original table in the report comprised three columns, one for the location information and one for each gender. The location information column identifies the county and then lists all the local government districts within that county. For each local government district it lists firstly the relationships between places where people are resident in the local government district and working in a different district/county, and secondly people working in that local government district and living in a different district/county. To clarify the table and make it easier to manipulate the county name has been added as an additional first column and the local government district being reported on as an additional second column. Further columns have been added to separate out the county and place with which there is a relationship.
  4. A third additional column identifies whether the statistics relate to either
    • residents who worked outside the district as RESIDENT
      • or
    • people who worked within the district, but were resident elsewhere as WORKING
  5. The matching to the auo is incomplete. These non-matches include:
    • Rows where the rel to unit being matched is within a different county to the county given in the row
    • Rows where the rel to unit relates to a total
    • Rows where the rel to unit is a county but not an admin county which is identified by its preferred name, either because it was subdivided for instance East and West Sussex recorded simply as Sussex, or the preferred name is different e.g. Durham rather than County Durham

Checking:

  1. 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.
  2. No checking of the numbers given for each pair of units between resident LGD and working LGD and vice versa has yet been attempted to check the accuracy of data input.

Indices:

IndexTypeColumn(s) indexed
trav_1951_ew_pkey Primary key rec_num
trav_1951_ew_g_unit_idx Unique g_unit, rec_num
trav_1951_ew_idx   cnty_name, dist_name, lg_type, rec_num

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
trav_1951_ew_pkey Primary Key See details above for primary key index


Columns within table:

ColumnTypeContents
serial_no Integer number. [No description available]
cnty_name Text string (max.len.=44). Name of Administrative County unit as it appeared in the original report.
dist_name Text string (max.len.=104). Name of Local Government District unit as it appeared in the original report.
place Text string (max.len.=104). Name of Local Government District unit as it appeared in the original report.
lgd_relationship Text string (max.len.=44). Whether resident within district and commuting out of it for work or resident elsewhere and commuting into district for work.
cnty_name_clean Text string (max.len.=104). [No description available]
dist_name_clean Text string (max.len.=104). [No description available]
lg_type Text string (max.len.=16). Type of Local Government District.
rel_to_name_clean Text string (max.len.=104). [No description available]
rel_to_type Text string (max.len.=24). Type of Local Government District.
adm_cnty_unit Integer number. Unique ID number for county unit.
g_unit Integer number. Unique ID number for local government district unit.
rel_to_unit Integer number. Unique ID number for local government district unit.
males Integer number. Total number of males.
females Integer number. Total number of females.
dup_dist_flag Integer number. [No description available]
dup_reldist_flag Integer number. [No description available]
rec_num Integer number. Unique number identifying row in table.