{"current_page":1,"data":[{"id":12273091,"change_date":"2026-06-25 21:50:00","inspection_id":"88232487","dot_number":"9997","report_state":"OR","report_number":"AA43380406","insp_date":"2026-06-24 00:00:00","insp_start_time":"0930","insp_end_time":"0955","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"MCMINNVILLE OR","county_code_state":"OR","county_code":"071","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3614628","transaction_code":"A","transaction_date":"2026-06-24 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2026-06-25 21:50:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:50:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:33.000000Z","updated_at":"2026-07-06T09:31:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528452,"change_date":null,"inspection_id":"88232487","insp_unit_id":"sms-backfill-794092383-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2488844","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ7JN889102","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21531976,"change_date":null,"inspection_id":"88232487","insp_unit_id":"sms-backfill-794092383-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PG74414","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA84296B707740","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11353896,"change_date":"2026-06-16 21:40:00","inspection_id":"87272184","dot_number":"9997","report_state":"OR","report_number":"AP43050932","insp_date":"2026-03-10 00:00:00","insp_start_time":"1050","insp_end_time":"1123","registration_date":"2026-03-20 00:00:00","region":"PD","ci_status_code":"C","location":"15-07","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2997369","transaction_code":"C","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2026-03-12 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-12 21:39:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:39:53.000000Z","updated_at":"2026-06-27T09:30:03.000000Z","inspection_violations":[{"id":20299222,"change_date":null,"inspection_id":"87272184","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39347E"},{"id":20299223,"change_date":null,"inspection_id":"87272184","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"78A-WS","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-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39378AWS"},{"id":20299224,"change_date":null,"inspection_id":"87272184","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LIL","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-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"3939ALIL"},{"id":20299225,"change_date":null,"inspection_id":"87272184","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":20335219,"change_date":null,"inspection_id":"87272184","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PG74197","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA6228EB704418","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20329115,"change_date":null,"inspection_id":"87272184","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2561575","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH3KN208769","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11202802,"change_date":"2026-02-23 21:38:00","inspection_id":"87113767","dot_number":"9997","report_state":"WA","report_number":"2116001823","insp_date":"2026-02-21 00:00:00","insp_start_time":"0840","insp_end_time":"0937","registration_date":null,"region":"PS","ci_status_code":"C","location":"X861","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"6580","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":"U","pen_cen_match":"I","final_status_date":"2026-02-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"69600","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2922797","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2026-02-23 21:38:00","snet_input_date":"2026-02-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-26T10:36:55.000000Z","updated_at":"2026-03-06T10:30:28.000000Z","inspection_violations":[{"id":19147968,"change_date":null,"inspection_id":"87113767","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDLNP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"38323A2LCDLNP"},{"id":19147969,"change_date":null,"inspection_id":"87113767","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"38395ALCDL"},{"id":19147970,"change_date":null,"inspection_id":"87113767","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":19455902,"change_date":null,"inspection_id":"87113767","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3539764","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV0RDVB0446","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19458976,"change_date":null,"inspection_id":"87113767","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":null,"insp_unit_license":"PG65664","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"527SR3115SL046795","insp_unit_decal":null,"insp_unit_decal_number":"36065342","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10874817,"change_date":"2026-03-06 21:42:00","inspection_id":"86905018","dot_number":"9997","report_state":"OR","report_number":"AP43240580","insp_date":"2026-01-28 00:00:00","insp_start_time":"1042","insp_end_time":"1121","registration_date":"2026-02-05 00:00:00","region":"PS","ci_status_code":"C","location":"20-06","location_desc":"NOTI OR","county_code_state":"OR","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"1214638","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-28 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2821776","transaction_code":"C","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2026-01-28 21:37:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-28 21:37:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-31T10:36:26.000000Z","updated_at":"2026-03-17T09:31:17.000000Z","inspection_violations":[{"id":18743236,"change_date":null,"inspection_id":"86905018","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-23T04:17:42.000000Z","updated_at":"2026-02-23T04:17:42.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19088775,"change_date":null,"inspection_id":"86905018","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2962328","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM002073","insp_unit_decal":null,"insp_unit_decal_number":"36068814","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19092159,"change_date":null,"inspection_id":"86905018","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"PG26684","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162819R3000308","insp_unit_decal":null,"insp_unit_decal_number":"36068815","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10616515,"change_date":"2026-02-02 21:38:00","inspection_id":"86756679","dot_number":"9997","report_state":"OR","report_number":"BX43950184","insp_date":"2026-01-05 00:00:00","insp_start_time":"0251","insp_end_time":"0312","registration_date":null,"region":"PS","ci_status_code":"C","location":"36-02","location_desc":"DAYTON OR","county_code_state":"OR","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DAIRY QUEEN","shipping_paper_number":"1211927","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-10 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2747764","transaction_code":"C","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2026-01-10 21:34:00","snet_input_date":"2026-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-10 21:34:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-13T10:35:41.000000Z","updated_at":"2026-02-13T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090126,"change_date":null,"inspection_id":"86756679","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2561574","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH1KN208768","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19093761,"change_date":null,"inspection_id":"86756679","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PG74062","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K9SJ518607","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10285163,"change_date":"2025-11-25 21:38:00","inspection_id":"86410092","dot_number":"9997","report_state":"OR","report_number":"AP43390781","insp_date":"2025-11-25 00:00:00","insp_start_time":"0834","insp_end_time":"0911","registration_date":null,"region":"PS","ci_status_code":"C","location":"24-03","location_desc":"GATES OR","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","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-25 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2585747","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2025-11-25 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-25 21:38:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-28T10:31:49.000000Z","updated_at":"2025-11-29T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18750523,"change_date":null,"inspection_id":"86410092","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2488504","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ4HN991404","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":18835010,"change_date":null,"inspection_id":"86410092","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"P668434","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V312C9JT806002","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":8567260,"change_date":"2025-05-07 21:43:00","inspection_id":"84601176","dot_number":"9997","report_state":"OR","report_number":"AP40680409","insp_date":"2025-05-07 00:00:00","insp_start_time":"1209","insp_end_time":"1234","registration_date":null,"region":"PD","ci_status_code":"C","location":"09-06","location_desc":"BEND OR","county_code_state":"OR","county_code":"017","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"1182693","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-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1696722","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:26.000000Z","updated_at":"2025-05-11T10:12:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18651359,"change_date":null,"inspection_id":"84601176","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3786756","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDR2SSWD5030","insp_unit_decal":null,"insp_unit_decal_number":"35220408","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18812131,"change_date":null,"inspection_id":"84601176","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"PB12492","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818F5001238","insp_unit_decal":null,"insp_unit_decal_number":"35220409","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8402030,"change_date":"2025-04-17 21:41:00","inspection_id":"84427009","dot_number":"9997","report_state":"OR","report_number":"AP43390465","insp_date":"2025-04-17 00:00:00","insp_start_time":"1205","insp_end_time":"1238","registration_date":null,"region":"PD","ci_status_code":"C","location":"02-01","location_desc":"PHILOMATH OR","county_code_state":"OR","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","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-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"1609335","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:57.000000Z","updated_at":"2025-04-21T10:22:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18648961,"change_date":null,"inspection_id":"84427009","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3711121","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV8SSVT2356","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":18809434,"change_date":null,"inspection_id":"84427009","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"PB12492","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818F5001238","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":8051966,"change_date":"2025-03-07 21:38:00","inspection_id":"84058291","dot_number":"9997","report_state":"WA","report_number":"2116001088","insp_date":"2025-03-06 00:00:00","insp_start_time":"0231","insp_end_time":"0348","registration_date":null,"region":"PS","ci_status_code":"C","location":"X861","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"ROUTE 4610","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":"U","pen_cen_match":"I","final_status_date":"2025-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1442098","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:25.000000Z","updated_at":"2025-03-17T21:05:25.000000Z","inspection_violations":[{"id":18441402,"change_date":null,"inspection_id":"84058291","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"2","insp_unit_id":"2","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":"39355D2B"}],"inspection_per_units":[{"id":18722107,"change_date":null,"inspection_id":"84058291","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3216253","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG5PN332559","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":18804394,"change_date":null,"inspection_id":"84058291","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":null,"insp_unit_license":"PG26533","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"527SR4827SL044728","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":7964702,"change_date":"2025-02-26 21:41:00","inspection_id":"83966680","dot_number":"9997","report_state":"OR","report_number":"AP43240256","insp_date":"2025-02-26 00:00:00","insp_start_time":"0846","insp_end_time":"0903","registration_date":null,"region":"PS","ci_status_code":"C","location":"27-04","location_desc":"FORT HILL OR","county_code_state":"OR","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"23983","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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1403687","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2025-02-26 21:41:00","snet_input_date":"2025-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:37.000000Z","updated_at":"2025-03-17T21:03:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18720947,"change_date":null,"inspection_id":"83966680","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3216253","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG5PN332559","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":18803067,"change_date":null,"inspection_id":"83966680","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P379241","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA8420EB709444","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":7587842,"change_date":"2025-01-10 21:39:00","inspection_id":"83570959","dot_number":"9997","report_state":"OR","report_number":"AA43730134","insp_date":"2025-01-09 00:00:00","insp_start_time":"1338","insp_end_time":"1351","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"PORTLAND OR","county_code_state":"OR","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"1231241","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:41.000000Z","updated_at":"2025-03-17T20:55:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18638228,"change_date":null,"inspection_id":"83570959","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2341904","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4MC9EG3GN968680","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":18797576,"change_date":null,"inspection_id":"83570959","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"HU60621","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GRAA6225BB706915","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":7191417,"change_date":"2024-11-14 21:40:00","inspection_id":"83153747","dot_number":"9997","report_state":"OR","report_number":"AP42890207","insp_date":"2024-11-14 00:00:00","insp_start_time":"1156","insp_end_time":"1217","registration_date":null,"region":"PS","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1053381","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-11-14 21:40:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-14 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:01.000000Z","updated_at":"2025-03-17T20:46:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18710375,"change_date":null,"inspection_id":"83153747","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3216286","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4WC9EG2PN332566","insp_unit_decal":null,"insp_unit_decal_number":"34643919","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18791506,"change_date":null,"inspection_id":"83153747","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"T46690","insp_unit_license_state":"MT","insp_unit_vehicle_id_number":"1GRAA9629CB704744","insp_unit_decal":null,"insp_unit_decal_number":"34643920","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6870692,"change_date":"2024-10-02 21:40:00","inspection_id":"82813313","dot_number":"9997","report_state":"OR","report_number":"AP42810137","insp_date":"2024-10-02 00:00:00","insp_start_time":"1020","insp_end_time":"1059","registration_date":null,"region":"PD","ci_status_code":"C","location":"30-06","location_desc":"UMATILLA OR","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"NONE","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-10-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"906133","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-10-02 21:40:00","snet_input_date":"2024-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-02 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:25.000000Z","updated_at":"2025-03-17T20:39:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18628316,"change_date":null,"inspection_id":"82813313","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3481203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV0PDUP2004","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":18786670,"change_date":null,"inspection_id":"82813313","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"P590504","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482C5HT816008","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":6685305,"change_date":"2024-12-30 21:38:00","inspection_id":"82615977","dot_number":"9997","report_state":"OR","report_number":"AA43380097","insp_date":"2024-09-09 00:00:00","insp_start_time":"1746","insp_end_time":"1805","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"BEAVERTON OR","county_code_state":"OR","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"829863","transaction_code":"C","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:38.000000Z","updated_at":"2025-03-17T20:35:38.000000Z","inspection_violations":[{"id":18418864,"change_date":null,"inspection_id":"82615977","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","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":"3922SLLLR"}],"inspection_per_units":[{"id":18703456,"change_date":null,"inspection_id":"82615977","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2488505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ6HN991405","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":18783960,"change_date":null,"inspection_id":"82615977","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"P744625","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382C7KT546001","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":6618936,"change_date":"2024-09-03 21:41:00","inspection_id":"82545368","dot_number":"9997","report_state":"OR","report_number":"AA43380088","insp_date":"2024-08-31 00:00:00","insp_start_time":"1625","insp_end_time":"1645","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"PORTLAND OR","county_code_state":"OR","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-01 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"803542","transaction_code":"C","transaction_date":"2024-09-01 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-09-01 21:32:00","snet_input_date":"2024-08-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-01 21:32:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:07.000000Z","updated_at":"2025-03-17T20:34:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18702566,"change_date":null,"inspection_id":"82545368","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"3711269","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDXTZN3KN750605","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":18783012,"change_date":null,"inspection_id":"82545368","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"P668436","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V312C2JT806004","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":6513782,"change_date":"2024-08-26 21:41:00","inspection_id":"82433308","dot_number":"9997","report_state":"OR","report_number":"BD01080022","insp_date":"2024-08-20 00:00:00","insp_start_time":"1425","insp_end_time":"1436","registration_date":null,"region":"PD","ci_status_code":"C","location":"03-04","location_desc":"ROCK CREEK OR","county_code_state":"OR","county_code":"005","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":"U","pen_cen_match":"I","final_status_date":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"763502","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:59.000000Z","updated_at":"2025-03-17T20:31:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18623455,"change_date":null,"inspection_id":"82433308","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2241326","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ6GN963053","insp_unit_decal":null,"insp_unit_decal_number":"34338941","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18781480,"change_date":null,"inspection_id":"82433308","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PC93600","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K4PJ133043","insp_unit_decal":null,"insp_unit_decal_number":"34338942","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6500793,"change_date":"2024-08-26 21:41:00","inspection_id":"82419526","dot_number":"9997","report_state":"OR","report_number":"AP42890114","insp_date":"2024-08-19 00:00:00","insp_start_time":"1134","insp_end_time":"1150","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-19 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":"758738","transaction_code":"C","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-08-19 21:42:00","snet_input_date":"2024-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-19 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:55.000000Z","updated_at":"2025-03-17T20:31:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18700965,"change_date":null,"inspection_id":"82419526","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3481035","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWFD7PHNS8823","insp_unit_decal":null,"insp_unit_decal_number":"34340390","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6385474,"change_date":"2024-08-05 21:42:00","inspection_id":"82296289","dot_number":"9997","report_state":"WA","report_number":"X803000922","insp_date":"2024-08-02 00:00:00","insp_start_time":"0755","insp_end_time":"0811","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"ROUTE 9592","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","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":"714319","transaction_code":"A","transaction_date":"2024-08-04 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-08-05 21:42:00","snet_input_date":"2024-08-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-05 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":18412940,"change_date":null,"inspection_id":"82296289","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","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":"3922SLLTCD"}],"inspection_per_units":[{"id":18699440,"change_date":null,"inspection_id":"82296289","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2240795","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ0FN929852","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":18779645,"change_date":null,"inspection_id":"82296289","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"52087AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA96279B700569","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":6331739,"change_date":"2026-03-23 21:49:00","inspection_id":"82238814","dot_number":"9997","report_state":"OR","report_number":"AL41131048","insp_date":"2024-07-29 00:00:00","insp_start_time":"1139","insp_end_time":"1210","registration_date":"2024-08-05 00:00:00","region":"PD","ci_status_code":"C","location":null,"location_desc":"SANDY OR","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO FOOD","shipping_paper_number":"1148901","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-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"696510","transaction_code":"C","transaction_date":"2024-07-29 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-07-29 21:41:00","snet_input_date":"2024-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-29 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:16.000000Z","updated_at":"2026-04-03T09:30:03.000000Z","inspection_violations":[{"id":18412073,"change_date":null,"inspection_id":"82238814","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LCL","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":"3939ALCL"}],"inspection_per_units":[{"id":18698726,"change_date":null,"inspection_id":"82238814","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YAJH003","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGBDV1ASAT1678","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":18778850,"change_date":null,"inspection_id":"82238814","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"PC93552","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818P3000281","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":6202893,"change_date":"2024-07-12 21:38:00","inspection_id":"82100740","dot_number":"9997","report_state":"WA","report_number":"1166007914","insp_date":"2024-07-05 00:00:00","insp_start_time":"1116","insp_end_time":"1141","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"TOLEDO WA","county_code_state":"WA","county_code":"041","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"647091","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-07-12 21:38:00","snet_input_date":"2024-07-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-12 21:38:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:44.000000Z","updated_at":"2025-03-17T20:25:44.000000Z","inspection_violations":[{"id":18409752,"change_date":null,"inspection_id":"82100740","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","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":"3922SLLS2"}],"inspection_per_units":[{"id":18619306,"change_date":null,"inspection_id":"82100740","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3711124","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV3SSVT2359","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":18776907,"change_date":null,"inspection_id":"82100740","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"P962345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"NO RECORD","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":5678101,"change_date":"2024-05-06 21:43:00","inspection_id":"81533092","dot_number":"9997","report_state":"OR","report_number":"AASJ009229","insp_date":"2024-05-03 00:00:00","insp_start_time":"1325","insp_end_time":"1405","registration_date":null,"region":"PT","ci_status_code":"C","location":"0906","location_desc":"BEND - 2 MI S BEND","county_code_state":"OR","county_code":"017","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"652061737","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":"2024-05-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247756","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-05-06 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-05-06 21:43:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T20:15:08.000000Z","updated_at":"2025-03-17T20:15:08.000000Z","inspection_violations":[{"id":18399155,"change_date":null,"inspection_id":"81533092","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1B","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":"3963A1B"}],"inspection_per_units":[{"id":18611754,"change_date":null,"inspection_id":"81533092","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2488500","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ7HN991400","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":5576862,"change_date":"2024-04-24 21:42:00","inspection_id":"81422806","dot_number":"9997","report_state":"OR","report_number":"AANG000613","insp_date":"2024-04-22 00:00:00","insp_start_time":"0824","insp_end_time":"0837","registration_date":null,"region":"PT","ci_status_code":"C","location":"3466","location_desc":"WASHINGTON COUNTY MCSAP","county_code_state":"OR","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247124","transaction_code":"C","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-23 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18610304,"change_date":null,"inspection_id":"81422806","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2488236","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH9HN983702","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":18767086,"change_date":null,"inspection_id":"81422806","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"P839519","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V38CXLT967003","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":5252662,"change_date":"2024-03-11 21:42:00","inspection_id":"81068988","dot_number":"9997","report_state":"WA","report_number":"2126000131","insp_date":"2024-03-04 00:00:00","insp_start_time":"0810","insp_end_time":"0845","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC54","location_desc":"PLYMOUTH WA","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PORTLAND","shipping_paper_number":"1130814","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-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"308307","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-03-11 21:42:00","snet_input_date":"2024-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-11 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"26250 SW PARKWAY CENTER DRIVE","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:42.000000Z","updated_at":"2025-03-17T20:06:42.000000Z","inspection_violations":[{"id":18390555,"change_date":null,"inspection_id":"81068988","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-CSLRR","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":"39311A1CSLRR"},{"id":18390556,"change_date":null,"inspection_id":"81068988","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","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":"39375A3TAOL"}],"inspection_per_units":[{"id":18683323,"change_date":null,"inspection_id":"81068988","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"2488844","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ7JN889102","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":18762007,"change_date":null,"inspection_id":"81068988","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"P962345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V482C2HT816001","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":4746874,"change_date":"2024-01-31 21:42:00","inspection_id":"80516453","dot_number":"9997","report_state":"OR","report_number":"AAMT001075","insp_date":"2023-12-30 00:00:00","insp_start_time":"0533","insp_end_time":"0539","registration_date":"2024-01-31 00:00:00","region":"PT","ci_status_code":"C","location":"3466","location_desc":"WASHINGTON COUNTY MCSAP","county_code_state":"OR","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-02 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1239963","transaction_code":"C","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-01-02 21:44:00","snet_input_date":"2024-01-02 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-02 21:44:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:56:53.000000Z","updated_at":"2025-03-17T19:56:53.000000Z","inspection_violations":[{"id":18381364,"change_date":null,"inspection_id":"80516453","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","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":"3939BRKLAMP"},{"id":18381365,"change_date":null,"inspection_id":"80516453","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","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":"3939T"}],"inspection_per_units":[{"id":18675963,"change_date":null,"inspection_id":"80516453","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YAJX372","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4MC9EG38N498877","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":18753861,"change_date":null,"inspection_id":"80516453","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PC93794","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K3PJ133017","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":4746869,"change_date":"2024-01-31 21:42:00","inspection_id":"80516447","dot_number":"9997","report_state":"OR","report_number":"AAK3008222","insp_date":"2023-12-29 00:00:00","insp_start_time":"0849","insp_end_time":"0928","registration_date":"2024-01-31 00:00:00","region":"PT","ci_status_code":"C","location":"1807","location_desc":"KLAMATH FALLS POE","county_code_state":"OR","county_code":"035","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"1123053","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":"2024-01-02 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1239987","transaction_code":"C","transaction_date":"2023-12-29 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2024-01-02 21:44:00","snet_input_date":"2024-01-02 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-02 21:44:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:56:53.000000Z","updated_at":"2025-03-17T19:56:53.000000Z","inspection_violations":[{"id":18381363,"change_date":null,"inspection_id":"80516447","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","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":"39375A3"}],"inspection_per_units":[{"id":18675962,"change_date":null,"inspection_id":"80516447","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"2488843","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EJ5JN889101","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":4324374,"change_date":"2023-10-31 21:40:00","inspection_id":"80052197","dot_number":"9997","report_state":"OR","report_number":"AAAU002527","insp_date":"2023-10-30 00:00:00","insp_start_time":"1241","insp_end_time":"1306","registration_date":null,"region":"PT","ci_status_code":"C","location":"2704","location_desc":"FORT HILL - E OF VALLEY JCT","county_code_state":"OR","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"1116521","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236659","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-10-31 21:40:00","snet_input_date":"2023-10-31 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-10-31 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:48:42.000000Z","updated_at":"2025-03-17T19:48:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4294691,"change_date":"2023-10-26 21:41:00","inspection_id":"80019375","dot_number":"9997","report_state":"OR","report_number":"AANL000551","insp_date":"2023-10-25 00:00:00","insp_start_time":"1201","insp_end_time":"1212","registration_date":"2023-10-26 00:00:00","region":"PT","ci_status_code":"C","location":"0304","location_desc":"ROCK CREEK - 2 MI E CLACKAMAS","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","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":"I","final_status_date":"2023-10-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"105500","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236457","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-26 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:47:53.000000Z","updated_at":"2025-03-17T19:47:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4116347,"change_date":"2023-10-03 21:41:00","inspection_id":"79822224","dot_number":"9997","report_state":"WA","report_number":"W335001420","insp_date":"2023-10-02 00:00:00","insp_start_time":"0830","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"1113076","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":"I","final_status_date":"2023-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2595420","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-10-03 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:05.000000Z","updated_at":"2025-03-17T19:44:05.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4035233,"change_date":"2023-09-22 21:39:00","inspection_id":"79731971","dot_number":"9997","report_state":"OR","report_number":"AAQB000189","insp_date":"2023-09-21 00:00:00","insp_start_time":"1315","insp_end_time":"1331","registration_date":null,"region":"PT","ci_status_code":"C","location":"0304","location_desc":"ROCK CREEK - 2 MI E CLACKAMAS","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"I","final_status_date":"2023-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233852","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-09-22 21:39:00","snet_input_date":"2023-09-22 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3935934,"change_date":"2023-09-08 21:41:00","inspection_id":"79621709","dot_number":"9997","report_state":"WA","report_number":"W739001260","insp_date":"2023-09-07 00:00:00","insp_start_time":"0900","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"1110052","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-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2590997","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-08 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3770087,"change_date":"2023-08-21 21:42:00","inspection_id":"79436484","dot_number":"9997","report_state":"WA","report_number":"W439000611","insp_date":"2023-08-15 00:00:00","insp_start_time":"0859","insp_end_time":"0918","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"DUSTY","county_code_state":"WA","county_code":"075","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"DAIRY QUEEN","shipping_paper_number":"2002","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-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"2587096","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:17.000000Z","updated_at":"2025-03-17T19:37:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3747708,"change_date":"2023-08-15 21:43:00","inspection_id":"79411544","dot_number":"9997","report_state":"WA","report_number":"W538000737","insp_date":"2023-08-10 00:00:00","insp_start_time":"1016","insp_end_time":"1056","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"552507257","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":"I","final_status_date":"2023-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2586644","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-08-15 21:43:00","snet_input_date":"2023-08-15 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-15 21:43:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:53.000000Z","updated_at":"2025-03-17T19:36:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3524176,"change_date":"2023-07-17 21:41:00","inspection_id":"79161229","dot_number":"9997","report_state":"WA","report_number":"A401000635","insp_date":"2023-07-14 00:00:00","insp_start_time":"1214","insp_end_time":"1255","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC64","location_desc":"SC64   EAST SPOKANE (POE)","county_code_state":"WA","county_code":"063","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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":"I","final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2581831","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-17 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3195093,"change_date":"2023-06-20 21:41:00","inspection_id":"78790909","dot_number":"9997","report_state":"OR","report_number":"AASC010660","insp_date":"2023-05-31 00:00:00","insp_start_time":"0845","insp_end_time":"0945","registration_date":"2023-06-20 00:00:00","region":"PT","ci_status_code":"C","location":"2006","location_desc":"NOTI - 1.2 MI E NOTI","county_code_state":"OR","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO 052","shipping_paper_number":"OPMF10RB","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-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1226102","transaction_code":"C","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-06-01 21:43:00","snet_input_date":"2023-06-01 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:26:08.000000Z","updated_at":"2025-03-17T19:26:08.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2751279,"change_date":"2023-04-06 21:40:00","inspection_id":"78289326","dot_number":"9997","report_state":"WA","report_number":"W523003286","insp_date":"2023-04-04 00:00:00","insp_start_time":"1458","insp_end_time":"1516","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"552233382","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":"I","final_status_date":"2023-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"105501","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":"2563259","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-06 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2688829,"change_date":"2023-03-29 21:42:00","inspection_id":"78218050","dot_number":"9997","report_state":"WA","report_number":"W708010460","insp_date":"2023-03-28 00:00:00","insp_start_time":"0851","insp_end_time":"0908","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC38","location_desc":"SC38   STANWOOD BRYANT","county_code_state":"WA","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66001","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2561502","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-03-29 21:42:00","snet_input_date":"2023-03-29 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:13.000000Z","updated_at":"2025-03-17T19:16:13.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2697627,"change_date":"2023-03-30 21:41:00","inspection_id":"78228153","dot_number":"9997","report_state":"WA","report_number":"W538000426","insp_date":"2023-03-24 00:00:00","insp_start_time":"1126","insp_end_time":"1139","registration_date":null,"region":"PT","ci_status_code":"C","location":"50699","location_desc":"I-5 N","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1089971","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":"I","final_status_date":"2023-03-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2561797","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-03-30 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-03-30 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:16.000000Z","updated_at":"2025-03-17T19:16:16.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2810818,"change_date":"2023-04-14 21:42:00","inspection_id":"78356570","dot_number":"9997","report_state":"WA","report_number":"W501016636","insp_date":"2023-03-23 00:00:00","insp_start_time":"1456","insp_end_time":"1509","registration_date":null,"region":"PT","ci_status_code":"C","location":"06","location_desc":"TIMMINS \/ NW LA CENTER RD","county_code_state":"WA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","pen_cen_match":"I","final_status_date":"2023-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2564624","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-04-14 21:42:00","snet_input_date":"2023-04-14 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-04-14 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:31.000000Z","updated_at":"2025-03-17T19:18:31.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2416168,"change_date":"2023-03-14 21:42:00","inspection_id":"77907646","dot_number":"9997","report_state":"WA","report_number":"W119001397","insp_date":"2023-02-20 00:00:00","insp_start_time":"0742","insp_end_time":"0754","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC07","location_desc":"SC07   FT LEWIS NORTHBOUND","county_code_state":"WA","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"ELMERS","shipping_paper_number":"1086002","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":"I","final_status_date":"2023-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"2553512","transaction_code":"C","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-02-21 21:42:00","snet_input_date":"2023-02-21 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:06.000000Z","updated_at":"2025-03-17T19:11:06.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2256247,"change_date":"2023-10-26 21:41:00","inspection_id":"77725334","dot_number":"9997","report_state":"OR","report_number":"AAMT000792","insp_date":"2023-01-28 00:00:00","insp_start_time":"1002","insp_end_time":"1007","registration_date":"2023-10-26 00:00:00","region":"PT","ci_status_code":"C","location":"3466","location_desc":"WASHINGTON COUNTY MCSAP","county_code_state":"OR","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"1217865","transaction_code":"C","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-30 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:08:10.000000Z","updated_at":"2025-03-17T19:08:10.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1891903,"change_date":"2022-12-07 21:40:00","inspection_id":"77308450","dot_number":"9997","report_state":"OR","report_number":"AADR002255","insp_date":"2022-12-06 00:00:00","insp_start_time":"1243","insp_end_time":"1253","registration_date":null,"region":"PT","ci_status_code":"C","location":"0304","location_desc":"ROCK CREEK - 2 MI E CLACKAMAS","county_code_state":"OR","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO PORTLAND INC","shipping_paper_number":"1077057","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-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1215004","transaction_code":"A","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-12-07 21:40:00","snet_input_date":"2022-12-07 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-12-07 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:01:30.000000Z","updated_at":"2025-03-17T19:01:30.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1853824,"change_date":"2023-05-11 21:42:00","inspection_id":"77264810","dot_number":"9997","report_state":"OR","report_number":"AAMT000742","insp_date":"2022-11-30 00:00:00","insp_start_time":"1111","insp_end_time":"1132","registration_date":"2022-12-08 00:00:00","region":"PT","ci_status_code":"C","location":"3466","location_desc":"WASHINGTON COUNTY MCSAP","county_code_state":"OR","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"I","final_status_date":"2022-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"1214795","transaction_code":"C","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-12-01 21:42:00","snet_input_date":"2022-12-01 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-12-01 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:00:46.000000Z","updated_at":"2025-03-17T19:00:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1844405,"change_date":"2022-11-30 21:40:00","inspection_id":"77254038","dot_number":"9997","report_state":"OR","report_number":"AADT001168","insp_date":"2022-11-29 00:00:00","insp_start_time":"1144","insp_end_time":"1228","registration_date":null,"region":"PT","ci_status_code":"C","location":"1603","location_desc":"JUNIPER BUTTE NB","county_code_state":"OR","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"1076188","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-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1214664","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-11-30 21:40:00","snet_input_date":"2022-11-30 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T19:00:43.000000Z","updated_at":"2025-03-17T19:00:43.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1755763,"change_date":"2022-12-08 21:41:00","inspection_id":"77152457","dot_number":"9997","report_state":"OR","report_number":"AADT001155","insp_date":"2022-11-15 00:00:00","insp_start_time":"1308","insp_end_time":"1343","registration_date":"2022-12-08 00:00:00","region":"PT","ci_status_code":"C","location":"1603","location_desc":"JUNIPER BUTTE NB","county_code_state":"OR","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO PORTLAND INC","shipping_paper_number":"1074584","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-11-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1214109","transaction_code":"C","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-11-16 21:41:00","snet_input_date":"2022-11-16 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-11-16 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T18:58:58.000000Z","updated_at":"2025-03-17T18:58:58.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1744365,"change_date":"2022-11-15 21:40:00","inspection_id":"77139313","dot_number":"9997","report_state":"OR","report_number":"AASM001359","insp_date":"2022-11-14 00:00:00","insp_start_time":"1310","insp_end_time":"1352","registration_date":"2022-11-15 00:00:00","region":"PT","ci_status_code":"C","location":"2006","location_desc":"NOTI - 1.2 MI E NOTI","county_code_state":"OR","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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":"I","final_status_date":"2022-11-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1213974","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-11-15 21:40:00","snet_input_date":"2022-11-15 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T18:58:54.000000Z","updated_at":"2025-03-17T18:58:54.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1379459,"change_date":"2022-11-15 21:40:00","inspection_id":"76718827","dot_number":"9997","report_state":"OR","report_number":"AAMS002258","insp_date":"2022-09-26 00:00:00","insp_start_time":"0500","insp_end_time":"0524","registration_date":"2022-11-15 00:00:00","region":"PT","ci_status_code":"C","location":"0366","location_desc":"CLACKAMAS COUNTY ROADSIDE","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"105500","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":"1210648","transaction_code":"C","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-09-27 21:40:00","snet_input_date":"2022-09-26 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T18:52:02.000000Z","updated_at":"2025-03-17T18:52:02.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1276802,"change_date":"2022-09-17 21:30:00","inspection_id":"76599346","dot_number":"9997","report_state":"WA","report_number":"A020001974","insp_date":"2022-09-12 00:00:00","insp_start_time":"0840","insp_end_time":"0925","registration_date":null,"region":"PT","ci_status_code":"C","location":"50699","location_desc":"RIDGEFIELD","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1066531","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":"I","final_status_date":"2022-09-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80001","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":"2520259","transaction_code":"C","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-09-13 21:41:00","snet_input_date":"2022-09-13 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-09-13 21:41:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:09.000000Z","updated_at":"2025-03-17T18:50:09.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1253841,"change_date":"2022-09-10 21:30:00","inspection_id":"76572723","dot_number":"9997","report_state":"WA","report_number":"W735001659","insp_date":"2022-09-07 00:00:00","insp_start_time":"1115","insp_end_time":"1207","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC33","location_desc":"SC33   BOW HILL (POE)","county_code_state":"WA","county_code":"057","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2022-09-10 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2519833","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-09-10 21:30:00","snet_input_date":"2022-09-09 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-09-10 21:30:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":595384,"change_date":"2022-07-07 21:42:00","inspection_id":"75803002","dot_number":"9997","report_state":"OR","report_number":"AANP000616","insp_date":"2022-06-06 00:00:00","insp_start_time":"1123","insp_end_time":"1133","registration_date":"2022-07-07 00:00:00","region":"PT","ci_status_code":"C","location":"0366","location_desc":"CLACKAMAS COUNTY ROADSIDE","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"OLYMPIC PROVISIONS","shipping_paper_number":"78072","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"105500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1204244","transaction_code":"C","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-06-13 21:42:00","snet_input_date":"2022-06-13 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-06-13 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T18:38:07.000000Z","updated_at":"2025-03-17T18:38:07.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":490708,"change_date":"2022-11-15 21:40:00","inspection_id":"75678420","dot_number":"9997","report_state":"OR","report_number":"AAMT000580","insp_date":"2022-05-25 00:00:00","insp_start_time":"1300","insp_end_time":"1358","registration_date":"2022-11-15 00:00:00","region":"PT","ci_status_code":"C","location":"3477","location_desc":"WASHINGTON COUNTY ROADSIDE","county_code_state":"OR","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1203836","transaction_code":"C","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"035278","created_at":"2025-03-17T18:36:20.000000Z","updated_at":"2025-03-17T18:36:20.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":177291,"change_date":"2022-04-14 21:42:00","inspection_id":"75304859","dot_number":"9997","report_state":"WA","report_number":"B306000190","insp_date":"2022-04-12 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC55","location_desc":"SC55   PASCO","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"I","final_status_date":"2022-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"2486732","transaction_code":"A","transaction_date":"2022-04-12 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00009997","upload_search_indicator":null,"census_search_date":"2022-04-14 21:42:00","snet_input_date":"2022-04-13 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-04-14 21:42:00","insp_carrier_name":"SYSCO PORTLAND INC","insp_carrier_street":"PO BOX 527","insp_carrier_city":"WILSONVILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97070","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:32.000000Z","updated_at":"2025-03-17T18:30:32.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/9997\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/9997\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/9997\/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\/9997\/inspections","per_page":100,"prev_page_url":null,"to":51,"total":51}