A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
Column | Type | Contents | row_type | Text string (max.len.=20). |
Type of row, derived from area_label:;
|
county | Text string (max.len.=84). | Name of the county, or 'Scotland' for the national totals. | district | Text string (max.len.=84). | Name of the district. These appear only within some larger counties. NB these are ancient units whcih do not appear in the AUO. | parish | Text string (max.len.=84). | Name of the parish. For rows which have been matched to the AUO at parish-level, it holds a copy of the name which achieved the match, which may be the value of area_name or sub_area from the same row, or a value of area_name from a previous row. It will be empty for counties and districts, and for any rows not yet matched. | area_name | Text string (max.len.=84). | Whatever text appears unindented in the column titled 'Parish, Burgh or Town'. | sub_area | Text string (max.len.=84). | Whatever text appears indented in the column titled 'Parish, Burgh or Town'. This will hold an entry only if area_name is empty, and viee-versa. | part_of | Text string (max.len.=12). | Where the original text in area_name ended with "(part of)", that was removed to enable matching to the AUO, and this separate column holds 'P'. The notes column may provide more details. | area_label | Text string (max.len.=44). | Label appearing in the right hand side of the column titled 'Parish, Burgh or Town'. | house_inh | Integer number. | Houses: Inhabited. | fam_total | Integer number. | Houses: Families. | house_bldg | Integer number. | Houses: Building. | house_uninh | Integer number. | Houses: Uninhabited. | fam_agric | Integer number. | Occupations: Families chiefly employed in Agriculture. | fam_trade | Integer number. | Occupations: Families chiefly employed in Trade, Manufactures, and Handicraft. | fam_other | Integer number. | Occupations: All other Families not comprised in the Two preceding Classes. | tot_male | Integer number. | Persons: Males. | tot_fem | Integer number. | Persons: Females. | tot_pop | Integer number. | Persons: Total of Persons. | county_unit | Integer number. | ID number for the county, as defined in the AUO. | parish_unit | Integer number. | ID number for the parish, as defined in the AUO. | map_unit | Integer number. | ID number for a parish that exists in the "Pre-1890" GIS (see note above). | burgh_unit | Integer number. | Where relevant, the ID number for a burgh, as defined in the AUO. These were set only where the row fairly clearly covered only the burgh and did not also cover a Landward area. | rec_num | Integer number. | Sequence number to keep rows in their original order, added on loading the data into GBHDB. |
---|