March 1 Revenue Forecast Report 2019

The Revenue Forecast Report for the City of Los Angeles provides a current and updated revenue estimate for fiscal year 2017-18 and revenue projections for fiscal year 2018-19.

Also included are the estimated requirements for debt service and General Fund cash flow borrowing. The Forecast is issued pursuant to the Controller’s City Charter mandate to monitor and report on all matters relating to the City’s fiscal health, to keep the City’s official financial records, and to supervise expenditures of the City.

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 \"controllerdata-lacity/march-1-revenue-forecast-report-2019-frv5-n2hg\".\"march_1_revenue_forecast_report_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.