Persons Removed from Doing Business Database
This report includes a list of entities or individuals should not be listed in the Database because the entity does not participate in transactions covered by LL 34, or the individual does not hold one of the positions noted above.
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
- As needed
- Actually updates about every
- —
- Publisher last updated the data
- Jun 30, 2021
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jun 30, 2021, 4:33 PM
- Rows in our copy
- 163
- Rows at the source
- 163
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 8 columns carry a concept; 8 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 |
|---|---|---|---|---|---|---|---|---|
date_removed | Date Removed | Date person or entity was removed from the Doing Business As database. | Not bound | Calendar date | date_removed | timestamp | — | |
doing_business_start_date | Doing Business Start Date | Date of the original Local Law 34 submission. | Not bound | Calendar date | doing_business_start_date | timestamp | — | |
report_period | Report Period | List publication date (month, year). | Not bound | Calendar date | report_period | timestamp | — | |
first_name | First Name | First name of person removed from the Doing Business As database. | Not bound | Text | first_name | text | — | |
middle_initial | Middle Initial | Middle initial of person removed from the Doing Business As database. | Not bound | Text | middle_initial | text | — | |
entity_name | Entity Name | Name of the entity or related entity removed from the Doing Business As database. | Not bound | Text | entity_name | text | — | |
db_date_ended | DB Date Ended | Date of the Local Law 34 record expiration. | Not bound | Calendar date | db_date_ended | timestamp | — | |
last_name | Last Name | Last name of person removed from the Doing Business As database. | Not bound | Text |
Download
This file was produced on Aug 20, 2026, 9:19 AM.
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/73qb-dcc3
- Version
- Content hash:
44f67c2798d8e3d0ab22994f843f86d7998dbd64ef41970acef3519fb7824f0a - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jun 30, 2021, 4:33 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 6, 2026, 4:09 AM | full_replace | success | 163 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.47 |