Name: Current OCM Licenses
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Current OCM Licenses

Dataset of all licensees as well as applicants who have obtained proximity protection for their proposed adult-use retail and medical dispensaries.
Organization: State of New York
Last updated: 2024-07-12T14:32:23.690804
Tags: cannabis, licenses, ocm, office-of-cannabis-management

Tables

Table 1

@usgov.state_of_new_york_current_ocm_licenses.table_1

263.79 kB
2,291 rows
44 columns

CREATE TABLE table_1 (
  "license_number" VARCHAR,
  "license_type" VARCHAR,
  "license_type_code" VARCHAR,
  "license_status" VARCHAR,
  "license_status_code" VARCHAR,
  "issued_date" VARCHAR,
  "effective_date" VARCHAR,
  "expiration_date" VARCHAR,
  "application_number" VARCHAR,
  "see_category" VARCHAR,
  "entity_name" VARCHAR,
  "dba" VARCHAR,
  "location_id" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "county" VARCHAR,
  "region" VARCHAR,
  "business_website" VARCHAR,
  "operational_status" VARCHAR,
  "business_purpose" VARCHAR,
  "tier_type" VARCHAR,
  "processor_type" VARCHAR,
  "cultivation_indoor" DOUBLE,
  "cultivation_outdoor" DOUBLE,
  "cultivation_mixed_light" DOUBLE,
  "cultivation_combination" DOUBLE,
  "cultivation_activities_drying_curing" DOUBLE,
  "cultivation_activities_storage" DOUBLE,
  "cultivation_activities_packaging" DOUBLE,
  "cultivation_activities_waste_rendering" DOUBLE,
  "processing_activities_extraction" DOUBLE,
  "processing_activities_blending_and_infusing" DOUBLE,
  "processing_activities_packaging_and_labeling" DOUBLE,
  "processing_activities_branding" DOUBLE,
  "retail_activities_sales_with_delivery" DOUBLE,
  "retail_activities_sales_no_delivery" DOUBLE,
  "retail_activities_non_cannabis_products" DOUBLE,
  "retail_activities_drive_thru" DOUBLE,
  "retail_date_opened_to_public" VARCHAR,
  "hours_of_operation" VARCHAR,
  "primary_contact_name" VARCHAR
);