About this Dataset

Annual Births By Age Of Mother

Number of annual live births by broad age group of mother in England and Wales for mid-year to mid-year periods from 1 July 2000 to 30 June 2020. Original data for Lower Super Output Areas (LSOA) published by the Office for National Statistics here and here. Data aggregated to higher geographies by the Greater London Authority.
Publisher name: Greater London Authority
Last updated: 2024-06-14T04:02:20Z

Tables

Birthsbylad11midyear01to20

@ukgov.annual_births_by_age_of_mother_1.birthsbylad11midyear01to20

85.07 kB
41,760 rows
8 columns

CREATE TABLE birthsbylad11midyear01to20 (
  "year" BIGINT,
  "rgn11cd" VARCHAR,
  "rgn11nm" VARCHAR,
  "lad11cd" VARCHAR,
  "lad11nm" VARCHAR,
  "age_of_mother" VARCHAR,
  "sex" VARCHAR,
  "births" BIGINT
);

Birthsbylad20midyear01to20

@ukgov.annual_births_by_age_of_mother_1.birthsbylad20midyear01to20

82.37 kB
40,320 rows
8 columns

CREATE TABLE birthsbylad20midyear01to20 (
  "year" BIGINT,
  "rgn20cd" VARCHAR,
  "rgn20nm" VARCHAR,
  "lad20cd" VARCHAR,
  "lad20nm" VARCHAR,
  "age_of_mother" VARCHAR,
  "sex" VARCHAR,
  "births" BIGINT
);

Birthsbymsoamidyear01to20

@ukgov.annual_births_by_age_of_mother_1.birthsbymsoamidyear01to20

3.95 MB
864,120 rows
10 columns

CREATE TABLE birthsbymsoamidyear01to20 (
  "year" BIGINT,
  "rgn11cd" VARCHAR,
  "rgn11nm" VARCHAR,
  "lad11cd" VARCHAR,
  "lad11nm" VARCHAR,
  "msoa11cd" VARCHAR,
  "msoa11nm" VARCHAR,
  "age_of_mother" VARCHAR,
  "sex" VARCHAR,
  "births" BIGINT
);

Birthsbyregionmidyear01to20

@ukgov.annual_births_by_age_of_mother_1.birthsbyregionmidyear01to20

11.73 kB
1,200 rows
6 columns

CREATE TABLE birthsbyregionmidyear01to20 (
  "year" BIGINT,
  "rgn11cd" VARCHAR,
  "rgn11nm" VARCHAR,
  "age_of_mother" VARCHAR,
  "sex" VARCHAR,
  "births" BIGINT
);

Birthsbyward20midyear01to20

@ukgov.annual_births_by_age_of_mother_1.birthsbyward20midyear01to20

4.96 MB
962,760 rows
10 columns

CREATE TABLE birthsbyward20midyear01to20 (
  "year" BIGINT,
  "rgn20cd" VARCHAR,
  "rgn20nm" VARCHAR,
  "lad20cd" VARCHAR,
  "lad20nm" VARCHAR,
  "wd20cd" VARCHAR,
  "wd20nm" VARCHAR,
  "age_of_mother" VARCHAR,
  "sex" VARCHAR,
  "births" BIGINT
);