A vision of Britain through time

A vision of Britain from 1801 to now.

Including maps, statistical trends and historical descriptions.

- Table ID:
- PAR_1851_EW_POLY1831_GLA (6566708)
- Contents:
- Parish level statistics and polygons for England and Wales taken from the 1851 census for the London area.
- Approx. number of rows:
- 1,314
- Table type:
- Raw Data
- Documentation Author:
- Paula Aucott
- Chronology:
- The data cover the period 1881 to 1911.

- This is a full transcription of
'Parishes - Area; houses, 1841, 1851; Inhabitants, 1801, 1811,
1821, 1831, 1841, 1851' taken from
*Census of Great Britain, 1851. Population tables. I. Numbers of the Inhabitants, in the years 1801, 1811, 1821, 1831, 1841, and 1851. Vol. II*. - It should be noted that, in its published form, a table is published for each of the census divisions of England and Wales. These tables have been combined here.
- The printed table includes extensive notes (see below).

- The statistical data were input by the Centre for Data Digitisation and Analysis at the Queen's University of Belfast.
- The notes given in the table are extensive and are still being entered and corrected. Initially the notes were keyed at QMW. This process is now being continued at the University of Portsmouth. Notes are currently still missing for Yorkshire, the Northern Counties and Wales.
- Until 2008, this version of the 1851 census table was held as 'par_1851_ew_poly1831_gla_clean', as the original par_1851_ew_poly1831_gla table was retained for compatibility with the old GBHGIS.
- This version of the 1851 census table is considered temporary. It includes only the registration counties closest to London as part of a consultancy covering the GLA area. It also includes polygon columns, which contain polygons relating to 1831 anicent parishes. The script creating this table does ad-hoc temporary changes to enable the two datasets to match within this table. It does not change any of the data permanently.

- All statistical data were checked by summing fields by county and comparing the result with county printed county summary data.

Index | Type | Column(s) indexed |
---|---|---|

par_1851_ew_poly1831_gla_pkey | Primary key | rec_num |

par_1851_ew_poly1831_gla_gunit_idx | Unique | anc_par_unit, rec_num |

The table has the following associated constraints:

Constraint | Type | Details |
---|---|---|

par_1851_ew_poly1831_gla_pkey | Primary Key | See details above for primary key index |

enforce_dims_g_foot_etrs | Check | (st_ndims(g_foot_etrs) = 2) |

enforce_dims_g_foot_gb | Check | (st_ndims(g_foot_gb) = 2) |

enforce_geotype_g_foot_etrs | Check | ((geometrytype(g_foot_etrs) = 'MULTIPOLYGON'::text) OR (g_foot_etrs IS NULL)) |

enforce_geotype_g_foot_gb | Check | ((geometrytype(g_foot_gb) = 'MULTIPOLYGON'::text) OR (g_foot_gb IS NULL)) |

enforce_srid_g_foot_etrs | Check | (st_srid(g_foot_etrs) = 3034) |

enforce_srid_g_foot_gb | Check | (st_srid(g_foot_gb) = 27700) |

Column | Type | Contents |
---|---|---|

area | Integer number. | Area of the 'place', in 'Statute Acres'. NB in some cases the acreages of smaller units were combined. |

inh_1841 | Integer number. | Number of inhabited houses in 1841. |

unh_1841 | Integer number. | Number of uninhabited houses in 1841. |

bih_1841 | Integer number. | Number of houses under construction in 1841 |

inh_1851 | Integer number. | Number of inhabited houses in 1851. |

unh_1851 | Integer number. | Number of uninhabited houses in 1851. |

bih_1851 | Integer number. | Number of houses under construction in 1851 |

pop_1801 | Integer number. | Total population in 1801 |

pop_1811 | Integer number. | Total population in 1811 |

pop_1821 | Integer number. | Total population in 1821 |

pop_1831 | Integer number. | Total population in 1831 |

pop_1841 | Integer number. | Total population in 1841 |

pop_1851 | Integer number. | Total population in 1851 |

ma_1801 | Integer number. | Total males in 1801 |

ma_1811 | Integer number. | Total males in 1811 |

ma_1821 | Integer number. | Total males in 1821 |

ma_1831 | Integer number. | Total males in 1831 |

ma_1841 | Integer number. | Total males in 1841 |

ma_1851 | Integer number. | Total males in 1851 |

fe_1801 | Integer number. | Total females in 1801 |

fe_1811 | Integer number. | Total females in 1811 |

fe_1821 | Integer number. | Total females in 1821 |

fe_1831 | Integer number. | Total females in 1831 |

fe_1841 | Integer number. | Total females in 1841 |

fe_1851 | Integer number. | Total females in 1851 |

nation_unit | Integer number. | ID number for the Nation (i.e. England or Wales) covering this row of the data, as defined in the GBH Administrative Unit Ontology. Derived from Registration County. |

anc_par_unit | Integer number. | ID number for the Ancient Parish covering this row of the data, as defined in the GBH Administrative Unit Ontology. |

rec_num | Integer number. | Sequence number to keep rows in their original order, added on loading the data into GBHDB. |

g_foot_gb | geometry | Polygon co-ordinates in OS National Grid. |

g_foot_etrs | geometry | Polygon co-ordinates in ETRS-89. |