From a 163-row sample across 8 columns.
doing_business_start_date| report_period | first_name | last_name | entity_name | doing_business_start_date | date_removed | db_date_ended | middle_initial |
|---|---|---|---|---|---|---|---|
| 2021-05-01T00:00:00.000 | Ashwini | Chhabra | Bird Rides Inc | 2018-10-01T00:00:00.000 | 2021-04-30T00:00:00.000 | 2020-12-31T00:00:00.000 | — |
| 2021-05-01T00:00:00.000 | David | Becker | Big Six Towers Inc | 2017-08-15T00:00:00.000 | 2021-04-30T00:00:00.000 | 2020-03-02T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
report_period | datetime | List publication date (month, year). | 0% | 2021-05-01T00:00:00.000of 1 |
first_name | text | First name of person removed from the Doing Business As database. | 1% | MichaelJohnRobert |
middle_initial | categorical | Middle initial of person removed from the Doing Business As database. | 67% | SAMof 15 |
last_name | text | Last name of person removed from the Doing Business As database. | 1% | FisherCohenCantillo |
GET /api/datasets/73qb-dcc3 GET /api/datasets/73qb-dcc3/quality GET /api/datasets/73qb-dcc3/related GET /api/columns?dataset=73qb-dcc3
| — |
| 2021-05-01T00:00:00.000 | Cidra | Sebastien | The Brotherhood/Sisterhood Sol | 2008-07-31T00:00:00.000 | 2021-04-30T00:00:00.000 | 2009-12-01T00:00:00.000 | — |
| 2021-05-01T00:00:00.000 | Jennifer | Ching | Queens Legal Services Corporation - Jenny Ching has been removed from the DBDB but remains on the Public Portal in error. She ended doing business on 2/13/17. This will be corrected in the next update | 2010-01-27T00:00:00.000 | 2021-04-30T00:00:00.000 | 2017-02-13T00:00:00.000 | — |
| 2021-05-01T00:00:00.000 | John | Rashkin | Housing Conservation Coordinators Inc | 2008-07-31T00:00:00.000 | 2021-04-30T00:00:00.000 | 2008-09-12T00:00:00.000 | — |
| 2021-05-01T00:00:00.000 | David | Saltzman | RH Bronx Rider LLC | 2011-03-31T00:00:00.000 | 2021-04-30T00:00:00.000 | 2016-01-01T00:00:00.000 | E |
| 2021-05-01T00:00:00.000 | Frank | Sullivan | Torchlight Investors LLC | 2009-05-01T00:00:00.000 | 2021-04-30T00:00:00.000 | 2014-05-31T00:00:00.000 | L |
| 2021-05-01T00:00:00.000 | Wai Po Wong | Tsang | Homecrest Community Services Inc | 2008-07-31T00:00:00.000 | 2021-04-30T00:00:00.000 | 2012-12-31T00:00:00.000 | W |
| 2021-05-01T00:00:00.000 | Paul | Finnegan | Failte Care Corp | 2017-07-01T00:00:00.000 | 2021-04-30T00:00:00.000 | 2020-10-31T00:00:00.000 | — |
| 2021-05-01T00:00:00.000 | Cheryl | Armitage Bergeron | Children's Harbor Montessori School | 2014-10-31T00:00:00.000 | 2021-03-31T00:00:00.000 | 2016-06-09T00:00:00.000 | — |
entity_name | text | Name of the entity or related entity removed from the Doing Business As database. | 0% | Consolidated Edison Comp…Skadden, Arps, Slate, Me…Plaza Construction Corpo… |
doing_business_start_date | datetime | Date of the original Local Law 34 submission. | 1% | 2008-07-31T00:00:00.0002008-02-02T00:00:00.0002013-05-01T00:00:00.000 |
date_removed | datetime | Date person or entity was removed from the Doing Business As database. | 0% | 2021-02-28T00:00:00.0002021-03-31T00:00:00.0002021-04-30T00:00:00.000 |
db_date_ended | datetime | Date of the Local Law 34 record expiration. | 0% | 2017-12-31T00:00:00.0002016-03-01T00:00:00.0002015-12-31T00:00:00.000 |