{"current_page":1,"data":[{"id":10258271,"change_date":"2025-11-21 21:38:00","inspection_id":"86381859","dot_number":"1542507","report_state":"NY","report_number":"D507101961","insp_date":"2025-11-20 00:00:00","insp_start_time":"1337","insp_end_time":"1403","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-21 21:38: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":"2569941","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:40.000000Z","updated_at":"2025-11-25T10:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17101698,"change_date":"2025-11-21 21:38:00","inspection_id":"86381859","insp_unit_id":"210167308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"91626000","insp_unit_license":"490A413","insp_unit_license_state":"VT","insp_unit_vehicle_id_number":"7GZ37TC74NN006626","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-11-24T10:01:54.000000Z","updated_at":"2025-11-25T10:00:31.000000Z"}]},{"id":10143003,"change_date":"2025-12-11 21:43:00","inspection_id":"86260781","dot_number":"1542507","report_state":"NY","report_number":"SPA3090341","insp_date":"2025-11-01 00:00:00","insp_start_time":"0834","insp_end_time":"0843","registration_date":"2025-12-05 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SILVER CREEK NY","county_code_state":"NY","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MIDSTATE BAKERY DIST","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":"2025-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2513880","transaction_code":"C","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:33.000000Z","updated_at":"2025-12-15T10:30:11.000000Z","inspection_violations":[{"id":17433119,"change_date":"2025-12-11 21:43:00","inspection_id":"86260781","insp_violation_id":"270605939","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:10.000000Z","updated_at":"2025-12-15T10:30:45.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17395756,"change_date":"2025-12-11 21:43:00","inspection_id":"86260781","insp_unit_id":"210539124","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"39791NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBYK113LGLS9593","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:48.000000Z","updated_at":"2025-12-15T10:00:17.000000Z"}]},{"id":9640122,"change_date":"2025-10-23 21:39:00","inspection_id":"85731626","dot_number":"1542507","report_state":"NY","report_number":"D507501236","insp_date":"2025-09-08 00:00:00","insp_start_time":"1002","insp_end_time":"1023","registration_date":"2025-10-21 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"ROCHESTER NY","county_code_state":"NY","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2244880","transaction_code":"C","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:32.000000Z","updated_at":"2025-10-27T10:00:10.000000Z","inspection_violations":[{"id":16556936,"change_date":"2025-10-23 21:39:00","inspection_id":"85731626","insp_violation_id":"269464971","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-26T10:17:36.000000Z","updated_at":"2025-10-27T10:15:21.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":16632306,"change_date":"2025-10-23 21:39:00","inspection_id":"85731626","insp_unit_id":"209610283","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"15511ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FL2GDC45489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:00.000000Z","updated_at":"2025-10-27T09:45:10.000000Z"}]},{"id":9351341,"change_date":"2025-08-07 21:39:00","inspection_id":"85428413","dot_number":"1542507","report_state":"NY","report_number":"D507801717","insp_date":"2025-08-07 00:00:00","insp_start_time":"1013","insp_end_time":"1043","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-07 21:39: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":"2098244","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:39.000000Z","updated_at":"2025-08-12T10:42:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15404783,"change_date":"2025-08-07 21:39:00","inspection_id":"85428413","insp_unit_id":"208280133","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"WHITE","insp_unit_license":"92925NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GTCG2HN008436","insp_unit_decal":"Y","insp_unit_decal_number":"35491804","created_at":"2025-08-10T09:46:18.000000Z","updated_at":"2025-08-11T09:45:38.000000Z"}]},{"id":9108431,"change_date":"2025-07-10 21:38:00","inspection_id":"85172837","dot_number":"1542507","report_state":"NY","report_number":"SPA3060639","insp_date":"2025-07-03 00:00:00","insp_start_time":"1424","insp_end_time":"1448","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"AMHERST NY","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MIDSTATE BAKERY DISTRIBUTORS INC","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-07-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1971227","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2025-07-10 21:38:00","snet_input_date":"2025-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-10 21:38:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:40.000000Z","updated_at":"2025-07-14T10:46:40.000000Z","inspection_violations":[{"id":14678392,"change_date":"2025-07-10 21:38:00","inspection_id":"85172837","insp_violation_id":"267314113","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"207792244","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-13T10:49:26.000000Z","updated_at":"2025-07-14T10:47:18.000000Z","normalized_code":"39341BNPB"},{"id":14678393,"change_date":"2025-07-10 21:38:00","inspection_id":"85172837","insp_violation_id":"267314114","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207792244","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:26.000000Z","updated_at":"2025-07-14T10:47:18.000000Z","normalized_code":"39378AWS"},{"id":14678394,"change_date":"2025-07-10 21:38:00","inspection_id":"85172837","insp_violation_id":"267314115","seq_no":"3","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:26.000000Z","updated_at":"2025-07-14T10:47:18.000000Z","normalized_code":"39141APC"},{"id":14678395,"change_date":"2025-07-10 21:38:00","inspection_id":"85172837","insp_violation_id":"267314116","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","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-07-13T10:49:26.000000Z","updated_at":"2025-07-14T10:47:18.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":14951875,"change_date":"2025-07-10 21:38:00","inspection_id":"85172837","insp_unit_id":"207792244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"92925NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GTCG2HN008436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:50.000000Z","updated_at":"2025-07-14T09:45:06.000000Z"}]},{"id":9025621,"change_date":"2025-06-30 21:38:00","inspection_id":"85085637","dot_number":"1542507","report_state":"NY","report_number":"5L40002057","insp_date":"2025-06-28 00:00:00","insp_start_time":"0928","insp_end_time":"0955","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BLASDELL NY","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"1932158","transaction_code":"A","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2025-06-30 21:38:00","snet_input_date":"2025-06-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-30 21:38:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-03T10:01:33.000000Z","updated_at":"2025-07-04T10:00:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14803025,"change_date":"2025-06-30 21:38:00","inspection_id":"85085637","insp_unit_id":"207629484","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"52729ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALB4W171G7F00893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:31.000000Z","updated_at":"2025-07-04T09:45:12.000000Z"}]},{"id":6437604,"change_date":"2024-08-12 21:42:00","inspection_id":"82352042","dot_number":"1542507","report_state":"NY","report_number":"5L47000039","insp_date":"2024-08-08 00:00:00","insp_start_time":"0934","insp_end_time":"1003","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER NY","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"735038","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2024-08-12 21:42:00","snet_input_date":"2024-08-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-12 21:42:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:20.000000Z","updated_at":"2025-03-17T20:30:20.000000Z","inspection_violations":[{"id":9997280,"change_date":"2024-08-12 21:42:00","inspection_id":"82352042","insp_violation_id":"261124433","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":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39141A"},{"id":9997281,"change_date":"2024-08-12 21:42:00","inspection_id":"82352042","insp_violation_id":"261124434","seq_no":"1","part_no":"390","part_no_section":"21T(e)","insp_viol_unit":"1","insp_unit_id":"202330952","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39021TE"}],"inspection_per_units":[{"id":10375542,"change_date":"2024-08-12 21:42:00","inspection_id":"82352042","insp_unit_id":"202330952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"497493","insp_unit_license":"3402124","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FDWE3FN7PDD35383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:33.000000Z","updated_at":"2025-03-17T23:30:33.000000Z"}]},{"id":5882233,"change_date":"2024-05-31 21:38:00","inspection_id":"81754185","dot_number":"1542507","report_state":"NY","report_number":"5L39000589","insp_date":"2024-05-29 00:00:00","insp_start_time":"0948","insp_end_time":"1005","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"VICTOR NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-31 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":"528719","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2024-05-31 21:38:00","snet_input_date":"2024-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-31 21:38:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:25.000000Z","updated_at":"2025-03-17T20:19:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9473948,"change_date":"2024-05-31 21:38:00","inspection_id":"81754185","insp_unit_id":"201167136","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"WHITE TRUCK","insp_unit_license":"23984ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3PS201908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":4650218,"change_date":"2023-12-18 21:41:00","inspection_id":"80410905","dot_number":"1542507","report_state":"NY","report_number":"SPT0441924","insp_date":"2023-12-15 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"40388A","location_desc":"HENRIETTA (EXIT 46)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2894412","transaction_code":"A","transaction_date":"2023-12-15 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:58.000000Z","updated_at":"2025-03-17T19:54:58.000000Z","inspection_violations":[{"id":7189740,"change_date":"2023-12-18 21:41:00","inspection_id":"80410905","insp_violation_id":"256931862","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198546950","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7478836,"change_date":"2023-12-18 21:41:00","inspection_id":"80410905","insp_unit_id":"198546949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4619","insp_unit_license":"16605PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AN4GY8LM019305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"},{"id":7478837,"change_date":"2023-12-18 21:41:00","inspection_id":"80410905","insp_unit_id":"198546950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"CB69268","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1JJV532D4DL747170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"}]},{"id":4403240,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","dot_number":"1542507","report_state":"NY","report_number":"SPA0350441","insp_date":"2023-11-06 00:00:00","insp_start_time":"0935","insp_end_time":"1021","registration_date":null,"region":"ET","ci_status_code":"C","location":"50481","location_desc":"TOPS SR 31","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RAZ DIST.","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2886478","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2023-11-13 21:41:00","snet_input_date":"2023-11-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-13 21:41:00","insp_carrier_name":"MIDSTATE BAKERIES","insp_carrier_street":"402 BABCOCK ST","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:16.000000Z","updated_at":"2025-03-17T19:50:16.000000Z","inspection_violations":[{"id":6815340,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340810","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39021B"},{"id":6815341,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340811","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39021B"},{"id":6815342,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340812","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3922"},{"id":6815343,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340813","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39395A"},{"id":6815344,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340814","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3939A"},{"id":6815345,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340815","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3939A"},{"id":6815346,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340816","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3939A"},{"id":6815347,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340817","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"39311"},{"id":6815348,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_violation_id":"256340818","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198010948","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7081301,"change_date":"2023-11-13 21:41:00","inspection_id":"80139424","insp_unit_id":"198010948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"632","insp_unit_license":"72441NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE4B142X7900762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:27.000000Z","updated_at":"2025-03-17T22:59:27.000000Z"}]},{"id":4110555,"change_date":"2023-10-03 21:40:00","inspection_id":"79815755","dot_number":"1542507","report_state":"NY","report_number":"0509016123","insp_date":"2023-09-28 00:00:00","insp_start_time":"1014","insp_end_time":"1036","registration_date":null,"region":"ET","ci_status_code":"C","location":"50191","location_desc":"SPRINGVILLE NYSDOT RES","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"2874404","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"PO BOX 23374","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6609097,"change_date":"2023-10-03 21:40:00","inspection_id":"79815755","insp_unit_id":"197362428","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"52729ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALB4W171G7F00893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3752711,"change_date":"2023-08-16 21:38:00","inspection_id":"79416936","dot_number":"1542507","report_state":"NY","report_number":"SP1A150031","insp_date":"2023-08-15 00:00:00","insp_start_time":"0852","insp_end_time":"0944","registration_date":null,"region":"ET","ci_status_code":"C","location":"A111","location_desc":"S TRANSIT RD","county_code_state":"NY","county_code":"063","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RAZDISTRIBUTION OF ERIE COUNTY","shipping_paper_number":"2737780","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2858871","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2023-08-16 21:38:00","snet_input_date":"2023-08-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-16 21:38:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:55.000000Z","updated_at":"2025-03-17T19:36:55.000000Z","inspection_violations":[{"id":5788009,"change_date":"2023-08-16 21:38:00","inspection_id":"79416936","insp_violation_id":"254679614","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5H2Q247","created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39216A"},{"id":5788010,"change_date":"2023-08-16 21:38:00","inspection_id":"79416936","insp_violation_id":"254679615","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196553300","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5H2PZV4","created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3922"},{"id":5788011,"change_date":"2023-08-16 21:38:00","inspection_id":"79416936","insp_violation_id":"254679616","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"196553300","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":6034021,"change_date":"2023-08-16 21:38:00","inspection_id":"79416936","insp_unit_id":"196553300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"632","insp_unit_license":"88895MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE4B142X7900762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":3394180,"change_date":"2023-06-29 21:41:00","inspection_id":"79015121","dot_number":"1542507","report_state":"NY","report_number":"SPT0384977","insp_date":"2023-06-27 00:00:00","insp_start_time":"0758","insp_end_time":"0818","registration_date":null,"region":"ET","ci_status_code":"C","location":"50361","location_desc":"HAMBURG (EXIT 57)","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MIDSTATE BAKERY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2842709","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":"M","census_search_date":"2023-06-29 21:41:00","snet_input_date":"2023-06-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-29 21:41:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:12.000000Z","updated_at":"2025-03-17T19:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5456680,"change_date":"2023-06-29 21:41:00","inspection_id":"79015121","insp_unit_id":"195739019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"66991MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JV2G4S54506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:03.000000Z","updated_at":"2025-03-17T22:46:03.000000Z"}]},{"id":3128943,"change_date":"2023-05-24 21:40:00","inspection_id":"78715861","dot_number":"1542507","report_state":"NY","report_number":"SPA0333859","insp_date":"2023-05-20 00:00:00","insp_start_time":"0851","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"50243A","location_desc":"DUNKIRK (EXIT 59)","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2828628","transaction_code":"A","transaction_date":"2023-05-20 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":null,"census_search_date":"2023-05-24 21:40:00","snet_input_date":"2023-05-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-24 21:40:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:57.000000Z","updated_at":"2025-03-17T19:24:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5032487,"change_date":"2023-05-24 21:40:00","inspection_id":"78715861","insp_unit_id":"195114243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"66991MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNE8JV2G4S54506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:41.000000Z","updated_at":"2025-03-17T22:42:41.000000Z"}]},{"id":2443491,"change_date":"2023-02-24 21:40:00","inspection_id":"77938409","dot_number":"1542507","report_state":"NY","report_number":"SPE0301701","insp_date":"2023-02-17 00:00:00","insp_start_time":"0939","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"40388","location_desc":"HENRIETTA","county_code_state":"NY","county_code":"055","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2801883","transaction_code":"A","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":"M","census_search_date":"2023-02-24 21:40:00","snet_input_date":"2023-02-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-24 21:40:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:45.000000Z","updated_at":"2025-03-17T19:11:45.000000Z","inspection_violations":[{"id":3761499,"change_date":"2023-02-24 21:40:00","inspection_id":"77938409","insp_violation_id":"251318272","seq_no":"1","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":null,"created_at":"2025-03-17T21:24:44.000000Z","updated_at":"2025-03-17T21:24:44.000000Z","normalized_code":"39141A"},{"id":3761500,"change_date":"2023-02-24 21:40:00","inspection_id":"77938409","insp_violation_id":"251318273","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"193563749","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:44.000000Z","updated_at":"2025-03-17T21:24:44.000000Z","normalized_code":"39341"},{"id":3761501,"change_date":"2023-02-24 21:40:00","inspection_id":"77938409","insp_violation_id":"251318274","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193563749","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0GFMB18","created_at":"2025-03-17T21:24:44.000000Z","updated_at":"2025-03-17T21:24:44.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3931955,"change_date":"2023-02-24 21:40:00","inspection_id":"77938409","insp_unit_id":"193563749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"15511ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FL2GDC45489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:10.000000Z","updated_at":"2025-03-17T22:34:10.000000Z"}]},{"id":2189088,"change_date":"2023-01-20 21:40:00","inspection_id":"77648364","dot_number":"1542507","report_state":"NY","report_number":"SPT0365482","insp_date":"2023-01-19 00:00:00","insp_start_time":"1420","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"50361","location_desc":"HAMBURG (EXIT 57)","county_code_state":"NY","county_code":"029","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MIDSTATE","shipping_paper_number":"ROUTE 213","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"2790907","transaction_code":"A","transaction_date":"2023-01-20 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":"M","census_search_date":"2023-01-20 21:40:00","snet_input_date":"2023-01-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-20 21:40:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:57.000000Z","updated_at":"2025-03-17T19:06:57.000000Z","inspection_violations":[{"id":3381926,"change_date":"2023-01-20 21:40:00","inspection_id":"77648364","insp_violation_id":"250680278","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192974519","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3523404,"change_date":"2023-01-20 21:40:00","inspection_id":"77648364","insp_unit_id":"192974519","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"42352MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALB4W171G7F00893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"}]},{"id":1505279,"change_date":"2022-10-13 21:39:00","inspection_id":"76864571","dot_number":"1542507","report_state":"NY","report_number":"SPE0215587","insp_date":"2022-10-12 00:00:00","insp_start_time":"1410","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714A","location_desc":"RIGA (EB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"2758138","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":"M","census_search_date":"2022-10-13 21:39:00","snet_input_date":"2022-10-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-13 21:39:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:28.000000Z","updated_at":"2025-03-17T18:54:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2422614,"change_date":"2022-10-13 21:39:00","inspection_id":"76864571","insp_unit_id":"191418714","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5359","insp_unit_license":"31817TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AN2AY1LM001807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:36.000000Z","updated_at":"2025-03-17T22:23:36.000000Z"},{"id":2422615,"change_date":"2022-10-13 21:39:00","inspection_id":"76864571","insp_unit_id":"191418715","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"CB69268","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1JJV532D4DL747170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:36.000000Z","updated_at":"2025-03-17T22:23:36.000000Z"}]},{"id":1431772,"change_date":"2022-10-04 21:40:00","inspection_id":"76779432","dot_number":"1542507","report_state":"NY","report_number":"SPA0257461","insp_date":"2022-10-03 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"50186A","location_desc":"COLLINS","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MIDSTATE BAKERY DISTRIBUTORS INC","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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"2755730","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01542507","upload_search_indicator":"M","census_search_date":"2022-10-04 21:40:00","snet_input_date":"2022-10-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-04 21:40:00","insp_carrier_name":"MIDSTATE BAKERY DISTRIBUTORS INC","insp_carrier_street":"402 BABCOCK STREET","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14206","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:04.000000Z","updated_at":"2025-03-17T18:53:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2304562,"change_date":"2022-10-04 21:40:00","inspection_id":"76779432","insp_unit_id":"191247159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"42352MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALB4W171G7F00893","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1542507\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1542507\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1542507\/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\/1542507\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}