Traditional Housing Affordability Index

The California Association of Realtors (C.A.R) Traditional Housing Affordability Index (HAI) measures the percentage of households that can afford to purchase the median priced home in the state and regions of California based on traditional assumptions. C.A.R. also reports its traditional and first-time buyer indexes for regions and select counties within the state. The HAI is the most fundamental measure of housing well-being for buyers in the state.

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 \"performance-smcgov/traditional-housing-affordability-index-u77h-e6k9\".\"traditional_housing_affordability_index\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.