{"current_page":1,"data":[{"id":7973139,"change_date":"2025-02-26 21:42:00","inspection_id":"83975520","dot_number":"3478170","report_state":"CA","report_number":"UEAO005006","insp_date":"2025-02-23 00:00:00","insp_start_time":"1211","insp_end_time":"1224","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15718072","transaction_code":"A","transaction_date":"2025-02-23 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:40.000000Z","updated_at":"2025-03-17T21:03:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12871451,"change_date":"2025-02-26 21:42:00","inspection_id":"83975520","insp_unit_id":"205523718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XRED","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"},{"id":12871452,"change_date":"2025-02-26 21:42:00","inspection_id":"83975520","insp_unit_id":"205523719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2X","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"}]},{"id":7307902,"change_date":"2024-11-30 21:33:00","inspection_id":"83276845","dot_number":"3478170","report_state":"CA","report_number":"UEHJ005039","insp_date":"2024-11-08 00:00:00","insp_start_time":"0200","insp_end_time":"0225","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GHIRINGHELLI FOODS","shipping_paper_number":"14125","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":"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":"15606449","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"570497","created_at":"2025-03-17T20:48:34.000000Z","updated_at":"2025-03-17T20:48:34.000000Z","inspection_violations":[{"id":11425067,"change_date":"2024-11-30 21:33:00","inspection_id":"83276845","insp_violation_id":"263152465","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"204112920","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA235413","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11788528,"change_date":"2024-11-30 21:33:00","inspection_id":"83276845","insp_unit_id":"204112919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","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":11788529,"change_date":"2024-11-30 21:33:00","inspection_id":"83276845","insp_unit_id":"204112920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R16818","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","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":6925799,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","dot_number":"3478170","report_state":"CA","report_number":"NDOG005637","insp_date":"2024-10-08 00:00:00","insp_start_time":"0945","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO CVEF","county_code_state":"CA","county_code":"111","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-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15549871","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"570497","created_at":"2025-03-17T20:40:37.000000Z","updated_at":"2025-03-17T20:40:37.000000Z","inspection_violations":[{"id":10795197,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","insp_violation_id":"262275774","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203343967","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"39345B2"},{"id":10795198,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","insp_violation_id":"262275775","seq_no":"2","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"203343968","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"3929A2"},{"id":10795199,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","insp_violation_id":"262275776","seq_no":"3","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"2","insp_unit_id":"203343968","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"393203B"},{"id":10795200,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","insp_violation_id":"262275777","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"203343968","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":11169817,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","insp_unit_id":"203343967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"},{"id":11169818,"change_date":"2024-10-09 21:42:00","inspection_id":"82871892","insp_unit_id":"203343968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6741432,"change_date":"2024-09-16 21:43:00","inspection_id":"82675529","dot_number":"3478170","report_state":"CA","report_number":"UF73002243","insp_date":"2024-09-08 00:00:00","insp_start_time":"1354","insp_end_time":"1407","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":"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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15523024","transaction_code":"A","transaction_date":"2024-09-08 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-09-16 21:43:00","snet_input_date":"2024-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"570497","created_at":"2025-03-17T20:36:53.000000Z","updated_at":"2025-03-17T20:36:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10870584,"change_date":"2024-09-16 21:43:00","inspection_id":"82675529","insp_unit_id":"202955716","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:37.000000Z","updated_at":"2025-03-17T23:35:37.000000Z"},{"id":10870585,"change_date":"2024-09-16 21:43:00","inspection_id":"82675529","insp_unit_id":"202955717","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:37.000000Z","updated_at":"2025-03-17T23:35:37.000000Z"}]},{"id":6661306,"change_date":"2024-09-05 21:43:00","inspection_id":"82590449","dot_number":"3478170","report_state":"CA","report_number":"UBZU003872","insp_date":"2024-09-04 00:00:00","insp_start_time":"1050","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","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":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15511409","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"570497","created_at":"2025-03-17T20:35:11.000000Z","updated_at":"2025-03-17T20:35:11.000000Z","inspection_violations":[{"id":10365826,"change_date":"2024-09-05 21:43:00","inspection_id":"82590449","insp_violation_id":"261647473","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202788455","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ37204","created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"},{"id":10365827,"change_date":"2024-09-05 21:43:00","inspection_id":"82590449","insp_violation_id":"261647474","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202788455","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"},{"id":10365828,"change_date":"2024-09-05 21:43:00","inspection_id":"82590449","insp_violation_id":"261647475","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10739940,"change_date":"2024-09-05 21:43:00","inspection_id":"82590449","insp_unit_id":"202788455","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"},{"id":10739941,"change_date":"2024-09-05 21:43:00","inspection_id":"82590449","insp_unit_id":"202788456","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6567155,"change_date":"2024-08-26 21:43:00","inspection_id":"82490099","dot_number":"3478170","report_state":"CA","report_number":"UEEE002489","insp_date":"2024-08-23 00:00:00","insp_start_time":"2010","insp_end_time":"2027","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":"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":"2024-08-26 21:43: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":"15496344","transaction_code":"A","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-08-26 21:43:00","snet_input_date":"2024-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-26 21:43:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:10.000000Z","updated_at":"2025-03-17T20:33:10.000000Z","inspection_violations":[{"id":10206133,"change_date":"2024-08-26 21:43:00","inspection_id":"82490099","insp_violation_id":"261418339","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202593084","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ36936","created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3922"},{"id":10206134,"change_date":"2024-08-26 21:43:00","inspection_id":"82490099","insp_violation_id":"261418340","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202593084","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA587917","created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10587421,"change_date":"2024-08-26 21:43:00","inspection_id":"82490099","insp_unit_id":"202593084","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:40.000000Z","updated_at":"2025-03-17T23:32:40.000000Z"},{"id":10587422,"change_date":"2024-08-26 21:43:00","inspection_id":"82490099","insp_unit_id":"202593085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:40.000000Z","updated_at":"2025-03-17T23:32:40.000000Z"}]},{"id":6426828,"change_date":"2024-08-08 21:42:00","inspection_id":"82340545","dot_number":"3478170","report_state":"CA","report_number":"UCOB006106","insp_date":"2024-08-03 00:00:00","insp_start_time":"1013","insp_end_time":"1044","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"2024-08-08 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":"15476539","transaction_code":"A","transaction_date":"2024-08-03 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-08-08 21:42:00","snet_input_date":"2024-08-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:17.000000Z","updated_at":"2025-03-17T20:30:17.000000Z","inspection_violations":[{"id":9979597,"change_date":"2024-08-08 21:42:00","inspection_id":"82340545","insp_violation_id":"261100498","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202309576","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 517860","created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10357762,"change_date":"2024-08-08 21:42:00","inspection_id":"82340545","insp_unit_id":"202309576","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:21.000000Z","updated_at":"2025-03-17T23:30:21.000000Z"},{"id":10357763,"change_date":"2024-08-08 21:42:00","inspection_id":"82340545","insp_unit_id":"202309577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:21.000000Z","updated_at":"2025-03-17T23:30:21.000000Z"}]},{"id":6257007,"change_date":"2024-07-18 21:41:00","inspection_id":"82158742","dot_number":"3478170","report_state":"CA","report_number":"NECL002040","insp_date":"2024-07-17 00:00:00","insp_start_time":"1431","insp_end_time":"1440","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OLIPOP","shipping_paper_number":"27644\/18316","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-18 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":"15447241","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[{"id":9718633,"change_date":"2024-07-18 21:41:00","inspection_id":"82158742","insp_violation_id":"260725781","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201962630","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA206543","created_at":"2025-03-17T21:53:00.000000Z","updated_at":"2025-03-17T21:53:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10081195,"change_date":"2024-07-18 21:41:00","inspection_id":"82158742","insp_unit_id":"201962630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"RED3X","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"},{"id":10081196,"change_date":"2024-07-18 21:41:00","inspection_id":"82158742","insp_unit_id":"201962631","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT2X","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"}]},{"id":5219644,"change_date":"2024-03-05 21:41:00","inspection_id":"81032719","dot_number":"3478170","report_state":"CA","report_number":"UCA2000182","insp_date":"2024-03-04 00:00:00","insp_start_time":"1255","insp_end_time":"1321","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","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":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"15268617","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:49.000000Z","updated_at":"2025-03-17T20:05:49.000000Z","inspection_violations":[{"id":8045305,"change_date":"2024-03-05 21:41:00","inspection_id":"81032719","insp_violation_id":"258221398","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199772087","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KU47077","created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8405145,"change_date":"2024-03-05 21:41:00","inspection_id":"81032719","insp_unit_id":"199772087","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11\/RED","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"},{"id":8405146,"change_date":"2024-03-05 21:41:00","inspection_id":"81032719","insp_unit_id":"199772088","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R16818\/WHT","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"}]},{"id":4905406,"change_date":"2024-01-25 21:44:00","inspection_id":"80689721","dot_number":"3478170","report_state":"CA","report_number":"NEYV000102","insp_date":"2024-01-23 00:00:00","insp_start_time":"0933","insp_end_time":"1004","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15213948","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-01-25 21:44:00","snet_input_date":"2024-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:01.000000Z","updated_at":"2025-03-17T20:00:01.000000Z","inspection_violations":[{"id":7558083,"change_date":"2024-01-25 21:44:00","inspection_id":"80689721","insp_violation_id":"257504530","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199117234","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3922"},{"id":7558084,"change_date":"2024-01-25 21:44:00","inspection_id":"80689721","insp_violation_id":"257504531","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199117234","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7893532,"change_date":"2024-01-25 21:44:00","inspection_id":"80689721","insp_unit_id":"199117234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X RED","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"},{"id":7893533,"change_date":"2024-01-25 21:44:00","inspection_id":"80689721","insp_unit_id":"199117235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2X WHITE","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"}]},{"id":4905446,"change_date":"2024-01-25 21:44:00","inspection_id":"80689761","dot_number":"3478170","report_state":"CA","report_number":"NC7K008149","insp_date":"2024-01-23 00:00:00","insp_start_time":"1341","insp_end_time":"1401","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-25 21:44: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":"15213639","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-01-25 21:44:00","snet_input_date":"2024-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:01.000000Z","updated_at":"2025-03-17T20:00:01.000000Z","inspection_violations":[{"id":7558124,"change_date":"2024-01-25 21:44:00","inspection_id":"80689761","insp_violation_id":"257504571","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199117294","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7893592,"change_date":"2024-01-25 21:44:00","inspection_id":"80689761","insp_unit_id":"199117294","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11\/RED 3X","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"Y","insp_unit_decal_number":"33523425","created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"},{"id":7893593,"change_date":"2024-01-25 21:44:00","inspection_id":"80689761","insp_unit_id":"199117295","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"6818\/RFR 2X","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"}]},{"id":4758589,"change_date":"2024-01-03 21:44:00","inspection_id":"80529159","dot_number":"3478170","report_state":"CA","report_number":"UD4G002685","insp_date":"2024-01-02 00:00:00","insp_start_time":"0939","insp_end_time":"1004","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":"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":"2024-01-03 21:44: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":"15187449","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2024-01-03 21:44:00","snet_input_date":"2024-01-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"432 EL MARGARITA RD","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95993","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"570497","created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[{"id":7343379,"change_date":"2024-01-03 21:44:00","inspection_id":"80529159","insp_violation_id":"257173167","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198800708","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"3922"},{"id":7343380,"change_date":"2024-01-03 21:44:00","inspection_id":"80529159","insp_violation_id":"257173168","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198800709","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA157733","created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7655345,"change_date":"2024-01-03 21:44:00","inspection_id":"80529159","insp_unit_id":"198800708","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:26.000000Z","updated_at":"2025-03-17T23:04:26.000000Z"},{"id":7655346,"change_date":"2024-01-03 21:44:00","inspection_id":"80529159","insp_unit_id":"198800709","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R16818","insp_unit_license":"4UU2227","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:26.000000Z","updated_at":"2025-03-17T23:04:26.000000Z"}]},{"id":3266369,"change_date":"2023-06-12 21:41:00","inspection_id":"78871106","dot_number":"3478170","report_state":"CA","report_number":"NE46002742","insp_date":"2023-06-07 00:00:00","insp_start_time":"0125","insp_end_time":"0145","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AEM FOOD & BEVERAGE INC.","shipping_paper_number":"1766","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-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14939599","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2023-06-12 21:41:00","snet_input_date":"2023-06-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"42 MAIN ST","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95991","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"570497","created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[{"id":5037580,"change_date":"2023-06-12 21:41:00","inspection_id":"78871106","insp_violation_id":"253455664","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:30:24.000000Z","updated_at":"2025-03-17T21:30:24.000000Z","normalized_code":"3922"},{"id":5037581,"change_date":"2023-06-12 21:41:00","inspection_id":"78871106","insp_violation_id":"253455665","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195456147","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:30:24.000000Z","updated_at":"2025-03-17T21:30:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5252824,"change_date":"2023-06-12 21:41:00","inspection_id":"78871106","insp_unit_id":"195456146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"},{"id":5252825,"change_date":"2023-06-12 21:41:00","inspection_id":"78871106","insp_unit_id":"195456147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R16818","insp_unit_license":"4RL6881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"}]},{"id":1208281,"change_date":"2022-09-02 21:39:00","inspection_id":"76520232","dot_number":"3478170","report_state":"CA","report_number":"NEDJ000504","insp_date":"2022-09-02 00:00:00","insp_start_time":"0253","insp_end_time":"0344","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":"SGS","shipping_paper_number":"77845","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14580516","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03478170","upload_search_indicator":null,"census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-09-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"DE LA FUENTE TRANSPORT INC","insp_carrier_street":"42 MAIN ST","insp_carrier_city":"YUBA CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"95991","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"570497","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1916890,"change_date":"2022-09-02 21:39:00","inspection_id":"76520232","insp_violation_id":"248206273","seq_no":"1","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":"VERBAL","created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":1943342,"change_date":"2022-09-02 21:39:00","inspection_id":"76520232","insp_unit_id":"190715260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"YP12544","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56GLGU1844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"},{"id":1943343,"change_date":"2022-09-02 21:39:00","inspection_id":"76520232","insp_unit_id":"190715261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"R16818","insp_unit_license":"4RL6881","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2JL069027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3478170\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3478170\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3478170\/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\/3478170\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}