Data Dictionary

ID
unique_id
Type
text
Aprašymas

Unique id for this record connected to source data

ID
estId
Type
text
Aprašymas

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
Aprašymas

Legacy establishment ID

ID
estName
Type
text
Aprašymas

Establishment Name

ID
address
Type
text
Aprašymas

Address of Establishment

ID
inspectionStatus
Type
text
Aprašymas

Status of the inspection (ex: Pass)

ID
phone
Type
text
Aprašymas

Establishment phone number

ID
inspectionDate
Type
date
Aprašymas

Date of inspection

ID
observation
Type
text
Aprašymas

Observation made during inspection

ID
typeDesc
Type
text
Aprašymas

Category of infraction

ID
deficiencyDesc
Type
text
Aprašymas

Details of infraction

ID
severity
Type
text
Aprašymas

Severity of infraction

ID
OutcomeDate
Type
date
Aprašymas

Date of outcome of prosecution, if there was one

ID
OutcomeDesc
Type
text
Aprašymas

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

ID
amountFined
Type
float8
Aprašymas

Dollar amount of fine given

Papildoma informacija

Laukas Reikšmė
Data last updated 2026 m. birželio 19 d.
Metadata last updated 2026 m. liepos 1 d.
Sukurtas 2026 m. birželio 19 d.
Formatas JSON
Licencija 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 updateprieš 48 minutes
Extract jobAirflow: Integration Pipeline dinesafe
Has viewsTrue
Idad342031-a0eb-4f5e-a2c6-61a499047993
Is previewTrue
Package idb6b4f3fb-2e2c-47e7-931d-b87d22806948
Position4
Record count105 312
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