Births and deaths data from various dates organised into 2011 Local Authority Districts

Table ID:
VITAL_REDISTRICTED     (6567554)
Contents:
Births and deaths data from various dates organised into 2011 Local Authority Districts
Approx. number of rows:
5,113
Table type:
Derived
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1861 to 2011.
Dates and times are identified by:
   Year

Sources:

  1. The current contents were all generated from existing mortality tables and are limited to census years because of the availability of Geography Conversion Tables:
    • Table mort_sub_summary was used to create data for 1881, 1891
    • Table mort_lgd_ew was used to create data for 1911, 1921, 1931, 1951, 1961
    • Table mort_2001_ew was used to create data from 1981-2001
    • Table mort_2010_ew was used to create data from 2008-2010 as 2011 data
  2. The table is currently limited to England and Wales.


Notes:

  1. Currently, no re-classifcation was involved in the construction of this table, only redistricting.
  2. The data for 2010 is slightly different to earlier dates in that:
    • (i) The figures was based on a three year block rather than an individual year. It covers 2008 to 2010, although 2010 is used as the date in the table. Data for 2011 has not yet been made available on public release.
    • (ii) The in_caz cloumn is blank because this data was added after the work for the GLA and therefore is not neccesary at present.
  3. The only row currently not being redistricted is Pebworth RD in Gloucestershire in 1931. This is because this unit was abolished in 1931 and the polygons match the census for which it does not appear. It was abolished to enlarge two other units, Evesham RD which took the majority of the area and populaiton and Campden RD which took the remainder. All rows for other units which were abolished in 1931 and had no polygons became part of just one other district. These were amended to be covered by the unit they became part of. They were:
    • LATHAM AND BURSCOUGH UD set to ORMSKIRK UD
    • BRAILES RD set to SHIPSTON ON STOUR RD
    • MARSTON SICCA RD set to STRATFORD ON AVON RD
    • ROSS RD set to ROSS AND WHITCHURCH RD
    • WHITCHURCH RD set to ROSS AND WHITCHURCH RD
    • STOW ON THE WOLD RD (Worcestershire) set to STOW ON THE WOLD RD (Gloucestershire)
    • CIVIL PARISHES OF REDMARLEY DABITÔT AND STAUNTON RD set to NEWENT RD
    Other units which were re-set contained no populations and were: Nottingham Shire Hall RD to Nottingham CB and Newcastle Moot Hall RD to Newcastle upon Tyne CB both in 1951 and Inner and Middle Temple set to City of London in 1921 and 1931.
  4. No further work was done to edit the script regarding the "caz" and "Greater London" units so data in these rows may now be incorrect.


Checking:

  1. Derived data: the scripts used to generate these data have been checked carefully.


Indices:

IndexTypeColumn(s) indexed
vital_redistricted_pkey Primary key year, g_unit


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
vital_redistricted_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
row_type Text string (max.len.=12). [No description available]
nation Text string (max.len.=6). [No description available]
area_code Text string (max.len.=18). ONS code for the District or Unitary Authority.
area_name Text string (max.len.=40). [No description available]
g_unit Integer number. ID number of the District or Unitary Authority as defined in the GBHGIS AUO.
year Integer number. Calendar year the data are for.
births Floating point number. Total number of births during year.
deaths Floating point number. Total number of deaths during year.
expected_deaths Floating point number. [No description available]
expected_deaths_1951 Floating point number. [No description available]
infant_deaths Floating point number. Total number of births of children aged under one year.
perinatal_deaths Floating point number. [No description available]
im_auth Text string (max.len.=28). [No description available]
im_note Text string (max.len.=408). [No description available]
g_data_precision Text string (max.len.=12). [No description available]
g_data_status Text string (max.len.=9). [No description available]