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.
Kilde: Dinesafe
Dataordbok
- ID
- unique_id
- Type
- text
- Beskrivelse
Unique id for this record connected to source data
- ID
- estId
- Type
- text
- Beskrivelse
Establishment ID - this will contain either a legacy id or a new one, depending on the system this data currently lives in.
- ID
- oldEstId
- Type
- text
- Beskrivelse
Legacy establishment ID
- ID
- estName
- Type
- text
- Beskrivelse
Establishment Name
- ID
- address
- Type
- text
- Beskrivelse
Address of Establishment
- ID
- inspectionStatus
- Type
- text
- Beskrivelse
Status of the inspection (ex: Pass)
- ID
- phone
- Type
- text
- Beskrivelse
Establishment phone number
- ID
- inspectionDate
- Type
- date
- Beskrivelse
Date of inspection
- ID
- observation
- Type
- text
- Beskrivelse
Observation made during inspection
- ID
- typeDesc
- Type
- text
- Beskrivelse
Category of infraction
- ID
- deficiencyDesc
- Type
- text
- Beskrivelse
Details of infraction
- ID
- severity
- Type
- text
- Beskrivelse
Severity of infraction
- ID
- OutcomeDate
- Type
- date
- Beskrivelse
Date of outcome of prosecution, if there was one
- ID
- OutcomeDesc
- Type
- text
- Beskrivelse
Description of outcome, if there was one - this can be 'pending' if an outcome is being processed
- ID
- amountFined
- Type
- float8
- Beskrivelse
Dollar amount of fine given
Tilleggsinformasjon
| Felt | Verdi |
|---|---|
| Data sist oppdatert | 19. juni 2026 |
| Metadata sist oppdatert | 1. juli 2026 |
| Opprettet | 19. juni 2026 |
| Format | JSON |
| Lisens | 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 | for 6 timer siden |
| 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 |