<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 licenses issued by DCWP to businesses and individuals so that they may legally operate in New York City. Note: Temporary street fair vendor permits are not included in this dataset.
This dataset has the following 27 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
DCA License Number | license_nbr | text | An identification number issued to businesses/individuals to operate legally for the duration of their license term. | 1374839-DCA 2003600-DCA 0006164-DCA 0010669-DCA 0010699-DCA view top 100 |
License Type | license_type | text | Indicates whether the licensee is a business or an individual. | Business Individual view top 100 |
License Expiration Date | lic_expir_dd | calendar_date | Expiration date of the License. | 2025-02-28T00:00:00.000 2015-02-28T00:00:00.000 2017-02-28T00:00:00.000 2019-02-28T00:00:00.000 2017-12-31T00:00:00.000 view top 100 |
License Status | license_status | text | This indicates whether the license is active or inactive. | Inactive Active view top 100 |
License Creation Date | license_creation_date | calendar_date | The date the license record was created. | 2000-12-05T00:00:00.000 2018-02-23T00:00:00.000 2000-12-06T00:00:00.000 2001-01-05T00:00:00.000 2002-12-30T00:00:00.000 view top 100 |
Industry | industry | text | The business category or business activity requiring a DCA-issued license in order to operate legally. | Home Improvement Contractor Home Improvement Salesperson Tobacco Retail Dealer Secondhand Dealer - General Electronics Store view top 100 |
Business Name | business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk or, if an individual, the person’s first name and last name. | T-MOBILE NORTHEAST LLC RADIOSHACK CORPORATION DUANE READE CENTRAL PARKING SYSTEM OF NEW YORK,INC. SP PLUS CORPORATION view top 100 |
Business Name 2 | business_name_2 | text | If applicable, the Doing-Business-As (DBA), or trade name. | T-MOBILE AT&T MOBILITY T-Mobile VERIZON WIRELESS T-Mobile 4110 view top 100 |
Address Building | address_building | text | Building number of the business's premise address. | 1 200 2 10 100 view top 100 |
Address Street Name | address_street_name | text | Street name of the business's premise address. | BROADWAY 3RD AVE 5TH AVE JAMAICA AVE ROOSEVELT AVE view top 100 |
Secondary Address Street Name | address_street_name_2 | text | The cross street of the business's premise address. | 6 AVENUE 8 AVENUE BROADWAY 3 AVENUE 7 AVENUE view top 100 |
Address City | address_city | text | City where the business is located. If an individual license, the City of the licensee's mailing address. | BROOKLYN NEW YORK BRONX STATEN ISLAND JAMAICA view top 100 |
Address State | address_state | text | State where the business is located. If an individual license, the State of the licensee's mailing address. | NY NJ PA CT FL view top 100 |
Address ZIP | address_zip | text | Postcode where the business is located. If an individual license, the postcode of the licensee's mailing address. | 11385 11214 11220 11368 11235 view top 100 |
Contact Phone Number | contact_phone | text | The phone number of the business. | 9999999999 2125025490 7189999999 8174152812 2126869800 view top 100 |
Address Borough | address_borough | text | Borough name where the business is located. | Brooklyn Queens Manhattan Bronx Outside NYC view top 100 |
Borough Code | detail | text | Borough Code of the Borough where the business is located. | 3 4 1 2 5 view top 100 |
Community Board | community_board | text | Community District number where the business is located. | 105 407 401 412 311 view top 100 |
Council District | council_district | text | City Council District number where the business is located. | 3 38 26 17 34 view top 100 |
BIN | bin | text | Building Identification Number where the business is located. | 0 4000000 3000000 2000000 1000000 view top 100 |
BBL | bbl | text | Borough Block Lot number where the business is located. | 4000000000 3000000000 2000000000 5000000000 1000220020 view top 100 |
NTA | nta | text | Neighborhood Tabulation Area where the business is located. | MN17 MN13 MN24 QN70 QN61 view top 100 |
Census Tract | census_tract | text | Census Tract where the business is located. | 96 33 41 65 138 view top 100 |
Detail | detail_2 | text | Provides additional licensing details for certain industries. | General Vendor Type: General Vendor (White) Laundry Type: Retail Laundry Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 2, 5 foot stands: 0, 5.01 to 10 foot stands: 0 Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 1, 5 foot stands: 0, 5.01 to 10 foot stands: 0 General Vendor Type: Citywide Specialized Vendor (Yellow) view top 100 |
Longitude | longitude | text | The longitude of the business's premise address. Not available for individual licenses. | -77.51958437167269 -74.01290870587448 -73.96606610619004 -73.87157752015248 -73.97801647268102 view top 100 |
Latitude | latitude | text | The latitude of the business's premise address. Not available for individual licenses. | 40.11238533659802 40.70627017391471 40.758226846199264 40.73384724725437 40.57543312279164 view top 100 |
Location | location | location | view top 100 |