Bad Debt Expense

Bad debt expense is the amount of revenue billed in any fiscal year that is not collected. It represents a final, audited number based on an analysis of collectability. While Austin Energy has experienced growth in receivable balances for active accounts due to a postponement of utility cut-offs for delinquent payment during Austin Energy’s transition to the new customer billing system, the utility is beginning to see significant collection on those balances. Find more information at http://austinenergy.com/go/reports.

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 \"datahub-austintexas-gov/bad-debt-expense-6zan-sbz2\".\"bad_debt_expense\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.