{"current_page":1,"data":[{"id":12265153,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","dot_number":"3457083","report_state":"CA","report_number":"UGAU000464","insp_date":"2026-06-23 00:00:00","insp_start_time":"1240","insp_end_time":"1339","registration_date":null,"region":"PS","ci_status_code":"C","location":"888","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BASALITE","shipping_paper_number":"78185689","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-06-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","viol_total":"10","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3605569","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2026-06-25 21:49:00","snet_input_date":"2026-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:49:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207-3018","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:12.000000Z","updated_at":"2026-07-06T09:30:19.000000Z","inspection_violations":[{"id":21350039,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096359","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ST 57427","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3922SLLEWA1"},{"id":21350040,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096360","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3922SLLEWA1"},{"id":21350041,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096361","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3922SLLEWA1"},{"id":21350043,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096363","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214257573","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ST 57428","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3922SLLSR"},{"id":21350044,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096364","seq_no":"6","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214257573","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3922SLLEQP"},{"id":21350045,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096365","seq_no":"7","part_no":"393","part_no_section":"51C-BNVLAWD","insp_viol_unit":"1","insp_unit_id":"214257573","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"39351CBNVLAWD"},{"id":21350046,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096366","seq_no":"8","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"214257573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3939ALHLI"},{"id":21350047,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096367","seq_no":"9","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"214257573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"39311A1CSLRR"},{"id":21350048,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096368","seq_no":"10","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214257574","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3939ALIL"},{"id":21350042,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_violation_id":"275096362","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214257573","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ST 57428","created_at":"2026-06-28T09:55:40.000000Z","updated_at":"2026-07-06T09:43:44.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":21298720,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_unit_id":"214257574","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"495\/SIL","insp_unit_license":"4ND6783","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF482S1F3890497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:14:25.000000Z","updated_at":"2026-07-06T09:01:22.000000Z"},{"id":21298719,"change_date":"2026-06-25 21:49:00","inspection_id":"88224173","insp_unit_id":"214257573","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"MAR","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:14:25.000000Z","updated_at":"2026-07-06T09:01:22.000000Z"}]},{"id":12242611,"change_date":"2026-06-21 21:33:00","inspection_id":"88200622","dot_number":"3457083","report_state":"CA","report_number":"NBGO010214","insp_date":"2026-06-19 00:00:00","insp_start_time":"0948","insp_end_time":"1015","registration_date":null,"region":"PS","ci_status_code":"C","location":"726","location_desc":"CA","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLEARVIEW TRANSPORT LLC","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-06-21 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"3589076","transaction_code":"A","transaction_date":"2026-06-21 00:00:00","upload_date":"2026-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2026-06-21 21:33:00","snet_input_date":"2026-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-21 21:33:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207-3018","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-24T09:39:53.000000Z","updated_at":"2026-07-02T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21260655,"change_date":"2026-06-21 21:33:00","inspection_id":"88200622","insp_unit_id":"214209016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"47\/RED","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-24T09:17:02.000000Z","updated_at":"2026-07-02T09:00:55.000000Z"},{"id":21260656,"change_date":"2026-06-21 21:33:00","inspection_id":"88200622","insp_unit_id":"214209017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":null,"insp_unit_license":"4ND6783","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF482S1F3890497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-24T09:17:02.000000Z","updated_at":"2026-07-02T09:00:55.000000Z"}]},{"id":11804728,"change_date":"2026-05-01 21:40:00","inspection_id":"87737978","dot_number":"3457083","report_state":"CA","report_number":"NA5N009412","insp_date":"2026-04-29 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3244006","transaction_code":"A","transaction_date":"2026-05-01 00:00:00","upload_date":"2026-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2026-05-01 21:40:00","snet_input_date":"2026-05-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-01 21:40:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207-3018","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-04T09:41:24.000000Z","updated_at":"2026-05-12T09:31:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20533093,"change_date":"2026-05-01 21:40:00","inspection_id":"87737978","insp_unit_id":"213337248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-04T09:20:07.000000Z","updated_at":"2026-05-12T09:03:12.000000Z"},{"id":20533094,"change_date":"2026-05-01 21:40:00","inspection_id":"87737978","insp_unit_id":"213337249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-04T09:20:07.000000Z","updated_at":"2026-05-12T09:03:12.000000Z"}]},{"id":11373568,"change_date":"2026-03-13 21:38:00","inspection_id":"87287303","dot_number":"3457083","report_state":"CA","report_number":"UEX8005311","insp_date":"2026-03-12 00:00:00","insp_start_time":"1021","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16207137","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2026-03-13 21:38:00","snet_input_date":"2026-03-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-13 21:38:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:21.000000Z","updated_at":"2026-03-24T09:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19474622,"change_date":"2026-03-13 21:38:00","inspection_id":"87287303","insp_unit_id":"212130401","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X MAR","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:03.000000Z","updated_at":"2026-03-24T09:05:25.000000Z"},{"id":19474623,"change_date":"2026-03-13 21:38:00","inspection_id":"87287303","insp_unit_id":"212130402","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":null,"insp_unit_license":"4NU4653","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C1F1571879","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:03.000000Z","updated_at":"2026-03-24T09:05:25.000000Z"}]},{"id":11243926,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","dot_number":"3457083","report_state":"CA","report_number":"NC7K010726","insp_date":"2026-02-25 00:00:00","insp_start_time":"0945","insp_end_time":"1055","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","viol_total":"10","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16185743","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2026-02-26 21:42:00","snet_input_date":"2026-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-26 21:42:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-01T10:39:10.000000Z","updated_at":"2026-03-09T09:32:32.000000Z","inspection_violations":[{"id":18884778,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077048","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"211868053","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"3965BL"},{"id":18884779,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077049","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211868053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"3939ALHLI"},{"id":18884780,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077050","seq_no":"3","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"1","insp_unit_id":"211868053","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA767550","created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39347D2BLTBD"},{"id":18884781,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077051","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"211868053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39345DB"},{"id":18884782,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077052","seq_no":"5","part_no":"393","part_no_section":"51C-BLPW","insp_viol_unit":"1","insp_unit_id":"211868053","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA767548","created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39351CBLPW"},{"id":18884783,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077053","seq_no":"6","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"211868054","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39345DB"},{"id":18884784,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077054","seq_no":"7","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"211868054","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39345B2BAIR"},{"id":18884785,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077055","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211868054","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":18884786,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077056","seq_no":"9","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"211868054","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA767549","created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"39375A3TAOL"},{"id":18884787,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_violation_id":"272077057","seq_no":"10","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"211868054","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA767550","created_at":"2026-03-01T10:57:19.000000Z","updated_at":"2026-03-09T09:47:19.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":19221419,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_unit_id":"211868053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"MRN 3X","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:51.000000Z","updated_at":"2026-03-09T09:10:40.000000Z"},{"id":19221420,"change_date":"2026-02-26 21:42:00","inspection_id":"87156756","insp_unit_id":"211868054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"120\/FB 2X","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:51.000000Z","updated_at":"2026-03-09T09:10:40.000000Z"}]},{"id":10536517,"change_date":"2025-12-29 21:39:00","inspection_id":"86672779","dot_number":"3457083","report_state":"CA","report_number":"UEAO005815","insp_date":"2025-12-24 00:00:00","insp_start_time":"0726","insp_end_time":"0741","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"16109254","transaction_code":"A","transaction_date":"2025-12-24 00:00:00","upload_date":"2025-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2025-12-29 21:39:00","snet_input_date":"2025-12-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-29 21:39:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-01T10:34:52.000000Z","updated_at":"2026-01-09T10:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17647857,"change_date":"2025-12-29 21:39:00","inspection_id":"86672779","insp_unit_id":"210843791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XRED","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:53.000000Z","updated_at":"2026-01-09T10:01:35.000000Z"},{"id":17647858,"change_date":"2025-12-29 21:39:00","inspection_id":"86672779","insp_unit_id":"210843792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"2XFB","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:53.000000Z","updated_at":"2026-01-09T10:01:35.000000Z"}]},{"id":10335958,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","dot_number":"3457083","report_state":"CA","report_number":"NC7K010517","insp_date":"2025-11-26 00:00:00","insp_start_time":"1020","insp_end_time":"1100","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":"2025-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16078135","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2025-12-02 21:39:00","snet_input_date":"2025-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-02 21:39:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:37.000000Z","updated_at":"2025-12-06T10:31:07.000000Z","inspection_violations":[{"id":17291693,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413365","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210370675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"3939ALIL"},{"id":17291694,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413366","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"210370675","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":17291695,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413367","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"210370676","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":17291696,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413368","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"210370676","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":17291697,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413369","seq_no":"5","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210370676","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA516749","created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"39375A3TAOL"},{"id":17291698,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413370","seq_no":"6","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"210370676","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"3939ALSLI"},{"id":17291699,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_violation_id":"270413371","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210370675","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:33.000000Z","updated_at":"2025-12-06T10:31:58.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17262710,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_unit_id":"210370675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"MRN 3X","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:03:00.000000Z","updated_at":"2025-12-06T10:01:10.000000Z"},{"id":17262711,"change_date":"2025-12-02 21:39:00","inspection_id":"86463229","insp_unit_id":"210370676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"120\/FB 2X","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:03:00.000000Z","updated_at":"2025-12-06T10:01:10.000000Z"}]},{"id":9964712,"change_date":"2025-10-16 21:40:00","inspection_id":"86072981","dot_number":"3457083","report_state":"CA","report_number":"NBGO009129","insp_date":"2025-10-15 00:00:00","insp_start_time":"0947","insp_end_time":"1008","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLEARVIEW TRANSPORT LLC","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-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"129410","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":"16021205","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-10-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-10-19T10:01:50.000000Z","updated_at":"2025-10-20T10:01:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16544338,"change_date":"2025-10-16 21:40:00","inspection_id":"86072981","insp_unit_id":"209515003","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"17\/WHT","insp_unit_license":"9G33182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M1AW02Y7DM033131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:02.000000Z","updated_at":"2025-10-20T09:46:47.000000Z"},{"id":16544339,"change_date":"2025-10-16 21:40:00","inspection_id":"86072981","insp_unit_id":"209515004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"4PX7912","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C0W1582422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:02.000000Z","updated_at":"2025-10-20T09:46:47.000000Z"}]},{"id":8299421,"change_date":"2025-04-04 21:41:00","inspection_id":"84318895","dot_number":"3457083","report_state":"CA","report_number":"NFDT000777","insp_date":"2025-04-03 00:00:00","insp_start_time":"1400","insp_end_time":"1432","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":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"15767056","transaction_code":"A","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-04-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:21.000000Z","updated_at":"2025-04-08T10:10:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13456652,"change_date":"2025-04-04 21:41:00","inspection_id":"84318895","insp_unit_id":"206164383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X RED","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"Y","insp_unit_decal_number":"35062489","created_at":"2025-04-07T10:14:04.000000Z","updated_at":"2025-04-08T10:03:18.000000Z"}]},{"id":7454573,"change_date":"2024-12-18 21:42:00","inspection_id":"83430991","dot_number":"3457083","report_state":"CA","report_number":"UECE006748","insp_date":"2024-12-18 00:00:00","insp_start_time":"1115","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"I-80 W\/B ANTELOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126220","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":"15635435","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2024-12-18 21:42:00","snet_input_date":"2024-12-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-18 21:42:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-03-17T20:51:34.000000Z","updated_at":"2025-03-17T20:51:34.000000Z","inspection_violations":[{"id":11650300,"change_date":"2024-12-18 21:42:00","inspection_id":"83430991","insp_violation_id":"263560219","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204466709","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3922SLLSR"},{"id":11650301,"change_date":"2024-12-18 21:42:00","inspection_id":"83430991","insp_violation_id":"263560220","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"204466709","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ECITE","created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3922SLL"},{"id":11650302,"change_date":"2024-12-18 21:42:00","inspection_id":"83430991","insp_violation_id":"263560221","seq_no":"3","part_no":"393","part_no_section":"11A1-LSLM","insp_viol_unit":"2","insp_unit_id":"204466710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39311A1LSLM"}],"inspection_per_units":[{"id":12026290,"change_date":"2024-12-18 21:42:00","inspection_id":"83430991","insp_unit_id":"204466709","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"},{"id":12026291,"change_date":"2024-12-18 21:42:00","inspection_id":"83430991","insp_unit_id":"204466710","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":null,"insp_unit_license":"4NH7989","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF482S7F3888592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"}]},{"id":7187064,"change_date":"2025-09-02 21:40:00","inspection_id":"83149135","dot_number":"3457083","report_state":"CA","report_number":"NF8B000866","insp_date":"2024-11-12 00:00:00","insp_start_time":"1735","insp_end_time":"1818","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLEARVIEW TRANSPORT LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"593000","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":"15592294","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-09-06T10:43:03.000000Z","inspection_violations":[{"id":15626199,"change_date":"2025-09-02 21:40:00","inspection_id":"83149135","insp_violation_id":"268412127","seq_no":"1","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RK89211","created_at":"2025-09-06T10:47:25.000000Z","updated_at":"2025-09-06T10:47:25.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":15793662,"change_date":"2025-09-02 21:40:00","inspection_id":"83149135","insp_unit_id":"208708824","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"RED","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:17.000000Z","updated_at":"2025-09-09T09:47:17.000000Z"},{"id":15793663,"change_date":"2025-09-02 21:40:00","inspection_id":"83149135","insp_unit_id":"208708825","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"FB\/505","insp_unit_license":"4ND6795","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF482S7F3890505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:17.000000Z","updated_at":"2025-09-09T09:47:17.000000Z"}]},{"id":6761610,"change_date":"2024-09-18 21:43:00","inspection_id":"82697109","dot_number":"3457083","report_state":"CA","report_number":"NCAT004701","insp_date":"2024-09-17 00:00:00","insp_start_time":"1909","insp_end_time":"1947","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"123220","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":"15526101","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2024-09-18 21:43:00","snet_input_date":"2024-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-18 21:43:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-03-17T20:37:17.000000Z","updated_at":"2025-03-17T20:37:17.000000Z","inspection_violations":[{"id":10529674,"change_date":"2024-09-18 21:43:00","inspection_id":"82697109","insp_violation_id":"261906162","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203014205","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA159500","created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10903419,"change_date":"2024-09-18 21:43:00","inspection_id":"82697109","insp_unit_id":"203014205","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"MORN\/3XL","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"},{"id":10903420,"change_date":"2024-09-18 21:43:00","inspection_id":"82697109","insp_unit_id":"203014206","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEHNK","insp_unit_company":"8206\/FLTBED","insp_unit_license":"J181255","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"4L5FB4329PF066542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"}]},{"id":6302404,"change_date":"2024-07-24 21:42:00","inspection_id":"82207389","dot_number":"3457083","report_state":"CA","report_number":"UDBL003468","insp_date":"2024-07-23 00:00:00","insp_start_time":"0834","insp_end_time":"0844","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-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"15455134","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-03-17T20:27:48.000000Z","updated_at":"2025-03-17T20:27:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10154924,"change_date":"2024-07-24 21:42:00","inspection_id":"82207389","insp_unit_id":"202055360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XMAR","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"},{"id":10154925,"change_date":"2024-07-24 21:42:00","inspection_id":"82207389","insp_unit_id":"202055361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"2XFB","insp_unit_license":"4TJ7138","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJF482F8YS692322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"}]},{"id":5022810,"change_date":"2025-09-02 21:40:00","inspection_id":"80818374","dot_number":"3457083","report_state":"CA","report_number":"NEYV000176","insp_date":"2024-02-06 00:00:00","insp_start_time":"0735","insp_end_time":"0813","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":"2024-02-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"15231345","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2024-02-09 21:42:00","snet_input_date":"2024-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-09 21:42:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:21.000000Z","updated_at":"2025-09-06T10:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15793650,"change_date":"2025-09-02 21:40:00","inspection_id":"80818374","insp_unit_id":"208708400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X \/RED","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"Y","insp_unit_decal_number":"33523624","created_at":"2025-09-09T09:47:17.000000Z","updated_at":"2025-09-09T09:47:17.000000Z"},{"id":15793651,"change_date":"2025-09-02 21:40:00","inspection_id":"80818374","insp_unit_id":"208708401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CWCF","insp_unit_company":"2X \/ FB","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"Y","insp_unit_decal_number":"33523625","created_at":"2025-09-09T09:47:17.000000Z","updated_at":"2025-09-09T09:47:17.000000Z"}]},{"id":4542973,"change_date":"2023-12-01 21:43:00","inspection_id":"80293226","dot_number":"3457083","report_state":"CA","report_number":"UD4T000986","insp_date":"2023-12-01 00:00:00","insp_start_time":"0635","insp_end_time":"0657","registration_date":null,"region":"PT","ci_status_code":"C","location":"9211","location_desc":"SAN JOQAUIN COUNTY","county_code_state":"CA","county_code":"077","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-12-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15152245","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2023-12-01 21:43:00","snet_input_date":"2023-12-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-01 21:43:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-03-17T19:52:57.000000Z","updated_at":"2025-03-17T19:52:57.000000Z","inspection_violations":[{"id":7028873,"change_date":"2023-12-01 21:43:00","inspection_id":"80293226","insp_violation_id":"256678759","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198317108","insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"3922"},{"id":7028874,"change_date":"2023-12-01 21:43:00","inspection_id":"80293226","insp_violation_id":"256678760","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198317108","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"3922"},{"id":7028875,"change_date":"2023-12-01 21:43:00","inspection_id":"80293226","insp_violation_id":"256678761","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"198317108","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":7306503,"change_date":"2023-12-01 21:43:00","inspection_id":"80293226","insp_unit_id":"198317108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:23.000000Z","updated_at":"2025-03-17T23:01:23.000000Z"},{"id":7306504,"change_date":"2023-12-01 21:43:00","inspection_id":"80293226","insp_unit_id":"198317109","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CWCF","insp_unit_company":null,"insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:23.000000Z","updated_at":"2025-03-17T23:01:23.000000Z"}]},{"id":3760010,"change_date":"2023-08-16 21:39:00","inspection_id":"79425095","dot_number":"3457083","report_state":"CA","report_number":"NC7K007634","insp_date":"2023-08-15 00:00:00","insp_start_time":"1045","insp_end_time":"1115","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"15024305","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2023-08-16 21:39:00","snet_input_date":"2023-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:14.000000Z","updated_at":"2025-03-17T19:37:14.000000Z","inspection_violations":[{"id":5798388,"change_date":"2023-08-16 21:39:00","inspection_id":"79425095","insp_violation_id":"254695699","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196569352","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39347E"},{"id":5798389,"change_date":"2023-08-16 21:39:00","inspection_id":"79425095","insp_violation_id":"254695700","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196569352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6045970,"change_date":"2023-08-16 21:39:00","inspection_id":"79425095","insp_unit_id":"196569351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"MRN 3X","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"Y","insp_unit_decal_number":"32851798","created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"},{"id":6045971,"change_date":"2023-08-16 21:39:00","inspection_id":"79425095","insp_unit_id":"196569352","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"570\/FB 2X","insp_unit_license":"4TL2749","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C7Y5989665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3667015,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","dot_number":"3457083","report_state":"CA","report_number":"NC7K007572","insp_date":"2023-08-02 00:00:00","insp_start_time":"0938","insp_end_time":"1015","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"15007700","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2023-08-03 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-03 21:41:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:16.000000Z","updated_at":"2025-03-17T19:35:16.000000Z","inspection_violations":[{"id":5653998,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","insp_violation_id":"254460139","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196356883","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3963A1"},{"id":5653999,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","insp_violation_id":"254460140","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196356883","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3963A1"},{"id":5654000,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","insp_violation_id":"254460141","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196356884","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3963A1"},{"id":5654001,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","insp_violation_id":"254460142","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196356883","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5895945,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","insp_unit_id":"196356883","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"MRN 3X","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:34.000000Z","updated_at":"2025-03-17T22:49:34.000000Z"},{"id":5895946,"change_date":"2023-08-03 21:41:00","inspection_id":"79321651","insp_unit_id":"196356884","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"6448\/FB 2X","insp_unit_license":"016D005","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF482F0XS625325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:34.000000Z","updated_at":"2025-03-17T22:49:34.000000Z"}]},{"id":2230589,"change_date":"2023-01-25 21:43:00","inspection_id":"77695942","dot_number":"3457083","report_state":"CA","report_number":"NDN6006695","insp_date":"2023-01-23 00:00:00","insp_start_time":"1140","insp_end_time":"1219","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"134320","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":"14756048","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2023-01-25 21:43:00","snet_input_date":"2023-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:45.000000Z","updated_at":"2025-03-17T19:07:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3590446,"change_date":"2023-01-25 21:43:00","inspection_id":"77695942","insp_unit_id":"193073792","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3X RED","insp_unit_license":"9F47458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJALDR79PAD1876","insp_unit_decal":"Y","insp_unit_decal_number":"32141897","created_at":"2025-03-17T22:31:45.000000Z","updated_at":"2025-03-17T22:31:45.000000Z"},{"id":3590447,"change_date":"2023-01-25 21:43:00","inspection_id":"77695942","insp_unit_id":"193073793","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CWCF","insp_unit_company":"2X FB","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"Y","insp_unit_decal_number":"32141898","created_at":"2025-03-17T22:31:45.000000Z","updated_at":"2025-03-17T22:31:45.000000Z"}]},{"id":2022671,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","dot_number":"3457083","report_state":"CA","report_number":"UF44003347","insp_date":"2022-12-23 00:00:00","insp_start_time":"1140","insp_end_time":"1256","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB JNO MG SCALES","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-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134320","viol_total":"12","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14721942","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":"03457083","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":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"4719 QUAIL LAKES SUITE G #1168","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"568352","created_at":"2025-03-17T19:03:58.000000Z","updated_at":"2025-03-17T19:03:58.000000Z","inspection_violations":[{"id":3137115,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281577","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":"LP36281","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"},{"id":3137116,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281578","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"15","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":"39347E"},{"id":3137117,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281579","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"16","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":"39353B"},{"id":3137118,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281580","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"15","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":"39347E"},{"id":3137119,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281581","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"15","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":"39347E"},{"id":3137120,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281582","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP36281","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3963A1"},{"id":3137121,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281583","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36281","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"},{"id":3137122,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281584","seq_no":"8","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192596947","insp_violation_category_id":"23","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":"39375C"},{"id":3137123,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281585","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192596947","insp_violation_category_id":"14","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":"3922"},{"id":3137124,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281586","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018701","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39378"},{"id":3137125,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281587","seq_no":"11","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018701","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39021TB"},{"id":3137126,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_violation_id":"250281588","seq_no":"12","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"192596946","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018701","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":3254318,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_unit_id":"192596946","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"3X BURG","insp_unit_license":"9F47458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5KJJALDR79PAD1876","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":3254319,"change_date":"2022-12-27 21:40:00","inspection_id":"77457763","insp_unit_id":"192596947","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CWCF","insp_unit_company":"2X ALUM FB","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","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":1081596,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","dot_number":"3457083","report_state":"CA","report_number":"NDN6005960","insp_date":"2022-08-15 00:00:00","insp_start_time":"0930","insp_end_time":"1004","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-08-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14555645","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03457083","upload_search_indicator":null,"census_search_date":"2022-08-18 21:40:00","snet_input_date":"2022-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-18 21:40:00","insp_carrier_name":"CLEARVIEW TRANSPORT LLC","insp_carrier_street":"426 MARC AVE","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:51.000000Z","updated_at":"2025-03-17T18:46:51.000000Z","inspection_violations":[{"id":1705754,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841909","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190415570","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA389798","created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3939A"},{"id":1705755,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841910","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"190415570","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"393207A"},{"id":1705756,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841911","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"190415570","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"393207A"},{"id":1705757,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841912","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190415570","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39375C"},{"id":1705758,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841913","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190415570","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3963A1"},{"id":1705759,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841914","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190415571","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39347E"},{"id":1705760,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841915","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190415571","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39353B"},{"id":1705761,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_violation_id":"247841916","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190415571","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1739734,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_unit_id":"190415570","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X RED","insp_unit_license":"9G04821","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGNBG2DDFH5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:58.000000Z","updated_at":"2025-03-17T22:18:58.000000Z"},{"id":1739735,"change_date":"2022-08-18 21:40:00","inspection_id":"76372943","insp_unit_id":"190415571","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CWCF","insp_unit_company":"2X FB","insp_unit_license":"4TK4408","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4FGL48208PA471227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:58.000000Z","updated_at":"2025-03-17T22:18:58.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3457083\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3457083\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3457083\/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\/3457083\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}