From a 500-row sample across 15 columns.
business_unique_iddba_trade_namebusiness_namebusiness_categorybusiness_unique_iddba_trade_name+2business_categorybusiness_unique_iddba_trade_name+1business_categorybusiness_unique_iddba_trade_name+1| dcwp_license_number | business_name | business_category | business_unique_id | asset_type | business_asset_id | state_of_registration | dcwp_plate_number | decal_number | latest_inspection_number | latest_inspection_date | latest_inspection_result |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0624070-DCA | GIUSEPPE, D'ONOFRIO | Horse Drawn Cab Owner | BA-1366401-2022 | Horse Drawn Cab | BAP-117953 | NY | 1076 | 4348 | INS-000879933 | 2025-09-18T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dcwp_license_number | text | The DCWP-issued license number associated with the business operating the vehicles. | 0% | 2005061-DCA0833070-DCA1413726-DCA |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk. | 0% | TAXI TOURS INCBREEN BROS. TOWING, INC.GO NEW YORK TOURS INC |
business_category | categorical | The business activity or business category requiring a DCWP-issued license in order to operate legally within NYC. | 0% | Tow Truck CompanyPedicab BusinessSightseeing Busof 4 |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. |
GET /api/datasets/9vpn-rpgs GET /api/datasets/9vpn-rpgs/quality GET /api/datasets/9vpn-rpgs/related GET /api/columns?dataset=9vpn-rpgs
business_categorybusiness_unique_iddba_trade_name+1business_categorybusiness_unique_idbusiness_name| Pass |
| 0624070-DCA | GIUSEPPE, D'ONOFRIO | Horse Drawn Cab Owner | BA-1366401-2022 | Horse Drawn Cab | BAP-117953 | — | — | — | INS-000913379 | 2026-01-22T00:00:00.000 | Pass |
| 0675662-DCA | A.T. COACH CORPORATION | Horse Drawn Cab Owner | BA-1110064-2022 | Horse Drawn Cab | BAP-119143 | NY | 1073 | 4354 | INS-000879901 | 2025-09-18T00:00:00.000 | Pass |
| 0675662-DCA | A.T. COACH CORPORATION | Horse Drawn Cab Owner | BA-1766085-2026 | Horse Drawn Cab | BAP-119143 | NY | 1073 | 4354 | INS-000879901 | 2025-09-18T00:00:00.000 | Pass |
| 0832833-DCA | D. MAC ARTHUR AUTO BODY LTD. | Tow Truck Company | BA-1225585-2022 | Tow Truck | BAP-118106 | NY | 7853 | — | INS-000729947 | 2024-04-16T00:00:00.000 | Pass |
| 0832833-DCA | D. MAC ARTHUR AUTO BODY LTD. | Tow Truck Company | BA-1225585-2022 | Tow Truck | BAP-119238 | NY | 5153 | — | INS-000729946 | 2024-04-16T00:00:00.000 | Pass |
| 0832835-DCA | SCUFFY'S COLLISION INC. | Tow Truck Company | BA-1539279-2022 | Tow Truck | BAP-109213 | NY | 5191 | — | INS-000750967 | 2024-06-04T00:00:00.000 | Pass |
| 0832835-DCA | SCUFFY'S COLLISION INC. | Tow Truck Company | BA-1539279-2022 | Tow Truck | BAP-109611 | NY | 8051 | — | INS-000749940 | 2024-06-04T00:00:00.000 | Pass |
| 0832835-DCA | SCUFFY'S COLLISION INC. | Tow Truck Company | BA-1539279-2022 | Tow Truck | BAP-109676 | NY | 5352 | — | INS-000749942 | 2024-06-04T00:00:00.000 | Pass |
| 0832835-DCA | SCUFFY'S COLLISION INC. | Tow Truck Company | BA-1539279-2022 | Tow Truck | BAP-113053 | NY | 8751 | — | INS-000749948 | 2024-06-04T00:00:00.000 | Pass |
Showing 12 of 15 columns. All of them are listed below.
| 0% |
BA-1559006-2022BA-1107544-2022BA-1310315-2022 |
dba_trade_name | text | If applicable, the Doing-Business-As (DBA), or trade name of the business. | 84% | Big Bus Tours New YorkTOPVIEW SIGHTSEEINGpedicab |
asset_type | categorical | The type of vehicle | 0% | Tow TruckPedicabSightseeing Busof 4 |
business_asset_id | text | An identification number assigned by DCWP to track vehicles across its systems. | 0% | BAP-119462BAP-119603BAP-119676 |
manufacture_identification_number | text | A unique serial number assigned by the vehicle's manufacturer that identifies the manufacturer, year of production, place of production and other vehicle characteristics. | 0% | 1FVACXFE6PHNX28615PVNJ7AP7S5T508055PVNJ8JP4K4S52620 |
dmv_license_plate_number | text | The license plate number issued by the state of registration's department of motor vehicles or transportation. | 33% | 18202TV10892TV17266TV |
state_of_registration | categorical | The state issuing the DMV License Plate | 8% | NYNJMDof 5 |
dcwp_plate_number | text | The plate number issued to the vehicle by DCWP. | 24% | 903890549100 |
decal_number | text | An identification number issued by DCWP, which is either in lieu of or in addition to the DCWP Plate Number. | 58% | 171117021629 |
latest_inspection_number | text | An identification number associated with the vehicle's most recent inspection. | 0% | INS-000944860INS-000944861INS-000891346 |
latest_inspection_date | datetime | The date of the vehicle's most recent inspection. | 0% | 2026-04-23T00:00:00.0002025-10-08T00:00:00.0002025-11-25T00:00:00.000 |
latest_inspection_result | categorical | The result of the vehicle's most recent inspection. | 0% | PassFailof 2 |