{"current_page":1,"data":[{"id":12169931,"change_date":"2026-06-12 21:41:00","inspection_id":"88124404","dot_number":"157345","report_state":"NY","report_number":"0L10001953","insp_date":"2026-06-08 00:00:00","insp_start_time":"1142","insp_end_time":"1158","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2026-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37600","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":"3524985","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2026-06-12 21:41:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:29.000000Z","updated_at":"2026-06-23T09:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21139299,"change_date":"2026-06-12 21:41:00","inspection_id":"88124404","insp_unit_id":"214066138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"34898","insp_unit_license":"77528NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACYFC7SHWC9108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:29.000000Z","updated_at":"2026-06-23T09:01:48.000000Z"}]},{"id":11537303,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","dot_number":"157345","report_state":"MA","report_number":"CX00002136","insp_date":"2026-04-01 00:00:00","insp_start_time":"1248","insp_end_time":"1317","registration_date":"2026-04-28 00:00:00","region":"ET","ci_status_code":"C","location":"386H","location_desc":"H-WORCESTER","county_code_state":"MA","county_code":"027","insp_level_id":"2","service_center":"EA","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":"Y","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-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","viol_total":"9","oos_total":"3","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"543283","transaction_code":"C","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2026-04-01 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-04-01 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-04T09:43:18.000000Z","updated_at":"2026-05-09T09:30:04.000000Z","inspection_violations":[{"id":19494801,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904303","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213266818","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"39395A4EEUS"},{"id":19494802,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904304","seq_no":"4","part_no":"393","part_no_section":"110C-C","insp_viol_unit":"2","insp_unit_id":"213266819","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"393110CC"},{"id":19494803,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904305","seq_no":"5","part_no":"393","part_no_section":"110C-C","insp_viol_unit":"2","insp_unit_id":"213266819","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"393110CC"},{"id":19494804,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904306","seq_no":"6","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"213266819","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"39343DBMA"},{"id":19494805,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904307","seq_no":"7","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"213266819","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"393104F3C"},{"id":19494806,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904308","seq_no":"8","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"213266819","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"39311A1LIL"},{"id":19494800,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904302","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"3922SLL"},{"id":19494799,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904301","seq_no":"1","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"55","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"3929ADFSL"},{"id":19494807,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_violation_id":"273904309","seq_no":"9","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"2","insp_unit_id":"213266819","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:06.000000Z","updated_at":"2026-05-09T09:41:48.000000Z","normalized_code":"39311A1LCL"}],"inspection_per_units":[{"id":19768094,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_unit_id":"213266818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"30869","insp_unit_license":"1AD35Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHG3DV2PHNM0374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:37.000000Z","updated_at":"2026-05-09T09:02:08.000000Z"},{"id":19768095,"change_date":"2026-04-28 21:39:00","inspection_id":"87459493","insp_unit_id":"213266819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SAUB","insp_unit_company":"25859","insp_unit_license":"C93475","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1F9UZ281XGV048007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:37.000000Z","updated_at":"2026-05-09T09:02:08.000000Z"}]},{"id":11498444,"change_date":"2026-03-27 21:39:00","inspection_id":"87418435","dot_number":"157345","report_state":"MA","report_number":"DA00004448","insp_date":"2026-03-26 00:00:00","insp_start_time":"1541","insp_end_time":"1552","registration_date":null,"region":"ET","ci_status_code":"C","location":"389H","location_desc":"H-WRENTHAM","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","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-27 21:39: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":"542825","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2026-03-27 21:39:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-27 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:37.000000Z","updated_at":"2026-04-07T09:31:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19697749,"change_date":"2026-03-27 21:39:00","inspection_id":"87418435","insp_unit_id":"212377509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V19409","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0W5HT7KED71149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:20.000000Z","updated_at":"2026-04-07T09:07:48.000000Z"}]},{"id":10568414,"change_date":"2026-01-07 21:38:00","inspection_id":"86706196","dot_number":"157345","report_state":"MA","report_number":"EI00000299","insp_date":"2025-12-31 00:00:00","insp_start_time":"1610","insp_end_time":"1625","registration_date":"2026-01-07 00:00:00","region":"ET","ci_status_code":"C","location":"327H","location_desc":"H-SWANSEA","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25100","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"537471","transaction_code":"C","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2025-12-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-08T10:34:18.000000Z","updated_at":"2026-01-18T10:31:05.000000Z","inspection_violations":[{"id":17789585,"change_date":"2026-01-07 21:38:00","inspection_id":"86706196","insp_violation_id":"271057794","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":null,"created_at":"2026-01-10T10:38:39.000000Z","updated_at":"2026-01-18T10:30:56.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17740824,"change_date":"2026-01-07 21:38:00","inspection_id":"86706196","insp_unit_id":"210950109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"26858","insp_unit_license":"S95046","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0W5HT3HEC57920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:04.000000Z","updated_at":"2026-01-18T10:00:26.000000Z"},{"id":17740825,"change_date":"2026-01-07 21:38:00","inspection_id":"86706196","insp_unit_id":"210950110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SAUB","insp_unit_company":null,"insp_unit_license":"C73885","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1F9UZ2215FV048200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:04.000000Z","updated_at":"2026-01-18T10:00:26.000000Z"}]},{"id":10494128,"change_date":"2025-12-31 21:37:00","inspection_id":"86628710","dot_number":"157345","report_state":"MA","report_number":"CX00001846","insp_date":"2025-12-21 00:00:00","insp_start_time":"1129","insp_end_time":"1140","registration_date":"2025-12-31 00:00:00","region":"ET","ci_status_code":"C","location":"023S","location_desc":"S-AYER","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"56360","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":"536739","transaction_code":"C","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-22 21:38:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:40.000000Z","updated_at":"2026-01-11T10:30:07.000000Z","inspection_violations":[{"id":17711664,"change_date":"2025-12-31 21:37:00","inspection_id":"86628710","insp_violation_id":"270970115","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"210867504","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-03T10:38:54.000000Z","updated_at":"2026-01-11T10:30:17.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":17663325,"change_date":"2025-12-31 21:37:00","inspection_id":"86628710","insp_unit_id":"210867504","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"CSE","insp_unit_company":null,"insp_unit_license":"W83109","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JEEN1021LMF253336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:49.000000Z","updated_at":"2026-01-11T10:00:07.000000Z"}]},{"id":10044188,"change_date":"2025-10-31 21:40:00","inspection_id":"86156667","dot_number":"157345","report_state":"MA","report_number":"DG00001392","insp_date":"2025-10-27 00:00:00","insp_start_time":"1343","insp_end_time":"1354","registration_date":"2025-10-31 00:00:00","region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-27 21:39: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":"532334","transaction_code":"C","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2025-10-27 21:39:00","snet_input_date":"2025-10-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-30T10:00:44.000000Z","updated_at":"2025-11-04T11:00:26.000000Z","inspection_violations":[{"id":16710722,"change_date":"2025-10-31 21:40:00","inspection_id":"86156667","insp_violation_id":"269648352","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209767353","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:34.000000Z","updated_at":"2025-11-04T11:15:39.000000Z","normalized_code":"39021TB1MC"},{"id":16710723,"change_date":"2025-10-31 21:40:00","inspection_id":"86156667","insp_violation_id":"269648353","seq_no":"2","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"209767353","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:34.000000Z","updated_at":"2025-11-04T11:15:39.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":16772471,"change_date":"2025-10-31 21:40:00","inspection_id":"86156667","insp_unit_id":"209767353","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"3665001","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FD0W5HT7NED43128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:11.000000Z","updated_at":"2025-11-04T10:45:34.000000Z"}]},{"id":9262666,"change_date":"2025-07-28 21:39:00","inspection_id":"85335118","dot_number":"157345","report_state":"US","report_number":"1468000102","insp_date":"2025-07-23 00:00:00","insp_start_time":"1123","insp_end_time":"1224","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER MA","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NATIONAL GRID","shipping_paper_number":"20964","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","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":"2052317","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2025-07-28 21:39:00","snet_input_date":"2025-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-28 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:24.000000Z","updated_at":"2025-08-01T10:41:12.000000Z","inspection_violations":[{"id":15005050,"change_date":"2025-07-28 21:39:00","inspection_id":"85335118","insp_violation_id":"267686170","seq_no":"1","part_no":"177","part_no_section":"817A-HMRSPMC","insp_viol_unit":"1","insp_unit_id":"208107411","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:14.000000Z","updated_at":"2025-08-01T10:42:45.000000Z","normalized_code":"177817AHMRSPMC"},{"id":15005051,"change_date":"2025-07-28 21:39:00","inspection_id":"85335118","insp_violation_id":"267686171","seq_no":"2","part_no":"180","part_no_section":"415-HMTMC","insp_viol_unit":"1","insp_unit_id":"208107411","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:14.000000Z","updated_at":"2025-08-01T10:42:45.000000Z","normalized_code":"180415HMTMC"},{"id":15005052,"change_date":"2025-07-28 21:39:00","inspection_id":"85335118","insp_violation_id":"267686172","seq_no":"3","part_no":"107","part_no_section":"608B-HMAMC","insp_viol_unit":"1","insp_unit_id":"208107411","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:14.000000Z","updated_at":"2025-08-01T10:42:45.000000Z","normalized_code":"107608BHMAMC"}],"inspection_per_units":[{"id":15244514,"change_date":"2025-07-28 21:39:00","inspection_id":"85335118","insp_unit_id":"208107411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"83232","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVACXDT4EHFR9784","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:27.000000Z","updated_at":"2025-08-01T09:45:27.000000Z"}]},{"id":9055137,"change_date":"2025-07-03 21:33:00","inspection_id":"85116681","dot_number":"157345","report_state":"MA","report_number":"CX00001443","insp_date":"2025-07-03 00:00:00","insp_start_time":"0850","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"300H","location_desc":"H-SHREWSBURY","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"522297","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2025-07-03 21:33:00","snet_input_date":"2025-07-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-03 21:33:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:30.000000Z","updated_at":"2025-07-07T10:07:30.000000Z","inspection_violations":[{"id":14570867,"change_date":"2025-07-03 21:33:00","inspection_id":"85116681","insp_violation_id":"267186786","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-07-06T10:16:46.000000Z","updated_at":"2025-07-07T10:15:12.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":14856952,"change_date":"2025-07-03 21:33:00","inspection_id":"85116681","insp_unit_id":"207686839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25636","insp_unit_license":"93954","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVDCWDT3GHHK9435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:16.000000Z","updated_at":"2025-07-07T09:45:09.000000Z"}]},{"id":8707856,"change_date":"2025-05-22 21:41:00","inspection_id":"84749047","dot_number":"157345","report_state":"US","report_number":"1468000096","insp_date":"2025-05-21 00:00:00","insp_start_time":"0906","insp_end_time":"0949","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER MA","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","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":"1763612","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2025-05-22 21:41:00","snet_input_date":"2025-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-22 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-25T10:04:50.000000Z","updated_at":"2025-05-26T10:03:43.000000Z","inspection_violations":[{"id":13881247,"change_date":"2025-05-22 21:41:00","inspection_id":"84749047","insp_violation_id":"266394940","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"207003426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:25.000000Z","updated_at":"2025-05-26T10:19:27.000000Z","normalized_code":"3939ALFTSI"},{"id":13881248,"change_date":"2025-05-22 21:41:00","inspection_id":"84749047","insp_violation_id":"266394941","seq_no":"2","part_no":"177","part_no_section":"817E1-HMHC","insp_viol_unit":"1","insp_unit_id":"207003426","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:25.000000Z","updated_at":"2025-05-26T10:19:27.000000Z","normalized_code":"177817E1HMHC"},{"id":13881249,"change_date":"2025-05-22 21:41:00","inspection_id":"84749047","insp_violation_id":"266394942","seq_no":"3","part_no":"177","part_no_section":"817E2-HMHC","insp_viol_unit":"1","insp_unit_id":"207003426","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:25.000000Z","updated_at":"2025-05-26T10:19:27.000000Z","normalized_code":"177817E2HMHC"}],"inspection_per_units":[{"id":14230514,"change_date":"2025-05-22 21:41:00","inspection_id":"84749047","insp_unit_id":"207003426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"83232","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVACXDT4EHFR9784","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:10.000000Z","updated_at":"2025-05-26T09:48:42.000000Z"}]},{"id":8465450,"change_date":"2025-04-28 21:35:00","inspection_id":"84493866","dot_number":"157345","report_state":"MA","report_number":"CR00003638","insp_date":"2025-04-24 00:00:00","insp_start_time":"1545","insp_end_time":"1553","registration_date":"2025-04-28 00:00:00","region":"ET","ci_status_code":"C","location":"042H","location_desc":"H-BOYLSTON","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"515752","transaction_code":"C","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2025-04-25 21:35:00","snet_input_date":"2025-04-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-25 21:35:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-28T10:13:55.000000Z","updated_at":"2025-05-02T10:22:03.000000Z","inspection_violations":[{"id":13394731,"change_date":"2025-04-28 21:35:00","inspection_id":"84493866","insp_violation_id":"265837054","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":null,"created_at":"2025-05-01T10:16:01.000000Z","updated_at":"2025-05-02T10:40:19.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":13765679,"change_date":"2025-04-28 21:35:00","inspection_id":"84493866","insp_unit_id":"206496430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"93954","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVDCWDT3GHHK9435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:45:54.000000Z","updated_at":"2025-05-02T09:49:45.000000Z"}]},{"id":7669110,"change_date":"2025-01-21 21:39:00","inspection_id":"83656434","dot_number":"157345","report_state":"MA","report_number":"CR00003421","insp_date":"2025-01-19 00:00:00","insp_start_time":"0945","insp_end_time":"0957","registration_date":null,"region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"507572","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:27.000000Z","updated_at":"2025-03-17T20:57:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12375156,"change_date":"2025-01-21 21:39:00","inspection_id":"83656434","insp_unit_id":"204929085","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"XHNT44","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1FDUF5GT4KDA17825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:35.000000Z","updated_at":"2025-03-17T23:51:35.000000Z"}]},{"id":7625055,"change_date":"2025-01-23 21:38:00","inspection_id":"83610089","dot_number":"157345","report_state":"MA","report_number":"CX00001245","insp_date":"2025-01-15 00:00:00","insp_start_time":"1320","insp_end_time":"1329","registration_date":"2025-01-23 00:00:00","region":"ET","ci_status_code":"C","location":"386H","location_desc":"H-WORCESTER","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"507236","transaction_code":"C","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:30.000000Z","updated_at":"2025-03-17T20:56:30.000000Z","inspection_violations":[{"id":11918684,"change_date":"2025-01-23 21:38:00","inspection_id":"83610089","insp_violation_id":"264140872","seq_no":"1","part_no":"392","part_no_section":"16B-DPASS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:02.000000Z","updated_at":"2025-03-17T22:04:02.000000Z","normalized_code":"39216BDPASS"},{"id":11918685,"change_date":"2025-01-23 21:38:00","inspection_id":"83610089","insp_violation_id":"264140873","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:02.000000Z","updated_at":"2025-03-17T22:04:02.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":12303585,"change_date":"2025-01-23 21:38:00","inspection_id":"83610089","insp_unit_id":"204972795","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"5295A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVDCYDT3HHJD5577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:47.000000Z","updated_at":"2025-03-17T23:50:47.000000Z"}]},{"id":7103006,"change_date":"2024-11-01 21:39:00","inspection_id":"83060099","dot_number":"157345","report_state":"NH","report_number":"1085004425","insp_date":"2024-10-30 00:00:00","insp_start_time":"0725","insp_end_time":"0737","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"279923","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2024-11-01 21:39:00","snet_input_date":"2024-10-30 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-11-01 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:14.000000Z","updated_at":"2025-03-17T20:44:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11455815,"change_date":"2024-11-01 21:39:00","inspection_id":"83060099","insp_unit_id":"203699579","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"6404B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVKG5FE8MHMH3270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:39.000000Z","updated_at":"2025-03-17T23:41:39.000000Z"}]},{"id":6665890,"change_date":"2024-09-06 21:40:00","inspection_id":"82595388","dot_number":"157345","report_state":"NH","report_number":"1058002309","insp_date":"2024-09-06 00:00:00","insp_start_time":"0833","insp_end_time":"0904","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"1","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"278298","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2024-09-06 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-09-06 21:40:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:12.000000Z","updated_at":"2025-03-17T20:35:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10747364,"change_date":"2024-09-06 21:40:00","inspection_id":"82595388","insp_unit_id":"202797383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T11378","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0W5HT5HEC57921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:17.000000Z","updated_at":"2025-03-17T23:34:17.000000Z"}]},{"id":6125704,"change_date":"2024-07-02 21:41:00","inspection_id":"82017691","dot_number":"157345","report_state":"RI","report_number":"M008000106","insp_date":"2024-06-26 00:00:00","insp_start_time":"1014","insp_end_time":"1122","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH KINGSTOWN RI","county_code_state":"RI","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"2024-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","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":"619590","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:11.000000Z","updated_at":"2025-03-17T20:24:11.000000Z","inspection_violations":[{"id":9510960,"change_date":"2024-07-02 21:41:00","inspection_id":"82017691","insp_violation_id":"260426022","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201692278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3939A"},{"id":9510961,"change_date":"2024-07-02 21:41:00","inspection_id":"82017691","insp_violation_id":"260426023","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"24502501715","created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9866977,"change_date":"2024-07-02 21:41:00","inspection_id":"82017691","insp_unit_id":"201692278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"24265","insp_unit_license":"969947","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGEDV4GLGY0234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:14.000000Z","updated_at":"2025-03-17T23:25:14.000000Z"},{"id":9866978,"change_date":"2024-07-02 21:41:00","inspection_id":"82017691","insp_unit_id":"201692279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WADE","insp_unit_company":"31152","insp_unit_license":"97568","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1W9FH422XPE285749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:14.000000Z","updated_at":"2025-03-17T23:25:14.000000Z"}]},{"id":5874505,"change_date":"2024-05-30 21:42:00","inspection_id":"81745868","dot_number":"157345","report_state":"MA","report_number":"CP00004255","insp_date":"2024-05-29 00:00:00","insp_start_time":"1538","insp_end_time":"1553","registration_date":"2024-05-30 00:00:00","region":"ET","ci_status_code":"C","location":"369H","location_desc":"H-WESTMINSTER","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"492711","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2024-05-30 21:42:00","snet_input_date":"2024-05-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-30 21:42:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:06.000000Z","updated_at":"2025-03-17T20:19:06.000000Z","inspection_violations":[{"id":9109282,"change_date":"2024-05-30 21:42:00","inspection_id":"81745868","insp_violation_id":"259807497","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9461550,"change_date":"2024-05-30 21:42:00","inspection_id":"81745868","insp_unit_id":"201150306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"S46438","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0W5HT7GEC75321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:09.000000Z","updated_at":"2025-03-17T23:21:09.000000Z"}]},{"id":5618491,"change_date":"2024-04-29 21:42:00","inspection_id":"81468201","dot_number":"157345","report_state":"NH","report_number":"1085003938","insp_date":"2024-04-01 00:00:00","insp_start_time":"0943","insp_end_time":"1002","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","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-04-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"274484","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2024-04-29 21:42:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-29 21:42:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9050708,"change_date":"2024-04-29 21:42:00","inspection_id":"81468201","insp_unit_id":"200620238","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"S17265","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HT6GEC75324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":5618540,"change_date":"2024-05-16 21:41:00","inspection_id":"81468255","dot_number":"157345","report_state":"NH","report_number":"1078007476","insp_date":"2024-04-01 00:00:00","insp_start_time":"0939","insp_end_time":"1001","registration_date":"2024-05-15 00:00:00","region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"2","service_center":"EA","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-04-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"111000","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":"274229","transaction_code":"C","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2024-04-29 21:43:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[{"id":8690417,"change_date":"2024-05-16 21:41:00","inspection_id":"81468255","insp_violation_id":"259543080","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200926611","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"3922"},{"id":8690418,"change_date":"2024-05-16 21:41:00","inspection_id":"81468255","insp_violation_id":"259543081","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200926611","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9050761,"change_date":"2024-05-16 21:41:00","inspection_id":"81468255","insp_unit_id":"200926610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AD35Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHG3DV2PHNM0374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"},{"id":9050762,"change_date":"2024-05-16 21:41:00","inspection_id":"81468255","insp_unit_id":"200926611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"5032909","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGAP3028NL010253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":4157479,"change_date":"2023-10-10 21:41:00","inspection_id":"79867626","dot_number":"157345","report_state":"MA","report_number":"CX00000482","insp_date":"2023-10-07 00:00:00","insp_start_time":"0755","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"312H","location_desc":"H-STERLING","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"Y","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-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"475743","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:59.000000Z","updated_at":"2025-03-17T19:44:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6684991,"change_date":"2023-10-10 21:41:00","inspection_id":"79867626","insp_unit_id":"197465989","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"30719","insp_unit_license":"1AC87Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5KJJALD14PPUJ7230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"},{"id":6684992,"change_date":"2023-10-10 21:41:00","inspection_id":"79867626","insp_unit_id":"197465990","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROGE","insp_unit_company":null,"insp_unit_license":"97147","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1RBH53300GAR26432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"}]},{"id":4140594,"change_date":"2023-10-06 21:40:00","inspection_id":"79848980","dot_number":"157345","report_state":"NH","report_number":"1078007090","insp_date":"2023-10-05 00:00:00","insp_start_time":"0910","insp_end_time":"0936","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"SANBORNTON","county_code_state":"NH","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"269895","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":"00157345","upload_search_indicator":null,"census_search_date":"2023-10-06 21:40:00","snet_input_date":"2023-10-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:53.000000Z","updated_at":"2025-03-17T19:44:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6657831,"change_date":"2023-10-06 21:40:00","inspection_id":"79848980","insp_unit_id":"197429804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"S65416","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HT8GEC75325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":4066949,"change_date":"2023-09-27 21:41:00","inspection_id":"79767250","dot_number":"157345","report_state":"NH","report_number":"1230001112","insp_date":"2023-09-26 00:00:00","insp_start_time":"1030","insp_end_time":"1129","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"I93 REST AREA","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2","hazmat_oos_total":"1","snet_sequence_id":"269517","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-26 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:11.000000Z","updated_at":"2025-03-17T19:43:11.000000Z","inspection_violations":[{"id":6297136,"change_date":"2023-09-27 21:41:00","inspection_id":"79767250","insp_violation_id":"255512748","seq_no":"1","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"197263070","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"001172","created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"177817A"},{"id":6297137,"change_date":"2023-09-27 21:41:00","inspection_id":"79767250","insp_violation_id":"255512749","seq_no":"2","part_no":"172","part_no_section":"328(d)","insp_viol_unit":"1","insp_unit_id":"197263070","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"172328D"}],"inspection_per_units":[{"id":6539019,"change_date":"2023-09-27 21:41:00","inspection_id":"79767250","insp_unit_id":"197263070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20964","insp_unit_license":"83232","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVACXDT4EHFR9784","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"}]},{"id":2598138,"change_date":"2023-03-17 21:41:00","inspection_id":"78114709","dot_number":"157345","report_state":"MA","report_number":"CP00002916","insp_date":"2023-03-16 00:00:00","insp_start_time":"1820","insp_end_time":"1831","registration_date":null,"region":"ET","ci_status_code":"C","location":"369H","location_desc":"H-WESTMINSTER","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","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":"Y","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-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"462321","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2023-03-17 21:41:00","snet_input_date":"2023-03-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-17 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:31.000000Z","updated_at":"2025-03-17T19:14:31.000000Z","inspection_violations":[{"id":3997128,"change_date":"2023-03-17 21:41:00","inspection_id":"78114709","insp_violation_id":"251718697","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4182043,"change_date":"2023-03-17 21:41:00","inspection_id":"78114709","insp_unit_id":"193921890","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"4668A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVACXDT9HHJD0767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"}]},{"id":2150151,"change_date":"2023-01-17 21:41:00","inspection_id":"77603726","dot_number":"157345","report_state":"NY","report_number":"1020001185","insp_date":"2023-01-13 00:00:00","insp_start_time":"0927","insp_end_time":"0944","registration_date":null,"region":"ET","ci_status_code":"C","location":"00046","location_desc":"DEER PARK (OLD RR STATION)","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"NATIONAL GRID SERVICE CO INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2789686","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2023-01-17 21:41:00","snet_input_date":"2023-01-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-17 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:15.000000Z","updated_at":"2025-03-17T19:06:15.000000Z","inspection_violations":[{"id":3325073,"change_date":"2023-01-17 21:41:00","inspection_id":"77603726","insp_violation_id":"250589128","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192887076","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3459695,"change_date":"2023-01-17 21:41:00","inspection_id":"77603726","insp_unit_id":"192887076","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"88455MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMMML9GL107543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:47.000000Z","updated_at":"2025-03-17T22:30:47.000000Z"}]},{"id":2110939,"change_date":"2023-01-11 21:42:00","inspection_id":"77558807","dot_number":"157345","report_state":"NY","report_number":"SPWL081065","insp_date":"2023-01-10 00:00:00","insp_start_time":"1131","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2787272","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2023-01-11 21:42:00","snet_input_date":"2023-01-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:32.000000Z","updated_at":"2025-03-17T19:05:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3397179,"change_date":"2023-01-11 21:42:00","inspection_id":"77558807","insp_unit_id":"192798344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"66532ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJTSKL0FH181659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:21.000000Z","updated_at":"2025-03-17T22:30:21.000000Z"}]},{"id":1226075,"change_date":"2022-09-07 21:40:00","inspection_id":"76540690","dot_number":"157345","report_state":"NH","report_number":"0896000593","insp_date":"2022-09-06 00:00:00","insp_start_time":"1032","insp_end_time":"1042","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"KEENE NB TRUCK LANES","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","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":"Y","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-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"260208","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2022-09-07 21:40:00","snet_input_date":"2022-09-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-09-07 21:40:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:19.000000Z","updated_at":"2025-03-17T18:49:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1972858,"change_date":"2022-09-07 21:40:00","inspection_id":"76540690","insp_unit_id":"190755227","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"92909","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVKG3DV8GHHN5556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:33.000000Z","updated_at":"2025-03-17T22:20:33.000000Z"}]},{"id":743828,"change_date":"2022-07-08 21:40:00","inspection_id":"75978151","dot_number":"157345","report_state":"NH","report_number":"1291002327","insp_date":"2022-06-30 00:00:00","insp_start_time":"1030","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"029","location_desc":"MARLBORO","county_code_state":"NH","county_code":"005","insp_level_id":"2","service_center":"EA","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":"Y","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-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"199140","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":"258045","transaction_code":"C","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":null,"census_search_date":"2022-07-05 21:41:00","snet_input_date":"2022-06-30 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-05 21:41:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:52.000000Z","updated_at":"2025-03-17T18:40:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1195564,"change_date":"2022-07-08 21:40:00","inspection_id":"75978151","insp_unit_id":"189666904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROGR","insp_unit_company":"25942","insp_unit_license":"97149","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1RBH53307GAR26430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"},{"id":1195565,"change_date":"2022-07-08 21:40:00","inspection_id":"75978151","insp_unit_id":"189666905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"16099","insp_unit_license":"76476","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5KJJALDR9BPAX9728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"}]},{"id":274524,"change_date":"2022-04-28 21:39:00","inspection_id":"75420457","dot_number":"157345","report_state":"NY","report_number":"SPWL090671","insp_date":"2022-04-27 00:00:00","insp_start_time":"1000","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","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":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2699787","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:16.000000Z","updated_at":"2025-03-17T18:32:16.000000Z","inspection_violations":[{"id":425627,"change_date":"2022-04-28 21:39:00","inspection_id":"75420457","insp_violation_id":"245435462","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9FD25QK","created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":425628,"change_date":"2022-04-28 21:39:00","inspection_id":"75420457","insp_violation_id":"245435463","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188390481","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":444431,"change_date":"2022-04-28 21:39:00","inspection_id":"75420457","insp_unit_id":"188390481","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20233","insp_unit_license":"14499TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FUBGEDV2DLFH9012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:55.000000Z","updated_at":"2025-03-17T22:10:55.000000Z"},{"id":444432,"change_date":"2022-04-28 21:39:00","inspection_id":"75420457","insp_unit_id":"188390482","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"25936","insp_unit_license":"BK49948","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS2406HG867302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:55.000000Z","updated_at":"2025-03-17T22:10:55.000000Z"}]},{"id":221531,"change_date":"2022-04-21 21:40:00","inspection_id":"75357204","dot_number":"157345","report_state":"NY","report_number":"SPL0077839","insp_date":"2022-04-01 00:00:00","insp_start_time":"0929","insp_end_time":"0944","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"2697241","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00157345","upload_search_indicator":"M","census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"NATIONAL GRID SERVICE CO INC","insp_carrier_street":"40 SYLVAN ROAD","insp_carrier_city":"WALTHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02451","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":358998,"change_date":"2022-04-21 21:40:00","inspection_id":"75357204","insp_unit_id":"188264564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20233","insp_unit_license":"14499TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FUBGEDV2DLFH9012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"},{"id":358999,"change_date":"2022-04-21 21:40:00","inspection_id":"75357204","insp_unit_id":"188264565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"25936","insp_unit_license":"BK49948","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1UYVS2406HG867302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/157345\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/157345\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/157345\/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\/157345\/inspections","per_page":100,"prev_page_url":null,"to":28,"total":28}