{"current_page":1,"data":[{"id":7341526,"change_date":"2024-12-04 21:42:00","inspection_id":"83312212","dot_number":"2809309","report_state":"CA","report_number":"NEUU000278","insp_date":"2024-12-04 00:00:00","insp_start_time":"0842","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-12-04 21:42: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":"15617123","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"BERBER TRUCKING LLC","insp_carrier_street":"21965 RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842814,"change_date":"2024-12-04 21:42:00","inspection_id":"83312212","insp_unit_id":"204192953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/WHT","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"Y","insp_unit_decal_number":"34477786","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11842815,"change_date":"2024-12-04 21:42:00","inspection_id":"83312212","insp_unit_id":"204192954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"285\/WHT","insp_unit_license":"4UV1249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5323XS291808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7341540,"change_date":"2024-12-04 21:42:00","inspection_id":"83312226","dot_number":"2809309","report_state":"CA","report_number":"NEUU000279","insp_date":"2024-12-04 00:00:00","insp_start_time":"0924","insp_end_time":"1005","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-12-04 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":"15616812","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"BERBER TRUCKING LLC","insp_carrier_street":"21965 RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842840,"change_date":"2024-12-04 21:42:00","inspection_id":"83312226","insp_unit_id":"204192981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7\/WHT","insp_unit_license":"9G27598","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR0DLBV9014","insp_unit_decal":"Y","insp_unit_decal_number":"34477787","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11842841,"change_date":"2024-12-04 21:42:00","inspection_id":"83312226","insp_unit_id":"204192982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7341541,"change_date":"2024-12-04 21:42:00","inspection_id":"83312227","dot_number":"2809309","report_state":"CA","report_number":"NEUU000280","insp_date":"2024-12-04 00:00:00","insp_start_time":"1010","insp_end_time":"1043","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-12-04 21:42: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":"15616788","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"BERBER TRUCKING LLC","insp_carrier_street":"21965 RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842842,"change_date":"2024-12-04 21:42:00","inspection_id":"83312227","insp_unit_id":"204192983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/ORG","insp_unit_license":"9G49093","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV2ELFK3362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7306411,"change_date":"2024-11-30 21:33:00","inspection_id":"83275308","dot_number":"2809309","report_state":"CA","report_number":"NEUU000272","insp_date":"2024-11-26 00:00:00","insp_start_time":"0816","insp_end_time":"0912","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-11-30 21:33: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":"15606308","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[{"id":11423593,"change_date":"2024-11-30 21:33:00","inspection_id":"83275308","insp_violation_id":"263150806","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204110530","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"39360D"},{"id":11423594,"change_date":"2024-11-30 21:33:00","inspection_id":"83275308","insp_violation_id":"263150807","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"204110531","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":11423595,"change_date":"2024-11-30 21:33:00","inspection_id":"83275308","insp_violation_id":"263150808","seq_no":"3","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"204110530","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"393207ASTCB"}],"inspection_per_units":[{"id":11786286,"change_date":"2024-11-30 21:33:00","inspection_id":"83275308","insp_unit_id":"204110530","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7\/WHT","insp_unit_license":"9G27598","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR0DLBV9014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"},{"id":11786287,"change_date":"2024-11-30 21:33:00","inspection_id":"83275308","insp_unit_id":"204110531","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"}]},{"id":7306574,"change_date":"2024-11-30 21:33:00","inspection_id":"83275472","dot_number":"2809309","report_state":"CA","report_number":"NEUU000273","insp_date":"2024-11-26 00:00:00","insp_start_time":"0915","insp_end_time":"0958","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15609302","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[{"id":11423743,"change_date":"2024-11-30 21:33:00","inspection_id":"83275472","insp_violation_id":"263150965","seq_no":"1","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"204110782","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"393207ASTCB"}],"inspection_per_units":[{"id":11786534,"change_date":"2024-11-30 21:33:00","inspection_id":"83275472","insp_unit_id":"204110782","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/WHT","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"},{"id":11786535,"change_date":"2024-11-30 21:33:00","inspection_id":"83275472","insp_unit_id":"204110783","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"285\/WHT","insp_unit_license":"4UV1249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5323XS291808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"}]},{"id":7306575,"change_date":"2024-11-30 21:33:00","inspection_id":"83275473","dot_number":"2809309","report_state":"CA","report_number":"NEUU000274","insp_date":"2024-11-26 00:00:00","insp_start_time":"1000","insp_end_time":"1041","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-11-30 21:33: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":"15606048","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11786536,"change_date":"2024-11-30 21:33:00","inspection_id":"83275473","insp_unit_id":"204110784","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/ORG","insp_unit_license":"9G49093","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV2ELFK3362","insp_unit_decal":"Y","insp_unit_decal_number":"34477779","created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"}]},{"id":7197424,"change_date":"2024-11-14 21:41:00","inspection_id":"83160044","dot_number":"2809309","report_state":"CA","report_number":"UFYK000154","insp_date":"2024-11-12 00:00:00","insp_start_time":"1531","insp_end_time":"1553","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580 LIVERMORE","county_code_state":"CA","county_code":"001","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-11-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":"15593277","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:03.000000Z","updated_at":"2025-03-17T20:46:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11609391,"change_date":"2024-11-14 21:41:00","inspection_id":"83160044","insp_unit_id":"203888209","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI 3X","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"},{"id":11609392,"change_date":"2024-11-14 21:41:00","inspection_id":"83160044","insp_unit_id":"203888210","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHI #53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"}]},{"id":6589122,"change_date":"2024-08-28 21:43:00","inspection_id":"82513448","dot_number":"2809309","report_state":"CA","report_number":"NBEV005813","insp_date":"2024-08-22 00:00:00","insp_start_time":"0641","insp_end_time":"0714","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MALLARD CREEK INC","shipping_paper_number":"31708322","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-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15499693","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-08-28 21:43:00","snet_input_date":"2024-08-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-28 21:43:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:39.000000Z","updated_at":"2025-03-17T20:33:39.000000Z","inspection_violations":[{"id":10246171,"change_date":"2024-08-28 21:43:00","inspection_id":"82513448","insp_violation_id":"261476522","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202638776","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3963A1"},{"id":10246172,"change_date":"2024-08-28 21:43:00","inspection_id":"82513448","insp_violation_id":"261476523","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202638775","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":10622971,"change_date":"2024-08-28 21:43:00","inspection_id":"82513448","insp_unit_id":"202638775","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:01.000000Z","updated_at":"2025-03-17T23:33:01.000000Z"},{"id":10622972,"change_date":"2024-08-28 21:43:00","inspection_id":"82513448","insp_unit_id":"202638776","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:01.000000Z","updated_at":"2025-03-17T23:33:01.000000Z"}]},{"id":6507819,"change_date":"2024-08-19 21:43:00","inspection_id":"82426967","dot_number":"2809309","report_state":"CA","report_number":"NEUU000186","insp_date":"2024-08-19 00:00:00","insp_start_time":"0805","insp_end_time":"0846","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15489066","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10107890,"change_date":"2024-08-19 21:43:00","inspection_id":"82426967","insp_violation_id":"261279756","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202472927","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39345B2"},{"id":10107891,"change_date":"2024-08-19 21:43:00","inspection_id":"82426967","insp_violation_id":"261279757","seq_no":"2","part_no":"393","part_no_section":"50(c)","insp_viol_unit":"1","insp_unit_id":"202472927","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39350C"}],"inspection_per_units":[{"id":10490652,"change_date":"2024-08-19 21:43:00","inspection_id":"82426967","insp_unit_id":"202472927","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6\/ORG","insp_unit_license":"9G49093","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV2ELFK3362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:41.000000Z","updated_at":"2025-03-17T23:31:41.000000Z"}]},{"id":6530295,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","dot_number":"2809309","report_state":"CA","report_number":"NEUU000187","insp_date":"2024-08-19 00:00:00","insp_start_time":"0855","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15491189","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-08-21 21:43:00","snet_input_date":"2024-08-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-21 21:43:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:32:22.000000Z","updated_at":"2025-03-17T20:32:22.000000Z","inspection_violations":[{"id":10144863,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_violation_id":"261332290","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202518424","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"39347E"},{"id":10144864,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_violation_id":"261332291","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202518424","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"39347E"},{"id":10144865,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_violation_id":"261332292","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202518424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"39353B"},{"id":10144866,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_violation_id":"261332293","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202518424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"39348A"},{"id":10144867,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_violation_id":"261332294","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202518424","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"3963A1"},{"id":10144868,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_violation_id":"261332295","seq_no":"6","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"202518423","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":10527213,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_unit_id":"202518423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7\/WHT","insp_unit_license":"9G27598","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR0DLBV9014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:02.000000Z","updated_at":"2025-03-17T23:32:02.000000Z"},{"id":10527214,"change_date":"2024-08-21 21:43:00","inspection_id":"82450811","insp_unit_id":"202518424","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"285\/WHT","insp_unit_license":"4UV1249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5323XS291808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:02.000000Z","updated_at":"2025-03-17T23:32:02.000000Z"}]},{"id":6153909,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","dot_number":"2809309","report_state":"CA","report_number":"NBEV005658","insp_date":"2024-07-02 00:00:00","insp_start_time":"0606","insp_end_time":"0638","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHEVRON","shipping_paper_number":"258603820","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-07-05 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15431406","transaction_code":"A","transaction_date":"2024-07-04 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-07-05 21:36:00","snet_input_date":"2024-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-05 21:36:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:37.000000Z","updated_at":"2025-03-17T20:24:37.000000Z","inspection_violations":[{"id":9551065,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","insp_violation_id":"260484593","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"201749794","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3965B"},{"id":9551066,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","insp_violation_id":"260484594","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"201749794","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39345"},{"id":9551067,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","insp_violation_id":"260484595","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201749794","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KW78493","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3922"},{"id":9551068,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","insp_violation_id":"260484596","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201749793","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9912845,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","insp_unit_id":"201749793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"},{"id":9912846,"change_date":"2024-07-05 21:36:00","inspection_id":"82048050","insp_unit_id":"201749794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"}]},{"id":5880126,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","dot_number":"2809309","report_state":"CA","report_number":"UB36003871","insp_date":"2024-05-28 00:00:00","insp_start_time":"1025","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"220","location_desc":"AUBURN AREA","county_code_state":"CA","county_code":"061","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-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15383579","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-05-30 21:43:00","snet_input_date":"2024-05-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-30 21:43:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:19:25.000000Z","updated_at":"2025-03-17T20:19:25.000000Z","inspection_violations":[{"id":9117485,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","insp_violation_id":"259822603","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201163241","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"3922"},{"id":9117486,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","insp_violation_id":"259822604","seq_no":"2","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:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"3922"},{"id":9117487,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","insp_violation_id":"259822605","seq_no":"3","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":"1","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"3922"},{"id":9117488,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","insp_violation_id":"259822606","seq_no":"4","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"201163241","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":9470577,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","insp_unit_id":"201163241","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"},{"id":9470578,"change_date":"2024-05-30 21:43:00","inspection_id":"81751928","insp_unit_id":"201163242","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":5590834,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","dot_number":"2809309","report_state":"CA","report_number":"NEUU000107","insp_date":"2024-04-24 00:00:00","insp_start_time":"0745","insp_end_time":"0842","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15333668","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-04-24 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-24 21:42:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:13:31.000000Z","updated_at":"2025-03-17T20:13:31.000000Z","inspection_violations":[{"id":8643661,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_violation_id":"259126337","seq_no":"1","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"200562329","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"393207F"},{"id":8643662,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_violation_id":"259126338","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200562329","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39347E"},{"id":8643663,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_violation_id":"259126339","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200562329","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39353B"},{"id":8643664,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_violation_id":"259126340","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200562329","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"3963A1"},{"id":8643665,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_violation_id":"259126341","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200562329","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9005601,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_unit_id":"200562328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7\/WHT","insp_unit_license":"9G27598","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR0DLBV9014","insp_unit_decal":"Y","insp_unit_decal_number":"33828792","created_at":"2025-03-17T23:16:48.000000Z","updated_at":"2025-03-17T23:16:48.000000Z"},{"id":9005602,"change_date":"2024-04-24 21:42:00","inspection_id":"81437903","insp_unit_id":"200562329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210\/WHT","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:48.000000Z","updated_at":"2025-03-17T23:16:48.000000Z"}]},{"id":5590915,"change_date":"2024-04-24 21:42:00","inspection_id":"81437986","dot_number":"2809309","report_state":"CA","report_number":"NEUU000108","insp_date":"2024-04-24 00:00:00","insp_start_time":"0848","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN","county_code_state":"CA","county_code":"019","insp_level_id":"5","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-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15333404","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2024-04-24 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-24 21:42:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T20:13:31.000000Z","updated_at":"2025-03-17T20:13:31.000000Z","inspection_violations":[{"id":8643759,"change_date":"2024-04-24 21:42:00","inspection_id":"81437986","insp_violation_id":"259126441","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200562463","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39347E"},{"id":8643760,"change_date":"2024-04-24 21:42:00","inspection_id":"81437986","insp_violation_id":"259126442","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200562463","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9005730,"change_date":"2024-04-24 21:42:00","inspection_id":"81437986","insp_unit_id":"200562463","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/WHT","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:48.000000Z","updated_at":"2025-03-17T23:16:48.000000Z"},{"id":9005731,"change_date":"2024-04-24 21:42:00","inspection_id":"81437986","insp_unit_id":"200562464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"285\/WHT","insp_unit_license":"4UV1249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5323XS291808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:48.000000Z","updated_at":"2025-03-17T23:16:48.000000Z"}]},{"id":4138110,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","dot_number":"2809309","report_state":"CA","report_number":"NDE9005480","insp_date":"2023-10-02 00:00:00","insp_start_time":"0615","insp_end_time":"0638","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"LEBEC","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MID VALLEY DISPOSAL INC.","shipping_paper_number":"4412026","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-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15086090","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[{"id":6405733,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","insp_violation_id":"255688965","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197424968","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922"},{"id":6405734,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","insp_violation_id":"255688966","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197424968","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922"},{"id":6405735,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","insp_violation_id":"255688967","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197424968","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39345B2"},{"id":6405736,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","insp_violation_id":"255688968","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197424968","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":6653950,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","insp_unit_id":"197424968","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"9G27598","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR0DLBV9014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"},{"id":6653951,"change_date":"2023-10-05 21:40:00","inspection_id":"79846272","insp_unit_id":"197424969","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"}]},{"id":3937962,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","dot_number":"2809309","report_state":"CA","report_number":"NDU0999743","insp_date":"2023-08-11 00:00:00","insp_start_time":"0742","insp_end_time":"0839","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SAN JOAQUIN, CA","county_code_state":"CA","county_code":"019","insp_level_id":"5","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":"2023-09-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15054779","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2023-09-08 21:42:00","snet_input_date":"2023-08-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-08 21:42:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"207255","created_at":"2025-03-17T19:40:30.000000Z","updated_at":"2025-03-17T19:40:30.000000Z","inspection_violations":[{"id":6088515,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176837","seq_no":"12","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39345B2"},{"id":6088516,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176838","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39347E"},{"id":6088517,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176839","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39353B"},{"id":6088518,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176840","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39347E"},{"id":6088519,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176841","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3963A1"},{"id":6088520,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176842","seq_no":"5","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"196976775","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39351"},{"id":6088521,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176843","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196976775","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3963A1"},{"id":6088522,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176844","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196976775","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3963A1"},{"id":6088523,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176845","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196976775","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39345B2"},{"id":6088524,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176846","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196976775","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3963A1"},{"id":6088525,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176847","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"3963A1"},{"id":6088526,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_violation_id":"255176848","seq_no":"11","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196976776","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:26.000000Z","updated_at":"2025-03-17T21:35:26.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":6331981,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_unit_id":"196976775","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:12.000000Z","updated_at":"2025-03-17T22:53:12.000000Z"},{"id":6331982,"change_date":"2023-09-08 21:42:00","inspection_id":"79623906","insp_unit_id":"196976776","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"285","insp_unit_license":"4UV1249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5323XS291808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:12.000000Z","updated_at":"2025-03-17T22:53:12.000000Z"}]},{"id":3678603,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","dot_number":"2809309","report_state":"CA","report_number":"UDMC002403","insp_date":"2023-08-04 00:00:00","insp_start_time":"0840","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"VICTORVILLE CHP AREA","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNRISE MFG","shipping_paper_number":"444011229","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15009507","transaction_code":"A","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[{"id":5672511,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","insp_violation_id":"254490698","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196382831","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39375C"},{"id":5672512,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","insp_violation_id":"254490699","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196382831","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"3922"},{"id":5672513,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","insp_violation_id":"254490700","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196382831","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39347E"},{"id":5672514,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","insp_violation_id":"254490701","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196382831","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5914414,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","insp_unit_id":"196382831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"9G27598","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR0DLBV9014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"},{"id":5914415,"change_date":"2023-08-04 21:41:00","inspection_id":"79334648","insp_unit_id":"196382832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53210","insp_unit_license":"4UM3645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539YP097007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"}]},{"id":2329432,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","dot_number":"2809309","report_state":"CA","report_number":"NDUF003619","insp_date":"2023-02-07 00:00:00","insp_start_time":"2223","insp_end_time":"0008","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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":"2023-02-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14776000","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2023-02-08 21:40:00","snet_input_date":"2023-02-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-08 21:40:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:38.000000Z","updated_at":"2025-03-17T19:09:38.000000Z","inspection_violations":[{"id":3588825,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027916","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193302483","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3588826,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027917","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193302483","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3588827,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027918","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193302483","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3588828,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027919","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193302483","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39355E"},{"id":3588829,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027920","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193302483","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3588830,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027921","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193302482","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3939A"},{"id":3588831,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027922","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193302482","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3588832,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027923","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193302482","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3588833,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_violation_id":"251027924","seq_no":"9","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"1","insp_unit_id":"193302482","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":3749069,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_unit_id":"193302482","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/8","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:50.000000Z","updated_at":"2025-03-17T22:32:50.000000Z"},{"id":3749070,"change_date":"2023-02-08 21:40:00","inspection_id":"77808030","insp_unit_id":"193302483","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"WHT\/285","insp_unit_license":"4UV1249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5323XS291808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:50.000000Z","updated_at":"2025-03-17T22:32:50.000000Z"}]},{"id":2260124,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","dot_number":"2809309","report_state":"CA","report_number":"NAGM006037","insp_date":"2023-01-26 00:00:00","insp_start_time":"0710","insp_end_time":"0757","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14760844","transaction_code":"A","transaction_date":"2023-01-26 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T19:08:27.000000Z","updated_at":"2025-03-17T19:08:27.000000Z","inspection_violations":[{"id":3489821,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858702","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3922"},{"id":3489822,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858703","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3922"},{"id":3489823,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858704","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW 471534","created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"393207A"},{"id":3489824,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858705","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"},{"id":3489825,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858706","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"},{"id":3489826,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858707","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"},{"id":3489827,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858708","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193140204","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"},{"id":3489828,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858709","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193140203","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3965B"},{"id":3489829,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_violation_id":"250858710","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193140203","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3638184,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_unit_id":"193140203","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/WHT","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:05.000000Z","updated_at":"2025-03-17T22:32:05.000000Z"},{"id":3638185,"change_date":"2023-01-30 21:44:00","inspection_id":"77729587","insp_unit_id":"193140204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"53011","insp_unit_license":"4DS8831","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W3YL728634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:05.000000Z","updated_at":"2025-03-17T22:32:05.000000Z"}]},{"id":1382595,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","dot_number":"2809309","report_state":"CA","report_number":"NDT8003072","insp_date":"2022-09-26 00:00:00","insp_start_time":"1416","insp_end_time":"1502","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC C.V.E.F.","county_code_state":"CA","county_code":"037","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":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14610666","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2022-09-27 21:40:00","snet_input_date":"2022-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:18.000000Z","updated_at":"2025-03-17T18:52:18.000000Z","inspection_violations":[{"id":2185612,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_violation_id":"248683888","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191133467","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3939A"},{"id":2185613,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_violation_id":"248683889","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"191133467","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"393205C"},{"id":2185614,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_violation_id":"248683890","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191133467","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"39345B2"},{"id":2185615,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_violation_id":"248683891","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191133468","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3963A1"},{"id":2185616,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_violation_id":"248683892","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191133468","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"39375C"},{"id":2185617,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_violation_id":"248683893","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191133468","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2226539,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_unit_id":"191133467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 3X","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:14.000000Z","updated_at":"2025-03-17T22:22:14.000000Z"},{"id":2226540,"change_date":"2022-09-27 21:40:00","inspection_id":"76722362","insp_unit_id":"191133468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT VAN","insp_unit_license":"4DS8831","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W3YL728634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:14.000000Z","updated_at":"2025-03-17T22:22:14.000000Z"}]},{"id":1320914,"change_date":"2022-09-19 21:40:00","inspection_id":"76650900","dot_number":"2809309","report_state":"CA","report_number":"ND6D003753","insp_date":"2022-09-16 00:00:00","insp_start_time":"0413","insp_end_time":"0450","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PACIFIC COAST PRODUCERS","shipping_paper_number":"1707152","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-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14599915","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2022-09-19 21:40:00","snet_input_date":"2022-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-19 21:40:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T18:51:11.000000Z","updated_at":"2025-03-17T18:51:11.000000Z","inspection_violations":[{"id":2091299,"change_date":"2022-09-19 21:40:00","inspection_id":"76650900","insp_violation_id":"248515908","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190985956","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39347E"},{"id":2091300,"change_date":"2022-09-19 21:40:00","inspection_id":"76650900","insp_violation_id":"248515909","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190985955","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":2126742,"change_date":"2022-09-19 21:40:00","inspection_id":"76650900","insp_unit_id":"190985955","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:34.000000Z","updated_at":"2025-03-17T22:21:34.000000Z"},{"id":2126743,"change_date":"2022-09-19 21:40:00","inspection_id":"76650900","insp_unit_id":"190985956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"53001","insp_unit_license":"4DS8831","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W3YL728634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:34.000000Z","updated_at":"2025-03-17T22:21:34.000000Z"}]},{"id":260074,"change_date":"2022-04-26 21:42:00","inspection_id":"75403538","dot_number":"2809309","report_state":"CA","report_number":"N8OL005179","insp_date":"2022-04-25 00:00:00","insp_start_time":"0728","insp_end_time":"0751","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"REX TRANSPORTATION","shipping_paper_number":"22166284","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-04-26 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":"14400740","transaction_code":"A","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2022-04-26 21:42:00","snet_input_date":"2022-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-26 21:42:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T18:32:11.000000Z","updated_at":"2025-03-17T18:32:11.000000Z","inspection_violations":[{"id":401302,"change_date":"2022-04-26 21:42:00","inspection_id":"75403538","insp_violation_id":"245392109","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188356110","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":421324,"change_date":"2022-04-26 21:42:00","inspection_id":"75403538","insp_unit_id":"188356109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8\/WHITE","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"Y","insp_unit_decal_number":"31128168","created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"},{"id":421325,"change_date":"2022-04-26 21:42:00","inspection_id":"75403538","insp_unit_id":"188356110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"53011\/WHITE","insp_unit_license":"4DS8831","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W3YL728634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"}]},{"id":260318,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","dot_number":"2809309","report_state":"CA","report_number":"NCNK004428","insp_date":"2022-04-25 00:00:00","insp_start_time":"0451","insp_end_time":"0531","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"REX TRANSPORTATION","shipping_paper_number":"22166284","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-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14401098","transaction_code":"A","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809309","upload_search_indicator":null,"census_search_date":"2022-04-26 21:42:00","snet_input_date":"2022-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-26 21:42:00","insp_carrier_name":"JOSE R BERBER BARBOSA","insp_carrier_street":"21965 WEST RAILROAD AVE","insp_carrier_city":"SAN JOAQUIN","insp_carrier_state":"CA","insp_carrier_zip_code":"93660","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"331202","created_at":"2025-03-17T18:32:11.000000Z","updated_at":"2025-03-17T18:32:11.000000Z","inspection_violations":[{"id":401502,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","insp_violation_id":"245392341","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","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-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3958E1"},{"id":401503,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","insp_violation_id":"245392342","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3958"},{"id":401504,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","insp_violation_id":"245392343","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"188356520","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA297951","created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"39347A"},{"id":401505,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","insp_violation_id":"245392344","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188356521","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":421689,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","insp_unit_id":"188356520","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/8","insp_unit_license":"9G52533","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGK0030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"},{"id":421690,"change_date":"2022-04-26 21:42:00","inspection_id":"75403804","insp_unit_id":"188356521","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT\/53011","insp_unit_license":"4DS8831","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W3YL728634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2809309\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2809309\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2809309\/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\/2809309\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}