Local Law 84 2021 (Monthly Data for Calendar Year 2020)

Monthly whole building electricity and natural gas consumption data in privately owned buildings over 25,000 ft2 and in City-owned buildings over 10,000 ft2.

To understand more about full building characteristics and annual metrics, visit this <a href="https://data.cityofnewyork.us/Environment/Energy-and-Water-Data-Disclosure-for-Local-Law-84-/usc3-8zwd">link</a> to view the annual water and energy consumption data set. Each property in these two data sets can be linked using the “Property ID” column, which serves as a key.

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-84-2021-monthly-data-for-calendar-year-in83-58q5\".\"local_law_84_2021_monthly_data_for_calendar_year\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.