About this Dataset

Housing Maintenance Code Violations NYCHA Properties

This dataset displays violations of the New York City Housing Maintenance Code or New York State Multiple Dwelling Law issued by Housing Inspectors pursuant to inspections of NYCHA buildings at the request of the NYC Housing Court.
Organization: City of New York
Last updated: 2025-09-15T00:41:39.287904
Tags: housing, hpd, nycha, s72, violation

Tables

Table 1

@usgov.city_of_new_york_housing_maintenance_code_violations_n_22b49de3.table_1

75.13 kB
658 rows
35 columns

CREATE TABLE table_1 (
  "violation_id" BIGINT,
  "primary_building_identifier" BIGINT,
  "primary_boro_identifier" BIGINT,
  "primary_borough_name" VARCHAR,
  "primary_house_number" VARCHAR,
  "primary_low_house_number" VARCHAR,
  "primary_high_house_number" VARCHAR,
  "primary_street_name" VARCHAR,
  "primary_postcode" BIGINT,
  "development_name" VARCHAR,
  "tds_number" BIGINT,
  "stairhall_number" BIGINT,
  "nycha_address_section_boroid" BIGINT,
  "nycha_address_section_borough" VARCHAR,
  "nycha_address_section_house_number" VARCHAR,
  "nycha_address_section_street_name" VARCHAR,
  "nycha_address_section_postcode" BIGINT,
  "apartment" VARCHAR,
  "story" BIGINT,
  "block" BIGINT,
  "lot" BIGINT,
  "violation_description" VARCHAR,
  "class" VARCHAR,
  "inspection_date" TIMESTAMP,
  "approved_date" TIMESTAMP,
  "order_number" BIGINT,
  "issued_in_error" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" BIGINT,
  "council_district" BIGINT,
  "bin" BIGINT,
  "bbl" BIGINT,
  "census_tract_2020" BIGINT  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);