Local Law 44 - Projects

The Projects data table contains information about Housing Development Projects about which HPD is required to report pursuant to Local Law 44 of 2012. This includes general project information such as start and completion dates, units, Borrower Legal Entity, general contractor (GC), and prevailing wage information. There is a one-to-one relationship between this information and the project. This is part of the <a <a href='https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=HPD+Local+Law+44'>Housing Projects Receiving City Financial Assistance (Local Law 44) collection of data tables</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-44-projects-ucdy-byxd\".\"local_law_44_projects\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.