{"results":[{"department":"Public Health","division":"Disease Control","program":"Vaccination Programs","budget_category":"Personnel","approved_budget_usd":"4200000","spent_to_date_usd":"1847000","remaining_usd":"2353000","fte_count":"38","fiscal_year":"2025"},{"department":"Public Health","division":"Disease Control","program":"Vaccination Programs","budget_category":"Operations","approved_budget_usd":"820000","spent_to_date_usd":"341000","remaining_usd":"479000","fte_count":"0","fiscal_year":"2025"},{"department":"Public Health","division":"Mental Health","program":"Community Clinics","budget_category":"Personnel","approved_budget_usd":"3100000","spent_to_date_usd":"1421000","remaining_usd":"1679000","fte_count":"29","fiscal_year":"2025"},{"department":"Public Health","division":"Mental Health","program":"Community Clinics","budget_category":"Contracts","approved_budget_usd":"1450000","spent_to_date_usd":"612000","remaining_usd":"838000","fte_count":"0","fiscal_year":"2025"},{"department":"Transportation","division":"Streets","program":"Road Maintenance","budget_category":"Personnel","approved_budget_usd":"6800000","spent_to_date_usd":"2914000","remaining_usd":"3886000","fte_count":"72","fiscal_year":"2025"},{"department":"Transportation","division":"Streets","program":"Road Maintenance","budget_category":"Equipment","approved_budget_usd":"2200000","spent_to_date_usd":"987000","remaining_usd":"1213000","fte_count":"0","fiscal_year":"2025"},{"department":"Transportation","division":"Transit","program":"Bus Operations","budget_category":"Personnel","approved_budget_usd":"12400000","spent_to_date_usd":"5432000","remaining_usd":"6968000","fte_count":"148","fiscal_year":"2025"},{"department":"Transportation","division":"Transit","program":"Bus Operations","budget_category":"Fuel","approved_budget_usd":"3800000","spent_to_date_usd":"1621000","remaining_usd":"2179000","fte_count":"0","fiscal_year":"2025"},{"department":"Transportation","division":"Transit","program":"Rail Maintenance","budget_category":"Personnel","approved_budget_usd":"8900000","spent_to_date_usd":"3812000","remaining_usd":"5088000","fte_count":"94","fiscal_year":"2025"},{"department":"Transportation","division":"Transit","program":"Rail Maintenance","budget_category":"Equipment","approved_budget_usd":"4100000","spent_to_date_usd":"1743000","remaining_usd":"2357000","fte_count":"0","fiscal_year":"2025"},{"department":"Education","division":"K-12","program":"Curriculum Development","budget_category":"Personnel","approved_budget_usd":"5600000","spent_to_date_usd":"2341000","remaining_usd":"3259000","fte_count":"61","fiscal_year":"2025"},{"department":"Education","division":"K-12","program":"Curriculum Development","budget_category":"Materials","approved_budget_usd":"980000","spent_to_date_usd":"412000","remaining_usd":"568000","fte_count":"0","fiscal_year":"2025"},{"department":"Education","division":"Higher Ed","program":"Community College","budget_category":"Contracts","approved_budget_usd":"7200000","spent_to_date_usd":"3124000","remaining_usd":"4076000","fte_count":"0","fiscal_year":"2025"},{"department":"Parks & Recreation","division":"Parks","program":"Maintenance","budget_category":"Personnel","approved_budget_usd":"3400000","spent_to_date_usd":"1478000","remaining_usd":"1922000","fte_count":"41","fiscal_year":"2025"},{"department":"Parks & Recreation","division":"Parks","program":"Maintenance","budget_category":"Operations","approved_budget_usd":"1100000","spent_to_date_usd":"467000","remaining_usd":"633000","fte_count":"0","fiscal_year":"2025"},{"department":"Public Safety","division":"Police","program":"Community Policing","budget_category":"Personnel","approved_budget_usd":"18700000","spent_to_date_usd":"8123000","remaining_usd":"10577000","fte_count":"198","fiscal_year":"2025"},{"department":"Public Safety","division":"Fire","program":"Emergency Response","budget_category":"Personnel","approved_budget_usd":"14200000","spent_to_date_usd":"6187000","remaining_usd":"8013000","fte_count":"152","fiscal_year":"2025"},{"department":"Public Safety","division":"Fire","program":"Emergency Response","budget_category":"Equipment","approved_budget_usd":"2800000","spent_to_date_usd":"1214000","remaining_usd":"1586000","fte_count":"0","fiscal_year":"2025"},{"department":"Housing","division":"Development","program":"Affordable Housing","budget_category":"Contracts","approved_budget_usd":"9400000","spent_to_date_usd":"4123000","remaining_usd":"5277000","fte_count":"0","fiscal_year":"2025"},{"department":"Housing","division":"Development","program":"Affordable Housing","budget_category":"Grants","approved_budget_usd":"3200000","spent_to_date_usd":"1387000","remaining_usd":"1813000","fte_count":"0","fiscal_year":"2025"}],"count":20,"schema":{"d3ecab24-4761-5f99-8916-eaf5739f2f3a":{"fields":{"department":{"type":"text","mysql_type":"text"},"division":{"type":"text","mysql_type":"text"},"program":{"type":"text","mysql_type":"text"},"budget_category":{"type":"text","mysql_type":"text"},"approved_budget_usd":{"type":"text","mysql_type":"text"},"spent_to_date_usd":{"type":"text","mysql_type":"text"},"remaining_usd":{"type":"text","mysql_type":"text"},"fte_count":{"type":"text","mysql_type":"text"},"fiscal_year":{"type":"text","mysql_type":"text"}}}},"query":{"resources":[{"id":"d3ecab24-4761-5f99-8916-eaf5739f2f3a","alias":"t"}],"limit":500,"offset":0,"count":true,"results":true,"schema":true,"keys":true,"format":"json","rowIds":false,"properties":["department","division","program","budget_category","approved_budget_usd","spent_to_date_usd","remaining_usd","fte_count","fiscal_year"]}}