From a 500-row sample across 10 columns.
boroughcommunity_districtboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | community_district | community_district_name | tobacco_retail_dealer_cap | active_tobacco_retail_dealer | trd_available_under_cap | electronic_cigarette_retail | active_electronic_cigarette | ecd_available_under_cap | data_as_of |
|---|---|---|---|---|---|---|---|---|---|
| Bronx | 201 | Bronx 1 | 63 | 42 | 21 | 13 | 12 | 1 | 2026-09-01T00:00:00.000 |
| Bronx | 202 | Bronx 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | Borough where the business is located. | 0% | BrooklynQueensBronxof 5 |
community_district | integer | Community District number where the business is located. | 0% | 304204408 |
community_district_name | text | Descriptive name of the Community District. | 0% | Bronx 1Bronx 10Brooklyn 13 |
tobacco_retail_dealer_cap | integer | Maximum number of Tobacco Retail Dealer (TRD) licenses allowed in the Community District. | 0% | 64 |
GET /api/datasets/p2wf-m8zt GET /api/datasets/p2wf-m8zt/quality GET /api/datasets/p2wf-m8zt/related GET /api/columns?dataset=p2wf-m8zt
borough| 36 |
| 32 |
| 4 |
| 5 |
| 5 |
| 0 |
| 2026-09-01T00:00:00.000 |
| Bronx | 203 | Bronx 3 | 45 | 34 | 11 | 8 | 6 | 2 | 2026-09-01T00:00:00.000 |
| Bronx | 204 | Bronx 4 | 88 | 80 | 8 | 9 | 8 | 1 | 2026-09-01T00:00:00.000 |
| Bronx | 205 | Bronx 5 | 68 | 57 | 11 | 14 | 12 | 2 | 2026-09-01T00:00:00.000 |
| Bronx | 206 | Bronx 6 | 58 | 53 | 5 | 7 | 7 | 0 | 2026-09-01T00:00:00.000 |
| Bronx | 207 | Bronx 7 | 63 | 62 | 1 | 18 | 13 | 5 | 2026-09-01T00:00:00.000 |
| Bronx | 208 | Bronx 8 | 36 | 32 | 4 | 12 | 10 | 2 | 2026-09-01T00:00:00.000 |
| Bronx | 209 | Bronx 9 | 78 | 63 | 15 | 15 | 13 | 2 | 2026-09-01T00:00:00.000 |
| Bronx | 210 | Bronx 10 | 52 | 51 | 1 | 30 | 32 | 0 | 2026-09-01T00:00:00.000 |
6268active_tobacco_retail_dealer | integer | Number of active Tobacco Retail Dealer licenses, Suspended Tobacco Retail Dealer licenses, and pending Tobacco Retail Dealer applications. | 0% | 548761 |
trd_available_under_cap | integer | Number of new Tobacco Retail Dealer licenses that can be issued in the Community District | 0% | 054 |
electronic_cigarette_retail | integer | Maximum number of Electronic Cigarette Retail Dealer licenses (ECD) assigned to the Community District. | 0% | 211915 |
active_electronic_cigarette | integer | Number of active Electronic Cigarette Retail Dealer licenses, Suspended Electronic Cigarette Retail Dealer licenses, and pending Electronic Cigarette Retail Dealer applications. | 0% | 221913 |
ecd_available_under_cap | categorical | Number of new ECD licenses that can be issued in the Community District | 0% | 021of 9 |
data_as_of | datetime | — | 0% | 2026-03-15T00:00:00.0002020-04-24T00:00:00.0002024-09-15T00:00:00.000of 13 |