A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
Column | Type | Contents | row_type | Text string (max.len.=24). |
Type of row:
|
province | Text string (max.len.=16). | Name of the province containing the county. | county | Text string (max.len.=36). | Name of the county. This always contains a value as all data comes from the county reports. | barony | Text string (max.len.=44). | Name of the barony. This will be empty for counties. | parish | Text string (max.len.=84). | Name of the parish. This will be empty for counties and baronies. For fisheries, railways etc it will include the name of the fishery, company, etc, if this is given in the footnote. | part_of | Text string (max.len.=6). | Contains 'P' if part of the parish was separately listed under a different barony, and otherwise empty. The notes column usually provides more details. | bracketed_letter | Text string (max.len.=10). | Letters that appear in brackets immediately after the parish name, providing a link to footnotes. In general, any such notes have been copied into the 'notes' column. | area_a | Integer number. | Acres part of total area. | area_r | Integer number. | Roods part of total area. | area_p | Integer number. | Perches part of total area. | area_decimal | Floating point number. | Area in acres, including the area given by roods and perches as a decimal fraction of acres. This derived value was computed based on 4 roods per acre, and 40 perhes per rood. | male_1841 | Integer number. | Population in 1841: Males. | fem_1841 | Integer number. | Population in 1841: Females. | pop_1841 | Integer number. | Population in 1841: Total. | male_1851 | Integer number. | Population in 1851: Males. | fem_1851 | Integer number. | Population in 1851: Females. | pop_1851 | Integer number. | Population in 1851: Total. | inh_1841 | Integer number. | Number of Houses in 1841: Inhabited. | unin_1841 | Integer number. | Number of Houses in 1841: Uninhabited. | build_1841 | Integer number. | Number of Houses in 1841: Building. | hous_1841 | Integer number. | Number of Houses in 1841: Total. | inh_1851 | Integer number. | Number of Houses in 1851: Inhabited. | unin_1851 | Integer number. | Number of Houses in 1851: Uninhabited. | build_1851 | Integer number. | Number of Houses in 1851: Building. | hous_1851 | Integer number. | Number of Houses in 1851: Total. | val_pnd | Integer number. | Poor Law Valuation in 1851: £ [Pounds] | val_shil | Integer number. | Poor Law Valuation in 1851: s. [Shillings] | val_pence | Floating point number. | Poor Law Valuation in 1851: d. [Pence]. This is defined as a floating point values as this column sometimes includes halfpennies. | val_pence_tot | Floating point number. | Total Poor Law Valuation in 1851 converted into pence, based on 20 shillings per pound and 12 pence per shilling. | notes | Text string (max.len.=804). | Footnotes appearing in the original tables. | province_unit | Integer number. | ID number for the province containing the county, as defined in the AUO. | county_unit | Integer number. | ID number for the county, as defined in the AUO. | barony_unit | Integer number. | ID number for the barony, as defined in the AUO. | parish_unit | Integer number. | ID number for the parish, as defined in the AUO. | rec_num | Integer number. | Sequence number to keep rows in their original order, added on loading the data into GBHDB. |
---|