{"current_page":1,"data":[{"id":8820807,"change_date":"2025-10-10 21:40:00","inspection_id":"84868656","dot_number":"395102","report_state":"MN","report_number":"1715000141","insp_date":"2025-05-29 00:00:00","insp_start_time":"1136","insp_end_time":"1156","registration_date":null,"region":"CD","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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":"U","pen_cen_match":"I","final_status_date":"2025-06-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1822554","transaction_code":"C","transaction_date":"2025-10-10 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2025-06-05 21:40:00","snet_input_date":"2025-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-05 21:40:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:00:55.000000Z","updated_at":"2025-10-14T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16441816,"change_date":"2025-10-10 21:40:00","inspection_id":"84868656","insp_unit_id":"209403671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"54804Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FDUF5HNXNED46561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:26.000000Z","updated_at":"2025-10-14T09:45:44.000000Z"}]},{"id":7316944,"change_date":"2024-12-02 21:39:00","inspection_id":"83286359","dot_number":"395102","report_state":"MD","report_number":"2274004140","insp_date":"2024-12-02 00:00:00","insp_start_time":"0850","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"013","location_desc":"PARK & RIDE SCALE I-95 @ I-495","county_code_state":"MD","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"2024-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2765342","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-12-02 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:37.000000Z","updated_at":"2025-03-17T20:48:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11803318,"change_date":"2024-12-02 21:39:00","inspection_id":"83286359","insp_unit_id":"204129631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FTL","insp_unit_company":null,"insp_unit_license":"3187557","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWFC3NHMV4384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:20.000000Z","updated_at":"2025-03-17T23:45:20.000000Z"}]},{"id":4959594,"change_date":"2024-02-02 21:40:00","inspection_id":"80749089","dot_number":"395102","report_state":"IN","report_number":"7429003317","insp_date":"2024-01-29 00:00:00","insp_start_time":"1007","insp_end_time":"1049","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PERU IN","county_code_state":"IN","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA PIPE & SUPPLY CO","shipping_paper_number":"6537669","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-02-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"212628","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2024-02-02 21:40:00","snet_input_date":"2024-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-02 21:40:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:53.000000Z","updated_at":"2025-03-17T20:00:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7981805,"change_date":"2024-02-02 21:40:00","inspection_id":"80749089","insp_unit_id":"199232251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"A22120","insp_unit_license":"68137Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FVHCYD25PHUE8329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:21.000000Z","updated_at":"2025-03-17T23:07:21.000000Z"}]},{"id":4838743,"change_date":"2024-01-16 21:45:00","inspection_id":"80616958","dot_number":"395102","report_state":"MN","report_number":"0ACY000998","insp_date":"2024-01-15 00:00:00","insp_start_time":"1110","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":"STPTR","location_desc":"ST. PETER","county_code_state":"MN","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","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":"I","final_status_date":"2024-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1430538","transaction_code":"A","transaction_date":"2024-01-15 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-16 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:29.000000Z","updated_at":"2025-03-17T19:58:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7785012,"change_date":"2024-01-16 21:45:00","inspection_id":"80616958","insp_unit_id":"198972355","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"258","insp_unit_license":"2986040","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC7KDLL6491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"}]},{"id":4161824,"change_date":"2023-10-10 21:41:00","inspection_id":"79872445","dot_number":"395102","report_state":"IL","report_number":"0093000837","insp_date":"2023-10-10 00:00:00","insp_start_time":"1258","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"CAR I7","location_desc":"CARLOCK-I74 E\/B","county_code_state":"IL","county_code":"113","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14969","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":"2280291","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:25.000000Z","updated_at":"2025-03-17T19:45:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6691742,"change_date":"2023-10-10 21:41:00","inspection_id":"79872445","insp_unit_id":"197474938","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"A21855","insp_unit_license":"51711Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3ALACXD23NDNS8540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:07.000000Z","updated_at":"2025-03-17T22:56:07.000000Z"}]},{"id":4103591,"change_date":"2023-10-02 21:41:00","inspection_id":"79808127","dot_number":"395102","report_state":"WI","report_number":"C054000065","insp_date":"2023-09-29 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7900BLK","county_code_state":"WI","county_code":"035","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"COLUMBIA PIPE AND SUPPLY CO","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-10-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"908266","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2023-10-02 21:41:00","snet_input_date":"2023-10-02 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-10-02 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:01.000000Z","updated_at":"2025-03-17T19:44:01.000000Z","inspection_violations":[{"id":6348556,"change_date":"2023-10-02 21:41:00","inspection_id":"79808127","insp_violation_id":"255598486","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197347284","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3929A"},{"id":6348557,"change_date":"2023-10-02 21:41:00","inspection_id":"79808127","insp_violation_id":"255598487","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:37.000000Z","updated_at":"2025-03-17T21:36:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6597729,"change_date":"2023-10-02 21:41:00","inspection_id":"79808127","insp_unit_id":"197347284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"54804Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FDUF5HNXNED46561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:21.000000Z","updated_at":"2025-03-17T22:55:21.000000Z"}]},{"id":3746534,"change_date":"2023-08-15 21:43:00","inspection_id":"79410230","dot_number":"395102","report_state":"MN","report_number":"0ACT002234","insp_date":"2023-08-15 00:00:00","insp_start_time":"1012","insp_end_time":"1031","registration_date":null,"region":"CT","ci_status_code":"C","location":"NRWD","location_desc":"NORWOOD","county_code_state":"MN","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1404097","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-08-15 21:43:00","snet_input_date":"2023-08-15 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-08-15 21:43:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:53.000000Z","updated_at":"2025-03-17T19:36:53.000000Z","inspection_violations":[{"id":5777078,"change_date":"2023-08-15 21:43:00","inspection_id":"79410230","insp_violation_id":"254662395","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6024083,"change_date":"2023-08-15 21:43:00","inspection_id":"79410230","insp_unit_id":"196539804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"58244Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FDUF5HN8NED46557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:37.000000Z","updated_at":"2025-03-17T22:50:37.000000Z"}]},{"id":3511327,"change_date":"2023-07-14 21:41:00","inspection_id":"79146849","dot_number":"395102","report_state":"IL","report_number":"4068830110","insp_date":"2023-07-14 00:00:00","insp_start_time":"1043","insp_end_time":"1047","registration_date":null,"region":"CT","ci_status_code":"C","location":"004","location_desc":"004 - US14, N OF HARVARD","county_code_state":"IL","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"2260764","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:28.000000Z","updated_at":"2025-03-17T19:32:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5646013,"change_date":"2023-07-14 21:41:00","inspection_id":"79146849","insp_unit_id":"196006678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8535","insp_unit_license":"48124Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3ALHCYD24NDNS8535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":3511759,"change_date":"2023-07-14 21:41:00","inspection_id":"79147333","dot_number":"395102","report_state":"MI","report_number":"RODRR02237","insp_date":"2023-07-13 00:00:00","insp_start_time":"1235","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MUSKEGON SB REST AREA","county_code_state":"MI","county_code":"121","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135344","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:28.000000Z","updated_at":"2025-03-17T19:32:28.000000Z","inspection_violations":[{"id":5414398,"change_date":"2023-07-14 21:41:00","inspection_id":"79147333","insp_violation_id":"254069416","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"1","insp_unit_id":"196008078","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3929A1"},{"id":5414399,"change_date":"2023-07-14 21:41:00","inspection_id":"79147333","insp_violation_id":"254069417","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196008078","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"39345D"},{"id":5414400,"change_date":"2023-07-14 21:41:00","inspection_id":"79147333","insp_violation_id":"254069418","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196008078","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4250128","created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5646761,"change_date":"2023-07-14 21:41:00","inspection_id":"79147333","insp_unit_id":"196008078","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"299460","insp_unit_license":"3156121","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC1MDMR8359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":3487848,"change_date":"2023-07-12 21:41:00","inspection_id":"79120661","dot_number":"395102","report_state":"IL","report_number":"4180670046","insp_date":"2023-06-19 00:00:00","insp_start_time":"0303","insp_end_time":"0335","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-290 E\/B AT S ASHLAND AVE","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-12 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"33000","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":"2259555","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-07-12 21:41:00","snet_input_date":"2023-06-19 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-07-12 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:04.000000Z","updated_at":"2025-03-17T19:32:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5608517,"change_date":"2023-07-12 21:41:00","inspection_id":"79120661","insp_unit_id":"195954711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRET","insp_unit_company":null,"insp_unit_license":"2575179","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXDT1EDFK1596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:16.000000Z","updated_at":"2025-03-17T22:47:16.000000Z"}]},{"id":3192704,"change_date":"2023-06-01 21:42:00","inspection_id":"78788133","dot_number":"395102","report_state":"IL","report_number":"4068440255","insp_date":"2023-05-31 00:00:00","insp_start_time":"1110","insp_end_time":"1119","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA PIPE","shipping_paper_number":"7623724","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":"2023-06-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2249775","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-06-01 21:42:00","snet_input_date":"2023-05-31 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-06-01 21:42:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:07.000000Z","updated_at":"2025-03-17T19:26:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5135257,"change_date":"2023-06-01 21:42:00","inspection_id":"78788133","insp_unit_id":"195258462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"8538","insp_unit_license":"23909L","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3ALACXD25NDNS8538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"}]},{"id":3167605,"change_date":"2023-05-30 21:42:00","inspection_id":"78759726","dot_number":"395102","report_state":"WI","report_number":"5033000069","insp_date":"2023-05-26 00:00:00","insp_start_time":"0940","insp_end_time":"1011","registration_date":null,"region":"CT","ci_status_code":"C","location":"S19","location_desc":"BELOIT SWEF","county_code_state":"WI","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"COLUMBIA PIPE & SUPPLY CO.","shipping_paper_number":"7621428","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":"I","final_status_date":"2023-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"895846","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-30 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:43.000000Z","updated_at":"2025-03-17T19:25:43.000000Z","inspection_violations":[{"id":4879112,"change_date":"2023-05-30 21:42:00","inspection_id":"78759726","insp_violation_id":"253148169","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195202031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39311"},{"id":4879113,"change_date":"2023-05-30 21:42:00","inspection_id":"78759726","insp_violation_id":"253148170","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195202031","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39395A"},{"id":4879114,"change_date":"2023-05-30 21:42:00","inspection_id":"78759726","insp_violation_id":"253148171","seq_no":"3","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":5094999,"change_date":"2023-05-30 21:42:00","inspection_id":"78759726","insp_unit_id":"195202031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NS85365","insp_unit_license":"48123Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3ALHCYD26NDNS8536","insp_unit_decal":"Y","insp_unit_decal_number":"32747565","created_at":"2025-03-17T22:43:08.000000Z","updated_at":"2025-03-17T22:43:08.000000Z"}]},{"id":3083734,"change_date":"2023-05-18 21:43:00","inspection_id":"78665120","dot_number":"395102","report_state":"MN","report_number":"0ACZ002988","insp_date":"2023-05-18 00:00:00","insp_start_time":"1028","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"RCHTR","location_desc":"ROCHESTER","county_code_state":"MN","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"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":"60000","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":"1388591","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":"00395102","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[{"id":4739093,"change_date":"2023-05-18 21:43:00","inspection_id":"78665120","insp_violation_id":"252927195","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:03.000000Z","updated_at":"2025-03-17T21:29:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4960348,"change_date":"2023-05-18 21:43:00","inspection_id":"78665120","insp_unit_id":"195015937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"255","insp_unit_license":"2902102","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFE1KDLL6492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"}]},{"id":3069726,"change_date":"2023-05-17 21:43:00","inspection_id":"78649347","dot_number":"395102","report_state":"WI","report_number":"2711002262","insp_date":"2023-05-16 00:00:00","insp_start_time":"1520","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":"S16","location_desc":"MADISON SWEF","county_code_state":"WI","county_code":"025","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"MULTIPLE","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":"I","final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"894039","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4938342,"change_date":"2023-05-17 21:43:00","inspection_id":"78649347","insp_unit_id":"194986462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"262","insp_unit_license":"2902069","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFE7KDLL6495","insp_unit_decal":"Y","insp_unit_decal_number":"32745981","created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"}]},{"id":3067309,"change_date":"2023-05-17 21:43:00","inspection_id":"78646584","dot_number":"395102","report_state":"IL","report_number":"3998361560","insp_date":"2023-05-15 00:00:00","insp_start_time":"1005","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-90 S\/B AT ADDISON AIS","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","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":"2023-05-17 21:43:00","post_acc_ind":"Y","gross_comb_veh_wt":"60000","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":"2245411","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-15 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[{"id":4712241,"change_date":"2023-05-17 21:43:00","inspection_id":"78646584","insp_violation_id":"252887721","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194981411","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:57.000000Z","updated_at":"2025-03-17T21:28:57.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4934308,"change_date":"2023-05-17 21:43:00","inspection_id":"78646584","insp_unit_id":"194981411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRET","insp_unit_company":"260","insp_unit_license":"3048821","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFE8KDLL6487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:53.000000Z","updated_at":"2025-03-17T22:41:53.000000Z"}]},{"id":2716666,"change_date":"2023-04-21 21:41:00","inspection_id":"78250064","dot_number":"395102","report_state":"IN","report_number":"9826000932","insp_date":"2023-03-28 00:00:00","insp_start_time":"0910","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"1365S","location_desc":"#13  I-65 SB  LAKE","county_code_state":"IN","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"COLUMBIA PIPE&SUPPLY CO.","shipping_paper_number":"7542694","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":"I","final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2182975","transaction_code":"C","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-03-30 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:38.000000Z","updated_at":"2025-03-17T19:16:38.000000Z","inspection_violations":[{"id":4172161,"change_date":"2023-04-21 21:41:00","inspection_id":"78250064","insp_violation_id":"252368125","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194519358","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4372263,"change_date":"2023-04-21 21:41:00","inspection_id":"78250064","insp_unit_id":"194519358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"214","insp_unit_license":"2927802","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYBS6DDFJ0591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:25.000000Z","updated_at":"2025-03-17T22:37:25.000000Z"}]},{"id":2586566,"change_date":"2023-03-15 21:42:00","inspection_id":"78101465","dot_number":"395102","report_state":"WI","report_number":"2641006537","insp_date":"2023-03-13 00:00:00","insp_start_time":"1025","insp_end_time":"1047","registration_date":null,"region":"CT","ci_status_code":"C","location":"S63","location_desc":"MENOMONIE SWEF","county_code_state":"WI","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2023-03-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"887971","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2023-03-15 21:42:00","snet_input_date":"2023-03-14 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-03-15 21:42:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:27.000000Z","updated_at":"2025-03-17T19:14:27.000000Z","inspection_violations":[{"id":3977899,"change_date":"2023-03-15 21:42:00","inspection_id":"78101465","insp_violation_id":"251682583","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193892091","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BJ321875-1","created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4163261,"change_date":"2023-03-15 21:42:00","inspection_id":"78101465","insp_unit_id":"193892091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2902102","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFE1KDLL6492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"}]},{"id":2553097,"change_date":"2023-03-10 21:41:00","inspection_id":"78062992","dot_number":"395102","report_state":"IL","report_number":"4180870026","insp_date":"2023-03-10 00:00:00","insp_start_time":"0925","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","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":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2228548","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-10 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:43.000000Z","updated_at":"2025-03-17T19:13:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4109308,"change_date":"2023-03-10 21:41:00","inspection_id":"78062992","insp_unit_id":"193814326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NS8542","insp_unit_license":"54675Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3ALACXD27NDNS8542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:27.000000Z","updated_at":"2025-03-17T22:35:27.000000Z"}]},{"id":1903262,"change_date":"2022-12-08 21:41:00","inspection_id":"77321150","dot_number":"395102","report_state":"MN","report_number":"00XE003738","insp_date":"2022-12-08 00:00:00","insp_start_time":"1420","insp_end_time":"1436","registration_date":null,"region":"CT","ci_status_code":"C","location":"STCLD","location_desc":"ST. CLOUD","county_code_state":"MN","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"7407204","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":"I","final_status_date":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1364400","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-08 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:49.000000Z","updated_at":"2025-03-17T19:01:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3062912,"change_date":"2022-12-08 21:41:00","inspection_id":"77321150","insp_unit_id":"192330809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"257","insp_unit_license":"2986039","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC5KDLL6490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"}]},{"id":1870764,"change_date":"2022-12-05 21:40:00","inspection_id":"77284221","dot_number":"395102","report_state":"WI","report_number":"2733001303","insp_date":"2022-12-01 00:00:00","insp_start_time":"1235","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":"S44","location_desc":"COLOMA SWEF","county_code_state":"WI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"5282","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":"I","final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"879296","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:07.000000Z","updated_at":"2025-03-17T19:01:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3010956,"change_date":"2022-12-05 21:40:00","inspection_id":"77284221","insp_unit_id":"192258767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"267","insp_unit_license":"3113955","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFE8MDMR8350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:37.000000Z","updated_at":"2025-03-17T22:27:37.000000Z"}]},{"id":1819805,"change_date":"2023-04-11 12:04:00","inspection_id":"77226126","dot_number":"395102","report_state":"IN","report_number":"3909004120","insp_date":"2022-11-18 00:00:00","insp_start_time":"1250","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-94WB SCALES MM#029","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"COLUMBIA PIPE AND SUPPLY","shipping_paper_number":"6070491","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":"I","final_status_date":"2022-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2161356","transaction_code":"C","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2022-11-28 21:41:00","snet_input_date":"2022-11-23 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-11-28 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:02.000000Z","updated_at":"2025-03-17T19:00:02.000000Z","inspection_violations":[{"id":2842274,"change_date":"2023-04-11 12:04:00","inspection_id":"77226126","insp_violation_id":"252126331","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194301533","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2927320,"change_date":"2023-04-11 12:04:00","inspection_id":"77226126","insp_unit_id":"194301533","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NS8541","insp_unit_license":"TK173OHF","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXD25NDNS8541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:02.000000Z","updated_at":"2025-03-17T22:27:02.000000Z"}]},{"id":1261401,"change_date":"2022-09-12 21:43:00","inspection_id":"76581728","dot_number":"395102","report_state":"IL","report_number":"4036870115","insp_date":"2022-09-08 00:00:00","insp_start_time":"0715","insp_end_time":"0723","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"US 20","county_code_state":"IL","county_code":"177","insp_level_id":"3","service_center":"MW","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-09-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2194399","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2022-09-12 21:43:00","snet_input_date":"2022-09-08 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-09-12 21:43:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:04.000000Z","updated_at":"2025-03-17T18:50:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2029516,"change_date":"2022-09-12 21:43:00","inspection_id":"76581728","insp_unit_id":"190840455","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"515571","insp_unit_license":"REGISTRATI","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3ALHCYCY0EDFH9289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:55.000000Z","updated_at":"2025-03-17T22:20:55.000000Z"}]},{"id":905170,"change_date":"2022-07-27 21:41:00","inspection_id":"76166285","dot_number":"395102","report_state":"MN","report_number":"00XC003529","insp_date":"2022-07-27 00:00:00","insp_start_time":"1139","insp_end_time":"1239","registration_date":null,"region":"CT","ci_status_code":"C","location":"MTLEY","location_desc":"MOTLEY","county_code_state":"MN","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"I","final_status_date":"2022-07-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1341658","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2022-07-27 21:41:00","snet_input_date":"2022-07-27 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:41.000000Z","updated_at":"2025-03-17T18:43:41.000000Z","inspection_violations":[{"id":1427348,"change_date":"2022-07-27 21:41:00","inspection_id":"76166285","insp_violation_id":"247347532","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"38323A2"},{"id":1427349,"change_date":"2022-07-27 21:41:00","inspection_id":"76166285","insp_violation_id":"247347533","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1456924,"change_date":"2022-07-27 21:41:00","inspection_id":"76166285","insp_unit_id":"189993710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"669988","insp_unit_license":"2520083","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMMN3HH693794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:10.000000Z","updated_at":"2025-03-17T22:17:10.000000Z"}]},{"id":777847,"change_date":"2022-07-08 21:40:00","inspection_id":"76017762","dot_number":"395102","report_state":"IL","report_number":"0104001108","insp_date":"2022-07-07 00:00:00","insp_start_time":"1012","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":"SC16","location_desc":"BOLINGBROOK - I-55 N\/B","county_code_state":"IL","county_code":"197","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"7191082","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":"I","final_status_date":"2022-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2181172","transaction_code":"A","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-08 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:17.000000Z","updated_at":"2025-03-17T18:41:17.000000Z","inspection_violations":[{"id":1228822,"change_date":"2022-07-08 21:40:00","inspection_id":"76017762","insp_violation_id":"246974331","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189672933","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1251542,"change_date":"2022-07-08 21:40:00","inspection_id":"76017762","insp_unit_id":"189672933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"515574","insp_unit_license":"2573707","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXDT2EDFJ9128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:53.000000Z","updated_at":"2025-03-17T22:15:53.000000Z"}]},{"id":739300,"change_date":"2022-07-01 21:38:00","inspection_id":"75972793","dot_number":"395102","report_state":"IL","report_number":"3998630149","insp_date":"2022-06-30 00:00:00","insp_start_time":"1612","insp_end_time":"1620","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"HALSTEAD @ 41 ST","county_code_state":"IL","county_code":"031","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"COLUBIA PIPE AND SUPPLY COMPANY","shipping_paper_number":"R554900010","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-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2180359","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-06-30 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"606091428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:35.000000Z","updated_at":"2025-03-17T18:40:35.000000Z","inspection_violations":[{"id":1163920,"change_date":"2022-07-01 21:38:00","inspection_id":"75972793","insp_violation_id":"246857366","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"1","insp_unit_id":"189575665","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":1187993,"change_date":"2022-07-01 21:38:00","inspection_id":"75972793","insp_unit_id":"189575665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"273","insp_unit_license":"3114048","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALHCYFEXMDMR8351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:29.000000Z","updated_at":"2025-03-17T22:15:29.000000Z"}]},{"id":628380,"change_date":"2022-06-16 21:43:00","inspection_id":"75842039","dot_number":"395102","report_state":"WI","report_number":"2641006062","insp_date":"2022-06-15 00:00:00","insp_start_time":"1103","insp_end_time":"1118","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"94","county_code_state":"WI","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"863488","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2022-06-16 21:43:00","snet_input_date":"2022-06-16 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:48.000000Z","updated_at":"2025-03-17T18:38:48.000000Z","inspection_violations":[{"id":985499,"change_date":"2022-06-16 21:43:00","inspection_id":"75842039","insp_violation_id":"246517710","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1009999,"change_date":"2022-06-16 21:43:00","inspection_id":"75842039","insp_unit_id":"189296354","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2520083","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMMN3HH693794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:24.000000Z","updated_at":"2025-03-17T22:14:24.000000Z"}]},{"id":573471,"change_date":"2022-06-09 21:42:00","inspection_id":"75776198","dot_number":"395102","report_state":"MI","report_number":"LITTJ04011","insp_date":"2022-06-06 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E\/B @ SCHAEFER","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1078635","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":null,"census_search_date":"2022-06-09 21:42:00","snet_input_date":"2022-06-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-09 21:42:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:47.000000Z","updated_at":"2025-03-17T18:37:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":922235,"change_date":"2022-06-09 21:42:00","inspection_id":"75776198","insp_unit_id":"189140609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"268","insp_unit_license":"3155354","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC4MDMR8355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"}]},{"id":82476,"change_date":"2022-03-31 21:41:00","inspection_id":"75189029","dot_number":"395102","report_state":"WI","report_number":"2733000995","insp_date":"2022-03-29 00:00:00","insp_start_time":"1009","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":"14(71)","location_desc":"REMINGTON (TOWN)","county_code_state":"WI","county_code":"141","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"000005757899","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":"I","final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"856424","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00395102","upload_search_indicator":"M","census_search_date":"2022-03-31 21:41:00","snet_input_date":"2022-03-30 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"COLUMBIA PIPE AND SUPPLY CO","insp_carrier_street":"1120 W PERSHING RD","insp_carrier_city":"CHICAGO","insp_carrier_state":"IL","insp_carrier_zip_code":"60609-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:06.000000Z","updated_at":"2025-03-17T18:29:06.000000Z","inspection_violations":[{"id":121025,"change_date":"2022-03-31 21:41:00","inspection_id":"75189029","insp_violation_id":"244890497","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187922933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:40.000000Z","updated_at":"2025-03-17T21:07:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":133811,"change_date":"2022-03-31 21:41:00","inspection_id":"75189029","insp_unit_id":"187922933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"677055","insp_unit_license":"3105019","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXDT2GDHN6608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/395102\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/395102\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/395102\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/395102\/inspections","per_page":100,"prev_page_url":null,"to":28,"total":28}