Datasets

Welcome to the data-startingpoint where you can find many different information and data sources to work with. There are different levels how to use Data for this Hackathon. We encourage you to use them all to get the most out of the data in the short time you have available!

1. Read-up and Explore

research results in different reports that use data to drive conclusions and recommendations. Also browse portals or online dashboards showing different datasets in a user-friendly matter. This allows for quick insights and new facts about health topics or regions.

2. Load tables and Datasets

into an app, dashboard or other programmable entity. This requires the data to be “Computer-friendly”, so available as raw data (such as Excel Spreadsheets) or via an API (Application Programming Interface).

In the Spotlight

Here are a couple of very useful datasets with some examples of the type of information you can find in there. Happy exploring!

Highlight 1: Social Resillience (Dutch: Sociale Veerkracht)

How health are you? 

The GGD Hart voor Brabant asks this question in detail to many many people. This health questionnaire (Dutch: GGD gezondheidsmonitor) database is a goldmine! The data you will receive during the event contains detailed responses.

What is in this dataset?

More than 50.000 answers on topics like:

  • Gender, age, education, etnicity, etc
  • Health: Weight, risk, alcohol, smoking, drugs, sex, independence, psychological issues, fear, etc
  • Living: Safety, social coherence, quality of life, etc
  • Daytime activities: Sports, volunteering, loneliness, chruch, social groups, etc
  • Upbringing: Family size, stress, vulnerability, etc

Did you know…

  • There are twice as many very lonely Females than Males in Boxtel
    Curious to how that applies to other cities?
  • 73% of respondees with a highly educated mother eat fruit every day, opposed to 67% with a lower educated mother
    Are those two related? Is that a high percentage? Is there a difference in smoking or drinking as well?
  • 45% of the heavy drinkers are also overweight
    Is that related? Is there a difference between nationalities?
  • 70% of the people in Waalwijk who are in full control of their lives, do not participate in volunteer work
    Do you think that is higher or lower in other cities? Or with people who smoke?

Some notes:

  • The actual data will be provided during the Hackathon in the form of a large CSV file! (60MB)
  • This raw data is one of different sources fed into the GGD “Gezondheidsatlas” http://ggd-hvb.gezondheidsatlas.nl/
  • The numbers are DUMMY values, but the relation between the numbers is kept intact.
    So your cannot make statements about the absolute values.
    Example: 70 heavy drinkers in Boxtel is false!
    However you can make statements about the relation between the numbers. Percentages are correct!
    Example: “1% of Boxtel are heavy drinkers” can be true!

Highlight 2: Social Resillience (Dutch: Sociale Veerkracht)

How to define social resilience?

The capacities of human beings and communities to deal with changes (shocks) and the access they have to external resources.

  • Personal resources: Trust and Mobility (action radius, share of non movers).
  • Social resources: Participation.
  • Personal resources: Availability of different kind of amenities, Multiple Deprivation Index (MDI), Mobility (motives).

What is in this dataset?

telos-sociale-veerkracht-monitor-databestand

Curious to how other cities rank? And how each measure is built-up from multiple sub-level indicators?
The actual data will be provided during the Hackathon in the form of an Excel sheet!
More information (in Dutch) about “Sociale Veerkracht” you can find on the website of the data-provider: www.telos.nl

Here are some example insights from the detailed report that Telos constructed based on this (and other) data.

telos-sociale-veerkracht-voorbeeld1-participatietelos-sociale-veerkracht-voorbeeld3-verplaatsingentelos-sociale-veerkracht-voorbeeld2-achterstanden

Reports, Analytics and Dashboards

Find your answers and insights in these interactive (people-friendly) data sources
Data Source Data Type? Scope? Description
http://www.buurtmonitor.nl/ Portal Municipalities of the Netherlands Multiple City Monitors. City Monitor are data portals containing many metrics and details for different municipalities, regio’s or the different GGDs (Like Hart voor Brabant, West Brabant and 7 more).
http://www.waarstaatjegemeente.nl/ Dashboard Municipalities of the Netherlands On this website, developed for local authorities and professionals, you can find the dashboard that is divided into 15 governmental themes. The data comes from different sources and research, like questionnaires, studies, CBS and other data sources. You can use the dashboard to check an individual municipality or compare with others or the Netherlands as a whole.
http://www.rivm.nl/
Media – Profielen – Gemeentelijst
Dashboard Municipalities of the Netherlands RIVM works to prevent and control outbreaks of infectious diseases. We promote public health and consumer safety, and we help to protect the quality of the environment. RIVM collects and collates knowledge and information from various sources, both national and international. We apply this knowledge ourselves, and we place it at the disposal of policy-makers, researchers, regulatory authorities and the general public. Each year, RIVM produces numerous reports on all aspects of public health, nutrition and diet, health care, disaster management, nature and the environment.
https://www.zorgprismapubliek.nl/
Producten – Zorgverzekeringen – Zorgkosten-basisverzekering
Dashboard Municipalities of the Netherlands How are different health costs distributed per type, compared between municipalities? This allows for a quick insight and comparison between a specific Gemeente and the national average per health-cost-type.
www.leefbaarometer.nl Data & Map Nederland Barometer about quality of Living for all Dutch neighbourhoods. Many details. Numbers can be explored using a browsable map, and data are available as open data!
http://jeugdmonitor.cbs.nl/en-gb/ Reports Nederland The National Youth Monitor is a summary of information, available in print and on the Internet, about the situation of young people in the Netherlands. The purpose of the monitor is to inform policymakers, researchers and other interested parties about the situation of the youth in the Netherlands today. The monitor is compiled on the basis of existing reports and datasets and presents a picture of how the population aged 0-24 years in the Netherlands is doing.
http://www.nji.nl/
Databank – Cijfers-over-Jeugd-en-Opvoeding
Reports Nederland DUTCH: U vindt hier cijfers en trends over onderwerpen op het gebied van jeugd en opvoeding en voorzieningen in de jeugdsector. Bij diverse onderwerpen zijn internationale vergelijkingen opgenomen. Daarnaast zijn de gebruikte onderzoeken en registraties beschreven.
http://www.ciz.databank.nl/
Report – Decentralisatie
Reports Different levels This site provides an extensive report about clients who have an indication for Exceptional Medical Expenses (NL: AWBZ) that will be de-centralized to WMO, ZVW en Jeugdwet).
http://www.lemoninternet.nl/
Gemeenten
Reports Municipalities of the Netherlands RIGO provides research to the quality of life within a specific area. For various municipalities detailed reports can be downloaded. For VROM they also helped developing the “Leefbaarometer”.
www.atlasleefomgeving.nl Dashboard Nederland Questions about your living environment? This Atlas will point the way to responsible information about milieu and health. We offer a lot of maps, often to the detail level of neighbourhoods.
www.ggdappstore.nl/

ggdappstore

Links/Inspiration Apps in the Netherlands The best apps for your health! According to different estimations there are about 100.000 different apps to help improve your health. Most apps are either free or require a small fee, and can be downloaded from the known app stores. Most people want to actively participate in improving their health and using smartphone apps can be fun and usefull in doing so.
http://www.rivm.nl/
Documenten en publicaties – Wetenschappelijk – Rapporten – 2014
Reports Nederland Meldingen van milieugerelateerde gezondheidsklachten bij GGDen (Vierde inventarisatie 2011-2012)
https://www.landelijkregisterkinderopvang.nl/ Portal Nederland LRKP: Landelijk Register Kinderopvang en Peuterspeelzalen (National Register Child-daycare)

'Closed' Data (provided during event)

Various interesting 'closed' datasets are distributed among the hackathon participants in the form of offline files. Use with care!
Data Files Data Provider Scope? Description
Social Resilience (Dutch: Sociale Veerkracht) Telos Municipalities of Brabant How to define social resilience? The capacities of human beings and communities to deal with changes (shocks) and the access they have to external resources. Personal resources (Trust and Mobility), Social resources (Participation) and Personal resources (Availability of different kind of amenities, Multiple Deprivation Index (MDI), Mobility motives).
Employment
(Dutch: werkgelegenheid)
Lisa Vestigingsregister, via Province of Brabant Municipalities of Brabant Numbers about employment and jobs within the Health sector from 1996-2015, categorized according to the CBS-SBI job-classification.
Air Quality and the impact on health Province of Brabant Brabant DUTCH: Dit bestand bevat gegevens over de blootstelling aan stikstofdioxide (NO2) in Noord-Brabant 1n 2013 en de vertaling daarvan naar gezondheidsrisico’s, zogenaamde GES-scores. De Gezondheids Effect Screening (GES)-methode geeft een score (van 0 t/m 8) aan de milieugezondheidskwaliteit. Deze scores zijn gebaseerd op de kennis over de relatie tussen blootstelling en gezondheidsrisico’s.
This data is one of many sources on the website: http://www.atlasleefomgeving.nl
Health questionnaires (Dutch: GGD gezondheidsmonitors) GGD Hart voor Brabant Brabant This data file contains detailed responses on the different health questionnaires “GGD-gezondheidsmonitors”. This raw data is one of different sources fed into the GGD “Gezondheidsatlas” http://ggd-hvb.gezondheidsatlas.nl/
Lightweight health support (Dutch: Lichte ondersteuning) Gemeente Tilburg Tilburg Numbers of quickscans and numbers about lightweight health-support in Tilburg. Per Wijk for first half of 2016 (Dummy numbers, but to reality).
STD (Dutch: SOA) GGD HVB + GGD WB Brabant Numbers on STD = Sexually Transmitted Disease = Seksueel Overdraagbare Aandoening = SOA = geslachtsziekte.

Structured Open Data

Browse and Load these various (machine-friendly) open datasets
Data Source Data Type? Scope? Description
http://opendata.cbs.nl/dataportaal/portal.html?_la=nl&_catalog=CBS Open Data Netherlands The mission of CBS is to publish reliable and coherent statistical information which responds to the needs of Dutch society. The responsibility of CBS is twofold: firstly, to compile (official) national statistics and secondly to compile European (community) statistics.
https://data.overheid.nl/ Open Data Netherlands This portal provides an overview of all available datasets provided by government organisations in the Netherlands. Over 150 Dutch government organisations provide all data in the data registry for over 6800 datasets. The data registry is updated daily by harvesting-processes, API-updates and individual users.
http://www.leefbaarometer.nl Data & Map Nederland Barometer about quality of Living for all Dutch neighbourhoods. Many details. Numbers can be explored using a browsable map, and data are available as open data!
http://www.vektis.nl/index.php/vektis-open-data Open Data Netherlands This part of the Vektis website provides open data files regarding the health insurance law. These files are accessible for everyone and contain information about healthcare costs paid by the health insurance companies. 2014 currently is the most up-to-date version. Vektis wants this information to help organisations within health to make better decisions for quality and affordable heathcare
https://www.volksgezondheidenzorg.info/cost-of-illness Open Data Netherlands Volksgezondheidenzorg.info (public health and health care) is the gateway to information about health and disease, risk factors, care and prevention in the Netherlands.
https://opendatanederland.org/ Links Netherlands We think it is great to have so much open data about the Netherlands available. Often these open data is listed on the organization’s website. Unfortunately these website are not well known. OpenDataNederland.org solves this problem by listing all the open datasets of the Netherlands on one single website
http://www.geonovum.nl/wegwijzer/dataportalen-0 Links Netherlands Geonovum make geo-information from the government accessible and facilitates in the necessary open-standards to do so.
http://metadata.brabant.nl Open Data Brabant Overview of datasets from the Province of Brabant that can be requested and provided as open data.
http://data.breda.nl/ Open Data Breda Portal with Open Data sources for the city of Breda
data.aireas.com Open Data Eindhoven + Breda + Helmond AiREAS Air Quality Data contains sensor calibrated data for 30 airbox locations in Eindhoven, 3 in Breda and 1 in Helmond. Measurements contain particulate matter 1, 2.5 and 10 (fine dust); NO2; Ozone; Ambient Temperature; Ambient Relative Humidity; Lat/Lon locations and in a few cases also UltraFineDust (UFP). The data is available in csv format per day for all locations at data.aireas.com/csv and the API for realtime and historic data in batches of maximum 30 days is described in data.aireas.com/docs.
For more information and inspiration about how to use this data, you can check the website globalaireas.wordpress.com

Toolkits

Quickstart into building solutions

GameBus – Gaming prototyping toolkit

https://app.gamebus.eu/

GameBus provides a platform to turn cognitive, physical and social activities into an enjoyable gaming experience. You can connect your app or wearable to the GameBus API (http://kowedes.nl/gamebus/docs/api) which will take care of the gamification layer (teams, leaderboards, badget). Support for using the GameBus is available during the hackathon via email.