Column | Type | Contents |
year |
Integer number. |
Calendar year covered by the data.
|
row_type |
Text string (max.len.=14). |
Type of area covered by the current row.
The available values are:
- Nation: National total for England and Wales. The unit ID is held only in g_unit.
- Division: Totals for a Registration Division. The unit ID is held in both reg_div_unit and g_unit.
- County: Totals for a Registration County. The unit ID is held in both reg_cnty_unit and g_unit.
- LonPart: Totals for those Districts within the London Division within each of the three ancient counties,
i.e. Middlesex, Surrey and Kent.
These areas are not currently defined in the AUO so these rows have no ID numbers.
- WalesPart: Data for 'South Wales' or 'North Wales'.
Up to and including 1902, these are listed as counties in the source tables,
but we have computed county data for the individual Welsh counties from the
district-level data.
- District: Registration District.
The unit ID is held in both reg_dist_unit and g_unit.
- Dist:PLU: Poor Law Union which was a sub-division of a
Registration District. The district ID is held in reg_dist_unit while
g_unit holds the ID of the Poor Law area, if known.
This is needed if aggregates of districts or counties are required.
|
reg_div |
Text string (max.len.=44). |
Name of the Registration Division.
"ENGLAND AND WALES", for the national totals, is also held here.
|
reg_cnty_num |
Integer number. |
Number of Registration County.
|
reg_cnty |
Text string (max.len.=44). |
Name of Registration County.
|
reg_num |
Integer number. |
Number of Registration District.
|
reg_sfx |
Text string (max.len.=5). |
Suffix to number of Registration District, allowing IDs such as '431A'.
|
reg_dist |
Text string (max.len.=104). |
Name of Registration District to which data relate.
Null for data for Divisions and Counties.
|
birth_tot |
Integer number. |
Births: Total.
Included in source tables for all years and areas.
|
birth_m |
Integer number. |
Male births, legitimate or illegitimate.
Included in source tables for 1871 to 1880.
Included as a derived value for counties
and higher-level areas for later dates.
|
birth_f |
Integer number. |
Female births, legitimate or illegitimate.
Included in source tables for 1871 to 1880.
Added as a derived value for counties
and higher-level areas for later dates.
|
birth_legit |
Integer number. |
Births: Legitimate.
Included in the source tables for 1881 onwards
but only for districts and sub-districts.
Added as a derived value from other counts
for all other dates and types of area.
|
birth_legit_m |
Integer number. |
Births: Legitimate: Males.
Up to 1880, not reported but has been computed from birth_m and birth_illegit_m.
From 1881 onwards, listed only for counties, divisions and national totals.
|
birth_legit_f |
Integer number. |
Births: Legitimate: Females.
Up to 1880, not reported but has been computed from birth_f and birth_illegit_f.
From 1881 onwards, listed only for counties, divisions and national totals.
|
birth_illegit |
Integer number. |
Births: Illegitimate.
Included in the source tables for 1881 onwards
but only for districts and sub-districts.
Added as a derived value from other counts
for all other dates and types of area.
|
birth_illegit_m |
Integer number. |
Births: Illegitimate: Males.
Up to 1880, reported for all areas.
From 1881 onwards, listed only for counties, divisions and national totals.
|
birth_illegit_f |
Integer number. |
Births: Illegitimate: Females.
Up to 1880, reported for all areas.
From 1881 onwards, listed only for counties, divisions and national totals.
|
death_tot |
Integer number. |
Deaths: Total.
|
death_m |
Integer number. |
Deaths: Males.
|
death_f |
Integer number. |
Deaths: Females.
|
mar_tot |
Integer number. |
Marriages.
Note that this count is not given for sub-districts, or for years before 1885.
|
excess |
Integer number. |
Excess of births over deaths.
Listed only for years before 1885,
when it was replaced by the count of marriages.
|
notes |
Long text. |
Footnotes copied from the original report.
These are mainly information about boundary changes, and their
impact on the data, and we have tried to include all notes
which affect district-level data.
They also list, for those districts covering more than one
Poor Law Union, which sub-districts formed each union.
These latter notes are not included in the current transcription,
but enable calculation of total deaths for the separate unions,
as held in the vital_ew_reg_ann table.
|
nation_unit |
Integer number. |
ID of either England or Wales, as appropriate and derived
from the county the District was in.
|
reg_div_unit |
Integer number. |
ID number of the Registration Division, as defined in the AUO.
|
reg_cnty_unit |
Integer number. |
ID number of the Registration County, as defined in the AUO.
|
reg_dist_unit |
Integer number. |
ID number of the Registration District, as defined in the AUO.
|
g_unit |
Integer number. |
ID number, as defined in the AUO, of the area covered by the current row.
See documentation for the row_type column for what exactly will be held here.
|
above_unit |
Integer number. |
[No description available]
|
match_dist |
Text string (max.len.=84). |
[No description available]
|
rec_num |
Integer number. |
Sequence number added on loading, keeping rows in correct order.
|