FAC Energy Use at FM Facilities

Energy data represents all electricity used at Pierce County Facilities, excluding the wastewater treatment plants and distributed pump houses.

All data is collected from utility bills and is entered into software where it is normalized by month and by fluctuations in the weather.

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/fac-energy-use-at-fm-facilities-wbem-zewh\".\"fac_energy_use_at_fm_facilities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.