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.
|