Data Dictionary

Column Type Label Description
estId int4

Establishment ID
estName text

Establishment Name
addrFull text

Address of Establishment
srvType text

Type of services offered by Establishment
insStatus text

Status of the inspection (ex: Pass)
insDate date

Date of inspection
observation text

Notes on the observations made during inspection
infCategory text

Category of infraction
defDesc text

Description of infraction
infType text

Type of infraction
actionDesc text

Description of action taken
OutcomeDate date

Date of outcome
OutcomeDesc text

Description of outcome
fineAmount int4

Amount of fine given
geometry text

Additional Information

Field Value
Data last updated August 15, 2022
Metadata last updated May 10, 2025
Created August 15, 2022
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': '05f7edf5-df38-4ca8-b46d-fcd40b10c0e6', '2952': '957ffc22-da39-4e69-be2a-20afab551f11'}, 'SHP': {'4326': '33f4cf13-aab0-4dbe-9b6d-be8717367f1d', '2952': 'a17793b4-ccec-4096-972e-93371632755c'}, 'GPKG': {'4326': '6c6dbd9b-9550-4a17-aeaf-1cb5542d9b85', '2952': '77ee9801-eea2-410c-9ab6-ff844904902b'}, 'GEOJSON': {'4326': '9a9fbb34-308f-44d1-bc28-8db99eab8c77'}}
Datastore cache last update6 hours ago
Extract jobAirflow - files_to_datastore.py - bodysafe
Has viewsTrue
Id315f0f9f-cbf0-4b95-b8a5-a4afda0f4ff5
Is previewTrue
Package idc4052ff7-a09d-4eaf-84e6-6669519f413d
Package name or idbodysafe
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - bodysafe
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID