Speculation Watch List
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 list is a subset of data provided in theLL7-2018 Qualified Transactions file.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Stale
- Says it updates
- Quarterly
- Actually updates about every
- —
- Publisher last updated the data
- May 7, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- May 7, 2026, 12:33 PM
- Rows in our copy
- 797
- Rows at the source
- 797
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
7 of 29 columns carry a concept; 20 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
:@computed_region_sbqj_enih | Police Precincts 2 | This column was automatically created in order to record in what polygon from the dataset 'Police Precincts' (sbqj-enih) the point in column 'geocoded_column' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. | Not bound | Number | :@computed_region_sbqj_enih | numeric | — | |
bin | BIN | The publisher describes this column nowhere. | bindeclared | Number | bin | numeric | — | |
hnum_lo | hnum_lo | Portion of street address: low house number | Not bound | Text | hnum_lo | text | — | |
hnum_hi | hnum_hi | Portion of street address: high house number | Not bound | Text | hnum_hi | text | — | |
yearqtr | yearqtr | Year and quarter | Not bound | Text | yearqtr | text | — | |
:@computed_region_yeji_bk3q | Borough Boundaries 2 | This column was automatically created in order to record in what polygon from the dataset 'Borough Boundaries' (yeji-bk3q) the point in column 'geocoded_column' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
Download
This file was produced on Aug 20, 2026, 9:22 AM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/adax-9mit
- Version
- Content hash:
53f81c600433485a8f77ca876cf2b0f97c16df754988c509bba9c025a4e570c4 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- May 7, 2026, 12:33 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 9, 2026, 4:16 PM | full_replace | success | 797 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.55 |
| Aug 9, 2026, 1:48 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 9, 2026, 12:33 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 11:18 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 10:03 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 8:39 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 7:24 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 6:09 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 4:54 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |
| Aug 8, 2026, 3:39 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.49 |