Coroners’ reports: open data
This is a list of every prevention of future deaths report we have collected from judiciary.uk, with who it was sent to and which responses are published. You can use it in a spreadsheet, a story or a study.
Rebuilt daily
The files
- Download reports.csv
reports.csv
One row for each report.
- Download recipients.csv
recipients.csv
One row for each organisation a report was sent to.
- Download responses.csv
responses.csv
One row for each response published on judiciary.uk.
- Download datapackage.json
datapackage.json
A machine-readable description of the files and columns, for data tools.
- Download coroners-reports.zip
coroners-reports.zip
All three files, with a README and datapackage.json.
5 files
What each column means
| File | Column | What it means |
|---|---|---|
| reports.csv | judiciary_post_id | judiciary.uk’s own number for the report page. |
| reports.csv | reference | The report’s reference. |
| reports.csv | report_date | The date on the report. |
| reports.csv | published_on_judiciary_uk | The day judiciary.uk put it online. |
| reports.csv | coroner_area | The coroner’s area. |
| reports.csv | categories | The categories judiciary.uk gives it, separated by “; ”. |
| reports.csv | recipients_count | How many organisations it was sent to. |
| reports.csv | responses_published | How many responses judiciary.uk has published so far. |
| reports.csv | response_status | A short code for the status. |
| reports.csv | response_status_label | The tracker’s words, for example “Deadline passed”. That means none is published on judiciary.uk so far, and a reply may have been sent and not yet published. |
| reports.csv | response_deadline | The report date plus 56 days. Blank when it can’t be worked out. |
| reports.csv | status_as_of | The day the status was worked out. |
| reports.csv | text_source | Whether we took the text from the file’s text (file_text), or by reading a scan (scan_read). web_page means the judiciary.uk page, and none means no text. |
| reports.csv | judiciary_uk_page | The report on judiciary.uk. |
| reports.csv | minute_book_page | The report on Minute Book. |
| reports.csv | licence | The licence that applies to the row. |
| recipients.csv | judiciary_post_id | Links the row to its report. |
| recipients.csv | position | The recipient’s place in the report’s list. |
| recipients.csv | recipient_as_published | The recipient exactly as judiciary.uk names it. |
| recipients.csv | organisation_name | Our name for the organisation. Blank unless the match was made automatically or confirmed by a person. |
| recipients.csv | ods_code | The organisation’s ODS code. Blank when there is no match. |
| recipients.csv | organisation_slug | The organisation’s address on Minute Book. Blank when there is no match. |
| recipients.csv | response_published | “yes” if its response is on judiciary.uk. |
| responses.csv | judiciary_post_id | Links the row to its report. |
| responses.csv | position | The document’s place in the report’s list. |
| responses.csv | kind | “response”, or “other” for another document. |
| responses.csv | responder | Who sent it, as published. |
| responses.csv | recipient_position | The recipient it belongs to. Blank if not yet matched. |
| responses.csv | uploaded_month | The month judiciary.uk uploaded it, not when it was sent. |
What’s left out, and why
No report text and no names of people who died. Each row links to the report on judiciary.uk.
Licence
The details taken from judiciary.uk are under the Open Government Licence v3.0. What we add (matches to organisations and response statuses) is under Creative Commons Attribution 4.0 (CC BY 4.0). Please credit Minute Book.
Contains public sector information licensed under the Open Government Licence v3.0. Source: Courts and Tribunals Judiciary, judiciary.uk. Organisation matches and response statuses © Fyllio Ltd, CC BY 4.0.
How to cite
Minute Book (Fyllio Ltd), Coroners' Prevention of Future Deaths reports dataset, edition YYYY-MM-DD, https://minute-book.com/data/coroners-reports.
If we take a report off Minute Book, it leaves these files at the next daily rebuild, within a day.
To look at single reports, use the coroners’ reports explorer.