{"current_page":1,"data":[{"id":12467099,"change_date":"2026-07-16 21:42:00","inspection_id":"88428010","dot_number":"4150366","report_state":"CA","report_number":"NDN6010654","insp_date":"2026-07-14 00:00:00","insp_start_time":"1100","insp_end_time":"1137","registration_date":null,"region":"PD","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"3767828","transaction_code":"A","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2026-07-16 21:42:00","snet_input_date":"2026-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-16 21:42:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-19T09:41:09.000000Z","updated_at":"2026-07-27T09:30:50.000000Z","inspection_violations":[{"id":21705430,"change_date":"2026-07-16 21:42:00","inspection_id":"88428010","insp_violation_id":"275546977","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214648930","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA733698","created_at":"2026-07-19T10:03:56.000000Z","updated_at":"2026-07-27T09:43:11.000000Z","normalized_code":"3922SLLEQP"},{"id":21705431,"change_date":"2026-07-16 21:42:00","inspection_id":"88428010","insp_violation_id":"275546978","seq_no":"2","part_no":"393","part_no_section":"47A-LJN","insp_viol_unit":"1","insp_unit_id":"214648930","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA733698","created_at":"2026-07-19T10:03:56.000000Z","updated_at":"2026-07-27T09:43:11.000000Z","normalized_code":"39347ALJN"}],"inspection_per_units":[{"id":21654175,"change_date":"2026-07-16 21:42:00","inspection_id":"88428010","insp_unit_id":"214648930","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:24.000000Z","updated_at":"2026-07-27T09:02:26.000000Z"},{"id":21654176,"change_date":"2026-07-16 21:42:00","inspection_id":"88428010","insp_unit_id":"214648931","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"JDTZ 1017","insp_unit_license":"4XE2709","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C402S7FT568146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:24.000000Z","updated_at":"2026-07-27T09:02:26.000000Z"}]},{"id":11600095,"change_date":"2026-04-08 21:38:00","inspection_id":"87526948","dot_number":"4150366","report_state":"CA","report_number":"UEAO006130","insp_date":"2026-04-07 00:00:00","insp_start_time":"1013","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"16239217","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:45.000000Z","updated_at":"2026-04-19T09:33:49.000000Z","inspection_violations":[{"id":19618502,"change_date":"2026-04-08 21:38:00","inspection_id":"87526948","insp_violation_id":"272947940","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"212614549","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA733384","created_at":"2026-04-11T10:03:38.000000Z","updated_at":"2026-04-18T10:49:45.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":19883373,"change_date":"2026-04-08 21:38:00","inspection_id":"87526948","insp_unit_id":"212614548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"9G74179","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:48.000000Z","updated_at":"2026-04-18T09:39:40.000000Z"},{"id":19883374,"change_date":"2026-04-08 21:38:00","inspection_id":"87526948","insp_unit_id":"212614549","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4XD4680","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C3MT275535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:48.000000Z","updated_at":"2026-04-18T09:39:40.000000Z"}]},{"id":11458822,"change_date":"2026-03-23 21:52:00","inspection_id":"87376658","dot_number":"4150366","report_state":"CA","report_number":"UEAO006090","insp_date":"2026-03-19 00:00:00","insp_start_time":"1702","insp_end_time":"1715","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:52: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":"16217749","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2026-03-23 21:52:00","snet_input_date":"2026-03-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-23 21:52:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:50.000000Z","updated_at":"2026-04-03T09:34:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19625497,"change_date":"2026-03-23 21:52:00","inspection_id":"87376658","insp_unit_id":"212296319","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XRED","insp_unit_license":"9G63183","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56FLGM3382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:56.000000Z","updated_at":"2026-04-03T09:08:00.000000Z"}]},{"id":11291577,"change_date":"2026-03-04 21:41:00","inspection_id":"87206849","dot_number":"4150366","report_state":"CA","report_number":"NDN6010241","insp_date":"2026-03-03 00:00:00","insp_start_time":"1230","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16193029","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2026-03-04 21:41:00","snet_input_date":"2026-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-04 21:41:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2026-03-07T10:39:16.000000Z","updated_at":"2026-03-15T09:31:24.000000Z","inspection_violations":[{"id":18988572,"change_date":"2026-03-04 21:41:00","inspection_id":"87206849","insp_violation_id":"272205264","seq_no":"1","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:58:02.000000Z","updated_at":"2026-03-15T09:42:49.000000Z","normalized_code":"3958A"},{"id":18988573,"change_date":"2026-03-04 21:41:00","inspection_id":"87206849","insp_violation_id":"272205265","seq_no":"2","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"211974470","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 771635","created_at":"2026-03-07T10:58:02.000000Z","updated_at":"2026-03-15T09:42:49.000000Z","normalized_code":"393207ASTBW"},{"id":18988574,"change_date":"2026-03-04 21:41:00","inspection_id":"87206849","insp_violation_id":"272205266","seq_no":"3","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"211974470","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:58:02.000000Z","updated_at":"2026-03-15T09:42:49.000000Z","normalized_code":"393207ASTBW"}],"inspection_per_units":[{"id":19312863,"change_date":"2026-03-04 21:41:00","inspection_id":"87206849","insp_unit_id":"211974470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X RED TT","insp_unit_license":"9G63183","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56FLGM3382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:50.000000Z","updated_at":"2026-03-15T09:06:34.000000Z"},{"id":19312864,"change_date":"2026-03-04 21:41:00","inspection_id":"87206849","insp_unit_id":"211974471","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"JIND","insp_unit_company":"TAXZ 448062","insp_unit_license":"3435713","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"KR1GV4021XD101729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:50.000000Z","updated_at":"2026-03-15T09:06:34.000000Z"}]},{"id":11211453,"change_date":"2026-02-23 21:39:00","inspection_id":"87122693","dot_number":"4150366","report_state":"CA","report_number":"UEX8005236","insp_date":"2026-02-19 00:00:00","insp_start_time":"1317","insp_end_time":"1344","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"16180654","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2026-02-23 21:39:00","snet_input_date":"2026-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-23 21:39:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-26T10:37:05.000000Z","updated_at":"2026-03-06T10:31:26.000000Z","inspection_violations":[{"id":18800783,"change_date":"2026-02-23 21:39:00","inspection_id":"87122693","insp_violation_id":"271975535","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211780241","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA771622","created_at":"2026-02-26T10:51:16.000000Z","updated_at":"2026-03-06T10:42:31.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":19144728,"change_date":"2026-02-23 21:39:00","inspection_id":"87122693","insp_unit_id":"211780241","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X RED","insp_unit_license":"9G63183","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56FLGM3382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:20.000000Z","updated_at":"2026-03-06T10:04:24.000000Z"},{"id":19144729,"change_date":"2026-02-23 21:39:00","inspection_id":"87122693","insp_unit_id":"211780242","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"JDTZ 1010","insp_unit_license":"4XA9342","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S03T325476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:20.000000Z","updated_at":"2026-03-06T10:04:24.000000Z"}]},{"id":11123193,"change_date":"2026-02-12 21:41:00","inspection_id":"87036303","dot_number":"4150366","report_state":"CA","report_number":"NE1M007726","insp_date":"2026-02-10 00:00:00","insp_start_time":"0929","insp_end_time":"0957","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126150","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16168123","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2026-02-15T10:38:53.000000Z","updated_at":"2026-02-23T10:31:23.000000Z","inspection_violations":[{"id":18629263,"change_date":"2026-02-12 21:41:00","inspection_id":"87036303","insp_violation_id":"271773905","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"211602443","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ35183","created_at":"2026-02-15T10:55:35.000000Z","updated_at":"2026-02-23T10:40:32.000000Z","normalized_code":"3939ALFTSI"},{"id":18629264,"change_date":"2026-02-12 21:41:00","inspection_id":"87036303","insp_violation_id":"271773906","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211602443","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:35.000000Z","updated_at":"2026-02-23T10:40:32.000000Z","normalized_code":"39347E"},{"id":18629265,"change_date":"2026-02-12 21:41:00","inspection_id":"87036303","insp_violation_id":"271773907","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"211602443","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:35.000000Z","updated_at":"2026-02-23T10:40:32.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":18971149,"change_date":"2026-02-12 21:41:00","inspection_id":"87036303","insp_unit_id":"211602444","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"TSXZ 429633","insp_unit_license":"254755F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41262LT017984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:13.000000Z","updated_at":"2026-02-23T10:04:03.000000Z"},{"id":18971148,"change_date":"2026-02-12 21:41:00","inspection_id":"87036303","insp_unit_id":"211602443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88\/3XWHT","insp_unit_license":"9G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:13.000000Z","updated_at":"2026-02-23T10:04:03.000000Z"}]},{"id":10324520,"change_date":"2025-12-01 21:39:00","inspection_id":"86451295","dot_number":"4150366","report_state":"CA","report_number":"UE2C006196","insp_date":"2025-11-21 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"16068397","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:46.000000Z","updated_at":"2025-12-05T10:31:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17241958,"change_date":"2025-12-01 21:39:00","inspection_id":"86451295","insp_unit_id":"210342665","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X RED","insp_unit_license":"9G63183","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56FLGM3382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:48.000000Z","updated_at":"2025-12-05T10:02:19.000000Z"},{"id":17241959,"change_date":"2025-12-01 21:39:00","inspection_id":"86451295","insp_unit_id":"210342666","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HERC","insp_unit_company":"TSXZ 421372","insp_unit_license":"4015963","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5K8CG40203H000642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:48.000000Z","updated_at":"2025-12-05T10:02:19.000000Z"}]},{"id":9405605,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","dot_number":"4150366","report_state":"CA","report_number":"NE28006068","insp_date":"2025-07-29 00:00:00","insp_start_time":"1550","insp_end_time":"1635","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15935239","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2025-08-13 21:39:00","snet_input_date":"2025-07-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"6371288","created_at":"2025-08-16T10:01:27.000000Z","updated_at":"2025-08-17T10:00:58.000000Z","inspection_violations":[{"id":15295871,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","insp_violation_id":"268013133","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208384548","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:17.000000Z","updated_at":"2025-08-17T10:44:47.000000Z","normalized_code":"39347E"},{"id":15295872,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","insp_violation_id":"268013134","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"208384548","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:17.000000Z","updated_at":"2025-08-17T10:44:47.000000Z","normalized_code":"39347E"},{"id":15295873,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","insp_violation_id":"268013135","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208384548","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-16T10:45:17.000000Z","updated_at":"2025-08-17T10:44:47.000000Z","normalized_code":"3963A1BOS"},{"id":15295874,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","insp_violation_id":"268013136","seq_no":"4","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"208384547","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:17.000000Z","updated_at":"2025-08-17T10:44:47.000000Z","normalized_code":"39311A1LFTSM"}],"inspection_per_units":[{"id":15501601,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","insp_unit_id":"208384547","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3382","insp_unit_license":"9G63183","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLD56FLGM3382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:41.000000Z","updated_at":"2025-08-17T09:46:09.000000Z"},{"id":15501602,"change_date":"2025-08-13 21:39:00","inspection_id":"85485272","insp_unit_id":"208384548","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FLGZ 431708","insp_unit_license":"T620519","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S0NT404208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:41.000000Z","updated_at":"2025-08-17T09:46:09.000000Z"}]},{"id":9442999,"change_date":"2025-08-18 21:40:00","inspection_id":"85524850","dot_number":"4150366","report_state":"CA","report_number":"UD5V001059","insp_date":"2025-07-27 00:00:00","insp_start_time":"1545","insp_end_time":"1610","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B LIVERMORE SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"15940209","transaction_code":"A","transaction_date":"2025-07-27 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2025-08-18 21:40:00","snet_input_date":"2025-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-18 21:40:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2025-08-23T10:46:07.000000Z","updated_at":"2025-08-23T10:46:07.000000Z","inspection_violations":[{"id":15373615,"change_date":"2025-08-18 21:40:00","inspection_id":"85524850","insp_violation_id":"268101011","seq_no":"1","part_no":"393","part_no_section":"126B-CIM","insp_viol_unit":"2","insp_unit_id":"208457488","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA517480","created_at":"2025-08-21T10:42:42.000000Z","updated_at":"2025-08-22T10:44:30.000000Z","normalized_code":"393126BCIM"},{"id":15373616,"change_date":"2025-08-18 21:40:00","inspection_id":"85524850","insp_violation_id":"268101012","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208457487","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:42.000000Z","updated_at":"2025-08-22T10:44:30.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":15569382,"change_date":"2025-08-18 21:40:00","inspection_id":"85524850","insp_unit_id":"208457487","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:50.000000Z","updated_at":"2025-08-22T09:46:25.000000Z"},{"id":15569383,"change_date":"2025-08-18 21:40:00","inspection_id":"85524850","insp_unit_id":"208457488","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"DECZ 401272","insp_unit_license":"3137776","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1S12GC402SG709467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:50.000000Z","updated_at":"2025-08-22T09:46:25.000000Z"}]},{"id":9279697,"change_date":"2025-07-29 21:40:00","inspection_id":"85352975","dot_number":"4150366","report_state":"CA","report_number":"NE1M007021","insp_date":"2025-07-25 00:00:00","insp_start_time":"1037","insp_end_time":"1108","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15918143","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2025-07-29 21:40:00","snet_input_date":"2025-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-29 21:40:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"3039 19TH AVE","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94132","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2025-08-01T10:42:11.000000Z","updated_at":"2025-08-04T10:00:56.000000Z","inspection_violations":[{"id":15042415,"change_date":"2025-07-29 21:40:00","inspection_id":"85352975","insp_violation_id":"267728505","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208142736","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:31.000000Z","updated_at":"2025-08-02T10:43:13.000000Z","normalized_code":"39021TB1MC"},{"id":15042416,"change_date":"2025-07-29 21:40:00","inspection_id":"85352975","insp_violation_id":"267728506","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:31.000000Z","updated_at":"2025-08-02T10:43:13.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":15276765,"change_date":"2025-07-29 21:40:00","inspection_id":"85352975","insp_unit_id":"208142736","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"22","insp_unit_license":"9G74179","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:50.000000Z","updated_at":"2025-08-02T09:46:11.000000Z"},{"id":15276766,"change_date":"2025-07-29 21:40:00","inspection_id":"85352975","insp_unit_id":"208142737","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"JDTZ 003","insp_unit_license":"3819679","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S8ST011603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:50.000000Z","updated_at":"2025-08-02T09:46:11.000000Z"}]},{"id":8101940,"change_date":"2025-03-12 21:41:00","inspection_id":"84110933","dot_number":"4150366","report_state":"CA","report_number":"UE2C005319","insp_date":"2025-03-08 00:00:00","insp_start_time":"2200","insp_end_time":"2230","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"15736548","transaction_code":"A","transaction_date":"2025-03-08 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2025-03-12 21:41:00","snet_input_date":"2025-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-12 21:41:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:49.000000Z","updated_at":"2025-03-17T21:06:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13081176,"change_date":"2025-03-12 21:41:00","inspection_id":"84110933","insp_unit_id":"205770316","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:37.000000Z","updated_at":"2025-03-17T23:59:37.000000Z"},{"id":13081177,"change_date":"2025-03-12 21:41:00","inspection_id":"84110933","insp_unit_id":"205770317","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"TAXZ 447961","insp_unit_license":"5097459","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1S12GC400MB671575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:37.000000Z","updated_at":"2025-03-17T23:59:37.000000Z"}]},{"id":7310403,"change_date":"2024-11-30 21:33:00","inspection_id":"83279445","dot_number":"4150366","report_state":"CA","report_number":"UD5V000276","insp_date":"2024-11-27 00:00:00","insp_start_time":"1245","insp_end_time":"1259","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B LIVERMORE SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"125700","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":"15612015","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11792483,"change_date":"2024-11-30 21:33:00","inspection_id":"83279445","insp_unit_id":"204117166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"},{"id":11792484,"change_date":"2024-11-30 21:33:00","inspection_id":"83279445","insp_unit_id":"204117167","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"DECZ 401444","insp_unit_license":"2941045","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S8VT009189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"}]},{"id":6146267,"change_date":"2024-07-03 21:40:00","inspection_id":"82039880","dot_number":"4150366","report_state":"CA","report_number":"UD3C000465","insp_date":"2024-07-02 00:00:00","insp_start_time":"0805","insp_end_time":"0828","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125700","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":"15428545","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2025-03-17T20:24:35.000000Z","updated_at":"2025-03-17T20:24:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9900323,"change_date":"2024-07-03 21:40:00","inspection_id":"82039880","insp_unit_id":"201734401","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G74179","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:38.000000Z","updated_at":"2025-03-17T23:25:38.000000Z"},{"id":9900324,"change_date":"2024-07-03 21:40:00","inspection_id":"82039880","insp_unit_id":"201734402","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"TAXZ 445526","insp_unit_license":"5386185","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S6RT000304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:38.000000Z","updated_at":"2025-03-17T23:25:38.000000Z"}]},{"id":5987759,"change_date":"2024-06-13 21:42:00","inspection_id":"81869223","dot_number":"4150366","report_state":"CA","report_number":"NA5N007213","insp_date":"2024-06-11 00:00:00","insp_start_time":"0750","insp_end_time":"0838","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42: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":"15401910","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9290076,"change_date":"2024-06-13 21:42:00","inspection_id":"81869223","insp_violation_id":"260078578","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201387693","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:57.000000Z","updated_at":"2025-03-17T21:50:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9644761,"change_date":"2024-06-13 21:42:00","inspection_id":"81869223","insp_unit_id":"201387693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G74179","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"Y","insp_unit_decal_number":"33812329","created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9644762,"change_date":"2024-06-13 21:42:00","inspection_id":"81869223","insp_unit_id":"201387694","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"MONO","insp_unit_company":null,"insp_unit_license":"4ST9905","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NNC04022YM333747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5659082,"change_date":"2024-05-02 21:43:00","inspection_id":"81512364","dot_number":"4150366","report_state":"CA","report_number":"NA5N007147","insp_date":"2024-05-01 00:00:00","insp_start_time":"0811","insp_end_time":"0852","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"15346239","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:45.000000Z","updated_at":"2025-03-17T20:14:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9114978,"change_date":"2024-05-02 21:43:00","inspection_id":"81512364","insp_unit_id":"200705967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"4G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"Y","insp_unit_decal_number":"33811149","created_at":"2025-03-17T23:17:48.000000Z","updated_at":"2025-03-17T23:17:48.000000Z"},{"id":9114979,"change_date":"2024-05-02 21:43:00","inspection_id":"81512364","insp_unit_id":"200705968","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"ZZZ 0000","insp_unit_license":"4VT2187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S3NT405093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:48.000000Z","updated_at":"2025-03-17T23:17:48.000000Z"}]},{"id":5536971,"change_date":"2024-04-17 21:42:00","inspection_id":"81379404","dot_number":"4150366","report_state":"CA","report_number":"NDN6008395","insp_date":"2024-04-16 00:00:00","insp_start_time":"1401","insp_end_time":"1434","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15323627","transaction_code":"A","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-04-17 21:42:00","snet_input_date":"2024-04-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-17 21:42:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:23.000000Z","updated_at":"2025-03-17T20:12:23.000000Z","inspection_violations":[{"id":8555983,"change_date":"2024-04-17 21:42:00","inspection_id":"81379404","insp_violation_id":"258994389","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:26.000000Z","updated_at":"2025-03-17T21:47:26.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":8919006,"change_date":"2024-04-17 21:42:00","inspection_id":"81379404","insp_unit_id":"200452524","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X GRAY","insp_unit_license":"9G74179","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:59.000000Z","updated_at":"2025-03-17T23:15:59.000000Z"},{"id":8919007,"change_date":"2024-04-17 21:42:00","inspection_id":"81379404","insp_unit_id":"200452525","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"LTCZ 95635","insp_unit_license":"4UT4931","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S31T095635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:59.000000Z","updated_at":"2025-03-17T23:15:59.000000Z"}]},{"id":5464830,"change_date":"2024-04-08 21:45:00","inspection_id":"81300269","dot_number":"4150366","report_state":"CA","report_number":"UEEE002266","insp_date":"2024-04-06 00:00:00","insp_start_time":"1906","insp_end_time":"1926","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"126450","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":"15308959","transaction_code":"A","transaction_date":"2024-04-06 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-04-08 21:45:00","snet_input_date":"2024-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:45:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:08.000000Z","updated_at":"2025-03-17T20:11:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8802546,"change_date":"2024-04-08 21:45:00","inspection_id":"81300269","insp_unit_id":"200298192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"4G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"},{"id":8802547,"change_date":"2024-04-08 21:45:00","inspection_id":"81300269","insp_unit_id":"200298193","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"ZZZ 0000","insp_unit_license":"4VT2187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S3NT405093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"}]},{"id":5464938,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","dot_number":"4150366","report_state":"CA","report_number":"UE5M003513","insp_date":"2024-04-06 00:00:00","insp_start_time":"1245","insp_end_time":"1318","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"126450","viol_total":"12","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15310126","transaction_code":"A","transaction_date":"2024-04-06 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-04-08 21:45:00","snet_input_date":"2024-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:45:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2025-03-17T20:11:08.000000Z","updated_at":"2025-03-17T20:11:08.000000Z","inspection_violations":[{"id":8437425,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815281","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA589661","created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"3922"},{"id":8437426,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815282","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39021TB"},{"id":8437427,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815283","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39021TA"},{"id":8437428,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815284","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200298364","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA589661","created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"3939A"},{"id":8437429,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815285","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200298364","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KB19370","created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"3939A"},{"id":8437430,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815286","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39347E"},{"id":8437431,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815287","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39353B"},{"id":8437432,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815288","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200298364","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39347E"},{"id":8437433,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815289","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200298364","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39353B"},{"id":8437434,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815290","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"3963A1"},{"id":8437435,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815291","seq_no":"11","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200298363","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39347A"},{"id":8437436,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_violation_id":"258815292","seq_no":"12","part_no":"390","part_no_section":"21T(g)(3)","insp_viol_unit":"2","insp_unit_id":"200298364","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KB19370","created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39021TG3"}],"inspection_per_units":[{"id":8802706,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_unit_id":"200298363","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"4G99560","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKJ0072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"},{"id":8802707,"change_date":"2024-04-08 21:45:00","inspection_id":"81300382","insp_unit_id":"200298364","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"ZZZ 0000","insp_unit_license":"4VT2187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S3NT405093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"}]},{"id":4851043,"change_date":"2024-01-17 21:44:00","inspection_id":"80630250","dot_number":"4150366","report_state":"CA","report_number":"N9ZT005468","insp_date":"2024-01-16 00:00:00","insp_start_time":"1145","insp_end_time":"1230","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-17 21:44: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":"15204392","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:50.000000Z","updated_at":"2025-03-17T19:58:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7805237,"change_date":"2024-01-17 21:44:00","inspection_id":"80630250","insp_unit_id":"199000231","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"CF87V34","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"Y","insp_unit_decal_number":"33523177","created_at":"2025-03-17T23:05:46.000000Z","updated_at":"2025-03-17T23:05:46.000000Z"}]},{"id":4645365,"change_date":"2023-12-15 21:39:00","inspection_id":"80405634","dot_number":"4150366","report_state":"CA","report_number":"NEVK000284","insp_date":"2023-12-12 00:00:00","insp_start_time":"1738","insp_end_time":"1804","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"111500","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":"15170392","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04150366","upload_search_indicator":null,"census_search_date":"2023-12-15 21:39:00","snet_input_date":"2023-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-15 21:39:00","insp_carrier_name":"EXPRESSO HAULOGISTICS LLC","insp_carrier_street":"916 GREEN AVE","insp_carrier_city":"SAN BRUNO","insp_carrier_state":"CA","insp_carrier_zip_code":"94066","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"637128","created_at":"2025-03-17T19:54:56.000000Z","updated_at":"2025-03-17T19:54:56.000000Z","inspection_violations":[{"id":7182243,"change_date":"2023-12-15 21:39:00","inspection_id":"80405634","insp_violation_id":"256922164","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198537903","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3922"},{"id":7182244,"change_date":"2023-12-15 21:39:00","inspection_id":"80405634","insp_violation_id":"256922165","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198537903","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7471259,"change_date":"2023-12-15 21:39:00","inspection_id":"80405634","insp_unit_id":"198537903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHITE","insp_unit_license":"CF87V34","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHPDV3KSKL2909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"},{"id":7471260,"change_date":"2023-12-15 21:39:00","inspection_id":"80405634","insp_unit_id":"198537904","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4TR5657","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C242SX1T095025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4150366\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4150366\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4150366\/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\/4150366\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}