{"current_page":1,"data":[{"id":12637939,"change_date":"2026-08-05 21:41:00","inspection_id":"88609414","dot_number":"895169","report_state":"MO","report_number":"1645004700","insp_date":"2026-08-04 00:00:00","insp_start_time":"1021","insp_end_time":"1041","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL STONE COMPANY","shipping_paper_number":"497095968","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":"2026-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72740","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3909227","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2026-08-05 21:41:00","snet_input_date":"2026-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-05 21:41:00","insp_carrier_name":"CANNON EXCAVATION COMPANY LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-08T09:41:08.000000Z","updated_at":"2026-08-08T09:41:08.000000Z","inspection_violations":[{"id":22004030,"change_date":"2026-08-05 21:41:00","inspection_id":"88609414","insp_violation_id":"275936546","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214988980","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-08T10:00:34.000000Z","updated_at":"2026-08-08T10:00:34.000000Z","normalized_code":"39617CPI"},{"id":22004031,"change_date":"2026-08-05 21:41:00","inspection_id":"88609414","insp_violation_id":"275936547","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"214988980","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-08T10:00:34.000000Z","updated_at":"2026-08-08T10:00:34.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":21938193,"change_date":"2026-08-05 21:41:00","inspection_id":"88609414","insp_unit_id":"214988980","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"119","insp_unit_license":"78J7VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDV2KLKK5750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-08T09:18:41.000000Z","updated_at":"2026-08-08T09:18:41.000000Z"}]},{"id":12017709,"change_date":"2026-05-26 21:40:00","inspection_id":"87957155","dot_number":"895169","report_state":"MO","report_number":"W134009106","insp_date":"2026-05-26 00:00:00","insp_start_time":"0830","insp_end_time":"0909","registration_date":null,"region":"CD","ci_status_code":"C","location":"E2N","location_desc":"STEELE MO","county_code_state":"MO","county_code":"155","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-26 21:40: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":"3404021","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2026-05-26 21:40:00","snet_input_date":"2026-05-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-26 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-29T09:39:58.000000Z","updated_at":"2026-06-06T09:31:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20889549,"change_date":"2026-05-26 21:40:00","inspection_id":"87957155","insp_unit_id":"213751808","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT-30","insp_unit_license":"93KT9B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAVDVXLPLZ9289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:32.000000Z","updated_at":"2026-06-06T09:03:53.000000Z"},{"id":20889550,"change_date":"2026-05-26 21:40:00","inspection_id":"87957155","insp_unit_id":"213751809","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KRUZ","insp_unit_company":null,"insp_unit_license":"48L6XL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1K9SD3624PK226830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:32.000000Z","updated_at":"2026-06-06T09:03:53.000000Z"}]},{"id":12025825,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","dot_number":"895169","report_state":"MO","report_number":"0384001228","insp_date":"2026-05-26 00:00:00","insp_start_time":"1415","insp_end_time":"1535","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TROY MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGRUDER LIMESTONE COMPANY","shipping_paper_number":"201193737","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":"U","pen_cen_match":"I","final_status_date":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"9","oos_total":"4","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3408774","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:28.000000Z","updated_at":"2026-06-07T09:30:40.000000Z","inspection_violations":[{"id":20926560,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522510","seq_no":"3","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"213768714","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"393207ASAPPAS"},{"id":20926563,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522513","seq_no":"6","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"213768714","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"39375GTAOW"},{"id":20926558,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522508","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"3922SLLEWA3"},{"id":20926559,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522509","seq_no":"2","part_no":"393","part_no_section":"75G-TFWETL","insp_viol_unit":"1","insp_unit_id":"213768714","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"39375GTFWETL"},{"id":20926561,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522511","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213768714","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"3939ALCL"},{"id":20926562,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522512","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"3922SLLEWA3"},{"id":20926564,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522514","seq_no":"7","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"213768714","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"39375GTAOW"},{"id":20926565,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522515","seq_no":"8","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"3922SLLEWA3"},{"id":20926566,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_violation_id":"274522516","seq_no":"9","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-05-30T09:57:30.000000Z","updated_at":"2026-06-07T09:42:03.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":20903453,"change_date":"2026-05-27 21:40:00","inspection_id":"87965666","insp_unit_id":"213768714","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-117","insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:30.000000Z","updated_at":"2026-06-07T09:01:59.000000Z"}]},{"id":11944875,"change_date":"2026-05-17 21:35:00","inspection_id":"87880193","dot_number":"895169","report_state":"MO","report_number":"0672002623","insp_date":"2026-05-11 00:00:00","insp_start_time":"1618","insp_end_time":"1651","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"NEW FLORENCE MO","county_code_state":"MO","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CAPITAL QUARRIES","shipping_paper_number":"228010363","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":"U","pen_cen_match":"I","final_status_date":"2026-05-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"3349159","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2026-05-17 21:35:00","snet_input_date":"2026-05-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-17 21:35:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-20T09:41:10.000000Z","updated_at":"2026-05-28T09:30:16.000000Z","inspection_violations":[{"id":20775641,"change_date":"2026-05-17 21:35:00","inspection_id":"87880193","insp_violation_id":"274322887","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","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":"2026-05-20T10:02:10.000000Z","updated_at":"2026-05-28T09:39:47.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":20770794,"change_date":"2026-05-17 21:35:00","inspection_id":"87880193","insp_unit_id":"213609034","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-121","insp_unit_license":"98J6WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV5KPKV0884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:19.000000Z","updated_at":"2026-05-28T09:02:00.000000Z"}]},{"id":11658454,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","dot_number":"895169","report_state":"MO","report_number":"0384001167","insp_date":"2026-04-14 00:00:00","insp_start_time":"1200","insp_end_time":"1315","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLS MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGRUDER LIMESTONE COMPANY","shipping_paper_number":"201189737","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":"U","pen_cen_match":"I","final_status_date":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"6","oos_total":"1","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3162893","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:30.000000Z","updated_at":"2026-04-27T09:30:30.000000Z","inspection_violations":[{"id":20247967,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_violation_id":"273631562","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-04-27T09:42:55.000000Z","updated_at":"2026-04-27T09:42:55.000000Z","normalized_code":"3922SLLEWA3"},{"id":20247964,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_violation_id":"273631559","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-04-27T09:42:55.000000Z","updated_at":"2026-04-27T09:42:55.000000Z","normalized_code":"3922SLLEWA3"},{"id":20247965,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_violation_id":"273631560","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-04-27T09:42:55.000000Z","updated_at":"2026-04-27T09:42:55.000000Z","normalized_code":"3922SLLEWA3"},{"id":20247966,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_violation_id":"273631561","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA3","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":"2026-04-27T09:42:55.000000Z","updated_at":"2026-04-27T09:42:55.000000Z","normalized_code":"3922SLLEWA3"},{"id":20247963,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_violation_id":"273631558","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"213039120","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-04-27T09:42:55.000000Z","updated_at":"2026-04-27T09:42:55.000000Z","normalized_code":"393207ASAPPAS"},{"id":20247968,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_violation_id":"273631563","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213039120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:42:55.000000Z","updated_at":"2026-04-27T09:42:55.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":20280101,"change_date":"2026-04-16 21:40:00","inspection_id":"87588304","insp_unit_id":"213039120","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-117","insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:06.000000Z","updated_at":"2026-04-27T09:03:06.000000Z"}]},{"id":11318718,"change_date":"2026-03-08 21:33:00","inspection_id":"87235259","dot_number":"895169","report_state":"MO","report_number":"W157001090","insp_date":"2026-03-02 00:00:00","insp_start_time":"1605","insp_end_time":"1630","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"NEW BLOOMFIELD MO","county_code_state":"MO","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE PROVIDED","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":"2026-03-08 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"184664","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":"2978697","transaction_code":"A","transaction_date":"2026-03-07 00:00:00","upload_date":"2026-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2026-03-08 21:33:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-08 21:33:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-11T09:38:21.000000Z","updated_at":"2026-03-19T09:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19365683,"change_date":"2026-03-08 21:33:00","inspection_id":"87235259","insp_unit_id":"212032643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT98","insp_unit_license":"78J8VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKPDCCJ8WK951399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:26.000000Z","updated_at":"2026-03-19T09:02:07.000000Z"},{"id":19365684,"change_date":"2026-03-08 21:33:00","inspection_id":"87235259","insp_unit_id":"212032644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"T 19","insp_unit_license":"34F7HC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"57JE52303K3575470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:26.000000Z","updated_at":"2026-03-19T09:02:07.000000Z"}]},{"id":10097526,"change_date":"2025-11-01 21:32:00","inspection_id":"86212880","dot_number":"895169","report_state":"MO","report_number":"0384000992","insp_date":"2025-10-28 00:00:00","insp_start_time":"1310","insp_end_time":"1405","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLS MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2025-11-01 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"144500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2489596","transaction_code":"A","transaction_date":"2025-10-31 00:00:00","upload_date":"2025-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-11-01 21:32:00","snet_input_date":"2025-10-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-01 21:32:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-04T11:01:26.000000Z","updated_at":"2025-11-06T10:30:12.000000Z","inspection_violations":[{"id":16728837,"change_date":"2025-11-01 21:32:00","inspection_id":"86212880","insp_violation_id":"269669467","seq_no":"1","part_no":"393","part_no_section":"110B2I-C","insp_viol_unit":"2","insp_unit_id":"209785627","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-04T11:17:18.000000Z","updated_at":"2025-11-07T10:30:18.000000Z","normalized_code":"393110B2IC"},{"id":16728838,"change_date":"2025-11-01 21:32:00","inspection_id":"86212880","insp_violation_id":"269669468","seq_no":"2","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"209785626","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-04T11:17:18.000000Z","updated_at":"2025-11-07T10:30:18.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":16788822,"change_date":"2025-11-01 21:32:00","inspection_id":"86212880","insp_unit_id":"209785626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-24","insp_unit_license":"19J9XF","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMBPDV1SLVJ9097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-04T10:46:48.000000Z","updated_at":"2025-11-06T10:00:18.000000Z"},{"id":16788823,"change_date":"2025-11-01 21:32:00","inspection_id":"86212880","insp_unit_id":"209785627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BROOKS BRO","insp_unit_company":null,"insp_unit_license":"00L5HN","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1B9TS2134EM274031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-04T10:46:48.000000Z","updated_at":"2025-11-06T10:00:18.000000Z"}]},{"id":9863367,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","dot_number":"895169","report_state":"MO","report_number":"W140001199","insp_date":"2025-10-03 00:00:00","insp_start_time":"0645","insp_end_time":"0745","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLS MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGRUDER","shipping_paper_number":"201174264","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":"U","pen_cen_match":"I","final_status_date":"2025-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2372542","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-10-06 21:40:00","snet_input_date":"2025-10-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:46.000000Z","updated_at":"2025-10-10T10:00:52.000000Z","inspection_violations":[{"id":16251785,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117513","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209314229","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"39345B2BAIR"},{"id":16251786,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117514","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","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-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"3922SLLEWA2"},{"id":16251787,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117515","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","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-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"3922SLLEWA3"},{"id":16251788,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117516","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA3","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-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"3922SLLEWA3"},{"id":16251789,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117517","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA3","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-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"3922SLLEWA3"},{"id":16251790,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117518","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWA3","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-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"3922SLLEWA3"},{"id":16251791,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_violation_id":"269117519","seq_no":"7","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"209314230","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-09T10:16:08.000000Z","updated_at":"2025-10-10T10:16:29.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":16360313,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_unit_id":"209314229","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"93KT9B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAVDVXLPLZ9289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:44.000000Z","updated_at":"2025-10-10T09:46:09.000000Z"},{"id":16360314,"change_date":"2025-10-06 21:40:00","inspection_id":"85965972","insp_unit_id":"209314230","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPERIOR T","insp_unit_company":null,"insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:44.000000Z","updated_at":"2025-10-10T09:46:09.000000Z"}]},{"id":9779368,"change_date":"2025-09-25 21:41:00","inspection_id":"85877663","dot_number":"895169","report_state":"MO","report_number":"W137001831","insp_date":"2025-09-25 00:00:00","insp_start_time":"0816","insp_end_time":"0907","registration_date":null,"region":"CD","ci_status_code":"C","location":"A3W","location_desc":"MAYVIEW MO","county_code_state":"MO","county_code":"107","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2025-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2327519","transaction_code":"A","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-09-25 21:41:00","snet_input_date":"2025-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:09.000000Z","updated_at":"2025-09-30T10:00:30.000000Z","inspection_violations":[{"id":16079345,"change_date":"2025-09-25 21:41:00","inspection_id":"85877663","insp_violation_id":"268922213","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209144546","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-28T10:17:05.000000Z","updated_at":"2025-09-30T10:15:54.000000Z","normalized_code":"39375A3TAOL"},{"id":16079346,"change_date":"2025-09-25 21:41:00","inspection_id":"85877663","insp_violation_id":"268922214","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"209144547","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-28T10:17:05.000000Z","updated_at":"2025-09-30T10:15:54.000000Z","normalized_code":"39375A3TAOL"},{"id":16079347,"change_date":"2025-09-25 21:41:00","inspection_id":"85877663","insp_violation_id":"268922215","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"209144547","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-28T10:17:05.000000Z","updated_at":"2025-09-30T10:15:54.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":16203320,"change_date":"2025-09-25 21:41:00","inspection_id":"85877663","insp_unit_id":"209144546","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT40","insp_unit_license":"21KS5W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAED16LPLZ9447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:46:47.000000Z","updated_at":"2025-09-29T09:46:47.000000Z"},{"id":16203321,"change_date":"2025-09-25 21:41:00","inspection_id":"85877663","insp_unit_id":"209144547","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"43M3BG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4M9DS4022R1017225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:46:47.000000Z","updated_at":"2025-09-29T09:46:47.000000Z"}]},{"id":9556585,"change_date":"2025-08-31 21:33:00","inspection_id":"85644632","dot_number":"895169","report_state":"MO","report_number":"3512001036","insp_date":"2025-08-29 00:00:00","insp_start_time":"0825","insp_end_time":"0900","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FENTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-31 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2204276","transaction_code":"A","transaction_date":"2025-08-31 00:00:00","upload_date":"2025-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-08-31 21:33:00","snet_input_date":"2025-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-31 21:33:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:44.000000Z","updated_at":"2025-09-06T10:42:44.000000Z","inspection_violations":[{"id":15604862,"change_date":"2025-08-31 21:33:00","inspection_id":"85644632","insp_violation_id":"268372125","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208678673","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:50.000000Z","updated_at":"2025-09-06T10:46:50.000000Z","normalized_code":"39617CPI"},{"id":15604863,"change_date":"2025-08-31 21:33:00","inspection_id":"85644632","insp_violation_id":"268372126","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"208678673","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:50.000000Z","updated_at":"2025-09-06T10:46:50.000000Z","normalized_code":"3939ALSLI"},{"id":15604864,"change_date":"2025-08-31 21:33:00","inspection_id":"85644632","insp_violation_id":"268372127","seq_no":"3","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"208678673","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:50.000000Z","updated_at":"2025-09-06T10:46:50.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":15773561,"change_date":"2025-08-31 21:33:00","inspection_id":"85644632","insp_unit_id":"208678673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-116","insp_unit_license":"98J5WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDVXHPJG4233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:03.000000Z","updated_at":"2025-09-09T09:47:03.000000Z"}]},{"id":8969974,"change_date":"2025-06-24 21:40:00","inspection_id":"85027281","dot_number":"895169","report_state":"MO","report_number":"W190000964","insp_date":"2025-06-23 00:00:00","insp_start_time":"0959","insp_end_time":"1039","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SILVA MO","county_code_state":"MO","county_code":"223","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SCRAP MART METALS","shipping_paper_number":"012232","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"1907652","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-06-24 21:40:00","snet_input_date":"2025-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-24 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:48.000000Z","updated_at":"2025-06-28T10:00:48.000000Z","inspection_violations":[{"id":14413333,"change_date":"2025-06-24 21:40:00","inspection_id":"85027281","insp_violation_id":"267009068","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"207524538","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:17.000000Z","updated_at":"2025-06-28T10:17:20.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":14706056,"change_date":"2025-06-24 21:40:00","inspection_id":"85027281","insp_unit_id":"207524538","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT40","insp_unit_license":"21KS5W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAED16LPLZ9447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:35.000000Z","updated_at":"2025-06-28T09:45:32.000000Z"},{"id":14706057,"change_date":"2025-06-24 21:40:00","inspection_id":"85027281","insp_unit_id":"207524539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"41M4EL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4M9DS4022R1017225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:35.000000Z","updated_at":"2025-06-28T09:45:32.000000Z"}]},{"id":8164229,"change_date":"2025-03-20 21:41:00","inspection_id":"84176529","dot_number":"895169","report_state":"MO","report_number":"0672002095","insp_date":"2025-03-14 00:00:00","insp_start_time":"0825","insp_end_time":"0856","registration_date":null,"region":"CD","ci_status_code":"C","location":"A40","location_desc":"KINGDOM CITY MO","county_code_state":"MO","county_code":"027","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE SCOTTS COMPANY AND SUBSIDIARIES","shipping_paper_number":"423847876","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138250","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1492844","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-03-20 21:41:00","snet_input_date":"2025-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-20 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:45:59.000000Z","updated_at":"2025-03-24T10:24:11.000000Z","inspection_violations":[{"id":12786139,"change_date":"2025-03-20 21:41:00","inspection_id":"84176529","insp_violation_id":"265146148","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205895727","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:01:58.000000Z","updated_at":"2025-03-23T11:29:51.000000Z","normalized_code":"39360C"},{"id":12786140,"change_date":"2025-03-20 21:41:00","inspection_id":"84176529","insp_violation_id":"265146149","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"205895727","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:01:58.000000Z","updated_at":"2025-03-23T11:29:51.000000Z","normalized_code":"3939ALSLI"},{"id":12786141,"change_date":"2025-03-20 21:41:00","inspection_id":"84176529","insp_violation_id":"265146150","seq_no":"3","part_no":"393","part_no_section":"110B2I-C","insp_viol_unit":"2","insp_unit_id":"205895728","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-22T11:01:58.000000Z","updated_at":"2025-03-23T11:29:51.000000Z","normalized_code":"393110B2IC"}],"inspection_per_units":[{"id":13192420,"change_date":"2025-03-20 21:41:00","inspection_id":"84176529","insp_unit_id":"205895727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"PB13","insp_unit_license":"42KR5J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPWD49X6DD201730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:10:21.000000Z","updated_at":"2025-03-24T09:55:03.000000Z"},{"id":13192421,"change_date":"2025-03-20 21:41:00","inspection_id":"84176529","insp_unit_id":"205895728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILSON TRA","insp_unit_company":null,"insp_unit_license":"81K5FT","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4WWHGB6B9BN613922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:10:21.000000Z","updated_at":"2025-03-24T09:55:03.000000Z"}]},{"id":7742519,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","dot_number":"895169","report_state":"MO","report_number":"0384000677","insp_date":"2025-01-28 00:00:00","insp_start_time":"1200","insp_end_time":"1310","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TROY MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGRUDER LIMESTONE COMPANY","shipping_paper_number":"201154283","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":"U","pen_cen_match":"I","final_status_date":"2025-01-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"5","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":"1300471","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2025-01-30 21:40:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-30 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":12097661,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","insp_violation_id":"264245550","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","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-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLEWA3"},{"id":12097662,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","insp_violation_id":"264245551","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"205071836","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"39345B2BAIR"},{"id":12097663,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","insp_violation_id":"264245552","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA2","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-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLEWA2"},{"id":12097664,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","insp_violation_id":"264245553","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA3","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-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLEWA3"},{"id":12097665,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","insp_violation_id":"264245554","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA3","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-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":12494469,"change_date":"2025-01-30 21:40:00","inspection_id":"83733250","insp_unit_id":"205071836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS 116","insp_unit_license":"98J5WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDVXHPJG4233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7235505,"change_date":"2024-11-20 21:40:00","inspection_id":"83200355","dot_number":"895169","report_state":"IL","report_number":"0095001469","insp_date":"2024-11-13 00:00:00","insp_start_time":"1202","insp_end_time":"1231","registration_date":null,"region":"CS","ci_status_code":"C","location":"IDOT32","location_desc":"LITCHFIELD IL","county_code_state":"IL","county_code":"135","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CERTAINTEED","shipping_paper_number":"800874561","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1072332","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11670685,"change_date":"2024-11-20 21:40:00","inspection_id":"83200355","insp_unit_id":"203964164","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"18AR6J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKEDD3J12K972392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"},{"id":11670686,"change_date":"2024-11-20 21:40:00","inspection_id":"83200355","insp_unit_id":"203964165","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":null,"insp_unit_license":"55L1BZ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTE532S5L3198590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":7107202,"change_date":"2024-11-03 21:33:00","inspection_id":"83064606","dot_number":"895169","report_state":"MO","report_number":"0505000193","insp_date":"2024-10-28 00:00:00","insp_start_time":"1515","insp_end_time":"1600","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TROY MO","county_code_state":"MO","county_code":"113","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EASTERN MISSOURI CC","shipping_paper_number":"201149737","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":"U","pen_cen_match":"I","final_status_date":"2024-11-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"84520","viol_total":"2","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":"1014388","transaction_code":"A","transaction_date":"2024-11-03 00:00:00","upload_date":"2024-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-11-03 21:33:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-03 21:33:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:15.000000Z","updated_at":"2025-03-17T20:44:15.000000Z","inspection_violations":[{"id":11098606,"change_date":"2024-11-03 21:33:00","inspection_id":"83064606","insp_violation_id":"262695156","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203707825","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"39395A1"},{"id":11098607,"change_date":"2024-11-03 21:33:00","inspection_id":"83064606","insp_violation_id":"262695157","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","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:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11462818,"change_date":"2024-11-03 21:33:00","inspection_id":"83064606","insp_unit_id":"203707825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS115","insp_unit_license":"98J3WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDVXFLGK3197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"}]},{"id":6744498,"change_date":"2024-09-17 21:44:00","inspection_id":"82678782","dot_number":"895169","report_state":"MO","report_number":"0410000250","insp_date":"2024-09-17 00:00:00","insp_start_time":"1115","insp_end_time":"1154","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"IRONTON MO","county_code_state":"MO","county_code":"093","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":"U","pen_cen_match":"I","final_status_date":"2024-09-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"139220","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":"855357","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-09-17 21:44:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-17 21:44:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:54.000000Z","updated_at":"2025-03-17T20:36:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10875547,"change_date":"2024-09-17 21:44:00","inspection_id":"82678782","insp_unit_id":"202961678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT21","insp_unit_license":"79KR1U","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJABD19MPMD2274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:40.000000Z","updated_at":"2025-03-17T23:35:40.000000Z"},{"id":10875548,"change_date":"2024-09-17 21:44:00","inspection_id":"82678782","insp_unit_id":"202961679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPERIOR T","insp_unit_company":"1","insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:40.000000Z","updated_at":"2025-03-17T23:35:40.000000Z"}]},{"id":6353010,"change_date":"2024-08-08 21:41:00","inspection_id":"82261568","dot_number":"895169","report_state":"MO","report_number":"0384000452","insp_date":"2024-07-30 00:00:00","insp_start_time":"0840","insp_end_time":"0930","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BOWLING GREEN MO","county_code_state":"MO","county_code":"163","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2024-07-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"704026","transaction_code":"C","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-07-31 21:42:00","snet_input_date":"2024-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-31 21:42:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:42.000000Z","updated_at":"2025-03-17T20:28:42.000000Z","inspection_violations":[{"id":9863769,"change_date":"2024-08-08 21:41:00","inspection_id":"82261568","insp_violation_id":"261077744","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:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3922"},{"id":9863770,"change_date":"2024-08-08 21:41:00","inspection_id":"82261568","insp_violation_id":"261077745","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202289743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3922"},{"id":9863771,"change_date":"2024-08-08 21:41:00","inspection_id":"82261568","insp_violation_id":"261077746","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202289743","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10237955,"change_date":"2024-08-08 21:41:00","inspection_id":"82261568","insp_unit_id":"202289743","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT 40","insp_unit_license":"21KS5W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAED16LPLZ9447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:03.000000Z","updated_at":"2025-03-17T23:29:03.000000Z"},{"id":10237956,"change_date":"2024-08-08 21:41:00","inspection_id":"82261568","insp_unit_id":"202289744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"48L6XL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1K9SD3624PK226830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:03.000000Z","updated_at":"2025-03-17T23:29:03.000000Z"}]},{"id":6324803,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","dot_number":"895169","report_state":"MO","report_number":"0384000440","insp_date":"2024-07-23 00:00:00","insp_start_time":"1859","insp_end_time":"2015","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SILEX MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2024-07-27 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690018","transaction_code":"A","transaction_date":"2024-07-27 00:00:00","upload_date":"2024-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-07-27 21:31:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-27 21:31:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:14.000000Z","updated_at":"2025-03-17T20:28:14.000000Z","inspection_violations":[{"id":9820483,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873445","seq_no":"1","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"202102203","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"39311A1"},{"id":9820484,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873446","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202102203","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3922"},{"id":9820485,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873447","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202102204","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"39617C"},{"id":9820486,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873448","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202102203","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"39345B2"},{"id":9820487,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873449","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202102203","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3922"},{"id":9820488,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873450","seq_no":"6","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:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3922"},{"id":9820489,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873451","seq_no":"7","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"202102203","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"39360D"},{"id":9820490,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_violation_id":"260873452","seq_no":"8","part_no":"392","part_no_section":"5(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3925A2"}],"inspection_per_units":[{"id":10191370,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_unit_id":"202102203","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT 02","insp_unit_license":"18AR6J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKEDD3J12K972392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:34.000000Z","updated_at":"2025-03-17T23:28:34.000000Z"},{"id":10191371,"change_date":"2024-07-27 21:31:00","inspection_id":"82231310","insp_unit_id":"202102204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPERIOR T","insp_unit_company":null,"insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:34.000000Z","updated_at":"2025-03-17T23:28:34.000000Z"}]},{"id":5903838,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","dot_number":"895169","report_state":"MO","report_number":"0193000678","insp_date":"2024-06-03 00:00:00","insp_start_time":"0907","insp_end_time":"0956","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"UNION MO","county_code_state":"MO","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EASTERN MISSOURI CONCRETE","shipping_paper_number":"112008088","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":"U","pen_cen_match":"I","final_status_date":"2024-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"5","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":"536267","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-06-04 21:41:00","snet_input_date":"2024-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-04 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:48.000000Z","updated_at":"2025-03-17T20:19:48.000000Z","inspection_violations":[{"id":9155048,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_violation_id":"259880838","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:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"3922"},{"id":9155049,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_violation_id":"259880839","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":null,"created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"3922"},{"id":9155050,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_violation_id":"259880840","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:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"3922"},{"id":9155051,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_violation_id":"259880841","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201213953","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"39617C"},{"id":9155052,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_violation_id":"259880842","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201213954","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:15.000000Z","updated_at":"2025-03-17T21:50:15.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9509117,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_unit_id":"201213953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WT30","insp_unit_license":"93KT9B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAVDVXLPLZ9289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:38.000000Z","updated_at":"2025-03-17T23:21:38.000000Z"},{"id":9509118,"change_date":"2024-06-04 21:41:00","inspection_id":"81777887","insp_unit_id":"201213954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPERIOR T","insp_unit_company":null,"insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:38.000000Z","updated_at":"2025-03-17T23:21:38.000000Z"}]},{"id":5873591,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","dot_number":"895169","report_state":"MO","report_number":"0384000379","insp_date":"2024-05-30 00:00:00","insp_start_time":"0649","insp_end_time":"0810","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TROY MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGRUDER LIMESTONE COMPANY","shipping_paper_number":"201136891","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":"U","pen_cen_match":"I","final_status_date":"2024-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"527062","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-05-30 21:42:00","snet_input_date":"2024-05-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-30 21:42:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:06.000000Z","updated_at":"2025-03-17T20:19:06.000000Z","inspection_violations":[{"id":9107748,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805493","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201148526","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9107749,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805494","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":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9107750,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805495","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9107751,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805496","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201148526","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9107752,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805497","seq_no":"5","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9107753,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805498","seq_no":"6","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9107754,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_violation_id":"259805499","seq_no":"7","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":9460058,"change_date":"2024-05-30 21:42:00","inspection_id":"81744873","insp_unit_id":"201148526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"PB-21","insp_unit_license":"33J7VH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1NPCLPEX7LD631255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:09.000000Z","updated_at":"2025-03-17T23:21:09.000000Z"}]},{"id":5862623,"change_date":"2024-05-29 21:40:00","inspection_id":"81732985","dot_number":"895169","report_state":"MO","report_number":"5745000923","insp_date":"2024-05-28 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BUSSEN QUARRIES","shipping_paper_number":"10879470","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-05-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"521096","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-05-29 21:40:00","snet_input_date":"2024-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-29 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:02.000000Z","updated_at":"2025-03-17T20:19:02.000000Z","inspection_violations":[{"id":9088780,"change_date":"2024-05-29 21:40:00","inspection_id":"81732985","insp_violation_id":"259777285","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"201125993","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":9442368,"change_date":"2024-05-29 21:40:00","inspection_id":"81732985","insp_unit_id":"201125993","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STERLING T","insp_unit_company":"ST07","insp_unit_license":"04J6VL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2FZMAZCV27AX71040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:58.000000Z","updated_at":"2025-03-17T23:20:58.000000Z"}]},{"id":5798635,"change_date":"2024-05-21 21:45:00","inspection_id":"81663463","dot_number":"895169","report_state":"MO","report_number":"1645001253","insp_date":"2024-05-20 00:00:00","insp_start_time":"0843","insp_end_time":"0903","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","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":"U","pen_cen_match":"I","final_status_date":"2024-05-21 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"72740","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":"497570","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-05-21 21:45:00","snet_input_date":"2024-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-21 21:45:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:33.000000Z","updated_at":"2025-03-17T20:17:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9339499,"change_date":"2024-05-21 21:45:00","inspection_id":"81663463","insp_unit_id":"200994411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"119","insp_unit_license":"78J7VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDV2KLKK5750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"}]},{"id":4791191,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","dot_number":"895169","report_state":"MO","report_number":"0384000201","insp_date":"2024-01-05 00:00:00","insp_start_time":"1235","insp_end_time":"1345","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLS MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BMC SAND","shipping_paper_number":"24046926","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":"U","pen_cen_match":"I","final_status_date":"2024-01-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"165522","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-01-09 21:42:00","snet_input_date":"2024-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-09 21:42:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:39.000000Z","updated_at":"2025-03-17T19:57:39.000000Z","inspection_violations":[{"id":7392890,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249811","seq_no":"1","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"198873237","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"39375GTAOW"},{"id":7392891,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249812","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":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922"},{"id":7392892,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249813","seq_no":"3","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"198873237","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"39375GTAOW"},{"id":7392893,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249814","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":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922"},{"id":7392894,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249815","seq_no":"5","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:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922"},{"id":7392895,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249816","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"198873237","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922SLLSR"},{"id":7392896,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_violation_id":"257249817","seq_no":"7","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:41:41.000000Z","updated_at":"2025-03-17T21:41:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7708136,"change_date":"2024-01-09 21:42:00","inspection_id":"80564822","insp_unit_id":"198873237","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS 117","insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:54.000000Z","updated_at":"2025-03-17T23:04:54.000000Z"}]},{"id":4751003,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","dot_number":"895169","report_state":"MO","report_number":"0193000569","insp_date":"2023-12-29 00:00:00","insp_start_time":"0800","insp_end_time":"0902","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SAINT CLAIR MO","county_code_state":"MO","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EASTERN MISSOURI CONCRETE","shipping_paper_number":"112004894","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":"U","pen_cen_match":"I","final_status_date":"2024-01-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"72740","viol_total":"8","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"154536","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2024-01-03 21:43:00","snet_input_date":"2023-12-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-03 21:43:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:54.000000Z","updated_at":"2025-03-17T19:56:54.000000Z","inspection_violations":[{"id":7332233,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153125","seq_no":"1","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"198779002","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39375GTAOW"},{"id":7332234,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153126","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":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"},{"id":7332235,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153127","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:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"},{"id":7332236,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153128","seq_no":"4","part_no":"393","part_no_section":"75G-TFWETL","insp_viol_unit":"1","insp_unit_id":"198779002","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39375GTFWETL"},{"id":7332237,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153129","seq_no":"5","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:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"},{"id":7332238,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153130","seq_no":"6","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"198779002","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39375GTAOW"},{"id":7332239,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153131","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198779002","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39617CPI"},{"id":7332240,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_violation_id":"257153132","seq_no":"8","part_no":"393","part_no_section":"75G-TFWETL","insp_viol_unit":"1","insp_unit_id":"198779002","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39375GTFWETL"}],"inspection_per_units":[{"id":7642888,"change_date":"2024-01-03 21:43:00","inspection_id":"80520866","insp_unit_id":"198779002","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-118","insp_unit_license":"78J9VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDV6KLKK5749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:19.000000Z","updated_at":"2025-03-17T23:04:19.000000Z"}]},{"id":4696996,"change_date":"2023-12-23 21:32:00","inspection_id":"80462219","dot_number":"895169","report_state":"MO","report_number":"0193000560","insp_date":"2023-12-20 00:00:00","insp_start_time":"0950","insp_end_time":"1022","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WRIGHT CITY MO","county_code_state":"MO","county_code":"219","insp_level_id":"3","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"72740","viol_total":"2","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":"143273","transaction_code":"A","transaction_date":"2023-12-23 00:00:00","upload_date":"2023-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-12-23 21:32:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-23 21:32:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:49.000000Z","updated_at":"2025-03-17T19:55:49.000000Z","inspection_violations":[{"id":7256969,"change_date":"2023-12-23 21:32:00","inspection_id":"80462219","insp_violation_id":"257037502","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"},{"id":7256970,"change_date":"2023-12-23 21:32:00","inspection_id":"80462219","insp_violation_id":"257037503","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":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7554970,"change_date":"2023-12-23 21:32:00","inspection_id":"80462219","insp_unit_id":"198648154","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-118","insp_unit_license":"78J9VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDV6KLKK5749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:31.000000Z","updated_at":"2025-03-17T23:03:31.000000Z"}]},{"id":4696998,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","dot_number":"895169","report_state":"MO","report_number":"0193000561","insp_date":"2023-12-20 00:00:00","insp_start_time":"1050","insp_end_time":"1135","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WRIGHT CITY MO","county_code_state":"MO","county_code":"219","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"143279","transaction_code":"A","transaction_date":"2023-12-23 00:00:00","upload_date":"2023-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-12-23 21:32:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-23 21:32:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:49.000000Z","updated_at":"2025-03-17T19:55:49.000000Z","inspection_violations":[{"id":7256974,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","insp_violation_id":"257037507","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"},{"id":7256975,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","insp_violation_id":"257037508","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"198648157","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"393100BC"},{"id":7256976,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","insp_violation_id":"257037509","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"38323A2LCDLN"},{"id":7256977,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","insp_violation_id":"257037510","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":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"},{"id":7256978,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","insp_violation_id":"257037511","seq_no":"5","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:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7554973,"change_date":"2023-12-23 21:32:00","inspection_id":"80462221","insp_unit_id":"198648157","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS-117","insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:31.000000Z","updated_at":"2025-03-17T23:03:31.000000Z"}]},{"id":4503651,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","dot_number":"895169","report_state":"MO","report_number":"0384000145","insp_date":"2023-11-28 00:00:00","insp_start_time":"1505","insp_end_time":"1625","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TROY MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGRUDER LIMESTONE COMPANY","shipping_paper_number":"201124414","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":"U","pen_cen_match":"I","final_status_date":"2023-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"110127","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-11-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:10.000000Z","updated_at":"2025-03-17T19:52:10.000000Z","inspection_violations":[{"id":6970944,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585435","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922SLLTCD"},{"id":6970945,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585436","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"198233073","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39375GTAOW"},{"id":6970946,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585437","seq_no":"3","part_no":"393","part_no_section":"75G-TFWETL","insp_viol_unit":"1","insp_unit_id":"198233073","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39375GTFWETL"},{"id":6970947,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585438","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":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"},{"id":6970948,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585439","seq_no":"5","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:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"},{"id":6970949,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585440","seq_no":"6","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198233073","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39360C"},{"id":6970950,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585441","seq_no":"7","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:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"},{"id":6970951,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585442","seq_no":"8","part_no":"393","part_no_section":"60E","insp_viol_unit":"1","insp_unit_id":"198233073","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39360E"},{"id":6970952,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585443","seq_no":"9","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:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"},{"id":6970953,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_violation_id":"256585444","seq_no":"10","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:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7243453,"change_date":"2023-11-28 21:41:00","inspection_id":"80249794","insp_unit_id":"198233073","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"WS117","insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4468632,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","dot_number":"895169","report_state":"MO","report_number":"3725000260","insp_date":"2023-11-21 00:00:00","insp_start_time":"0914","insp_end_time":"0936","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CHESTERFIELD MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CANNON EXCAVATION 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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"137740","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"104577","transaction_code":"A","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-11-21 21:39:00","snet_input_date":"2023-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-21 21:39:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:25.000000Z","updated_at":"2025-03-17T19:51:25.000000Z","inspection_violations":[{"id":6917184,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502614","seq_no":"6","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39355EB"},{"id":6917185,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502615","seq_no":"7","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3939ALSML"},{"id":6917186,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502616","seq_no":"8","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"393100BC"},{"id":6917187,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502617","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39617CPI"},{"id":6917188,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502618","seq_no":"2","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39355C2"},{"id":6917189,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502619","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3939ALIL"},{"id":6917190,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502620","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"198156526","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3939ALLPL"},{"id":6917191,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_violation_id":"256502621","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198156527","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":7186701,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_unit_id":"198156526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BROOKS BRO","insp_unit_company":null,"insp_unit_license":"00L5HN","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1B9TS2134EM274031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:22.000000Z","updated_at":"2025-03-17T23:00:22.000000Z"},{"id":7186702,"change_date":"2023-11-21 21:39:00","inspection_id":"80211438","insp_unit_id":"198156527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"78J9VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDV6KLKK5749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:22.000000Z","updated_at":"2025-03-17T23:00:22.000000Z"}]},{"id":4409364,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","dot_number":"895169","report_state":"MO","report_number":"0257000018","insp_date":"2023-11-09 00:00:00","insp_start_time":"1153","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"C4W","location_desc":"POST C4 W.","county_code_state":"MO","county_code":"183","insp_level_id":"1","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-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2091891","transaction_code":"C","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-13 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:18.000000Z","updated_at":"2025-03-17T19:50:18.000000Z","inspection_violations":[{"id":6822957,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_violation_id":"256490696","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198146602","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3963A1"},{"id":6822958,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_violation_id":"256490697","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"198146602","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39375C"},{"id":6822959,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_violation_id":"256490698","seq_no":"3","part_no":"393","part_no_section":"13(b)","insp_viol_unit":"1","insp_unit_id":"198146602","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39313B"},{"id":6822960,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_violation_id":"256490699","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"198146603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39311"},{"id":6822961,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_violation_id":"256490700","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"198146602","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39348A"},{"id":6822962,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_violation_id":"256490701","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"198146602","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":7091268,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_unit_id":"198146602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"40","insp_unit_license":"2AKS5W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KJJAED16LPLZ9447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"},{"id":7091269,"change_date":"2023-11-20 21:40:00","inspection_id":"80146335","insp_unit_id":"198146603","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"KMAR","insp_unit_company":null,"insp_unit_license":"48L6XL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1K9SD3624PK226830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"}]},{"id":4356614,"change_date":"2023-11-05 21:30:00","inspection_id":"80087617","dot_number":"895169","report_state":"MO","report_number":"W140000140","insp_date":"2023-10-31 00:00:00","insp_start_time":"0811","insp_end_time":"0843","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"OLD MONROE MO","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BMC SAND","shipping_paper_number":"24045913","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":"U","pen_cen_match":"I","final_status_date":"2023-11-05 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"89200","viol_total":"4","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":"86583","transaction_code":"A","transaction_date":"2023-11-05 00:00:00","upload_date":"2023-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-11-05 21:30:00","snet_input_date":"2023-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-05 21:30:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:09.000000Z","updated_at":"2025-03-17T19:49:09.000000Z","inspection_violations":[{"id":6739755,"change_date":"2023-11-05 21:30:00","inspection_id":"80087617","insp_violation_id":"256224133","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:38:24.000000Z","updated_at":"2025-03-17T21:38:24.000000Z","normalized_code":"3922"},{"id":6739756,"change_date":"2023-11-05 21:30:00","inspection_id":"80087617","insp_violation_id":"256224134","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":null,"created_at":"2025-03-17T21:38:24.000000Z","updated_at":"2025-03-17T21:38:24.000000Z","normalized_code":"3922"},{"id":6739757,"change_date":"2023-11-05 21:30:00","inspection_id":"80087617","insp_violation_id":"256224135","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:38:24.000000Z","updated_at":"2025-03-17T21:38:24.000000Z","normalized_code":"3922"},{"id":6739758,"change_date":"2023-11-05 21:30:00","inspection_id":"80087617","insp_violation_id":"256224136","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"197911203","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:24.000000Z","updated_at":"2025-03-17T21:38:24.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":7006697,"change_date":"2023-11-05 21:30:00","inspection_id":"80087617","insp_unit_id":"197911203","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"04J6WM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV3LLKY5335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:49.000000Z","updated_at":"2025-03-17T22:58:49.000000Z"}]},{"id":3919972,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","dot_number":"895169","report_state":"MO","report_number":"0769000008","insp_date":"2023-09-07 00:00:00","insp_start_time":"0939","insp_end_time":"1033","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TROYMO","county_code_state":"MO","county_code":"113","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2023-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"5","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":"49951","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-09-07 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-07 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:09.000000Z","updated_at":"2025-03-17T19:40:09.000000Z","inspection_violations":[{"id":6058568,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_violation_id":"255124922","seq_no":"1","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"196935384","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3939ALBL"},{"id":6058569,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_violation_id":"255124923","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196935384","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39395F"},{"id":6058570,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_violation_id":"255124924","seq_no":"3","part_no":"393","part_no_section":"60E","insp_viol_unit":"1","insp_unit_id":"196935384","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39360E"},{"id":6058571,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_violation_id":"255124925","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"196935384","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39345DB"},{"id":6058572,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_violation_id":"255124926","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"196935385","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":6303324,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_unit_id":"196935384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"78J8VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKPDCCJ8WK951399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"},{"id":6303325,"change_date":"2023-09-07 21:40:00","inspection_id":"79603852","insp_unit_id":"196935385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"43M3BG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4M9DS2822R1017024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"}]},{"id":3920141,"change_date":"2023-09-07 21:40:00","inspection_id":"79604032","dot_number":"895169","report_state":"MO","report_number":"0769000009","insp_date":"2023-09-07 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLSMO","county_code_state":"MO","county_code":"113","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2023-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"50117","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-09-07 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-07 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:24.000000Z","updated_at":"2025-03-17T19:40:24.000000Z","inspection_violations":[{"id":6059069,"change_date":"2023-09-07 21:40:00","inspection_id":"79604032","insp_violation_id":"255125476","seq_no":"1","part_no":"391","part_no_section":"11(b)(4)","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:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":6303615,"change_date":"2023-09-07 21:40:00","inspection_id":"79604032","insp_unit_id":"196935697","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"Y","insp_unit_decal_number":"33044649","created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"}]},{"id":3929707,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","dot_number":"895169","report_state":"MO","report_number":"0230000038","insp_date":"2023-09-07 00:00:00","insp_start_time":"1236","insp_end_time":"1328","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLSMO","county_code_state":"MO","county_code":"113","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BIG CREEK QUARRY","shipping_paper_number":"798256","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":"U","pen_cen_match":"I","final_status_date":"2023-09-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","viol_total":"10","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":"50465","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-09-08 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-08 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:27.000000Z","updated_at":"2025-03-17T19:40:27.000000Z","inspection_violations":[{"id":6073942,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151318","seq_no":"1","part_no":"393","part_no_section":"106B-C","insp_viol_unit":"1","insp_unit_id":"196957240","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"393106BC"},{"id":6073943,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151319","seq_no":"2","part_no":"393","part_no_section":"41-BNPB-SPR","insp_viol_unit":"1","insp_unit_id":"196957240","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39341BNPBSPR"},{"id":6073944,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151320","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196957240","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39360C"},{"id":6073945,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151321","seq_no":"4","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"196957240","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39345B2B"},{"id":6073946,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151322","seq_no":"5","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"196957240","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3939ALSML"},{"id":6073947,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151323","seq_no":"6","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:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3922"},{"id":6073948,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151324","seq_no":"7","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39216D"},{"id":6073949,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151325","seq_no":"8","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:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3922"},{"id":6073950,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151326","seq_no":"9","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:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3922"},{"id":6073951,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_violation_id":"255151327","seq_no":"10","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:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6318716,"change_date":"2023-09-08 21:40:00","inspection_id":"79614698","insp_unit_id":"196957240","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"98J5WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDVXHPJG4233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:04.000000Z","updated_at":"2025-03-17T22:53:04.000000Z"}]},{"id":3929719,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","dot_number":"895169","report_state":"MO","report_number":"0193000013","insp_date":"2023-09-07 00:00:00","insp_start_time":"0932","insp_end_time":"1040","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TROYMO","county_code_state":"MO","county_code":"113","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2023-09-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"50458","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-09-08 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-08 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:27.000000Z","updated_at":"2025-03-17T19:40:27.000000Z","inspection_violations":[{"id":6073976,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151354","seq_no":"1","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39348ABIBD"},{"id":6073977,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151355","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39348ABIBD"},{"id":6073978,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151356","seq_no":"3","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39345B2B"},{"id":6073979,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151357","seq_no":"4","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39348ABIBD"},{"id":6073980,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151358","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3963A1BOS"},{"id":6073981,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151359","seq_no":"6","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39348ABIBD"},{"id":6073982,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151360","seq_no":"7","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39345DB"},{"id":6073983,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_violation_id":"255151361","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"196957263","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":6318735,"change_date":"2023-09-08 21:40:00","inspection_id":"79614711","insp_unit_id":"196957263","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"78J6VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKHAXDV4GPHM1169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:04.000000Z","updated_at":"2025-03-17T22:53:04.000000Z"}]},{"id":3929761,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","dot_number":"895169","report_state":"MO","report_number":"0193000014","insp_date":"2023-09-07 00:00:00","insp_start_time":"1206","insp_end_time":"1240","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLSMO","county_code_state":"MO","county_code":"113","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-09-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","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":"50459","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":"2023-09-08 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-08 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:27.000000Z","updated_at":"2025-03-17T19:40:27.000000Z","inspection_violations":[{"id":6074095,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","insp_violation_id":"255151498","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196957342","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39347E"},{"id":6074096,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","insp_violation_id":"255151499","seq_no":"2","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"196957342","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3963A1ALBV"},{"id":6074097,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","insp_violation_id":"255151500","seq_no":"3","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"196957342","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39355D1B"},{"id":6074098,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","insp_violation_id":"255151501","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"196957342","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39353BB"},{"id":6074099,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","insp_violation_id":"255151502","seq_no":"5","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":6318801,"change_date":"2023-09-08 21:40:00","inspection_id":"79614760","insp_unit_id":"196957342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STERLING T","insp_unit_company":null,"insp_unit_license":"04J6VL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2FZMAZCV27AX71040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:04.000000Z","updated_at":"2025-03-17T22:53:04.000000Z"}]},{"id":3193721,"change_date":"2023-06-01 21:43:00","inspection_id":"78789277","dot_number":"895169","report_state":"MO","report_number":"W100000709","insp_date":"2023-05-31 00:00:00","insp_start_time":"1045","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":"C2W","location_desc":"WESTBOUND SCALES ST. CLAIR","county_code_state":"MO","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CAPITAL SAND COMPANY","shipping_paper_number":"1339669","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-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2077086","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":"00895169","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","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":[{"id":4919598,"change_date":"2023-06-01 21:43:00","inspection_id":"78789277","insp_violation_id":"253215669","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195261775","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"3922"},{"id":4919599,"change_date":"2023-06-01 21:43:00","inspection_id":"78789277","insp_violation_id":"253215670","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195261775","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5136921,"change_date":"2023-06-01 21:43:00","inspection_id":"78789277","insp_unit_id":"195261775","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WT98","insp_unit_license":"78J8VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKPDCCJ8WK951399","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":5136922,"change_date":"2023-06-01 21:43:00","inspection_id":"78789277","insp_unit_id":"195261776","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPR","insp_unit_company":null,"insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","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":3193836,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","dot_number":"895169","report_state":"MO","report_number":"W005008825","insp_date":"2023-05-31 00:00:00","insp_start_time":"0704","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"C2E","location_desc":"C2E","county_code_state":"MO","county_code":"071","insp_level_id":"1","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-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2076997","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":"00895169","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","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":[{"id":4919800,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","insp_violation_id":"253215976","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195262022","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39345B2"},{"id":4919801,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","insp_violation_id":"253215977","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195262023","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"},{"id":4919802,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","insp_violation_id":"253215978","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195262023","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"},{"id":4919803,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","insp_violation_id":"253215979","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195262023","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5137110,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","insp_unit_id":"195262022","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WT98","insp_unit_license":"78J8VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKPDCCJ8WK951399","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":5137111,"change_date":"2023-06-01 21:43:00","inspection_id":"78789417","insp_unit_id":"195262023","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPI","insp_unit_company":null,"insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","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":2413150,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","dot_number":"895169","report_state":"MO","report_number":"0384001609","insp_date":"2023-02-10 00:00:00","insp_start_time":"0735","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":"C61","location_desc":"US 61 SB @ TROY","county_code_state":"MO","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MAGRUDER LIMESTONE COMPANY","shipping_paper_number":"201101422","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-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"7","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2059411","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-21 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-21 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:05.000000Z","updated_at":"2025-03-17T19:11:05.000000Z","inspection_violations":[{"id":3714237,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243517","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39141A1"},{"id":3714238,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243518","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":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"},{"id":3714239,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243519","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:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"},{"id":3714240,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243520","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":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"},{"id":3714241,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243521","seq_no":"5","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:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"},{"id":3714242,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243522","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193496244","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"},{"id":3714243,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_violation_id":"251243523","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193496244","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3883086,"change_date":"2023-02-21 21:41:00","inspection_id":"77904176","insp_unit_id":"193496244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"PB 21","insp_unit_license":"33J7VH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1NPCLPEX7LD631255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:48.000000Z","updated_at":"2025-03-17T22:33:48.000000Z"}]},{"id":2346870,"change_date":"2023-02-10 21:40:00","inspection_id":"77828348","dot_number":"895169","report_state":"MO","report_number":"1507019768","insp_date":"2023-02-09 00:00:00","insp_start_time":"1317","insp_end_time":"1359","registration_date":null,"region":"CT","ci_status_code":"C","location":"C70","location_desc":"I-70 @ 5TH STREET","county_code_state":"MO","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HOLCIM","shipping_paper_number":"13172033","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-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"89200","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":"2057925","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-10 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-10 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:57.000000Z","updated_at":"2025-03-17T19:09:57.000000Z","inspection_violations":[{"id":3613753,"change_date":"2023-02-10 21:40:00","inspection_id":"77828348","insp_violation_id":"251071754","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:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3776652,"change_date":"2023-02-10 21:40:00","inspection_id":"77828348","insp_unit_id":"193343121","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"04J6WM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV3LLKY5335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:03.000000Z","updated_at":"2025-03-17T22:33:03.000000Z"}]},{"id":2167090,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","dot_number":"895169","report_state":"MO","report_number":"SLC7000874","insp_date":"2023-01-17 00:00:00","insp_start_time":"0733","insp_end_time":"0806","registration_date":null,"region":"CT","ci_status_code":"C","location":"C141","location_desc":"MO 141 AT GRAVOIS BLUFFS","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARGILL","shipping_paper_number":"ASI-9","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":"I","final_status_date":"2023-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2054061","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-18 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:36.000000Z","updated_at":"2025-03-17T19:06:36.000000Z","inspection_violations":[{"id":3351437,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_violation_id":"250632311","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39141A1"},{"id":3351438,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_violation_id":"250632312","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192926326","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39617C"},{"id":3351439,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_violation_id":"250632313","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192926326","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3939A"},{"id":3351440,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_violation_id":"250632314","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"192926327","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39617C"},{"id":3351441,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_violation_id":"250632315","seq_no":"5","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192926327","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":3487868,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_unit_id":"192926326","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WT98","insp_unit_license":"78J8VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WKPDCCJ8WK951399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:00.000000Z","updated_at":"2025-03-17T22:31:00.000000Z"},{"id":3487869,"change_date":"2023-01-18 21:40:00","inspection_id":"77623696","insp_unit_id":"192926327","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPI","insp_unit_company":null,"insp_unit_license":"40K0VU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2820LE573038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:00.000000Z","updated_at":"2025-03-17T22:31:00.000000Z"}]},{"id":818473,"change_date":"2022-07-14 21:41:00","inspection_id":"76065184","dot_number":"895169","report_state":"MO","report_number":"1507019266","insp_date":"2022-07-13 00:00:00","insp_start_time":"1234","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"C44","location_desc":"I-44 @ MO 100","county_code_state":"MO","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BMC SAND","shipping_paper_number":"24037914","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":"2022-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"89200","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":"2021451","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-14 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-14 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:00.000000Z","updated_at":"2025-03-17T18:42:00.000000Z","inspection_violations":[{"id":1289583,"change_date":"2022-07-14 21:41:00","inspection_id":"76065184","insp_violation_id":"247093028","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:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"3922"},{"id":1289584,"change_date":"2022-07-14 21:41:00","inspection_id":"76065184","insp_violation_id":"247093029","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"189778296","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":1316754,"change_date":"2022-07-14 21:41:00","inspection_id":"76065184","insp_unit_id":"189778296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"04J6WM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV3LLKY5335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"}]},{"id":800105,"change_date":"2022-07-12 21:39:00","inspection_id":"76043527","dot_number":"895169","report_state":"MO","report_number":"ET02003693","insp_date":"2022-07-11 00:00:00","insp_start_time":"1225","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"E91","location_desc":"ADVANCE","county_code_state":"MO","county_code":"207","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CANNON EXCAVATION","shipping_paper_number":"622009000","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-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72740","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2020945","transaction_code":"A","transaction_date":"2022-07-12 00:00:00","upload_date":"2022-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-12 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-12 21:39:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:54.000000Z","updated_at":"2025-03-17T18:41:54.000000Z","inspection_violations":[{"id":1262415,"change_date":"2022-07-12 21:39:00","inspection_id":"76043527","insp_violation_id":"247033240","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189726797","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:58.000000Z","updated_at":"2025-03-17T21:12:58.000000Z","normalized_code":"3922"},{"id":1262416,"change_date":"2022-07-12 21:39:00","inspection_id":"76043527","insp_violation_id":"247033241","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189726797","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:58.000000Z","updated_at":"2025-03-17T21:12:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1287601,"change_date":"2022-07-12 21:39:00","inspection_id":"76043527","insp_unit_id":"189726797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"119","insp_unit_license":"78J7VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKMAVDV2KLKK5750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:05.000000Z","updated_at":"2025-03-17T22:16:05.000000Z"}]},{"id":638717,"change_date":"2022-06-17 21:40:00","inspection_id":"75854269","dot_number":"895169","report_state":"IL","report_number":"3998511284","insp_date":"2022-06-16 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"IL RTE 3 AT NEW POAG","county_code_state":"IL","county_code":"119","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"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":"N","pen_cen_match":null,"final_status_date":"2022-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2178011","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-06-17 21:40:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:51.000000Z","updated_at":"2025-03-17T18:38:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1026417,"change_date":"2022-06-17 21:40:00","inspection_id":"75854269","insp_unit_id":"189324474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BP20","insp_unit_license":"88KR7N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPXD49X2LD661924","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:30.000000Z","updated_at":"2025-03-17T22:14:30.000000Z"},{"id":1026418,"change_date":"2022-06-17 21:40:00","inspection_id":"75854269","insp_unit_id":"189324475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"83L4AW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5DADN4023JC046463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:30.000000Z","updated_at":"2025-03-17T22:14:30.000000Z"}]},{"id":540101,"change_date":"2022-06-03 21:41:00","inspection_id":"75737023","dot_number":"895169","report_state":"MO","report_number":"SLC7000518","insp_date":"2022-06-02 00:00:00","insp_start_time":"0739","insp_end_time":"0802","registration_date":null,"region":"CT","ci_status_code":"C","location":"C21","location_desc":"MO 21 SB AT OLD TESSON","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"EASTERN CONCRETE","shipping_paper_number":"DAY SHEET","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":"I","final_status_date":"2022-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"79740","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":"2014675","transaction_code":"A","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-03 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-06-03 21:41:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:23.000000Z","updated_at":"2025-03-17T18:37:23.000000Z","inspection_violations":[{"id":853079,"change_date":"2022-06-03 21:41:00","inspection_id":"75737023","insp_violation_id":"246241000","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:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39216A"},{"id":853080,"change_date":"2022-06-03 21:41:00","inspection_id":"75737023","insp_violation_id":"246241001","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"189057846","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":869161,"change_date":"2022-06-03 21:41:00","inspection_id":"75737023","insp_unit_id":"189057846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WS-117","insp_unit_license":"98J4WA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV1HPJG4234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"}]},{"id":93731,"change_date":"2022-04-02 21:30:00","inspection_id":"75202661","dot_number":"895169","report_state":"MO","report_number":"W191008424","insp_date":"2022-04-01 00:00:00","insp_start_time":"0912","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":"C2W","location_desc":"C2W","county_code_state":"MO","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CAPITAL SAND COMPANY","shipping_paper_number":"1327664","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-04-02 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"89200","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2003963","transaction_code":"A","transaction_date":"2022-04-02 00:00:00","upload_date":"2022-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00895169","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-04-02 21:30:00","insp_carrier_name":"CANNON EXCAVATION CO LLC","insp_carrier_street":"193 N LINCOLN DRIVE","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"454653","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:10.000000Z","updated_at":"2025-03-17T18:29:10.000000Z","inspection_violations":[{"id":138685,"change_date":"2022-04-02 21:30:00","inspection_id":"75202661","insp_violation_id":"244924004","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:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"3922"},{"id":138686,"change_date":"2022-04-02 21:30:00","inspection_id":"75202661","insp_violation_id":"244924005","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":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"3922"},{"id":138687,"change_date":"2022-04-02 21:30:00","inspection_id":"75202661","insp_violation_id":"244924006","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"187951233","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":152092,"change_date":"2022-04-02 21:30:00","inspection_id":"75202661","insp_unit_id":"187951233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WS122","insp_unit_license":"04J6WM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKSAVDV3LLKY5335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/895169\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/895169\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/895169\/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\/895169\/inspections","per_page":100,"prev_page_url":null,"to":45,"total":45}