From a 500-row sample across 22 columns.
housenumberzipblock+5housenumberzipblock+5housenumberzipblock+11housenumberzipblock+10Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| litigationid | buildingid | boroid | housenumber | streetname | zip | block | lot | casetype | caseopendate | casestatus | casejudgement |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 413007 | 1296 | 1 | 231 | 2 AVENUE | 10003 | 896 | 23 | Heat and Hot Water | 2023-04-20T00:00:00.000 | CLOSED | NO |
| 177972 | 807587 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
litigationid | integer | Unique number identifying the case | 0% | 172225 |
buildingid | integer | Unique identifier of building | 0% | 80688611674065175 |
boroid | categorical | unique identifier of Borough | 0% | 321of 5 |
housenumber | text | Principle house number | 0% | 201540 |
streetname | text |
GET /api/datasets/59kj-x8nc GET /api/datasets/59kj-x8nc/quality GET /api/datasets/59kj-x8nc/related GET /api/columns?dataset=59kj-x8nc
housenumberzipblock+9housenumberzipblock+11blockntalongitude+6| 3 |
| 5532 |
| AVENUE D |
| 11203 |
| 7930 |
| 1 |
| Tenant Action |
| 2012-01-18T00:00:00.000 |
| CLOSED |
| NO |
| 452674 | 927015 | 1 | 227 | CHERRY STREET | 10002 | 248 | 7501 | Tenant Action | 2024-04-04T00:00:00.000 | CLOSED | NO |
| 454835 | 62863 | 2 | 759 | EAST 138 STREET | 10454 | 2590 | 102 | Tenant Action/Harrassment | 2024-05-23T00:00:00.000 | CLOSED | NO |
| 30911 | 85879 | 2 | 2736 | HOLLAND AVENUE | 10467 | 4511 | 18 | Tenant Action | 2006-03-21T00:00:00.000 | CLOSED | NO |
| 435419 | 808406 | 3 | 995 | GATES AVENUE | 11221 | 1633 | 60 | Heat and Hot Water | 2023-12-05T00:00:00.000 | CLOSED | NO |
| 461230 | 808952 | 3 | 1355 | NEW YORK AVENUE | 11203 | 4967 | 40 | Tenant Action | 2024-08-21T00:00:00.000 | CLOSED | NO |
| 244856 | 42893 | 1 | 526 | WEST 161 STREET | 10032 | 2119 | 23 | False Certification Non-Lead | 2015-04-09T00:00:00.000 | CLOSED | NO |
| 365983 | 838088 | 4 | 102-27 | 135 STREET | 11419 | 9503 | 59 | Heat and Hot Water | 2020-01-13T00:00:00.000 | CLOSED | NO |
| 426386 | 981192 | 3 | 910 | HENDRIX PLACE | 11207 | 4375 | 1 | Tenant Action | 2023-06-06T00:00:00.000 | CLOSED | NO |
Showing 12 of 21 columns. All of them are listed below.
| The normalized street name associated with a given Geosupport Information System (GIS) Street Code |
| 0% |
GRAND CONCOURSEBROADWAYMORRIS AVENUE |
zip | text | Zipcode for the property | 0% | 112261045810453 |
block | integer | Number assigned by DoF identifying the tax block the lot is on | 0% | 191824563304 |
lot | integer | Unique number assigned by DoF within a block identifying a lot | 0% | 1296 |
casetype | categorical | The purpose of the litigation | 0% | Tenant ActionHeat and Hot WaterTenant Action/Harrassmen…of 14 |
caseopendate | datetime | Date the case was opened | 0% | 2010-01-13T00:00:00.0002007-11-28T00:00:00.0002009-01-21T00:00:00.000 |
casestatus | text | The status of the case | 0% | CLOSEDPENDINGAPPLICATION PENDING |
casejudgement | categorical | The final judgment if any for this case | 0% | NOYESof 2 |
findingofharassment | categorical | — | 96% | No HarassmentAfter InquestAfter Trialof 3 |
findingdate | date | — | 100% | 05/18/2018 00:00:0012/05/2023 00:00:0007/11/2024 00:00:00 |
penalty | text | — | 100% | 200005000 |
respondent | text | — | 1% | VED PARKASHWAVECREST MANAGEMENTRIVERBAY CORPORATION |
latitude | coordinate | — | 0% | 40.851719040.834676040.8326130 |
longitude | coordinate | — | 0% | -73.922780-73.930268-73.904675 |
community_district | categorical | — | 0% | 1245of 18 |
council_district | text | — | 0% | 151614 |
census_tract | text | — | 0% | 245225253 |
bin | text | — | 0% | 200000030000001000000 |
bbl | text | — | 0% | 202882022930427100014159260001 |
nta | text | — | 0% | Concourse-Concourse Vill…Crown Heights (North)Harlem (North) |