YourMoney Agency Expenditures
The data file reflects data for a budget fiscal year as a cumulatively fiscal year-to-date total. For ease of reporting and to facilitate understanding of the data, the expenditures are categorized by department/agency, expenditure description, organization, statewide program, funding category, expenditure category, and payee. 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 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-expenditures-apet-rp2i\".\"yourmoney_agency_expenditures\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.