Current OCM Licenses

State of New York

@usgov.state_of_new_york_current_ocm_licenses

Table List

1 table(257.6 KB)

Table 1

@usgov.state_of_new_york_current_ocm_licenses.table_1

257.6 KB
2291 rows
44 columns

license_type License Type	license_type_code License Type Code	license_status License Status	license_status_code License Status Code	application_number Application Number	entity_name Entity Name	dba DBA	location_id Location ID	county County	region Region	business_website Business Website	operational_status Operational Status	business_purpose Business Purpose	tier_type Tier Type	cultivation_indoor Cultivation Indoor	cultivation_combination Cultivation Combination	cultivation_activities_drying_curing Cultivation Activities Drying Curing	cultivation_activities_storage Cultivation Activities Storage	cultivation_activities_packaging Cultivation Activities Packaging	cultivation_activities_waste_rendering Cultivation Activities Waste Rendering	primary_contact_name Primary Contact Name
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000013	John J Spencer JR	Snake Island Genetics	34252B19-EA12-442B-8B71-E60597AD74BF	Ontario	Finger Lakes	snakegen.com	Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T1	1		1	1	1	1	John Spencer
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000098	DAVESBUDS LLC		8EA6AA2E-C1AE-465D-8B6A-4F2DFD75E224	Saratoga	Capital District		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T1	1		1	1	1	1	David Ceriotti
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000098	DAVESBUDS LLC	DAVESBUDS	4E0E7507-C443-478F-935E-2DC3ABF183B2	Saratoga	Capital District		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T1	1		1	1	1	1	David Ceriotti
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000144	Hold Ya Head Productions, L.L.C.	Ivory & Tusks	51C1F619-546B-4725-AD18-C86EC93EDA83	Kings	Brooklyn		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T1	1		1	1	1	1	George Wellington
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000287	Jerico Farms LLC	Jerico Farms	17A05BB3-7AF2-4B61-B5F5-0F9C18AFA3AC	Genesee	Finger Lakes		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T1	1		1	1	1	1	Zachary Swapceinski
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000296	Robert L Ellis		F7487F60-E4F9-4609-A144-71C5B5FF8C6E	Chautauqua	Western NY		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T2	1		1	1	1	1	Robert Ellis
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000358	CCKNY, LLC		229357E4-BBF1-48E3-A078-141B3B134DD4	Erie	Western NY		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T2	1		1	1	1	1	Gilbert Milam
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2023-000366	Marco A Quijada		53249016-9219-429F-8B20-19C603CDE2B1	Washington	Capital District		Non-Operational	Adult-Use Cultivation	CULT_INDOOR_T2	1		1	1	1	1	Marco Quijada
Adult-Use Cultivator License	OCMCULT	In-Process	Pending	OCMCULT-2024-000054	Windsor Cider LLC		EB1CAFC9-BF3F-41B2-9098-7D8A1C24DF50	Broome	Southern Tier		Non-Operational	Adult-Use Cultivation	CCULT_COMBINATION_T2		1	1	1	1	1	Goldy Mastey
Adult-Use Distributor License	OCMDIST	In-Process	Pending	OCMDIST-2023-000014	Empire Greens NY LLC		BA8D63D9-8422-4AA8-8687-5376BD9140EC	Chenango	Southern Tier		Non-Operational	Adult-Use Distribution								Jaime Musacchio


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
);