LAHD Affordable Housing Projects List (2003 to Present)

Disclaimer:

PLEASE READ THIS AGREEMENT CAREFULLY BEFORE USING THIS DATA SET. BY USING THIS DATA SET, YOU ARE CONSENTING TO BE OBLIGATED AND BECOME A PARTY TO THIS AGREEMENT. IF YOU DO NOT AGREE TO THE TERMS AND CONDITIONS BELOW YOU SHOULD NOT ACCESS OR USE THIS DATA SET.

This data set is presented as a public service that provides Internet accessibility to information provided by the City of Los Angeles and to other City, State, and Federal information. Due to the dynamic nature of the information contained within this data set and the data set’s reliance on information from outside sources, the City of Los Angeles does not guarantee the accuracy or reliability of the information transmitted from this data set. This data set and all materials contained on it are distributed and transmitted on an “as is” and “as available” basis without any warranties of any kind, whether expressed or implied, including without limitation, warranties of title or implied warranties of merchantability or fitness for a particular purpose.

The City of Los Angeles is not responsible for any special, indirect, incidental, punitive, or consequential damages that may arise from the use of, or the inability to use the data set and/or materials contained on the data set, or that result from mistakes, omissions, interruptions, deletion of files, errors, defects, delays in operation, or transmission, or any failure of performance, whether the material is provided by the City of Los Angeles or a third-party.

The City of Los Angeles reserves the right to modify, update, or alter these Terms and Conditions of use at any time. Your continued use of this Site constitutes your agreement to comply with such modifications.

The information provided on this data set, and its links to other related web sites, are provided as a courtesy to our web site visitors only, and are in no manner an endorsement, recommendation, or approval of any person, any product, or any service contained on any other web site.

Description:

LAHD financed projects since 2003 to present. These projects are financed with programs including Affordable Housing Managed Pipeline, Supportive Housing Program, Affordable Housing Bond Program, and the Proposition HHH Supportive Housing Loan Program. This project list contains participants, property, units, construction and milestone information. Each line contains both site and project level information. Site level information are presented with "SITE" in the column headers. Column headers without "SITE" are project level information.

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 \"lacity/lahd-affordable-housing-projects-list-2003-to-mymu-zi3s\".\"lahd_affordable_housing_projects_list_2003_to\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.