A vision of Ireland from 1821 onwards.
Including maps, statistical trends and historical descriptions.
Index | Type | Column(s) indexed |
---|---|---|
par_1801_gb_pkey | Primary key | rec_num |
par_1801_gb_idx | Unique | nation, row_type, anc_cnty, anc_dist, anc_type, sup_dist, sup_type, anc_par, par_name, par_type, part_of |
par_1801_gb_idx2 | Unique | anc_par, par_type, part_of, anc_dist, anc_type, sup_dist, sup_type, anc_cnty |
par_1801_gb_idx3 | Unique | anc_par, par_type, anc_cnty, pop_1801 |
par_1801_gb_idx_dist | Unique | cnty_unit, anc_dist, anc_type, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
par_1801_gb_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | row_type | Text string (max.len.=7). | Type of row: G = Great Britain total, N = Nation, C = County, DoC = Division of County (Riding, Lathe, etc), Div = Division (e.g. for Hampshire), D = District, P = Parish | nation | Text string (max.len.=6). | Nation: E = England, W = Wales, S = Scotland | anc_cnty | Text string (max.len.=29). | Name of ancient county, as originally listed in the report (these are often abbreviated, e.g. 'BERKS'). | anc_dist | Text string (max.len.=104). | Name of hundred or similar unit. In most cases this will be identical to the value in dist_unit, but in some counties two levels of district appear. In some rare cases, such as the Isle of Ely within Cambridgeshire, the names of hundreds do not appear at all and have had to be inserted by looking up parish names in pargaz. The aim, however, is that this column will always identify a Hundred, Borough etc as defined by Youngs. However, the name used will be that appearing in the census report, not that used by Youngs, unless no hundred name at all appears in the census. | anc_type | Text string (max.len.=34). | Type of the unit named in anc_dist, usually as listed in the table. If anc_dist is simply a copy of dist_unit, this column will usually simply hold a copy of dist_type. However, units listed as 'Towns' have their type re-set here to 'Borough'. | sup_dist | Text string (max.len.=104). | This will generally be the name of a Hundred or other Ancient District, but there are many exceptions. More specifically this column, possible in combination with the value in anc_dist, identifies the unit for which the original census table includes a sub-total. This is sometimes a higher-level unit than our Ancient Districts, as in Hampshire where it lists 'Divisions', and sometimes lower, as in Middlesex where this column is used to identify the sub-divisions of Ossulstone Hundred. | sup_type | Text string (max.len.=34). | The type of the unit named in sup_dist. NB many units which were actually Boroughs are listed here as 'Town'. | anc_par | Text string (max.len.=84). | By default, this column holds a copy of whatever is held in par_name, but we have manually added truncated versions or different names altogether where the unit named in par_name is only part of a parish. NB this is not used to handle variant forms of parish names, where as usual our method is to add the variant name to the core gazetteer. | par_name | Text string (max.len.=84). | Name of parish-level unit. | part_of | Text string (max.len.=28). | Contains any text indicating that the row covers only part of the unit named in 'par_name'. | par_type | Text string (max.len.=28). | Type of parish-level unit, transcribed as it appears in the original table rather than using a code. | house_in | Integer number. | Number of inhabited houses | house_fam | Integer number. | By how many families occupied. | house_un | Integer number. | Number of uninhabited houses. | ma_1801 | Integer number. | Total males. | fe_1801 | Integer number. | Total females. | oc_agric | Integer number. | Number of persons chiefly employed in agriculture. | oc_trade | Integer number. | Number of persons chiefly employed in trade, manufacturers or handicraft. | oc_other | Integer number. | Number of persons not comprised in the other two occupational groups. | pop_1801 | Integer number. | Total population. | derived_flag | Text string (max.len.=6). | Includes 'D' for rows which either do not appear in the original report at all or whose values are different from the original. The notes column will contain an explanation. | notes | Text string (max.len.=2004). | The original table includes only a small number of footnotes, which we try to include here. [Additional comments are included to indicate the alterations we have made to make the table not only loadable but linkable to the core gazetteer.] | nat_unit | Integer number. | Unique ID number for container unit, a country; England, Wales, Scotland or Great Britain. | cnty_unit | Integer number. | Unique ID number for container unit, a county. | anc_dist_unit | Integer number. | Unique ID number for container unit, an ancient district (mainly null in Scotland). | sup_dist_unit | Integer number. | Unique ID number for container unit, a supplementary ancient district (mainly null in Scotland). | g_unit | Integer number. | Unique ID number for unit | rec_num | Integer number. | Unique number identifying row in table. |
---|
These data were gathered by asking the following questions, usually of parish priests: