From a 500-row sample across 29 columns.
business_namecontact_phoneunit_type+14business_nameunit_typestreet3+12business_nameaddress_street_nameaddress_building+12Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| license_nbr | business_name | business_unique_id | business_category | license_type | license_status | license_creation_date | lic_expir_dd | contact_phone | address_type | address_building | address_street_name |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0016371-DCA | JAMES ROBINSON, INC. | BA-1322274-2022 | Secondhand Dealer - General | Premises | Active | 2003-10-31T00:00:00.000 | 2027-07-31T00:00:00.000 | 2127526166 | Complete Address | 480 | PARK AVENUE |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
license_nbr | text | An identification number issued to a business or individual when their license application is approved by DCWP. | 0% | 2080975-DCA0010699-DCA0216428-DCA |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk or, if an individual, the person’s first name and last name. | 0% | T-MOBILE NORTHEAST LLCSP PLUS CORPORATIONecoATM, LLC |
dba_trade_name | text | The "Doing Business As" or "Trade Name" registered with the NYS Department of State. | 87% | T-Mobile 4110ecoATMAT&T MOBILITY |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. |
GET /api/datasets/w7w3-xahh GET /api/datasets/w7w3-xahh/quality GET /api/datasets/w7w3-xahh/related GET /api/columns?dataset=w7w3-xahh
business_nameunit_typelatitude+9business_namebusiness_categorydba_trade_name+1business_namedba_trade_namebusiness_unique_idlatitudelongitudecensus_tract+5business_namelicense_nbr| 0157941-DCA | T & J SALVAGE CORP. | BA-1518146-2022 | Secondhand Dealer - General | Premises | Surrendered | 2003-06-12T00:00:00.000 | 2023-07-31T00:00:00.000 | 7189466200 | Complete Address | 2647 | STILLWELL AVE |
| 0202454-DCA | S. BELLITTE & SONS, INC. | BA-1564089-2022 | Secondhand Dealer - General | Premises | Expired | 2003-06-26T00:00:00.000 | 2025-07-31T00:00:00.000 | 7187395540 | Complete Address | 16920 | JAMAICA AVE |
| 0225766-DCA | EMPIRE DIAMOND CORPORATION | BA-1598130-2023 | Secondhand Dealer - General | Premises | Active | 2003-07-29T00:00:00.000 | 2027-07-31T00:00:00.000 | 2125644777 | Complete Address | 350 | 5TH AVE |
| 0227765-DCA | HECHT SEWING MACHINE & MOTOR CO., INC. | BA-1301425-2022 | Secondhand Dealer - General | Premises | Active | 2003-08-13T00:00:00.000 | 2027-07-31T00:00:00.000 | 2125635950 | Complete Address | 304 | W 38TH ST |
| 0230587-DCA | IDEAL AUTO EXCHANGE CORP. | BA-1735070-2025 | Secondhand Dealer - Auto | Premises | Active | 1995-05-31T00:00:00.000 | 2027-07-31T00:00:00.000 | 7186585132 | Complete Address | 8825 | 138TH ST |
| 0230939-DCA | CHARLES FRANKEL JEWELER, INC. | BA-1162940-2022 | Secondhand Dealer - General | Premises | Active | 2003-06-16T00:00:00.000 | 2027-07-31T00:00:00.000 | 7186482712 | Complete Address | 1927 | AVENUE U |
| 0254769-DCA | MCMILLEN, INC. | BA-1461306-2022 | Secondhand Dealer - General | Premises | Expired | 2003-07-28T00:00:00.000 | 2023-07-31T00:00:00.000 | 2127535600 | Complete Address | 155 | EAST 56 STREET |
| 0255366-DCA | FRENCH & COMPANY, INC. | BA-1235307-2022 | Secondhand Dealer - General | Premises | Active | 2003-06-19T00:00:00.000 | 2027-07-31T00:00:00.000 | 2125353330 | Complete Address | 17 | E 65TH ST |
| 0256627-DCA | CENTRAL TIME CLOCK INC. | BA-1238837-2022 | Secondhand Dealer - General | Premises | Active | 2003-07-01T00:00:00.000 | 2027-07-31T00:00:00.000 | 7187844900 | Complete Address | 523 | 50TH AVE |
Showing 12 of 27 columns. All of them are listed below.
| 0% |
BA-1305489-2022BA-1302088-2022BA-1103941-2022 |
business_category | text | The business activity or business category requiring a DCWP-issued license in order to operate legally within NYC. | 0% | Home Improvement Contrac…Tobacco Retail DealerSecondhand Dealer - Gene… |
license_type | categorical | Indicates whether the license is issued to an individual or an organization. | 0% | PremisesIndividualof 2 |
license_status | categorical | Indicates the current status of the license. | 0% | ActiveExpiredReady for Renewalof 10 |
license_creation_date | datetime | The date the license was originally issued. | 0% | 1900-12-31T00:00:00.0002018-02-23T00:00:00.0002025-05-16T00:00:00.000 |
lic_expir_dd | datetime | The date the license term expired or will expire. | 0% | 2027-02-28T00:00:00.0002026-12-31T00:00:00.0002028-03-31T00:00:00.000 |
detail | text | Additional information about the license for certain business categories. | 88% | Vendor Type: General Ven…Vendor Type: Citywide Sp…Product Category: Fruits… |
contact_phone | text | The phone number of the business contact. | 28% | 2123217542(425) 279-4550(858) 766-7249 |
address_type | categorical | The type of address where the business is located. | 24% | Complete AddressCross Street (Intersecti…Place (Landmark)of 4 |
address_building | text | The building number where the business is located. | 25% | 110200 |
address_street_name | text | The name of the street where the business is located. | 24% | BROADWAYJAMAICA AVE5TH AVE |
address_street_name_2 | text | The name of the cross street where the business is located. | 100% | — |
street3 | text | The name of the street where the business is located. | 100% | MADISON AVENUEof 1 |
unit_type | text | The type of unit of the business' address. | 85% | APTSTEFL |
apt_suite | text | The unit number of the business' address. | 85% | 123 |
address_city | text | The city where the business is located. | 0% | BROOKLYNNEW YORKBRONX |
address_state | text | The state where the business is located. | 0% | NYNJOutside USA |
address_zip | text | The ZIP Code where the business is located. | 0% | 112351121411385 |
address_borough | categorical | The NYC Borough where the business is located. | 30% | BrooklynQueensManhattanof 6 |
community_board | text | The NYC Community District where the business is located. | 36% | 105412407 |
council_district | text | The NYC City Council District where the business is located. | 36% | 040301 |
bin | text | The Building Identification Number where the business is located. | 37% | 400000030000002000000 |
bbl | text | The Borough-Block-Lot number where the business is located. | 37% | 411544010010109900434050447501 |
nta | text | The Neighborhood Tabulation Area where the business is located. | 37% | MN17QN55MN13 |
census_block_2010_ | text | The 2010 Census Block where the business is located. | 37% | 100020001001 |
census_tract | text | The 2010 Census Tract where the business is located. | 36% | 962176 |
latitude | float | The latitudinal coordinate where the business is located. | 34% | 40.5823045709559840.75822680570795640.67004755675707 |
longitude | float | The longitudinal coordinate where the business is located. | 34% | -74.16905343328875-73.96606610619004-73.84264537457251 |