About this Dataset

Multiple Dwelling Registrations

Pursuant to New York City’s Housing Maintenance Code, the Department of Housing
Preservation and Development (HPD) collects registration information from owners of
residential rental units. Owners are required to register if they own residential buildings
with three or more units or if they own one- or two-family homes and neither they nor
members of their immediate family live there. Registrations are required upon taking
ownership of a qualifying building, and once a year thereafter.
Organization: City of New York
Last updated: 2020-11-10T17:05:21.476639
Tags: department-of-housing-preservation-and-development, hpd, registrations

Tables

Table 1

@usgov.city_of_new_york_multiple_dwelling_registrations.table_1

8.07 MB
198,888 rows
16 columns

CREATE TABLE table_1 (
  "registrationid" BIGINT,
  "buildingid" BIGINT,
  "boroid" BIGINT,
  "boro" VARCHAR,
  "housenumber" VARCHAR,
  "lowhousenumber" VARCHAR,
  "highhousenumber" VARCHAR,
  "streetname" VARCHAR,
  "streetcode" BIGINT,
  "zip" DOUBLE,
  "block" BIGINT,
  "lot" BIGINT,
  "bin" DOUBLE,
  "communityboard" BIGINT,
  "lastregistrationdate" TIMESTAMP,
  "registrationenddate" TIMESTAMP
);