{"current_page":1,"data":[{"id":12344738,"change_date":"2026-07-02 21:40:00","inspection_id":"88304377","dot_number":"2654221","report_state":"CA","report_number":"UE03005021","insp_date":"2026-06-30 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"PD","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3671842","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2026-07-02 21:40:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-02 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-05T09:42:15.000000Z","updated_at":"2026-07-14T09:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21438216,"change_date":"2026-07-02 21:40:00","inspection_id":"88304377","insp_unit_id":"214418027","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4AX","insp_unit_license":"11760W2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X1LJ413688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:44.000000Z","updated_at":"2026-07-14T09:02:13.000000Z"}]},{"id":11774744,"change_date":"2026-04-28 21:40:00","inspection_id":"87705705","dot_number":"2654221","report_state":"CA","report_number":"UCUF004867","insp_date":"2026-04-27 00:00:00","insp_start_time":"1315","insp_end_time":"1345","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"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-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"124857","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":"16266404","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2026-04-28 21:40:00","snet_input_date":"2026-04-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-28 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2026-05-01T09:40:36.000000Z","updated_at":"2026-05-09T09:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20484534,"change_date":"2026-04-28 21:40:00","inspection_id":"87705705","insp_unit_id":"213277602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"221005","insp_unit_license":"9F63068","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV5HSJE3791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:21:07.000000Z","updated_at":"2026-05-09T09:04:30.000000Z"},{"id":20484535,"change_date":"2026-04-28 21:40:00","inspection_id":"87705705","insp_unit_id":"213277603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"4XC4569","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5C2BB30B35M004826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:21:07.000000Z","updated_at":"2026-05-09T09:04:30.000000Z"}]},{"id":11612355,"change_date":"2026-04-09 22:21:00","inspection_id":"87540000","dot_number":"2654221","report_state":"CA","report_number":"UEED003615","insp_date":"2026-04-08 00:00:00","insp_start_time":"1035","insp_end_time":"1056","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"EB JWO GREENVILLE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-09 22:21:00","post_acc_ind":"N","gross_comb_veh_wt":"124857","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":"16240534","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2026-04-09 22:21:00","snet_input_date":"2026-04-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-09 22:21:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-12T10:16:05.000000Z","updated_at":"2026-04-20T10:12:38.000000Z","inspection_violations":[{"id":20147473,"change_date":"2026-04-09 22:21:00","inspection_id":"87540000","insp_violation_id":"273509842","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212939664","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:28.000000Z","updated_at":"2026-04-19T14:08:44.000000Z","normalized_code":"3922SLLEQP"},{"id":20147474,"change_date":"2026-04-09 22:21:00","inspection_id":"87540000","insp_violation_id":"273509843","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"212939665","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:28.000000Z","updated_at":"2026-04-19T14:08:44.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20195820,"change_date":"2026-04-09 22:21:00","inspection_id":"87540000","insp_unit_id":"212939664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F63068","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV5HSJE3791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:50.000000Z","updated_at":"2026-04-19T10:38:19.000000Z"},{"id":20195821,"change_date":"2026-04-09 22:21:00","inspection_id":"87540000","insp_unit_id":"212939665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"4LC4691","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5C2BB30B35M004826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:50.000000Z","updated_at":"2026-04-19T10:38:19.000000Z"}]},{"id":11504348,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","dot_number":"2654221","report_state":"CA","report_number":"UEED003598","insp_date":"2026-03-26 00:00:00","insp_start_time":"1500","insp_end_time":"1520","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"JNO INDUSTRIAL WAY","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"5","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16226642","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:49.000000Z","updated_at":"2026-04-07T09:33:08.000000Z","inspection_violations":[{"id":19428612,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_violation_id":"272703844","seq_no":"1","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212392192","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"ST52522","created_at":"2026-03-30T10:20:26.000000Z","updated_at":"2026-04-07T09:49:55.000000Z","normalized_code":"39348ABIHE"},{"id":19428613,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_violation_id":"272703845","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"212392192","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-30T10:20:26.000000Z","updated_at":"2026-04-07T09:49:55.000000Z","normalized_code":"39343DBMA"},{"id":19428614,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_violation_id":"272703846","seq_no":"3","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"212392192","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-30T10:20:26.000000Z","updated_at":"2026-04-07T09:49:55.000000Z","normalized_code":"3939ALSLIWR"},{"id":19428615,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_violation_id":"272703847","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"212392192","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:26.000000Z","updated_at":"2026-04-07T09:49:55.000000Z","normalized_code":"3922SLLEQP"},{"id":19428616,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_violation_id":"272703848","seq_no":"5","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":"2026-03-30T10:20:26.000000Z","updated_at":"2026-04-07T09:49:55.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19708422,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_unit_id":"212392191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"30331H3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDFF6KT0MDA12663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:31.000000Z","updated_at":"2026-04-07T09:09:40.000000Z"},{"id":19708423,"change_date":"2026-03-27 21:40:00","inspection_id":"87424582","insp_unit_id":"212392192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAMAR","insp_unit_company":null,"insp_unit_license":"4NW5339","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5RVDT1426FM026409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:31.000000Z","updated_at":"2026-04-07T09:09:40.000000Z"}]},{"id":10602411,"change_date":"2026-01-08 21:40:00","inspection_id":"86741825","dot_number":"2654221","report_state":"CA","report_number":"UCU1001034","insp_date":"2026-01-07 00:00:00","insp_start_time":"1010","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"16120544","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:47.000000Z","updated_at":"2026-01-19T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17774848,"change_date":"2026-01-08 21:40:00","inspection_id":"86741825","insp_unit_id":"210984036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X WHT","insp_unit_license":"45543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL49X3LJ429930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:16.000000Z","updated_at":"2026-01-19T10:01:12.000000Z"}]},{"id":10591337,"change_date":"2026-01-07 21:39:00","inspection_id":"86730169","dot_number":"2654221","report_state":"CA","report_number":"NC7K010637","insp_date":"2026-01-06 00:00:00","insp_start_time":"1130","insp_end_time":"1200","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":"2026-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"16118686","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2026-01-07 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-07 21:39:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-10T10:34:42.000000Z","updated_at":"2026-01-18T10:32:07.000000Z","inspection_violations":[{"id":17802823,"change_date":"2026-01-07 21:39:00","inspection_id":"86730169","insp_violation_id":"271069708","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210961397","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:45.000000Z","normalized_code":"3922SLLEQP"},{"id":17802824,"change_date":"2026-01-07 21:39:00","inspection_id":"86730169","insp_violation_id":"271069709","seq_no":"2","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"210961397","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA767636","created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:45.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":17753974,"change_date":"2026-01-07 21:39:00","inspection_id":"86730169","insp_unit_id":"210961397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26\/WHT 3XED","insp_unit_license":"45543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL49X3LJ429930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:12.000000Z","updated_at":"2026-01-18T10:01:39.000000Z"}]},{"id":10071999,"change_date":"2025-10-29 21:41:00","inspection_id":"86185776","dot_number":"2654221","report_state":"CA","report_number":"UF44006746","insp_date":"2025-10-29 00:00:00","insp_start_time":"0530","insp_end_time":"0558","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"I-680 NB @ 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"16037635","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-10-29 21:41:00","snet_input_date":"2025-10-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-29 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-11-01T10:02:36.000000Z","updated_at":"2025-11-02T11:01:42.000000Z","inspection_violations":[{"id":16679035,"change_date":"2025-10-29 21:41:00","inspection_id":"86185776","insp_violation_id":"269604907","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"209728516","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SK57935","created_at":"2025-11-01T10:18:11.000000Z","updated_at":"2025-11-02T11:17:32.000000Z","normalized_code":"3922SLLEWA3"},{"id":16679036,"change_date":"2025-10-29 21:41:00","inspection_id":"86185776","insp_violation_id":"269604908","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"209728516","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SK57935","created_at":"2025-11-01T10:18:11.000000Z","updated_at":"2025-11-02T11:17:32.000000Z","normalized_code":"3922SLLEQP"},{"id":16679037,"change_date":"2025-10-29 21:41:00","inspection_id":"86185776","insp_violation_id":"269604909","seq_no":"3","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"209728516","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SK57935","created_at":"2025-11-01T10:18:11.000000Z","updated_at":"2025-11-02T11:17:32.000000Z","normalized_code":"3922SLLSOA"},{"id":16679038,"change_date":"2025-10-29 21:41:00","inspection_id":"86185776","insp_violation_id":"269604910","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"209728516","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:18:11.000000Z","updated_at":"2025-11-02T11:17:32.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":16741076,"change_date":"2025-10-29 21:41:00","inspection_id":"86185776","insp_unit_id":"209728516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:13.000000Z","updated_at":"2025-11-02T10:47:10.000000Z"}]},{"id":9811672,"change_date":"2025-09-29 21:40:00","inspection_id":"85911649","dot_number":"2654221","report_state":"CA","report_number":"UF44006668","insp_date":"2025-09-29 00:00:00","insp_start_time":"0654","insp_end_time":"0745","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 SB N N MISSION","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15998058","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-09-29 21:40:00","snet_input_date":"2025-09-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-29 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-10-02T10:00:27.000000Z","updated_at":"2025-10-03T10:01:32.000000Z","inspection_violations":[{"id":16141075,"change_date":"2025-09-29 21:40:00","inspection_id":"85911649","insp_violation_id":"268993928","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"209210258","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SK55642","created_at":"2025-10-02T10:15:42.000000Z","updated_at":"2025-10-03T10:17:35.000000Z","normalized_code":"3922SLLEQP"},{"id":16141076,"change_date":"2025-09-29 21:40:00","inspection_id":"85911649","insp_violation_id":"268993929","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"209210258","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SK55642","created_at":"2025-10-02T10:15:42.000000Z","updated_at":"2025-10-03T10:17:35.000000Z","normalized_code":"3922SLLEWA2"},{"id":16141077,"change_date":"2025-09-29 21:40:00","inspection_id":"85911649","insp_violation_id":"268993930","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"209210258","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-02T10:15:42.000000Z","updated_at":"2025-10-03T10:17:35.000000Z","normalized_code":"3922SLLEWA1"},{"id":16141078,"change_date":"2025-09-29 21:40:00","inspection_id":"85911649","insp_violation_id":"268993931","seq_no":"4","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"209210258","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SK55642","created_at":"2025-10-02T10:15:42.000000Z","updated_at":"2025-10-03T10:17:35.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":16262889,"change_date":"2025-09-29 21:40:00","inspection_id":"85911649","insp_unit_id":"209210258","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:25.000000Z","updated_at":"2025-10-03T09:47:04.000000Z"}]},{"id":9761217,"change_date":"2025-09-23 21:43:00","inspection_id":"85858637","dot_number":"2654221","report_state":"CA","report_number":"UED8001682","insp_date":"2025-09-22 00:00:00","insp_start_time":"1244","insp_end_time":"1303","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"SB I-680 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-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"15991514","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-09-23 21:43:00","snet_input_date":"2025-09-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-09-25T10:00:52.000000Z","updated_at":"2025-09-26T10:00:59.000000Z","inspection_violations":[{"id":16040891,"change_date":"2025-09-23 21:43:00","inspection_id":"85858637","insp_violation_id":"268881341","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209109496","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CD071419","created_at":"2025-09-26T10:17:00.000000Z","updated_at":"2025-09-27T10:16:40.000000Z","normalized_code":"3922SLLSR"},{"id":16040892,"change_date":"2025-09-23 21:43:00","inspection_id":"85858637","insp_violation_id":"268881342","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"209109496","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN31158","created_at":"2025-09-26T10:17:00.000000Z","updated_at":"2025-09-27T10:16:40.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":16169510,"change_date":"2025-09-23 21:43:00","inspection_id":"85858637","insp_unit_id":"209109496","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2","insp_unit_license":"18822T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEVTAR9LL805892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:11.000000Z","updated_at":"2025-09-27T09:46:12.000000Z"}]},{"id":9464313,"change_date":"2025-08-20 21:40:00","inspection_id":"85547088","dot_number":"2654221","report_state":"CA","report_number":"UDBH003621","insp_date":"2025-08-20 00:00:00","insp_start_time":"0644","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"9360","location_desc":"101 NB AT PBN","county_code_state":"CA","county_code":"097","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-08-20 21:40: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":"15946705","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-08-20 21:40:00","snet_input_date":"2025-08-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-20 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:55.000000Z","updated_at":"2025-08-25T10:42:27.000000Z","inspection_violations":[{"id":15417531,"change_date":"2025-08-20 21:40:00","inspection_id":"85547088","insp_violation_id":"268150474","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208499030","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BJ55141","created_at":"2025-08-23T10:49:24.000000Z","updated_at":"2025-08-24T10:48:10.000000Z","normalized_code":"3922SLLSOA"},{"id":15417532,"change_date":"2025-08-20 21:40:00","inspection_id":"85547088","insp_violation_id":"268150475","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208499030","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BJ55141","created_at":"2025-08-23T10:49:24.000000Z","updated_at":"2025-08-24T10:48:10.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":15607962,"change_date":"2025-08-20 21:40:00","inspection_id":"85547088","insp_unit_id":"208499030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2XL WHT","insp_unit_license":"50574D4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML0ML354580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:48.000000Z","updated_at":"2025-08-24T09:46:22.000000Z"}]},{"id":9180613,"change_date":"2025-07-24 21:41:00","inspection_id":"85248746","dot_number":"2654221","report_state":"CA","report_number":"UFYK000659","insp_date":"2025-07-15 00:00:00","insp_start_time":"1128","insp_end_time":"1155","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-17 21:42: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":"15903342","transaction_code":"C","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-07-21T10:43:22.000000Z","updated_at":"2025-07-30T10:00:41.000000Z","inspection_violations":[{"id":14952539,"change_date":"2025-07-24 21:41:00","inspection_id":"85248746","insp_violation_id":"267638607","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208066321","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:38.000000Z","normalized_code":"3922SLLSOA"},{"id":14952540,"change_date":"2025-07-24 21:41:00","inspection_id":"85248746","insp_violation_id":"267638608","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208066321","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA516949","created_at":"2025-07-27T10:44:10.000000Z","updated_at":"2025-07-28T10:48:38.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":15197248,"change_date":"2025-07-24 21:41:00","inspection_id":"85248746","insp_unit_id":"208066321","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHI 2X","insp_unit_license":"50574D4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML0ML354580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:30.000000Z","updated_at":"2025-07-28T09:45:50.000000Z"}]},{"id":9016536,"change_date":"2025-06-27 21:39:00","inspection_id":"85075974","dot_number":"2654221","report_state":"CA","report_number":"UF44006303","insp_date":"2025-06-26 00:00:00","insp_start_time":"1313","insp_end_time":"1323","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15877878","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-06-30T10:01:26.000000Z","updated_at":"2025-07-03T10:00:55.000000Z","inspection_violations":[{"id":14494427,"change_date":"2025-06-27 21:39:00","inspection_id":"85075974","insp_violation_id":"267101579","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":"SC34677","created_at":"2025-06-30T10:17:53.000000Z","updated_at":"2025-07-02T10:16:24.000000Z","normalized_code":"3922SLLTCD"},{"id":14494428,"change_date":"2025-06-27 21:39:00","inspection_id":"85075974","insp_violation_id":"267101580","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207613073","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC34678","created_at":"2025-06-30T10:17:53.000000Z","updated_at":"2025-07-02T10:16:24.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":14787858,"change_date":"2025-06-27 21:39:00","inspection_id":"85075974","insp_unit_id":"207613073","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"30331H3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDFF6KT0MDA12663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:40.000000Z","updated_at":"2025-07-01T09:50:03.000000Z"}]},{"id":9006238,"change_date":"2025-06-26 21:42:00","inspection_id":"85065233","dot_number":"2654221","report_state":"CA","report_number":"UF44006262","insp_date":"2025-06-18 00:00:00","insp_start_time":"1244","insp_end_time":"1251","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","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":"Y","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":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15865293","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-06-30T10:01:14.000000Z","updated_at":"2025-06-30T10:01:14.000000Z","inspection_violations":[{"id":14475990,"change_date":"2025-06-26 21:42:00","inspection_id":"85065233","insp_violation_id":"267080699","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":"SC35512","created_at":"2025-06-29T10:17:06.000000Z","updated_at":"2025-06-30T10:18:56.000000Z","normalized_code":"3922SLLTCD"},{"id":14475991,"change_date":"2025-06-26 21:42:00","inspection_id":"85065233","insp_violation_id":"267080700","seq_no":"2","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"207593689","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC35513","created_at":"2025-06-29T10:17:06.000000Z","updated_at":"2025-06-30T10:18:56.000000Z","normalized_code":"39311A1LRR"}],"inspection_per_units":[{"id":14769890,"change_date":"2025-06-26 21:42:00","inspection_id":"85065233","insp_unit_id":"207593689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"05725J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML4NL455056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:29.000000Z","updated_at":"2025-07-01T09:48:55.000000Z"}]},{"id":8232054,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","dot_number":"2654221","report_state":"CA","report_number":"UEED003027","insp_date":"2025-03-25 00:00:00","insp_start_time":"1735","insp_end_time":"1816","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"NB JNO I-580","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"63199","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":"15757528","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-03-27 21:42:00","snet_input_date":"2025-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:53.000000Z","updated_at":"2025-03-31T10:31:52.000000Z","inspection_violations":[{"id":12921785,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_violation_id":"265304207","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206034766","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:58:53.000000Z","updated_at":"2025-03-31T11:03:31.000000Z","normalized_code":"3922SLLSR"},{"id":12921786,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_violation_id":"265304208","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"206034766","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-29T10:58:53.000000Z","updated_at":"2025-03-31T11:03:31.000000Z","normalized_code":"39343DBMA"},{"id":12921787,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_violation_id":"265304209","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206034766","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:58:53.000000Z","updated_at":"2025-03-31T11:03:31.000000Z","normalized_code":"3922SLLSR"},{"id":12921788,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_violation_id":"265304210","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206034765","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:58:53.000000Z","updated_at":"2025-03-31T11:03:31.000000Z","normalized_code":"3922SLLSR"},{"id":12921789,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_violation_id":"265304211","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206034765","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SA23518","created_at":"2025-03-29T10:58:53.000000Z","updated_at":"2025-03-31T11:03:31.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13317183,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_unit_id":"206034765","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"45543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL49X3LJ429930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:31:43.000000Z","updated_at":"2025-03-31T10:13:21.000000Z"},{"id":13317184,"change_date":"2025-03-27 21:42:00","inspection_id":"84247924","insp_unit_id":"206034766","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAMAR","insp_unit_company":null,"insp_unit_license":"4NW5339","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5RVDT1426FM026409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:31:43.000000Z","updated_at":"2025-03-31T10:13:21.000000Z"}]},{"id":8075950,"change_date":"2025-03-10 21:39:00","inspection_id":"84083663","dot_number":"2654221","report_state":"CA","report_number":"UGHP000014","insp_date":"2025-03-07 00:00:00","insp_start_time":"1605","insp_end_time":"1615","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"N\/OF INDUSTRIAL","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15732754","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-03-10 21:39:00","snet_input_date":"2025-03-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-10 21:39:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13039249,"change_date":"2025-03-10 21:39:00","inspection_id":"84083663","insp_unit_id":"205720221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:05.000000Z","updated_at":"2025-03-17T23:59:05.000000Z"}]},{"id":7959956,"change_date":"2025-02-25 21:41:00","inspection_id":"83961648","dot_number":"2654221","report_state":"CA","report_number":"UF44005862","insp_date":"2025-02-25 00:00:00","insp_start_time":"1243","insp_end_time":"1302","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"MISSION RD NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15717671","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-02-25 21:41:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[{"id":12438468,"change_date":"2025-02-25 21:41:00","inspection_id":"83961648","insp_violation_id":"264697918","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":"RV67382","created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12849645,"change_date":"2025-02-25 21:41:00","inspection_id":"83961648","insp_unit_id":"205497311","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7836419,"change_date":"2025-02-10 21:41:00","inspection_id":"83832203","dot_number":"2654221","report_state":"CA","report_number":"UEH7006323","insp_date":"2025-02-10 00:00:00","insp_start_time":"1036","insp_end_time":"1047","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"CORRAL HOLLOW RD","county_code_state":"CA","county_code":"077","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-02-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15699206","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-02-10 21:41:00","snet_input_date":"2025-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-10 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T21:00:48.000000Z","updated_at":"2025-03-17T21:00:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12647243,"change_date":"2025-02-10 21:41:00","inspection_id":"83832203","insp_unit_id":"205258701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:42.000000Z","updated_at":"2025-03-17T23:54:42.000000Z"}]},{"id":7899580,"change_date":"2025-02-18 21:40:00","inspection_id":"83898436","dot_number":"2654221","report_state":"CA","report_number":"NDCK002492","insp_date":"2025-02-10 00:00:00","insp_start_time":"0739","insp_end_time":"0828","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","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":"2025-02-18 21:40: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":"15708004","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12751346,"change_date":"2025-02-18 21:40:00","inspection_id":"83898436","insp_unit_id":"205381274","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"11760W2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X1LJ413688","insp_unit_decal":"Y","insp_unit_decal_number":"34764941","created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7899581,"change_date":"2025-02-18 21:40:00","inspection_id":"83898437","dot_number":"2654221","report_state":"CA","report_number":"NDCK002493","insp_date":"2025-02-10 00:00:00","insp_start_time":"0835","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","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":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"15708005","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[{"id":12344800,"change_date":"2025-02-18 21:40:00","inspection_id":"83898437","insp_violation_id":"264575970","seq_no":"1","part_no":"393","part_no_section":"47D2-BLT-1\/16AD","insp_viol_unit":"2","insp_unit_id":"205381276","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"39347D2BLT1\/16AD"}],"inspection_per_units":[{"id":12751347,"change_date":"2025-02-18 21:40:00","inspection_id":"83898437","insp_unit_id":"205381275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"9F63068","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV5HSJE3791","insp_unit_decal":"Y","insp_unit_decal_number":"34764940","created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"},{"id":12751348,"change_date":"2025-02-18 21:40:00","inspection_id":"83898437","insp_unit_id":"205381276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"4RF7011","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5C2EF30F85M004826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7899582,"change_date":"2025-02-18 21:40:00","inspection_id":"83898438","dot_number":"2654221","report_state":"CA","report_number":"NDCK002494","insp_date":"2025-02-10 00:00:00","insp_start_time":"0940","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","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":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15708006","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12751349,"change_date":"2025-02-18 21:40:00","inspection_id":"83898438","insp_unit_id":"205381277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"81181B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X0MJ468585","insp_unit_decal":"Y","insp_unit_decal_number":"34764938","created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7899583,"change_date":"2025-02-18 21:40:00","inspection_id":"83898439","dot_number":"2654221","report_state":"CA","report_number":"NDCK002495","insp_date":"2025-02-10 00:00:00","insp_start_time":"1045","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","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":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"15708007","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12751350,"change_date":"2025-02-18 21:40:00","inspection_id":"83898439","insp_unit_id":"205381278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"45543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL49X3LJ429930","insp_unit_decal":"Y","insp_unit_decal_number":"34764939","created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7569178,"change_date":"2025-01-07 21:41:00","inspection_id":"83551408","dot_number":"2654221","report_state":"CA","report_number":"UF44005688","insp_date":"2025-01-06 00:00:00","insp_start_time":"1441","insp_end_time":"1502","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"NATIONAL DR X BRISA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15651536","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2025-01-07 21:41:00","snet_input_date":"2025-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-07 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T20:55:17.000000Z","updated_at":"2025-03-17T20:55:17.000000Z","inspection_violations":[{"id":11833108,"change_date":"2025-01-07 21:41:00","inspection_id":"83551408","insp_violation_id":"263806160","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"204696897","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ74567","created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLEWA3"},{"id":11833109,"change_date":"2025-01-07 21:41:00","inspection_id":"83551408","insp_violation_id":"263806161","seq_no":"2","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:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLTCD"},{"id":11833110,"change_date":"2025-01-07 21:41:00","inspection_id":"83551408","insp_violation_id":"263806162","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204696897","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLSR"},{"id":11833111,"change_date":"2025-01-07 21:41:00","inspection_id":"83551408","insp_violation_id":"263806163","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"204696897","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ74567","created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":12212679,"change_date":"2025-01-07 21:41:00","inspection_id":"83551408","insp_unit_id":"204696897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:49.000000Z","updated_at":"2025-03-17T23:49:49.000000Z"}]},{"id":7522303,"change_date":"2024-12-30 21:39:00","inspection_id":"83502133","dot_number":"2654221","report_state":"CA","report_number":"UE1B001431","insp_date":"2024-12-30 00:00:00","insp_start_time":"0650","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"310","location_desc":"N\/B MARIN SCALE (TERRA LINDA)","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":"Y","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":"53000","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":"15644590","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T20:53:09.000000Z","updated_at":"2025-03-17T20:53:09.000000Z","inspection_violations":[{"id":11758008,"change_date":"2024-12-30 21:39:00","inspection_id":"83502133","insp_violation_id":"263702743","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204599049","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW 754006","created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3922SLLSR"},{"id":11758009,"change_date":"2024-12-30 21:39:00","inspection_id":"83502133","insp_violation_id":"263702744","seq_no":"2","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"204599049","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW 754006","created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39311A1LBL"}],"inspection_per_units":[{"id":12135784,"change_date":"2024-12-30 21:39:00","inspection_id":"83502133","insp_unit_id":"204599049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3XWHI","insp_unit_license":"18822T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEVTAR9LL805892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:00.000000Z","updated_at":"2025-03-17T23:49:00.000000Z"}]},{"id":7224297,"change_date":"2024-11-18 21:41:00","inspection_id":"83188529","dot_number":"2654221","report_state":"CA","report_number":"UEED002755","insp_date":"2024-11-14 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"SB JNO HAWTHORN","county_code_state":"CA","county_code":"001","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":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15595981","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[{"id":11292189,"change_date":"2024-11-18 21:41:00","inspection_id":"83188529","insp_violation_id":"262964978","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"203942307","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ56596","created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"3922SLLEWA3"},{"id":11292190,"change_date":"2024-11-18 21:41:00","inspection_id":"83188529","insp_violation_id":"262964979","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"203942307","insp_violation_category_id":"47","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":"3922SLLEWA2"}],"inspection_per_units":[{"id":11652843,"change_date":"2024-11-18 21:41:00","inspection_id":"83188529","insp_unit_id":"203942307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"81181B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X0MJ468585","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":6578807,"change_date":"2024-08-27 21:43:00","inspection_id":"82502492","dot_number":"2654221","report_state":"CA","report_number":"UDLV003592","insp_date":"2024-08-27 00:00:00","insp_start_time":"0535","insp_end_time":"0556","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":"4","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-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15497774","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-08-27 21:43:00","snet_input_date":"2024-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-27 21:43:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T20:33:14.000000Z","updated_at":"2025-03-17T20:33:14.000000Z","inspection_violations":[{"id":10227813,"change_date":"2024-08-27 21:43:00","inspection_id":"82502492","insp_violation_id":"261449552","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202616575","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"3939A"},{"id":10227814,"change_date":"2024-08-27 21:43:00","inspection_id":"82502492","insp_violation_id":"261449553","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202616575","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39021TB"},{"id":10227815,"change_date":"2024-08-27 21:43:00","inspection_id":"82502492","insp_violation_id":"261449554","seq_no":"3","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"1","insp_unit_id":"202616575","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39216B"},{"id":10227816,"change_date":"2024-08-27 21:43:00","inspection_id":"82502492","insp_violation_id":"261449555","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":10605997,"change_date":"2024-08-27 21:43:00","inspection_id":"82502492","insp_unit_id":"202616575","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:52.000000Z","updated_at":"2025-03-17T23:32:52.000000Z"}]},{"id":5989883,"change_date":"2024-06-13 21:43:00","inspection_id":"81871433","dot_number":"2654221","report_state":"CA","report_number":"UEED002381","insp_date":"2024-06-10 00:00:00","insp_start_time":"0524","insp_end_time":"1800","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"JSO INDUSTRIAL WAY","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15401930","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-06-13 21:43:00","snet_input_date":"2024-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:43:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T20:21:28.000000Z","updated_at":"2025-03-17T20:21:28.000000Z","inspection_violations":[{"id":9292075,"change_date":"2024-06-13 21:43:00","inspection_id":"81871433","insp_violation_id":"260080792","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201391049","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:57.000000Z","updated_at":"2025-03-17T21:50:57.000000Z","normalized_code":"3922"},{"id":9292076,"change_date":"2024-06-13 21:43:00","inspection_id":"81871433","insp_violation_id":"260080793","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201391049","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:57.000000Z","updated_at":"2025-03-17T21:50:57.000000Z","normalized_code":"3922"},{"id":9292077,"change_date":"2024-06-13 21:43:00","inspection_id":"81871433","insp_violation_id":"260080794","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"201391049","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"ML49307","created_at":"2025-03-17T21:50:57.000000Z","updated_at":"2025-03-17T21:50:57.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":9647855,"change_date":"2024-06-13 21:43:00","inspection_id":"81871433","insp_unit_id":"201391049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"11761W2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X3LJ413689","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"}]},{"id":5442555,"change_date":"2024-04-04 21:43:00","inspection_id":"81275971","dot_number":"2654221","report_state":"CA","report_number":"UDBL003011","insp_date":"2024-04-02 00:00:00","insp_start_time":"0833","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"15306705","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-04-04 21:43:00","snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1355192","created_at":"2025-03-17T20:10:39.000000Z","updated_at":"2025-03-17T20:10:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8766669,"change_date":"2024-04-04 21:43:00","inspection_id":"81275971","insp_unit_id":"200251898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3XEDWHT","insp_unit_license":"45543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL49X3LJ429930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"}]},{"id":5394280,"change_date":"2024-03-28 21:41:00","inspection_id":"81223195","dot_number":"2654221","report_state":"CA","report_number":"UCZC002236","insp_date":"2024-03-27 00:00:00","insp_start_time":"1635","insp_end_time":"1659","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"I-680 NB MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15298453","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:29.000000Z","updated_at":"2025-03-17T20:09:29.000000Z","inspection_violations":[{"id":8325838,"change_date":"2024-03-28 21:41:00","inspection_id":"81223195","insp_violation_id":"258647295","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8687776,"change_date":"2024-03-28 21:41:00","inspection_id":"81223195","insp_unit_id":"200145550","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4X WHT","insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:48.000000Z","updated_at":"2025-03-17T23:13:48.000000Z"}]},{"id":5291185,"change_date":"2024-03-14 21:42:00","inspection_id":"81110934","dot_number":"2654221","report_state":"CA","report_number":"UDLV003120","insp_date":"2024-03-14 00:00:00","insp_start_time":"0652","insp_end_time":"0703","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONTRA COSTA BLVD OFF RAMP","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15280806","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T20:07:30.000000Z","updated_at":"2025-03-17T20:07:30.000000Z","inspection_violations":[{"id":8159694,"change_date":"2024-03-14 21:42:00","inspection_id":"81110934","insp_violation_id":"258396579","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8520750,"change_date":"2024-03-14 21:42:00","inspection_id":"81110934","insp_unit_id":"199924970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"34","insp_unit_license":"26982Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT5LDA03028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:14.000000Z","updated_at":"2025-03-17T23:12:14.000000Z"}]},{"id":5066440,"change_date":"2024-02-15 21:43:00","inspection_id":"80865953","dot_number":"2654221","report_state":"CA","report_number":"UEGX000117","insp_date":"2024-02-15 00:00:00","insp_start_time":"0550","insp_end_time":"0630","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":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15239538","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2024-02-15 21:43:00","snet_input_date":"2024-02-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-15 21:43:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T20:03:04.000000Z","updated_at":"2025-03-17T20:03:04.000000Z","inspection_violations":[{"id":7809214,"change_date":"2024-02-15 21:43:00","inspection_id":"80865953","insp_violation_id":"257873538","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"199454701","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"393100B"},{"id":7809215,"change_date":"2024-02-15 21:43:00","inspection_id":"80865953","insp_violation_id":"257873539","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199454701","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"39311"},{"id":7809216,"change_date":"2024-02-15 21:43:00","inspection_id":"80865953","insp_violation_id":"257873540","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199454701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8155740,"change_date":"2024-02-15 21:43:00","inspection_id":"80865953","insp_unit_id":"199454701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:57.000000Z","updated_at":"2025-03-17T23:08:57.000000Z"}]},{"id":3679145,"change_date":"2023-08-04 21:41:00","inspection_id":"79335218","dot_number":"2654221","report_state":"CA","report_number":"UEED002068","insp_date":"2023-07-27 00:00:00","insp_start_time":"1100","insp_end_time":"1118","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"NB AT LAS POSITAS","county_code_state":"CA","county_code":"001","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-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15008289","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[{"id":5673098,"change_date":"2023-08-04 21:41:00","inspection_id":"79335218","insp_violation_id":"254491365","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196383757","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KH25191","created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":5915256,"change_date":"2023-08-04 21:41:00","inspection_id":"79335218","insp_unit_id":"196383757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"F550","insp_unit_license":"26982Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT5LDA03028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:44.000000Z","updated_at":"2025-03-17T22:49:44.000000Z"}]},{"id":2280141,"change_date":"2023-02-01 21:42:00","inspection_id":"77752119","dot_number":"2654221","report_state":"CA","report_number":"UF44003507","insp_date":"2023-01-31 00:00:00","insp_start_time":"1616","insp_end_time":"1633","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 SB @ BOLLINGER CNYN","county_code_state":"CA","county_code":"001","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":"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":"24500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14765312","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T19:08:49.000000Z","updated_at":"2025-03-17T19:08:49.000000Z","inspection_violations":[{"id":3516683,"change_date":"2023-02-01 21:42:00","inspection_id":"77752119","insp_violation_id":"250903609","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP37908","created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"39282A1"},{"id":3516684,"change_date":"2023-02-01 21:42:00","inspection_id":"77752119","insp_violation_id":"250903610","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193186273","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP37909","created_at":"2025-03-17T21:23:35.000000Z","updated_at":"2025-03-17T21:23:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3670399,"change_date":"2023-02-01 21:42:00","inspection_id":"77752119","insp_unit_id":"193186272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"26982Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT5LDA03028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:19.000000Z","updated_at":"2025-03-17T22:32:19.000000Z"},{"id":3670400,"change_date":"2023-02-01 21:42:00","inspection_id":"77752119","insp_unit_id":"193186273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOOSA","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FXCABAA1DU450657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:19.000000Z","updated_at":"2025-03-17T22:32:19.000000Z"}]},{"id":2247399,"change_date":"2023-01-27 21:41:00","inspection_id":"77715271","dot_number":"2654221","report_state":"CA","report_number":"N9ZT004227","insp_date":"2023-01-24 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"14759034","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2023-01-27 21:41:00","snet_input_date":"2023-01-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T19:08:07.000000Z","updated_at":"2025-03-17T19:08:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3617460,"change_date":"2023-01-27 21:41:00","inspection_id":"77715271","insp_unit_id":"193112314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"81181B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X0MJ468585","insp_unit_decal":"Y","insp_unit_decal_number":"32141630","created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"}]},{"id":2022635,"change_date":"2022-12-27 21:40:00","inspection_id":"77457725","dot_number":"2654221","report_state":"CA","report_number":"UF44003346","insp_date":"2022-12-23 00:00:00","insp_start_time":"1045","insp_end_time":"1128","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB JNO SR-84","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14720272","transaction_code":"A","transaction_date":"2022-12-23 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-12-27 21:40:00","snet_input_date":"2022-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-27 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T19:03:58.000000Z","updated_at":"2025-03-17T19:03:58.000000Z","inspection_violations":[{"id":3137080,"change_date":"2022-12-27 21:40:00","inspection_id":"77457725","insp_violation_id":"250281540","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36280","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"},{"id":3137081,"change_date":"2022-12-27 21:40:00","inspection_id":"77457725","insp_violation_id":"250281541","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192596885","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36280","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"},{"id":3137082,"change_date":"2022-12-27 21:40:00","inspection_id":"77457725","insp_violation_id":"250281542","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192596885","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3254263,"change_date":"2022-12-27 21:40:00","inspection_id":"77457725","insp_unit_id":"192596885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5 - 4X WHT","insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:17.000000Z","updated_at":"2025-03-17T22:29:17.000000Z"}]},{"id":2008495,"change_date":"2022-12-22 21:40:00","inspection_id":"77441760","dot_number":"2654221","report_state":"CA","report_number":"UEDD000039","insp_date":"2022-12-21 00:00:00","insp_start_time":"1537","insp_end_time":"1545","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB S ANDRADE","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14718064","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-12-22 21:40:00","snet_input_date":"2022-12-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-22 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[{"id":3117927,"change_date":"2022-12-22 21:40:00","inspection_id":"77441760","insp_violation_id":"250252125","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP35272","created_at":"2025-03-17T21:21:46.000000Z","updated_at":"2025-03-17T21:21:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3231230,"change_date":"2022-12-22 21:40:00","inspection_id":"77441760","insp_unit_id":"192566264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"88984E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT3KDA19923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]},{"id":1991223,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","dot_number":"2654221","report_state":"CA","report_number":"UEDD000017","insp_date":"2022-12-20 00:00:00","insp_start_time":"0630","insp_end_time":"0732","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"JOHNSON DR X STONERIDGE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14715401","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[{"id":3091538,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209016","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CK018620","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39311"},{"id":3091539,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209017","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018620","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39021TB"},{"id":3091540,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209018","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018620","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3963A1"},{"id":3091541,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209019","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375C"},{"id":3091542,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209020","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018620","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375C"},{"id":3091543,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209021","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3922"},{"id":3091544,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209022","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3922"},{"id":3091545,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209023","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP35262","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3922"},{"id":3091546,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_violation_id":"250209024","seq_no":"9","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"192527313","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":3203757,"change_date":"2022-12-20 21:41:00","inspection_id":"77422072","insp_unit_id":"192527313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"81181B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X0MJ468585","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1629437,"change_date":"2022-10-28 21:40:00","inspection_id":"77007526","dot_number":"2654221","report_state":"CA","report_number":"UDLV002055","insp_date":"2022-10-28 00:00:00","insp_start_time":"0923","insp_end_time":"0935","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"LAS GALLINAS S\/OF LUCAS VALLEY","county_code_state":"CA","county_code":"041","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14654719","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-10-28 21:40:00","snet_input_date":"2022-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:56:40.000000Z","updated_at":"2025-03-17T18:56:40.000000Z","inspection_violations":[{"id":2558568,"change_date":"2022-10-28 21:40:00","inspection_id":"77007526","insp_violation_id":"249323382","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:01.000000Z","updated_at":"2025-03-17T21:19:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2621344,"change_date":"2022-10-28 21:40:00","inspection_id":"77007526","insp_unit_id":"191706229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":1555186,"change_date":"2022-10-19 21:42:00","inspection_id":"76922309","dot_number":"2654221","report_state":"CA","report_number":"NB7O004789","insp_date":"2022-10-18 00:00:00","insp_start_time":"1338","insp_end_time":"1404","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-10-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"14641458","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":"02654221","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":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:55:14.000000Z","updated_at":"2025-03-17T18:55:14.000000Z","inspection_violations":[{"id":2446686,"change_date":"2022-10-19 21:42:00","inspection_id":"76922309","insp_violation_id":"249135106","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191535752","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"},{"id":2446687,"change_date":"2022-10-19 21:42:00","inspection_id":"76922309","insp_violation_id":"249135107","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191535752","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"},{"id":2446688,"change_date":"2022-10-19 21:42:00","inspection_id":"76922309","insp_violation_id":"249135108","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191535752","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2502600,"change_date":"2022-10-19 21:42:00","inspection_id":"76922309","insp_unit_id":"191535752","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"96747Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X9MJ468584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:09.000000Z","updated_at":"2025-03-17T22:24:09.000000Z"}]},{"id":1309479,"change_date":"2022-09-16 21:41:00","inspection_id":"76637619","dot_number":"2654221","report_state":"CA","report_number":"UF44003039","insp_date":"2022-09-16 00:00:00","insp_start_time":"1202","insp_end_time":"1216","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"SOUTHFRONT X I-580","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14597816","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-09-16 21:41:00","snet_input_date":"2022-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:50:50.000000Z","updated_at":"2025-03-17T18:50:50.000000Z","inspection_violations":[{"id":2073623,"change_date":"2022-09-16 21:41:00","inspection_id":"76637619","insp_violation_id":"248486737","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LR37971","created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3922"},{"id":2073624,"change_date":"2022-09-16 21:41:00","inspection_id":"76637619","insp_violation_id":"248486738","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190959156","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3922"},{"id":2073625,"change_date":"2022-09-16 21:41:00","inspection_id":"76637619","insp_violation_id":"248486739","seq_no":"3","part_no":"392","part_no_section":"5(a)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3925A3"}],"inspection_per_units":[{"id":2107942,"change_date":"2022-09-16 21:41:00","inspection_id":"76637619","insp_unit_id":"190959156","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"88985E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT3KDA19923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":781394,"change_date":"2022-07-08 21:41:00","inspection_id":"76021859","dot_number":"2654221","report_state":"CA","report_number":"NDUP002955","insp_date":"2022-07-07 00:00:00","insp_start_time":"1250","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:41: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":"14498889","transaction_code":"A","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[{"id":1235303,"change_date":"2022-07-08 21:41:00","inspection_id":"76021859","insp_violation_id":"246985755","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189682324","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3922"},{"id":1235304,"change_date":"2022-07-08 21:41:00","inspection_id":"76021859","insp_violation_id":"246985756","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189682324","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1257439,"change_date":"2022-07-08 21:41:00","inspection_id":"76021859","insp_unit_id":"189682324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"#1 3X FLAT","insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","insp_unit_decal":"Y","insp_unit_decal_number":"31469733","created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"}]},{"id":704839,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","dot_number":"2654221","report_state":"CA","report_number":"UF44002768","insp_date":"2022-06-24 00:00:00","insp_start_time":"2012","insp_end_time":"2041","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"NISSEN DR X KITTYHAWK","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26522","viol_total":"6","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14484958","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-06-27 21:41:00","snet_input_date":"2022-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:40:09.000000Z","updated_at":"2025-03-17T18:40:09.000000Z","inspection_violations":[{"id":1107802,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_violation_id":"246749857","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189489996","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP31847","created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"39348A"},{"id":1107803,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_violation_id":"246749858","seq_no":"2","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"189489996","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP31847","created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"39343D"},{"id":1107804,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_violation_id":"246749859","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189489996","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP31847","created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"3939A"},{"id":1107805,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_violation_id":"246749860","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189489996","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP31847","created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"3922"},{"id":1107806,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_violation_id":"246749861","seq_no":"5","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"38323A2"},{"id":1107807,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_violation_id":"246749862","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189489995","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP31847","created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1133181,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_unit_id":"189489995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"81506B2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G67GED30728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"},{"id":1133182,"change_date":"2022-06-27 21:41:00","inspection_id":"75932281","insp_unit_id":"189489996","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"DOOSA","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"UN5CCBHB0KY894903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"}]},{"id":412225,"change_date":"2022-05-17 21:43:00","inspection_id":"75584699","dot_number":"2654221","report_state":"CA","report_number":"UBSS001356","insp_date":"2022-05-17 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"ST VINCENT","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":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14431875","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":"02654221","upload_search_indicator":null,"census_search_date":"2022-05-17 21:43:00","snet_input_date":"2022-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[{"id":645452,"change_date":"2022-05-17 21:43:00","inspection_id":"75584699","insp_violation_id":"245860560","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"38323A2"},{"id":645453,"change_date":"2022-05-17 21:43:00","inspection_id":"75584699","insp_violation_id":"245860561","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188742452","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":645454,"change_date":"2022-05-17 21:43:00","inspection_id":"75584699","insp_violation_id":"245860562","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188742452","insp_violation_category_id":"47","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":645455,"change_date":"2022-05-17 21:43:00","inspection_id":"75584699","insp_violation_id":"245860563","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188742452","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KQ70667","created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":665756,"change_date":"2022-05-17 21:43:00","inspection_id":"75584699","insp_unit_id":"188742452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","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":197935,"change_date":"2022-04-18 21:44:00","inspection_id":"75328993","dot_number":"2654221","report_state":"CA","report_number":"NDQ6005288","insp_date":"2022-04-13 00:00:00","insp_start_time":"1641","insp_end_time":"1736","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14389407","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02654221","upload_search_indicator":null,"census_search_date":"2022-04-18 21:44:00","snet_input_date":"2022-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-18 21:44:00","insp_carrier_name":"CALIFORNIA'S GUNITE AND POOL PLASTERING INC","insp_carrier_street":"510 GREENVILLE ROAD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"135192","created_at":"2025-03-17T18:30:54.000000Z","updated_at":"2025-03-17T18:30:54.000000Z","inspection_violations":[{"id":303586,"change_date":"2022-04-18 21:44:00","inspection_id":"75328993","insp_violation_id":"245221759","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"188207485","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":320816,"change_date":"2022-04-18 21:44:00","inspection_id":"75328993","insp_unit_id":"188207485","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2X FB","insp_unit_license":"73721B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML2ML183024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:07.000000Z","updated_at":"2025-03-17T22:10:07.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2654221\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2654221\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2654221\/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\/2654221\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}