Proposals and comments can be accessed for the first time in the 2015 Citizens’ Budget of the City of Cologne, in machine-readable form. The entire database can be queried and filtered via URL.
The Citizen’s Budget website can be accessed via the following URL: https://buergerhaushalt.stadt-koeln.de/2015/
The query is returned in the JSON (JavaScript Object Notation) data format. Sample queries can be found in the documentation below.
<TABLE>
<THEAD></THEAD>
<TBODY>
<TR>
<TD>
URL [GET]
</TD>
<TD>
https://buergerhaushalt.stadt-koeln.de/2015/json
</TD>
</TR>
<TR>
<TD>
Response
</TD>
<TD>
All proposals, ascending in time.
“proposals”: [COMPLETE]
{
“proposal”: {
“proposal_id”: “B-9”,
“created”: “13.10.2014-11:52”,
“NID”: “1270”,
“Title”: “Montibus tepescunt perpetuum Porz”,
“proposal”: “Pluvialibus horrifer [...]glomeravit\n”,
“category”: “Children and youth”,
“type”: “Save proposal”,
“district”: “Porz”,
“path”: “[Domain]/2015/buergervorschlaege/B9”,
“votesPro”: “0”,
“votesContra”: “0”,
“commentsCount”: No comments,
“commentsLink”: “[Domain]/2015/json/comments/1270”
}
},]
</TD>
</TR>
</TBODY>
</TABLE>
Optional parameters
<TABLE>
<THEAD></THEAD>
<TBODY>
<TR>
<TD>
page
</TD>
<TD>
Side-by-side leafing. First page
<code>page=0</code>
</TD>
</TR>
<TR>
<TD>
district
</TD>
<TD>
Allowed values:
<code>Rodenkirchen | Lindenthal | Ehrenfeld | Porz | Downtown | Kalk | Mülheim | Nippes | Chorweiler | Köln total</code>
Example call:
<code>https://buergerhaushalt.stadt-koeln.de/2015/json/?page=0&district=Ehrenfeld</code>
</TD>
</TR>
</TBODY>
</TABLE>
<h3>Single suggestion as JSON</h3>
<TABLE>
<THEAD></THEAD>
<TBODY>
<TR>
<TD>
URL [GET]
</TD>
<TD>
/2015/json/<NID>
</TD>
</TR>
</TBODY>
</TABLE>
<h3>Comments on proposals</h3>
If comments on proposals are available, they can be accessed via the call stored in the <code>commentsLink </code>property.
<TABLE>
<THEAD></THEAD>
<TBODY>
<TR>
<TD>
URL [GET]
</TD>
<td><code>/2015/json/comments/nid</code></td>
</TR>
</TBODY>
</TABLE>
Build on reliable and scalable technology
FAQ
Frequently Asked Questions
Some basic informations about API Store ®.
Operation and development of APIs are currently fully funded by company Apitalks and its usage is for free.
Yes, you can.
All important information such as time of last update, license and other information are in response of each API call.
In case of major update that would not be compatible with previous version of API, we keep for 30 days both versions so you will have enough time to transfer to new version. We will inform you about the changes in advance by e-mail.