From a 500-row sample across 16 columns.
zipcommunityboardblock+10zipblockstreetname+5streetcodezipcommunityboard+11registrationidHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| registrationid | buildingid | boroid | boro | housenumber | lowhousenumber | highhousenumber | streetname | streetcode | zip | block | lot |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 825850 | 271859 | 3 | BROOKLYN | 787 | 787 | 787 | EAST 56 STREET | 37280 | 11234 | 7974 | 28 |
| 131572 | 169 | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
registrationid | integer | Unique identifier of Registration | 0% | 911741912547913236 |
buildingid | integer | Unique identifier of building being registered | 0% | 941028940896941039 |
boroid | categorical | Unique identifier of a borough | 0% | 341of 5 |
boro | categorical | Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) | 0% | BROOKLYNQUEENSMANHATTANof 5 |
GET /api/datasets/tesw-yqqr GET /api/datasets/tesw-yqqr/quality GET /api/datasets/tesw-yqqr/related GET /api/columns?dataset=tesw-yqqr
zipblockstreetname+6zipblockstreetname+6zipblockstreetname+5| MANHATTAN |
| 141 |
| 141 |
| 141 |
| 1 AVENUE |
| 10010 |
| 10003 |
| 450 |
| 31 |
| 109808 | 245 | 1 | MANHATTAN | 1576 | 1576 | 1576 | 1 AVENUE | 10010 | 10028 | 1561 | 45 |
| 420463 | 810843 | 4 | QUEENS | 163-15 | 163-15 | 163-19 | 130 AVENUE | 21870 | 11434 | 12495 | 2 |
| 335058 | 383549 | 3 | BROOKLYN | 220 | 220 | 220 | UNION STREET | 86530 | 11231 | 344 | 22 |
| 125763 | 1043 | 1 | MANHATTAN | 1734 | 1734 | 1734 | 2 AVENUE | 10110 | 10128 | 1553 | 2 |
| 137997 | 1699 | 1 | MANHATTAN | 1210 | 1210 | 1216 | 3 AVENUE | 10210 | 10021 | 1405 | 33 |
| 142492 | 8531 | 1 | MANHATTAN | 732 | 732 | 732 | BROADWAY | 13610 | 10003 | 545 | 20 |
| 124742 | 2193 | 1 | MANHATTAN | 340 | 340 | 340 | 3 AVENUE | 10210 | 10010 | 881 | 40 |
| 110059 | 2635 | 1 | MANHATTAN | 2060 | 2060 | 2062 | 5 AVENUE | 10410 | 10035 | 1725 | 33 |
Showing 12 of 16 columns. All of them are listed below.
housenumber | text | Address information for the building | 0% | 152025 |
lowhousenumber | text | Address information for the building | 0% | 152018 |
highhousenumber | text | Address information for the building | 0% | 151920 |
streetname | text | Address information for the building | 0% | BROADWAY3 AVENUE5 AVENUE |
streetcode | integer | Address information for the building | 0% | 01863010110 |
zip | text | Address information for the building | 0% | 113851122111215 |
block | integer | Tax block for building | 0% | 711734328276 |
lot | integer | Tax lot for building | 0% | 175012 |
bin | integer | DCP Building Identification Number for building | 0% | 030000004445478 |
communityboard | integer | Community Board for building | 0% | 1312 |
lastregistrationdate | datetime | Date on which the registration information was processed | 2% | 2025-09-05T00:00:00.0002025-08-26T00:00:00.0002025-10-11T00:00:00.000 |
registrationenddate | datetime | Expiration date of registration record | 0% | 2026-09-01T00:00:00.0002027-09-01T00:00:00.0002025-09-01T00:00:00.000 |