All Results API
← All results

Department of Consumer and Worker Protection (DCWP), NYC OpenDataIssued Licenses

Published Apr 14, 2026 by admin

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.

📊 View Analysis Report 🗺️ View Interactive Map

Categories

altering_and_remodeling_contractor tobacco_shop used_vintage_and_consignment electronics e_cigarette_store parking street_vendor medical_supply appliance_store hotel

Category Inference

Licensed businesses in New York City issued permits by the NYC Department of Consumer and Worker Protection (DCWP), covering a wide range of industries including retail, food service, home improvement, automotive, personal care, and other consumer-facing commercial enterprises.

Fallback category: business_to_business›business

Source category mappings

(41)
Source category Overture category Confidence Valid
Hotel accommodation›hotel 1.00 ✓
Pawnbroker retail›shopping›pawn_shop 1.00 ✓
Pedicab Business travel›transportation›pedicab_service 1.00 ✓
Debt Collection Agency financial_service›collection_agencies 0.99 ✓
Electronic Cigarette Dealer retail›shopping›e_cigarette_store 0.99 ✓
Locksmith home_service›key_and_locksmith 0.99 ✓
Pedicab Driver travel›transportation›pedicab_service 0.99 ✓
Process Server Individual professional_services›legal_services›process_servers 0.99 ✓
Process Serving Agency professional_services›legal_services›process_servers 0.99 ✓
Bingo Game Operator arts_and_entertainment›bingo_hall 0.98 ✓
Employment Agency professional_services›employment_agencies 0.98 ✓
Tow Truck Company automotive›automotive_services_and_repair›towing_service 0.97 ✓
Electronics Store retail›shopping›electronics 0.95 ✓
Garage & Parking Lot travel›transportation›parking 0.95 ✓
Secondhand Dealer - Auto automotive›automotive_dealer›used_car_dealer 0.95 ✓
Tow Truck Driver automotive›automotive_services_and_repair›towing_service 0.95 ✓
Home Improvement Contractor home_service›contractor›altering_and_remodeling_contractor 0.92 ✓
Newsstand retail›shopping›books_mags_music_and_video›newspaper_and_magazines_store 0.92 ✓
RM retail 0.92 ✓
Secondhand Dealer - General retail›shopping›fashion›used_vintage_and_consignment 0.92 ✓
Ticket Seller Individual arts_and_entertainment›ticket_sales 0.92 ✓
Tobacco Retail Dealer retail›shopping›tobacco_shop 0.92 ✓
Sightseeing Guide travel›travel_services›travel_agents›sightseeing_tour_agency 0.88 ✓
General Vendor retail›food›street_vendor 0.82 ✓
Place (Landmark) attractions_and_activities›landmark_and_historical_building 0.82 ✓
Dealer In Products For The Disabled retail›shopping›medical_supply 0.72 ✓
Games of Chance - Raffle with Net Proceeds Over $30,000 professional_services›lottery_ticket 0.72 ✓
Storage Warehouse business_to_business›business_storage_and_transportation›b2b_storage_and_warehouses›warehouses 0.72 ✓
APT real_estate›real_estate_agent›apartment_agent 0.65 ✓
Electronic & Home Appliance Service Dealer retail›shopping›home_and_garden›appliance_store 0.65 ✓
Horse Drawn Cab Owner travel›transportation›taxi_service 0.65 ✓
Stoop Line Stand retail›food›street_vendor 0.62 ✓
Premises business_to_business›business 0.55 ✓
SPC eat_and_drink›cafe 0.55 ✓
STE retail›shopping›market_stall 0.55 ✓
FRNT business_to_business›business 0.45 ✓
FL retail›shopping›flea_market 0.40 ✓
Individual business_to_business›business 0.35 ✓
UNIT business_to_business›business 0.30 ✓
Cross Street (Intersection) structure_and_geography 0.20 ✓
Complete Address business_to_business›business 0.05 ✓

Source Schema

(31 columns)
Name Type Null % Unique Sample values
License Number object 0.0% 10000
  • 2103139-DCA
  • 2115106-DCA
  • 2106073-DCA
Business Name object 0.0% 9461
  • YA.K.K INC
  • JULIEN MORALES
  • Don Littlefield
DBA/Trade Name object 86.1% 1218
  • 50 SUTTON PLACE SO GARAGE
  • ECONO-THERM INSULATION CO
  • NEW BOATS & MOTORS
Business Unique ID object 0.0% 9837
  • BA-1539630-2022
  • BA-1599832-2023
  • BA-1243907-2022
Business Category object 0.0% 45
  • Electronics Store
  • Sightseeing Guide
  • Sightseeing Guide
License Type object 0.0% 2
  • Premises
  • Individual
  • Individual
License Status object 0.0% 9
  • Expired
  • Active
  • Active
Initial Issuance Date object 0.0% 4372
  • 12/15/2021
  • 07/17/2023
  • 05/17/2022
Expiration Date object 0.1% 113
  • 12/31/2024
  • 03/31/2028
  • 03/31/2028
Details object 88.7% 309
  • Vehicle Capacity: 260; Bicycle Capacity: 21
  • Vehicle Capacity: 129; Bicycle Capacity: 12
  • Vehicle Capacity: 150; Bicycle Capacity: 15
Contact Phone object 27.2% 6522
  • 2125873840
  • 718-266-0377
  • 7189844100
Address Type object 23.7% 4
  • Complete Address
  • Complete Address
  • Complete Address
Building Number object 25.1% 3801
  • 81
  • 288
  • 2453
Street1 object 23.7% 3177
  • BAYARD STREET
  • AVENUE U
  • ARTHUR KILL RD
Street2 float64 100.0% 0 —
Street3 float64 100.0% 0 —
Unit Type object 84.6% 16
  • UNIT
  • UNIT
  • APT
Apt/Suite object 85.3% 494
  • 3J
  • 3D
  • 1A
City object 0.0% 751
  • NEW YORK
  • BROOKLYN
  • PORTLAND
State object 0.1% 42
  • NY
  • NY
  • ME
ZIP Code object 0.1% 1059
  • 10013
  • 11233
  • 04102
Borough object 29.5% 6
  • Manhattan
  • Brooklyn
  • Staten Island
Community Board float64 35.8% 64
  • 103.0
  • 315.0
  • 503.0
Council District float64 35.8% 51
  • 1.0
  • 44.0
  • 51.0
BIN float64 37.7% 5545
  • 1001812.0
  • 3192646.0
  • 5086708.0
BBL float64 37.7% 5598
  • 1001640022.0
  • 3071230010.0
  • 5071520056.0
NTA object 37.1% 193
  • MN27
  • BK26
  • SI11
Census Block (2010) float64 37.1% 169
  • 1006.0
  • 1001.0
  • 1001.0
Census Tract (2010) float64 35.8% 1113
  • 29.0
  • 398.0
  • 226.0
Latitude float64 34.2% 5405
  • 40.71573
  • 40.59694
  • 40.55435
Longitude float64 34.2% 5975
  • -73.998788
  • -73.973497
  • -74.217834

Quality Report

✅ Dataset is usable