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 |
---|---|---|
crop_1801_pkey | Primary key | rec_num |
crop_1801_idx | Unique | anc_cnty, anc_par, par_flag |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
crop_1801_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | anc_cnty | Text string (max.len.=30). | The name of the 1801 county, as assigned by Professor Turner. | anc_par | Text string (max.len.=84). | The name of the place, usually a parish. | par_flag | Integer number. | In a small number of cases, as listed above, this column holds a number between 1 and 5 to permit a unique index to be constructed despite a few parish names not being unique within their counties. | wheat | Floating point number. | The number of acres of land used to grow wheat. | barley | Floating point number. | The number of acres of land used to grow barley. | oats | Floating point number. | The number of acres of land used to grow oats. | b_and_o | Floating point number. | The number of acres of land used to grow barley and oats. | potatoes | Floating point number. | The number of acres of land used to grow potatoes. | peas | Floating point number. | The number of acres of land used to grow peas. | beans | Floating point number. | The number of acres of land used to grow beans. | p_and_b | Floating point number. | The number of acres of land used to grow peas and beans. | turnips | Floating point number. | The number of acres of land used to grow turnips. | rape | Floating point number. | The number of acres of land used to grow rape. | t_or_r | Floating point number. | The number of acres of land used to grow turnips or rape. Although the column is headed as an alternative, unless they are specifically separated it cannot be assumed such entries refer to the dominant crop which would have been turnips, but it can be reasonably assumed they are in combination. | rye | Floating point number. | The number of acres of land used to grow rye. | oth_crop | Text string (max.len.=44). | Any other type of crop grown. | other | Floating point number. | The number of acres of land used to grow that other crop. | oth_crop_2 | Text string (max.len.=64). | Any additional other crops that were grown. | other_2 | Floating point number. | The number of acres of additional other crops that were grown. | notes | Long text. | Notes. | rec_num | Integer number. | Sequence number to keep rows in order, added on loading. | anc_cnty_unit | Integer number. | ID number of the county containing the parish, as defined in the AUO. NB this has been set for all rows except where the county is listed as 'UNKNOWN', while many parishes have yet to be matched. | anc_cdiv_unit | Integer number. | ID number of the division of Ancient County containing the parish, as defined in the AUO. This is set for the Ridings of Yorkshire and the Parts of Lincolnshire. | anc_par_unit | Integer number. | ID number of the parish itself, as defined in the AUO. |
---|