Age-standardised mortality rates for deaths involving coronavirus (COVID-19), non-COVID-19 deaths and all deaths by vaccination status, broken down by age group.

Dataset description

Daily official UK Covid data. The data is available per country (England, Scotland, Wales and Northern Ireland) and for different regions in England. The different regions are split into two different files as part of the data is directly gathered by the NHS (National Health Service). The files that contain the word 'nhsregion' in their name, include data related to hospitals only, such as number of admissions or number of people in respirators. The files containing the word 'region' in their name, include the rest of the data, such as number of cases, number of vaccinated people or number of tests performed per day. The next paragraphs describe the columns for the different file types.

Region files

Files related to regions (word 'region' included in the file name) have the following columns: - "date": date in YYYY-MM-DD format - "area type": type of area covered in the file (region or nation) - "area name": name of area covered in the file (region or nation name) - "daily cases": new cases on a given date - "cum cases": cumulative cases - "new deaths 28days": new deaths within 28 days of a positive test - "cum deaths 28days": cumulative deaths within 28 days of a positive test - "new deaths_60days": new deaths within 60 days of a positive test - "cum deaths 60days": cumulative deaths within 60 days of a positive test - "new_first_episode": new first episodes by date - "cum_first_episode": cumulative first episodes by date - "new_reinfections": new reinfections by specimen data - "cum_reinfections": cumualtive reinfections by specimen data - "new_virus_test": new virus tests by date - "cum_virus_test": cumulative virus tests by date - "new_pcr_test": new PCR tests by date - "cum_pcr_test": cumulative PCR tests by date - "new_lfd_test": new LFD tests by date - "cum_lfd_test": cumulative LFD tests by date - "test_roll_pos_pct": percentage of unique case positivity by date rolling sum - "test_roll_people": unique people tested by date rolling sum - "new first dose": new people vaccinated with a first dose - "cum first dose": cumulative people vaccinated with a first dose - "new second dose": new people vaccinated with a first dose - "cum second dose": cumulative people vaccinated with a first dose - "new third dose": new people vaccinated with a booster or third dose - "cum third dose": cumulative people vaccinated with a booster or third dose

Country files

Files related to countries (England, Northern Ireland, Scotland and Wales) have the above columns and also: - "new admissions": new admissions, - "cum admissions": cumulative admissions, - "hospital cases": patients in hospitals, - "ventilator beds": COVID occupied mechanical ventilator beds - "trans_rate_min": minimum transmission rate (R) - "trans_rate_max": maximum transmission rate (R) - "trans_growth_min": transmission rate growth min - "trans_growth_max": transmission rate growth max

NHS Region files

Files related to nhsregion (word 'nhsregion' included in the file name) have the following columns: - "new admissions": new admissions, - "cum admissions": cumulative admissions, - "hospital cases": patients in hospitals, - "ventilator beds": COVID occupied mechanical ventilator beds - "trans_rate_min": minimum transmission rate (R) - "trans_rate_max": maximum transmission rate (R) - "trans_growth_min": transmission rate growth min - "trans_growth_max": transmission rate growth max

It's worth noting that the dataset hasn't been cleaned and it needs cleaning. Also, different files have different null columns. This isn't an error in the dataset but the way different countries and regions report the data.

Vaccinations in London Between 8 December 2020 and 15 September 2021 5,838,305 1st doses and 5,232,885 2nd doses have been administered to London residents.

Differences in vaccine roll out between London and the Rest of England London Rest of England Priority Group Vaccinations given Percentage vaccinated Vaccinations given Percentage vaccinated Group 1 Older Adult Care Home Residents 21,883 95% 275,964 96% Older Adult Care Home Staff 29,405 85% 381,637 88% Group 2 80+ years 251,021 83% 2,368,284 93% Health Care Worker 174,944 99% 1,139,243 100%* Group 3 75 - 79 years 177,665 90% 1,796,408 99% Group 4 70 - 74 years 252,609 90% 2,454,381 97% Clinically Extremely Vulnerable 278,967 88% 1,850,485 95% Group 5 65 - 69 years 285,768 90% 2,381,250 97% Group 6 At Risk or Carer (Under 65) 983,379 78% 6,093,082 88% Younger Adult Care Home Residents 3,822 92% 30,321 93% Group 7 60 - 64 years 373,327 92% 2,748,412 98% Group 8 55 - 59 years 465,276 91% 3,152,412 97% Group 9 50 - 54 years 510,132 90% 3,141,219 95% Data as at 15 September 2021 for age based groups and as at 12 September 2021 for non-age based groups * The number who have received their first dose exceeds the latest official estimate of the population for this group There is considerable uncertainty in the population denominators used to calculate the percentage vaccinated. Comparing implied vaccination rates for multiple sources of denominators provides some indication of uncertainty in the true values. Confidence is higher where the results from multiple sources agree more closely. Because the denominator sources are not fully independent of one another, users should interpret the range of values across sources as indicating the minimum range of uncertainty in the true value. The following datasets can be used to estimate vaccine uptake by age group for London:

ONS 2020 mid-year estimates (MYE). This is the population estimate used for age groups throughout the rest of the analysis.


Number of people ages 18 and over on the National Immunisation Management Service (NIMS)


ONS Public Health Data Asset (PHDA) dataset. This is a linked dataset combining the 2011 Census, the General Practice Extraction Service (GPES) data for pandemic planning and research and the Hospital Episode Statistics (HES). This data covers a subset of the population.

Vaccine roll out in London by Ethnic Group Understanding how vaccine uptake varies across different ethnic groups in London is complicated by two issues:

Ethnicity information for recipients is unavailable for a very large number of the vaccinations that have been delivered. As a result, estimates of vaccine uptake by ethnic group are highly sensitive to the assumptions about and treatment of the Unknown group in calculations of rates.

For vaccinations given to people aged 50 and over in London nearly 10% do not have ethnicity information available,

The accuracy of available population denominators by ethnic group is limited. Because ethnicity information is not captured in official estimates of births, deaths, and migration, the available population denominators typically rely on projecting forward patterns captured in the 2011 Census. Subsequent changes to these patterns, particularly with respect to international migration, leads to increasing uncertainty in the accuracy of denominators sources as we move further away from 2011.

Comparing estimated population sizes and implied vaccination rates for multiple sources of denominators provides some indication of uncertainty in the true values. Confidence is higher where the results from multiple sources agree more closely. Because the denominator sources are not fully independent of one another, users should interpret the range of values across sources as indicating the minimum range of uncertainty in the true value. The following population estimates are available by Ethnic group for London:

GLA Ethnic group population projections - 2016 as at 2021


ONS Population Denominators produced for Race Disparity Audit as at 2018


ETHPOP population projections produced by the University of Leeds as at 2020

Antibody prevalence estimates As part of the ONS Coronavirus (COVID-19) Infection Survey ONS publish a modelled estimate of the percent of the adult population testing positive for antibodies to Coronavirus by region. Antibodies can be generated by vaccination or previous infection.

Vaccine effects on cases, hospitalisations and deaths When the vaccine roll out began in December 2020 coronavirus cases, hospital admissions and deaths were rising steeply. The peak of infections came in London in early January 2021, before reducing during the national lockdown and as the vaccine roll out progressed. As the vaccine roll out began in older age groups the effect of vaccinations can be separated from the effect of national lockdown by comparing changes in cases, admissions and deaths