{"current_page":1,"data":[{"id":7742063,"change_date":"2025-01-29 21:41:00","inspection_id":"83732771","dot_number":"2621499","report_state":"CA","report_number":"UE68000431","insp_date":"2025-01-29 00:00:00","insp_start_time":"0755","insp_end_time":"0818","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SR-78 E\/OF SR-111","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","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":"15683749","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12493782,"change_date":"2025-01-29 21:41:00","inspection_id":"83732771","insp_unit_id":"205070915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT, 2449","insp_unit_license":"1470033","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5HY5FEC26727","insp_unit_decal":"Y","insp_unit_decal_number":"34817669","created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":3772228,"change_date":"2023-08-17 21:44:00","inspection_id":"79438824","dot_number":"2621499","report_state":"CA","report_number":"NBAB002264","insp_date":"2023-08-17 00:00:00","insp_start_time":"0615","insp_end_time":"0645","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CVWD","shipping_paper_number":"CVWD","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15026108","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065095,"change_date":"2023-08-17 21:44:00","inspection_id":"79438824","insp_unit_id":"196598094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"504","insp_unit_license":"1206318","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2FZHAZCV15AU19968","insp_unit_decal":"Y","insp_unit_decal_number":"32912655","created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772229,"change_date":"2023-08-17 21:44:00","inspection_id":"79438825","dot_number":"2621499","report_state":"CA","report_number":"NBAB002265","insp_date":"2023-08-17 00:00:00","insp_start_time":"0645","insp_end_time":"0715","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CVWD","shipping_paper_number":"CVWD","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15025222","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065096,"change_date":"2023-08-17 21:44:00","inspection_id":"79438825","insp_unit_id":"196598095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"517","insp_unit_license":"1092302","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTSEAANX1H344404","insp_unit_decal":"Y","insp_unit_decal_number":"32912656","created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772230,"change_date":"2023-08-17 21:44:00","inspection_id":"79438826","dot_number":"2621499","report_state":"CA","report_number":"NBAB002266","insp_date":"2023-08-17 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44: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":"15026116","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065097,"change_date":"2023-08-17 21:44:00","inspection_id":"79438826","insp_unit_id":"196598096","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"590","insp_unit_license":"1642666","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X4RJ334072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772231,"change_date":"2023-08-17 21:44:00","inspection_id":"79438827","dot_number":"2621499","report_state":"CA","report_number":"NBAB002267","insp_date":"2023-08-17 00:00:00","insp_start_time":"0745","insp_end_time":"0815","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44: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":"15026053","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065098,"change_date":"2023-08-17 21:44:00","inspection_id":"79438827","insp_unit_id":"196598097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"584","insp_unit_license":"1642285","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40XORJ334070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772265,"change_date":"2023-08-17 21:44:00","inspection_id":"79438863","dot_number":"2621499","report_state":"CA","report_number":"NBAB002268","insp_date":"2023-08-17 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44: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":"15025346","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065145,"change_date":"2023-08-17 21:44:00","inspection_id":"79438863","insp_unit_id":"196598150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"560","insp_unit_license":"1576539","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X5LM374011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772266,"change_date":"2023-08-17 21:44:00","inspection_id":"79438864","dot_number":"2621499","report_state":"CA","report_number":"NBAB002269","insp_date":"2023-08-17 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44: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":"15024907","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065146,"change_date":"2023-08-17 21:44:00","inspection_id":"79438864","insp_unit_id":"196598151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"559","insp_unit_license":"1216109","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTXKAHT26J322397","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772152,"change_date":"2023-08-17 21:44:00","inspection_id":"79438746","dot_number":"2621499","report_state":"CA","report_number":"NBAB002257","insp_date":"2023-08-16 00:00:00","insp_start_time":"0615","insp_end_time":"0645","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"146000","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":"15025471","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6064978,"change_date":"2023-08-17 21:44:00","inspection_id":"79438746","insp_unit_id":"196597972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"592","insp_unit_license":"1422682","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40X3RJ333949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"},{"id":6064979,"change_date":"2023-08-17 21:44:00","inspection_id":"79438746","insp_unit_id":"196597973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COZA","insp_unit_company":"621","insp_unit_license":"1353350","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C9XL502651772096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"}]},{"id":3772153,"change_date":"2023-08-17 21:44:00","inspection_id":"79438747","dot_number":"2621499","report_state":"CA","report_number":"NBAB002258","insp_date":"2023-08-16 00:00:00","insp_start_time":"0645","insp_end_time":"0715","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"146000","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":"15024979","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6064980,"change_date":"2023-08-17 21:44:00","inspection_id":"79438747","insp_unit_id":"196597974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"589","insp_unit_license":"1422699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD40XXRJ333950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"},{"id":6064981,"change_date":"2023-08-17 21:44:00","inspection_id":"79438747","insp_unit_id":"196597975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COZA","insp_unit_company":"603","insp_unit_license":"E318472","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"CC82079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"}]},{"id":3772154,"change_date":"2023-08-17 21:44:00","inspection_id":"79438748","dot_number":"2621499","report_state":"CA","report_number":"NBAB002259","insp_date":"2023-08-16 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"15024798","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6064982,"change_date":"2023-08-17 21:44:00","inspection_id":"79438748","insp_unit_id":"196597976","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"579","insp_unit_license":"1576228","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHJ7XILM245772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"},{"id":6064983,"change_date":"2023-08-17 21:44:00","inspection_id":"79438748","insp_unit_id":"196597977","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":"607","insp_unit_license":"1210680","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"112H8V3255L070365","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"}]},{"id":3772190,"change_date":"2023-08-17 21:44:00","inspection_id":"79438785","dot_number":"2621499","report_state":"CA","report_number":"NBAB002260","insp_date":"2023-08-16 00:00:00","insp_start_time":"0745","insp_end_time":"0815","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"15024953","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065036,"change_date":"2023-08-17 21:44:00","inspection_id":"79438785","insp_unit_id":"196598032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"555","insp_unit_license":"1576249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTDSTZT8MN304736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"},{"id":6065037,"change_date":"2023-08-17 21:44:00","inspection_id":"79438785","insp_unit_id":"196598033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"604","insp_unit_license":"1092585","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DA13RPZX1P015489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772191,"change_date":"2023-08-17 21:44:00","inspection_id":"79438786","dot_number":"2621499","report_state":"CA","report_number":"NBAB002261","insp_date":"2023-08-16 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CVWD","shipping_paper_number":"CVWD","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"29614","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":"15026230","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065038,"change_date":"2023-08-17 21:44:00","inspection_id":"79438786","insp_unit_id":"196598034","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"418","insp_unit_license":"1227225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDAF57XY6EA89880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"},{"id":6065039,"change_date":"2023-08-17 21:44:00","inspection_id":"79438786","insp_unit_id":"196598035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FILL","insp_unit_company":"672","insp_unit_license":"E111563","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"C45566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772192,"change_date":"2023-08-17 21:44:00","inspection_id":"79438787","dot_number":"2621499","report_state":"CA","report_number":"NBAB002262","insp_date":"2023-08-16 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"15024836","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065040,"change_date":"2023-08-17 21:44:00","inspection_id":"79438787","insp_unit_id":"196598036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"591","insp_unit_license":"1642678","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X4RJ334069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"},{"id":6065041,"change_date":"2023-08-17 21:44:00","inspection_id":"79438787","insp_unit_id":"196598037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":"605","insp_unit_license":"1210683","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"112HV32X5L070359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3772193,"change_date":"2023-08-17 21:44:00","inspection_id":"79438788","dot_number":"2621499","report_state":"CA","report_number":"NBAB002263","insp_date":"2023-08-16 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"COACHELLA","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"15025503","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02621499","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6065042,"change_date":"2023-08-17 21:44:00","inspection_id":"79438788","insp_unit_id":"196598038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STEM","insp_unit_company":"570","insp_unit_license":"1214020","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2FZACFDC46AW04878","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"},{"id":6065043,"change_date":"2023-08-17 21:44:00","inspection_id":"79438788","insp_unit_id":"196598039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTER","insp_unit_company":"608","insp_unit_license":"1216474","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JKDLA4016M007486","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3758986,"change_date":"2023-08-16 21:39:00","inspection_id":"79424014","dot_number":"2621499","report_state":"CA","report_number":"NBAB002249","insp_date":"2023-08-15 00:00:00","insp_start_time":"0615","insp_end_time":"0645","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15023798","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6044482,"change_date":"2023-08-16 21:39:00","inspection_id":"79424014","insp_unit_id":"196567690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"526","insp_unit_license":"1576248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTDSTZT6MN304735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6044483,"change_date":"2023-08-16 21:39:00","inspection_id":"79424014","insp_unit_id":"196567691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTRS","insp_unit_company":"633","insp_unit_license":"1265624","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JKDLA4032M002915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3758987,"change_date":"2023-08-16 21:39:00","inspection_id":"79424015","dot_number":"2621499","report_state":"CA","report_number":"NBAB002250","insp_date":"2023-08-15 00:00:00","insp_start_time":"0645","insp_end_time":"0715","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15024002","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[{"id":5797392,"change_date":"2023-08-16 21:39:00","inspection_id":"79424015","insp_violation_id":"254694560","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196567692","insp_violation_category_id":"14","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":"3922"}],"inspection_per_units":[{"id":6044484,"change_date":"2023-08-16 21:39:00","inspection_id":"79424015","insp_unit_id":"196567692","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"551","insp_unit_license":"1533084","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF6AY7JDF04157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3759025,"change_date":"2023-08-16 21:39:00","inspection_id":"79424056","dot_number":"2621499","report_state":"CA","report_number":"NBAB002255","insp_date":"2023-08-15 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"81500","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":"15023205","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6044539,"change_date":"2023-08-16 21:39:00","inspection_id":"79424056","insp_unit_id":"196567751","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"525","insp_unit_license":"1187019","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2FZBCHDC35AU19977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6044540,"change_date":"2023-08-16 21:39:00","inspection_id":"79424056","insp_unit_id":"196567752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTRS","insp_unit_company":"625","insp_unit_license":"E954858","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JKGLA4045M006652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3759026,"change_date":"2023-08-16 21:39:00","inspection_id":"79424057","dot_number":"2621499","report_state":"CA","report_number":"NBAB002256","insp_date":"2023-08-15 00:00:00","insp_start_time":"0945","insp_end_time":"1015","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44920","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":"15023784","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6044541,"change_date":"2023-08-16 21:39:00","inspection_id":"79424057","insp_unit_id":"196567753","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"FELL","insp_unit_company":"641","insp_unit_license":"1442883","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FTFA3523G1002774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3759252,"change_date":"2023-08-16 21:39:00","inspection_id":"79424294","dot_number":"2621499","report_state":"CA","report_number":"NBAB002251","insp_date":"2023-08-15 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102920","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":"15023841","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[{"id":5797544,"change_date":"2023-08-16 21:39:00","inspection_id":"79424294","insp_violation_id":"254694730","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"196568084","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"393207A"},{"id":5797545,"change_date":"2023-08-16 21:39:00","inspection_id":"79424294","insp_violation_id":"254694731","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196568085","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":"3963A1"}],"inspection_per_units":[{"id":6044836,"change_date":"2023-08-16 21:39:00","inspection_id":"79424294","insp_unit_id":"196568084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"564","insp_unit_license":"1576247","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTDSTZT4MN304734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6044837,"change_date":"2023-08-16 21:39:00","inspection_id":"79424294","insp_unit_id":"196568085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"643","insp_unit_license":"1370647","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FTCF3620H1004129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3759253,"change_date":"2023-08-16 21:39:00","inspection_id":"79424295","dot_number":"2621499","report_state":"CA","report_number":"NBAB002252","insp_date":"2023-08-15 00:00:00","insp_start_time":"0745","insp_end_time":"0815","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"47800","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":"15023306","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[{"id":5797546,"change_date":"2023-08-16 21:39:00","inspection_id":"79424295","insp_violation_id":"254694732","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"196568087","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":6044838,"change_date":"2023-08-16 21:39:00","inspection_id":"79424295","insp_unit_id":"196568086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2513","insp_unit_license":"1616012","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5HNOMEC10275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6044839,"change_date":"2023-08-16 21:39:00","inspection_id":"79424295","insp_unit_id":"196568087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"640","insp_unit_license":"MISSING","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FTEF2626G1002213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3759254,"change_date":"2023-08-16 21:39:00","inspection_id":"79424296","dot_number":"2621499","report_state":"CA","report_number":"NBAB002253","insp_date":"2023-08-15 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"104920","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":"15022794","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6044840,"change_date":"2023-08-16 21:39:00","inspection_id":"79424296","insp_unit_id":"196568088","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"588","insp_unit_license":"1607576","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL40X6LJ416425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6044841,"change_date":"2023-08-16 21:39:00","inspection_id":"79424296","insp_unit_id":"196568089","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"623","insp_unit_license":"1420383","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FTFA3524F1001101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3759255,"change_date":"2023-08-16 21:39:00","inspection_id":"79424297","dot_number":"2621499","report_state":"CA","report_number":"NBAB002254","insp_date":"2023-08-15 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"PS","ci_status_code":"C","location":"630","location_desc":"PALM DESERT","county_code_state":"CA","county_code":"065","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48800","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":"15023562","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":"02621499","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":"COACHELLA VALLEY WATER DISTRICT","insp_carrier_street":"51-501 TYLER STREET","insp_carrier_city":"COACHELLA","insp_carrier_state":"CA","insp_carrier_zip_code":"92236","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"7202","created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6044842,"change_date":"2023-08-16 21:39:00","inspection_id":"79424297","insp_unit_id":"196568090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"556","insp_unit_license":"1570386","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEETAR4ML877102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"},{"id":6044843,"change_date":"2023-08-16 21:39:00","inspection_id":"79424297","insp_unit_id":"196568091","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTRS","insp_unit_company":"631","insp_unit_license":"1104826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JKDLA4091M002397","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2621499\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2621499\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2621499\/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\/2621499\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}