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_polygons_pkey | Primary key | rec_num |
par_1831_ew_polygons_gunit_idx | Unique | par_unit, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
par_1831_ew_polygons_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | anc_cnty | Text string (max.len.=44). | Name of the ancient 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. | anc_dist | Text string (max.len.=84). | Standardised name of the ancient district. | anc_type | Text string (max.len.=34). | Standardised type of the ancient district. | anc_par | Text string (max.len.=104). | Standardised name of the ancient parish. | area | Floating point number. | Area of the 'place', in 'Statute Acres'. NB in some cases the acreages of smaller units were combined. | inh_1831 | int8 | Houses: Inhabited. | fam_tot | int8 | Houses: Families. | bih_1831 | int8 | Houses: Building. | unh_1831 | int8 | Houses: Uninhabited. | fam_ag | int8 | Occupations: Families chiefly employed in Agriculture. | fam_trade | int8 | Occupations: Families chiefly employed in Trade, Manufactures, and Handicraft. | fam_other | int8 | Occupations: All other Families not comprised in the two preceding Classes. | ma_1831 | int8 | Persons: Males. | fe_1831 | int8 | Persons: Females. | pop_1831 | int8 | Persons: Total of Persons. | em_tot | int8 | Persons: Males Twenty Years of Age. | em_ag_empl | int8 | Agriculture: Occupiers employing Labourers. | em_ag_noemp | int8 | Agriculture: Occupiers not employing Labourers. | em_ag_lab | int8 | Agriculture: Labourers employed in Agriculture. | em_manuf | int8 | Employed in Manufacture, or in making Manufacturing Machinery. | em_trade | int8 | Employed in Retail Trade, or in Handicrafts as Masters or Workmen. | em_prof | int8 | Capitalists, Bankers, Professional and other Educated Men. | em_lab | int8 | Labourers employed in Labour not Agricultural. | em_other | int8 | Other Males 20 Years of Age (except Servants). | em_serv | int8 | Male Servants: 20 Years of Age. | boy_serv | int8 | Male Servants: Under 20 Years. | fem_serv | int8 | 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. | cnty_unit | Integer number. | ID number for the Ancient County as defined in the GBH Administrative Unit Ontology. | dist_unit | Integer number. | ID number for the Ancient District covering this row of the data, as defined in the GBH Administrative Unit Ontology. | 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. | g_foot_gb | geometry | Polygon in OSGB co-ordinates. |
---|