Baselight
Sign In

Annual Birth Estimates

Greater London Authority

@ukgov.annual_birth_estimates

Births Ctry
@ukgov.annual_birth_estimates.births_ctry

Annual births for the countries of England and Wales by date of year ending

  • 8.53 KB
  • 78 rows
  • 9 columns
gss_code

Gss Code

gss_name

Gss Name

year_ending_date

Year Ending Date

measure

Measure

geography

Geography

source

Source

sex

Sex

source_url

Source Url

value

Value

E92000001EnglandWed Jul 01 1992 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017661858
E92000001EnglandThu Jul 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017637168
E92000001EnglandFri Jul 01 1994 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017637259
E92000001EnglandSat Jul 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017617504
E92000001EnglandMon Jul 01 1996 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017605871
E92000001EnglandTue Jul 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017619712
E92000001EnglandWed Jul 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017601728
E92000001EnglandThu Jul 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017597607
E92000001EnglandSat Jul 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017580201
E92000001EnglandSun Jul 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)annual_birthsCTRY21ONS ad hocpersonshttps://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/adhocs/009628birthsanddeathsbylowersuperoutputarealsoaenglandandwales1991to1992to2016to2017567698

CREATE TABLE births_ctry (
  "gss_code" VARCHAR,
  "gss_name" VARCHAR,
  "year_ending_date" TIMESTAMP,
  "measure" VARCHAR,
  "geography" VARCHAR,
  "source" VARCHAR,
  "sex" VARCHAR,
  "source_url" VARCHAR,
  "value" BIGINT
);