A vision of Ireland from 1821 onwards.
Including maps, statistical trends and historical descriptions.
We are extremely grateful to the following:
Index | Type | Column(s) indexed |
---|---|---|
par_1831_ew_poly1831_gla_pkey | Primary key | rec_num |
par_1831_ew_poly1831_gla_gunit_idx | Unique | anc_par_unit, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
par_1831_ew_poly1831_gla_pkey | Primary Key | See details above for primary key index |
enforce_dims_g_foot_etrs | Check | ((st_ndims(g_foot_etrs) = 2)) |
enforce_dims_g_foot_gb | Check | ((st_ndims(g_foot_gb) = 2)) |
enforce_geotype_g_foot_etrs | Check | (((geometrytype(g_foot_etrs) = 'MULTIPOLYGON'::text) OR (g_foot_etrs IS NULL))) |
enforce_geotype_g_foot_gb | Check | (((geometrytype(g_foot_gb) = 'MULTIPOLYGON'::text) OR (g_foot_gb IS NULL))) |
enforce_srid_g_foot_etrs | Check | ((st_srid(g_foot_etrs) = 3034)) |
enforce_srid_g_foot_gb | Check | ((st_srid(g_foot_gb) = 27700)) |
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_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 co-ordinates in OS National Grid. | g_foot_etrs | geometry | Polygon co-ordinates in ETRS-89. |
---|