Alcohol Products

**Overview** This data package contains all the information about alcoholic beverages, their local options either wet or dry, sales and permits issued by the State Liquor Authority across New York State. **Description** The State Liquor Authority (SLA) regulates the manufacture and sale of alcoholic beverages. The SLA maintains offices in New York City, Albany (which serves as the agency headquarters), and Buffalo. Towns can determine whether they want to be wet, dry or partially dry through local option elections. This dataset contains a complete list of all the relevant details regarding local options. The New York State Alcohol Beverage Control Law (ABCL) specifies that no manufacturer or wholesaler shall sell to any retailer nor shall any retailer purchase any alcoholic beverages unless these beverages are labeled in accordance with the Authority's Rules and Federal Regulations and unless such label shall be registered with and approved by the State Liquor Authority. The SLA’s Licensing Bureau is responsible for the statewide processing of licenses, license renewals, permits and brand label registrations. All must be consistent with the Alcoholic Beverage Control Law. Base information corresponds to that provided, by applicants, on various permit applications. Processing time is contingent upon review within the Licensing Bureau. A list of active permits is also available in this data package. **Benefits** - complete list of active permits available - complete list of local options - brand label and whole sale information beneficial for the buyers and sellers **License Information** The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes. **Included Datasets** - [Alcoholic Beverage Wet And Dry Local Options](https://www.johnsnowlabs.com/marketplace/alcoholic-beverage-wet-and-dry-local-options) - This dataset contains information on in-force local options regarding sales of alcoholic beverages for municipalities across New York state beginning in 1948. - [Brand Label and Wholesale Information for Registered Alcohol Products](https://www.johnsnowlabs.com/marketplace/brand-label-and-wholesale-information-for-registered-alcohol-products) - This dataset contains information on brand label and wholesale information for alcohol products registered in New York State. - [List of Active Permits Issued by Liquor Authority](https://www.johnsnowlabs.com/marketplace/list-of-active-permits-issued-by-liquor-authority) - This dataset contains a list of all active permits issued by the State Liquor Authority (SLA). Permits in this dataset are issued for 1-3 year terms. The State Liquor Authority (SLA) regulates the manufacture and sale of alcoholic beverages. **Data Engineering Overview** **We deliver high-quality data** - Each dataset goes through 3 levels of quality review - 2 Manual reviews are done by domain experts - Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints - Data is normalized into one unified type system - All dates, unites, codes, currencies look the same - All null values are normalized to the same value - All dataset and field names are SQL and Hive compliant - Data and Metadata - Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters - Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated - Data Updates - Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted **Our data is curated and enriched by domain experts** Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts: - Field names, descriptions, and normalized values are chosen by people who actually understand their meaning - Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset - Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations - The data is always kept up to date – even when the source requires manual effort to get updates - Support for data subscribers is provided directly by the domain experts who curated the data sets - Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution. **Need Help?** If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).**概览** 本数据包涵盖纽约州范围内酒类饮品及其本地干湿可选政策、酒类销售信息，以及纽约州酒类管理局（State Liquor Authority，SLA）在全州范围内核发的各类许可文件的完整信息。 **详细说明** 纽约州酒类管理局（State Liquor Authority，SLA）负责监管酒类饮品的生产与销售。该局在纽约市、奥尔巴尼（作为机构总部所在地）以及布法罗均设有办事处。各城镇可通过地方公投决议自身为禁酒区、不禁酒区或部分禁酒区。本数据集包含所有与本地可选政策相关的完整细节信息。 根据《纽约州酒类饮品管控法》（Alcohol Beverage Control Law，ABCL）规定，任何生产商或批发商均不得向零售商售卖酒类饮品，任何零售商亦不得购进酒类饮品，除非相关饮品已按照该局规则及联邦法规完成标签标注，且该标签已在纽约州酒类管理局完成注册并获批准。SLA许可局负责全州范围内的许可证核发、续期、许可办理以及品牌标签注册工作，所有流程均需符合《酒类饮品管控法》的要求。基础信息源自申请人在各类许可申请中提交的内容，办理时长取决于许可局内部的审核进度。本数据包同时提供有效许可文件清单。 **优势** - 提供有效许可文件的完整清单 - 涵盖本地可选政策的完整列表 - 品牌标签与批发信息可助力酒类购销双方开展业务 **许可使用说明** 约翰·斯诺实验室（John Snow Labs）数据集可免费用于个人研究与学术研究用途。如需商业使用，请前往约翰·斯诺实验室官网订阅[数据库](https://www.johnsnowlabs.com/marketplace/)，订阅后可商业使用约翰·斯诺实验室旗下所有数据集与数据包。 **包含数据集** - [纽约州酒类饮品干湿本地可选政策数据集](https://www.johnsnowlabs.com/marketplace/alcoholic-beverage-wet-and-dry-local-options) - 该数据集包含1948年起纽约州各市政辖区内生效的酒类饮品销售本地可选政策相关信息。 - [注册酒类产品品牌标签与批发信息数据集](https://www.johnsnowlabs.com/marketplace/brand-label-and-wholesale-information-for-registered-alcohol-products) - 该数据集涵盖纽约州境内注册酒类产品的品牌标签与批发相关信息。 - [纽约州酒类管理局核发有效许可清单数据集](https://www.johnsnowlabs.com/marketplace/list-of-active-permits-issued-by-liquor-authority) - 该数据集包含纽约州酒类管理局（SLA）核发的所有有效许可文件清单。本数据集内的许可有效期为1至3年。纽约州酒类管理局（SLA）负责监管酒类饮品的生产与销售。 **数据工程概览** **我们提供高品质数据** - 每份数据集均经过三级质量审核 - 由领域专家完成2次人工审核 - 随后通过60余项自动化验证流程，确保所有数据项均符合元数据与既定约束规则 - 数据已归一化为统一类型系统 - 所有日期、单位、编码、货币格式均保持统一 - 所有空值均归一化为统一标准值 - 所有数据集与字段名称均符合SQL与Hive语法规范 - 数据与元数据 - 数据支持CSV与Apache Parquet两种格式，可在分布式Hadoop、Spark及MPP集群上实现高性能读取 - 元数据采用开放的Frictionless Data标准格式，所有字段均经过归一化与验证 - 数据更新 - 数据更新采用替换更新模式：过时外键将被标记为弃用，而非直接删除 **我们的数据集由领域专家整理与富集** 每份数据集均由我们的医师、药剂师、公共卫生与医疗计费专家团队手动审核整理： - 字段名称、描述与归一化值均由真正理解其含义的专业人员选定 - 医疗健康与生命科学领域专家可为每份数据集添加分类、搜索关键词、描述等额外信息 - 针对临床编码、服务提供商、药品及地理定位信息，同时支持人工与自动化富集流程 - 即便数据源需要人工获取更新，我们也会确保数据始终保持最新状态 - 数据集的订阅支持可直接由负责整理该数据集的领域专家提供 - 所有数据源的许可均经过人工审核，确保可用于免版税的商业使用与再分发。 **需要帮助？** 如有产品相关疑问，请发送邮件至[[e-mail]](mailto:[e-mail])。

搜集汇总

背景与挑战

背景概述

该数据集汇总了纽约州酒类管理局（SLA）监管的酒精饮料相关信息，包括本地销售选项（湿/干地区）、有效许可清单以及品牌标签与批发数据。它适用于个人和研究用途，商业使用需通过订阅获取。