{"results":[{"department":"Public Safety","division":"Police","category":"Personnel","budgeted_amount":"125000000","spent_ytd":"89234567","encumbered":"8765433","available":"27000000"},{"department":"Public Safety","division":"Fire","category":"Personnel","budgeted_amount":"87500000","spent_ytd":"62341789","encumbered":"6158211","available":"19000000"},{"department":"Public Safety","division":"Emergency Management","category":"Operations","budgeted_amount":"4200000","spent_ytd":"2987654","encumbered":"312346","available":"900000"},{"department":"Public Works","division":"Streets","category":"Infrastructure","budgeted_amount":"34500000","spent_ytd":"18654321","encumbered":"4345679","available":"11500000"},{"department":"Public Works","division":"Sanitation","category":"Operations","budgeted_amount":"28900000","spent_ytd":"20432156","encumbered":"2567844","available":"5900000"},{"department":"Public Works","division":"Water","category":"Capital","budgeted_amount":"45600000","spent_ytd":"31234567","encumbered":"5765433","available":"8600000"},{"department":"Parks & Recreation","division":"Parks","category":"Operations","budgeted_amount":"18700000","spent_ytd":"13245678","encumbered":"1754322","available":"3700000"},{"department":"Parks & Recreation","division":"Recreation","category":"Programs","budgeted_amount":"12300000","spent_ytd":"8765432","encumbered":"1234568","available":"2300000"},{"department":"Health","division":"Public Health","category":"Personnel","budgeted_amount":"23400000","spent_ytd":"16543219","encumbered":"2456781","available":"4400000"},{"department":"Health","division":"Behavioral Health","category":"Programs","budgeted_amount":"15600000","spent_ytd":"11234567","encumbered":"1365433","available":"3000000"},{"department":"Education","division":"Schools","category":"Personnel","budgeted_amount":"234000000","spent_ytd":"167890123","encumbered":"19109877","available":"47000000"},{"department":"Education","division":"Libraries","category":"Operations","budgeted_amount":"8900000","spent_ytd":"6234567","encumbered":"865433","available":"1800000"},{"department":"Administration","division":"Finance","category":"Personnel","budgeted_amount":"11200000","spent_ytd":"7987654","encumbered":"1012346","available":"2200000"},{"department":"Administration","division":"HR","category":"Personnel","budgeted_amount":"8700000","spent_ytd":"6234567","encumbered":"765433","available":"1700000"},{"department":"Administration","division":"IT","category":"Capital","budgeted_amount":"14300000","spent_ytd":"9876543","encumbered":"1323457","available":"3100000"},{"department":"Housing","division":"Community Development","category":"Programs","budgeted_amount":"19800000","spent_ytd":"14123456","encumbered":"1876544","available":"3800000"},{"department":"Housing","division":"Code Enforcement","category":"Operations","budgeted_amount":"6700000","spent_ytd":"4765432","encumbered":"734568","available":"1200000"},{"department":"Transportation","division":"SEPTA Subsidy","category":"Operations","budgeted_amount":"34000000","spent_ytd":"24234567","encumbered":"2765433","available":"7000000"},{"department":"Transportation","division":"Streets Division","category":"Capital","budgeted_amount":"22100000","spent_ytd":"15765432","encumbered":"2334568","available":"4000000"},{"department":"Social Services","division":"Human Services","category":"Programs","budgeted_amount":"45600000","spent_ytd":"32456789","encumbered":"4143211","available":"9000000"}],"count":20,"schema":{"4673a30f-79c3-5223-939f-7d1fd91b9ce7":{"fields":{"department":{"type":"text","mysql_type":"text"},"division":{"type":"text","mysql_type":"text"},"category":{"type":"text","mysql_type":"text"},"budgeted_amount":{"type":"text","mysql_type":"text"},"spent_ytd":{"type":"text","mysql_type":"text"},"encumbered":{"type":"text","mysql_type":"text"},"available":{"type":"text","mysql_type":"text"}}}},"query":{"resources":[{"id":"4673a30f-79c3-5223-939f-7d1fd91b9ce7","alias":"t"}],"limit":500,"offset":0,"count":true,"results":true,"schema":true,"keys":true,"format":"json","rowIds":false,"properties":["department","division","category","budgeted_amount","spent_ytd","encumbered","available"]}}