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 <a href="https://data.cityofnewyork.us/Housing-Development/Speculation-Watch-List/adax-9mit">Speculation Watch List</a>.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/local-law-72018-qualified-transactions-8wi4-bsy4\".\"local_law_72018_qualified_transactions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.