From a 500-row sample across 10 columns.
project_idbbl| project_id | bbl | validated_borough | validated_block | validated_lot | validated | validated_date | unverified_borough | unverified_block | unverified_lot |
|---|---|---|---|---|---|---|---|---|---|
| P2017X0311 | 2030430008 | Bronx | 3043 | 8 | true | 2021-02-03T21:39:41.000 | Bronx | 3043 | 8 |
| P2017X0311 | 2030430030 | Bronx | 3043 | 30 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
project_id | text | Unique internal application identifier | 0% | 2020R01892019K01992023Q0381 |
bbl | integer | Borough, block and lot number of a tax lot associated to the application. This field consists of the borough code, followed by the tax block, followed by the tax lot. The borough code is one numeric digit. The tax block is one to five numeric digits, preceded with leading zeros when the block is less than five digits. The tax lot is one to four digits and is preceded with leading zeros when the lot is less than four digits. This was validated by Geosupport. | 1% | 400082750140007275014002687501 |
validated_borough | categorical | Borough of a tax lot associated to the application. This was validated by Geosupport. See validated field description for more details. | 0% | Staten IslandBrooklynManhattanof 5 |
GET /api/datasets/2iga-a6mk GET /api/datasets/2iga-a6mk/quality GET /api/datasets/2iga-a6mk/related GET /api/columns?dataset=2iga-a6mk
| true |
| 2021-02-03T21:39:59.000 |
| Bronx |
| 3043 |
| 30 |
| 2025K0154 | 3019900040 | Brooklyn | 1990 | 40 | true | 2025-02-27T19:16:36.000 | Brooklyn | 1990 | 40 |
| 2025K0339 | 3015460001 | Brooklyn | 1546 | 1 | true | 2025-02-28T21:44:13.000 | Brooklyn | 1546 | 1 |
| 2024M0432 | 1017740001 | Manhattan | 1774 | 1 | true | 2025-02-21T00:12:04.000 | Manhattan | 1774 | 1 |
| 2025K0324 | 3009670001 | Brooklyn | 967 | 1 | true | 2025-02-26T17:05:55.000 | Brooklyn | 967 | 1 |
| 2026K0149 | 3070640045 | Brooklyn | 7064 | 45 | true | 2025-09-03T03:12:41.000 | Brooklyn | 7064 | 45 |
| 2026K0149 | 3070160098 | Brooklyn | 7016 | 98 | true | 2025-09-03T03:12:43.000 | Brooklyn | 7016 | 98 |
| 2026K0149 | 3070490108 | Brooklyn | 7049 | 108 | true | 2025-09-03T03:12:47.000 | Brooklyn | 7049 | 108 |
| 2026K0149 | 3070510033 | Brooklyn | 7051 | 33 | true | 2025-09-03T03:12:49.000 | Brooklyn | 7051 | 33 |
validated_block |
| integer |
| Block number of a tax lot associated to the application. This was validated by Geosupport. See validated field description for more details. |
| 0% |
859610612 |
validated_lot | integer | Tax lot number of a tax lot associated to the application. This was validated by Geosupport. See validated field description for more details. | 0% | 175010 |
validated | categorical | Flag that indicates whether the BBL or address data was validated against Geosupport. Geosupport is a geocoding tool that allows for the standardization, validation and processing of geographic locations throughout New York City. | 37% | truefalseof 2 |
validated_date | datetime | Date the Geosupport validation was run. | 1% | 2018-04-10T04:00:00.0002023-04-09T04:00:00.0002025-07-28T18:04:21.000 |
unverified_borough | categorical | Borough of a tax lot associated to the application. This data was manually entered by a user. If validated_borough field is blank then there was not a matching record in Geosupport. See validated field description for more details. | 0% | Staten IslandBrooklynManhattanof 5 |
unverified_block | integer | Block number of a tax lot associated to the application. This data was manually entered by a user. If validated_block field is blank then there was not a matching record in Geosupport. See validated field description for more details. | 2% | 859610612 |
unverified_lot | integer | Tax lot number of a tax lot associated to the application. This data was manually entered by a user. If validated_lot field is blank then there was not a matching record in Geosupport. See validated field description for more details. | 4% | 1730 |