A vision of Britain through time
A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
A vision of Britain through time
A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
| Index | Type | Column(s) indexed |
|---|---|---|
| par_1851_pkey | Primary key | rec_num |
| par_1851_idx | Unique | sub_par, par_name, anc_dist, sub_dist, reg_dist, reg_cnty, sub_type, rec_num |
| par_1851_key_idx | par_key |
The table has the following associated constraints:
| Constraint | Type | Details |
|---|---|---|
| par_1851_pkey | Primary Key | See details above for primary key index |
| Column | Type | Contents | reg_num | Integer number. | Number of Registration District, as listed in original census report. | reg_sfx | Text string (max.len.=8). | Alpha suffix to number of Registration District, as listed in the original census report (only needed for Pontefract and Hemsworth). | sub_num | Integer number. | Number of Registration sub-District, as listed in the original census report. | par_num | Integer number. | Number of the individual unit within the sub-District, as listed in the original census report. NB the report titles this 'No. of Parish', but the numbering covers sub-parish units. | reg_cnty | Text string (max.len.=34). | Name of Registration County. | reg_dist | Text string (max.len.=44). | Name of Registration District | sub_dist | Text string (max.len.=64). | Name of Registration Sub-District | par_name | Text string (max.len.=164). | Name of Parish as it originally appeared in the published report. | anc_par | Text string (max.len.=124). | Name of Ancient Parish after being cleaning up. | sub_par | Text string (max.len.=164). | Name of the 'place', or subdivision of a parish, that the row of statistical data relates to. This is blank if the data relate to an entire parish. | sub_type | Text string (max.len.=34). | Type of sub-parish unit stated as a one or two letter code. | part_of | Text string (max.len.=8). | Set to 'P' if the unit is described as being 'part of' a parish in the original report. | anc_cnty | Text string (max.len.=54). | Name of the ancient county where different to the registration county. | inst | Text string (max.len.=14). | Codes indicating whether a workhouse or a workhouse school was present: '(W) or (W.S.) denotes that a Workhouse or Workhouse School belonging to the District is situated within the limits of the Parish; (w) or (w.s.) that one of these institutions not belonging to the District is situated therein'. | 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 | anc_dist | Text string (max.len.=104). | Name of Hundred or similar ancient district. | notes | Text string (max.len.=1004). | Notes. These are generally taken from the original report. NB these were very extensive. The current transcription is incomplete, and covers approximately the first two thirds of the counties in alphabetical order. | par_key | Text string (max.len.=14). | This is a text string consisting of the Registration District number, the sub-District number and the Parish number, each separated by a semi-colon. It has been constructed to match the IDs used by Roger Kain and Richard Oliver in their mapping of ancient parishes and other units. | nat_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. | regc_unit | Integer number. | ID number for the Registration County covering this row of the data, as defined in the GBH Administrative Unit Ontology. | regd_unit | Integer number. | ID number for the Registration District covering this row of the data, as defined in the GBH Administrative Unit Ontology. | subd_unit | Integer number. | ID number for the Registration sub-District covering this row of the data, as defined in the GBH Administrative Unit Ontology. | ancp_unit | Integer number. | ID number for the Ancient Parish covering this row of the data, as defined in the GBH Administrative Unit Ontology. | subp_unit | Integer number. | ID number for the sub-parish unit the row is for, if this could be matched in the GBH Administrative Unit Ontology. | ancc_unit | Integer number. | ID number of the Ancient County covering the row, as defined in the GBH Administrative Unit Ontology. | ancd_unit | Integer number. | ID number of the Ancient District, i.e. a Hundred, Wapentake, etc, covering the row, 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. |
|---|