Datenverzeichnis

ID
unique_id
Typ
text
Beschreibung

Unique id for this record connected to source data

ID
estId
Typ
text
Beschreibung

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
Beschreibung

Legacy establishment ID

ID
estName
Typ
text
Beschreibung

Establishment Name

ID
address
Typ
text
Beschreibung

Address of Establishment

ID
inspectionStatus
Typ
text
Beschreibung

Status of the inspection (ex: Pass)

ID
phone
Typ
text
Beschreibung

Establishment phone number

ID
inspectionDate
Typ
date
Beschreibung

Date of inspection

ID
observation
Typ
text
Beschreibung

Observation made during inspection

ID
typeDesc
Typ
text
Beschreibung

Category of infraction

ID
deficiencyDesc
Typ
text
Beschreibung

Details of infraction

ID
severity
Typ
text
Beschreibung

Severity of infraction

ID
OutcomeDate
Typ
date
Beschreibung

Date of outcome of prosecution, if there was one

ID
OutcomeDesc
Typ
text
Beschreibung

Description of outcome, if there was one - this can be 'pending' if an outcome is being processed

ID
amountFined
Typ
float8
Beschreibung

Dollar amount of fine given

Zusätzliche Informationen

Feld Wert
Daten wurden zuletzt aktualisiert 9. Juli 2026
Metadaten zuletzt aktualisiert 9. Juli 2026
Erstellt 9. Juli 2026
Format JSON
Lizenz 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 updatevor 18 Stunden
Extract jobAirflow: Integration Pipeline dinesafe
Has viewsTrue
Id75dbb3ff-8281-4f03-9de2-bd1214761302
Is previewTrue
Package idb6b4f3fb-2e2c-47e7-931d-b87d22806948
Position7
Record count104.242
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