On May 9, 2020, we released a consolidated database of 626 Long-Term Care (LTC) Homes in Ontario, derived from information published by the provincial government. Today we’re supplementing this database with an Index to Inspection Reports issued for LTC Homes in the province between April 2010 and March 2020.
Primary Source
Our primary source was the Ontario government’s Reports on Long-Term Care Homes website.
Methods
As noted in our May 9, 2020 posting, the source code for the website’s Search-by-Home-Name API included links to Home Reports on every LTC Home. These links allowed us to automate a process for accessing the Profiles and Inspection Findings of every LTC Home on the website. These Profiles were incorporated previously in our consolidated database of LTC Homes; these Inspection Findings are incorporated here into our Index of Reports of Inspections Issued to these same LTC Homes.
Final Results
Our consolidated database profiled 626 Long-Term Care Homes currently licensed to operate in Ontario. As a further assistance to researchers, we have compiled an Index to Reports of Inspections Issued to these LTC Homes between April 2010 – March 2020. The Index is described in Table 1 and is made available as a CSV file or Excel spreadsheet.
| Field | Definition |
|---|---|
| MOH_PRO_ID* | A unique identifier assigned to an MOH service provider. |
| NAME | English name of the LTC Home service provider. |
| _INSPECTION_TYPE* | There were six main types of inspection: Resident Quality Inspection; Complaints Inspection; Critical Incident Inspection; Mandatory Inspection; Follow-Up Inspection; and Other Inspection. Every type of inspection may be accompanied with Order(s) of the Inspector, e.g. Complaints Inspection with Order(s) of the Inspector. There were occasional references to three other types of inspection: Director Order Follow-Up Inspection; Notification of Cease of Admissions; and Lifting of Cease of Admissions. |
| _INSPECTION_DATE | |
| _DOCUMENT_ID | A unique identifier in two parts (separated by a hyphen): a unique identifier for the Inspection Report and a unique identifier for the LTC Home. (In April 2020, the URL of the PDF version of the Inspection Report included both identifiers). |
This work, including the database, is licensed under a Creative Commons Attribution 4.0 International License. If you should use this work, please credit Paul Allen, paul@hartallen.com.