This dataset contains specific comments made in association with observed violations during food service inspections conducted by Fulton County Board of Health environmental health specialists. Each comment cites the code of the violation as documented in the Georgia Department of Public Health Food Service Rules and Regulations and describes the specific observation that was the cause of the violation. A violation may have more than one comment if there were multiple observations that led to the same violation.
This dataset has the following 24 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Inspection ID | inspection_id | text | A unique numeric identifier for the inspection. This is not part of the source inspection data but rather is a number generated in the process of extracting the data from the source. The Inspection ID will be duplicated for each violation in the dataset associated with the same inspection. | 32922 13362 23504 13642 1692 view top 100 |
Item Number | item_number | text | 4-2B 15A 15C 17C 6-1A view top 100 | |
Observations | observations | text | Violation of Code: [511-6-1.04(4)(m)] Wet wiping cloth not stored in sanitizing solution between uses. New Violation. Violation of Code: [511-6-1.03(5)(i)] Observed employee with no hair restraint. New Violation. Violation of Code: [511-6-1.04(6)(g)] Prepared food not marked with date of preparation or date for disposal. New Violation. Violation of Code: [511-6-1.04(4)(q)] Observed food stored on floor. New Violation. Violation of Code: [511-6-1.04(4)(n)2,3,4] Single-use gloves not changed as needed after changing tasks or when damaged or soiled.. New Violation. view top 100 | |
Facility | facility | text | The name of the food service establishment. | Subway American Deli Waffle House McDonald's Dunkin Donuts view top 100 |
Address | address | text | The street number and street name component of the address of the food service establishment. | 931 Monroe DR 2841 Greenbriar PKWY 590 West Peachtree ST NW 3707 Main ST 3393 Peachtree RD view top 100 |
City | city | text | The city component of the address of the food service establishment. | Atlanta Alpharetta Roswell Eastpoint College Park view top 100 |
State | state | text | The state component of the address of the food service establishment. | GA TX view top 100 |
Zipcode | zipcode | text | The zip code component of the address of the food service establishment. | 30303 30308 30309 30318 30344 view top 100 |
Date | date | calendar_date | The date on which the inspection was conducted. | 2019-06-19T00:00:00.000 2018-01-11T00:00:00.000 2018-10-16T00:00:00.000 2019-04-08T00:00:00.000 2019-07-16T00:00:00.000 view top 100 |
Permit Number | permit_number | text | An alphanumeric sequence of characters used to uniquely identify each permit required to operate a food service establishment. | FSP-060-006194 FSP-060-002184 1-30396 FSP-060-004577 FSP-060-002385 view top 100 |
Score | score | number | The overall score (0-100) resulting from the inspection | 90 91 96 95 92 view top 100 |
Grade | grade | text | A letter grade based on the inspection score (A=90-100, B=80-89, C=70-79, U=0-69). | A B C U view top 100 |
Purpose | purpose | text | The purpose of the inspection (Initial, Routine, FollowUp, Temporary) | Routine Followup Initial Issued Provisional Permit Temporary view top 100 |
Risk Type | risk_type | text | A number (1, 2 or 3) indicating the risk of food-borne illness based on the menu items served; the food preparation process performed, and the previous food safety history of the food service establishment. The Risk Type determines the frequency at which the establishment must be inspected. Risk Type 3 represents the highest risk and requires the highest frequency of inspection. Detailed information on risk types can be found at https://dph.georgia.gov/sites/dph.georgia.gov/files/EnvHealth/Food/InterpretationManual/10InterpretationManualInspectionsComplainceProcedures.pdf. | 2 1 3 view top 100 |
Last Score | last_score | text | The overall score (0-100) resulting from the inspection immediately preceding the inspection subject of the record. | 100 90 96 91 95 view top 100 |
Last Grade | last_grade | text | A letter grade based on the inspection immediately preceding the inspection subject of the record. | A B C U view top 100 |
Last Date | last_date | calendar_date | The date of the inspection immediately preceding the inspection subject of the record. | 2017-11-14T00:00:00.000 2018-01-29T00:00:00.000 2019-01-15T00:00:00.000 2017-06-06T00:00:00.000 2018-03-12T00:00:00.000 view top 100 |
Prior Score | prior_score | text | The overall score (0-100) resulting from the inspection prior to the immediately preceding the inspection subject of the record. | 100 96 90 91 view top 100 |
Prior Grade | prior_grade | text | A letter grade based on the score from the inspection prior to the immediately preceding the inspection subject of the record. | A B C U view top 100 |
Prior Date | prior_date | calendar_date | The date of the inspection prior to the inspection immediately preceding the inspection subject of the record. | 2016-02-29T00:00:00.000 2016-02-03T00:00:00.000 2017-06-21T00:00:00.000 2016-08-09T00:00:00.000 2016-04-19T00:00:00.000 view top 100 |
Follow Up Needed | follow_up_needed | checkbox | Indicates whether a followup inspection is required. | false true view top 100 |
Follow Up Date | follow_up_date | calendar_date | The scheduled date of a followup inspection if needed. | 2017-03-24T00:00:00.000 2018-10-26T00:00:00.000 2017-10-30T00:00:00.000 2017-08-28T00:00:00.000 2019-04-18T00:00:00.000 view top 100 |
Date Time In | date_time_in | calendar_date | The date and time of the start of the inspection. | 2019-06-19T10:00:00.000 2020-09-29T12:25:00.000 2019-06-19T13:20:00.000 2017-08-14T13:00:00.000 2017-06-30T11:30:00.000 view top 100 |
Date Time Out | date_time_out | calendar_date | The date and time of the end of the inspection. | 2019-06-19T11:00:00.000 2018-02-14T13:30:00.000 2020-09-29T15:35:00.000 2016-10-06T15:00:00.000 2019-07-16T12:30:00.000 view top 100 |