Column | Type | Contents |
lg_unit |
Text string (max.len.=44). |
Name of the unit the data relates to. This may be a local
government district, but the table includes county totals,
with and without any County Boroughs listed with the county.
|
lg_type |
Text string (max.len.=8). |
Type of district. This is limited to:
'AC' = Administrative County,
'ACB' = Administrative County with associated County Boroughs,
'CB' = County Borough,
'CC' = County Corporate (this is specific to the City of London)
'LB' = London Borough,
'MB' = Municipal Borough,
'UD' = Urban District.
|
adm_cnty |
Text string (max.len.=28). |
Name of administrative county in which the place is located.
|
row_id |
Integer number. |
Numeric field identifying and placing in order the different
rows of information for each reporting unit; for example,
'Boiler firemen, stokers' (category 915, order XXV) will
always have row_id=359.
|
lev_1 |
Floating point number. |
Level 1 occupational category, given in roman numerals
in the original report. This column is non-null for all rows
apart from the initial 'occupational status' data.
|
lev_2 |
Floating point number. |
Level 2 occupational category. This does not appear
for all level 1 categories.
|
lev_3 |
Floating point number. |
Level 3 (lowest) occupational category; a three digit
occupational code number; which is null where the row is
a higher level total.
NB in the original report, 'Retired from Previous Gainful
Occupation' had the code 'number' 'Y' and 'Other Persons
(no Gainful Occupation stated)' had the code 'X'. These have
been coded as 998 and 999 respectively so that this could be a
numeric column.
Three rows provided ad hoc totals within categories,
had no occupational code in the original report but were
coded as 1000 so that they could be distinguished from both
level 2 totals and figures for individual occupations. These were:
'Agricultural Labourers, Farm Servants' (row ID=22),
'Proprietors and Managers of Retail Businesses for the
sale of' (row ID=488),
and 'Salesmen and Shop Assistants retailing' (row ID=511).
|
occup |
Text string (max.len.=124). |
Name of the occupational category.
NB this may be the name of a level 1, 2 or 3 category,
or an occupational status. In most cases, it is simply
whatever text appears next to the row of numbers.
|
males |
Floating point number. |
Number of males.
|
females |
Floating point number. |
Number of females.
|
ac_tot |
Text string (max.len.=6). |
Flag to indicate rows which are totals for Administrative
Counties. This is always set to 'T' for rows where
lg_type = 'ACB', and manually set to 'T' for rows where
lg_type = 'AC' and there are no associated County Boroughs.
|
notes |
Long text. |
Notes.
|
rec_num |
Integer number. |
Sequence number added on loading, placing the data rows in an overall order.
|
admc_unit |
Integer number. |
ID number for the county containing the unit, as defined in the AUO.
If the unit is a county, this will be identical to g_unit.
|
g_unit |
Integer number. |
ID number for reporting area, as defined in the AUO.
|