Lottery Applications for Tobacco Retail Dealer (TRD) and Electronic Cigarette Dealer Licenses (ECD)

u42f-se8eBusiness16 columns

The Department of Consumer and Worker Protection (DCWP) conducts a semi-annual review of Tobacco Retail Dealer licenses and Electronic Cigarette Dealer Licenses in each Community District to determine if the number of current licenses has fallen below the Community District cap. DCWP issues a public notice in the City Record stating which Community Districts have available licenses, how many licenses are available, and when it will begin accepting Lottery Application forms. At the close of the Lottery Application Period, DCWP will assign each accepted application a “Priority Number” using a computer-generated random number selection program. If the number of accepted Lottery Application Forms exceeds the number of available Tobacco Retail Dealer licenses for the Community District, DCWP will issue offers to apply for the license in the order of the assigned Priority Numbers.

View on NYC Open Data

Quality

C79.3 / 100

From a 26-row sample across 16 columns.

completeness97/ 25% weight

consistency78/ 20% weight

accuracy95/ 20% weight

timeliness2/ 15% weight

usability100/ 20% weight

· Has geographic keys — joinable to other NYC datasets

Related datasets

Tobacco Retail Dealer and Electronic Cigarette Retail Dealer Caps by Community District0.45
joins onboroughcommunity_district
Office of Labor Policy & Standards Workplace Inquiries (Historical)0.35
joins oncitycommunity_districtstate
Where Are the Unbanked and Underbanked in New York City0.32
joins onborough
Worker Coops0.32
joins onboroughcitystate
Waiting List for General Vendor Licenses0.32

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

record_id	record_type_category	record_type_sub_type	applicant_name	application_submission_date	lottery_application_order	lottery_application_order_1	lottery_priority_number	lottery_selection_date	selected_from_lottery	license_application_number	city
10-2022-ATDL	Lottery Application	Tobacco Retail Dealer	TIFFINY GONZALEZ	2022-05-31T00:00:00.000	9	3	1	2022-06-08T00:00:00.000	Yes	5160-2022-ATRD

Columns

16 queryable · 16 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`record_id`	text	A system generated number used to track the lottery application record through DCWP systems	0%	`23-2022-ATDL25-2022-ATDL14-2022-ATDL`
`record_type_category`	text	The type of record created in the system	0%	`Lottery Application`of 1
`record_type_sub_type`	text	The license category of the lottery application record	0%	`Tobacco Retail Dealer`of 1
`applicant_name`	text	The name of the person or entity that is applying to be included in the lottery	0%	`MMM Party Supplies & Spa…`

Query this from your own app

GET /api/datasets/u42f-se8e
GET /api/datasets/u42f-se8e/quality
GET /api/datasets/u42f-se8e/related
GET /api/columns?dataset=u42f-se8e