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.
来源: Dinesafe
Data Dictionary
- ID
- unique_id
- Type
- text
- 描述
Unique id for this record connected to source data
- ID
- estId
- Type
- text
- 描述
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
- 描述
Legacy establishment ID
- ID
- estName
- Type
- text
- 描述
Establishment Name
- ID
- address
- Type
- text
- 描述
Address of Establishment
- ID
- inspectionStatus
- Type
- text
- 描述
Status of the inspection (ex: Pass)
- ID
- phone
- Type
- text
- 描述
Establishment phone number
- ID
- inspectionDate
- Type
- date
- 描述
Date of inspection
- ID
- observation
- Type
- text
- 描述
Observation made during inspection
- ID
- typeDesc
- Type
- text
- 描述
Category of infraction
- ID
- deficiencyDesc
- Type
- text
- 描述
Details of infraction
- ID
- severity
- Type
- text
- 描述
Severity of infraction
- ID
- OutcomeDate
- Type
- date
- 描述
Date of outcome of prosecution, if there was one
- ID
- OutcomeDesc
- Type
- text
- 描述
Description of outcome, if there was one - this can be 'pending' if an outcome is being processed
- ID
- amountFined
- Type
- float8
- 描述
Dollar amount of fine given
其他信息
| 域 | 价值 |
|---|---|
| Data last updated | 2026年6月19日 |
| Metadata last updated | 2026年7月1日 |
| 创建的 | 2026年6月19日 |
| 格式 | JSON |
| 授权 | 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 | 43分钟前 |
| 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 |