Primary tabs

Inspection Violations of Failed Restaurants

A list of the violations recorded against permitted restaurants that failed inspection.
Data Dictionary:
EstablishmentID - Permit Number
InspectionDate - date of inspection
InspectionID - system inspection id
EstTypeDesc - desciption of facility type
premise_name - facility name
premise_adr1_num - facility street number
premise_adr1_street - facility street
premise_city - facility city
premise_state - facility state
premise_zip - facility zip code
InspectionType - description of inspection type
score - inspection score
InspTypeSpecificViolID - Violation ID for specific type of facility
ViolationDesc - text description of violation
critical_yn - Is the violation critical?
Insp_Viol_Comments - violation comments
rpt_area_id - Establishment Type Code

Data Preview: Note that by default the preview only displays up to 100 records. Use the pager to flip through more records or adjust the start and end fields to display the number of records you wish to see.

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

6 + 4 = Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.