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 update15 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