Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Bedbug Reporting

wz6d-d3jbHousing & Development21 columns
Property owners are required to obtain bedbug infestation history from tenants or a dwelling unit owner. This dataset captures the bedbug infestation history as reported by the property owner. Local Law 69 of 2017 requires that all multiple dwelling property owners must attempt to obtain the bed bug infestation history from the tenant or unit owner, including whether eradication measures were employed for a bedbug infestation. The information reported in this file is self-reported information filed annually by property owners. Once the Bed Bug Annual Report has been filed, the property owner is required to either provide the filing receipt to each tenant (upon commencement of a new lease and with each lease renewal) OR post the filing receipt in a prominent location in the building. In addition, the property owner must either distribute to each tenant or post the DOHMH Preventing and Getting Rid of Bedbugs Safely guide, which provides information on the prevention, detection, and removal of bedbugs. Each record in the file represents a filing completed. If a property has submitted two records for the same period, the second filing is the active final submission for the period.
View on NYC Open Data↗

Quality

A90.4 / 100

From a 500-row sample across 21 columns.

completeness100/ 25% weight
consistency57/ 20% weight
accuracy96/ 20% weight
timeliness98/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Buildings Selected for the Alternative Enforcement Program (AEP)0.40
    joins onbuilding_idntabbl+5
  • Multiple Dwelling Registrations0.39
    joins onbin
  • Order to Repair/Vacate Orders0.39
    joins onbuilding_idntabbl+7
  • DOB NOW: Certificate of Occupancy0.38
    joins onboroughbblbin+4
  • Housing Litigations

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

building_idregistration_idboroughhouse_numberstreet_namepostcodeof_dwelling_unitsinfested_dwelling_unit_counteradicated_unit_countre_infested_dwelling_unitfiling_datefiling_period_start_date
344156306009BROOKLYN161NEWEL STREET1122260002021-02-16T00:00:00.0002019-11-01T00:00:00.000

Columns

21 queryable · 21 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
building_idtextUnique identifier of building0%304979145968171617
registration_idtextUnique identifier of valid registration information0%0920659388794
boroughcategorical—0%BROOKLYNMANHATTANQUEENSof 5
house_numbertextThe street number in the building's address.0%11510015

Query this from your own app

GET /api/datasets/wz6d-d3jb
GET /api/datasets/wz6d-d3jb/quality
GET /api/datasets/wz6d-d3jb/related
GET /api/columns?dataset=wz6d-d3jb
0.38
joins onntabblbin+2
  • Housing Maintenance Code Complaints and Problems0.37
    joins onboroughbuilding_idnta+7
  • DOB Certificate Of Occupancy0.37
    joins onboroughntabbl+7
  • DOB NOW: Safety Boiler0.36
    • 733380500790STATEN ISLAND300EDGEWATER STREET10305110002024-02-16T00:00:00.0002022-11-01T00:00:00.000
    355173322333BROOKLYN121PRESIDENT STREET1123140002024-04-19T00:00:00.0002022-11-01T00:00:00.000
    924358346557BROOKLYN2327 AVENUE1121560002023-12-26T00:00:00.0002022-11-01T00:00:00.000
    296385304339BROOKLYN147FROST STREET1121130002025-08-20T00:00:00.0002023-11-01T00:00:00.000
    358122357464BROOKLYN389PUTNAM AVENUE1121630002023-07-10T00:00:00.0002021-11-01T00:00:00.000
    705843403865QUEENS861WOODWARD AVENUE1138540002021-05-05T00:00:00.0002019-11-01T00:00:00.000
    877716379778BROOKLYN912MOTHER GASTON BOULEVARD1121230002023-07-06T00:00:00.0002021-11-01T00:00:00.000
    233155302281BROOKLYN45DIAMOND STREET1122260002019-02-07T00:00:00.0002017-11-01T00:00:00.000
    29583611270MANHATTAN269WEST 4 STREET1001420002019-12-20T00:00:00.0002018-11-01T00:00:00.000

    Showing 12 of 21 columns. All of them are listed below.

    street_name
    text
    The name of the street in the building's address.
    0%
    BROADWAY3 AVENUE5 AVENUE
    postcodetext—0%113851121511221
    of_dwelling_unitsintegerTotal unit count in the building on file with HPD.0%346
    infested_dwelling_unit_countintegerNumber of units in the building that had bedbugs during the reporting period, as reported by the building owner.0%012
    eradicated_unit_countintegerNumber of units in the building where bedbugs had been eradicated but had returned after treatment, as reported by the building owner.0%013
    re_infested_dwelling_unitintegerNumber of units in the building where bedbugs had been eradicated, as reported by the building owner.0%013
    filing_datedatetimeFiling date of the report.0%2023-12-06T00:00:00.0002025-12-02T00:00:00.0002023-12-05T00:00:00.000
    filing_period_start_datedatetimeStart of the period for which the owner is reporting results.0%2023-11-01T00:00:00.0002022-11-01T00:00:00.0002024-11-01T00:00:00.000of 8
    filling_period_end_datedatetimeEnd of the period for which the owner is reporting results.0%2024-10-31T00:00:00.0002023-10-31T00:00:00.0002025-10-31T00:00:00.000of 8
    latitudecoordinateLatitude of the building's location.0%40.65657140.74651740.766537
    longitudecoordinateLongitude of the building's location.0%-73.906492-73.898552-73.999751
    community_boardcategoricalThe Community Board field indicates the New York City Community District where the building is located.0%134of 19
    city_council_districttextThe Council District field indicates the New York City Council District where the building is located.0%393433
    census_tract_2010textThe Census Tract field indicates the U.S. Census Tract where the building is located.0%3965159
    bintextThe BIN (Building Identification Number) is a unique identifier for each building in the City.0%300000010000002000000
    bbltextThe BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City.0%406715000240584375035005950015
    ntatextThe Neighborhood Tabulation Area field indicates the New York City Neighborhood area where the building is located.0%RidgewoodBedford-Stuyvesant (West…Park Slope