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

Table ID:

VITAL_REDISTRICTED     (1253406)

Contents:

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

Approx. number of rows:

5,123

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

---

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.
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:

Index	Type	Column(s) indexed
vital_redistricted_pkey	Primary key	year, g_unit

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
vital_redistricted_pkey	Primary Key	See details above for primary key index
vital_redistricted_area_type_check	Check	((((area_type)::text = 'COUNTRY'::text) OR ((area_type)::text = 'DISTRICT'::text) OR ((area_type)::text = 'GOR'::text) OR ((area_type)::text = 'MOD_REG'::text) OR ((area_type)::text = 'MOD_CNTY'::text) OR ((area_type)::text = 'NATION'::text)))
vital_redistricted_nat_source_check	Check	((((nat_source)::text = 'Reported_total'::text) OR ((nat_source)::text = 'Sum_of_redist'::text) OR ((nat_source)::text = 'Sum_of_raw_EnumD'::text) OR ((nat_source)::text = 'Sum_of_raw_Par'::text) OR ((nat_source)::text = 'Sum_of_raw_Ward'::text) OR ((nat_source)::text = 'Sum_of_EW_and_Scot'::text)))

---

Columns within table:

Column	Type	Contents
area_type	Text string (max.len.=12).	This column identifies the geographical level: DISTRICT, i.e. an individual local authority. MOD_CNTY, i.e. an English county. GOR, i.e. computed total for a Government Office Region (or Wales). NATIONAL, i.e. an overall total for England and Wales, Scotland or Great Britain. The nat_source column records how such totals were obtained.
nation	Text string (max.len.=6).	One or two-letter code identifying the part of the UK.
nat_source	Text string (max.len.=28).	Appears only for rows which are national totals, and then identifies how it was derived. This will ideally be "Reported_total".
area_code	Text string (max.len.=18).	ONS code for the District or Unitary Authority.
area_name	Text string (max.len.=40).	Name of the local authority district, as extracted from the AUO.
g_unit	Integer number.	ID number of the area 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.	Expected number of deaths in the area, computed by applying age- and gender-specific national mortality rates for Great Britain in the relevant year to census age structure data for the area, again in the relevant year.
expected_deaths_1951	Floating point number.	Expected number of deaths in the area, computed by applying age- and gender-specific national mortality rates for Great Britain in 1951 to census age structure data for the area in the current year. 1951 is used as being somewhat central in the period covered.
infant_deaths	Floating point number.	Total number of births of children aged under one year.
perinatal_deaths	Floating point number.	Total number of births of children aged under one week.
g_authority	Text string (max.len.=28).	Source identifier.
g_auth_note	Text string (max.len.=408).	More detailed information on source, including IDs for specific census tables.
g_data_precision	Text string (max.len.=12).	Code identifying basis for calculation: 'E' for exact counts for 2011 data, and most other data 'GBR' to indicate data redistricted by the project.
g_data_status	Text string (max.len.=9).	Code specifying access status: 'P' for public by default.
rec_num	Integer number.	Sequence number keeping rows in correct order.