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

Public Health Funerals April 2016 To March 2017

@ukgov.wirral_public_health_funerals.public_health_funerals_april_2016_to_march_2017

12.23 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
);

Wirral Public Health Funerals

@ukgov.wirral_public_health_funerals.wirral_public_health_funerals

11.14 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
);