Historical License Applications
This dataset represents the state of completed license applications and renewals City Agencies Management Information System, (CAMIS) as of October 2013.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Jul 17, 2024
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jul 17, 2024, 11:52 AM
- Rows in our copy
- 741,062
- Rows at the source
- 741,062
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
4 of 28 columns carry a concept; 28 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
location_street2 | Secondary Address Street Name | The secondary cross street of the business's location. | Not bound | Text | location_street2 | text | — | |
state | Address State | State where the business is located. If an individual license, the State of the licensee's mailing address. | Not bound | Text | state | text | — | |
license_number | License Number | An identification number issued to businesses/individuals to operate legally for the duration of their license term. | Not bound | Number | license_number | numeric | — | |
boro_code | Boro Code | Borough Code of the Borough where the business is located. | Not bound | Text | boro_code | text | — | |
street1 | Address Street Name | Street name where the business is located. | Not bound | Text | street1 | text | — | |
city | Address City | City where the business is located. If an individual license, the City of the licensee's mailing address. | Not bound | Text | city | text | — | |
license_code | License Code | The code associated with the business category or business activity requiring a DCWP-issued license in order to operate leally. | Not bound | Number | license_code | numeric | — | |
nta2020 | Neighborhood Tabulation Area (NTA) (2020) | The Neighborhood Tabulation Area (Census 2020) field indicates the New York City Neighborhood area where the building is located |
Download
This file was produced on Aug 29, 2026, 10:12 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/vnz6-h2k4
- Version
- Content hash:
1b572e116a13e31d50216160f2ac5c2119367ab2396f08d5af2cb055f2a45711 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jul 17, 2024, 11:52 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 29, 2026, 3:00 AM | full_replace | success | 741,062 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |