Skip to content


Switch branches/tags

Latest commit


Git stats


Failed to load latest commit information.
Latest commit message
Commit time


Openkamer gives insight into the Dutch parliament by gathering, organizing and visualizing parliamentary data.

Openkamer extracts parliamentary data from several external sources (Tweede Kamer API, WikiData,, creates relations, and visualizes this data in a web application.

Openkamer is a Python 3.5+ and Django 2.2+ project under MIT license.

Installation (Linux)

Get the code and enter the project directory,

$ git clone
$ cd openkamer

Install in a local environment (creates a Python 3 virtualenv and a sqlite database file),

$ ./

Activate the virtualenv,

$ source env/bin/activate


There are 3 options to fill your database with data.

Option 1: Load a json dump from (5 min)

This will fill your database with all openkamer data. Download the latest openkamer-<date>.json.gz file from
Load this data into your local database with the following Django command,

$ python loaddata openkamer-<date>.json.gz

Option 2: Scrape a small demo data set (10-15 min)

Scrape a demo data subset from external sources. This is the longer, but more exciting method. Scraping demo data can take several minutes and mostly depends on response time of external sources,

$ python create_demo_data

Option 3: Scrape all data from scratch (12-24 hours)

This is how you get all data from scratch; scrape everything from external sources. This will take several hours, but is independent of
Use the following command,

$ python create_data

Run a development server

Run the Django dev web server in the virtualenv,

$ source env/bin/activate
(env)$ python runserver

Openkamer is now available at and


See website/ and website/ for settings.


based on download and install solr-6.5.0 from start and create core

$ bin/solr start
$ bin/solr create -c default5

You should now be able to visit the admin page at from website/templates/search_configuration copy solrconfig.xml to [SOLR base folder]server/solr/default5/conf

create schema.xml and refresh core:

$ python build_solr_schema --filename=[SOLR base folder]/server/solr/default5/conf/schema.xml && curl 'http://localhost:8983/solr/admin/cores?action=RELOAD&core=default5&wt=json&indent=true'

create search index

$ python rebuild_index



Run tests

Run all tests,

$ python test

Run specific tests (example),

$ python test website.test.TestCreateParliament
Create test json fixtures
$ python dumpdata --all --natural-foreign --indent 2 auth.User auth.Group person parliament government document website > website/fixtures/<fixture_name>.json

Debug toolbar

Enable the django debug toolbar by uncommenting the django_toolbar related lines in INSTALLED_APPS and MIDDLEWARE in website/


Openkamer has some optional cronjobs that do some cool stuff. You can review them in website/
Create the following cronjob (Linux) to kickstart the django-cron jobs,

$ crontab -e
*/5 * * * * source /home/<user>/.bashrc && source /home/<path-to-openkamer>/openkamer/env/bin/activate && python /home/<path-to-openkamer>/website/ runcrons > /home/<path-to-openkamer>/log/cronjob.log