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_gla_pkey | Primary key | rec_num |
par_1831_ew_gla_gunit_idx | Unique | anc_par_unit, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
par_1831_ew_gla_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | area | Floating point number. | Area of the 'place', in 'Statute Acres'. NB in some cases the acreages of smaller units were combined. | fam_tot | Integer number. | Houses: Families. | inh_1831 | Integer number. | Houses: Inhabited. | bih_1831 | Integer number. | Houses: Building. | unh_1831 | Integer number. | Houses: Uninhabited. | fam_ag | 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. | ma_1831 | Integer number. | Persons: Males. | fe_1831 | Integer number. | Persons: Females. | pop_1831 | Integer number. | Persons: Total of Persons. | em_tot | Integer number. | Persons: Males Twenty Years of Age. | em_ag_empl | Integer number. | Agriculture: Occupiers employing Labourers. | em_ag_noemp | Integer number. | Agriculture: Occupiers not employing Labourers. | em_ag_lab | Integer number. | Agriculture: Labourers employed in Agriculture. | em_manuf | Integer number. | Employed in Manufacture, or in making Manufacturing Machinery. | em_trade | Integer number. | Employed in Retail Trade, or in Handicrafts as Masters or Workmen. | em_prof | Integer number. | Capitalists, Bankers, Professional and other Educated Men. | em_lab | Integer number. | Labourers employed in Labour not Agricultural. | em_other | Integer number. | Other Males 20 Years of Age (except Servants). | em_serv | Integer number. | Male Servants: 20 Years of Age. | boy_serv | Integer number. | Male Servants: Under 20 Years. | fem_serv | Integer number. | Female Servants. | nation_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 Ancient County. | anc_cnty_unit | Integer number. | ID number for the Ancient County as defined in the GBH Administrative Unit Ontology. | anc_dist_unit | Integer number. | ID number for the Ancient District covering this row of the data, as defined in the GBH Administrative Unit Ontology. | anc_par_unit | Integer number. | ID number for the Ancient Parish covering this row of the data, 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. |
---|