About this Dataset

Local Law 7-2018 Qualified Transactions

List of sales of select rent-regulated multiple dwellings that are evaluated for the Speculation Watch List. This list is promulgated pursuant to Local Law 7 of 2018 and 28 RCNY Chapter 52. A subset of these data are provided as the Speculation Watch List. 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. A subset of these data are provided as the Speculation Watch List.
Organization: City of New York
Last updated: 2020-11-10T17:01:25.407591
Tags: capitalization-rate, hpd, speculation-watch

Tables

Table 1

@usgov.city_of_new_york_local_law_7_2018_qualified_transactions.table_1

170.81 kB
1,410 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" DOUBLE,
  "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
);