License Revocations, Suspensions, Surrenders, and Reinstatements

rpeq-j89eBusiness7 columns

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.

View on NYC Open Data

Quality

C79.7 / 100

From a 500-row sample across 7 columns.

completeness88/ 25% weight

consistency93/ 20% weight

accuracy100/ 20% weight

timeliness1/ 15% weight

usability95/ 20% weight

Related datasets

Action Taken Against Process Servers0.32
DCWP Payments Received0.31
joins onbusiness_name
DCWP Fines and Fees (Historical)0.31
joins onindustrybusiness_name
Waiting List for General Vendor Licenses0.30
HISTORICAL Sidewalk Café Licenses and Applications0.30
joins onbusiness_name
Historical Licenses0.29
joins on

Sample rows

dca_license_number	business_name	industry	event_type	event_date	status
0010699-DCA	KALOGIANNAKIS, MARINOS	Newsstand	Suspended	2022-12-06T00:00:00.000	Active
0010699-DCA	KALOGIANNAKIS, MARINOS	Newsstand	Reinstated	2022-12-16T00:00:00.000	Active
0010800-DCA	BELKIN, MARSHALL	Newsstand	Revoked	2003-08-08T00:00:00.000

Columns

7 queryable · 7 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`dca_license_number`	text	An identification number issued to businesses/individuals to operate legally for the duration of their license term or until the license is revoked.	0%	`2036752-1-DCA2004734-1183-DCA2066139-1-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 license, the individual's first name and last name.	10%	`T-MOBILE NORTHEAST LLCOMNIPOINT COMMUNICATIONS…CENTRAL PARKING SYSTEM O…`
`business_name_2`	text	If applicable, the Doing-Business-As (DBA) or trade name.	75%	`T-MOBILET-MobileAT&T MOBILITY`
`industry`	text	The category of business activity that requires a DCA license.

Query this from your own app

GET /api/datasets/rpeq-j89e
GET /api/datasets/rpeq-j89e/quality
GET /api/datasets/rpeq-j89e/related
GET /api/columns?dataset=rpeq-j89e