Restaurant Inspection results by county and facility.
This dataset has the following 13 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Organization Name | organization_name | text | Inspection Jurisdiction | PENNSYLVANIA DEPARTMENT OF AGRICULTURE Chester County Health Department City of Philadelphia Allentown City Lancaster City view top 100 |
Active Indicator | active_indicator | text | Valid values are O and 1. 1 means Active. | Yes No ERIE view top 100 |
Public Facility Name | public_facility_name | text | Facility Being Inspected | SUBWAY DUNKIN DONUTS DOMINO'S PIZZA FOX'S PIZZA DEN KENTUCKY FRIED CHICKEN view top 100 |
Program Group Type | program_group_type | text | valid values Food, Chester County Food | Food ChesterCountyFood 16565 view top 100 |
Address | address | text | Facility Being Inspected address | 334 CARLISLE AVE 2300 N CAMERON ST 120 N DUKE ST 120 N Duke ST Special Events view top 100 |
City | city | text | Facility Being Inspected city | Philadelphia Allentown Lancaster West Chester Harrisburg view top 100 |
County Name | county_name | text | Facility Being Inspected county | Chester Lancaster Lehigh Philadelphia Westmoreland view top 100 |
Zip Code | zip_code | text | Facility Being Inspected zip code | 17603 18102 17602 17201 17815 view top 100 |
State | state | text | Facility Being Inspected state | PA DE OH NY MD view top 100 |
Inspection Date | inspection_date | calendar_date | Facility Being Inspected Date of Inspection | 2019-09-23T00:00:00.000 2018-08-20T00:00:00.000 2018-09-24T00:00:00.000 2018-09-25T00:00:00.000 2018-08-16T00:00:00.000 view top 100 |
Inspection Reason Type | inspection_reason_type | text | valid Values: 2nd Follow Up 3rd Follow Up Annual Change of Owner Complaint Consultation Emergency Response Follow-up Food born Investigation Opening Regular School Meal Program Type 2 Follow-up Type 3 Follow-up | Regular Follow-up Opening Complaint Change of Owner view top 100 |
Overall Compliance | overall_compliance | text | Valid values of Yes or No | Yes No view top 100 |
Georeferenced Latitude and Longitude | geocoded_column | point | A georeferenced Latitude & Longitude point within the county calculated from the address. These points can be used to create visualizations such as maps to show the data by county. | {"coordinates":[-76.754393,39.959633],"type":"Point"} {"coordinates":[-76.882105,40.288333],"type":"Point"} {"coordinates":[-76.304033,40.040348],"type":"Point"} {"coordinates":[-76.306889,40.038584],"type":"Point"} {"coordinates":[-76.669043,40.289667],"type":"Point"} view top 100 |