In the data specs and layout it says that the field INSPECTION_VISIT_ID is unique but I found 3 duplicated data, which has different dates for them, and one of them has a different violations result. Well it's nothing compared to a 500k+ database. But I'm just keeping track of it here.
Data image preview:
![image](https://cloud.githubusercontent.com/assets/6147142/16901944/3dbbd4e8-4c1f-11e6-9b7c-33bb8fdffb7e.png)
Raw data:
Fields order:
district county_number county_name license_type_code license_number business_name location_address location_city location_zipcode inspection_number visit_number inspection_class inspection_type inspection_disposition inspection_date critical_violations_before_2013 noncritical_violations_before_2013 total_violations high_priority_violations intermediate_violations basic_violations pda_status violation_01 violation_02 violation_03 violation_04 violation_05 violation_06 violation_07 violation_08 violation_09 violation_10 violation_11 violation_12 violation_13 violation_14 violation_15 violation_16 violation_17 violation_18 violation_19 violation_20 violation_21 violation_22 violation_23 violation_24 violation_25 violation_26 violation_27 violation_28 violation_29 violation_30 violation_31 violation_32 violation_33 violation_34 violation_35 violation_36 violation_37 violation_38 violation_39 violation_40 violation_41 violation_42 violation_43 violation_44 violation_45 violation_46 violation_47 violation_48 violation_49 violation_50 violation_51 violation_52 violation_53 violation_54 violation_55 violation_56 violation_57 violation_58 license_id inspection_visit_id
'D2','60','Palm Beach','2010','6012903','CRAZY BUFFET','2030 PALM BEACH LAKES BLVD','WEST PALM BEACH','33409','2261347','2','Food','Complaint Full','Call Back - Admin. complaint recommended','2013-03-12',NULL,NULL,'20','3','7','10','1','0','2','3','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','2','0','0','0','0','0','0','2','0','3','2','1','0','0','3','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','5458444','4853712'
'D2','60','Palm Beach','2010','6012903','CRAZY BUFFET','2030 PALM BEACH LAKES BLVD','WEST PALM BEACH','33409','2261347','2','Food','Complaint Full','Admin. Complaint Callback Not Complied','2014-03-11',NULL,NULL,'28','6','8','14','1','0','2','3','0','0','0','0','2','0','3','0','1','0','0','0','0','0','0','0','0','0','4','0','1','0','0','0','0','2','0','3','2','1','0','0','3','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','5458444','4853712'
'D2','16','Broward','2010','1601657','BONAVENTURE COUNTRY CLUB','200 BONAVENTURE BLVD','WESTON','33326','2264876','2','Food','Complaint Full','Call Back - Admin. complaint recommended','2013-05-24',NULL,NULL,'11','0','3','8','1','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','2','1','0','0','0','1','0','0','0','1','0','0','0','0','4','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2137340','4885503'
'D2','16','Broward','2010','1601657','BONAVENTURE COUNTRY CLUB','200 BONAVENTURE BLVD','WESTON','33326','2264876','2','Food','Complaint Full','Call Back - Complied','2013-12-04',NULL,NULL,'11','0','3','8','1','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','2','1','0','0','0','1','0','0','0','1','0','0','0','0','4','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2137340','4885503'
'D5','65','St. Johns','2010','6500464','SCARLETT'S ST AUGGY & DOS GATOS ST AUGGY','70 HYPOLITA ST','SAINT AUGUSTINE','32084','2477216','2','Food','Routine - Food','Call Back - Admin. complaint recommended','2015-06-15',NULL,NULL,'1','0','1','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','6032700','5557390'
'D5','65','St. Johns','2010','6500464','SCARLETT'S ST AUGGY & DOS GATOS ST AUGGY','70 HYPOLITA ST','SAINT AUGUSTINE','32084','2477216','2','Food','Routine - Food','Call Back - Complied','2016-01-20',NULL,NULL,'1','0','1','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','6032700','5557390'