{"current_page":1,"data":[{"id":12207718,"change_date":"2026-06-17 21:40:00","inspection_id":"88164752","dot_number":"3229868","report_state":"RI","report_number":"0092000027","insp_date":"2026-06-11 00:00:00","insp_start_time":"1305","insp_end_time":"1331","registration_date":null,"region":"ED","ci_status_code":"C","location":"C0095C","location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRAND FOO TRADING INC","shipping_paper_number":"081730","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3559150","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2026-06-17 21:40:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-17 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-20T09:43:37.000000Z","updated_at":"2026-06-28T09:30:21.000000Z","inspection_violations":[{"id":21245920,"change_date":"2026-06-17 21:40:00","inspection_id":"88164752","insp_violation_id":"274957445","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:17.000000Z","updated_at":"2026-06-28T09:40:15.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21202748,"change_date":"2026-06-17 21:40:00","inspection_id":"88164752","insp_unit_id":"214143915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:21:49.000000Z","updated_at":"2026-06-28T09:01:22.000000Z"}]},{"id":11890396,"change_date":"2026-06-01 21:40:00","inspection_id":"87828494","dot_number":"3229868","report_state":"CT","report_number":"3031A01118","insp_date":"2026-05-12 00:00:00","insp_start_time":"1454","insp_end_time":"1533","registration_date":"2026-05-29 00:00:00","region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRAND FOO","shipping_paper_number":"080803","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":"2026-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"772590","transaction_code":"C","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:43.000000Z","updated_at":"2026-06-12T09:30:09.000000Z","inspection_violations":[{"id":20682060,"change_date":"2026-06-01 21:40:00","inspection_id":"87828494","insp_violation_id":"274605516","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138657-3","created_at":"2026-05-15T12:58:33.000000Z","updated_at":"2026-06-12T09:40:22.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":20673355,"change_date":"2026-06-01 21:40:00","inspection_id":"87828494","insp_unit_id":"213840826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:12:47.000000Z","updated_at":"2026-06-12T09:01:07.000000Z"}]},{"id":11818723,"change_date":"2026-05-14 21:43:00","inspection_id":"87753092","dot_number":"3229868","report_state":"NY","report_number":"BC01000593","insp_date":"2026-04-28 00:00:00","insp_start_time":"0944","insp_end_time":"1047","registration_date":"2026-05-14 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BRONX NY","county_code_state":"NY","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"080333","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3256467","transaction_code":"C","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2026-05-04 21:39:00","snet_input_date":"2026-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-04 21:39:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-07T09:39:00.000000Z","updated_at":"2026-05-25T09:30:04.000000Z","inspection_violations":[{"id":20552946,"change_date":"2026-05-14 21:43:00","inspection_id":"87753092","insp_violation_id":"274262103","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"213555689","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:47.000000Z","updated_at":"2026-05-25T09:44:03.000000Z","normalized_code":"3939ALLPL"},{"id":20552945,"change_date":"2026-05-14 21:43:00","inspection_id":"87753092","insp_violation_id":"274262102","seq_no":"1","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":"2026-05-07T09:57:47.000000Z","updated_at":"2026-05-25T09:44:03.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":20556496,"change_date":"2026-05-14 21:43:00","inspection_id":"87753092","insp_unit_id":"213555689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"Y","insp_unit_decal_number":"36369974","created_at":"2026-05-07T09:17:36.000000Z","updated_at":"2026-05-25T09:02:06.000000Z"}]},{"id":11235895,"change_date":"2026-02-26 21:41:00","inspection_id":"87148357","dot_number":"3229868","report_state":"MA","report_number":"DX00001029","insp_date":"2026-02-26 00:00:00","insp_start_time":"1226","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"294H","location_desc":"H-SEEKONK","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRAND FOO TRADING","shipping_paper_number":"078333","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 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":"540895","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":"M","census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:59.000000Z","updated_at":"2026-03-09T09:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19207398,"change_date":"2026-02-26 21:41:00","inspection_id":"87148357","insp_unit_id":"211850766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:42.000000Z","updated_at":"2026-03-09T09:07:58.000000Z"}]},{"id":11444151,"change_date":"2026-03-23 21:50:00","inspection_id":"87361214","dot_number":"3229868","report_state":"NJ","report_number":"PACCI00533","insp_date":"2026-02-09 00:00:00","insp_start_time":"1630","insp_end_time":"1639","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NJ","county_code_state":"NJ","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-23 21:50: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":"3048140","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2026-03-23 21:50:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-23 21:50:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:20.000000Z","updated_at":"2026-04-03T09:31:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19603542,"change_date":"2026-03-23 21:50:00","inspection_id":"87361214","insp_unit_id":"212271684","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:38.000000Z","updated_at":"2026-04-03T09:04:49.000000Z"}]},{"id":11089818,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","dot_number":"3229868","report_state":"NY","report_number":"SPT3150240","insp_date":"2026-02-03 00:00:00","insp_start_time":"1326","insp_end_time":"1402","registration_date":"2026-03-03 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"WHITE PLAINS NY","county_code_state":"NY","county_code":"119","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":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2865957","transaction_code":"C","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:48.000000Z","updated_at":"2026-03-15T09:30:47.000000Z","inspection_violations":[{"id":18964485,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186395","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"3922SLLIFTA"},{"id":18964486,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186396","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"3922SLLSR"},{"id":18964487,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186397","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"39395F"},{"id":18964488,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186398","seq_no":"4","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"39111B2Q"},{"id":18964489,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186399","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"39395A1"},{"id":18964490,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186400","seq_no":"6","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"3969D2FTF"},{"id":18964491,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186401","seq_no":"7","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"3939ALCL"},{"id":18964492,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_violation_id":"272186402","seq_no":"8","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"211959361","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:12.000000Z","updated_at":"2026-03-15T09:41:34.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":19303123,"change_date":"2026-03-04 21:40:00","inspection_id":"87001315","insp_unit_id":"211959361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"11","insp_unit_license":"30731NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W164J7300550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:44.000000Z","updated_at":"2026-03-15T09:03:11.000000Z"}]},{"id":10807189,"change_date":"2026-01-20 21:39:00","inspection_id":"86834132","dot_number":"3229868","report_state":"NY","report_number":"SPK4070118","insp_date":"2026-01-13 00:00:00","insp_start_time":"1045","insp_end_time":"1114","registration_date":null,"region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25998","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2788680","transaction_code":"A","transaction_date":"2026-01-19 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:10.000000Z","updated_at":"2026-01-31T10:30:15.000000Z","inspection_violations":[{"id":18064196,"change_date":"2026-01-20 21:39:00","inspection_id":"86834132","insp_violation_id":"271295321","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"211169057","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:19.000000Z","updated_at":"2026-01-31T10:37:08.000000Z","normalized_code":"3922SLLIFTA"},{"id":18064197,"change_date":"2026-01-20 21:39:00","inspection_id":"86834132","insp_violation_id":"271295322","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:19.000000Z","updated_at":"2026-01-31T10:37:08.000000Z","normalized_code":"39111B2Q"},{"id":18064198,"change_date":"2026-01-20 21:39:00","inspection_id":"86834132","insp_violation_id":"271295323","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:19.000000Z","updated_at":"2026-01-31T10:37:08.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":18146619,"change_date":"2026-01-20 21:39:00","inspection_id":"86834132","insp_unit_id":"211169057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:14.000000Z","updated_at":"2026-01-31T10:02:32.000000Z"}]},{"id":10233797,"change_date":"2025-12-05 21:41:00","inspection_id":"86356095","dot_number":"3229868","report_state":"CT","report_number":"0632000317","insp_date":"2025-11-18 00:00:00","insp_start_time":"1330","insp_end_time":"1415","registration_date":"2025-12-05 00:00:00","region":"ET","ci_status_code":"C","location":"130","location_desc":"I-84 E\/B X15 S&S LOT","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRAND FOO TRADING","shipping_paper_number":"075168","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"758112","transaction_code":"C","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-11-19 21:38:00","snet_input_date":"2025-11-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-19 21:38:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-23T10:31:20.000000Z","updated_at":"2025-12-09T10:30:04.000000Z","inspection_violations":[{"id":17333676,"change_date":"2025-12-05 21:41:00","inspection_id":"86356095","insp_violation_id":"270474096","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-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:06.000000Z","normalized_code":"39141APC"},{"id":17333677,"change_date":"2025-12-05 21:41:00","inspection_id":"86356095","insp_violation_id":"270474097","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210426267","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:06.000000Z","normalized_code":"39347E"},{"id":17333678,"change_date":"2025-12-05 21:41:00","inspection_id":"86356095","insp_violation_id":"270474098","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"210426267","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:06.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":17304869,"change_date":"2025-12-05 21:41:00","inspection_id":"86356095","insp_unit_id":"210426267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"001","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:47.000000Z","updated_at":"2025-12-09T10:00:05.000000Z"}]},{"id":9374017,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","dot_number":"3229868","report_state":"CT","report_number":"3070007243","insp_date":"2025-08-09 00:00:00","insp_start_time":"1041","insp_end_time":"1502","registration_date":"2025-08-28 00:00:00","region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"071732","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-11 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"6","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"748409","transaction_code":"C","transaction_date":"2025-08-09 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-08-11 21:37:00","snet_input_date":"2025-08-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-11 21:37:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:17.000000Z","updated_at":"2025-09-06T10:42:22.000000Z","inspection_violations":[{"id":15570406,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_violation_id":"268327678","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"1","insp_unit_id":"208646271","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135336-0","created_at":"2025-09-06T10:45:56.000000Z","updated_at":"2025-09-06T10:45:56.000000Z","normalized_code":"3922SLLEWG2"},{"id":15570407,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_violation_id":"268327679","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"208646271","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135336-0","created_at":"2025-09-06T10:45:56.000000Z","updated_at":"2025-09-06T10:45:56.000000Z","normalized_code":"3922SLLEWA1"},{"id":15570408,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_violation_id":"268327680","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"208646271","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135336-0","created_at":"2025-09-06T10:45:56.000000Z","updated_at":"2025-09-06T10:45:56.000000Z","normalized_code":"3922SLLIFTA"},{"id":15570409,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_violation_id":"268327681","seq_no":"4","part_no":"393","part_no_section":"75G-TFWETL","insp_viol_unit":"1","insp_unit_id":"208646271","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V135336-0","created_at":"2025-09-06T10:45:56.000000Z","updated_at":"2025-09-06T10:45:56.000000Z","normalized_code":"39375GTFWETL"},{"id":15570410,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_violation_id":"268327682","seq_no":"5","part_no":"383","part_no_section":"91A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:45:56.000000Z","updated_at":"2025-09-06T10:45:56.000000Z","normalized_code":"38391ALCDL"},{"id":15570411,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_violation_id":"268327683","seq_no":"6","part_no":"391","part_no_section":"41B10-MC","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-09-06T10:45:56.000000Z","updated_at":"2025-09-06T10:45:56.000000Z","normalized_code":"39141B10MC"}],"inspection_per_units":[{"id":15744068,"change_date":"2025-08-29 21:39:00","inspection_id":"85452128","insp_unit_id":"208646271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:43.000000Z","updated_at":"2025-09-09T09:46:43.000000Z"}]},{"id":8790208,"change_date":"2025-06-19 21:37:00","inspection_id":"84836343","dot_number":"3229868","report_state":"CT","report_number":"0511000505","insp_date":"2025-05-31 00:00:00","insp_start_time":"1216","insp_end_time":"1228","registration_date":"2025-06-19 00:00:00","region":"ET","ci_status_code":"C","location":"101","location_desc":"I-91 NORTH HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GRAND FOO TRADING INC","shipping_paper_number":"069375","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"741802","transaction_code":"C","transaction_date":"2025-05-31 00:00:00","upload_date":"2025-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-05-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:22.000000Z","updated_at":"2025-06-23T10:00:05.000000Z","inspection_violations":[{"id":14339132,"change_date":"2025-06-19 21:37:00","inspection_id":"84836343","insp_violation_id":"266925196","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-22T10:16:36.000000Z","updated_at":"2025-06-23T10:15:07.000000Z","normalized_code":"3922SLLS4"},{"id":14339133,"change_date":"2025-06-19 21:37:00","inspection_id":"84836343","insp_violation_id":"266925197","seq_no":"2","part_no":"392","part_no_section":"2-SLLFC","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:36.000000Z","updated_at":"2025-06-23T10:15:07.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":14642265,"change_date":"2025-06-19 21:37:00","inspection_id":"84836343","insp_unit_id":"207455529","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"10","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:23.000000Z","updated_at":"2025-06-23T09:45:04.000000Z"}]},{"id":8688651,"change_date":"2025-07-02 21:40:00","inspection_id":"84728834","dot_number":"3229868","report_state":"NJ","report_number":"PACAI00265","insp_date":"2025-05-19 00:00:00","insp_start_time":"1750","insp_end_time":"1835","registration_date":"2025-05-20 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"HOLLAND TUNNEL POST 20","county_code_state":"NJ","county_code":"017","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":"2025-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1287423","transaction_code":"C","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-19 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:04:15.000000Z","updated_at":"2025-07-07T10:07:14.000000Z","inspection_violations":[{"id":14551121,"change_date":"2025-07-02 21:40:00","inspection_id":"84728834","insp_violation_id":"267173510","seq_no":"1","part_no":"393","part_no_section":"9B-LRR","insp_viol_unit":"1","insp_unit_id":"207676920","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:27.000000Z","updated_at":"2025-07-06T10:16:54.000000Z","normalized_code":"3939BLRR"},{"id":14551122,"change_date":"2025-07-02 21:40:00","inspection_id":"84728834","insp_violation_id":"267173511","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"207676920","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:27.000000Z","updated_at":"2025-07-06T10:16:54.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":14551123,"change_date":"2025-07-02 21:40:00","inspection_id":"84728834","insp_violation_id":"267173512","seq_no":"3","part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"207676920","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:27.000000Z","updated_at":"2025-07-06T10:16:54.000000Z","normalized_code":"393201BFR"},{"id":14551124,"change_date":"2025-07-02 21:40:00","inspection_id":"84728834","insp_violation_id":"267173513","seq_no":"4","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:27.000000Z","updated_at":"2025-07-06T10:16:54.000000Z","normalized_code":"39111B2Q"}],"inspection_per_units":[{"id":14840987,"change_date":"2025-07-02 21:40:00","inspection_id":"84728834","insp_unit_id":"207676920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30731NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W164J7300550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:05.000000Z","updated_at":"2025-07-06T09:45:17.000000Z"}]},{"id":8387865,"change_date":"2025-04-16 21:40:00","inspection_id":"84412013","dot_number":"3229868","report_state":"NY","report_number":"D012102074","insp_date":"2025-04-11 00:00:00","insp_start_time":"1128","insp_end_time":"1139","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","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":"U","pen_cen_match":"I","final_status_date":"2025-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1599236","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:45.000000Z","updated_at":"2025-04-20T10:23:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13614554,"change_date":"2025-04-16 21:40:00","inspection_id":"84412013","insp_unit_id":"206334906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"30705NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W166P7902035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:02:36.000000Z","updated_at":"2025-04-20T09:50:48.000000Z"}]},{"id":8310150,"change_date":"2025-05-19 21:40:00","inspection_id":"84330285","dot_number":"3229868","report_state":"NJ","report_number":"SPQSI02580","insp_date":"2025-04-04 00:00:00","insp_start_time":"1200","insp_end_time":"1245","registration_date":"2025-04-14 00:00:00","region":"ET","ci_status_code":"C","location":"1217","location_desc":"PISCATAWAY WEIGHT STATION","county_code_state":"NJ","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1277356","transaction_code":"C","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:17.000000Z","updated_at":"2025-05-23T10:04:10.000000Z","inspection_violations":[{"id":13807412,"change_date":"2025-05-19 21:40:00","inspection_id":"84330285","insp_violation_id":"266317701","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"206940832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:18:11.000000Z","updated_at":"2025-05-23T10:21:24.000000Z","normalized_code":"3939ALCL"},{"id":13807413,"change_date":"2025-05-19 21:40:00","inspection_id":"84330285","insp_violation_id":"266317702","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"206940832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:18:11.000000Z","updated_at":"2025-05-23T10:21:24.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":14167899,"change_date":"2025-05-19 21:40:00","inspection_id":"84330285","insp_unit_id":"206940832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30731NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W164J7300550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:45:58.000000Z","updated_at":"2025-05-23T09:49:04.000000Z"}]},{"id":7905804,"change_date":"2025-02-19 21:40:00","inspection_id":"83904959","dot_number":"3229868","report_state":"NJ","report_number":"SPSDI01303","insp_date":"2025-02-17 00:00:00","insp_start_time":"1215","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"@SH 3 WB MP 5.8 RUTHERFORD BOR","county_code_state":"NJ","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1266031","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-17 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:21.000000Z","updated_at":"2025-03-17T21:02:21.000000Z","inspection_violations":[{"id":12354926,"change_date":"2025-02-19 21:40:00","inspection_id":"83904959","insp_violation_id":"264588699","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12761238,"change_date":"2025-02-19 21:40:00","inspection_id":"83904959","insp_unit_id":"205392589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:00.000000Z","updated_at":"2025-03-17T23:56:00.000000Z"}]},{"id":7658919,"change_date":"2025-01-18 21:33:00","inspection_id":"83645631","dot_number":"3229868","report_state":"NY","report_number":"0L98000491","insp_date":"2025-01-17 00:00:00","insp_start_time":"1134","insp_end_time":"1151","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","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":"U","pen_cen_match":"I","final_status_date":"2025-01-18 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1264097","transaction_code":"A","transaction_date":"2025-01-18 00:00:00","upload_date":"2025-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-01-18 21:33:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-18 21:33:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:04.000000Z","updated_at":"2025-03-17T20:57:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12358361,"change_date":"2025-01-18 21:33:00","inspection_id":"83645631","insp_unit_id":"204910137","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"30705NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W166P7902035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:22.000000Z","updated_at":"2025-03-17T23:51:22.000000Z"}]},{"id":7615261,"change_date":"2025-03-13 21:43:00","inspection_id":"83599871","dot_number":"3229868","report_state":"NJ","report_number":"PABZI00254","insp_date":"2025-01-13 00:00:00","insp_start_time":"1701","insp_end_time":"1743","registration_date":"2025-01-13 00:00:00","region":"ET","ci_status_code":"C","location":"0219","location_desc":"GWB FORT LEE NJ","county_code_state":"NJ","county_code":"003","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":"2025-01-14 21:55: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":"1258072","transaction_code":"C","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2025-01-14 21:55:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-01-14 21:55:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":11904116,"change_date":"2025-03-13 21:43:00","inspection_id":"83599871","insp_violation_id":"265022310","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"205784813","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":12287492,"change_date":"2025-03-13 21:43:00","inspection_id":"83599871","insp_unit_id":"205784813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:37.000000Z","updated_at":"2025-03-17T23:50:37.000000Z"}]},{"id":7225486,"change_date":"2024-11-19 21:40:00","inspection_id":"83189778","dot_number":"3229868","report_state":"NY","report_number":"SPK4000014","insp_date":"2024-11-12 00:00:00","insp_start_time":"1120","insp_end_time":"1140","registration_date":null,"region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","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-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25590","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":"1067338","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[{"id":11293931,"change_date":"2024-11-19 21:40:00","inspection_id":"83189778","insp_violation_id":"262967598","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"203944734","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":11654729,"change_date":"2024-11-19 21:40:00","inspection_id":"83189778","insp_unit_id":"203944734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA01023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:46.000000Z","updated_at":"2025-03-17T23:43:46.000000Z"}]},{"id":6910250,"change_date":"2024-10-08 21:41:00","inspection_id":"82855395","dot_number":"3229868","report_state":"NY","report_number":"D012101332","insp_date":"2024-10-08 00:00:00","insp_start_time":"1208","insp_end_time":"1232","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","county_code_state":"NY","county_code":"059","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-10-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"924853","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-10-08 21:41:00","snet_input_date":"2024-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:14.000000Z","updated_at":"2025-03-17T20:40:14.000000Z","inspection_violations":[{"id":10768519,"change_date":"2024-10-08 21:41:00","inspection_id":"82855395","insp_violation_id":"262238868","seq_no":"1","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"203312321","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7TG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39311A1"},{"id":10768520,"change_date":"2024-10-08 21:41:00","inspection_id":"82855395","insp_violation_id":"262238869","seq_no":"2","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"203312321","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"10040B7VG9","created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":11144634,"change_date":"2024-10-08 21:41:00","inspection_id":"82855395","insp_unit_id":"203312321","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"30705NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W166P7902035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"}]},{"id":6677846,"change_date":"2024-09-09 21:40:00","inspection_id":"82608121","dot_number":"3229868","report_state":"NJ","report_number":"PABJI00151","insp_date":"2024-09-06 00:00:00","insp_start_time":"1135","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SIB","county_code_state":"NJ","county_code":"023","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":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1233266","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:16.000000Z","updated_at":"2025-03-17T20:35:16.000000Z","inspection_violations":[{"id":10393215,"change_date":"2024-09-09 21:40:00","inspection_id":"82608121","insp_violation_id":"261685268","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202821708","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"39395A"},{"id":10393216,"change_date":"2024-09-09 21:40:00","inspection_id":"82608121","insp_violation_id":"261685269","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202821708","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3939A"},{"id":10393217,"change_date":"2024-09-09 21:40:00","inspection_id":"82608121","insp_violation_id":"261685270","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"202821708","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1216-HH-106231","created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":10766830,"change_date":"2024-09-09 21:40:00","inspection_id":"82608121","insp_unit_id":"202821708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30731NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W164J7300550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"}]},{"id":6353867,"change_date":"2024-07-31 21:42:00","inspection_id":"82262498","dot_number":"3229868","report_state":"NY","report_number":"D012101037","insp_date":"2024-07-30 00:00:00","insp_start_time":"1316","insp_end_time":"1339","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","county_code_state":"NY","county_code":"059","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-07-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"704900","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-07-31 21:42:00","snet_input_date":"2024-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-31 21:42:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:42.000000Z","updated_at":"2025-03-17T20:28:42.000000Z","inspection_violations":[{"id":9865164,"change_date":"2024-07-31 21:42:00","inspection_id":"82262498","insp_violation_id":"260935222","seq_no":"1","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"202161050","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":10239373,"change_date":"2024-07-31 21:42:00","inspection_id":"82262498","insp_unit_id":"202161050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"30705NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W166P7902035","insp_unit_decal":"Y","insp_unit_decal_number":"34336782","created_at":"2025-03-17T23:29:03.000000Z","updated_at":"2025-03-17T23:29:03.000000Z"}]},{"id":6158006,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","dot_number":"3229868","report_state":"NY","report_number":"N417000731","insp_date":"2024-07-02 00:00:00","insp_start_time":"0902","insp_end_time":"0943","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BROOKLYN NY","county_code_state":"NY","county_code":"047","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-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"5","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":"631447","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-07-08 21:41:00","snet_input_date":"2024-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-08 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:39.000000Z","updated_at":"2025-03-17T20:24:39.000000Z","inspection_violations":[{"id":9557771,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","insp_violation_id":"260492961","seq_no":"1","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"201757774","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4457733743","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"39021TB2"},{"id":9557772,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","insp_violation_id":"260492962","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"201757774","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4457733774","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"39375C"},{"id":9557773,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","insp_violation_id":"260492963","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"201757774","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4457733760","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"39375C"},{"id":9557774,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","insp_violation_id":"260492964","seq_no":"4","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"201757774","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4457733730","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"39021TB1"},{"id":9557775,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","insp_violation_id":"260492965","seq_no":"5","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"201757774","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4457733757","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":9919725,"change_date":"2024-07-08 21:41:00","inspection_id":"82052448","insp_unit_id":"201757774","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"58559MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4B16177007233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:48.000000Z","updated_at":"2025-03-17T23:25:48.000000Z"}]},{"id":5814303,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","dot_number":"3229868","report_state":"RI","report_number":"0198000016","insp_date":"2024-05-16 00:00:00","insp_start_time":"1325","insp_end_time":"1444","registration_date":"2024-06-04 00:00:00","region":"ED","ci_status_code":"C","location":"I0095N","location_desc":"EXETER RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GRAND FOO TRADING INC","shipping_paper_number":"056674","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"504589","transaction_code":"C","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:54.000000Z","updated_at":"2025-03-17T20:17:54.000000Z","inspection_violations":[{"id":9007119,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886253","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39378A"},{"id":9007120,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886254","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"3939A"},{"id":9007121,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886255","seq_no":"3","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39021TB2"},{"id":9007122,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886256","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39347E"},{"id":9007123,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886257","seq_no":"5","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39311A1"},{"id":9007124,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886258","seq_no":"6","part_no":"393","part_no_section":"102(c)(2)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"393102C2"},{"id":9007125,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886259","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"3969D2"},{"id":9007126,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886260","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39353B"},{"id":9007127,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886261","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201217941","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"3963A1"},{"id":9007128,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_violation_id":"259886262","seq_no":"10","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:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9364199,"change_date":"2024-06-04 21:41:00","inspection_id":"81680923","insp_unit_id":"201217941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:13.000000Z","updated_at":"2025-03-17T23:20:13.000000Z"}]},{"id":5443191,"change_date":"2024-04-09 21:40:00","inspection_id":"81276652","dot_number":"3229868","report_state":"CT","report_number":"3017001540","insp_date":"2024-04-04 00:00:00","insp_start_time":"1850","insp_end_time":"1941","registration_date":"2024-04-09 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 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":"704174","transaction_code":"C","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-04-05 21:39:00","snet_input_date":"2024-04-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-05 21:39:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:39.000000Z","updated_at":"2025-03-17T20:10:39.000000Z","inspection_violations":[{"id":8401558,"change_date":"2024-04-09 21:40:00","inspection_id":"81276652","insp_violation_id":"258815790","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200298974","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":8767660,"change_date":"2024-04-09 21:40:00","inspection_id":"81276652","insp_unit_id":"200298974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"10","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:33.000000Z","updated_at":"2025-03-17T23:14:33.000000Z"}]},{"id":5334025,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","dot_number":"3229868","report_state":"NY","report_number":"D011900552","insp_date":"2024-03-19 00:00:00","insp_start_time":"1243","insp_end_time":"1330","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GLEN COVE NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CHINA PALACE  GLEN COVE","shipping_paper_number":"54799","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":"2024-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"333924","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-03-21 21:40:00","snet_input_date":"2024-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-21 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[{"id":8231078,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503446","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409M7G9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3922SLLIFTA"},{"id":8231079,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503447","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"100409MFG9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3963A1BOS"},{"id":8231080,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503448","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409M6G9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39021TB2DOT"},{"id":8231081,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503449","seq_no":"4","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409M8G9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39311A1LRR"},{"id":8231082,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503450","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409MMBG9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39347E"},{"id":8231083,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503451","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409M9G9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39347E"},{"id":8231084,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503452","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409MCG9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39347E"},{"id":8231085,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_violation_id":"258503453","seq_no":"8","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"200015747","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"100409MDG9","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":8590166,"change_date":"2024-03-21 21:40:00","inspection_id":"81157780","insp_unit_id":"200015747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT3A4S51569","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:55.000000Z","updated_at":"2025-03-17T23:12:55.000000Z"}]},{"id":4880302,"change_date":"2024-01-23 21:44:00","inspection_id":"80662268","dot_number":"3229868","report_state":"CT","report_number":"3016000756","insp_date":"2024-01-23 00:00:00","insp_start_time":"1043","insp_end_time":"1056","registration_date":null,"region":"ET","ci_status_code":"C","location":"057","location_desc":"I95 N\/B EXIT 3 GREENWICH","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ARIANA CAFE","shipping_paper_number":"52963","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-01-23 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"697628","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-01-23 21:44:00","snet_input_date":"2024-01-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-23 21:44:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:34.000000Z","updated_at":"2025-03-17T19:59:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7852458,"change_date":"2024-01-23 21:44:00","inspection_id":"80662268","insp_unit_id":"199061320","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"0","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:11.000000Z","updated_at":"2025-03-17T23:06:11.000000Z"}]},{"id":5049218,"change_date":"2024-02-14 21:41:00","inspection_id":"80847138","dot_number":"3229868","report_state":"NJ","report_number":"PACB000259","insp_date":"2024-01-22 00:00:00","insp_start_time":"1649","insp_end_time":"1731","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GWB POST 10 NJ TOLL PLAZA","county_code_state":"NJ","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-02-14 21:41: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":"1193843","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2024-02-14 21:41:00","snet_input_date":"2024-02-14 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-02-14 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:45.000000Z","updated_at":"2025-03-17T20:02:45.000000Z","inspection_violations":[{"id":7781629,"change_date":"2024-02-14 21:41:00","inspection_id":"80847138","insp_violation_id":"257832622","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199418423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8127636,"change_date":"2024-02-14 21:41:00","inspection_id":"80847138","insp_unit_id":"199418423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"10","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:38.000000Z","updated_at":"2025-03-17T23:08:38.000000Z"}]},{"id":4731975,"change_date":"2023-12-29 21:40:00","inspection_id":"80500204","dot_number":"3229868","report_state":"NY","report_number":"0L95000112","insp_date":"2023-12-29 00:00:00","insp_start_time":"1313","insp_end_time":"1335","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WOODBURY 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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-29 21:40: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":"149766","transaction_code":"A","transaction_date":"2023-12-29 00:00:00","upload_date":"2023-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:33.000000Z","updated_at":"2025-03-17T19:56:33.000000Z","inspection_violations":[{"id":7306753,"change_date":"2023-12-29 21:40:00","inspection_id":"80500204","insp_violation_id":"257114576","seq_no":"1","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"198736417","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"L182HK7RXS","created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39019B2"}],"inspection_per_units":[{"id":7611713,"change_date":"2023-12-29 21:40:00","inspection_id":"80500204","insp_unit_id":"198736417","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"10","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:03.000000Z","updated_at":"2025-03-17T23:04:03.000000Z"}]},{"id":4402507,"change_date":"2023-11-21 21:39:00","inspection_id":"80138601","dot_number":"3229868","report_state":"MA","report_number":"DQ00000212","insp_date":"2023-11-09 00:00:00","insp_start_time":"1717","insp_end_time":"1730","registration_date":"2023-11-21 00:00:00","region":"ET","ci_status_code":"C","location":"116H","location_desc":"H-FRAMINGHAM","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"050489","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"478319","transaction_code":"C","transaction_date":"2023-11-13 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":"M","census_search_date":"2023-11-13 21:40:00","snet_input_date":"2023-11-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-13 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:15.000000Z","updated_at":"2025-03-17T19:50:15.000000Z","inspection_violations":[{"id":6814625,"change_date":"2023-11-21 21:39:00","inspection_id":"80138601","insp_violation_id":"256506056","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:47.000000Z","updated_at":"2025-03-17T21:38:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7080291,"change_date":"2023-11-21 21:39:00","inspection_id":"80138601","insp_unit_id":"198159340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"10","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","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":4280183,"change_date":"2023-10-25 21:41:00","inspection_id":"80003191","dot_number":"3229868","report_state":"NY","report_number":"1019009031","insp_date":"2023-10-24 00:00:00","insp_start_time":"1301","insp_end_time":"1333","registration_date":null,"region":"ET","ci_status_code":"C","location":"02026","location_desc":"GLEN COVE TRANSFER STATION","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CHINA PLACE GLEN COVE","shipping_paper_number":"49978","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-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2882220","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:49.000000Z","updated_at":"2025-03-17T19:47:49.000000Z","inspection_violations":[{"id":6621146,"change_date":"2023-10-25 21:41:00","inspection_id":"80003191","insp_violation_id":"256032348","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197736484","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1004099FG9","created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3963A1"},{"id":6621147,"change_date":"2023-10-25 21:41:00","inspection_id":"80003191","insp_violation_id":"256032349","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197736484","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1004099GG9","created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"39311"},{"id":6621148,"change_date":"2023-10-25 21:41:00","inspection_id":"80003191","insp_violation_id":"256032350","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197736484","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1004099HG9","created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6883488,"change_date":"2023-10-25 21:41:00","inspection_id":"80003191","insp_unit_id":"197736484","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"58482MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAA534H516215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:42.000000Z","updated_at":"2025-03-17T22:57:42.000000Z"}]},{"id":3551789,"change_date":"2023-08-08 21:40:00","inspection_id":"79192181","dot_number":"3229868","report_state":"CT","report_number":"3013000520","insp_date":"2023-07-20 00:00:00","insp_start_time":"1112","insp_end_time":"1146","registration_date":"2023-08-08 00:00:00","region":"ET","ci_status_code":"C","location":"014","location_desc":"BRANFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"046544","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-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"681126","transaction_code":"C","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-07-20 21:40:00","snet_input_date":"2023-07-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-20 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:10.000000Z","updated_at":"2025-03-17T19:33:10.000000Z","inspection_violations":[{"id":5476240,"change_date":"2023-08-08 21:40:00","inspection_id":"79192181","insp_violation_id":"254523102","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":5711095,"change_date":"2023-08-08 21:40:00","inspection_id":"79192181","insp_unit_id":"196414841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"10","insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:05.000000Z","updated_at":"2025-03-17T22:48:05.000000Z"}]},{"id":3528521,"change_date":"2023-07-27 21:40:00","inspection_id":"79165923","dot_number":"3229868","report_state":"MA","report_number":"CP00003281","insp_date":"2023-07-13 00:00:00","insp_start_time":"1641","insp_end_time":"1656","registration_date":"2023-07-27 00:00:00","region":"ET","ci_status_code":"C","location":"307H","location_desc":"H-SOUTHBOROUGH","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"470120","transaction_code":"C","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-07-18 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-07-18 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:48.000000Z","updated_at":"2025-03-17T19:32:48.000000Z","inspection_violations":[{"id":5441125,"change_date":"2023-07-27 21:40:00","inspection_id":"79165923","insp_violation_id":"254305142","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"3922"},{"id":5441126,"change_date":"2023-07-27 21:40:00","inspection_id":"79165923","insp_violation_id":"254305143","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:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5673535,"change_date":"2023-07-27 21:40:00","inspection_id":"79165923","insp_unit_id":"196217457","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:46.000000Z","updated_at":"2025-03-17T22:47:46.000000Z"}]},{"id":3175544,"change_date":"2023-05-31 21:41:00","inspection_id":"78768527","dot_number":"3229868","report_state":"NY","report_number":"SPK0146643","insp_date":"2023-05-30 00:00:00","insp_start_time":"1303","insp_end_time":"1318","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","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-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2830453","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-05-31 21:41:00","snet_input_date":"2023-05-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-31 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:46.000000Z","updated_at":"2025-03-17T19:25:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5107861,"change_date":"2023-05-31 21:41:00","inspection_id":"78768527","insp_unit_id":"195220014","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"30731NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W164J7300550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"}]},{"id":2700478,"change_date":"2023-03-31 21:40:00","inspection_id":"78231281","dot_number":"3229868","report_state":"CT","report_number":"3087002443","insp_date":"2023-03-30 00:00:00","insp_start_time":"1835","insp_end_time":"1924","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"UNION","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"671056","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-03-31 21:40:00","snet_input_date":"2023-03-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-31 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:33.000000Z","updated_at":"2025-03-17T19:16:33.000000Z","inspection_violations":[{"id":4147815,"change_date":"2023-03-31 21:40:00","inspection_id":"78231281","insp_violation_id":"251965464","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"194153309","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y9949901","created_at":"2025-03-17T21:26:26.000000Z","updated_at":"2025-03-17T21:26:26.000000Z","normalized_code":"39375A"},{"id":4147816,"change_date":"2023-03-31 21:40:00","inspection_id":"78231281","insp_violation_id":"251965465","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:26.000000Z","updated_at":"2025-03-17T21:26:26.000000Z","normalized_code":"3922"},{"id":4147817,"change_date":"2023-03-31 21:40:00","inspection_id":"78231281","insp_violation_id":"251965466","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194153309","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:26.000000Z","updated_at":"2025-03-17T21:26:26.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4347187,"change_date":"2023-03-31 21:40:00","inspection_id":"78231281","insp_unit_id":"194153309","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:14.000000Z","updated_at":"2025-03-17T22:37:14.000000Z"}]},{"id":2406264,"change_date":"2023-05-10 21:41:00","inspection_id":"77896104","dot_number":"3229868","report_state":"RI","report_number":"00DP002378","insp_date":"2023-02-09 00:00:00","insp_start_time":"1219","insp_end_time":"1243","registration_date":"2023-03-06 00:00:00","region":"ET","ci_status_code":"C","location":"29","location_desc":"RT 95N @ EXIT 16 (RT 10)","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"80653","transaction_code":"C","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":"M","census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-09 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:03.000000Z","updated_at":"2025-03-17T19:11:03.000000Z","inspection_violations":[{"id":3704295,"change_date":"2023-05-10 21:41:00","inspection_id":"77896104","insp_violation_id":"252739501","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3872035,"change_date":"2023-05-10 21:41:00","inspection_id":"77896104","insp_unit_id":"194849861","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2100901,"change_date":"2023-01-30 21:42:00","inspection_id":"77547235","dot_number":"3229868","report_state":"CT","report_number":"3090003044","insp_date":"2023-01-10 00:00:00","insp_start_time":"1019","insp_end_time":"1042","registration_date":"2023-01-30 00:00:00","region":"ET","ci_status_code":"C","location":"057","location_desc":"GREENWICH","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"040303","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"663143","transaction_code":"C","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2023-01-10 21:39:00","snet_input_date":"2023-01-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-01-10 21:39:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:28.000000Z","updated_at":"2025-03-17T19:05:28.000000Z","inspection_violations":[{"id":3253255,"change_date":"2023-01-30 21:42:00","inspection_id":"77547235","insp_violation_id":"250833844","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:24.000000Z","updated_at":"2025-03-17T21:22:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3380820,"change_date":"2023-01-30 21:42:00","inspection_id":"77547235","insp_unit_id":"193115390","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:14.000000Z","updated_at":"2025-03-17T22:30:14.000000Z"}]},{"id":1724276,"change_date":"2022-11-14 21:41:00","inspection_id":"77116296","dot_number":"3229868","report_state":"NY","report_number":"0L70000169","insp_date":"2022-11-10 00:00:00","insp_start_time":"1557","insp_end_time":"1608","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B L.I. EXPRESSWAY X51\/52","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-14 21:41: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":"2767780","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":"M","census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[{"id":2700967,"change_date":"2022-11-14 21:41:00","inspection_id":"77116296","insp_violation_id":"249560622","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191920299","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H930G339B5","created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"3922"},{"id":2700968,"change_date":"2022-11-14 21:41:00","inspection_id":"77116296","insp_violation_id":"249560623","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"191920299","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":2773706,"change_date":"2022-11-14 21:41:00","inspection_id":"77116296","insp_unit_id":"191920299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT3A4S51569","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":929890,"change_date":"2022-08-01 21:38:00","inspection_id":"76195629","dot_number":"3229868","report_state":"NY","report_number":"SPWK081849","insp_date":"2022-07-30 00:00:00","insp_start_time":"1123","insp_end_time":"1142","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057","location_desc":"INTERSTATE 684","county_code_state":"NY","county_code":"119","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-08-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2733938","transaction_code":"A","transaction_date":"2022-08-01 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":"M","census_search_date":"2022-08-01 21:38:00","snet_input_date":"2022-08-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-01 21:38:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:04.000000Z","updated_at":"2025-03-17T18:44:04.000000Z","inspection_violations":[{"id":1467761,"change_date":"2022-08-01 21:38:00","inspection_id":"76195629","insp_violation_id":"247420290","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190053786","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3922"},{"id":1467762,"change_date":"2022-08-01 21:38:00","inspection_id":"76195629","insp_violation_id":"247420291","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190053786","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3922"},{"id":1467763,"change_date":"2022-08-01 21:38:00","inspection_id":"76195629","insp_violation_id":"247420292","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190053786","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1496866,"change_date":"2022-08-01 21:38:00","inspection_id":"76195629","insp_unit_id":"190053786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58562MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT3A4S51569","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:25.000000Z","updated_at":"2025-03-17T22:17:25.000000Z"}]},{"id":775641,"change_date":"2022-07-08 21:40:00","inspection_id":"76015127","dot_number":"3229868","report_state":"CT","report_number":"3067002183","insp_date":"2022-07-07 00:00:00","insp_start_time":"1005","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"084","location_desc":"MILFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"648257","transaction_code":"A","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03229868","upload_search_indicator":null,"census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"GRAND FOO TRADING INC","insp_carrier_street":"126 GARDNER AVE","insp_carrier_city":"BROOKLYN","insp_carrier_state":"NY","insp_carrier_zip_code":"11237","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[{"id":1225491,"change_date":"2022-07-08 21:40:00","inspection_id":"76015127","insp_violation_id":"246966291","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3922"},{"id":1225492,"change_date":"2022-07-08 21:40:00","inspection_id":"76015127","insp_violation_id":"246966292","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189666229","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1248120,"change_date":"2022-07-08 21:40:00","inspection_id":"76015127","insp_unit_id":"189666229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"58558MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV4J4S69740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3229868\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3229868\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3229868\/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\/3229868\/inspections","per_page":100,"prev_page_url":null,"to":38,"total":38}