{"current_page":1,"data":[{"id":12473747,"change_date":"2026-07-17 21:41:00","inspection_id":"88434862","dot_number":"2808327","report_state":"CA","report_number":"NEVK002685","insp_date":"2026-07-16 00:00:00","insp_start_time":"1645","insp_end_time":"1702","registration_date":null,"region":"PD","ci_status_code":"C","location":"347","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3777479","transaction_code":"A","transaction_date":"2026-07-17 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-07-17 21:41:00","snet_input_date":"2026-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2026-07-20T09:42:29.000000Z","updated_at":"2026-07-28T09:30:20.000000Z","inspection_violations":[{"id":21718048,"change_date":"2026-07-17 21:41:00","inspection_id":"88434862","insp_violation_id":"275563140","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"214661515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:01.000000Z","updated_at":"2026-07-28T09:41:54.000000Z","normalized_code":"3939ALCL"},{"id":21718049,"change_date":"2026-07-17 21:41:00","inspection_id":"88434862","insp_violation_id":"275563141","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"214661515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA675791","created_at":"2026-07-20T10:08:01.000000Z","updated_at":"2026-07-28T09:41:54.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":21665229,"change_date":"2026-07-17 21:41:00","inspection_id":"88434862","insp_unit_id":"214661515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BT2\/WHITE","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:20:39.000000Z","updated_at":"2026-07-28T09:01:26.000000Z"}]},{"id":11970421,"change_date":"2026-05-20 21:40:00","inspection_id":"87907155","dot_number":"2808327","report_state":"CA","report_number":"NEC6001955","insp_date":"2026-05-19 00:00:00","insp_start_time":"1218","insp_end_time":"1233","registration_date":null,"region":"PS","ci_status_code":"C","location":"726","location_desc":"CA","county_code_state":"CA","county_code":"085","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":"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-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3364220","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-05-20 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2026-05-23T09:42:50.000000Z","updated_at":"2026-06-01T09:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20812383,"change_date":"2026-05-20 21:40:00","inspection_id":"87907155","insp_unit_id":"213659792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BT3\/WHT","insp_unit_license":"29951Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B0JS801999","insp_unit_decal":"Y","insp_unit_decal_number":"36239417","created_at":"2026-05-23T09:20:15.000000Z","updated_at":"2026-06-01T09:02:20.000000Z"}]},{"id":11880932,"change_date":"2026-05-12 21:38:00","inspection_id":"87818488","dot_number":"2808327","report_state":"CA","report_number":"NDUP008319","insp_date":"2026-05-06 00:00:00","insp_start_time":"0933","insp_end_time":"0956","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":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-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3303230","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-05-12 21:38:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:38:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2026-05-14T12:39:22.000000Z","updated_at":"2026-05-23T09:30:16.000000Z","inspection_violations":[{"id":20663842,"change_date":"2026-05-12 21:38:00","inspection_id":"87818488","insp_violation_id":"274185512","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213494307","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:25.000000Z","updated_at":"2026-05-23T09:43:10.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":20657765,"change_date":"2026-05-12 21:38:00","inspection_id":"87818488","insp_unit_id":"213494307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"29951Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B0JS801999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:17.000000Z","updated_at":"2026-05-23T09:02:44.000000Z"}]},{"id":11784039,"change_date":"2026-04-29 21:40:00","inspection_id":"87715487","dot_number":"2808327","report_state":"CA","report_number":"UEGX002689","insp_date":"2026-04-29 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16268610","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-04-29 21:40:00","snet_input_date":"2026-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-29 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2026-05-02T09:41:08.000000Z","updated_at":"2026-05-10T09:31:21.000000Z","inspection_violations":[{"id":20492609,"change_date":"2026-04-29 21:40:00","inspection_id":"87715487","insp_violation_id":"273942913","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213296455","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN25767","created_at":"2026-05-02T10:03:04.000000Z","updated_at":"2026-05-10T09:42:23.000000Z","normalized_code":"3922SLLSR"},{"id":20492610,"change_date":"2026-04-29 21:40:00","inspection_id":"87715487","insp_violation_id":"273942914","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213296455","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-02T10:03:04.000000Z","updated_at":"2026-05-10T09:42:23.000000Z","normalized_code":"3922SLLSR"},{"id":20492611,"change_date":"2026-04-29 21:40:00","inspection_id":"87715487","insp_violation_id":"273942915","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"213296455","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-02T10:03:04.000000Z","updated_at":"2026-05-10T09:42:23.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":20499870,"change_date":"2026-04-29 21:40:00","inspection_id":"87715487","insp_unit_id":"213296455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:25.000000Z","updated_at":"2026-05-10T09:04:09.000000Z"}]},{"id":11557722,"change_date":"2026-04-02 21:39:00","inspection_id":"87480931","dot_number":"2808327","report_state":"CA","report_number":"NA5N009294","insp_date":"2026-04-01 00:00:00","insp_start_time":"1134","insp_end_time":"1204","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"16232480","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-05T09:57:04.000000Z","updated_at":"2026-04-13T09:31:43.000000Z","inspection_violations":[{"id":19534321,"change_date":"2026-04-02 21:39:00","inspection_id":"87480931","insp_violation_id":"272843839","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212519898","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN87986","created_at":"2026-04-05T10:27:00.000000Z","updated_at":"2026-04-12T10:18:48.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19806710,"change_date":"2026-04-02 21:39:00","inspection_id":"87480931","insp_unit_id":"212519898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X WHT","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"Y","insp_unit_decal_number":"36187935","created_at":"2026-04-05T09:52:24.000000Z","updated_at":"2026-04-13T09:05:06.000000Z"}]},{"id":11359359,"change_date":"2026-03-12 21:40:00","inspection_id":"87277906","dot_number":"2808327","report_state":"CA","report_number":"UEAO006049","insp_date":"2026-03-11 00:00:00","insp_start_time":"1501","insp_end_time":"1533","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":"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-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"16205248","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-03-12 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-15T09:40:03.000000Z","updated_at":"2026-03-23T09:32:55.000000Z","inspection_violations":[{"id":19140228,"change_date":"2026-03-12 21:40:00","inspection_id":"87277906","insp_violation_id":"272377667","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212113552","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA516443","created_at":"2026-03-15T10:03:50.000000Z","updated_at":"2026-03-23T09:52:21.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19440736,"change_date":"2026-03-12 21:40:00","inspection_id":"87277906","insp_unit_id":"212113552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2XWHT","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:45.000000Z","updated_at":"2026-03-23T09:12:00.000000Z"}]},{"id":11314663,"change_date":"2026-03-06 21:43:00","inspection_id":"87230956","dot_number":"2808327","report_state":"CA","report_number":"UF44007199","insp_date":"2026-03-06 00:00:00","insp_start_time":"0957","insp_end_time":"1013","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-580 WB JWO FIRST","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16198902","transaction_code":"A","transaction_date":"2026-03-06 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-03-06 21:43:00","snet_input_date":"2026-03-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-06 21:43:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2026-03-09T09:42:53.000000Z","updated_at":"2026-03-17T09:31:40.000000Z","inspection_violations":[{"id":19042660,"change_date":"2026-03-06 21:43:00","inspection_id":"87230956","insp_violation_id":"272267992","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA30419","created_at":"2026-03-09T10:09:10.000000Z","updated_at":"2026-03-17T09:41:56.000000Z","normalized_code":"3922SLLLR"},{"id":19042661,"change_date":"2026-03-06 21:43:00","inspection_id":"87230956","insp_violation_id":"272267993","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212025417","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:09:10.000000Z","updated_at":"2026-03-17T09:41:56.000000Z","normalized_code":"3922SLLSR"},{"id":19042662,"change_date":"2026-03-06 21:43:00","inspection_id":"87230956","insp_violation_id":"272267994","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212025417","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA30420","created_at":"2026-03-09T10:09:10.000000Z","updated_at":"2026-03-17T09:41:56.000000Z","normalized_code":"3922SLLEQP"},{"id":19042663,"change_date":"2026-03-06 21:43:00","inspection_id":"87230956","insp_violation_id":"272267995","seq_no":"4","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"212025417","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:09:10.000000Z","updated_at":"2026-03-17T09:41:56.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":19358948,"change_date":"2026-03-06 21:43:00","inspection_id":"87230956","insp_unit_id":"212025417","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"81486K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W168F7002973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:32.000000Z","updated_at":"2026-03-17T09:04:21.000000Z"}]},{"id":11230102,"change_date":"2026-02-25 21:49:00","inspection_id":"87142254","dot_number":"2808327","report_state":"CA","report_number":"NDMK006931","insp_date":"2026-02-23 00:00:00","insp_start_time":"1113","insp_end_time":"1135","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16184142","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2026-02-25 21:49:00","snet_input_date":"2026-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2026-02-28T10:39:31.000000Z","updated_at":"2026-03-08T09:32:29.000000Z","inspection_violations":[{"id":18853328,"change_date":"2026-02-25 21:49:00","inspection_id":"87142254","insp_violation_id":"272039713","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211839586","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ35263","created_at":"2026-02-28T10:57:10.000000Z","updated_at":"2026-03-08T09:50:21.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19196327,"change_date":"2026-02-25 21:49:00","inspection_id":"87142254","insp_unit_id":"211839586","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:24.000000Z","updated_at":"2026-03-08T09:07:30.000000Z"}]},{"id":10345186,"change_date":"2025-12-04 21:38:00","inspection_id":"86472840","dot_number":"2808327","report_state":"CA","report_number":"NE7S005476","insp_date":"2025-12-02 00:00:00","insp_start_time":"1500","insp_end_time":"1515","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16080348","transaction_code":"C","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2025-12-03 21:39:00","snet_input_date":"2025-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-03 21:39:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2025-12-06T10:31:38.000000Z","updated_at":"2025-12-08T10:30:49.000000Z","inspection_violations":[{"id":17324416,"change_date":"2025-12-04 21:38:00","inspection_id":"86472840","insp_violation_id":"270469960","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210420983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:13.000000Z","updated_at":"2025-12-08T10:31:25.000000Z","normalized_code":"3922SLLSR"},{"id":17324417,"change_date":"2025-12-04 21:38:00","inspection_id":"86472840","insp_violation_id":"270469961","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210420983","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:13.000000Z","updated_at":"2025-12-08T10:31:25.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":17294042,"change_date":"2025-12-04 21:38:00","inspection_id":"86472840","insp_unit_id":"210420983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE\/2AX","insp_unit_license":"81486K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W168F7002973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:29.000000Z","updated_at":"2025-12-08T10:00:58.000000Z"}]},{"id":8706257,"change_date":"2025-05-21 21:42:00","inspection_id":"84747372","dot_number":"2808327","report_state":"CA","report_number":"NEC6000802","insp_date":"2025-05-15 00:00:00","insp_start_time":"1138","insp_end_time":"1153","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":"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-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15829217","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"656171","created_at":"2025-05-24T10:04:39.000000Z","updated_at":"2025-05-25T10:07:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14227180,"change_date":"2025-05-21 21:42:00","inspection_id":"84747372","insp_unit_id":"207000365","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"217644\/WHT","insp_unit_license":"29951Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B0JS801999","insp_unit_decal":"Y","insp_unit_decal_number":"35094564","created_at":"2025-05-24T09:50:02.000000Z","updated_at":"2025-05-25T09:53:30.000000Z"}]},{"id":7949046,"change_date":"2025-02-24 21:40:00","inspection_id":"83950260","dot_number":"2808327","report_state":"CA","report_number":"UE03003845","insp_date":"2025-02-21 00:00:00","insp_start_time":"0932","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15712897","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES LLC","insp_carrier_street":"22390 THUNDERBIRD PL","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T21:03:16.000000Z","updated_at":"2025-03-17T21:03:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12832031,"change_date":"2025-02-24 21:40:00","inspection_id":"83950260","insp_unit_id":"205476524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2AX","insp_unit_license":"81486K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W168F7002973","insp_unit_decal":"Y","insp_unit_decal_number":"34766030","created_at":"2025-03-17T23:56:45.000000Z","updated_at":"2025-03-17T23:56:45.000000Z"}]},{"id":7223727,"change_date":"2024-11-18 21:41:00","inspection_id":"83187938","dot_number":"2808327","report_state":"CA","report_number":"NARW002890","insp_date":"2024-11-14 00:00:00","insp_start_time":"1003","insp_end_time":"1015","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15597096","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11651992,"change_date":"2024-11-18 21:41:00","inspection_id":"83187938","insp_unit_id":"203941356","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/2X","insp_unit_license":"29951Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B0JS801999","insp_unit_decal":"Y","insp_unit_decal_number":"34467709","created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":7006907,"change_date":"2024-10-21 21:42:00","inspection_id":"82958131","dot_number":"2808327","report_state":"CA","report_number":"NE1M005930","insp_date":"2024-10-17 00:00:00","insp_start_time":"1154","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15561594","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-10-21 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-21 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T20:42:15.000000Z","updated_at":"2025-03-17T20:42:15.000000Z","inspection_violations":[{"id":10932910,"change_date":"2024-10-21 21:42:00","inspection_id":"82958131","insp_violation_id":"262467191","seq_no":"1","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"1","insp_unit_id":"203509360","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"393205CWR"},{"id":10932911,"change_date":"2024-10-21 21:42:00","inspection_id":"82958131","insp_violation_id":"262467192","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203509360","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11301703,"change_date":"2024-10-21 21:42:00","inspection_id":"82958131","insp_unit_id":"203509360","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:01.000000Z","updated_at":"2025-03-17T23:40:01.000000Z"}]},{"id":6916371,"change_date":"2024-10-08 21:42:00","inspection_id":"82861858","dot_number":"2808327","report_state":"CA","report_number":"UEHG004207","insp_date":"2024-10-08 00:00:00","insp_start_time":"0801","insp_end_time":"0818","registration_date":null,"region":"PT","ci_status_code":"C","location":"9601","location_desc":"8000 BLK COMMERCIAL ST.","county_code_state":"CA","county_code":"073","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15549435","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:16.000000Z","updated_at":"2025-03-17T20:40:16.000000Z","inspection_violations":[{"id":10779298,"change_date":"2024-10-08 21:42:00","inspection_id":"82861858","insp_violation_id":"262254192","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203325130","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:10.000000Z","updated_at":"2025-03-17T21:58:10.000000Z","normalized_code":"3922"},{"id":10779299,"change_date":"2024-10-08 21:42:00","inspection_id":"82861858","insp_violation_id":"262254193","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203325130","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:10.000000Z","updated_at":"2025-03-17T21:58:10.000000Z","normalized_code":"3922"},{"id":10779300,"change_date":"2024-10-08 21:42:00","inspection_id":"82861858","insp_violation_id":"262254194","seq_no":"3","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"203325130","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:10.000000Z","updated_at":"2025-03-17T21:58:10.000000Z","normalized_code":"39311A1"}],"inspection_per_units":[{"id":11154634,"change_date":"2024-10-08 21:42:00","inspection_id":"82861858","insp_unit_id":"203325130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"DT3","insp_unit_license":"08237A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163G7301214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:30.000000Z","updated_at":"2025-03-17T23:38:30.000000Z"}]},{"id":6145785,"change_date":"2024-07-03 21:40:00","inspection_id":"82039375","dot_number":"2808327","report_state":"CA","report_number":"NF37000385","insp_date":"2024-07-01 00:00:00","insp_start_time":"0912","insp_end_time":"0935","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-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15428984","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T20:24:35.000000Z","updated_at":"2025-03-17T20:24:35.000000Z","inspection_violations":[{"id":9540378,"change_date":"2024-07-03 21:40:00","inspection_id":"82039375","insp_violation_id":"260469116","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201733584","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:12.000000Z","updated_at":"2025-03-17T21:52:12.000000Z","normalized_code":"3939A"},{"id":9540379,"change_date":"2024-07-03 21:40:00","inspection_id":"82039375","insp_violation_id":"260469117","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201733584","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:12.000000Z","updated_at":"2025-03-17T21:52:12.000000Z","normalized_code":"3939A"},{"id":9540380,"change_date":"2024-07-03 21:40:00","inspection_id":"82039375","insp_violation_id":"260469118","seq_no":"3","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"201733584","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:12.000000Z","updated_at":"2025-03-17T21:52:12.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":9899575,"change_date":"2024-07-03 21:40:00","inspection_id":"82039375","insp_unit_id":"201733584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BT2","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":5692206,"change_date":"2024-05-07 21:43:00","inspection_id":"81548429","dot_number":"2808327","report_state":"CA","report_number":"NBH6005512","insp_date":"2024-05-06 00:00:00","insp_start_time":"0909","insp_end_time":"0927","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15351175","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-05-07 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-07 21:43:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T20:15:30.000000Z","updated_at":"2025-03-17T20:15:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9168381,"change_date":"2024-05-07 21:43:00","inspection_id":"81548429","insp_unit_id":"200776207","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"DT1","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"Y","insp_unit_decal_number":"33810793","created_at":"2025-03-17T23:18:19.000000Z","updated_at":"2025-03-17T23:18:19.000000Z"}]},{"id":5402292,"change_date":"2024-03-29 21:38:00","inspection_id":"81231917","dot_number":"2808327","report_state":"CA","report_number":"UCKN001534","insp_date":"2024-03-29 00:00:00","insp_start_time":"0904","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15301208","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T20:09:50.000000Z","updated_at":"2025-03-17T20:09:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8700709,"change_date":"2024-03-29 21:38:00","inspection_id":"81231917","insp_unit_id":"200162069","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:56.000000Z","updated_at":"2025-03-17T23:13:56.000000Z"}]},{"id":5263878,"change_date":"2024-03-11 21:44:00","inspection_id":"81081226","dot_number":"2808327","report_state":"CA","report_number":"UE7U002395","insp_date":"2024-03-08 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"S\/B GILROY INSPECTION FACILITY","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15275320","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T20:07:03.000000Z","updated_at":"2025-03-17T20:07:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8476513,"change_date":"2024-03-11 21:44:00","inspection_id":"81081226","insp_unit_id":"199864030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BT3\/WHT","insp_unit_license":"29951Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B0JS801999","insp_unit_decal":"Y","insp_unit_decal_number":"33575553","created_at":"2025-03-17T23:11:50.000000Z","updated_at":"2025-03-17T23:11:50.000000Z"}]},{"id":4759153,"change_date":"2024-01-03 21:44:00","inspection_id":"80529751","dot_number":"2808327","report_state":"CA","report_number":"UEFO000196","insp_date":"2023-12-30 00:00:00","insp_start_time":"0801","insp_end_time":"0816","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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-01-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15187117","transaction_code":"A","transaction_date":"2023-12-30 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2024-01-03 21:44:00","snet_input_date":"2023-12-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:56:57.000000Z","updated_at":"2025-03-17T19:56:57.000000Z","inspection_violations":[{"id":7343852,"change_date":"2024-01-03 21:44:00","inspection_id":"80529751","insp_violation_id":"257173690","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"198801737","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":7656300,"change_date":"2024-01-03 21:44:00","inspection_id":"80529751","insp_unit_id":"198801737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"95799S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162D7000519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:26.000000Z","updated_at":"2025-03-17T23:04:26.000000Z"}]},{"id":4638257,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","dot_number":"2808327","report_state":"CA","report_number":"NDN6007964","insp_date":"2023-12-12 00:00:00","insp_start_time":"1100","insp_end_time":"1133","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-12-14 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15168355","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-12-14 21:44:00","snet_input_date":"2023-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-14 21:44:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:54:36.000000Z","updated_at":"2025-03-17T19:54:36.000000Z","inspection_violations":[{"id":7172670,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_violation_id":"256907039","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198523569","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3963A1"},{"id":7172671,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_violation_id":"256907040","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"198523569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39330"},{"id":7172672,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_violation_id":"256907041","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"198523569","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"393205C"},{"id":7172673,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_violation_id":"256907042","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198523569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3922"},{"id":7172674,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_violation_id":"256907043","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198523569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"3922"},{"id":7172675,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_violation_id":"256907044","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198523569","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7460229,"change_date":"2023-12-14 21:44:00","inspection_id":"80397850","insp_unit_id":"198523569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X DMP","insp_unit_license":"81486K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W168F7002973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:44.000000Z","updated_at":"2025-03-17T23:02:44.000000Z"}]},{"id":4148925,"change_date":"2023-10-06 21:41:00","inspection_id":"79858285","dot_number":"2808327","report_state":"CA","report_number":"NCAT003346","insp_date":"2023-10-05 00:00:00","insp_start_time":"1543","insp_end_time":"1604","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":"ENVIRONMENTAL REMEDIES","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":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15087969","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:44:56.000000Z","updated_at":"2025-03-17T19:44:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6671133,"change_date":"2023-10-06 21:41:00","inspection_id":"79858285","insp_unit_id":"197447778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"Y","insp_unit_decal_number":"33203183","created_at":"2025-03-17T22:55:57.000000Z","updated_at":"2025-03-17T22:55:57.000000Z"}]},{"id":3583111,"change_date":"2023-07-24 21:43:00","inspection_id":"79227473","dot_number":"2808327","report_state":"CA","report_number":"NCCL004987","insp_date":"2023-07-21 00:00:00","insp_start_time":"0845","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14993842","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-07-24 21:43:00","snet_input_date":"2023-07-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-24 21:43:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:33:51.000000Z","updated_at":"2025-03-17T19:33:51.000000Z","inspection_violations":[{"id":5525304,"change_date":"2023-07-24 21:43:00","inspection_id":"79227473","insp_violation_id":"254249790","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196168795","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL 41833","created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"3922"},{"id":5525305,"change_date":"2023-07-24 21:43:00","inspection_id":"79227473","insp_violation_id":"254249791","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"196168795","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":5761539,"change_date":"2023-07-24 21:43:00","inspection_id":"79227473","insp_unit_id":"196168795","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT 2X","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"Y","insp_unit_decal_number":"32854829","created_at":"2025-03-17T22:48:29.000000Z","updated_at":"2025-03-17T22:48:29.000000Z"}]},{"id":3515089,"change_date":"2023-07-14 21:41:00","inspection_id":"79151065","dot_number":"2808327","report_state":"CA","report_number":"N9ZT004651","insp_date":"2023-07-07 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"14981887","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5652239,"change_date":"2023-07-14 21:41:00","inspection_id":"79151065","insp_unit_id":"196015700","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"29951Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DC4W1B0JS801999","insp_unit_decal":"Y","insp_unit_decal_number":"32851476","created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":3338287,"change_date":"2023-06-21 21:43:00","inspection_id":"78952388","dot_number":"2808327","report_state":"CA","report_number":"UFJ5000403","insp_date":"2023-06-21 00:00:00","insp_start_time":"0758","insp_end_time":"0805","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"GREENVILLE AT SOUTHFRONT","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14953514","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-06-21 21:43:00","snet_input_date":"2023-06-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-21 21:43:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[{"id":5147917,"change_date":"2023-06-21 21:43:00","inspection_id":"78952388","insp_violation_id":"253632421","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195614588","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3922"},{"id":5147918,"change_date":"2023-06-21 21:43:00","inspection_id":"78952388","insp_violation_id":"253632422","seq_no":"2","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"195614588","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":5367002,"change_date":"2023-06-21 21:43:00","inspection_id":"78952388","insp_unit_id":"195614588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"}]},{"id":2980172,"change_date":"2023-05-05 21:43:00","inspection_id":"78548324","dot_number":"2808327","report_state":"CA","report_number":"UE03002555","insp_date":"2023-05-03 00:00:00","insp_start_time":"0600","insp_end_time":"0630","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"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":"2023-05-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14888177","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-05-05 21:43:00","snet_input_date":"2023-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-05 21:43:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:22:13.000000Z","updated_at":"2025-03-17T19:22:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4794912,"change_date":"2023-05-05 21:43:00","inspection_id":"78548324","insp_unit_id":"194784278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2AX","insp_unit_license":"08017T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DB4W1B9JS800586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:46.000000Z","updated_at":"2025-03-17T22:40:46.000000Z"}]},{"id":2744230,"change_date":"2023-04-05 21:41:00","inspection_id":"78281252","dot_number":"2808327","report_state":"CA","report_number":"NE8I002083","insp_date":"2023-04-03 00:00:00","insp_start_time":"1356","insp_end_time":"1442","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14846591","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:19.000000Z","updated_at":"2025-03-17T19:17:19.000000Z","inspection_violations":[{"id":4212739,"change_date":"2023-04-05 21:41:00","inspection_id":"78281252","insp_violation_id":"252071370","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"194250342","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":4417390,"change_date":"2023-04-05 21:41:00","inspection_id":"78281252","insp_unit_id":"194250342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BT2\/WHITE","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"Y","insp_unit_decal_number":"32473389","created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"}]},{"id":3561276,"change_date":"2023-07-20 21:42:00","inspection_id":"79202849","dot_number":"2808327","report_state":"CA","report_number":"N9ZT004316","insp_date":"2023-03-10 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14990720","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-07-20 21:42:00","snet_input_date":"2023-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-20 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:33:30.000000Z","updated_at":"2025-03-17T19:33:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5726736,"change_date":"2023-07-20 21:42:00","inspection_id":"79202849","insp_unit_id":"196117984","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:12.000000Z","updated_at":"2025-03-17T22:48:12.000000Z"}]},{"id":2519218,"change_date":"2023-03-06 21:41:00","inspection_id":"78024590","dot_number":"2808327","report_state":"CA","report_number":"UCZC999733","insp_date":"2023-03-06 00:00:00","insp_start_time":"1150","insp_end_time":"1203","registration_date":null,"region":"PT","ci_status_code":"C","location":"345","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14808862","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-03-06 21:41:00","snet_input_date":"2023-03-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:59.000000Z","updated_at":"2025-03-17T19:12:59.000000Z","inspection_violations":[{"id":3874845,"change_date":"2023-03-06 21:41:00","inspection_id":"78024590","insp_violation_id":"251509721","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193736906","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4054922,"change_date":"2023-03-06 21:41:00","inspection_id":"78024590","insp_unit_id":"193736906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X WHT","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"}]},{"id":2527555,"change_date":"2023-03-07 21:42:00","inspection_id":"78034090","dot_number":"2808327","report_state":"CA","report_number":"NCCL004540","insp_date":"2023-03-03 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14811009","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-03-07 21:42:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-07 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[{"id":3886053,"change_date":"2023-03-07 21:42:00","inspection_id":"78034090","insp_violation_id":"251530281","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193756900","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL 41498","created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3939A"},{"id":3886054,"change_date":"2023-03-07 21:42:00","inspection_id":"78034090","insp_violation_id":"251530282","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193756900","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4068509,"change_date":"2023-03-07 21:42:00","inspection_id":"78034090","insp_unit_id":"193756900","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"DT 7 WHT 2X","insp_unit_license":"08017T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DB4W1B9JS800586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"}]},{"id":2441256,"change_date":"2023-02-23 21:41:00","inspection_id":"77935993","dot_number":"2808327","report_state":"CA","report_number":"UDLV002334","insp_date":"2023-02-21 00:00:00","insp_start_time":"0847","insp_end_time":"0903","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"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-02-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14795102","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-02-23 21:41:00","snet_input_date":"2023-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-23 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:11:44.000000Z","updated_at":"2025-03-17T19:11:44.000000Z","inspection_violations":[{"id":3759055,"change_date":"2023-02-23 21:41:00","inspection_id":"77935993","insp_violation_id":"251314623","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193559886","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:41.000000Z","updated_at":"2025-03-17T21:24:41.000000Z","normalized_code":"3922"},{"id":3759056,"change_date":"2023-02-23 21:41:00","inspection_id":"77935993","insp_violation_id":"251314624","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193559886","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW890914","created_at":"2025-03-17T21:24:41.000000Z","updated_at":"2025-03-17T21:24:41.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3928902,"change_date":"2023-02-23 21:41:00","inspection_id":"77935993","insp_unit_id":"193559886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:08.000000Z","updated_at":"2025-03-17T22:34:08.000000Z"}]},{"id":2548601,"change_date":"2023-03-09 21:43:00","inspection_id":"78057876","dot_number":"2808327","report_state":"CA","report_number":"UCUF002829","insp_date":"2023-02-14 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"14813184","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-03-09 21:43:00","snet_input_date":"2023-02-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-09 21:43:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[{"id":3919787,"change_date":"2023-03-09 21:43:00","inspection_id":"78057876","insp_violation_id":"251583899","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"193803700","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 392315","created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":4102325,"change_date":"2023-03-09 21:43:00","inspection_id":"78057876","insp_unit_id":"193803700","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI #07","insp_unit_license":"CE51Z34","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DB4W1B9JS800586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":2136391,"change_date":"2023-01-12 21:42:00","inspection_id":"77587993","dot_number":"2808327","report_state":"CA","report_number":"NE7S001680","insp_date":"2023-01-09 00:00:00","insp_start_time":"1252","insp_end_time":"1309","registration_date":null,"region":"PT","ci_status_code":"C","location":"370","location_desc":"OAKLAND AREA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14738256","transaction_code":"A","transaction_date":"2023-01-09 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2023-01-12 21:42:00","snet_input_date":"2023-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[{"id":3306335,"change_date":"2023-01-12 21:42:00","inspection_id":"77587993","insp_violation_id":"250558058","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192857654","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"3922"},{"id":3306336,"change_date":"2023-01-12 21:42:00","inspection_id":"77587993","insp_violation_id":"250558059","seq_no":"2","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"192857654","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":3438252,"change_date":"2023-01-12 21:42:00","inspection_id":"77587993","insp_unit_id":"192857654","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE\/2AX","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"}]},{"id":2041655,"change_date":"2022-12-29 21:40:00","inspection_id":"77479456","dot_number":"2808327","report_state":"CA","report_number":"UCKN001295","insp_date":"2022-12-29 00:00:00","insp_start_time":"0951","insp_end_time":"0958","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14725244","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:04:20.000000Z","updated_at":"2025-03-17T19:04:20.000000Z","inspection_violations":[{"id":3164217,"change_date":"2022-12-29 21:40:00","inspection_id":"77479456","insp_violation_id":"250326018","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192640458","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3284517,"change_date":"2022-12-29 21:40:00","inspection_id":"77479456","insp_unit_id":"192640458","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:30.000000Z","updated_at":"2025-03-17T22:29:30.000000Z"}]},{"id":2022161,"change_date":"2022-12-27 21:40:00","inspection_id":"77457205","dot_number":"2808327","report_state":"CA","report_number":"UDBL001618","insp_date":"2022-12-19 00:00:00","insp_start_time":"0805","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF (E\/B I-580)","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":"2022-12-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"14719936","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-12-27 21:40:00","snet_input_date":"2022-12-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-27 21:40:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T19:03:58.000000Z","updated_at":"2025-03-17T19:03:58.000000Z","inspection_violations":[{"id":3136571,"change_date":"2022-12-27 21:40:00","inspection_id":"77457205","insp_violation_id":"250280927","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192596040","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA388774","created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3253533,"change_date":"2022-12-27 21:40:00","inspection_id":"77457205","insp_unit_id":"192596040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2XWHT","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","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":1575901,"change_date":"2022-10-21 21:39:00","inspection_id":"76946121","dot_number":"2808327","report_state":"CA","report_number":"UDBL001320","insp_date":"2022-10-17 00:00:00","insp_start_time":"1207","insp_end_time":"1217","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF (E\/B I-580)","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":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14644617","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T18:55:37.000000Z","updated_at":"2025-03-17T18:55:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2536298,"change_date":"2022-10-21 21:39:00","inspection_id":"76946121","insp_unit_id":"191583489","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2XWHT","insp_unit_license":"86381M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALCDW168J7K00767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:23.000000Z","updated_at":"2025-03-17T22:24:23.000000Z"}]},{"id":1330942,"change_date":"2022-09-20 21:42:00","inspection_id":"76662555","dot_number":"2808327","report_state":"CA","report_number":"NE8I001438","insp_date":"2022-09-15 00:00:00","insp_start_time":"1450","insp_end_time":"1511","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14602231","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-09-20 21:42:00","snet_input_date":"2022-09-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-20 21:42:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T18:51:14.000000Z","updated_at":"2025-03-17T18:51:14.000000Z","inspection_violations":[{"id":2106444,"change_date":"2022-09-20 21:42:00","inspection_id":"76662555","insp_violation_id":"248544768","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191010504","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2142781,"change_date":"2022-09-20 21:42:00","inspection_id":"76662555","insp_unit_id":"191010504","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"BT5\/WHT","insp_unit_license":"63629K1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDGG31C481907033","insp_unit_decal":"Y","insp_unit_decal_number":"31480452","created_at":"2025-03-17T22:21:40.000000Z","updated_at":"2025-03-17T22:21:40.000000Z"}]},{"id":1000116,"change_date":"2022-08-09 21:41:00","inspection_id":"76277642","dot_number":"2808327","report_state":"CA","report_number":"N8MC005217","insp_date":"2022-07-22 00:00:00","insp_start_time":"0910","insp_end_time":"0938","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":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-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"14540803","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-08-09 21:41:00","snet_input_date":"2022-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T18:45:23.000000Z","updated_at":"2025-03-17T18:45:23.000000Z","inspection_violations":[{"id":1577243,"change_date":"2022-08-09 21:41:00","inspection_id":"76277642","insp_violation_id":"247615368","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190221909","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"3922"},{"id":1577244,"change_date":"2022-08-09 21:41:00","inspection_id":"76277642","insp_violation_id":"247615369","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190221909","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"3922"},{"id":1577245,"change_date":"2022-08-09 21:41:00","inspection_id":"76277642","insp_violation_id":"247615370","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190221909","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1609505,"change_date":"2022-08-09 21:41:00","inspection_id":"76277642","insp_unit_id":"190221909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"Y","insp_unit_decal_number":"31539477","created_at":"2025-03-17T22:18:08.000000Z","updated_at":"2025-03-17T22:18:08.000000Z"}]},{"id":542699,"change_date":"2022-06-03 21:41:00","inspection_id":"75740085","dot_number":"2808327","report_state":"CA","report_number":"N9PI004598","insp_date":"2022-05-24 00:00:00","insp_start_time":"1213","insp_end_time":"1238","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"14452612","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-06-03 21:41:00","snet_input_date":"2022-05-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-03 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T18:37:24.000000Z","updated_at":"2025-03-17T18:37:24.000000Z","inspection_violations":[{"id":856863,"change_date":"2022-06-03 21:41:00","inspection_id":"75740085","insp_violation_id":"246249283","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189064814","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39021TB"},{"id":856864,"change_date":"2022-06-03 21:41:00","inspection_id":"75740085","insp_violation_id":"246249284","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189064814","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":873251,"change_date":"2022-06-03 21:41:00","inspection_id":"75740085","insp_unit_id":"189064814","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT DT2","insp_unit_license":"81486K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W168F7002973","insp_unit_decal":"Y","insp_unit_decal_number":"31183973","created_at":"2025-03-17T22:13:34.000000Z","updated_at":"2025-03-17T22:13:34.000000Z"}]},{"id":294936,"change_date":"2022-04-29 21:41:00","inspection_id":"75444961","dot_number":"2808327","report_state":"CA","report_number":"UDBL000929","insp_date":"2022-04-26 00:00:00","insp_start_time":"0941","insp_end_time":"0951","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF (E\/B I-580)","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14407806","transaction_code":"A","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02808327","upload_search_indicator":null,"census_search_date":"2022-04-29 21:41:00","snet_input_date":"2022-04-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"ENVIRONMENTAL REMEDIES INC","insp_carrier_street":"3910 VALLEY AVE","insp_carrier_city":"PLEASANTON","insp_carrier_state":"CA","insp_carrier_zip_code":"94566","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"295685","created_at":"2025-03-17T18:32:37.000000Z","updated_at":"2025-03-17T18:32:37.000000Z","inspection_violations":[{"id":459704,"change_date":"2022-04-29 21:41:00","inspection_id":"75444961","insp_violation_id":"245496942","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188440620","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":477271,"change_date":"2022-04-29 21:41:00","inspection_id":"75444961","insp_unit_id":"188440620","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XWHT","insp_unit_license":"40459S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7004176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:08.000000Z","updated_at":"2025-03-17T22:11:08.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2808327\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2808327\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2808327\/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\/2808327\/inspections","per_page":100,"prev_page_url":null,"to":39,"total":39}