{"current_page":1,"data":[{"id":12089872,"change_date":"2026-06-04 21:45:00","inspection_id":"88033639","dot_number":"4074551","report_state":"CA","report_number":"UBZ9001656","insp_date":"2026-06-03 00:00:00","insp_start_time":"0630","insp_end_time":"0655","registration_date":null,"region":"PS","ci_status_code":"C","location":"360","location_desc":"CA","county_code_state":"CA","county_code":"097","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"147000","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":"3457938","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY ROAD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:39.000000Z","updated_at":"2026-06-16T09:30:16.000000Z","inspection_violations":[{"id":21039588,"change_date":"2026-06-04 21:45:00","inspection_id":"88033639","insp_violation_id":"274678311","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"1","insp_unit_id":"213899616","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA789253","created_at":"2026-06-07T10:00:25.000000Z","updated_at":"2026-06-16T09:44:09.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":21008229,"change_date":"2026-06-04 21:45:00","inspection_id":"88033639","insp_unit_id":"213899616","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:35.000000Z","updated_at":"2026-06-16T09:01:27.000000Z"},{"id":21008230,"change_date":"2026-06-04 21:45:00","inspection_id":"88033639","insp_unit_id":"213899617","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"4MV9327","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440VH5S1B38541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:35.000000Z","updated_at":"2026-06-16T09:01:27.000000Z"}]},{"id":10864735,"change_date":"2026-01-26 21:37:00","inspection_id":"86894443","dot_number":"4074551","report_state":"CA","report_number":"UDM7004734","insp_date":"2026-01-26 00:00:00","insp_start_time":"0810","insp_end_time":"0832","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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-01-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"147000","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":"16145156","transaction_code":"A","transaction_date":"2026-01-26 00:00:00","upload_date":"2026-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2026-01-26 21:37:00","snet_input_date":"2026-01-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-26 21:37:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY ROAD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-29T10:36:10.000000Z","updated_at":"2026-02-06T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18256733,"change_date":"2026-01-26 21:37:00","inspection_id":"86894443","insp_unit_id":"211300251","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-29T10:07:42.000000Z","updated_at":"2026-02-06T10:03:03.000000Z"},{"id":18256734,"change_date":"2026-01-26 21:37:00","inspection_id":"86894443","insp_unit_id":"211300252","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"4WV9327","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440VH5S1B38541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-29T10:07:42.000000Z","updated_at":"2026-02-06T10:03:03.000000Z"}]},{"id":10442210,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","dot_number":"4074551","report_state":"CA","report_number":"NDMK006737","insp_date":"2025-12-11 00:00:00","insp_start_time":"0855","insp_end_time":"0926","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":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":"2025-12-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"147000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16096075","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2025-12-15 21:40:00","snet_input_date":"2025-12-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-15 21:40:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY ROAD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:48.000000Z","updated_at":"2025-12-26T10:31:22.000000Z","inspection_violations":[{"id":17512956,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701463","seq_no":"1","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"210622589","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC12259","created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"39021TCMC"},{"id":17512957,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701464","seq_no":"2","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"210622589","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"3963A1BALAC"},{"id":17512958,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701465","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"210622590","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"39347E"},{"id":17512959,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701466","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"210622590","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"39347E"},{"id":17512960,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701467","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"210622590","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"39347E"},{"id":17512961,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701468","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"210622590","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"3963A1BOS"},{"id":17512962,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_violation_id":"270701469","seq_no":"7","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"210622590","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:17.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":17469254,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_unit_id":"210622589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"Y","insp_unit_decal_number":"35618533","created_at":"2025-12-18T10:00:40.000000Z","updated_at":"2025-12-26T10:01:32.000000Z"},{"id":17469255,"change_date":"2025-12-15 21:40:00","inspection_id":"86574363","insp_unit_id":"210622590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"4WV9327","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440VH5S1B38541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:40.000000Z","updated_at":"2025-12-26T10:01:32.000000Z"}]},{"id":10232617,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","dot_number":"4074551","report_state":"CA","report_number":"UED8001829","insp_date":"2025-11-18 00:00:00","insp_start_time":"0413","insp_end_time":"0437","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"WB SR-4 WO SOLANO","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GALLO WINERY","shipping_paper_number":"434204","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16062286","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2025-11-18 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-18 21:39:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY ROAD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"630185","created_at":"2025-11-21T10:31:56.000000Z","updated_at":"2025-11-23T10:31:13.000000Z","inspection_violations":[{"id":17011920,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","insp_violation_id":"270047868","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"210108692","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:33:07.000000Z","updated_at":"2025-11-23T10:31:45.000000Z","normalized_code":"39021TB1MC"},{"id":17011921,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","insp_violation_id":"270047869","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"210108692","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:33:07.000000Z","updated_at":"2025-11-23T10:31:45.000000Z","normalized_code":"39021TB2DOT"},{"id":17011922,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","insp_violation_id":"270047870","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"210108692","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:33:07.000000Z","updated_at":"2025-11-23T10:31:45.000000Z","normalized_code":"3922SLLSIV"},{"id":17011923,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","insp_violation_id":"270047871","seq_no":"4","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"210108692","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:33:07.000000Z","updated_at":"2025-11-23T10:31:45.000000Z","normalized_code":"39021TELCMVINFO"}],"inspection_per_units":[{"id":17052384,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","insp_unit_id":"210108692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03","insp_unit_license":"9G91172","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGHDVXLDLJ8815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:02:02.000000Z","updated_at":"2025-11-23T10:01:30.000000Z"},{"id":17052385,"change_date":"2025-11-18 21:39:00","inspection_id":"86354879","insp_unit_id":"210108693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"428A","insp_unit_license":"4RS9425","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534J3407402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:02:02.000000Z","updated_at":"2025-11-23T10:01:30.000000Z"}]},{"id":9773530,"change_date":"2025-09-24 21:42:00","inspection_id":"85871523","dot_number":"4074551","report_state":"CA","report_number":"UD1D001290","insp_date":"2025-09-17 00:00:00","insp_start_time":"1130","insp_end_time":"1230","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-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"149100","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":"15993603","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY ROAD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"630185","created_at":"2025-09-26T10:01:19.000000Z","updated_at":"2025-09-28T10:00:53.000000Z","inspection_violations":[{"id":16065502,"change_date":"2025-09-24 21:42:00","inspection_id":"85871523","insp_violation_id":"268908810","seq_no":"1","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"209133074","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC11801","created_at":"2025-09-27T10:17:14.000000Z","updated_at":"2025-09-28T10:16:30.000000Z","normalized_code":"39021TCMC"},{"id":16065503,"change_date":"2025-09-24 21:42:00","inspection_id":"85871523","insp_violation_id":"268908811","seq_no":"2","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"209133074","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:14.000000Z","updated_at":"2025-09-28T10:16:30.000000Z","normalized_code":"39021TCMC"}],"inspection_per_units":[{"id":16191519,"change_date":"2025-09-24 21:42:00","inspection_id":"85871523","insp_unit_id":"209133074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"211\/BLU","insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:26.000000Z","updated_at":"2025-09-29T09:46:25.000000Z"},{"id":16191520,"change_date":"2025-09-24 21:42:00","inspection_id":"85871523","insp_unit_id":"209133075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":"BLK FB","insp_unit_license":"4WV9327","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440VH5S1B38541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:26.000000Z","updated_at":"2025-09-29T09:46:25.000000Z"}]},{"id":7262990,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","dot_number":"4074551","report_state":"CA","report_number":"NF50000699","insp_date":"2024-11-15 00:00:00","insp_start_time":"1007","insp_end_time":"1039","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":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-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15603230","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY RD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"630185","created_at":"2025-03-17T20:47:41.000000Z","updated_at":"2025-03-17T20:47:41.000000Z","inspection_violations":[{"id":11354908,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052407","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"204019475","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3963A1BALAC"},{"id":11354909,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052408","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"204019476","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3963A1BOS"},{"id":11354910,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052409","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"204019476","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39353B"},{"id":11354911,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052410","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204019476","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39347E"},{"id":11354912,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052411","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204019476","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39347E"},{"id":11354913,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052412","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204019476","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39347E"},{"id":11354914,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_violation_id":"263052413","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"204019476","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11715247,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_unit_id":"204019475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"},{"id":11715248,"change_date":"2024-11-22 21:41:00","inspection_id":"83229347","insp_unit_id":"204019476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANDL","insp_unit_company":null,"insp_unit_license":"4JJ7692","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH435UH181B16837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"}]},{"id":6372867,"change_date":"2024-08-01 21:42:00","inspection_id":"82282730","dot_number":"4074551","report_state":"CA","report_number":"UE5M003818","insp_date":"2024-07-31 00:00:00","insp_start_time":"0730","insp_end_time":"0753","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-01 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":"15467284","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2024-08-01 21:42:00","snet_input_date":"2024-07-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-01 21:42:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY RD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"630185","created_at":"2025-03-17T20:29:07.000000Z","updated_at":"2025-03-17T20:29:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10269679,"change_date":"2024-08-01 21:42:00","inspection_id":"82282730","insp_unit_id":"202200101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"},{"id":10269680,"change_date":"2024-08-01 21:42:00","inspection_id":"82282730","insp_unit_id":"202200102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"433855Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D9LL185300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":5229428,"change_date":"2024-03-06 21:41:00","inspection_id":"81043363","dot_number":"4074551","report_state":"CA","report_number":"UF44004757","insp_date":"2024-03-06 00:00:00","insp_start_time":"1159","insp_end_time":"1208","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"15271104","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04074551","upload_search_indicator":null,"census_search_date":"2024-03-06 21:41:00","snet_input_date":"2024-03-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-06 21:41:00","insp_carrier_name":"ESPEJEL TRANSPORTATION LLC","insp_carrier_street":"10668 OAK VALLEY RD","insp_carrier_city":"ANGELS CAMP","insp_carrier_state":"CA","insp_carrier_zip_code":"95222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"630185","created_at":"2025-03-17T20:06:13.000000Z","updated_at":"2025-03-17T20:06:13.000000Z","inspection_violations":[{"id":8062770,"change_date":"2024-03-06 21:41:00","inspection_id":"81043363","insp_violation_id":"258249748","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199794007","insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MJ45994","created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8420932,"change_date":"2024-03-06 21:41:00","inspection_id":"81043363","insp_unit_id":"199794006","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G24387","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD198483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"},{"id":8420933,"change_date":"2024-03-06 21:41:00","inspection_id":"81043363","insp_unit_id":"199794007","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"423A","insp_unit_license":"4FS1887","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06256K274601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4074551\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4074551\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4074551\/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\/4074551\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}