{"current_page":1,"data":[{"id":12187468,"change_date":"2026-06-15 21:40:00","inspection_id":"88143173","dot_number":"320502","report_state":"IA","report_number":"277H000013","insp_date":"2026-06-15 00:00:00","insp_start_time":"0716","insp_end_time":"0740","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"HULL IA","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125321","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":"3544804","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":null,"census_search_date":"2026-06-15 21:40:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:40:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-18T09:40:55.000000Z","updated_at":"2026-06-26T09:30:29.000000Z","inspection_violations":[{"id":21210733,"change_date":"2026-06-15 21:40:00","inspection_id":"88143173","insp_violation_id":"274908620","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214100871","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:00:27.000000Z","updated_at":"2026-06-26T09:41:31.000000Z","normalized_code":"39617CPI"},{"id":21210734,"change_date":"2026-06-15 21:40:00","inspection_id":"88143173","insp_violation_id":"274908621","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"214100872","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:00:27.000000Z","updated_at":"2026-06-26T09:41:31.000000Z","normalized_code":"39617CPI"},{"id":21210732,"change_date":"2026-06-15 21:40:00","inspection_id":"88143173","insp_violation_id":"274908619","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"IL2606150730430","created_at":"2026-06-18T10:00:27.000000Z","updated_at":"2026-06-26T09:41:31.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":21168696,"change_date":"2026-06-15 21:40:00","inspection_id":"88143173","insp_unit_id":"214100871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"109","insp_unit_license":"FV7860","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKDL40X59R238768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:36.000000Z","updated_at":"2026-06-26T09:01:25.000000Z"},{"id":21168697,"change_date":"2026-06-15 21:40:00","inspection_id":"88143173","insp_unit_id":"214100872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEMENT-BR","insp_unit_company":"23","insp_unit_license":"U092423","insp_unit_license_state":"SD","insp_unit_vehicle_id_number":"1A9A1EP26G11A9332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:36.000000Z","updated_at":"2026-06-26T09:01:25.000000Z"}]},{"id":9266341,"change_date":"2025-07-28 21:40:00","inspection_id":"85338940","dot_number":"320502","report_state":"IA","report_number":"000P13DLGC","insp_date":"2025-07-24 00:00:00","insp_start_time":"1705","insp_end_time":"1720","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 10 WB & MONROE AVE - GRANV","county_code_state":"IA","county_code":"141","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"137160","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1368694","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-28 21:40:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:37.000000Z","updated_at":"2025-08-01T10:41:37.000000Z","inspection_violations":[{"id":15016518,"change_date":"2025-07-28 21:40:00","inspection_id":"85338940","insp_violation_id":"267692589","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":"7HIL25072417105","created_at":"2025-07-31T10:43:33.000000Z","updated_at":"2025-08-01T10:43:33.000000Z","normalized_code":"3922SLLS3"},{"id":15016519,"change_date":"2025-07-28 21:40:00","inspection_id":"85338940","insp_violation_id":"267692590","seq_no":"2","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7HIL25072417110","created_at":"2025-07-31T10:43:33.000000Z","updated_at":"2025-08-01T10:43:33.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":15253362,"change_date":"2025-07-28 21:40:00","inspection_id":"85338940","insp_unit_id":"208114219","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMCO","insp_unit_company":"11","insp_unit_license":"FT2523","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1S9SS4239BL476659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:34.000000Z","updated_at":"2025-08-01T09:45:34.000000Z"},{"id":15253363,"change_date":"2025-07-28 21:40:00","inspection_id":"85338940","insp_unit_id":"208114220","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"09","insp_unit_license":"FP5320","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD49X79J259013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:34.000000Z","updated_at":"2025-08-01T09:45:34.000000Z"}]},{"id":4685079,"change_date":"2023-12-21 21:39:00","inspection_id":"80449273","dot_number":"320502","report_state":"IA","report_number":"000P11022L","insp_date":"2023-12-13 00:00:00","insp_start_time":"1535","insp_end_time":"1605","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 10 WB AT GRANT","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"1297293","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7239496,"change_date":"2023-12-21 21:39:00","inspection_id":"80449273","insp_violation_id":"257011801","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":"1DYK23121315522","created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":7535561,"change_date":"2023-12-21 21:39:00","inspection_id":"80449273","insp_unit_id":"198623427","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84A","insp_unit_license":"FP5341","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9XX5D833972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"},{"id":7535562,"change_date":"2023-12-21 21:39:00","inspection_id":"80449273","insp_unit_id":"198623428","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"FP5350","insp_unit_license":"FP5350","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKSC43387W118617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"}]},{"id":4538150,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","dot_number":"320502","report_state":"IA","report_number":"000P15PGJT","insp_date":"2023-11-30 00:00:00","insp_start_time":"0916","insp_end_time":"1008","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 10 SB & 19TH ST HAWARDEN","county_code_state":"IA","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOYER","shipping_paper_number":"DIRT","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"150020","viol_total":"14","oos_total":"1","driver_viol_total":"7","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1295808","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[{"id":7021600,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665142","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":"3KIR23113009484","created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021601,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665143","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:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021602,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665144","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:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021603,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665145","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:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021604,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665146","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:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021605,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665147","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":"3KIR23113010041","created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021606,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665148","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":"3KIR23113010045","created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"},{"id":7021607,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665149","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198306257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3939A"},{"id":7021608,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665150","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198306257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3939A"},{"id":7021609,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665151","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198306257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3939A"},{"id":7021610,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665152","seq_no":"11","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198306257","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39378"},{"id":7021611,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665153","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"198306258","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39348A"},{"id":7021612,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665154","seq_no":"13","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198306258","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39375C"},{"id":7021613,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_violation_id":"256665155","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198306257","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7298643,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_unit_id":"198306257","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"44","insp_unit_license":"FP5329","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPFDB0X07D649144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"},{"id":7298644,"change_date":"2023-12-01 21:42:00","inspection_id":"80287912","insp_unit_id":"198306258","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUST","insp_unit_company":"29","insp_unit_license":"FP5326","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1S9SS40295L476872","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"}]},{"id":4423095,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","dot_number":"320502","report_state":"IA","report_number":"000TT4ZM0J","insp_date":"2023-11-08 00:00:00","insp_start_time":"1008","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 10 AND 20TH ST","county_code_state":"IA","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOYER SAND AND ROCK","shipping_paper_number":"EMPTY","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"142242","viol_total":"17","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1293585","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:41.000000Z","updated_at":"2025-03-17T19:50:41.000000Z","inspection_violations":[{"id":6843648,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388480","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:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3922"},{"id":6843649,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388481","seq_no":"2","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":"4HAN23110810295","created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39216A"},{"id":6843650,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388482","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3922"},{"id":6843651,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388483","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6843652,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388484","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39395A"},{"id":6843653,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388485","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39395F"},{"id":6843654,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388486","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39311"},{"id":6843655,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388487","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39311"},{"id":6843656,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388488","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4HAN23110810323","created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39617C"},{"id":6843657,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388489","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198056287","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39617C"},{"id":6843658,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388490","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6843659,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388491","seq_no":"12","part_no":"393","part_no_section":"25(b)","insp_viol_unit":"2","insp_unit_id":"198056287","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39325B"},{"id":6843660,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388492","seq_no":"13","part_no":"393","part_no_section":"25(b)","insp_viol_unit":"2","insp_unit_id":"198056287","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39325B"},{"id":6843661,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388493","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198056287","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3939A"},{"id":6843662,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388494","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3963A1"},{"id":6843663,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388495","seq_no":"16","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198056287","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39375C"},{"id":6843664,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_violation_id":"256388496","seq_no":"17","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198056286","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":7113082,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_unit_id":"198056286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84A","insp_unit_license":"FP5341","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9XX5D833972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:43.000000Z","updated_at":"2025-03-17T22:59:43.000000Z"},{"id":7113083,"change_date":"2023-11-14 21:42:00","inspection_id":"80161380","insp_unit_id":"198056287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SIDE","insp_unit_company":"93","insp_unit_license":"FP5346","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1YPFS42357P002039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:43.000000Z","updated_at":"2025-03-17T22:59:43.000000Z"}]},{"id":3734066,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","dot_number":"320502","report_state":"IA","report_number":"000P1101SQ","insp_date":"2023-08-08 00:00:00","insp_start_time":"1337","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 12 NB 110TH","county_code_state":"IA","county_code":"149","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-08-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1284238","transaction_code":"A","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-14 21:42:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:31.000000Z","updated_at":"2025-03-17T19:36:31.000000Z","inspection_violations":[{"id":5758453,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630584","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:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"3922"},{"id":5758454,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630585","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196510950","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39617C"},{"id":5758455,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630586","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196510949","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39360C"},{"id":5758456,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630587","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196510949","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39378"},{"id":5758457,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630588","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196510949","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"3939A"},{"id":5758458,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630589","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196510949","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"3939A"},{"id":5758459,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_violation_id":"254630590","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196510949","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6003800,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_unit_id":"196510949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"92","insp_unit_license":"FP5345","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5D49X57N673718","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"},{"id":6003801,"change_date":"2023-08-14 21:42:00","inspection_id":"79396317","insp_unit_id":"196510950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAVIS","insp_unit_company":"FT4712","insp_unit_license":"FT4712","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"48XEF483XD1008424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"}]},{"id":3456629,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","dot_number":"320502","report_state":"IA","report_number":"000TT6NGJN","insp_date":"2023-07-06 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 WB","county_code_state":"IA","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOYER SAND AND GRAVEL","shipping_paper_number":"10088282","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","viol_total":"7","oos_total":"0","driver_viol_total":"6","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1280054","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-07 21:41:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5329030,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929253","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:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5329031,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929254","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195882008","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5329032,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929255","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":"9CUR23070613533","created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5329033,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929256","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:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5329034,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929257","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":"9CUR23070613555","created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5329035,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929258","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:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5329036,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_violation_id":"253929259","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":"9CUR23070614012","created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5558082,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_unit_id":"195882007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"109","insp_unit_license":"FV7860","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKDL40X59R238768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"},{"id":5558083,"change_date":"2023-07-07 21:41:00","inspection_id":"79085564","insp_unit_id":"195882008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"FP5350","insp_unit_license":"FP5350","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TKSC43387W118617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"}]},{"id":1658152,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","dot_number":"320502","report_state":"IA","report_number":"000TT87SN6","insp_date":"2022-11-01 00:00:00","insp_start_time":"0831","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 10 & 23RD ST - HAWARDEN","county_code_state":"IA","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOYER SAND & ROCK INC","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-11-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249485","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-02 21:40:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:06.000000Z","updated_at":"2025-03-17T18:57:06.000000Z","inspection_violations":[{"id":2600829,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395414","seq_no":"1","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"191772784","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T10822110108453","created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"393130"},{"id":2600830,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395415","seq_no":"2","part_no":"393","part_no_section":"128","insp_viol_unit":"2","insp_unit_id":"191772784","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"393128"},{"id":2600831,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395416","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191772783","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"39345B2"},{"id":2600832,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395417","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"191772784","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"39311"},{"id":2600833,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395418","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191772783","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"39617C"},{"id":2600834,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395419","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191772784","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"39617C"},{"id":2600835,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_violation_id":"249395420","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191772784","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:17.000000Z","updated_at":"2025-03-17T21:19:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2667738,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_unit_id":"191772783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"FP5324","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJGEDV6CSBM1369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:17.000000Z","updated_at":"2025-03-17T22:25:17.000000Z"},{"id":2667739,"change_date":"2022-11-02 21:40:00","inspection_id":"77040424","insp_unit_id":"191772784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":null,"insp_unit_license":"751458ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1P9NL53B14S477009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:17.000000Z","updated_at":"2025-03-17T22:25:17.000000Z"}]},{"id":1146228,"change_date":"2022-08-26 21:40:00","inspection_id":"76448347","dot_number":"320502","report_state":"IA","report_number":"000TT6NFRQ","insp_date":"2022-08-18 00:00:00","insp_start_time":"1425","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 WB","county_code_state":"IA","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOYER","shipping_paper_number":"ROCK","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","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":"1239329","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00320502","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"BOYER SAND & ROCK INC","insp_carrier_street":"4162 BIRCH AVENUE","insp_carrier_city":"HAWARDEN","insp_carrier_state":"IA","insp_carrier_zip_code":"51023","insp_colonia":null,"docket_number":"376988","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:54.000000Z","updated_at":"2025-03-17T18:47:54.000000Z","inspection_violations":[{"id":1814319,"change_date":"2022-08-26 21:40:00","inspection_id":"76448347","insp_violation_id":"248027941","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:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3922"},{"id":1814320,"change_date":"2022-08-26 21:40:00","inspection_id":"76448347","insp_violation_id":"248027942","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190566865","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1842491,"change_date":"2022-08-26 21:40:00","inspection_id":"76448347","insp_unit_id":"190566865","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"09","insp_unit_license":"FP5320","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD49X79J259013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"},{"id":1842492,"change_date":"2022-08-26 21:40:00","inspection_id":"76448347","insp_unit_id":"190566866","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SMITHCO","insp_unit_company":"T1187","insp_unit_license":"FP1528","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1S9SS4632BL476870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/320502\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/320502\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/320502\/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\/320502\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}