Restaruant Inspection data for food service facilities within Adams, Arapahoe, and Douglas counties in Colorado provided by Tri-County Health Department (TCHD).
This dataset has the following 76 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Facility ID | facility_id | text | ID number of the facility selling consumable goods. | FA0003078 FA0000488 FA0010527 FA0004116 FA0005901 view top 100 |
| Record ID | record_id | text | PR0004363 PR0003225 PR0001095 PR0004488 PR0008304 view top 100 | |
| Serial Number | serial_number | text | ID number of the licensed inspection. Corresponds to "InspectionID" in CDPHE database. | DA36XE8ZE DACHJ8Q9V DAHESYJDB DASGISPGW DALFI00FN view top 100 |
| Service Desc. | service_desc | text | Type of inspection. Corresponds to "InspectionType" in CDPHE database. | Inspection, Routine Inspection, Routine (Enforcement) view top 100 |
| PE | pe | number | Building Capacity. | 1025 1045 1007 1065 1005 view top 100 |
| PE Desc | pe_desc | text | Building Capacity. | Restaurant (0 - 100 seats) Restaurant (101 - 200 seats) Limited Food Service (convenience, other) Restaurant (>200 seats) No fee license (K-12 schools, non-profit) view top 100 |
| Category | category | text | Risk category. | Med Risk (3) Low Risk (2) Very Low Risk (1) High Risk (4) view top 100 |
| Description | description | text | Type of business. Corresponds to "FacilityType" in CDPHE database. | Food - Restaurants Food - Grocery Food - Institutions Food - Other view top 100 |
| County | county | text | County in which inspected business operates. | Arapahoe Adams Douglas view top 100 |
| Agency | agency | text | Agency under which operating business is inspected. Corresponds to "Jurisdiction" in CDPHE database. | Tri-County Health Department view top 100 |
| Program Identifier | program_identifier | text | Name of facility selling consumable goods. Corresponds to "FacilityName" in CDPHE database. | Chipotle Mexican Grill McDonalds Subway Subway Sandwiches and Salads Noodles and Company view top 100 |
| Site Address | site_address | text | Street address of facility selling consumable goods. Corresponds to "FacilityStreetAddress" in CDPHE database. | 8801 Pecos St 6000 Victory Way 6700 N Gaylord Rockies Blvd 650 Perry Park Ave 7007 E 88th Ave view top 100 |
| City | city | text | City of facility selling consumable goods. Corresponds to "FacilityCity" in CDPHE database. | Aurora Thornton Westminster Parker Castle Rock view top 100 |
| St | st | text | State of facility selling consumable goods. Corresponds to "FacilityState" in CDPHE database. | CO SD view top 100 |
| Zip | zip | text | Zip of facility selling consumable goods. Corresponds to "FacilityZip" in CDPHE database. | 80260-5038 80022-4203 80019-2198 80118-8246 80640-8214 view top 100 |
| GIS Latitude | gis_latitude | number | Latitude of facility selling consumable goods. | 39.856339 39.975899 39.595147 39.81754265 39.2286273 view top 100 |
| GIS Longitude | gis_longitude | number | Longitude of facility selling consumable goods. | -104.9778 -104.8099 -104.866 -104.9066 -104.8659 view top 100 |
| Activity Date | activity_date | calendar_date | Date of facility inspection. Corresponds to "InspectionDate" in CDPHE database. | 2020-02-05T00:00:00.000 2020-02-10T00:00:00.000 2019-02-13T00:00:00.000 2019-10-31T00:00:00.000 2020-02-26T00:00:00.000 view top 100 |
| FC01 | fc01 | number | Person in charge present, demonstrates knowledge, and performs duties | 0 1 view top 100 |
| FC02 | fc02 | number | Certified Food Protection Manager | 0 1 3 view top 100 |
| FC03 | fc03 | number | Management, food employee and conditional employee; knowledge, responsibilities and reporting | 0 1 view top 100 |
| FC04 | fc04 | number | Proper use of restriction and exclusion | 0 1 view top 100 |
| FC05 | fc05 | number | Procedures for responding to vomiting and diarrheal events | 0 1 view top 100 |
| FC06 | fc06 | number | Proper eating, tasting, drinking, or tobacco use | 0 1 view top 100 |
| FC07 | fc07 | number | No discharge from eyes, nose, and mouth | 0 1 view top 100 |
| FC08 | fc08 | number | Hands clean & properly washed | 0 1 view top 100 |
| FC09 | fc09 | number | No bare hand contact with RTE food or a pre-approved alternative procedure properly allowed | 0 1 view top 100 |
| FC10 | fc10 | number | Adequate handwashing sinks properly supplied and accessible | 0 1 view top 100 |
| FC11 | fc11 | number | Food obtained from approved source | 0 1 2 view top 100 |
| FC12 | fc12 | number | Food received at proper temperature | 0 1 view top 100 |
| FC13 | fc13 | number | Food in good condition, safe, & unadulterated | 0 1 view top 100 |
| FC14 | fc14 | number | Required records available: shellstock tags, parasite destruction | 0 1 view top 100 |
| FC15 | fc15 | number | Food separated and protected | 0 1 view top 100 |
| FC16 | fc16 | number | Food contact surfaces; cleaned & sanitized | 0 1 view top 100 |
| FC17 | fc17 | number | Proper disposition of returned, previously served, reconditioned & unsafe food | 0 1 view top 100 |
| FC18 | fc18 | number | Proper cooking time & temperatures | 0 1 view top 100 |
| FC19 | fc19 | number | Proper reheating procedures for hot holding | 0 1 view top 100 |
| FC20 | fc20 | number | Proper cooling time and temperature | 0 1 view top 100 |
| FC21 | fc21 | number | Proper hot holding temperatures | 0 1 2 view top 100 |
| FC22 | fc22 | number | Proper cold holding temperatures | 0 1 view top 100 |
| FC23 | fc23 | number | Proper date marking and disposition | 0 1 view top 100 |
| FC24 | fc24 | number | Time as a Public Health Control; procedures & records | 0 1 view top 100 |
| FC25 | fc25 | number | Consumer advisory provided for raw/undercooked food | 0 1 view top 100 |
| FC26 | fc26 | number | Pasteurized foods used; prohibited foods not offered | 0 1 view top 100 |
| FC27 | fc27 | number | Food additives: approved & Properly used | 0 1 view top 100 |
| FC28 | fc28 | number | Toxic substances properly identified, stored & used | 0 1 view top 100 |
| FC29 | fc29 | number | Compliance with variance / specialized process / HACCP | 0 1 view top 100 |
| Total Foodborne Illness Risk Violations | total_foodborne_illness_risk | number | Total foodborne illness risk violations for inspection codes FC01 - FC29 | 0 1 2 3 4 view top 100 |
| FC30 | fc30 | number | Pasteurized eggs used where required | 0 1 view top 100 |
| FC31 | fc31 | number | Water & ice from approved source | 0 1 view top 100 |
| FC32 | fc32 | number | Variance obtained for specialized processing methods | 0 1 view top 100 |
| FC33 | fc33 | number | Proper cooling methods used; adequate equipment for temperature control | 0 1 view top 100 |
| FC34 | fc34 | number | Plant food properly cooked for hot holding | 0 1 view top 100 |
| FC35 | fc35 | number | Approved thawing methods used | 0 1 view top 100 |
| FC36 | fc36 | number | Thermometer provided & accurate | 0 1 view top 100 |
| FC37 | fc37 | number | Food properly labeled; original container | 0 1 view top 100 |
| FC38 | fc38 | number | Insects, rodents, & animals not present | 0 1 view top 100 |
| FC39 | fc39 | number | Contamination prevented during food preparation, storage & display | 0 1 view top 100 |
| FC40 | fc40 | number | Personal cleanliness | 0 1 view top 100 |
| FC41 | fc41 | number | Wiping Cloths; properly used & stored | 0 1 view top 100 |
| FC42 | fc42 | number | Washing fruits & vegetables | 0 1 view top 100 |
| FC43 | fc43 | number | In-use utensils: properly stored | 0 1 view top 100 |
| FC44 | fc44 | number | Utensils, equipment & linens: properly stored, dried, & handled | 0 1 view top 100 |
| FC45 | fc45 | number | Single-use / single-service articles: properly stored & used | 0 1 view top 100 |
| FC46 | fc46 | number | Gloves used properly | 0 1 view top 100 |
| FC47 | fc47 | number | Food & non-food contact surfaces cleanable, properly designed, constructed, & used | 0 1 view top 100 |
| FC48 | fc48 | number | Warewashing facilities: installed, maintained, & used; test strips | 0 1 view top 100 |
| FC49 | fc49 | number | Non-food contact surfaces clean | 0 1 view top 100 |
| FC50 | fc50 | number | Hot & cold water available; adequate pressure | 0 1 view top 100 |
| FC51 | fc51 | number | Plumbing installed; proper backflow devices | 0 1 view top 100 |
| FC52 | fc52 | number | Sewage & waste water properly disposed | 0 1 view top 100 |
| FC53 | fc53 | number | Toilet facilities: properly constructed, supplied, & cleaned | 0 1 view top 100 |
| FC54 | fc54 | number | Garbage & refuse properly disposed; facilities maintained | 0 1 view top 100 |
| FC55 | fc55 | number | Physical facilities installed, maintained, & clean | 0 1 view top 100 |
| FC56 | fc56 | number | Adequate ventilation & lighting; designated areas used | 0 1 view top 100 |
| Total Good Retail Practices Violations | total_good_retail_practices | number | Total good retail practices violations for inspection codes FC30 - FC56 | 0 1 2 3 4 view top 100 |