From a 500-row sample across 9 columns.
industryrecord_idbusiness_nameindustrybusiness_namebusiness_name_2| record_id | date_opened | business_name | industry | withdrawal_from | basis_for_withdrawal | amount | date_completed |
|---|---|---|---|---|---|---|---|
| 100-2017-CPLI | 2017-03-29T00:00:00.000 | GIL, ISIDRO Q"" | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for Consumer | 7000 | 2018-08-20T00:00:00.000 |
| 10065-2014-ADJC | 2014-08-19T00:00:00.000 | 4 SEASONS INTERIORS CORP. | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for DCA fines |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
record_id | text | An identification number assigned by DCA for internal tracking purposes. | 0% | 326-2017-CPLI7411-2019-ADJC453-2015-CPLI |
date_opened | datetime | Date when the record or case was opened. | 0% | 2017-09-01T00:00:00.0002016-11-01T00:00:00.0002014-08-28T00:00:00.000 |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk or, if an Individual license, the individual's first name and last name. | 1% | PLANTAGENET HOLDINGS, IN…TRADEMARK CONTRACTING IN…TIP TOP ALUMINUM PRODUCT… |
business_name_2 | categorical | If applicable, the Doing-Business-As (DBA) or trade name. |
GET /api/datasets/ga3c-v25a GET /api/datasets/ga3c-v25a/quality GET /api/datasets/ga3c-v25a/related GET /api/columns?dataset=ga3c-v25a
record_idbusiness_name| 3000 |
| 2015-01-29T00:00:00.000 |
| 10293-2014-ADJC | 2014-08-28T00:00:00.000 | A&C ARMSTRONG CORPORATION | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for DCA fines | 3000 | 2015-05-15T00:00:00.000 |
| 10300-2014-ADJC | 2014-08-28T00:00:00.000 | DECOR RENOVATIONS INC. | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for DCA Fines | 8500 | 2015-03-10T00:00:00.000 |
| 10300-2014-ADJC | 2014-08-28T00:00:00.000 | DECOR RENOVATIONS INC. | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for DCA Fines | 8500 | 2015-03-10T00:00:00.000 |
| 10300-2022-ADJC | 2022-10-28T00:00:00.000 | LONG LIFE INTERIORS, INC."" | Collections Case | Trust Fund Invasion (HIC) - Restitution | Breach of CO between R. and Consumer Consumer restitution. | 7500 | 2022-11-29T00:00:00.000 |
| 10304-2014-ADJC | 2014-08-28T00:00:00.000 | PLANTAGENET HOLDINGS, INC."" | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for DCA Fines | 8109 | 2015-02-26T00:00:00.000 |
| 10378-2014-ADJC | 2014-09-02T00:00:00.000 | SINGH, JARNAIL"" | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for DCA fines | 3250 | 2016-02-23T00:00:00.000 |
| 104-2013-CPLI | 2013-12-30T00:00:00.000 | CHASE LANDSCAPE CONSTRUCTION INC. | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | Restitution Payment | 17000 | 2014-06-24T00:00:00.000 |
| 104-2015-CPLI | 2015-03-23T00:00:00.000 | B. TOWER CONTRACTING CORP. | Home Improvement Contractor - 100 | Trust Fund Invasion (HIC) | TFI for Consumer | 3050 | 2018-12-12T00:00:00.000 |
| 92% |
ALLSTATE RENOVATIONSOK CONSTRUCTION COMPANYWIDE WORLD HOME IMPROVEM…of 16 |
industry | categorical | The category that describes the business activity requiring a DCA license. | 0% | Home Improvement Contrac…Collections CaseTow Truck Company - 124of 4 |
withdrawal_from | categorical | Name of the trust fund from which the monies were withdrawn. | 0% | Trust Fund Invasion (HIC…Trust Fund Invasion (HIC…Trust Fund Invasion (HIC…of 6 |
basis_for_withdrawal | text | Reason for the trust fund invasion. | 0% | TFI for DCA finesTFI for ConsumerTFI for Restitution |
amount | integer | Total amount withdrawn from the trust fund. | 0% | 30001700025000 |
date_completed | datetime | The date the check was received from the NYC Office of the Comptroller | 0% | 2019-06-05T00:00:00.0002018-12-12T00:00:00.0002014-02-04T00:00:00.000 |