From a 500-row sample across 35 columns.
boroziplot+5lotlatitudelongitude+6ziplotlatitude+6boroziplot+8Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| viol_seq_no | bldg_id | boro | boro_nm | phn | low_hus_no | high_hus_no | str_nm | zip | development_name | tds_no | stairhall_no |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 18220152 | 808768 | 3 | BROOKLYN | 1 | 1 | 17 | LORRAINE STREET | 11231 | RED HOOK WEST | 79 | 84 |
| 18220153 | 808768 | 3 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
viol_seq_no | integer | Unique identifier of Violation | 0% | 182174751821747618217477 |
bldg_id | integer | Unique identifier of a building assigned by HPD | 0% | 807999805285810254 |
boro | categorical | Borough code of the primary address identified by HPD | 0% | 134of 5 |
boro_nm | categorical | The borough of the primary address where the building is located | 0% | MANHATTANBROOKLYNQUEENSof 5 |
GET /api/datasets/im9z-53hg GET /api/datasets/im9z-53hg/quality GET /api/datasets/im9z-53hg/related GET /api/columns?dataset=im9z-53hg
latitudelongitudecommunity_board+4boroziplot+1ziplotlatitude+5boroziplot+1| BROOKLYN |
| 1 |
| 1 |
| 17 |
| LORRAINE STREET |
| 11231 |
| RED HOOK WEST |
| 79 |
| 84 |
| 18220154 | 808768 | 3 | BROOKLYN | 1 | 1 | 17 | LORRAINE STREET | 11231 | RED HOOK WEST | 79 | 84 |
| 18223815 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
| 18223816 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
| 18223817 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
| 18223818 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
| 18223819 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
| 18223820 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
| 18223821 | 286990 | 3 | BROOKLYN | 621 | 615 | 621 | EAST 105 STREET | 11236 | BREUKELEN | 56 | 64 |
Showing 12 of 35 columns. All of them are listed below.
phn | text | The street number in the building's primary address. E.g.: the house number is '100' in '100 Gold Street' | 0% | 466237080 |
low_hus_no | text | If there is a range for a building, the lowest house number in the building’s primary address. | 0% | 70502370 |
high_hus_no | text | If there is a range for a building, the highest house number in the building’s primary address. | 0% | 237047227-25 |
str_nm | text | The name of the street in the building's address. E.g.: the street name is 'Gold Street' in '100 Gold Street' | 0% | COLUMBIA STREETEAST 105 STREETEAST 115 STREET |
zip | text | The postcode where the building is located | 0% | 100291123110002 |
development_name | text | The NYCHA development name. | 0% | RED HOOK WESTWAGNERRED HOOK EAST |
tds_no | integer | The Tenant Data System number is a unique identifier generated by NYCHA for each development. | 0% | 79744 |
stairhall_no | text | The NYCHA Stairhall number. | 0% | 241 |
sctn_boro | categorical | Borough code of the section address identified by NYCHA | 0% | 134of 5 |
sctn_boro_nm | categorical | The borough of the section address where the building is located | 0% | MANHATTANBROOKLYNQUEENSof 5 |
sctn_hus_no | text | The street number in the building's section address identified by NYCHA. E.g.: the house number is '100' in '100 Gold Street' | 0% | 70237050 |
sctn_str_nm | text | The name of the street in the building's section address identified by NYCHA. E.g.: the street name is 'Gold Street' in '100 Gold Street' | 0% | COLUMBIA STREET2ND AVENUEEAST 105 STREET |
sctn_zip | text | The postcode of the section address where the building is located | 0% | 100291123110002 |
actl_unit_insp | text | Apartment in violation, if applicable | 1% | 1B2A4A |
actl_stry | text | Floor of violation | 0% | 124 |
blk | text | Tax block for building | 0% | 005380053301797 |
lot | text | Tax lot for building | 0% | 000101010002 |
viol_desc | text | Description of the violation | 0% | § 27-2005, 27-2007, 27-2…§ 27-2005, 27-2007, 27-2…§ 27-2005 ADM CODE REPA… |
hzrd_clas | categorical | The class of a violation describes it’s degree of hazard. In the Housing Maintenance Code, there are three classes of violation: class A (non-hazardous), class B (hazardous) and class C (immediately hazardous). The period in which a landlord is required to correct the condition depends on the class of violation and, for class C violations, the type of violation. A class A violation has a correction period of 90 days. A class B violation has a correction period of 30 days. Class C immediatel | 0% | BACof 3 |
insp_dt | datetime | Date when the violating condition was physically observed by a uniformed HPD Housing Inspector. | 0% | 2025-09-22T00:00:00.0002026-05-13T00:00:00.0002026-04-28T00:00:00.000 |
viol_appr_dt | datetime | Date when the violation was approved to be issued according to HPD's procedures for reviewing/approving violations. | 0% | 2026-04-29T00:00:00.0002025-09-22T00:00:00.0002026-05-08T00:00:00.000 |
viol_typ_ordr_no | text | Reference to the abstract description of the violation condition which cites a specific section of the law which is in violation | 0% | 508502501 |
issued_in_err | categorical | "Y" indicates that HPD issued the violation in error. These violation are not considered on record. | 0% | NYof 2 |
latitude | float | Latitude of the site's location | 0% | 40.67579640.80035940.774993 |
longitude | float | Longitude of the site's location | 0% | -74.007163-73.935217-73.936448 |
community_board | integer | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. Note: as a column header, “Community Board” ( | 0% | 111103306 |
council_district | integer | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. | 0% | 8382 |
bin | integer | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 1% | 332697710812764430784 |
bbl | integer | he BBL (Borough, Block, and Lot) is a combination of three numeric codes - a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 1% | 300538000130053300011017970001 |
census_tract | integer | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped. | 0% | 8525194 |
nta | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv | 0% | MN1102BK0601MN1101 |