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
- Establishment ID
- Type
- text
- Description
Unique identifier for an establishment
- ID
- Inspection ID
- Type
- text
- Description
Unique ID for an inspection
- ID
- Establishment Name
- Type
- text
- Description
Business name of the establishment
- ID
- Establishment Type
- Type
- text
- Description
Establishment type ie restaurant, mobile cart
- ID
- Establishment Address
- Type
- text
- Description
Municipal address of the establishment
- ID
- Infraction Details
- Type
- text
- Description
Description of the Infraction
- ID
- Inspection Observation
- Type
- text
- Description
Details observed associated with the Infraction
- ID
- Inspection Date
- Type
- date
- Description
Calendar date the inspection was conducted
- ID
- Severity
- Type
- text
- Description
Level of the infraction, i.e. S - Significant, M - Minor, C - Crucial
- ID
- Action
- Type
- text
- Description
Enforcement activity based on the infractions noted during a food safety inspection
- ID
- Outcome
- Type
- text
- Description
The registered court decision resulting from the issuance of a ticket or summons for outstanding infractions to the Health Protection and Promotion Act
- ID
- Outcome Date
- Type
- date
- Description
The date of the court outcome
- ID
- Amount Fined
- Type
- float8
- Description
Fine determined in the court outcome
- ID
- Latitude
- Type
- float8
- Description
Latitude of establishment
- ID
- Longitude
- Type
- float8
- Description
Longitude of establishment
- ID
- unique_id
- Type
- text
- Description
Unique composite key
Additional Information
| Field | Value |
|---|---|
| Data last updated | 2026 अप्रिल 9 |
| Metadata last updated | 2026 मे 2 |
| Created | 2026 अप्रिल 9 |
| Format | JSON |
| License | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': 'eda39233-4791-464e-98e6-094f51a01916', 'XML': '8d98cc2e-8898-4335-968a-ebeb09b72cc1', 'JSON': 'e9df9d33-727e-4758-9a84-67ebefec1453'} |
| Datastore cache last update | 4 घण्टा पहिले |
| Extract job | Airflow: Integration Pipeline dinesafe |
| Has views | True |
| Id | 29d83dfa-f8b6-4aa2-8e57-12046c1d83e8 |
| Is preview | True |
| Package id | b6b4f3fb-2e2c-47e7-931d-b87d22806948 |
| Position | 4 |
| Record count | 19,803 |
| 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 |