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 |
---|---|---|
occ_1881_ew_cnty_idx | Unique | reg_cnty, class, occ_order, sub_order, occupation, mw_code |
Column | Type | Contents | reg_cnty | Text string (max.len.=36). | The name of the Registration County to which the data relate. London is not included as a unit, but as three separate 'intra-metro.' parts of Kent, Middlesex and Surrey, with the remainders of those counties listed as 'extra-metro'. | reg_num | Integer number. | The number of the Registration County to which the data relate. This field was added during transcription at Essex. These numbers are NOT the county numbers assigned in the printed table). | mw_code | Integer number. | Occupation reference code. Added during transcription by Matthew Woollard at the University of Essex. The code is six numeric characters long and has been generated by taking the Order, sub-Order and Occupation two number codes and combining them. The original printed table does not include an occupational code number. This has been generated during transcription and is simply based on a two-number count of each occupation within each sub-Order. These codes are defined in the table 'occ_1881_occ_codes'. | class_num | Text string (max.len.=8). | Occupational class reference number. These appear as roman numerals in the paper table but have been converted to Arabic style during transcription. | class | Text string (max.len.=28). | Occupational Class name. These are the major occupational divisions. Each occupation falls into one of 6 (VI) groups. | order_num | Integer number. | Occupational Order reference number. These are recorded in the original report. | occ_order | Text string (max.len.=64). | Occupational Order name. | sub_order | Text string (max.len.=54). | Occupational sub_Order name. In the printed report the sub-Order also has a reference number. This has not been transcribed. | occupation | Text string (max.len.=124). | The specific occupation. | males | Integer number. | Total males in the specified occupation. | females | Integer number. | Total females in the specified occupation. | notes | Long text. | Notes added during post processing of the data from Essex or later. | regc_unit | Integer number. | ID for unit as defined in the GBH Administrative Unit Ontology. NB this is correctly set for the Isle of Man and the Channel Islands, as well as for the actual Registration Counties. The intra-metropolitan parts of Middlesex, Surrey and Kent are all treated as 'London'. | nat_unit | Integer number. | ID for containing nation, as defined in the GBH Administrative Unit Ontology. This is null for the Isle of Man and the Channel Islands. | occ_code | Integer number. | Sequence number identifying occupation, as defined and looked up from the occ_1881_occ_codes table. This forms the basis for the cell references used for these data in the main data table. |
---|