{"current_page":1,"data":[{"id":12514490,"change_date":"2026-07-22 21:43:00","inspection_id":"88479397","dot_number":"631647","report_state":"MN","report_number":"1618001027","insp_date":"2026-07-15 00:00:00","insp_start_time":"1156","insp_end_time":"1252","registration_date":null,"region":"CD","ci_status_code":"C","location":"CLKGVN","location_desc":"CLARKS GROVE MN","county_code_state":"MN","county_code":"047","insp_level_id":"1","service_center":"MW","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-07-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3806499","transaction_code":"A","transaction_date":"2026-07-21 00:00:00","upload_date":"2026-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2026-07-22 21:43:00","snet_input_date":"2026-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-22 21:43:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-25T09:41:27.000000Z","updated_at":"2026-07-26T09:40:30.000000Z","inspection_violations":[{"id":21786642,"change_date":"2026-07-22 21:43:00","inspection_id":"88479397","insp_violation_id":"275653602","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214749969","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-25T10:01:55.000000Z","updated_at":"2026-07-26T10:00:36.000000Z","normalized_code":"39347E"},{"id":21786643,"change_date":"2026-07-22 21:43:00","inspection_id":"88479397","insp_violation_id":"275653603","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"214749969","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-07-25T10:01:55.000000Z","updated_at":"2026-07-26T10:00:36.000000Z","normalized_code":"3963A1BOS"},{"id":21786644,"change_date":"2026-07-22 21:43:00","inspection_id":"88479397","insp_violation_id":"275653604","seq_no":"4","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-25T10:01:55.000000Z","updated_at":"2026-07-26T10:00:36.000000Z","normalized_code":"39141AMCPC"},{"id":21786641,"change_date":"2026-07-22 21:43:00","inspection_id":"88479397","insp_violation_id":"275653601","seq_no":"1","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"214749969","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-25T10:01:55.000000Z","updated_at":"2026-07-26T10:00:36.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":21733538,"change_date":"2026-07-22 21:43:00","inspection_id":"88479397","insp_unit_id":"214749969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"175","insp_unit_license":"YCG1652","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NPKHM6X0RM686403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-25T09:20:24.000000Z","updated_at":"2026-07-26T09:17:06.000000Z"}]},{"id":12382494,"change_date":"2026-07-08 21:41:00","inspection_id":"88345494","dot_number":"631647","report_state":"MN","report_number":"0134000637","insp_date":"2026-07-01 00:00:00","insp_start_time":"0908","insp_end_time":"0956","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SAINT PETER MN","county_code_state":"MN","county_code":"103","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3704618","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:35.000000Z","updated_at":"2026-07-19T09:30:48.000000Z","inspection_violations":[{"id":21548301,"change_date":"2026-07-08 21:41:00","inspection_id":"88345494","insp_violation_id":"275353856","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8826013400401","created_at":"2026-07-11T09:56:42.000000Z","updated_at":"2026-07-19T09:42:32.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":21501147,"change_date":"2026-07-08 21:41:00","inspection_id":"88345494","insp_unit_id":"214493779","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"YCD1793","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1D5PS202087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:31.000000Z","updated_at":"2026-07-19T09:02:07.000000Z"}]},{"id":12382284,"change_date":"2026-07-08 21:41:00","inspection_id":"88345271","dot_number":"631647","report_state":"MN","report_number":"0209000106","insp_date":"2026-07-01 00:00:00","insp_start_time":"0907","insp_end_time":"0941","registration_date":null,"region":"CD","ci_status_code":"C","location":"2200","location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"3704301","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:33.000000Z","updated_at":"2026-07-19T09:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21500800,"change_date":"2026-07-08 21:41:00","inspection_id":"88345271","insp_unit_id":"214493406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"27","insp_unit_license":"YCJ9347","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HA3GTC79SN006559","insp_unit_decal":"Y","insp_unit_decal_number":"36701890","created_at":"2026-07-11T09:15:29.000000Z","updated_at":"2026-07-19T09:02:03.000000Z"}]},{"id":12351488,"change_date":"2026-07-03 21:37:00","inspection_id":"88312504","dot_number":"631647","report_state":"MN","report_number":"0025000878","insp_date":"2026-06-26 00:00:00","insp_start_time":"0858","insp_end_time":"0937","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CHANHASSEN MN","county_code_state":"MN","county_code":"053","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"U","pen_cen_match":"I","final_status_date":"2026-07-03 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3675523","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2026-07-03 21:37:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-03 21:37:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-06T09:43:17.000000Z","updated_at":"2026-07-14T09:31:57.000000Z","inspection_violations":[{"id":21498375,"change_date":"2026-07-03 21:37:00","inspection_id":"88312504","insp_violation_id":"275288881","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":"2026-07-06T10:07:18.000000Z","updated_at":"2026-07-14T09:44:24.000000Z","normalized_code":"3922SLLS2"},{"id":21498376,"change_date":"2026-07-03 21:37:00","inspection_id":"88312504","insp_violation_id":"275288882","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"214433981","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-06T10:07:18.000000Z","updated_at":"2026-07-14T09:44:24.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":21449510,"change_date":"2026-07-03 21:37:00","inspection_id":"88312504","insp_unit_id":"214433981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"42","insp_unit_license":"YCG0193","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1C6GS807582","insp_unit_decal":"Y","insp_unit_decal_number":"36360975","created_at":"2026-07-06T09:21:31.000000Z","updated_at":"2026-07-14T09:03:50.000000Z"}]},{"id":10415534,"change_date":"2025-12-12 21:40:00","inspection_id":"86546459","dot_number":"631647","report_state":"MN","report_number":"0134000458","insp_date":"2025-12-05 00:00:00","insp_start_time":"0913","insp_end_time":"0945","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2646192","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-12-12 21:40:00","snet_input_date":"2025-12-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-12 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-15T10:31:52.000000Z","updated_at":"2025-12-23T10:30:10.000000Z","inspection_violations":[{"id":17460727,"change_date":"2025-12-12 21:40:00","inspection_id":"86546459","insp_violation_id":"270638879","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210567358","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:26.000000Z","updated_at":"2025-12-23T10:30:24.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":17420115,"change_date":"2025-12-12 21:40:00","inspection_id":"86546459","insp_unit_id":"210567358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCD2977","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDUF4GY9CEC64064","insp_unit_decal":"Y","insp_unit_decal_number":"3572124","created_at":"2025-12-15T10:02:27.000000Z","updated_at":"2025-12-23T10:00:13.000000Z"}]},{"id":10328568,"change_date":"2025-12-02 21:38:00","inspection_id":"86455480","dot_number":"631647","report_state":"MN","report_number":"0078000440","insp_date":"2025-11-25 00:00:00","insp_start_time":"1429","insp_end_time":"1446","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"3","service_center":"MW","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":"U","pen_cen_match":"I","final_status_date":"2025-12-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2604963","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-12-02 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-02 21:38:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:24.000000Z","updated_at":"2025-12-06T10:30:14.000000Z","inspection_violations":[{"id":17277386,"change_date":"2025-12-02 21:38:00","inspection_id":"86455480","insp_violation_id":"270386409","seq_no":"2","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882500780190","created_at":"2025-12-05T10:33:08.000000Z","updated_at":"2025-12-06T10:30:28.000000Z","normalized_code":"39282DUMT"},{"id":17277387,"change_date":"2025-12-02 21:38:00","inspection_id":"86455480","insp_violation_id":"270386410","seq_no":"3","part_no":"392","part_no_section":"2-SLLIT","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-05T10:33:08.000000Z","updated_at":"2025-12-06T10:30:28.000000Z","normalized_code":"3922SLLIT"},{"id":17277385,"change_date":"2025-12-02 21:38:00","inspection_id":"86455480","insp_violation_id":"270386408","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:08.000000Z","updated_at":"2025-12-06T10:30:28.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":17250025,"change_date":"2025-12-02 21:38:00","inspection_id":"86455480","insp_unit_id":"210349661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"43","insp_unit_license":"YBT8325","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DB4W1B2FS805006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:48.000000Z","updated_at":"2025-12-06T10:00:15.000000Z"}]},{"id":10067119,"change_date":"2025-10-29 21:40:00","inspection_id":"86180747","dot_number":"631647","report_state":"IA","report_number":"000P151W0V","insp_date":"2025-10-28 00:00:00","insp_start_time":"1015","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"SOUTH 8TH ST NB CLEAR LAKE","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"A H HERMEL CANDY AND TOBACCO COMPAN","shipping_paper_number":"FOREST CITY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1379256","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2025-10-29 21:40:00","snet_input_date":"2025-10-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:30.000000Z","updated_at":"2025-11-02T11:01:06.000000Z","inspection_violations":[{"id":16670847,"change_date":"2025-10-29 21:40:00","inspection_id":"86180747","insp_violation_id":"269594458","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209719511","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0NEL25102810264","created_at":"2025-11-01T10:17:58.000000Z","updated_at":"2025-11-02T11:16:41.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16733094,"change_date":"2025-10-29 21:40:00","inspection_id":"86180747","insp_unit_id":"209719511","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"YCC1671","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDXE4FN8NDC32383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:05.000000Z","updated_at":"2025-11-02T10:46:25.000000Z"}]},{"id":9931712,"change_date":"2025-10-14 21:41:00","inspection_id":"86037656","dot_number":"631647","report_state":"MN","report_number":"0134000394","insp_date":"2025-10-07 00:00:00","insp_start_time":"1335","insp_end_time":"1403","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"103","insp_level_id":"1","service_center":"MW","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-10-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2404214","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","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:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16484002,"change_date":"2025-10-14 21:41:00","inspection_id":"86037656","insp_unit_id":"209448556","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"175","insp_unit_license":"YCG1652","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NPKHM6X0RM686403","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":9791322,"change_date":"2025-09-26 21:40:00","inspection_id":"85890175","dot_number":"631647","report_state":"IA","report_number":"000P13X643","insp_date":"2025-09-25 00:00:00","insp_start_time":"0835","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 WB","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"A H HERMEL","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":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1375767","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:08.000000Z","updated_at":"2025-09-30T10:01:08.000000Z","inspection_violations":[{"id":16103156,"change_date":"2025-09-26 21:40:00","inspection_id":"85890175","insp_violation_id":"268949178","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-09-30T10:16:50.000000Z","updated_at":"2025-09-30T10:16:50.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16226856,"change_date":"2025-09-26 21:40:00","inspection_id":"85890175","insp_unit_id":"209168671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"GTS103","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA6GUCG2JN000488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:45.000000Z","updated_at":"2025-09-30T09:45:44.000000Z"}]},{"id":9777223,"change_date":"2025-09-25 21:40:00","inspection_id":"85875396","dot_number":"631647","report_state":"MN","report_number":"1768000683","insp_date":"2025-09-18 00:00:00","insp_start_time":"1003","insp_end_time":"1047","registration_date":null,"region":"CD","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON MN","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"5","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2322727","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-09-25 21:40:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:01.000000Z","updated_at":"2025-09-30T10:00:14.000000Z","inspection_violations":[{"id":16071715,"change_date":"2025-09-25 21:40:00","inspection_id":"85875396","insp_violation_id":"268915753","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"209139660","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-09-28T10:16:41.000000Z","updated_at":"2025-09-30T10:15:21.000000Z","normalized_code":"3922SLLMF"},{"id":16071716,"change_date":"2025-09-25 21:40:00","inspection_id":"85875396","insp_violation_id":"268915754","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"209139660","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-09-28T10:16:41.000000Z","updated_at":"2025-09-30T10:15:21.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":16197626,"change_date":"2025-09-25 21:40:00","inspection_id":"85875396","insp_unit_id":"209139660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"20","insp_unit_license":"YBK1288","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GB6G5CG4D1174816","insp_unit_decal":"Y","insp_unit_decal_number":"35507951","created_at":"2025-09-29T09:46:39.000000Z","updated_at":"2025-09-29T09:46:39.000000Z"}]},{"id":9302879,"change_date":"2025-08-01 21:38:00","inspection_id":"85377536","dot_number":"631647","report_state":"MN","report_number":"0134000330","insp_date":"2025-07-25 00:00:00","insp_start_time":"1213","insp_end_time":"1240","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"1","service_center":"MW","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-08-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2070238","transaction_code":"A","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-08-01 21:38:00","snet_input_date":"2025-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-01 21:38:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:38.000000Z","updated_at":"2025-08-06T10:42:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15318562,"change_date":"2025-08-01 21:38:00","inspection_id":"85377536","insp_unit_id":"208187796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"GSF094","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B2HS807765","insp_unit_decal":"Y","insp_unit_decal_number":"35506415","created_at":"2025-08-04T09:46:22.000000Z","updated_at":"2025-08-05T09:45:09.000000Z"}]},{"id":8976340,"change_date":"2025-06-25 21:39:00","inspection_id":"85033947","dot_number":"631647","report_state":"MN","report_number":"0134000285","insp_date":"2025-06-18 00:00:00","insp_start_time":"1242","insp_end_time":"1320","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1909916","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:59.000000Z","updated_at":"2025-06-30T10:00:10.000000Z","inspection_violations":[{"id":14427982,"change_date":"2025-06-25 21:39:00","inspection_id":"85033947","insp_violation_id":"267025743","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-06-28T10:16:45.000000Z","updated_at":"2025-06-29T10:15:15.000000Z","normalized_code":"3922SLLS2"},{"id":14427983,"change_date":"2025-06-25 21:39:00","inspection_id":"85033947","insp_violation_id":"267025744","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207537313","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:45.000000Z","updated_at":"2025-06-29T10:15:15.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":14717731,"change_date":"2025-06-25 21:39:00","inspection_id":"85033947","insp_unit_id":"207537313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"YCE6377","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"7GZ37TC77PN000869","insp_unit_decal":"Y","insp_unit_decal_number":"35279319","created_at":"2025-06-28T09:46:08.000000Z","updated_at":"2025-06-29T09:45:15.000000Z"}]},{"id":8872913,"change_date":"2025-06-11 21:42:00","inspection_id":"84923929","dot_number":"631647","report_state":"IA","report_number":"000P169B2H","insp_date":"2025-06-10 00:00:00","insp_start_time":"0726","insp_end_time":"0734","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 69 SB\/260TH ST","county_code_state":"IA","county_code":"197","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","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-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1363640","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:01:01.000000Z","updated_at":"2025-06-15T10:00:38.000000Z","inspection_violations":[{"id":14216808,"change_date":"2025-06-11 21:42:00","inspection_id":"84923929","insp_violation_id":"266784255","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-06-14T10:16:35.000000Z","updated_at":"2025-06-17T10:17:40.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14532309,"change_date":"2025-06-11 21:42:00","inspection_id":"84923929","insp_unit_id":"207333602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"88","insp_unit_license":"YBY0188","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1B9JS811348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:52.000000Z"}]},{"id":8852732,"change_date":"2025-06-09 21:41:00","inspection_id":"84902592","dot_number":"631647","report_state":"IA","report_number":"000P11SFW6","insp_date":"2025-06-05 00:00:00","insp_start_time":"0805","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"A.H. HERMEL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1363218","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2025-06-09 21:41:00","snet_input_date":"2025-06-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-09 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:33.000000Z","updated_at":"2025-06-14T10:00:33.000000Z","inspection_violations":[{"id":14178446,"change_date":"2025-06-09 21:41:00","inspection_id":"84902592","insp_violation_id":"266740864","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7LEW25060508133","created_at":"2025-06-12T10:15:52.000000Z","updated_at":"2025-06-13T10:17:39.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":14496445,"change_date":"2025-06-09 21:41:00","inspection_id":"84902592","insp_unit_id":"207294454","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"176","insp_unit_license":"YCF9966","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5PVNJ8JV4L4S76884","insp_unit_decal":"Y","insp_unit_decal_number":"35251265","created_at":"2025-06-13T09:45:34.000000Z","updated_at":"2025-06-13T09:45:34.000000Z"}]},{"id":8809684,"change_date":"2025-06-04 21:40:00","inspection_id":"84856930","dot_number":"631647","report_state":"MN","report_number":"0092000465","insp_date":"2025-05-28 00:00:00","insp_start_time":"1311","insp_end_time":"1332","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MAPLE GROVE MN","county_code_state":"MN","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1070601","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":"U","pen_cen_match":"I","final_status_date":"2025-06-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1817571","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-06-04 21:40:00","snet_input_date":"2025-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-04 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:00:55.000000Z","updated_at":"2025-06-09T10:00:06.000000Z","inspection_violations":[{"id":14095619,"change_date":"2025-06-04 21:40:00","inspection_id":"84856930","insp_violation_id":"266647173","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":"WARNING","created_at":"2025-06-07T10:16:37.000000Z","updated_at":"2025-06-08T10:16:41.000000Z","normalized_code":"3922SLLS3"},{"id":14095620,"change_date":"2025-06-04 21:40:00","inspection_id":"84856930","insp_violation_id":"266647174","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-06-07T10:16:37.000000Z","updated_at":"2025-06-08T10:16:41.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14420156,"change_date":"2025-06-04 21:40:00","inspection_id":"84856930","insp_unit_id":"207211734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"51","insp_unit_license":"HLY654","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1BXJS804764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:08.000000Z","updated_at":"2025-06-08T09:45:07.000000Z"}]},{"id":8742864,"change_date":"2025-05-27 21:39:00","inspection_id":"84786306","dot_number":"631647","report_state":"IA","report_number":"000P16D8VR","insp_date":"2025-05-23 00:00:00","insp_start_time":"1010","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"220TH AND CHASE","county_code_state":"IA","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL","shipping_paper_number":"SEFL","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1361883","transaction_code":"A","transaction_date":"2025-05-27 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:30.000000Z","updated_at":"2025-05-31T10:00:35.000000Z","inspection_violations":[{"id":13954880,"change_date":"2025-05-27 21:39:00","inspection_id":"84786306","insp_violation_id":"266485494","seq_no":"1","part_no":"392","part_no_section":"80A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:46.000000Z","updated_at":"2025-05-31T10:17:26.000000Z","normalized_code":"39280A"}],"inspection_per_units":[{"id":14295796,"change_date":"2025-05-27 21:39:00","inspection_id":"84786306","insp_unit_id":"207076502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YBW7869","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDXE45S35HA74373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:33.000000Z","updated_at":"2025-05-31T09:47:13.000000Z"}]},{"id":7864709,"change_date":"2025-02-13 21:40:00","inspection_id":"83861842","dot_number":"631647","report_state":"IA","report_number":"000P13X5KZ","insp_date":"2025-02-13 00:00:00","insp_start_time":"0720","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 SWEA CITY","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL","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":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1349450","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[{"id":12289653,"change_date":"2025-02-13 21:40:00","inspection_id":"83861842","insp_violation_id":"264505555","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-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12693595,"change_date":"2025-02-13 21:40:00","inspection_id":"83861842","insp_unit_id":"205313665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"GTS169","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA6GUCG6HN011164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"}]},{"id":7870636,"change_date":"2025-02-14 21:40:00","inspection_id":"83868058","dot_number":"631647","report_state":"MN","report_number":"0134000185","insp_date":"2025-02-07 00:00:00","insp_start_time":"1112","insp_end_time":"1140","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1359184","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2025-02-14 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-14 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:34.000000Z","updated_at":"2025-03-17T21:01:34.000000Z","inspection_violations":[{"id":12300519,"change_date":"2025-02-14 21:40:00","inspection_id":"83868058","insp_violation_id":"264520296","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-17T22:06:04.000000Z","updated_at":"2025-03-17T22:06:04.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12703421,"change_date":"2025-02-14 21:40:00","inspection_id":"83868058","insp_unit_id":"205325715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"GSF094","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B2HS807765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:18.000000Z","updated_at":"2025-03-17T23:55:18.000000Z"}]},{"id":7340131,"change_date":"2024-12-04 21:41:00","inspection_id":"83310772","dot_number":"631647","report_state":"IA","report_number":"000P14WDJL","insp_date":"2024-12-03 00:00:00","insp_start_time":"0702","insp_end_time":"0722","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"BALSAM AVE SB\/280TH ST","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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":"2024-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1340494","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11840662,"change_date":"2024-12-04 21:41:00","inspection_id":"83310772","insp_unit_id":"204181811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"YBR9299","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GB6GUCG5H1103401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:45.000000Z","updated_at":"2025-03-17T23:45:45.000000Z"}]},{"id":7185135,"change_date":"2024-11-13 21:40:00","inspection_id":"83147113","dot_number":"631647","report_state":"IA","report_number":"000TT6CH67","insp_date":"2024-11-12 00:00:00","insp_start_time":"0719","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 69 AND 330TH ST","county_code_state":"IA","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AH HERMEL CANDY AND TOBACCO CO","shipping_paper_number":"3630155 RT63","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1337285","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:59.000000Z","updated_at":"2025-03-17T20:45:59.000000Z","inspection_violations":[{"id":11228025,"change_date":"2024-11-13 21:40:00","inspection_id":"83147113","insp_violation_id":"262874626","seq_no":"1","part_no":"392","part_no_section":"2C","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:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3922C"},{"id":11228026,"change_date":"2024-11-13 21:40:00","inspection_id":"83147113","insp_violation_id":"262874627","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203862777","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11589261,"change_date":"2024-11-13 21:40:00","inspection_id":"83147113","insp_unit_id":"203862777","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"18","insp_unit_license":"YBY0188","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1B9JS811348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:04.000000Z","updated_at":"2025-03-17T23:43:04.000000Z"}]},{"id":5867749,"change_date":"2024-05-29 21:41:00","inspection_id":"81738576","dot_number":"631647","report_state":"IA","report_number":"000P123CV6","insp_date":"2024-05-28 00:00:00","insp_start_time":"1217","insp_end_time":"1233","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 9 WB","county_code_state":"IA","county_code":"189","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"A H HERMEL CANDY AND TOBACCO COMPAN","shipping_paper_number":"OWN","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-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1314982","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":"00631647","upload_search_indicator":"M","census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:04.000000Z","updated_at":"2025-03-17T20:19:04.000000Z","inspection_violations":[{"id":9097515,"change_date":"2024-05-29 21:41:00","inspection_id":"81738576","insp_violation_id":"259790937","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201136701","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"39617C"},{"id":9097516,"change_date":"2024-05-29 21:41:00","inspection_id":"81738576","insp_violation_id":"259790938","seq_no":"2","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":"1LOP24052812250","created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9450509,"change_date":"2024-05-29 21:41:00","inspection_id":"81738576","insp_unit_id":"201136701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORESTRIVE","insp_unit_company":"0488","insp_unit_license":"GTS103","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA6GUCG2JN000488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:03.000000Z","updated_at":"2025-03-17T23:21:03.000000Z"}]},{"id":5718909,"change_date":"2024-05-10 21:38:00","inspection_id":"81577331","dot_number":"631647","report_state":"IA","report_number":"000P10ST0T","insp_date":"2024-05-09 00:00:00","insp_start_time":"0940","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 18 @ 189MM","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL","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":"2024-05-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1312227","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2024-05-10 21:38:00","snet_input_date":"2024-05-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-10 21:38:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:56.000000Z","updated_at":"2025-03-17T20:15:56.000000Z","inspection_violations":[{"id":8848638,"change_date":"2024-05-10 21:38:00","inspection_id":"81577331","insp_violation_id":"259431106","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":"7DER24050909532","created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9211132,"change_date":"2024-05-10 21:38:00","inspection_id":"81577331","insp_unit_id":"200830720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"YCC1671","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDXE4FN8NDC32383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"}]},{"id":5736968,"change_date":"2024-05-14 21:41:00","inspection_id":"81596957","dot_number":"631647","report_state":"MN","report_number":"0485000049","insp_date":"2024-05-08 00:00:00","insp_start_time":"0653","insp_end_time":"0715","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ELLENDALE MN","county_code_state":"MN","county_code":"047","insp_level_id":"3","service_center":"MW","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":"2024-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"479128","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2024-05-14 21:41:00","snet_input_date":"2024-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-14 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:20.000000Z","updated_at":"2025-03-17T20:16:20.000000Z","inspection_violations":[{"id":8879858,"change_date":"2024-05-14 21:41:00","inspection_id":"81596957","insp_violation_id":"259479108","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":"WARNING","created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3922"},{"id":8879859,"change_date":"2024-05-14 21:41:00","inspection_id":"81596957","insp_violation_id":"259479109","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39141A"},{"id":8879860,"change_date":"2024-05-14 21:41:00","inspection_id":"81596957","insp_violation_id":"259479110","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9240338,"change_date":"2024-05-14 21:41:00","inspection_id":"81596957","insp_unit_id":"200869269","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"178","insp_unit_license":"YCE7133","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP2HM6XXLM677019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:00.000000Z","updated_at":"2025-03-17T23:19:00.000000Z"}]},{"id":5339304,"change_date":"2024-03-21 21:41:00","inspection_id":"81163618","dot_number":"631647","report_state":"MN","report_number":"00ZE003971","insp_date":"2024-03-21 00:00:00","insp_start_time":"0912","insp_end_time":"0923","registration_date":null,"region":"CT","ci_status_code":"C","location":"SHBRN","location_desc":"SHERBURNE","county_code_state":"MN","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1441646","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-21 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:20.000000Z","updated_at":"2025-03-17T20:08:20.000000Z","inspection_violations":[{"id":8238952,"change_date":"2024-03-21 21:41:00","inspection_id":"81163618","insp_violation_id":"258515232","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:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3922"},{"id":8238953,"change_date":"2024-03-21 21:41:00","inspection_id":"81163618","insp_violation_id":"258515233","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8598759,"change_date":"2024-03-21 21:41:00","inspection_id":"81163618","insp_unit_id":"200026840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3461355","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWFC2RHUN5743","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"}]},{"id":5123793,"change_date":"2024-02-23 21:41:00","inspection_id":"80928569","dot_number":"631647","report_state":"IA","report_number":"000P16D74P","insp_date":"2024-02-22 00:00:00","insp_start_time":"1100","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HERMEL","shipping_paper_number":"SELF","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1303917","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2024-02-23 21:41:00","snet_input_date":"2024-02-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-02-23 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:11.000000Z","updated_at":"2025-03-17T20:04:11.000000Z","inspection_violations":[{"id":7900811,"change_date":"2024-02-23 21:41:00","inspection_id":"80928569","insp_violation_id":"258010412","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199575813","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:12.000000Z","updated_at":"2025-03-17T21:44:12.000000Z","normalized_code":"39021TB"},{"id":7900812,"change_date":"2024-02-23 21:41:00","inspection_id":"80928569","insp_violation_id":"258010413","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199575813","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:12.000000Z","updated_at":"2025-03-17T21:44:12.000000Z","normalized_code":"3922"},{"id":7900813,"change_date":"2024-02-23 21:41:00","inspection_id":"80928569","insp_violation_id":"258010414","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9CUR24022212044","created_at":"2025-03-17T21:44:12.000000Z","updated_at":"2025-03-17T21:44:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8249155,"change_date":"2024-02-23 21:41:00","inspection_id":"80928569","insp_unit_id":"199575813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"GTS103","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA6GUCG2JN000488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:45.000000Z","updated_at":"2025-03-17T23:09:45.000000Z"}]},{"id":5052929,"change_date":"2024-02-14 21:42:00","inspection_id":"80851250","dot_number":"631647","report_state":"MN","report_number":"0ADO003847","insp_date":"2024-02-14 00:00:00","insp_start_time":"0615","insp_end_time":"0705","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"42","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1434868","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7786843,"change_date":"2024-02-14 21:42:00","inspection_id":"80851250","insp_violation_id":"257840575","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199426217","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8133577,"change_date":"2024-02-14 21:42:00","inspection_id":"80851250","insp_unit_id":"199426217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"20","insp_unit_license":"YBK1288","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GB6G5CG4D1174816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:41.000000Z","updated_at":"2025-03-17T23:08:41.000000Z"}]},{"id":4987961,"change_date":"2024-02-06 21:42:00","inspection_id":"80780120","dot_number":"631647","report_state":"MN","report_number":"0AEY000315","insp_date":"2024-02-06 00:00:00","insp_start_time":"1306","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"GYLRD","location_desc":"GAYLORD","county_code_state":"MN","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1008585","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":"I","final_status_date":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1433408","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-02-06 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:37.000000Z","updated_at":"2025-03-17T20:01:37.000000Z","inspection_violations":[{"id":7682103,"change_date":"2024-02-06 21:42:00","inspection_id":"80780120","insp_violation_id":"257687482","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:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8027886,"change_date":"2024-02-06 21:42:00","inspection_id":"80780120","insp_unit_id":"199290445","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"178","insp_unit_license":"YCE7133","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP2HM6XXLM677019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"}]},{"id":4997591,"change_date":"2024-02-07 21:41:00","inspection_id":"80790702","dot_number":"631647","report_state":"IA","report_number":"000P141GNH","insp_date":"2024-02-06 00:00:00","insp_start_time":"0645","insp_end_time":"0705","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB HWY 9 FOREST CITY","county_code_state":"IA","county_code":"189","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL FOOD SERVICE","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-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1301989","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2024-02-07 21:41:00","snet_input_date":"2024-02-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":7697794,"change_date":"2024-02-07 21:41:00","inspection_id":"80790702","insp_violation_id":"257711517","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":"8WAA24020606524","created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8043817,"change_date":"2024-02-07 21:41:00","inspection_id":"80790702","insp_unit_id":"199311662","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"GOX864","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB6GUCGXG1173457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4858880,"change_date":"2024-01-18 21:45:00","inspection_id":"80638854","dot_number":"631647","report_state":"MN","report_number":"0AER001125","insp_date":"2024-01-18 00:00:00","insp_start_time":"1412","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"A H HERMEL CANDDY AND TOBACCO CO","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-18 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1430935","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:53.000000Z","updated_at":"2025-03-17T19:58:53.000000Z","inspection_violations":[{"id":7488984,"change_date":"2024-01-18 21:45:00","inspection_id":"80638854","insp_violation_id":"257397196","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":"882416630002","created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"39282A1"},{"id":7488985,"change_date":"2024-01-18 21:45:00","inspection_id":"80638854","insp_violation_id":"257397197","seq_no":"2","part_no":"391","part_no_section":"11(b)(1)","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:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"39111B1"}],"inspection_per_units":[{"id":7817606,"change_date":"2024-01-18 21:45:00","inspection_id":"80638854","insp_unit_id":"199015697","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"28","insp_unit_license":"JJJ258","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B8HS807785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:52.000000Z","updated_at":"2025-03-17T23:05:52.000000Z"}]},{"id":4373746,"change_date":"2023-11-07 21:40:00","inspection_id":"80106942","dot_number":"631647","report_state":"IA","report_number":"000TT4KD6T","insp_date":"2023-11-06 00:00:00","insp_start_time":"0840","insp_end_time":"0857","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 205 MM EB","county_code_state":"IA","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1293407","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:33.000000Z","updated_at":"2025-03-17T19:49:33.000000Z","inspection_violations":[{"id":6766082,"change_date":"2023-11-07 21:40:00","inspection_id":"80106942","insp_violation_id":"256265846","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":"1SCO23110608515","created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7034080,"change_date":"2023-11-07 21:40:00","inspection_id":"80106942","insp_unit_id":"197947990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"YCC1671","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDXE4FN8NDC32383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:02.000000Z","updated_at":"2025-03-17T22:59:02.000000Z"}]},{"id":4272995,"change_date":"2023-10-24 21:40:00","inspection_id":"79995386","dot_number":"631647","report_state":"MN","report_number":"00ZE003763","insp_date":"2023-10-24 00:00:00","insp_start_time":"0651","insp_end_time":"0701","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTRVL","location_desc":"WATERVILLE","county_code_state":"MN","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1416953","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-24 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[{"id":6608574,"change_date":"2023-10-24 21:40:00","inspection_id":"79995386","insp_violation_id":"256014477","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:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"},{"id":6608575,"change_date":"2023-10-24 21:40:00","inspection_id":"79995386","insp_violation_id":"256014478","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197722128","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6872147,"change_date":"2023-10-24 21:40:00","inspection_id":"79995386","insp_unit_id":"197722128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"178","insp_unit_license":"YBX3144","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP2HM6XXLM677019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:37.000000Z","updated_at":"2025-03-17T22:57:37.000000Z"}]},{"id":3193487,"change_date":"2023-06-01 21:43:00","inspection_id":"78789007","dot_number":"631647","report_state":"MN","report_number":"0AEY000117","insp_date":"2023-06-01 00:00:00","insp_start_time":"0606","insp_end_time":"0627","registration_date":null,"region":"CT","ci_status_code":"C","location":"KLSNR","location_desc":"KLOSSNER","county_code_state":"MN","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","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":"1390646","transaction_code":"A","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2023-06-01 21:43:00","snet_input_date":"2023-06-01 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:07.000000Z","updated_at":"2025-03-17T19:26:07.000000Z","inspection_violations":[{"id":4919210,"change_date":"2023-06-01 21:43:00","inspection_id":"78789007","insp_violation_id":"253215138","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":"882300780199","created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"3922"},{"id":4919211,"change_date":"2023-06-01 21:43:00","inspection_id":"78789007","insp_violation_id":"253215139","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195261327","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5136548,"change_date":"2023-06-01 21:43:00","inspection_id":"78789007","insp_unit_id":"195261327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MAZD","insp_unit_company":"75","insp_unit_license":"YBZ3109","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"JL6CRK1A2FK000284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"}]},{"id":3053722,"change_date":"2023-05-16 21:42:00","inspection_id":"78631407","dot_number":"631647","report_state":"MN","report_number":"0AEY000093","insp_date":"2023-05-16 00:00:00","insp_start_time":"1002","insp_end_time":"1023","registration_date":null,"region":"CT","ci_status_code":"C","location":"MNKTO","location_desc":"MANKATO","county_code_state":"MN","county_code":"013","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1388020","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2023-05-16 21:42:00","snet_input_date":"2023-05-16 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:25.000000Z","updated_at":"2025-03-17T19:23:25.000000Z","inspection_violations":[{"id":4693072,"change_date":"2023-05-16 21:42:00","inspection_id":"78631407","insp_violation_id":"252858300","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:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3922"},{"id":4693073,"change_date":"2023-05-16 21:42:00","inspection_id":"78631407","insp_violation_id":"252858301","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194952840","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4912886,"change_date":"2023-05-16 21:42:00","inspection_id":"78631407","insp_unit_id":"194952840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"5","insp_unit_license":"YCA7845","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HA6GVC73MN009548","insp_unit_decal":"Y","insp_unit_decal_number":"32720976","created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"}]},{"id":2917807,"change_date":"2023-04-28 21:39:00","inspection_id":"78477942","dot_number":"631647","report_state":"IA","report_number":"000TT6NG9Z","insp_date":"2023-04-21 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 17 NB","county_code_state":"IA","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"A H HERMEL","shipping_paper_number":"SELF","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-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"1273052","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2023-04-28 21:39:00","snet_input_date":"2023-04-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:29.000000Z","updated_at":"2025-03-17T19:20:29.000000Z","inspection_violations":[{"id":4477688,"change_date":"2023-04-28 21:39:00","inspection_id":"78477942","insp_violation_id":"252504559","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:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4694438,"change_date":"2023-04-28 21:39:00","inspection_id":"78477942","insp_unit_id":"194644204","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"JJJ258","insp_unit_license":"JJJ258","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B8HS807785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:00.000000Z","updated_at":"2025-03-17T22:40:00.000000Z"}]},{"id":2756685,"change_date":"2023-04-07 21:38:00","inspection_id":"78295305","dot_number":"631647","report_state":"MN","report_number":"0AEP000478","insp_date":"2023-04-05 00:00:00","insp_start_time":"1033","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"NSTPL","location_desc":"NORTH ST PAUL","county_code_state":"MN","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1380570","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2023-04-07 21:38:00","snet_input_date":"2023-04-07 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:23.000000Z","updated_at":"2025-03-17T19:17:23.000000Z","inspection_violations":[{"id":4230969,"change_date":"2023-04-07 21:38:00","inspection_id":"78295305","insp_violation_id":"252102460","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:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4230970,"change_date":"2023-04-07 21:38:00","inspection_id":"78295305","insp_violation_id":"252102461","seq_no":"2","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:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4436859,"change_date":"2023-04-07 21:38:00","inspection_id":"78295305","insp_unit_id":"194278554","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"NONE","insp_unit_license":"YBV3463","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1CXHS803276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"}]},{"id":2644889,"change_date":"2023-03-23 21:43:00","inspection_id":"78167420","dot_number":"631647","report_state":"IA","report_number":"000TT6CX82","insp_date":"2023-03-22 00:00:00","insp_start_time":"0605","insp_end_time":"0631","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/160TH SST","county_code_state":"IA","county_code":"187","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","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-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1267715","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2023-03-23 21:43:00","snet_input_date":"2023-03-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-23 21:43:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:30.000000Z","updated_at":"2025-03-17T19:15:30.000000Z","inspection_violations":[{"id":4065633,"change_date":"2023-03-23 21:43:00","inspection_id":"78167420","insp_violation_id":"251829252","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194026749","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4257718,"change_date":"2023-03-23 21:43:00","inspection_id":"78167420","insp_unit_id":"194026749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"258","insp_unit_license":"JJJ258","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B8HS807785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:32.000000Z","updated_at":"2025-03-17T22:36:32.000000Z"}]},{"id":2357691,"change_date":"2023-02-13 21:42:00","inspection_id":"77840586","dot_number":"631647","report_state":"IA","report_number":"000TT6CX4Q","insp_date":"2023-02-09 00:00:00","insp_start_time":"1243","insp_end_time":"1318","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 NB\/270TH ST","county_code_state":"IA","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1262377","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2023-02-13 21:42:00","snet_input_date":"2023-02-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-13 21:42:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:01.000000Z","updated_at":"2025-03-17T19:10:01.000000Z","inspection_violations":[{"id":3630890,"change_date":"2023-02-13 21:42:00","inspection_id":"77840586","insp_violation_id":"251100334","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193367938","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3794258,"change_date":"2023-02-13 21:42:00","inspection_id":"77840586","insp_unit_id":"193367938","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"258","insp_unit_license":"JJJ258","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B8HS807785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"}]},{"id":1676153,"change_date":"2022-11-04 21:38:00","inspection_id":"77061138","dot_number":"631647","report_state":"IA","report_number":"000P14KG7Q","insp_date":"2022-11-03 00:00:00","insp_start_time":"0653","insp_end_time":"0723","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 182MM SB","county_code_state":"IA","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"2022-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249872","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-11-04 21:38:00","snet_input_date":"2022-11-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:27.000000Z","updated_at":"2025-03-17T18:57:27.000000Z","inspection_violations":[{"id":2628361,"change_date":"2022-11-04 21:38:00","inspection_id":"77061138","insp_violation_id":"249441685","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191813354","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3939A"},{"id":2628362,"change_date":"2022-11-04 21:38:00","inspection_id":"77061138","insp_violation_id":"249441686","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191813354","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3939A"},{"id":2628363,"change_date":"2022-11-04 21:38:00","inspection_id":"77061138","insp_violation_id":"249441687","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191813354","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3939A"},{"id":2628364,"change_date":"2022-11-04 21:38:00","inspection_id":"77061138","insp_violation_id":"249441688","seq_no":"4","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"191813354","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":2696373,"change_date":"2022-11-04 21:38:00","inspection_id":"77061138","insp_unit_id":"191813354","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"12","insp_unit_license":"GOX859","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB6G5CG6B1168450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"}]},{"id":1658149,"change_date":"2022-11-02 21:40:00","inspection_id":"77040421","dot_number":"631647","report_state":"IA","report_number":"000TT823RS","insp_date":"2022-11-01 00:00:00","insp_start_time":"0951","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9","county_code_state":"IA","county_code":"059","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL CANDY","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-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249404","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-11-02 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-02 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:06.000000Z","updated_at":"2025-03-17T18:57:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2667734,"change_date":"2022-11-02 21:40:00","inspection_id":"77040421","insp_unit_id":"191772779","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"YBZ7479","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1BXLS805027","insp_unit_decal":"Y","insp_unit_decal_number":"32041345","created_at":"2025-03-17T22:25:17.000000Z","updated_at":"2025-03-17T22:25:17.000000Z"}]},{"id":1901855,"change_date":"2022-12-08 21:40:00","inspection_id":"77319496","dot_number":"631647","report_state":"IA","report_number":"000P14KG6S","insp_date":"2022-10-24 00:00:00","insp_start_time":"0541","insp_end_time":"0555","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 194MM SB","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"2022-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"1253976","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-12-08 21:40:00","snet_input_date":"2022-10-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:49.000000Z","updated_at":"2025-03-17T19:01:49.000000Z","inspection_violations":[{"id":2958526,"change_date":"2022-12-08 21:40:00","inspection_id":"77319496","insp_violation_id":"249993455","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:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3060507,"change_date":"2022-12-08 21:40:00","inspection_id":"77319496","insp_unit_id":"192327580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"GOX864","insp_unit_license":"GOX864","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB6GUCGXG1173457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"}]},{"id":1458442,"change_date":"2022-10-06 21:40:00","inspection_id":"76810527","dot_number":"631647","report_state":"IA","report_number":"000TT82GCF","insp_date":"2022-10-05 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 EB & 170TH AVE","county_code_state":"IA","county_code":"059","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL","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":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14050","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":"1245519","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:28.000000Z","updated_at":"2025-03-17T18:53:28.000000Z","inspection_violations":[{"id":2295974,"change_date":"2022-10-06 21:40:00","inspection_id":"76810527","insp_violation_id":"248877145","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:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2347808,"change_date":"2022-10-06 21:40:00","inspection_id":"76810527","insp_unit_id":"191309998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"151","insp_unit_license":"YBW7869","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDXE45S35HA74373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":1344130,"change_date":"2022-09-22 21:40:00","inspection_id":"76678059","dot_number":"631647","report_state":"IA","report_number":"000TT83KW9","insp_date":"2022-09-21 00:00:00","insp_start_time":"1509","insp_end_time":"1535","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB WEST OF OAK AVE","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"A H HERMEL CANDY AND TOBACCO COMPAN","shipping_paper_number":"24","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-09-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1243292","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-09-22 21:40:00","snet_input_date":"2022-09-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2128893,"change_date":"2022-09-22 21:40:00","inspection_id":"76678059","insp_violation_id":"248584879","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:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3922"},{"id":2128894,"change_date":"2022-09-22 21:40:00","inspection_id":"76678059","insp_violation_id":"248584880","seq_no":"2","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":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"39216A"},{"id":2128895,"change_date":"2022-09-22 21:40:00","inspection_id":"76678059","insp_violation_id":"248584881","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191042872","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2164190,"change_date":"2022-09-22 21:40:00","inspection_id":"76678059","insp_unit_id":"191042872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"28","insp_unit_license":"JJJ258","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"54DC4W1B8HS807785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"}]},{"id":1295186,"change_date":"2022-09-15 21:40:00","inspection_id":"76620715","dot_number":"631647","report_state":"MN","report_number":"00ZE003164","insp_date":"2022-09-15 00:00:00","insp_start_time":"1155","insp_end_time":"1203","registration_date":null,"region":"CT","ci_status_code":"C","location":"STJMS","location_desc":"ST. JAMES","county_code_state":"MN","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-09-15 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":"1350696","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2022-09-15 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[{"id":2048863,"change_date":"2022-09-15 21:40:00","inspection_id":"76620715","insp_violation_id":"248440164","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:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2084726,"change_date":"2022-09-15 21:40:00","inspection_id":"76620715","insp_unit_id":"190922498","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"177","insp_unit_license":"YBV3672","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP2HM6X0KM616681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"}]},{"id":973670,"change_date":"2022-08-05 21:40:00","inspection_id":"76247027","dot_number":"631647","report_state":"MN","report_number":"0ADH001398","insp_date":"2022-08-03 00:00:00","insp_start_time":"1111","insp_end_time":"1124","registration_date":null,"region":"CT","ci_status_code":"C","location":"MPLWD","location_desc":"MAPLEWOOD","county_code_state":"MN","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-08-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1343240","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":null,"census_search_date":"2022-08-05 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-08-05 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"P O BOX 447","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:47.000000Z","updated_at":"2025-03-17T18:44:47.000000Z","inspection_violations":[{"id":1535490,"change_date":"2022-08-05 21:40:00","inspection_id":"76247027","insp_violation_id":"247544578","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:14:14.000000Z","updated_at":"2025-03-17T21:14:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1566797,"change_date":"2022-08-05 21:40:00","inspection_id":"76247027","insp_unit_id":"190159084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"YBV3463","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"54DC4W1CXHS803276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:52.000000Z","updated_at":"2025-03-17T22:17:52.000000Z"}]},{"id":817564,"change_date":"2022-07-14 21:41:00","inspection_id":"76064109","dot_number":"631647","report_state":"IA","report_number":"000TT6LPJC","insp_date":"2022-07-13 00:00:00","insp_start_time":"1830","insp_end_time":"1845","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"WB HWY 9 FERTILE","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HERMEL","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":"2022-07-14 21:41: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":"1233319","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-07-14 21:41:00","snet_input_date":"2022-07-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-14 21:41:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:00.000000Z","updated_at":"2025-03-17T18:42:00.000000Z","inspection_violations":[{"id":1288002,"change_date":"2022-07-14 21:41:00","inspection_id":"76064109","insp_violation_id":"247090509","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:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1315171,"change_date":"2022-07-14 21:41:00","inspection_id":"76064109","insp_unit_id":"189776075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PN816419","insp_unit_license":"PAV2852","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3HSDZAPR3PN816419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"},{"id":1315172,"change_date":"2022-07-14 21:41:00","inspection_id":"76064109","insp_unit_id":"189776076","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"100491","insp_unit_license":"8264STZ","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1UYVS2364FU101301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"}]},{"id":669903,"change_date":"2022-06-22 21:40:00","inspection_id":"75891039","dot_number":"631647","report_state":"IA","report_number":"000TT6ZTTC","insp_date":"2022-06-20 00:00:00","insp_start_time":"1005","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 NB FROM OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230036","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00631647","upload_search_indicator":"M","census_search_date":"2022-06-22 21:40:00","snet_input_date":"2022-06-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-22 21:40:00","insp_carrier_name":"A H HERMEL CANDY AND TOBACCO COMPANY","insp_carrier_street":"23099 RIVERFRONT DRIVE NORTH","insp_carrier_city":"MANKATO","insp_carrier_state":"MN","insp_carrier_zip_code":"56001-9300","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:31.000000Z","updated_at":"2025-03-17T18:39:31.000000Z","inspection_violations":[{"id":1054292,"change_date":"2022-06-22 21:40:00","inspection_id":"75891039","insp_violation_id":"246647145","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":"T41922062010144","created_at":"2025-03-17T21:11:56.000000Z","updated_at":"2025-03-17T21:11:56.000000Z","normalized_code":"3922"},{"id":1054293,"change_date":"2022-06-22 21:40:00","inspection_id":"75891039","insp_violation_id":"246647146","seq_no":"2","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:56.000000Z","updated_at":"2025-03-17T21:11:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1076535,"change_date":"2022-06-22 21:40:00","inspection_id":"75891039","insp_unit_id":"189402248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"00064L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FN8NDC32383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:49.000000Z","updated_at":"2025-03-17T22:14:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/631647\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/631647\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/631647\/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\/631647\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}