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. Empty only for 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'.
Row type was set to 'Parish' for the following labels:
|
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_manuf | 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. | males_20_up | Integer number. | Males 20 Years of Age [i.e. the total for the following 8 columns]. | farmers_w_lab | Integer number. | [Adult Male Occupations:] Agriculture: Occupiers employing Labourers. | farmers_nolab | Integer number. | [Adult Male Occupations:] Agriculture: Occupiers not employing Labourers. | farm_lab | Integer number. | [Adult Male Occupations:] Agriculture: Labourers employed in Agriculture. | empl_manuf | Integer number. | [Adult Male Occupations:] Employed in Manufacture or in making Manufacturing Machinery. | empl_retail | Integer number. | [Adult Male Occupations:] Employed in Retail Trade or in Handicraft as Masters or Workmen. | capitalists | Integer number. | [Adult Male Occupations:] Capitalists, Bankers, Professional and other educated Men. | labourers | Integer number. | [Adult Male Occupations:] Labourers employed in Labour not Agricultural. | other_males | Integer number. | [Adult Male Occupations:] Other Males 20 Years of Age (except Servants). | serv_m_20up | Integer number. | [Adult Male Occupations:] Male Servants: 20 Years of Age. | serv_m_u20 | Integer number. | Male Servants: Under 20Years. | serv_fem | Integer number. | Female Servants. | notes | Text string (max.len.=1204). | Footnotes appearing in the original tables. NB these have been included for all counties currently covered. Unlike the Irish table's footnotes, these are mainly concerned with the reasons for population changes. They often provide interesting information about clearances, emigration and new industrial developments. | 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. |
---|