1881 occupational statistics for the counties of England and Wales.

Table ID:
OCC_1881_C     (1251826)
Contents:
1881 occupational statistics for the counties of England and Wales.
Approx. number of rows:
23,999
Table type:
Undocumented table

Indices:

IndexTypeColumn(s) indexed
occ_1881_c_idx Unique reg_cnty, class, occ_order, sub_order, occupation


Columns within table:

ColumnTypeContents
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.=84). 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.