Icon for Socrata external plugin
Open repository in Console
Updated 3 months ago
Indexed 6 hours ago


The Location Affordability Index (LAI) consists of estimates of the combined household and transportation costs. The LAI is calculated at the Census block-group level (block groups contain 600 to 3,000 residents each) for each of the 942 Core Based Statistical Areas and at the county level for non-metropolitan counties using statistical regression modeling.

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" \
{"sql": "
    SELECT *
    FROM \"celebratingcities-data-socrata/dmvlai-ypa6-339b\".\"dmvlai\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • dmvlai