From a 84-row sample across 18 columns.
boroughstatelatitude+5community_boardcouncil_districtborough+6latitudentacensus_tract+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| location | name | license | business_address | city_or_town | state | zip_code | phone_no | borough | latitude | longitude | community_board |
|---|---|---|---|---|---|---|---|---|---|---|---|
| NEW YORK CITY | 1705 SUNSHINE WHOLESALE INC | OTP-10124 | 7804 20TH AVE | BROOKLYN | NEW YORK | 11214 | 7182326968 | BROOKLYN | 40.609026 | -73.993668 | 311 |
| NEW YORK CITY |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
location | categorical | — | 0% | NEW YORK CITYOUT OF STATEUPSTATE NEW YORK AND LON…of 3 |
name | text | Business Name | 0% | MCLANE EASTERN INCSUPER FOOD SERVICES, INC…IDN DISTRIBUTORS INC |
license | text | License No. Prefix ; OTP = Other tobacco products | 0% | OTP-10170OTP-10209OTP-10102 |
business_address | text | Address of licesnsed business | 0% | 10409 53RD AVE |
GET /api/datasets/f264-qcv3 GET /api/datasets/f264-qcv3/quality GET /api/datasets/f264-qcv3/related GET /api/columns?dataset=f264-qcv3
community_boardboroughcommunity_boardcouncil_districtborough+6| 53RD QUEENS BEER INC |
| OTP-10125 |
| 10409 53RD AVE |
| CORONA |
| NEW YORK |
| 11368 |
| 9172171517 |
| QUEENS |
| 40.741715 |
| -73.856546 |
| 404 |
| NEW YORK CITY | A & G WHOLESALE CANDY/PAPERBAG, INC. | OTP-10127 | 511 WHITTIER ST | BRONX | NEW YORK | 10474 | 7186818918 | BRONX | 40.810989 | -73.882689 | 202 |
| NEW YORK CITY | AFICION INC | OTP-10192 | 965 RICHMOND AVE | STATEN ISLAND | NEW YORK | 10314 | 7187611234 | STATEN IS | 40.623068 | -74.149304 | 501 |
| NEW YORK CITY | AIR KING TRADING, INC. | OTP-10129 | 415 DEVOE AVE | BRONX | NEW YORK | 10460 | 7188246400 | BRONX | 40.84058 | -73.877031 | 206 |
| NEW YORK CITY | AL'S CIGARS INC | OTP-10101 | 3872 RICHMOND AVE | STATEN ISLAND | NEW YORK | 10312 | 7183512233 | STATEN IS | 40.54359 | -74.164566 | 503 |
| NEW YORK CITY | AMADIZ CIGARS INC | OTP-10121 | 470 CITY ISLAND AVE | BRONX | NEW YORK | 10464 | 7188851363 | BRONX | 40.851351 | -73.788589 | 210 |
| NEW YORK CITY | AMERICAN TOBACCO CORP | OTP-10126 | 272 WAKEMAN PL | BROOKLYN | NEW YORK | 11220 | 9172549574 | BROOKLYN | 40.638445 | -74.025308 | 310 |
| NEW YORK CITY | ANR CIGAR INC | OTP-10102 | 9212 3RD AVE | BROOKLYN | NEW YORK | 11209 | 7182382224 | BROOKLYN | 40.618983 | -74.032901 | 310 |
| NEW YORK CITY | AROMA DOMINICAN CIGARS LLC | OTP-10231 | 1738 VICTORY BLVD | STATEN ISLAND | NEW YORK | 10314 | 7184471508 | STATEN IS | 40.613131 | -74.121747 | 501 |
Showing 12 of 18 columns. All of them are listed below.
5009 BROADWAY1500 SOLANA BLVDcity_or_town | text | — | 0% | NEW YORKBROOKLYNBRONX |
state | categorical | — | 0% | NEW YORKPENNSYLVANIAFLORIDAof 12 |
zip_code | text | — | 0% | 113851003411214 |
phone_no | text | — | 0% | 254742342271835122337278285425 |
borough | categorical | — | 29% | MANHATTANQUEENSBROOKLYNof 5 |
latitude | float | — | 29% | 40.69527740.5435940.617567 |
longitude | float | — | 29% | -73.882689-74.001894-73.86906 |
community_board | text | — | 29% | 311105405 |
council_district | text | — | 29% | 431 |
bin | text | — | 29% | 103452033440612006856 |
bbl | text | — | 29% | 306258000110128900212040030032 |
census_tract | text | — | 29% | 7075299 |
nta | text | — | 29% | BK1101BK1001MN0502 |
effective_date | datetime | Date the data was produced | 0% | 2026-08-28T00:00:00.000of 1 |