{"current_page":1,"data":[{"id":8244172,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","dot_number":"2684082","report_state":"CA","report_number":"UGM6001676","insp_date":"2025-03-27 00:00:00","insp_start_time":"1558","insp_end_time":"1629","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD AREA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GALLO WINERY CDC","shipping_paper_number":"10025012","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-03-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15759409","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2025-03-28 21:42:00","snet_input_date":"2025-03-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-28 21:42:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"298352","created_at":"2025-03-31T10:33:05.000000Z","updated_at":"2025-04-01T10:14:49.000000Z","inspection_violations":[{"id":12943607,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","insp_violation_id":"265329213","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ95383","created_at":"2025-03-31T11:18:44.000000Z","updated_at":"2025-03-31T11:28:20.000000Z","normalized_code":"39216D"},{"id":12943608,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","insp_violation_id":"265329214","seq_no":"2","part_no":"392","part_no_section":"71A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ95383","created_at":"2025-03-31T11:18:44.000000Z","updated_at":"2025-03-31T11:28:20.000000Z","normalized_code":"39271AD"},{"id":12943609,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","insp_violation_id":"265329215","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RJ95383","created_at":"2025-03-31T11:18:44.000000Z","updated_at":"2025-03-31T11:28:20.000000Z","normalized_code":"3958A1HOSP"},{"id":12943610,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","insp_violation_id":"265329216","seq_no":"4","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"206057864","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:18:44.000000Z","updated_at":"2025-03-31T11:28:20.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":13338439,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","insp_unit_id":"206057864","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"9H12938","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X8JD483511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:26:12.000000Z","updated_at":"2025-04-01T10:07:14.000000Z"},{"id":13338440,"change_date":"2025-03-28 21:42:00","inspection_id":"84260746","insp_unit_id":"206057865","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"5326","insp_unit_license":"4AA9125","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C01T080021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:26:12.000000Z","updated_at":"2025-04-01T10:07:14.000000Z"}]},{"id":7721119,"change_date":"2025-01-27 21:40:00","inspection_id":"83710830","dot_number":"2684082","report_state":"CA","report_number":"UCRG000309","insp_date":"2025-01-25 00:00:00","insp_start_time":"1145","insp_end_time":"1206","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":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-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15680030","transaction_code":"A","transaction_date":"2025-01-25 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0298352","created_at":"2025-03-17T20:58:39.000000Z","updated_at":"2025-03-17T20:58:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12459964,"change_date":"2025-01-27 21:40:00","inspection_id":"83710830","insp_unit_id":"205030579","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03\/WHI","insp_unit_license":"9H12938","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X8JD483511","insp_unit_decal":"Y","insp_unit_decal_number":"34779700","created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"}]},{"id":2744629,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","dot_number":"2684082","report_state":"CA","report_number":"NECK000419","insp_date":"2023-04-04 00:00:00","insp_start_time":"1820","insp_end_time":"1845","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ARIZONA BEVERAGES","shipping_paper_number":"660904","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-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"14847263","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"298352","created_at":"2025-03-17T19:17:19.000000Z","updated_at":"2025-03-17T19:17:19.000000Z","inspection_violations":[{"id":4213168,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","insp_violation_id":"252071924","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194251001","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39345B2"},{"id":4213169,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","insp_violation_id":"252071925","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194251002","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW855623","created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39375A3"},{"id":4213170,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","insp_violation_id":"252071926","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194251001","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3963A1"},{"id":4213171,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","insp_violation_id":"252071927","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194251001","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4417971,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","insp_unit_id":"194251001","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"9F64371","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ320940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"},{"id":4417972,"change_date":"2023-04-05 21:41:00","inspection_id":"78281690","insp_unit_id":"194251002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"533","insp_unit_license":"4AA9126","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C41T080054","insp_unit_decal":"Y","insp_unit_decal_number":"32506722","created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"}]},{"id":1856173,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","dot_number":"2684082","report_state":"CA","report_number":"NDE9004189","insp_date":"2022-11-30 00:00:00","insp_start_time":"1647","insp_end_time":"1736","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PACIFIC COAST PRODUCERS","shipping_paper_number":"1727352","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-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14692515","transaction_code":"A","transaction_date":"2022-12-01 00:00:00","upload_date":"2022-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2022-12-01 21:42:00","snet_input_date":"2022-11-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-01 21:42:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"298352","created_at":"2025-03-17T19:00:47.000000Z","updated_at":"2025-03-17T19:00:47.000000Z","inspection_violations":[{"id":2892858,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881600","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"1","insp_unit_id":"192223659","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3929A1"},{"id":2892859,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881601","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"192223660","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39345"},{"id":2892860,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881602","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"192223660","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39345"},{"id":2892861,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881603","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192223659","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3963A1"},{"id":2892862,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881604","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192223660","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA293157","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39311"},{"id":2892863,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881605","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192223660","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA293157","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39375C"},{"id":2892864,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_violation_id":"249881606","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192223659","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":2986999,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_unit_id":"192223659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"9F64371","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ320940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"},{"id":2987000,"change_date":"2022-12-01 21:42:00","inspection_id":"77267408","insp_unit_id":"192223660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"EA5344","insp_unit_license":"4TY9462","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX7L098111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"}]},{"id":401143,"change_date":"2022-05-16 21:44:00","inspection_id":"75571579","dot_number":"2684082","report_state":"CA","report_number":"NDGS005527","insp_date":"2022-05-14 00:00:00","insp_start_time":"0900","insp_end_time":"0925","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-16 21:44: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":"14427293","transaction_code":"A","transaction_date":"2022-05-14 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2022-05-16 21:44:00","snet_input_date":"2022-05-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-16 21:44:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"298352","created_at":"2025-03-17T18:34:44.000000Z","updated_at":"2025-03-17T18:34:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":648157,"change_date":"2022-05-16 21:44:00","inspection_id":"75571579","insp_unit_id":"188711008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X WHT","insp_unit_license":"9F64371","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ320940","insp_unit_decal":"Y","insp_unit_decal_number":"31141163","created_at":"2025-03-17T22:12:10.000000Z","updated_at":"2025-03-17T22:12:10.000000Z"},{"id":648158,"change_date":"2022-05-16 21:44:00","inspection_id":"75571579","insp_unit_id":"188711009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5338","insp_unit_license":"4FY8275","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L952335","insp_unit_decal":"Y","insp_unit_decal_number":"31141164","created_at":"2025-03-17T22:12:10.000000Z","updated_at":"2025-03-17T22:12:10.000000Z"}]},{"id":305522,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","dot_number":"2684082","report_state":"CA","report_number":"NE02001562","insp_date":"2022-04-15 00:00:00","insp_start_time":"1640","insp_end_time":"1719","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ 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":"2022-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"14409879","transaction_code":"A","transaction_date":"2022-04-15 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2022-05-02 21:41:00","snet_input_date":"2022-04-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-02 21:41:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"298352","created_at":"2025-03-17T18:32:55.000000Z","updated_at":"2025-03-17T18:32:55.000000Z","inspection_violations":[{"id":476062,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","insp_violation_id":"245527478","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"188466944","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39345D"},{"id":476063,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","insp_violation_id":"245527479","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188466944","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3939A"},{"id":476064,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","insp_violation_id":"245527480","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188466944","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3963A1"},{"id":476065,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","insp_violation_id":"245527481","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188466944","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":494443,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","insp_unit_id":"188466944","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2\/SILVER3X","insp_unit_license":"9F64371","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ320940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:13.000000Z","updated_at":"2025-03-17T22:11:13.000000Z"},{"id":494444,"change_date":"2022-05-02 21:41:00","inspection_id":"75457670","insp_unit_id":"188466945","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"EA5340\/WHT2","insp_unit_license":"4MK4563","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W97L024050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:13.000000Z","updated_at":"2025-03-17T22:11:13.000000Z"}]},{"id":66786,"change_date":"2022-03-29 21:42:00","inspection_id":"75169874","dot_number":"2684082","report_state":"CA","report_number":"NC20003625","insp_date":"2022-03-28 00:00:00","insp_start_time":"0818","insp_end_time":"0825","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14363132","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02684082","upload_search_indicator":null,"census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"ESEQUIEL RIVERA MARIN","insp_carrier_street":"2649 PEAR TREE DRIVE","insp_carrier_city":"MADERA","insp_carrier_state":"CA","insp_carrier_zip_code":"93637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"298352","created_at":"2025-03-17T18:28:47.000000Z","updated_at":"2025-03-17T18:28:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":108675,"change_date":"2022-03-29 21:42:00","inspection_id":"75169874","insp_unit_id":"187884335","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2\/GRY","insp_unit_license":"9F64371","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ320940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:53.000000Z","updated_at":"2025-03-17T22:08:53.000000Z"},{"id":108676,"change_date":"2022-03-29 21:42:00","inspection_id":"75169874","insp_unit_id":"187884336","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"EA5343\/WHT","insp_unit_license":"4MK4564","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W77L024080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:53.000000Z","updated_at":"2025-03-17T22:08:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2684082\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2684082\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2684082\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2684082\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}