{"current_page":1,"data":[{"id":9180687,"change_date":"2025-07-17 21:42:00","inspection_id":"85248822","dot_number":"3536618","report_state":"CA","report_number":"UEQZ000318","insp_date":"2025-07-17 00:00:00","insp_start_time":"1005","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"US101 SB \/ ST VINCENT SCALES","county_code_state":"CA","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-17 21:42: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":"15904128","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:22.000000Z","updated_at":"2025-07-21T10:43:22.000000Z","inspection_violations":[{"id":14827477,"change_date":"2025-07-17 21:42:00","inspection_id":"85248822","insp_violation_id":"267483818","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207937342","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU96543","created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"3922SLLSR"},{"id":14827478,"change_date":"2025-07-17 21:42:00","inspection_id":"85248822","insp_violation_id":"267483819","seq_no":"2","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"207937342","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"39330B"},{"id":14827479,"change_date":"2025-07-17 21:42:00","inspection_id":"85248822","insp_violation_id":"267483820","seq_no":"3","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"207937342","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":15086660,"change_date":"2025-07-17 21:42:00","inspection_id":"85248822","insp_unit_id":"207937342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"73144B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W16XM7005628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:34.000000Z","updated_at":"2025-07-21T09:46:24.000000Z"}]},{"id":7311617,"change_date":"2024-11-30 21:33:00","inspection_id":"83280685","dot_number":"3536618","report_state":"CA","report_number":"UD4G003382","insp_date":"2024-11-28 00:00:00","insp_start_time":"0645","insp_end_time":"0655","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":"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":"2024-11-30 21:33: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":"15610290","transaction_code":"A","transaction_date":"2024-11-28 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[{"id":11430012,"change_date":"2024-11-30 21:33:00","inspection_id":"83280685","insp_violation_id":"263157850","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"204119347","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":11794552,"change_date":"2024-11-30 21:33:00","inspection_id":"83280685","insp_unit_id":"204119347","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"}]},{"id":6840019,"change_date":"2024-09-27 21:40:00","inspection_id":"82780808","dot_number":"3536618","report_state":"CA","report_number":"NDZ5004877","insp_date":"2024-09-20 00:00:00","insp_start_time":"2002","insp_end_time":"2028","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-27 21:40: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":"15537127","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2024-09-27 21:40:00","snet_input_date":"2024-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[{"id":10654776,"change_date":"2024-09-27 21:40:00","inspection_id":"82780808","insp_violation_id":"262080103","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203170793","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11030654,"change_date":"2024-09-27 21:40:00","inspection_id":"82780808","insp_unit_id":"203170793","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BAY4","insp_unit_license":"73127B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":5968002,"change_date":"2024-06-11 21:43:00","inspection_id":"81847672","dot_number":"3536618","report_state":"CA","report_number":"UCKN001622","insp_date":"2024-06-10 00:00:00","insp_start_time":"1305","insp_end_time":"1314","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-06-11 21:43: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":"15397990","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2024-06-11 21:43:00","snet_input_date":"2024-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-11 21:43:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:04.000000Z","updated_at":"2025-03-17T20:21:04.000000Z","inspection_violations":[{"id":9258120,"change_date":"2024-06-11 21:43:00","inspection_id":"81847672","insp_violation_id":"260032763","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"201346964","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"39375C"},{"id":9258121,"change_date":"2024-06-11 21:43:00","inspection_id":"81847672","insp_violation_id":"260032764","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201346964","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":9612930,"change_date":"2024-06-11 21:43:00","inspection_id":"81847672","insp_unit_id":"201346964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"73144B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W16XM7005628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:40.000000Z","updated_at":"2025-03-17T23:22:40.000000Z"}]},{"id":4606996,"change_date":"2023-12-11 21:42:00","inspection_id":"80363503","dot_number":"3536618","report_state":"CA","report_number":"UEEE002025","insp_date":"2023-12-01 00:00:00","insp_start_time":"1900","insp_end_time":"1916","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"CITY","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-11 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":"15161944","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-12-11 21:42:00","snet_input_date":"2023-12-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-11 21:42:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:10.000000Z","updated_at":"2025-03-17T19:54:10.000000Z","inspection_violations":[{"id":7123886,"change_date":"2023-12-11 21:42:00","inspection_id":"80363503","insp_violation_id":"256830461","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198456168","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:26.000000Z","updated_at":"2025-03-17T21:40:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7410240,"change_date":"2023-12-11 21:42:00","inspection_id":"80363503","insp_unit_id":"198456168","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"3536618","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:18.000000Z","updated_at":"2025-03-17T23:02:18.000000Z"}]},{"id":4326612,"change_date":"2023-10-31 21:40:00","inspection_id":"80054639","dot_number":"3536618","report_state":"CA","report_number":"NDZ5003958","insp_date":"2023-10-30 00:00:00","insp_start_time":"1753","insp_end_time":"1838","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":"2023-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15118204","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-10-31 21:40:00","snet_input_date":"2023-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-31 21:40:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T19:48:43.000000Z","updated_at":"2025-03-17T19:48:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6958264,"change_date":"2023-10-31 21:40:00","inspection_id":"80054639","insp_unit_id":"197843092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"4","insp_unit_license":"73127B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"Y","insp_unit_decal_number":"33204711","created_at":"2025-03-17T22:58:24.000000Z","updated_at":"2025-03-17T22:58:24.000000Z"}]},{"id":4209902,"change_date":"2023-10-16 21:43:00","inspection_id":"79925569","dot_number":"3536618","report_state":"CA","report_number":"UDK7002634","insp_date":"2023-10-08 00:00:00","insp_start_time":"1950","insp_end_time":"2000","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":"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-10-16 21:43: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":"15096942","transaction_code":"A","transaction_date":"2023-10-08 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[{"id":6518832,"change_date":"2023-10-16 21:43:00","inspection_id":"79925569","insp_violation_id":"255868911","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197584227","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6770307,"change_date":"2023-10-16 21:43:00","inspection_id":"79925569","insp_unit_id":"197584227","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"}]},{"id":4209423,"change_date":"2023-10-16 21:43:00","inspection_id":"79925064","dot_number":"3536618","report_state":"CA","report_number":"NDZ5003856","insp_date":"2023-10-02 00:00:00","insp_start_time":"1940","insp_end_time":"2019","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":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15097435","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T19:46:14.000000Z","updated_at":"2025-03-17T19:46:14.000000Z","inspection_violations":[{"id":6518403,"change_date":"2023-10-16 21:43:00","inspection_id":"79925064","insp_violation_id":"255868436","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197583423","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":6769574,"change_date":"2023-10-16 21:43:00","inspection_id":"79925064","insp_unit_id":"197583423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"4","insp_unit_license":"73127B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:44.000000Z","updated_at":"2025-03-17T22:56:44.000000Z"}]},{"id":3691019,"change_date":"2023-08-07 21:43:00","inspection_id":"79348526","dot_number":"3536618","report_state":"CA","report_number":"UDK7002445","insp_date":"2023-07-30 00:00:00","insp_start_time":"1815","insp_end_time":"1840","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":"2023-08-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":"15009920","transaction_code":"A","transaction_date":"2023-07-30 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-08-07 21:43:00","snet_input_date":"2023-07-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-07 21:43:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T19:35:42.000000Z","updated_at":"2025-03-17T19:35:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5934603,"change_date":"2023-08-07 21:43:00","inspection_id":"79348526","insp_unit_id":"196413716","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:52.000000Z","updated_at":"2025-03-17T22:49:52.000000Z"}]},{"id":3126261,"change_date":"2023-05-23 21:43:00","inspection_id":"78712951","dot_number":"3536618","report_state":"CA","report_number":"UE74001672","insp_date":"2023-05-20 00:00:00","insp_start_time":"1905","insp_end_time":"1920","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 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":"14914148","transaction_code":"A","transaction_date":"2023-05-20 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:57.000000Z","updated_at":"2025-03-17T19:24:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5028497,"change_date":"2023-05-23 21:43:00","inspection_id":"78712951","insp_unit_id":"195109549","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"73127B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"}]},{"id":2691397,"change_date":"2023-03-29 21:42:00","inspection_id":"78220940","dot_number":"3536618","report_state":"CA","report_number":"NDMK004219","insp_date":"2023-03-15 00:00:00","insp_start_time":"0729","insp_end_time":"0759","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":"2023-03-29 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":"14838848","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-03-29 21:42:00","snet_input_date":"2023-03-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[{"id":4134610,"change_date":"2023-03-29 21:42:00","inspection_id":"78220940","insp_violation_id":"251944024","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194133568","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:20.000000Z","updated_at":"2025-03-17T21:26:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4332893,"change_date":"2023-03-29 21:42:00","inspection_id":"78220940","insp_unit_id":"194133568","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"Y","insp_unit_decal_number":"32139010","created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2650512,"change_date":"2023-03-23 21:43:00","inspection_id":"78173784","dot_number":"3536618","report_state":"CA","report_number":"NBIJ003807","insp_date":"2023-03-08 00:00:00","insp_start_time":"0851","insp_end_time":"0909","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":"2023-03-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"14830892","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-03-23 21:43:00","snet_input_date":"2023-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-23 21:43:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T19:15:32.000000Z","updated_at":"2025-03-17T19:15:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4267280,"change_date":"2023-03-23 21:43:00","inspection_id":"78173784","insp_unit_id":"194041499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"73127B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"Y","insp_unit_decal_number":"32138059","created_at":"2025-03-17T22:36:37.000000Z","updated_at":"2025-03-17T22:36:37.000000Z"}]},{"id":2320880,"change_date":"2023-02-07 21:41:00","inspection_id":"77798332","dot_number":"3536618","report_state":"CA","report_number":"UD4G002031","insp_date":"2023-02-06 00:00:00","insp_start_time":"1020","insp_end_time":"1040","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":"2023-02-07 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":"14773855","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T19:09:35.000000Z","updated_at":"2025-03-17T19:09:35.000000Z","inspection_violations":[{"id":3574502,"change_date":"2023-02-07 21:41:00","inspection_id":"77798332","insp_violation_id":"251006121","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193284047","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3735486,"change_date":"2023-02-07 21:41:00","inspection_id":"77798332","insp_unit_id":"193284047","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"73144B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W16XM7005628","insp_unit_decal":"Y","insp_unit_decal_number":"32135094","created_at":"2025-03-17T22:32:46.000000Z","updated_at":"2025-03-17T22:32:46.000000Z"}]},{"id":1719237,"change_date":"2022-11-10 21:39:00","inspection_id":"77110535","dot_number":"3536618","report_state":"CA","report_number":"NA5N005362","insp_date":"2022-11-07 00:00:00","insp_start_time":"1253","insp_end_time":"1329","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B 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":"2022-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"14670041","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2022-11-10 21:39:00","snet_input_date":"2022-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-10 21:39:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T18:58:15.000000Z","updated_at":"2025-03-17T18:58:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2765968,"change_date":"2022-11-10 21:39:00","inspection_id":"77110535","insp_unit_id":"191910686","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"73127B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W167M7005621","insp_unit_decal":"Y","insp_unit_decal_number":"31821814","created_at":"2025-03-17T22:25:56.000000Z","updated_at":"2025-03-17T22:25:56.000000Z"}]},{"id":1620618,"change_date":"2022-10-27 21:42:00","inspection_id":"76997484","dot_number":"3536618","report_state":"CA","report_number":"NCNG005624","insp_date":"2022-10-26 00:00:00","insp_start_time":"0705","insp_end_time":"0720","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":"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-10-27 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":"14652708","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2022-10-27 21:42:00","snet_input_date":"2022-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-27 21:42:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T18:56:37.000000Z","updated_at":"2025-03-17T18:56:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2607428,"change_date":"2022-10-27 21:42:00","inspection_id":"76997484","insp_unit_id":"191687148","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"Y","insp_unit_decal_number":"31817674","created_at":"2025-03-17T22:24:52.000000Z","updated_at":"2025-03-17T22:24:52.000000Z"}]},{"id":1152315,"change_date":"2022-08-26 21:41:00","inspection_id":"76455310","dot_number":"3536618","report_state":"CA","report_number":"UD4G001794","insp_date":"2022-08-25 00:00:00","insp_start_time":"0950","insp_end_time":"1020","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":"2022-08-26 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":"14566778","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2022-08-26 21:41:00","snet_input_date":"2022-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-26 21:41:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T18:47:56.000000Z","updated_at":"2025-03-17T18:47:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1852798,"change_date":"2022-08-26 21:41:00","inspection_id":"76455310","insp_unit_id":"190580856","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"71884Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W161L7013129","insp_unit_decal":"Y","insp_unit_decal_number":"31473262","created_at":"2025-03-17T22:19:45.000000Z","updated_at":"2025-03-17T22:19:45.000000Z"}]},{"id":909207,"change_date":"2022-07-27 21:41:00","inspection_id":"76170912","dot_number":"3536618","report_state":"CA","report_number":"NE1M002471","insp_date":"2022-07-26 00:00:00","insp_start_time":"0715","insp_end_time":"0740","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-27 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":"14523132","transaction_code":"A","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2022-07-27 21:41:00","snet_input_date":"2022-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T18:43:42.000000Z","updated_at":"2025-03-17T18:43:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1463553,"change_date":"2022-07-27 21:41:00","inspection_id":"76170912","insp_unit_id":"190003502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"BAY-2","insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"Y","insp_unit_decal_number":"31468741","created_at":"2025-03-17T22:17:12.000000Z","updated_at":"2025-03-17T22:17:12.000000Z"}]},{"id":804006,"change_date":"2022-07-13 21:40:00","inspection_id":"76048011","dot_number":"3536618","report_state":"CA","report_number":"UEO5000216","insp_date":"2022-07-11 00:00:00","insp_start_time":"1501","insp_end_time":"1511","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":"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":"2022-07-12 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":"14502685","transaction_code":"C","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2022-07-12 21:40:00","snet_input_date":"2022-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-12 21:40:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:55.000000Z","updated_at":"2025-03-17T18:41:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1293927,"change_date":"2022-07-13 21:40:00","inspection_id":"76048011","insp_unit_id":"189763092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30907X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165K7008806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:07.000000Z","updated_at":"2025-03-17T22:16:07.000000Z"}]},{"id":766730,"change_date":"2022-07-06 21:42:00","inspection_id":"76004608","dot_number":"3536618","report_state":"CA","report_number":"UE9B001263","insp_date":"2022-07-04 00:00:00","insp_start_time":"1136","insp_end_time":"1202","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":"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":"2022-07-06 21:42: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":"14495159","transaction_code":"A","transaction_date":"2022-07-04 00:00:00","upload_date":"2022-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03536618","upload_search_indicator":null,"census_search_date":"2022-07-06 21:42:00","snet_input_date":"2022-07-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-06 21:42:00","insp_carrier_name":"EMERGENCY RESTORATION COMPANY","insp_carrier_street":"197 MAYHEW WY","insp_carrier_city":"WALNUT CREEK","insp_carrier_state":"CA","insp_carrier_zip_code":"94597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576906","created_at":"2025-03-17T18:41:13.000000Z","updated_at":"2025-03-17T18:41:13.000000Z","inspection_violations":[{"id":1209896,"change_date":"2022-07-06 21:42:00","inspection_id":"76004608","insp_violation_id":"246936543","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189643195","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"3922"},{"id":1209897,"change_date":"2022-07-06 21:42:00","inspection_id":"76004608","insp_violation_id":"246936544","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"189643195","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39360D"},{"id":1209898,"change_date":"2022-07-06 21:42:00","inspection_id":"76004608","insp_violation_id":"246936545","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189643195","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1233455,"change_date":"2022-07-06 21:42:00","inspection_id":"76004608","insp_unit_id":"189643195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X GRY","insp_unit_license":"71884Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W161L7013129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:46.000000Z","updated_at":"2025-03-17T22:15:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3536618\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3536618\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3536618\/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\/3536618\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}