Column | Type | Contents |
row_type |
Text string (max.len.=12). |
Flag indicating, broadly, the geographical level.
See notes for how it is used but the main values are NATIONAL, COUNTY and DISTRICT.
|
row_status |
Text string (max.len.=12). |
RAW for all data directly computerised from source, and
DERIVED for the additional data for county residuals and
the data specially inserted as Yorkshire totals and
for the Finsbury area deducting Clerkenwell.
|
district_name |
Text string (max.len.=204). |
The name of the area to which the data relate, as stated in the
original report. This may be a county or an urban area (see
notes).
|
simpler_name |
Text string (max.len.=44). |
A simpler version of the district name, added by us.
For example, 'Bristol City with Barton Regis Hundred' becomes simply 'Bristol'.
|
container |
Text string (max.len.=104). |
The name of the higher-level area, usually a county, to which the data relate.
These are all either Ancient Counties or Scottish Counties.
This column is blank for data covering county and national totals.
|
container_agr |
Text string (max.len.=44). |
For England and Wales this matches container, but it groups Scottish counties
into regions.
This was used to support certain analyses, notably the maps in the
Gilbert and Southall chapter in the Cambridge Urban History of Britain
nation |
Text string (max.len.=6). |
Indicates the nation containing the county:
'E'=England, 'S'=Scotland, 'W'=Wales.
Empty for the national totals for 'England and
Wales' and 'Great Britain'.
|
occupation |
Text string (max.len.=84). |
The occupational group as stated in the census table
(see note).
|
occ_type |
Text string (max.len.=6). |
A set of 3 codes to signify 3 different types of data.:
T indicates 'Total Number of Persons whose Occupations
are returned as above', which NB excludes the residual
category.
R indicates numbers in residual categories such as
'Other persons employed in trade'.
N indicates categories out of employment, e.g.
'Independent persons', 'Almspeople'.
P indicates 'Total Population'.
In general, rows with non-null values here should be
ignored when analysing occupations.
|
m_occ_20 |
Integer number. |
Number of males 20 years and upwards occupied in
the specified occupation.
|
m_occ_19 |
Integer number. |
Number of males under 20 years of age occupied in
the specified occupation.
|
f_occ_20 |
Integer number. |
Number of females 20 years and upwards occupied in
the specified occupation.
|
f_occ_19 |
Integer number. |
Number of females under 20 years of age occupied in
the specified occupation.
|
pop_occ |
Integer number. |
Total occupied population for the specified occupation
in each county.
NB this is raw data for county totals, but is simply
computed from the four age/sex categories for towns.
|
g_unit |
Integer number. |
ID as defined in the AUO for the unit the row of data is for.
These include Nations, Ancient Counties, Scottish Counties,
Divisions of Ancient Counties (for the Yorkshire Ridings),
and the special purpose 1841 Occupation reporting areas
which link to specially created digital boundary data.
|
notes |
Text string (max.len.=104). |
Notes.
|
rec_num |
Integer number. |
Sequence number added on loading to keep rows in order.
|
|