Housing and Development Complaint Problems

$79 / year

This dataset shows the Department of Housing Preservation and Development (HPD) complaints and information about problems associated with complaints.

Complexity

The Department of Housing Preservation and Development (HPD) records complaints that are made by the public through the 311 Citizen Services Center, Code Enforcement Borough Offices or the internet for conditions which violate the New York City Housing Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL). Each complaint is associated with one or more problems reported by the complainant. Problems are closed if a tenant verifies by phone that the condition was corrected or an inspection result is entered by an HPD inspector. A complaint is closed when all associated problems are closed.
Each new file will contain the information about complaints that were opened or closed during the month covered by the file. A complaint will be added to the file based on the date a complaint was received.
Complaints are identified by a ComplaintID. A complaint may be opened in one month and closed in another. In that case there will be an entry identified by the CompaintID in the first month showing that the Complaint was opened and an entry with a matching Complaint ID in the second month showing that the Complaint was closed. If a complaint is opened and closed in the same month, there will be one record for that complaint, showing its creation date as well as its closed status.
Several changes were implemented starting with the file available on October 1, 2013. First, the StatusDate field was added to the Problem element. Second, Complaints are now included if the status of any problem associated with the complaint changes. Third, to facilitate tracking of the lifecycle of complaints with all their problems, the October 1 file contains not only complaints whose status, or the status of any of its problems, changed in September, 2013, but also all complaints that were open as of September 30, 2013.

Date Created

2013-11-19

Last Modified

2018-03-03

Version

2018-03-03

Update Frequency

Monthly

Temporal Coverage

2003-2017

Spatial Coverage

United States

Source

John Snow Labs => Data City of New York

Source License URL

John Snow Labs Standard License

Source License Requirements

N/A

Source Citation

N/A

Keywords

Housing Problems Complaints, Complaint Problems, Housing and Development Complaints, HPD Complaints, Department of Housing Preservation and Development

Other Titles

Problems Associated With Complaints, Housing and Development Complaint Records, Complaint Against Housing Company

Name Description Type Constraints
Problem_IDUnique identifier of this problemintegerlevel : Nominal
Complaint_IDUnique identifier of the complaint this problem is associated withintegerlevel : Nominal
Unit_Type_IDUnique number to identify unit typeintegerlevel : Nominal
Unit_TypeType of unit where the problem was reported (Apartment, Building, Public Area/Park)string-
Space_Type_IDUnique number to identify Space typeintegerlevel : Nominal
Space_TypeType of space where the problem was reportedstring-
Type_IDUnique number to identify Problem Typeintegerlevel : Nominal
TypeNumeric code indicating the problem typestring-
Major_Category_IDUnique number to identify Problem Major Categoryintegerlevel : Nominal
Major_CategoryThe major category of the problemstring-
Minor_Category_IDThe minor category identityintegerlevel : Nominal
Minor_CategoryThe minor categorystring-
Code_IDUnique number to identify problem Codeintegerlevel : Nominal
CodeThe problem codestring-
Status_DateDate when the problem status was updateddate-
Status_DescriptionDescription of Statusstring-
Problem_IDComplaint_IDUnit_Type_IDUnit_TypeSpace_Type_IDSpace_TypeType_IDTypeMajor_Category_IDMajor_CategoryMinor_Category_IDMinor_CategoryCode_IDCodeStatus_DateStatus_Description
15077071724355791APARTMENT542BEDROOM1EMERGENCY10ELECTRIC71WIRING2461ILLEGAL2015-01-31
14898490713740791APARTMENT541BATHROOM1EMERGENCY9PLUMBING66TOILET2796NO WATER2014-12-17
14993514719148091APARTMENT541BATHROOM1EMERGENCY10ELECTRIC71WIRING2589EXPOSED2015-04-06
14932116715668393PUBLIC ARE567KITCHEN1EMERGENCY10ELECTRIC71WIRING2589EXPOSED2014-12-22
15899184767641591APARTMENT541BATHROOM1EMERGENCY9PLUMBING66TOILET2796NO WATER2015-12-01
14548254696768791APARTMENT547LIVING ROOM1EMERGENCY10ELECTRIC71WIRING2589EXPOSED2014-09-29
14763172705625791APARTMENT542BEDROOM1EMERGENCY63UNSANITARY CONDITION375MOLD28172014-11-26
14737029704340391APARTMENT546KITCHEN1EMERGENCY63UNSANITARY CONDITION375MOLD28172015-01-09
14844641710493793PUBLIC ARE555BOILER ROOM1EMERGENCY9PLUMBING367BOILER2781BROKEN2014-12-02
14849622710818093PUBLIC ARE555BOILER ROOM1EMERGENCY9PLUMBING367BOILER2781BROKEN2014-12-02