This data set is intended to communicate the name of establishment, the physical location of the establishment, the date the inspection was conducted, the overall score for the inspection, and the point deduction for the individual violations. Disclaimer: The inspection data represents a specific period in time. It does not represent the ownership of the establishment or the full history of the establishment.
This dataset has the following 114 columns:
Column Name | API Column Name | Data Type | Description |
---|---|---|---|
Restaurant Name | program_identifier | text | The Program Identifier allows users to add a description for a General Health Program record that identifies one general health program from another. For example, two programs (restaurants) at one facility can have the same Program/Element code (1600 - Food). The PROGRAM_IDENTIFIER field allows users to add a description for differentiating the two (The Moonlight Room and The Laguna Lounge). |
Inspection Date | insp_date | calendar_date | Date the inspection for the facility was performed. |
Inspection Score | score | number | The aggregate score from the inspection violations. Please note not every violation will reflect a point deduction as establishments are allowed to correct violations during the inspection process, and therefore no reduction in the overall score is reflected for the violation. |
Inspection Type | type | text | Code indicating the inspection type, such as Routine, Follow-up, Complaint, Temporary and Mobile. • Routine Inspections – are conducted at least once every six months • Follow-up Inspections – are conducted as a result of poor sanitation issues, low scores • Complaints Inspections – General Sanitation/Hygienic Practices /Illness Investigation, Smoking and Other • Temporary – the City of Dallas Office of Special Events provides a listing of public events being held involving food and the Consumer Health Division provides guidance and inspects • Mobile – the various mobile food units are inspected annually with random inspections conducted during the year |
Street Address | site_address | text | Full street address of the facility. |
Zip Code | zip | text | Zip Code of the facility's address. |
Street Number | street_number | number | Street number for the address of the facility. |
Street Name | street_name | text | Street name for the address of the facility. |
Street Direction | street_direction | text | Street direction for the address of the facility. For example, N, W, S, etc. |
Street Type | street_type | text | Street type for the address of the facility. For example, AVE, LN, ST, etc. |
Street Unit | street_unit | text | Unit number or apartment number for the address of the facility. |
Violation Description - 1 | violation1_description | text | A brief description of the violation. |
Violation Points - 1 | violation1_points | number | The amount of points assigned to this violation. |
Violation Detail - 1 | violation1_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 1 | violation1_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 2 | violation2_description | text | A brief description of the violation. |
Violation Points - 2 | violation2_points | number | The amount of points assigned to this violation. |
Violation Detail - 2 | violation2_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 2 | violation2_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 3 | violation3_description | text | A brief description of the violation. |
Violation Points - 3 | violation3_points | number | The amount of points assigned to this violation. |
Violation Detail - 3 | violation3_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 3 | violation3_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 4 | violation4_description | text | A brief description of the violation. |
Violation Points - 4 | violation4_points | number | The amount of points assigned to this violation. |
Violation Detail - 4 | violation4_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 4 | violation4_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 5 | violation5_description | text | A brief description of the violation. |
Violation Points - 5 | violation5_points | number | The amount of points assigned to this violation. |
Violation Detail - 5 | violation5_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 5 | violation5_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 6 | violation6_description | text | A brief description of the violation. |
Violation Points - 6 | violation6_points | number | The amount of points assigned to this violation. |
Violation Detail - 6 | violation6_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 6 | violation6_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 7 | violation7_description | text | A brief description of the violation. |
Violation Points - 7 | violation7_points | number | The amount of points assigned to this violation. |
Violation Detail - 7 | violation7_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 7 | violation7_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 8 | violation8_description | text | A brief description of the violation. |
Violation Points - 8 | violation8_points | number | The amount of points assigned to this violation. |
Violation Detail - 8 | violation8_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 8 | violation8_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 9 | violation9_description | text | A brief description of the violation. |
Violation Points - 9 | violation9_points | number | The amount of points assigned to this violation. |
Violation Detail - 9 | violation9_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 9 | violation9_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 10 | violation10_description | text | A brief description of the violation. |
Violation Points - 10 | violation10_points | number | The amount of points assigned to this violation. |
Violation Detail - 10 | violation10_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 10 | violation10_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 11 | violation11_description | text | A brief description of the violation. |
Violation Points - 11 | violation11_points | number | The amount of points assigned to this violation. |
Violation Detail - 11 | violation11_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 11 | violation11_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 12 | violation12_description | text | A brief description of the violation. |
Violation Points - 12 | violation12_points | number | The amount of points assigned to this violation. |
Violation Detail - 12 | violation12_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 12 | violation12_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 13 | violation13_description | text | A brief description of the violation. |
Violation Points - 13 | violation13_points | number | The amount of points assigned to this violation. |
Violation Detail - 13 | violation13_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 13 | violation13_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 14 | violation14_description | text | A brief description of the violation. |
Violation Points - 14 | violation14_points | number | The amount of points assigned to this violation. |
Violation Detail - 14 | violation14_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 14 | violation14_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 15 | violation15_description | text | A brief description of the violation. |
Violation Points - 15 | violation15_points | number | The amount of points assigned to this violation. |
Violation Detail - 15 | violation15_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 15 | violation15_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 16 | violation16_description | text | A brief description of the violation. |
Violation Points - 16 | violation16_points | number | The amount of points assigned to this violation. |
Violation Detail - 16 | violation16_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 16 | violation16_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 17 | violation17_description | text | A brief description of the violation. |
Violation Points - 17 | violation17_points | number | The amount of points assigned to this violation. |
Violation Detail - 17 | violation17_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 17 | violation17_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 18 | violation18_description | text | A brief description of the violation. |
Violation Points - 18 | violation18_points | number | The amount of points assigned to this violation. |
Violation Detail - 18 | violation18_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 18 | violation18_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 19 | violation19_description | text | A brief description of the violation. |
Violation Points - 19 | violation19_points | number | The amount of points assigned to this violation. |
Violation Detail - 19 | violation19_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 19 | violation19_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 20 | violation20_description | text | A brief description of the violation. |
Violation Points - 20 | violation20_points | number | The amount of points assigned to this violation. |
Violation Detail - 20 | violation20_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 20 | violation20_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 21 | violation21_description | text | A brief description of the violation. |
Violation Points - 21 | violation21_points | number | The amount of points assigned to this violation. |
Violation Detail - 21 | violation21_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 21 | violation21_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 22 | violation22_description | text | A brief description of the violation. |
Violation Points - 22 | violation22_points | number | The amount of points assigned to this violation. |
Violation Detail - 22 | violation22_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 22 | violation22_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 23 | violation23_description | text | A brief description of the violation. |
Violation Points - 23 | violation23_points | number | The amount of points assigned to this violation. |
Violation Detail - 23 | violation23_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 23 | violation23_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 24 | violation24_description | text | A brief description of the violation. |
Violation Points - 24 | violation24_points | number | The amount of points assigned to this violation. |
Violation Detail - 24 | violation24_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 24 | violation24_memo | text | This field is used for any additional comments about the enforcement action. |
Violation Description - 25 | violation25_description | text | A brief description of the violation. |
Violation Points - 25 | violation25_points | number | The amount of points assigned to this violation. |
Violation Detail - 25 | violation25_text | text | Field used to describe the type of violation associated with the enforcement action. |
Violation Memo - 25 | violation25_memo | text | This field is used for any additional comments about the enforcement action. |
Inspection Month | month | text | Added column to improve visualization of inspections by month |
Inspection Year | inspection_year | text | Added column to improve visualization of inspections for specific fiscal years |
Lat Long Location | lat_long | location | Denotes a location point on a longitude line (perpendicular to the equator) and latitude line (parallel to the equator) |