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_1841_codebook_pkey | Primary key | occupation |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
occ_1841_codebook_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | seq_num | Integer number. | A unique sequence number identifying each row, starting from 1. | occupation | Text string (max.len.=84). | The occupation as listed in the 1841 census report and as held in the 'occ_1841' table. | formatted | Text string (max.len.=84). | Text to be output in table reconstructions in Vision of Britain. Identical to 'occupation' except for the total of the individual occupations and the overall total population, which have added HTML tags to set them to bold. | booth | Text string (max.len.=10). | The occupational category under the Booth-Armstrong coding scheme. Set to 'TOTAL' for the categories at the end of the table which are not occupations at all. | ind_sector | Text string (max.len.=9). | This is an ad hoc code which, broadly speaking, maps the Booth classification to a much simpler system of sux sectors as used in the 'Vision of Britain' web site. Most of the assignments are obvious. However, the following specific groups were assigned to Utilities, not Services: those employed in posts and telegraph in PP1; those employed at waterworks in PP3; and labourers in IS2. | order21 | Integer number. | The occupational order under the classification used by the 1921 census held as a conventional number. | ord21_rom | Text string (max.len.=10). | The occupational order under the classification used by the 1921 census, held as a roman numeral and therefore matching the categories in the table 'occ_1921'. | group21 | Integer number. | The occupational group under the classification used by the 1921 census. | class21 | Integer number. | The social class under the 1921 occupational classification, as provided by Armstrong. | class51 | Integer number. | The social class under the 1951 occupational classification, as provided by Armstrong. | sic_query | Text string (max.len.=6). | This is a flag column which holds 'Q' if our assignment of the 1841 category to the 2007 SIC was seen as especially problematic; otherwise empty. | sic_division | Integer number. | Integer number identifying the 2007 SIC 'Division' to which we have assigned the 1841 group. These form a single sequence running from 1 to 99. | sic_division_name | Text string (max.len.=142). | Name of the 2007 SIC 'Division'. For example, 'AGRICULTURE, FORESTRY AND FISHING' is divided into (01) 'Crop and animal production, hunting and related service activities', (02) 'Forestry and logging', and (03) 'Fishing and aquaculture'. Some Sections contain only one division. | notes | Long text. | Notes, mainly used to explain the basis for problematic allocations. This includes information copied from other sources, including the Oxford English Dictionary and Wikipedia. |
---|