This is the cumulative sum of expenditures for each accounting string (EECAF & PNGCAF) by fiscal year and accounting period. The accumulation starts in the first accounting period for each fiscal year and ends on the last accounting period for the fiscal year.
Data sources are publicly available via Open Expenditures at https://openexpenditures.mesaaz.gov/#!/year/All%20Years/explore/0/activity_name/EECAF+Elec+Energ+Cost+Adj+Factor+(EECAF)/0/department_name
and
https://openexpenditures.mesaaz.gov/#!/year/All%20Years/explore/0/activity_name/PNGCAF+Purch+Natur+Gas+Cost+Adjust+Factor/0/department_name
Data reporting may have a 14 day lag.
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 \"citydata-mesaaz-gov/electric-energy-natural-gas-supply-costs-uaiy-c7rn\".\"electric_energy_natural_gas_supply_costs\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.