The Norwegian Debt Chrisis

The Norwegian Debt Chrisis

Publication Date: 04/10/2015

Applicant(s)

Description

By going through anonymized data from the collection agency Experian, VG revealed that Norwegian’s never had more overdue payments, in spite of high salaries and a low unemployment rate. Together with the dataset delivered from Experian, we combined these with municipality data from Statitistics Norway and could then create journalism based on our findings. We used multiple data tools to evaluate the data, including regular programming, mySql and R. The complete dataset was put into CartoDB to easily see geographical differences. We also, based on the data, made a few extra tools and apps for our readers. First we made a counter for use on the VG front and articles which calculated the total overdue payments. An example can be seen a bit down in this article: https://translate.google.no/translate?sl=no&tl=en&js=y&prev=_t&hl=en&ie=UTF-8&u=http%3A%2F%2Fwww.vg.no%2Fnyheter%2Finnenriks%2Fgjeldskrisen%2Frekordmange-nordmenn-svartelistet-ikke-hver-dag-jeg-spiser-middag%2Fa%2F23330233%2F&edit-text=&act=url Or as an isolated feature here: http://www.vg.no/spesial/2014/inkassokrisen/toppobjekter/inkassoteller_stripe.php We also created a “How to get out of the debt” web-app, it can be seen here: or in Google Translate (with some weird translations) https://translate.google.no/translate?hl=en&sl=no&tl=en&u=http%3A%2F%2Fwww.vg.no%2Fnyheter%2Finnenriks%2Fgjeldskrisen%2Fstor-guide-raadene-for-aa-komme-deg-ut-av-inkasso-fella%2Fa%2F23337353%2F http://www.vg.no/nyheter/innenriks/gjeldskrisen/stor-guide-raadene-for-aa-komme-deg-ut-av-inkasso-fella/a/23337353/ Finally, we also created a new comment-field, filtering out all but the most relevant comments, as can be seen here: http://www.vg.no/nyheter/innenriks/gjeldskrisen/gjeldskrisen-vestlendinger-best-til-aa-betale-regninger/a/23333890/ Our findings were released both as regular journalism and opened through our web feature, which can be found here: http://www.vg.no/spesial/2014/inkassokrisen/ The articles can be found here: http://www.vg.no/nyheter/innenriks/gjeldskrisen/

Technologies used for this project:

Excel, Mysql, R, PHP, JavaScript (Highcharts), CartoDB, MapBox. An of course HTML and CSS. Open norwegian public data from the national census bureau and Map Office.
Follow this project
Wait
Comment

Comments (0)

You have to be connected to contribute

You have to be connected to follow

Leave this project and no longer be informed about this project

By joining this project, you will be informed by email when an update or a new contribution is posted on the website.

Thank you for your active participation !
Best,

The GEN Community Team