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