{"current_page":1,"data":[{"id":12316838,"change_date":"2026-06-29 21:42:00","inspection_id":"88274625","dot_number":"86872","report_state":"MS","report_number":"2012013943","insp_date":"2026-06-29 00:00:00","insp_start_time":"0705","insp_end_time":"0717","registration_date":null,"region":"CT","ci_status_code":"C","location":"54","location_desc":"PANOLA COUNTY","county_code_state":"MS","county_code":"107","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1155181","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-06-29 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:44.000000Z","updated_at":"2026-07-03T09:40:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":12164713,"change_date":"2026-06-11 21:42:00","inspection_id":"88114790","dot_number":"86872","report_state":"MS","report_number":"2012013913","insp_date":"2026-06-11 00:00:00","insp_start_time":"0729","insp_end_time":"0757","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL","shipping_paper_number":"59789","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1152966","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-06-11 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-06-11 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:39.000000Z","updated_at":"2026-06-22T09:31:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":12154709,"change_date":"2026-06-30 21:40:00","inspection_id":"88104246","dot_number":"86872","report_state":"MS","report_number":"7645014003","insp_date":"2026-06-09 00:00:00","insp_start_time":"0938","insp_end_time":"1057","registration_date":"2026-06-17 00:00:00","region":"CD","ci_status_code":"C","location":"57","location_desc":"MS","county_code_state":"MS","county_code":"113","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","shipping_paper_number":"291160","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"4","hazmat_oos_total":"0","snet_sequence_id":"3654155","transaction_code":"C","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:37.000000Z","updated_at":"2026-07-03T09:41:04.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":12154506,"change_date":"2026-06-10 21:45:00","inspection_id":"88103978","dot_number":"86872","report_state":"MS","report_number":"0202100497","insp_date":"2026-06-09 00:00:00","insp_start_time":"1313","insp_end_time":"1348","registration_date":null,"region":"CT","ci_status_code":"C","location":"B-99","location_desc":"NESBIT SCALE I-55 NORTH","county_code_state":"MS","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"291136","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-10 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1152634","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-06-10 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:37.000000Z","updated_at":"2026-06-21T09:32:09.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":11875940,"change_date":"2026-05-11 21:39:00","inspection_id":"87813253","dot_number":"86872","report_state":"MS","report_number":"2012013829","insp_date":"2026-04-18 00:00:00","insp_start_time":"0702","insp_end_time":"0714","registration_date":null,"region":"CT","ci_status_code":"C","location":"54","location_desc":"PANOLA COUNTY","county_code_state":"MS","county_code":"107","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL","shipping_paper_number":"290119","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147313","transaction_code":"A","transaction_date":"2026-04-18 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-05-07 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-05-11 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:28.000000Z","updated_at":"2026-05-22T09:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21338433,"change_date":null,"inspection_id":"87813253","insp_unit_id":"sms-backfill-790319277-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3249057","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR1NN150433","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"},{"id":21342868,"change_date":null,"inspection_id":"87813253","insp_unit_id":"sms-backfill-790319277-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469950","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9626FB707894","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11280667,"change_date":"2026-03-04 21:40:00","inspection_id":"87195322","dot_number":"86872","report_state":"LA","report_number":"LAETS00393","insp_date":"2026-03-02 00:00:00","insp_start_time":"0828","insp_end_time":"0919","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SPRINGFIELD LA","county_code_state":"LA","county_code":null,"insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPANY","shipping_paper_number":"289089","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2956769","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2026-03-04 21:40:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-04 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-07T10:38:58.000000Z","updated_at":"2026-03-15T09:30:10.000000Z","inspection_violations":[{"id":20297772,"change_date":null,"inspection_id":"87195322","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39524"},{"id":20297773,"change_date":null,"inspection_id":"87195322","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":20328103,"change_date":null,"inspection_id":"87195322","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":null,"insp_unit_license":"P1604HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPRXNN150446","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20334055,"change_date":null,"inspection_id":"87195322","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"U469947","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9620EB707891","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11259703,"change_date":"2026-03-01 21:33:00","inspection_id":"87173389","dot_number":"86872","report_state":"TN","report_number":"I033T92074","insp_date":"2026-02-27 00:00:00","insp_start_time":"1100","insp_end_time":"1229","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MEMPHIS TN","county_code_state":"TN","county_code":"157","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY","shipping_paper_number":"289101","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"99200","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"2948642","transaction_code":"A","transaction_date":"2026-02-28 00:00:00","upload_date":"2026-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2026-03-01 21:33:00","snet_input_date":"2026-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-01 21:33:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-04T10:38:38.000000Z","updated_at":"2026-03-12T09:30:11.000000Z","inspection_violations":[{"id":20297743,"change_date":null,"inspection_id":"87173389","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"200A-HMSPS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"172200AHMSPS"},{"id":20297744,"change_date":null,"inspection_id":"87173389","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"516C5-HMPMC","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"172516C5HMPMC"},{"id":20297745,"change_date":null,"inspection_id":"87173389","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41B10-MC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39141B10MC"}],"inspection_per_units":[{"id":20328087,"change_date":null,"inspection_id":"87173389","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150419","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20334043,"change_date":null,"inspection_id":"87173389","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"U421558","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1PMA24426D5012210","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11248298,"change_date":"2026-02-27 21:41:00","inspection_id":"87161272","dot_number":"86872","report_state":"US","report_number":"1770000128","insp_date":"2026-02-25 00:00:00","insp_start_time":"1207","insp_end_time":"1304","registration_date":null,"region":"CS","ci_status_code":"C","location":"FULTON","location_desc":"FULTON MS","county_code_state":"MS","county_code":"057","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"288978","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2942603","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2026-02-27 21:41:00","snet_input_date":"2026-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-27 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-02T10:39:33.000000Z","updated_at":"2026-03-10T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20327911,"change_date":null,"inspection_id":"87161272","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3303070","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150436","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20333861,"change_date":null,"inspection_id":"87161272","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"U469947","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9620EB707891","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":10628450,"change_date":"2026-01-12 21:39:00","inspection_id":"86769247","dot_number":"86872","report_state":"TX","report_number":"V262172516","insp_date":"2026-01-07 00:00:00","insp_start_time":"1112","insp_end_time":"1143","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A201","location_desc":"IH20 EB TERRELL SCALE","county_code_state":"TX","county_code":"257","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OCCIDENTAL CHEMICAL CORP","shipping_paper_number":"45211","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9813696","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-12 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":"0123871","created_at":"2026-01-15T10:37:06.000000Z","updated_at":"2026-01-23T10:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19086990,"change_date":null,"inspection_id":"86769247","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P272732","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR2NN150456","insp_unit_decal":null,"insp_unit_decal_number":"35949907","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19093929,"change_date":null,"inspection_id":"86769247","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"151484T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9627MB229144","insp_unit_decal":null,"insp_unit_decal_number":"35949908","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10552515,"change_date":"2026-01-01 21:33:00","inspection_id":"86689454","dot_number":"86872","report_state":"AL","report_number":"1183000422","insp_date":"2025-12-29 00:00:00","insp_start_time":"1220","insp_end_time":"1255","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SILAS AL","county_code_state":"AL","county_code":"023","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"400263","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2715678","transaction_code":"A","transaction_date":"2026-01-01 00:00:00","upload_date":"2026-01-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2026-01-01 21:33:00","snet_input_date":"2025-12-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-01 21:33:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-04T10:33:46.000000Z","updated_at":"2026-01-12T10:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19085296,"change_date":null,"inspection_id":"86689454","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"P1605HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPR8NN150445","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19091958,"change_date":null,"inspection_id":"86689454","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"675398T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A6428SB702483","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10479531,"change_date":"2025-12-19 21:39:00","inspection_id":"86613427","dot_number":"86872","report_state":"AR","report_number":"5880000616","insp_date":"2025-12-18 00:00:00","insp_start_time":"1100","insp_end_time":"1215","registration_date":null,"region":"CS","ci_status_code":"C","location":"503","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL COMPANY","shipping_paper_number":"287527","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2680618","transaction_code":"A","transaction_date":"2025-12-19 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-12-19 21:39:00","snet_input_date":"2025-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-19 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-22T10:32:04.000000Z","updated_at":"2025-12-30T10:33:41.000000Z","inspection_violations":[{"id":18491394,"change_date":null,"inspection_id":"86613427","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-ATIS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3ATIS"},{"id":18491395,"change_date":null,"inspection_id":"86613427","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1OAL"}],"inspection_per_units":[{"id":18675249,"change_date":null,"inspection_id":"86613427","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3296946","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR9NN150437","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18837868,"change_date":null,"inspection_id":"86613427","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"6753907T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A6429SB702475","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10258672,"change_date":"2025-11-21 21:38:00","inspection_id":"86382279","dot_number":"86872","report_state":"US","report_number":"1770000101","insp_date":"2025-11-17 00:00:00","insp_start_time":"1323","insp_end_time":"1420","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MARION AR","county_code_state":"AR","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"287004","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2570032","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:41.000000Z","updated_at":"2025-11-25T10:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18750016,"change_date":null,"inspection_id":"86382279","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"P272732","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR2NN150456","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18834429,"change_date":null,"inspection_id":"86382279","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151483T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9625MB229143","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9997191,"change_date":"2025-10-21 21:39:00","inspection_id":"86107179","dot_number":"86872","report_state":"MS","report_number":"7644009569","insp_date":"2025-10-20 00:00:00","insp_start_time":"0849","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":"1","location_desc":"ADAMS COUNTY","county_code_state":"MS","county_code":"001","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"286407","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125183","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-21 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-10-21 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-24T10:01:55.000000Z","updated_at":"2025-10-25T10:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18669029,"change_date":null,"inspection_id":"86107179","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P1605HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPR8NN150445","insp_unit_decal":null,"insp_unit_decal_number":"35684219","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18831050,"change_date":null,"inspection_id":"86107179","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469949","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9624EB707893","insp_unit_decal":null,"insp_unit_decal_number":"35684220","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9509424,"change_date":"2025-09-15 21:40:00","inspection_id":"85594587","dot_number":"86872","report_state":"MS","report_number":"3007011052","insp_date":"2025-08-26 00:00:00","insp_start_time":"0534","insp_end_time":"0602","registration_date":"2025-09-15 00:00:00","region":"CT","ci_status_code":"C","location":"45","location_desc":"MADISON COUNTY","county_code_state":"MS","county_code":"089","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1118222","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-26 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:43:04.000000Z","updated_at":"2025-09-18T10:00:20.000000Z","inspection_violations":[{"id":18466409,"change_date":null,"inspection_id":"85594587","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":18740697,"change_date":null,"inspection_id":"85594587","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P1605HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPR8NN150445","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18824491,"change_date":null,"inspection_id":"85594587","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469948","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9622EB707892","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9446945,"change_date":"2025-08-19 21:40:00","inspection_id":"85528890","dot_number":"86872","report_state":"AR","report_number":"8250000164","insp_date":"2025-08-19 00:00:00","insp_start_time":"0718","insp_end_time":"0821","registration_date":null,"region":"CD","ci_status_code":"C","location":"404","location_desc":"HOPE AR","county_code_state":"AR","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPAY","shipping_paper_number":"284989","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2148479","transaction_code":"A","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:22.000000Z","updated_at":"2025-08-23T10:46:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18662252,"change_date":null,"inspection_id":"85528890","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"P272732","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR2NN150456","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18823712,"change_date":null,"inspection_id":"85528890","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151483T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9625MB229143","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9297869,"change_date":"2025-07-31 21:41:00","inspection_id":"85372253","dot_number":"86872","report_state":"MS","report_number":"2012013310","insp_date":"2025-07-30 00:00:00","insp_start_time":"0920","insp_end_time":"0934","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"57359","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114191","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-31 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-07-31 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:32.000000Z","updated_at":"2025-08-04T10:01:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18660561,"change_date":null,"inspection_id":"85372253","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3303070","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150436","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18821883,"change_date":null,"inspection_id":"85372253","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"068565T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9621MB229141","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9229124,"change_date":"2025-07-24 21:40:00","inspection_id":"85299847","dot_number":"86872","report_state":"AR","report_number":"7320001292","insp_date":"2025-07-23 00:00:00","insp_start_time":"0826","insp_end_time":"0920","registration_date":null,"region":"CD","ci_status_code":"C","location":"404","location_desc":"HOPE AR","county_code_state":"AR","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"284406","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2030586","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:43.000000Z","updated_at":"2025-07-30T10:00:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18737356,"change_date":null,"inspection_id":"85299847","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"P272733","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR6NN150458","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18821037,"change_date":null,"inspection_id":"85299847","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151484T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9627MB229144","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9088851,"change_date":"2025-07-10 21:39:00","inspection_id":"85152248","dot_number":"86872","report_state":"MS","report_number":"MC00390660","insp_date":"2025-07-07 00:00:00","insp_start_time":"0751","insp_end_time":"0856","registration_date":"2025-07-09 00:00:00","region":"CT","ci_status_code":"C","location":"Y-10","location_desc":"BOVINA SCALE HOUSE","county_code_state":"MS","county_code":"149","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"COMPLEX CHEMICALS CO. INC","shipping_paper_number":"302370","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1110658","transaction_code":"C","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-08 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-07-08 21:38:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:49.000000Z","updated_at":"2025-07-14T10:46:44.000000Z","inspection_violations":[{"id":18459794,"change_date":null,"inspection_id":"85152248","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":18735898,"change_date":null,"inspection_id":"85152248","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P1605HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPR8NN150445","insp_unit_decal":null,"insp_unit_decal_number":"35421405","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18819467,"change_date":null,"inspection_id":"85152248","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"151482T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9623MB229142","insp_unit_decal":null,"insp_unit_decal_number":"35421406","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9029530,"change_date":"2025-07-10 21:39:00","inspection_id":"85089762","dot_number":"86872","report_state":"MS","report_number":"6647018737","insp_date":"2025-06-26 00:00:00","insp_start_time":"1019","insp_end_time":"1030","registration_date":"2025-07-10 00:00:00","region":"CT","ci_status_code":"C","location":"66","location_desc":"STONE COUNTY","county_code_state":"MS","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL","shipping_paper_number":"283788","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1109663","transaction_code":"C","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-27 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-06-30 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-03T10:01:42.000000Z","updated_at":"2025-07-14T10:46:43.000000Z","inspection_violations":[{"id":18458497,"change_date":null,"inspection_id":"85089762","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":18657388,"change_date":null,"inspection_id":"85089762","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P275712","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR4NN150491","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18818494,"change_date":null,"inspection_id":"85089762","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"675398T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A6428SB702483","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8909172,"change_date":"2025-06-16 21:39:00","inspection_id":"84962670","dot_number":"86872","report_state":"MS","report_number":"0202100350","insp_date":"2025-06-13 00:00:00","insp_start_time":"0817","insp_end_time":"0841","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"300590","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1107729","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-16 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:22.000000Z","updated_at":"2025-06-20T10:00:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18655845,"change_date":null,"inspection_id":"84962670","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P1605HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPR8NN150445","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18816860,"change_date":null,"inspection_id":"84962670","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469948","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9622EB707892","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8882665,"change_date":"2025-06-16 21:39:00","inspection_id":"84934310","dot_number":"86872","report_state":"MS","report_number":"1007010492","insp_date":"2025-06-11 00:00:00","insp_start_time":"1321","insp_end_time":"1401","registration_date":"2025-06-16 00:00:00","region":"CT","ci_status_code":"C","location":"48","location_desc":"MONROE COUNTY","county_code_state":"MS","county_code":"095","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"282650","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1107255","transaction_code":"C","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-12 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-06-12 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-15T10:01:09.000000Z","updated_at":"2025-06-20T10:00:07.000000Z","inspection_violations":[{"id":18456333,"change_date":null,"inspection_id":"84934310","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3AII","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953AII"}],"inspection_per_units":[{"id":18655801,"change_date":null,"inspection_id":"84934310","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3296946","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR9NN150437","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18816813,"change_date":null,"inspection_id":"84934310","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"151484T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9627MB229144","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8894385,"change_date":"2025-06-13 21:40:00","inspection_id":"84946819","dot_number":"86872","report_state":"AR","report_number":"7290000633","insp_date":"2025-06-10 00:00:00","insp_start_time":"0700","insp_end_time":"0755","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"56995","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1862503","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:11.000000Z","updated_at":"2025-06-17T10:00:28.000000Z","inspection_violations":[{"id":18456010,"change_date":null,"inspection_id":"84946819","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38395ALCDL"},{"id":18456011,"change_date":null,"inspection_id":"84946819","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18655600,"change_date":null,"inspection_id":"84946819","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3434132","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR5NN150502","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18816587,"change_date":null,"inspection_id":"84946819","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"U249880","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1PMS34329B1037030","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8711795,"change_date":"2025-05-22 21:41:00","inspection_id":"84753315","dot_number":"86872","report_state":"AR","report_number":"7940000733","insp_date":"2025-05-22 00:00:00","insp_start_time":"0700","insp_end_time":"0825","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL LOGISTICS","shipping_paper_number":"56856","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1767861","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-05-22 21:41:00","snet_input_date":"2025-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-22 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-25T10:05:08.000000Z","updated_at":"2025-05-26T10:04:58.000000Z","inspection_violations":[{"id":18452918,"change_date":null,"inspection_id":"84753315","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18730941,"change_date":null,"inspection_id":"84753315","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3296946","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR9NN150437","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18814049,"change_date":null,"inspection_id":"84753315","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"U469947","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9620EB707891","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8687943,"change_date":"2025-05-20 21:41:00","inspection_id":"84728090","dot_number":"86872","report_state":"AL","report_number":"1276002372","insp_date":"2025-05-20 00:00:00","insp_start_time":"1044","insp_end_time":"1116","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EUFAULA AL","county_code_state":"AL","county_code":"005","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARL LOTT","shipping_paper_number":"368276988","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1755742","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:04:12.000000Z","updated_at":"2025-05-24T10:05:19.000000Z","inspection_violations":[{"id":18452464,"change_date":null,"inspection_id":"84728090","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":18652841,"change_date":null,"inspection_id":"84728090","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"1180186","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1HTMSAZR2AH180168","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8700568,"change_date":"2025-06-03 21:40:00","inspection_id":"84741455","dot_number":"86872","report_state":"MS","report_number":"3017011879","insp_date":"2025-05-16 00:00:00","insp_start_time":"1000","insp_end_time":"1055","registration_date":"2025-06-02 00:00:00","region":"CT","ci_status_code":"C","location":"Y-99","location_desc":"BOVINA SCALE I-20 EAST","county_code_state":"MS","county_code":"149","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPANY","shipping_paper_number":"100851","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103516","transaction_code":"C","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-19 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:17.000000Z","updated_at":"2025-06-07T10:00:10.000000Z","inspection_violations":[{"id":18454241,"change_date":null,"inspection_id":"84741455","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":18731944,"change_date":null,"inspection_id":"84741455","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P1604HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPRXNN150446","insp_unit_decal":null,"insp_unit_decal_number":"35141892","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18815149,"change_date":null,"inspection_id":"84741455","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469948","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9622EB707892","insp_unit_decal":null,"insp_unit_decal_number":"35141893","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8489428,"change_date":"2025-04-29 21:48:00","inspection_id":"84518970","dot_number":"86872","report_state":"US","report_number":"1988000013","insp_date":"2025-04-28 00:00:00","insp_start_time":"1059","insp_end_time":"1154","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VICKSBURG MS","county_code_state":"MS","county_code":"149","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL AND SUPPLY","shipping_paper_number":"200469","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"121182","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1650802","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:40.000000Z","updated_at":"2025-05-02T13:49:36.000000Z","inspection_violations":[{"id":18448988,"change_date":null,"inspection_id":"84518970","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":18650194,"change_date":null,"inspection_id":"84518970","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"P272733","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR6NN150458","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18810803,"change_date":null,"inspection_id":"84518970","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GENERAL TR","insp_unit_company":null,"insp_unit_license":"U469948","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9622FB707892","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8400158,"change_date":"2025-04-17 21:41:00","inspection_id":"84425014","dot_number":"86872","report_state":"TN","report_number":"I3A0591260","insp_date":"2025-04-15 00:00:00","insp_start_time":"1615","insp_end_time":"1717","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"STANTON TN","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL SUPPLY COMPANY","shipping_paper_number":"282197","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1607118","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:48.000000Z","updated_at":"2025-04-21T10:21:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18648934,"change_date":null,"inspection_id":"84425014","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3296946","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR9NN150437","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18809409,"change_date":null,"inspection_id":"84425014","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"675392T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A6422SB702477","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8066985,"change_date":"2025-03-10 21:38:00","inspection_id":"84074259","dot_number":"86872","report_state":"AR","report_number":"8160000096","insp_date":"2025-03-06 00:00:00","insp_start_time":"0710","insp_end_time":"0740","registration_date":null,"region":"CS","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PRODUCTION ASSISTANCE LINK","shipping_paper_number":"281353","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1450547","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:50.000000Z","updated_at":"2025-03-17T21:05:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18644542,"change_date":null,"inspection_id":"84074259","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR5NN150435","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18804590,"change_date":null,"inspection_id":"84074259","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"068565T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9621MB229141","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8029506,"change_date":"2025-03-05 21:39:00","inspection_id":"84034800","dot_number":"86872","report_state":"TN","report_number":"I01R841283","insp_date":"2025-03-04 00:00:00","insp_start_time":"0707","insp_end_time":"0752","registration_date":null,"region":"CS","ci_status_code":"C","location":"HAYWDE","location_desc":"STANTON TN","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"JACKSON MADISON CO. HOSPITAL","shipping_paper_number":"281374","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1432088","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2025-03-05 21:39:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-05 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:57.000000Z","updated_at":"2025-03-17T21:04:57.000000Z","inspection_violations":[{"id":18441087,"change_date":null,"inspection_id":"84034800","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18644098,"change_date":null,"inspection_id":"84034800","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3303070","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150436","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18804068,"change_date":null,"inspection_id":"84034800","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"068565T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9621MB229141","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7123397,"change_date":"2024-11-05 21:38:00","inspection_id":"83081685","dot_number":"86872","report_state":"AR","report_number":"8120000333","insp_date":"2024-11-04 00:00:00","insp_start_time":"0634","insp_end_time":"0714","registration_date":null,"region":"CS","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY","shipping_paper_number":"55380","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1022313","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-11-05 21:38:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-05 21:38:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18631789,"change_date":null,"inspection_id":"83081685","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR5NN150435","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18790482,"change_date":null,"inspection_id":"83081685","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"068565T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9621MB229141","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6754651,"change_date":"2024-09-18 21:42:00","inspection_id":"82689608","dot_number":"86872","report_state":"AR","report_number":"7290000266","insp_date":"2024-09-16 00:00:00","insp_start_time":"0815","insp_end_time":"0915","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPANY","shipping_paper_number":"277326","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"859870","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:57.000000Z","updated_at":"2025-03-17T20:36:57.000000Z","inspection_violations":[{"id":18420020,"change_date":null,"inspection_id":"82689608","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18626739,"change_date":null,"inspection_id":"82689608","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150419","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18784964,"change_date":null,"inspection_id":"82689608","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"U469953","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA642XEB707897","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6607360,"change_date":"2024-08-30 21:40:00","inspection_id":"82533090","dot_number":"86872","report_state":"AR","report_number":"8120000134","insp_date":"2024-08-29 00:00:00","insp_start_time":"0705","insp_end_time":"0740","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY","shipping_paper_number":"277150","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"800219","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-08-30 21:40:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:03.000000Z","updated_at":"2025-03-17T20:34:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18624733,"change_date":null,"inspection_id":"82533090","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR5NN150435","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18782813,"change_date":null,"inspection_id":"82533090","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151354T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A962XMB229140","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6333997,"change_date":"2024-09-11 21:40:00","inspection_id":"82241234","dot_number":"86872","report_state":"MS","report_number":"1026012072","insp_date":"2024-07-26 00:00:00","insp_start_time":"0915","insp_end_time":"1020","registration_date":"2024-09-10 00:00:00","region":"CT","ci_status_code":"C","location":"T-93","location_desc":"FULTON SCALE US 78 WEST","county_code_state":"MS","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SUNSHINE MILLS","shipping_paper_number":"100833","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"1074018","transaction_code":"C","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-29 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:17.000000Z","updated_at":"2025-03-17T20:28:17.000000Z","inspection_violations":[{"id":18412132,"change_date":null,"inspection_id":"82241234","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"201(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172201A1"},{"id":18412133,"change_date":null,"inspection_id":"82241234","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177817E"},{"id":18412134,"change_date":null,"inspection_id":"82241234","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45PC","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345PC"}],"inspection_per_units":[{"id":18621079,"change_date":null,"inspection_id":"82241234","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3248269","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR3NN150420","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18778880,"change_date":null,"inspection_id":"82241234","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"151354T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A962XMB229140","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6286014,"change_date":"2024-09-11 21:41:00","inspection_id":"82189898","dot_number":"86872","report_state":"MS","report_number":"2012012665","insp_date":"2024-07-23 00:00:00","insp_start_time":"0702","insp_end_time":"0724","registration_date":"2024-09-09 00:00:00","region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL","shipping_paper_number":"275640","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1073556","transaction_code":"C","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-23 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-07-23 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:22.000000Z","updated_at":"2025-03-17T20:27:22.000000Z","inspection_violations":[{"id":18411239,"change_date":null,"inspection_id":"82189898","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":18698076,"change_date":null,"inspection_id":"82189898","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"C1229HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3AKJGEBG7ESFV1118","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18778084,"change_date":null,"inspection_id":"82189898","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"U654282","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1PMS34325G1047609","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6239736,"change_date":"2024-07-17 21:41:00","inspection_id":"82140339","dot_number":"86872","report_state":"AR","report_number":"8050000171","insp_date":"2024-07-15 00:00:00","insp_start_time":"0721","insp_end_time":"0807","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PRODUCTION ASSISTANCE LINK","shipping_paper_number":"276072","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"663109","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-07-17 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-17 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:16.000000Z","updated_at":"2025-03-17T20:26:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18697456,"change_date":null,"inspection_id":"82140339","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150419","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18777442,"change_date":null,"inspection_id":"82140339","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"068565T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9621MB229141","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6057288,"change_date":"2024-06-24 21:41:00","inspection_id":"81944314","dot_number":"86872","report_state":"AR","report_number":"7870000152","insp_date":"2024-06-24 00:00:00","insp_start_time":"0710","insp_end_time":"0805","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL AND SUPPLY CO.","shipping_paper_number":"275584","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"595648","transaction_code":"A","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-06-24 21:41:00","snet_input_date":"2024-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-24 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:39.000000Z","updated_at":"2025-03-17T20:22:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18617268,"change_date":null,"inspection_id":"81944314","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3249784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR5NN150435","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18774671,"change_date":null,"inspection_id":"81944314","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151353T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9623MB229139","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5961921,"change_date":"2024-10-02 21:41:00","inspection_id":"81841014","dot_number":"86872","report_state":"MS","report_number":"1021011996","insp_date":"2024-06-10 00:00:00","insp_start_time":"0838","insp_end_time":"0922","registration_date":"2024-10-01 00:00:00","region":"CT","ci_status_code":"C","location":"48","location_desc":"MONROE COUNTY","county_code_state":"MS","county_code":"095","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"275128","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1070224","transaction_code":"C","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-11 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-06-11 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:02.000000Z","updated_at":"2025-03-17T20:21:02.000000Z","inspection_violations":[{"id":18405055,"change_date":null,"inspection_id":"81841014","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"22H4","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":18693520,"change_date":null,"inspection_id":"81841014","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3249782","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR4NN150376","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18773065,"change_date":null,"inspection_id":"81841014","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"U033605","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1PMS3432671031032","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5815354,"change_date":"2024-05-22 21:40:00","inspection_id":"81682069","dot_number":"86872","report_state":"GA","report_number":"1226000126","insp_date":"2024-05-16 00:00:00","insp_start_time":"1045","insp_end_time":"1145","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TRENTON GA","county_code_state":"GA","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N CHANGE CARRIER CARRIER DETAILS PREVIOUS INSPECTIONS NOTES ADD COINSPECTOR ATTACH IDEAL CHEMICAL AND SUPPLY COMPANY INC","shipping_paper_number":"274694","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"505536","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[{"id":18402111,"change_date":null,"inspection_id":"81682069","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216D"},{"id":18402112,"change_date":null,"inspection_id":"81682069","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"22H3-ELDMF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39522H3ELDMF"}],"inspection_per_units":[{"id":18691406,"change_date":null,"inspection_id":"81682069","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3303070","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7NN150436","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18770792,"change_date":null,"inspection_id":"81682069","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151354T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A962XMB229140","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5461285,"change_date":"2024-04-08 21:44:00","inspection_id":"81296550","dot_number":"86872","report_state":"TX","report_number":"V241264457","insp_date":"2024-04-02 00:00:00","insp_start_time":"0712","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A402","location_desc":"IH 30 WESTBOUND MT PLEASANT","county_code_state":"TX","county_code":"449","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"273578","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-08 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9242064","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":"0123871","created_at":"2025-03-17T20:11:07.000000Z","updated_at":"2025-03-17T20:11:07.000000Z","inspection_violations":[{"id":18394626,"change_date":null,"inspection_id":"81296550","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":18686250,"change_date":null,"inspection_id":"81296550","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":null,"insp_unit_license":"P272732","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR2NN150456","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18765331,"change_date":null,"inspection_id":"81296550","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"151483T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9625MB229143","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5469968,"change_date":"2024-04-12 21:39:00","inspection_id":"81306053","dot_number":"86872","report_state":"MS","report_number":"3011011034","insp_date":"2024-04-01 00:00:00","insp_start_time":"1230","insp_end_time":"1334","registration_date":null,"region":"CT","ci_status_code":"C","location":"Y-99","location_desc":"BOVINA SCALE I-20 EAST","county_code_state":"MS","county_code":"149","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"273381","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1064605","transaction_code":"C","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-09 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-04-09 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:10.000000Z","updated_at":"2025-03-17T20:11:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18608817,"change_date":null,"inspection_id":"81306053","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"P1605HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3HSDZAPR8NN150445","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18765454,"change_date":null,"inspection_id":"81306053","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469950","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9626EB707894","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5395528,"change_date":"2024-03-29 21:37:00","inspection_id":"81224528","dot_number":"86872","report_state":"AR","report_number":"8020000026","insp_date":"2024-03-28 00:00:00","insp_start_time":"1445","insp_end_time":"1545","registration_date":null,"region":"CD","ci_status_code":"C","location":"504","location_desc":"MARION AR","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL SUPPLY","shipping_paper_number":"273406","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-29 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"354651","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-03-29 21:37:00","snet_input_date":"2024-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-29 21:37:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:29.000000Z","updated_at":"2025-03-17T20:09:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18607755,"change_date":null,"inspection_id":"81224528","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3248269","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR3NN150420","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18764322,"change_date":null,"inspection_id":"81224528","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"151353T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1A9623MB229139","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5240428,"change_date":"2024-03-08 21:39:00","inspection_id":"81055701","dot_number":"86872","report_state":"US","report_number":"1659000046","insp_date":"2024-02-29 00:00:00","insp_start_time":"1415","insp_end_time":"1457","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"272952","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"303517","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18605395,"change_date":null,"inspection_id":"81055701","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"P272732","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3HSDZAPR2NN150456","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18761821,"change_date":null,"inspection_id":"81055701","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"469950","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA9626EB707894","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4721083,"change_date":"2023-12-28 21:44:00","inspection_id":"80488355","dot_number":"86872","report_state":"MS","report_number":"2013011552","insp_date":"2023-12-28 00:00:00","insp_start_time":"1018","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"271330","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1056737","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-28 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-12-28 21:44:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:30.000000Z","updated_at":"2025-03-17T19:56:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18675643,"change_date":null,"inspection_id":"80488355","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3249782","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR4NN150376","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18753525,"change_date":null,"inspection_id":"80488355","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"U469953","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRAA642XEB707897","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4610862,"change_date":"2023-12-12 21:41:00","inspection_id":"80367774","dot_number":"86872","report_state":"LA","report_number":"LAPR000882","insp_date":"2023-12-11 00:00:00","insp_start_time":"0942","insp_end_time":"1032","registration_date":null,"region":"CT","ci_status_code":"C","location":"53","location_desc":"KENTWOOD SCALES","county_code_state":"LA","county_code":"105","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"271022","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188667","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-12 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-12-12 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:11.000000Z","updated_at":"2025-03-17T19:54:11.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3877149,"change_date":"2023-08-31 21:42:00","inspection_id":"79556105","dot_number":"86872","report_state":"MS","report_number":"2019011655","insp_date":"2023-08-30 00:00:00","insp_start_time":"0743","insp_end_time":"0823","registration_date":null,"region":"CT","ci_status_code":"C","location":"B-98","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NITEO PRODUCTS","shipping_paper_number":"268765","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1044144","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-31 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:25.000000Z","updated_at":"2025-03-17T19:39:25.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3650707,"change_date":"2023-08-02 21:41:00","inspection_id":"79303022","dot_number":"86872","report_state":"LA","report_number":"LAPR000782","insp_date":"2023-07-31 00:00:00","insp_start_time":"0934","insp_end_time":"1026","registration_date":null,"region":"CT","ci_status_code":"C","location":"53","location_desc":"ROADSIDE","county_code_state":"LA","county_code":"105","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"267944","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175847","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-02 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:56.000000Z","updated_at":"2025-03-17T19:34:56.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3586423,"change_date":"2023-07-25 21:41:00","inspection_id":"79231089","dot_number":"86872","report_state":"AR","report_number":"771E000320","insp_date":"2023-07-25 00:00:00","insp_start_time":"0715","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":"18-501","location_desc":"CRITTENDEN CO (RIVERSIDE STN)","county_code_state":"AR","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"EVERGREEN PACKAGING","shipping_paper_number":"267908","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1467737","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-25 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-07-25 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:52.000000Z","updated_at":"2025-03-17T19:33:52.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3400703,"change_date":"2023-06-29 21:42:00","inspection_id":"79022500","dot_number":"86872","report_state":"MS","report_number":"1027011883","insp_date":"2023-06-28 00:00:00","insp_start_time":"1239","insp_end_time":"1257","registration_date":null,"region":"CT","ci_status_code":"C","location":"48","location_desc":"MONROE COUNTY","county_code_state":"MS","county_code":"095","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPANY","shipping_paper_number":"267298","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1032457","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-29 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-06-29 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:32.000000Z","updated_at":"2025-03-17T19:30:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3254749,"change_date":"2023-06-12 21:39:00","inspection_id":"78857903","dot_number":"86872","report_state":"US","report_number":"1347240001","insp_date":"2023-06-08 00:00:00","insp_start_time":"1001","insp_end_time":"1138","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"STANTONTN","county_code_state":"TN","county_code":"001","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"266851","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-06-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"106700","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"22259","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":"2023-06-12 21:39:00","snet_input_date":"2023-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-12 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:22.000000Z","updated_at":"2025-03-17T19:27:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3078433,"change_date":"2023-05-18 21:43:00","inspection_id":"78659037","dot_number":"86872","report_state":"AR","report_number":"E526005932","insp_date":"2023-05-18 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"19","location_desc":"CROSS COUNTY","county_code_state":"AR","county_code":"037","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPANY","shipping_paper_number":"81955","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1458079","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-18 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:49.000000Z","updated_at":"2025-03-17T19:23:49.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2971249,"change_date":"2023-05-17 21:42:00","inspection_id":"78538029","dot_number":"86872","report_state":"AR","report_number":"E526005918","insp_date":"2023-05-05 00:00:00","insp_start_time":"1005","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"19","location_desc":"CROSS COUNTY","county_code_state":"AR","county_code":"037","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY COMPANY","shipping_paper_number":"266124","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1456086","transaction_code":"C","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-05 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-05-05 21:41:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:52.000000Z","updated_at":"2025-03-17T19:21:52.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2033085,"change_date":"2022-12-29 21:39:00","inspection_id":"77469417","dot_number":"86872","report_state":"AR","report_number":"774E000114","insp_date":"2022-12-29 00:00:00","insp_start_time":"0635","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"18-503","location_desc":"CRITTENDEN CO (BRIDGEPORT STN)","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY CO","shipping_paper_number":"262622","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1437692","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-29 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-29 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:02.000000Z","updated_at":"2025-03-17T19:04:02.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2043004,"change_date":"2022-12-30 21:36:00","inspection_id":"77480973","dot_number":"86872","report_state":"AR","report_number":"776E000093","insp_date":"2022-12-29 00:00:00","insp_start_time":"1431","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":"18-503","location_desc":"CRITTENDEN CO (BRIDGEPORT STN)","county_code_state":"AR","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"263030","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-30 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1437799","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-29 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-30 21:36:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:21.000000Z","updated_at":"2025-03-17T19:04:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1993507,"change_date":"2022-12-21 21:39:00","inspection_id":"77424672","dot_number":"86872","report_state":"AR","report_number":"E510007448","insp_date":"2022-12-21 00:00:00","insp_start_time":"1025","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"LEE COUNTY","county_code_state":"AR","county_code":"077","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL SUPPLY","shipping_paper_number":"261876","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1436713","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-21 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1982850,"change_date":"2022-12-20 21:40:00","inspection_id":"77412547","dot_number":"86872","report_state":"MS","report_number":"2012011907","insp_date":"2022-12-19 00:00:00","insp_start_time":"1020","insp_end_time":"1034","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"400375","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1003573","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-20 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-12-20 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:17.000000Z","updated_at":"2025-03-17T19:03:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1858550,"change_date":"2022-12-02 21:40:00","inspection_id":"77270140","dot_number":"86872","report_state":"LA","report_number":"LAEW001058","insp_date":"2022-11-30 00:00:00","insp_start_time":"1014","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":"53","location_desc":"ROADSIDE","county_code_state":"LA","county_code":"105","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL & SUPPLY CO.","shipping_paper_number":"262312","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1150204","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-02 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-12-02 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:48.000000Z","updated_at":"2025-03-17T19:00:48.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1506679,"change_date":"2022-10-13 21:40:00","inspection_id":"76866178","dot_number":"86872","report_state":"MS","report_number":"2013010909","insp_date":"2022-10-12 00:00:00","insp_start_time":"1025","insp_end_time":"1044","registration_date":null,"region":"CT","ci_status_code":"C","location":"B-94","location_desc":"LULA SCALE US 49","county_code_state":"MS","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"261166","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"993197","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-13 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-10-13 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:28.000000Z","updated_at":"2025-03-17T18:54:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1433045,"change_date":"2022-10-04 21:40:00","inspection_id":"76780939","dot_number":"86872","report_state":"MS","report_number":"3005010471","insp_date":"2022-10-03 00:00:00","insp_start_time":"1240","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"Y-99","location_desc":"BOVINA SCALE I-20 EAST","county_code_state":"MS","county_code":"149","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"260880","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"991787","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-04 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-10-04 21:40:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:05.000000Z","updated_at":"2025-03-17T18:53:05.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1282042,"change_date":"2022-10-13 21:40:00","inspection_id":"76605289","dot_number":"86872","report_state":"LA","report_number":"LAPN000751","insp_date":"2022-09-13 00:00:00","insp_start_time":"1032","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SCALES","county_code_state":"LA","county_code":"105","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"IDEAL CHEMICAL AND SUPPLY","shipping_paper_number":"260408","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142753","transaction_code":"C","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-14 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-09-14 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:26.000000Z","updated_at":"2025-03-17T18:50:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":405203,"change_date":"2022-05-17 21:42:00","inspection_id":"75576341","dot_number":"86872","report_state":"MS","report_number":"2012011319","insp_date":"2022-05-17 00:00:00","insp_start_time":"0624","insp_end_time":"0642","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"DE SOTO COUNTY","county_code_state":"MS","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"257538","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"965737","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-17 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:46.000000Z","updated_at":"2025-03-17T18:34:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":233422,"change_date":"2022-04-29 21:40:00","inspection_id":"75371337","dot_number":"86872","report_state":"MS","report_number":"1004010070","insp_date":"2022-04-21 00:00:00","insp_start_time":"1440","insp_end_time":"1500","registration_date":"2022-04-28 00:00:00","region":"CT","ci_status_code":"C","location":"2","location_desc":"ALCORN COUNTY","county_code_state":"MS","county_code":"003","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL CHEMICAL","shipping_paper_number":"256795","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"962004","transaction_code":"C","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-22 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-04-22 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:35.000000Z","updated_at":"2025-03-17T18:31:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":127143,"change_date":"2022-04-07 21:39:00","inspection_id":"75244391","dot_number":"86872","report_state":"MS","report_number":"2013010637","insp_date":"2022-04-06 00:00:00","insp_start_time":"1352","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":"6","location_desc":"BOLIVAR COUNTY","county_code_state":"MS","county_code":"011","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"959823","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-06 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:49.000000Z","updated_at":"2025-03-17T18:29:49.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":154748,"change_date":"2022-04-12 21:42:00","inspection_id":"75277378","dot_number":"86872","report_state":"US","report_number":"1659202211","insp_date":"2022-03-31 00:00:00","insp_start_time":"1521","insp_end_time":"1602","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-55 N BRIDGEPORT INSPECTION","county_code_state":"AR","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"IDEAL CHEMICAL SUPPLY","shipping_paper_number":"256286","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2100","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00086872","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-12 00:00:00","source_office":"2ARD001","mcmis_add_date":"2022-04-12 21:42:00","insp_carrier_name":"IDEAL CHEMICAL AND SUPPLY COMPANY INC","insp_carrier_street":"4025 AIR PARK STREET","insp_carrier_city":"MEMPHIS","insp_carrier_state":"TN","insp_carrier_zip_code":"38118","insp_colonia":null,"docket_number":"369336","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:11.000000Z","updated_at":"2025-03-17T18:30:11.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/86872\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/86872\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/86872\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/86872\/inspections","per_page":100,"prev_page_url":null,"to":63,"total":63}