From a 500-row sample across 11 columns.
fee_statusrecord_idrecord_type+2record_idbusiness_namerecord_idbusiness_namebusiness_nameindustry| record_id | record_type | business_name | industry | fee_sequence_id | fee_type | fee_description | fee_amount | fee_date | fee_status | business_name2 |
|---|---|---|---|---|---|---|---|---|---|---|
| 0829164-AMPP | Application | DACOSTA, WINSTON | Motion Picture Projectionist - 123 | 1370511 | PLANREVIEW | Plan Review Fee | 60.0 | 1989-01-01T00:00:00.000 | INVOICED | — |
| 0828326-ATTD | Application |
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% | 0511718-ABGO0511102-ABGO0511692-ABGO |
record_type | text | The type of record used by DCA to track internal operations | 0% | ApplicationRenewalAdjudication |
business_name | text | Primary business or Individual name | 0% | PELHAM PARKWAY LITTLE LE…PELHAM PARKWAY LITTLE LE…DUANE READE |
business_name2 | text | If applicable, the Doing-Business-As (DBA), or trade name | 75% |
GET /api/datasets/2k3g-r445 GET /api/datasets/2k3g-r445/quality GET /api/datasets/2k3g-r445/related GET /api/columns?dataset=2k3g-r445
business_namebusiness_name2| MAZZIO, MICHAEL R |
| Tow Truck Driver - 125 |
| 1436584 |
| PLANREVIEW |
| Plan Review Fee |
| 20.0 |
| 1992-01-01T00:00:00.000 |
| INVOICED |
| — |
| 00777032-1-ENFO | Enforcement | JAY AMBAY INC. | Stoop Line Stand - 033 | 240179 | CNV_SI | SI - Certificate of Inspection fee (scales) | 40.0 | 2000-01-01T00:00:00.000 | INVOICED | PATEL BROTHERS |
| 00777033-1-ENFO | Enforcement | ARYANA HALAL MEAT & VEGETABLE, INC. | Grocery-Retail - 808 | 240180 | CNV_SI | SI - Certificate of Inspection fee (scales) | 20.0 | 2000-01-01T00:00:00.000 | INVOICED | — |
| 00777034-1-ENFO | Enforcement | A & N FOOD MARKET, INC. | Electronic Store - 001 | 240181 | CNV_SI | SI - Certificate of Inspection fee (scales) | 220.0 | 2000-01-01T00:00:00.000 | INVOICED | — |
| 00777984-1-ENFO | Enforcement | EAST BRONX FOOD CORP. | Supermarket - 819 | 240524 | CNV_SI | SI - Certificate of Inspection fee (scales) | 140.0 | 2000-01-01T00:00:00.000 | INVOICED | PIONEER SUPERMARKET |
| 00777988-1-ENFO | Enforcement | BAEZ, FRANCISCO | Grocery-Retail - 808 | 240526 | CNV_SI | SI - Certificate of Inspection fee (scales) | 20.0 | 2000-01-01T00:00:00.000 | INVOICED | DAVID GROCERY |
| 00796937-1-ENFO | Enforcement | PETLAND DISCOUNTS, INC. | Restaurant - 818 | 241671 | CNV_SI | SI - Certificate of Inspection fee (scales) | 20.0 | 2000-01-01T00:00:00.000 | INVOICED | PETLAND DISCOUNTS |
| 1-2014-ACRD | Application | 718 HENDERSON FOOD CORP | Tobacco Retail Dealer | 1549540 | LICENSE | Cigarette Retail Dealer License Fee | 110.0 | 2014-01-01T00:00:00.000 | INVOICED | — |
| 14234-2013-ENFO | Enforcement | TREASURE TROVE GIFT & SMOKE SHOP CORP. | Grocery-Retail - 808 | 1549567 | LATE | Scale Late Fee | 100.0 | 2014-01-01T00:00:00.000 | INVOICED | — |
BRONXDALE HALL INCLLOYD BUSINESS LTDCRESCENT HALL INCindustry | text | The category that describes the business | 2% | Home Improvement Contrac…Bingo Game Operator - 08…Home Improvement Salespe… |
fee_sequence_id | integer | The unique system-generated identification number for the DCA fine or fee | 0% | 1125131652384857477 |
fee_type | text | The code associated with the DCA fine or fee | 0% | RENEWALLICENSETRUSTFUNDHIC |
fee_description | text | The description associated with the DCA fine or fee | 0% | Per Game License FeeHome Improvement Contrac…SI - Certificate of Insp… |
fee_amount | float | Dollar amount issued for the DCA fine or fee | 0% | 50.0100.0200.0 |
fee_date | datetime | Date when the DCA fine or fee was applied to the record | 0% | 2017-02-21T00:00:00.0002014-02-25T00:00:00.0002020-03-03T00:00:00.000 |
fee_status | categorical | Status for the DCA fine or fee | 0% | INVOICEDCREDITEDVOIDEDof 4 |