{"current_page":1,"data":[{"id":12095223,"change_date":"2026-06-04 21:45:00","inspection_id":"88039356","dot_number":"1168816","report_state":"NY","report_number":"SPL4060118","insp_date":"2026-05-28 00:00:00","insp_start_time":"1132","insp_end_time":"1159","registration_date":"2026-06-03 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"DEER PARK NY","county_code_state":"NY","county_code":"103","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3463459","transaction_code":"A","transaction_date":"2026-06-03 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:49.000000Z","updated_at":"2026-06-16T09:31:14.000000Z","inspection_violations":[{"id":21049279,"change_date":"2026-06-04 21:45:00","inspection_id":"88039356","insp_violation_id":"274690070","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"213909219","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:47.000000Z","updated_at":"2026-06-16T09:45:35.000000Z","normalized_code":"39395A4EENA"},{"id":21049280,"change_date":"2026-06-04 21:45:00","inspection_id":"88039356","insp_violation_id":"274690071","seq_no":"2","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"213909219","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:47.000000Z","updated_at":"2026-06-16T09:45:35.000000Z","normalized_code":"39021TELCMVINFO"},{"id":21049281,"change_date":"2026-06-04 21:45:00","inspection_id":"88039356","insp_violation_id":"274690072","seq_no":"3","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:47.000000Z","updated_at":"2026-06-16T09:45:35.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":21016755,"change_date":"2026-06-04 21:45:00","inspection_id":"88039356","insp_unit_id":"213909219","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"786908","insp_unit_license":"3856703","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML9SL164127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:54.000000Z","updated_at":"2026-06-16T09:02:55.000000Z"}]},{"id":10502919,"change_date":"2025-12-23 21:38:00","inspection_id":"86637786","dot_number":"1168816","report_state":"NY","report_number":"SPL3060872","insp_date":"2025-12-16 00:00:00","insp_start_time":"1039","insp_end_time":"1054","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2025-12-23 21:38: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":"2690632","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:32.000000Z","updated_at":"2026-01-03T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17588379,"change_date":"2025-12-23 21:38:00","inspection_id":"86637786","insp_unit_id":"210766155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"3","insp_unit_license":"23772AL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ7H1C7XJ500518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:27.000000Z","updated_at":"2026-01-03T10:00:21.000000Z"}]},{"id":10159470,"change_date":"2025-11-10 21:38:00","inspection_id":"86278116","dot_number":"1168816","report_state":"NY","report_number":"SPL3040976","insp_date":"2025-11-03 00:00:00","insp_start_time":"0915","insp_end_time":"0936","registration_date":"2025-11-05 00:00:00","region":"ES","ci_status_code":"C","location":"00096E","location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2522725","transaction_code":"A","transaction_date":"2025-11-09 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2025-11-10 21:38:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-10 21:38:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:28.000000Z","updated_at":"2025-11-14T10:30:10.000000Z","inspection_violations":[{"id":16863456,"change_date":"2025-11-10 21:38:00","inspection_id":"86278116","insp_violation_id":"269837616","seq_no":"1","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209930713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:30:44.000000Z","updated_at":"2025-11-14T10:30:21.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":16914610,"change_date":"2025-11-10 21:38:00","inspection_id":"86278116","insp_unit_id":"209930713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"38844GL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ6C1CX4F514885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:31.000000Z","updated_at":"2025-11-14T10:00:13.000000Z"}]},{"id":9713634,"change_date":"2025-11-03 21:38:00","inspection_id":"85809046","dot_number":"1168816","report_state":"NY","report_number":"SPE3080898","insp_date":"2025-09-11 00:00:00","insp_start_time":"0958","insp_end_time":"1021","registration_date":"2025-11-01 00:00:00","region":"ED","ci_status_code":"C","location":"00096E","location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2292215","transaction_code":"C","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2025-09-18 21:42:00","snet_input_date":"2025-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-18 21:42:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:16.000000Z","updated_at":"2025-11-07T10:30:04.000000Z","inspection_violations":[{"id":16735186,"change_date":"2025-11-03 21:38:00","inspection_id":"85809046","insp_violation_id":"269681551","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209796497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:30:34.000000Z","updated_at":"2025-11-07T10:30:34.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":16795456,"change_date":"2025-11-03 21:38:00","inspection_id":"85809046","insp_unit_id":"209796497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"836708","insp_unit_license":"3964366","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMMLXTL701010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:27.000000Z","updated_at":"2025-11-07T10:00:07.000000Z"}]},{"id":8934689,"change_date":"2025-06-19 21:37:00","inspection_id":"84989653","dot_number":"1168816","report_state":"NY","report_number":"SPL4010149","insp_date":"2025-06-12 00:00:00","insp_start_time":"0851","insp_end_time":"0909","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1883162","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2025-06-19 21:37:00","snet_input_date":"2025-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-19 21:37:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:01:10.000000Z","updated_at":"2025-06-23T10:00:08.000000Z","inspection_violations":[{"id":14340263,"change_date":"2025-06-19 21:37:00","inspection_id":"84989653","insp_violation_id":"266925502","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-06-22T10:16:37.000000Z","updated_at":"2025-06-23T10:15:11.000000Z","normalized_code":"39216D"},{"id":14340264,"change_date":"2025-06-19 21:37:00","inspection_id":"84989653","insp_violation_id":"266925503","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207455854","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:37.000000Z","updated_at":"2025-06-23T10:15:11.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14643538,"change_date":"2025-06-19 21:37:00","inspection_id":"84989653","insp_unit_id":"207455854","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"38844ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ6C1CX4F514885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:25.000000Z","updated_at":"2025-06-23T09:45:09.000000Z"}]},{"id":8628012,"change_date":"2025-05-14 21:41:00","inspection_id":"84665131","dot_number":"1168816","report_state":"NY","report_number":"D012102156","insp_date":"2025-05-13 00:00:00","insp_start_time":"0927","insp_end_time":"0942","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","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-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1727376","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:57.000000Z","updated_at":"2025-05-18T10:04:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14088596,"change_date":"2025-05-14 21:41:00","inspection_id":"84665131","insp_unit_id":"206850092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"489152","insp_unit_license":"3195162","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC3NDNR5848","insp_unit_decal":"Y","insp_unit_decal_number":"35219285","created_at":"2025-05-17T09:49:03.000000Z","updated_at":"2025-05-18T09:50:28.000000Z"}]},{"id":7492213,"change_date":"2024-12-24 21:34:00","inspection_id":"83470641","dot_number":"1168816","report_state":"NY","report_number":"SPL3040294","insp_date":"2024-12-17 00:00:00","insp_start_time":"1020","insp_end_time":"1044","registration_date":null,"region":"ES","ci_status_code":"C","location":"00096E","location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-24 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1190048","transaction_code":"A","transaction_date":"2024-12-24 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2024-12-24 21:34:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-24 21:34:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:20.000000Z","updated_at":"2025-03-17T20:52:20.000000Z","inspection_violations":[{"id":11711081,"change_date":"2024-12-24 21:34:00","inspection_id":"83470641","insp_violation_id":"263641777","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204540864","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8L69JT06M1","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12086929,"change_date":"2024-12-24 21:34:00","inspection_id":"83470641","insp_unit_id":"204540864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"11532GL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ7H1C7XJ500518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:28.000000Z","updated_at":"2025-03-17T23:48:28.000000Z"}]},{"id":6767583,"change_date":"2024-09-19 21:41:00","inspection_id":"82703496","dot_number":"1168816","report_state":"NY","report_number":"SPWL011446","insp_date":"2024-09-18 00:00:00","insp_start_time":"1230","insp_end_time":"1254","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2951525","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[{"id":10539422,"change_date":"2024-09-19 21:41:00","inspection_id":"82703496","insp_violation_id":"261918707","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203025220","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"3922"},{"id":10539423,"change_date":"2024-09-19 21:41:00","inspection_id":"82703496","insp_violation_id":"261918708","seq_no":"2","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"203025220","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"999"}],"inspection_per_units":[{"id":10912882,"change_date":"2024-09-19 21:41:00","inspection_id":"82703496","insp_unit_id":"203025220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3728679","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC9SDVS2186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:03.000000Z","updated_at":"2025-03-17T23:36:03.000000Z"}]},{"id":6803259,"change_date":"2024-09-24 21:41:00","inspection_id":"82741795","dot_number":"1168816","report_state":"NY","report_number":"SPB3000028","insp_date":"2024-09-18 00:00:00","insp_start_time":"0833","insp_end_time":"0855","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2024-09-24 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":"879395","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2024-09-24 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-24 21:41:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:10.000000Z","updated_at":"2025-03-17T20:38:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10970799,"change_date":"2024-09-24 21:41:00","inspection_id":"82741795","insp_unit_id":"203096430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3728679","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC9SDVS2186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"}]},{"id":4525406,"change_date":"2023-11-30 21:38:00","inspection_id":"80273781","dot_number":"1168816","report_state":"NY","report_number":"SPL0182940","insp_date":"2023-11-29 00:00:00","insp_start_time":"0830","insp_end_time":"0856","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2890286","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:33.000000Z","updated_at":"2025-03-17T19:52:33.000000Z","inspection_violations":[{"id":7002871,"change_date":"2023-11-30 21:38:00","inspection_id":"80273781","insp_violation_id":"256635684","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198278732","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"3939A"},{"id":7002872,"change_date":"2023-11-30 21:38:00","inspection_id":"80273781","insp_violation_id":"256635685","seq_no":"2","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"198278732","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"39381"},{"id":7002873,"change_date":"2023-11-30 21:38:00","inspection_id":"80273781","insp_violation_id":"256635686","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198278732","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7277929,"change_date":"2023-11-30 21:38:00","inspection_id":"80273781","insp_unit_id":"198278732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"11532GL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ7H1C7XJ500518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"}]},{"id":4545929,"change_date":"2023-12-04 21:40:00","inspection_id":"80296456","dot_number":"1168816","report_state":"NY","report_number":"SPL0200067","insp_date":"2023-11-29 00:00:00","insp_start_time":"1152","insp_end_time":"1211","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"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-12-04 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":"2890841","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2023-12-04 21:40:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-04 21:40:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3 36400 NORTH ROAD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:58.000000Z","updated_at":"2025-03-17T19:52:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7311083,"change_date":"2023-12-04 21:40:00","inspection_id":"80296456","insp_unit_id":"198323194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"38844GL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ6C1CX4F514885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"}]},{"id":4320006,"change_date":"2023-10-31 21:39:00","inspection_id":"80047297","dot_number":"1168816","report_state":"NY","report_number":"0L80000001","insp_date":"2023-10-24 00:00:00","insp_start_time":"0754","insp_end_time":"0807","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-31 21:39: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":"81556","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2023-10-31 21:39:00","snet_input_date":"2023-10-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-31 21:39:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:41.000000Z","updated_at":"2025-03-17T19:48:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6948021,"change_date":"2023-10-31 21:39:00","inspection_id":"80047297","insp_unit_id":"197828410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3350477","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC5PDNZ9421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:19.000000Z","updated_at":"2025-03-17T22:58:19.000000Z"}]},{"id":4200658,"change_date":"2023-10-16 21:42:00","inspection_id":"79915281","dot_number":"1168816","report_state":"NY","report_number":"SPL0135358","insp_date":"2023-10-04 00:00:00","insp_start_time":"0852","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2879235","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":null,"census_search_date":"2023-10-16 21:42:00","snet_input_date":"2023-10-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-16 21:42:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3 36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:12.000000Z","updated_at":"2025-03-17T19:46:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6755295,"change_date":"2023-10-16 21:42:00","inspection_id":"79915281","insp_unit_id":"197563380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"582872","insp_unit_license":"3350477","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC5PDNZ9421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:39.000000Z","updated_at":"2025-03-17T22:56:39.000000Z"}]},{"id":1944424,"change_date":"2022-12-14 21:39:00","inspection_id":"77368584","dot_number":"1168816","report_state":"NY","report_number":"SPL0182244","insp_date":"2022-12-13 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"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":"2022-12-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2779254","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2022-12-14 21:39:00","snet_input_date":"2022-12-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-14 21:39:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:32.000000Z","updated_at":"2025-03-17T19:02:32.000000Z","inspection_violations":[{"id":3021361,"change_date":"2022-12-14 21:39:00","inspection_id":"77368584","insp_violation_id":"250094323","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192420543","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:24.000000Z","updated_at":"2025-03-17T21:21:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3128400,"change_date":"2022-12-14 21:39:00","inspection_id":"77368584","insp_unit_id":"192420543","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"38844GL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ6C1CX4F514885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:25.000000Z","updated_at":"2025-03-17T22:28:25.000000Z"}]},{"id":1525980,"change_date":"2022-10-17 21:40:00","inspection_id":"76888459","dot_number":"1168816","report_state":"NY","report_number":"1020000942","insp_date":"2022-10-15 00:00:00","insp_start_time":"0719","insp_end_time":"0744","registration_date":null,"region":"ET","ci_status_code":"C","location":"00716","location_desc":"RIVERHEAD NYS ARMORY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"JAY W GUILD WHOLESALE GROWER","shipping_paper_number":"127377","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2759384","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2022-10-17 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-17 21:40:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:49.000000Z","updated_at":"2025-03-17T18:54:49.000000Z","inspection_violations":[{"id":2402539,"change_date":"2022-10-17 21:40:00","inspection_id":"76888459","insp_violation_id":"249056695","seq_no":"1","part_no":"390","part_no_section":"21T(e)","insp_viol_unit":"1","insp_unit_id":"191464483","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:09.000000Z","updated_at":"2025-03-17T21:18:09.000000Z","normalized_code":"39021TE"}],"inspection_per_units":[{"id":2455256,"change_date":"2022-10-17 21:40:00","inspection_id":"76888459","insp_unit_id":"191464483","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"522452","insp_unit_license":"3168682","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC4NDNG6676","insp_unit_decal":"Y","insp_unit_decal_number":"32008982","created_at":"2025-03-17T22:23:50.000000Z","updated_at":"2025-03-17T22:23:50.000000Z"}]},{"id":1483148,"change_date":"2022-10-11 21:41:00","inspection_id":"76839096","dot_number":"1168816","report_state":"NY","report_number":"1001014961","insp_date":"2022-10-08 00:00:00","insp_start_time":"1216","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"00716","location_desc":"RIVERHEAD NYS ARMORY","county_code_state":"NY","county_code":"103","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":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2757238","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:06.000000Z","updated_at":"2025-03-17T18:54:06.000000Z","inspection_violations":[{"id":2334423,"change_date":"2022-10-11 21:41:00","inspection_id":"76839096","insp_violation_id":"248940321","seq_no":"1","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"191364345","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:41.000000Z","updated_at":"2025-03-17T21:17:41.000000Z","normalized_code":"39381"}],"inspection_per_units":[{"id":2386487,"change_date":"2022-10-11 21:41:00","inspection_id":"76839096","insp_unit_id":"191364345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"786122","insp_unit_license":"2730335","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC0JDKA8193","insp_unit_decal":"Y","insp_unit_decal_number":"32008763","created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"}]},{"id":1351878,"change_date":"2022-09-23 21:37:00","inspection_id":"76686920","dot_number":"1168816","report_state":"NY","report_number":"1021001002","insp_date":"2022-09-22 00:00:00","insp_start_time":"0802","insp_end_time":"0828","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096M","location_desc":"YAPHANK REST AREA (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-23 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2752053","transaction_code":"A","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2022-09-23 21:37:00","snet_input_date":"2022-09-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-23 21:37:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:38.000000Z","updated_at":"2025-03-17T18:51:38.000000Z","inspection_violations":[{"id":2140674,"change_date":"2022-09-23 21:37:00","inspection_id":"76686920","insp_violation_id":"248604768","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191060585","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:48.000000Z","updated_at":"2025-03-17T21:16:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2176622,"change_date":"2022-09-23 21:37:00","inspection_id":"76686920","insp_unit_id":"191060585","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"786122","insp_unit_license":"2730335","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC0JDKA8193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:54.000000Z","updated_at":"2025-03-17T22:21:54.000000Z"}]},{"id":1245523,"change_date":"2022-09-09 21:38:00","inspection_id":"76563123","dot_number":"1168816","report_state":"NY","report_number":"1019007473","insp_date":"2022-09-08 00:00:00","insp_start_time":"0855","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096M","location_desc":"YAPHANK REST AREA (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2746830","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2022-09-09 21:38:00","snet_input_date":"2022-09-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:42.000000Z","updated_at":"2025-03-17T18:49:42.000000Z","inspection_violations":[{"id":1971846,"change_date":"2022-09-09 21:38:00","inspection_id":"76563123","insp_violation_id":"248300515","seq_no":"1","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"190802172","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"393203B"},{"id":1971847,"change_date":"2022-09-09 21:38:00","inspection_id":"76563123","insp_violation_id":"248300516","seq_no":"2","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"190802172","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":2004266,"change_date":"2022-09-09 21:38:00","inspection_id":"76563123","insp_unit_id":"190802172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"821138","insp_unit_license":"2736861","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC2KDKF9132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"}]},{"id":470196,"change_date":"2022-05-24 21:43:00","inspection_id":"75653697","dot_number":"1168816","report_state":"NY","report_number":"SPL0163492","insp_date":"2022-05-18 00:00:00","insp_start_time":"0735","insp_end_time":"0759","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2710398","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01168816","upload_search_indicator":"M","census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"JAY W GUILD WHOLESALE GROWER","insp_carrier_street":"RR 3   36400 NORTH RD","insp_carrier_city":"PECONIC","insp_carrier_state":"NY","insp_carrier_zip_code":"11958","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:58.000000Z","updated_at":"2025-03-17T18:35:58.000000Z","inspection_violations":[{"id":744196,"change_date":"2022-05-24 21:43:00","inspection_id":"75653697","insp_violation_id":"246031984","seq_no":"1","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"188877538","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:34.000000Z","updated_at":"2025-03-17T21:10:34.000000Z","normalized_code":"39355B"},{"id":744197,"change_date":"2022-05-24 21:43:00","inspection_id":"75653697","insp_violation_id":"246031985","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188877538","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:34.000000Z","updated_at":"2025-03-17T21:10:34.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":755978,"change_date":"2022-05-24 21:43:00","inspection_id":"75653697","insp_unit_id":"188877538","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"38844GL","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJ6C1CX4F514885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:51.000000Z","updated_at":"2025-03-17T22:12:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1168816\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1168816\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1168816\/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\/1168816\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}