Proof of concept.This is an unofficial demo built by Datopian from Roscommon County Council's public data. The official portal is data-roscoco.opendata.arcgis.com. Questions or feedback: hello@datopian.com

A PortalJS proof of concept · data from Roscommon County Council's ArcGIS Hub

Data story · Council finances

Where the council’s budget goes

Every year the council adopts a budget that sets out what each of its eight service divisions will spend, and what it expects to bring in from grants, charges and rents. The Hub holds these tables for 2015 to 2018. Here is what they say.

€54.5m
budgeted spending in 2018
37%
of it on roads and transport
€22.2m
net cost left for local funding

Spending by division

Road Transport & Safety is by far the largest division, at €19.9m in 2018. The dark part of each bar is the net cost: what is left once the division’s own income is counted.

BRoad Transport & Safety€19.9m
CWater Services€7.4m
AHousing and Building€6.4m
EEnvironmental Services€5.7m
DDevelopment Management€5.7m
HMiscellaneous Services€5.0m
FRecreation and Amenity€3.6m
GAgriculture, Education, Health & Welfare€0.8m

Net costCovered by the division’s own income

What pays for itself

Across all divisions, budgeted income covers 59% of spending in 2018, leaving €22.2m to be met from commercial rates, the Local Property Tax and the Local Government Fund. Housing and Building is budgeted to bring in more than it spends, mostly from rents and housing grants.

How it changed, 2015 to 2018

Total budgeted spending went from €53.6m to €54.5m. Recreation and Amenity grew the most, by 17%; Agriculture, Education, Health & Welfare fell the most, by 41%.

YearSpendingIncomeNet cost
2015€53.6m€32.3m€21.4m
2016€54.0m€33.0m€21.0m
2017€52.4m€30.9m€21.5m
2018€54.5m€32.2m€22.2m

How we worked this out

From Table A of the Annual Budget for 2015, 2016, 2017 and 2018: the rows for the eight service divisions, using budgeted expenditure and income (income is shown as a negative number in the tables). Net cost is expenditure minus income. These are adopted budgets, not outturns, and 2018 is the latest year the council has published on its Hub.