Data
Deze pagina is in het Engels om zoveel mogelijk mensen de kans te geven om de data te gebruiken.
Iv3-data
Up till 2015 we have been collecting the data for openspending.nl ourselves. Nowadays, Statistics Netherlands (Centraal Bureau voor de Statistiek/CBS) releases most of the data and thus has become our main source. Every government body (municipality, province, ‘waterschap’ and ‘gemeenschappelijke regeling’) reports their financial information to the CBS in a standardized format called ‘Informatie voor Derden‘ or ‘Iv3’. More information can be found on the website of Bureau KREDO (the department within CBS which deals with the Iv3 data). This page gives more details on their release of open data and here is a direct link to their API. You can also use our API, see the section below, which has an easier way of accessing the data and also contains metrics for the governments.
API
We have made the openspending.nl Iv3-data and detaildata available via an API. The easiest way to get to know the data is to start exploring it via our interactive Swagger/OpenAPI documentation:
Terms & Explanation
Here is some basic information about this data and the terms we use. First of all, each local government body delivers its budgets/realisation data to the CBS using an Excel form. Check out the empty example forms for municipalities and provinces (go to the website of Bureau KREDO for more examples). Even better, check out this form containing the actual data of the municipality Weststellingwerf. The values which we are interested in are shown in the sheets called “5.Verdelingsmatrix lasten” for the expenses and “6.Verdelingsmatrix baten” for the income values. The main takeaway is that these values are structured as a matrix as shown in this image:
On the vertical axis (on the left) you see the functions to which a value can belong, e.g. “210 Wegen, straten en pleinen” (roads, streets and squares). We call these “subfunctions” or “sub” as we also allow you to extract the data on the “main function” or “main” level, e.g., “Hoofdfunctie 2 VERKEER, VERVOER EN WATERSTAAT” (Main function 2 TRAFFIC, TRANSPORT AND WATER). Such a value is not simply 1 number, but broken down into the “categories” or “cat” you see on the horizontal axis (on the top). In the case of “210 Wegen, straten en pleinen” its expenses were spent as follows: 164 was spent on “Energie” (energy), 44 on “Betaalde belastingen” (paid taxes), etc. Note that all these values are divided by 1,000 (one thousand). So the actual spending on energy was €164,000. In our API, we call these values “entries“. Only cells with an actual value are stored in our API.
Another term used in the API is “document“. This relates to the Excel forms shown above. Each Excel form is one document and thus contains the values for one government body for a certain year and period. The local government bodies send the CBS up to 6 of those documents per year, called periods 0 till 5. A document with period 0 contains the budget for the whole year ((jaar)begroting), periods 1-4 contain the actual spending (realisatie) for each quarter of the year and period 5 contains the spending of the whole year ((jaar)realisatie). Some governments also submit quarterly budgets to the CBS. This are adjusted budgets as in ‘budget per quarter’.
Example
Our Open Spending Lijstjes tool makes uses of our own Open Spending API (eat your own dog food ;D). Its code is posted on GitHub.