{"current_page":1,"data":[{"id":11825106,"change_date":"2026-05-05 21:39:00","inspection_id":"87759837","dot_number":"2751005","report_state":"CA","report_number":"NATH005838","insp_date":"2026-04-30 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","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":"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-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3260312","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2026-05-08T09:40:26.000000Z","updated_at":"2026-05-15T12:18:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20566651,"change_date":"2026-05-05 21:39:00","inspection_id":"87759837","insp_unit_id":"213382832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":null,"insp_unit_license":"3814133","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML7RL754661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:15.000000Z","updated_at":"2026-05-15T11:57:30.000000Z"}]},{"id":11254739,"change_date":"2026-02-27 21:42:00","inspection_id":"87168157","dot_number":"2751005","report_state":"CA","report_number":"NBGW008989","insp_date":"2026-02-25 00:00:00","insp_start_time":"2113","insp_end_time":"2136","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16187987","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2026-02-27 21:42:00","snet_input_date":"2026-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-27 21:42:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2026-03-02T10:39:54.000000Z","updated_at":"2026-03-10T09:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19243654,"change_date":"2026-02-27 21:42:00","inspection_id":"87168157","insp_unit_id":"211893790","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"843","insp_unit_license":"91764X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUTAL4RL128628","insp_unit_decal":"Y","insp_unit_decal_number":"35934652","created_at":"2026-03-02T10:16:32.000000Z","updated_at":"2026-03-10T09:06:46.000000Z"}]},{"id":11108529,"change_date":"2026-02-11 21:39:00","inspection_id":"87020927","dot_number":"2751005","report_state":"CA","report_number":"NARW004149","insp_date":"2026-02-10 00:00:00","insp_start_time":"1107","insp_end_time":"1129","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":"2026-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16167813","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2026-02-11 21:39:00","snet_input_date":"2026-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-11 21:39:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2026-02-14T10:37:40.000000Z","updated_at":"2026-02-22T10:31:07.000000Z","inspection_violations":[{"id":18603665,"change_date":"2026-02-11 21:39:00","inspection_id":"87020927","insp_violation_id":"271743220","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211573069","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:31.000000Z","updated_at":"2026-02-22T10:40:13.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":18945228,"change_date":"2026-02-11 21:39:00","inspection_id":"87020927","insp_unit_id":"211573069","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"56\/WHT2X","insp_unit_license":"63854C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUTAL7RL128669","insp_unit_decal":"Y","insp_unit_decal_number":"35884302","created_at":"2026-02-14T10:15:37.000000Z","updated_at":"2026-02-22T10:03:42.000000Z"}]},{"id":11098217,"change_date":"2026-02-10 21:39:00","inspection_id":"87010158","dot_number":"2751005","report_state":"CA","report_number":"ND6S009061","insp_date":"2026-01-29 00:00:00","insp_start_time":"1233","insp_end_time":"1251","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"W\/B ANTELOPE SCALES","county_code_state":"CA","county_code":"067","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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"16165960","transaction_code":"A","transaction_date":"2026-01-29 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2026-02-10 21:39:00","snet_input_date":"2026-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-10 21:39:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2026-02-13T10:37:57.000000Z","updated_at":"2026-02-21T10:31:06.000000Z","inspection_violations":[{"id":18583245,"change_date":"2026-02-10 21:39:00","inspection_id":"87010158","insp_violation_id":"271716899","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211549813","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:52:32.000000Z","updated_at":"2026-02-21T10:40:14.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18926037,"change_date":"2026-02-10 21:39:00","inspection_id":"87010158","insp_unit_id":"211549813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:42.000000Z","updated_at":"2026-02-21T10:04:03.000000Z"}]},{"id":9722020,"change_date":"2025-09-18 21:43:00","inspection_id":"85817868","dot_number":"2751005","report_state":"CA","report_number":"NE1M007203","insp_date":"2025-09-11 00:00:00","insp_start_time":"1002","insp_end_time":"1034","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15986419","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-09-18 21:43:00","snet_input_date":"2025-09-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-18 21:43:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-09-23T10:02:30.000000Z","updated_at":"2025-09-23T10:02:30.000000Z","inspection_violations":[{"id":15961216,"change_date":"2025-09-18 21:43:00","inspection_id":"85817868","insp_violation_id":"268792439","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"209033958","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA670326","created_at":"2025-09-22T10:17:59.000000Z","updated_at":"2025-09-22T10:17:59.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":16098883,"change_date":"2025-09-18 21:43:00","inspection_id":"85817868","insp_unit_id":"209033958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"37\/2XWHTBX","insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:59.000000Z","updated_at":"2025-09-22T09:46:45.000000Z"}]},{"id":9723342,"change_date":"2025-09-18 21:43:00","inspection_id":"85819219","dot_number":"2751005","report_state":"CA","report_number":"UE74003069","insp_date":"2025-09-11 00:00:00","insp_start_time":"1120","insp_end_time":"1159","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15986429","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-09-18 21:43:00","snet_input_date":"2025-09-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-18 21:43:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:31.000000Z","updated_at":"2025-09-23T10:02:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16101018,"change_date":"2025-09-18 21:43:00","inspection_id":"85819219","insp_unit_id":"209036197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"Y","insp_unit_decal_number":"35340449","created_at":"2025-09-21T09:46:01.000000Z","updated_at":"2025-09-22T09:46:54.000000Z"}]},{"id":9660053,"change_date":"2025-09-12 21:50:00","inspection_id":"85752467","dot_number":"2751005","report_state":"CA","report_number":"UDT4001850","insp_date":"2025-09-10 00:00:00","insp_start_time":"1000","insp_end_time":"1020","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":"2025-09-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"15977153","transaction_code":"C","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-09-11 21:42:00","snet_input_date":"2025-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-09-13T10:48:08.000000Z","updated_at":"2025-09-16T10:48:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16001156,"change_date":"2025-09-12 21:50:00","inspection_id":"85752467","insp_unit_id":"208929259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"32192N1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FTBF2AT5DEB41392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:03.000000Z","updated_at":"2025-09-16T09:56:32.000000Z"}]},{"id":9357105,"change_date":"2025-08-07 21:40:00","inspection_id":"85434487","dot_number":"2751005","report_state":"CA","report_number":"UD8N004361","insp_date":"2025-08-07 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"370","location_desc":"N\/OF 66TH, OAKLAND","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15929469","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-08-07 21:40:00","snet_input_date":"2025-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-07 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:02.000000Z","updated_at":"2025-08-12T10:44:02.000000Z","inspection_violations":[{"id":15196969,"change_date":"2025-08-07 21:40:00","inspection_id":"85434487","insp_violation_id":"267901901","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208291404","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:52.000000Z","updated_at":"2025-08-11T10:45:03.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15414923,"change_date":"2025-08-07 21:40:00","inspection_id":"85434487","insp_unit_id":"208291404","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"91912Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5GDHE3616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:24.000000Z","updated_at":"2025-08-11T09:46:16.000000Z"}]},{"id":9145807,"change_date":"2025-07-14 21:41:00","inspection_id":"85212329","dot_number":"2751005","report_state":"CA","report_number":"NE02005766","insp_date":"2025-07-10 00:00:00","insp_start_time":"1403","insp_end_time":"1418","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":"2025-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15896882","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-07-18T10:45:50.000000Z","updated_at":"2025-07-18T10:45:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15019151,"change_date":"2025-07-14 21:41:00","inspection_id":"85212329","insp_unit_id":"207864692","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL843\/W2X","insp_unit_license":"91764X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUTAL4RL128628","insp_unit_decal":"Y","insp_unit_decal_number":"35342810","created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:17.000000Z"}]},{"id":9003795,"change_date":"2025-06-26 21:42:00","inspection_id":"85062671","dot_number":"2751005","report_state":"CA","report_number":"UDXH001115","insp_date":"2025-06-24 00:00:00","insp_start_time":"0951","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"EVANS AVE AND MARIN ST","county_code_state":"CA","county_code":"075","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15867638","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-06-30T10:01:11.000000Z","updated_at":"2025-06-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14766051,"change_date":"2025-06-26 21:42:00","inspection_id":"85062671","insp_unit_id":"207589535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL843","insp_unit_license":"91764X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUTAL4RL128628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:27.000000Z","updated_at":"2025-07-01T09:48:41.000000Z"}]},{"id":7752294,"change_date":"2025-01-30 21:41:00","inspection_id":"83743591","dot_number":"2751005","report_state":"CA","report_number":"UEAO004918","insp_date":"2025-01-27 00:00:00","insp_start_time":"1645","insp_end_time":"1657","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":"2025-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15684703","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0279153","created_at":"2025-03-17T20:59:09.000000Z","updated_at":"2025-03-17T20:59:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12510398,"change_date":"2025-01-30 21:41:00","inspection_id":"83743591","insp_unit_id":"205090677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2XWHT","insp_unit_license":"CX13A76","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUTAL7RL128669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:07.000000Z","updated_at":"2025-03-17T23:53:07.000000Z"}]},{"id":7086485,"change_date":"2024-10-30 21:41:00","inspection_id":"83042509","dot_number":"2751005","report_state":"CA","report_number":"UEGX000929","insp_date":"2024-10-30 00:00:00","insp_start_time":"0530","insp_end_time":"0600","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"I-80 E\/B JEO CORDELIA SCALES","county_code_state":"CA","county_code":"095","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15576564","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-10-30 21:41:00","snet_input_date":"2024-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-30 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T20:43:51.000000Z","updated_at":"2025-03-17T20:43:51.000000Z","inspection_violations":[{"id":11064327,"change_date":"2024-10-30 21:41:00","inspection_id":"83042509","insp_violation_id":"262648835","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":",RH07975","created_at":"2025-03-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"3922SLLTCD"},{"id":11064328,"change_date":"2024-10-30 21:41:00","inspection_id":"83042509","insp_violation_id":"262648836","seq_no":"2","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"3922SLLS4"},{"id":11064329,"change_date":"2024-10-30 21:41:00","inspection_id":"83042509","insp_violation_id":"262648837","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"203667062","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":11428951,"change_date":"2024-10-30 21:41:00","inspection_id":"83042509","insp_unit_id":"203667062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:20.000000Z","updated_at":"2025-03-17T23:41:20.000000Z"}]},{"id":6661229,"change_date":"2024-09-05 21:43:00","inspection_id":"82590365","dot_number":"2751005","report_state":"CA","report_number":"UBGJ005964","insp_date":"2024-09-03 00:00:00","insp_start_time":"1439","insp_end_time":"1537","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15512034","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0279153","created_at":"2025-03-17T20:35:11.000000Z","updated_at":"2025-03-17T20:35:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10739814,"change_date":"2024-09-05 21:43:00","inspection_id":"82590365","insp_unit_id":"202788307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"#37","insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"Y","insp_unit_decal_number":"34151131","created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6023340,"change_date":"2024-06-18 21:43:00","inspection_id":"81907516","dot_number":"2751005","report_state":"CA","report_number":"UG4W001506","insp_date":"2024-06-18 00:00:00","insp_start_time":"0644","insp_end_time":"0706","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"ANTELOPE E\/B","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"24514","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":"2024-06-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15407853","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-06-18 21:43:00","snet_input_date":"2024-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-18 21:43:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T20:22:13.000000Z","updated_at":"2025-03-17T20:22:13.000000Z","inspection_violations":[{"id":9346201,"change_date":"2024-06-18 21:43:00","inspection_id":"81907516","insp_violation_id":"260183813","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"201478366","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:14.000000Z","updated_at":"2025-03-17T21:51:14.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":9701412,"change_date":"2024-06-18 21:43:00","inspection_id":"81907516","insp_unit_id":"201478366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"37","insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:32.000000Z","updated_at":"2025-03-17T23:23:32.000000Z"}]},{"id":5887457,"change_date":"2024-05-31 21:39:00","inspection_id":"81759939","dot_number":"2751005","report_state":"CA","report_number":"UDWG001676","insp_date":"2024-05-31 00:00:00","insp_start_time":"0931","insp_end_time":"0955","registration_date":null,"region":"PT","ci_status_code":"C","location":"590","location_desc":"PARAMOUNT","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15385605","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T20:19:27.000000Z","updated_at":"2025-03-17T20:19:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9482503,"change_date":"2024-05-31 21:39:00","inspection_id":"81759939","insp_unit_id":"201180375","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83827S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDU7FDGR1806","insp_unit_decal":"Y","insp_unit_decal_number":"33839698","created_at":"2025-03-17T23:21:22.000000Z","updated_at":"2025-03-17T23:21:22.000000Z"}]},{"id":5649102,"change_date":"2024-05-01 21:43:00","inspection_id":"81501445","dot_number":"2751005","report_state":"CA","report_number":"NEEU002201","insp_date":"2024-04-29 00:00:00","insp_start_time":"1249","insp_end_time":"1311","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":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15344122","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9099027,"change_date":"2024-05-01 21:43:00","inspection_id":"81501445","insp_unit_id":"200683602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"13\/WHT","insp_unit_license":"89855N1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163E7302165","insp_unit_decal":"Y","insp_unit_decal_number":"33814731","created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5374095,"change_date":"2024-03-26 21:43:00","inspection_id":"81201328","dot_number":"2751005","report_state":"CA","report_number":"NARW002166","insp_date":"2024-03-21 00:00:00","insp_start_time":"1253","insp_end_time":"1311","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":"2024-03-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15294405","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-03-26 21:43:00","snet_input_date":"2024-03-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-26 21:43:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T20:09:05.000000Z","updated_at":"2025-03-17T20:09:05.000000Z","inspection_violations":[{"id":8294602,"change_date":"2024-03-26 21:43:00","inspection_id":"81201328","insp_violation_id":"258597999","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200099953","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW953082","created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"3939A"},{"id":8294603,"change_date":"2024-03-26 21:43:00","inspection_id":"81201328","insp_violation_id":"258598000","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200099953","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"3939A"},{"id":8294604,"change_date":"2024-03-26 21:43:00","inspection_id":"81201328","insp_violation_id":"258598001","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8655050,"change_date":"2024-03-26 21:43:00","inspection_id":"81201328","insp_unit_id":"200099953","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"26\/WHT2X","insp_unit_license":"91912Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5GDHE3616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:31.000000Z","updated_at":"2025-03-17T23:13:31.000000Z"}]},{"id":5246768,"change_date":"2024-03-08 21:40:00","inspection_id":"81062559","dot_number":"2751005","report_state":"CA","report_number":"NC9Y005443","insp_date":"2024-03-05 00:00:00","insp_start_time":"1242","insp_end_time":"1258","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":"2024-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15274209","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-03-08 21:40:00","snet_input_date":"2024-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-08 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:40.000000Z","updated_at":"2025-03-17T20:06:40.000000Z","inspection_violations":[{"id":8091615,"change_date":"2024-03-08 21:40:00","inspection_id":"81062559","insp_violation_id":"258290902","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199829316","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8448730,"change_date":"2024-03-08 21:40:00","inspection_id":"81062559","insp_unit_id":"199829316","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/12","insp_unit_license":"98196M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163E7301100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:33.000000Z","updated_at":"2025-03-17T23:11:33.000000Z"}]},{"id":5236752,"change_date":"2024-03-07 21:39:00","inspection_id":"81051777","dot_number":"2751005","report_state":"CA","report_number":"NARW002113","insp_date":"2024-03-04 00:00:00","insp_start_time":"1243","insp_end_time":"1306","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":"2024-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15271997","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[{"id":8074925,"change_date":"2024-03-07 21:39:00","inspection_id":"81051777","insp_violation_id":"258268558","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199810095","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3922"},{"id":8074926,"change_date":"2024-03-07 21:39:00","inspection_id":"81051777","insp_violation_id":"258268559","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199810095","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8432812,"change_date":"2024-03-07 21:39:00","inspection_id":"81051777","insp_unit_id":"199810095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/2X","insp_unit_license":"91912Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5GDHE3616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:24.000000Z","updated_at":"2025-03-17T23:11:24.000000Z"}]},{"id":4979683,"change_date":"2024-02-05 21:40:00","inspection_id":"80771110","dot_number":"2751005","report_state":"CA","report_number":"NC9Y005361","insp_date":"2024-01-30 00:00:00","insp_start_time":"1012","insp_end_time":"1031","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":"2024-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15224997","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-01-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:17.000000Z","updated_at":"2025-03-17T20:01:17.000000Z","inspection_violations":[{"id":7671129,"change_date":"2024-02-05 21:40:00","inspection_id":"80771110","insp_violation_id":"257671899","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"199274100","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:03.000000Z","updated_at":"2025-03-17T21:43:03.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":8014667,"change_date":"2024-02-05 21:40:00","inspection_id":"80771110","insp_unit_id":"199274100","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/12","insp_unit_license":"98196M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163E7301100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:38.000000Z","updated_at":"2025-03-17T23:07:38.000000Z"}]},{"id":3089247,"change_date":"2023-05-18 21:44:00","inspection_id":"78671317","dot_number":"2751005","report_state":"CA","report_number":"NE8I002203","insp_date":"2023-05-10 00:00:00","insp_start_time":"1347","insp_end_time":"1406","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-05-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14907728","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2023-05-18 21:44:00","snet_input_date":"2023-05-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-18 21:44:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[{"id":4750658,"change_date":"2023-05-18 21:44:00","inspection_id":"78671317","insp_violation_id":"252944523","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195028476","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW951847","created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4969485,"change_date":"2023-05-18 21:44:00","inspection_id":"78671317","insp_unit_id":"195028476","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"13\/WHITE","insp_unit_license":"89855N1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163E7302165","insp_unit_decal":"Y","insp_unit_decal_number":"32473902","created_at":"2025-03-17T22:42:10.000000Z","updated_at":"2025-03-17T22:42:10.000000Z"}]},{"id":2948719,"change_date":"2023-05-02 21:41:00","inspection_id":"78512544","dot_number":"2751005","report_state":"CA","report_number":"NEEU001079","insp_date":"2023-04-29 00:00:00","insp_start_time":"1535","insp_end_time":"1605","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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14884388","transaction_code":"A","transaction_date":"2023-04-29 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4744647,"change_date":"2023-05-02 21:41:00","inspection_id":"78512544","insp_unit_id":"194713217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"37\/WHT","insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"Y","insp_unit_decal_number":"32473834","created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"}]},{"id":2538134,"change_date":"2023-03-08 21:41:00","inspection_id":"78045973","dot_number":"2751005","report_state":"CA","report_number":"UCV3001715","insp_date":"2023-03-08 00:00:00","insp_start_time":"0051","insp_end_time":"0105","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-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14811294","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4085503,"change_date":"2023-03-08 21:41:00","inspection_id":"78045973","insp_unit_id":"193779948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2 AXLE","insp_unit_license":"83827S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDU7FDGR1806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:17.000000Z","updated_at":"2025-03-17T22:35:17.000000Z"}]},{"id":2188012,"change_date":"2023-01-19 21:44:00","inspection_id":"77647164","dot_number":"2751005","report_state":"CA","report_number":"UDWG001216","insp_date":"2023-01-18 00:00:00","insp_start_time":"1034","insp_end_time":"1107","registration_date":null,"region":"PT","ci_status_code":"C","location":"590","location_desc":"PARAMOUNT","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14747995","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2023-01-19 21:44:00","snet_input_date":"2023-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T19:06:57.000000Z","updated_at":"2025-03-17T19:06:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3522004,"change_date":"2023-01-19 21:44:00","inspection_id":"77647164","insp_unit_id":"192972256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"79010H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XD7301724","insp_unit_decal":"Y","insp_unit_decal_number":"32176113","created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"}]},{"id":2188036,"change_date":"2023-01-19 21:44:00","inspection_id":"77647189","dot_number":"2751005","report_state":"CA","report_number":"UDWG001217","insp_date":"2023-01-18 00:00:00","insp_start_time":"1105","insp_end_time":"1135","registration_date":null,"region":"PT","ci_status_code":"C","location":"590","location_desc":"PARAMOUNT","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14747691","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2023-01-19 21:44:00","snet_input_date":"2023-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T19:06:57.000000Z","updated_at":"2025-03-17T19:06:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3522035,"change_date":"2023-01-19 21:44:00","inspection_id":"77647189","insp_unit_id":"192972292","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"75369T1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163F7301096","insp_unit_decal":"Y","insp_unit_decal_number":"32176114","created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"}]},{"id":2188037,"change_date":"2023-01-19 21:44:00","inspection_id":"77647190","dot_number":"2751005","report_state":"CA","report_number":"UDWG001218","insp_date":"2023-01-18 00:00:00","insp_start_time":"1128","insp_end_time":"1153","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"PARAMOUNT","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14748518","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2023-01-19 21:44:00","snet_input_date":"2023-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T19:06:57.000000Z","updated_at":"2025-03-17T19:06:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3522036,"change_date":"2023-01-19 21:44:00","inspection_id":"77647190","insp_unit_id":"192972293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"46380M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC6JDJR5339","insp_unit_decal":"Y","insp_unit_decal_number":"32176115","created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"}]},{"id":1942389,"change_date":"2022-12-13 21:40:00","inspection_id":"77366306","dot_number":"2751005","report_state":"CA","report_number":"UCV3001665","insp_date":"2022-12-13 00:00:00","insp_start_time":"0036","insp_end_time":"0052","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":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14706186","transaction_code":"A","transaction_date":"2022-12-13 00:00:00","upload_date":"2022-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-12-13 21:40:00","snet_input_date":"2022-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0279153","created_at":"2025-03-17T19:02:31.000000Z","updated_at":"2025-03-17T19:02:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3125644,"change_date":"2022-12-13 21:40:00","inspection_id":"77366306","insp_unit_id":"192417233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2 AXLE","insp_unit_license":"8S36225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16X87302006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:25.000000Z","updated_at":"2025-03-17T22:28:25.000000Z"}]},{"id":1791901,"change_date":"2022-11-21 21:42:00","inspection_id":"77193902","dot_number":"2751005","report_state":"CA","report_number":"NE5C000587","insp_date":"2022-11-10 00:00:00","insp_start_time":"1202","insp_end_time":"1241","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":"2022-11-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14681846","transaction_code":"A","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-11-21 21:42:00","snet_input_date":"2022-11-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-21 21:42:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T18:59:39.000000Z","updated_at":"2025-03-17T18:59:39.000000Z","inspection_violations":[{"id":2803517,"change_date":"2022-11-21 21:42:00","inspection_id":"77193902","insp_violation_id":"249730327","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192075395","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2882764,"change_date":"2022-11-21 21:42:00","inspection_id":"77193902","insp_unit_id":"192075395","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"17","insp_unit_license":"8S36225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16X87302006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:43.000000Z","updated_at":"2025-03-17T22:26:43.000000Z"}]},{"id":1427806,"change_date":"2022-10-03 21:41:00","inspection_id":"76774919","dot_number":"2751005","report_state":"CA","report_number":"NCEB004824","insp_date":"2022-09-27 00:00:00","insp_start_time":"1937","insp_end_time":"1955","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14618741","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-10-03 21:41:00","snet_input_date":"2022-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-03 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T18:53:03.000000Z","updated_at":"2025-03-17T18:53:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2299114,"change_date":"2022-10-03 21:41:00","inspection_id":"76774919","insp_unit_id":"191239750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"26 WHITE","insp_unit_license":"91912Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5GDHE3616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:44.000000Z","updated_at":"2025-03-17T22:22:44.000000Z"}]},{"id":1289446,"change_date":"2022-09-14 21:40:00","inspection_id":"76613934","dot_number":"2751005","report_state":"CA","report_number":"UD8N002011","insp_date":"2022-09-13 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF SR-237, SAN JOSE","county_code_state":"CA","county_code":"085","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14593979","transaction_code":"A","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T18:50:28.000000Z","updated_at":"2025-03-17T18:50:28.000000Z","inspection_violations":[{"id":2040930,"change_date":"2022-09-14 21:40:00","inspection_id":"76613934","insp_violation_id":"248423264","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190908034","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:23.000000Z","updated_at":"2025-03-17T21:16:23.000000Z","normalized_code":"3922"},{"id":2040931,"change_date":"2022-09-14 21:40:00","inspection_id":"76613934","insp_violation_id":"248423265","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190908034","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:23.000000Z","updated_at":"2025-03-17T21:16:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2075607,"change_date":"2022-09-14 21:40:00","inspection_id":"76613934","insp_unit_id":"190908034","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"98196M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163E7301100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:15.000000Z","updated_at":"2025-03-17T22:21:15.000000Z"}]},{"id":1000919,"change_date":"2022-08-09 21:41:00","inspection_id":"76278530","dot_number":"2751005","report_state":"CA","report_number":"NCNG005252","insp_date":"2022-08-04 00:00:00","insp_start_time":"0948","insp_end_time":"1015","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":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14539654","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-08-09 21:41:00","snet_input_date":"2022-08-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0279153","created_at":"2025-03-17T18:45:23.000000Z","updated_at":"2025-03-17T18:45:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1610581,"change_date":"2022-08-09 21:41:00","inspection_id":"76278530","insp_unit_id":"190223151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"00247V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7301091","insp_unit_decal":"Y","insp_unit_decal_number":"31470959","created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"}]},{"id":402375,"change_date":"2022-05-16 21:44:00","inspection_id":"75572957","dot_number":"2751005","report_state":"CA","report_number":"UE7F001226","insp_date":"2022-05-11 00:00:00","insp_start_time":"0016","insp_end_time":"0042","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14428327","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-05-16 21:44:00","snet_input_date":"2022-05-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-16 21:44:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"279153","created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":649985,"change_date":"2022-05-16 21:44:00","inspection_id":"75572957","insp_unit_id":"188713116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"13","insp_unit_license":"89855N1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163E7302165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:10.000000Z","updated_at":"2025-03-17T22:12:10.000000Z"}]},{"id":170412,"change_date":"2022-04-13 21:40:00","inspection_id":"75296120","dot_number":"2751005","report_state":"CA","report_number":"UD8N001679","insp_date":"2022-04-13 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF SR-237, SAN JOSE","county_code_state":"CA","county_code":"085","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14385399","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:30.000000Z","updated_at":"2025-03-17T18:30:30.000000Z","inspection_violations":[{"id":256288,"change_date":"2022-04-13 21:40:00","inspection_id":"75296120","insp_violation_id":"245141987","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"38323A2"},{"id":256289,"change_date":"2022-04-13 21:40:00","inspection_id":"75296120","insp_violation_id":"245141988","seq_no":"2","part_no":"396","part_no_section":"7","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CQ035554","created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":276273,"change_date":"2022-04-13 21:40:00","inspection_id":"75296120","insp_unit_id":"188141528","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"90730Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML1ML080516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:52.000000Z","updated_at":"2025-03-17T22:09:52.000000Z"}]},{"id":170448,"change_date":"2022-04-13 21:40:00","inspection_id":"75296163","dot_number":"2751005","report_state":"CA","report_number":"UD8N001682","insp_date":"2022-04-13 00:00:00","insp_start_time":"1050","insp_end_time":"1123","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF SR-237, SAN JOSE","county_code_state":"CA","county_code":"085","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54250","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":"14385229","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02751005","upload_search_indicator":null,"census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"BAYVIEW DEMOLITION SERVICES","insp_carrier_street":"6925 SAN LEANDRO ST","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94621","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:30.000000Z","updated_at":"2025-03-17T18:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":276325,"change_date":"2022-04-13 21:40:00","inspection_id":"75296163","insp_unit_id":"188141602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"07782C2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X5GJ114954","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:52.000000Z","updated_at":"2025-03-17T22:09:52.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2751005\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2751005\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2751005\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2751005\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}