From a 500-row sample across 41 columns.
blocklotstreetname+9blocklotstreetname+11binbbllatitude+1blocklotstreetname+11Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| violationid | buildingid | registrationid | boroid | boro | housenumber | lowhousenumber | highhousenumber | streetname | streetcode | zip | apartment |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10081311 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | 5 |
| 10299683 | 375411 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
violationid | integer | Unique identifier of Violation | 0% | 110977110978110979 |
buildingid | integer | Unique identifier of building | 0% | 11194565537119285 |
registrationid | integer | Unique identifier of valid registration information | 0% | 0205779207907 |
boroid | categorical | unique number to identify borough | 0% | 321of 5 |
boro |
GET /api/datasets/wvxf-dwi5 GET /api/datasets/wvxf-dwi5/quality GET /api/datasets/wvxf-dwi5/related GET /api/columns?dataset=wvxf-dwi5
apartmentblocklot+10blocklotbin+4blocklotbin+4registrationid| 306067 |
| 3 |
| BROOKLYN |
| 22 FRONT |
| 22 FRON |
| 22 FRONT |
| STAGG STREET |
| 80930 |
| 11206 |
| 1F |
| 10299685 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | 1F |
| 10299686 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | 1F |
| 10299690 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | 1F |
| 10600720 | 805012 | 100420 | 1 | MANHATTAN | 144REAR | 144rear | 146 REAR | LUDLOW STREET | 25090 | 10002 | — |
| 10767483 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | — |
| 10767484 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | — |
| 10842512 | 375411 | 306067 | 3 | BROOKLYN | 22 FRONT | 22 FRON | 22 FRONT | STAGG STREET | 80930 | 11206 | 1 |
| 10013160 | 68995 | 222908 | 2 | BRONX | 642 | 642 | 642 | EAST 220 STREET | 28230 | 10467 | — |
Showing 12 of 38 columns. All of them are listed below.
| categorical |
| Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) |
| 0% |
BROOKLYNBRONXMANHATTANof 5 |
housenumber | text | Address information for the building | 0% | 2015125 |
lowhousenumber | text | Address information for the building | 0% | 1220 |
highhousenumber | text | Address information for the building | 0% | 2015130 |
streetname | text | Address information for the building | 0% | GRAND CONCOURSEBROADWAYOCEAN AVENUE |
streetcode | text | Address information for the building | 0% | 364206753013610 |
zip | text | Address information for the building | 0% | 112261045810457 |
apartment | text | Apartment with violation, if applicable | 32% | 213 |
story | text | Floor of violation | 18% | 123 |
block | integer | Tax block for building | 0% | 213619882170 |
lot | integer | Tax lot for building | 0% | 1640 |
class | categorical | Indicator of seriousness of the violations, where A is the least serious and C is the most serious | 0% | BACof 4 |
inspectiondate | datetime | Date when the violation was observed | 0% | 2021-04-02T00:00:00.0002021-04-01T00:00:00.0002022-03-01T00:00:00.000 |
approveddate | datetime | Date when violation was approved | 0% | 2021-04-02T00:00:00.0002021-04-01T00:00:00.0002022-03-01T00:00:00.000 |
originalcertifybydate | datetime | Original date by when the owner was to inform HPD that the violation as corrected | 7% | 2008-07-24T00:00:00.0002006-11-26T00:00:00.0002008-07-23T00:00:00.000 |
originalcorrectbydate | datetime | Original date by when the owner was to correct the violation | 7% | 2008-07-10T00:00:00.0002006-11-12T00:00:00.0002008-07-09T00:00:00.000 |
newcertifybydate | datetime | Modified date by when the owner was to inform HPD that the violation as corrected | 99% | 1982-08-18T00:00:00.0001982-08-09T00:00:00.0002022-12-20T00:00:00.000 |
newcorrectbydate | datetime | Modified date by when the owner was to correct the violation | 99% | 1982-08-01T00:00:00.0002022-12-15T00:00:00.0002022-09-15T00:00:00.000 |
certifieddate | datetime | Date when the violation was certified (if it was) | 66% | 2020-01-08T00:00:00.0002019-03-13T00:00:00.0002019-11-19T00:00:00.000 |
ordernumber | text | Reference to the abstract description of the violation condition which cites a specific section of the law which is in violation | 0% | 508780502 |
novid | integer | Unique identifier of the Notice of Violation sent to the owner | 7% | 273067629607172174995 |
novdescription | text | Description of the violation | 0% | SECTION27-2107 ADM CODE …(A) � HMC:FILE ANNUAL …(A) � HMC:FILE ANNUAL … |
novissueddate | datetime | Date when the NOV was sent | 7% | 2006-07-28T00:00:00.0002008-06-05T00:00:00.0002006-07-03T00:00:00.000 |
currentstatusid | integer | unique id to identify current status | 0% | 1992 |
currentstatus | text | Violation status (see below for details) | 0% | VIOLATION CLOSEDVIOLATION DISMISSEDNOV SENT OUT |
currentstatusdate | datetime | Date when the current status when into effect | 0% | 2006-07-03T00:00:00.0002008-06-05T00:00:00.0002007-06-06T00:00:00.000 |
novtype | categorical | Original / Reissued Notice of Violation. For more information on the Reissuance process, see http://www1.nyc.gov/site/hpd/owners/compliance-clear-violations.page . | 7% | OriginalReissuedof 2 |
violationstatus | categorical | Status of Violation(Open / Close) | 0% | CloseOpenof 2 |
rentimpairing | categorical | A rent-impairing violation is a condition within a multiple dwelling which constitutes, or if not promptly corrected will constitute, a fire hazard or a serious threat to the life, health or safety of occupants thereof (New York State Multiple Dwelling Law Section 302). | 0% | NYof 2 |
latitude | coordinate | The latitude associated with the provided entity location. | 0% | 40.82796640.83258440.829399 |
longitude | coordinate | The longitude associated with the provided entity location. | 0% | -73.875222-73.922802-73.869201 |
communityboard | categorical | The NYC community board associated with the provided entity location (numbered 1 – 59. | 0% | 1245of 18 |
councildistrict | text | The NYC council district associated with the provided entity location (numbered 1 – 51). | 0% | 151436 |
censustract | text | The US census tract associated with the provided entity location (in the format of up to four-digit integers, followed by an optional two-digit suffix; e.g., “15.02” or “319”). | 0% | 225245261 |
bin | text | The Building Identification Number (BIN) associated with the provided entity location. It is formatted as a seven-digit numerical identifier, which is unique to each building in NYC. | 0% | 300000020239941000000 |
bbl | text | The Borough, Block, Lot (BBL) associated with the provided entity location. It is formatted as a ten-digit numerical identifier, which is unique to each parcel of real property in NYC. | 0% | 304271900120288202294159260001 |
nta | text | The Neighborhood Tabulation Area (NTA) associated with the provided entity location, which is formatted as a two-letter borough identifier followed by a two-digit numerical identifier (e.g., “BX31”). | 0% | Crown Heights NorthFlatbushWashington Heights South |