{"current_page":1,"data":[{"id":6903266,"change_date":"2024-10-07 21:41:00","inspection_id":"82848032","dot_number":"592037","report_state":"IA","report_number":"000P123FKR","insp_date":"2024-10-04 00:00:00","insp_start_time":"1308","insp_end_time":"1323","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"N KENTUCKY AVE NB","county_code_state":"IA","county_code":"033","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":"2024-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1332302","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2024-10-07 21:41:00","snet_input_date":"2024-10-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-07 21:41:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:11.000000Z","updated_at":"2025-03-17T20:40:11.000000Z","inspection_violations":[{"id":10756523,"change_date":"2024-10-07 21:41:00","inspection_id":"82848032","insp_violation_id":"262222838","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1LOP24100413151","created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":11133329,"change_date":"2024-10-07 21:41:00","inspection_id":"82848032","insp_unit_id":"203298982","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75","insp_unit_license":"HN6360","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY0MM022006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:18.000000Z","updated_at":"2025-03-17T23:38:18.000000Z"},{"id":11133330,"change_date":"2024-10-07 21:41:00","inspection_id":"82848032","insp_unit_id":"203298983","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"75T","insp_unit_license":"HG8441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4733MH000171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:18.000000Z","updated_at":"2025-03-17T23:38:18.000000Z"}]},{"id":6118021,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","dot_number":"592037","report_state":"IA","report_number":"000P123D08","insp_date":"2024-06-28 00:00:00","insp_start_time":"0748","insp_end_time":"0907","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I35 NB","county_code_state":"IA","county_code":"033","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHARLSON EXCAVATING","shipping_paper_number":"OWN","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":"2024-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1319037","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:49.000000Z","updated_at":"2025-03-17T20:23:49.000000Z","inspection_violations":[{"id":9497866,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","insp_violation_id":"260409037","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:51:56.000000Z","updated_at":"2025-03-17T21:51:56.000000Z","normalized_code":"3922"},{"id":9497867,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","insp_violation_id":"260409038","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"201677501","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:56.000000Z","updated_at":"2025-03-17T21:51:56.000000Z","normalized_code":"39355C1"},{"id":9497868,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","insp_violation_id":"260409039","seq_no":"3","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:51:56.000000Z","updated_at":"2025-03-17T21:51:56.000000Z","normalized_code":"3922"},{"id":9497869,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","insp_violation_id":"260409040","seq_no":"4","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":"1LOP24062808535","created_at":"2025-03-17T21:51:56.000000Z","updated_at":"2025-03-17T21:51:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9854399,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","insp_unit_id":"201677501","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"71","insp_unit_license":"KR4867","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y69N006011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:05.000000Z","updated_at":"2025-03-17T23:25:05.000000Z"},{"id":9854400,"change_date":"2024-07-01 21:44:00","inspection_id":"82009537","insp_unit_id":"201677502","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILBLAZE","insp_unit_company":"72","insp_unit_license":"GU9912","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1C9SS422991425288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:05.000000Z","updated_at":"2025-03-17T23:25:05.000000Z"}]},{"id":6060845,"change_date":"2024-06-24 21:42:00","inspection_id":"81948182","dot_number":"592037","report_state":"IA","report_number":"000P123CZH","insp_date":"2024-06-20 00:00:00","insp_start_time":"0858","insp_end_time":"0919","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I35 SB","county_code_state":"IA","county_code":"069","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHARLSON EXCAVATING","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1317832","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":"00592037","upload_search_indicator":"M","census_search_date":"2024-06-24 21:42:00","snet_input_date":"2024-06-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-24 21:42:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:56.000000Z","updated_at":"2025-03-17T20:22:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9761718,"change_date":"2024-06-24 21:42:00","inspection_id":"81948182","insp_unit_id":"201556450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"71","insp_unit_license":"KR4867","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y69N006011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:07.000000Z","updated_at":"2025-03-17T23:24:07.000000Z"},{"id":9761719,"change_date":"2024-06-24 21:42:00","inspection_id":"81948182","insp_unit_id":"201556451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILBLAZE","insp_unit_company":"71","insp_unit_license":"GU9912","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1C9SS422991425288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:07.000000Z","updated_at":"2025-03-17T23:24:07.000000Z"}]},{"id":5598404,"change_date":"2024-04-25 21:43:00","inspection_id":"81446223","dot_number":"592037","report_state":"IA","report_number":"000P16D7BM","insp_date":"2024-04-24 00:00:00","insp_start_time":"1518","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"300TH S OF LARK","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHARLSON","shipping_paper_number":"ROCK","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":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"143000","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":"1310711","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:33.000000Z","updated_at":"2025-03-17T20:13:33.000000Z","inspection_violations":[{"id":8655539,"change_date":"2024-04-25 21:43:00","inspection_id":"81446223","insp_violation_id":"259144352","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9CUR24042415212","created_at":"2025-03-17T21:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9017698,"change_date":"2024-04-25 21:43:00","inspection_id":"81446223","insp_unit_id":"200578476","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"HN6360","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY0MM022006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"},{"id":9017699,"change_date":"2024-04-25 21:43:00","inspection_id":"81446223","insp_unit_id":"200578477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":null,"insp_unit_license":"HG8441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4733MH000171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"}]},{"id":4684860,"change_date":"2023-12-21 21:39:00","inspection_id":"80449011","dot_number":"592037","report_state":"IA","report_number":"000P14WRD1","insp_date":"2023-12-13 00:00:00","insp_start_time":"0918","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I35 NB 196 MM","county_code_state":"IA","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CT PLEASANT VALLEY QUARRY","shipping_paper_number":"1323","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1297273","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-12-21 21:39:00","snet_input_date":"2023-12-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7239102,"change_date":"2023-12-21 21:39:00","inspection_id":"80449011","insp_violation_id":"257011226","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":"9GLA23121309312","created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"3922"},{"id":7239103,"change_date":"2023-12-21 21:39:00","inspection_id":"80449011","insp_violation_id":"257011227","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198622951","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":7535176,"change_date":"2023-12-21 21:39:00","inspection_id":"80449011","insp_unit_id":"198622950","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75","insp_unit_license":"HN6360","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY0MM022006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"},{"id":7535177,"change_date":"2023-12-21 21:39:00","inspection_id":"80449011","insp_unit_id":"198622951","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"75T","insp_unit_license":"HG8441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4733MH000171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"}]},{"id":4293301,"change_date":"2023-10-26 21:41:00","inspection_id":"80017810","dot_number":"592037","report_state":"IA","report_number":"000TT4WRBL","insp_date":"2023-10-25 00:00:00","insp_start_time":"1133","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 69 NB 149 MM BLAIRSBURG","county_code_state":"IA","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTENTEED","shipping_paper_number":"6881","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-10-26 21:41: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":"1292556","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:53.000000Z","updated_at":"2025-03-17T19:47:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6904667,"change_date":"2023-10-26 21:41:00","inspection_id":"80017810","insp_unit_id":"197764877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"74","insp_unit_license":"HN6292","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY2MM022007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:53.000000Z","updated_at":"2025-03-17T22:57:53.000000Z"},{"id":6904668,"change_date":"2023-10-26 21:41:00","inspection_id":"80017810","insp_unit_id":"197764878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JET","insp_unit_company":"T74","insp_unit_license":"HC3925","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4739MH000160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:53.000000Z","updated_at":"2025-03-17T22:57:53.000000Z"}]},{"id":3734147,"change_date":"2023-08-14 21:42:00","inspection_id":"79396413","dot_number":"592037","report_state":"IA","report_number":"000TT688SN","insp_date":"2023-08-10 00:00:00","insp_start_time":"1005","insp_end_time":"1031","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 SB","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHARLSON EXCAVATING COMPANY INC","shipping_paper_number":"SELF","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-08-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1284599","transaction_code":"A","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-08-14 21:42:00","snet_input_date":"2023-08-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-14 21:42:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:31.000000Z","updated_at":"2025-03-17T19:36:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6003949,"change_date":"2023-08-14 21:42:00","inspection_id":"79396413","insp_unit_id":"196511128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75","insp_unit_license":"HN6360","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY0MM022006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"},{"id":6003950,"change_date":"2023-08-14 21:42:00","inspection_id":"79396413","insp_unit_id":"196511129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"75T","insp_unit_license":"HG8441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4733MH000171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"}]},{"id":3578020,"change_date":"2023-07-24 21:42:00","inspection_id":"79221743","dot_number":"592037","report_state":"IA","report_number":"000TT66VKK","insp_date":"2023-07-18 00:00:00","insp_start_time":"0808","insp_end_time":"0825","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I 35 NB 165 MM LATIMER","county_code_state":"IA","county_code":"069","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTAINTEED GYPSUM","shipping_paper_number":"13446","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-07-24 21:42: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":"1281536","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:35.000000Z","updated_at":"2025-03-17T19:33:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5752998,"change_date":"2023-07-24 21:42:00","inspection_id":"79221743","insp_unit_id":"196156580","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75","insp_unit_license":"HN6360","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY0MM022006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"},{"id":5752999,"change_date":"2023-07-24 21:42:00","inspection_id":"79221743","insp_unit_id":"196156581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"75T","insp_unit_license":"HG8441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4733MH000171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"}]},{"id":2975924,"change_date":"2023-05-05 21:42:00","inspection_id":"78543507","dot_number":"592037","report_state":"IA","report_number":"000P14KGQX","insp_date":"2023-05-03 00:00:00","insp_start_time":"0649","insp_end_time":"0701","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 148 MM NB","county_code_state":"IA","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","pen_cen_match":null,"final_status_date":"2023-05-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"1273678","transaction_code":"A","transaction_date":"2023-05-05 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-05-05 21:42:00","snet_input_date":"2023-05-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-05 21:42:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:53.000000Z","updated_at":"2025-03-17T19:21:53.000000Z","inspection_violations":[{"id":4567296,"change_date":"2023-05-05 21:42:00","inspection_id":"78543507","insp_violation_id":"252650889","seq_no":"1","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:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4787787,"change_date":"2023-05-05 21:42:00","inspection_id":"78543507","insp_unit_id":"194774441","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"72","insp_unit_license":"FF7353","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW21Y8EM037820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:44.000000Z","updated_at":"2025-03-17T22:40:44.000000Z"},{"id":4787788,"change_date":"2023-05-05 21:42:00","inspection_id":"78543507","insp_unit_id":"194774442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":"GU9912","insp_unit_license":"GU9912","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1C9SS422991425288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:44.000000Z","updated_at":"2025-03-17T22:40:44.000000Z"}]},{"id":2954405,"change_date":"2023-05-03 21:41:00","inspection_id":"78518900","dot_number":"592037","report_state":"IA","report_number":"000TT6ZVRF","insp_date":"2023-05-02 00:00:00","insp_start_time":"1435","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"JONQUIL AVE AND 300TH EB TOWAR","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"N","pen_cen_match":null,"final_status_date":"2023-05-03 21:41: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":"1273479","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-05-03 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:24.000000Z","updated_at":"2025-03-17T19:21:24.000000Z","inspection_violations":[{"id":4534461,"change_date":"2023-05-03 21:41:00","inspection_id":"78518900","insp_violation_id":"252592037","seq_no":"1","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:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4753813,"change_date":"2023-05-03 21:41:00","inspection_id":"78518900","insp_unit_id":"194725065","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"TRAILBLAZE","insp_unit_company":"NONE","insp_unit_license":"GU9878","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1C9SS422791425290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"},{"id":4753814,"change_date":"2023-05-03 21:41:00","inspection_id":"78518900","insp_unit_id":"194725066","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"MACK","insp_unit_company":"73","insp_unit_license":"FF7343","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW07YXEM040374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"}]},{"id":2827258,"change_date":"2023-04-18 21:41:00","inspection_id":"78375162","dot_number":"592037","report_state":"IA","report_number":"000P123CTN","insp_date":"2023-04-13 00:00:00","insp_start_time":"1114","insp_end_time":"1129","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 122 WB","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHARLSON EXCAVATING","shipping_paper_number":"DIRT","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-04-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1270764","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":"M","census_search_date":"2023-04-18 21:41:00","snet_input_date":"2023-04-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-18 21:41:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY OF CLEAR LAKE","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[{"id":4338194,"change_date":"2023-04-18 21:41:00","inspection_id":"78375162","insp_violation_id":"252283799","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1LOP23041311203","created_at":"2025-03-17T21:27:15.000000Z","updated_at":"2025-03-17T21:27:15.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4550752,"change_date":"2023-04-18 21:41:00","inspection_id":"78375162","insp_unit_id":"194444233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"75","insp_unit_license":"HN6360","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY0MM022006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"},{"id":4550753,"change_date":"2023-04-18 21:41:00","inspection_id":"78375162","insp_unit_id":"194444234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"75T","insp_unit_license":"HG8441","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4733MH000171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"}]},{"id":1707248,"change_date":"2022-11-09 21:40:00","inspection_id":"77096805","dot_number":"592037","report_state":"IA","report_number":"000TT8BC7Q","insp_date":"2022-11-08 00:00:00","insp_start_time":"1107","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"4TH ST SW\/EISENHOWER","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHARLSON EXCAVATING","shipping_paper_number":"ROCK","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-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250357","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00592037","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"CHARLSON EXCAVATING COMPANY INC","insp_carrier_street":"4111 7TH AVE N","insp_carrier_city":"CLEAR LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2675288,"change_date":"2022-11-09 21:40:00","inspection_id":"77096805","insp_violation_id":"249517618","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39216A"},{"id":2675289,"change_date":"2022-11-09 21:40:00","inspection_id":"77096805","insp_violation_id":"249517619","seq_no":"2","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":"T28522110811395","created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"},{"id":2675290,"change_date":"2022-11-09 21:40:00","inspection_id":"77096805","insp_violation_id":"249517620","seq_no":"3","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":"T28522110811413","created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2746465,"change_date":"2022-11-09 21:40:00","inspection_id":"77096805","insp_unit_id":"191882230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2007","insp_unit_license":"HN6292","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AN4GY2MM022007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2746466,"change_date":"2022-11-09 21:40:00","inspection_id":"77096805","insp_unit_id":"191882231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JETC","insp_unit_company":"0160","insp_unit_license":"HC3925","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JNSS4739MH000160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/592037\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/592037\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/592037\/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\/592037\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}