{"current_page":1,"data":[{"id":11923872,"change_date":"2026-05-15 21:44:00","inspection_id":"87858170","dot_number":"3200766","report_state":"CA","report_number":"NCEB009741","insp_date":"2026-05-08 00:00:00","insp_start_time":"0731","insp_end_time":"0747","registration_date":null,"region":"PS","ci_status_code":"C","location":"726","location_desc":"CA","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3330771","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:27.000000Z","updated_at":"2026-05-26T09:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21525156,"change_date":null,"inspection_id":"87858170","insp_unit_id":"sms-backfill-790723530-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"94576G4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC1KDKH2972","insp_unit_decal":null,"insp_unit_decal_number":"36241062","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11809175,"change_date":"2026-05-02 21:34:00","inspection_id":"87742639","dot_number":"3200766","report_state":"CA","report_number":"UELQ000901","insp_date":"2026-04-28 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTADOS FOODS LLC","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-02 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3249417","transaction_code":"A","transaction_date":"2026-05-02 00:00:00","upload_date":"2026-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2026-05-02 21:34:00","snet_input_date":"2026-05-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-02 21:34:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-05T09:41:42.000000Z","updated_at":"2026-05-13T09:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21339741,"change_date":null,"inspection_id":"87742639","insp_unit_id":"sms-backfill-789683751-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"94576G4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC1KDKH2972","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11220132,"change_date":"2026-02-24 21:40:00","inspection_id":"87131826","dot_number":"3200766","report_state":"CA","report_number":"NEAH006547","insp_date":"2026-02-20 00:00:00","insp_start_time":"0806","insp_end_time":"0829","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16181622","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2026-02-24 21:40:00","snet_input_date":"2026-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-24 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"539002","created_at":"2026-02-27T10:38:10.000000Z","updated_at":"2026-03-07T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19456049,"change_date":null,"inspection_id":"87131826","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"94576G4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC1KDKH2972","insp_unit_decal":null,"insp_unit_decal_number":"35934553","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10501338,"change_date":"2025-12-22 21:39:00","inspection_id":"86636159","dot_number":"3200766","report_state":"CA","report_number":"NFSD000225","insp_date":"2025-12-18 00:00:00","insp_start_time":"1704","insp_end_time":"1751","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":"ESTADOS FOODS LLC","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-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16104901","transaction_code":"A","transaction_date":"2025-12-18 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"539002","created_at":"2025-12-25T10:37:50.000000Z","updated_at":"2026-01-02T10:31:19.000000Z","inspection_violations":[{"id":18491027,"change_date":null,"inspection_id":"86636159","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":18752773,"change_date":null,"inspection_id":"86636159","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83422C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2JDJL1654","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10197787,"change_date":"2025-11-14 21:40:00","inspection_id":"86318457","dot_number":"3200766","report_state":"US","report_number":"2048000720","insp_date":"2025-11-13 00:00:00","insp_start_time":"1020","insp_end_time":"1119","registration_date":null,"region":"PS","ci_status_code":"C","location":"646OTY","location_desc":"SAN DIEGO CA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LUCIA EMIRET MENDEZ SANTIAGO","shipping_paper_number":"83U14349536","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","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":"2541085","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:23.000000Z","updated_at":"2025-11-18T10:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18749305,"change_date":null,"inspection_id":"86318457","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":null,"insp_unit_decal_number":"35741825","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9711115,"change_date":"2025-09-17 21:41:00","inspection_id":"85806452","dot_number":"3200766","report_state":"CA","report_number":"UE7U003123","insp_date":"2025-09-12 00:00:00","insp_start_time":"0253","insp_end_time":"0315","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"S\/B GILROY INSPECTION FACILITY","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15983618","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-09-17 21:41:00","snet_input_date":"2025-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-17 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:55.000000Z","updated_at":"2025-09-23T10:01:55.000000Z","inspection_violations":[{"id":15938087,"change_date":"2025-09-17 21:41:00","inspection_id":"85806452","insp_violation_id":"268765468","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"209010417","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1","created_at":"2025-09-20T10:16:37.000000Z","updated_at":"2025-09-22T10:17:11.000000Z","normalized_code":"39311A1LHLM"}],"inspection_per_units":[{"id":16077239,"change_date":"2025-09-17 21:41:00","inspection_id":"85806452","insp_unit_id":"209010417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06\/WHT","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:53.000000Z","updated_at":"2025-09-21T09:45:46.000000Z"}]},{"id":9711114,"change_date":"2025-09-17 21:41:00","inspection_id":"85806451","dot_number":"3200766","report_state":"CA","report_number":"UE7U003122","insp_date":"2025-09-11 00:00:00","insp_start_time":"2007","insp_end_time":"2048","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"S\/B GILROY INSPECTION FACILITY","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15983087","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-09-17 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-17 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:55.000000Z","updated_at":"2025-09-23T10:01:55.000000Z","inspection_violations":[{"id":15938086,"change_date":"2025-09-17 21:41:00","inspection_id":"85806451","insp_violation_id":"268765467","seq_no":"1","part_no":"393","part_no_section":"75A1-TFBMF","insp_viol_unit":"1","insp_unit_id":"209010416","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1","created_at":"2025-09-20T10:16:37.000000Z","updated_at":"2025-09-22T10:17:11.000000Z","normalized_code":"39375A1TFBMF"}],"inspection_per_units":[{"id":16077238,"change_date":"2025-09-17 21:41:00","inspection_id":"85806451","insp_unit_id":"209010416","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07\/WHT","insp_unit_license":"99249G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXDT9FDGM5892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:53.000000Z","updated_at":"2025-09-21T09:45:46.000000Z"}]},{"id":8809127,"change_date":"2025-06-03 21:41:00","inspection_id":"84856323","dot_number":"3200766","report_state":"CA","report_number":"UFRY001644","insp_date":"2025-06-02 00:00:00","insp_start_time":"2154","insp_end_time":"2210","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15845463","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-06-03 21:41:00","snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-03 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:09.000000Z","updated_at":"2025-06-07T10:00:52.000000Z","inspection_violations":[{"id":14093415,"change_date":"2025-06-03 21:41:00","inspection_id":"84856323","insp_violation_id":"266645525","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"207210526","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SH42906","created_at":"2025-06-06T10:16:51.000000Z","updated_at":"2025-06-07T10:18:03.000000Z","normalized_code":"39311A1LHLM"}],"inspection_per_units":[{"id":14418629,"change_date":"2025-06-03 21:41:00","inspection_id":"84856323","insp_unit_id":"207210526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:53.000000Z","updated_at":"2025-06-07T09:46:07.000000Z"}]},{"id":8747003,"change_date":"2025-05-27 21:39:00","inspection_id":"84790613","dot_number":"3200766","report_state":"CA","report_number":"NC20007915","insp_date":"2025-05-22 00:00:00","insp_start_time":"0840","insp_end_time":"0905","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":"LOS ESTADOS FOODS","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15837473","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-05-30T10:00:37.000000Z","updated_at":"2025-05-31T10:00:52.000000Z","inspection_violations":[{"id":13963970,"change_date":"2025-05-27 21:39:00","inspection_id":"84790613","insp_violation_id":"266497829","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"207084985","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA249956","created_at":"2025-05-30T10:15:58.000000Z","updated_at":"2025-05-31T10:18:02.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":14302664,"change_date":"2025-05-27 21:39:00","inspection_id":"84790613","insp_unit_id":"207084985","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08\/WHT","insp_unit_license":"83422C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2JDJL1654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:37.000000Z","updated_at":"2025-05-31T09:47:37.000000Z"}]},{"id":8551864,"change_date":"2025-05-05 21:40:00","inspection_id":"84585006","dot_number":"3200766","report_state":"CA","report_number":"NCSV006923","insp_date":"2025-04-30 00:00:00","insp_start_time":"0238","insp_end_time":"0255","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15806842","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:51.000000Z","updated_at":"2025-05-09T10:24:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13907855,"change_date":"2025-05-05 21:40:00","inspection_id":"84585006","insp_unit_id":"206651630","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"99249G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXDT9FDGM5892","insp_unit_decal":"Y","insp_unit_decal_number":"35087550","created_at":"2025-05-08T09:59:21.000000Z","updated_at":"2025-05-09T10:07:37.000000Z"}]},{"id":8291075,"change_date":"2025-04-03 21:42:00","inspection_id":"84310053","dot_number":"3200766","report_state":"CA","report_number":"UCAC012686","insp_date":"2025-04-01 00:00:00","insp_start_time":"2115","insp_end_time":"2147","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTADOS FOODS","shipping_paper_number":"EFBO83U1414503","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-04-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15766382","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2025-04-03 21:42:00","snet_input_date":"2025-04-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-03 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-06T10:25:20.000000Z","updated_at":"2025-04-07T10:21:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13442000,"change_date":"2025-04-03 21:42:00","inspection_id":"84310053","insp_unit_id":"206148459","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"35080454","created_at":"2025-04-06T10:16:35.000000Z","updated_at":"2025-04-07T10:08:51.000000Z"}]},{"id":7502839,"change_date":"2024-12-26 21:37:00","inspection_id":"83481789","dot_number":"3200766","report_state":"CA","report_number":"UCO5003109","insp_date":"2024-12-23 00:00:00","insp_start_time":"1400","insp_end_time":"1410","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LUCIA EMIRET MENDEZ SANTIAGO","shipping_paper_number":"83U14047288","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-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15642346","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-12-26 21:37:00","snet_input_date":"2024-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-26 21:37:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:39.000000Z","updated_at":"2025-03-17T20:52:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12103806,"change_date":"2024-12-26 21:37:00","inspection_id":"83481789","insp_unit_id":"204560582","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6  WT","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:37.000000Z","updated_at":"2025-03-17T23:48:37.000000Z"}]},{"id":7396699,"change_date":"2024-12-11 21:41:00","inspection_id":"83370225","dot_number":"3200766","report_state":"CA","report_number":"NA25006849","insp_date":"2024-12-09 00:00:00","insp_start_time":"1752","insp_end_time":"1818","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"EFBO83U14033668","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15626072","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:20.000000Z","updated_at":"2025-03-17T20:50:20.000000Z","inspection_violations":[{"id":11559321,"change_date":"2024-12-11 21:41:00","inspection_id":"83370225","insp_violation_id":"263405709","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204332460","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V","created_at":"2025-03-17T22:02:14.000000Z","updated_at":"2025-03-17T22:02:14.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":11932473,"change_date":"2024-12-11 21:41:00","inspection_id":"83370225","insp_unit_id":"204332460","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06 WHT","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:44.000000Z","updated_at":"2025-03-17T23:46:44.000000Z"}]},{"id":5923891,"change_date":"2024-06-05 21:42:00","inspection_id":"81799765","dot_number":"3200766","report_state":"CA","report_number":"UD7O002410","insp_date":"2024-06-04 00:00:00","insp_start_time":"2020","insp_end_time":"2027","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":"ESTADOS FOODS","shipping_paper_number":"18148","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-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15391602","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:14.000000Z","updated_at":"2025-03-17T20:20:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9541349,"change_date":"2024-06-05 21:42:00","inspection_id":"81799765","insp_unit_id":"201256205","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06\/WHI","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"33822737","created_at":"2025-03-17T23:21:58.000000Z","updated_at":"2025-03-17T23:21:58.000000Z"}]},{"id":5659931,"change_date":"2024-05-02 21:43:00","inspection_id":"81513234","dot_number":"3200766","report_state":"CA","report_number":"N9PI007624","insp_date":"2024-05-01 00:00:00","insp_start_time":"2121","insp_end_time":"2143","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":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15345770","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T20:14:46.000000Z","updated_at":"2025-03-17T20:14:46.000000Z","inspection_violations":[{"id":8754793,"change_date":"2024-05-02 21:43:00","inspection_id":"81513234","insp_violation_id":"259292500","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200707268","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA248332","created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9116184,"change_date":"2024-05-02 21:43:00","inspection_id":"81513234","insp_unit_id":"200707268","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT VAN TRK","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:50.000000Z","updated_at":"2025-03-17T23:17:50.000000Z"}]},{"id":5660162,"change_date":"2024-05-02 21:43:00","inspection_id":"81513475","dot_number":"3200766","report_state":"CA","report_number":"UFEV002790","insp_date":"2024-05-01 00:00:00","insp_start_time":"2200","insp_end_time":"2220","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15344333","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:02.000000Z","updated_at":"2025-03-17T20:15:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9116528,"change_date":"2024-05-02 21:43:00","inspection_id":"81513475","insp_unit_id":"200707645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHI","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"Y","insp_unit_decal_number":"33822834","created_at":"2025-03-17T23:17:50.000000Z","updated_at":"2025-03-17T23:17:50.000000Z"}]},{"id":5515174,"change_date":"2024-04-15 21:42:00","inspection_id":"81355507","dot_number":"3200766","report_state":"CA","report_number":"NDLY007689","insp_date":"2024-04-12 00:00:00","insp_start_time":"0906","insp_end_time":"0923","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":"LUCIA","shipping_paper_number":"83U13800489","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-04-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15318672","transaction_code":"A","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-04-15 21:42:00","snet_input_date":"2024-04-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-15 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T20:11:58.000000Z","updated_at":"2025-03-17T20:11:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8883948,"change_date":"2024-04-15 21:42:00","inspection_id":"81355507","insp_unit_id":"200404988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"05","insp_unit_license":"07283Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNV8JV6C4S52252","insp_unit_decal":"Y","insp_unit_decal_number":"33820853","created_at":"2025-03-17T23:15:39.000000Z","updated_at":"2025-03-17T23:15:39.000000Z"}]},{"id":5336406,"change_date":"2024-03-21 21:40:00","inspection_id":"81160405","dot_number":"3200766","report_state":"US","report_number":"1812000030","insp_date":"2024-03-20 00:00:00","insp_start_time":"1050","insp_end_time":"1124","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"SAN DIEGO CA","county_code_state":"CA","county_code":"073","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"336643","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-03-21 21:40:00","snet_input_date":"2024-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-21 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:19.000000Z","updated_at":"2025-03-17T20:08:19.000000Z","inspection_violations":[{"id":8234688,"change_date":"2024-03-21 21:40:00","inspection_id":"81160405","insp_violation_id":"258508176","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":8594168,"change_date":"2024-03-21 21:40:00","inspection_id":"81160405","insp_unit_id":"200020428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"33741488","created_at":"2025-03-17T23:12:56.000000Z","updated_at":"2025-03-17T23:12:56.000000Z"}]},{"id":5184129,"change_date":"2024-02-29 21:48:00","inspection_id":"80994022","dot_number":"3200766","report_state":"CA","report_number":"NDLY007472","insp_date":"2024-02-28 00:00:00","insp_start_time":"2118","insp_end_time":"2128","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":"ESTADOS FOODS","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-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"15264430","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-02-29 21:48:00","snet_input_date":"2024-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8347194,"change_date":"2024-02-29 21:48:00","inspection_id":"80994022","insp_unit_id":"199699570","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"}]},{"id":4869403,"change_date":"2024-01-19 21:44:00","inspection_id":"80650446","dot_number":"3200766","report_state":"CA","report_number":"UFEV002609","insp_date":"2024-01-18 00:00:00","insp_start_time":"2210","insp_end_time":"2228","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"15206560","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2024-01-19 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:14.000000Z","updated_at":"2025-03-17T19:59:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7834627,"change_date":"2024-01-19 21:44:00","inspection_id":"80650446","insp_unit_id":"199038804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01","insp_unit_license":"69427H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"69427H1","insp_unit_decal":"Y","insp_unit_decal_number":"33537675","created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"}]},{"id":4730494,"change_date":"2023-12-28 21:46:00","inspection_id":"80498576","dot_number":"3200766","report_state":"CA","report_number":"NDLY007210","insp_date":"2023-12-27 00:00:00","insp_start_time":"1445","insp_end_time":"1502","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":"EST ADOS FOODS","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-28 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15183247","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-12-28 21:46:00","snet_input_date":"2023-12-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-28 21:46:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:56:33.000000Z","updated_at":"2025-03-17T19:56:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7609368,"change_date":"2023-12-28 21:46:00","inspection_id":"80498576","insp_unit_id":"198733722","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"33229644","created_at":"2025-03-17T23:04:01.000000Z","updated_at":"2025-03-17T23:04:01.000000Z"}]},{"id":4593824,"change_date":"2023-12-08 21:41:00","inspection_id":"80349078","dot_number":"3200766","report_state":"CA","report_number":"NDS4004867","insp_date":"2023-12-07 00:00:00","insp_start_time":"1255","insp_end_time":"1423","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":"ESTADOS FOODS","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-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15159936","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-12-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:53:48.000000Z","updated_at":"2025-03-17T19:53:48.000000Z","inspection_violations":[{"id":7104989,"change_date":"2023-12-08 21:41:00","inspection_id":"80349078","insp_violation_id":"256802346","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KW78880","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":7388635,"change_date":"2023-12-08 21:41:00","inspection_id":"80349078","insp_unit_id":"198428950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"05\/WHT","insp_unit_license":"07283Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNV8JV6C4S52252","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:05.000000Z","updated_at":"2025-03-17T23:02:05.000000Z"}]},{"id":4241173,"change_date":"2023-10-19 21:41:00","inspection_id":"79959933","dot_number":"3200766","report_state":"CA","report_number":"NC43007259","insp_date":"2023-10-18 00:00:00","insp_start_time":"2040","insp_end_time":"2101","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":"2023-10-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"15104109","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-10-19 21:41:00","snet_input_date":"2023-10-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-19 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:47:01.000000Z","updated_at":"2025-03-17T19:47:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6820736,"change_date":"2023-10-19 21:41:00","inspection_id":"79959933","insp_unit_id":"197654024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"Y","insp_unit_decal_number":"33227577","created_at":"2025-03-17T22:57:11.000000Z","updated_at":"2025-03-17T22:57:11.000000Z"}]},{"id":4051800,"change_date":"2023-09-25 21:41:00","inspection_id":"79750234","dot_number":"3200766","report_state":"CA","report_number":"UF54000369","insp_date":"2023-09-23 00:00:00","insp_start_time":"1610","insp_end_time":"1640","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15074177","transaction_code":"A","transaction_date":"2023-09-23 00:00:00","upload_date":"2023-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-09-25 21:41:00","snet_input_date":"2023-09-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-25 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:49.000000Z","updated_at":"2025-03-17T19:42:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6515120,"change_date":"2023-09-25 21:41:00","inspection_id":"79750234","insp_unit_id":"197229102","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"}]},{"id":4016899,"change_date":"2023-09-20 21:40:00","inspection_id":"79711464","dot_number":"3200766","report_state":"CA","report_number":"NC20005784","insp_date":"2023-09-19 00:00:00","insp_start_time":"1319","insp_end_time":"1609","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":"2023-09-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15067791","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-09-20 21:40:00","snet_input_date":"2023-09-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-20 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:42:04.000000Z","updated_at":"2025-03-17T19:42:04.000000Z","inspection_violations":[{"id":6217399,"change_date":"2023-09-20 21:40:00","inspection_id":"79711464","insp_violation_id":"255385243","seq_no":"1","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":null,"created_at":"2025-03-17T21:35:59.000000Z","updated_at":"2025-03-17T21:35:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6458994,"change_date":"2023-09-20 21:40:00","inspection_id":"79711464","insp_unit_id":"197152545","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"05\/WHT6","insp_unit_license":"07283Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNV8JV6C4S52252","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:12.000000Z","updated_at":"2025-03-17T22:54:12.000000Z"}]},{"id":3678501,"change_date":"2023-08-04 21:41:00","inspection_id":"79334539","dot_number":"3200766","report_state":"CA","report_number":"NCG8003182","insp_date":"2023-08-03 00:00:00","insp_start_time":"1707","insp_end_time":"1740","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"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":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15008801","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5914266,"change_date":"2023-08-04 21:41:00","inspection_id":"79334539","insp_unit_id":"196382664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"32905310","created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"}]},{"id":3424712,"change_date":"2023-07-03 21:38:00","inspection_id":"79049389","dot_number":"3200766","report_state":"CA","report_number":"UEAW002412","insp_date":"2023-07-01 00:00:00","insp_start_time":"0830","insp_end_time":"0901","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"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":"2023-07-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14967990","transaction_code":"A","transaction_date":"2023-07-01 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-07-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:55.000000Z","updated_at":"2025-03-17T19:30:55.000000Z","inspection_violations":[{"id":5281528,"change_date":"2023-07-03 21:38:00","inspection_id":"79049389","insp_violation_id":"253848279","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"195807336","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA209845","created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39375A1"},{"id":5281529,"change_date":"2023-07-03 21:38:00","inspection_id":"79049389","insp_violation_id":"253848280","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195807336","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5506089,"change_date":"2023-07-03 21:38:00","inspection_id":"79049389","insp_unit_id":"195807336","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:28.000000Z","updated_at":"2025-03-17T22:46:28.000000Z"}]},{"id":3287661,"change_date":"2023-06-14 21:42:00","inspection_id":"78895328","dot_number":"3200766","report_state":"CA","report_number":"NC20005516","insp_date":"2023-06-13 00:00:00","insp_start_time":"1335","insp_end_time":"1351","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":"2023-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14942978","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-06-14 21:42:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-14 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:28:08.000000Z","updated_at":"2025-03-17T19:28:08.000000Z","inspection_violations":[{"id":5071055,"change_date":"2023-06-14 21:42:00","inspection_id":"78895328","insp_violation_id":"253513309","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5286077,"change_date":"2023-06-14 21:42:00","inspection_id":"78895328","insp_unit_id":"195504164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"05\/WHT","insp_unit_license":"07283Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNV8JV6C4S52252","insp_unit_decal":"Y","insp_unit_decal_number":"32498720","created_at":"2025-03-17T22:44:40.000000Z","updated_at":"2025-03-17T22:44:40.000000Z"}]},{"id":3155365,"change_date":"2023-05-26 21:40:00","inspection_id":"78745652","dot_number":"3200766","report_state":"CA","report_number":"N8OL007132","insp_date":"2023-05-25 00:00:00","insp_start_time":"1305","insp_end_time":"1322","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":"ESTADOS FOODS","shipping_paper_number":"12381","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-05-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14919736","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-05-26 21:40:00","snet_input_date":"2023-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-26 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:25:23.000000Z","updated_at":"2025-03-17T19:25:23.000000Z","inspection_violations":[{"id":4859872,"change_date":"2023-05-26 21:40:00","inspection_id":"78745652","insp_violation_id":"253116759","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195173348","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA299594","created_at":"2025-03-17T21:29:34.000000Z","updated_at":"2025-03-17T21:29:34.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5074540,"change_date":"2023-05-26 21:40:00","inspection_id":"78745652","insp_unit_id":"195173348","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT BOX TRK","insp_unit_license":"75763Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7K00058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:59.000000Z","updated_at":"2025-03-17T22:42:59.000000Z"}]},{"id":3172510,"change_date":"2023-05-30 21:43:00","inspection_id":"78765168","dot_number":"3200766","report_state":"CA","report_number":"ND7N006518","insp_date":"2023-05-25 00:00:00","insp_start_time":"1909","insp_end_time":"1919","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":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14921582","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:45.000000Z","updated_at":"2025-03-17T19:25:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5103241,"change_date":"2023-05-30 21:43:00","inspection_id":"78765168","insp_unit_id":"195213908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"03 WHT","insp_unit_license":"75763Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7K00058","insp_unit_decal":"Y","insp_unit_decal_number":"32494279","created_at":"2025-03-17T22:43:13.000000Z","updated_at":"2025-03-17T22:43:13.000000Z"}]},{"id":3124607,"change_date":"2023-05-23 21:43:00","inspection_id":"78711184","dot_number":"3200766","report_state":"CA","report_number":"NBH0006393","insp_date":"2023-05-18 00:00:00","insp_start_time":"0849","insp_end_time":"0857","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":"2023-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14912339","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:24:56.000000Z","updated_at":"2025-03-17T19:24:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5025889,"change_date":"2023-05-23 21:43:00","inspection_id":"78711184","insp_unit_id":"195106686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"32497242","created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"}]},{"id":2463928,"change_date":"2023-02-27 21:42:00","inspection_id":"77961725","dot_number":"3200766","report_state":"CA","report_number":"UCKB001650","insp_date":"2023-02-24 00:00:00","insp_start_time":"2140","insp_end_time":"2205","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14798345","transaction_code":"A","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3965502,"change_date":"2023-02-27 21:42:00","inspection_id":"77961725","insp_unit_id":"193610709","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:25.000000Z","updated_at":"2025-03-17T22:34:25.000000Z"}]},{"id":2259642,"change_date":"2023-01-30 21:44:00","inspection_id":"77729084","dot_number":"3200766","report_state":"CA","report_number":"ND7N005961","insp_date":"2023-01-24 00:00:00","insp_start_time":"1554","insp_end_time":"1614","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-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14761149","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:08:11.000000Z","updated_at":"2025-03-17T19:08:11.000000Z","inspection_violations":[{"id":3489408,"change_date":"2023-01-30 21:44:00","inspection_id":"77729084","insp_violation_id":"250858226","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193139464","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA299048","created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3637509,"change_date":"2023-01-30 21:44:00","inspection_id":"77729084","insp_unit_id":"193139464","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04 WHT","insp_unit_license":"18481Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT0CDBH8354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"}]},{"id":2208414,"change_date":"2023-01-23 21:42:00","inspection_id":"77670555","dot_number":"3200766","report_state":"CA","report_number":"UD54000088","insp_date":"2023-01-21 00:00:00","insp_start_time":"1350","insp_end_time":"1410","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":"ESTADOS FOODS","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-01-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14753326","transaction_code":"A","transaction_date":"2023-01-21 00:00:00","upload_date":"2023-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-01-23 21:42:00","snet_input_date":"2023-01-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-23 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"2206 N PLEASANT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93705","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:07:21.000000Z","updated_at":"2025-03-17T19:07:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3554584,"change_date":"2023-01-23 21:42:00","inspection_id":"77670555","insp_unit_id":"193018913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"75763Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7K00058","insp_unit_decal":"Y","insp_unit_decal_number":"32168790","created_at":"2025-03-17T22:31:29.000000Z","updated_at":"2025-03-17T22:31:29.000000Z"}]},{"id":2079132,"change_date":"2023-01-05 21:41:00","inspection_id":"77522226","dot_number":"3200766","report_state":"CA","report_number":"NDUF003485","insp_date":"2023-01-05 00:00:00","insp_start_time":"0147","insp_end_time":"0214","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":"2023-01-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"14729680","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2023-01-05 21:41:00","snet_input_date":"2023-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-05 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:48.000000Z","updated_at":"2025-03-17T19:04:48.000000Z","inspection_violations":[{"id":3218582,"change_date":"2023-01-05 21:41:00","inspection_id":"77522226","insp_violation_id":"250415548","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3345553,"change_date":"2023-01-05 21:41:00","inspection_id":"77522226","insp_unit_id":"192726345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/01","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:58.000000Z","updated_at":"2025-03-17T22:29:58.000000Z"}]},{"id":2060476,"change_date":"2023-01-03 21:42:00","inspection_id":"77500981","dot_number":"3200766","report_state":"US","report_number":"1600230371","insp_date":"2022-12-30 00:00:00","insp_start_time":"0720","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"CHP OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ESTADOS FOODS LLC","shipping_paper_number":"3","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":"I","final_status_date":"2023-01-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"395426","transaction_code":"A","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":"M","census_search_date":"2023-01-03 21:42:00","snet_input_date":"2023-01-03 00:00:00","source_office":"4CAD001","mcmis_add_date":"2023-01-03 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3147 W OLIVE AVE SPC 65","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722-5782","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:42.000000Z","updated_at":"2025-03-17T19:04:42.000000Z","inspection_violations":[{"id":3190945,"change_date":"2023-01-03 21:42:00","inspection_id":"77500981","insp_violation_id":"250370627","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:06.000000Z","updated_at":"2025-03-17T21:22:06.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":3314998,"change_date":"2023-01-03 21:42:00","inspection_id":"77500981","insp_unit_id":"192683791","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01\/ WHT","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:43.000000Z","updated_at":"2025-03-17T22:29:43.000000Z"}]},{"id":2031150,"change_date":"2022-12-28 21:40:00","inspection_id":"77467269","dot_number":"3200766","report_state":"CA","report_number":"N9Y4005012","insp_date":"2022-12-27 00:00:00","insp_start_time":"0743","insp_end_time":"0804","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTADOS FOODS","shipping_paper_number":"EXP20712","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"14723492","transaction_code":"A","transaction_date":"2022-12-27 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-12-28 21:40:00","snet_input_date":"2022-12-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-28 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T19:04:01.000000Z","updated_at":"2025-03-17T19:04:01.000000Z","inspection_violations":[{"id":3149636,"change_date":"2022-12-28 21:40:00","inspection_id":"77467269","insp_violation_id":"250302544","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192617358","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"39395A"},{"id":3149637,"change_date":"2022-12-28 21:40:00","inspection_id":"77467269","insp_violation_id":"250302545","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192617358","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":3268094,"change_date":"2022-12-28 21:40:00","inspection_id":"77467269","insp_unit_id":"192617358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01\/ WHT","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"Y","insp_unit_decal_number":"31876723","created_at":"2025-03-17T22:29:23.000000Z","updated_at":"2025-03-17T22:29:23.000000Z"}]},{"id":1792207,"change_date":"2022-11-21 21:42:00","inspection_id":"77194228","dot_number":"3200766","report_state":"CA","report_number":"UFEV002039","insp_date":"2022-11-19 00:00:00","insp_start_time":"0845","insp_end_time":"0903","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14680779","transaction_code":"A","transaction_date":"2022-11-19 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-11-21 21:42:00","snet_input_date":"2022-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-21 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:40.000000Z","updated_at":"2025-03-17T18:59:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2883228,"change_date":"2022-11-21 21:42:00","inspection_id":"77194228","insp_unit_id":"192075896","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06 \/ WHI","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"Y","insp_unit_decal_number":"31835895","created_at":"2025-03-17T22:26:43.000000Z","updated_at":"2025-03-17T22:26:43.000000Z"}]},{"id":1736700,"change_date":"2022-11-14 21:43:00","inspection_id":"77130527","dot_number":"3200766","report_state":"CA","report_number":"NDT8003172","insp_date":"2022-11-12 00:00:00","insp_start_time":"0840","insp_end_time":"0915","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"14671523","transaction_code":"A","transaction_date":"2022-11-12 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-11-14 21:43:00","snet_input_date":"2022-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-14 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:58:36.000000Z","updated_at":"2025-03-17T18:58:36.000000Z","inspection_violations":[{"id":2720424,"change_date":"2022-11-14 21:43:00","inspection_id":"77130527","insp_violation_id":"249592093","seq_no":"1","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"191948498","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"39367C7V"},{"id":2720425,"change_date":"2022-11-14 21:43:00","inspection_id":"77130527","insp_violation_id":"249592094","seq_no":"2","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"191948498","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"39375A1"},{"id":2720426,"change_date":"2022-11-14 21:43:00","inspection_id":"77130527","insp_violation_id":"249592095","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191948498","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA205741","created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"3963A1"},{"id":2720427,"change_date":"2022-11-14 21:43:00","inspection_id":"77130527","insp_violation_id":"249592096","seq_no":"4","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"191948498","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"393209E"}],"inspection_per_units":[{"id":2794432,"change_date":"2022-11-14 21:43:00","inspection_id":"77130527","insp_unit_id":"191948498","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:07.000000Z","updated_at":"2025-03-17T22:26:07.000000Z"}]},{"id":1692888,"change_date":"2022-11-07 21:42:00","inspection_id":"77080260","dot_number":"3200766","report_state":"CA","report_number":"UC13002604","insp_date":"2022-11-05 00:00:00","insp_start_time":"0810","insp_end_time":"0830","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-11-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14664997","transaction_code":"A","transaction_date":"2022-11-05 00:00:00","upload_date":"2022-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-11-07 21:42:00","snet_input_date":"2022-11-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-07 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:57:47.000000Z","updated_at":"2025-03-17T18:57:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2723625,"change_date":"2022-11-07 21:42:00","inspection_id":"77080260","insp_unit_id":"191850800","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"75763Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7K00058","insp_unit_decal":"Y","insp_unit_decal_number":"31835604","created_at":"2025-03-17T22:25:39.000000Z","updated_at":"2025-03-17T22:25:39.000000Z"}]},{"id":1522491,"change_date":"2022-10-14 21:40:00","inspection_id":"76884552","dot_number":"3200766","report_state":"CA","report_number":"NDTI004276","insp_date":"2022-10-13 00:00:00","insp_start_time":"2316","insp_end_time":"2353","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14634803","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-10-14 21:40:00","snet_input_date":"2022-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-14 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:54:48.000000Z","updated_at":"2025-03-17T18:54:48.000000Z","inspection_violations":[{"id":2398558,"change_date":"2022-10-14 21:40:00","inspection_id":"76884552","insp_violation_id":"249050708","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191457896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2450178,"change_date":"2022-10-14 21:40:00","inspection_id":"76884552","insp_unit_id":"191457896","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT-06","insp_unit_license":"07642Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT9FDGA4281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:48.000000Z","updated_at":"2025-03-17T22:23:48.000000Z"}]},{"id":1289055,"change_date":"2022-09-14 21:40:00","inspection_id":"76613486","dot_number":"3200766","report_state":"CA","report_number":"ND7N005349","insp_date":"2022-09-13 00:00:00","insp_start_time":"1605","insp_end_time":"1614","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-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"14593931","transaction_code":"A","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:28.000000Z","updated_at":"2025-03-17T18:50:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2075030,"change_date":"2022-09-14 21:40:00","inspection_id":"76613486","insp_unit_id":"190907357","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"02 WHT","insp_unit_license":"31890F3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB3GTCGXG1334354","insp_unit_decal":"Y","insp_unit_decal_number":"31489329","created_at":"2025-03-17T22:21:15.000000Z","updated_at":"2025-03-17T22:21:15.000000Z"}]},{"id":991303,"change_date":"2022-08-08 21:40:00","inspection_id":"76267312","dot_number":"3200766","report_state":"CA","report_number":"UCX0001509","insp_date":"2022-08-05 00:00:00","insp_start_time":"1904","insp_end_time":"1924","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"14537570","transaction_code":"A","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:45:06.000000Z","updated_at":"2025-03-17T18:45:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1595469,"change_date":"2022-08-08 21:40:00","inspection_id":"76267312","insp_unit_id":"190199910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"Y","insp_unit_decal_number":"31530303","created_at":"2025-03-17T22:18:03.000000Z","updated_at":"2025-03-17T22:18:03.000000Z"}]},{"id":976463,"change_date":"2022-08-05 21:40:00","inspection_id":"76250255","dot_number":"3200766","report_state":"US","report_number":"1600230167","insp_date":"2022-08-04 00:00:00","insp_start_time":"1445","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"CHP-OTAY MESA","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ESTADOS FOODS LLC","shipping_paper_number":"13319332","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":"I","final_status_date":"2022-08-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"391736","transaction_code":"A","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":"M","census_search_date":"2022-08-05 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"4CAD001","mcmis_add_date":"2022-08-05 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3147 W OLIVE AVE SPC 65","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722-5782","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:48.000000Z","updated_at":"2025-03-17T18:44:48.000000Z","inspection_violations":[{"id":1541672,"change_date":"2022-08-05 21:40:00","inspection_id":"76250255","insp_violation_id":"247554612","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:17.000000Z","updated_at":"2025-03-17T21:14:17.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":1571456,"change_date":"2022-08-05 21:40:00","inspection_id":"76250255","insp_unit_id":"190166328","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"69427H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWE3FLXCDA94220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:54.000000Z","updated_at":"2025-03-17T22:17:54.000000Z"}]},{"id":960441,"change_date":"2022-08-03 21:43:00","inspection_id":"76231456","dot_number":"3200766","report_state":"CA","report_number":"NC43005583","insp_date":"2022-08-02 00:00:00","insp_start_time":"1630","insp_end_time":"1646","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-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"14532844","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-08-03 21:43:00","snet_input_date":"2022-08-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-03 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:43.000000Z","updated_at":"2025-03-17T18:44:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1545702,"change_date":"2022-08-03 21:43:00","inspection_id":"76231456","insp_unit_id":"190126857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"75763Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7K00058","insp_unit_decal":"Y","insp_unit_decal_number":"31488256","created_at":"2025-03-17T22:17:44.000000Z","updated_at":"2025-03-17T22:17:44.000000Z"}]},{"id":909365,"change_date":"2022-07-27 21:41:00","inspection_id":"76171090","dot_number":"3200766","report_state":"CA","report_number":"NC43005554","insp_date":"2022-07-25 00:00:00","insp_start_time":"1628","insp_end_time":"1640","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-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14523600","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-07-27 21:41:00","snet_input_date":"2022-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:43:42.000000Z","updated_at":"2025-03-17T18:43:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1463779,"change_date":"2022-07-27 21:41:00","inspection_id":"76171090","insp_unit_id":"190003771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X\/WHT","insp_unit_license":"18481Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT0CDBH8354","insp_unit_decal":"Y","insp_unit_decal_number":"31488226","created_at":"2025-03-17T22:17:12.000000Z","updated_at":"2025-03-17T22:17:12.000000Z"}]},{"id":876810,"change_date":"2022-07-22 21:40:00","inspection_id":"76133255","dot_number":"3200766","report_state":"CA","report_number":"NC20004104","insp_date":"2022-07-20 00:00:00","insp_start_time":"1225","insp_end_time":"1235","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-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14516861","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-07-22 21:40:00","snet_input_date":"2022-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-22 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:43:04.000000Z","updated_at":"2025-03-17T18:43:04.000000Z","inspection_violations":[{"id":1381665,"change_date":"2022-07-22 21:40:00","inspection_id":"76133255","insp_violation_id":"247266511","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189925967","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:32.000000Z","updated_at":"2025-03-17T21:13:32.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1411706,"change_date":"2022-07-22 21:40:00","inspection_id":"76133255","insp_unit_id":"189925967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04\/WHT","insp_unit_license":"18481Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT0CDBH8354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:52.000000Z","updated_at":"2025-03-17T22:16:52.000000Z"}]},{"id":823295,"change_date":"2022-07-14 21:42:00","inspection_id":"76070905","dot_number":"3200766","report_state":"CA","report_number":"ND7N005100","insp_date":"2022-07-13 00:00:00","insp_start_time":"1558","insp_end_time":"1608","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14506365","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-07-14 21:42:00","snet_input_date":"2022-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[{"id":1299263,"change_date":"2022-07-14 21:42:00","inspection_id":"76070905","insp_violation_id":"247110861","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189791215","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1324862,"change_date":"2022-07-14 21:42:00","inspection_id":"76070905","insp_unit_id":"189791215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04 WHT","insp_unit_license":"18481Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT0CDBH8354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:19.000000Z","updated_at":"2025-03-17T22:16:19.000000Z"}]},{"id":713374,"change_date":"2022-06-28 21:43:00","inspection_id":"75942390","dot_number":"3200766","report_state":"CA","report_number":"NCNK004690","insp_date":"2022-06-27 00:00:00","insp_start_time":"0952","insp_end_time":"1006","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":"ESTADOS FOODS LLC","shipping_paper_number":"7378","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-06-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"14486394","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-06-28 21:43:00","snet_input_date":"2022-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-28 21:43:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:40:12.000000Z","updated_at":"2025-03-17T18:40:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1146720,"change_date":"2022-06-28 21:43:00","inspection_id":"75942390","insp_unit_id":"189511723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT\/01","insp_unit_license":"31890F3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB3GTCGXG1334354","insp_unit_decal":"Y","insp_unit_decal_number":"31133217","created_at":"2025-03-17T22:15:15.000000Z","updated_at":"2025-03-17T22:15:15.000000Z"}]},{"id":520356,"change_date":"2022-05-31 21:42:00","inspection_id":"75713400","dot_number":"3200766","report_state":"CA","report_number":"UDTG001929","insp_date":"2022-05-27 00:00:00","insp_start_time":"2305","insp_end_time":"2317","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14451636","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-05-31 21:42:00","snet_input_date":"2022-05-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-31 21:42:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:00.000000Z","updated_at":"2025-03-17T18:37:00.000000Z","inspection_violations":[{"id":822947,"change_date":"2022-05-31 21:42:00","inspection_id":"75713400","insp_violation_id":"246179072","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189005921","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:10:56.000000Z","updated_at":"2025-03-17T21:10:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":837408,"change_date":"2022-05-31 21:42:00","inspection_id":"75713400","insp_unit_id":"189005921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"18481Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT0CDBH8354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"}]},{"id":389575,"change_date":"2022-05-13 21:40:00","inspection_id":"75557344","dot_number":"3200766","report_state":"CA","report_number":"UCLA000832","insp_date":"2022-05-11 00:00:00","insp_start_time":"1205","insp_end_time":"1235","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE CVEF","county_code_state":"CA","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESTADOS FOODS LLC","shipping_paper_number":"6831","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14425946","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-05-13 21:40:00","snet_input_date":"2022-05-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-13 21:40:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"539002","created_at":"2025-03-17T18:34:25.000000Z","updated_at":"2025-03-17T18:34:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":629535,"change_date":"2022-05-13 21:40:00","inspection_id":"75557344","insp_unit_id":"188682798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"18481Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT0CDBH8354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:03.000000Z","updated_at":"2025-03-17T22:12:03.000000Z"}]},{"id":132337,"change_date":"2022-04-07 21:39:00","inspection_id":"75250706","dot_number":"3200766","report_state":"CA","report_number":"NBH0004654","insp_date":"2022-04-06 00:00:00","insp_start_time":"1145","insp_end_time":"1157","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":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17500","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":"14376974","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03200766","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"ESTADOS FOODS LLC","insp_carrier_street":"3228 W OLIVE AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:50.000000Z","updated_at":"2025-03-17T18:29:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":214474,"change_date":"2022-04-07 21:39:00","inspection_id":"75250706","insp_unit_id":"188050308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"75763Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7K00058","insp_unit_decal":"Y","insp_unit_decal_number":"31128297","created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3200766\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3200766\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3200766\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3200766\/inspections","per_page":100,"prev_page_url":null,"to":52,"total":52}