{"current_page":1,"data":[{"id":12198147,"change_date":"2026-06-16 21:39:00","inspection_id":"88154766","dot_number":"2728459","report_state":"CA","report_number":"UD4G004589","insp_date":"2026-06-15 00:00:00","insp_start_time":"0815","insp_end_time":"0835","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"106820","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":"3550265","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-06-19T09:42:36.000000Z","updated_at":"2026-06-26T09:32:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21186967,"change_date":"2026-06-16 21:39:00","inspection_id":"88154766","insp_unit_id":"214124975","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-024","insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:05.000000Z","updated_at":"2026-06-26T09:04:00.000000Z"},{"id":21186968,"change_date":"2026-06-16 21:39:00","inspection_id":"88154766","insp_unit_id":"214124976","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":null,"insp_unit_license":"4RW2344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5UCPR3724JA003590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:05.000000Z","updated_at":"2026-06-26T09:04:00.000000Z"}]},{"id":12192884,"change_date":"2026-06-15 21:41:00","inspection_id":"88148920","dot_number":"2728459","report_state":"CA","report_number":"UDM7005148","insp_date":"2026-06-15 00:00:00","insp_start_time":"1102","insp_end_time":"1125","registration_date":null,"region":"PS","ci_status_code":"C","location":"320","location_desc":"CA","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BAY CITIES","shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","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":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3549191","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-18T09:41:03.000000Z","updated_at":"2026-06-26T09:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21177794,"change_date":"2026-06-15 21:41:00","inspection_id":"88148920","insp_unit_id":"214111707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"05141T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X0KJ367786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:56.000000Z","updated_at":"2026-06-26T09:02:37.000000Z"}]},{"id":12181570,"change_date":"2026-06-13 21:35:00","inspection_id":"88136917","dot_number":"2728459","report_state":"CA","report_number":"NC3S012026","insp_date":"2026-06-12 00:00:00","insp_start_time":"0520","insp_end_time":"0600","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":"BAY CITIES PAVING & GRADING INC","shipping_paper_number":"MSDS","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3536967","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158798,"change_date":"2026-06-13 21:35:00","inspection_id":"88136917","insp_unit_id":"214089791","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"Y","insp_unit_decal_number":"36187222","created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":12150239,"change_date":"2026-06-10 21:44:00","inspection_id":"88099350","dot_number":"2728459","report_state":"CA","report_number":"UGL7000260","insp_date":"2026-06-10 00:00:00","insp_start_time":"0820","insp_end_time":"0850","registration_date":null,"region":"PS","ci_status_code":"C","location":"850","location_desc":"CA","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2","hazmat_oos_total":"0","snet_sequence_id":"3512304","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:31.000000Z","updated_at":"2026-06-21T09:31:23.000000Z","inspection_violations":[{"id":21146652,"change_date":"2026-06-10 21:44:00","inspection_id":"88099350","insp_violation_id":"274819677","seq_no":"1","part_no":"172","part_no_section":"516C6-HMPMC","insp_viol_unit":"1","insp_unit_id":"214018497","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:44.000000Z","updated_at":"2026-06-21T09:45:44.000000Z","normalized_code":"172516C6HMPMC"},{"id":21146653,"change_date":"2026-06-10 21:44:00","inspection_id":"88099350","insp_violation_id":"274819678","seq_no":"2","part_no":"397","part_no_section":"3-SLL","insp_viol_unit":"1","insp_unit_id":"214018497","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:44.000000Z","updated_at":"2026-06-21T09:45:44.000000Z","normalized_code":"3973SLL"},{"id":21146654,"change_date":"2026-06-10 21:44:00","inspection_id":"88099350","insp_violation_id":"274819679","seq_no":"3","part_no":"107","part_no_section":"620B-HMAMC","insp_viol_unit":"1","insp_unit_id":"214018497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:44.000000Z","updated_at":"2026-06-21T09:45:44.000000Z","normalized_code":"107620BHMAMC"}],"inspection_per_units":[{"id":21106899,"change_date":"2026-06-10 21:44:00","inspection_id":"88099350","insp_unit_id":"214018497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"05141T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X0KJ367786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:58.000000Z","updated_at":"2026-06-21T09:02:36.000000Z"}]},{"id":12181751,"change_date":"2026-06-13 21:35:00","inspection_id":"88137103","dot_number":"2728459","report_state":"CA","report_number":"NDUP008384","insp_date":"2026-06-10 00:00:00","insp_start_time":"0834","insp_end_time":"0909","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":"OTH","hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3536386","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21159099,"change_date":"2026-06-13 21:35:00","inspection_id":"88137103","insp_unit_id":"214090108","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-026 2X","insp_unit_license":"07517V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X0LM427335","insp_unit_decal":"Y","insp_unit_decal_number":"36186228","created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":11872484,"change_date":"2026-05-11 21:38:00","inspection_id":"87809618","dot_number":"2728459","report_state":"CA","report_number":"UEED003670","insp_date":"2026-05-07 00:00:00","insp_start_time":"0955","insp_end_time":"1005","registration_date":null,"region":"PS","ci_status_code":"C","location":"390","location_desc":"CA","county_code_state":"CA","county_code":"013","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":"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-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3300663","transaction_code":"A","transaction_date":"2026-05-11 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-05-11 21:38:00","snet_input_date":"2026-05-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-11 21:38:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-05-13T13:15:22.000000Z","updated_at":"2026-05-22T09:30:36.000000Z","inspection_violations":[{"id":20650338,"change_date":"2026-05-11 21:38:00","inspection_id":"87809618","insp_violation_id":"274166924","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213477257","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:36.000000Z","updated_at":"2026-05-22T09:42:06.000000Z","normalized_code":"3922SLLSR"},{"id":20650337,"change_date":"2026-05-11 21:38:00","inspection_id":"87809618","insp_violation_id":"274166923","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"213477257","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:36.000000Z","updated_at":"2026-05-22T09:42:06.000000Z","normalized_code":"3922SLL"},{"id":20650339,"change_date":"2026-05-11 21:38:00","inspection_id":"87809618","insp_violation_id":"274166925","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213477257","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:36.000000Z","updated_at":"2026-05-22T09:42:06.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20643787,"change_date":"2026-05-11 21:38:00","inspection_id":"87809618","insp_unit_id":"213477257","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"78726N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W16XL7306792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:01.000000Z","updated_at":"2026-05-22T09:03:03.000000Z"}]},{"id":11703547,"change_date":"2026-04-20 21:39:00","inspection_id":"87630092","dot_number":"2728459","report_state":"CA","report_number":"UEAO006174","insp_date":"2026-04-18 00:00:00","insp_start_time":"1506","insp_end_time":"1522","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"155000","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":"16253648","transaction_code":"A","transaction_date":"2026-04-18 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-04-20 21:39:00","snet_input_date":"2026-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-20 21:39:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:36:56.000000Z","updated_at":"2026-05-01T09:31:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20367249,"change_date":"2026-04-20 21:39:00","inspection_id":"87630092","insp_unit_id":"213126520","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X","insp_unit_license":"9F39209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ245147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:49.000000Z","updated_at":"2026-05-01T09:05:17.000000Z"},{"id":20367250,"change_date":"2026-04-20 21:39:00","inspection_id":"87630092","insp_unit_id":"213126521","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":"44010","insp_unit_license":"4FU5875","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B4920X3A056263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:49.000000Z","updated_at":"2026-05-01T09:05:17.000000Z"}]},{"id":11670089,"change_date":"2026-04-16 21:41:00","inspection_id":"87600543","dot_number":"2728459","report_state":"CA","report_number":"UFA3003418","insp_date":"2026-04-13 00:00:00","insp_start_time":"0810","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"EB ANTELOPE SCALE","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"158000","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":"16248931","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-04-27T09:32:17.000000Z","updated_at":"2026-04-27T09:32:17.000000Z","inspection_violations":[{"id":20269266,"change_date":"2026-04-16 21:41:00","inspection_id":"87600543","insp_violation_id":"273657804","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"213062062","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-27T09:45:54.000000Z","updated_at":"2026-04-27T09:45:54.000000Z","normalized_code":"393100BC"},{"id":20269265,"change_date":"2026-04-16 21:41:00","inspection_id":"87600543","insp_violation_id":"273657803","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"213062061","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:54.000000Z","updated_at":"2026-04-27T09:45:54.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":20299948,"change_date":"2026-04-16 21:41:00","inspection_id":"87600543","insp_unit_id":"213062061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05-009","insp_unit_license":"9F39209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ245147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:47.000000Z","updated_at":"2026-04-27T09:05:47.000000Z"},{"id":20299949,"change_date":"2026-04-16 21:41:00","inspection_id":"87600543","insp_unit_id":"213062062","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":"44010","insp_unit_license":"4FU5875","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B4920X3A056263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:47.000000Z","updated_at":"2026-04-27T09:05:47.000000Z"}]},{"id":11548632,"change_date":"2026-04-01 21:40:00","inspection_id":"87471369","dot_number":"2728459","report_state":"CA","report_number":"UD4G004423","insp_date":"2026-03-30 00:00:00","insp_start_time":"1202","insp_end_time":"1235","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","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":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16231094","transaction_code":"A","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-04-04T09:43:39.000000Z","updated_at":"2026-04-12T09:33:14.000000Z","inspection_violations":[{"id":19513172,"change_date":"2026-04-01 21:40:00","inspection_id":"87471369","insp_violation_id":"272811852","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RJ34748","created_at":"2026-04-03T10:13:47.000000Z","updated_at":"2026-04-11T09:50:05.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":19788501,"change_date":"2026-04-01 21:40:00","inspection_id":"87471369","insp_unit_id":"212491896","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:53.000000Z","updated_at":"2026-04-12T09:12:24.000000Z"}]},{"id":11546651,"change_date":"2026-04-01 21:40:00","inspection_id":"87469309","dot_number":"2728459","report_state":"CA","report_number":"NBH6007778","insp_date":"2026-03-26 00:00:00","insp_start_time":"0839","insp_end_time":"0915","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":"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":"148000","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":"16230154","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":"02728459","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","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 CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2026-04-04T09:43:36.000000Z","updated_at":"2026-04-12T09:32:54.000000Z","inspection_violations":[{"id":19510456,"change_date":"2026-04-01 21:40:00","inspection_id":"87469309","insp_violation_id":"272808710","seq_no":"2","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"212488479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:41.000000Z","updated_at":"2026-04-11T09:49:41.000000Z","normalized_code":"3963A1BALAC"},{"id":19510457,"change_date":"2026-04-01 21:40:00","inspection_id":"87469309","insp_violation_id":"272808711","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"212488479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:41.000000Z","updated_at":"2026-04-11T09:49:41.000000Z","normalized_code":"39345B2BHTD"},{"id":19510455,"change_date":"2026-04-01 21:40:00","inspection_id":"87469309","insp_violation_id":"272808709","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"212488479","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:41.000000Z","updated_at":"2026-04-11T09:49:41.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":19785368,"change_date":"2026-04-01 21:40:00","inspection_id":"87469309","insp_unit_id":"212488478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05-010","insp_unit_license":"9F01922","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ352747","insp_unit_decal":"Y","insp_unit_decal_number":"35881356","created_at":"2026-04-04T09:21:51.000000Z","updated_at":"2026-04-12T09:11:57.000000Z"},{"id":19785369,"change_date":"2026-04-01 21:40:00","inspection_id":"87469309","insp_unit_id":"212488479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":"44-006","insp_unit_license":"4SH6653","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B472085A056415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:51.000000Z","updated_at":"2026-04-12T09:11:57.000000Z"}]},{"id":11479332,"change_date":"2026-03-25 21:40:00","inspection_id":"87398396","dot_number":"2728459","report_state":"CA","report_number":"UEW3000260","insp_date":"2026-03-24 00:00:00","insp_start_time":"1355","insp_end_time":"1425","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB PLATFORM SCALE","county_code_state":"CA","county_code":"013","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16222478","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:51.000000Z","updated_at":"2026-04-05T09:33:09.000000Z","inspection_violations":[{"id":19378811,"change_date":"2026-03-25 21:40:00","inspection_id":"87398396","insp_violation_id":"272643109","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:07.000000Z","updated_at":"2026-04-05T10:02:09.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":19663023,"change_date":"2026-03-25 21:40:00","inspection_id":"87398396","insp_unit_id":"212339022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"56156B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B6KS802124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:03.000000Z","updated_at":"2026-04-05T09:19:27.000000Z"}]},{"id":9774211,"change_date":"2025-09-24 21:42:00","inspection_id":"85872213","dot_number":"2728459","report_state":"CA","report_number":"NBH6007205","insp_date":"2025-09-23 00:00:00","insp_start_time":"0751","insp_end_time":"0818","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":"Y","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-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"15993715","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-09-26T10:01:20.000000Z","updated_at":"2025-09-28T10:00:56.000000Z","inspection_violations":[{"id":16066184,"change_date":"2025-09-24 21:42:00","inspection_id":"85872213","insp_violation_id":"268909537","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209134185","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:15.000000Z","updated_at":"2025-09-28T10:16:32.000000Z","normalized_code":"3965BL"},{"id":16066185,"change_date":"2025-09-24 21:42:00","inspection_id":"85872213","insp_violation_id":"268909538","seq_no":"2","part_no":"397","part_no_section":"3-SLL","insp_viol_unit":"1","insp_unit_id":"209134185","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:15.000000Z","updated_at":"2025-09-28T10:16:32.000000Z","normalized_code":"3973SLL"}],"inspection_per_units":[{"id":16192583,"change_date":"2025-09-24 21:42:00","inspection_id":"85872213","insp_unit_id":"209134185","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:27.000000Z","updated_at":"2025-09-29T09:46:27.000000Z"}]},{"id":9657242,"change_date":"2025-09-12 21:50:00","inspection_id":"85740203","dot_number":"2728459","report_state":"CA","report_number":"UED8001639","insp_date":"2025-09-10 00:00:00","insp_start_time":"1221","insp_end_time":"1243","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"SB WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"N","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-10 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":"15974968","transaction_code":"C","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-09-10 21:41:00","snet_input_date":"2025-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-10 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-09-13T10:48:04.000000Z","updated_at":"2025-09-16T10:48:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15997563,"change_date":"2025-09-12 21:50:00","inspection_id":"85740203","insp_unit_id":"208922852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"56580P3C","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK4NH772971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:01.000000Z","updated_at":"2025-09-16T09:56:18.000000Z"}]},{"id":9636702,"change_date":"2025-09-09 21:41:00","inspection_id":"85728006","dot_number":"2728459","report_state":"CA","report_number":"UED8001627","insp_date":"2025-09-09 00:00:00","insp_start_time":"0537","insp_end_time":"0558","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"SB WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"106320","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":"15972556","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-09-09 21:41:00","snet_input_date":"2025-09-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-09-11T10:47:16.000000Z","updated_at":"2025-09-13T10:47:21.000000Z","inspection_violations":[{"id":15768863,"change_date":"2025-09-09 21:41:00","inspection_id":"85728006","insp_violation_id":"268565736","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"208837621","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:42.000000Z","updated_at":"2025-09-13T10:50:15.000000Z","normalized_code":"39355D2B"},{"id":15768864,"change_date":"2025-09-09 21:41:00","inspection_id":"85728006","insp_violation_id":"268565737","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"208837622","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:42.000000Z","updated_at":"2025-09-13T10:50:15.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":15920854,"change_date":"2025-09-09 21:41:00","inspection_id":"85728006","insp_unit_id":"208837621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-024","insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:52.000000Z","updated_at":"2025-09-13T10:00:12.000000Z"},{"id":15920855,"change_date":"2025-09-09 21:41:00","inspection_id":"85728006","insp_unit_id":"208837622","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"44018","insp_unit_license":"4RW2344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5UCPR3724JA003590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:52.000000Z","updated_at":"2025-09-13T10:00:12.000000Z"}]},{"id":9526393,"change_date":"2025-08-27 21:41:00","inspection_id":"85612342","dot_number":"2728459","report_state":"CA","report_number":"UDLV004510","insp_date":"2025-08-27 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"N","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-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2","hazmat_oos_total":"1","snet_sequence_id":"15956266","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-08-27 21:41:00","snet_input_date":"2025-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-27 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:27.000000Z","updated_at":"2025-09-06T10:41:59.000000Z","inspection_violations":[{"id":15547580,"change_date":"2025-08-27 21:41:00","inspection_id":"85612342","insp_violation_id":"268297482","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"208621867","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:43.000000Z","updated_at":"2025-09-06T10:45:14.000000Z","normalized_code":"3922SLL"},{"id":15547581,"change_date":"2025-08-27 21:41:00","inspection_id":"85612342","insp_violation_id":"268297483","seq_no":"2","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"208621867","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW891914","created_at":"2025-09-05T10:50:43.000000Z","updated_at":"2025-09-06T10:45:14.000000Z","normalized_code":"177834AHMC"},{"id":15547582,"change_date":"2025-08-27 21:41:00","inspection_id":"85612342","insp_violation_id":"268297484","seq_no":"3","part_no":"172","part_no_section":"406F-HML","insp_viol_unit":"1","insp_unit_id":"208621867","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW891914","created_at":"2025-09-05T10:50:43.000000Z","updated_at":"2025-09-06T10:45:14.000000Z","normalized_code":"172406FHML"}],"inspection_per_units":[{"id":15722130,"change_date":"2025-08-27 21:41:00","inspection_id":"85612342","insp_unit_id":"208621867","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"56580P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK4NH772971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:44.000000Z","updated_at":"2025-09-09T09:46:24.000000Z"}]},{"id":9367987,"change_date":"2025-08-08 21:40:00","inspection_id":"85445771","dot_number":"2728459","report_state":"CA","report_number":"UD4G003918","insp_date":"2025-08-07 00:00:00","insp_start_time":"1220","insp_end_time":"1245","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-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15929856","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":"02728459","upload_search_indicator":null,"census_search_date":"2025-08-08 21:40:00","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 CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-08-12T10:44:18.000000Z","updated_at":"2025-08-12T10:44:18.000000Z","inspection_violations":[{"id":15219434,"change_date":"2025-08-08 21:40:00","inspection_id":"85445771","insp_violation_id":"267927028","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208312059","insp_violation_category_id":"28","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:46:01.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":15434073,"change_date":"2025-08-08 21:40:00","inspection_id":"85445771","insp_unit_id":"208312059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"03-041","insp_unit_license":"56156B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B6KS802124","insp_unit_decal":"Y","insp_unit_decal_number":"35339353","created_at":"2025-08-11T09:46:29.000000Z","updated_at":"2025-08-12T09:46:19.000000Z"}]},{"id":9191630,"change_date":"2025-07-18 21:40:00","inspection_id":"85260224","dot_number":"2728459","report_state":"CA","report_number":"UBZU004692","insp_date":"2025-07-15 00:00:00","insp_start_time":"0830","insp_end_time":"0905","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15905242","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-07-18 21:40:00","snet_input_date":"2025-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-18 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:39.000000Z","updated_at":"2025-07-22T10:45:25.000000Z","inspection_violations":[{"id":14848252,"change_date":"2025-07-18 21:40:00","inspection_id":"85260224","insp_violation_id":"267507179","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207958002","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:46:25.000000Z","updated_at":"2025-07-22T10:46:52.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":15105867,"change_date":"2025-07-18 21:40:00","inspection_id":"85260224","insp_unit_id":"207958002","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"03-041","insp_unit_license":"56156B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B6KS802124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:39.000000Z","updated_at":"2025-07-22T09:46:07.000000Z"}]},{"id":9091743,"change_date":"2025-07-09 08:53:00","inspection_id":"85155817","dot_number":"2728459","report_state":"CA","report_number":"UEGX001790","insp_date":"2025-07-08 00:00:00","insp_start_time":"1240","insp_end_time":"1310","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","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-07-09 08:53:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"15889264","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-07-09 08:53:00","snet_input_date":"2025-07-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 08:53:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-07-12T10:44:59.000000Z","updated_at":"2025-07-14T10:45:18.000000Z","inspection_violations":[{"id":14644214,"change_date":"2025-07-09 08:53:00","inspection_id":"85155817","insp_violation_id":"267273058","seq_no":"1","part_no":"107","part_no_section":"620B-HMAMC","insp_viol_unit":"1","insp_unit_id":"207757635","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-13T10:48:39.000000Z","updated_at":"2025-07-13T10:48:39.000000Z","normalized_code":"107620BHMAMC"},{"id":14644215,"change_date":"2025-07-09 08:53:00","inspection_id":"85155817","insp_violation_id":"267273059","seq_no":"2","part_no":"397","part_no_section":"3-SLL","insp_viol_unit":"1","insp_unit_id":"207757635","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-13T10:48:39.000000Z","updated_at":"2025-07-13T10:48:39.000000Z","normalized_code":"3973SLL"}],"inspection_per_units":[{"id":14920661,"change_date":"2025-07-09 08:53:00","inspection_id":"85155817","insp_unit_id":"207757635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"05141T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X0KJ367786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:39.000000Z","updated_at":"2025-07-13T09:45:09.000000Z"}]},{"id":8999196,"change_date":"2025-06-26 21:41:00","inspection_id":"85057925","dot_number":"2728459","report_state":"CA","report_number":"NDUP007150","insp_date":"2025-06-12 00:00:00","insp_start_time":"1045","insp_end_time":"1118","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":"NA","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15872668","transaction_code":"A","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-06-30T10:01:06.000000Z","updated_at":"2025-06-30T10:01:06.000000Z","inspection_violations":[{"id":14468428,"change_date":"2025-06-26 21:41:00","inspection_id":"85057925","insp_violation_id":"267072310","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207581674","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:55.000000Z","updated_at":"2025-06-30T10:18:23.000000Z","normalized_code":"3965BL"},{"id":14468429,"change_date":"2025-06-26 21:41:00","inspection_id":"85057925","insp_violation_id":"267072311","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207581674","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:55.000000Z","updated_at":"2025-06-30T10:18:23.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14758555,"change_date":"2025-06-26 21:41:00","inspection_id":"85057925","insp_unit_id":"207581674","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016 2X","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"Y","insp_unit_decal_number":"35063517","created_at":"2025-06-29T09:46:22.000000Z","updated_at":"2025-07-01T09:48:11.000000Z"}]},{"id":8717194,"change_date":"2025-05-22 21:43:00","inspection_id":"84758979","dot_number":"2728459","report_state":"CA","report_number":"UEQZ000258","insp_date":"2025-05-21 00:00:00","insp_start_time":"1235","insp_end_time":"1255","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"US 101 SB JSO ST VINCENT","county_code_state":"CA","county_code":"041","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":"2025-05-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15831868","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-05-22 21:43:00","snet_input_date":"2025-05-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-22 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-25T10:06:13.000000Z","updated_at":"2025-05-26T10:07:13.000000Z","inspection_violations":[{"id":13905074,"change_date":"2025-05-22 21:43:00","inspection_id":"84758979","insp_violation_id":"266430972","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":null,"created_at":"2025-05-25T10:29:05.000000Z","updated_at":"2025-05-26T10:29:03.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":14248934,"change_date":"2025-05-22 21:43:00","inspection_id":"84758979","insp_unit_id":"207026809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"56156B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B6KS802124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:51:08.000000Z","updated_at":"2025-05-26T09:52:32.000000Z"}]},{"id":8611094,"change_date":"2025-05-12 21:41:00","inspection_id":"84647179","dot_number":"2728459","report_state":"CA","report_number":"UEX8004596","insp_date":"2025-05-09 00:00:00","insp_start_time":"0910","insp_end_time":"0934","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAY CITIES PAVING\/GRADING","shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"15815595","transaction_code":"A","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-05-12 21:41:00","snet_input_date":"2025-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-12 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-05-15T10:01:24.000000Z","updated_at":"2025-05-17T10:06:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14057846,"change_date":"2025-05-12 21:41:00","inspection_id":"84647179","insp_unit_id":"206817475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/06-024","insp_unit_license":"05141T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X0KJ367786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:26.000000Z","updated_at":"2025-05-16T09:52:29.000000Z"}]},{"id":8621848,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","dot_number":"2728459","report_state":"CA","report_number":"NF37001310","insp_date":"2025-05-06 00:00:00","insp_start_time":"0804","insp_end_time":"0850","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-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"15817415","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-05-17T10:04:23.000000Z","updated_at":"2025-05-17T10:09:45.000000Z","inspection_violations":[{"id":13708445,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_violation_id":"266201084","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"206838881","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-16T10:36:51.000000Z","updated_at":"2025-05-18T10:27:00.000000Z","normalized_code":"39345B2BHTD"},{"id":13708446,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_violation_id":"266201085","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"206838882","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA670220","created_at":"2025-05-16T10:36:51.000000Z","updated_at":"2025-05-18T10:27:00.000000Z","normalized_code":"39375A3TAOL"},{"id":13708447,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_violation_id":"266201086","seq_no":"3","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"206838882","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-16T10:36:51.000000Z","updated_at":"2025-05-18T10:27:00.000000Z","normalized_code":"3963A1BALAC"},{"id":13708448,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_violation_id":"266201087","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206838882","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-16T10:36:51.000000Z","updated_at":"2025-05-18T10:27:00.000000Z","normalized_code":"39347E"},{"id":13708449,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_violation_id":"266201088","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"206838882","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-16T10:36:51.000000Z","updated_at":"2025-05-18T10:27:00.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":14077748,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_unit_id":"206838881","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05-010","insp_unit_license":"9F01922","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ352747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:53.000000Z","updated_at":"2025-05-17T09:51:50.000000Z"},{"id":14077749,"change_date":"2025-05-13 21:41:00","inspection_id":"84658689","insp_unit_id":"206838882","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":"44-006","insp_unit_license":"4SH6653","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B472085A056415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:53.000000Z","updated_at":"2025-05-17T09:51:50.000000Z"}]},{"id":7818800,"change_date":"2025-02-07 21:41:00","inspection_id":"83813626","dot_number":"2728459","report_state":"CA","report_number":"UDLV003976","insp_date":"2025-02-07 00:00:00","insp_start_time":"1012","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"N","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-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15697295","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-02-07 21:41:00","snet_input_date":"2025-02-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-07 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T21:00:23.000000Z","updated_at":"2025-03-17T21:00:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12618046,"change_date":"2025-02-07 21:41:00","inspection_id":"83813626","insp_unit_id":"205225277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-023","insp_unit_license":"73352G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7X0JM201775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:23.000000Z","updated_at":"2025-03-17T23:54:23.000000Z"}]},{"id":7644587,"change_date":"2025-01-16 21:41:00","inspection_id":"83630474","dot_number":"2728459","report_state":"CA","report_number":"UEGX001229","insp_date":"2025-01-16 00:00:00","insp_start_time":"0430","insp_end_time":"0500","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15664741","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:57:00.000000Z","updated_at":"2025-03-17T20:57:00.000000Z","inspection_violations":[{"id":11944649,"change_date":"2025-01-16 21:41:00","inspection_id":"83630474","insp_violation_id":"264046566","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204882198","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:04:13.000000Z","updated_at":"2025-03-17T22:04:13.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12334810,"change_date":"2025-01-16 21:41:00","inspection_id":"83630474","insp_unit_id":"204882198","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:06.000000Z","updated_at":"2025-03-17T23:51:06.000000Z"}]},{"id":7610665,"change_date":"2025-01-13 21:46:00","inspection_id":"83595047","dot_number":"2728459","report_state":"CA","report_number":"UEED002868","insp_date":"2025-01-09 00:00:00","insp_start_time":"0925","insp_end_time":"0941","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"JSO JACK LONDON BLVD","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-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15657633","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:56:08.000000Z","updated_at":"2025-03-17T20:56:08.000000Z","inspection_violations":[{"id":11897464,"change_date":"2025-01-13 21:46:00","inspection_id":"83595047","insp_violation_id":"263920098","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204790592","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922SLLEQP"},{"id":11897465,"change_date":"2025-01-13 21:46:00","inspection_id":"83595047","insp_violation_id":"263920099","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"204790592","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":12280323,"change_date":"2025-01-13 21:46:00","inspection_id":"83595047","insp_unit_id":"204790592","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2XL","insp_unit_license":"02250H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMAALXEL780213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7521515,"change_date":"2024-12-30 21:39:00","inspection_id":"83501327","dot_number":"2728459","report_state":"CA","report_number":"NEEU002790","insp_date":"2024-12-26 00:00:00","insp_start_time":"0919","insp_end_time":"0946","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":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"158000","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":"15644864","transaction_code":"A","transaction_date":"2024-12-26 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[{"id":11757288,"change_date":"2024-12-30 21:39:00","inspection_id":"83501327","insp_violation_id":"263701932","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204597745","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW392491","created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39375A3TAOL"},{"id":11757289,"change_date":"2024-12-30 21:39:00","inspection_id":"83501327","insp_violation_id":"263701933","seq_no":"2","part_no":"393","part_no_section":"130B-CHVE","insp_viol_unit":"2","insp_unit_id":"204597746","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"393130BCHVE"},{"id":11757290,"change_date":"2024-12-30 21:39:00","inspection_id":"83501327","insp_violation_id":"263701934","seq_no":"3","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"204597746","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":12134578,"change_date":"2024-12-30 21:39:00","inspection_id":"83501327","insp_unit_id":"204597745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05-009\/3X","insp_unit_license":"9F39209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ245147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"},{"id":12134579,"change_date":"2024-12-30 21:39:00","inspection_id":"83501327","insp_unit_id":"204597746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":"44010\/2X","insp_unit_license":"4FU5875","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B4920X3A056263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"}]},{"id":7224067,"change_date":"2024-11-18 21:41:00","inspection_id":"83188295","dot_number":"2728459","report_state":"CA","report_number":"UD2M002592","insp_date":"2024-11-18 00:00:00","insp_start_time":"0830","insp_end_time":"0856","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"LOS BANOS AREA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":"NON SERIALIZED","cargo_tank":"NON","hazmat_placard_req":"Y","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-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"15597343","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[{"id":11291973,"change_date":"2024-11-18 21:41:00","inspection_id":"83188295","insp_violation_id":"262964731","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"203941940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"3922SLLEQP"},{"id":11291974,"change_date":"2024-11-18 21:41:00","inspection_id":"83188295","insp_violation_id":"262964732","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"203941940","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"39360D"},{"id":11291975,"change_date":"2024-11-18 21:41:00","inspection_id":"83188295","insp_violation_id":"262964733","seq_no":"3","part_no":"172","part_no_section":"604A3-HMER","insp_viol_unit":"1","insp_unit_id":"203941940","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"172604A3HMER"}],"inspection_per_units":[{"id":11652500,"change_date":"2024-11-18 21:41:00","inspection_id":"83188295","insp_unit_id":"203941940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"95253M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7X3KM258974","insp_unit_decal":"Y","insp_unit_decal_number":"34478890","created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":7262308,"change_date":"2024-11-22 21:41:00","inspection_id":"83228643","dot_number":"2728459","report_state":"CA","report_number":"NARN004993","insp_date":"2024-11-15 00:00:00","insp_start_time":"1445","insp_end_time":"1512","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"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":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15602522","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":11354291,"change_date":"2024-11-22 21:41:00","inspection_id":"83228643","insp_violation_id":"263051725","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"1","insp_unit_id":"204018365","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":11714213,"change_date":"2024-11-22 21:41:00","inspection_id":"83228643","insp_unit_id":"204018365","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-025","insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":7263811,"change_date":"2024-11-22 21:41:00","inspection_id":"83230187","dot_number":"2728459","report_state":"CA","report_number":"UBZU004038","insp_date":"2024-11-06 00:00:00","insp_start_time":"0705","insp_end_time":"0740","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAB CARD 1000GAL TANK","shipping_paper_number":"COMPANY","cargo_tank":"NON","hazmat_placard_req":"Y","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15604707","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:47:41.000000Z","updated_at":"2025-03-17T20:47:41.000000Z","inspection_violations":[{"id":11355647,"change_date":"2024-11-22 21:41:00","inspection_id":"83230187","insp_violation_id":"263053206","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"204020773","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:08.000000Z","updated_at":"2025-03-17T22:01:08.000000Z","normalized_code":"3965BL"},{"id":11355648,"change_date":"2024-11-22 21:41:00","inspection_id":"83230187","insp_violation_id":"263053207","seq_no":"2","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"204020773","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:08.000000Z","updated_at":"2025-03-17T22:01:08.000000Z","normalized_code":"3963A1OAL"},{"id":11355649,"change_date":"2024-11-22 21:41:00","inspection_id":"83230187","insp_violation_id":"263053208","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204020773","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:08.000000Z","updated_at":"2025-03-17T22:01:08.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11716466,"change_date":"2024-11-22 21:41:00","inspection_id":"83230187","insp_unit_id":"204020773","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"}]},{"id":7262409,"change_date":"2024-11-22 21:41:00","inspection_id":"83228747","dot_number":"2728459","report_state":"CA","report_number":"NE28005378","insp_date":"2024-11-05 00:00:00","insp_start_time":"1844","insp_end_time":"1905","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"15604690","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":11354399,"change_date":"2024-11-22 21:41:00","inspection_id":"83228747","insp_violation_id":"263051849","seq_no":"1","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"2","insp_unit_id":"204018542","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RJ33194","created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39311A1LTSM"}],"inspection_per_units":[{"id":11714378,"change_date":"2024-11-22 21:41:00","inspection_id":"83228747","insp_unit_id":"204018541","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05-009","insp_unit_license":"9F39209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ245147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"},{"id":11714379,"change_date":"2024-11-22 21:41:00","inspection_id":"83228747","insp_unit_id":"204018542","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":"44-017","insp_unit_license":"4PV1129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9G44202GA056904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":7263836,"change_date":"2024-11-22 21:41:00","inspection_id":"83230215","dot_number":"2728459","report_state":"CA","report_number":"UCV0000252","insp_date":"2024-11-05 00:00:00","insp_start_time":"2121","insp_end_time":"2145","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","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":"15603955","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0010751","created_at":"2025-03-17T20:47:41.000000Z","updated_at":"2025-03-17T20:47:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11716509,"change_date":"2024-11-22 21:41:00","inspection_id":"83230215","insp_unit_id":"204020822","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-025","insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"}]},{"id":7064620,"change_date":"2024-10-28 21:40:00","inspection_id":"83019349","dot_number":"2728459","report_state":"CA","report_number":"NE7S003862","insp_date":"2024-10-26 00:00:00","insp_start_time":"1130","insp_end_time":"1150","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-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15573840","transaction_code":"A","transaction_date":"2024-10-26 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-10-28 21:40:00","snet_input_date":"2024-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-28 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:43:25.000000Z","updated_at":"2025-03-17T20:43:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11393814,"change_date":"2024-10-28 21:40:00","inspection_id":"83019349","insp_unit_id":"203623724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/2AX","insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"Y","insp_unit_decal_number":"34468049","created_at":"2025-03-17T23:40:57.000000Z","updated_at":"2025-03-17T23:40:57.000000Z"}]},{"id":6481355,"change_date":"2024-08-15 21:43:00","inspection_id":"82398732","dot_number":"2728459","report_state":"CA","report_number":"UD4G003128","insp_date":"2024-08-14 00:00:00","insp_start_time":"1530","insp_end_time":"1545","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":"BAY CITIES PAVING","shipping_paper_number":"N\/A","cargo_tank":"NON","hazmat_placard_req":"Y","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-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15484150","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-08-15 21:43:00","snet_input_date":"2024-08-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-15 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:31:32.000000Z","updated_at":"2025-03-17T20:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10447116,"change_date":"2024-08-15 21:43:00","inspection_id":"82398732","insp_unit_id":"202420660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:15.000000Z","updated_at":"2025-03-17T23:31:15.000000Z"}]},{"id":6460882,"change_date":"2024-08-13 21:43:00","inspection_id":"82376899","dot_number":"2728459","report_state":"CA","report_number":"UDM7003429","insp_date":"2024-08-12 00:00:00","insp_start_time":"1155","insp_end_time":"1213","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"106820","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":"15480551","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-08-13 21:43:00","snet_input_date":"2024-08-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:04.000000Z","updated_at":"2025-03-17T20:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10413793,"change_date":"2024-08-13 21:43:00","inspection_id":"82376899","insp_unit_id":"202378580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:54.000000Z","updated_at":"2025-03-17T23:30:54.000000Z"},{"id":10413794,"change_date":"2024-08-13 21:43:00","inspection_id":"82376899","insp_unit_id":"202378581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":null,"insp_unit_license":"4RW2344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5UCPR3724JA003590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:54.000000Z","updated_at":"2025-03-17T23:30:54.000000Z"}]},{"id":6469648,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","dot_number":"2728459","report_state":"CA","report_number":"NE1M005646","insp_date":"2024-08-09 00:00:00","insp_start_time":"0609","insp_end_time":"0641","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"106820","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15482634","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-08-14 21:39:00","snet_input_date":"2024-08-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-14 21:39:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:31:07.000000Z","updated_at":"2025-03-17T20:31:07.000000Z","inspection_violations":[{"id":10047946,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","insp_violation_id":"261196618","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202396055","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:38.000000Z","updated_at":"2025-03-17T21:54:38.000000Z","normalized_code":"3922"},{"id":10047947,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","insp_violation_id":"261196619","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202396056","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:38.000000Z","updated_at":"2025-03-17T21:54:38.000000Z","normalized_code":"39347E"},{"id":10047948,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","insp_violation_id":"261196620","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202396056","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:38.000000Z","updated_at":"2025-03-17T21:54:38.000000Z","normalized_code":"39353B"},{"id":10047949,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","insp_violation_id":"261196621","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202396056","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:38.000000Z","updated_at":"2025-03-17T21:54:38.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":10428141,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","insp_unit_id":"202396055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-024","insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:03.000000Z","updated_at":"2025-03-17T23:31:03.000000Z"},{"id":10428142,"change_date":"2024-08-14 21:39:00","inspection_id":"82386160","insp_unit_id":"202396056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"44018","insp_unit_license":"4RW2344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5UCPR3724JA003590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:03.000000Z","updated_at":"2025-03-17T23:31:03.000000Z"}]},{"id":6254927,"change_date":"2024-07-18 21:41:00","inspection_id":"82156600","dot_number":"2728459","report_state":"CA","report_number":"UEX8003930","insp_date":"2024-07-15 00:00:00","insp_start_time":"1557","insp_end_time":"1620","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"EB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15444074","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10078080,"change_date":"2024-07-18 21:41:00","inspection_id":"82156600","insp_unit_id":"201959280","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","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":5998491,"change_date":"2024-06-14 21:41:00","inspection_id":"81880763","dot_number":"2728459","report_state":"CA","report_number":"UEGX000483","insp_date":"2024-06-14 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CRK PLTFM SCALES","county_code_state":"CA","county_code":"013","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"1","snet_sequence_id":"15404595","transaction_code":"A","transaction_date":"2024-06-14 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[{"id":9306148,"change_date":"2024-06-14 21:41:00","inspection_id":"81880763","insp_violation_id":"260101145","seq_no":"1","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"201408474","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":9661426,"change_date":"2024-06-14 21:41:00","inspection_id":"81880763","insp_unit_id":"201408474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"}]},{"id":6012135,"change_date":"2024-06-17 21:46:00","inspection_id":"81895523","dot_number":"2728459","report_state":"CA","report_number":"UEGX000485","insp_date":"2024-06-14 00:00:00","insp_start_time":"1150","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CRK PLTFM SCALES","county_code_state":"CA","county_code":"013","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15405814","transaction_code":"A","transaction_date":"2024-06-14 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-06-17 21:46:00","snet_input_date":"2024-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-17 21:46:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:21:53.000000Z","updated_at":"2025-03-17T20:21:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9683402,"change_date":"2024-06-17 21:46:00","inspection_id":"81895523","insp_unit_id":"201455187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:21.000000Z","updated_at":"2025-03-17T23:23:21.000000Z"}]},{"id":5978044,"change_date":"2024-06-12 21:43:00","inspection_id":"81858625","dot_number":"2728459","report_state":"CA","report_number":"UDLV003345","insp_date":"2024-06-12 00:00:00","insp_start_time":"0754","insp_end_time":"0806","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15399792","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-06-12 21:43:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-12 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9628914,"change_date":"2024-06-12 21:43:00","inspection_id":"81858625","insp_unit_id":"201367547","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:48.000000Z","updated_at":"2025-03-17T23:22:48.000000Z"}]},{"id":5554151,"change_date":"2024-04-19 21:39:00","inspection_id":"81398071","dot_number":"2728459","report_state":"CA","report_number":"UDM7003087","insp_date":"2024-04-19 00:00:00","insp_start_time":"1100","insp_end_time":"1123","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15326522","transaction_code":"A","transaction_date":"2024-04-19 00:00:00","upload_date":"2024-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-04-19 21:39:00","snet_input_date":"2024-04-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-19 21:39:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:47.000000Z","updated_at":"2025-03-17T20:12:47.000000Z","inspection_violations":[{"id":8584097,"change_date":"2024-04-19 21:39:00","inspection_id":"81398071","insp_violation_id":"259035354","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200487110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:36.000000Z","updated_at":"2025-03-17T21:47:36.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8946389,"change_date":"2024-04-19 21:39:00","inspection_id":"81398071","insp_unit_id":"200487110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:15.000000Z","updated_at":"2025-03-17T23:16:15.000000Z"}]},{"id":5627163,"change_date":"2024-04-29 21:44:00","inspection_id":"81477696","dot_number":"2728459","report_state":"CA","report_number":"UE7F001555","insp_date":"2024-04-15 00:00:00","insp_start_time":"2134","insp_end_time":"2208","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:44: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":"15339638","transaction_code":"A","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-04-29 21:44:00","snet_input_date":"2024-04-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-29 21:44:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:14:17.000000Z","updated_at":"2025-03-17T20:14:17.000000Z","inspection_violations":[{"id":8700716,"change_date":"2024-04-29 21:44:00","inspection_id":"81477696","insp_violation_id":"259211577","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200638430","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9064236,"change_date":"2024-04-29 21:44:00","inspection_id":"81477696","insp_unit_id":"200638430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-016","insp_unit_license":"97086E2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMMAAL5CH624986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:19.000000Z","updated_at":"2025-03-17T23:17:19.000000Z"}]},{"id":5383959,"change_date":"2024-03-27 21:43:00","inspection_id":"81212004","dot_number":"2728459","report_state":"CA","report_number":"UDM7003046","insp_date":"2024-03-26 00:00:00","insp_start_time":"1405","insp_end_time":"1425","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"N","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-27 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":"1","hazmat_oos_total":"0","snet_sequence_id":"15296632","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-03-27 21:43:00","snet_input_date":"2024-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-27 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:25.000000Z","updated_at":"2025-03-17T20:09:25.000000Z","inspection_violations":[{"id":8310058,"change_date":"2024-03-27 21:43:00","inspection_id":"81212004","insp_violation_id":"258623811","seq_no":"1","part_no":"172","part_no_section":"406(f)","insp_viol_unit":"1","insp_unit_id":"200123693","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:13.000000Z","updated_at":"2025-03-17T21:46:13.000000Z","normalized_code":"172406F"}],"inspection_per_units":[{"id":8670941,"change_date":"2024-03-27 21:43:00","inspection_id":"81212004","insp_unit_id":"200123693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"56580P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK4NH772971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:39.000000Z","updated_at":"2025-03-17T23:13:39.000000Z"}]},{"id":5322524,"change_date":"2024-03-19 21:45:00","inspection_id":"81145294","dot_number":"2728459","report_state":"CA","report_number":"UD89002846","insp_date":"2024-03-15 00:00:00","insp_start_time":"0905","insp_end_time":"0940","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":"NON","hazmat_placard_req":"Y","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-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15285248","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T20:08:15.000000Z","updated_at":"2025-03-17T20:08:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8571832,"change_date":"2024-03-19 21:45:00","inspection_id":"81145294","insp_unit_id":"199990901","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"Y","insp_unit_decal_number":"33521120","created_at":"2025-03-17T23:12:42.000000Z","updated_at":"2025-03-17T23:12:42.000000Z"}]},{"id":4477948,"change_date":"2023-11-21 21:40:00","inspection_id":"80221625","dot_number":"2728459","report_state":"CA","report_number":"UEH7004864","insp_date":"2023-11-21 00:00:00","insp_start_time":"0801","insp_end_time":"0816","registration_date":null,"region":"PT","ci_status_code":"C","location":"285","location_desc":"RIEGO RD","county_code_state":"CA","county_code":"101","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":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15142579","transaction_code":"A","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:51:28.000000Z","updated_at":"2025-03-17T19:51:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7201592,"change_date":"2023-11-21 21:40:00","inspection_id":"80221625","insp_unit_id":"198175925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"07517V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X0LM427335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:30.000000Z","updated_at":"2025-03-17T23:00:30.000000Z"}]},{"id":4317254,"change_date":"2023-10-30 21:43:00","inspection_id":"80044331","dot_number":"2728459","report_state":"CA","report_number":"N839000653","insp_date":"2023-10-30 00:00:00","insp_start_time":"1152","insp_end_time":"1209","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK N\/B SCALES","county_code_state":"CA","county_code":"013","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 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":"15117273","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-10-30 21:43:00","snet_input_date":"2023-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-30 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:48:24.000000Z","updated_at":"2025-03-17T19:48:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6943875,"change_date":"2023-10-30 21:43:00","inspection_id":"80044331","insp_unit_id":"197823612","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"06-021","insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"Y","insp_unit_decal_number":"33214990","created_at":"2025-03-17T22:58:16.000000Z","updated_at":"2025-03-17T22:58:16.000000Z"}]},{"id":4318629,"change_date":"2023-10-30 21:43:00","inspection_id":"80045779","dot_number":"2728459","report_state":"CA","report_number":"UDM7002774","insp_date":"2023-10-30 00:00:00","insp_start_time":"1154","insp_end_time":"1213","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"2023-10-30 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":"15117248","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-10-30 21:43:00","snet_input_date":"2023-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-30 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:48:25.000000Z","updated_at":"2025-03-17T19:48:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6945804,"change_date":"2023-10-30 21:43:00","inspection_id":"80045779","insp_unit_id":"197825759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:19.000000Z","updated_at":"2025-03-17T22:58:19.000000Z"}]},{"id":3603299,"change_date":"2023-07-26 21:41:00","inspection_id":"79250018","dot_number":"2728459","report_state":"CA","report_number":"NCZ3005415","insp_date":"2023-07-25 00:00:00","insp_start_time":"0748","insp_end_time":"0804","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":"N","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-26 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":"14996635","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-26 21:41:00","snet_input_date":"2023-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-26 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:34:11.000000Z","updated_at":"2025-03-17T19:34:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5793873,"change_date":"2023-07-26 21:41:00","inspection_id":"79250018","insp_unit_id":"196214489","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"06-027","insp_unit_license":"56580P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK4NH772971","insp_unit_decal":"Y","insp_unit_decal_number":"32847952","created_at":"2025-03-17T22:48:44.000000Z","updated_at":"2025-03-17T22:48:44.000000Z"}]},{"id":3506411,"change_date":"2023-07-13 21:43:00","inspection_id":"79141307","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005472","insp_date":"2023-07-12 00:00:00","insp_start_time":"1005","insp_end_time":"1047","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":"N","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-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14980312","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-07-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638277,"change_date":"2023-07-13 21:43:00","inspection_id":"79141307","insp_unit_id":"195996181","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2X UTIL","insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3624804,"change_date":"2023-07-28 21:42:00","inspection_id":"79274157","dot_number":"2728459","report_state":"CA","report_number":"NBYR000933","insp_date":"2023-07-12 00:00:00","insp_start_time":"1005","insp_end_time":"1047","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":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-07-28 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":"15000374","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10571","created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5828010,"change_date":"2023-07-28 21:42:00","inspection_id":"79274157","insp_unit_id":"196262425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-020","insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:01.000000Z","updated_at":"2025-03-17T22:49:01.000000Z"}]},{"id":3424179,"change_date":"2023-07-03 21:38:00","inspection_id":"79048823","dot_number":"2728459","report_state":"CA","report_number":"N99W001903","insp_date":"2023-07-03 00:00:00","insp_start_time":"0900","insp_end_time":"0938","registration_date":null,"region":"PT","ci_status_code":"C","location":"370","location_desc":"WALNUT CREEK, CA","county_code_state":"CA","county_code":"013","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-07-03 21:38: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":"14968377","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-07-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:30:55.000000Z","updated_at":"2025-03-17T19:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5505336,"change_date":"2023-07-03 21:38:00","inspection_id":"79048823","insp_unit_id":"195806502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"06-021","insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"Y","insp_unit_decal_number":"32857797","created_at":"2025-03-17T22:46:28.000000Z","updated_at":"2025-03-17T22:46:28.000000Z"}]},{"id":3440005,"change_date":"2023-07-05 21:42:00","inspection_id":"79066467","dot_number":"2728459","report_state":"CA","report_number":"UDLV002604","insp_date":"2023-07-03 00:00:00","insp_start_time":"0910","insp_end_time":"0926","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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-07-05 21:42: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":"14969037","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-05 21:42:00","snet_input_date":"2023-07-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:31:16.000000Z","updated_at":"2025-03-17T19:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5531785,"change_date":"2023-07-05 21:42:00","inspection_id":"79066467","insp_unit_id":"195842626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:40.000000Z","updated_at":"2025-03-17T22:46:40.000000Z"}]},{"id":3391572,"change_date":"2023-06-28 21:43:00","inspection_id":"79012282","dot_number":"2728459","report_state":"CA","report_number":"NDUP004435","insp_date":"2023-06-27 00:00:00","insp_start_time":"1106","insp_end_time":"1134","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-06-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"98320","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":"14962591","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-28 21:43:00","snet_input_date":"2023-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-28 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"94520","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:30:11.000000Z","updated_at":"2025-03-17T19:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5452888,"change_date":"2023-06-28 21:43:00","inspection_id":"79012282","insp_unit_id":"195734448","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"#04-024 3X","insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"Y","insp_unit_decal_number":"32467264","created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"},{"id":5452889,"change_date":"2023-06-28 21:43:00","inspection_id":"79012282","insp_unit_id":"195734449","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL","insp_unit_company":"2X","insp_unit_license":"4RW2344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5UCPR3724JA003590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"}]},{"id":3506278,"change_date":"2023-07-13 21:43:00","inspection_id":"79141171","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005420","insp_date":"2023-06-15 00:00:00","insp_start_time":"0800","insp_end_time":"0854","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14979047","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638106,"change_date":"2023-07-13 21:43:00","inspection_id":"79141171","insp_unit_id":"195995996","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-020","insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506279,"change_date":"2023-07-13 21:43:00","inspection_id":"79141172","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005421","insp_date":"2023-06-15 00:00:00","insp_start_time":"0902","insp_end_time":"0947","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14979159","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638107,"change_date":"2023-07-13 21:43:00","inspection_id":"79141172","insp_unit_id":"195995997","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"03-038","insp_unit_license":"60867S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK5NH731992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506280,"change_date":"2023-07-13 21:43:00","inspection_id":"79141173","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005422","insp_date":"2023-06-15 00:00:00","insp_start_time":"0952","insp_end_time":"1032","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14979856","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638108,"change_date":"2023-07-13 21:43:00","inspection_id":"79141173","insp_unit_id":"195995998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-025","insp_unit_license":"89606J2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML6HL672432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506281,"change_date":"2023-07-13 21:43:00","inspection_id":"79141174","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005423","insp_date":"2023-06-15 00:00:00","insp_start_time":"1040","insp_end_time":"1150","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"14979837","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638109,"change_date":"2023-07-13 21:43:00","inspection_id":"79141174","insp_unit_id":"195995999","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"04-026","insp_unit_license":"CN88W01","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK0PH717453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"},{"id":5638110,"change_date":"2023-07-13 21:43:00","inspection_id":"79141174","insp_unit_id":"195996000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PACIF","insp_unit_company":"44-011","insp_unit_license":"4PW9222","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1P9UF1629CN144786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506249,"change_date":"2023-07-13 21:43:00","inspection_id":"79141141","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005413","insp_date":"2023-06-13 00:00:00","insp_start_time":"0815","insp_end_time":"0900","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":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14979961","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638066,"change_date":"2023-07-13 21:43:00","inspection_id":"79141141","insp_unit_id":"195995955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"03-039","insp_unit_license":"60875S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK0NH355413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506250,"change_date":"2023-07-13 21:43:00","inspection_id":"79141142","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005415","insp_date":"2023-06-13 00:00:00","insp_start_time":"0905","insp_end_time":"1012","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14979407","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638067,"change_date":"2023-07-13 21:43:00","inspection_id":"79141142","insp_unit_id":"195995956","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05-010","insp_unit_license":"9F01922","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ352747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"},{"id":5638068,"change_date":"2023-07-13 21:43:00","inspection_id":"79141142","insp_unit_id":"195995957","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EALO","insp_unit_company":"44-006","insp_unit_license":"4SH6653","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B472085A056415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506251,"change_date":"2023-07-13 21:43:00","inspection_id":"79141143","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005416","insp_date":"2023-06-13 00:00:00","insp_start_time":"1016","insp_end_time":"1121","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43: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":"14980175","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638069,"change_date":"2023-07-13 21:43:00","inspection_id":"79141143","insp_unit_id":"195995958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-024","insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"},{"id":5638070,"change_date":"2023-07-13 21:43:00","inspection_id":"79141143","insp_unit_id":"195995959","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL","insp_unit_company":"44-018","insp_unit_license":"4RW2344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5UCPR3724JA003590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506252,"change_date":"2023-07-13 21:43:00","inspection_id":"79141144","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005417","insp_date":"2023-06-13 00:00:00","insp_start_time":"1132","insp_end_time":"1216","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","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":"14979432","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638071,"change_date":"2023-07-13 21:43:00","inspection_id":"79141144","insp_unit_id":"195995960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-025","insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506276,"change_date":"2023-07-13 21:43:00","inspection_id":"79141169","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005418","insp_date":"2023-06-13 00:00:00","insp_start_time":"1258","insp_end_time":"1349","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14980042","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638104,"change_date":"2023-07-13 21:43:00","inspection_id":"79141169","insp_unit_id":"195995994","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-022","insp_unit_license":"95253M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7X3KM258974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3506277,"change_date":"2023-07-13 21:43:00","inspection_id":"79141170","dot_number":"2728459","report_state":"CA","report_number":"NDQ6005419","insp_date":"2023-06-13 00:00:00","insp_start_time":"1403","insp_end_time":"1506","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONCORD","county_code_state":"CA","county_code":"013","insp_level_id":"5","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-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14980095","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5638105,"change_date":"2023-07-13 21:43:00","inspection_id":"79141170","insp_unit_id":"195995995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-026","insp_unit_license":"07517V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X0LM427335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3267267,"change_date":"2023-06-12 21:41:00","inspection_id":"78872091","dot_number":"2728459","report_state":"CA","report_number":"UDM7002397","insp_date":"2023-06-12 00:00:00","insp_start_time":"1120","insp_end_time":"1150","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"N","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14939405","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-12 21:41:00","snet_input_date":"2023-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5254182,"change_date":"2023-06-12 21:41:00","inspection_id":"78872091","insp_unit_id":"195457736","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"}]},{"id":3267403,"change_date":"2023-06-12 21:41:00","inspection_id":"78872239","dot_number":"2728459","report_state":"CA","report_number":"UE99003593","insp_date":"2023-06-12 00:00:00","insp_start_time":"0830","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"285","location_desc":"RIEGO RD E\/OF SR-99","county_code_state":"CA","county_code":"101","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":"2023-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14939859","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-12 21:41:00","snet_input_date":"2023-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5254381,"change_date":"2023-06-12 21:41:00","inspection_id":"78872239","insp_unit_id":"195457967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"07517V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X0LM427335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"}]},{"id":3279591,"change_date":"2023-06-13 21:43:00","inspection_id":"78886168","dot_number":"2728459","report_state":"CA","report_number":"UDOD000447","insp_date":"2023-06-12 00:00:00","insp_start_time":"1218","insp_end_time":"1249","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I 680 N\/B, WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"EXE","hazmat_placard_req":"Y","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-06-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"14941535","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-13 21:43:00","snet_input_date":"2023-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-13 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:27:46.000000Z","updated_at":"2025-03-17T19:27:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5273306,"change_date":"2023-06-13 21:43:00","inspection_id":"78886168","insp_unit_id":"195485220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-025","insp_unit_license":"05141T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X0KJ367786","insp_unit_decal":"Y","insp_unit_decal_number":"32477500","created_at":"2025-03-17T22:44:34.000000Z","updated_at":"2025-03-17T22:44:34.000000Z"}]},{"id":3244813,"change_date":"2023-06-08 21:42:00","inspection_id":"78846796","dot_number":"2728459","report_state":"CA","report_number":"UE7D001209","insp_date":"2023-06-08 00:00:00","insp_start_time":"0936","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"CAMINO SCALE","county_code_state":"CA","county_code":"017","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-06-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"158000","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":"14934847","transaction_code":"A","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-08 21:42:00","snet_input_date":"2023-06-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-08 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5218871,"change_date":"2023-06-08 21:42:00","inspection_id":"78846796","insp_unit_id":"195408383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":null,"insp_unit_license":"9F39209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ245147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:07.000000Z","updated_at":"2025-03-17T22:44:07.000000Z"},{"id":5218872,"change_date":"2023-06-08 21:42:00","inspection_id":"78846796","insp_unit_id":"195408384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MRRA","insp_unit_company":null,"insp_unit_license":"4FU5875","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B4920X3A056263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:07.000000Z","updated_at":"2025-03-17T22:44:07.000000Z"}]},{"id":3235153,"change_date":"2023-06-07 21:43:00","inspection_id":"78835963","dot_number":"2728459","report_state":"CA","report_number":"NE28003431","insp_date":"2023-06-01 00:00:00","insp_start_time":"1445","insp_end_time":"1523","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-06-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"158000","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":"14932671","transaction_code":"A","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-07 21:43:00","snet_input_date":"2023-06-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-07 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:26:56.000000Z","updated_at":"2025-03-17T19:26:56.000000Z","inspection_violations":[{"id":4988517,"change_date":"2023-06-07 21:43:00","inspection_id":"78835963","insp_violation_id":"253375225","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195386413","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5203311,"change_date":"2023-06-07 21:43:00","inspection_id":"78835963","insp_unit_id":"195386412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":"05-009","insp_unit_license":"9F39209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X1KJ245147","insp_unit_decal":"Y","insp_unit_decal_number":"32464563","created_at":"2025-03-17T22:44:00.000000Z","updated_at":"2025-03-17T22:44:00.000000Z"},{"id":5203312,"change_date":"2023-06-07 21:43:00","inspection_id":"78835963","insp_unit_id":"195386413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MRRA","insp_unit_company":"44-010","insp_unit_license":"4FU5875","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B4920X3A056263","insp_unit_decal":"Y","insp_unit_decal_number":"32464564","created_at":"2025-03-17T22:44:00.000000Z","updated_at":"2025-03-17T22:44:00.000000Z"}]},{"id":3224543,"change_date":"2023-06-06 21:45:00","inspection_id":"78824081","dot_number":"2728459","report_state":"CA","report_number":"NBIJ004083","insp_date":"2023-05-30 00:00:00","insp_start_time":"0518","insp_end_time":"0544","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-06-06 21:45: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":"14931494","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-06-06 21:45:00","snet_input_date":"2023-05-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-06 21:45:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:26:52.000000Z","updated_at":"2025-03-17T19:26:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5186176,"change_date":"2023-06-06 21:45:00","inspection_id":"78824081","insp_unit_id":"195359305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03-019","insp_unit_license":"69233X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY2BEB91943","insp_unit_decal":"Y","insp_unit_decal_number":"32463777","created_at":"2025-03-17T22:43:52.000000Z","updated_at":"2025-03-17T22:43:52.000000Z"}]},{"id":3135662,"change_date":"2023-05-24 21:41:00","inspection_id":"78723551","dot_number":"2728459","report_state":"CA","report_number":"ND6S005730","insp_date":"2023-05-22 00:00:00","insp_start_time":"1146","insp_end_time":"1210","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":"N","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14915925","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:25:00.000000Z","updated_at":"2025-03-17T19:25:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5043411,"change_date":"2023-05-24 21:41:00","inspection_id":"78723551","insp_unit_id":"195130396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96210A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X4HM155041","insp_unit_decal":"Y","insp_unit_decal_number":"32465228","created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":3075142,"change_date":"2023-05-17 21:44:00","inspection_id":"78655376","dot_number":"2728459","report_state":"CA","report_number":"UDM7002301","insp_date":"2023-05-16 00:00:00","insp_start_time":"1305","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"166000","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":"14905504","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-05-17 21:44:00","snet_input_date":"2023-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-17 21:44:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:23:48.000000Z","updated_at":"2025-03-17T19:23:48.000000Z","inspection_violations":[{"id":4726221,"change_date":"2023-05-17 21:44:00","inspection_id":"78655376","insp_violation_id":"252907269","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4946844,"change_date":"2023-05-17 21:44:00","inspection_id":"78655376","insp_unit_id":"194997260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9F65506","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X4JJ194337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:01.000000Z","updated_at":"2025-03-17T22:42:01.000000Z"},{"id":4946845,"change_date":"2023-05-17 21:44:00","inspection_id":"78655376","insp_unit_id":"194997261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MRRA","insp_unit_company":null,"insp_unit_license":"4FU5875","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9B4920X3A056263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:01.000000Z","updated_at":"2025-03-17T22:42:01.000000Z"}]},{"id":3038773,"change_date":"2023-05-12 21:43:00","inspection_id":"78614569","dot_number":"2728459","report_state":"CA","report_number":"UEED001871","insp_date":"2023-05-12 00:00:00","insp_start_time":"0930","insp_end_time":"0958","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"SB JSO N. FRONT","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":"OTH","hazmat_placard_req":"Y","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-05-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"14898595","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-05-12 21:43:00","snet_input_date":"2023-05-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-12 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:23:03.000000Z","updated_at":"2025-03-17T19:23:03.000000Z","inspection_violations":[{"id":4667709,"change_date":"2023-05-12 21:43:00","inspection_id":"78614569","insp_violation_id":"252814939","seq_no":"1","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"194916325","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA443695","created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"172602C1"},{"id":4667710,"change_date":"2023-05-12 21:43:00","inspection_id":"78614569","insp_violation_id":"252814940","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194916325","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA443695","created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4888680,"change_date":"2023-05-12 21:43:00","inspection_id":"78614569","insp_unit_id":"194916325","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"95253M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7X3KM258974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:31.000000Z","updated_at":"2025-03-17T22:41:31.000000Z"}]},{"id":3057251,"change_date":"2023-05-16 21:43:00","inspection_id":"78635375","dot_number":"2728459","report_state":"CA","report_number":"NC7K007275","insp_date":"2023-05-10 00:00:00","insp_start_time":"0758","insp_end_time":"0823","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":"N","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-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14900928","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-05-16 21:43:00","snet_input_date":"2023-05-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-16 21:43:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:26.000000Z","updated_at":"2025-03-17T19:23:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4918614,"change_date":"2023-05-16 21:43:00","inspection_id":"78635375","insp_unit_id":"194961259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-023\/WHT2","insp_unit_license":"73352G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7X0JM201775","insp_unit_decal":"Y","insp_unit_decal_number":"32467995","created_at":"2025-03-17T22:41:46.000000Z","updated_at":"2025-03-17T22:41:46.000000Z"}]},{"id":2519829,"change_date":"2023-03-06 21:41:00","inspection_id":"78025283","dot_number":"2728459","report_state":"CA","report_number":"UDLV002376","insp_date":"2023-03-03 00:00:00","insp_start_time":"1310","insp_end_time":"1326","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","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-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14806924","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-03-06 21:41:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:12:59.000000Z","updated_at":"2025-03-17T19:12:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4055860,"change_date":"2023-03-06 21:41:00","inspection_id":"78025283","insp_unit_id":"193738008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:04.000000Z","updated_at":"2025-03-17T22:35:04.000000Z"}]},{"id":2427803,"change_date":"2023-02-22 21:41:00","inspection_id":"77920859","dot_number":"2728459","report_state":"CA","report_number":"NBH6004132","insp_date":"2023-02-14 00:00:00","insp_start_time":"0830","insp_end_time":"0845","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14790275","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-02-22 21:41:00","snet_input_date":"2023-02-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-22 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:11:25.000000Z","updated_at":"2025-03-17T19:11:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3907566,"change_date":"2023-02-22 21:41:00","inspection_id":"77920859","insp_unit_id":"193530312","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"06-021","insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"Y","insp_unit_decal_number":"32135884","created_at":"2025-03-17T22:33:59.000000Z","updated_at":"2025-03-17T22:33:59.000000Z"}]},{"id":2341019,"change_date":"2023-02-09 21:40:00","inspection_id":"77821482","dot_number":"2728459","report_state":"CA","report_number":"UCZP000387","insp_date":"2023-02-02 00:00:00","insp_start_time":"1100","insp_end_time":"1141","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA EB CVEF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BAY CITIES","shipping_paper_number":"GENERIC","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"14777055","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-02-09 21:40:00","snet_input_date":"2023-02-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:09:55.000000Z","updated_at":"2025-03-17T19:09:55.000000Z","inspection_violations":[{"id":3606024,"change_date":"2023-02-09 21:40:00","inspection_id":"77821482","insp_violation_id":"251057793","seq_no":"1","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"193328645","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW890684","created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":3767126,"change_date":"2023-02-09 21:40:00","inspection_id":"77821482","insp_unit_id":"193328645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"Y","insp_unit_decal_number":"32133357","created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"}]},{"id":2279509,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","dot_number":"2728459","report_state":"CA","report_number":"UD1W001259","insp_date":"2023-02-01 00:00:00","insp_start_time":"0815","insp_end_time":"0842","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","location_desc":"COMMERCE AVE.","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14766023","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[{"id":3515976,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_violation_id":"250902663","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193185190","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KM94482","created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"3922"},{"id":3515977,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_violation_id":"250902664","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193185190","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"3922"},{"id":3515978,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_violation_id":"250902665","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193185190","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"3922"},{"id":3515979,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_violation_id":"250902666","seq_no":"4","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":"215","created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"38323A2"},{"id":3515980,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_violation_id":"250902667","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193185190","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"3922"},{"id":3515981,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_violation_id":"250902668","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193185190","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3669475,"change_date":"2023-02-01 21:42:00","inspection_id":"77751411","insp_unit_id":"193185190","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"02250H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMAALXEL780213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":1651576,"change_date":"2022-11-01 21:41:00","inspection_id":"77032943","dot_number":"2728459","report_state":"CA","report_number":"NCNG005648","insp_date":"2022-10-28 00:00:00","insp_start_time":"1230","insp_end_time":"1249","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"Y","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-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14658194","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-11-01 21:41:00","snet_input_date":"2022-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-01 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:57:04.000000Z","updated_at":"2025-03-17T18:57:04.000000Z","inspection_violations":[{"id":2592031,"change_date":"2022-11-01 21:41:00","inspection_id":"77032943","insp_violation_id":"249380697","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191758377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"3939A"},{"id":2592032,"change_date":"2022-11-01 21:41:00","inspection_id":"77032943","insp_violation_id":"249380698","seq_no":"2","part_no":"385","part_no_section":"415(a)(1)","insp_viol_unit":"1","insp_unit_id":"191758377","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"385415A1"}],"inspection_per_units":[{"id":2657460,"change_date":"2022-11-01 21:41:00","inspection_id":"77032943","insp_unit_id":"191758377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:13.000000Z","updated_at":"2025-03-17T22:25:13.000000Z"}]},{"id":1555391,"change_date":"2022-10-19 21:42:00","inspection_id":"76922531","dot_number":"2728459","report_state":"CA","report_number":"NBH6003743","insp_date":"2022-10-18 00:00:00","insp_start_time":"0548","insp_end_time":"0605","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":"N","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-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14640447","transaction_code":"A","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-10-19 21:42:00","snet_input_date":"2022-10-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-19 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:55:14.000000Z","updated_at":"2025-03-17T18:55:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2502908,"change_date":"2022-10-19 21:42:00","inspection_id":"76922531","insp_unit_id":"191536101","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"06-021","insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"Y","insp_unit_decal_number":"31817340","created_at":"2025-03-17T22:24:09.000000Z","updated_at":"2025-03-17T22:24:09.000000Z"}]},{"id":1522892,"change_date":"2022-10-14 21:40:00","inspection_id":"76884986","dot_number":"2728459","report_state":"CA","report_number":"ND6S004619","insp_date":"2022-10-12 00:00:00","insp_start_time":"1154","insp_end_time":"1220","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14632636","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-10-14 21:40:00","snet_input_date":"2022-10-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-14 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:54:48.000000Z","updated_at":"2025-03-17T18:54:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2450788,"change_date":"2022-10-14 21:40:00","inspection_id":"76884986","insp_unit_id":"191458571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"07517V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X0LM427335","insp_unit_decal":"Y","insp_unit_decal_number":"31817925","created_at":"2025-03-17T22:23:48.000000Z","updated_at":"2025-03-17T22:23:48.000000Z"}]},{"id":1492142,"change_date":"2022-10-11 21:42:00","inspection_id":"76849659","dot_number":"2728459","report_state":"CA","report_number":"UDM7001915","insp_date":"2022-10-10 00:00:00","insp_start_time":"1250","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM SCALES","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14629194","transaction_code":"A","transaction_date":"2022-10-10 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-10-11 21:42:00","snet_input_date":"2022-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-11 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:54:09.000000Z","updated_at":"2025-03-17T18:54:09.000000Z","inspection_violations":[{"id":2348959,"change_date":"2022-10-11 21:42:00","inspection_id":"76849659","insp_violation_id":"248967143","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":"CW890838","created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3922"},{"id":2348960,"change_date":"2022-10-11 21:42:00","inspection_id":"76849659","insp_violation_id":"248967144","seq_no":"2","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:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2401531,"change_date":"2022-10-11 21:42:00","inspection_id":"76849659","insp_unit_id":"191387538","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9F65506","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X4JJ194336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"},{"id":2401532,"change_date":"2022-10-11 21:42:00","inspection_id":"76849659","insp_unit_id":"191387539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MURT","insp_unit_company":null,"insp_unit_license":"4PV1129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M9G44202GA056904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"}]},{"id":1469428,"change_date":"2022-10-07 21:39:00","inspection_id":"76823286","dot_number":"2728459","report_state":"CA","report_number":"NC7K006449","insp_date":"2022-10-05 00:00:00","insp_start_time":"0818","insp_end_time":"0847","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":"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":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"14626111","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:47.000000Z","updated_at":"2025-03-17T18:53:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2365956,"change_date":"2022-10-07 21:39:00","inspection_id":"76823286","insp_unit_id":"191335996","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"04-024\/WHT3","insp_unit_license":"06870J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTPCAPT0NN155712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:13.000000Z","updated_at":"2025-03-17T22:23:13.000000Z"}]},{"id":1020846,"change_date":"2022-08-11 21:38:00","inspection_id":"76301837","dot_number":"2728459","report_state":"CA","report_number":"NA5N004953","insp_date":"2022-08-08 00:00:00","insp_start_time":"1320","insp_end_time":"1347","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-11 21:38: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":"14544974","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-08-11 21:38:00","snet_input_date":"2022-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:46.000000Z","updated_at":"2025-03-17T18:45:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1642834,"change_date":"2022-08-11 21:38:00","inspection_id":"76301837","insp_unit_id":"190270602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"8N47996","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDAF57R78EA35178","insp_unit_decal":"Y","insp_unit_decal_number":"31475795","created_at":"2025-03-17T22:18:21.000000Z","updated_at":"2025-03-17T22:18:21.000000Z"}]},{"id":948686,"change_date":"2022-08-02 21:40:00","inspection_id":"76217631","dot_number":"2728459","report_state":"CA","report_number":"UCSZ000934","insp_date":"2022-08-02 00:00:00","insp_start_time":"0958","insp_end_time":"1022","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":"BAY CITIES","shipping_paper_number":"PAPER B.O.L","cargo_tank":"NON","hazmat_placard_req":"Y","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-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14531036","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-08-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:44:24.000000Z","updated_at":"2025-03-17T18:44:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1527843,"change_date":"2022-08-02 21:40:00","inspection_id":"76217631","insp_unit_id":"190099749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"}]},{"id":824418,"change_date":"2022-07-14 21:42:00","inspection_id":"76072138","dot_number":"2728459","report_state":"CA","report_number":"UCZC001357","insp_date":"2022-07-14 00:00:00","insp_start_time":"1003","insp_end_time":"1014","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK PS","county_code_state":"CA","county_code":"013","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-07-14 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":"14507301","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-07-14 21:42:00","snet_input_date":"2022-07-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1326500,"change_date":"2022-07-14 21:42:00","inspection_id":"76072138","insp_unit_id":"189793124","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2X WHT","insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","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":621742,"change_date":"2022-06-15 21:41:00","inspection_id":"75834010","dot_number":"2728459","report_state":"CA","report_number":"UD4G001648","insp_date":"2022-06-14 00:00:00","insp_start_time":"1130","insp_end_time":"1200","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":"BAY CITIES PAVING","shipping_paper_number":"N\/A","cargo_tank":"EXE","hazmat_placard_req":"Y","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-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14469811","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:38:46.000000Z","updated_at":"2025-03-17T18:38:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":999926,"change_date":"2022-06-15 21:41:00","inspection_id":"75834010","insp_unit_id":"189280660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"06-016","insp_unit_license":"27762G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HN7X6DM188963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]},{"id":599755,"change_date":"2022-06-13 21:42:00","inspection_id":"75808090","dot_number":"2728459","report_state":"CA","report_number":"NCZ3003620","insp_date":"2022-06-09 00:00:00","insp_start_time":"1221","insp_end_time":"1241","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":"2022-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14466273","transaction_code":"A","transaction_date":"2022-06-09 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-06-13 21:42:00","snet_input_date":"2022-06-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-13 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:38:08.000000Z","updated_at":"2025-03-17T18:38:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":964283,"change_date":"2022-06-13 21:42:00","inspection_id":"75808090","insp_unit_id":"189223141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"06-023","insp_unit_license":"73352G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7X0JM201775","insp_unit_decal":"Y","insp_unit_decal_number":"31098626","created_at":"2025-03-17T22:14:07.000000Z","updated_at":"2025-03-17T22:14:07.000000Z"}]},{"id":412740,"change_date":"2022-05-17 21:44:00","inspection_id":"75585271","dot_number":"2728459","report_state":"CA","report_number":"UDOD000278","insp_date":"2022-05-17 00:00:00","insp_start_time":"1044","insp_end_time":"1057","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I 680 N\/B, WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"2022-05-17 21:44: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":"14431995","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-05-17 21:44:00","snet_input_date":"2022-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-17 21:44:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[{"id":645884,"change_date":"2022-05-17 21:44:00","inspection_id":"75585271","insp_violation_id":"245861111","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188743288","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"},{"id":645885,"change_date":"2022-05-17 21:44:00","inspection_id":"75585271","insp_violation_id":"245861112","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188743288","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":666464,"change_date":"2022-05-17 21:44:00","inspection_id":"75585271","insp_unit_id":"188743288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"80456S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM6X9KM303614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":324132,"change_date":"2022-05-04 21:42:00","inspection_id":"75479624","dot_number":"2728459","report_state":"CA","report_number":"ND6S003901","insp_date":"2022-05-03 00:00:00","insp_start_time":"0920","insp_end_time":"0944","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":"N","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-04 21:42: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":"14413114","transaction_code":"A","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02728459","upload_search_indicator":null,"census_search_date":"2022-05-04 21:42:00","snet_input_date":"2022-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-04 21:42:00","insp_carrier_name":"BAY CITIES PAVING & GRADING INC","insp_carrier_street":"1450 CIVIC CT BLDG B 400","insp_carrier_city":"CONCORD","insp_carrier_state":"CA","insp_carrier_zip_code":"945201224","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"10751","created_at":"2025-03-17T18:33:18.000000Z","updated_at":"2025-03-17T18:33:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":524405,"change_date":"2022-05-04 21:42:00","inspection_id":"75479624","insp_unit_id":"188514827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"50290K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GTXDEB24712","insp_unit_decal":"Y","insp_unit_decal_number":"31096640","created_at":"2025-03-17T22:11:25.000000Z","updated_at":"2025-03-17T22:11:25.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2728459\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2728459\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2728459\/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\/2728459\/inspections","per_page":100,"prev_page_url":null,"to":88,"total":88}