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

Municipality

ispt_purpose text

Purpose Code

abrv text

Purpose Abbreviation

purpose text Purpose

Initial, Remodel, etc

reispt_cd text Reinspection needed?

1=yes

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 June 16, 2024
Metadata last updated June 16, 2024
Created unknown
Format CSV
License Creative Commons CCZero
Created2 years ago
Media typetext/csv
Datastore activeTrue
Has viewsTrue
Id4ea730d8-2bf9-4783-b0a5-b41ed687097e
Package id8744b4f6-5525-49be-9054-401a2c4c2fac
Position1
Revision id2f40c27f-35bf-4186-b141-24fa5fa2e713
Stateactive
Url typedatapusher