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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/tobacco-retail-dealer-and-electronic-cigarette-p2wf-m8zt\".\"tobacco_retail_dealer_and_electronic_cigarette\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.