Codebook mapping categories used in the 1911 Occupation Tables to other classifications.

Table ID:

OCC_1911_CODEBOOK     (1251901)

Contents:

Codebook mapping categories used in the 1911 Occupation Tables to other classifications.

Approx. number of rows:

403

Table type:

Codebook

Documentation Author:

Humphrey Southall

Notes:

1. This table is derived from occ_1911_lg_t, with SIC (2007) codes added by Humphrey Southall.

---

Indices:

Index	Type	Column(s) indexed
occ_1911_codebook_pkey	Primary key	row_number
occ_1911_codebook_idx_occup	Unique	order_number, suborder_number, occupation
occ_1911_codebook_idx_sic	Unique	sic_division, row_number

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
occ_1911_codebook_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
row_number	Integer number.	Sequence number and primary key. NB the occ_1911_lg_t table uses these as identifiers.
order_number	Integer number.	Number of the Order, from 1 to 23.
order_name	Text string (max.len.=84).	Name of the Order.
suborder_number	Integer number.	Number of the sub-Order containing the category. NB not all Orders contain sub-Orders.
occup_level	Integer number.	Number between 0 and 5: Used only for the overall "TOTAL OCCUPIED AND UNOCCUPIED" row. Used for "Retired or Unoccupied (Order XXIII.)" and "Engaged in Occupations (Orders I.-XXII.)" at the start of the table, and for the totals for each Order. However, note that all of the latter have been deleted except for "VIII. FISHING." as no actual data were given for them. Used for the numbered sub-Orders. Used for other non-numbered categories which were always reported, and which contribute to the overall total occupied. Used for more detailed categories which are printed in italics and appear only for some areas. These do not contribute to the overall total occupied, so need to be excluded in simple calculations using these data.
occupation	Text string (max.len.=94).	Occupation, as listed in the original report.
small_cat_m	Text string (max.len.=20).	Corresponding category in the table for males in smaller towns, held here as occ_1911_sm_m. The values held in this column generally match the column names used in that table, but some categories have to be merged because of differences in how the classifications are used in the two tables. The more detailed breakdowns provided for textiles in Lancashire and the West Riding are ignored, so the whole of Order 18, sub-orders 1-5 are classed as 'XVIII15'.
small_cat_f	Text string (max.len.=20).	Corresponding category in the table for females in smaller towns, held here as occ_1911_sm_f. The values held in this column generally match the column names used in that table, but some categories have to be merged because of differences in how the classifications are used in the two tables. N.B. these categories are different from and fewer than those used for males. The more detailed breakdowns provided for textiles in Lancashire and the West Riding are ignored, so the whole of Order 18 sub-orders 1-6 are classed as 'XVIII16'.
sic_div_for_container	Integer number.	For rows with occup_level = 4, the SIC Division which presumably contains the higher level count for this category, if this is different from that to which we assign the level 4 category.
sic_division	Integer number.	Number of the most appropriate Division within the Standard Industrial Classification (2007). An additional division, 999, has been added for persons retired or unoccupied.
sic_division_name	Text string (max.len.=144).	Name of the SIC Division.