Dataset: Wirral Public Health Funerals

About this Dataset

Wirral Public Health Funerals

Public Health Funeral data for Wirral Council. It is a legal requirement that when a resident in the area passes away prior to a hospital admission, and there is no one else willing or able to pay, the council will make the necessary arrangements for the funeral. This is known as a Public Health Funeral and the cost is covered by the council.
Publisher name: Wirral Metropolitan Borough Council
Last updated: 2024-06-14T04:02:44Z

Tables

Wirral Public Health Funerals

@ukgov.wirral_public_health_funerals.wirral_public_health_funerals

10.88 KB
7 rows
13 columns


CREATE TABLE wirral_public_health_funerals (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "referraldate" TIMESTAMP,
  "dateofbirth" TIMESTAMP,
  "dateofdeath" TIMESTAMP,
  "ageatdateofdeath" BIGINT,
  "placeofdeath" VARCHAR,
  "name" VARCHAR,
  "protectionofproperty" VARCHAR,
  "referredby" VARCHAR,
  "funeraltype" VARCHAR,
  "costtolocalauthority" DOUBLE,
  "funeralcostsrecovered" DOUBLE
);

Public Health Funerals April 2016 To March 2017

@ukgov.wirral_public_health_funerals.public_health_funerals_april_2016_to_march_2017

11.95 KB
8 rows
14 columns


CREATE TABLE public_health_funerals_april_2016_to_march_2017 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "referraldate" TIMESTAMP,
  "dateofbirth" TIMESTAMP,
  "dateofdeath" TIMESTAMP,
  "ageatdateofdeath" BIGINT,
  "placeofdeath" VARCHAR,
  "name" VARCHAR,
  "protectionofproperty" VARCHAR,
  "referredby" VARCHAR,
  "funeraltype" VARCHAR,
  "costtolocalauthority" DOUBLE,
  "funeralcostsrecovered" DOUBLE,
  "dateoffuneral" TIMESTAMP
);