{"current_page":1,"data":[{"id":12009877,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","dot_number":"1800538","report_state":"CA","report_number":"UED8002225","insp_date":"2026-05-25 00:00:00","insp_start_time":"0921","insp_end_time":"1010","registration_date":null,"region":"PS","ci_status_code":"C","location":"9320","location_desc":"CA","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3397574","transaction_code":"A","transaction_date":"2026-05-25 00:00:00","upload_date":"2026-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2026-05-25 21:34:00","snet_input_date":"2026-05-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-25 21:34:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2026-05-28T09:39:22.000000Z","updated_at":"2026-06-06T09:30:24.000000Z","inspection_violations":[{"id":20895999,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481474","seq_no":"8","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"213736457","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"3922SLLEQP"},{"id":20895992,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481467","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213736456","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"3939ALFTSI"},{"id":20895993,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481468","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213736456","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"3939ALHLI"},{"id":20895994,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481469","seq_no":"3","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"213736457","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"39323LEU"},{"id":20895995,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481470","seq_no":"4","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"213736456","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"39311A1LLPL"},{"id":20895996,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481471","seq_no":"5","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"213736456","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"39311A1LIL"},{"id":20895997,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481472","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"213736457","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"3922SLLSR"},{"id":20895998,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_violation_id":"274481473","seq_no":"7","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"213736457","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:33.000000Z","updated_at":"2026-06-06T09:41:31.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":20876878,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_unit_id":"213736456","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BC07","insp_unit_license":"16014N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBCYBS3BDAZ4878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:47.000000Z","updated_at":"2026-06-06T09:01:33.000000Z"},{"id":20876879,"change_date":"2026-05-25 21:34:00","inspection_id":"87948877","insp_unit_id":"213736457","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"2X BLE","insp_unit_license":"4BM9929","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KNFT19272L160381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:47.000000Z","updated_at":"2026-06-06T09:01:33.000000Z"}]},{"id":9671562,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","dot_number":"1800538","report_state":"CA","report_number":"UEGX002066","insp_date":"2025-09-12 00:00:00","insp_start_time":"1140","insp_end_time":"1210","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-09-12 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15979484","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2025-09-12 21:50:00","snet_input_date":"2025-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-12 21:50:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-09-16T10:48:43.000000Z","updated_at":"2025-09-16T10:48:43.000000Z","inspection_violations":[{"id":15855902,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_violation_id":"268671405","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208932288","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RH09735","created_at":"2025-09-14T11:58:22.000000Z","updated_at":"2025-09-16T10:52:01.000000Z","normalized_code":"3922SLLSR"},{"id":15855903,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_violation_id":"268671406","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"208932288","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-09-14T11:58:22.000000Z","updated_at":"2025-09-16T10:52:01.000000Z","normalized_code":"3922SLL"},{"id":15855904,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_violation_id":"268671407","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208932288","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RH09735","created_at":"2025-09-14T11:58:22.000000Z","updated_at":"2025-09-16T10:52:01.000000Z","normalized_code":"3922SLLSR"},{"id":15855905,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_violation_id":"268671408","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"208932288","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:22.000000Z","updated_at":"2025-09-16T10:52:01.000000Z","normalized_code":"3939ALSML"},{"id":15855906,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_violation_id":"268671409","seq_no":"5","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"208932288","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:22.000000Z","updated_at":"2025-09-16T10:52:01.000000Z","normalized_code":"39311A1LLPL"},{"id":15855907,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_violation_id":"268671410","seq_no":"6","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"208932288","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:22.000000Z","updated_at":"2025-09-16T10:52:01.000000Z","normalized_code":"39311A1LRR"}],"inspection_per_units":[{"id":16004964,"change_date":"2025-09-12 21:50:00","inspection_id":"85764630","insp_unit_id":"208932288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"16014N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBCYBS3BDAZ4878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:05.000000Z","updated_at":"2025-09-16T09:56:47.000000Z"}]},{"id":9003765,"change_date":"2025-06-26 21:42:00","inspection_id":"85062639","dot_number":"1800538","report_state":"CA","report_number":"UDXH001127","insp_date":"2025-06-25 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"US-101 S\/B CANDLESTICK ON","county_code_state":"CA","county_code":"081","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"15876367","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-06-30T10:01:11.000000Z","updated_at":"2025-06-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14766006,"change_date":"2025-06-26 21:42:00","inspection_id":"85062639","insp_unit_id":"207589487","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"40071T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHCYFE1LHLJ1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:27.000000Z","updated_at":"2025-07-01T09:48:41.000000Z"}]},{"id":8571905,"change_date":"2025-05-07 21:47:00","inspection_id":"84606000","dot_number":"1800538","report_state":"CA","report_number":"UBZ9001436","insp_date":"2025-05-07 00:00:00","insp_start_time":"0715","insp_end_time":"0755","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"ST VINCENT SCALE","county_code_state":"CA","county_code":"041","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":"2025-05-07 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"15811254","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2025-05-07 21:47:00","snet_input_date":"2025-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-07 21:47:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-05-10T11:03:26.000000Z","updated_at":"2025-05-11T10:21:45.000000Z","inspection_violations":[{"id":13613223,"change_date":"2025-05-07 21:47:00","inspection_id":"84606000","insp_violation_id":"266093848","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206744024","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV10941","created_at":"2025-05-09T11:42:41.000000Z","updated_at":"2025-05-10T11:51:54.000000Z","normalized_code":"3922SLLSR"},{"id":13613224,"change_date":"2025-05-07 21:47:00","inspection_id":"84606000","insp_violation_id":"266093849","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206744024","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV10941","created_at":"2025-05-09T11:42:41.000000Z","updated_at":"2025-05-10T11:51:54.000000Z","normalized_code":"3922SLLSR"},{"id":13613225,"change_date":"2025-05-07 21:47:00","inspection_id":"84606000","insp_violation_id":"266093850","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206744024","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV10941","created_at":"2025-05-09T11:42:41.000000Z","updated_at":"2025-05-10T11:51:54.000000Z","normalized_code":"3922SLLSR"},{"id":13613226,"change_date":"2025-05-07 21:47:00","inspection_id":"84606000","insp_violation_id":"266093851","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206744024","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV10941","created_at":"2025-05-09T11:42:41.000000Z","updated_at":"2025-05-10T11:51:54.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13989708,"change_date":"2025-05-07 21:47:00","inspection_id":"84606000","insp_unit_id":"206744024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"60186A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:47:43.000000Z","updated_at":"2025-05-11T04:00:28.000000Z"}]},{"id":7777088,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","dot_number":"1800538","report_state":"CA","report_number":"UBZ9001348","insp_date":"2025-01-31 00:00:00","insp_start_time":"1145","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"TERRA LINDA SCALE","county_code_state":"CA","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139540","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15689251","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2025-02-03 21:40:00","snet_input_date":"2025-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-03 21:40:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[{"id":12152673,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","insp_violation_id":"264317812","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"205139279","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLEWA3"},{"id":12152674,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","insp_violation_id":"264317813","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"2","insp_unit_id":"205139280","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU66360","created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLEWA3"},{"id":12152675,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","insp_violation_id":"264317814","seq_no":"3","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"2","insp_unit_id":"205139280","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39311A1LRR"},{"id":12152676,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","insp_violation_id":"264317815","seq_no":"4","part_no":"393","part_no_section":"106D-C","insp_viol_unit":"2","insp_unit_id":"205139280","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RU66360","created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"393106DC"}],"inspection_per_units":[{"id":12551294,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","insp_unit_id":"205139279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BC12","insp_unit_license":"9E25302","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXD49X5JD468907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"},{"id":12551295,"change_date":"2025-02-03 21:40:00","inspection_id":"83769831","insp_unit_id":"205139280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"4WH6807","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TKA048275M041588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"}]},{"id":7741317,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","dot_number":"1800538","report_state":"CA","report_number":"UBZ9001342","insp_date":"2025-01-29 00:00:00","insp_start_time":"0620","insp_end_time":"0735","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"LUCAS VLY RD W\/O LAS GALINAS","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-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"79000","viol_total":"7","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15683854","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":12095936,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243200","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-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLTCD"},{"id":12095937,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243201","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW753719","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLDL"},{"id":12095938,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243202","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"205069626","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU66358","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3922SLLSR"},{"id":12095939,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243203","seq_no":"4","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"205069626","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU66358","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"3939ALSLI"},{"id":12095940,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243204","seq_no":"5","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"205069626","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RU66358","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"39343DB"},{"id":12095941,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243205","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"205069625","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU66358","created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":12095942,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_violation_id":"264243206","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"1","insp_unit_id":"205069625","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:59.000000Z","updated_at":"2025-03-17T22:04:59.000000Z","normalized_code":"39348ABIHE"}],"inspection_per_units":[{"id":12492608,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_unit_id":"205069625","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"4007173","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHCYFE1LHLJ1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"},{"id":12492609,"change_date":"2025-01-29 21:41:00","inspection_id":"83731988","insp_unit_id":"205069626","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"LAMA","insp_unit_company":null,"insp_unit_license":"4WM6658","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5RVH82839RP122274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7358039,"change_date":"2024-12-06 21:44:00","inspection_id":"83329664","dot_number":"1800538","report_state":"CA","report_number":"UBZ9001294","insp_date":"2024-12-06 00:00:00","insp_start_time":"0900","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"TERRA LINDA SCALE","county_code_state":"CA","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15620069","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2024-12-06 21:44:00","snet_input_date":"2024-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-06 21:44:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:49:26.000000Z","updated_at":"2025-03-17T20:49:26.000000Z","inspection_violations":[{"id":11498740,"change_date":"2024-12-06 21:44:00","inspection_id":"83329664","insp_violation_id":"263305034","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"204243391","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ09941","created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLEWA3"},{"id":11498741,"change_date":"2024-12-06 21:44:00","inspection_id":"83329664","insp_violation_id":"263305035","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204243391","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ09941","created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLSR"},{"id":11498742,"change_date":"2024-12-06 21:44:00","inspection_id":"83329664","insp_violation_id":"263305036","seq_no":"3","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"204243391","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW079320","created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"39311A1LRR"},{"id":11498743,"change_date":"2024-12-06 21:44:00","inspection_id":"83329664","insp_violation_id":"263305037","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204243391","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":11869308,"change_date":"2024-12-06 21:44:00","inspection_id":"83329664","insp_unit_id":"204243391","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BC08","insp_unit_license":"64882X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXCY0FDGP4260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:01.000000Z","updated_at":"2025-03-17T23:46:01.000000Z"}]},{"id":7358040,"change_date":"2024-12-06 21:44:00","inspection_id":"83329665","dot_number":"1800538","report_state":"CA","report_number":"UBZ9001295","insp_date":"2024-12-06 00:00:00","insp_start_time":"1045","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"TERRA LINDA SCALE","county_code_state":"CA","county_code":"041","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"18900","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":"15619932","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2024-12-06 21:44:00","snet_input_date":"2024-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-06 21:44:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:49:26.000000Z","updated_at":"2025-03-17T20:49:26.000000Z","inspection_violations":[{"id":11498744,"change_date":"2024-12-06 21:44:00","inspection_id":"83329665","insp_violation_id":"263305038","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204243392","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ09942","created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLSR"},{"id":11498745,"change_date":"2024-12-06 21:44:00","inspection_id":"83329665","insp_violation_id":"263305039","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204243392","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11869309,"change_date":"2024-12-06 21:44:00","inspection_id":"83329665","insp_unit_id":"204243392","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"BC05","insp_unit_license":"08180A1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBJC34U45E324917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:01.000000Z","updated_at":"2025-03-17T23:46:01.000000Z"},{"id":11869310,"change_date":"2024-12-06 21:44:00","inspection_id":"83329665","insp_unit_id":"204243393","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"LAKE","insp_unit_company":null,"insp_unit_license":"4RF3216","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B9TB2129H1245797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:01.000000Z","updated_at":"2025-03-17T23:46:01.000000Z"}]},{"id":7312291,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","dot_number":"1800538","report_state":"CA","report_number":"UE9B002720","insp_date":"2024-11-23 00:00:00","insp_start_time":"1553","insp_end_time":"1636","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":"2024-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15611976","transaction_code":"A","transaction_date":"2024-11-23 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[{"id":11430868,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_violation_id":"263158816","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204120536","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ33241","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLSR"},{"id":11430869,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_violation_id":"263158817","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"204120536","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39395A1"},{"id":11430870,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_violation_id":"263158818","seq_no":"3","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"204120536","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39311A1LFTSM"},{"id":11430871,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_violation_id":"263158819","seq_no":"4","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"1","insp_unit_id":"204120536","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39311A1LTSM"},{"id":11430872,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_violation_id":"263158820","seq_no":"5","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"204120536","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ33241","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39348ABIBD"},{"id":11430873,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_violation_id":"263158821","seq_no":"6","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"204120536","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":11795663,"change_date":"2024-11-30 21:33:00","inspection_id":"83281389","insp_unit_id":"204120536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X BLU","insp_unit_license":"9E25302","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXD49X5JD468907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:16.000000Z","updated_at":"2025-03-17T23:45:16.000000Z"}]},{"id":7232904,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","dot_number":"1800538","report_state":"CA","report_number":"UBZ9001282","insp_date":"2024-11-18 00:00:00","insp_start_time":"0620","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"ST VINCENT SCALE","county_code_state":"CA","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15598278","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2024-11-19 21:41:00","snet_input_date":"2024-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-19 21:41:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:46:51.000000Z","updated_at":"2025-03-17T20:46:51.000000Z","inspection_violations":[{"id":11306727,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_violation_id":"262985143","seq_no":"1","part_no":"393","part_no_section":"128B-CLWV","insp_viol_unit":"2","insp_unit_id":"203959495","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"393128BCLWV"},{"id":11306728,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_violation_id":"262985144","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"203959495","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ09940","created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLSR"},{"id":11306729,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_violation_id":"262985145","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"203959495","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLEQP"},{"id":11306730,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_violation_id":"262985146","seq_no":"4","part_no":"392","part_no_section":"2SLSCR","insp_viol_unit":"2","insp_unit_id":"203959495","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLSCR"},{"id":11306731,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_violation_id":"262985147","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203959494","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11666538,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_unit_id":"203959494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"16014N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBCYBS3BDAZ4878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:55.000000Z","updated_at":"2025-03-17T23:43:55.000000Z"},{"id":11666539,"change_date":"2024-11-19 21:41:00","inspection_id":"83197628","insp_unit_id":"203959495","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"TOWMA","insp_unit_company":null,"insp_unit_license":"4BM9929","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KNFT19272L160381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:55.000000Z","updated_at":"2025-03-17T23:43:55.000000Z"}]},{"id":7097677,"change_date":"2024-10-31 21:43:00","inspection_id":"83054385","dot_number":"1800538","report_state":"CA","report_number":"UEY5001196","insp_date":"2024-10-31 00:00:00","insp_start_time":"0827","insp_end_time":"0850","registration_date":null,"region":"PT","ci_status_code":"C","location":"859","location_desc":"SR-16 AT I-505","county_code_state":"CA","county_code":"113","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":"2024-10-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15579488","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2024-10-31 21:43:00","snet_input_date":"2024-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-31 21:43:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:43:54.000000Z","updated_at":"2025-03-17T20:43:54.000000Z","inspection_violations":[{"id":11082348,"change_date":"2024-10-31 21:43:00","inspection_id":"83054385","insp_violation_id":"262673918","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203689393","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3922SLLSR"},{"id":11082349,"change_date":"2024-10-31 21:43:00","inspection_id":"83054385","insp_violation_id":"262673919","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"203689393","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":11447184,"change_date":"2024-10-31 21:43:00","inspection_id":"83054385","insp_unit_id":"203689393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"02910H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:33.000000Z","updated_at":"2025-03-17T23:41:33.000000Z"}]},{"id":6314666,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","dot_number":"1800538","report_state":"CA","report_number":"NDA2006438","insp_date":"2024-07-24 00:00:00","insp_start_time":"1619","insp_end_time":"1657","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15457223","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2024-07-25 21:44:00","snet_input_date":"2024-07-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-25 21:44:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T20:27:52.000000Z","updated_at":"2025-03-17T20:27:52.000000Z","inspection_violations":[{"id":9806418,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854125","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202080987","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9806419,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854126","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202080987","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39021TB"},{"id":9806420,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854127","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202080987","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9806421,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854128","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202080987","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9806422,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854129","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202080987","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9806423,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854130","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202080987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA158354","created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3939A"},{"id":9806424,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854131","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202080988","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9806425,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_violation_id":"260854132","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202080988","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10174960,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_unit_id":"202080987","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BC04","insp_unit_license":"02910H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:22.000000Z","updated_at":"2025-03-17T23:28:22.000000Z"},{"id":10174961,"change_date":"2024-07-25 21:44:00","inspection_id":"82220567","insp_unit_id":"202080988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KRAFT","insp_unit_company":"BLU 3X","insp_unit_license":"4VP9094","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5E7HP343XPA002462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:22.000000Z","updated_at":"2025-03-17T23:28:22.000000Z"}]},{"id":3244673,"change_date":"2023-06-08 21:42:00","inspection_id":"78846641","dot_number":"1800538","report_state":"CA","report_number":"UDBH001907","insp_date":"2023-06-07 00:00:00","insp_start_time":"1416","insp_end_time":"1442","registration_date":null,"region":"PT","ci_status_code":"C","location":"360","location_desc":"US101 NB N OF PBN","county_code_state":"CA","county_code":"097","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":"2023-06-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14934644","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2023-06-08 21:42:00","snet_input_date":"2023-06-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-08 21:42:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[{"id":5002780,"change_date":"2023-06-08 21:42:00","inspection_id":"78846641","insp_violation_id":"253399260","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195408143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW350092","created_at":"2025-03-17T21:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"3922"},{"id":5002781,"change_date":"2023-06-08 21:42:00","inspection_id":"78846641","insp_violation_id":"253399261","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195408143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"3922"},{"id":5002782,"change_date":"2023-06-08 21:42:00","inspection_id":"78846641","insp_violation_id":"253399262","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195408143","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5218660,"change_date":"2023-06-08 21:42:00","inspection_id":"78846641","insp_unit_id":"195408143","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"02910H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","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":1243494,"change_date":"2022-09-08 21:39:00","inspection_id":"76560867","dot_number":"1800538","report_state":"CA","report_number":"NB7O004608","insp_date":"2022-09-07 00:00:00","insp_start_time":"1750","insp_end_time":"1814","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":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"14585614","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T18:49:41.000000Z","updated_at":"2025-03-17T18:49:41.000000Z","inspection_violations":[{"id":1969480,"change_date":"2022-09-08 21:39:00","inspection_id":"76560867","insp_violation_id":"248296513","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190798060","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3922"},{"id":1969481,"change_date":"2022-09-08 21:39:00","inspection_id":"76560867","insp_violation_id":"248296514","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190798061","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2001249,"change_date":"2022-09-08 21:39:00","inspection_id":"76560867","insp_unit_id":"190798060","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BC  04","insp_unit_license":"02910H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"},{"id":2001250,"change_date":"2022-09-08 21:39:00","inspection_id":"76560867","insp_unit_id":"190798061","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"RAMP","insp_unit_company":null,"insp_unit_license":"4RZ6251","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5SPTD3123JW2K1179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"}]},{"id":260865,"change_date":"2022-04-26 21:42:00","inspection_id":"75404399","dot_number":"1800538","report_state":"CA","report_number":"UDLV001680","insp_date":"2022-04-26 00:00:00","insp_start_time":"1101","insp_end_time":"1123","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":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-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14402038","transaction_code":"A","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2022-04-26 21:42:00","snet_input_date":"2022-04-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-26 21:42:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"535114","created_at":"2025-03-17T18:32:11.000000Z","updated_at":"2025-03-17T18:32:11.000000Z","inspection_violations":[{"id":401899,"change_date":"2022-04-26 21:42:00","inspection_id":"75404399","insp_violation_id":"245392786","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188357479","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KV84652","created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3922"},{"id":401900,"change_date":"2022-04-26 21:42:00","inspection_id":"75404399","insp_violation_id":"245392787","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":422543,"change_date":"2022-04-26 21:42:00","inspection_id":"75404399","insp_unit_id":"188357479","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"02910H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"}]},{"id":189376,"change_date":"2022-04-15 21:37:00","inspection_id":"75318842","dot_number":"1800538","report_state":"CA","report_number":"NCNG004782","insp_date":"2022-04-14 00:00:00","insp_start_time":"1500","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BAY CITIES ALPHALT","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"14387312","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01800538","upload_search_indicator":null,"census_search_date":"2022-04-15 21:37:00","snet_input_date":"2022-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"BAY CITIES ASPHALT INC","insp_carrier_street":"7948 N LOCKE RD","insp_carrier_city":"VACAVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95688","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:51.000000Z","updated_at":"2025-03-17T18:30:51.000000Z","inspection_violations":[{"id":290285,"change_date":"2022-04-15 21:37:00","inspection_id":"75318842","insp_violation_id":"245197946","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188186010","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JH07292","created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":306698,"change_date":"2022-04-15 21:37:00","inspection_id":"75318842","insp_unit_id":"188186009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BC04 BLUE","insp_unit_license":"02910H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV3CLBE1141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:02.000000Z","updated_at":"2025-03-17T22:10:02.000000Z"},{"id":306699,"change_date":"2022-04-15 21:37:00","inspection_id":"75318842","insp_unit_id":"188186010","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL","insp_unit_company":"RED","insp_unit_license":"1WX2478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4S0DP322311000340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:02.000000Z","updated_at":"2025-03-17T22:10:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1800538\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1800538\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1800538\/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\/1800538\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}