sonomacounty-ca-gov/food-facility-inspections-8r44-w5qd
Icon for Socrata external plugin
 
Readme
Updated 8 hours ago
Indexed 29 minutes ago

Food Facility Inspections

The Sonoma County Department of Health Services Food Facility inspection data. Food safety and consumer protection programs provided by the Department of Health Services serve many food facilities, such as restaurants, caterers, mobile units, grocery stores, wineries, or any facility selling food directly to the consumer.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Location (city)location_citylocation_cityText
Location (zip)location_ziplocation_zipText
ViolationDescriptionsviolationdescriptionsviolationdescriptionsTextThe description of the violation(s) found during an inspection.
Location (state)location_statelocation_stateText
LocationlocationlocationPointThe address where the inspection was performed.
ZipCodezipcodezipcodeText
PhoneNumberphonenumberphonenumberText
AddressaddressaddressText
Location (address)location_addresslocation_addressText
ViolationCodesviolationcodesviolationcodesTextCodes used by Health Services to identify a violation type.
NamenamenameTextFood facility name
CitycitycityText
InspectionIdinspectionidinspectionidTextThe unique identifier Health Services uses to identify an inspection.
DatedatedateCalendar dateThe date of the inspection.
InspectionTypeinspectiontypeinspectiontypeText
StatestatestateText
BusinessIdbusinessidbusinessidTextThe unique identifier Health Services uses to identify a business.
Census Tract Boundary:@computed_region_xw9s_pz78:@computed_region_xw9s_pz78Number
Zip Codes:@computed_region_dig5_f3vy:@computed_region_dig5_f3vyNumber
 
Preview
  • food_facility_inspections
     
Upstream Metadata