{"current_page":1,"data":[{"id":11595169,"change_date":"2026-04-08 21:38:00","inspection_id":"87521299","dot_number":"714911","report_state":"MO","report_number":"W228007262","insp_date":"2026-04-07 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FAIRFAX MO","county_code_state":"MO","county_code":"005","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPIEGEL FARMS LP","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":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3128875","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"3210 US HWY 275","insp_carrier_city":"HAMBURG","insp_carrier_state":"IA","insp_carrier_zip_code":"51640","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:38.000000Z","updated_at":"2026-04-19T09:31:38.000000Z","inspection_violations":[{"id":19609285,"change_date":"2026-04-08 21:38:00","inspection_id":"87521299","insp_violation_id":"272934841","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"212602985","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-04-11T10:03:17.000000Z","updated_at":"2026-04-18T10:48:11.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":19875105,"change_date":"2026-04-08 21:38:00","inspection_id":"87521299","insp_unit_id":"212602984","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"52","insp_unit_license":"58KS3P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPXD40X98D751964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:41.000000Z","updated_at":"2026-04-18T09:35:58.000000Z"},{"id":19875106,"change_date":"2026-04-08 21:38:00","inspection_id":"87521299","insp_unit_id":"212602985","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMITHCO","insp_unit_company":null,"insp_unit_license":"73L0CY","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4231ML476898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:41.000000Z","updated_at":"2026-04-18T09:35:58.000000Z"}]},{"id":10351367,"change_date":"2025-12-04 21:38:00","inspection_id":"86479298","dot_number":"714911","report_state":"IA","report_number":"000P12JP3X","insp_date":"2025-12-03 00:00:00","insp_start_time":"1205","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"14 - I29 NB MM 12 PERCIVAL","county_code_state":"IA","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BUNGEE","shipping_paper_number":"0411885","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1382925","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2025-12-04 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-04 21:38:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"3210 US HWY 275","insp_carrier_city":"HAMBURG","insp_carrier_state":"IA","insp_carrier_zip_code":"51640","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-07T10:31:44.000000Z","updated_at":"2025-12-08T10:31:07.000000Z","inspection_violations":[{"id":17327560,"change_date":"2025-12-04 21:38:00","inspection_id":"86479298","insp_violation_id":"270459391","seq_no":"1","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":"7WEL25120312090","created_at":"2025-12-07T10:32:18.000000Z","updated_at":"2025-12-08T10:31:44.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":17298691,"change_date":"2025-12-04 21:38:00","inspection_id":"86479298","insp_unit_id":"210412231","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"50","insp_unit_license":"21KS8L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPWDP9X1CD136799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:32.000000Z","updated_at":"2025-12-08T10:01:20.000000Z"},{"id":17298692,"change_date":"2025-12-04 21:38:00","inspection_id":"86479298","insp_unit_id":"210412232","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"5184","insp_unit_license":"31K6BC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4WW4432A8D7705184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:32.000000Z","updated_at":"2025-12-08T10:01:20.000000Z"}]},{"id":10177964,"change_date":"2025-11-12 21:41:00","inspection_id":"86297648","dot_number":"714911","report_state":"IA","report_number":"000P13HZ1Q","insp_date":"2025-11-11 00:00:00","insp_start_time":"1155","insp_end_time":"1205","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 59NB AND 290TH","county_code_state":"IA","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPIEGAL FARMS","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1380565","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"3210 US HWY 275","insp_carrier_city":"HAMBURG","insp_carrier_state":"IA","insp_carrier_zip_code":"51640","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:55.000000Z","inspection_violations":[{"id":16903429,"change_date":"2025-11-12 21:41:00","inspection_id":"86297648","insp_violation_id":"269893016","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-11-15T10:31:03.000000Z","updated_at":"2025-11-16T10:31:36.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16951574,"change_date":"2025-11-12 21:41:00","inspection_id":"86297648","insp_unit_id":"209977204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"51","insp_unit_license":"21KS9L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPWDP9X1CD136835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:39.000000Z","updated_at":"2025-11-16T10:01:13.000000Z"},{"id":16951575,"change_date":"2025-11-12 21:41:00","inspection_id":"86297648","insp_unit_id":"209977205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMITH","insp_unit_company":"1","insp_unit_license":"80K9WD","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4237LL476452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:39.000000Z","updated_at":"2025-11-16T10:01:13.000000Z"}]},{"id":9608335,"change_date":"2025-09-06 21:34:00","inspection_id":"85700946","dot_number":"714911","report_state":"MO","report_number":"W228007037","insp_date":"2025-09-05 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FAIRFAX MO","county_code_state":"MO","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORRIS QUARRIES","shipping_paper_number":"8317493","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-06 21:34: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":"2229746","transaction_code":"A","transaction_date":"2025-09-06 00:00:00","upload_date":"2025-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2025-09-06 21:34:00","snet_input_date":"2025-09-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-06 21:34:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"3210 US HWY 275","insp_carrier_city":"HAMBURG","insp_carrier_state":"IA","insp_carrier_zip_code":"51640","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:52.000000Z","updated_at":"2025-09-10T10:45:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15869717,"change_date":"2025-09-06 21:34:00","inspection_id":"85700946","insp_unit_id":"208782712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"47","insp_unit_license":"31KL8A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPALU0X24M815544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:35.000000Z","updated_at":"2025-09-10T09:46:35.000000Z"}]},{"id":8085228,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","dot_number":"714911","report_state":"NE","report_number":"T360000223","insp_date":"2025-03-03 00:00:00","insp_start_time":"0759","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 75, WEST OF NEBRASKA","county_code_state":"NE","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NON","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"135300","viol_total":"7","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":"809244","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-10 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"3210 US HWY 275","insp_carrier_city":"HAMBURG","insp_carrier_state":"IA","insp_carrier_zip_code":"51640","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[{"id":12635229,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950743","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED26V0002632","created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922SLLS3"},{"id":12635230,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950744","seq_no":"2","part_no":"392","part_no_section":"2FT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED2603829","created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922FT"},{"id":12635231,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950745","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205738474","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39617C"},{"id":12635232,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950746","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"205738475","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39617C"},{"id":12635233,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950747","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"205738475","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED2603829","created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922RG"},{"id":12635234,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950748","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED2603829","created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922"},{"id":12635235,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_violation_id":"264950749","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205738474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED26V0002632","created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13054040,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_unit_id":"205738474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"46","insp_unit_license":"52KR6S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPTD49X48D762498","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13054041,"change_date":"2025-03-11 21:41:00","inspection_id":"84093442","insp_unit_id":"205738475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":null,"insp_unit_license":"06L8XJ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4232HL476690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":5575496,"change_date":"2024-04-23 21:41:00","inspection_id":"81421257","dot_number":"714911","report_state":"IA","report_number":"000P112ZC4","insp_date":"2024-04-22 00:00:00","insp_start_time":"1110","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BARTLETT GRAIN","shipping_paper_number":"953407","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1310384","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"11807 C AVE","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8617092,"change_date":"2024-04-23 21:41:00","inspection_id":"81421257","insp_violation_id":"259081089","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200529353","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":8981069,"change_date":"2024-04-23 21:41:00","inspection_id":"81421257","insp_unit_id":"200529353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"53","insp_unit_license":"04KS1W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9XX7D743921","insp_unit_decal":"Y","insp_unit_decal_number":"34053130","created_at":"2025-03-17T23:16:34.000000Z","updated_at":"2025-03-17T23:16:34.000000Z"},{"id":8981070,"change_date":"2024-04-23 21:41:00","inspection_id":"81421257","insp_unit_id":"200529354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"53T","insp_unit_license":"31K6BC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4WW4432A8D7705184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:34.000000Z","updated_at":"2025-03-17T23:16:34.000000Z"}]},{"id":4473726,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","dot_number":"714911","report_state":"NE","report_number":"T426000202","insp_date":"2023-11-20 00:00:00","insp_start_time":"0957","insp_end_time":"1059","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 77, 212 FEET NORTH O","county_code_state":"NE","county_code":"067","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":"N","pen_cen_match":null,"final_status_date":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139630","viol_total":"12","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":"776321","transaction_code":"C","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"15174 STATE HWY B","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:26.000000Z","updated_at":"2025-03-17T19:51:26.000000Z","inspection_violations":[{"id":6924816,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535279","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198186995","insp_violation_category_id":"26","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ED2504870","created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39378"},{"id":6924817,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535280","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"2","insp_unit_id":"198186996","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3969D2"},{"id":6924818,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535281","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED2504870","created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"},{"id":6924819,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535282","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198186995","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"},{"id":6924820,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535283","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198186996","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"},{"id":6924821,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535284","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198186995","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3939A"},{"id":6924822,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535285","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198186996","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"ED2504870","created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3939A"},{"id":6924823,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535286","seq_no":"8","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198186995","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39395A"},{"id":6924824,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535287","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198186996","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3939A"},{"id":6924825,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535288","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198186996","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39617C"},{"id":6924826,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535289","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"},{"id":6924827,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_violation_id":"256535290","seq_no":"12","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198186995","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":7194913,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_unit_id":"198186995","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"58KS3P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPXD40X98D751964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:25.000000Z","updated_at":"2025-03-17T23:00:25.000000Z"},{"id":7194914,"change_date":"2023-11-22 21:39:00","inspection_id":"80217077","insp_unit_id":"198186996","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":null,"insp_unit_license":"80K9WD","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4237LL476452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:25.000000Z","updated_at":"2025-03-17T23:00:25.000000Z"}]},{"id":3589910,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","dot_number":"714911","report_state":"NE","report_number":"T303000075","insp_date":"2023-07-25 00:00:00","insp_start_time":"0838","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"278TH & RAINWOOD RD.","county_code_state":"NE","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"141630","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":"765237","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2023-07-25 21:41:00","snet_input_date":"2023-07-25 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-07-25 21:41:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"15174 STATE HWY B","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:53.000000Z","updated_at":"2025-03-17T19:33:53.000000Z","inspection_violations":[{"id":5533826,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","insp_violation_id":"254264414","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"3922"},{"id":5533827,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","insp_violation_id":"254264415","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196183577","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"3922"},{"id":5533828,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","insp_violation_id":"254264416","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196183577","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"3922"},{"id":5533829,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","insp_violation_id":"254264417","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196183578","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5772086,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","insp_unit_id":"196183577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"50","insp_unit_license":"21KS8L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPWDP9X1CD136799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:34.000000Z","updated_at":"2025-03-17T22:48:34.000000Z"},{"id":5772087,"change_date":"2023-07-25 21:41:00","inspection_id":"79235054","insp_unit_id":"196183578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":null,"insp_unit_license":"80K9WD","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4237LL476452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:34.000000Z","updated_at":"2025-03-17T22:48:34.000000Z"}]},{"id":3387468,"change_date":"2023-06-28 21:42:00","inspection_id":"79007626","dot_number":"714911","report_state":"NE","report_number":"T303000047","insp_date":"2023-06-20 00:00:00","insp_start_time":"0928","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON STATE HWY 64, 2656 FEET NOR","county_code_state":"NE","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"141450","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":"762634","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-21 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"15174 STATE HWY B","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:09.000000Z","updated_at":"2025-03-17T19:30:09.000000Z","inspection_violations":[{"id":5221892,"change_date":"2023-06-28 21:42:00","inspection_id":"79007626","insp_violation_id":"253753542","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5446028,"change_date":"2023-06-28 21:42:00","inspection_id":"79007626","insp_unit_id":"195724795","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"49","insp_unit_license":"04KS6B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPWDB0X99D777594","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:58.000000Z","updated_at":"2025-03-17T22:45:58.000000Z"},{"id":5446029,"change_date":"2023-06-28 21:42:00","inspection_id":"79007626","insp_unit_id":"195724796","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":null,"insp_unit_license":"73L0CY","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4231ML476898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:58.000000Z","updated_at":"2025-03-17T22:45:58.000000Z"}]},{"id":2511530,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","dot_number":"714911","report_state":"IA","report_number":"000TT76ZHQ","insp_date":"2023-03-05 00:00:00","insp_start_time":"1005","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BARTLETT GRAIN","shipping_paper_number":"704392","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1264831","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"11807 C AVE","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:56.000000Z","updated_at":"2025-03-17T19:12:56.000000Z","inspection_violations":[{"id":3861646,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","insp_violation_id":"251490791","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:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3922"},{"id":3861647,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","insp_violation_id":"251490792","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:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3922"},{"id":3861648,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","insp_violation_id":"251490793","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193720440","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3939A"},{"id":3861649,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","insp_violation_id":"251490794","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193720440","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4042083,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","insp_unit_id":"193720440","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"53","insp_unit_license":"04KS1W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9XX7D743921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"},{"id":4042084,"change_date":"2023-03-06 21:40:00","inspection_id":"78015882","insp_unit_id":"193720441","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"53T","insp_unit_license":"31K6BC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4WW4432A8D7705184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"}]},{"id":2324880,"change_date":"2023-02-08 21:39:00","inspection_id":"77802873","dot_number":"714911","report_state":"IA","report_number":"000TT6CX3Z","insp_date":"2023-02-06 00:00:00","insp_start_time":"0911","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"OATS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1261816","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2023-02-08 21:39:00","snet_input_date":"2023-02-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"11807 C AVE","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:36.000000Z","updated_at":"2025-03-17T19:09:36.000000Z","inspection_violations":[{"id":3579590,"change_date":"2023-02-08 21:39:00","inspection_id":"77802873","insp_violation_id":"251014791","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:23:52.000000Z","updated_at":"2025-03-17T21:23:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3741512,"change_date":"2023-02-08 21:39:00","inspection_id":"77802873","insp_unit_id":"193292705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"53","insp_unit_license":"04KS1W","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9XX7D743921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"},{"id":3741513,"change_date":"2023-02-08 21:39:00","inspection_id":"77802873","insp_unit_id":"193292706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"53T","insp_unit_license":"31K6BC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4WW4432A8D7705184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"}]},{"id":1294328,"change_date":"2022-09-15 21:40:00","inspection_id":"76619703","dot_number":"714911","report_state":"IA","report_number":"000TT884PW","insp_date":"2022-09-14 00:00:00","insp_start_time":"1430","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 34 AND 195TH","county_code_state":"IA","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMES","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1242276","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2022-09-15 21:40:00","snet_input_date":"2022-09-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"15174 STATE HWY B","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[{"id":2047954,"change_date":"2022-09-15 21:40:00","inspection_id":"76619703","insp_violation_id":"248438377","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2083326,"change_date":"2022-09-15 21:40:00","inspection_id":"76619703","insp_unit_id":"190920437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"47","insp_unit_license":"31KL8A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2NPALU0X24M815544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"}]},{"id":1046413,"change_date":"2022-08-16 21:39:00","inspection_id":"76331480","dot_number":"714911","report_state":"NE","report_number":"QS00002573","insp_date":"2022-08-16 00:00:00","insp_start_time":"1117","insp_end_time":"1139","registration_date":null,"region":"CT","ci_status_code":"C","location":"FREMNT","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"KOSS CONTRUCTION","shipping_paper_number":"490103669","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-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738587","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-16 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"11807 C AVENUE","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1647766,"change_date":"2022-08-16 21:39:00","inspection_id":"76331480","insp_violation_id":"247739414","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190331453","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39395A"},{"id":1647767,"change_date":"2022-08-16 21:39:00","inspection_id":"76331480","insp_violation_id":"247739415","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:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3922"},{"id":1647768,"change_date":"2022-08-16 21:39:00","inspection_id":"76331480","insp_violation_id":"247739416","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190331453","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1683703,"change_date":"2022-08-16 21:39:00","inspection_id":"76331480","insp_unit_id":"190331453","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"50","insp_unit_license":"21KS8L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPWDP9X1CD136799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"},{"id":1683704,"change_date":"2022-08-16 21:39:00","inspection_id":"76331480","insp_unit_id":"190331454","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":null,"insp_unit_license":"24LONZ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9SS4020NL476040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"}]},{"id":1135909,"change_date":"2022-08-25 21:42:00","inspection_id":"76436260","dot_number":"714911","report_state":"NE","report_number":"ZU00002641","insp_date":"2022-08-16 00:00:00","insp_start_time":"1440","insp_end_time":"1503","registration_date":null,"region":"CT","ci_status_code":"C","location":"FREMNT","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"739536","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":null,"census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-25 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"15174 STATE HWY B","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:36.000000Z","updated_at":"2025-03-17T18:47:36.000000Z","inspection_violations":[{"id":1795652,"change_date":"2022-08-25 21:42:00","inspection_id":"76436260","insp_violation_id":"247996989","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":"ED1501412","created_at":"2025-03-17T21:15:19.000000Z","updated_at":"2025-03-17T21:15:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1826917,"change_date":"2022-08-25 21:42:00","inspection_id":"76436260","insp_unit_id":"190544393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"52","insp_unit_license":"58KS3P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPXD40X98D751964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:35.000000Z","updated_at":"2025-03-17T22:19:35.000000Z"},{"id":1826918,"change_date":"2022-08-25 21:42:00","inspection_id":"76436260","insp_unit_id":"190544394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMIH","insp_unit_company":"SD14","insp_unit_license":"254792","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1S9SS4232HL476690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:35.000000Z","updated_at":"2025-03-17T22:19:35.000000Z"}]},{"id":531317,"change_date":"2022-06-02 21:42:00","inspection_id":"75726536","dot_number":"714911","report_state":"IA","report_number":"000TT65R6V","insp_date":"2022-06-01 00:00:00","insp_start_time":"0945","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"14 - I29 NB MM 12 PERCIVAL","county_code_state":"IA","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SPIEGEL FARMS LP","shipping_paper_number":"BOBTAIL","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-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1227746","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00714911","upload_search_indicator":"M","census_search_date":"2022-06-02 21:42:00","snet_input_date":"2022-06-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-02 21:42:00","insp_carrier_name":"SPIEGEL FARMS LP","insp_carrier_street":"11807 C AVE","insp_carrier_city":"WATSON","insp_carrier_state":"MO","insp_carrier_zip_code":"64496","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:04.000000Z","updated_at":"2025-03-17T18:37:04.000000Z","inspection_violations":[{"id":838307,"change_date":"2022-06-02 21:42:00","inspection_id":"75726536","insp_violation_id":"246212872","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":854854,"change_date":"2022-06-02 21:42:00","inspection_id":"75726536","insp_unit_id":"189035575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"52","insp_unit_license":"58KS3P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPXD40X98D751964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:28.000000Z","updated_at":"2025-03-17T22:13:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/714911\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/714911\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/714911\/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\/714911\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}