From a 500-row sample across 29 columns.
ntabinborough+4census_tractntabin+7Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| sr | request_date | site_street_address | borocode | community_board | block | lot | violation | permit | homeowner_contractor | attempt | violation_issue_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 311-25539416 | 2025-12-11T00:00:00.000 | 1726 RADCLIFF AVE. | 2 | 11 | 4101 | 138 | 34622 | X042025317A38 | C | 1 | 2019-11-21T00:00:00.000 |
| 311-26996465 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sr | text | — | 1% | Construction DBOemail|1|2011-10-25|2023-11-18… |
request_date | datetime | — | 3% | 2023-11-18T00:00:00.0002024-06-27T00:00:00.0002024-10-07T00:00:00.000 |
site_street_address | text | — | 3% | 1319 63RD ST.1359 63RD ST.47-18 SKILLMAN AVE. |
borocode | categorical | — | 3% | 432of 7 |
GET /api/datasets/p4u2-3jgx GET /api/datasets/p4u2-3jgx/quality GET /api/datasets/p4u2-3jgx/related GET /api/columns?dataset=p4u2-3jgx
boroughcensus_tractntabin+6| 2026-04-01T00:00:00.000 |
| 132 W. 27TH ST. |
| 1 |
| 5 |
| 802 |
| 61 |
| 1955 |
| M042026078A18 |
| C |
| 2 |
| 1992-10-21T00:00:00.000 |
| DOT-741250-P2B9 | 2026-04-03T00:00:00.000 | 125 W. 11TH ST. | 1 | 2 | 607 | 58 | 24351 | M042026084A04 | C | 1 | 2012-01-31T00:00:00.000 |
| 311-27137517 | 2026-04-14T00:00:00.000 | 1854 E. 38TH ST. | 3 | 18 | 8481 | 75 | 119664 | B042026099A20 | C | 1 | 2025-09-23T00:00:00.000 |
| 311-27127287 | 2026-04-13T00:00:00.000 | 26-30 CLEARVIEW EXPY. | 4 | 11 | 5981 | 30 | 93579 | Q042026098A22 | C | 1 | 2020-01-27T00:00:00.000 |
| 311-27231232 | 2026-04-22T00:00:00.000 | 1059 E. 102ND ST. | 3 | 18 | 8229 | 17 | 119340 | B042026106A91 | C | 1 | 2025-08-06T00:00:00.000 |
| 311-27237016 | 2026-04-22T00:00:00.000 | 1353 E. 92ND ST. | 3 | 18 | 8238 | 32 | 119358 | B042026110A38 | H | 1 | 2025-08-07T00:00:00.000 |
| 311-27228369 | 2026-04-22T00:00:00.000 | 45-28 196TH ST. | 4 | 11 | 5537 | 100 | 107490 | Q042026075A13 | H | 1 | 2025-09-16T00:00:00.000 |
| 311-27091371 | 2026-04-10T00:00:00.000 | 3026 BRONX PARK E. | 2 | 12 | 4543 | 14 | 36357 | X042026098A17 | H | 1 | 2022-03-15T00:00:00.000 |
| 311-27163673 | 2026-04-16T00:00:00.000 | 401 E. 140TH ST. | 2 | 1 | 2285 | 1 | 23548 | X012026022A13 | C | 1 | 2011-01-07T00:00:00.000 |
Showing 12 of 29 columns. All of them are listed below.
community_board | integer | — | 3% | 1113 |
block | integer | — | 2% | 57337422589 |
lot | integer | — | 3% | 15470 |
violation | integer | — | 3% | 9999999996799868005 |
permit | text | — | 3% | B042011325031B042012005019Q042026176A29 |
homeowner_contractor | text | — | 3% | CH0 |
attempt | categorical | — | 5% | 123of 7 |
violation_issue_date | datetime | — | 5% | 9999-09-09T00:00:00.0002017-06-28T00:00:00.0002018-01-09T00:00:00.000 |
assigned_date | datetime | — | 16% | 2024-07-08T00:00:00.0002018-07-19T00:00:00.0002017-10-30T00:00:00.000 |
inspection_date | datetime | — | 25% | 2019-02-23T00:00:00.0002024-01-27T00:00:00.0002018-12-27T00:00:00.000 |
pass_fail | categorical | — | 25% | PassFail – 4+ Family/Commerc…Fail – No tree defectsof 14 |
reason_for_failure | text | — | 79% | 1,336C |
car_needed_y_n | categorical | — | 4% | NoYesof 2 |
date_results_are_mailed | datetime | — | 37% | 2018-08-10T00:00:00.0002019-01-31T00:00:00.0002019-01-24T00:00:00.000 |
expedited | categorical | — | 4% | NoYesof 2 |
vdd | datetime | — | 80% | 2014-11-12T00:00:00.0002014-07-07T00:00:00.0002014-09-15T00:00:00.000 |
borough | categorical | — | 3% | QUEENSBROOKLYNBRONXof 5 |
postcode | integer | — | 3% | 112191138510314 |
latitude | float | — | 3% | 40.6267840.62640140.746422 |
longitude | float | — | 3% | -73.999694-73.999067-73.916831 |
council_district | integer | — | 3% | 431922 |
bin | integer | — | 4% | 314165631416453000000 |
bbl | integer | — | 4% | 305733007030573300544001360033 |
census_tract | integer | — | 3% | 19261157101 |
nta | text | — | 3% | BK1202QN0103BK1101 |