About this Dataset

Public Health Funeral Data

Information on funerals organised by Leeds City Council due to circumstances such as no traceable next of kin, next of kin unable or prepared to organise or no-one able/available to fund the funeral. Dataset guidance ---------------- * Column 1: Postcode of area of the last known address of the deceased. * Column 2: Date of death. * Column 3: Total cost of the funeral (not just the amount the council recovers, or the charge by the council). * Column 4: Date the estate was referred to the Treasury Solicitor (the Treasury Solicitor is the Government department that deals with the estates of those who have no next of kin i.e. they try and trace a next of kin who may be entitled to inherit the estate). * Column 5: Gender of deceased. Further Information ------------------- For more information on public health funerals visit: http://www.leeds.gov.uk/residents/Pages/Public-health-funerals.aspx
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:05:01Z

Tables

2011

@ukgov.public_health_funeral_data.n_2011

6.53 kB
28 rows
7 columns

CREATE TABLE n_2011 (
  "postcode_area_of_last_known_address" VARCHAR,
  "date_of_death" VARCHAR,
  "cost_of_funeral" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR,
  "gender" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

2012

@ukgov.public_health_funeral_data.n_2012

7.97 kB
60 rows
9 columns

CREATE TABLE n_2012 (
  "postcode_area_of_last_known_address" VARCHAR,
  "date_of_death" VARCHAR,
  "cost_of_funeral" VARCHAR,
  "cost_recovered" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR,
  "gender" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

2013

@ukgov.public_health_funeral_data.n_2013

8.51 kB
59 rows
10 columns

CREATE TABLE n_2013 (
  "postcode_area_of_last_known_address" VARCHAR,
  "date_of_death" VARCHAR,
  "cost_of_funeral" VARCHAR,
  "cost_recovered" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR,
  "gender" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2014

@ukgov.public_health_funeral_data.n_2014

7.47 kB
65 rows
7 columns

CREATE TABLE n_2014 (
  "postcode_area_of_last_known_address" VARCHAR,
  "date_of_death" TIMESTAMP,
  "cost_of_funeral" VARCHAR,
  "cost_recovered" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR,
  "gender" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

2015

@ukgov.public_health_funeral_data.n_2015

6.76 kB
104 rows
6 columns

CREATE TABLE n_2015 (
  "postcode_area_of_last_known_address" VARCHAR,
  "date_of_death" TIMESTAMP,
  "cost_of_funeral" VARCHAR,
  "cost_recovered" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR,
  "gender" VARCHAR
);

2016

@ukgov.public_health_funeral_data.n_2016

7.03 kB
68 rows
6 columns

CREATE TABLE n_2016 (
  "postcode_area_of_last_known_address" VARCHAR,
  "date_of_death" TIMESTAMP,
  "cost_of_funeral" VARCHAR,
  "cost_recovered" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR,
  "gender" VARCHAR
);

2019

@ukgov.public_health_funeral_data.n_2019

7.43 kB
73 rows
7 columns

CREATE TABLE n_2019 (
  "gender" VARCHAR,
  "postcode" VARCHAR,
  "age" BIGINT,
  "dod" TIMESTAMP,
  "funeral_cost" VARCHAR,
  "costs_recovered" VARCHAR,
  "date_referred_to_treasury_solicitor" VARCHAR
);