Dinesafe
Dataset description:
DineSafe is Toronto Public Health’s food safety program that inspects all establishments serving and preparing food. Each inspection results in a pass, a conditional pass or a closed notice.
Source: Dinesafe
Data Dictionary
- ID
- unique_id
- Type
- text
- Description
Unique id for this record connected to source data
- ID
- estId
- Type
- text
- Description
Establishment ID
- ID
- estName
- Type
- text
- Description
Establishment Name
- ID
- address
- Type
- text
- Description
Address of Establishment
- ID
- inspectionStatus
- Type
- text
- Description
Status of the inspection (ex: Pass)
- ID
- inspectionDate
- Type
- date
- Description
Date of inspection
- ID
- typeDesc
- Type
- text
- Description
Category of infraction
- ID
- deficiencyDesc
- Type
- text
- Description
Description of infraction deficiency
- ID
- actionDesc
- Type
- text
- Description
Description of action taken
- ID
- OutcomeDate
- Type
- date
- Description
Date of outcome
- ID
- OutcomeDesc
- Type
- text
- Description
Description of outcome
- ID
- amountFined
- Type
- float8
- Description
Dollar amount of fine given
Additional Information
| Field | Value |
|---|---|
| Data last updated | 20 May 2026 |
| Metadata last updated | 23 May 2026 |
| Created | 20 May 2026 |
| Format | JSON |
| License | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': 'af0f5b8a-4b73-4a50-8781-65e949792b40', 'XML': '8d98cc2e-8898-4335-968a-ebeb09b72cc1', 'JSON': 'e9df9d33-727e-4758-9a84-67ebefec1453'} |
| Datastore cache last update | 3 hours ago |
| Extract job | Airflow: Integration Pipeline dinesafe |
| Has views | True |
| Id | 4df989e6-e9b3-4e98-ba13-5ecfddaa8ae2 |
| Is preview | True |
| Package id | b6b4f3fb-2e2c-47e7-931d-b87d22806948 |
| Position | 3 |
| Record count | 103,938 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow: Integration Pipeline dinesafe |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |