Data Dictionary

ID
unique_id
Typ
text
Beskrivning

Unique id for this record connected to source data

ID
estId
Typ
text
Beskrivning

Establishment ID

ID
estName
Typ
text
Beskrivning

Establishment Name

ID
address
Typ
text
Beskrivning

Address of Establishment

ID
inspectionStatus
Typ
text
Beskrivning

Status of the inspection (ex: Pass)

ID
inspectionDate
Typ
date
Beskrivning

Date of inspection

ID
typeDesc
Typ
text
Beskrivning

Category of infraction

ID
deficiencyDesc
Typ
text
Beskrivning

Description of infraction deficiency

ID
actionDesc
Typ
text
Beskrivning

Description of action taken

ID
OutcomeDate
Typ
date
Beskrivning

Date of outcome

ID
OutcomeDesc
Typ
text
Beskrivning

Description of outcome

ID
amountFined
Typ
float8
Beskrivning

Dollar amount of fine given

Mer information

Fält Värde
Data senast uppdaterad 20 maj 2026
Metadata senast uppdaterad 4 juni 2026
Skapad 20 maj 2026
Format JSON
Licens 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 updateför 19 timmar sedan
Extract jobAirflow: Integration Pipeline dinesafe
Has viewsTrue
Id4df989e6-e9b3-4e98-ba13-5ecfddaa8ae2
Is previewTrue
Package idb6b4f3fb-2e2c-47e7-931d-b87d22806948
Position3
Record count106 410
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