Open repository in Console
Readme
Updated almost 2 years ago
‧ Indexed 3 hours ago
Financial Audit Reports Data (ACFR) 2021
The compiled ACFR data for fiscal year 2020. Please note that due to differences in audit report styles and definitions, comparison between numbers should be done carefully. For example, public safety in one city may include fire, ambulance and police; where public safety in another city may only include police.
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 \"orcities/financial-audit-reports-data-acfr-2021-g4d6-2zrp\".\"financial_audit_reports_data_acfr_2021\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.