A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
We are extremely grateful to the following:
Index | Type | Column(s) indexed |
---|---|---|
par_1831_ew_pkey | Primary key | rec_num |
par_1831_ew_idx | anc_cnty, anc_dist, anc_type, anc_par, sub_par, sub_type |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
par_1831_ew_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | nation | Text string (max.len.=7). | Name of the nation containing this row of the data; inferred from county name. | anc_cnty | Text string (max.len.=44). | Name of the county for which this row of data was listed. | anc_cdiv | Text string (max.len.=44). | Name of the division of ancient county. This is used only to identify the Yorkshire Ridings. | dist_name | Text string (max.len.=84). | Name of the ancient district, i.e. Hundred, Wapentake etc., as listed in the original report. This sometimes includes text identifying sub-divisions of Hundreds, etc. | dist_type | Text string (max.len.=34). | Type of the ancient district, as listed in the original report. | anc_dist | Text string (max.len.=84). | Name of the ancient district, with text identifying sub-divisions, etc, removed to permit matching to the GBH Administrative Unit Ontology. | anc_type | Text string (max.len.=34). | Type of the ancient district, modified to match the status identifiers used in the GBH Administrative Unit Ontology. | par_name | Text string (max.len.=104). | Name of the reporting unit, as listed in the original report. This may include, for example, the name of a sub-division within the parish. | par_type | Text string (max.len.=34). | Text string appearing to right of 'parish name' in the original report, indicating the type of unit. | anc_par | Text string (max.len.=104). | The part of the name of the reporting unit that identifies the actual parish. NB in most cases this is identical to par_name. | part_of_par | Text string (max.len.=6). | Flag: holds 'P' if the report indicates that the row covers only part of the population of the parish. | sub_par | Text string (max.len.=104). | Name of the sub-parish unit, such as a chapelry or township. | sub_type | Text string (max.len.=14). | Type identifier derived from par_type but matching the status identifiers used in the GBH AUO. The following types are currenly used: 'Ch'=Chapelry; 'ParLib'=Liberty; 'Tg'=Tything; 'Tn'=Township; All values of par_type that could not be matched to one of the above have a null value of row_type. | part_of_sub | Text string (max.len.=6). | Flag: holds 'P' if the report indicates that the row covers only part of the population of the sub-unit; for example, if a township was part of more than one parish and had multiple rows as a result. | area_a | Floating point number. | Area: English Statute Acres. | 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. | Persons: Males Twenty Years of Age. | farmers_w_lab | Integer number. | Agriculture: Occupiers employing Labourers. | farmers_nolab | Integer number. | Agriculture: Occupiers not employing Labourers. | farm_lab | Integer number. | Agriculture: Labourers employed in Agriculture. | empl_manuf | Integer number. | Employed in Manufacture, or in making Manufacturing Machinery. | empl_retail | Integer number. | Employed in Retail Trade, or in Handicrafts as Masters or Workmen. | capitalists | Integer number. | Capitalists, Bankers, Professional and other Educated Men. | labourers | Integer number. | Labourers employed in Labour not Agricultural. | other_males | Integer number. | Other Males 20 Years of Age (except Servants). | serv_m_20up | Integer number. | Male Servants: 20 Years of Age. | serv_m_u20 | Integer number. | Male Servants: Under 20 Years. | serv_fem | Integer number. | Female Servants. | notes | Long text. | Notes. Only 49 rows currently have notes, relating only to row status, and the majority of the notes in the original report have not been transcribed. | nat_unit | Integer number. | GBH Administrative Unit Ontology ID number for the nation containing the row of data, i.e. England or Wales. This was inserted based on the county listed in the data. | cnty_unit | Integer number. | GBH Administrative Unit Ontology ID number for the ancient county containing the row of data, as identified from the names in the data. | dist_unit | Integer number. | GBH Administrative Unit Ontology ID number for the ancient district (Hundred, Wapentake, Borough, etc) containing the row of data, as identified from the names in the data. | par_unit | Integer number. | GBH Administrative Unit Ontology ID number for the ancient parish containing the row of data, as identified from the names in the data. NB where separate listings are given for townships, chapelries, etc, this aims to identify the mother parish. | sub_unit | Integer number. | GBH Administrative Unit Ontology ID number for the ancient sub-parish unit containing the row of data, as identified from the names in the data. This column is not yet populated. | rec_num | Integer number. | Sequence number, added on loading to hold rows in original order. |
---|