Baselight

Coronavirus (COVID-19) Deaths

Greater London Authority

@ukgov.coronavirus_covid_19_deaths_1

Loading...
Loading...

About this Dataset

Coronavirus (COVID-19) Deaths

Due to changes in the collection and availability of data on COVID-19 this page will no longer be updated. The webpage will no longer be available as of 11 May 2023. On-going, reliable sources of data for COVID-19 are available via the COVID-19 dashboard, Office for National Statistics, and the UKHSA This page provides a weekly summary of data on deaths related to COVID-19 published by NHS England and the Office for National Statistics. More frequent reporting on COVID-19 deaths is now available here, alongside data on cases, hospitalisations, and vaccinations. This update contains data on deaths related to COVID-19 from: * NHS England COVID-19 Daily Deaths \- last updated on 28 June 2022 with data up to and including 27 June 2022. * ONS weekly deaths by Local Authority \- last updated on 16 August 2022 with data up to and including 05 August 2022. Summary notes about each these sources are provided at the end of this document. Note on interpreting deaths data: statistics from the available sources differ in definition, timing and completeness. It is important to understand these differences when interpreting the data or comparing between sources. ### Weekly Key Points * An additional 24 deaths in London hospitals of patients who had tested positive for COVID-19 and an additional 5 where COVID-19 was mentioned on the death certificate were announced in the week ending 27 June 2022. This compares with 40 and 3 for the previous week. * A total of 306 deaths in hospitals of patients who had tested positive for COVID-19 and 27 where COVID-19 was mentioned on the death certificate were announced for England as whole. This compares with 301 and 26 for the previous week. * The total number of COVID-19 deaths reported in London hospitals of patients who had tested positive for COVID-19 is now 19,102. The total number of deaths in London hospitals where COVID-19 was mentioned on the death certificate is now 1,590. * This compares to figures of 119,237 and 8,197 for English hospitals as a whole. * Due to the delay between death occurrence and reporting, the estimated number of deaths to this point will be revised upwards over coming days * These figures do not include deaths that occurred outside of hospitals. Data from ONS has indicated that the majority (79%) of COVID-19 deaths in London have taken place in hospitals. ### Recently announced deaths in Hospitals
Publisher name: Greater London Authority
Last updated: 2024-06-14T04:02:21Z

Tables

Nhse Daily Announced Deaths By Region

@ukgov.coronavirus_covid_19_deaths_1.nhse_daily_announced_deaths_by_region
  • 200.47 KB
  • 85872 rows
  • 7 columns
Loading...

CREATE TABLE nhse_daily_announced_deaths_by_region (
  "nhs_england_region" VARCHAR,
  "date_of_death" VARCHAR,
  "date_of_report" TIMESTAMP,
  "date_of_announcement" TIMESTAMP,
  "new_deaths_with_positive_test" BIGINT,
  "new_deaths_without_positive_test" BIGINT,
  "new_deaths_total" BIGINT
);

Nhse Total Deaths By Region

@ukgov.coronavirus_covid_19_deaths_1.nhse_total_deaths_by_region
  • 105.23 KB
  • 5950 rows
  • 9 columns
Loading...

CREATE TABLE nhse_total_deaths_by_region (
  "nhs_england_region" VARCHAR,
  "date" TIMESTAMP,
  "new_deaths_with_positive_test" BIGINT,
  "cumulative_deaths_with_positive_test" BIGINT,
  "new_deaths_without_positive_test" BIGINT,
  "cumulative_deaths_without_positive_test" BIGINT,
  "new_deaths_total" BIGINT,
  "cumulative_deaths_total" BIGINT,
  "data_subject_to_change" BOOLEAN
);

Ons Deaths Cqc By La

@ukgov.coronavirus_covid_19_deaths_1.ons_deaths_cqc_by_la
  • 6.77 KB
  • 2100 rows
  • 4 columns
Loading...

CREATE TABLE ons_deaths_cqc_by_la (
  "area_name" VARCHAR,
  "date" TIMESTAMP,
  "cause_of_death" VARCHAR,
  "deaths" BIGINT
);

Ons Deaths Weekly Occurrences By La Location

@ukgov.coronavirus_covid_19_deaths_1.ons_deaths_weekly_occurrences_by_la_location
  • 384.08 KB
  • 543372 rows
  • 9 columns
Loading...

CREATE TABLE ons_deaths_weekly_occurrences_by_la_location (
  "area_code" VARCHAR,
  "area_name" VARCHAR,
  "place_of_death" VARCHAR,
  "week_start" TIMESTAMP,
  "week_end" TIMESTAMP,
  "week_number" BIGINT,
  "year" BIGINT,
  "cause_of_death" VARCHAR,
  "deaths" BIGINT
);

Share link

Anyone who has the link will be able to view this.