From a 37-row sample across 18 columns.
borougheffective_datebbl+14boroughboroughstatezip_codeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| location | name | license_no | business_address | borough | city_or_town | state | community_board | zip_code | phone_no | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| NEW YORK CITY | 1705 SUNSHINE WHOLESALE INC | SJ-03370 | 7804 20TH AVE | BROOKLYN | BROOKLYN | NEW YORK | 311 | 11214 | 7182326968 | 40.609026 | -73.993668 |
| 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…GLOBE WHOLESALE TOBACCO … |
license_no | text | License Number of Wholesale Cigarette Dealer | 0% | SJ-02897AJ-03337SJ-02826 |
business_address | text | Business Address of Wholesale Cigarette Dealer | 0% | 840 SAINT ANNS AVE |
GET /api/datasets/98b7-th5j GET /api/datasets/98b7-th5j/quality GET /api/datasets/98b7-th5j/related GET /api/columns?dataset=98b7-th5j
boroughbblcouncil_districtbblcouncil_districtnta+5statezip_codebblntabin| 53RD QUEENS BEER INC |
| SJ-03417 |
| 10409 53RD AVE |
| QUEENS |
| CORONA |
| NEW YORK |
| 404 |
| 11368 |
| 9172171517 |
| 40.741715 |
| -73.856546 |
| NEW YORK CITY | A & G WHOLESALE CANDY/PAPERBAG, INC. | SJ-03176 | 511 WHITTIER ST | BRONX | BRONX | NEW YORK | 202 | 10474 | 7186818918 | 40.810989 | -73.882689 |
| NEW YORK CITY | AIR KING TRADING, INC. | SJ-03448 | 415 DEVOE AVE | BRONX | BRONX | NEW YORK | 206 | 10460 | 7188246400 | 40.84058 | -73.877031 |
| NEW YORK CITY | AMERICAN TOBACCO CORP | SJ-03464 | 272 WAKEMAN PL | BROOKLYN | BROOKLYN | NEW YORK | 310 | 11220 | 9172549574 | 40.638445 | -74.025308 |
| NEW YORK CITY | BAY RIDGE TOBACCO DISTRIBUTORS INC | SJ-02897 | 9225 5TH AVE | BROOKLYN | BROOKLYN | NEW YORK | 310 | 11209 | 7187453011 | 40.617567 | -74.029572 |
| NEW YORK CITY | BM WHOLESALE CORP | SJ-03501 | 6925 COOPER AVE | QUEENS | GLENDALE | NEW YORK | 405 | 11385 | 6469125785 | 40.701352 | -73.881569 |
| NEW YORK CITY | BRONX TRADING CO., INC. | SJ-03425 | 1375 SEABURY AVE | BRONX | BRONX | NEW YORK | 210 | 10461 | 7189316448 | 40.837404 | -73.842662 |
| NEW YORK CITY | CIGARETTES PLUS INC | SJ-03438 | 3855 9TH AVE | MANHATTAN | NEW YORK | NEW YORK | 112 | 10034 | 2125699710 | 40.863117 | -73.917474 |
| NEW YORK CITY | CJS WHOLESALERS INC | SJ-03482 | 147 W 35TH ST | MANHATTAN | NEW YORK | NEW YORK | 105 | 10001 | 2126293400 | 40.751123 | -73.988844 |
Showing 12 of 18 columns. All of them are listed below.
10409 53RD AVE1500 SOLANA BLVDborough | categorical | — | 43% | QUEENSBRONXBROOKLYNof 4 |
city_or_town | text | City where NY Wholesale Cigarette Dealer is located | 0% | BROOKLYNBRONXNEW YORK |
state | categorical | State where NY Wholesale Cigarette Dealer is located | 0% | NEW YORKNEW JERSEYNORTH CAROLINAof 9 |
community_board | categorical | The Community Board field indicates the New York City Community District where the wholesale dealer is located. | 43% | 311405310of 18 |
zip_code | text | Zipcode of NY Licensed Wholesale Cigarette Dealer is located | 0% | 113851136818434 |
phone_no | text | Phone Number of NY Licensed Wholesale Cigarette Dealer is located | 0% | 254742342291725495749172171517 |
latitude | float | Latitude of the wholesale dealer's location. | 43% | 40.75112340.75469140.755486 |
longitude | float | Longitude of the wholesale dealer's location. | 43% | -73.882689-73.819485-74.025308 |
council_district | categorical | The Council District field indicates the New York City Council District where the wholesale dealer is located. | 43% | 17473of 18 |
census_tract | text | The Census Tract field indicates the U.S. Census Tract where the wholesale dealer is located. | 43% | 7170274 |
bin | text | The BIN (Building Identification Number) is a unique identifier for each wholesale dealer in the City. | 43% | 409037220030831013615 |
bbl | text | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City. | 43% | 100811001030625800012038470018 |
nta | categorical | The Neighborhood Tabulation Area field indicates the New York City Neighborhood area where the wholesale dealer is located. | 43% | BK1001QN0503BK1101of 18 |
effective_date | datetime | Date the data was produced | 0% | 2026-08-28T00:00:00.000of 1 |