About this Dataset

Tobacco Retail Dealer And Electronic Cigarette Retail Dealer Caps By Community District

This dataset shows the maximum number (cap) of Tobacco Retail Dealer licenses (TRD) and Electronic Cigarette Retail Dealer licenses (ECD) allowed in each Community District, as well as the current number of active Tobacco Retail Dealer and Electronic Cigarette Retail Dealer licenses and, where the number of active licenses is less than the cap, the number of licenses that are available.
Organization: City of New York
Last updated: 2022-06-30T02:01:01.395760
Tags: active, borough, cap, cigarette, community-board, community-district, cutoff-date, electronic-cigarette-retail-dealer, licenses, limit, suspended, tobacco, tobacco-retail-dealer

Tables

Table 1

@usgov.city_of_new_york_tobacco_retail_dealer_and_electronic__0084796c.table_1

14.16 kB
579 rows
10 columns

CREATE TABLE table_1 (
  "borough" VARCHAR,
  "community_district" BIGINT,
  "community_district_name" VARCHAR,
  "tobacco_retail_dealer_cap" BIGINT,
  "active_tobacco_retail_dealer_licenses" BIGINT,
  "trd_available_under_cap" BIGINT,
  "electronic_cigarette_retail_dealer_cap" BIGINT,
  "active_electronic_cigarette_retail_dealer_licenses" BIGINT,
  "ecd_available_under_cap" BIGINT,
  "data_as_of" TIMESTAMP
);