Readme
Updated 12 hours ago
‧ Indexed 5 hours ago
Restaurant Inspections in Tri-County Colorado
Restaruant Inspection data for food service facilities within Adams, Arapahoe, and Douglas counties in Colorado provided by Tri-County Health Department (TCHD).
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
Total Foodborne Illness Risk Violations | total_foodborne_illness_risk | total_foodborne_illness_risk | Number | Total foodborne illness risk violations for inspection codes FC01 - FC29 |
GIS Longitude | gis_longitude | gis_longitude | Number | Longitude of facility selling consumable goods. |
GIS Latitude | gis_latitude | gis_latitude | Number | Latitude of facility selling consumable goods. |
Serial Number | serial_number | serial_number | Text | ID number of the licensed inspection. Corresponds to "InspectionID" in CDPHE database. |
Facility ID | facility_id | facility_id | Text | ID number of the facility selling consumable goods. |
Activity Date | activity_date | activity_date | Calendar date | Date of facility inspection. Corresponds to "InspectionDate" in CDPHE database. |
City | city | city | Text | City of facility selling consumable goods. Corresponds to "FacilityCity" in CDPHE database. |
Record ID | record_id | record_id | Text | |
Site Address | site_address | site_address | Text | Street address of facility selling consumable goods. Corresponds to "FacilityStreetAddress" in CDPHE database. |
Total Good Retail Practices Violations | total_good_retail_practices | total_good_retail_practices | Number | Total good retail practices violations for inspection codes FC30 - FC56 |
FC55 | fc55 | fc55 | Number | Physical facilities installed, maintained, & clean |
FC36 | fc36 | fc36 | Number | Thermometer provided & accurate |
FC12 | fc12 | fc12 | Number | Food received at proper temperature |
FC09 | fc09 | fc09 | Number | No bare hand contact with RTE food or a pre-approved alternative procedure properly allowed |
FC02 | fc02 | fc02 | Number | Certified Food Protection Manager |
Zip | zip | zip | Text | Zip of facility selling consumable goods. Corresponds to "FacilityZip" in CDPHE database. |
FC40 | fc40 | fc40 | Number | Personal cleanliness |
Program Identifier | program_identifier | program_identifier | Text | Name of facility selling consumable goods. Corresponds to "FacilityName" in CDPHE database. |
PE Desc | pe_desc | pe_desc | Text | Building Capacity. |
FC44 | fc44 | fc44 | Number | Utensils, equipment & linens: properly stored, dried, & handled |
St | st | st | Text | State of facility selling consumable goods. Corresponds to "FacilityState" in CDPHE database. |
FC10 | fc10 | fc10 | Number | Adequate handwashing sinks properly supplied and accessible |
PE | pe | pe | Number | Building Capacity. |
FC20 | fc20 | fc20 | Number | Proper cooling time and temperature |
FC16 | fc16 | fc16 | Number | Food contact surfaces; cleaned & sanitized |
FC52 | fc52 | fc52 | Number | Sewage & waste water properly disposed |
FC15 | fc15 | fc15 | Number | Food separated and protected |
FC56 | fc56 | fc56 | Number | Adequate ventilation & lighting; designated areas used |
FC54 | fc54 | fc54 | Number | Garbage & refuse properly disposed; facilities maintained |
FC53 | fc53 | fc53 | Number | Toilet facilities: properly constructed, supplied, & cleaned |
FC51 | fc51 | fc51 | Number | Plumbing installed; proper backflow devices |
FC50 | fc50 | fc50 | Number | Hot & cold water available; adequate pressure |
FC49 | fc49 | fc49 | Number | Non-food contact surfaces clean |
FC48 | fc48 | fc48 | Number | Warewashing facilities: installed, maintained, & used; test strips |
FC47 | fc47 | fc47 | Number | Food & non-food contact surfaces cleanable, properly designed, constructed, & used |
FC46 | fc46 | fc46 | Number | Gloves used properly |
FC45 | fc45 | fc45 | Number | Single-use / single-service articles: properly stored & used |
FC43 | fc43 | fc43 | Number | In-use utensils: properly stored |
FC42 | fc42 | fc42 | Number | Washing fruits & vegetables |
FC41 | fc41 | fc41 | Number | Wiping Cloths; properly used & stored |
FC39 | fc39 | fc39 | Number | Contamination prevented during food preparation, storage & display |
FC38 | fc38 | fc38 | Number | Insects, rodents, & animals not present |
FC37 | fc37 | fc37 | Number | Food properly labeled; original container |
FC35 | fc35 | fc35 | Number | Approved thawing methods used |
FC34 | fc34 | fc34 | Number | Plant food properly cooked for hot holding |
FC33 | fc33 | fc33 | Number | Proper cooling methods used; adequate equipment for temperature control |
FC32 | fc32 | fc32 | Number | Variance obtained for specialized processing methods |
FC31 | fc31 | fc31 | Number | Water & ice from approved source |
FC30 | fc30 | fc30 | Number | Pasteurized eggs used where required |
FC29 | fc29 | fc29 | Number | Compliance with variance / specialized process / HACCP |
FC28 | fc28 | fc28 | Number | Toxic substances properly identified, stored & used |
FC27 | fc27 | fc27 | Number | Food additives: approved & Properly used |
FC26 | fc26 | fc26 | Number | Pasteurized foods used; prohibited foods not offered |
FC25 | fc25 | fc25 | Number | Consumer advisory provided for raw/undercooked food |
FC24 | fc24 | fc24 | Number | Time as a Public Health Control; procedures & records |
FC23 | fc23 | fc23 | Number | Proper date marking and disposition |
FC22 | fc22 | fc22 | Number | Proper cold holding temperatures |
FC21 | fc21 | fc21 | Number | Proper hot holding temperatures |
FC19 | fc19 | fc19 | Number | Proper reheating procedures for hot holding |
FC18 | fc18 | fc18 | Number | Proper cooking time & temperatures |
FC17 | fc17 | fc17 | Number | Proper disposition of returned, previously served, reconditioned & unsafe food |
FC14 | fc14 | fc14 | Number | Required records available: shellstock tags, parasite destruction |
FC13 | fc13 | fc13 | Number | Food in good condition, safe, & unadulterated |
FC11 | fc11 | fc11 | Number | Food obtained from approved source |
FC08 | fc08 | fc08 | Number | Hands clean & properly washed |
FC07 | fc07 | fc07 | Number | No discharge from eyes, nose, and mouth |
FC06 | fc06 | fc06 | Number | Proper eating, tasting, drinking, or tobacco use |
FC04 | fc04 | fc04 | Number | Proper use of restriction and exclusion |
FC03 | fc03 | fc03 | Number | Management, food employee and conditional employee; knowledge, responsibilities and reporting |
FC01 | fc01 | fc01 | Number | Person in charge present, demonstrates knowledge, and performs duties |
Agency | agency | agency | Text | Agency under which operating business is inspected. Corresponds to "Jurisdiction" in CDPHE database. |
County | county | county | Text | County in which inspected business operates. |
Description | description | description | Text | Type of business. Corresponds to "FacilityType" in CDPHE database. |
Category | category | category | Text | Risk category. |
Service Desc. | service_desc | service_desc | Text | Type of inspection. Corresponds to "InspectionType" in CDPHE database. |
FC05 | fc05 | fc05 | Number | Procedures for responding to vomiting and diarrheal events |
Upstream Metadata