Dataset: Speculation Watch List
The speculation_watch_list dataset can be added to NYCDB by running:
> nycdb --download speculation_watch_list
> nycdb --load speculation_watch_list
The dataset comes from the NYC Open Data Portal:
List of sales of select rent-regulated multiple dwellings where there may be potential for speculation. This list is promulgated pursuant to Local Law 7 of 2018 and 28 RCNY Chapter 52. This list is a subset of data provided in the LL7-2018 Qualified Transactions file. Please note that borough, block, and lot is the best geographic identifier for this data set, and Building Identification Number (BIN) is provided for convenience only. BIN as provided in this dataset may be inaccurate, as more than one BIN may be associated with borough, block, and lot.
This dataset is published by the Department Housing Preservation and Development (HPD), and has been updated on a quarterly basis since November 11, 2018.
The creation of this dataset was established by the Local Law 7 of 2018, with additional details about criteria for inclusion listed in 28 RCNY Chapter 52.
According to both these sources, properties are added to the speculation watch list if their capitalization rates (net operating income divided by sales price) are below the borough-wide median rate. Properties are only evaluated for the watch list if they are
- Completely residential with at least 11 units, or
- Mixed-use with 7+ residential units and at least one commercial unit.
Inclusion on the watch list doesn't necessarily have any consequences for the property owner.
The median capitalization rate of each borough is calculated based on all "qualified transactions" carried out over the last four fiscal quarters. Properties can be removed from the list if they begin providing affordable housing and in some other cases. Individuals can also email HPD to challenge the inclusion of a property on the list. For more details, see 28 RCNY Chapter 52.
According to Local Law 7, HPD can change the criteria for inclusion on the watch list at any time.
For all properties that HPD evaluates to assemble the speculation watch list, see the LL7-2018 Qualified Transactions file.
Click to expand the speculation_watch_list Data Dictionary
| column_name | data_type | description |
|---|---|---|
| borough | text | Borough where property is located (text). BX: Bronx, BK: Brooklyn, MN: Manhattan, QN: Queens, SI: Staten Island |
| boro | number | Borough where property is located (numeric). 1: Manhattan, 2: Bronx, 3: Brooklyn, 4: Queens, 5: Staten Island |
| block | number | Tax block |
| lot | number | Tax lot |
| bbl | number | Borough, block, and lot |
| hnum_lo | text | Portion of street address: low house number. Source: NYC DOF final tax roll file |
| hnum_hi | text | Portion of street address: high house number. Source: NYC DOF final tax roll file |
| str_name | text | Portion of street address: street name. Source: NYC DOF final tax roll file |
| crfn | number | City Register file number. May be used to identify property sale in ACRIS. |
| grantee | text | Name of buyer(s). Source: ACRIS |
| deed_date | floating timestamp | Execution date of transfer. Source: ACRIS |
| price | number | Price. Source: ACRIS |
| cap_rate | number | Capitalization rate |
| borough_cap_rate | number | Borough capitalization rate. Median capitalization rate calculated from qualified transactions occurring in that borough during this quarter and prior three quarters |
| yearqtr | number | Year and quarter |
| postcode | number | Postcode |
| latitude | number | Latitude |
| longitude | number | Longitude |
| community_board | text | Community Board |
| council_district | text | Council District |
| census_tract | text | Census Tract (2020) (from 2023) |
| bin | number | Building Identification Number |
| nta | text | Neighborhood Tabulation Area (NTA) (2020) (from 2023) |
| geocoded_column | location | Location1 (latitude and longitude) |
This dataset has the following tables:
-
speculation_watch_listis the only table in this dataset.
- Building Identification Numbers may not be accurate since they could apply to more than one borough/block/lot. Use bbl instead.