fultoncountyga-gov/food-service-inspections-w896-7wba

  • food
  • inspection
  • score
  • service

Food Service Inspections

Food Service Inspections

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Follow Up Neededfollow_up_neededfollow_up_neededCheckboxIndicates whether a followup inspection is required.
Date Time Outdate_time_outdate_time_outCalendar dateThe date and time of the end of the inspection.
CitycitycityTextThe city component of the address of the food service establishment.
DatedatedateCalendar dateThe date on which the inspection was conducted.
AddressaddressaddressTextThe street number and street name component of the address of the food service establishment.
GradegradegradeTextA letter grade based on the inspection score (A=90-100, B=80-89, C=70-79, U=0-69).
Prior Gradeprior_gradeprior_gradeTextA letter grade based on the score from the inspection prior to the immediately preceding the inspection subject of the record.
StatestatestateTextThe state component of the address of the food service establishment.
Lat Longgeocoded_columngeocoded_columnPoint
Last Gradelast_gradelast_gradeTextA letter grade based on the inspection immediately preceding the inspection subject of the record.
PurposepurposepurposeTextThe purpose of the inspection (Initial, Routine, FollowUp, Temporary)
Follow Up Datefollow_up_datefollow_up_dateCalendar dateThe scheduled date of a followup inspection if needed.
Last Datelast_datelast_dateCalendar dateThe date of the inspection immediately preceding the inspection subject of the record.
Permit Numberpermit_numberpermit_numberTextAn alphanumeric sequence of characters used to uniquely identify each permit required to operate a food service establishment.
Date Time Indate_time_indate_time_inCalendar dateThe date and time of the start of the inspection.
Prior Scoreprior_scoreprior_scoreTextThe overall score (0-100) resulting from the inspection prior to the immediately preceding the inspection subject of the record.
Last Scorelast_scorelast_scoreTextThe overall score (0-100) resulting from the inspection immediately preceding the inspection subject of the record.
FacilityfacilityfacilityTextThe name of of the food service establishment.
ZipcodezipcodezipcodeTextThe zip code component of the address of the food service establishment.
Prior Dateprior_dateprior_dateCalendar dateThe date of the inspection prior to the inspection immediately preceding the inspection subject of the record.
Risk Typerisk_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.
ScorescorescoreNumberThe overall score (0-100) resulting from the inspection
Inspection IDinspection_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.

Upstream Metadata