Data Dictionary

Column Type Label Description
id text ID

System generated ID

facility_name text Facility name

Name of the food facility

num text House number

Street address number of the facility

street text Street name

Street name facility is located on

city text City

Address level city facility is located in

state text State

State facility is located in

zip text ZIP code

ZIP code facility is located in

municipal text Municipality

Municipality facility is located in

category_cd text Category code

Facility category code

description text Category description

Facility category description

p_code text
fdo date First day of operation

First day of operation

bus_st_date date Business start date

Business start date

bus_cl_date date Business close date

Business close date

seat_count int4 Seat count

Number of seats in facility

noroom int4 Number of rooms

Number of rooms in facility

sq_feet int4 Area (ft^2)

Number of square feet in facility

status text Status

Facility current status: * 8 Pending * 0 Inactive * 1 Active (open) * 2 Seasonal * 3 Temporary * 4 Transient * 5 Consumer Alert * 6 Administrative Closure * 7 Out of Business (closed) * 9 Pre-Operational

placard_st text
x float8 Longitude

Geocoded longitude of the facility

y float8 Latitide

Geocoded latitude of the facility

address text Full address

Full address for the facility

Additional Information

Field Value
Data last updated November 24, 2024
Metadata last updated November 24, 2024
Created August 22, 2018
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Hash298f68737e46f47c9bc25781b51590bf
Id112a3821-334d-4f3f-ab40-4de1220b1a0a
Package id8744b4f6-5525-49be-9054-401a2c4c2fac
Position2
PreviewTrue
Preview rows0
Size2.5 MiB
Stateactive
Total record count1
Url typedatapusher