{"current_page":1,"data":[{"id":11724771,"change_date":"2026-04-22 21:40:00","inspection_id":"87652448","dot_number":"3019645","report_state":"CA","report_number":"UD89003687","insp_date":"2026-04-21 00:00:00","insp_start_time":"1220","insp_end_time":"1246","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","county_code_state":"CA","county_code":"095","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16258445","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2026-04-22 21:40:00","snet_input_date":"2026-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-22 21:40:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2026-04-27T09:40:10.000000Z","updated_at":"2026-05-03T09:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20402007,"change_date":"2026-04-22 21:40:00","inspection_id":"87652448","insp_unit_id":"213168649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"9G47156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XK1D49X8LJ415635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:05.000000Z","updated_at":"2026-05-03T09:04:36.000000Z"},{"id":20402008,"change_date":"2026-04-22 21:40:00","inspection_id":"87652448","insp_unit_id":"213168650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZO","insp_unit_company":null,"insp_unit_license":"4WL4006","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4B9BKDL23TH054279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:05.000000Z","updated_at":"2026-05-03T09:04:36.000000Z"}]},{"id":11402130,"change_date":"2026-03-17 21:40:00","inspection_id":"87317186","dot_number":"3019645","report_state":"CA","report_number":"UD3C001564","insp_date":"2026-03-11 00:00:00","insp_start_time":"1045","insp_end_time":"1108","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128200","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":"16212520","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2026-03-17 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-17 21:40:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2026-03-20T09:42:49.000000Z","updated_at":"2026-03-28T09:32:00.000000Z","inspection_violations":[{"id":19222782,"change_date":"2026-03-17 21:40:00","inspection_id":"87317186","insp_violation_id":"272462823","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"212189855","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-03-20T10:04:03.000000Z","updated_at":"2026-03-28T09:48:44.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19528540,"change_date":"2026-03-17 21:40:00","inspection_id":"87317186","insp_unit_id":"212189854","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"9G47156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XK1D49X8LJ415635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:34.000000Z","updated_at":"2026-03-28T09:06:40.000000Z"},{"id":19528541,"change_date":"2026-03-17 21:40:00","inspection_id":"87317186","insp_unit_id":"212189855","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZO","insp_unit_company":null,"insp_unit_license":"4WL4006","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4B9BKDL23TH054279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:34.000000Z","updated_at":"2026-03-28T09:06:40.000000Z"}]},{"id":11060239,"change_date":"2026-02-05 21:39:00","inspection_id":"86970404","dot_number":"3019645","report_state":"CA","report_number":"UD8R000250","insp_date":"2026-01-30 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"128200","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":"16159587","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2026-02-05 21:39:00","snet_input_date":"2026-01-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-05 21:39:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2026-02-08T10:37:25.000000Z","updated_at":"2026-02-16T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18857389,"change_date":"2026-02-05 21:39:00","inspection_id":"86970404","insp_unit_id":"211470244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"9G47156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XK1D49X8LJ415635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:19.000000Z","updated_at":"2026-02-16T10:04:46.000000Z"},{"id":18857390,"change_date":"2026-02-05 21:39:00","inspection_id":"86970404","insp_unit_id":"211470245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZO","insp_unit_company":null,"insp_unit_license":"4WL4006","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4B9BKDL23TH054279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:19.000000Z","updated_at":"2026-02-16T10:04:46.000000Z"}]},{"id":9117584,"change_date":"2025-07-10 21:39:00","inspection_id":"85182680","dot_number":"3019645","report_state":"CA","report_number":"NDN6009596","insp_date":"2025-07-09 00:00:00","insp_start_time":"1400","insp_end_time":"1424","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15891968","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:54.000000Z","updated_at":"2025-07-14T10:46:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14968433,"change_date":"2025-07-10 21:39:00","inspection_id":"85182680","insp_unit_id":"207810118","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X ORANGE","insp_unit_license":"9G47156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XK1D49X8LJ415635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:47:00.000000Z","updated_at":"2025-07-14T09:46:00.000000Z"},{"id":14968434,"change_date":"2025-07-10 21:39:00","inspection_id":"85182680","insp_unit_id":"207810119","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"2X ED WHITE","insp_unit_license":"4SB2959","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9BB37B5XM110373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:47:00.000000Z","updated_at":"2025-07-14T09:46:00.000000Z"}]},{"id":9001848,"change_date":"2025-06-26 21:42:00","inspection_id":"85060641","dot_number":"3019645","report_state":"CA","report_number":"UD1D001146","insp_date":"2025-06-12 00:00:00","insp_start_time":"1635","insp_end_time":"1710","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15866997","transaction_code":"A","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2025-06-30T10:01:09.000000Z","updated_at":"2025-06-30T10:01:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14762944,"change_date":"2025-06-26 21:42:00","inspection_id":"85060641","insp_unit_id":"207586230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"9G47156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XK1D49X8LJ415635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:25.000000Z","updated_at":"2025-07-01T09:48:29.000000Z"},{"id":14762945,"change_date":"2025-06-26 21:42:00","inspection_id":"85060641","insp_unit_id":"207586231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"WHT","insp_unit_license":"4SB2959","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9BB37B5XM110373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:25.000000Z","updated_at":"2025-07-01T09:48:29.000000Z"}]},{"id":7347762,"change_date":"2024-12-05 21:38:00","inspection_id":"83318819","dot_number":"3019645","report_state":"CA","report_number":"UBGJ006196","insp_date":"2024-12-04 00:00:00","insp_start_time":"1905","insp_end_time":"1957","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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-12-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"15618091","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2024-12-05 21:38:00","snet_input_date":"2024-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-05 21:38:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:23.000000Z","updated_at":"2025-03-17T20:49:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11852784,"change_date":"2024-12-05 21:38:00","inspection_id":"83318819","insp_unit_id":"204214933","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"4SB2959","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9BB37B5XM110373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:52.000000Z","updated_at":"2025-03-17T23:45:52.000000Z"},{"id":11852785,"change_date":"2024-12-05 21:38:00","inspection_id":"83318819","insp_unit_id":"204214934","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3X\/RED","insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:52.000000Z","updated_at":"2025-03-17T23:45:52.000000Z"}]},{"id":7341531,"change_date":"2024-12-04 21:42:00","inspection_id":"83312217","dot_number":"3019645","report_state":"CA","report_number":"NDN6009027","insp_date":"2024-12-03 00:00:00","insp_start_time":"1000","insp_end_time":"1034","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15615920","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842824,"change_date":"2024-12-04 21:42:00","inspection_id":"83312217","insp_unit_id":"204192963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3X RED","insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"Y","insp_unit_decal_number":"34470107","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11842825,"change_date":"2024-12-04 21:42:00","inspection_id":"83312217","insp_unit_id":"204192964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"2X ED","insp_unit_license":"4SB2959","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9BB37B5XM110373","insp_unit_decal":"Y","insp_unit_decal_number":"34470108","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7253730,"change_date":"2024-11-21 21:41:00","inspection_id":"83219580","dot_number":"3019645","report_state":"CA","report_number":"NDN6008995","insp_date":"2024-11-20 00:00:00","insp_start_time":"1330","insp_end_time":"1415","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15602121","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:17.000000Z","updated_at":"2025-03-17T20:47:17.000000Z","inspection_violations":[{"id":11340618,"change_date":"2024-11-21 21:41:00","inspection_id":"83219580","insp_violation_id":"263030909","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"204000177","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA514450","created_at":"2025-03-17T22:01:06.000000Z","updated_at":"2025-03-17T22:01:06.000000Z","normalized_code":"3963A1BALAC"},{"id":11340619,"change_date":"2024-11-21 21:41:00","inspection_id":"83219580","insp_violation_id":"263030910","seq_no":"2","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"204000177","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA514450","created_at":"2025-03-17T22:01:06.000000Z","updated_at":"2025-03-17T22:01:06.000000Z","normalized_code":"39311A1LFTSM"}],"inspection_per_units":[{"id":11700137,"change_date":"2024-11-21 21:41:00","inspection_id":"83219580","insp_unit_id":"204000177","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3X RED","insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:17.000000Z","updated_at":"2025-03-17T23:44:17.000000Z"},{"id":11700138,"change_date":"2024-11-21 21:41:00","inspection_id":"83219580","insp_unit_id":"204000178","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"2X ED","insp_unit_license":"4SB2959","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9BB37B5XM110373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:17.000000Z","updated_at":"2025-03-17T23:44:17.000000Z"}]},{"id":5485901,"change_date":"2024-04-10 21:43:00","inspection_id":"81323760","dot_number":"3019645","report_state":"CA","report_number":"UDJB003662","insp_date":"2024-04-09 00:00:00","insp_start_time":"1320","insp_end_time":"1352","registration_date":null,"region":"PT","ci_status_code":"C","location":"9401","location_desc":"N\/B SANTA NELLA PLATFORM SCALE","county_code_state":"CA","county_code":"047","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15312821","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2024-04-10 21:43:00","snet_input_date":"2024-04-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-10 21:43:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:30.000000Z","updated_at":"2025-03-17T20:11:30.000000Z","inspection_violations":[{"id":8471995,"change_date":"2024-04-10 21:43:00","inspection_id":"81323760","insp_violation_id":"258867647","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200343344","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8837029,"change_date":"2024-04-10 21:43:00","inspection_id":"81323760","insp_unit_id":"200343344","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"9G47156","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XK1D49X8LJ415635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:12.000000Z","updated_at":"2025-03-17T23:15:12.000000Z"},{"id":8837030,"change_date":"2024-04-10 21:43:00","inspection_id":"81323760","insp_unit_id":"200343345","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"4SB2959","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9BB37B5XM110373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:12.000000Z","updated_at":"2025-03-17T23:15:12.000000Z"}]},{"id":5394719,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","dot_number":"3019645","report_state":"CA","report_number":"UDQ3001592","insp_date":"2024-03-27 00:00:00","insp_start_time":"1624","insp_end_time":"1733","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"NB SANTA NELLA SCALES","county_code_state":"CA","county_code":"047","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-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"11","oos_total":"9","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"9","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15299429","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2025-03-17T20:09:29.000000Z","updated_at":"2025-03-17T20:09:29.000000Z","inspection_violations":[{"id":8326373,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647888","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200146283","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MN41733","created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"3922"},{"id":8326374,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647889","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326375,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647890","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326376,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647891","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326377,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647892","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326378,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647893","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326379,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647894","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326380,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647895","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326381,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647896","seq_no":"9","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39345B2"},{"id":8326382,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647897","seq_no":"10","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"200146283","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"393201A"},{"id":8326383,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_violation_id":"258647898","seq_no":"11","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"200146282","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":8688449,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_unit_id":"200146282","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:48.000000Z","updated_at":"2025-03-17T23:13:48.000000Z"},{"id":8688450,"change_date":"2024-03-28 21:41:00","inspection_id":"81223650","insp_unit_id":"200146283","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"4SU8250","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5C2BB39B01M003078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:48.000000Z","updated_at":"2025-03-17T23:13:48.000000Z"}]},{"id":2671243,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","dot_number":"3019645","report_state":"CA","report_number":"UFUE000100","insp_date":"2023-03-20 00:00:00","insp_start_time":"1352","insp_end_time":"1431","registration_date":null,"region":"PT","ci_status_code":"C","location":"9345","location_desc":"NB I-880 TO DAVIS ST OFFRAMP","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133430","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14834083","transaction_code":"A","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2025-03-17T19:15:53.000000Z","updated_at":"2025-03-17T19:15:53.000000Z","inspection_violations":[{"id":4105468,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_violation_id":"251891911","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194086892","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA200807","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39395A"},{"id":4105469,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_violation_id":"251891912","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194086893","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA200807","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3939A"},{"id":4105470,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_violation_id":"251891913","seq_no":"3","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"194086892","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA200807","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39360E"},{"id":4105471,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_violation_id":"251891914","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194086893","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA200807","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"},{"id":4105472,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_violation_id":"251891915","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194086893","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3939A"},{"id":4105473,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_violation_id":"251891916","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4301088,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_unit_id":"194086892","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X TT","insp_unit_license":"9F56167","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X1DJ319685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"},{"id":4301089,"change_date":"2023-03-27 21:40:00","inspection_id":"78197092","insp_unit_id":"194086893","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"2X RECYCLE","insp_unit_license":"4RH4432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5C2BB39B01M003078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"}]},{"id":1452850,"change_date":"2022-10-05 21:41:00","inspection_id":"76803916","dot_number":"3019645","report_state":"CA","report_number":"UCUF002612","insp_date":"2022-10-03 00:00:00","insp_start_time":"1505","insp_end_time":"1530","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-05 21:41: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":"14623725","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2022-10-05 21:41:00","snet_input_date":"2022-10-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-05 21:41:00","insp_carrier_name":"ANDRES TRUCKING LLC","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"616739","created_at":"2025-03-17T18:53:26.000000Z","updated_at":"2025-03-17T18:53:26.000000Z","inspection_violations":[{"id":2288812,"change_date":"2022-10-05 21:41:00","inspection_id":"76803916","insp_violation_id":"248862546","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191296467","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2339246,"change_date":"2022-10-05 21:41:00","inspection_id":"76803916","insp_unit_id":"191296467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3T.TT","insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:01.000000Z","updated_at":"2025-03-17T22:23:01.000000Z"},{"id":2339247,"change_date":"2022-10-05 21:41:00","inspection_id":"76803916","insp_unit_id":"191296468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WECR","insp_unit_company":null,"insp_unit_license":"4TX9684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W91038212W172892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:01.000000Z","updated_at":"2025-03-17T22:23:01.000000Z"}]},{"id":465640,"change_date":"2022-05-23 21:43:00","inspection_id":"75648214","dot_number":"3019645","report_state":"CA","report_number":"NCEB004289","insp_date":"2022-05-18 00:00:00","insp_start_time":"1455","insp_end_time":"1518","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":"2022-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"14439931","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2022-05-23 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-23 21:43:00","insp_carrier_name":"ANDRES CIPRES CABALLERO","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:56.000000Z","updated_at":"2025-03-17T18:35:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":750194,"change_date":"2022-05-23 21:43:00","inspection_id":"75648214","insp_unit_id":"188869704","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"9F56167","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X1DJ319685","insp_unit_decal":"Y","insp_unit_decal_number":"31182289","created_at":"2025-03-17T22:12:49.000000Z","updated_at":"2025-03-17T22:12:49.000000Z"},{"id":750195,"change_date":"2022-05-23 21:43:00","inspection_id":"75648214","insp_unit_id":"188869705","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"END DUMP","insp_unit_license":"4RH4432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5C2BB39B01M003078","insp_unit_decal":"Y","insp_unit_decal_number":"31182990","created_at":"2025-03-17T22:12:49.000000Z","updated_at":"2025-03-17T22:12:49.000000Z"}]},{"id":238664,"change_date":"2022-04-22 21:46:00","inspection_id":"75377578","dot_number":"3019645","report_state":"CA","report_number":"N9ZT003542","insp_date":"2022-04-15 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:46: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":"14397187","transaction_code":"A","transaction_date":"2022-04-15 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2022-04-22 21:46:00","snet_input_date":"2022-04-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-22 21:46:00","insp_carrier_name":"ANDRES CIPRES CABALLERO","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:37.000000Z","updated_at":"2025-03-17T18:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":386973,"change_date":"2022-04-22 21:46:00","inspection_id":"75377578","insp_unit_id":"188304785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"Y","insp_unit_decal_number":"31101095","created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"},{"id":386974,"change_date":"2022-04-22 21:46:00","inspection_id":"75377578","insp_unit_id":"188304786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WECO","insp_unit_company":null,"insp_unit_license":"4TX9684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W91038212W172892","insp_unit_decal":"Y","insp_unit_decal_number":"31101096","created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"}]},{"id":131489,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","dot_number":"3019645","report_state":"CA","report_number":"UELS001885","insp_date":"2022-04-06 00:00:00","insp_start_time":"1205","insp_end_time":"1239","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"W\/B SR-152 @ PALM","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14375790","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03019645","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"ANDRES CIPRES CABALLERO","insp_carrier_street":"3489 SUMMIT WAY","insp_carrier_city":"ANTIOCH","insp_carrier_state":"CA","insp_carrier_zip_code":"94509","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"509144","created_at":"2025-03-17T18:29:50.000000Z","updated_at":"2025-03-17T18:29:50.000000Z","inspection_violations":[{"id":195489,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","insp_violation_id":"245036822","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188048733","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KM34116","created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"},{"id":195490,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","insp_violation_id":"245036823","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188048733","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"},{"id":195491,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","insp_violation_id":"245036824","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188048733","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"},{"id":195492,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","insp_violation_id":"245036825","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188048732","insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KM34115","created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":213183,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","insp_unit_id":"188048732","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G39172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSDJAPR6FH696969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"},{"id":213184,"change_date":"2022-04-07 21:39:00","inspection_id":"75249732","insp_unit_id":"188048733","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WECO","insp_unit_company":null,"insp_unit_license":"4TX9684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W91038212W172892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3019645\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3019645\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3019645\/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\/3019645\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}