Data Dictionary

Column Type Label Description
encounter text

Identifier for distinct inspection

id text

Identifier for distinct restaurant

placard_st text

Inspection Result

placard_desc text

Inspection Result Description

facility_name text

Name of facility

bus_st_date date

Business start date

category_cd text

Facility category code (see description)

description text

Type of facility e.g. Restaurant with Liquor, Church Kitchen, etc.

num text

Street number of facility

street text

Street address of facility

city text

Mailing city of facility

state text

State of the facility

zip float8

Zip code of the city

inspect_dt date

Date of inspection

start_time time

Start time of inspection

end_time time

End time of inspection

municipal text


ispt_purpose text

Purpose Code

abrv text

Purpose Abbreviation

purpose text Purpose

Initial, Remodel, etc

reispt_cd text Reinspection needed?


reispt_dt date

Target rei-nspection date

status text Facility status
  • 8 Pending
  • 0 Inactive
  • 1 Active
  • 2 Seasonal
  • 3 Temporary
  • 4 Transient
  • 5 Consumer Alert
  • 6 Administrative Closure
  • 7 Out of Business
  • 9 Pre-Operational

Additional Information

Field Value
Data last updated July 18, 2024
Metadata last updated July 18, 2024
Created August 22, 2022
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Package id8744b4f6-5525-49be-9054-401a2c4c2fac
Revision id2f40c27f-35bf-4186-b141-24fa5fa2e713
Url typedatapusher