{"current_page":1,"data":[{"id":12121726,"change_date":"2026-06-10 21:45:00","inspection_id":"88007311","dot_number":"27863","report_state":"MA","report_number":"DF00003349","insp_date":"2026-06-01 00:00:00","insp_start_time":"0411","insp_end_time":"0426","registration_date":"2026-06-10 00:00:00","region":"ES","ci_status_code":"C","location":"373H","location_desc":"MA","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":"U","pen_cen_match":"I","final_status_date":"2026-06-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3439356","transaction_code":"C","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2026-06-01 21:40:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:30:49.000000Z","updated_at":"2026-06-16T09:39:02.000000Z","inspection_violations":[{"id":21096044,"change_date":"2026-06-10 21:45:00","inspection_id":"88007311","insp_violation_id":"274826882","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"214025421","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:41:08.000000Z","updated_at":"2026-06-15T10:01:54.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":21096043,"change_date":"2026-06-10 21:45:00","inspection_id":"88007311","insp_violation_id":"274826881","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"214025421","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-12T09:41:08.000000Z","updated_at":"2026-06-15T10:01:54.000000Z","normalized_code":"3929BAINACTIVE"},{"id":21096045,"change_date":"2026-06-10 21:45:00","inspection_id":"88007311","insp_violation_id":"274826883","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"214025421","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:41:08.000000Z","updated_at":"2026-06-15T10:01:54.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":21059989,"change_date":"2026-06-10 21:45:00","inspection_id":"88007311","insp_unit_id":"214025421","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"78801A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFC9SHVZ5963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:02:13.000000Z","updated_at":"2026-06-16T09:14:22.000000Z"}]},{"id":12121730,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","dot_number":"27863","report_state":"CT","report_number":"3086000054","insp_date":"2026-05-20 00:00:00","insp_start_time":"0536","insp_end_time":"0809","registration_date":"2026-06-01 00:00:00","region":"ED","ci_status_code":"C","location":"163","location_desc":"CT","county_code_state":"CT","county_code":null,"insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RI DOC","shipping_paper_number":"22672","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":"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":"117000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3457950","transaction_code":"C","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2026-05-20 21:40:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:34:35.000000Z","updated_at":"2026-06-16T09:30:10.000000Z","inspection_violations":[{"id":21096176,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678370","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213899660","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"3922SLLSR"},{"id":21096177,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678371","seq_no":"2","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"213899660","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"39380A"},{"id":21096178,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678372","seq_no":"3","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"2","insp_unit_id":"213899661","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"39345DBAAL"},{"id":21096179,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678373","seq_no":"4","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"213899660","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"3929BAINACTIVE"},{"id":21096180,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678374","seq_no":"5","part_no":"390","part_no_section":"19A2","insp_viol_unit":"1","insp_unit_id":"213899660","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"39019A2"},{"id":21096181,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678375","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213899660","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"39345B2BAIR"},{"id":21096182,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_violation_id":"274678376","seq_no":"7","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213899660","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:49:03.000000Z","updated_at":"2026-06-15T09:44:01.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":21060359,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_unit_id":"213899661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"830509","insp_unit_license":"BE28618","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526165329J5001307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:07:47.000000Z","updated_at":"2026-06-16T09:01:18.000000Z"},{"id":21060358,"change_date":"2026-06-04 21:45:00","inspection_id":"87905013","insp_unit_id":"213899660","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"415441","insp_unit_license":"79972A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDVXNSNJ2582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:07:47.000000Z","updated_at":"2026-06-16T09:01:18.000000Z"}]},{"id":11528554,"change_date":"2026-03-31 21:39:00","inspection_id":"87450121","dot_number":"27863","report_state":"NJ","report_number":"SPSTI00083","insp_date":"2026-03-26 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"ED","ci_status_code":"C","location":"1352","location_desc":"NJ","county_code_state":"NJ","county_code":"025","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":"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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25401","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":"3094690","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2026-03-31 21:39:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-31 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-03T09:46:10.000000Z","updated_at":"2026-04-11T09:30:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19751279,"change_date":"2026-03-31 21:39:00","inspection_id":"87450121","insp_unit_id":"212447266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"64067A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE0KDKN8125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-03T09:24:35.000000Z","updated_at":"2026-04-11T09:03:24.000000Z"}]},{"id":11223511,"change_date":"2026-02-25 21:46:00","inspection_id":"87135347","dot_number":"27863","report_state":"NY","report_number":"SPC3011772","insp_date":"2026-02-18 00:00:00","insp_start_time":"1650","insp_end_time":"1713","registration_date":"2026-02-24 00:00:00","region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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":"2026-02-25 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2928382","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2026-02-25 21:46:00","snet_input_date":"2026-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-25 21:46:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:38:24.000000Z","updated_at":"2026-03-08T09:30:46.000000Z","inspection_violations":[{"id":18824233,"change_date":"2026-02-25 21:46:00","inspection_id":"87135347","insp_violation_id":"272003599","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"211810743","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:55:55.000000Z","updated_at":"2026-03-08T09:45:28.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19171759,"change_date":"2026-02-25 21:46:00","inspection_id":"87135347","insp_unit_id":"211810742","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"415441","insp_unit_license":"79972A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDVXNSNJ2582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:01.000000Z","updated_at":"2026-03-08T09:03:39.000000Z"},{"id":19171760,"change_date":"2026-02-25 21:46:00","inspection_id":"87135347","insp_unit_id":"211810743","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"429","insp_unit_license":"5365507","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"52616532XK5001429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:01.000000Z","updated_at":"2026-03-08T09:03:39.000000Z"}]},{"id":10879644,"change_date":"2026-01-29 21:37:00","inspection_id":"86910028","dot_number":"27863","report_state":"CT","report_number":"3090004950","insp_date":"2026-01-29 00:00:00","insp_start_time":"1055","insp_end_time":"1123","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"3301118","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-01-29 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"764476","transaction_code":"A","transaction_date":"2026-01-29 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2026-01-29 21:37:00","snet_input_date":"2026-01-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-29 21:37:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:40.000000Z","updated_at":"2026-02-10T10:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18285366,"change_date":"2026-01-29 21:37:00","inspection_id":"86910028","insp_unit_id":"211333767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"350083","insp_unit_license":"66402A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV4LSLX7225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:35.000000Z","updated_at":"2026-02-09T10:00:54.000000Z"},{"id":18285367,"change_date":"2026-01-29 21:37:00","inspection_id":"86910028","insp_unit_id":"211333768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"48G17137","insp_unit_license":"5223971","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483H6113611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:35.000000Z","updated_at":"2026-02-09T10:00:54.000000Z"}]},{"id":10435840,"change_date":"2025-12-17 21:39:00","inspection_id":"86567726","dot_number":"27863","report_state":"MA","report_number":"DY00001215","insp_date":"2025-12-15 00:00:00","insp_start_time":"0359","insp_end_time":"0417","registration_date":"2025-12-17 00:00:00","region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","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":"19481","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-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"536124","transaction_code":"C","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2025-12-15 21:39:00","snet_input_date":"2025-12-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:39.000000Z","updated_at":"2025-12-28T10:30:33.000000Z","inspection_violations":[{"id":17543330,"change_date":"2025-12-17 21:39:00","inspection_id":"86567726","insp_violation_id":"270736421","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-12-20T10:32:13.000000Z","updated_at":"2025-12-28T10:31:02.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":17500193,"change_date":"2025-12-17 21:39:00","inspection_id":"86567726","insp_unit_id":"210656654","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"81020A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV6LSLX7226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:45.000000Z","updated_at":"2025-12-28T10:00:39.000000Z"},{"id":17500194,"change_date":"2025-12-17 21:39:00","inspection_id":"86567726","insp_unit_id":"210656655","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDRO","insp_unit_company":null,"insp_unit_license":"BW42605","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526163628S5000084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:45.000000Z","updated_at":"2025-12-28T10:00:39.000000Z"}]},{"id":10337478,"change_date":"2025-12-05 21:41:00","inspection_id":"86464788","dot_number":"27863","report_state":"CT","report_number":"0613001497","insp_date":"2025-12-03 00:00:00","insp_start_time":"1451","insp_end_time":"1512","registration_date":"2025-12-05 00:00:00","region":"ET","ci_status_code":"C","location":"145","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"759579","transaction_code":"C","transaction_date":"2025-12-03 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-12-03 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-03 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-06T10:31:21.000000Z","updated_at":"2025-12-09T10:30:04.000000Z","inspection_violations":[{"id":17333808,"change_date":"2025-12-05 21:41:00","inspection_id":"86464788","insp_violation_id":"270474123","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"210426284","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:07.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":17304929,"change_date":"2025-12-05 21:41:00","inspection_id":"86464788","insp_unit_id":"210426285","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDRO","insp_unit_company":null,"insp_unit_license":"BW42925","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"52616281XS3000310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:47.000000Z","updated_at":"2025-12-09T10:00:05.000000Z"},{"id":17304928,"change_date":"2025-12-05 21:41:00","inspection_id":"86464788","insp_unit_id":"210426284","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"67374A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV5MSMK7549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:47.000000Z","updated_at":"2025-12-09T10:00:05.000000Z"}]},{"id":10331165,"change_date":"2025-12-02 21:38:00","inspection_id":"86458216","dot_number":"27863","report_state":"NH","report_number":"0940001114","insp_date":"2025-12-02 00:00:00","insp_start_time":"0511","insp_end_time":"0528","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 101EB\/TROOP C LIGHTS","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"2025-12-02 21:38: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":"290774","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-12-02 21:38:00","snet_input_date":"2025-12-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-12-02 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:28.000000Z","updated_at":"2025-12-06T10:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17254253,"change_date":"2025-12-02 21:38:00","inspection_id":"86458216","insp_unit_id":"210355364","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:51.000000Z","updated_at":"2025-12-06T10:00:34.000000Z"}]},{"id":10212236,"change_date":"2025-11-17 21:38:00","inspection_id":"86333587","dot_number":"27863","report_state":"CT","report_number":"1229002072","insp_date":"2025-11-17 00:00:00","insp_start_time":"1359","insp_end_time":"1411","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"8694","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-17 21:38: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":"757957","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-11-17 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-17 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:20.000000Z","updated_at":"2025-11-21T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17011543,"change_date":"2025-11-17 21:38:00","inspection_id":"86333587","insp_unit_id":"210053832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592705","insp_unit_license":"75994A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACXFC1RDUR1855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:25.000000Z","updated_at":"2025-11-21T10:00:07.000000Z"}]},{"id":10190451,"change_date":"2025-11-19 21:39:00","inspection_id":"86310738","dot_number":"27863","report_state":"MA","report_number":"DQ00002882","insp_date":"2025-11-13 00:00:00","insp_start_time":"0419","insp_end_time":"0442","registration_date":"2025-11-19 00:00:00","region":"ET","ci_status_code":"C","location":"218H","location_desc":"H-NATICK","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":"3283699","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-11-13 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":"533812","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2025-11-13 21:39:00","snet_input_date":"2025-11-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:54.000000Z","updated_at":"2025-11-23T10:31:38.000000Z","inspection_violations":[{"id":17022884,"change_date":"2025-11-19 21:39:00","inspection_id":"86310738","insp_violation_id":"270061010","seq_no":"1","part_no":"392","part_no_section":"7A-D","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-11-23T10:32:12.000000Z","updated_at":"2025-11-23T10:32:12.000000Z","normalized_code":"3927AD"}],"inspection_per_units":[{"id":17063074,"change_date":"2025-11-19 21:39:00","inspection_id":"86310738","insp_unit_id":"210120159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BV13415","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC1RDUR1607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:44.000000Z","updated_at":"2025-11-23T10:01:44.000000Z"}]},{"id":10144971,"change_date":"2025-11-13 21:39:00","inspection_id":"86262894","dot_number":"27863","report_state":"NH","report_number":"1086002327","insp_date":"2025-11-04 00:00:00","insp_start_time":"0735","insp_end_time":"0810","registration_date":"2025-11-10 00:00:00","region":"ES","ci_status_code":"C","location":"217","location_desc":"NH","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"CUST# 146634","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2535766","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:36.000000Z","updated_at":"2025-11-17T10:30:10.000000Z","inspection_violations":[{"id":16920469,"change_date":"2025-11-13 21:39:00","inspection_id":"86262894","insp_violation_id":"269921812","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","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-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"3922SLLML"},{"id":16920470,"change_date":"2025-11-13 21:39:00","inspection_id":"86262894","insp_violation_id":"269921813","seq_no":"2","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"39522H1ELDNUM"},{"id":16920471,"change_date":"2025-11-13 21:39:00","inspection_id":"86262894","insp_violation_id":"269921814","seq_no":"3","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:09.000000Z","updated_at":"2025-11-17T10:30:20.000000Z","normalized_code":"39524DELDPT"}],"inspection_per_units":[{"id":16966036,"change_date":"2025-11-13 21:39:00","inspection_id":"86262894","insp_unit_id":"210000791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"561788","insp_unit_license":"71083A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKBHSDV5NSNS9823","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:11.000000Z"},{"id":16966037,"change_date":"2025-11-13 21:39:00","inspection_id":"86262894","insp_unit_id":"210000792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"788209","insp_unit_license":"BW42926","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526162811S3000311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:11.000000Z"}]},{"id":9943917,"change_date":"2025-10-15 21:38:00","inspection_id":"86051101","dot_number":"27863","report_state":"CT","report_number":"3129006291","insp_date":"2025-10-15 00:00:00","insp_start_time":"1415","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","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-10-15 21:38: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":"755238","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-10-15 21:38:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-15 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:38.000000Z","updated_at":"2025-10-19T10:00:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16506097,"change_date":"2025-10-15 21:38:00","inspection_id":"86051101","insp_unit_id":"209473649","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592705","insp_unit_license":"75994A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC1RDUR1855","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:02.000000Z","updated_at":"2025-10-19T09:45:05.000000Z"}]},{"id":9931592,"change_date":"2025-10-14 21:41:00","inspection_id":"86037524","dot_number":"27863","report_state":"CT","report_number":"3129006284","insp_date":"2025-10-14 00:00:00","insp_start_time":"1245","insp_end_time":"1301","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","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-10-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"55001","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":"755047","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:27.000000Z","updated_at":"2025-10-18T10:00:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16483822,"change_date":"2025-10-14 21:41:00","inspection_id":"86037524","insp_unit_id":"209448144","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64092A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE5KDKN8122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:39.000000Z","updated_at":"2025-10-18T09:45:09.000000Z"}]},{"id":9884624,"change_date":"2025-10-08 21:40:00","inspection_id":"85988275","dot_number":"27863","report_state":"NY","report_number":"SPD3071345","insp_date":"2025-10-02 00:00:00","insp_start_time":"0714","insp_end_time":"0736","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","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-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":"2380970","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:43.000000Z","updated_at":"2025-10-12T10:00:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16400519,"change_date":"2025-10-08 21:40:00","inspection_id":"85988275","insp_unit_id":"209357338","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"BT82705","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFCXRDUR1606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:09.000000Z","updated_at":"2025-10-12T09:45:47.000000Z"}]},{"id":9625957,"change_date":"2025-09-09 21:39:00","inspection_id":"85716767","dot_number":"27863","report_state":"CT","report_number":"3091006110","insp_date":"2025-09-09 00:00:00","insp_start_time":"0923","insp_end_time":"0943","registration_date":null,"region":"ET","ci_status_code":"C","location":"049","location_desc":"ENFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"17354","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-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"751414","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-09-09 21:39:00","snet_input_date":"2025-09-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-09-09 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:46:52.000000Z","updated_at":"2025-09-13T10:46:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15899835,"change_date":"2025-09-09 21:39:00","inspection_id":"85716767","insp_unit_id":"208815021","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"415440","insp_unit_license":"80651A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV8NSNJ2581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:39.000000Z","updated_at":"2025-09-13T09:58:50.000000Z"},{"id":15899836,"change_date":"2025-09-09 21:39:00","inspection_id":"85716767","insp_unit_id":"208815022","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"48G16004","insp_unit_license":"5366452","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483GM470104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:39.000000Z","updated_at":"2025-09-13T09:58:50.000000Z"}]},{"id":9533030,"change_date":"2025-08-28 21:41:00","inspection_id":"85619471","dot_number":"27863","report_state":"MA","report_number":"BU00004294","insp_date":"2025-08-28 00:00:00","insp_start_time":"0905","insp_end_time":"0939","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-28 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":"526970","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:14.000000Z","updated_at":"2025-09-06T10:42:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15734589,"change_date":"2025-08-28 21:41:00","inspection_id":"85619471","insp_unit_id":"208634430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BT82705","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFCXRDUR1606","insp_unit_decal":"Y","insp_unit_decal_number":"35600053","created_at":"2025-09-09T09:46:36.000000Z","updated_at":"2025-09-09T09:46:36.000000Z"}]},{"id":9564668,"change_date":"2025-09-02 21:39:00","inspection_id":"85653064","dot_number":"27863","report_state":"VT","report_number":"3500000403","insp_date":"2025-08-28 00:00:00","insp_start_time":"0919","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"0105","location_desc":"FERRISBURGH","county_code_state":"VT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY","shipping_paper_number":"3262675","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-09-02 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":"220065","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:00.000000Z","updated_at":"2025-09-06T10:43:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15788014,"change_date":"2025-09-02 21:39:00","inspection_id":"85653064","insp_unit_id":"208693863","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:13.000000Z","updated_at":"2025-09-09T09:47:13.000000Z"}]},{"id":9399012,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","dot_number":"27863","report_state":"NY","report_number":"SPE3060923","insp_date":"2025-08-07 00:00:00","insp_start_time":"0645","insp_end_time":"0716","registration_date":"2025-08-26 00:00:00","region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","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":"2122565","transaction_code":"C","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-08-13 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:19.000000Z","updated_at":"2025-09-05T10:46:16.000000Z","inspection_violations":[{"id":15506966,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_violation_id":"268255259","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208586892","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39355EB"},{"id":15506967,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_violation_id":"268255260","seq_no":"2","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"1","insp_unit_id":"208586891","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39522H1ELDNUM"},{"id":15506968,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_violation_id":"268255261","seq_no":"3","part_no":"395","part_no_section":"22H3-ELDMF","insp_viol_unit":"1","insp_unit_id":"208586891","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39522H3ELDMF"},{"id":15506969,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_violation_id":"268255262","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208586892","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39617CPI"},{"id":15506970,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_violation_id":"268255263","seq_no":"5","part_no":"395","part_no_section":"22H2-ELDNISDT","insp_viol_unit":"1","insp_unit_id":"208586891","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39522H2ELDNISDT"},{"id":15506971,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_violation_id":"268255264","seq_no":"6","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"208586892","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":15686979,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_unit_id":"208586891","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"415442","insp_unit_license":"69748A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV1NSNJ2583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:37.000000Z","updated_at":"2025-09-05T09:45:33.000000Z"},{"id":15686980,"change_date":"2025-08-26 21:40:00","inspection_id":"85478357","insp_unit_id":"208586892","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"5365507","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"52616532XK5001429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:37.000000Z","updated_at":"2025-09-05T09:45:33.000000Z"}]},{"id":9362886,"change_date":"2025-08-08 21:39:00","inspection_id":"85440536","dot_number":"27863","report_state":"VT","report_number":"5500002601","insp_date":"2025-08-05 00:00:00","insp_start_time":"0849","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"1408SB","location_desc":"WHITE RIVER SB RA","county_code_state":"VT","county_code":"027","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":"2025-08-08 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":"219400","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:13.000000Z","updated_at":"2025-08-12T10:44:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15425650,"change_date":"2025-08-08 21:39:00","inspection_id":"85440536","insp_unit_id":"208302743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75347A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC3RDUR1856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:25.000000Z","updated_at":"2025-08-12T09:45:47.000000Z"}]},{"id":9313973,"change_date":"2025-08-03 21:33:00","inspection_id":"85389028","dot_number":"27863","report_state":"CT","report_number":"1229001848","insp_date":"2025-08-01 00:00:00","insp_start_time":"1530","insp_end_time":"1549","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","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":"2025-08-03 21:33: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":"747734","transaction_code":"A","transaction_date":"2025-08-01 00:00:00","upload_date":"2025-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-08-03 21:33:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-03 21:33:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-06T10:43:40.000000Z","updated_at":"2025-08-07T10:44:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15337797,"change_date":"2025-08-03 21:33:00","inspection_id":"85389028","insp_unit_id":"208208521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"492446","insp_unit_license":"BT82705","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFCXRDUR1606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-06T09:45:18.000000Z","updated_at":"2025-08-07T09:45:06.000000Z"}]},{"id":9210341,"change_date":"2025-07-22 21:41:00","inspection_id":"85279935","dot_number":"27863","report_state":"CT","report_number":"1229001825","insp_date":"2025-07-22 00:00:00","insp_start_time":"1503","insp_end_time":"1513","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","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":"2025-07-22 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":"746830","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-07-22 21:41:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-22 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:43.000000Z","updated_at":"2025-07-27T10:40:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15144016,"change_date":"2025-07-22 21:41:00","inspection_id":"85279935","insp_unit_id":"207996714","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:35.000000Z","updated_at":"2025-07-26T09:45:15.000000Z"}]},{"id":9134300,"change_date":"2025-07-14 21:39:00","inspection_id":"85200191","dot_number":"27863","report_state":"CT","report_number":"3132005710","insp_date":"2025-07-14 00:00:00","insp_start_time":"1416","insp_end_time":"1434","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 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":"745883","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-07-14 21:39:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-14 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:32.000000Z","updated_at":"2025-07-18T10:45:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14998015,"change_date":"2025-07-14 21:39:00","inspection_id":"85200191","insp_unit_id":"207841922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"78801A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFC9SHVZ5963","insp_unit_decal":"Y","insp_unit_decal_number":"35535497","created_at":"2025-07-17T09:45:23.000000Z","updated_at":"2025-07-18T09:45:06.000000Z"}]},{"id":9134301,"change_date":"2025-07-14 21:39:00","inspection_id":"85200192","dot_number":"27863","report_state":"CT","report_number":"3132005711","insp_date":"2025-07-14 00:00:00","insp_start_time":"1602","insp_end_time":"1617","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 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":"745889","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-07-14 21:39:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-14 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:32.000000Z","updated_at":"2025-07-18T10:45:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14998016,"change_date":"2025-07-14 21:39:00","inspection_id":"85200192","insp_unit_id":"207841923","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"78803A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACXFC2SHVZ5965","insp_unit_decal":"Y","insp_unit_decal_number":"35535498","created_at":"2025-07-17T09:45:23.000000Z","updated_at":"2025-07-18T09:45:06.000000Z"}]},{"id":9117760,"change_date":"2025-08-12 21:39:00","inspection_id":"85182853","dot_number":"27863","report_state":"CT","report_number":"3010004353","insp_date":"2025-07-11 00:00:00","insp_start_time":"0602","insp_end_time":"0647","registration_date":"2025-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"132","location_desc":"S. WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY I","shipping_paper_number":"TRIP SLIP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"745521","transaction_code":"C","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-07-11 21:38:00","snet_input_date":"2025-07-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-11 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:54.000000Z","updated_at":"2025-08-16T10:00:04.000000Z","inspection_violations":[{"id":15251146,"change_date":"2025-08-12 21:39:00","inspection_id":"85182853","insp_violation_id":"267961868","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"208342179","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:24.000000Z","updated_at":"2025-08-16T10:42:47.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":15462437,"change_date":"2025-08-12 21:39:00","inspection_id":"85182853","insp_unit_id":"208342179","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"751282","insp_unit_license":"62106A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN5JH253243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:14.000000Z","updated_at":"2025-08-16T09:45:06.000000Z"}]},{"id":8835583,"change_date":"2025-06-06 21:40:00","inspection_id":"84884301","dot_number":"27863","report_state":"NH","report_number":"0896001433","insp_date":"2025-06-06 00:00:00","insp_start_time":"0555","insp_end_time":"0615","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"KEENE\/ PUB PARKING LOT","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-06 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":"285663","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-06-06 21:40:00","snet_input_date":"2025-06-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:17.000000Z","updated_at":"2025-06-10T10:00:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14466859,"change_date":"2025-06-06 21:40:00","inspection_id":"84884301","insp_unit_id":"207261577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:17.000000Z","updated_at":"2025-06-10T09:45:36.000000Z"}]},{"id":8749732,"change_date":"2025-05-28 21:42:00","inspection_id":"84793427","dot_number":"27863","report_state":"CT","report_number":"3063007082","insp_date":"2025-05-28 00:00:00","insp_start_time":"0953","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"059","location_desc":"GROTON","county_code_state":"CT","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HPC FOODSERVICE","shipping_paper_number":"261278","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-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"741513","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-05-28 21:42:00","snet_input_date":"2025-05-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-28 21:42:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:18.000000Z","updated_at":"2025-06-01T10:00:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14307798,"change_date":"2025-05-28 21:42:00","inspection_id":"84793427","insp_unit_id":"207089502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"833629","insp_unit_license":"78773A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKBHSDV1KSKN4690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:42.000000Z","updated_at":"2025-06-01T09:46:36.000000Z"},{"id":14307799,"change_date":"2025-05-28 21:42:00","inspection_id":"84793427","insp_unit_id":"207089503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VT HA","insp_unit_company":"665562","insp_unit_license":"AE44179","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526162819G5001041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:42.000000Z","updated_at":"2025-06-01T09:46:36.000000Z"}]},{"id":8636317,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","dot_number":"27863","report_state":"CT","report_number":"3072000483","insp_date":"2025-05-15 00:00:00","insp_start_time":"1058","insp_end_time":"1126","registration_date":"2025-05-22 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"740321","transaction_code":"C","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-05-15 21:42:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-15 21:42:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:03:27.000000Z","updated_at":"2025-05-26T10:03:26.000000Z","inspection_violations":[{"id":13879673,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_violation_id":"266393060","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"207002006","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:11.000000Z","updated_at":"2025-05-26T10:18:40.000000Z","normalized_code":"39345B2BAIR"},{"id":13879674,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_violation_id":"266393061","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"207002006","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:11.000000Z","updated_at":"2025-05-26T10:18:40.000000Z","normalized_code":"39345B2BAIR"},{"id":13879675,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_violation_id":"266393062","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"207002007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:11.000000Z","updated_at":"2025-05-26T10:18:40.000000Z","normalized_code":"39345B2BAIR"},{"id":13879676,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_violation_id":"266393063","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"207002007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:11.000000Z","updated_at":"2025-05-26T10:18:40.000000Z","normalized_code":"39345B2BAIR"},{"id":13879677,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_violation_id":"266393064","seq_no":"5","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"207002007","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:11.000000Z","updated_at":"2025-05-26T10:18:40.000000Z","normalized_code":"39311BCSRIGRR"},{"id":13879678,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_violation_id":"266393065","seq_no":"6","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"207002007","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:25:11.000000Z","updated_at":"2025-05-26T10:18:40.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":14229150,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_unit_id":"207002006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"415441","insp_unit_license":"79972A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDVXNSNJ2582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:07.000000Z","updated_at":"2025-05-26T09:48:23.000000Z"},{"id":14229151,"change_date":"2025-05-22 21:41:00","inspection_id":"84673604","insp_unit_id":"207002007","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"48G16067","insp_unit_license":"2559868","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2480GM625904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:50:07.000000Z","updated_at":"2025-05-26T09:48:23.000000Z"}]},{"id":8657880,"change_date":"2025-05-27 21:38:00","inspection_id":"84696318","dot_number":"27863","report_state":"MA","report_number":"DX00000315","insp_date":"2025-05-15 00:00:00","insp_start_time":"1410","insp_end_time":"1504","registration_date":"2025-05-27 00:00:00","region":"ET","ci_status_code":"C","location":"270H","location_desc":"H-RAYNHAM","county_code_state":"MA","county_code":"005","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":"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-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":"517865","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":"00027863","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":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","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":13944244,"change_date":"2025-05-27 21:38:00","inspection_id":"84696318","insp_violation_id":"266482766","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:31.000000Z","updated_at":"2025-05-31T10:16:39.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":14285193,"change_date":"2025-05-27 21:38:00","inspection_id":"84696318","insp_unit_id":"207072370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75347A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC3RDUR1856","insp_unit_decal":"Y","insp_unit_decal_number":"35323571","created_at":"2025-05-30T09:45:26.000000Z","updated_at":"2025-05-31T09:46:36.000000Z"}]},{"id":8622596,"change_date":"2025-05-14 21:40:00","inspection_id":"84659457","dot_number":"27863","report_state":"CT","report_number":"3132005564","insp_date":"2025-05-14 00:00:00","insp_start_time":"1436","insp_end_time":"1443","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-05-14 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":"740194","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-05-14 21:40:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-14 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:26.000000Z","updated_at":"2025-05-18T10:03:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14078889,"change_date":"2025-05-14 21:40:00","inspection_id":"84659457","insp_unit_id":"206840063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"62106A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN5JH253243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:32.000000Z","updated_at":"2025-05-18T09:48:14.000000Z"}]},{"id":8496039,"change_date":"2025-04-30 21:50:00","inspection_id":"84525922","dot_number":"27863","report_state":"CT","report_number":"1229001628","insp_date":"2025-04-30 00:00:00","insp_start_time":"1443","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:50: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":"738882","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-04-30 21:50:00","snet_input_date":"2025-04-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-30 21:50:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:49:31.000000Z","updated_at":"2025-05-04T10:32:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13808510,"change_date":"2025-04-30 21:50:00","inspection_id":"84525922","insp_unit_id":"206543548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"492446","insp_unit_license":"BT82705","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFCXRDUR1606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:08:57.000000Z","updated_at":"2025-05-04T09:48:35.000000Z"}]},{"id":8465348,"change_date":"2025-05-01 21:40:00","inspection_id":"84493754","dot_number":"27863","report_state":"CT","report_number":"3077A00385","insp_date":"2025-04-25 00:00:00","insp_start_time":"1131","insp_end_time":"1145","registration_date":"2025-05-01 00:00:00","region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY I","shipping_paper_number":"14446","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-04-25 21:35: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":"738437","transaction_code":"C","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-04-25 21:35:00","snet_input_date":"2025-04-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-25 21:35:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-28T10:13:45.000000Z","updated_at":"2025-05-05T10:10:21.000000Z","inspection_violations":[{"id":13484160,"change_date":"2025-05-01 21:40:00","inspection_id":"84493754","insp_violation_id":"265940161","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W1120-4296","created_at":"2025-05-03T11:16:20.000000Z","updated_at":"2025-05-04T10:48:17.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":13846147,"change_date":"2025-05-01 21:40:00","inspection_id":"84493754","insp_unit_id":"206584033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:15:53.000000Z","updated_at":"2025-05-05T09:48:52.000000Z"}]},{"id":8497069,"change_date":"2025-04-30 21:50:00","inspection_id":"84527039","dot_number":"27863","report_state":"NY","report_number":"SPA3020670","insp_date":"2025-04-23 00:00:00","insp_start_time":"1027","insp_end_time":"1045","registration_date":null,"region":"ED","ci_status_code":"C","location":"80881M","location_desc":"SLATE HILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"HPC FOOD SERVICE","shipping_paper_number":"3232163","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-04-30 21:50: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":"1653545","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-04-30 21:50:00","snet_input_date":"2025-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:50:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:49:35.000000Z","updated_at":"2025-05-04T10:33:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13810179,"change_date":"2025-04-30 21:50:00","inspection_id":"84527039","insp_unit_id":"206545407","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:09:49.000000Z","updated_at":"2025-05-04T09:49:47.000000Z"}]},{"id":8202635,"change_date":"2025-03-25 21:36:00","inspection_id":"84217088","dot_number":"27863","report_state":"MA","report_number":"DQ00001996","insp_date":"2025-03-24 00:00:00","insp_start_time":"1640","insp_end_time":"1704","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"512997","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2025-03-25 21:36:00","snet_input_date":"2025-03-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-25 21:36:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:58.000000Z","updated_at":"2025-03-29T10:20:07.000000Z","inspection_violations":[{"id":12864326,"change_date":"2025-03-25 21:36:00","inspection_id":"84217088","insp_violation_id":"265237472","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"205974322","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:34:50.000000Z","updated_at":"2025-03-28T10:51:17.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":13262426,"change_date":"2025-03-25 21:36:00","inspection_id":"84217088","insp_unit_id":"205974322","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BA16448","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"JALEEW168L7302112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:07:10.000000Z","updated_at":"2025-03-29T10:00:42.000000Z"}]},{"id":7949479,"change_date":"2025-02-28 21:40:00","inspection_id":"83950709","dot_number":"27863","report_state":"CT","report_number":"3063006973","insp_date":"2025-02-25 00:00:00","insp_start_time":"0556","insp_end_time":"0654","registration_date":"2025-02-28 00:00:00","region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"3217436","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-02-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"733152","transaction_code":"C","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-02-25 21:39:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-02-25 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:16.000000Z","updated_at":"2025-03-17T21:03:16.000000Z","inspection_violations":[{"id":12420473,"change_date":"2025-02-28 21:40:00","inspection_id":"83950709","insp_violation_id":"264750442","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205548692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"3939ALIL"},{"id":12420474,"change_date":"2025-02-28 21:40:00","inspection_id":"83950709","insp_violation_id":"264750443","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"205548692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"3939ALCL"},{"id":12420475,"change_date":"2025-02-28 21:40:00","inspection_id":"83950709","insp_violation_id":"264750444","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"205548692","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"3939ALSML"},{"id":12420476,"change_date":"2025-02-28 21:40:00","inspection_id":"83950709","insp_violation_id":"264750445","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205548692","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":12832686,"change_date":"2025-02-28 21:40:00","inspection_id":"83950709","insp_unit_id":"205548692","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"227650","insp_unit_license":"2910644","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTEUMMLXLH801128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:45.000000Z","updated_at":"2025-03-17T23:56:45.000000Z"}]},{"id":7758019,"change_date":"2025-01-31 21:40:00","inspection_id":"83749716","dot_number":"27863","report_state":"VT","report_number":"51A0001042","insp_date":"2025-01-30 00:00:00","insp_start_time":"1245","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":"0909NB","location_desc":"RANDOLPH NB RA","county_code_state":"VT","county_code":"017","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-31 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":"213896","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:11.000000Z","updated_at":"2025-03-17T20:59:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12519581,"change_date":"2025-01-31 21:40:00","inspection_id":"83749716","insp_unit_id":"205102082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:11.000000Z","updated_at":"2025-03-17T23:53:11.000000Z"}]},{"id":7680138,"change_date":"2025-01-22 21:39:00","inspection_id":"83667912","dot_number":"27863","report_state":"NY","report_number":"SPK4080026","insp_date":"2025-01-15 00:00:00","insp_start_time":"1136","insp_end_time":"1200","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HOPEWELL JUNCTION NY","county_code_state":"NY","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-01-22 21:39: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1274597","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:51.000000Z","updated_at":"2025-03-17T20:57:51.000000Z","inspection_violations":[{"id":12000601,"change_date":"2025-01-22 21:39:00","inspection_id":"83667912","insp_violation_id":"264116617","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204949792","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:30.000000Z","updated_at":"2025-03-17T22:04:30.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":12392962,"change_date":"2025-01-22 21:39:00","inspection_id":"83667912","insp_unit_id":"204949792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"BT82705","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFCXRDUR1606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:46.000000Z","updated_at":"2025-03-17T23:51:46.000000Z"}]},{"id":7533370,"change_date":"2025-01-02 21:38:00","inspection_id":"83513769","dot_number":"27863","report_state":"MA","report_number":"DF00001760","insp_date":"2025-01-02 00:00:00","insp_start_time":"0614","insp_end_time":"0629","registration_date":null,"region":"ET","ci_status_code":"C","location":"136H","location_desc":"H-HANOVER","county_code_state":"MA","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"11952","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-02 21:38: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":"506240","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2025-01-02 21:38:00","snet_input_date":"2025-01-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-02 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:12.000000Z","updated_at":"2025-03-17T20:53:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12153745,"change_date":"2025-01-02 21:38:00","inspection_id":"83513769","insp_unit_id":"204620284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75347A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC3RDUR1856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"}]},{"id":7500220,"change_date":"2025-01-02 21:38:00","inspection_id":"83479079","dot_number":"27863","report_state":"MA","report_number":"DQ00001658","insp_date":"2024-12-23 00:00:00","insp_start_time":"1549","insp_end_time":"1617","registration_date":"2025-01-02 00:00:00","region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-26 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"55001","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":"505927","transaction_code":"C","transaction_date":"2024-12-26 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2024-12-26 21:36:00","snet_input_date":"2024-12-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-26 21:36:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:38.000000Z","updated_at":"2025-03-17T20:52:38.000000Z","inspection_violations":[{"id":11723665,"change_date":"2025-01-02 21:38:00","inspection_id":"83479079","insp_violation_id":"263723270","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:08.000000Z","updated_at":"2025-03-17T22:03:08.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":12099754,"change_date":"2025-01-02 21:38:00","inspection_id":"83479079","insp_unit_id":"204620252","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64092A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE5KDKN8122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:34.000000Z","updated_at":"2025-03-17T23:48:34.000000Z"}]},{"id":7455104,"change_date":"2024-12-26 21:36:00","inspection_id":"83431553","dot_number":"27863","report_state":"CT","report_number":"0775000297","insp_date":"2024-12-19 00:00:00","insp_start_time":"1401","insp_end_time":"1431","registration_date":"2024-12-26 00:00:00","region":"ET","ci_status_code":"C","location":null,"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":"SAME","shipping_paper_number":"RT 429","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-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"727350","transaction_code":"C","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-12-19 21:40:00","snet_input_date":"2024-12-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-19 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:35.000000Z","updated_at":"2025-03-17T20:51:35.000000Z","inspection_violations":[{"id":11651001,"change_date":"2024-12-26 21:36:00","inspection_id":"83431553","insp_violation_id":"263651549","seq_no":"1","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"204550262","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:44.000000Z","updated_at":"2025-03-17T22:02:44.000000Z","normalized_code":"393203BCBP"}],"inspection_per_units":[{"id":12027101,"change_date":"2024-12-26 21:36:00","inspection_id":"83431553","insp_unit_id":"204550262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592706","insp_unit_license":"75347A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFC3RDUR1856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"}]},{"id":7364974,"change_date":"2024-12-13 21:40:00","inspection_id":"83337013","dot_number":"27863","report_state":"CT","report_number":"3017001762","insp_date":"2024-12-07 00:00:00","insp_start_time":"0749","insp_end_time":"0815","registration_date":"2024-12-12 00:00:00","region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SMARTERBEV","shipping_paper_number":"3449","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":"2024-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"725872","transaction_code":"C","transaction_date":"2024-12-07 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-12-09 21:40:00","snet_input_date":"2024-12-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-09 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:47.000000Z","updated_at":"2025-03-17T20:49:47.000000Z","inspection_violations":[{"id":11508633,"change_date":"2024-12-13 21:40:00","inspection_id":"83337013","insp_violation_id":"263438763","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131334-2","created_at":"2025-03-17T22:02:01.000000Z","updated_at":"2025-03-17T22:02:01.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":11880947,"change_date":"2024-12-13 21:40:00","inspection_id":"83337013","insp_unit_id":"204362471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"374699","insp_unit_license":"67406A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV5MSMK7552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:13.000000Z","updated_at":"2025-03-17T23:46:13.000000Z"},{"id":11880948,"change_date":"2024-12-13 21:40:00","inspection_id":"83337013","insp_unit_id":"204362472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"48G16067","insp_unit_license":"2559868","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2480GM625904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:13.000000Z","updated_at":"2025-03-17T23:46:13.000000Z"}]},{"id":7518212,"change_date":"2025-01-14 21:55:00","inspection_id":"83497884","dot_number":"27863","report_state":"VT","report_number":"51A0000886","insp_date":"2024-11-12 00:00:00","insp_start_time":"0853","insp_end_time":"0919","registration_date":"2025-01-13 00:00:00","region":"ET","ci_status_code":"C","location":"1313","location_desc":"PUTNEY SCALEHOUSE","county_code_state":"VT","county_code":"025","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-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"212933","transaction_code":"C","transaction_date":"2024-11-12 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-11-12 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:44.000000Z","updated_at":"2025-03-17T20:52:44.000000Z","inspection_violations":[{"id":11750217,"change_date":"2025-01-14 21:55:00","inspection_id":"83497884","insp_violation_id":"263991233","seq_no":"1","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"204824135","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"393203BCBP"}],"inspection_per_units":[{"id":12129050,"change_date":"2025-01-14 21:55:00","inspection_id":"83497884","insp_unit_id":"204824135","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"592704","insp_unit_license":"75993A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFCXRDUR1854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:54.000000Z","updated_at":"2025-03-17T23:48:54.000000Z"}]},{"id":7112450,"change_date":"2024-11-13 21:39:00","inspection_id":"83070230","dot_number":"27863","report_state":"MA","report_number":"DF00001558","insp_date":"2024-11-04 00:00:00","insp_start_time":"0532","insp_end_time":"0546","registration_date":"2024-11-13 00:00:00","region":"ET","ci_status_code":"C","location":"373H","location_desc":"H-WEYMOUTH","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":"2024-11-04 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":"502710","transaction_code":"C","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:17.000000Z","updated_at":"2025-03-17T20:44:17.000000Z","inspection_violations":[{"id":11107689,"change_date":"2024-11-13 21:39:00","inspection_id":"83070230","insp_violation_id":"262870259","seq_no":"1","part_no":"376","part_no_section":"11D1","insp_viol_unit":"1","insp_unit_id":"203858967","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":11471407,"change_date":"2024-11-13 21:39:00","inspection_id":"83070230","insp_unit_id":"203858967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"59719A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN9HH655082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:51.000000Z","updated_at":"2025-03-17T23:41:51.000000Z"}]},{"id":7076131,"change_date":"2024-10-31 21:41:00","inspection_id":"83031524","dot_number":"27863","report_state":"CT","report_number":"3014004322","insp_date":"2024-10-30 00:00:00","insp_start_time":"1023","insp_end_time":"1036","registration_date":"2024-10-31 00:00:00","region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","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":"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":"2024-10-30 21:40: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":"721996","transaction_code":"C","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-10-30 21:40:00","snet_input_date":"2024-10-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[{"id":11047070,"change_date":"2024-10-31 21:41:00","inspection_id":"83031524","insp_violation_id":"262649405","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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:37.000000Z","updated_at":"2025-03-17T21:59:37.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11412035,"change_date":"2024-10-31 21:41:00","inspection_id":"83031524","insp_unit_id":"203667542","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"492446","insp_unit_license":"BT82705","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFCXRDUR1606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:10.000000Z","updated_at":"2025-03-17T23:41:10.000000Z"}]},{"id":6496881,"change_date":"2024-08-19 21:41:00","inspection_id":"82415349","dot_number":"27863","report_state":"CT","report_number":"3091005507","insp_date":"2024-08-15 00:00:00","insp_start_time":"1109","insp_end_time":"1134","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":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"79081","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-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"715681","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","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":10472648,"change_date":"2024-08-19 21:41:00","inspection_id":"82415349","insp_unit_id":"202451442","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"415439","insp_unit_license":"69745A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV6NSNJ2580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"},{"id":10472649,"change_date":"2024-08-19 21:41:00","inspection_id":"82415349","insp_unit_id":"202451443","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDRO","insp_unit_company":"751272","insp_unit_license":"AH48474","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526163227H5001189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"}]},{"id":6259697,"change_date":"2024-07-23 21:41:00","inspection_id":"82161629","dot_number":"27863","report_state":"MA","report_number":"DR00000938","insp_date":"2024-07-18 00:00:00","insp_start_time":"0506","insp_end_time":"0522","registration_date":"2024-07-23 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":"CARRIER","shipping_paper_number":"8302","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-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"496115","transaction_code":"C","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[{"id":9723358,"change_date":"2024-07-23 21:41:00","inspection_id":"82161629","insp_violation_id":"260788380","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:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10085546,"change_date":"2024-07-23 21:41:00","inspection_id":"82161629","insp_unit_id":"202017920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"830571","insp_unit_license":"63981A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE7KDKN8123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":6260416,"change_date":"2024-07-25 21:43:00","inspection_id":"82162392","dot_number":"27863","report_state":"NY","report_number":"SPD0216479","insp_date":"2024-07-18 00:00:00","insp_start_time":"0709","insp_end_time":"0733","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2938129","transaction_code":"C","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:58.000000Z","updated_at":"2025-03-17T20:26:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10086565,"change_date":"2024-07-25 21:43:00","inspection_id":"82162392","insp_unit_id":"202066687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"350083","insp_unit_license":"66402A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV4LSLX7225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"},{"id":10086566,"change_date":"2024-07-25 21:43:00","inspection_id":"82162392","insp_unit_id":"202066688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"5331325","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"52616532XK5001429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":6217806,"change_date":"2024-07-15 21:41:00","inspection_id":"82116723","dot_number":"27863","report_state":"NY","report_number":"SPE0311887","insp_date":"2024-07-10 00:00:00","insp_start_time":"0933","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"80881A","location_desc":"WAWAYANDA (EB)","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HPC","shipping_paper_number":"3158384","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-15 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":"2936852","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:49.000000Z","updated_at":"2025-03-17T20:25:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10017474,"change_date":"2024-07-15 21:41:00","inspection_id":"82116723","insp_unit_id":"201883425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"59720A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN0HH655983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:48.000000Z","updated_at":"2025-03-17T23:26:48.000000Z"}]},{"id":5866572,"change_date":"2024-05-29 21:41:00","inspection_id":"81737291","dot_number":"27863","report_state":"NY","report_number":"SPF0251097","insp_date":"2024-05-22 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"80881A","location_desc":"WAWAYANDA (EB)","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-29 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":"2927122","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"PO BOX 1228","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:03.000000Z","updated_at":"2025-03-17T20:19:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9448539,"change_date":"2024-05-29 21:41:00","inspection_id":"81737291","insp_unit_id":"201133748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"751284","insp_unit_license":"62108A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN9JH253245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:00.000000Z","updated_at":"2025-03-17T23:21:00.000000Z"}]},{"id":5833822,"change_date":"2024-05-24 21:38:00","inspection_id":"81702023","dot_number":"27863","report_state":"US","report_number":"1888000051","insp_date":"2024-05-16 00:00:00","insp_start_time":"0823","insp_end_time":"0920","registration_date":null,"region":"ED","ci_status_code":"C","location":"I0095N","location_desc":"EXETER RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"665524","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-05-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","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":"511342","transaction_code":"A","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-05-24 21:38:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-24 21:38:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:17.000000Z","updated_at":"2025-03-17T20:18:17.000000Z","inspection_violations":[{"id":9040178,"change_date":"2024-05-24 21:38:00","inspection_id":"81702023","insp_violation_id":"259709232","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201066834","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:43.000000Z","updated_at":"2025-03-17T21:49:43.000000Z","normalized_code":"39347E"},{"id":9040179,"change_date":"2024-05-24 21:38:00","inspection_id":"81702023","insp_violation_id":"259709233","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201066834","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:43.000000Z","updated_at":"2025-03-17T21:49:43.000000Z","normalized_code":"39353B"},{"id":9040180,"change_date":"2024-05-24 21:38:00","inspection_id":"81702023","insp_violation_id":"259709234","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201066834","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:43.000000Z","updated_at":"2025-03-17T21:49:43.000000Z","normalized_code":"39347E"},{"id":9040181,"change_date":"2024-05-24 21:38:00","inspection_id":"81702023","insp_violation_id":"259709235","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201066834","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:43.000000Z","updated_at":"2025-03-17T21:49:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9395508,"change_date":"2024-05-24 21:38:00","inspection_id":"81702023","insp_unit_id":"201066834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"665524","insp_unit_license":"59720A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN0HH655083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:32.000000Z","updated_at":"2025-03-17T23:20:32.000000Z"}]},{"id":5412592,"change_date":"2024-04-03 21:40:00","inspection_id":"81243286","dot_number":"27863","report_state":"CT","report_number":"0997000667","insp_date":"2024-04-01 00:00:00","insp_start_time":"0543","insp_end_time":"0605","registration_date":"2024-04-03 00:00:00","region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"5872","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":"2024-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"703664","transaction_code":"C","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-04-02 21:41:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-02 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:53.000000Z","updated_at":"2025-03-17T20:09:53.000000Z","inspection_violations":[{"id":8355280,"change_date":"2024-04-03 21:40:00","inspection_id":"81243286","insp_violation_id":"258713251","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:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8717767,"change_date":"2024-04-03 21:40:00","inspection_id":"81243286","insp_unit_id":"200204082","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"350082","insp_unit_license":"68239A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV2LSLX7224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:05.000000Z","updated_at":"2025-03-17T23:14:05.000000Z"},{"id":8717768,"change_date":"2024-04-03 21:40:00","inspection_id":"81243286","insp_unit_id":"200204083","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"665571","insp_unit_license":"AE44164","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"52616281XG5001050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:05.000000Z","updated_at":"2025-03-17T23:14:05.000000Z"}]},{"id":5080927,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","dot_number":"27863","report_state":"CT","report_number":"3025003609","insp_date":"2024-02-19 00:00:00","insp_start_time":"1323","insp_end_time":"1416","registration_date":"2024-02-27 00:00:00","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":"SHARON FOODS","shipping_paper_number":"631451","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"699909","transaction_code":"C","transaction_date":"2024-02-19 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:25.000000Z","updated_at":"2025-03-17T20:03:25.000000Z","inspection_violations":[{"id":7832014,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048228","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39347E"},{"id":7832015,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048229","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39347E"},{"id":7832016,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048230","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39347E"},{"id":7832017,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048231","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39353B"},{"id":7832018,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048232","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V126299-0","created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"3963A1"},{"id":7832019,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048233","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39347A"},{"id":7832020,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_violation_id":"258048234","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199609190","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":8179951,"change_date":"2024-02-27 21:38:00","inspection_id":"80881863","insp_unit_id":"199609190","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"003","insp_unit_license":"59720A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN0HH655083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:08.000000Z","updated_at":"2025-03-17T23:09:08.000000Z"}]},{"id":4947729,"change_date":"2024-02-07 21:40:00","inspection_id":"80736035","dot_number":"27863","report_state":"CT","report_number":"3129004650","insp_date":"2024-02-01 00:00:00","insp_start_time":"1035","insp_end_time":"1143","registration_date":"2024-02-07 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"1055410","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-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"698502","transaction_code":"C","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-02-01 21:42:00","snet_input_date":"2024-02-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-01 21:42:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:49.000000Z","updated_at":"2025-03-17T20:00:49.000000Z","inspection_violations":[{"id":7620685,"change_date":"2024-02-07 21:40:00","inspection_id":"80736035","insp_violation_id":"257699925","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199300797","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"3922"},{"id":7620686,"change_date":"2024-02-07 21:40:00","inspection_id":"80736035","insp_violation_id":"257699926","seq_no":"2","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"199300798","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":7962468,"change_date":"2024-02-07 21:40:00","inspection_id":"80736035","insp_unit_id":"199300797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"321218","insp_unit_license":"2728601","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV7KSKE0581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:10.000000Z","updated_at":"2025-03-17T23:07:10.000000Z"},{"id":7962469,"change_date":"2024-02-07 21:40:00","inspection_id":"80736035","insp_unit_id":"199300798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5310028","insp_unit_license":"248529F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS25390M851922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:10.000000Z","updated_at":"2025-03-17T23:07:10.000000Z"}]},{"id":4963005,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","dot_number":"27863","report_state":"VT","report_number":"4600000035","insp_date":"2024-01-02 00:00:00","insp_start_time":"0919","insp_end_time":"0958","registration_date":"2024-02-26 00:00:00","region":"ET","ci_status_code":"C","location":"0105","location_desc":"FERRISBURGH","county_code_state":"VT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HPC FOODSERVICE","shipping_paper_number":"3782","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"203269","transaction_code":"C","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2024-02-02 21:41:00","snet_input_date":"2024-01-02 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-02-02 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:11.000000Z","updated_at":"2025-03-17T20:01:11.000000Z","inspection_violations":[{"id":7644829,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","insp_violation_id":"258054067","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199613723","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39347E"},{"id":7644830,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","insp_violation_id":"258054068","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199613723","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39353B"},{"id":7644831,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","insp_violation_id":"258054069","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199613723","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3963A1"},{"id":7644832,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","insp_violation_id":"258054070","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"199613723","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39345D"},{"id":7644833,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","insp_violation_id":"258054071","seq_no":"5","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"199613723","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"393209E"}],"inspection_per_units":[{"id":7987225,"change_date":"2024-02-27 21:39:00","inspection_id":"80752846","insp_unit_id":"199613723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"751284","insp_unit_license":"62108A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN9JH253245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:24.000000Z","updated_at":"2025-03-17T23:07:24.000000Z"}]},{"id":4585895,"change_date":"2023-12-12 21:41:00","inspection_id":"80340328","dot_number":"27863","report_state":"MA","report_number":"DR00000300","insp_date":"2023-12-04 00:00:00","insp_start_time":"1631","insp_end_time":"1639","registration_date":"2023-12-12 00:00:00","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":"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":"2023-12-08 21:40: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":"480328","transaction_code":"C","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2023-12-08 21:40:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-12-08 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:46.000000Z","updated_at":"2025-03-17T19:53:46.000000Z","inspection_violations":[{"id":7094009,"change_date":"2023-12-12 21:41:00","inspection_id":"80340328","insp_violation_id":"256836433","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:16.000000Z","updated_at":"2025-03-17T21:40:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7375921,"change_date":"2023-12-12 21:41:00","inspection_id":"80340328","insp_unit_id":"198461082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"665524","insp_unit_license":"59720A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN0HH655083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:00.000000Z","updated_at":"2025-03-17T23:02:00.000000Z"}]},{"id":4534783,"change_date":"2023-12-01 21:42:00","inspection_id":"80284118","dot_number":"27863","report_state":"NH","report_number":"0940000627","insp_date":"2023-12-01 00:00:00","insp_start_time":"0553","insp_end_time":"0607","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LAMSON STREET\/KEENE","county_code_state":"NH","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"271316","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-12-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:36.000000Z","updated_at":"2025-03-17T19:52:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7293388,"change_date":"2023-12-01 21:42:00","inspection_id":"80284118","insp_unit_id":"198298577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"59719A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN9HH655082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:15.000000Z","updated_at":"2025-03-17T23:01:15.000000Z"}]},{"id":4339312,"change_date":"2023-11-02 21:41:00","inspection_id":"80068554","dot_number":"27863","report_state":"MA","report_number":"CP00003619","insp_date":"2023-11-02 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-02 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":"477683","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2023-11-02 21:41:00","snet_input_date":"2023-11-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-02 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:47.000000Z","updated_at":"2025-03-17T19:48:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6978860,"change_date":"2023-11-02 21:41:00","inspection_id":"80068554","insp_unit_id":"197871486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"23962MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W164H7000477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"}]},{"id":4190101,"change_date":"2023-10-19 21:40:00","inspection_id":"79903628","dot_number":"27863","report_state":"CT","report_number":"3015002318","insp_date":"2023-10-13 00:00:00","insp_start_time":"0809","insp_end_time":"0839","registration_date":"2023-10-18 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RLS LOGISTICS","shipping_paper_number":"1673723","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"688810","transaction_code":"C","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:51.000000Z","updated_at":"2025-03-17T19:45:51.000000Z","inspection_violations":[{"id":6487629,"change_date":"2023-10-19 21:40:00","inspection_id":"79903628","insp_violation_id":"255922721","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197633281","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"3939A"},{"id":6487630,"change_date":"2023-10-19 21:40:00","inspection_id":"79903628","insp_violation_id":"255922722","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197633281","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6738419,"change_date":"2023-10-19 21:40:00","inspection_id":"79903628","insp_unit_id":"197633280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"61674A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGEDR8JDJS0779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"},{"id":6738420,"change_date":"2023-10-19 21:40:00","inspection_id":"79903628","insp_unit_id":"197633281","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"N\/A","insp_unit_license":"248529F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS25390M851922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":3862875,"change_date":"2023-08-30 21:43:00","inspection_id":"79540246","dot_number":"27863","report_state":"CT","report_number":"3016000543","insp_date":"2023-08-29 00:00:00","insp_start_time":"0727","insp_end_time":"0751","registration_date":null,"region":"ET","ci_status_code":"C","location":"096","location_desc":"145 DANBURY RD NEW MILFORD","county_code_state":"CT","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CANDLEWOOD VALLEY HEALTH","shipping_paper_number":"3072361","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"684824","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-08-30 21:43:00","snet_input_date":"2023-08-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-30 21:43:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:20.000000Z","updated_at":"2025-03-17T19:39:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6210553,"change_date":"2023-08-30 21:43:00","inspection_id":"79540246","insp_unit_id":"196799088","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"830571","insp_unit_license":"63981A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE7KDKN8123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:11.000000Z","updated_at":"2025-03-17T22:52:11.000000Z"}]},{"id":3862851,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","dot_number":"27863","report_state":"CT","report_number":"3025002968","insp_date":"2023-08-28 00:00:00","insp_start_time":"1328","insp_end_time":"1428","registration_date":"2023-08-30 00:00:00","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":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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"684880","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-08-30 21:43:00","snet_input_date":"2023-08-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-30 21:43:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:20.000000Z","updated_at":"2025-03-17T19:39:20.000000Z","inspection_violations":[{"id":5965797,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","insp_violation_id":"254964076","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"196799030","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y998710-4","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39375A"},{"id":5965798,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","insp_violation_id":"254964077","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196799030","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y998710-4","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39345B2"},{"id":5965799,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","insp_violation_id":"254964078","seq_no":"3","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"196799030","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"393201D"},{"id":5965800,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","insp_violation_id":"254964079","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196799030","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39347E"},{"id":5965801,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","insp_violation_id":"254964080","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196799030","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6210516,"change_date":"2023-08-30 21:43:00","inspection_id":"79540218","insp_unit_id":"196799030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"830572","insp_unit_license":"63982A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE9KDKN8124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:11.000000Z","updated_at":"2025-03-17T22:52:11.000000Z"}]},{"id":3348473,"change_date":"2023-07-05 21:41:00","inspection_id":"78963846","dot_number":"27863","report_state":"CT","report_number":"3011000401","insp_date":"2023-06-23 00:00:00","insp_start_time":"1021","insp_end_time":"1110","registration_date":"2023-07-05 00:00:00","region":"ET","ci_status_code":"C","location":"132","location_desc":"SOUTH WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITTYS LLC","shipping_paper_number":"1666569","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-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"678346","transaction_code":"C","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-06-23 21:39:00","snet_input_date":"2023-06-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-23 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:21.000000Z","updated_at":"2025-03-17T19:29:21.000000Z","inspection_violations":[{"id":5163961,"change_date":"2023-07-05 21:41:00","inspection_id":"78963846","insp_violation_id":"253855217","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195814242","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5382962,"change_date":"2023-07-05 21:41:00","inspection_id":"78963846","insp_unit_id":"195814242","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":"245360","insp_unit_license":"2916017","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN5LL899562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:27.000000Z","updated_at":"2025-03-17T22:45:27.000000Z"}]},{"id":3290014,"change_date":"2023-06-26 21:40:00","inspection_id":"78897900","dot_number":"27863","report_state":"MA","report_number":"CW00001775","insp_date":"2023-06-15 00:00:00","insp_start_time":"0524","insp_end_time":"0538","registration_date":"2023-06-26 00:00:00","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":"SAME","shipping_paper_number":"99288","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-15 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":"468226","transaction_code":"C","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2023-06-15 21:41:00","snet_input_date":"2023-06-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-06-15 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:09.000000Z","updated_at":"2025-03-17T19:28:09.000000Z","inspection_violations":[{"id":5073787,"change_date":"2023-06-26 21:40:00","inspection_id":"78897900","insp_violation_id":"253690335","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:35.000000Z","updated_at":"2025-03-17T21:30:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5289541,"change_date":"2023-06-26 21:40:00","inspection_id":"78897900","insp_unit_id":"195663619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"62107A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN7JH253244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:40.000000Z","updated_at":"2025-03-17T22:44:40.000000Z"}]},{"id":3254481,"change_date":"2023-06-14 21:41:00","inspection_id":"78857611","dot_number":"27863","report_state":"CT","report_number":"0935000228","insp_date":"2023-06-09 00:00:00","insp_start_time":"1218","insp_end_time":"1312","registration_date":"2023-06-14 00:00:00","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":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"6142801","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-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"676872","transaction_code":"C","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-06-12 21:39:00","snet_input_date":"2023-06-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-12 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:22.000000Z","updated_at":"2025-03-17T19:27:22.000000Z","inspection_violations":[{"id":5017871,"change_date":"2023-06-14 21:41:00","inspection_id":"78857611","insp_violation_id":"253490792","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195485658","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5233953,"change_date":"2023-06-14 21:41:00","inspection_id":"78857611","insp_unit_id":"195485657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"37405","insp_unit_license":"68127A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV6MSMK7558","insp_unit_decal":"Y","insp_unit_decal_number":"32752746","created_at":"2025-03-17T22:44:15.000000Z","updated_at":"2025-03-17T22:44:15.000000Z"},{"id":5233954,"change_date":"2023-06-14 21:41:00","inspection_id":"78857611","insp_unit_id":"195485658","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"665565","insp_unit_license":"AE17913","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526162814G5001044","insp_unit_decal":"Y","insp_unit_decal_number":"32752747","created_at":"2025-03-17T22:44:15.000000Z","updated_at":"2025-03-17T22:44:15.000000Z"}]},{"id":3198024,"change_date":"2023-06-02 21:41:00","inspection_id":"78794098","dot_number":"27863","report_state":"CT","report_number":"3132003851","insp_date":"2023-06-01 00:00:00","insp_start_time":"0738","insp_end_time":"0809","registration_date":"2023-06-02 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"3050336","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"675900","transaction_code":"A","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-06-02 21:41:00","snet_input_date":"2023-06-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-02 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:09.000000Z","updated_at":"2025-03-17T19:26:09.000000Z","inspection_violations":[{"id":4926652,"change_date":"2023-06-02 21:41:00","inspection_id":"78794098","insp_violation_id":"253227555","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195271380","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5143820,"change_date":"2023-06-02 21:41:00","inspection_id":"78794098","insp_unit_id":"195271380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2916017","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN5LL899562","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:31.000000Z","updated_at":"2025-03-17T22:43:31.000000Z"}]},{"id":3138255,"change_date":"2023-06-05 21:42:00","inspection_id":"78726396","dot_number":"27863","report_state":"VT","report_number":"4100003915","insp_date":"2023-05-25 00:00:00","insp_start_time":"0941","insp_end_time":"1013","registration_date":"2023-06-03 00:00:00","region":"ET","ci_status_code":"C","location":"0417NB","location_desc":"WILLISTON RA NB","county_code_state":"VT","county_code":"007","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-05-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"198852","transaction_code":"C","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-05-25 21:41:00","snet_input_date":"2023-05-25 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-05-25 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:01.000000Z","updated_at":"2025-03-17T19:25:01.000000Z","inspection_violations":[{"id":4831791,"change_date":"2023-06-05 21:42:00","inspection_id":"78726396","insp_violation_id":"253275318","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"195308408","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":5047221,"change_date":"2023-06-05 21:42:00","inspection_id":"78726396","insp_unit_id":"195308408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64067A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE0KDKN8125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:47.000000Z","updated_at":"2025-03-17T22:42:47.000000Z"}]},{"id":3090112,"change_date":"2023-05-25 21:41:00","inspection_id":"78672251","dot_number":"27863","report_state":"CT","report_number":"3091004795","insp_date":"2023-05-19 00:00:00","insp_start_time":"1328","insp_end_time":"1357","registration_date":"2023-05-25 00:00:00","region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"3047027","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"675074","transaction_code":"C","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[{"id":4751569,"change_date":"2023-05-25 21:41:00","inspection_id":"78672251","insp_violation_id":"253066803","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y996110-1","created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4970688,"change_date":"2023-05-25 21:41:00","inspection_id":"78672251","insp_unit_id":"195131676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"350085","insp_unit_license":"66401A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV8LSLX7227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"},{"id":4970689,"change_date":"2023-05-25 21:41:00","inspection_id":"78672251","insp_unit_id":"195131677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"830511","insp_unit_license":"AJ72512","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526163627J5001306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":2949703,"change_date":"2023-05-15 21:41:00","inspection_id":"78513628","dot_number":"27863","report_state":"CT","report_number":"3087002479","insp_date":"2023-05-03 00:00:00","insp_start_time":"1500","insp_end_time":"1525","registration_date":"2023-05-15 00:00:00","region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"673466","transaction_code":"C","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-05-03 21:41:00","snet_input_date":"2023-05-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[{"id":4527674,"change_date":"2023-05-15 21:41:00","inspection_id":"78513628","insp_violation_id":"252816634","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":"Y995651-4","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"3922"},{"id":4527675,"change_date":"2023-05-15 21:41:00","inspection_id":"78513628","insp_violation_id":"252816635","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"Y995654-0","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":4746100,"change_date":"2023-05-15 21:41:00","inspection_id":"78513628","insp_unit_id":"194917969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"70063A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN8HH639083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"}]},{"id":2681765,"change_date":"2023-03-29 21:41:00","inspection_id":"78208865","dot_number":"27863","report_state":"NH","report_number":"1085002950","insp_date":"2023-03-28 00:00:00","insp_start_time":"0725","insp_end_time":"0746","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NORTHFIELD","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-29 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":"265147","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-03-29 21:41:00","snet_input_date":"2023-03-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-03-29 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:11.000000Z","updated_at":"2025-03-17T19:16:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4317877,"change_date":"2023-03-29 21:41:00","inspection_id":"78208865","insp_unit_id":"194111110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"64091A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN6KH135302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:01.000000Z","updated_at":"2025-03-17T22:37:01.000000Z"}]},{"id":2419383,"change_date":"2023-02-27 21:40:00","inspection_id":"77911241","dot_number":"27863","report_state":"CT","report_number":"0779000765","insp_date":"2023-02-22 00:00:00","insp_start_time":"1417","insp_end_time":"1445","registration_date":"2023-02-27 00:00:00","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":"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":"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-02-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"667330","transaction_code":"C","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-02-22 21:39:00","snet_input_date":"2023-02-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-22 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:07.000000Z","updated_at":"2025-03-17T19:11:07.000000Z","inspection_violations":[{"id":3726846,"change_date":"2023-02-27 21:40:00","inspection_id":"77911241","insp_violation_id":"251341733","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3893970,"change_date":"2023-02-27 21:40:00","inspection_id":"77911241","insp_unit_id":"193583863","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"415438","insp_unit_license":"69744A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDVXNSNJ2579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:53.000000Z","updated_at":"2025-03-17T22:33:53.000000Z"},{"id":3893971,"change_date":"2023-02-27 21:40:00","inspection_id":"77911241","insp_unit_id":"193583864","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":"1","insp_unit_license":"3129516","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"526163626K5001427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:53.000000Z","updated_at":"2025-03-17T22:33:53.000000Z"}]},{"id":2342166,"change_date":"2023-02-14 21:40:00","inspection_id":"77822737","dot_number":"27863","report_state":"CT","report_number":"3017000981","insp_date":"2023-02-08 00:00:00","insp_start_time":"1335","insp_end_time":"1401","registration_date":"2023-02-14 00:00:00","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":"SELF","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":"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-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"666116","transaction_code":"C","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","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":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","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":[{"id":3607331,"change_date":"2023-02-14 21:40:00","inspection_id":"77822737","insp_violation_id":"251114347","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":"Y993610-0","created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3768911,"change_date":"2023-02-14 21:40:00","inspection_id":"77822737","insp_unit_id":"193380584","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"374696","insp_unit_license":"67374A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV5MSMK7549","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":3768912,"change_date":"2023-02-14 21:40:00","inspection_id":"77822737","insp_unit_id":"193380585","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDRO","insp_unit_company":"665568","insp_unit_license":"AE44623","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"52616281XG5001047","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":2176099,"change_date":"2023-01-19 21:43:00","inspection_id":"77633619","dot_number":"27863","report_state":"MA","report_number":"CW00001246","insp_date":"2023-01-19 00:00:00","insp_start_time":"0605","insp_end_time":"0620","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":"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":"2023-01-19 21:43: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":"458925","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2023-01-19 21:43:00","snet_input_date":"2023-01-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-19 21:43:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[{"id":3362951,"change_date":"2023-01-19 21:43:00","inspection_id":"77633619","insp_violation_id":"250648483","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":"769745AB","created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3502323,"change_date":"2023-01-19 21:43:00","inspection_id":"77633619","insp_unit_id":"192944108","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"59687A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN6HH639082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":2063222,"change_date":"2023-01-04 21:39:00","inspection_id":"77504042","dot_number":"27863","report_state":"VT","report_number":"4100003775","insp_date":"2022-12-28 00:00:00","insp_start_time":"1031","insp_end_time":"1053","registration_date":null,"region":"ET","ci_status_code":"C","location":"0417SB","location_desc":"WILLISTON RA SB","county_code_state":"VT","county_code":"007","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":"2023-01-04 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":"195864","transaction_code":"A","transaction_date":"2022-12-28 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2023-01-04 21:39:00","snet_input_date":"2022-12-28 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-01-04 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:43.000000Z","updated_at":"2025-03-17T19:04:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3319039,"change_date":"2023-01-04 21:39:00","inspection_id":"77504042","insp_unit_id":"192688731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"62106A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN5JH253243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:45.000000Z","updated_at":"2025-03-17T22:29:45.000000Z"}]},{"id":1957769,"change_date":"2023-01-05 21:39:00","inspection_id":"77383931","dot_number":"27863","report_state":"CT","report_number":"3091004404","insp_date":"2022-12-15 00:00:00","insp_start_time":"1231","insp_end_time":"1315","registration_date":"2023-01-03 00:00:00","region":"ET","ci_status_code":"C","location":"146","location_desc":"VERNON","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"SI-00008325","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"661255","transaction_code":"C","transaction_date":"2022-12-15 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-12-16 21:39:00","snet_input_date":"2022-12-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-16 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:36.000000Z","updated_at":"2025-03-17T19:02:36.000000Z","inspection_violations":[{"id":3040861,"change_date":"2023-01-05 21:39:00","inspection_id":"77383931","insp_violation_id":"250396499","seq_no":"1","part_no":"392","part_no_section":"82(a)(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":"Y992564-4","created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":3150233,"change_date":"2023-01-05 21:39:00","inspection_id":"77383931","insp_unit_id":"192707431","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"415442","insp_unit_license":"69748A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV1NSNJ2583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:35.000000Z","updated_at":"2025-03-17T22:28:35.000000Z"},{"id":3150234,"change_date":"2023-01-05 21:39:00","inspection_id":"77383931","insp_unit_id":"192707432","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"194659","insp_unit_license":"BN42205","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA0626JB131407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:35.000000Z","updated_at":"2025-03-17T22:28:35.000000Z"}]},{"id":1857383,"change_date":"2022-12-02 21:40:00","inspection_id":"77268767","dot_number":"27863","report_state":"NY","report_number":"0325001558","insp_date":"2022-12-01 00:00:00","insp_start_time":"1236","insp_end_time":"1302","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585M","location_desc":"NICHOLS REST AREA (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"HPC FOODSERVICE","shipping_paper_number":"11302022","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-12-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2776047","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2022-12-02 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-02 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"PO BOX 1228","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:47.000000Z","updated_at":"2025-03-17T19:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2988639,"change_date":"2022-12-02 21:40:00","inspection_id":"77268767","insp_unit_id":"192225847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"69747A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDVXNSNJ2582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"},{"id":2988640,"change_date":"2022-12-02 21:40:00","inspection_id":"77268767","insp_unit_id":"192225848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"3155765","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"52616362XK5001429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"}]},{"id":1701527,"change_date":"2022-11-09 21:39:00","inspection_id":"77090113","dot_number":"27863","report_state":"CT","report_number":"3061001792","insp_date":"2022-11-09 00:00:00","insp_start_time":"1352","insp_end_time":"1403","registration_date":null,"region":"ET","ci_status_code":"C","location":"162","location_desc":"WINCHESTER","county_code_state":"CT","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"55001","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":"658357","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-11-09 21:39:00","snet_input_date":"2022-11-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-09 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:09.000000Z","updated_at":"2025-03-17T18:58:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2737855,"change_date":"2022-11-09 21:39:00","inspection_id":"77090113","insp_unit_id":"191870108","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64067A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE0KDKN8125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":1454712,"change_date":"2022-12-29 21:39:00","inspection_id":"76806074","dot_number":"27863","report_state":"RI","report_number":"00SH001806","insp_date":"2022-09-02 00:00:00","insp_start_time":"0603","insp_end_time":"0607","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 6 BYPASS","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"HPC","shipping_paper_number":"2976623","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":"I","final_status_date":"2022-10-06 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":"78052","transaction_code":"C","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","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":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"PO BOX 1228","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","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":[],"inspection_per_units":[{"id":2341721,"change_date":"2022-12-29 21:39:00","inspection_id":"76806074","insp_unit_id":"192620249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"64091A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN6KH135302","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":775648,"change_date":"2022-07-21 21:39:00","inspection_id":"76015134","dot_number":"27863","report_state":"CT","report_number":"3078001035","insp_date":"2022-07-08 00:00:00","insp_start_time":"0522","insp_end_time":"0550","registration_date":"2022-07-21 00:00:00","region":"ET","ci_status_code":"C","location":"159","location_desc":"WETHERSFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"MANIFESR","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":"2022-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"648310","transaction_code":"C","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[{"id":1225504,"change_date":"2022-07-21 21:39:00","inspection_id":"76015134","insp_violation_id":"247222012","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:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1248129,"change_date":"2022-07-21 21:39:00","inspection_id":"76015134","insp_unit_id":"189888284","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"68125A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV2MSMK7556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"},{"id":1248130,"change_date":"2022-07-21 21:39:00","inspection_id":"76015134","insp_unit_id":"189888285","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":"751272","insp_unit_license":"AH48474","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526163227H5001189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]},{"id":612963,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","dot_number":"27863","report_state":"CT","report_number":"0797000009","insp_date":"2022-06-15 00:00:00","insp_start_time":"0655","insp_end_time":"0850","registration_date":"2022-06-28 00:00:00","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":"HPC FODSERVICE","shipping_paper_number":"1642139","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-06-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"646546","transaction_code":"C","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-06-15 21:40:00","snet_input_date":"2022-06-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-15 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:28.000000Z","updated_at":"2025-03-17T18:38:28.000000Z","inspection_violations":[{"id":963079,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","insp_violation_id":"246750645","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"38323A2"},{"id":963080,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","insp_violation_id":"246750646","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189490467","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39355E"},{"id":963081,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","insp_violation_id":"246750647","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189490467","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39345B2"},{"id":963082,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","insp_violation_id":"246750648","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189490467","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":985923,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","insp_unit_id":"189490466","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"415442","insp_unit_license":"69748A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV1NSNJ2583","insp_unit_decal":"Y","insp_unit_decal_number":"31375732","created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"},{"id":985924,"change_date":"2022-06-28 21:42:00","inspection_id":"75823463","insp_unit_id":"189490467","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIDRO","insp_unit_company":"751263","insp_unit_license":"BE28864","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"526164829H5001188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"}]},{"id":546858,"change_date":"2022-06-28 21:42:00","inspection_id":"75744812","dot_number":"27863","report_state":"MA","report_number":"CK00002128","insp_date":"2022-06-03 00:00:00","insp_start_time":"1050","insp_end_time":"1100","registration_date":"2022-06-28 00:00:00","region":"ET","ci_status_code":"C","location":"038S","location_desc":"S-BOSTON","county_code_state":"MA","county_code":"025","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":"2022-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"447226","transaction_code":"C","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2022-06-06 21:40:00","snet_input_date":"2022-06-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-06-06 21:40:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:25.000000Z","updated_at":"2025-03-17T18:37:25.000000Z","inspection_violations":[{"id":861151,"change_date":"2022-06-28 21:42:00","inspection_id":"75744812","insp_violation_id":"246751602","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:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":879736,"change_date":"2022-06-28 21:42:00","inspection_id":"75744812","insp_unit_id":"189490929","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"71669A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKBHSDV7NSNS9824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:36.000000Z","updated_at":"2025-03-17T22:13:36.000000Z"},{"id":879737,"change_date":"2022-06-28 21:42:00","inspection_id":"75744812","insp_unit_id":"189490930","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"AE44164","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"52616281XG5001050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:36.000000Z","updated_at":"2025-03-17T22:13:36.000000Z"}]},{"id":427645,"change_date":"2022-06-29 21:41:00","inspection_id":"75602947","dot_number":"27863","report_state":"ME","report_number":"4468005567","insp_date":"2022-05-19 00:00:00","insp_start_time":"0735","insp_end_time":"0758","registration_date":"2022-06-27 00:00:00","region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2022-05-19 21:41: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":"347205","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":"M","census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"PO BOX 1228","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:08.000000Z","updated_at":"2025-03-17T18:35:08.000000Z","inspection_violations":[{"id":671858,"change_date":"2022-06-29 21:41:00","inspection_id":"75602947","insp_violation_id":"246785070","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189517379","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39345B2"},{"id":671859,"change_date":"2022-06-29 21:41:00","inspection_id":"75602947","insp_violation_id":"246785071","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189517379","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":689709,"change_date":"2022-06-29 21:41:00","inspection_id":"75602947","insp_unit_id":"189517379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"751284","insp_unit_license":"62108A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN9JH253245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"}]},{"id":402632,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","dot_number":"27863","report_state":"CT","report_number":"0935000172","insp_date":"2022-05-10 00:00:00","insp_start_time":"0712","insp_end_time":"0831","registration_date":"2022-06-20 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"I-84 EXIT 28 COMM LOT","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION COMPANY INC","shipping_paper_number":"90977","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-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"643950","transaction_code":"C","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-05-17 21:42:00","snet_input_date":"2022-05-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-17 21:42:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:45.000000Z","updated_at":"2025-03-17T18:34:45.000000Z","inspection_violations":[{"id":629223,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_violation_id":"246578948","seq_no":"1","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39530B1"},{"id":629224,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_violation_id":"246578949","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189342855","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39347E"},{"id":629225,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_violation_id":"246578950","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189342855","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39353B"},{"id":629226,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_violation_id":"246578951","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189342855","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39345B2"},{"id":629227,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_violation_id":"246578952","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189342855","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39345B2"},{"id":629228,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_violation_id":"246578953","seq_no":"6","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"189342855","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39347D"}],"inspection_per_units":[{"id":650325,"change_date":"2022-06-20 21:35:00","inspection_id":"75573247","insp_unit_id":"189342855","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"830573","insp_unit_license":"64067A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALHCYFE0KDKN8125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:12.000000Z","updated_at":"2025-03-17T22:12:12.000000Z"}]},{"id":316921,"change_date":"2022-05-09 21:40:00","inspection_id":"75471018","dot_number":"27863","report_state":"VT","report_number":"3800002768","insp_date":"2022-05-02 00:00:00","insp_start_time":"1108","insp_end_time":"1126","registration_date":"2022-05-06 00:00:00","region":"ET","ci_status_code":"C","location":"0413","location_desc":"SHELBURNE","county_code_state":"VT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HARTFORD PROVISION CO","shipping_paper_number":"2938691","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-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"191476","transaction_code":"C","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-05-04 21:41:00","snet_input_date":"2022-05-02 00:00:00","source_office":"1VTS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:59.000000Z","updated_at":"2025-03-17T18:32:59.000000Z","inspection_violations":[{"id":494655,"change_date":"2022-05-09 21:40:00","inspection_id":"75471018","insp_violation_id":"245646829","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188563402","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":512426,"change_date":"2022-05-09 21:40:00","inspection_id":"75471018","insp_unit_id":"188563402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"833638","insp_unit_license":"64091A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMMMN6KH135302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:20.000000Z","updated_at":"2025-03-17T22:11:20.000000Z"}]},{"id":95989,"change_date":"2022-04-11 21:40:00","inspection_id":"75205461","dot_number":"27863","report_state":"CT","report_number":"3009002099","insp_date":"2022-04-04 00:00:00","insp_start_time":"1428","insp_end_time":"1445","registration_date":"2022-04-11 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I-84 E\/B BY EXIT 23","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"TRIP SLIP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"641419","transaction_code":"C","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00027863","upload_search_indicator":null,"census_search_date":"2022-04-04 21:39:00","snet_input_date":"2022-04-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-04-04 21:39:00","insp_carrier_name":"HARTFORD PROVISION COMPANY INC","insp_carrier_street":"625 NUTMEG ROAD NORTH","insp_carrier_city":"SOUTH WINDSOR","insp_carrier_state":"CT","insp_carrier_zip_code":"06074","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":[{"id":142134,"change_date":"2022-04-11 21:40:00","inspection_id":"75205461","insp_violation_id":"245060379","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:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3922"},{"id":142135,"change_date":"2022-04-11 21:40:00","inspection_id":"75205461","insp_violation_id":"245060380","seq_no":"2","part_no":"390","part_no_section":"19(a)(1)","insp_viol_unit":"1","insp_unit_id":"188071348","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39019A1"}],"inspection_per_units":[{"id":155472,"change_date":"2022-04-11 21:40:00","inspection_id":"75205461","insp_unit_id":"188071348","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"350084","insp_unit_license":"66406A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV6LSLX7226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:10.000000Z","updated_at":"2025-03-17T22:09:10.000000Z"},{"id":155473,"change_date":"2022-04-11 21:40:00","inspection_id":"75205461","insp_unit_id":"188071349","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"AE44692","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"52616362XG5001034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:10.000000Z","updated_at":"2025-03-17T22:09:10.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/27863\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/27863\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/27863\/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\/27863\/inspections","per_page":100,"prev_page_url":null,"to":82,"total":82}