{"current_page":1,"data":[{"id":11847872,"change_date":"2026-05-08 21:38:00","inspection_id":"87783795","dot_number":"1670993","report_state":"CA","report_number":"NFAC002511","insp_date":"2026-05-04 00:00:00","insp_start_time":"1705","insp_end_time":"1725","registration_date":null,"region":"PS","ci_status_code":"C","location":"147","location_desc":"CA","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CG ROXANE","shipping_paper_number":"15733926","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3276646","transaction_code":"C","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":"2026-05-07 21:39:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:32.000000Z","updated_at":"2026-05-19T09:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20603910,"change_date":"2026-05-08 21:38:00","inspection_id":"87783795","insp_unit_id":"213440916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:47.000000Z","updated_at":"2026-05-19T09:02:06.000000Z"},{"id":20603911,"change_date":"2026-05-08 21:38:00","inspection_id":"87783795","insp_unit_id":"213440917","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4RH4190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W57L033506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:47.000000Z","updated_at":"2026-05-19T09:02:06.000000Z"}]},{"id":11292734,"change_date":"2026-03-05 21:39:00","inspection_id":"87208033","dot_number":"1670993","report_state":"OR","report_number":"AP08000467","insp_date":"2026-03-04 00:00:00","insp_start_time":"1025","insp_end_time":"1045","registration_date":null,"region":"PS","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PEPES FOODS","shipping_paper_number":"3101465PP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2963096","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":"2026-03-05 21:39:00","snet_input_date":"2026-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-05 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:01.000000Z","updated_at":"2026-03-16T09:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19315095,"change_date":"2026-03-05 21:39:00","inspection_id":"87208033","insp_unit_id":"211976578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"98","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPRZLN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:08.000000Z","updated_at":"2026-03-16T09:02:07.000000Z"},{"id":19315096,"change_date":"2026-03-05 21:39:00","inspection_id":"87208033","insp_unit_id":"211976579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4RH4190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W57L033506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:08.000000Z","updated_at":"2026-03-16T09:02:07.000000Z"}]},{"id":11229022,"change_date":"2026-02-25 21:49:00","inspection_id":"87141142","dot_number":"1670993","report_state":"CA","report_number":"NFAC002112","insp_date":"2026-02-23 00:00:00","insp_start_time":"1541","insp_end_time":"1704","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CG ROXANNE","shipping_paper_number":"15727111","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"16184433","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:30.000000Z","updated_at":"2026-03-08T09:32:21.000000Z","inspection_violations":[{"id":18851929,"change_date":"2026-02-25 21:49:00","inspection_id":"87141142","insp_violation_id":"272038207","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"211837779","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA714511","created_at":"2026-02-28T10:57:06.000000Z","updated_at":"2026-03-08T09:50:11.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":19194636,"change_date":"2026-02-25 21:49:00","inspection_id":"87141142","insp_unit_id":"211837778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7\/GREY","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:23.000000Z","updated_at":"2026-03-08T09:07:18.000000Z"},{"id":19194637,"change_date":"2026-02-25 21:49:00","inspection_id":"87141142","insp_unit_id":"211837779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:23.000000Z","updated_at":"2026-03-08T09:07:18.000000Z"}]},{"id":11109379,"change_date":"2026-02-11 21:39:00","inspection_id":"87021789","dot_number":"1670993","report_state":"CA","report_number":"UDZG000614","insp_date":"2026-02-10 00:00:00","insp_start_time":"1239","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"145","location_desc":"DORRIS AG STATION","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"16167396","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-11 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:41.000000Z","updated_at":"2026-02-22T10:31:13.000000Z","inspection_violations":[{"id":18604839,"change_date":"2026-02-11 21:39:00","inspection_id":"87021789","insp_violation_id":"271744448","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"211574467","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:32.000000Z","updated_at":"2026-02-22T10:40:21.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":18946577,"change_date":"2026-02-11 21:39:00","inspection_id":"87021789","insp_unit_id":"211574467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7\/SILVER","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:37.000000Z","updated_at":"2026-02-22T10:03:49.000000Z"},{"id":18946578,"change_date":"2026-02-11 21:39:00","inspection_id":"87021789","insp_unit_id":"211574468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:37.000000Z","updated_at":"2026-02-22T10:03:49.000000Z"}]},{"id":11123315,"change_date":"2026-02-12 21:41:00","inspection_id":"87036429","dot_number":"1670993","report_state":"CA","report_number":"NEZF003616","insp_date":"2026-02-06 00:00:00","insp_start_time":"1301","insp_end_time":"1323","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CRYSTAL GEYSER","shipping_paper_number":"15 726031","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16168685","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:53.000000Z","updated_at":"2026-02-23T10:31:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18971330,"change_date":"2026-02-12 21:41:00","inspection_id":"87036429","insp_unit_id":"211602645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"35871921","created_at":"2026-02-15T10:20:13.000000Z","updated_at":"2026-02-23T10:04:04.000000Z"},{"id":18971331,"change_date":"2026-02-12 21:41:00","inspection_id":"87036429","insp_unit_id":"211602646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"M9\/WHT","insp_unit_license":"4VX8963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B8GL949979","insp_unit_decal":"Y","insp_unit_decal_number":"35871922","created_at":"2026-02-15T10:20:13.000000Z","updated_at":"2026-02-23T10:04:04.000000Z"}]},{"id":10602820,"change_date":"2026-01-08 21:40:00","inspection_id":"86742244","dot_number":"1670993","report_state":"CA","report_number":"NEZF003446","insp_date":"2026-01-05 00:00:00","insp_start_time":"1330","insp_end_time":"1340","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CRYSTAL GEYSER","shipping_paper_number":"15 723131","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16121701","transaction_code":"A","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:48.000000Z","updated_at":"2026-01-19T10:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17775529,"change_date":"2026-01-08 21:40:00","inspection_id":"86742244","insp_unit_id":"210984746","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7\/GRAY","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:16.000000Z","updated_at":"2026-01-19T10:01:14.000000Z"},{"id":17775530,"change_date":"2026-01-08 21:40:00","inspection_id":"86742244","insp_unit_id":"210984747","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:16.000000Z","updated_at":"2026-01-19T10:01:14.000000Z"}]},{"id":10510925,"change_date":"2025-12-23 21:39:00","inspection_id":"86646117","dot_number":"1670993","report_state":"CA","report_number":"UEIG000797","insp_date":"2025-12-22 00:00:00","insp_start_time":"1417","insp_end_time":"1452","registration_date":null,"region":"PT","ci_status_code":"C","location":"160","location_desc":"I-5 NB N\/OF CR-68","county_code_state":"CA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"16106761","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-23 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"356054","created_at":"2025-12-26T10:38:41.000000Z","updated_at":"2026-01-03T10:31:05.000000Z","inspection_violations":[{"id":17646440,"change_date":"2025-12-23 21:39:00","inspection_id":"86646117","insp_violation_id":"270882671","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":"RT69620","created_at":"2025-12-26T10:44:45.000000Z","updated_at":"2026-01-03T10:32:00.000000Z","normalized_code":"3922SLLS3"},{"id":17646441,"change_date":"2025-12-23 21:39:00","inspection_id":"86646117","insp_violation_id":"270882672","seq_no":"2","part_no":"395","part_no_section":"8E1-HOSPVID","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:45.000000Z","updated_at":"2026-01-03T10:32:00.000000Z","normalized_code":"3958E1HOSPVID"}],"inspection_per_units":[{"id":17602052,"change_date":"2025-12-23 21:39:00","inspection_id":"86646117","insp_unit_id":"210788577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:35.000000Z","updated_at":"2026-01-03T10:01:13.000000Z"},{"id":17602053,"change_date":"2025-12-23 21:39:00","inspection_id":"86646117","insp_unit_id":"210788578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:35.000000Z","updated_at":"2026-01-03T10:01:13.000000Z"}]},{"id":10071267,"change_date":"2025-10-29 21:41:00","inspection_id":"86185027","dot_number":"1670993","report_state":"CA","report_number":"NDZX004560","insp_date":"2025-10-23 00:00:00","insp_start_time":"1604","insp_end_time":"1635","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"246489","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16038310","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-29 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:35.000000Z","updated_at":"2025-11-02T11:01:37.000000Z","inspection_violations":[{"id":16678249,"change_date":"2025-10-29 21:41:00","inspection_id":"86185027","insp_violation_id":"269604008","seq_no":"1","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"209727261","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA712769","created_at":"2025-11-01T10:18:09.000000Z","updated_at":"2025-11-02T11:17:26.000000Z","normalized_code":"39345DBAAL"},{"id":16678250,"change_date":"2025-10-29 21:41:00","inspection_id":"86185027","insp_violation_id":"269604009","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209727261","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:18:09.000000Z","updated_at":"2025-11-02T11:17:26.000000Z","normalized_code":"39347E"},{"id":16678251,"change_date":"2025-10-29 21:41:00","inspection_id":"86185027","insp_violation_id":"269604010","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"209727261","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:18:09.000000Z","updated_at":"2025-11-02T11:17:26.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":16739876,"change_date":"2025-10-29 21:41:00","inspection_id":"86185027","insp_unit_id":"209727261","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:12.000000Z","updated_at":"2025-11-02T10:47:03.000000Z"},{"id":16739877,"change_date":"2025-10-29 21:41:00","inspection_id":"86185027","insp_unit_id":"209727262","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4MF7129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U385804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:12.000000Z","updated_at":"2025-11-02T10:47:03.000000Z"}]},{"id":10072139,"change_date":"2025-10-29 21:41:00","inspection_id":"86185918","dot_number":"1670993","report_state":"CA","report_number":"UF7J000100","insp_date":"2025-10-23 00:00:00","insp_start_time":"1908","insp_end_time":"1915","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"246489","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"16038330","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-29 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:36.000000Z","updated_at":"2025-11-02T11:01:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16741299,"change_date":"2025-10-29 21:41:00","inspection_id":"86185918","insp_unit_id":"209728755","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"35607318","created_at":"2025-11-01T09:47:13.000000Z","updated_at":"2025-11-02T10:47:11.000000Z"},{"id":16741300,"change_date":"2025-10-29 21:41:00","inspection_id":"86185918","insp_unit_id":"209728756","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4MF7129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U385804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:13.000000Z","updated_at":"2025-11-02T10:47:11.000000Z"}]},{"id":9660356,"change_date":"2025-09-12 21:50:00","inspection_id":"85752779","dot_number":"1670993","report_state":"CA","report_number":"NDZX004256","insp_date":"2025-09-08 00:00:00","insp_start_time":"1525","insp_end_time":"1535","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CG ROXANNE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15977692","transaction_code":"C","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:48:09.000000Z","updated_at":"2025-09-16T10:48:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16001636,"change_date":"2025-09-12 21:50:00","inspection_id":"85752779","insp_unit_id":"208929439","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"SIL","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:03.000000Z","updated_at":"2025-09-16T09:56:34.000000Z"},{"id":16001637,"change_date":"2025-09-12 21:50:00","inspection_id":"85752779","insp_unit_id":"208929440","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06297B702980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:03.000000Z","updated_at":"2025-09-16T09:56:34.000000Z"}]},{"id":9405051,"change_date":"2025-08-13 21:39:00","inspection_id":"85484713","dot_number":"1670993","report_state":"CA","report_number":"NCRM007767","insp_date":"2025-08-05 00:00:00","insp_start_time":"1517","insp_end_time":"1525","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS LLC","shipping_paper_number":"243797","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15936188","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:26.000000Z","updated_at":"2025-08-17T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15500698,"change_date":"2025-08-13 21:39:00","inspection_id":"85484713","insp_unit_id":"208383608","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7\/GRAY","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:41.000000Z","updated_at":"2025-08-17T09:46:06.000000Z"},{"id":15500699,"change_date":"2025-08-13 21:39:00","inspection_id":"85484713","insp_unit_id":"208383609","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"M9\/WHT","insp_unit_license":"4VX8963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B8GL949979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:41.000000Z","updated_at":"2025-08-17T09:46:06.000000Z"}]},{"id":9279391,"change_date":"2025-07-29 21:40:00","inspection_id":"85352667","dot_number":"1670993","report_state":"CA","report_number":"N92M007575","insp_date":"2025-07-25 00:00:00","insp_start_time":"0750","insp_end_time":"0811","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15917845","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-29 21:40:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-01T10:42:11.000000Z","updated_at":"2025-08-04T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15276287,"change_date":"2025-07-29 21:40:00","inspection_id":"85352667","insp_unit_id":"208142245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"35330875","created_at":"2025-08-01T09:45:49.000000Z","updated_at":"2025-08-02T09:46:10.000000Z"},{"id":15276288,"change_date":"2025-07-29 21:40:00","inspection_id":"85352667","insp_unit_id":"208142246","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"Y","insp_unit_decal_number":"35330876","created_at":"2025-08-01T09:45:49.000000Z","updated_at":"2025-08-02T09:46:10.000000Z"}]},{"id":9145356,"change_date":"2025-07-14 21:41:00","inspection_id":"85211873","dot_number":"1670993","report_state":"CA","report_number":"NCU6004787","insp_date":"2025-06-26 00:00:00","insp_start_time":"1017","insp_end_time":"1031","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15897453","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:50.000000Z","updated_at":"2025-07-18T10:45:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15018349,"change_date":"2025-07-14 21:41:00","inspection_id":"85211873","insp_unit_id":"207863864","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:14.000000Z"},{"id":15018350,"change_date":"2025-07-14 21:41:00","inspection_id":"85211873","insp_unit_id":"207863865","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:14.000000Z"}]},{"id":8593487,"change_date":"2025-05-09 21:42:00","inspection_id":"84628604","dot_number":"1670993","report_state":"CA","report_number":"NDZX003542","insp_date":"2025-05-05 00:00:00","insp_start_time":"1538","insp_end_time":"1601","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15813599","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-09 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:03:10.000000Z","updated_at":"2025-05-13T10:03:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14027460,"change_date":"2025-05-09 21:42:00","inspection_id":"84628604","insp_unit_id":"206784660","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7\/  SILVER","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"Y","insp_unit_decal_number":"35053409","created_at":"2025-05-12T09:48:58.000000Z","updated_at":"2025-05-13T09:49:16.000000Z"},{"id":14027461,"change_date":"2025-05-09 21:42:00","inspection_id":"84628604","insp_unit_id":"206784661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"L7\/ WHT","insp_unit_license":"4RH4190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W57L033506","insp_unit_decal":"Y","insp_unit_decal_number":"35053410","created_at":"2025-05-12T09:48:58.000000Z","updated_at":"2025-05-13T09:49:16.000000Z"}]},{"id":8205472,"change_date":"2025-03-26 21:41:00","inspection_id":"84220033","dot_number":"1670993","report_state":"CA","report_number":"NF8R001013","insp_date":"2025-03-20 00:00:00","insp_start_time":"1814","insp_end_time":"1849","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"23942","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15753126","transaction_code":"C","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-25 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"356054","created_at":"2025-03-28T10:15:16.000000Z","updated_at":"2025-03-30T10:36:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13284343,"change_date":"2025-03-26 21:41:00","inspection_id":"84220033","insp_unit_id":"206001312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"34775245","created_at":"2025-03-29T10:11:51.000000Z","updated_at":"2025-03-30T10:08:29.000000Z"},{"id":13284344,"change_date":"2025-03-26 21:41:00","inspection_id":"84220033","insp_unit_id":"206001313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B4","insp_unit_license":"4MF7129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U385804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:11:51.000000Z","updated_at":"2025-03-30T10:08:29.000000Z"}]},{"id":7959922,"change_date":"2025-02-25 21:41:00","inspection_id":"83961612","dot_number":"1670993","report_state":"CA","report_number":"UED8001022","insp_date":"2025-02-25 00:00:00","insp_start_time":"1009","insp_end_time":"1029","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"WILLOW PASS RD AT MANOR DR","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","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":"2025-02-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15717553","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"356054","created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[{"id":12438408,"change_date":"2025-02-25 21:41:00","inspection_id":"83961612","insp_violation_id":"264697839","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"205497245","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39395A4EEUS"},{"id":12438409,"change_date":"2025-02-25 21:41:00","inspection_id":"83961612","insp_violation_id":"264697840","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"205497245","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":12849584,"change_date":"2025-02-25 21:41:00","inspection_id":"83961612","insp_unit_id":"205497245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98","insp_unit_license":"ZP49000","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"},{"id":12849585,"change_date":"2025-02-25 21:41:00","inspection_id":"83961612","insp_unit_id":"205497246","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5","insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7610778,"change_date":"2025-01-13 21:46:00","inspection_id":"83595167","dot_number":"1670993","report_state":"CA","report_number":"UFAW001792","insp_date":"2024-12-27 00:00:00","insp_start_time":"1326","insp_end_time":"1336","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOOD","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15658976","transaction_code":"A","transaction_date":"2024-12-27 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:08.000000Z","updated_at":"2025-03-17T20:56:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12280493,"change_date":"2025-01-13 21:46:00","inspection_id":"83595167","insp_unit_id":"204790787","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"},{"id":12280494,"change_date":"2025-01-13 21:46:00","inspection_id":"83595167","insp_unit_id":"204790788","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7454504,"change_date":"2024-12-18 21:42:00","inspection_id":"83430920","dot_number":"1670993","report_state":"CA","report_number":"UD34000903","insp_date":"2024-12-17 00:00:00","insp_start_time":"1610","insp_end_time":"1625","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ACM PRADO'S","shipping_paper_number":"107080","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15634652","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-18 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:34.000000Z","updated_at":"2025-03-17T20:51:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12026187,"change_date":"2024-12-18 21:42:00","inspection_id":"83430920","insp_unit_id":"204466598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHI","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"},{"id":12026188,"change_date":"2024-12-18 21:42:00","inspection_id":"83430920","insp_unit_id":"204466599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S56\/WHI","insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"}]},{"id":6669873,"change_date":"2024-09-06 21:41:00","inspection_id":"82599568","dot_number":"1670993","report_state":"CA","report_number":"NCRM006410","insp_date":"2024-09-04 00:00:00","insp_start_time":"1616","insp_end_time":"1631","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS LLC","shipping_paper_number":"232496","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15513546","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-06 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:14.000000Z","updated_at":"2025-03-17T20:35:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10753947,"change_date":"2024-09-06 21:41:00","inspection_id":"82599568","insp_unit_id":"202806588","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1 \/ SILV","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"Y","insp_unit_decal_number":"34138644","created_at":"2025-03-17T23:34:20.000000Z","updated_at":"2025-03-17T23:34:20.000000Z"},{"id":10753948,"change_date":"2024-09-06 21:41:00","inspection_id":"82599568","insp_unit_id":"202806589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"M9\/WHT","insp_unit_license":"4VX8963","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B8GL949979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:20.000000Z","updated_at":"2025-03-17T23:34:20.000000Z"}]},{"id":6578847,"change_date":"2024-08-27 21:43:00","inspection_id":"82502534","dot_number":"1670993","report_state":"CA","report_number":"UDFU003592","insp_date":"2024-08-27 00:00:00","insp_start_time":"0927","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"VETERANS LIVING MEMORIAL","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15499052","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-27 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:14.000000Z","updated_at":"2025-03-17T20:33:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10606057,"change_date":"2024-08-27 21:43:00","inspection_id":"82502534","insp_unit_id":"202616643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"34133104","created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"},{"id":10606058,"change_date":"2024-08-27 21:43:00","inspection_id":"82502534","insp_unit_id":"202616644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"}]},{"id":6542264,"change_date":"2024-08-22 21:43:00","inspection_id":"82463566","dot_number":"1670993","report_state":"CA","report_number":"UD3C000570","insp_date":"2024-08-21 00:00:00","insp_start_time":"1535","insp_end_time":"1550","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"15492487","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"356054","created_at":"2025-03-17T20:32:45.000000Z","updated_at":"2025-03-17T20:32:45.000000Z","inspection_violations":[{"id":10164304,"change_date":"2024-08-22 21:43:00","inspection_id":"82463566","insp_violation_id":"261359742","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202542177","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10546515,"change_date":"2024-08-22 21:43:00","inspection_id":"82463566","insp_unit_id":"202542177","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7","insp_unit_license":"ZP22934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR3GN749294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:14.000000Z","updated_at":"2025-03-17T23:32:14.000000Z"},{"id":10546516,"change_date":"2024-08-22 21:43:00","inspection_id":"82463566","insp_unit_id":"202542178","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B4","insp_unit_license":"4MF7129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U385804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:14.000000Z","updated_at":"2025-03-17T23:32:14.000000Z"}]},{"id":6305824,"change_date":"2024-07-25 21:43:00","inspection_id":"82211092","dot_number":"1670993","report_state":"WA","report_number":"2103000438","insp_date":"2024-07-16 00:00:00","insp_start_time":"1609","insp_end_time":"1626","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BERBER FOOD MFG, LLC","shipping_paper_number":"403319","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"686604","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":"2024-07-25 21:43:00","snet_input_date":"2024-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-25 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:49.000000Z","updated_at":"2025-03-17T20:27:49.000000Z","inspection_violations":[{"id":9792084,"change_date":"2024-07-25 21:43:00","inspection_id":"82211092","insp_violation_id":"260833214","seq_no":"1","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"202062286","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"39021TB2"}],"inspection_per_units":[{"id":10160563,"change_date":"2024-07-25 21:43:00","inspection_id":"82211092","insp_unit_id":"202062286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"98","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:16.000000Z","updated_at":"2025-03-17T23:28:16.000000Z"},{"id":10160564,"change_date":"2024-07-25 21:43:00","inspection_id":"82211092","insp_unit_id":"202062287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"S5","insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:16.000000Z","updated_at":"2025-03-17T23:28:16.000000Z"}]},{"id":5939538,"change_date":"2024-06-07 21:38:00","inspection_id":"81816727","dot_number":"1670993","report_state":"CA","report_number":"NELC002075","insp_date":"2024-06-04 00:00:00","insp_start_time":"1218","insp_end_time":"1247","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"229291","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15393905","transaction_code":"A","transaction_date":"2024-06-07 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-07 21:38:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:19.000000Z","updated_at":"2025-03-17T20:20:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9566948,"change_date":"2024-06-07 21:38:00","inspection_id":"81816727","insp_unit_id":"201289025","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5\/RED","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"Y","insp_unit_decal_number":"33800992","created_at":"2025-03-17T23:22:13.000000Z","updated_at":"2025-03-17T23:22:13.000000Z"},{"id":9566949,"change_date":"2024-06-07 21:38:00","inspection_id":"81816727","insp_unit_id":"201289026","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5\/WHT","insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:13.000000Z","updated_at":"2025-03-17T23:22:13.000000Z"}]},{"id":5637290,"change_date":"2024-04-30 21:42:00","inspection_id":"81488629","dot_number":"1670993","report_state":"CA","report_number":"UDBH002429","insp_date":"2024-04-29 00:00:00","insp_start_time":"0850","insp_end_time":"0919","registration_date":null,"region":"PT","ci_status_code":"C","location":"360","location_desc":"LAKEVILLE RD N OF SR37","county_code_state":"CA","county_code":"097","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15341732","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:20.000000Z","updated_at":"2025-03-17T20:14:20.000000Z","inspection_violations":[{"id":8718245,"change_date":"2024-04-30 21:42:00","inspection_id":"81488629","insp_violation_id":"259237237","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3922"},{"id":8718246,"change_date":"2024-04-30 21:42:00","inspection_id":"81488629","insp_violation_id":"259237238","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9080528,"change_date":"2024-04-30 21:42:00","inspection_id":"81488629","insp_unit_id":"200659669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"},{"id":9080529,"change_date":"2024-04-30 21:42:00","inspection_id":"81488629","insp_unit_id":"200659670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"}]},{"id":5617040,"change_date":"2024-04-29 21:42:00","inspection_id":"81466623","dot_number":"1670993","report_state":"WA","report_number":"0905000112","insp_date":"2024-04-24 00:00:00","insp_start_time":"1151","insp_end_time":"1241","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC75","location_desc":"GOLDENDALE WA","county_code_state":"WA","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"228058","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"437913","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":"2024-04-29 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-29 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:55.000000Z","updated_at":"2025-03-17T20:13:55.000000Z","inspection_violations":[{"id":8687710,"change_date":"2024-04-29 21:42:00","inspection_id":"81466623","insp_violation_id":"259191310","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200617301","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"39360C"},{"id":8687711,"change_date":"2024-04-29 21:42:00","inspection_id":"81466623","insp_violation_id":"259191311","seq_no":"2","part_no":"393","part_no_section":"95(a)(4)","insp_viol_unit":"1","insp_unit_id":"200617301","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"39395A4"},{"id":8687712,"change_date":"2024-04-29 21:42:00","inspection_id":"81466623","insp_violation_id":"259191312","seq_no":"3","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":9048441,"change_date":"2024-04-29 21:42:00","inspection_id":"81466623","insp_unit_id":"200617301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"98\/WHT","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"},{"id":9048442,"change_date":"2024-04-29 21:42:00","inspection_id":"81466623","insp_unit_id":"200617302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"M-9","insp_unit_license":"949979","insp_unit_license_state":"UT","insp_unit_vehicle_id_number":"1JJV532B8G2949979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"}]},{"id":5436199,"change_date":"2024-04-17 21:41:00","inspection_id":"81269298","dot_number":"1670993","report_state":"OR","report_number":"AASC010965","insp_date":"2024-04-04 00:00:00","insp_start_time":"0913","insp_end_time":"0935","registration_date":"2024-04-17 00:00:00","region":"PT","ci_status_code":"C","location":"2005","location_desc":"LOWELL - 4 MI E LOWELL JCT","county_code_state":"OR","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SUPERMERCADOS INC","shipping_paper_number":"32311","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1246085","transaction_code":"C","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-04 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"092886","created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[{"id":8391734,"change_date":"2024-04-17 21:41:00","inspection_id":"81269298","insp_violation_id":"258988147","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200448351","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8756754,"change_date":"2024-04-17 21:41:00","inspection_id":"81269298","insp_unit_id":"200448350","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:27.000000Z","updated_at":"2025-03-17T23:14:27.000000Z"},{"id":8756755,"change_date":"2024-04-17 21:41:00","inspection_id":"81269298","insp_unit_id":"200448351","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"B3","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:27.000000Z","updated_at":"2025-03-17T23:14:27.000000Z"}]},{"id":5247603,"change_date":"2024-03-08 21:40:00","inspection_id":"81063438","dot_number":"1670993","report_state":"CA","report_number":"NDN9004932","insp_date":"2024-03-07 00:00:00","insp_start_time":"1606","insp_end_time":"1612","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"226507","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15275007","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-08 21:40:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:40.000000Z","updated_at":"2025-03-17T20:06:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8449896,"change_date":"2024-03-08 21:40:00","inspection_id":"81063438","insp_unit_id":"199830583","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"33508801","created_at":"2025-03-17T23:11:33.000000Z","updated_at":"2025-03-17T23:11:33.000000Z"},{"id":8449897,"change_date":"2024-03-08 21:40:00","inspection_id":"81063438","insp_unit_id":"199830584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"B3\/WHT","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06297B702980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:33.000000Z","updated_at":"2025-03-17T23:11:33.000000Z"}]},{"id":5166000,"change_date":"2024-02-28 21:43:00","inspection_id":"80974196","dot_number":"1670993","report_state":"CA","report_number":"UCL5004209","insp_date":"2024-02-26 00:00:00","insp_start_time":"1827","insp_end_time":"1842","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SCUSA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15256454","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8317535,"change_date":"2024-02-28 21:43:00","inspection_id":"80974196","insp_unit_id":"199662748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5\/RED","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:22.000000Z","updated_at":"2025-03-17T23:10:22.000000Z"},{"id":8317536,"change_date":"2024-02-28 21:43:00","inspection_id":"80974196","insp_unit_id":"199662749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"L7\/WHT","insp_unit_license":"4RH4190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W57L033506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:22.000000Z","updated_at":"2025-03-17T23:10:22.000000Z"}]},{"id":4869139,"change_date":"2024-01-19 21:44:00","inspection_id":"80650167","dot_number":"1670993","report_state":"CA","report_number":"NC7K008119","insp_date":"2024-01-17 00:00:00","insp_start_time":"0810","insp_end_time":"0853","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15207378","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:14.000000Z","updated_at":"2025-03-17T19:59:14.000000Z","inspection_violations":[{"id":7503874,"change_date":"2024-01-19 21:44:00","inspection_id":"80650167","insp_violation_id":"257421322","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199038340","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7834202,"change_date":"2024-01-19 21:44:00","inspection_id":"80650167","insp_unit_id":"199038340","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT 3X","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"},{"id":7834203,"change_date":"2024-01-19 21:44:00","inspection_id":"80650167","insp_unit_id":"199038341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"B3\/RFR 2X","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06297B702980","insp_unit_decal":"Y","insp_unit_decal_number":"33523415","created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"}]},{"id":4851688,"change_date":"2024-01-17 21:44:00","inspection_id":"80630938","dot_number":"1670993","report_state":"CA","report_number":"NEYV000017","insp_date":"2023-12-22 00:00:00","insp_start_time":"1213","insp_end_time":"1248","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15203668","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:51.000000Z","updated_at":"2025-03-17T19:58:51.000000Z","inspection_violations":[{"id":7479781,"change_date":"2024-01-17 21:44:00","inspection_id":"80630938","insp_violation_id":"257383670","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199001327","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7806226,"change_date":"2024-01-17 21:44:00","inspection_id":"80630938","insp_unit_id":"199001327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:46.000000Z","updated_at":"2025-03-17T23:05:46.000000Z"},{"id":7806227,"change_date":"2024-01-17 21:44:00","inspection_id":"80630938","insp_unit_id":"199001328","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"B3","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06297B702980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:46.000000Z","updated_at":"2025-03-17T23:05:46.000000Z"}]},{"id":4605896,"change_date":"2023-12-11 21:42:00","inspection_id":"80362335","dot_number":"1670993","report_state":"CA","report_number":"NDA2005629","insp_date":"2023-12-01 00:00:00","insp_start_time":"1929","insp_end_time":"1949","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15162145","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-11 21:42:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"356054","created_at":"2025-03-17T19:54:10.000000Z","updated_at":"2025-03-17T19:54:10.000000Z","inspection_violations":[{"id":7122496,"change_date":"2023-12-11 21:42:00","inspection_id":"80362335","insp_violation_id":"256828885","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198454190","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:26.000000Z","updated_at":"2025-03-17T21:40:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7408439,"change_date":"2023-12-11 21:42:00","inspection_id":"80362335","insp_unit_id":"198454189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"6941","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:16.000000Z","updated_at":"2025-03-17T23:02:16.000000Z"},{"id":7408440,"change_date":"2023-12-11 21:42:00","inspection_id":"80362335","insp_unit_id":"198454190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:16.000000Z","updated_at":"2025-03-17T23:02:16.000000Z"}]},{"id":3757687,"change_date":"2023-08-16 21:39:00","inspection_id":"79422583","dot_number":"1670993","report_state":"OR","report_number":"AADU003243","insp_date":"2023-08-15 00:00:00","insp_start_time":"2054","insp_end_time":"2113","registration_date":null,"region":"PT","ci_status_code":"C","location":"2005","location_desc":"LOWELL - 4 MI E LOWELL JCT","county_code_state":"OR","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MULTIPLE SHIPPERS","shipping_paper_number":"1100690882","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1230967","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-16 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"092886","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6042290,"change_date":"2023-08-16 21:39:00","inspection_id":"79422583","insp_unit_id":"196564776","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPRZLN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6042291,"change_date":"2023-08-16 21:39:00","inspection_id":"79422583","insp_unit_id":"196564777","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B4","insp_unit_license":"4MF7129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3539628,"change_date":"2023-07-18 21:43:00","inspection_id":"79178528","dot_number":"1670993","report_state":"CA","report_number":"NCV6005570","insp_date":"2023-07-11 00:00:00","insp_start_time":"0926","insp_end_time":"1002","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS LLC","shipping_paper_number":"217705","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14987039","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-18 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:51.000000Z","updated_at":"2025-03-17T19:32:51.000000Z","inspection_violations":[{"id":5457785,"change_date":"2023-07-18 21:43:00","inspection_id":"79178528","insp_violation_id":"254139562","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"196070080","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"39345"},{"id":5457786,"change_date":"2023-07-18 21:43:00","inspection_id":"79178528","insp_violation_id":"254139563","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196070080","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA307487","created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"39347E"},{"id":5457787,"change_date":"2023-07-18 21:43:00","inspection_id":"79178528","insp_violation_id":"254139564","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196070080","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5691474,"change_date":"2023-07-18 21:43:00","inspection_id":"79178528","insp_unit_id":"196070080","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5\/RED","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"},{"id":5691475,"change_date":"2023-07-18 21:43:00","inspection_id":"79178528","insp_unit_id":"196070081","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1710","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"Y","insp_unit_decal_number":"32834766","created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"}]},{"id":3539798,"change_date":"2023-07-18 21:43:00","inspection_id":"79178708","dot_number":"1670993","report_state":"CA","report_number":"NDZX001590","insp_date":"2023-07-11 00:00:00","insp_start_time":"1435","insp_end_time":"1444","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"217705","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14986788","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-18 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:51.000000Z","updated_at":"2025-03-17T19:32:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5691720,"change_date":"2023-07-18 21:43:00","inspection_id":"79178708","insp_unit_id":"196070347","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"RED","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"Y","insp_unit_decal_number":"32835282","created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"},{"id":5691721,"change_date":"2023-07-18 21:43:00","inspection_id":"79178708","insp_unit_id":"196070348","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT","insp_unit_license":"4RZ1710","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"}]},{"id":3058702,"change_date":"2023-05-16 21:43:00","inspection_id":"78636910","dot_number":"1670993","report_state":"CA","report_number":"NCV6005367","insp_date":"2023-04-20 00:00:00","insp_start_time":"0929","insp_end_time":"0947","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"214881","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14902120","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-16 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:26.000000Z","updated_at":"2025-03-17T19:23:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4920944,"change_date":"2023-05-16 21:43:00","inspection_id":"78636910","insp_unit_id":"194963778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"Y","insp_unit_decal_number":"32445860","created_at":"2025-03-17T22:41:48.000000Z","updated_at":"2025-03-17T22:41:48.000000Z"},{"id":4920945,"change_date":"2023-05-16 21:43:00","inspection_id":"78636910","insp_unit_id":"194963779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"Y","insp_unit_decal_number":"32445861","created_at":"2025-03-17T22:41:48.000000Z","updated_at":"2025-03-17T22:41:48.000000Z"}]},{"id":2947616,"change_date":"2023-05-02 21:41:00","inspection_id":"78511358","dot_number":"1670993","report_state":"CA","report_number":"N9PH003135","insp_date":"2023-04-06 00:00:00","insp_start_time":"1933","insp_end_time":"1941","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS","shipping_paper_number":"214210","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14883630","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4742915,"change_date":"2023-05-02 21:41:00","inspection_id":"78511358","insp_unit_id":"194711298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"},{"id":4742916,"change_date":"2023-05-02 21:41:00","inspection_id":"78511358","insp_unit_id":"194711299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5","insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25305U447010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"}]},{"id":2736144,"change_date":"2023-04-04 21:43:00","inspection_id":"78272007","dot_number":"1670993","report_state":"CA","report_number":"NDN9003984","insp_date":"2023-03-23 00:00:00","insp_start_time":"1726","insp_end_time":"1743","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS LLC","shipping_paper_number":"214105","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14842650","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-04 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:01.000000Z","updated_at":"2025-03-17T19:17:01.000000Z","inspection_violations":[{"id":4201643,"change_date":"2023-04-04 21:43:00","inspection_id":"78272007","insp_violation_id":"252052844","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194232387","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4404433,"change_date":"2023-04-04 21:43:00","inspection_id":"78272007","insp_unit_id":"194232387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"98\/WHT","insp_unit_license":"YP77365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR2LN145643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:39.000000Z","updated_at":"2025-03-17T22:37:39.000000Z"},{"id":4404434,"change_date":"2023-04-04 21:43:00","inspection_id":"78272007","insp_unit_id":"194232388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"B3\/WHT","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06297B702980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:39.000000Z","updated_at":"2025-03-17T22:37:39.000000Z"}]},{"id":1808832,"change_date":"2022-11-23 21:40:00","inspection_id":"77213492","dot_number":"1670993","report_state":"OR","report_number":"AADW003347","insp_date":"2022-11-20 00:00:00","insp_start_time":"1045","insp_end_time":"1057","registration_date":null,"region":"PT","ci_status_code":"C","location":"1404","location_desc":"CASCADE LOCKS POE","county_code_state":"OR","county_code":"027","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","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-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1214432","transaction_code":"A","transaction_date":"2022-11-20 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-23 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"092886","created_at":"2025-03-17T18:59:59.000000Z","updated_at":"2025-03-17T18:59:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2909830,"change_date":"2022-11-23 21:40:00","inspection_id":"77213492","insp_unit_id":"192115357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"WP50926","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR5BN289079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"},{"id":2909831,"change_date":"2022-11-23 21:40:00","inspection_id":"77213492","insp_unit_id":"192115358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5","insp_unit_license":"4MY5934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1802379,"change_date":"2022-11-22 21:41:00","inspection_id":"77206001","dot_number":"1670993","report_state":"CA","report_number":"NBTJ003803","insp_date":"2022-11-03 00:00:00","insp_start_time":"1738","insp_end_time":"1750","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"14682077","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:57.000000Z","updated_at":"2025-03-17T18:59:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2899444,"change_date":"2022-11-22 21:41:00","inspection_id":"77206001","insp_unit_id":"192100214","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"GRY","insp_unit_license":"WP50926","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR5BN289079","insp_unit_decal":"Y","insp_unit_decal_number":"31808752","created_at":"2025-03-17T22:26:50.000000Z","updated_at":"2025-03-17T22:26:50.000000Z"},{"id":2899445,"change_date":"2022-11-22 21:41:00","inspection_id":"77206001","insp_unit_id":"192100215","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"Y","insp_unit_decal_number":"31808753","created_at":"2025-03-17T22:26:50.000000Z","updated_at":"2025-03-17T22:26:50.000000Z"}]},{"id":1346373,"change_date":"2022-09-22 21:40:00","inspection_id":"76680707","dot_number":"1670993","report_state":"WA","report_number":"W531004246","insp_date":"2022-09-20 00:00:00","insp_start_time":"1356","insp_end_time":"1502","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SPICERS PAPER","shipping_paper_number":"BURGO#50","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2522145","transaction_code":"A","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-21 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2132329,"change_date":"2022-09-22 21:40:00","inspection_id":"76680707","insp_violation_id":"248590559","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191048463","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"39345D"},{"id":2132330,"change_date":"2022-09-22 21:40:00","inspection_id":"76680707","insp_violation_id":"248590560","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191048463","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3939A"},{"id":2132331,"change_date":"2022-09-22 21:40:00","inspection_id":"76680707","insp_violation_id":"248590561","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"191048464","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":2168088,"change_date":"2022-09-22 21:40:00","inspection_id":"76680707","insp_unit_id":"191048463","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN263908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:50.000000Z","updated_at":"2025-03-17T22:21:50.000000Z"},{"id":2168089,"change_date":"2022-09-22 21:40:00","inspection_id":"76680707","insp_unit_id":"191048464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"L7","insp_unit_license":"4RH4190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W57L033506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:50.000000Z","updated_at":"2025-03-17T22:21:50.000000Z"}]},{"id":1243685,"change_date":"2022-09-08 21:39:00","inspection_id":"76561074","dot_number":"1670993","report_state":"CA","report_number":"NCRM004099","insp_date":"2022-08-25 00:00:00","insp_start_time":"1803","insp_end_time":"1822","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AB FOODS LLC","shipping_paper_number":"206705","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14587245","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:41.000000Z","updated_at":"2025-03-17T18:49:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2001542,"change_date":"2022-09-08 21:39:00","inspection_id":"76561074","insp_unit_id":"190798383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4\/SILV","insp_unit_license":"WP50926","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR5BN289079","insp_unit_decal":"Y","insp_unit_decal_number":"31458407","created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"},{"id":2001543,"change_date":"2022-09-08 21:39:00","inspection_id":"76561074","insp_unit_id":"190798384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8\/WHT","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W07L046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"}]},{"id":1088431,"change_date":"2022-08-19 21:36:00","inspection_id":"76380935","dot_number":"1670993","report_state":"OR","report_number":"AABN003329","insp_date":"2022-08-18 00:00:00","insp_start_time":"0628","insp_end_time":"0645","registration_date":null,"region":"PT","ci_status_code":"C","location":"1805","location_desc":"KLAMATH FALLS SB - 1 MI N TOWN","county_code_state":"OR","county_code":"035","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"RIZO LOPEZ FOODS INC","shipping_paper_number":"3066392","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-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1208235","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-19 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-08-19 21:36:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"092886","created_at":"2025-03-17T18:46:54.000000Z","updated_at":"2025-03-17T18:46:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1750868,"change_date":"2022-08-19 21:36:00","inspection_id":"76380935","insp_unit_id":"190431267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"WP50926","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR5BN289079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:03.000000Z","updated_at":"2025-03-17T22:19:03.000000Z"},{"id":1750869,"change_date":"2022-08-19 21:36:00","inspection_id":"76380935","insp_unit_id":"190431268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R8","insp_unit_license":"4RZ1718","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:03.000000Z","updated_at":"2025-03-17T22:19:03.000000Z"}]},{"id":158695,"change_date":"2022-04-12 21:43:00","inspection_id":"75282135","dot_number":"1670993","report_state":"OR","report_number":"AAA2005191","insp_date":"2022-04-11 00:00:00","insp_start_time":"1703","insp_end_time":"1722","registration_date":null,"region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AFCO DISTIBUTIONS","shipping_paper_number":"KBX1204577622","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"1200834","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-12 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-04-12 21:43:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"092886","created_at":"2025-03-17T18:30:12.000000Z","updated_at":"2025-03-17T18:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":257146,"change_date":"2022-04-12 21:43:00","inspection_id":"75282135","insp_unit_id":"188112786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"05","insp_unit_license":"WP60103","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR9BN26390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:45.000000Z","updated_at":"2025-03-17T22:09:45.000000Z"},{"id":257147,"change_date":"2022-04-12 21:43:00","inspection_id":"75282135","insp_unit_id":"188112787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"01","insp_unit_license":"4HK5569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:45.000000Z","updated_at":"2025-03-17T22:09:45.000000Z"}]},{"id":82911,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","dot_number":"1670993","report_state":"OR","report_number":"AASJ008427","insp_date":"2022-03-30 00:00:00","insp_start_time":"1110","insp_end_time":"1147","registration_date":"2022-04-18 00:00:00","region":"MT","ci_status_code":"C","location":"1807","location_desc":"KLAMATH FALLS POE","county_code_state":"OR","county_code":"035","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"KRAFT HEINZ FOODS CO","shipping_paper_number":"2072625700","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1200351","transaction_code":"C","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01670993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-31 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"BERNARDO SANDOVAL","insp_carrier_street":"308 C ST","insp_carrier_city":"WATERFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"95386","insp_colonia":null,"docket_number":"614182","insp_interstate":"Y","insp_carrier_state_id":"092886","created_at":"2025-03-17T18:29:06.000000Z","updated_at":"2025-03-17T18:29:06.000000Z","inspection_violations":[{"id":121738,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","insp_violation_id":"245212921","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188201188","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:40.000000Z","updated_at":"2025-03-17T21:07:40.000000Z","normalized_code":"39347E"},{"id":121739,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","insp_violation_id":"245212922","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188201188","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:40.000000Z","updated_at":"2025-03-17T21:07:40.000000Z","normalized_code":"39353B"},{"id":121740,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","insp_violation_id":"245212923","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188201188","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:40.000000Z","updated_at":"2025-03-17T21:07:40.000000Z","normalized_code":"39347E"},{"id":121741,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","insp_violation_id":"245212924","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188201188","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:40.000000Z","updated_at":"2025-03-17T21:07:40.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":134564,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","insp_unit_id":"188201188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4","insp_unit_license":"WP50926","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSCUAPR5BN289079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"},{"id":134565,"change_date":"2022-04-18 21:42:00","inspection_id":"75189568","insp_unit_id":"188201189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B4","insp_unit_license":"4MF7129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"Y","insp_unit_decal_number":"30978778","created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1670993\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1670993\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1670993\/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\/1670993\/inspections","per_page":100,"prev_page_url":null,"to":44,"total":44}