{"current_page":1,"data":[{"id":12191813,"change_date":"2026-06-15 21:41:00","inspection_id":"88147796","dot_number":"668842","report_state":"CT","report_number":"3080001167","insp_date":"2026-06-15 00:00:00","insp_start_time":"0852","insp_end_time":"0935","registration_date":null,"region":"ES","ci_status_code":"C","location":"083S","location_desc":"CT","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NONE","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-15 21:41: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":"3546056","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-18T09:41:01.000000Z","updated_at":"2026-06-22T09:35:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21175865,"change_date":"2026-06-15 21:41:00","inspection_id":"88147796","insp_unit_id":"214109646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"553720","insp_unit_license":"X11566","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL0PL791353","insp_unit_decal":"Y","insp_unit_decal_number":"36429728","created_at":"2026-06-18T09:17:53.000000Z","updated_at":"2026-06-22T09:09:49.000000Z"}]},{"id":11908120,"change_date":"2026-05-14 21:42:00","inspection_id":"87847260","dot_number":"668842","report_state":"MA","report_number":"DF00003292","insp_date":"2026-05-14 00:00:00","insp_start_time":"0813","insp_end_time":"0846","registration_date":null,"region":"ES","ci_status_code":"C","location":"362H","location_desc":"MA","county_code_state":"MA","county_code":"025","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","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":"3322865","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:53.000000Z","updated_at":"2026-05-25T09:31:19.000000Z","inspection_violations":[{"id":20714557,"change_date":"2026-05-14 21:42:00","inspection_id":"87847260","insp_violation_id":"274256402","seq_no":"1","part_no":"392","part_no_section":"2-SLLTR","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-05-16T13:13:04.000000Z","updated_at":"2026-05-25T09:43:26.000000Z","normalized_code":"3922SLLTR"}],"inspection_per_units":[{"id":20701961,"change_date":"2026-05-14 21:42:00","inspection_id":"87847260","insp_unit_id":"213550832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"X92786","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW167R7900300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:49.000000Z","updated_at":"2026-05-25T09:03:45.000000Z"}]},{"id":11901918,"change_date":"2026-05-14 21:41:00","inspection_id":"87840713","dot_number":"668842","report_state":"CT","report_number":"3013004878","insp_date":"2026-05-14 00:00:00","insp_start_time":"0949","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRANITE CITY ELECTRIC","shipping_paper_number":"S010955557.002","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-14 21:41: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":"772837","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-05-14 21:41:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-14 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:42.000000Z","updated_at":"2026-05-25T09:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20691876,"change_date":"2026-05-14 21:41:00","inspection_id":"87840713","insp_unit_id":"213537406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"708398","insp_unit_license":"3560639","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC2RDUW1046","insp_unit_decal":"Y","insp_unit_decal_number":"36429889","created_at":"2026-05-16T12:44:35.000000Z","updated_at":"2026-05-25T09:02:26.000000Z"}]},{"id":11969026,"change_date":"2026-05-20 21:40:00","inspection_id":"87905646","dot_number":"668842","report_state":"RI","report_number":"0145000776","insp_date":"2026-05-14 00:00:00","insp_start_time":"1000","insp_end_time":"1051","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RICHMOND RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KM KELLY INC","shipping_paper_number":"S010956669","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-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3365067","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-05-20 21:40:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:47.000000Z","updated_at":"2026-06-01T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20810177,"change_date":"2026-05-20 21:40:00","inspection_id":"87905646","insp_unit_id":"213657344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"296414","insp_unit_license":"2726B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN7ML069200","insp_unit_decal":"Y","insp_unit_decal_number":"36455370","created_at":"2026-05-23T09:20:10.000000Z","updated_at":"2026-06-01T09:02:01.000000Z"}]},{"id":11948004,"change_date":"2026-05-18 21:39:00","inspection_id":"87883498","dot_number":"668842","report_state":"RI","report_number":"0212000112","insp_date":"2026-05-12 00:00:00","insp_start_time":"1157","insp_end_time":"1229","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RICHMOND RI","county_code_state":"RI","county_code":"009","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":"U","pen_cen_match":"I","final_status_date":"2026-05-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"3351708","transaction_code":"A","transaction_date":"2026-05-17 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-05-18 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-18 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:04.000000Z","updated_at":"2026-05-29T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20775938,"change_date":"2026-05-18 21:39:00","inspection_id":"87883498","insp_unit_id":"213614977","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"W76429","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW160N7901346","insp_unit_decal":"Y","insp_unit_decal_number":"36455377","created_at":"2026-05-21T09:20:20.000000Z","updated_at":"2026-05-29T09:02:23.000000Z"}]},{"id":11768173,"change_date":"2026-04-28 21:39:00","inspection_id":"87698808","dot_number":"668842","report_state":"NH","report_number":"1201000323","insp_date":"2026-04-20 00:00:00","insp_start_time":"1057","insp_end_time":"1123","registration_date":"2026-04-21 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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":"U","pen_cen_match":"I","final_status_date":"2026-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"3224398","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-04-28 21:39:00","snet_input_date":"2026-04-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-28 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:25.000000Z","updated_at":"2026-05-09T09:30:47.000000Z","inspection_violations":[{"id":20462631,"change_date":"2026-04-28 21:39:00","inspection_id":"87698808","insp_violation_id":"273901560","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213264315","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:01:48.000000Z","updated_at":"2026-05-09T09:41:31.000000Z","normalized_code":"3939ALIL"},{"id":20462632,"change_date":"2026-04-28 21:39:00","inspection_id":"87698808","insp_violation_id":"273901561","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213264315","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:01:48.000000Z","updated_at":"2026-05-09T09:41:31.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20473584,"change_date":"2026-04-28 21:39:00","inspection_id":"87698808","insp_unit_id":"213264315","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"458131","insp_unit_license":"X70247","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW165P7900471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:27.000000Z","updated_at":"2026-05-09T09:03:07.000000Z"}]},{"id":11629588,"change_date":"2026-04-13 21:37:00","inspection_id":"87558184","dot_number":"668842","report_state":"NY","report_number":"D103101584","insp_date":"2026-04-09 00:00:00","insp_start_time":"0836","insp_end_time":"0915","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","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":"U","pen_cen_match":"I","final_status_date":"2026-04-13 21:37: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":"3150494","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-04-13 21:37:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-13 21:37:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-24T09:30:36.000000Z","updated_at":"2026-04-24T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20227317,"change_date":"2026-04-13 21:37:00","inspection_id":"87558184","insp_unit_id":"212981208","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"16208NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAL8SS460795","insp_unit_decal":"Y","insp_unit_decal_number":"36368017","created_at":"2026-04-24T09:03:01.000000Z","updated_at":"2026-04-24T09:03:01.000000Z"}]},{"id":11475401,"change_date":"2026-03-25 21:40:00","inspection_id":"87394306","dot_number":"668842","report_state":"MA","report_number":"DA00004443","insp_date":"2026-03-25 00:00:00","insp_start_time":"1240","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"044H","location_desc":"H-BRAINTREE","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-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"542750","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:46.000000Z","updated_at":"2026-04-05T09:32:00.000000Z","inspection_violations":[{"id":19372065,"change_date":"2026-03-25 21:40:00","inspection_id":"87394306","insp_violation_id":"272633529","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:11:51.000000Z","updated_at":"2026-04-05T10:01:06.000000Z","normalized_code":"39021TE2IVD"},{"id":19372066,"change_date":"2026-03-25 21:40:00","inspection_id":"87394306","insp_violation_id":"272633530","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"212330289","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:11:51.000000Z","updated_at":"2026-04-05T10:01:06.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":19656352,"change_date":"2026-03-25 21:40:00","inspection_id":"87394306","insp_unit_id":"212330289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"48441","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"JALCDW163M7005387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:22:57.000000Z","updated_at":"2026-04-05T09:17:18.000000Z"}]},{"id":12148696,"change_date":"2026-06-10 21:44:00","inspection_id":"88097625","dot_number":"668842","report_state":"NH","report_number":"1112000002","insp_date":"2026-01-15 00:00:00","insp_start_time":"1018","insp_end_time":"1045","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"3509781","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:29.000000Z","updated_at":"2026-06-21T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21105021,"change_date":"2026-06-10 21:44:00","inspection_id":"88097625","insp_unit_id":"214016342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"561132","insp_unit_license":"Y69629","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW167N7901165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:55.000000Z","updated_at":"2026-06-21T09:02:19.000000Z"}]},{"id":10452897,"change_date":"2025-12-17 21:38:00","inspection_id":"86585493","dot_number":"668842","report_state":"CT","report_number":"0532000059","insp_date":"2025-12-17 00:00:00","insp_start_time":"0815","insp_end_time":"0849","registration_date":null,"region":"ET","ci_status_code":"C","location":"100","location_desc":"NORTH CANAAN","county_code_state":"CT","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MONTEREY MECHANICAL","shipping_paper_number":"M000241601","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"760995","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-12-17 21:38:00","snet_input_date":"2025-12-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-17 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:17.000000Z","updated_at":"2025-12-28T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17491962,"change_date":"2025-12-17 21:38:00","inspection_id":"86585493","insp_unit_id":"210646976","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"503050","insp_unit_license":"7049B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN7ML239801","insp_unit_decal":"Y","insp_unit_decal_number":"35803692","created_at":"2025-12-20T10:01:37.000000Z","updated_at":"2025-12-28T10:00:09.000000Z"}]},{"id":10491419,"change_date":"2025-12-22 21:38:00","inspection_id":"86625851","dot_number":"668842","report_state":"NY","report_number":"SPG3090607","insp_date":"2025-12-15 00:00:00","insp_start_time":"1122","insp_end_time":"1143","registration_date":null,"region":"ES","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-12-22 21:38: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":"2687427","transaction_code":"A","transaction_date":"2025-12-21 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-22 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:37.000000Z","updated_at":"2026-01-02T10:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17567312,"change_date":"2025-12-22 21:38:00","inspection_id":"86625851","insp_unit_id":"210743395","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"16208NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAL8SS460795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:36.000000Z","updated_at":"2026-01-02T10:00:19.000000Z"}]},{"id":10408393,"change_date":"2025-12-11 21:44:00","inspection_id":"86539006","dot_number":"668842","report_state":"NY","report_number":"D102601210","insp_date":"2025-12-10 00:00:00","insp_start_time":"1025","insp_end_time":"1032","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","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":"2025-12-11 21:44: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":"2644943","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-12-11 21:44:00","snet_input_date":"2025-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-11 21:44:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:45.000000Z","updated_at":"2025-12-15T10:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17407032,"change_date":"2025-12-11 21:44:00","inspection_id":"86539006","insp_unit_id":"210547875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"16208NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAL8SS460795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:59.000000Z","updated_at":"2025-12-15T10:01:17.000000Z"}]},{"id":10375757,"change_date":"2025-12-08 21:38:00","inspection_id":"86504874","dot_number":"668842","report_state":"MA","report_number":"ED00000625","insp_date":"2025-12-03 00:00:00","insp_start_time":"2218","insp_end_time":"2231","registration_date":null,"region":"ET","ci_status_code":"C","location":"270H","location_desc":"H-RAYNHAM","county_code_state":"MA","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"535183","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:29.000000Z","updated_at":"2025-12-12T10:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17343987,"change_date":"2025-12-08 21:38:00","inspection_id":"86504874","insp_unit_id":"210469117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"W94687","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW164N7901348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:28.000000Z","updated_at":"2025-12-12T10:00:36.000000Z"}]},{"id":10233717,"change_date":"2025-11-19 21:38:00","inspection_id":"86356008","dot_number":"668842","report_state":"CT","report_number":"3120005706","insp_date":"2025-11-19 00:00:00","insp_start_time":"0651","insp_end_time":"0718","registration_date":null,"region":"ET","ci_status_code":"C","location":"047","location_desc":"EAST WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRANITE CITY ELECTRIC","shipping_paper_number":"S010670329.005","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-11-19 21:38: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":"758182","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-11-19 21:38:00","snet_input_date":"2025-11-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-19 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-23T10:31:20.000000Z","updated_at":"2025-11-23T10:31:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17054659,"change_date":"2025-11-19 21:38:00","inspection_id":"86356008","insp_unit_id":"210110655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"769647","insp_unit_license":"Y27749","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUTAL7SS481198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:39.000000Z","updated_at":"2025-11-23T10:01:39.000000Z"}]},{"id":10012755,"change_date":"2025-10-23 21:38:00","inspection_id":"86123528","dot_number":"668842","report_state":"CT","report_number":"0104000110","insp_date":"2025-10-23 00:00:00","insp_start_time":"1025","insp_end_time":"1051","registration_date":null,"region":"ET","ci_status_code":"C","location":"086N","location_desc":"TROOP E - MONTVILLE","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRANITE CITY","shipping_paper_number":"M000239305","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:38: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":"755888","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-10-23 21:38:00","snet_input_date":"2025-10-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-23 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:36.000000Z","updated_at":"2025-10-27T10:00:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16631561,"change_date":"2025-10-23 21:38:00","inspection_id":"86123528","insp_unit_id":"209609714","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"769647","insp_unit_license":"Y27749","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUTAL7SS481198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:00.000000Z","updated_at":"2025-10-27T09:45:06.000000Z"}]},{"id":9886727,"change_date":"2025-10-08 21:40:00","inspection_id":"85990500","dot_number":"668842","report_state":"MA","report_number":"CY00003909","insp_date":"2025-10-07 00:00:00","insp_start_time":"2337","insp_end_time":"2348","registration_date":null,"region":"ET","ci_status_code":"C","location":"331H","location_desc":"H-TEWKSBURY","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"530823","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:46.000000Z","updated_at":"2025-10-12T10:00:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16403987,"change_date":"2025-10-08 21:40:00","inspection_id":"85990500","insp_unit_id":"209361933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"543058","insp_unit_license":"3212924","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC9NDNH9150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:12.000000Z","updated_at":"2025-10-12T09:46:07.000000Z"}]},{"id":9835474,"change_date":"2025-10-02 21:42:00","inspection_id":"85936584","dot_number":"668842","report_state":"MA","report_number":"DR00001835","insp_date":"2025-10-01 00:00:00","insp_start_time":"1813","insp_end_time":"1824","registration_date":"2025-10-02 00:00:00","region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","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-02 21:42: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":"530242","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-10-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:01:51.000000Z","updated_at":"2025-10-05T10:01:51.000000Z","inspection_violations":[{"id":16197113,"change_date":"2025-10-02 21:42:00","inspection_id":"85936584","insp_violation_id":"269052094","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-10-05T10:17:34.000000Z","updated_at":"2025-10-05T10:17:34.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16309986,"change_date":"2025-10-02 21:42:00","inspection_id":"85936584","insp_unit_id":"209257429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"815666","insp_unit_license":"AU45276","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC9KDKF9094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:56.000000Z","updated_at":"2025-10-05T09:46:56.000000Z"}]},{"id":9653125,"change_date":"2025-09-11 21:41:00","inspection_id":"85746877","dot_number":"668842","report_state":"MA","report_number":"CW00004006","insp_date":"2025-09-09 00:00:00","insp_start_time":"2116","insp_end_time":"2135","registration_date":null,"region":"ET","ci_status_code":"C","location":"366H","location_desc":"H-WESTFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"M000237323","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-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"528318","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:57.000000Z","updated_at":"2025-09-16T10:46:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15951937,"change_date":"2025-09-11 21:41:00","inspection_id":"85746877","insp_unit_id":"208872973","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"727081","insp_unit_license":"1AJ79N","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUTAN8SS355661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:37.000000Z","updated_at":"2025-09-15T09:53:17.000000Z"}]},{"id":9603064,"change_date":"2025-09-09 21:40:00","inspection_id":"85692989","dot_number":"668842","report_state":"MA","report_number":"CU00003721","insp_date":"2025-09-04 00:00:00","insp_start_time":"2237","insp_end_time":"2301","registration_date":"2025-09-09 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-09-05 21:39: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":"527936","transaction_code":"C","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:46.000000Z","updated_at":"2025-09-13T10:46:23.000000Z","inspection_violations":[{"id":15749063,"change_date":"2025-09-09 21:40:00","inspection_id":"85692989","insp_violation_id":"268549408","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-09-12T10:51:10.000000Z","updated_at":"2025-09-13T10:48:40.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":15903508,"change_date":"2025-09-09 21:40:00","inspection_id":"85692989","insp_unit_id":"208823846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"763252","insp_unit_license":"Y21870","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL5SL475861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:41.000000Z","updated_at":"2025-09-13T09:59:06.000000Z"}]},{"id":9454365,"change_date":"2025-08-20 21:39:00","inspection_id":"85536755","dot_number":"668842","report_state":"CT","report_number":"3129006088","insp_date":"2025-08-20 00:00:00","insp_start_time":"0755","insp_end_time":"0811","registration_date":null,"region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","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":"2025-08-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"749566","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-08-20 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-20 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:42.000000Z","updated_at":"2025-08-25T10:41:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15590658,"change_date":"2025-08-20 21:39:00","inspection_id":"85536755","insp_unit_id":"208479684","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"727081","insp_unit_license":"1AJ79N","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUTAN8SS355661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:34.000000Z","updated_at":"2025-08-24T09:45:09.000000Z"}]},{"id":9373969,"change_date":"2025-08-14 21:39:00","inspection_id":"85452080","dot_number":"668842","report_state":"CT","report_number":"0773000131","insp_date":"2025-08-11 00:00:00","insp_start_time":"0953","insp_end_time":"1022","registration_date":"2025-08-14 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"INTERSTATE 84 EXIT 40","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CTEC SOLAR","shipping_paper_number":"M00236035","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-08-11 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"748471","transaction_code":"C","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-08-11 21:37:00","snet_input_date":"2025-08-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-11 21:37:00","insp_carrier_name":"GRANITE CITY ELECTRIC SUPPLY","insp_carrier_street":"19 QUINCY AVE","insp_carrier_city":"MILFORD","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:17.000000Z","updated_at":"2025-08-20T10:43:26.000000Z","inspection_violations":[{"id":15298329,"change_date":"2025-08-14 21:39:00","inspection_id":"85452080","insp_violation_id":"268015887","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208387519","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:44:57.000000Z","updated_at":"2025-08-18T10:43:02.000000Z","normalized_code":"39347E"},{"id":15298330,"change_date":"2025-08-14 21:39:00","inspection_id":"85452080","insp_violation_id":"268015888","seq_no":"2","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"208387519","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:44:57.000000Z","updated_at":"2025-08-18T10:43:02.000000Z","normalized_code":"39311A1LBL"}],"inspection_per_units":[{"id":15504368,"change_date":"2025-08-14 21:39:00","inspection_id":"85452080","insp_unit_id":"208387519","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"503048","insp_unit_license":"7048B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN5ML239800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:19.000000Z","updated_at":"2025-08-18T09:45:06.000000Z"}]},{"id":9320903,"change_date":"2025-08-12 21:39:00","inspection_id":"85396381","dot_number":"668842","report_state":"MA","report_number":"DY00000741","insp_date":"2025-08-01 00:00:00","insp_start_time":"2100","insp_end_time":"2118","registration_date":"2025-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"064H","location_desc":"H-CHARLTON","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF\/SAME","shipping_paper_number":"M000235696","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-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"524729","transaction_code":"C","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:48.000000Z","updated_at":"2025-08-16T10:00:07.000000Z","inspection_violations":[{"id":15252513,"change_date":"2025-08-12 21:39:00","inspection_id":"85396381","insp_violation_id":"267973351","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208351362","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-08-15T10:45:27.000000Z","updated_at":"2025-08-16T10:42:53.000000Z","normalized_code":"3922SLLSR"},{"id":15252514,"change_date":"2025-08-12 21:39:00","inspection_id":"85396381","insp_violation_id":"267973352","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208351362","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-08-15T10:45:27.000000Z","updated_at":"2025-08-16T10:42:53.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15463089,"change_date":"2025-08-12 21:39:00","inspection_id":"85396381","insp_unit_id":"208351362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"48J8","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2538GG700902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:08.000000Z"},{"id":15463090,"change_date":"2025-08-12 21:39:00","inspection_id":"85396381","insp_unit_id":"208351363","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"292946","insp_unit_license":"1902B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJHLDV4LSMD3188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:08.000000Z"}]},{"id":10079008,"change_date":"2025-10-30 21:42:00","inspection_id":"86193436","dot_number":"668842","report_state":"NH","report_number":"1305000055","insp_date":"2025-06-19 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRANITE CITY ELECTRIC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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":"U","pen_cen_match":"I","final_status_date":"2025-10-30 21:42: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":"2481637","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:13.000000Z","updated_at":"2025-11-03T11:01:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16754381,"change_date":"2025-10-30 21:42:00","inspection_id":"86193436","insp_unit_id":"209741293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"763253","insp_unit_license":"Y32880","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL7SL475862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:07.000000Z"}]},{"id":8820332,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","dot_number":"668842","report_state":"CT","report_number":"3029003095","insp_date":"2025-06-05 00:00:00","insp_start_time":"0551","insp_end_time":"0711","registration_date":null,"region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CHICOPEE GRANITE CITY ELECTRIC","shipping_paper_number":"S010373760.001","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-06-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"742192","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-06-05 21:40:00","snet_input_date":"2025-06-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-05 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:00:54.000000Z","updated_at":"2025-06-09T10:00:54.000000Z","inspection_violations":[{"id":14115868,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","insp_violation_id":"266670670","seq_no":"4","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"1","insp_unit_id":"207232389","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V134171-4","created_at":"2025-06-08T10:16:39.000000Z","updated_at":"2025-06-09T10:15:06.000000Z","normalized_code":"39348ABISA"},{"id":14115869,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","insp_violation_id":"266670671","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207232389","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-08T10:16:39.000000Z","updated_at":"2025-06-09T10:15:06.000000Z","normalized_code":"3963A1BOS"},{"id":14115870,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","insp_violation_id":"266670672","seq_no":"1","part_no":"393","part_no_section":"102C2-C","insp_viol_unit":"1","insp_unit_id":"207232389","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:39.000000Z","updated_at":"2025-06-09T10:15:06.000000Z","normalized_code":"393102C2C"},{"id":14115871,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","insp_violation_id":"266670673","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207232389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:39.000000Z","updated_at":"2025-06-09T10:15:06.000000Z","normalized_code":"39353BB"},{"id":14115872,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","insp_violation_id":"266670674","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207232389","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:39.000000Z","updated_at":"2025-06-09T10:15:06.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":14439011,"change_date":"2025-06-05 21:40:00","inspection_id":"84868147","insp_unit_id":"207232389","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"503048","insp_unit_license":"7048B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN5ML239800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:19.000000Z","updated_at":"2025-06-09T09:45:05.000000Z"}]},{"id":8712442,"change_date":"2025-05-29 21:41:00","inspection_id":"84753995","dot_number":"668842","report_state":"MA","report_number":"CT00003383","insp_date":"2025-05-22 00:00:00","insp_start_time":"0947","insp_end_time":"0956","registration_date":"2025-05-29 00:00:00","region":"ET","ci_status_code":"C","location":"059S","location_desc":"S-CARVER","county_code_state":"MA","county_code":"023","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-05-22 21:41: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":"518587","transaction_code":"C","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2025-05-22 21:41:00","snet_input_date":"2025-05-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-22 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-25T10:05:10.000000Z","updated_at":"2025-06-04T10:00:08.000000Z","inspection_violations":[{"id":13997950,"change_date":"2025-05-29 21:41:00","inspection_id":"84753995","insp_violation_id":"266545493","seq_no":"1","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":"2025-06-01T10:17:21.000000Z","updated_at":"2025-06-02T10:16:45.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14333755,"change_date":"2025-05-29 21:41:00","inspection_id":"84753995","insp_unit_id":"207126689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"763250","insp_unit_license":"Y21868","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL7SL475859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:38.000000Z","updated_at":"2025-06-02T09:45:08.000000Z"}]},{"id":8657889,"change_date":"2025-05-27 21:38:00","inspection_id":"84696327","dot_number":"668842","report_state":"MA","report_number":"CR00003700","insp_date":"2025-05-15 00:00:00","insp_start_time":"2022","insp_end_time":"2035","registration_date":"2025-05-27 00:00:00","region":"ET","ci_status_code":"C","location":"086H","location_desc":"H-DEERFIELD","county_code_state":"MA","county_code":"011","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-05-16 21:42: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":"517858","transaction_code":"C","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2025-05-16 21:42:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-16 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:10.000000Z","updated_at":"2025-05-31T10:00:05.000000Z","inspection_violations":[{"id":13944245,"change_date":"2025-05-27 21:38:00","inspection_id":"84696327","insp_violation_id":"266482124","seq_no":"1","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":"2025-05-30T10:15:31.000000Z","updated_at":"2025-05-31T10:16:39.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14285194,"change_date":"2025-05-27 21:38:00","inspection_id":"84696327","insp_unit_id":"207071998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9440A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN0ML069183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:26.000000Z","updated_at":"2025-05-31T09:46:36.000000Z"}]},{"id":8201199,"change_date":"2025-03-25 21:35:00","inspection_id":"84215556","dot_number":"668842","report_state":"CT","report_number":"3031A00313","insp_date":"2025-03-24 00:00:00","insp_start_time":"0711","insp_end_time":"0724","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"M000229974","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-03-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"735661","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-03-25 21:35:00","snet_input_date":"2025-03-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-25 21:35:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:51.000000Z","updated_at":"2025-03-29T10:19:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13259518,"change_date":"2025-03-25 21:35:00","inspection_id":"84215556","insp_unit_id":"205971398","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"727081","insp_unit_license":"1AJ79N","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUTAN8SS355661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:05:13.000000Z","updated_at":"2025-03-29T09:58:16.000000Z"}]},{"id":8089779,"change_date":"2025-03-12 21:39:00","inspection_id":"84098183","dot_number":"668842","report_state":"CT","report_number":"158A000036","insp_date":"2025-03-12 00:00:00","insp_start_time":"1103","insp_end_time":"1148","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","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-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"734657","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-03-12 21:39:00","snet_input_date":"2025-03-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-12 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:17.000000Z","updated_at":"2025-03-17T21:06:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13061512,"change_date":"2025-03-12 21:39:00","inspection_id":"84098183","insp_unit_id":"205747012","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"503048","insp_unit_license":"7048B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN5ML239800","insp_unit_decal":"Y","insp_unit_decal_number":"34981919","created_at":"2025-03-17T23:59:24.000000Z","updated_at":"2025-03-17T23:59:24.000000Z"}]},{"id":8028054,"change_date":"2025-03-05 21:39:00","inspection_id":"84033241","dot_number":"668842","report_state":"NY","report_number":"1L47000020","insp_date":"2025-03-04 00:00:00","insp_start_time":"1209","insp_end_time":"1305","registration_date":null,"region":"ES","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-03-05 21:39: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1430226","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-03-05 21:39:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-05 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:56.000000Z","updated_at":"2025-03-17T21:04:56.000000Z","inspection_violations":[{"id":12546324,"change_date":"2025-03-05 21:39:00","inspection_id":"84033241","insp_violation_id":"264836823","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"205629226","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:21.000000Z","updated_at":"2025-03-17T22:07:21.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":12960742,"change_date":"2025-03-05 21:39:00","inspection_id":"84033241","insp_unit_id":"205629226","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"2927115","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML5LL847251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:11.000000Z","updated_at":"2025-03-17T23:58:11.000000Z"}]},{"id":7696900,"change_date":"2025-01-28 21:38:00","inspection_id":"83685435","dot_number":"668842","report_state":"CT","report_number":"3010003963","insp_date":"2025-01-24 00:00:00","insp_start_time":"0612","insp_end_time":"0635","registration_date":"2025-01-28 00:00:00","region":"ET","ci_status_code":"C","location":"047","location_desc":"EAST WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"M000227601","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":"2025-01-24 21:39: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":"730528","transaction_code":"C","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2025-01-24 21:39:00","snet_input_date":"2025-01-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-24 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:56.000000Z","updated_at":"2025-03-17T20:57:56.000000Z","inspection_violations":[{"id":12025913,"change_date":"2025-01-28 21:38:00","inspection_id":"83685435","insp_violation_id":"264203232","seq_no":"1","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":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12420135,"change_date":"2025-01-28 21:38:00","inspection_id":"83685435","insp_unit_id":"205032152","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"503048","insp_unit_license":"7048B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN5ML239800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"}]},{"id":7091400,"change_date":"2024-11-13 21:39:00","inspection_id":"83047751","dot_number":"668842","report_state":"MA","report_number":"CY00002724","insp_date":"2024-10-31 00:00:00","insp_start_time":"0730","insp_end_time":"0742","registration_date":"2024-11-13 00:00:00","region":"ET","ci_status_code":"C","location":"066H","location_desc":"H-CHELMSFORD","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"502579","transaction_code":"C","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-10-31 21:42:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-10-31 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:52.000000Z","updated_at":"2025-03-17T20:43:52.000000Z","inspection_violations":[{"id":11073407,"change_date":"2024-11-13 21:39:00","inspection_id":"83047751","insp_violation_id":"262870250","seq_no":"1","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-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":11437095,"change_date":"2024-11-13 21:39:00","inspection_id":"83047751","insp_unit_id":"203858960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"561132","insp_unit_license":"5154072","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"JALEEW167N7901165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:26.000000Z","updated_at":"2025-03-17T23:41:26.000000Z"}]},{"id":7140068,"change_date":"2024-11-07 21:40:00","inspection_id":"83099300","dot_number":"668842","report_state":"NY","report_number":"SPG3010165","insp_date":"2024-10-31 00:00:00","insp_start_time":"1201","insp_end_time":"1216","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRANITE CITY","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":"2024-11-07 21:40: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":"1027232","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-11-07 21:40:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-07 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:04.000000Z","updated_at":"2025-03-17T20:45:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11515883,"change_date":"2024-11-07 21:40:00","inspection_id":"83099300","insp_unit_id":"203773497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"2927115","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML5LL847251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:20.000000Z","updated_at":"2025-03-17T23:42:20.000000Z"}]},{"id":6997085,"change_date":"2024-10-21 21:40:00","inspection_id":"82947751","dot_number":"668842","report_state":"CT","report_number":"3119002128","insp_date":"2024-10-19 00:00:00","insp_start_time":"0554","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"720976","transaction_code":"A","transaction_date":"2024-10-19 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-10-21 21:40:00","snet_input_date":"2024-10-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-21 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:50.000000Z","updated_at":"2025-03-17T20:41:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11286042,"change_date":"2024-10-21 21:40:00","inspection_id":"82947751","insp_unit_id":"203489225","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"296413","insp_unit_license":"9440A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUTAN0ML069183","insp_unit_decal":"Y","insp_unit_decal_number":"34681889","created_at":"2025-03-17T23:39:52.000000Z","updated_at":"2025-03-17T23:39:52.000000Z"}]},{"id":6930701,"change_date":"2024-10-10 21:41:00","inspection_id":"82877146","dot_number":"668842","report_state":"MA","report_number":"CW00003258","insp_date":"2024-10-08 00:00:00","insp_start_time":"2025","insp_end_time":"2040","registration_date":null,"region":"ET","ci_status_code":"C","location":"141H","location_desc":"H-HATFIELD","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"S010025832","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":"2024-10-10 21:41: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":"501242","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-10-10 21:41:00","snet_input_date":"2024-10-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-10-10 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:39.000000Z","updated_at":"2025-03-17T20:40:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11177801,"change_date":"2024-10-10 21:41:00","inspection_id":"82877146","insp_unit_id":"203353114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"Y20117","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC5RDVF8558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:45.000000Z","updated_at":"2025-03-17T23:38:45.000000Z"}]},{"id":6687946,"change_date":"2024-09-12 21:41:00","inspection_id":"82618811","dot_number":"668842","report_state":"MA","report_number":"CY00002492","insp_date":"2024-09-09 00:00:00","insp_start_time":"2311","insp_end_time":"2324","registration_date":"2024-09-12 00:00:00","region":"ET","ci_status_code":"C","location":"066H","location_desc":"H-CHELMSFORD","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S009958667.003","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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"499191","transaction_code":"C","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:39.000000Z","updated_at":"2025-03-17T20:35:39.000000Z","inspection_violations":[{"id":10409958,"change_date":"2024-09-12 21:41:00","inspection_id":"82618811","insp_violation_id":"261762212","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":10783671,"change_date":"2024-09-12 21:41:00","inspection_id":"82618811","insp_unit_id":"202888745","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"458131","insp_unit_license":"X70247","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW165P7900471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:38.000000Z","updated_at":"2025-03-17T23:34:38.000000Z"}]},{"id":6618906,"change_date":"2024-09-01 21:32:00","inspection_id":"82545333","dot_number":"668842","report_state":"RI","report_number":"M024000019","insp_date":"2024-08-26 00:00:00","insp_start_time":"0745","insp_end_time":"0816","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":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2024-09-01 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"803700","transaction_code":"A","transaction_date":"2024-09-01 00:00:00","upload_date":"2024-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-09-01 21:32:00","snet_input_date":"2024-08-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-01 21:32:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:07.000000Z","updated_at":"2025-03-17T20:34:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10671338,"change_date":"2024-09-01 21:32:00","inspection_id":"82545333","insp_unit_id":"202701450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"1NI875","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"JALE5W169J7901047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:31.000000Z","updated_at":"2025-03-17T23:33:31.000000Z"}]},{"id":6498027,"change_date":"2024-08-19 21:41:00","inspection_id":"82416586","dot_number":"668842","report_state":"NY","report_number":"D103100691","insp_date":"2024-08-16 00:00:00","insp_start_time":"1025","insp_end_time":"1049","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2024-08-19 21:41: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":"754722","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-03-17T20:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10474533,"change_date":"2024-08-19 21:41:00","inspection_id":"82416586","insp_unit_id":"202453677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"40410NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:30.000000Z","updated_at":"2025-03-17T23:31:30.000000Z"}]},{"id":6383701,"change_date":"2024-09-11 21:40:00","inspection_id":"82294400","dot_number":"668842","report_state":"CT","report_number":"3079002915","insp_date":"2024-08-05 00:00:00","insp_start_time":"0618","insp_end_time":"0629","registration_date":"2024-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"051","location_desc":"FAIRFIELD","county_code_state":"CT","county_code":"001","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":"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-08-05 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":"714465","transaction_code":"C","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-08-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":9908088,"change_date":"2024-09-11 21:40:00","inspection_id":"82294400","insp_violation_id":"261727613","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:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10287543,"change_date":"2024-09-11 21:40:00","inspection_id":"82294400","insp_unit_id":"202857705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"7049B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN7ML239801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"}]},{"id":6344868,"change_date":"2024-07-30 21:43:00","inspection_id":"82252747","dot_number":"668842","report_state":"MA","report_number":"CY00002377","insp_date":"2024-07-29 00:00:00","insp_start_time":"2245","insp_end_time":"2300","registration_date":null,"region":"ET","ci_status_code":"C","location":"177H","location_desc":"H-LOWELL","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-30 21:43: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":"496782","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-07-30 21:43:00","snet_input_date":"2024-07-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:39.000000Z","updated_at":"2025-03-17T20:28:39.000000Z","inspection_violations":[{"id":9851350,"change_date":"2024-07-30 21:43:00","inspection_id":"82252747","insp_violation_id":"260914655","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:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10224371,"change_date":"2024-07-30 21:43:00","inspection_id":"82252747","insp_unit_id":"202141785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"7048B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN5ML239800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:54.000000Z","updated_at":"2025-03-17T23:28:54.000000Z"}]},{"id":6296686,"change_date":"2024-07-24 21:41:00","inspection_id":"82201325","dot_number":"668842","report_state":"VT","report_number":"51A0000691","insp_date":"2024-07-19 00:00:00","insp_start_time":"0859","insp_end_time":"0918","registration_date":null,"region":"ET","ci_status_code":"C","location":"0202EB","location_desc":"BENNINGTON BYPASS","county_code_state":"VT","county_code":"003","insp_level_id":"2","service_center":"EA","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-07-24 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":"207971","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-07-24 21:41:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-07-24 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:26.000000Z","updated_at":"2025-03-17T20:27:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10145700,"change_date":"2024-07-24 21:41:00","inspection_id":"82201325","insp_unit_id":"202044093","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"246085","insp_unit_license":"91900MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALCDW162L7009641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:07.000000Z","updated_at":"2025-03-17T23:28:07.000000Z"}]},{"id":6246374,"change_date":"2024-07-18 21:40:00","inspection_id":"82147484","dot_number":"668842","report_state":"US","report_number":"1923000012","insp_date":"2024-07-18 00:00:00","insp_start_time":"0909","insp_end_time":"0936","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ROWLEY MA","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"S009891413","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":"2024-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"665410","transaction_code":"A","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:36.000000Z","updated_at":"2025-03-17T20:26:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10064508,"change_date":"2024-07-18 21:40:00","inspection_id":"82147484","insp_unit_id":"201942434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"X70241","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW162P7900475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:15.000000Z","updated_at":"2025-03-17T23:27:15.000000Z"}]},{"id":6070074,"change_date":"2024-07-11 21:41:00","inspection_id":"81958036","dot_number":"668842","report_state":"MA","report_number":"DR00000904","insp_date":"2024-06-25 00:00:00","insp_start_time":"0505","insp_end_time":"0513","registration_date":"2024-07-11 00:00:00","region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","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-06-25 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":"494699","transaction_code":"C","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-06-25 21:41:00","snet_input_date":"2024-06-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-25 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:59.000000Z","updated_at":"2025-03-17T20:22:59.000000Z","inspection_violations":[{"id":9418412,"change_date":"2024-07-11 21:41:00","inspection_id":"81958036","insp_violation_id":"260584878","seq_no":"1","part_no":"392","part_no_section":"2","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-17T21:51:33.000000Z","updated_at":"2025-03-17T21:51:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9776788,"change_date":"2024-07-11 21:41:00","inspection_id":"81958036","insp_unit_id":"201834530","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"296413","insp_unit_license":"9440A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN0ML069183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"}]},{"id":6016033,"change_date":"2024-06-18 21:42:00","inspection_id":"81899753","dot_number":"668842","report_state":"MA","report_number":"CP00004315","insp_date":"2024-06-18 00:00:00","insp_start_time":"1104","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"165H","location_desc":"H-LANCASTER","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":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-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"494176","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-06-18 21:42:00","snet_input_date":"2024-06-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-18 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:54.000000Z","updated_at":"2025-03-17T20:21:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9689744,"change_date":"2024-06-18 21:42:00","inspection_id":"81899753","insp_unit_id":"201463145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"X71259","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW16XP7900577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:24.000000Z","updated_at":"2025-03-17T23:23:24.000000Z"}]},{"id":5883833,"change_date":"2024-05-31 21:38:00","inspection_id":"81755962","dot_number":"668842","report_state":"MA","report_number":"CT00002794","insp_date":"2024-05-30 00:00:00","insp_start_time":"2145","insp_end_time":"2159","registration_date":null,"region":"ET","ci_status_code":"C","location":"049H","location_desc":"H-BROCKTON","county_code_state":"MA","county_code":"023","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":"2024-05-31 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"492829","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2024-05-31 21:38:00","snet_input_date":"2024-05-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-31 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9476634,"change_date":"2024-05-31 21:38:00","inspection_id":"81755962","insp_unit_id":"201171035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"555977","insp_unit_license":"W76438","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW168N7901188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5765303,"change_date":"2024-05-16 21:41:00","inspection_id":"81627636","dot_number":"668842","report_state":"NH","report_number":"0945004200","insp_date":"2024-05-15 00:00:00","insp_start_time":"1057","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES SOUTH","county_code_state":"NH","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRANITE CITY ELECTRIC","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"275129","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:04.000000Z","updated_at":"2025-03-17T20:17:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9285828,"change_date":"2024-05-16 21:41:00","inspection_id":"81627636","insp_unit_id":"200926522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"X71259","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW16XP7900577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:27.000000Z","updated_at":"2025-03-17T23:19:27.000000Z"}]},{"id":5430658,"change_date":"2024-04-04 21:41:00","inspection_id":"81263216","dot_number":"668842","report_state":"NY","report_number":"M604500932","insp_date":"2024-04-01 00:00:00","insp_start_time":"1025","insp_end_time":"1105","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"DLC ELECTRIC LLC","shipping_paper_number":"S009712895.001","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":"2024-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"371372","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-04-04 21:41:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-04 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:17.000000Z","updated_at":"2025-03-17T20:10:17.000000Z","inspection_violations":[{"id":8384037,"change_date":"2024-04-04 21:41:00","inspection_id":"81263216","insp_violation_id":"258737308","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200227164","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:36.000000Z","updated_at":"2025-03-17T21:46:36.000000Z","normalized_code":"39347E"},{"id":8384038,"change_date":"2024-04-04 21:41:00","inspection_id":"81263216","insp_violation_id":"258737309","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200227164","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:36.000000Z","updated_at":"2025-03-17T21:46:36.000000Z","normalized_code":"3963A1"},{"id":8384039,"change_date":"2024-04-04 21:41:00","inspection_id":"81263216","insp_violation_id":"258737310","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200227164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:36.000000Z","updated_at":"2025-03-17T21:46:36.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8747651,"change_date":"2024-04-04 21:41:00","inspection_id":"81263216","insp_unit_id":"200227164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"283006","insp_unit_license":"40410NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:21.000000Z","updated_at":"2025-03-17T23:14:21.000000Z"}]},{"id":5050266,"change_date":"2024-02-14 21:42:00","inspection_id":"80848306","dot_number":"668842","report_state":"VT","report_number":"5500002124","insp_date":"2024-02-12 00:00:00","insp_start_time":"0900","insp_end_time":"0931","registration_date":null,"region":"ET","ci_status_code":"C","location":"0203EL","location_desc":"EMERALD LAKE TURN OUT","county_code_state":"VT","county_code":"003","insp_level_id":"1","service_center":"EA","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-02-14 21:42: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":"203741","transaction_code":"A","transaction_date":"2024-02-12 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-12 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:45.000000Z","updated_at":"2025-03-17T20:02:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8129021,"change_date":"2024-02-14 21:42:00","inspection_id":"80848306","insp_unit_id":"199420162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"W76450","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALCDW167N7014790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:38.000000Z","updated_at":"2025-03-17T23:08:38.000000Z"}]},{"id":4430874,"change_date":"2023-12-20 21:41:00","inspection_id":"80169855","dot_number":"668842","report_state":"RI","report_number":"416A000077","insp_date":"2023-11-15 00:00:00","insp_start_time":"1100","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BURRILLVILLE RT 102","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"GRANITE CITY ELECTRIC SUPPLY CO","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"84926","transaction_code":"C","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-11-15 21:41:00","snet_input_date":"2023-11-15 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:43.000000Z","updated_at":"2025-03-17T19:50:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7125402,"change_date":"2023-12-20 21:41:00","inspection_id":"80169855","insp_unit_id":"198591137","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"555976","insp_unit_license":"W94687","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW164N7901348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:50.000000Z","updated_at":"2025-03-17T22:59:50.000000Z"}]},{"id":4358110,"change_date":"2023-11-06 21:41:00","inspection_id":"80089226","dot_number":"668842","report_state":"MA","report_number":"CL00003569","insp_date":"2023-11-03 00:00:00","insp_start_time":"2006","insp_end_time":"2018","registration_date":null,"region":"ET","ci_status_code":"C","location":"366H","location_desc":"H-WESTFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"T001893988","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":"2023-11-06 21:41: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":"477833","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-11-06 21:41:00","snet_input_date":"2023-11-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-06 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:10.000000Z","updated_at":"2025-03-17T19:49:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7009050,"change_date":"2023-11-06 21:41:00","inspection_id":"80089226","insp_unit_id":"197913946","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"543057","insp_unit_license":"3212263","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC2NDNH9149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:49.000000Z","updated_at":"2025-03-17T22:58:49.000000Z"}]},{"id":3896536,"change_date":"2023-09-05 21:40:00","inspection_id":"79577742","dot_number":"668842","report_state":"NY","report_number":"SPG0251233","insp_date":"2023-09-01 00:00:00","insp_start_time":"0843","insp_end_time":"0906","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","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":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2864835","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-09-05 21:40:00","snet_input_date":"2023-09-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6264524,"change_date":"2023-09-05 21:40:00","inspection_id":"79577742","insp_unit_id":"196882898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"283006","insp_unit_license":"368A396","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":3819791,"change_date":"2023-08-24 21:40:00","inspection_id":"79491883","dot_number":"668842","report_state":"NY","report_number":"SPT0482655","insp_date":"2023-08-23 00:00:00","insp_start_time":"0856","insp_end_time":"0912","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","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-08-24 21:40: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":"2861710","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-08-24 21:40:00","snet_input_date":"2023-08-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-24 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:07.000000Z","updated_at":"2025-03-17T19:38:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6141379,"change_date":"2023-08-24 21:40:00","inspection_id":"79491883","insp_unit_id":"196702521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"368A396","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:36.000000Z","updated_at":"2025-03-17T22:51:36.000000Z"}]},{"id":3681685,"change_date":"2023-08-07 21:41:00","inspection_id":"79338050","dot_number":"668842","report_state":"MA","report_number":"DI00000221","insp_date":"2023-08-02 00:00:00","insp_start_time":"2030","insp_end_time":"2049","registration_date":null,"region":"ET","ci_status_code":"C","location":"178H","location_desc":"H-LUDLOW","county_code_state":"MA","county_code":"013","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-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"471565","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-08-07 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-08-07 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:38.000000Z","updated_at":"2025-03-17T19:35:38.000000Z","inspection_violations":[{"id":5677104,"change_date":"2023-08-07 21:41:00","inspection_id":"79338050","insp_violation_id":"254496621","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196388848","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5919363,"change_date":"2023-08-07 21:41:00","inspection_id":"79338050","insp_unit_id":"196388848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3212924","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC9NDNH9150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:45.000000Z","updated_at":"2025-03-17T22:49:45.000000Z"}]},{"id":3586007,"change_date":"2023-07-25 21:40:00","inspection_id":"79230609","dot_number":"668842","report_state":"NY","report_number":"SPWG020853","insp_date":"2023-07-24 00:00:00","insp_start_time":"1040","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2851072","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-07-25 21:40:00","snet_input_date":"2023-07-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-25 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:52.000000Z","updated_at":"2025-03-17T19:33:52.000000Z","inspection_violations":[{"id":5529014,"change_date":"2023-07-25 21:40:00","inspection_id":"79230609","insp_violation_id":"254255157","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196173987","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5765730,"change_date":"2023-07-25 21:40:00","inspection_id":"79230609","insp_unit_id":"196173987","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"815662","insp_unit_license":"3560807","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC1KDKF9090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:31.000000Z","updated_at":"2025-03-17T22:48:31.000000Z"}]},{"id":3383057,"change_date":"2023-09-12 21:39:00","inspection_id":"79002642","dot_number":"668842","report_state":"RI","report_number":"0084001259","insp_date":"2023-06-26 00:00:00","insp_start_time":"1218","insp_end_time":"1222","registration_date":null,"region":"ET","ci_status_code":"C","location":"84","location_desc":"RT 37 WEST","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-06-28 21:42: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":"82937","transaction_code":"C","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-28 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:08.000000Z","updated_at":"2025-03-17T19:30:08.000000Z","inspection_violations":[{"id":5216287,"change_date":"2023-09-12 21:39:00","inspection_id":"79002642","insp_violation_id":"255211338","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":null,"created_at":"2025-03-17T21:31:11.000000Z","updated_at":"2025-03-17T21:31:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5438448,"change_date":"2023-09-12 21:39:00","inspection_id":"79002642","insp_unit_id":"197006666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2726B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAN7ML069200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:54.000000Z","updated_at":"2025-03-17T22:45:54.000000Z"}]},{"id":3280959,"change_date":"2023-06-14 21:41:00","inspection_id":"78887689","dot_number":"668842","report_state":"NY","report_number":"SPWG050846","insp_date":"2023-06-13 00:00:00","insp_start_time":"1206","insp_end_time":"1223","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697","location_desc":"QUEENSBURY","county_code_state":"NY","county_code":"113","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ROZELL INDUSTRIES INC","shipping_paper_number":"LYD3764","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-06-14 21:41: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":"2836047","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-06-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-14 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:06.000000Z","updated_at":"2025-03-17T19:28:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5275207,"change_date":"2023-06-14 21:41:00","inspection_id":"78887689","insp_unit_id":"195487940","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"INTE","insp_unit_company":"283006","insp_unit_license":"368A396","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:36.000000Z","updated_at":"2025-03-17T22:44:36.000000Z"}]},{"id":3245413,"change_date":"2023-06-09 21:40:00","inspection_id":"78847436","dot_number":"668842","report_state":"MA","report_number":"CB00008067","insp_date":"2023-06-09 00:00:00","insp_start_time":"0855","insp_end_time":"0912","registration_date":null,"region":"ET","ci_status_code":"C","location":"268S","location_desc":"S-QUINCY","county_code_state":"MA","county_code":"021","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-06-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"467744","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-06-09 21:40:00","snet_input_date":"2023-06-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[{"id":5003864,"change_date":"2023-06-09 21:40:00","inspection_id":"78847436","insp_violation_id":"253400584","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:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"3922"},{"id":5003865,"change_date":"2023-06-09 21:40:00","inspection_id":"78847436","insp_violation_id":"253400585","seq_no":"2","part_no":"392","part_no_section":"7(a)","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:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"3927A"},{"id":5003866,"change_date":"2023-06-09 21:40:00","inspection_id":"78847436","insp_violation_id":"253400586","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195409404","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5219780,"change_date":"2023-06-09 21:40:00","inspection_id":"78847436","insp_unit_id":"195409404","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"V56156","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALEEW165L7900898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:07.000000Z","updated_at":"2025-03-17T22:44:07.000000Z"}]},{"id":3206397,"change_date":"2023-06-05 21:41:00","inspection_id":"78803542","dot_number":"668842","report_state":"US","report_number":"1888000007","insp_date":"2023-05-17 00:00:00","insp_start_time":"1024","insp_end_time":"1100","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WYOMINGRI","county_code_state":"RI","county_code":"001","insp_level_id":"1","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2023-06-05 21:41: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":"20156","transaction_code":"A","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-06-05 21:41:00","snet_input_date":"2023-05-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-05 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:28.000000Z","updated_at":"2025-03-17T19:26:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5157086,"change_date":"2023-06-05 21:41:00","inspection_id":"78803542","insp_unit_id":"195302576","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"V40388","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL6LL077527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:38.000000Z","updated_at":"2025-03-17T22:43:38.000000Z"}]},{"id":2692258,"change_date":"2023-03-30 21:40:00","inspection_id":"78221894","dot_number":"668842","report_state":"NH","report_number":"1078006588","insp_date":"2023-03-29 00:00:00","insp_start_time":"1110","insp_end_time":"1135","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-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"265183","transaction_code":"A","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-03-30 21:40:00","snet_input_date":"2023-03-29 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-03-30 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[{"id":4135779,"change_date":"2023-03-30 21:40:00","inspection_id":"78221894","insp_violation_id":"251946422","seq_no":"1","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"194135602","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":"39360E"}],"inspection_per_units":[{"id":4334106,"change_date":"2023-03-30 21:40:00","inspection_id":"78221894","insp_unit_id":"194135602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"5154072","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"JALEEW167N7901165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2383914,"change_date":"2023-02-16 21:41:00","inspection_id":"77870672","dot_number":"668842","report_state":"MA","report_number":"CV00001898","insp_date":"2023-02-14 00:00:00","insp_start_time":"2024","insp_end_time":"2036","registration_date":null,"region":"ET","ci_status_code":"C","location":"236H","location_desc":"H-NORTHAMPTON","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRANITE CITY ELECTRIC","shipping_paper_number":"S009087490.001","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-02-16 21:41: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":"460670","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2023-02-16 21:41:00","snet_input_date":"2023-02-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-02-16 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:41.000000Z","updated_at":"2025-03-17T19:10:41.000000Z","inspection_violations":[{"id":3671146,"change_date":"2023-02-16 21:41:00","inspection_id":"77870672","insp_violation_id":"251171063","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":"814741AB","created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3836120,"change_date":"2023-02-16 21:41:00","inspection_id":"77870672","insp_unit_id":"193428755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T26685","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC2JDJP8599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"}]},{"id":2342081,"change_date":"2023-02-10 21:39:00","inspection_id":"77822644","dot_number":"668842","report_state":"CT","report_number":"3016000164","insp_date":"2023-02-08 00:00:00","insp_start_time":"1016","insp_end_time":"1034","registration_date":null,"region":"ET","ci_status_code":"C","location":"138","location_desc":"LORDSHIP\/SURF STRATFORD","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ANGELO DEGRUTTOLO CDI","shipping_paper_number":"S009077439.001","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-02-10 21:39: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":"666013","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-02-10 21:39:00","snet_input_date":"2023-02-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-10 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:56.000000Z","updated_at":"2025-03-17T19:09:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3768784,"change_date":"2023-02-10 21:39:00","inspection_id":"77822644","insp_unit_id":"193330563","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"813910","insp_unit_license":"AB03606","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMML8KH797736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"}]},{"id":2270386,"change_date":"2023-02-15 21:38:00","inspection_id":"77741166","dot_number":"668842","report_state":"NH","report_number":"0850000527","insp_date":"2023-01-30 00:00:00","insp_start_time":"1053","insp_end_time":"1130","registration_date":"2023-02-15 00:00:00","region":"ET","ci_status_code":"C","location":"237","location_desc":"EVERETT TURNPIKE","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRANITE CITY ELECTRIC","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-02-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"263870","transaction_code":"C","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-02-01 21:40:00","snet_input_date":"2023-01-30 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-02-01 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:30.000000Z","updated_at":"2025-03-17T19:08:30.000000Z","inspection_violations":[{"id":3503977,"change_date":"2023-02-15 21:38:00","inspection_id":"77741166","insp_violation_id":"251147873","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193409971","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:34.000000Z","updated_at":"2025-03-17T21:23:34.000000Z","normalized_code":"39021TB"},{"id":3503978,"change_date":"2023-02-15 21:38:00","inspection_id":"77741166","insp_violation_id":"251147874","seq_no":"2","part_no":"376","part_no_section":"11(d)(1)","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:23:34.000000Z","updated_at":"2025-03-17T21:23:34.000000Z","normalized_code":"37611D1"},{"id":3503979,"change_date":"2023-02-15 21:38:00","inspection_id":"77741166","insp_violation_id":"251147875","seq_no":"3","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:23:34.000000Z","updated_at":"2025-03-17T21:23:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3654887,"change_date":"2023-02-15 21:38:00","inspection_id":"77741166","insp_unit_id":"193409971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVY","insp_unit_company":"519862","insp_unit_license":"W56661","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALCDW168M7007099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:11.000000Z","updated_at":"2025-03-17T22:32:11.000000Z"}]},{"id":2148662,"change_date":"2023-01-17 21:41:00","inspection_id":"77602047","dot_number":"668842","report_state":"CT","report_number":"0791000322","insp_date":"2023-01-16 00:00:00","insp_start_time":"1150","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","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-01-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"663825","transaction_code":"A","transaction_date":"2023-01-16 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2023-01-17 21:41:00","snet_input_date":"2023-01-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-01-17 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","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":3322796,"change_date":"2023-01-17 21:41:00","inspection_id":"77602047","insp_violation_id":"250585205","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:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"3922"},{"id":3322797,"change_date":"2023-01-17 21:41:00","inspection_id":"77602047","insp_violation_id":"250585206","seq_no":"2","part_no":"392","part_no_section":"8","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:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":3457827,"change_date":"2023-01-17 21:41:00","inspection_id":"77602047","insp_unit_id":"192884352","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V57326","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL4LL156503","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":1454826,"change_date":"2023-01-30 21:43:00","inspection_id":"76806222","dot_number":"668842","report_state":"RI","report_number":"502C000354","insp_date":"2022-09-26 00:00:00","insp_start_time":"1115","insp_end_time":"1200","registration_date":"2022-11-02 00:00:00","region":"ET","ci_status_code":"C","location":"502","location_desc":"DEVILS FOOT ROAD BRIDGE","county_code_state":"RI","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"78825","transaction_code":"C","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2022-10-06 21:39:00","snet_input_date":"2022-10-03 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-10-06 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:27.000000Z","updated_at":"2025-03-17T18:53:27.000000Z","inspection_violations":[{"id":2291394,"change_date":"2023-01-30 21:43:00","inspection_id":"76806222","insp_violation_id":"250837507","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193118757","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"22502501788","created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3922"},{"id":2291395,"change_date":"2023-01-30 21:43:00","inspection_id":"76806222","insp_violation_id":"250837508","seq_no":"2","part_no":"393","part_no_section":"201(b)","insp_viol_unit":"1","insp_unit_id":"193118757","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"393201B"}],"inspection_per_units":[{"id":2341856,"change_date":"2023-01-30 21:43:00","inspection_id":"76806222","insp_unit_id":"193118757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"273642","insp_unit_license":"V40388","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL6LL077527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"}]},{"id":1154683,"change_date":"2022-09-01 21:40:00","inspection_id":"76458074","dot_number":"668842","report_state":"VT","report_number":"53B0001473","insp_date":"2022-08-23 00:00:00","insp_start_time":"0953","insp_end_time":"1042","registration_date":"2022-08-31 00:00:00","region":"ET","ci_status_code":"C","location":"1307NB","location_desc":"GUILFORD TRUCK CHECK AREA","county_code_state":"VT","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRANITE CITY SUPPLY","shipping_paper_number":"M000190273","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-08-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"193532","transaction_code":"C","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2022-08-29 21:41:00","snet_input_date":"2022-08-23 00:00:00","source_office":"1VTS001","mcmis_add_date":"2022-08-29 21:41:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:57.000000Z","updated_at":"2025-03-17T18:47:57.000000Z","inspection_violations":[{"id":1831132,"change_date":"2022-09-01 21:40:00","inspection_id":"76458074","insp_violation_id":"248153904","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190673518","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1856152,"change_date":"2022-09-01 21:40:00","inspection_id":"76458074","insp_unit_id":"190673518","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"283289","insp_unit_license":"V57326","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL4LL156503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:47.000000Z","updated_at":"2025-03-17T22:19:47.000000Z"}]},{"id":910712,"change_date":"2022-07-28 21:40:00","inspection_id":"76172594","dot_number":"668842","report_state":"NY","report_number":"SPG0223569","insp_date":"2022-07-27 00:00:00","insp_start_time":"1302","insp_end_time":"1327","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"S008783594003","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-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2732110","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2022-07-28 21:40:00","snet_input_date":"2022-07-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:43.000000Z","updated_at":"2025-03-17T18:43:43.000000Z","inspection_violations":[{"id":1436474,"change_date":"2022-07-28 21:40:00","inspection_id":"76172594","insp_violation_id":"247363496","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190006335","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:46.000000Z","updated_at":"2025-03-17T21:13:46.000000Z","normalized_code":"3939A"},{"id":1436475,"change_date":"2022-07-28 21:40:00","inspection_id":"76172594","insp_violation_id":"247363497","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"190006335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:46.000000Z","updated_at":"2025-03-17T21:13:46.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":1465715,"change_date":"2022-07-28 21:40:00","inspection_id":"76172594","insp_unit_id":"190006335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"283006","insp_unit_license":"368A396","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:13.000000Z","updated_at":"2025-03-17T22:17:13.000000Z"}]},{"id":846162,"change_date":"2022-08-04 21:42:00","inspection_id":"76097406","dot_number":"668842","report_state":"NH","report_number":"0896000517","insp_date":"2022-07-18 00:00:00","insp_start_time":"0935","insp_end_time":"0952","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":"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":"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-07-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"258565","transaction_code":"C","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":null,"census_search_date":"2022-07-19 21:39:00","snet_input_date":"2022-07-18 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-19 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:39.000000Z","updated_at":"2025-03-17T18:42:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1361909,"change_date":"2022-08-04 21:42:00","inspection_id":"76097406","insp_unit_id":"190129087","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V57326","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAEUTAL4LL156503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:33.000000Z","updated_at":"2025-03-17T22:16:33.000000Z"}]},{"id":678034,"change_date":"2022-10-20 21:40:00","inspection_id":"75900501","dot_number":"668842","report_state":"RI","report_number":"502A000935","insp_date":"2022-06-23 00:00:00","insp_start_time":"0915","insp_end_time":"0942","registration_date":"2022-10-20 00:00:00","region":"ET","ci_status_code":"C","location":"502","location_desc":"DEVILS FOOT RD","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"77476","transaction_code":"C","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2022-06-23 21:39:00","snet_input_date":"2022-06-23 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-06-23 21:39:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:33.000000Z","updated_at":"2025-03-17T18:39:33.000000Z","inspection_violations":[{"id":1066704,"change_date":"2022-10-20 21:40:00","inspection_id":"75900501","insp_violation_id":"249139405","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"39141A1"},{"id":1066705,"change_date":"2022-10-20 21:40:00","inspection_id":"75900501","insp_violation_id":"249139406","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191540401","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"22502501125","created_at":"2025-03-17T21:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1089318,"change_date":"2022-10-20 21:40:00","inspection_id":"75900501","insp_unit_id":"191540401","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"678748","insp_unit_license":"4529052","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"JALE5W164H7900415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:53.000000Z","updated_at":"2025-03-17T22:14:53.000000Z"}]},{"id":737153,"change_date":"2022-07-01 21:38:00","inspection_id":"75970149","dot_number":"668842","report_state":"NY","report_number":"SPG0260573","insp_date":"2022-06-23 00:00:00","insp_start_time":"1133","insp_end_time":"1148","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRANITE CITY ELECTRIC SUPPLY COMPANY","shipping_paper_number":"M000187873","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-01 21:38: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":"2722045","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:34.000000Z","updated_at":"2025-03-17T18:40:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1184456,"change_date":"2022-07-01 21:38:00","inspection_id":"75970149","insp_unit_id":"189570303","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"283006","insp_unit_license":"368A396","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"}]},{"id":97147,"change_date":"2022-04-04 21:40:00","inspection_id":"75206800","dot_number":"668842","report_state":"NY","report_number":"0122002217","insp_date":"2022-04-01 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"12057","location_desc":"TROY 1","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-04-04 21:40: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":"2691187","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2022-04-04 21:40:00","snet_input_date":"2022-04-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:11.000000Z","updated_at":"2025-03-17T18:29:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":157077,"change_date":"2022-04-04 21:40:00","inspection_id":"75206800","insp_unit_id":"187958759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"283006","insp_unit_license":"368A396","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"3HAEUTAL3LL453813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:11.000000Z","updated_at":"2025-03-17T22:09:11.000000Z"}]},{"id":85501,"change_date":"2022-04-01 21:38:00","inspection_id":"75192744","dot_number":"668842","report_state":"MA","report_number":"CL00002604","insp_date":"2022-03-31 00:00:00","insp_start_time":"1415","insp_end_time":"1429","registration_date":null,"region":"ET","ci_status_code":"C","location":"036H","location_desc":"H-BLANDFORD","county_code_state":"MA","county_code":"013","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-01 21:38: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":"444043","transaction_code":"A","transaction_date":"2022-04-01 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00668842","upload_search_indicator":"M","census_search_date":"2022-04-01 21:38:00","snet_input_date":"2022-03-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-04-01 21:38:00","insp_carrier_name":"GRANITE CITY ELECTRIC","insp_carrier_street":"19 QUINCY AVENUE","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:07.000000Z","updated_at":"2025-03-17T18:29:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":138733,"change_date":"2022-04-01 21:38:00","inspection_id":"75192744","insp_unit_id":"187932009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"749697","insp_unit_license":"T26685","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC2JDJP8599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:04.000000Z","updated_at":"2025-03-17T22:09:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/668842\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/668842\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/668842\/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\/668842\/inspections","per_page":100,"prev_page_url":null,"to":70,"total":70}