Issued Licenses

Department of Consumer and Worker Protection (DCWP), NYC OpenData
This dataset features licenses issued by the NYC Department of Consumer and Worker Protection (DCWP)—formerly the Department of Consumer Affairs (DCA). Each row represents a license issued by DCWP and its current status, with 69.2K rows and 31 columns including license number, business name, business category, license type, license status, issuance/expiration dates, and address information.
Data Format CSV, API (Socrata)
Download Url https://data.cityofnewyork.us/api/views/w7w3-xahh/rows.cs...
Download Url Validated False
Validation Message All URLs failed validation
Alternate Download Urls https://data.cityofnewyork.us/resource/w7w3-xahh.csv
https://data.cityofnewyork.us/resource/w7w3-xahh.json
https://data.cityofnewyork.us/api/views/w7w3-xa...
Update Frequency Weekly
Last Updated April 11, 2026 (Metadata); March 10, 2026 (Data)
Geospatial Bounds -122.6697,0.0,40.8847,47.5765
Portal Type socrata
Success False
Quality Score
100%
Usable
Yes
Total Rows
45,607
Valid Geometries
45,607 / 45,607

Schema Compliance

Geometry Type Point
CRS {"$schema": "https://proj.org/schemas/v0.7/projjso...
WGS84 Yes
Required Columns Yes

Spatial Bounds

SW: (-122.6697, 0.0)
NE: (40.8847, 47.5765)

Column Completeness

Column Completeness
id 100.0%
names 100.0%
categories 100.0%
operating_status 100.0%
addresses 100.0%
phones 100.0%
websites 100.0%
socials 100.0%
emails 100.0%
sources 100.0%
source_properties 100.0%

Top Categories

altering_and_remodeling_contractor (13,703) tobacco_shop (6,513) used_vintage_and_consignment (5,306) electronics (4,053) e_cigarette_store (2,705) parking (2,641) street_vendor (2,602) medical_supply (1,845) appliance_store (1,750) hotel (778)

Issues