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
- Typ
- text
- Opis
Unique id for this record connected to source data
- ID
- estId
- Typ
- text
- Opis
Establishment ID - this will contain either a legacy id or a new one, depending on the system this data currently lives in.
- ID
- oldEstId
- Typ
- text
- Opis
Legacy establishment ID
- ID
- estName
- Typ
- text
- Opis
Establishment Name
- ID
- address
- Typ
- text
- Opis
Address of Establishment
- ID
- inspectionStatus
- Typ
- text
- Opis
Status of the inspection (ex: Pass)
- ID
- phone
- Typ
- text
- Opis
Establishment phone number
- ID
- inspectionDate
- Typ
- date
- Opis
Date of inspection
- ID
- observation
- Typ
- text
- Opis
Observation made during inspection
- ID
- typeDesc
- Typ
- text
- Opis
Category of infraction
- ID
- deficiencyDesc
- Typ
- text
- Opis
Details of infraction
- ID
- severity
- Typ
- text
- Opis
Severity of infraction
- ID
- OutcomeDate
- Typ
- date
- Opis
Date of outcome of prosecution, if there was one
- ID
- OutcomeDesc
- Typ
- text
- Opis
Description of outcome, if there was one - this can be 'pending' if an outcome is being processed
- ID
- amountFined
- Typ
- float8
- Opis
Dollar amount of fine given
Dodatkowe informacje
| Pole | Wartość |
|---|---|
| Data last updated | 19 czerwca 2026 |
| Metadata last updated | 1 lipca 2026 |
| Created | 19 czerwca 2026 |
| Format | JSON |
| Licencja | 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 | 48 minut temu |
| Extract job | Airflow: Integration Pipeline dinesafe |
| Has views | True |
| Id | ad342031-a0eb-4f5e-a2c6-61a499047993 |
| Is preview | True |
| Package id | b6b4f3fb-2e2c-47e7-931d-b87d22806948 |
| Position | 4 |
| Record count | 105 312 |
| 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 |