Coronavirus (COVID-19) Deaths
Greater London Authority
@ukgov.coronavirus_covid_19_deaths_1
Greater London Authority
@ukgov.coronavirus_covid_19_deaths_1
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
);
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
);
CREATE TABLE ons_deaths_cqc_by_la (
"area_name" VARCHAR,
"date" TIMESTAMP,
"cause_of_death" VARCHAR,
"deaths" BIGINT
);
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
);
Anyone who has the link will be able to view this.