From a 500-row sample across 35 columns.
council_districtcensus_block_2010_unit_type+14council_districtcitycensus_block_2010_+16council_districtlatitudeborough+6Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| application_id | license_number | business_name | business_unique_id | business_category | application_type | license_type | intake_channel | submission_date | date_closed | status | contact_phone |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001-2025-RHIC | 2103162-DCA | MH CONSTRUCTION BD CORP | BA-1429361-2022 | Home Improvement Contractor | Renewal | Premises | Online | 2025-01-01T00:00:00.000 | 2025-01-03T00:00:00.000 | Approved | 7186298242 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
application_id | text | An identification number assigned by DCWP to record each application received | 0% | 2116296-2023-RSHG2115785-2023-RTSI00002-2024-1-RTRD |
license_number | text | An identification number issued to a business or individual when their license application is approved by DCWP. | 7% | 2121513-DCWP2025040-DCA2075574-DCA |
business_name | text | The name of the business or individual submitting a new or renewal license application to DCWP. | 0% | SP PLUS CORPORATIONT-MOBILE NORTHEAST LLCecoATM, LLC |
dba_trade_name | text | The "Doing Business As" or "Trade Name" registered with the NYS Department of State. |
GET /api/datasets/ptev-4hud GET /api/datasets/ptev-4hud/quality GET /api/datasets/ptev-4hud/related GET /api/columns?dataset=ptev-4hud
citystreet_2unit_typebusiness_categorybusiness_unique_iddba_trade_name+1business_unique_iddba_trade_namebusiness_namecityzipbusiness_name+2council_districtlatitudenta+4| 00001-2026-AGEV | — | FA SHUN NI | BA-1758632-2025 | General Vendor | New | Individual | Online | 2026-01-01T00:00:00.000 | — | Additional Info Requested | — |
| 00002-2024-1-RTRD | 2039678-1-DCA | J.G.L. FINE FOODS, INC. | BA-1279958-2022 | Tobacco Retail Dealer | Renewal | Premises | Online | 2024-01-01T00:00:00.000 | 2024-01-02T00:00:00.000 | Approved | 718-851-6200 |
| 00002-2025-RHIC | 2105081-DCA | HAYWOOD CONSTRUCTION LLC | BA-1314274-2022 | Home Improvement Contractor | Renewal | Premises | Online | 2025-01-01T00:00:00.000 | 2025-01-03T00:00:00.000 | Approved | (917) 353-0739 |
| 00002-2026-2-RECD | 2075292-1-DCA | CAVIAR MIST 6 INC. | BA-1197963-2022 | Electronic Cigarette Dealer | Renewal | Premises | Online | 2026-01-01T00:00:00.000 | 2026-03-20T00:00:00.000 | Approved | 7183001114 |
| 00003-2024-RSSG | 2093252-DCA | EDWARD STRAKA | BA-1163596-2022 | Sightseeing Guide | Renewal | Individual | Online | 2024-01-01T00:00:00.000 | 2024-01-02T00:00:00.000 | Approved | — |
| 00003-2025-RHIC | 1448690-DCA | WHITE, WILLIAM | BA-1575092-2023 | Home Improvement Contractor | Renewal | Premises | Online | 2025-01-01T00:00:00.000 | 2025-01-03T00:00:00.000 | Approved | 8564951891 |
| 00003-2026-2-RECD | 2074186-1-DCA | STEINWAY GOURMET DELI INC | BA-1507860-2022 | Electronic Cigarette Dealer | Renewal | Premises | Online | 2026-01-01T00:00:00.000 | 2026-01-02T00:00:00.000 | Approved | 347-944-2837 |
| 00004-2024-RSSG | 0977062-DCA | ANTHONY W ROBINS | BA-1120815-2022 | Sightseeing Guide | Renewal | Individual | Online | 2024-01-01T00:00:00.000 | 2024-01-02T00:00:00.000 | Approved | — |
| 00004-2025-RHIC | 2112053-DCA | DUMBO HOME IMPROVEMENT CORP | BA-1579032-2023 | Home Improvement Contractor | Renewal | Premises | Online | 2025-01-01T00:00:00.000 | 2025-01-03T00:00:00.000 | Approved | 9295308492 |
Showing 12 of 30 columns. All of them are listed below.
| 89% |
AT&T MOBILITYT-Mobile 4110SPECTRUM |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. | 0% | BA-1305489-2022BA-1695421-2024BA-1442784-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…Secondhand Dealer - Gene…Tobacco Retail Dealer |
application_type | categorical | Indicates whether the applicant is submitting a new or renewal license application. | 0% | RenewalNewof 2 |
license_type | categorical | Indicates whether the applicant is submitting an application for a license to be issued to an individual or to business. | 0% | PremisesIndividualof 2 |
intake_channel | categorical | The method the applicant used to submit their application to DCWP. | 0% | OnlineWalk-Inof 2 |
submission_date | datetime | Date when all application requirements are received. Note that if application status is pending, a start date will not appear. | 0% | 2024-12-20T00:00:00.0002025-02-27T00:00:00.0002025-01-06T00:00:00.000 |
date_closed | datetime | The date a final determination was made on an application. | 6% | 2025-03-04T00:00:00.0002025-03-01T00:00:00.0002025-01-07T00:00:00.000 |
status | categorical | The current status of the application. | 0% | ApprovedClosedDeniedof 10 |
temp_op_letter_issued | datetime | The most recent date a Temporary Operating Letter (TOL) was issued. | 99% | 2025-05-16T00:00:00.0002026-02-27T00:00:00.0002025-05-22T00:00:00.000 |
temp_op_letter_expiration | datetime | The current expiration date of a Temporary Operating Letter (TOL). | 99% | 2026-03-31T00:00:00.0002025-06-16T00:00:00.0002025-03-30T00:00:00.000 |
contact_phone | text | Contact telephone number for license applicant. | 35% | 2123217542(425) 279-4550(877) 727-5464 |
address_type | categorical | The type of address where the business is located. | 32% | Complete AddressCross Street (Intersecti…Place (Landmark)of 4 |
building_number | text | The building number where the business is located. | 33% | 120010 |
street | text | The name of the street where the business is located. | 32% | BROADWAYJAMAICA AVE5TH AVE |
street_2 | text | The name of the cross street where the business is located. | 99% | 8 AVENUE3 AVENUEWILLIAM STREET |
street3 | text | The name of the street where the business is located. | 100% | MADISON AVENUEof 1 |
unit_type | text | The unit type of the business’s address (e.g., Apartment/Suite/Other). | 86% | APTSTEFL |
unit | text | The unit number of the business' address. | 87% | 123 |
city | text | The city where the business is located. | 0% | BROOKLYNNEW YORKBRONX |
state | text | The state where the business is located. | 0% | NYNJOutside USA |
zip | text | The ZIP Code where the business is located. | 0% | 112351121410036 |
borough | categorical | The NYC Borough where the business is located. | 38% | QueensBrooklynManhattanof 6 |
community_board | text | The NYC Community District where the business is located. | 43% | 105407412 |
council_district | text | The NYC City Council District where the business is located. | 43% | 040301 |
bin | text | The Building Identification Number where the business is located. | 45% | 400000030000002000000 |
bbl | text | The Borough-Block-Lot number where the business is located. | 45% | 101099004341154401004050447501 |
nta | text | The Neighborhood Tabulation Area where the business is located. | 44% | MN17QN55MN13 |
census_block_2010_ | text | The 2010 Census Block where the business is located. | 44% | 100020001001 |
census_tract_2010_ | text | The 2010 Census Tract where the business is located. | 43% | 967621 |
latitude | coordinate | The latitudinal coordinate where the business is located. | 41% | 40.75822680570795640.5823045709559840.75739571541868 |
longitude | coordinate | The longitudinal coordinate where the business is located. | 41% | -73.96606610619004-74.16905343328875-73.98029180455218 |