License Applications
This dataset features all license applications submitted to the NYC Department of Consumer and Worker Protection (DCWP)—formerly the Department of Consumer Affairs (DCA). It includes applications where a license was issued or renewed, denied, withdrawn, or remains in pending status. If applicable, there is a corresponding license number, details of which can be found in the DCWP Licenses dataset.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Weekly
- Actually updates about every
- 7 days
- Publisher last updated the data
- Oct 2, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 2, 2026, 3:06 PM
- Rows in our copy
- 65,932
- Rows at the source
- 65,932
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
3 of 35 columns carry a concept; 35 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
community_board | Community Board | The NYC Community District where the business is located. | community_districtdeclared | Text | community_board | text | — | |
state | State | The state where the business is located. | Not bound | Text | state | text | — | |
council_district | Council District | The NYC City Council District where the business is located. | Not bound | Text | council_district | text | — | |
bbl | BBL | The Borough-Block-Lot number where the business is located. | Not bound | Text | bbl | text | — | |
census_block_2010_ | Census Block (2010) | The 2010 Census Block where the business is located. | Not bound | Text | census_block_2010_ | text | — | |
status | Application Status | The current status of the application. | Not bound | Text | status | text | — | |
census_tract_2010_ | Census Tract (2010) | The 2010 Census Tract where the business is located. | Not bound | Text | census_tract_2010_ | text | — | |
latitude | Latitude | The latitudinal coordinate where the business is located. | Not bound | Text | latitude | text | — | |
longitude |
Download
This file was produced on Oct 2, 2026, 10:03 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/ptev-4hud
- Version
- Content hash:
5651c1ac514dda91f3182e7ee045f4d3fe859a9add7f253067dedeab6c7d3e97 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 2, 2026, 3:06 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 2, 2026, 9:35 PM | full_replace | success | 65,932 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 25, 2026, 10:05 PM | full_replace | success | 65,932 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 18, 2026, 9:39 PM | full_replace | success | 65,932 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.82 |
| Sep 11, 2026, 9:39 PM | full_replace | success | 65,932 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 4, 2026, 11:15 PM | full_replace | success | 65,967 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 4, 2026, 9:27 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 27, 2026, 12:50 AM | full_replace | success | 87,632 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |