Mello Roos Yearly Fiscal

Among other data, the principal amount of bonds outstanding, the balance in the reserve fund, the balance in the capitalized interest fund, the number of parcels delinquent, and the assessed value of all the parcels subject to the tax for debt issued by California community facilities districts under the Mello-Roos Act.

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 \"debtwatch-treasurer-ca-gov/mello-roos-yearly-fiscal-dzi5-k38k\".\"mello_roos_yearly_fiscal\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.