YourMoney Agency Revenue
The data file reflects revenue data for a 13 period accounting fiscal year as recorded per accounting month and cumulatively as a fiscal year-to-date total. For ease of reporting and to facilitate understanding of the data, the revenue is categorized by fund, type, department/agency, source, revenue description and organization. Note that the 12 accounting months begin in July and run sequentially through the 12th period which stays open for both calendar months June and July of the following year. A 13th period closing/adjustment period, which is not associated with any particular calendar month, remains open for a period of time for final entries in preparation of the State's CAFR reporting. Additional information is in the attached dataset summary PDF (available on the About tab under "Attachments".).
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 \"nj-gov/yourmoney-agency-revenue-k9iw-i8yt\".\"yourmoney_agency_revenue\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
