Business Services - Faulty Utility Meters
This dataset contains the number of faulty meters (gas, water, electric) that are detected each month and how many of those meters had been faulty for 3 months or less. A faulty meter is one that is not registering the usage correctly.
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 \"citydata-mesaaz-gov/business-services-faulty-utility-meters-ygkp-e8sz\".\"business_services_faulty_utility_meters\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.