About this Dataset

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.
Organization: City of New York
Last updated: 2020-11-10T17:01:49.176484
Tags: capitalization-rate, hpd, speculation-watch

Tables

Table 1

@usgov.city_of_new_york_speculation_watch_list.table_1

95.45 kB
659 rows
24 columns

CREATE TABLE table_1 (
  "borough" VARCHAR,
  "boro" BIGINT,
  "block" BIGINT,
  "lot" BIGINT,
  "bbl" BIGINT,
  "hnum_lo" VARCHAR,
  "hnum_hi" VARCHAR,
  "str_name" VARCHAR,
  "crfn" BIGINT,
  "grantee" VARCHAR,
  "deed_date" TIMESTAMP,
  "price" BIGINT,
  "cap_rate" DOUBLE,
  "borough_cap_rate" DOUBLE,
  "yearqtr" VARCHAR,
  "postcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract_2020_from_2023" DOUBLE  -- Census Tract (2020) (from 2023),
  "bin" DOUBLE,
  "neighborhood_tabulation_area_nta_2020_from_2023" VARCHAR  -- NEIGHBORHOOD TABULATION AREA (NTA) (2020) (from 2023),
  "location1" VARCHAR
);