ED Private Capital Investment

Rolling average of private capital investments for commercial and industrial projects permitted by Pierce County in the previous 18 months.

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 \"internal-open-piercecountywa-gov/ed-private-capital-investment-agu8-qi6z\".\"ed_private_capital_investment\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.