{"current_page":1,"data":[{"id":11211478,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","dot_number":"1872800","report_state":"CA","report_number":"UFJ3003514","insp_date":"2026-02-23 00:00:00","insp_start_time":"0852","insp_end_time":"0927","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"VISALIA AREA","county_code_state":"CA","county_code":"107","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16180949","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2026-02-23 21:39:00","snet_input_date":"2026-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-23 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"154 KAISER LANE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"250821","created_at":"2026-02-26T10:37:05.000000Z","updated_at":"2026-03-06T10:31:26.000000Z","inspection_violations":[{"id":18800816,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_violation_id":"271975587","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"211780284","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"3939ALSLI"},{"id":18800817,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_violation_id":"271975588","seq_no":"3","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"211780283","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"39355D1B"},{"id":18800818,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_violation_id":"271975589","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"211780284","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"3922SLLEQP"},{"id":18800819,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_violation_id":"271975590","seq_no":"5","part_no":"393","part_no_section":"60E","insp_viol_unit":"1","insp_unit_id":"211780283","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"39360E"},{"id":18800820,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_violation_id":"271975591","seq_no":"6","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":null,"created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"3958A1HOSP"},{"id":18800815,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_violation_id":"271975586","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"211780284","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"SP88612","created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":19144763,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_unit_id":"211780283","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"9G27090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDV8JLJP8125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:20.000000Z","updated_at":"2026-03-06T10:04:25.000000Z"},{"id":19144764,"change_date":"2026-02-23 21:39:00","inspection_id":"87122719","insp_unit_id":"211780284","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4DR8596","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJF482WXWL415677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:20.000000Z","updated_at":"2026-03-06T10:04:25.000000Z"}]},{"id":10325335,"change_date":"2025-12-01 21:40:00","inspection_id":"86452139","dot_number":"1872800","report_state":"CA","report_number":"UDCP000306","insp_date":"2025-11-28 00:00:00","insp_start_time":"1054","insp_end_time":"1108","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":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-12-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"16074863","transaction_code":"A","transaction_date":"2025-11-28 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2025-12-01 21:40:00","snet_input_date":"2025-11-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"154 KAISER LANE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:47.000000Z","updated_at":"2025-12-05T10:31:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17243274,"change_date":"2025-12-01 21:40:00","inspection_id":"86452139","insp_unit_id":"210344030","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"RED 5","insp_unit_license":"9G06294","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X5FD267088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:49.000000Z","updated_at":"2025-12-05T10:02:26.000000Z"},{"id":17243275,"change_date":"2025-12-01 21:40:00","inspection_id":"86452139","insp_unit_id":"210344031","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"90","insp_unit_license":"4HZ3003","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PT01ADH4W9004334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:49.000000Z","updated_at":"2025-12-05T10:02:26.000000Z"}]},{"id":9657541,"change_date":"2025-09-12 21:50:00","inspection_id":"85740514","dot_number":"1872800","report_state":"CA","report_number":"UGM6002265","insp_date":"2025-09-09 00:00:00","insp_start_time":"2001","insp_end_time":"2034","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"S\/B SR-99 OFFRAMP \/ SR-119","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-09-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15974506","transaction_code":"C","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2025-09-10 21:41:00","snet_input_date":"2025-09-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-10 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"154 KAISER LANE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"250821","created_at":"2025-09-13T10:48:05.000000Z","updated_at":"2025-09-16T10:48:25.000000Z","inspection_violations":[{"id":15850885,"change_date":"2025-09-12 21:50:00","inspection_id":"85740514","insp_violation_id":"268665261","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208924169","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD26910","created_at":"2025-09-14T11:58:11.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"3922SLLSR"},{"id":15850886,"change_date":"2025-09-12 21:50:00","inspection_id":"85740514","insp_violation_id":"268665262","seq_no":"2","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"208924169","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:11.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"39311BCSRIGRR"},{"id":15850887,"change_date":"2025-09-12 21:50:00","inspection_id":"85740514","insp_violation_id":"268665263","seq_no":"3","part_no":"391","part_no_section":"11B4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"SD26909","created_at":"2025-09-14T11:58:11.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":15998063,"change_date":"2025-09-12 21:50:00","inspection_id":"85740514","insp_unit_id":"208924168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"9F40805","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV9BSAW9714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:01.000000Z","updated_at":"2025-09-16T09:56:20.000000Z"},{"id":15998064,"change_date":"2025-09-12 21:50:00","inspection_id":"85740514","insp_unit_id":"208924169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"93590","insp_unit_license":"4MS8562","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W2YL712232","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:01.000000Z","updated_at":"2025-09-16T09:56:20.000000Z"}]},{"id":9227775,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","dot_number":"1872800","report_state":"CA","report_number":"NCNK009104","insp_date":"2025-07-22 00:00:00","insp_start_time":"1017","insp_end_time":"1200","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":"A & T HARVESTING AND TRUCKING","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-23 21:42: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":"15910434","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"154 KAISER LANE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"250821","created_at":"2025-07-27T10:41:39.000000Z","updated_at":"2025-07-27T10:41:39.000000Z","inspection_violations":[{"id":14935769,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607944","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208040935","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA251047","created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"3963A1BOS"},{"id":14935770,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607945","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208040935","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"39347E"},{"id":14935771,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607946","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208040935","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"39347E"},{"id":14935772,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607947","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"208040935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"39353BB"},{"id":14935773,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607948","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208040935","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK91555","created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"3922SLLSR"},{"id":14935774,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607949","seq_no":"6","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208040935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"39355EB"},{"id":14935775,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_violation_id":"267607950","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208040934","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK91555","created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15182437,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_unit_id":"208040934","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/4","insp_unit_license":"9G86670","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD51GLHT1287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:32.000000Z","updated_at":"2025-07-27T09:46:17.000000Z"},{"id":15182438,"change_date":"2025-07-23 21:42:00","inspection_id":"85298489","insp_unit_id":"208040935","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/R87","insp_unit_license":"4RH4534","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25324U125242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:32.000000Z","updated_at":"2025-07-27T09:46:17.000000Z"}]},{"id":8749422,"change_date":"2025-05-27 21:39:00","inspection_id":"84793106","dot_number":"1872800","report_state":"CA","report_number":"UFG0001482","insp_date":"2025-05-24 00:00:00","insp_start_time":"1110","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"TULARE\/TIPTON, CA","county_code_state":"CA","county_code":"107","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUN PACIFIC HARVESTING","shipping_paper_number":"391457","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-05-27 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":"15836515","transaction_code":"A","transaction_date":"2025-05-24 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"154 KAISER LANE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:40.000000Z","updated_at":"2025-05-31T10:01:15.000000Z","inspection_violations":[{"id":13966572,"change_date":"2025-05-27 21:39:00","inspection_id":"84793106","insp_violation_id":"266500740","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RW62571","created_at":"2025-05-30T10:16:01.000000Z","updated_at":"2025-05-31T10:18:14.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":14306440,"change_date":"2025-05-27 21:39:00","inspection_id":"84793106","insp_unit_id":"207088948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"9F11098","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXDB9X78D755261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:40.000000Z","updated_at":"2025-05-31T09:47:51.000000Z"},{"id":14306441,"change_date":"2025-05-27 21:39:00","inspection_id":"84793106","insp_unit_id":"207088949","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4DS3152","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24853A997903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:40.000000Z","updated_at":"2025-05-31T09:47:51.000000Z"}]},{"id":8197836,"change_date":"2025-03-25 12:44:00","inspection_id":"84211980","dot_number":"1872800","report_state":"CA","report_number":"UGCY000084","insp_date":"2025-03-24 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"MADERA AREA\/ AVE 21 1\/2","county_code_state":"CA","county_code":"039","insp_level_id":"1","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":"Y","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-03-25 12:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15752609","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2025-03-25 12:44:00","snet_input_date":"2025-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-25 12:44:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"154 KAISER LANE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93307","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:38.000000Z","updated_at":"2025-03-29T10:18:40.000000Z","inspection_violations":[{"id":12854147,"change_date":"2025-03-25 12:44:00","inspection_id":"84211980","insp_violation_id":"265225614","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205964757","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK72497","created_at":"2025-03-28T10:28:45.000000Z","updated_at":"2025-03-28T10:43:48.000000Z","normalized_code":"3922SLLSR"},{"id":12854148,"change_date":"2025-03-25 12:44:00","inspection_id":"84211980","insp_violation_id":"265225615","seq_no":"2","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":"VERBAL","created_at":"2025-03-28T10:28:45.000000Z","updated_at":"2025-03-28T10:43:48.000000Z","normalized_code":"3958A1HOSP"},{"id":12854149,"change_date":"2025-03-25 12:44:00","inspection_id":"84211980","insp_violation_id":"265225616","seq_no":"3","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"1","insp_unit_id":"205964757","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:28:45.000000Z","updated_at":"2025-03-28T10:43:48.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":13253675,"change_date":"2025-03-25 12:44:00","inspection_id":"84211980","insp_unit_id":"205964757","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"UTIL","insp_unit_company":"WHI\/SIL\/REF","insp_unit_license":"4UD5177","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25304U239904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:01:18.000000Z","updated_at":"2025-03-29T09:52:56.000000Z"},{"id":13253676,"change_date":"2025-03-25 12:44:00","inspection_id":"84211980","insp_unit_id":"205964758","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"PTRB","insp_unit_company":"GRY","insp_unit_license":"9F11098","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXDB9X78D755261","insp_unit_decal":"Y","insp_unit_decal_number":"34779108","created_at":"2025-03-28T10:01:18.000000Z","updated_at":"2025-03-29T09:52:56.000000Z"}]},{"id":7417001,"change_date":"2024-12-13 21:41:00","inspection_id":"83391518","dot_number":"1872800","report_state":"CA","report_number":"NETF000405","insp_date":"2024-12-13 00:00:00","insp_start_time":"0926","insp_end_time":"0957","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":"DESTINY PACKAGING","shipping_paper_number":"128543","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118410","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":"15629081","transaction_code":"A","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-12-13 21:41:00","snet_input_date":"2024-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-13 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T20:50:48.000000Z","updated_at":"2025-03-17T20:50:48.000000Z","inspection_violations":[{"id":11590570,"change_date":"2024-12-13 21:41:00","inspection_id":"83391518","insp_violation_id":"263467706","seq_no":"1","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"204385788","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39311A1LSML"},{"id":11590571,"change_date":"2024-12-13 21:41:00","inspection_id":"83391518","insp_violation_id":"263467707","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"204385787","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":11965484,"change_date":"2024-12-13 21:41:00","inspection_id":"83391518","insp_unit_id":"204385787","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5","insp_unit_license":"9G06294","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X5FD267088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:06.000000Z","updated_at":"2025-03-17T23:47:06.000000Z"},{"id":11965485,"change_date":"2024-12-13 21:41:00","inspection_id":"83391518","insp_unit_id":"204385788","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"54011","insp_unit_license":"4EJ4239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5329SS942111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:06.000000Z","updated_at":"2025-03-17T23:47:06.000000Z"}]},{"id":6567291,"change_date":"2024-08-26 21:43:00","inspection_id":"82490238","dot_number":"1872800","report_state":"CA","report_number":"UFEK004161","insp_date":"2024-08-24 00:00:00","insp_start_time":"1230","insp_end_time":"1242","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15496645","transaction_code":"A","transaction_date":"2024-08-24 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-08-26 21:43:00","snet_input_date":"2024-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-26 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","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":10206289,"change_date":"2024-08-26 21:43:00","inspection_id":"82490238","insp_violation_id":"261418526","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":10587634,"change_date":"2024-08-26 21:43:00","inspection_id":"82490238","insp_unit_id":"202593310","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"RED-05","insp_unit_license":"9G06294","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X5FD267088","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":6251792,"change_date":"2024-07-18 21:41:00","inspection_id":"82153369","dot_number":"1872800","report_state":"CA","report_number":"N8MC008714","insp_date":"2024-07-15 00:00:00","insp_start_time":"1011","insp_end_time":"1051","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"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":"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":"15442289","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:38.000000Z","updated_at":"2025-03-17T20:26:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10073346,"change_date":"2024-07-18 21:41:00","inspection_id":"82153369","insp_unit_id":"201954198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11\/WHT","insp_unit_license":"9G16366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV6FSGT2872","insp_unit_decal":"Y","insp_unit_decal_number":"34197047","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"},{"id":10073347,"change_date":"2024-07-18 21:41:00","inspection_id":"82153369","insp_unit_id":"201954199","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"FB","insp_unit_license":"4MP2601","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2486XA802705","insp_unit_decal":"Y","insp_unit_decal_number":"34197048","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":5441534,"change_date":"2024-04-04 21:43:00","inspection_id":"81274923","dot_number":"1872800","report_state":"CA","report_number":"UFGN002964","insp_date":"2024-04-02 00:00:00","insp_start_time":"1103","insp_end_time":"1141","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":"DESTINY PACKAGING","shipping_paper_number":"118521","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15303937","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-04-04 21:43:00","snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:39.000000Z","updated_at":"2025-03-17T20:10:39.000000Z","inspection_violations":[{"id":8399938,"change_date":"2024-04-04 21:43:00","inspection_id":"81274923","insp_violation_id":"258761137","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:46:38.000000Z","updated_at":"2025-03-17T21:46:38.000000Z","normalized_code":"3922"},{"id":8399939,"change_date":"2024-04-04 21:43:00","inspection_id":"81274923","insp_violation_id":"258761138","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200250317","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"00NY0028S","created_at":"2025-03-17T21:46:38.000000Z","updated_at":"2025-03-17T21:46:38.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8765249,"change_date":"2024-04-04 21:43:00","inspection_id":"81274923","insp_unit_id":"200250317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H01127","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR3CSBJ9871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"},{"id":8765250,"change_date":"2024-04-04 21:43:00","inspection_id":"81274923","insp_unit_id":"200250318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4RH4571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25362U744651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"}]},{"id":5363067,"change_date":"2024-03-25 21:41:00","inspection_id":"81189380","dot_number":"1872800","report_state":"CA","report_number":"UGM6000301","insp_date":"2024-03-23 00:00:00","insp_start_time":"1415","insp_end_time":"1434","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2024-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15292927","transaction_code":"A","transaction_date":"2024-03-23 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-03-25 21:41:00","snet_input_date":"2024-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T20:09:01.000000Z","updated_at":"2025-03-17T20:09:01.000000Z","inspection_violations":[{"id":8277057,"change_date":"2024-03-25 21:41:00","inspection_id":"81189380","insp_violation_id":"258571351","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200076869","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3922"},{"id":8277058,"change_date":"2024-03-25 21:41:00","inspection_id":"81189380","insp_violation_id":"258571352","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200076870","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39311"},{"id":8277059,"change_date":"2024-03-25 21:41:00","inspection_id":"81189380","insp_violation_id":"258571353","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200076870","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":8637262,"change_date":"2024-03-25 21:41:00","inspection_id":"81189380","insp_unit_id":"200076869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"17","insp_unit_license":"9F57236","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR3CSBJ9871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"},{"id":8637263,"change_date":"2024-03-25 21:41:00","inspection_id":"81189380","insp_unit_id":"200076870","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R-88","insp_unit_license":"4RH4571","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25362U744651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"}]},{"id":5161387,"change_date":"2024-02-28 21:43:00","inspection_id":"80969413","dot_number":"1872800","report_state":"CA","report_number":"NCNO001838","insp_date":"2024-01-29 00:00:00","insp_start_time":"0758","insp_end_time":"0850","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"137350","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":"15256626","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T20:04:55.000000Z","updated_at":"2025-03-17T20:04:55.000000Z","inspection_violations":[{"id":7958922,"change_date":"2024-02-28 21:43:00","inspection_id":"80969413","insp_violation_id":"258098964","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199654798","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8310133,"change_date":"2024-02-28 21:43:00","inspection_id":"80969413","insp_unit_id":"199654798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5","insp_unit_license":"9G06294","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X5FD267088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"},{"id":8310134,"change_date":"2024-02-28 21:43:00","inspection_id":"80969413","insp_unit_id":"199654799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"9667","insp_unit_license":"4NM9667","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WWGGB6B41N606130","insp_unit_decal":"Y","insp_unit_decal_number":"33530969","created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"}]},{"id":5161388,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","dot_number":"1872800","report_state":"CA","report_number":"NCNO001839","insp_date":"2024-01-29 00:00:00","insp_start_time":"0855","insp_end_time":"0943","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15255770","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T20:04:55.000000Z","updated_at":"2025-03-17T20:04:55.000000Z","inspection_violations":[{"id":7958923,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","insp_violation_id":"258098965","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199654800","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39347E"},{"id":7958924,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","insp_violation_id":"258098966","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199654800","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39353B"},{"id":7958925,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","insp_violation_id":"258098967","seq_no":"3","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"199654800","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39381"},{"id":7958926,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","insp_violation_id":"258098968","seq_no":"4","part_no":"396","part_no_section":"5(a)","insp_viol_unit":"2","insp_unit_id":"199654801","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3965A"}],"inspection_per_units":[{"id":8310135,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","insp_unit_id":"199654800","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"16","insp_unit_license":"9G36411","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X7FD267089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"},{"id":8310136,"change_date":"2024-02-28 21:43:00","inspection_id":"80969414","insp_unit_id":"199654801","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R86","insp_unit_license":"4SA6400","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25336U698704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"}]},{"id":5161389,"change_date":"2024-02-28 21:43:00","inspection_id":"80969415","dot_number":"1872800","report_state":"CA","report_number":"NCNO001840","insp_date":"2024-01-29 00:00:00","insp_start_time":"0952","insp_end_time":"1040","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43: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":"15255157","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T20:04:55.000000Z","updated_at":"2025-03-17T20:04:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8310137,"change_date":"2024-02-28 21:43:00","inspection_id":"80969415","insp_unit_id":"199654802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"9F43927","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV1ELFM6313","insp_unit_decal":"Y","insp_unit_decal_number":"33530970","created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"},{"id":8310138,"change_date":"2024-02-28 21:43:00","inspection_id":"80969415","insp_unit_id":"199654803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R-94","insp_unit_license":"4KM1807","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96241W010520","insp_unit_decal":"Y","insp_unit_decal_number":"33530971","created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"}]},{"id":5161390,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","dot_number":"1872800","report_state":"CA","report_number":"NCNO001841","insp_date":"2024-01-29 00:00:00","insp_start_time":"1045","insp_end_time":"1130","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"111000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15257240","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T20:04:55.000000Z","updated_at":"2025-03-17T20:04:55.000000Z","inspection_violations":[{"id":7958927,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_violation_id":"258098969","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199654804","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39345B2"},{"id":7958928,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_violation_id":"258098970","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199654804","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3922"},{"id":7958929,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_violation_id":"258098971","seq_no":"3","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"199654804","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393205A"},{"id":7958930,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_violation_id":"258098972","seq_no":"4","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"199654804","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393209D"},{"id":7958931,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_violation_id":"258098973","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199654805","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8310139,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_unit_id":"199654804","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"9F41552","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV5BSAX9334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"},{"id":8310140,"change_date":"2024-02-28 21:43:00","inspection_id":"80969416","insp_unit_id":"199654805","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4817","insp_unit_license":"4AE3857","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XSW029702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:19.000000Z","updated_at":"2025-03-17T23:10:19.000000Z"}]},{"id":4749561,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","dot_number":"1872800","report_state":"CA","report_number":"NE46003432","insp_date":"2023-12-29 00:00:00","insp_start_time":"0031","insp_end_time":"0115","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":"WONDERFUL PISTACHIOS","shipping_paper_number":"4864115","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-02 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"15185180","transaction_code":"A","transaction_date":"2023-12-29 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2024-01-02 21:44:00","snet_input_date":"2023-12-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-02 21:44:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T19:56:53.000000Z","updated_at":"2025-03-17T19:56:53.000000Z","inspection_violations":[{"id":7330568,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","insp_violation_id":"257150871","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198776240","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KW76272","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39375A3"},{"id":7330569,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","insp_violation_id":"257150872","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198776240","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3963A1"},{"id":7330570,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","insp_violation_id":"257150873","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198776240","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KW76272","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3963A1"},{"id":7330571,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","insp_violation_id":"257150874","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198776240","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7640514,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","insp_unit_id":"198776240","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"9F41552","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV5BSAX9334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:19.000000Z","updated_at":"2025-03-17T23:04:19.000000Z"},{"id":7640515,"change_date":"2024-01-02 21:44:00","inspection_id":"80519314","insp_unit_id":"198776241","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"54011","insp_unit_license":"4EJ4239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A5329SS942111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:19.000000Z","updated_at":"2025-03-17T23:04:19.000000Z"}]},{"id":4638327,"change_date":"2023-12-14 21:44:00","inspection_id":"80397921","dot_number":"1872800","report_state":"CA","report_number":"NDLY007159","insp_date":"2023-12-12 00:00:00","insp_start_time":"2124","insp_end_time":"2148","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-14 21:44: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":"15168014","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2023-12-14 21:44:00","snet_input_date":"2023-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-14 21:44:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T19:54:36.000000Z","updated_at":"2025-03-17T19:54:36.000000Z","inspection_violations":[{"id":7172731,"change_date":"2023-12-14 21:44:00","inspection_id":"80397921","insp_violation_id":"256907104","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"198523661","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA247613","created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7460316,"change_date":"2023-12-14 21:44:00","inspection_id":"80397921","insp_unit_id":"198523660","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8 \/BLUE","insp_unit_license":"9F43927","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV1ELFM6313","insp_unit_decal":"Y","insp_unit_decal_number":"33229609","created_at":"2025-03-17T23:02:44.000000Z","updated_at":"2025-03-17T23:02:44.000000Z"},{"id":7460317,"change_date":"2023-12-14 21:44:00","inspection_id":"80397921","insp_unit_id":"198523661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R-94 \/WHT","insp_unit_license":"4KM1807","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96241W010520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:44.000000Z","updated_at":"2025-03-17T23:02:44.000000Z"}]},{"id":4336562,"change_date":"2023-11-01 21:44:00","inspection_id":"80065571","dot_number":"1872800","report_state":"CA","report_number":"ND6B004911","insp_date":"2023-10-31 00:00:00","insp_start_time":"0954","insp_end_time":"1042","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAUSER PACKAGING","shipping_paper_number":"100436","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-11-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15119100","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2023-11-01 21:44:00","snet_input_date":"2023-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-01 21:44:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"250821","created_at":"2025-03-17T19:48:46.000000Z","updated_at":"2025-03-17T19:48:46.000000Z","inspection_violations":[{"id":6708613,"change_date":"2023-11-01 21:44:00","inspection_id":"80065571","insp_violation_id":"256175213","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197866145","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6708614,"change_date":"2023-11-01 21:44:00","inspection_id":"80065571","insp_violation_id":"256175214","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197866145","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6708615,"change_date":"2023-11-01 21:44:00","inspection_id":"80065571","insp_violation_id":"256175215","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197866145","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6974270,"change_date":"2023-11-01 21:44:00","inspection_id":"80065571","insp_unit_id":"197866144","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"13","insp_unit_license":"9G81835","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGHDV4JSKA5737","insp_unit_decal":"Y","insp_unit_decal_number":"33281989","created_at":"2025-03-17T22:58:32.000000Z","updated_at":"2025-03-17T22:58:32.000000Z"},{"id":6974271,"change_date":"2023-11-01 21:44:00","inspection_id":"80065571","insp_unit_id":"197866145","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"G1","insp_unit_license":"4NG4210","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0629VB080006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:32.000000Z","updated_at":"2025-03-17T22:58:32.000000Z"}]},{"id":3986969,"change_date":"2023-09-15 21:41:00","inspection_id":"79678301","dot_number":"1872800","report_state":"CA","report_number":"UBVF003241","insp_date":"2023-09-12 00:00:00","insp_start_time":"0643","insp_end_time":"0702","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":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15062880","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2023-09-15 21:41:00","snet_input_date":"2023-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-15 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[{"id":6167339,"change_date":"2023-09-15 21:41:00","inspection_id":"79678301","insp_violation_id":"255307046","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197087345","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA247526","created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6410885,"change_date":"2023-09-15 21:41:00","inspection_id":"79678301","insp_unit_id":"197087345","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10 WHT","insp_unit_license":"9F53616","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDV1CSBN3109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:50.000000Z","updated_at":"2025-03-17T22:53:50.000000Z"},{"id":6410886,"change_date":"2023-09-15 21:41:00","inspection_id":"79678301","insp_unit_id":"197087346","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT R95","insp_unit_license":"4NG2438","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV482WX1L734677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:50.000000Z","updated_at":"2025-03-17T22:53:50.000000Z"}]},{"id":2341009,"change_date":"2023-02-09 21:40:00","inspection_id":"77821469","dot_number":"1872800","report_state":"CA","report_number":"UC5R001744","insp_date":"2023-02-07 00:00:00","insp_start_time":"0655","insp_end_time":"0710","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":"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":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"14777569","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2023-02-09 21:40:00","snet_input_date":"2023-02-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:55.000000Z","updated_at":"2025-03-17T19:09:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3767110,"change_date":"2023-02-09 21:40:00","inspection_id":"77821469","insp_unit_id":"193328624","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#9\/BLU","insp_unit_license":"9F43867","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV8ELFM6261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"},{"id":3767111,"change_date":"2023-02-09 21:40:00","inspection_id":"77821469","insp_unit_id":"193328625","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"#R-95\/WHI","insp_unit_license":"4NG2438","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV482WX1L734677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"}]},{"id":2319853,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","dot_number":"1872800","report_state":"CA","report_number":"NEDJ001034","insp_date":"2023-02-03 00:00:00","insp_start_time":"2345","insp_end_time":"0053","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":"MARICOPA COLD STORAGE","shipping_paper_number":"384768","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14775223","transaction_code":"A","transaction_date":"2023-02-04 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T19:09:18.000000Z","updated_at":"2025-03-17T19:09:18.000000Z","inspection_violations":[{"id":3573413,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_violation_id":"251004793","seq_no":"1","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"1","insp_unit_id":"193282278","insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KR27867","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3903E"},{"id":3573414,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_violation_id":"251004794","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193282279","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39347E"},{"id":3573415,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_violation_id":"251004795","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"193282279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39353B"},{"id":3573416,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_violation_id":"251004796","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"193282279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39345B2"},{"id":3573417,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_violation_id":"251004797","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"193282279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39345B2"},{"id":3573418,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_violation_id":"251004798","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193282278","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3733966,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_unit_id":"193282278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"9F40832","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV1BSAX9332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:44.000000Z","updated_at":"2025-03-17T22:32:44.000000Z"},{"id":3733967,"change_date":"2023-02-07 21:41:00","inspection_id":"77797209","insp_unit_id":"193282279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"820","insp_unit_license":"4AE3860","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9627SW029709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:44.000000Z","updated_at":"2025-03-17T22:32:44.000000Z"}]},{"id":1268949,"change_date":"2022-09-12 21:43:00","inspection_id":"76590242","dot_number":"1872800","report_state":"CA","report_number":"NCNK004995","insp_date":"2022-09-09 00:00:00","insp_start_time":"0642","insp_end_time":"0709","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-12 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":"14589859","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2022-09-12 21:43:00","snet_input_date":"2022-09-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-12 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T18:50:06.000000Z","updated_at":"2025-03-17T18:50:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2042222,"change_date":"2022-09-12 21:43:00","inspection_id":"76590242","insp_unit_id":"190857914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"WHT\/32","insp_unit_license":"4NU5843","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0628XB002433","insp_unit_decal":"Y","insp_unit_decal_number":"31490516","created_at":"2025-03-17T22:21:02.000000Z","updated_at":"2025-03-17T22:21:02.000000Z"},{"id":2042223,"change_date":"2022-09-12 21:43:00","inspection_id":"76590242","insp_unit_id":"190857915","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/11","insp_unit_license":"9G16366","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV6FSGT2872","insp_unit_decal":"Y","insp_unit_decal_number":"31490515","created_at":"2025-03-17T22:21:02.000000Z","updated_at":"2025-03-17T22:21:02.000000Z"}]},{"id":1120399,"change_date":"2022-08-23 21:42:00","inspection_id":"76418096","dot_number":"1872800","report_state":"CA","report_number":"NBH0005285","insp_date":"2022-08-22 00:00:00","insp_start_time":"0719","insp_end_time":"0732","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":"2022-08-23 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":"14561108","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2022-08-23 21:42:00","snet_input_date":"2022-08-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T18:47:31.000000Z","updated_at":"2025-03-17T18:47:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1802244,"change_date":"2022-08-23 21:42:00","inspection_id":"76418096","insp_unit_id":"190506535","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5\/RED","insp_unit_license":"9G06294","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X5FD267088","insp_unit_decal":"Y","insp_unit_decal_number":"31490283","created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"},{"id":1802245,"change_date":"2022-08-23 21:42:00","inspection_id":"76418096","insp_unit_id":"190506536","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT","insp_unit_license":"4MS8562","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W2YL712232","insp_unit_decal":"Y","insp_unit_decal_number":"31490284","created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":889189,"change_date":"2022-07-25 21:40:00","inspection_id":"76147564","dot_number":"1872800","report_state":"CA","report_number":"UDSS000865","insp_date":"2022-07-20 00:00:00","insp_start_time":"1105","insp_end_time":"1115","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN PACIFIC GRAPE DIVISION","shipping_paper_number":"804901","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-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14518586","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2022-07-25 21:40:00","snet_input_date":"2022-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-25 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T18:43:23.000000Z","updated_at":"2025-03-17T18:43:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1431639,"change_date":"2022-07-25 21:40:00","inspection_id":"76147564","insp_unit_id":"189954114","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"9F11098","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXDB9X78D755261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"},{"id":1431640,"change_date":"2022-07-25 21:40:00","inspection_id":"76147564","insp_unit_id":"189954115","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R-89","insp_unit_license":"4SD7626","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25336U872304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"}]},{"id":766057,"change_date":"2022-07-06 21:42:00","inspection_id":"76003869","dot_number":"1872800","report_state":"CA","report_number":"NBH0005025","insp_date":"2022-06-30 00:00:00","insp_start_time":"0712","insp_end_time":"0936","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":"2022-07-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14494591","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01872800","upload_search_indicator":null,"census_search_date":"2022-07-06 21:42:00","snet_input_date":"2022-06-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-06 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"9407 DOWNIE RIVER DRIVE","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93311","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"250821","created_at":"2025-03-17T18:41:13.000000Z","updated_at":"2025-03-17T18:41:13.000000Z","inspection_violations":[{"id":1209248,"change_date":"2022-07-06 21:42:00","inspection_id":"76003869","insp_violation_id":"246935729","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"1","insp_unit_id":"189642032","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KR57596","created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39375A2"},{"id":1209249,"change_date":"2022-07-06 21:42:00","inspection_id":"76003869","insp_violation_id":"246935730","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KR57596","created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1232453,"change_date":"2022-07-06 21:42:00","inspection_id":"76003869","insp_unit_id":"189642032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"14\/WHT","insp_unit_license":"9D80564","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X99D792409","insp_unit_decal":"Y","insp_unit_decal_number":"31133640","created_at":"2025-03-17T22:15:46.000000Z","updated_at":"2025-03-17T22:15:46.000000Z"},{"id":1232454,"change_date":"2022-07-06 21:42:00","inspection_id":"76003869","insp_unit_id":"189642033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R97\/WHT","insp_unit_license":"4RU4564","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0625BW702587","insp_unit_decal":"Y","insp_unit_decal_number":"31133632","created_at":"2025-03-17T22:15:46.000000Z","updated_at":"2025-03-17T22:15:46.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/1872800\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/1872800\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/1872800\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/1872800\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}