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 activeTrue
Datastore cache{'CSV': 'af0f5b8a-4b73-4a50-8781-65e949792b40', 'XML': '8d98cc2e-8898-4335-968a-ebeb09b72cc1', 'JSON': 'e9df9d33-727e-4758-9a84-67ebefec1453'}
Datastore cache last update2 hours ago
Extract jobAirflow: Integration Pipeline dinesafe
Has viewsTrue
Id4df989e6-e9b3-4e98-ba13-5ecfddaa8ae2
Is previewTrue
Package idb6b4f3fb-2e2c-47e7-931d-b87d22806948
Position3
Record count103,938
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline dinesafe
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID