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. </p> 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.
This dataset has the following 21 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Building ID | building_id | text | Unique identifier of building | 17864 34772 23270 155 810872 view top 100 |
| Registration ID | registration_id | text | Unique identifier of valid registration information | 0 920659 116040 108094 402311 view top 100 |
| Borough | borough | text | BROOKLYN MANHATTAN QUEENS BRONX STATEN ISLAND view top 100 | |
| House Number | house_number | text | The street number in the building's address. | 115 100 25 15 20 view top 100 |
| Street Name | street_name | text | The name of the street in the building's address. | BROADWAY 3 AVENUE 2 AVENUE 5 AVENUE 1 AVENUE view top 100 |
| Postcode | postcode | text | 11385 11215 11221 11222 11237 view top 100 | |
| # of Dwelling Units | of_dwelling_units | number | Total unit count in the building on file with HPD. | 3 4 6 8 5 view top 100 |
| Infested Dwelling Unit Count | infested_dwelling_unit_count | number | Number of units in the building that had bedbugs during the reporting period, as reported by the building owner. | 0 1 2 3 4 view top 100 |
| Eradicated Unit Count | eradicated_unit_count | number | Number of units in the building where bedbugs had been eradicated but had returned after treatment, as reported by the building owner. | 0 1 2 3 4 view top 100 |
| Re-infested Dwelling Unit Count | re_infested_dwelling_unit | number | Number of units in the building where bedbugs had been eradicated, as reported by the building owner. | 0 1 3 2 4 view top 100 |
| Filing Date | filing_date | calendar_date | Filing date of the report. | 2023-12-06T00:00:00.000 2023-12-05T00:00:00.000 2023-12-07T00:00:00.000 2023-12-04T00:00:00.000 2022-12-01T00:00:00.000 view top 100 |
| Filing Period Start Date | filing_period_start_date | calendar_date | Start of the period for which the owner is reporting results. | 2021-11-01T00:00:00.000 2020-11-01T00:00:00.000 2019-11-01T00:00:00.000 2022-11-01T00:00:00.000 2017-11-01T00:00:00.000 view top 100 |
| Filling Period End Date | filling_period_end_date | calendar_date | End of the period for which the owner is reporting results. | 2022-10-31T00:00:00.000 2021-10-31T00:00:00.000 2020-10-31T00:00:00.000 2023-10-31T00:00:00.000 2018-11-30T00:00:00.000 view top 100 |
| Latitude | latitude | text | Latitude of the building's location. | 40.738146 40.746517 40.748466 40.766537 40.767566 view top 100 |
| Longitude | longitude | text | Longitude of the building's location. | -73.906492 -73.999751 -73.999848 -73.789812 -74.000238 view top 100 |
| Community Board | community_board | text | The Community Board field indicates the New York City Community District where the building is located. | 1 3 7 4 8 view top 100 |
| Council District | city_council_district | text | The Council District field indicates the New York City Council District where the building is located. | 39 34 33 3 36 view top 100 |
| 2010 Census Tract | census_tract_2010 | text | The Census Tract field indicates the U.S. Census Tract where the building is located. | 39 157 159 65 161 view top 100 |
| BIN | bin | text | The BIN (Building Identification Number) is a unique identifier for each building in the City. | 3000000 4000000 1000000 2000000 4446424 view top 100 |
| BBL | bbl | text | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City. | 4067150002 4058437503 5005950015 2039447501 3082737501 view top 100 |
| NTA | nta | text | The Neighborhood Tabulation Area field indicates the New York City Neighborhood area where the building is located. | Ridgewood Upper West Side (Central) Park Slope Bedford-Stuyvesant (West) Bushwick (West) view top 100 |