From a 500-row sample across 8 columns.
house_numberbindobrundate+2binstreet_namecommunity_boardbinstreet_namehouse_numberbincommunity_boardHas borough codes (`borough_name`) — joinable, but needs boundary shapes to draw.
| borough_name | community_board | bin | house_number | street_name | complaint_number | date_complaint_received | dobrundate |
|---|---|---|---|---|---|---|---|
| Bronx | 201 | 2003952 | 522 | WALES AVENUE | 2189415 | 2013-08-29T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 202 | 2130687 | 1109 | INTERVALE AVENUE | 2189417 | 2013-08-29T00:00:00.000 | 2026-10-15T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough_name | categorical | 1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island | 0% | BrooklynQueensManhattanof 5 |
community_board | text | 3-digit identifier: Borough code = first position, last 2 = community board | 0% | 414301111 |
bin | text | Number assigned by City Planning to a specific building | 0% | 180305210905921076762 |
house_number | text | House Number of Residence or Commercial Property | 0% | 103 410 |
GET /api/datasets/i296-73x5 GET /api/datasets/i296-73x5/quality GET /api/datasets/i296-73x5/related GET /api/columns?dataset=i296-73x5
house_numberbinstreet_name+1bincommunity_boardhouse_numberbin| Bronx | 203 | 2829458 | 3336 | 3 AVENUE | 2189420 | 2013-08-29T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 204 | 2003532 | 1328 | UNIVERSITY AVENUE | 2148626 | 2010-08-07T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 205 | 2828919 | 23 | FEATHERBED LANE | 2189422 | 2013-08-29T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 205 | 2129190 | 21 | FEATHERBED LANE | 2189421 | 2013-08-29T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 205 | 2816467 | 1646 | UNIVERSITY AVENUE | 2186733 | 2013-06-25T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 205 | 2129640 | 1665 | JEROME AVENUE | 2186736 | 2013-06-25T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 205 | 2009092 | 175 | WEST TREMONT AVENUE | 2175960 | 2012-08-01T00:00:00.000 | 2026-10-15T00:00:00.000 |
| Bronx | 206 | 2011570 | 2243 | BATHGATE AVENUE | 2147367 | 2010-07-08T00:00:00.000 | 2026-10-15T00:00:00.000 |
109 street_name | text | Street Name where Property is located | 0% | SEAGIRT AVENUE …SEAGIRT BOULEVARD …BEACH CHANNEL DRIVE … |
complaint_number | text | Complaint number starting with borough code: (1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) | 0% | 125284512527751275678 |
date_complaint_received | datetime | Date Complaint Received | 0% | 2012-02-09T00:00:00.0002009-04-02T00:00:00.0002012-04-30T00:00:00.000 |
dobrundate | datetime | Date when query is run and pushed to Open Data. Could be used to differentiate report dates. | 0% | 2024-06-17T00:00:00.0002024-06-18T00:00:00.0002024-06-11T00:00:00.000 |