{"current_page":1,"data":[{"id":11930508,"change_date":"2026-05-15 21:44:00","inspection_id":"87865128","dot_number":"853165","report_state":"CA","report_number":"NARW004442","insp_date":"2026-05-13 00:00:00","insp_start_time":"0721","insp_end_time":"0747","registration_date":null,"region":"PS","ci_status_code":"C","location":"347","location_desc":"CA","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"87600","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":"3337594","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:36.000000Z","updated_at":"2026-05-26T09:31:48.000000Z","inspection_violations":[{"id":20752015,"change_date":"2026-05-15 21:44:00","inspection_id":"87865128","insp_violation_id":"274293426","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"213582964","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:01:11.000000Z","updated_at":"2026-05-26T09:45:08.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":20747531,"change_date":"2026-05-15 21:44:00","inspection_id":"87865128","insp_unit_id":"213582964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04\/WHT\/3X","insp_unit_license":"9E83671","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:52.000000Z","updated_at":"2026-05-26T09:04:11.000000Z"},{"id":20747532,"change_date":"2026-05-15 21:44:00","inspection_id":"87865128","insp_unit_id":"213582965","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CMIC","insp_unit_company":"UPHZ 166263","insp_unit_license":"U961271","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC54264JT025502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:52.000000Z","updated_at":"2026-05-26T09:04:11.000000Z"}]},{"id":11868034,"change_date":"2026-05-10 21:34:00","inspection_id":"87804928","dot_number":"853165","report_state":"CA","report_number":"UE2C006718","insp_date":"2026-05-07 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-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":"3294794","transaction_code":"A","transaction_date":"2026-05-10 00:00:00","upload_date":"2026-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":"2026-05-10 21:34:00","snet_input_date":"2026-05-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-10 21:34:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T09:38:38.000000Z","updated_at":"2026-05-21T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20636489,"change_date":"2026-05-10 21:34:00","inspection_id":"87804928","insp_unit_id":"213468553","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"5841JX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532W68L113771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T09:15:22.000000Z","updated_at":"2026-05-21T09:02:36.000000Z"},{"id":20636488,"change_date":"2026-05-10 21:34:00","inspection_id":"87804928","insp_unit_id":"213468552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E83672","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED60ESFS4055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T09:15:22.000000Z","updated_at":"2026-05-21T09:02:36.000000Z"}]},{"id":11548359,"change_date":"2026-04-01 21:40:00","inspection_id":"87471087","dot_number":"853165","report_state":"CA","report_number":"NDUP008158","insp_date":"2026-03-26 00:00:00","insp_start_time":"0602","insp_end_time":"0639","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","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-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"16230166","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2026-04-04T09:43:39.000000Z","updated_at":"2026-04-12T09:33:11.000000Z","inspection_violations":[{"id":19512844,"change_date":"2026-04-01 21:40:00","inspection_id":"87471087","insp_violation_id":"272811482","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"212491420","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:47.000000Z","updated_at":"2026-04-11T09:50:03.000000Z","normalized_code":"3963A1BALAC"},{"id":19512845,"change_date":"2026-04-01 21:40:00","inspection_id":"87471087","insp_violation_id":"272811483","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"212491420","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:47.000000Z","updated_at":"2026-04-11T09:50:03.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":19512846,"change_date":"2026-04-01 21:40:00","inspection_id":"87471087","insp_violation_id":"272811484","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212491420","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:47.000000Z","updated_at":"2026-04-11T09:50:03.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":19788073,"change_date":"2026-04-01 21:40:00","inspection_id":"87471087","insp_unit_id":"212491420","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#92 3XWHT","insp_unit_license":"9E83673","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:53.000000Z","updated_at":"2026-04-12T09:12:20.000000Z"},{"id":19788074,"change_date":"2026-04-01 21:40:00","inspection_id":"87471087","insp_unit_id":"212491421","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"DECZ 400996","insp_unit_license":"3049519","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5D7GC4024YC000719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:53.000000Z","updated_at":"2026-04-12T09:12:20.000000Z"}]},{"id":11302427,"change_date":"2026-03-05 21:40:00","inspection_id":"87218193","dot_number":"853165","report_state":"CA","report_number":"NE1M007811","insp_date":"2026-02-25 00:00:00","insp_start_time":"1149","insp_end_time":"1221","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-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128400","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":"16194373","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-05 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2026-03-08T09:44:17.000000Z","updated_at":"2026-03-16T09:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19333265,"change_date":"2026-03-05 21:40:00","inspection_id":"87218193","insp_unit_id":"211996294","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"9E83671","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"Y","insp_unit_decal_number":"35881173","created_at":"2026-03-08T09:25:21.000000Z","updated_at":"2026-03-16T09:04:43.000000Z"},{"id":19333266,"change_date":"2026-03-05 21:40:00","inspection_id":"87218193","insp_unit_id":"211996295","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"TSXZ 429628","insp_unit_license":"254626F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41265LT017851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:21.000000Z","updated_at":"2026-03-16T09:04:43.000000Z"}]},{"id":11088245,"change_date":"2026-02-09 21:39:00","inspection_id":"86999660","dot_number":"853165","report_state":"CA","report_number":"UDXH001519","insp_date":"2026-02-09 00:00:00","insp_start_time":"0935","insp_end_time":"1020","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"US-101 N\/B SOUTH OF I-280","county_code_state":"CA","county_code":"075","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127900","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":"16163932","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-09 21:39:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2026-02-12T10:37:07.000000Z","updated_at":"2026-02-20T10:31:16.000000Z","inspection_violations":[{"id":18562096,"change_date":"2026-02-09 21:39:00","inspection_id":"86999660","insp_violation_id":"271691164","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211528637","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:45.000000Z","updated_at":"2026-02-20T10:40:15.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18907778,"change_date":"2026-02-09 21:39:00","inspection_id":"86999660","insp_unit_id":"211528637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"719","insp_unit_license":"ZP10238","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X5JJ210562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:43.000000Z","updated_at":"2026-02-20T10:04:35.000000Z"},{"id":18907779,"change_date":"2026-02-09 21:39:00","inspection_id":"86999660","insp_unit_id":"211528638","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"DDTZ 328349","insp_unit_license":"293648T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"57VAA5329N2001364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:43.000000Z","updated_at":"2026-02-20T10:04:35.000000Z"}]},{"id":11121599,"change_date":"2026-02-12 21:41:00","inspection_id":"87034679","dot_number":"853165","report_state":"CA","report_number":"NATH005536","insp_date":"2026-02-09 00:00:00","insp_start_time":"0835","insp_end_time":"0903","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":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125650","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":"16169732","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2026-02-15T10:38:51.000000Z","updated_at":"2026-02-23T10:31:13.000000Z","inspection_violations":[{"id":18627731,"change_date":"2026-02-12 21:41:00","inspection_id":"87034679","insp_violation_id":"271772282","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211599769","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ35180","created_at":"2026-02-15T10:55:32.000000Z","updated_at":"2026-02-23T10:40:22.000000Z","normalized_code":"3922SLLSR"},{"id":18627732,"change_date":"2026-02-12 21:41:00","inspection_id":"87034679","insp_violation_id":"271772283","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211599769","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:32.000000Z","updated_at":"2026-02-23T10:40:22.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":18968579,"change_date":"2026-02-12 21:41:00","inspection_id":"87034679","insp_unit_id":"211599769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"9E83671","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:12.000000Z","updated_at":"2026-02-23T10:03:48.000000Z"},{"id":18968580,"change_date":"2026-02-12 21:41:00","inspection_id":"87034679","insp_unit_id":"211599770","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"THEU","insp_unit_company":"EMCZ 540836","insp_unit_license":"2656207","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1TA144026F1122573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:12.000000Z","updated_at":"2026-02-23T10:03:48.000000Z"}]},{"id":10602333,"change_date":"2026-01-08 21:40:00","inspection_id":"86741744","dot_number":"853165","report_state":"CA","report_number":"UD5V001454","insp_date":"2026-01-07 00:00:00","insp_start_time":"1050","insp_end_time":"1115","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":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"16120547","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2026-01-11T10:34:47.000000Z","updated_at":"2026-01-19T10:30:59.000000Z","inspection_violations":[{"id":17824346,"change_date":"2026-01-08 21:40:00","inspection_id":"86741744","insp_violation_id":"271094063","seq_no":"1","part_no":"393","part_no_section":"45A-BHTBS","insp_viol_unit":"1","insp_unit_id":"210983892","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA 516279","created_at":"2026-01-11T10:39:30.000000Z","updated_at":"2026-01-19T10:31:52.000000Z","normalized_code":"39345ABHTBS"},{"id":17824347,"change_date":"2026-01-08 21:40:00","inspection_id":"86741744","insp_violation_id":"271094064","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210983892","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN 87731","created_at":"2026-01-11T10:39:30.000000Z","updated_at":"2026-01-19T10:31:52.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17774713,"change_date":"2026-01-08 21:40:00","inspection_id":"86741744","insp_unit_id":"210983892","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9E83674","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:16.000000Z","updated_at":"2026-01-19T10:01:11.000000Z"},{"id":17774714,"change_date":"2026-01-08 21:40:00","inspection_id":"86741744","insp_unit_id":"210983893","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"FLGZ 4403","insp_unit_license":"293931T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1S12GC405RG691492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:16.000000Z","updated_at":"2026-01-19T10:01:11.000000Z"}]},{"id":10592570,"change_date":"2026-01-07 21:39:00","inspection_id":"86731432","dot_number":"853165","report_state":"CA","report_number":"UD6V001041","insp_date":"2026-01-05 00:00:00","insp_start_time":"0945","insp_end_time":"1019","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B LIVERMORE CVEF","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-01-07 21:39: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":"16119242","transaction_code":"A","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-07 21:39:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-10T10:34:43.000000Z","updated_at":"2026-01-18T10:32:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17755982,"change_date":"2026-01-07 21:39:00","inspection_id":"86731432","insp_unit_id":"210963518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3 AX WHT","insp_unit_license":"9E83672","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED60ESFS4055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:13.000000Z","updated_at":"2026-01-18T10:01:48.000000Z"},{"id":17755983,"change_date":"2026-01-07 21:39:00","inspection_id":"86731432","insp_unit_id":"210963519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"5002647","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V532K3PS564089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:13.000000Z","updated_at":"2026-01-18T10:01:48.000000Z"}]},{"id":10581677,"change_date":"2026-01-06 21:39:00","inspection_id":"86720064","dot_number":"853165","report_state":"CA","report_number":"UEX8005110","insp_date":"2026-01-02 00:00:00","insp_start_time":"1520","insp_end_time":"1551","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":"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"16115507","transaction_code":"A","transaction_date":"2026-01-02 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-06 21:39:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:33.000000Z","updated_at":"2026-01-17T10:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17734259,"change_date":"2026-01-06 21:39:00","inspection_id":"86720064","insp_unit_id":"210939120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"92 WHT","insp_unit_license":"9E83673","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:59.000000Z","updated_at":"2026-01-17T10:01:21.000000Z"},{"id":17734260,"change_date":"2026-01-06 21:39:00","inspection_id":"86720064","insp_unit_id":"210939121","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"ALLI","insp_unit_company":"FLXZ 426806","insp_unit_license":"T446679","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1LDC2420XEB843372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:59.000000Z","updated_at":"2026-01-17T10:01:21.000000Z"}]},{"id":10484799,"change_date":"2025-12-19 21:40:00","inspection_id":"86618919","dot_number":"853165","report_state":"CA","report_number":"UD5V001395","insp_date":"2025-12-18 00:00:00","insp_start_time":"1325","insp_end_time":"1340","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"16103088","transaction_code":"A","transaction_date":"2025-12-18 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-19 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-12-22T10:32:11.000000Z","updated_at":"2025-12-30T10:34:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17554835,"change_date":"2025-12-19 21:40:00","inspection_id":"86618919","insp_unit_id":"210731153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9E83672","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED60ESFS4055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:02:10.000000Z","updated_at":"2025-12-30T10:01:34.000000Z"},{"id":17554836,"change_date":"2025-12-19 21:40:00","inspection_id":"86618919","insp_unit_id":"210731154","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"FHCZ 448300","insp_unit_license":"U466401","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC4026241000934","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:02:10.000000Z","updated_at":"2025-12-30T10:01:34.000000Z"}]},{"id":10475371,"change_date":"2025-12-18 21:41:00","inspection_id":"86608992","dot_number":"853165","report_state":"CA","report_number":"UD5V001389","insp_date":"2025-12-17 00:00:00","insp_start_time":"1310","insp_end_time":"1335","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-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"16100948","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-18 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-12-21T10:32:00.000000Z","updated_at":"2025-12-29T10:31:31.000000Z","inspection_violations":[{"id":17576567,"change_date":"2025-12-18 21:41:00","inspection_id":"86608992","insp_violation_id":"270787100","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210704068","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-21T10:32:44.000000Z","updated_at":"2025-12-29T10:32:29.000000Z","normalized_code":"39395A1"},{"id":17576568,"change_date":"2025-12-18 21:41:00","inspection_id":"86608992","insp_violation_id":"270787101","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"210704068","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-21T10:32:44.000000Z","updated_at":"2025-12-29T10:32:29.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":17576569,"change_date":"2025-12-18 21:41:00","inspection_id":"86608992","insp_violation_id":"270787102","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210704068","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 734155","created_at":"2025-12-21T10:32:44.000000Z","updated_at":"2025-12-29T10:32:29.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":17535054,"change_date":"2025-12-18 21:41:00","inspection_id":"86608992","insp_unit_id":"210704068","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9E83672","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED60ESFS4055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:53.000000Z","updated_at":"2025-12-29T10:01:47.000000Z"},{"id":17535055,"change_date":"2025-12-18 21:41:00","inspection_id":"86608992","insp_unit_id":"210704069","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"FHCZ 448300","insp_unit_license":"U466401","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC4026241000934","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:53.000000Z","updated_at":"2025-12-29T10:01:47.000000Z"}]},{"id":10354116,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","dot_number":"853165","report_state":"CA","report_number":"NDN6010014","insp_date":"2025-12-02 00:00:00","insp_start_time":"1010","insp_end_time":"1100","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":"2025-12-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16082576","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-04 21:38:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-12-07T10:31:48.000000Z","updated_at":"2025-12-08T10:31:25.000000Z","inspection_violations":[{"id":17332267,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","insp_violation_id":"270472597","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"210424517","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-07T10:32:26.000000Z","updated_at":"2025-12-08T10:32:15.000000Z","normalized_code":"39345B2BHTD"},{"id":17332268,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","insp_violation_id":"270472598","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210424517","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ 79559","created_at":"2025-12-07T10:32:26.000000Z","updated_at":"2025-12-08T10:32:15.000000Z","normalized_code":"3922SLLSR"},{"id":17332269,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","insp_violation_id":"270472599","seq_no":"3","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"210424517","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:26.000000Z","updated_at":"2025-12-08T10:32:15.000000Z","normalized_code":"39345DBAAL"},{"id":17332270,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","insp_violation_id":"270472600","seq_no":"4","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"210424518","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA 770345","created_at":"2025-12-07T10:32:26.000000Z","updated_at":"2025-12-08T10:32:15.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":17303214,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","insp_unit_id":"210424517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9E83674","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:37.000000Z","updated_at":"2025-12-08T10:01:39.000000Z"},{"id":17303215,"change_date":"2025-12-04 21:38:00","inspection_id":"86482128","insp_unit_id":"210424518","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"DDRZ 991117","insp_unit_license":"U866804","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3X532S8WT008832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:37.000000Z","updated_at":"2025-12-08T10:01:39.000000Z"}]},{"id":9671503,"change_date":"2025-09-12 21:50:00","inspection_id":"85764571","dot_number":"853165","report_state":"CA","report_number":"NA5N008610","insp_date":"2025-09-11 00:00:00","insp_start_time":"1007","insp_end_time":"1059","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":"2025-09-12 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"126200","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":"15978432","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-12 21:50:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:43.000000Z","updated_at":"2025-09-16T10:48:43.000000Z","inspection_violations":[{"id":15855832,"change_date":"2025-09-12 21:50:00","inspection_id":"85764571","insp_violation_id":"268671331","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208932197","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:21.000000Z","updated_at":"2025-09-16T10:52:00.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16004882,"change_date":"2025-09-12 21:50:00","inspection_id":"85764571","insp_unit_id":"208932196","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9E83674","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:05.000000Z","updated_at":"2025-09-16T09:56:46.000000Z"},{"id":16004883,"change_date":"2025-09-12 21:50:00","inspection_id":"85764571","insp_unit_id":"208932197","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"TSXZ 152180","insp_unit_license":"3417889","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S34T202882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:05.000000Z","updated_at":"2025-09-16T09:56:46.000000Z"}]},{"id":9659247,"change_date":"2025-09-12 21:50:00","inspection_id":"85751642","dot_number":"853165","report_state":"CA","report_number":"UDBL004792","insp_date":"2025-09-08 00:00:00","insp_start_time":"1037","insp_end_time":"1101","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, LIVERMORE","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-09-11 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":"15976411","transaction_code":"C","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:48:07.000000Z","updated_at":"2025-09-16T10:48:31.000000Z","inspection_violations":[{"id":15851794,"change_date":"2025-09-12 21:50:00","inspection_id":"85751642","insp_violation_id":"268667039","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"208926395","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA770806","created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:41.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":15999889,"change_date":"2025-09-12 21:50:00","inspection_id":"85751642","insp_unit_id":"208926395","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"9E83674","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:02.000000Z","updated_at":"2025-09-16T09:56:26.000000Z"},{"id":15999890,"change_date":"2025-09-12 21:50:00","inspection_id":"85751642","insp_unit_id":"208926396","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"2XVAN\/WHT","insp_unit_license":"CC3119","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532C3KR112720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:02.000000Z","updated_at":"2025-09-16T09:56:26.000000Z"}]},{"id":9618428,"change_date":"2025-09-08 21:38:00","inspection_id":"85698211","dot_number":"853165","report_state":"CA","report_number":"NF37001578","insp_date":"2025-08-29 00:00:00","insp_start_time":"0540","insp_end_time":"1046","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"125800","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":"15968960","transaction_code":"C","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-09-10T10:46:09.000000Z","updated_at":"2025-09-11T10:46:13.000000Z","inspection_violations":[{"id":15730372,"change_date":"2025-09-08 21:38:00","inspection_id":"85698211","insp_violation_id":"268532702","seq_no":"1","part_no":"393","part_no_section":"207F-SLAS","insp_viol_unit":"1","insp_unit_id":"208809784","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:05.000000Z","updated_at":"2025-09-12T10:49:59.000000Z","normalized_code":"393207FSLAS"},{"id":15730373,"change_date":"2025-09-08 21:38:00","inspection_id":"85698211","insp_violation_id":"268532703","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"208809784","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"SC11018","created_at":"2025-09-11T10:48:05.000000Z","updated_at":"2025-09-12T10:49:59.000000Z","normalized_code":"3963A1BALR"},{"id":15730374,"change_date":"2025-09-08 21:38:00","inspection_id":"85698211","insp_violation_id":"268532704","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208809784","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:05.000000Z","updated_at":"2025-09-12T10:49:59.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":15887780,"change_date":"2025-09-08 21:38:00","inspection_id":"85698211","insp_unit_id":"208809784","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"92","insp_unit_license":"9E83673","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:38.000000Z","updated_at":"2025-09-12T10:46:50.000000Z"},{"id":15887781,"change_date":"2025-09-08 21:38:00","inspection_id":"85698211","insp_unit_id":"208809785","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"FLTZ 407640","insp_unit_license":"U552979","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3M2CG40291S003874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:38.000000Z","updated_at":"2025-09-12T10:46:50.000000Z"}]},{"id":9597515,"change_date":"2025-09-04 21:41:00","inspection_id":"85687181","dot_number":"853165","report_state":"CA","report_number":"UE2C005901","insp_date":"2025-08-21 00:00:00","insp_start_time":"1600","insp_end_time":"1630","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-09-04 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":"15967317","transaction_code":"A","transaction_date":"2025-08-21 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-04 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:35.000000Z","updated_at":"2025-09-10T10:45:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15846866,"change_date":"2025-09-04 21:41:00","inspection_id":"85687181","insp_unit_id":"208758239","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9E83674","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:54.000000Z","updated_at":"2025-09-10T09:46:19.000000Z"},{"id":15846867,"change_date":"2025-09-04 21:41:00","inspection_id":"85687181","insp_unit_id":"208758240","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"FLXZ 427644","insp_unit_license":"T441630","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"P618102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:54.000000Z","updated_at":"2025-09-10T09:46:19.000000Z"}]},{"id":9367486,"change_date":"2025-08-08 21:40:00","inspection_id":"85445249","dot_number":"853165","report_state":"CA","report_number":"NE8I004641","insp_date":"2025-08-07 00:00:00","insp_start_time":"1329","insp_end_time":"1346","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15930597","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-08 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-08-12T10:44:17.000000Z","updated_at":"2025-08-12T10:44:17.000000Z","inspection_violations":[{"id":15218715,"change_date":"2025-08-08 21:40:00","inspection_id":"85445249","insp_violation_id":"267926168","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"208311232","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:39.000000Z","updated_at":"2025-08-12T10:45:58.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":15433318,"change_date":"2025-08-08 21:40:00","inspection_id":"85445249","insp_unit_id":"208311231","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"92\/WHITE","insp_unit_license":"9E83673","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:28.000000Z","updated_at":"2025-08-12T09:46:16.000000Z"},{"id":15433319,"change_date":"2025-08-08 21:40:00","inspection_id":"85445249","insp_unit_id":"208311232","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNRC","insp_unit_company":"545938","insp_unit_license":"9538LM","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NNVX5329YM330155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:28.000000Z","updated_at":"2025-08-12T09:46:16.000000Z"}]},{"id":8718414,"change_date":"2025-05-22 21:43:00","inspection_id":"84760232","dot_number":"853165","report_state":"CA","report_number":"UBGJ006680","insp_date":"2025-05-20 00:00:00","insp_start_time":"1440","insp_end_time":"1511","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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-05-22 21:43: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":"15831735","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-22 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-25T10:06:17.000000Z","updated_at":"2025-05-26T10:07:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14250882,"change_date":"2025-05-22 21:43:00","inspection_id":"84760232","insp_unit_id":"207028891","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#04\/WHT","insp_unit_license":"9E83671","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:51:12.000000Z","updated_at":"2025-05-26T09:52:55.000000Z"},{"id":14250883,"change_date":"2025-05-22 21:43:00","inspection_id":"84760232","insp_unit_id":"207028892","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FHCZ 046313","insp_unit_license":"U379915","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S3VT007964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:51:12.000000Z","updated_at":"2025-05-26T09:52:55.000000Z"}]},{"id":8037174,"change_date":"2025-03-05 21:40:00","inspection_id":"84042849","dot_number":"853165","report_state":"CA","report_number":"NCNG008774","insp_date":"2025-02-25 00:00:00","insp_start_time":"0747","insp_end_time":"0825","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":"N\/A","shipping_paper_number":"0091933","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-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"15728151","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"100155","created_at":"2025-03-17T21:04:59.000000Z","updated_at":"2025-03-17T21:04:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12975537,"change_date":"2025-03-05 21:40:00","inspection_id":"84042849","insp_unit_id":"205646766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"ZP10239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"Y","insp_unit_decal_number":"34773753","created_at":"2025-03-17T23:58:21.000000Z","updated_at":"2025-03-17T23:58:21.000000Z"},{"id":12975538,"change_date":"2025-03-05 21:40:00","inspection_id":"84042849","insp_unit_id":"205646767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"APMZ415140","insp_unit_license":"T478885","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1JRC4026641002816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:21.000000Z","updated_at":"2025-03-17T23:58:21.000000Z"}]},{"id":7502857,"change_date":"2024-12-26 21:37:00","inspection_id":"83481808","dot_number":"853165","report_state":"CA","report_number":"NA5N007761","insp_date":"2024-12-23 00:00:00","insp_start_time":"0847","insp_end_time":"0911","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"15642273","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-26 21:37:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:39.000000Z","updated_at":"2025-03-17T20:52:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12103830,"change_date":"2024-12-26 21:37:00","inspection_id":"83481808","insp_unit_id":"204560614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:37.000000Z","updated_at":"2025-03-17T23:48:37.000000Z"},{"id":12103831,"change_date":"2024-12-26 21:37:00","inspection_id":"83481808","insp_unit_id":"204560615","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"MONN","insp_unit_company":"FLGZ 400114","insp_unit_license":"T623588","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1NNC0402XNM170342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:37.000000Z","updated_at":"2025-03-17T23:48:37.000000Z"}]},{"id":7341843,"change_date":"2024-12-04 21:42:00","inspection_id":"83312534","dot_number":"853165","report_state":"CA","report_number":"UBGJ006183","insp_date":"2024-12-03 00:00:00","insp_start_time":"1327","insp_end_time":"1401","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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-12-04 21:42: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":"15616037","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11843300,"change_date":"2024-12-04 21:42:00","inspection_id":"83312534","insp_unit_id":"204193477","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#92","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11843301,"change_date":"2024-12-04 21:42:00","inspection_id":"83312534","insp_unit_id":"204193478","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"FLXZ 434276","insp_unit_license":"U587335","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"HPZ276325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7157848,"change_date":"2024-11-08 21:41:00","inspection_id":"83118106","dot_number":"853165","report_state":"CA","report_number":"UE2C004855","insp_date":"2024-11-07 00:00:00","insp_start_time":"1730","insp_end_time":"1800","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":"2024-11-08 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":"15587581","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-08 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:10.000000Z","updated_at":"2025-03-17T20:45:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11544789,"change_date":"2024-11-08 21:41:00","inspection_id":"83118106","insp_unit_id":"203809613","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:36.000000Z","updated_at":"2025-03-17T23:42:36.000000Z"},{"id":11544790,"change_date":"2024-11-08 21:41:00","inspection_id":"83118106","insp_unit_id":"203809614","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"COEN","insp_unit_company":"TSXZ 421132","insp_unit_license":"3628199","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1C9GS4026SN330114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:36.000000Z","updated_at":"2025-03-17T23:42:36.000000Z"}]},{"id":6831332,"change_date":"2024-09-26 21:41:00","inspection_id":"82771509","dot_number":"853165","report_state":"CA","report_number":"UE2C004754","insp_date":"2024-09-25 00:00:00","insp_start_time":"1330","insp_end_time":"1400","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":"2024-09-26 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":"15535919","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-26 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:37.000000Z","updated_at":"2025-03-17T20:38:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11016485,"change_date":"2024-09-26 21:41:00","inspection_id":"82771509","insp_unit_id":"203153609","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:06.000000Z","updated_at":"2025-03-17T23:37:06.000000Z"},{"id":11016486,"change_date":"2024-09-26 21:41:00","inspection_id":"82771509","insp_unit_id":"203153610","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"DDTZ 170560","insp_unit_license":"229751T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"57VAA5320M1008241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:06.000000Z","updated_at":"2025-03-17T23:37:06.000000Z"}]},{"id":6821201,"change_date":"2024-09-25 21:42:00","inspection_id":"82760859","dot_number":"853165","report_state":"CA","report_number":"UBGJ006006","insp_date":"2024-09-23 00:00:00","insp_start_time":"1849","insp_end_time":"1931","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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-09-25 21:42: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":"15533898","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-25 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:33.000000Z","updated_at":"2025-03-17T20:38:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10999940,"change_date":"2024-09-25 21:42:00","inspection_id":"82760859","insp_unit_id":"203133775","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"},{"id":10999941,"change_date":"2024-09-25 21:42:00","inspection_id":"82760859","insp_unit_id":"203133776","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CTIC","insp_unit_company":"UPHZ 165766","insp_unit_license":"U928953","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5EF2GC531KB792889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6784192,"change_date":"2024-09-20 21:43:00","inspection_id":"82721528","dot_number":"853165","report_state":"CA","report_number":"UEAO004545","insp_date":"2024-09-19 00:00:00","insp_start_time":"1317","insp_end_time":"1331","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":"2024-09-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15528507","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:43.000000Z","updated_at":"2025-03-17T20:37:43.000000Z","inspection_violations":[{"id":10565593,"change_date":"2024-09-20 21:43:00","inspection_id":"82721528","insp_violation_id":"261958583","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203060145","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:11.000000Z","updated_at":"2025-03-17T21:57:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10939960,"change_date":"2024-09-20 21:43:00","inspection_id":"82721528","insp_unit_id":"203060144","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"},{"id":10939961,"change_date":"2024-09-20 21:43:00","inspection_id":"82721528","insp_unit_id":"203060145","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2X","insp_unit_license":"71176AC","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532W97L032942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":6339847,"change_date":"2024-07-29 21:42:00","inspection_id":"82247374","dot_number":"853165","report_state":"CA","report_number":"UE2C004612","insp_date":"2024-07-26 00:00:00","insp_start_time":"1500","insp_end_time":"1530","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":"2024-07-29 21:42: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":"15461558","transaction_code":"A","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:19.000000Z","updated_at":"2025-03-17T20:28:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10216092,"change_date":"2024-07-29 21:42:00","inspection_id":"82247374","insp_unit_id":"202132132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"},{"id":10216093,"change_date":"2024-07-29 21:42:00","inspection_id":"82247374","insp_unit_id":"202132133","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"DUNH","insp_unit_company":"FLXZ 426638","insp_unit_license":"T443475","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"974077235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"}]},{"id":6255166,"change_date":"2024-07-18 21:41:00","inspection_id":"82156847","dot_number":"853165","report_state":"CA","report_number":"UDBL003436","insp_date":"2024-07-16 00:00:00","insp_start_time":"0804","insp_end_time":"0827","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, LIVERMORE","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-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"15444847","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[{"id":9716651,"change_date":"2024-07-18 21:41:00","inspection_id":"82156847","insp_violation_id":"260723627","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201959658","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ78461","created_at":"2025-03-17T21:53:00.000000Z","updated_at":"2025-03-17T21:53:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10078435,"change_date":"2024-07-18 21:41:00","inspection_id":"82156847","insp_unit_id":"201959658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"},{"id":10078436,"change_date":"2024-07-18 21:41:00","inspection_id":"82156847","insp_unit_id":"201959659","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HEART","insp_unit_company":"FLXZ 416024","insp_unit_license":"T281015","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"R728316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"}]},{"id":5680119,"change_date":"2024-05-06 21:44:00","inspection_id":"81535252","dot_number":"853165","report_state":"CA","report_number":"N9ZT005835","insp_date":"2024-05-03 00:00:00","insp_start_time":"1209","insp_end_time":"1255","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-05-06 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":"15347711","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":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-06 21:44:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:26.000000Z","updated_at":"2025-03-17T20:15:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9149003,"change_date":"2024-05-06 21:44:00","inspection_id":"81535252","insp_unit_id":"200750628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"Y","insp_unit_decal_number":"33811482","created_at":"2025-03-17T23:18:07.000000Z","updated_at":"2025-03-17T23:18:07.000000Z"}]},{"id":5666945,"change_date":"2024-05-03 21:39:00","inspection_id":"81520866","dot_number":"853165","report_state":"CA","report_number":"UBGJ005683","insp_date":"2024-05-02 00:00:00","insp_start_time":"1231","insp_end_time":"1316","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"15346674","transaction_code":"A","transaction_date":"2024-05-02 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-03 21:39:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:04.000000Z","updated_at":"2025-03-17T20:15:04.000000Z","inspection_violations":[{"id":8766568,"change_date":"2024-05-03 21:39:00","inspection_id":"81520866","insp_violation_id":"259312137","seq_no":"1","part_no":"393","part_no_section":"126","insp_viol_unit":"2","insp_unit_id":"200722865","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA512620","created_at":"2025-03-17T21:48:24.000000Z","updated_at":"2025-03-17T21:48:24.000000Z","normalized_code":"393126"}],"inspection_per_units":[{"id":9127158,"change_date":"2024-05-03 21:39:00","inspection_id":"81520866","insp_unit_id":"200722864","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X\/WHT","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:56.000000Z","updated_at":"2025-03-17T23:17:56.000000Z"},{"id":9127159,"change_date":"2024-05-03 21:39:00","inspection_id":"81520866","insp_unit_id":"200722865","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FHCZ 147182","insp_unit_license":"U399802","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S85T223597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:56.000000Z","updated_at":"2025-03-17T23:17:56.000000Z"}]},{"id":5601335,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","dot_number":"853165","report_state":"CA","report_number":"NA5N007107","insp_date":"2024-04-22 00:00:00","insp_start_time":"0935","insp_end_time":"1026","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-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15333941","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[{"id":8661457,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_violation_id":"259154386","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"200585221","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA518095","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39375A1"},{"id":8661458,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_violation_id":"259154387","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200585221","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA518095","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8661459,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_violation_id":"259154388","seq_no":"3","part_no":"393","part_no_section":"126","insp_viol_unit":"2","insp_unit_id":"200585222","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA518095","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"393126"},{"id":8661460,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_violation_id":"259154389","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200585222","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39347E"},{"id":8661461,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_violation_id":"259154390","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200585222","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9022561,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_unit_id":"200585221","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"},{"id":9022562,"change_date":"2024-04-25 21:43:00","inspection_id":"81449412","insp_unit_id":"200585222","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"TSXZ 461918","insp_unit_license":"2447983","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S5TT000544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":5464401,"change_date":"2024-04-08 21:45:00","inspection_id":"81299810","dot_number":"853165","report_state":"CA","report_number":"UE03003118","insp_date":"2024-04-05 00:00:00","insp_start_time":"0930","insp_end_time":"1001","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","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":"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":"112000","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":"15310313","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:45:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","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":8801923,"change_date":"2024-04-08 21:45:00","inspection_id":"81299810","insp_unit_id":"200297490","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"92","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","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":8801924,"change_date":"2024-04-08 21:45:00","inspection_id":"81299810","insp_unit_id":"200297491","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FLGZ 435054","insp_unit_license":"T635948","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S4ST005474","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":5394018,"change_date":"2024-03-28 21:41:00","inspection_id":"81222921","dot_number":"853165","report_state":"CA","report_number":"NA5N007010","insp_date":"2024-03-26 00:00:00","insp_start_time":"0733","insp_end_time":"0747","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-03-28 21:41: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":"15299770","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:29.000000Z","updated_at":"2025-03-17T20:09:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8687368,"change_date":"2024-03-28 21:41:00","inspection_id":"81222921","insp_unit_id":"200145088","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"Y","insp_unit_decal_number":"33524277","created_at":"2025-03-17T23:13:48.000000Z","updated_at":"2025-03-17T23:13:48.000000Z"}]},{"id":5128309,"change_date":"2024-02-23 21:42:00","inspection_id":"80933456","dot_number":"853165","report_state":"CA","report_number":"UEX8003620","insp_date":"2024-02-22 00:00:00","insp_start_time":"1444","insp_end_time":"1507","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"15249018","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-23 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:12.000000Z","updated_at":"2025-03-17T20:04:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8256250,"change_date":"2024-02-23 21:42:00","inspection_id":"80933456","insp_unit_id":"199584661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"ZP10239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD56ESFK8008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"},{"id":8256251,"change_date":"2024-02-23 21:42:00","inspection_id":"80933456","insp_unit_id":"199584662","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FLTZ 043081","insp_unit_license":"T764100","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412SXNT401882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"}]},{"id":5105269,"change_date":"2024-02-21 21:41:00","inspection_id":"80908305","dot_number":"853165","report_state":"CA","report_number":"NBH6005336","insp_date":"2024-02-20 00:00:00","insp_start_time":"0545","insp_end_time":"0608","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"15243764","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-21 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:48.000000Z","updated_at":"2025-03-17T20:03:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8219291,"change_date":"2024-02-21 21:41:00","inspection_id":"80908305","insp_unit_id":"199534272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"92","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"},{"id":8219292,"change_date":"2024-02-21 21:41:00","inspection_id":"80908305","insp_unit_id":"199534273","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"AJAX","insp_unit_company":"FLXZ 417411","insp_unit_license":"T308274","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1AJCG4029XH002687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"}]},{"id":4936327,"change_date":"2024-01-30 21:42:00","inspection_id":"80723490","dot_number":"853165","report_state":"CA","report_number":"UESQ003522","insp_date":"2024-01-30 00:00:00","insp_start_time":"1030","insp_end_time":"1041","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"ARCH RD AT FITE CT","county_code_state":"CA","county_code":"077","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-30 21:42: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":"15219360","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-30 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:30.000000Z","updated_at":"2025-03-17T20:00:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7943910,"change_date":"2024-01-30 21:42:00","inspection_id":"80723490","insp_unit_id":"199181820","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:59.000000Z","updated_at":"2025-03-17T23:06:59.000000Z"}]},{"id":4735803,"change_date":"2023-12-29 21:40:00","inspection_id":"80504325","dot_number":"853165","report_state":"CA","report_number":"UE2C004107","insp_date":"2023-12-23 00:00:00","insp_start_time":"0730","insp_end_time":"0800","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":"2023-12-29 21:40: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":"15184254","transaction_code":"A","transaction_date":"2023-12-23 00:00:00","upload_date":"2023-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:34.000000Z","updated_at":"2025-03-17T19:56:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7617638,"change_date":"2023-12-29 21:40:00","inspection_id":"80504325","insp_unit_id":"198744500","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"},{"id":7617639,"change_date":"2023-12-29 21:40:00","inspection_id":"80504325","insp_unit_id":"198744501","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"UPHZ 158037","insp_unit_license":"2262KL","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"LJRC54268G1004012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"}]},{"id":4657669,"change_date":"2023-12-18 21:43:00","inspection_id":"80419151","dot_number":"853165","report_state":"CA","report_number":"NAHY005941","insp_date":"2023-12-18 00:00:00","insp_start_time":"0155","insp_end_time":"0217","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-18 21:43: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":"15170808","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-18 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:00.000000Z","updated_at":"2025-03-17T19:55:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7491537,"change_date":"2023-12-18 21:43:00","inspection_id":"80419151","insp_unit_id":"198563509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/WHITE","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"Y","insp_unit_decal_number":"33230973","created_at":"2025-03-17T23:02:59.000000Z","updated_at":"2025-03-17T23:02:59.000000Z"}]},{"id":4500893,"change_date":"2023-11-27 21:43:00","inspection_id":"80246830","dot_number":"853165","report_state":"CA","report_number":"NEEU001706","insp_date":"2023-11-20 00:00:00","insp_start_time":"1640","insp_end_time":"1716","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-11-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"128400","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":"15145048","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-27 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:09.000000Z","updated_at":"2025-03-17T19:52:09.000000Z","inspection_violations":[{"id":6967291,"change_date":"2023-11-27 21:43:00","inspection_id":"80246830","insp_violation_id":"256581008","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198227982","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39347E"},{"id":6967292,"change_date":"2023-11-27 21:43:00","inspection_id":"80246830","insp_violation_id":"256581009","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198227982","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39353B"},{"id":6967293,"change_date":"2023-11-27 21:43:00","inspection_id":"80246830","insp_violation_id":"256581010","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198227982","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7238954,"change_date":"2023-11-27 21:43:00","inspection_id":"80246830","insp_unit_id":"198227982","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04\/WHT\/3X","insp_unit_license":"YP78150","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:48.000000Z","updated_at":"2025-03-17T23:00:48.000000Z"},{"id":7238955,"change_date":"2023-11-27 21:43:00","inspection_id":"80246830","insp_unit_id":"198227983","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"TSXZ 485653","insp_unit_license":"254292F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41269LT017450","insp_unit_decal":"Y","insp_unit_decal_number":"33213184","created_at":"2025-03-17T23:00:48.000000Z","updated_at":"2025-03-17T23:00:48.000000Z"}]},{"id":4416135,"change_date":"2023-11-13 21:43:00","inspection_id":"80153662","dot_number":"853165","report_state":"CA","report_number":"UE2C004068","insp_date":"2023-11-09 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":"2023-11-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"15132619","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-13 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:20.000000Z","updated_at":"2025-03-17T19:50:20.000000Z","inspection_violations":[{"id":6833405,"change_date":"2023-11-13 21:43:00","inspection_id":"80153662","insp_violation_id":"256370348","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198039758","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA512846","created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3939A"},{"id":6833406,"change_date":"2023-11-13 21:43:00","inspection_id":"80153662","insp_violation_id":"256370349","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198039759","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA512846","created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7102275,"change_date":"2023-11-13 21:43:00","inspection_id":"80153662","insp_unit_id":"198039758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X RED","insp_unit_license":"9E28538","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDV0ESFW0386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"},{"id":7102276,"change_date":"2023-11-13 21:43:00","inspection_id":"80153662","insp_unit_id":"198039759","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UPDZ 810653","insp_unit_license":"U878220","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"145C242S3FL001243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"}]},{"id":4368062,"change_date":"2023-11-06 21:43:00","inspection_id":"80100208","dot_number":"853165","report_state":"CA","report_number":"UE2C004045","insp_date":"2023-11-02 00:00:00","insp_start_time":"1330","insp_end_time":"1400","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":"2023-11-06 21:43: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":"15123704","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-06 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:31.000000Z","updated_at":"2025-03-17T19:49:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7025237,"change_date":"2023-11-06 21:43:00","inspection_id":"80100208","insp_unit_id":"197935505","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"},{"id":7025238,"change_date":"2023-11-06 21:43:00","inspection_id":"80100208","insp_unit_id":"197935506","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"UPHZ 168054","insp_unit_license":"297776T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1DW4C5322PEA98221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":4337214,"change_date":"2023-11-01 21:44:00","inspection_id":"80066271","dot_number":"853165","report_state":"CA","report_number":"UFEK003414","insp_date":"2023-10-31 00:00:00","insp_start_time":"1250","insp_end_time":"1310","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15119769","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-01 21:44:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:46.000000Z","updated_at":"2025-03-17T19:48:46.000000Z","inspection_violations":[{"id":6709662,"change_date":"2023-11-01 21:44:00","inspection_id":"80066271","insp_violation_id":"256176487","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197867444","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6975428,"change_date":"2023-11-01 21:44:00","inspection_id":"80066271","insp_unit_id":"197867444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"}]},{"id":4108546,"change_date":"2023-10-02 21:42:00","inspection_id":"79813564","dot_number":"853165","report_state":"CA","report_number":"NE7S002497","insp_date":"2023-09-27 00:00:00","insp_start_time":"0645","insp_end_time":"0730","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-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"129200","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":"15081127","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-02 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-03-17T19:44:02.000000Z","updated_at":"2025-03-17T19:44:02.000000Z","inspection_violations":[{"id":6357580,"change_date":"2023-10-02 21:42:00","inspection_id":"79813564","insp_violation_id":"255612307","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197358554","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39347E"},{"id":6357581,"change_date":"2023-10-02 21:42:00","inspection_id":"79813564","insp_violation_id":"255612308","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197358554","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39353B"},{"id":6357582,"change_date":"2023-10-02 21:42:00","inspection_id":"79813564","insp_violation_id":"255612309","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197358554","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6606047,"change_date":"2023-10-02 21:42:00","inspection_id":"79813564","insp_unit_id":"197358554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHITE\/3AX","insp_unit_license":"YP78150","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"},{"id":6606048,"change_date":"2023-10-02 21:42:00","inspection_id":"79813564","insp_unit_id":"197358555","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UPHZ 138818","insp_unit_license":"U265583","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C532S23T134419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3849346,"change_date":"2023-08-28 21:42:00","inspection_id":"79525301","dot_number":"853165","report_state":"CA","report_number":"N9ZT004948","insp_date":"2023-08-25 00:00:00","insp_start_time":"1200","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":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15038130","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:55.000000Z","updated_at":"2025-03-17T19:38:55.000000Z","inspection_violations":[{"id":5947800,"change_date":"2023-08-28 21:42:00","inspection_id":"79525301","insp_violation_id":"254934743","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196769931","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":6189398,"change_date":"2023-08-28 21:42:00","inspection_id":"79525301","insp_unit_id":"196769931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP78115","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED60ESFS4055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:59.000000Z","updated_at":"2025-03-17T22:51:59.000000Z"}]},{"id":3850120,"change_date":"2023-09-25 21:41:00","inspection_id":"79526109","dot_number":"853165","report_state":"CA","report_number":"NC3S007109","insp_date":"2023-08-25 00:00:00","insp_start_time":"0700","insp_end_time":"0730","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":"2023-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"125800","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":"15038751","transaction_code":"C","transaction_date":"2023-09-22 00:00:00","upload_date":"2023-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[{"id":5948346,"change_date":"2023-09-25 21:41:00","inspection_id":"79526109","insp_violation_id":"255470547","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":6190505,"change_date":"2023-09-25 21:41:00","inspection_id":"79526109","insp_unit_id":"197227496","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"92-WHT","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"Y","insp_unit_decal_number":"32849731","created_at":"2025-03-17T22:52:01.000000Z","updated_at":"2025-03-17T22:52:01.000000Z"},{"id":6190506,"change_date":"2023-09-25 21:41:00","inspection_id":"79526109","insp_unit_id":"197227497","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FLXZ 435337","insp_unit_license":"T771739","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"P618787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:01.000000Z","updated_at":"2025-03-17T22:52:01.000000Z"}]},{"id":3795321,"change_date":"2023-08-21 21:43:00","inspection_id":"79464626","dot_number":"853165","report_state":"CA","report_number":"NE8I002489","insp_date":"2023-08-16 00:00:00","insp_start_time":"1354","insp_end_time":"1441","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-08-21 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":"15028461","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-21 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:43.000000Z","updated_at":"2025-03-17T19:37:43.000000Z","inspection_violations":[{"id":5854642,"change_date":"2023-08-21 21:43:00","inspection_id":"79464626","insp_violation_id":"254786850","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196649544","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL41888","created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3963A1"},{"id":5854643,"change_date":"2023-08-21 21:43:00","inspection_id":"79464626","insp_violation_id":"254786851","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196649544","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6102581,"change_date":"2023-08-21 21:43:00","inspection_id":"79464626","insp_unit_id":"196649544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03\/WHITE","insp_unit_license":"YP78115","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED60ESFS4055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:16.000000Z","updated_at":"2025-03-17T22:51:16.000000Z"}]},{"id":3515519,"change_date":"2023-07-14 21:41:00","inspection_id":"79151527","dot_number":"853165","report_state":"CA","report_number":"NDN6007441","insp_date":"2023-07-06 00:00:00","insp_start_time":"0838","insp_end_time":"0913","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"14981763","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:30.000000Z","updated_at":"2025-03-17T19:32:30.000000Z","inspection_violations":[{"id":5421752,"change_date":"2023-07-14 21:41:00","inspection_id":"79151527","insp_violation_id":"254081096","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196016442","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39021TB"},{"id":5421753,"change_date":"2023-07-14 21:41:00","inspection_id":"79151527","insp_violation_id":"254081097","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196016442","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5421754,"change_date":"2023-07-14 21:41:00","inspection_id":"79151527","insp_violation_id":"254081098","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"196016442","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":5652871,"change_date":"2023-07-14 21:41:00","inspection_id":"79151527","insp_unit_id":"196016442","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"},{"id":5652872,"change_date":"2023-07-14 21:41:00","inspection_id":"79151527","insp_unit_id":"196016443","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CTIC","insp_unit_company":"TSFZ 557464","insp_unit_license":"U873960","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1TA144023E1117605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":3326296,"change_date":"2023-06-20 21:41:00","inspection_id":"78939043","dot_number":"853165","report_state":"UT","report_number":"23PL000305","insp_date":"2023-06-15 00:00:00","insp_start_time":"1550","insp_end_time":"1618","registration_date":null,"region":"MT","ci_status_code":"C","location":"30","location_desc":"WENDOVER PORT OF ENTRY EASTBOU","county_code_state":"UT","county_code":"045","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MOVING MAN","shipping_paper_number":"BYCT-101","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"886453","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-15 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:54.000000Z","updated_at":"2025-03-17T19:28:54.000000Z","inspection_violations":[{"id":5129988,"change_date":"2023-06-20 21:41:00","inspection_id":"78939043","insp_violation_id":"253605741","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:50.000000Z","updated_at":"2025-03-17T21:30:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5347680,"change_date":"2023-06-20 21:41:00","inspection_id":"78939043","insp_unit_id":"195589408","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"719","insp_unit_license":"YP73644","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X5JJ210562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:11.000000Z","updated_at":"2025-03-17T22:45:11.000000Z"},{"id":5347681,"change_date":"2023-06-20 21:41:00","inspection_id":"78939043","insp_unit_id":"195589409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"T17","insp_unit_license":"4RG9923","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D9HL961951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:11.000000Z","updated_at":"2025-03-17T22:45:11.000000Z"}]},{"id":3252895,"change_date":"2023-06-09 21:41:00","inspection_id":"78855887","dot_number":"853165","report_state":"CA","report_number":"UBGJ004837","insp_date":"2023-06-04 00:00:00","insp_start_time":"2326","insp_end_time":"0013","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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":"2023-06-09 21:41: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":"14936978","transaction_code":"A","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-09 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:21.000000Z","updated_at":"2025-03-17T19:27:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5231618,"change_date":"2023-06-09 21:41:00","inspection_id":"78855887","insp_unit_id":"195425549","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#172","insp_unit_license":"YP78157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:14.000000Z","updated_at":"2025-03-17T22:44:14.000000Z"}]},{"id":3196753,"change_date":"2023-06-01 21:43:00","inspection_id":"78792739","dot_number":"853165","report_state":"CA","report_number":"NCCL004810","insp_date":"2023-05-30 00:00:00","insp_start_time":"0835","insp_end_time":"0910","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121700","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":"14926594","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-03-17T19:26:08.000000Z","updated_at":"2025-03-17T19:26:08.000000Z","inspection_violations":[{"id":4925486,"change_date":"2023-06-01 21:43:00","inspection_id":"78792739","insp_violation_id":"253226046","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195269258","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"3939A"},{"id":4925487,"change_date":"2023-06-01 21:43:00","inspection_id":"78792739","insp_violation_id":"253226047","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195269258","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"39347E"},{"id":4925488,"change_date":"2023-06-01 21:43:00","inspection_id":"78792739","insp_violation_id":"253226048","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195269258","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5141949,"change_date":"2023-06-01 21:43:00","inspection_id":"78792739","insp_unit_id":"195269257","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"719WHT3X","insp_unit_license":"YP73644","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X5JJ210562","insp_unit_decal":"Y","insp_unit_decal_number":"32474027","created_at":"2025-03-17T22:43:31.000000Z","updated_at":"2025-03-17T22:43:31.000000Z"},{"id":5141950,"change_date":"2023-06-01 21:43:00","inspection_id":"78792739","insp_unit_id":"195269258","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"TSFZ 500935","insp_unit_license":"U897902","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"145X412S3JL108084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:31.000000Z","updated_at":"2025-03-17T22:43:31.000000Z"}]},{"id":2736421,"change_date":"2023-04-04 21:43:00","inspection_id":"78272314","dot_number":"853165","report_state":"CA","report_number":"UE2C003418","insp_date":"2023-03-29 00:00:00","insp_start_time":"1330","insp_end_time":"1400","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":"2023-04-04 21:43: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":"14842119","transaction_code":"A","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-04 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:01.000000Z","updated_at":"2025-03-17T19:17:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4404854,"change_date":"2023-04-04 21:43:00","inspection_id":"78272314","insp_unit_id":"194232861","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G26153","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV7GLGZ3464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:39.000000Z","updated_at":"2025-03-17T22:37:39.000000Z"},{"id":4404855,"change_date":"2023-04-04 21:43:00","inspection_id":"78272314","insp_unit_id":"194232862","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FHCZ 06951","insp_unit_license":"U464053","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S7VT008602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:39.000000Z","updated_at":"2025-03-17T22:37:39.000000Z"}]},{"id":2733000,"change_date":"2023-04-04 21:42:00","inspection_id":"78268597","dot_number":"853165","report_state":"CA","report_number":"NC9Y004655","insp_date":"2023-03-28 00:00:00","insp_start_time":"0702","insp_end_time":"0724","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-04 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":"14840755","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-04 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:59.000000Z","updated_at":"2025-03-17T19:16:59.000000Z","inspection_violations":[{"id":4199029,"change_date":"2023-04-04 21:42:00","inspection_id":"78268597","insp_violation_id":"252049829","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194226719","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:37.000000Z","updated_at":"2025-03-17T21:26:37.000000Z","normalized_code":"3939A"},{"id":4199030,"change_date":"2023-04-04 21:42:00","inspection_id":"78268597","insp_violation_id":"252049830","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194226719","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:37.000000Z","updated_at":"2025-03-17T21:26:37.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4399376,"change_date":"2023-04-04 21:42:00","inspection_id":"78268597","insp_unit_id":"194226719","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/3AX","insp_unit_license":"YP78150","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV4GLHK1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"},{"id":4399377,"change_date":"2023-04-04 21:42:00","inspection_id":"78268597","insp_unit_id":"194226720","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"UPHZ 157209","insp_unit_license":"3034KL","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"LJRC5426XG1003184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"}]},{"id":2495637,"change_date":"2023-03-02 21:41:00","inspection_id":"77997928","dot_number":"853165","report_state":"CA","report_number":"NE1M003443","insp_date":"2023-02-28 00:00:00","insp_start_time":"0944","insp_end_time":"1018","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":"2023-03-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126450","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":"14804639","transaction_code":"A","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-03-17T19:12:33.000000Z","updated_at":"2025-03-17T19:12:33.000000Z","inspection_violations":[{"id":3839450,"change_date":"2023-03-02 21:41:00","inspection_id":"77997928","insp_violation_id":"251453507","seq_no":"1","part_no":"393","part_no_section":"126","insp_viol_unit":"2","insp_unit_id":"193683579","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:25:00.000000Z","updated_at":"2025-03-17T21:25:00.000000Z","normalized_code":"393126"},{"id":3839451,"change_date":"2023-03-02 21:41:00","inspection_id":"77997928","insp_violation_id":"251453508","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193683578","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:00.000000Z","updated_at":"2025-03-17T21:25:00.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4016067,"change_date":"2023-03-02 21:41:00","inspection_id":"77997928","insp_unit_id":"193683578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"YP78149","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGED52FSGX1261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:47.000000Z","updated_at":"2025-03-17T22:34:47.000000Z"},{"id":4016068,"change_date":"2023-03-02 21:41:00","inspection_id":"77997928","insp_unit_id":"193683579","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UPHZ 137591","insp_unit_license":"U434683","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C532S71T106385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:47.000000Z","updated_at":"2025-03-17T22:34:47.000000Z"}]},{"id":2231055,"change_date":"2023-01-25 21:43:00","inspection_id":"77696446","dot_number":"853165","report_state":"CA","report_number":"UCUF002795","insp_date":"2023-01-23 00:00:00","insp_start_time":"1620","insp_end_time":"1650","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-25 21:43: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":"14756041","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-03-17T19:07:45.000000Z","updated_at":"2025-03-17T19:07:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3591163,"change_date":"2023-01-25 21:43:00","inspection_id":"77696446","insp_unit_id":"193074592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHI #719","insp_unit_license":"YP73644","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X5JJ210562","insp_unit_decal":"Y","insp_unit_decal_number":"32142052","created_at":"2025-03-17T22:31:45.000000Z","updated_at":"2025-03-17T22:31:45.000000Z"}]},{"id":2231069,"change_date":"2023-01-25 21:43:00","inspection_id":"77696460","dot_number":"853165","report_state":"CA","report_number":"UE2C003216","insp_date":"2023-01-20 00:00:00","insp_start_time":"1030","insp_end_time":"1120","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":"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-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14756452","transaction_code":"A","transaction_date":"2023-01-20 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:45.000000Z","updated_at":"2025-03-17T19:07:45.000000Z","inspection_violations":[{"id":3447396,"change_date":"2023-01-25 21:43:00","inspection_id":"77696460","insp_violation_id":"250788940","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193074613","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA392297","created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"39021TB"},{"id":3447397,"change_date":"2023-01-25 21:43:00","inspection_id":"77696460","insp_violation_id":"250788941","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193074613","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA392297","created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"39021TB"},{"id":3447398,"change_date":"2023-01-25 21:43:00","inspection_id":"77696460","insp_violation_id":"250788942","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193074613","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA392297","created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3591184,"change_date":"2023-01-25 21:43:00","inspection_id":"77696460","insp_unit_id":"193074613","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X WHT","insp_unit_license":"YP73644","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X5JJ210562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:45.000000Z","updated_at":"2025-03-17T22:31:45.000000Z"}]},{"id":1417136,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","dot_number":"853165","report_state":"CA","report_number":"UEDD000004","insp_date":"2022-09-28 00:00:00","insp_start_time":"0946","insp_end_time":"1028","registration_date":null,"region":"PT","ci_status_code":"C","location":"0345","location_desc":"I-880 S\/B NIMITZ CVEF","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":"2022-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14617676","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-30 21:40:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:44.000000Z","updated_at":"2025-03-17T18:52:44.000000Z","inspection_violations":[{"id":2233885,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_violation_id":"248770059","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191213317","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"39347E"},{"id":2233886,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_violation_id":"248770060","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191213317","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"39353B"},{"id":2233887,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_violation_id":"248770061","seq_no":"3","part_no":"393","part_no_section":"126","insp_viol_unit":"2","insp_unit_id":"191213317","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"393126"},{"id":2233888,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_violation_id":"248770062","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191213316","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"39345"},{"id":2233889,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_violation_id":"248770063","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191213316","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LR39262","created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2281382,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_unit_id":"191213316","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3 X WHT","insp_unit_license":"9D27424","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJBBCK58LAA9995","insp_unit_decal":"Y","insp_unit_decal_number":"31483728","created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"},{"id":2281383,"change_date":"2022-09-30 21:40:00","inspection_id":"76762667","insp_unit_id":"191213317","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"JIND","insp_unit_company":"FHCZ 145474","insp_unit_license":"U401991","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"KR1GV40212D104574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"}]},{"id":843636,"change_date":"2022-07-18 21:43:00","inspection_id":"76094548","dot_number":"853165","report_state":"CA","report_number":"NA5N004831","insp_date":"2022-07-14 00:00:00","insp_start_time":"1101","insp_end_time":"1143","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B 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":"2022-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14509644","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-18 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:38.000000Z","updated_at":"2025-03-17T18:42:38.000000Z","inspection_violations":[{"id":1331196,"change_date":"2022-07-18 21:43:00","inspection_id":"76094548","insp_violation_id":"247171137","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189843039","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:16.000000Z","updated_at":"2025-03-17T21:13:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1358036,"change_date":"2022-07-18 21:43:00","inspection_id":"76094548","insp_unit_id":"189843039","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G26153","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV7GLGZ3464","insp_unit_decal":"Y","insp_unit_decal_number":"31475349","created_at":"2025-03-17T22:16:32.000000Z","updated_at":"2025-03-17T22:16:32.000000Z"}]},{"id":824512,"change_date":"2022-07-14 21:42:00","inspection_id":"76072242","dot_number":"853165","report_state":"CA","report_number":"UCOB003517","insp_date":"2022-07-13 00:00:00","insp_start_time":"0930","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"2022-07-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14507455","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[{"id":1300132,"change_date":"2022-07-14 21:42:00","inspection_id":"76072242","insp_violation_id":"247111955","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189793267","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA 387747","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1326623,"change_date":"2022-07-14 21:42:00","inspection_id":"76072242","insp_unit_id":"189793267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9D27424","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJBBCK58LAA9995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"},{"id":1326624,"change_date":"2022-07-14 21:42:00","inspection_id":"76072242","insp_unit_id":"189793268","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"FLGZ 441034","insp_unit_license":"T602298","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1S12GC402SG693884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"}]},{"id":518804,"change_date":"2022-05-31 21:42:00","inspection_id":"75711651","dot_number":"853165","report_state":"CA","report_number":"NCAT002191","insp_date":"2022-05-27 00:00:00","insp_start_time":"1739","insp_end_time":"1807","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":"BAY CITY EXPRESS INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"110500","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":"14449445","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-31 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-03-17T18:36:44.000000Z","updated_at":"2025-03-17T18:36:44.000000Z","inspection_violations":[{"id":821626,"change_date":"2022-05-31 21:42:00","inspection_id":"75711651","insp_violation_id":"246177378","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189003156","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:56.000000Z","updated_at":"2025-03-17T21:10:56.000000Z","normalized_code":"39347E"},{"id":821627,"change_date":"2022-05-31 21:42:00","inspection_id":"75711651","insp_violation_id":"246177379","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189003156","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:56.000000Z","updated_at":"2025-03-17T21:10:56.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":835050,"change_date":"2022-05-31 21:42:00","inspection_id":"75711651","insp_unit_id":"189003155","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111","insp_unit_license":"9G26153","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV7GLGZ3464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"},{"id":835051,"change_date":"2022-05-31 21:42:00","inspection_id":"75711651","insp_unit_id":"189003156","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"BRTO","insp_unit_company":"FLXZ 426664","insp_unit_license":"T443555","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1BZ2C2428CW004572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"}]},{"id":519732,"change_date":"2022-05-31 21:42:00","inspection_id":"75712681","dot_number":"853165","report_state":"CA","report_number":"UD89001521","insp_date":"2022-05-27 00:00:00","insp_start_time":"1820","insp_end_time":"1902","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"110500","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":"14449279","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-31 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":"392661","created_at":"2025-03-17T18:36:44.000000Z","updated_at":"2025-03-17T18:36:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":836457,"change_date":"2022-05-31 21:42:00","inspection_id":"75712681","insp_unit_id":"189004784","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111","insp_unit_license":"9G26153","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGHDV7GLGZ3464","insp_unit_decal":"Y","insp_unit_decal_number":"31095631","created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"},{"id":836458,"change_date":"2022-05-31 21:42:00","inspection_id":"75712681","insp_unit_id":"189004785","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"BRTO","insp_unit_company":"FLXZ 426664","insp_unit_license":"T443555","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1BZ2C2428CW004572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"}]},{"id":497526,"change_date":"2022-05-26 21:43:00","inspection_id":"75686322","dot_number":"853165","report_state":"CA","report_number":"UCOB003417","insp_date":"2022-05-20 00:00:00","insp_start_time":"0946","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14446790","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:22.000000Z","updated_at":"2025-03-17T18:36:22.000000Z","inspection_violations":[{"id":790234,"change_date":"2022-05-26 21:43:00","inspection_id":"75686322","insp_violation_id":"246119542","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188949361","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA 387571","created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3939A"},{"id":790235,"change_date":"2022-05-26 21:43:00","inspection_id":"75686322","insp_violation_id":"246119543","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"188949360","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA 387571","created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39345"},{"id":790236,"change_date":"2022-05-26 21:43:00","inspection_id":"75686322","insp_violation_id":"246119544","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188949361","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA 387571","created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":800220,"change_date":"2022-05-26 21:43:00","inspection_id":"75686322","insp_unit_id":"188949360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39138","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG0AN287355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"},{"id":800221,"change_date":"2022-05-26 21:43:00","inspection_id":"75686322","insp_unit_id":"188949361","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"FLXZ 445534","insp_unit_license":"T967345","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"VVM116052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"}]},{"id":380885,"change_date":"2022-05-12 21:42:00","inspection_id":"75547126","dot_number":"853165","report_state":"CA","report_number":"UE2C002372","insp_date":"2022-05-04 00:00:00","insp_start_time":"1530","insp_end_time":"1600","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":"2022-05-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"14424500","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-12 21:42:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:22.000000Z","updated_at":"2025-03-17T18:34:22.000000Z","inspection_violations":[{"id":597652,"change_date":"2022-05-12 21:42:00","inspection_id":"75547126","insp_violation_id":"245764922","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188660819","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA388040","created_at":"2025-03-17T21:09:49.000000Z","updated_at":"2025-03-17T21:09:49.000000Z","normalized_code":"39021TB"},{"id":597653,"change_date":"2022-05-12 21:42:00","inspection_id":"75547126","insp_violation_id":"245764923","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188660819","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA388040","created_at":"2025-03-17T21:09:49.000000Z","updated_at":"2025-03-17T21:09:49.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":616003,"change_date":"2022-05-12 21:42:00","inspection_id":"75547126","insp_unit_id":"188660819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9D27424","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJBBCK58LAA9995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:59.000000Z","updated_at":"2025-03-17T22:11:59.000000Z"},{"id":616004,"change_date":"2022-05-12 21:42:00","inspection_id":"75547126","insp_unit_id":"188660820","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"FLXZ 441157","insp_unit_license":"U320640","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1JJC24237JL111898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:59.000000Z","updated_at":"2025-03-17T22:11:59.000000Z"}]},{"id":230415,"change_date":"2022-04-21 21:44:00","inspection_id":"75367746","dot_number":"853165","report_state":"CA","report_number":"UEXA001054","insp_date":"2022-04-21 00:00:00","insp_start_time":"0645","insp_end_time":"0700","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"GRAND AVE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-21 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14396107","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00853165","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-21 21:44:00","insp_carrier_name":"BAY CITY EXPRESS INC","insp_carrier_street":"34199 ZWISSIG WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"375562","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:34.000000Z","updated_at":"2025-03-17T18:31:34.000000Z","inspection_violations":[{"id":354243,"change_date":"2022-04-21 21:44:00","inspection_id":"75367746","insp_violation_id":"245311039","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188285571","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KW035855","created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":373619,"change_date":"2022-04-21 21:44:00","inspection_id":"75367746","insp_unit_id":"188285571","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP33863","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD58FSGJ2882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:30.000000Z","updated_at":"2025-03-17T22:10:30.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/853165\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/853165\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/853165\/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\/853165\/inspections","per_page":100,"prev_page_url":null,"to":62,"total":62}