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_codebook_pkey | Primary key | occ_code |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
occ_1881_codebook_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | occ_code | Integer number. | A number simply placing each occupation in the order it appears in the master list. NB this is the value that appears in the main 1881 dataset derived from the microdata. | src_tab_row | Integer number. | Row number for use in table reconstructions within Vision of Britain. These are based on occ_code, but include gaps in the sequence enabling totals for the occupational orders and sub-orders to be included within the reconstructions. For example, values of occ_code from 1 to 8 have values of src_tab_row higher by one, enabling a total for "General/Local Government" to be inserted before; then occ_code values from 10 to 16 have values higher by two, enabling a total for "Defence of the country" to be inserted before them, | mw_code | Integer number. | Code number devised by Matthew Woollard, as supplied by him. | lev_1_id | Integer number. | Number identifying the top level of the original 1881 classification of occupations. | lev_1 | Text string (max.len.=24). | Text describing the top level of the original 1881 classification of occupations. | lev_2_id | Integer number. | Number identifying the second level of the original 1881 classification of occupations. | lev_2 | Text string (max.len.=61). | Text describing the second level in the original 1881 classification of occupations. | lev_2_s | Text string (max.len.=27). | A shorter version of the text describing the second level in the original 1881 classification of occupations. | lev_3 | Text string (max.len.=50). | Text describing the third level in the original 1881 classification of occupations. | lev_4 | Text string (max.len.=72). | Text describing the most detailed level in the original 1881 classification of occupations. In general, this specifies quite detailed occupations, such as 'Blacksmith'. | booth | Text string (max.len.=8). | The industrial sector as specified by the Booth-Armstrong classification. | order_21 | Integer number. | The occupational order under the classification used by the 1921 census. | ord_21_rom | Text string (max.len.=10). | The occupational order under the classification used by the 1921 census, represented as a roman numeral. | group_21 | Integer number. | The occupational group under the classification used by the 1921 census. | class_21 | Integer number. | The social class under the 1921 occupational classification, as provided by Armstrong. | class_21_div | Text string (max.len.=10). | The social class under the 1921 occupational classification, but with social class 3 divided into manual and non-manual. As a result, note that this is a character values, not a number. See note above. | class_51 | Integer number. | The social class under the 1951 occupational classification, as provided by Armstrong. | ind_sector | Text string (max.len.=8). | A simple six-way industrial classification, added to permit creation of data for the VisionOfBritain web site. | sic_query | Text string (max.len.=10). | This is a flag column which holds 'Q' if our assignment of the 1881 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 1931 group. These form a single sequence running from 1 to 99. | sic_division_name | Text string (max.len.=138). | 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. |
---|