License Revocations, Suspensions, Surrenders, and Reinstatements
NOTE: This dataset reflects data as of 7/21/2023. The Department of Consumer and Worker Protection (DCWP) is working on an updated version of this dataset. This dataset features DCWP licenses that have been revoked, suspended, or surrendered as well as licenses that have been reinstated, if applicable. Licenses can be suspended or revoked for several reasons including, an order by the Office of Administrative Trials and Hearings; non-payment of fines and/or fees; or not maintaining a license requirement such as a current driver’s license or insurance coverage. Licenses are typically surrendered when a business closes, changes ownership, changes location, changes business name, or discontinues the activity that required the license. Licenses can be reinstated based on appeal of a revocation, expiration of a suspension, or new application after surrendering it. Each record in the dataset represents a time that a license was revoked, suspended, surrendered, or reinstated so a license can appear more than once. This dataset can be linked to other DCA datasets using the DCA License Number column. This dataset cannot be linked to an administrative hearing decision or provide a specific reason for the change in status.
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.
OverdueNo automatic refresh
- Automatic refresh
No scheduled refresh runs for this dataset. A refresh you ask for on this page runs anyway.
The publisher set a regular schedule for this dataset but has not updated it for far longer than that schedule, so the automatic queue skips it. An hourly triage lifts this fence once the publisher updates it again, which takes up to about 7 hours 15 minutes.
- Says it updates
- Weekly
- Actually updates about every
- —
- Publisher last updated the data
- Oct 11, 2023
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 11, 2023, 9:44 AM
- Rows in our copy
- 34,806
- Rows at the source
- 34,806
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 7 columns carry a concept; 7 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 |
|---|---|---|---|---|---|---|---|---|
status | Status | The status of the license as of the data extract date; Active/Inactive | Not bound | Text | status | text | — | |
business_name | Business Name | The legal business name as filed with the New York State Secretary of State or County Clerk or, if an Individual license, the individual's first name and last name. | Not bound | Text | business_name | text | — | |
event_date | Event Date | Date when the license was suspended, revoked, surrendered, or reinstated. | Not bound | Calendar date | event_date | timestamp | — | |
dca_license_number | DCA License Number | An identification number issued to businesses/individuals to operate legally for the duration of their license term or until the license is revoked. | Not bound | Text | dca_license_number | text | — | |
business_name_2 | Business Name 2 | If applicable, the Doing-Business-As (DBA) or trade name. |
Download
This file was produced on Aug 27, 2026, 10:02 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/rpeq-j89e
- Version
- Content hash:
4d66b9ced4ba9d7f1e82d008d4bd0d5b4c79e28eae56cc69ff70d8221ca8bf41 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 11, 2023, 9:44 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 27, 2026, 1:15 AM | full_replace | success | 34,806 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |