Food Service Inspections

data.fultoncountyga.gov | Last Updated 12 Feb 2019

This dataset contains records of food service inspections conducted by the Environmental Health Services Division of the the Fulton County Board of Health, which is responsible for the regulation of establishments where food is served to the public within Fulton County. Inspections are conducted for the purpose of assuring proper sanitation practices that minimize hazards from cross-contamination, improper cooking, handling, and temperature maintenance of foods, potable water contamination, improper garbage and refuse disposal, and poor insect and rodent control. This dataset is related to the following datasets: Food Service Violations, Food Service Violation Comments and Food Service Temperature Violations.

Tags: food, service, inspection, score

This dataset has the following 22 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Inspection IDinspection_idtextA unique numeric record identifier. 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.
FacilityfacilitytextThe name of of the food service establishment.
AddressaddresstextThe street number and street name component of the address of the food service establishment.
CitycitytextThe city component of the address of the food service establishment.
StatestatetextThe state component of the address of the food service establishment.
ZipcodezipcodetextThe zip code component of the address of the food service establishment.
Datedatecalendar_dateThe date on which the inspection was conducted.
Permit Numberpermit_numbertextAn alphanumeric sequence of characters used to uniquely identify each permit required to operate a food service establishment.
ScorescorenumberThe overall score (0-100) resulting from the inspection
GradegradetextA letter grade based on the inspection score (A=90-100, B=80-89, C=70-79, U=0-69).
PurposepurposetextThe purpose of the inspection (Initial, Routine, FollowUp, Temporary)
Risk Typerisk_typetextA 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.
Last Scorelast_scoretextThe overall score (0-100) resulting from the inspection immediately preceding the inspection subject of the record.
Last Gradelast_gradetextA letter grade based on the inspection immediately preceding the inspection subject of the record.
Last Datelast_datecalendar_dateThe date of the inspection immediately preceding the inspection subject of the record.
Prior Scoreprior_scoretextThe overall score (0-100) resulting from the inspection prior to the immediately preceding the inspection subject of the record.
Prior Gradeprior_gradetextA letter grade based on the score from the inspection prior to the immediately preceding the inspection subject of the record.
Prior Dateprior_datecalendar_dateThe date of the inspection prior to the inspection immediately preceding the inspection subject of the record.
Follow Up Neededfollow_up_neededcheckboxIndicates whether a followup inspection is required.
Follow Up Datefollow_up_datecalendar_dateThe scheduled date of a followup inspection if needed.
Date Time Indate_time_incalendar_dateThe date and time of the start of the inspection.
Date Time Outdate_time_outcalendar_dateThe date and time of the end of the inspection.