New York City Rent-Regulated Property Sales with Speculation Risk

A 2024 list of sales for select rent-regulated multiple dwellings where potential for speculation exists, published by the City of New York. The dataset is a subset of the Local Law 7-2018 Qualified Transactions file. It includes geographic and financial details for properties flagged under the city's anti-speculation monitoring program.

Use Cases

• Identify high-risk transactions by analyzing price, cap_rate, and borough_cap_rate columns across different neighborhoods.
• Map sales activity and potential speculation hotspots using geographic columns like Latitude, Longitude, bbl, and NEIGHBORHOOD TABULATION AREA (NTA).
• Analyze temporal trends in deed_date and yearqtr to correlate sales activity with policy changes or market cycles.
• Cross-reference property identifiers such as BIN, block, and lot with other municipal datasets for deeper property-level analysis.

Strengths

• Contains over 25 specific columns including financial metrics (price, cap_rate), geographic identifiers (bbl, Latitude), and administrative details (Council District, Police Precincts).
• Directly tied to a specific city regulation (Local Law 7 of 2018), providing legal context for the data collection.
• Updated as of September 2024, indicating recent maintenance.

Limitations

• The dataset is a subset of a larger file, so it may not represent the full universe of qualified transactions.
• The Building Identification Number (BIN) column may be inaccurate as multiple BINs can be associated with a single borough-block-lot.
• Sample size, row count, and temporal coverage are unknown, limiting statistical assessment.

Provenance

Source

data.cityofnewyork.us, the official open data portal for New York City.

Collection Method

Compiled pursuant to Local Law 7 of 2018 and 28 RCNY Chapter 52, as a subset of the LL7-2018 Qualified Transactions file.

Freshness

Last updated on 2024-09-25.

Geography

New York City, with identifiers for borough, community board, and census tract.