{"current_page":1,"data":[{"id":11893173,"change_date":"2026-05-13 21:41:00","inspection_id":"87831453","dot_number":"1390965","report_state":"NY","report_number":"D507802383","insp_date":"2026-05-07 00:00:00","insp_start_time":"0829","insp_end_time":"0907","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GENEVA NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3311075","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:48.000000Z","updated_at":"2026-05-24T09:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20677907,"change_date":"2026-05-13 21:41:00","inspection_id":"87831453","insp_unit_id":"213518994","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"23","insp_unit_license":"54298NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDNF6AN9SDF04779","insp_unit_decal":"Y","insp_unit_decal_number":"36369702","created_at":"2026-05-15T12:13:26.000000Z","updated_at":"2026-05-24T09:03:44.000000Z"}]},{"id":11144391,"change_date":"2026-02-17 21:38:00","inspection_id":"87058676","dot_number":"1390965","report_state":"NY","report_number":"5L49000138","insp_date":"2026-02-10 00:00:00","insp_start_time":"1203","insp_end_time":"1216","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2894611","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2026-02-17 21:38:00","snet_input_date":"2026-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-17 21:38:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:40.000000Z","updated_at":"2026-02-28T10:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19011868,"change_date":"2026-02-17 21:38:00","inspection_id":"87058676","insp_unit_id":"211650843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"V10","insp_unit_license":"57313ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3GSCGXG1292472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:24.000000Z","updated_at":"2026-02-28T10:02:46.000000Z"}]},{"id":10776827,"change_date":"2026-01-15 21:41:00","inspection_id":"86802332","dot_number":"1390965","report_state":"NY","report_number":"5L49000134","insp_date":"2026-01-14 00:00:00","insp_start_time":"1257","insp_end_time":"1330","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2770638","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:05.000000Z","updated_at":"2026-01-26T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18092878,"change_date":"2026-01-15 21:41:00","inspection_id":"86802332","insp_unit_id":"211106796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"68","insp_unit_license":"62919ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMAAN2DL239110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:53.000000Z","updated_at":"2026-01-26T10:00:48.000000Z"}]},{"id":10776918,"change_date":"2026-01-15 21:41:00","inspection_id":"86802426","dot_number":"1390965","report_state":"NY","report_number":"D507802075","insp_date":"2026-01-13 00:00:00","insp_start_time":"1358","insp_end_time":"1419","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"STANLEY NY","county_code_state":"NY","county_code":"069","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-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"2770713","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:05.000000Z","updated_at":"2026-01-26T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18093012,"change_date":"2026-01-15 21:41:00","inspection_id":"86802426","insp_unit_id":"211106952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"8","insp_unit_license":"99040MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XP3AJ7X6GM346715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:54.000000Z","updated_at":"2026-01-26T10:00:48.000000Z"},{"id":18093013,"change_date":"2026-01-15 21:41:00","inspection_id":"86802426","insp_unit_id":"211106953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"4086D1","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9625AT555496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:54.000000Z","updated_at":"2026-01-26T10:00:48.000000Z"}]},{"id":10275549,"change_date":"2025-11-24 21:38:00","inspection_id":"86400008","dot_number":"1390965","report_state":"NY","report_number":"D507802004","insp_date":"2025-11-21 00:00:00","insp_start_time":"0826","insp_end_time":"0901","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"STANLEY NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2581357","transaction_code":"A","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-11-24 21:38:00","snet_input_date":"2025-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-24 21:38:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:33.000000Z","updated_at":"2025-11-28T10:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17149658,"change_date":"2025-11-24 21:38:00","inspection_id":"86400008","insp_unit_id":"210226506","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"87836NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB5SS077015","insp_unit_decal":"Y","insp_unit_decal_number":"35749822","created_at":"2025-11-27T10:00:31.000000Z","updated_at":"2025-11-28T10:00:29.000000Z"}]},{"id":10258297,"change_date":"2025-11-21 21:38:00","inspection_id":"86381886","dot_number":"1390965","report_state":"NY","report_number":"5L49000101","insp_date":"2025-11-20 00:00:00","insp_start_time":"1307","insp_end_time":"1323","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2569946","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:40.000000Z","updated_at":"2025-11-25T10:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17101736,"change_date":"2025-11-21 21:38:00","inspection_id":"86381886","insp_unit_id":"210167348","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"23","insp_unit_license":"54298NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDNF6AN9SDF04779","insp_unit_decal":"Y","insp_unit_decal_number":"35749785","created_at":"2025-11-24T10:01:54.000000Z","updated_at":"2025-11-25T10:00:31.000000Z"}]},{"id":10194474,"change_date":"2025-11-14 21:39:00","inspection_id":"86314940","dot_number":"1390965","report_state":"NY","report_number":"SPE3090863","insp_date":"2025-11-07 00:00:00","insp_start_time":"1244","insp_end_time":"1301","registration_date":null,"region":"ES","ci_status_code":"C","location":"60533N","location_desc":"HIMROD NY","county_code_state":"NY","county_code":"123","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2537664","transaction_code":"A","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-11-14 21:39:00","snet_input_date":"2025-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-14 21:39:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:12.000000Z","updated_at":"2025-11-18T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16981099,"change_date":"2025-11-14 21:39:00","inspection_id":"86314940","insp_unit_id":"210015830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"63","insp_unit_license":"55296MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAANXCH616285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:12.000000Z","updated_at":"2025-11-18T10:00:13.000000Z"}]},{"id":10012865,"change_date":"2025-11-05 21:40:00","inspection_id":"86123643","dot_number":"1390965","report_state":"NY","report_number":"5L45000781","insp_date":"2025-10-22 00:00:00","insp_start_time":"1420","insp_end_time":"1441","registration_date":"2025-11-04 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"GENEVA NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MULTIPLE BILLS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2449456","transaction_code":"C","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-10-23 21:38:00","snet_input_date":"2025-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-23 21:38:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:36.000000Z","updated_at":"2025-11-09T10:30:11.000000Z","inspection_violations":[{"id":16783378,"change_date":"2025-11-05 21:40:00","inspection_id":"86123643","insp_violation_id":"269738028","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209848164","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-08T10:32:23.000000Z","updated_at":"2025-11-09T10:30:20.000000Z","normalized_code":"39395A1"},{"id":16783379,"change_date":"2025-11-05 21:40:00","inspection_id":"86123643","insp_violation_id":"269738029","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209848164","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-08T10:32:23.000000Z","updated_at":"2025-11-09T10:30:20.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":16843521,"change_date":"2025-11-05 21:40:00","inspection_id":"86123643","insp_unit_id":"209848164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"V14","insp_unit_license":"78449NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3F67KDC46639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:03.000000Z","updated_at":"2025-11-09T10:00:13.000000Z"}]},{"id":9478192,"change_date":"2025-08-22 21:38:00","inspection_id":"85561752","dot_number":"1390965","report_state":"NY","report_number":"SPE3070952","insp_date":"2025-08-15 00:00:00","insp_start_time":"1043","insp_end_time":"1059","registration_date":null,"region":"ED","ci_status_code":"C","location":"60533N","location_desc":"HIMROD NY","county_code_state":"NY","county_code":"123","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSI","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":"2025-08-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2163388","transaction_code":"A","transaction_date":"2025-08-21 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-08-22 21:38:00","snet_input_date":"2025-08-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-22 21:38:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-25T10:43:11.000000Z","updated_at":"2025-08-26T10:45:21.000000Z","inspection_violations":[{"id":15448269,"change_date":"2025-08-22 21:38:00","inspection_id":"85561752","insp_violation_id":"268183516","seq_no":"1","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"208526436","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:40.000000Z","normalized_code":"177834AHMC"}],"inspection_per_units":[{"id":15634813,"change_date":"2025-08-22 21:38:00","inspection_id":"85561752","insp_unit_id":"208526436","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"63","insp_unit_license":"55296MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAANXCH616285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:30.000000Z","updated_at":"2025-08-26T09:45:25.000000Z"}]},{"id":9421417,"change_date":"2025-10-30 21:41:00","inspection_id":"85501972","dot_number":"1390965","report_state":"NY","report_number":"5L49000061","insp_date":"2025-08-14 00:00:00","insp_start_time":"1458","insp_end_time":"1524","registration_date":"2025-10-29 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"STANLEY NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2133953","transaction_code":"C","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-08-15 21:38:00","snet_input_date":"2025-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-15 21:38:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:33.000000Z","updated_at":"2025-11-03T11:00:04.000000Z","inspection_violations":[{"id":16680212,"change_date":"2025-10-30 21:41:00","inspection_id":"85501972","insp_violation_id":"269606943","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:07.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":16742305,"change_date":"2025-10-30 21:41:00","inspection_id":"85501972","insp_unit_id":"209730160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"24","insp_unit_license":"87837NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB3SS077014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":9174201,"change_date":"2025-09-04 21:40:00","inspection_id":"85241961","dot_number":"1390965","report_state":"NY","report_number":"5L49000045","insp_date":"2025-07-17 00:00:00","insp_start_time":"1122","insp_end_time":"1142","registration_date":"2025-07-23 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2005585","transaction_code":"C","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:09.000000Z","updated_at":"2025-09-10T10:45:15.000000Z","inspection_violations":[{"id":15663270,"change_date":"2025-09-04 21:40:00","inspection_id":"85241961","insp_violation_id":"268447515","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208737722","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:22.000000Z","normalized_code":"39395A1"},{"id":15663271,"change_date":"2025-09-04 21:40:00","inspection_id":"85241961","insp_violation_id":"268447516","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208737722","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:22.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":15827725,"change_date":"2025-09-04 21:40:00","inspection_id":"85241961","insp_unit_id":"208737722","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"23","insp_unit_license":"54298NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDNF6AN9SDF04779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:04.000000Z"}]},{"id":7554394,"change_date":"2025-01-06 21:39:00","inspection_id":"83535857","dot_number":"1390965","report_state":"NY","report_number":"5L49000005","insp_date":"2025-01-06 00:00:00","insp_start_time":"1313","insp_end_time":"1320","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220866","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[{"id":11808274,"change_date":"2025-01-06 21:39:00","inspection_id":"83535857","insp_violation_id":"263768807","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204663380","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":12188992,"change_date":"2025-01-06 21:39:00","inspection_id":"83535857","insp_unit_id":"204663380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"67","insp_unit_license":"10718ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN8DH196141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":6663511,"change_date":"2024-09-06 21:40:00","inspection_id":"82592774","dot_number":"1390965","report_state":"NY","report_number":"D507800798","insp_date":"2024-09-05 00:00:00","insp_start_time":"1400","insp_end_time":"1423","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","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":"2024-09-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"819137","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2024-09-06 21:40:00","snet_input_date":"2024-09-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-06 21:40:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:12.000000Z","updated_at":"2025-03-17T20:35:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10743558,"change_date":"2024-09-06 21:40:00","inspection_id":"82592774","insp_unit_id":"202792706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"8","insp_unit_license":"99040MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XP3AJ7X6GM346715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:14.000000Z","updated_at":"2025-03-17T23:34:14.000000Z"},{"id":10743559,"change_date":"2024-09-06 21:40:00","inspection_id":"82592774","insp_unit_id":"202792707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"8","insp_unit_license":"3582D5","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9625AT555496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:14.000000Z","updated_at":"2025-03-17T23:34:14.000000Z"}]},{"id":5627939,"change_date":"2024-04-30 21:41:00","inspection_id":"81478513","dot_number":"1390965","report_state":"NY","report_number":"5L45000585","insp_date":"2024-04-29 00:00:00","insp_start_time":"1407","insp_end_time":"1447","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GENEVA NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MULTIPLE BILLS","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-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"439316","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:17.000000Z","updated_at":"2025-03-17T20:14:17.000000Z","inspection_violations":[{"id":8701594,"change_date":"2024-04-30 21:41:00","inspection_id":"81478513","insp_violation_id":"259212725","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","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-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"38323A2"},{"id":8701595,"change_date":"2024-04-30 21:41:00","inspection_id":"81478513","insp_violation_id":"259212726","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200639780","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9065432,"change_date":"2024-04-30 21:41:00","inspection_id":"81478513","insp_unit_id":"200639780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"66","insp_unit_license":"44911MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN8DH419276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:22.000000Z","updated_at":"2025-03-17T23:17:22.000000Z"}]},{"id":5531844,"change_date":"2024-04-17 21:41:00","inspection_id":"81373815","dot_number":"1390965","report_state":"NY","report_number":"SPE0274404","insp_date":"2024-04-15 00:00:00","insp_start_time":"1335","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"40321","location_desc":"GENEVA","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","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-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2917858","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":"M","census_search_date":"2024-04-17 21:41:00","snet_input_date":"2024-04-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-17 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:21.000000Z","updated_at":"2025-03-17T20:12:21.000000Z","inspection_violations":[{"id":8547173,"change_date":"2024-04-17 21:41:00","inspection_id":"81373815","insp_violation_id":"258979615","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200440352","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:25.000000Z","updated_at":"2025-03-17T21:47:25.000000Z","normalized_code":"39311"},{"id":8547174,"change_date":"2024-04-17 21:41:00","inspection_id":"81373815","insp_violation_id":"258979616","seq_no":"2","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"200440353","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:25.000000Z","updated_at":"2025-03-17T21:47:25.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8910589,"change_date":"2024-04-17 21:41:00","inspection_id":"81373815","insp_unit_id":"200440352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8","insp_unit_license":"99040MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XP3AJ7X6GM346715","insp_unit_decal":"Y","insp_unit_decal_number":"34017682","created_at":"2025-03-17T23:15:56.000000Z","updated_at":"2025-03-17T23:15:56.000000Z"},{"id":8910590,"change_date":"2024-04-17 21:41:00","inspection_id":"81373815","insp_unit_id":"200440353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"0","insp_unit_license":"3582D5","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9625AT555496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:56.000000Z","updated_at":"2025-03-17T23:15:56.000000Z"}]},{"id":4880446,"change_date":"2024-01-23 21:44:00","inspection_id":"80662416","dot_number":"1390965","report_state":"NY","report_number":"5L45000023","insp_date":"2024-01-23 00:00:00","insp_start_time":"0932","insp_end_time":"0956","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MULTIPLE BILLS","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-01-23 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"189797","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":"01390965","upload_search_indicator":null,"census_search_date":"2024-01-23 21:44:00","snet_input_date":"2024-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-23 21:44:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","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":7852646,"change_date":"2024-01-23 21:44:00","inspection_id":"80662416","insp_unit_id":"199061648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"V12","insp_unit_license":"33197MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FL1DDA42055","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T23:06:11.000000Z","updated_at":"2025-03-17T23:06:11.000000Z"}]},{"id":4647922,"change_date":"2023-12-18 21:41:00","inspection_id":"80408413","dot_number":"1390965","report_state":"NY","report_number":"D507900213","insp_date":"2023-12-14 00:00:00","insp_start_time":"1327","insp_end_time":"1346","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GENEVA NY","county_code_state":"NY","county_code":"069","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":"2023-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134759","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[{"id":7185471,"change_date":"2023-12-18 21:41:00","inspection_id":"80408413","insp_violation_id":"256926174","seq_no":"1","part_no":"382","part_no_section":"501A-SSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"382501ASSF"}],"inspection_per_units":[{"id":7475321,"change_date":"2023-12-18 21:41:00","inspection_id":"80408413","insp_unit_id":"198542706","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"55296MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAANXCH616285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:51.000000Z","updated_at":"2025-03-17T23:02:51.000000Z"}]},{"id":4616748,"change_date":"2023-12-13 21:41:00","inspection_id":"80374257","dot_number":"1390965","report_state":"NY","report_number":"5L45000012","insp_date":"2023-12-12 00:00:00","insp_start_time":"1303","insp_end_time":"1337","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PHELPS NY","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MULTIPLE BILLS","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"129691","transaction_code":"A","transaction_date":"2023-12-13 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2023-12-13 21:41:00","snet_input_date":"2023-12-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-13 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:13.000000Z","updated_at":"2025-03-17T19:54:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7425833,"change_date":"2023-12-13 21:41:00","inspection_id":"80374257","insp_unit_id":"198478276","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"68","insp_unit_license":"62919ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMAAN2DL239110","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T23:02:26.000000Z","updated_at":"2025-03-17T23:02:26.000000Z"}]},{"id":4513877,"change_date":"2023-11-29 21:41:00","inspection_id":"80261029","dot_number":"1390965","report_state":"NY","report_number":"D507000069","insp_date":"2023-11-28 00:00:00","insp_start_time":"1331","insp_end_time":"1357","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"STANLEY NY","county_code_state":"NY","county_code":"069","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":"2023-11-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32900","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":"110622","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2023-11-29 21:41:00","snet_input_date":"2023-11-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-29 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:13.000000Z","updated_at":"2025-03-17T19:52:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7259669,"change_date":"2023-11-29 21:41:00","inspection_id":"80261029","insp_unit_id":"198254687","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50","insp_unit_license":"53996JS","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN05H698241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:57.000000Z","updated_at":"2025-03-17T23:00:57.000000Z"}]},{"id":4010481,"change_date":"2023-09-20 21:39:00","inspection_id":"79704310","dot_number":"1390965","report_state":"NY","report_number":"0510024826","insp_date":"2023-09-19 00:00:00","insp_start_time":"1257","insp_end_time":"1327","registration_date":null,"region":"ET","ci_status_code":"C","location":"41387","location_desc":"PHELPS","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2870402","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":"M","census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:02.000000Z","updated_at":"2025-03-17T19:42:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6448565,"change_date":"2023-09-20 21:39:00","inspection_id":"79704310","insp_unit_id":"197138198","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"68","insp_unit_license":"62919ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMAAN2DL239110","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:54:08.000000Z","updated_at":"2025-03-17T22:54:08.000000Z"}]},{"id":3885822,"change_date":"2023-09-01 21:39:00","inspection_id":"79565772","dot_number":"1390965","report_state":"NY","report_number":"0510024762","insp_date":"2023-08-31 00:00:00","insp_start_time":"1205","insp_end_time":"1231","registration_date":null,"region":"ET","ci_status_code":"C","location":"40321","location_desc":"GENEVA","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"GENEVA CLUB VENDING COMPANY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2864347","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:42.000000Z","updated_at":"2025-03-17T19:39:42.000000Z","inspection_violations":[{"id":6005776,"change_date":"2023-09-01 21:39:00","inspection_id":"79565772","insp_violation_id":"255038473","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39141A1"},{"id":6005777,"change_date":"2023-09-01 21:39:00","inspection_id":"79565772","insp_violation_id":"255038474","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196858224","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6247259,"change_date":"2023-09-01 21:39:00","inspection_id":"79565772","insp_unit_id":"196858224","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"V11","insp_unit_license":"93182ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3G4CG4F1116463","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"}]},{"id":3840414,"change_date":"2023-08-28 21:41:00","inspection_id":"79515176","dot_number":"1390965","report_state":"NY","report_number":"0519001214","insp_date":"2023-08-25 00:00:00","insp_start_time":"0928","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"40764R","location_desc":"SENECA","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2863341","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":null,"census_search_date":"2023-08-28 21:41:00","snet_input_date":"2023-08-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-28 21:41:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:53.000000Z","updated_at":"2025-03-17T19:38:53.000000Z","inspection_violations":[{"id":5932311,"change_date":"2023-08-28 21:41:00","inspection_id":"79515176","insp_violation_id":"254909339","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"1","insp_unit_id":"196748912","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39375A2"},{"id":5932312,"change_date":"2023-08-28 21:41:00","inspection_id":"79515176","insp_violation_id":"254909340","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196748912","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"3963A1"},{"id":5932313,"change_date":"2023-08-28 21:41:00","inspection_id":"79515176","insp_violation_id":"254909341","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"196748912","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":6174413,"change_date":"2023-08-28 21:41:00","inspection_id":"79515176","insp_unit_id":"196748912","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"60","insp_unit_license":"32876MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN89H134083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:51.000000Z","updated_at":"2025-03-17T22:51:51.000000Z"}]},{"id":3605641,"change_date":"2023-07-27 21:40:00","inspection_id":"79252567","dot_number":"1390965","report_state":"NY","report_number":"0510024621","insp_date":"2023-07-25 00:00:00","insp_start_time":"1439","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"40764","location_desc":"SENECA HIGHWAY DEPT","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2851940","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01390965","upload_search_indicator":"M","census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"GENEVA CLUB BEVERAGE CO INC","insp_carrier_street":"1 PEPSI LANE","insp_carrier_city":"GENEVA","insp_carrier_state":"NY","insp_carrier_zip_code":"14456","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5797208,"change_date":"2023-07-27 21:40:00","inspection_id":"79252567","insp_unit_id":"196219412","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"67","insp_unit_license":"10718ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN8DH196141","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1390965\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1390965\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1390965\/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\/1390965\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}