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?
- 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.
“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?
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.
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.|
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.|
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.|
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.|
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).|
|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/||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.|
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).|
|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
Quickstart into building solutions
GameBus – Gaming prototyping toolkit
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.