From a 500-row sample across 21 columns.
latitudebusiness_namebin+8license_numberlatitudecity+10latitudebusiness_namebin+5citystatecouncil_districtMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| camis_id | license_type | license_code | license_category | license_number | business_name | activity_type | activity_date | activity | activity_code | activity_notes | building_number |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10021677 | Business | 64 | LAUNDRY | 409426 | NG, YING KI | RENEWAL | 1995-10-17T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | REQUIREMENTS MET | 4803 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
camis_id | integer | A unique system-generated identification number used to track a business across the system. | 0% | 411139224104813241293476 |
license_type | categorical | Indicates whether the applicant is a business or an individual. | 0% | BusinessIndividualof 2 |
license_code | integer | The code associated with the business category or business activity requiring a DCWP-issued license in order to operate leally. | 0% | 101100127 |
license_category | text | The business category or business activity requiring a DCWP-issued license in order to operate legally. | 0% |
GET /api/datasets/vnz6-h2k4 GET /api/datasets/vnz6-h2k4/quality GET /api/datasets/vnz6-h2k4/related GET /api/columns?dataset=vnz6-h2k4
latitudetrade_namecity+8latitudecitystreet1+9citystatecouncil_district| 10029117 |
| Business |
| 64 |
| LAUNDRY |
| 695257 |
| 853 DISTRICT CORP |
| RENEWAL |
| 1999-11-17T00:00:00.000 |
| APPROVED |
| RAPID RENEWAL |
| RAPID RENEWAL PROCESSING |
| 853 |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1994-05-09T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | OK TO APPROVE | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1995-04-27T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | OK TO APPROVE | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1996-01-24T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | OK TO APPROVE | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1997-02-21T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | OK TO APPROVE | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1997-12-31T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | OK TO APPROVE | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1998-12-07T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | RENEWAL APPROVE | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 1999-11-24T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | RENEWAL APPRPOVED | — |
| 11000191 | Individual | 94 | GENERAL VENDOR VETERAN | 795628 | KIM, TAL RYONG | RENEWAL | 2000-12-06T00:00:00.000 | APPROVED | LICENSE STATUS- RNA | RENEWAL APPROVED | — |
Showing 12 of 18 columns. All of them are listed below.
HOME IMPROVEMENT SALESPE…HOME IMPROVEMENT CONTRAC…CIGARETTE RETAIL DEALERlicense_number | integer | An identification number issued to businesses/individuals to operate legally for the duration of their license term. | 2% | 119859712699881174724 |
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 last name and first name. | 0% | DUANE READERADIOSHACK CORPORATIONCENTRAL PARKING SYSTEM O… |
trade_name | text | If applicable, the Doing-Business-As (DBA), or trade name of the business. | 78% | T-MOBILEVERIZON WIRELESSHUDSON NEWS |
activity_type | categorical | Indicates whether the transaction was a new license application or for the renewal of an existing license | 0% | RENEWALNEW APPLICATIONof 2 |
activity_date | datetime | The date a final determination was made on the application or renewal. | 0% | 2007-10-06T00:00:00.0002013-09-24T00:00:00.0002013-09-21T00:00:00.000 |
activity | categorical | The final determination on the application or renewal. | 0% | APPROVEDDENIEDWITHDRAWNof 3 |
activity_code | categorical | Code entered into the system to denote a activity or action on a record. | 0% | RAPID RENEWALLICENSE STATUS- ANLLICENSE STATUS- RNAof 8 |
activity_notes | text | Notes entered into the system by the person processing the application or renewal. | 0% | RAPID RENEWAL PROCESSINGOK TO APPROVEREQUIREMENTS MET |
building_number | text | Building number of the business's premise address. | 36% | 200N/W/C1 |
street1 | text | Street name where the business is located. | 36% | BROADWAY3 AVENUE5 AVENUE |
location_street2 | text | The secondary cross street of the business's location. | 91% | 1ST FLOOR2ND FLOOR1 FL |
city | text | City where the business is located. If an individual license, the City of the licensee's mailing address. | 0% | BROOKLYNNEW YORKBRONX |
state | text | State where the business is located. If an individual license, the State of the licensee's mailing address. | 0% | NYNJPA |
postcode | text | Postcode where the business is located. If an individual license, the postcode of the licensee's mailing address. | 0% | 100361138511214 |
boro_code | text | Borough Code of the Borough where the business is located. | 15% | 341 |
community_board | integer | The Community District where the business is located. | 26% | 105407401 |
council_district | integer | The City Council District where the business is located. | 51% | 314 |
borough | categorical | Borough in which the building is located | 51% | BROOKLYNMANHATTANQUEENSof 5 |
latitude | float | Latitude of the building's location | 51% | 40.75822740.57543340.591314 |
longitude | float | Longitude of the building's location | 51% | -73.966066-73.994488-73.978006 |
bin | integer | The BIN (Building Identification Number) is a unique identifier for each building in the City | 52% | 400000030000001000000 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City | 52% | 101348004930694300303086960212 |
ct2020 | integer | The Census Tract (Census 2020) field indicates the U.S. Census Tract where the building is located. Please note that as part of the geocoding process, leading and trailing zeros are dropped | 51% | 964158 |
nta2020 | text | The Neighborhood Tabulation Area (Census 2020) field indicates the New York City Neighborhood area where the building is located | 51% | MN0502MN0501QN1201 |