State Of California

The principal amounts, sale dates, interest rates, terms, purposes, ratings, costs of issuance, financing team participants, issuance documents, and annual reporting (if applicable), among 67 other data points required under California Government Code section 8855, of the various types of debt issued by the State of California, State programs and departments, State entities, State joint powers authorities, and the Student Loan Corporation.

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/state-of-california-brnb-swt7\".\"state_of_california\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.