---

Description

**Excel Age-Range creator for Office for National Statistics (ONS) Mid year population estimates (MYE) covering each year between 1999 and 2013**  These files take into account the revised estimates for 2002-2010 released in April 2013 down to Local Authority level and the post 2011 estimates based on the Census results. Scotland and Northern Ireland data has not been revised, so Great Britain and United Kingdom totals comprise the original data for these plus revised England and Wales figures. This Excel based tool enables users to query the single year of age raw data so that any age range can easily be calculated without having to carry out often complex, and time consuming formulas that could also be open to human error. Simply select the lower and upper age range for both males and females and the spreadsheet will return the total population for the range. Please adhere to the terms and conditions of supply contained within the file. **Tip:** You can copy and paste the rows you are interested in to another worksheet by using the filters at the top of the columns and then select all by pressing Ctrl+A. Then simply copy and paste the cells to a new location. **ONS Mid year population estimates** [Open Excel tool (London Boroughs, Regions and National, 1999-2013)](https://londondatastore-upload.s3.amazonaws.com/o_k%3Dons-mye-custom-age-tool.xls) Also available is a custom-age tool for all geographies in the UK. Open the tool for all UK geographies (local authority and above) for: [2010](https://londondatastore-upload.s3.amazonaws.com/ons-mye-custom-age-tool-uk-geogs-2010.xls), [2011](https://londondatastore-upload.s3.amazonaws.com/ons-mye-custom-age-tool-uk-geogs-2011.xls), [2012](https://londondatastore-upload.s3.amazonaws.com/ons-mye-custom-age-tool-uk-geogs-2012.xls) and [2013](https://londondatastore-upload.s3.amazonaws.com/uk0%3Dons-mye-custom-age-tool-uk-geogs-2013.xls). This full MYE dataset by single year of age (SYA) age and gender is available as a Datastore package at the link below. **Ward Level Population estimates** [Excel single year of age population tool for 2002 to 2013 for all wards in London.](https://londondatastore-upload.s3.amazonaws.com/ons-mye-custom-age-tool-ward.xls)

---

General Information

• This data is described at

  http://data.london.gov.uk/dataset/ons-mid-year-population-estimates-custom-age-tables Do you think this data is incorrect? Let us know

• This data is published by

  Greater London Authority (GLA) Do you think this data is incorrect? Let us know

---

Legal Information

• This data was

  originally created or generated by its curator Do you think this data is incorrect? Let us know

• The rights statement is at

  http://data.london.gov.uk/dataset/ons-mid-year-population-estimates-custom-age-tables Do you think this data is incorrect? Let us know

• This data is available under

  UK Open Government Licence Do you think this data is incorrect? Let us know

• There are

  yes, and the rights are all held by the same person or organisation Do you think this data is incorrect? Let us know

• The content is available under

  UK Open Government Licence Do you think this data is incorrect? Let us know

• This data contains

  no data about individuals Do you think this data is incorrect? Let us know

---

Practical Information

• The data appears in this collection

  http://data.london.gov.uk Do you think this data is incorrect? Let us know

• This data changes

  no Do you think this data is incorrect? Let us know

---

Technical Information

• Releases of this data are listed at

  http://data.london.gov.uk/api/rest/package/ons-mid-year-population-estimates-custom-age-tables Do you think this data is incorrect? Let us know

• This data is

  machine-readable Do you think this data is incorrect? Let us know

---

Social Information

• The documentation includes machine-readable data for

  title Do you think this data is incorrect? Let us know

• The documentation includes machine-readable data for

  description Do you think this data is incorrect? Let us know

• The documentation includes machine-readable data for

  release frequency Do you think this data is incorrect? Let us know

• The documentation includes machine-readable data for

  publisher Do you think this data is incorrect? Let us know

• The documentation includes machine-readable data for

  distribution(s) Do you think this data is incorrect? Let us know

• The documentation includes machine-readable data for

  release date Do you think this data is incorrect? Let us know

• The documentation includes machine-readable data for

  modification date Do you think this data is incorrect? Let us know

---