License Revocations, Suspensions, Surrenders, and Reinstatements

<b>NOTE:</b> 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.</br></p>

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.</br>

Licenses can be reinstated based on appeal of a revocation, expiration of a suspension, or new application after surrendering it.</br>

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/license-revocations-suspensions-surrenders-and-rpeq-j89e\".\"license_revocations_suspensions_surrenders_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.