Skip to content

Instantly share code, notes, and snippets.

@sjockers
sjockers / eu_country_codes.csv
Last active November 27, 2020 15:08
Country codes used by EU institutions such as Eurostat. Differs from ISO-3166 alpha-2 (see e.g. Greece, UK). CSV extracted from the Eurostat Glossary (https://ec.europa.eu/eurostat/statistics-explained/index.php/Glossary:Country_codes).
AL Albania
AM Armenia
AR Argentina
AT Austria
AU Australia
AZ Azerbaijan
BA Bosnia and Herzegovina
BE Belgium
BG Bulgaria
BR Brazil
{
"meta": {
"license": { "name": "Open Database License (ODbL) v1.0", "url": "https://opendatacommons.org/licenses/odbl/1.0/" },
"contributer": [],
"subsets": [
"https://www.abgeordnetenwatch.de/api/parliament/brandenburg/deputies.json?subsets=votes",
"https://www.abgeordnetenwatch.de/api/parliament/brandenburg/deputies.json?subsets=dialogues",
"https://www.abgeordnetenwatch.de/api/parliament/brandenburg/deputies.json?subsets=sidejobs"
]
},
'use strict';
function _interopDefault (ex) { return (ex && (typeof ex === 'object') && 'default' in ex) ? ex['default'] : ex; }
var test = _interopDefault(require('ava'));
function noop() {}
function assign(tar, src) {
for (var k in src) tar[k] = src[k];
@sjockers
sjockers / infoplus.md
Created May 16, 2018 08:50
infoformation+ conference 2018 proposal

Statistics as commons: Making official statistics more accessible to citizens

Around the world, government agencies constantly collect and process quantitative information about all areas of our lives, including economic development, education, public health, and the environment. The results of these massive state-run data gathering efforts are usually called official statistics – and they are a public good.

Official statistics are important tools, for political decision-makers as well as for academia and the general public. Politicians, scientists, journalists, businesses, and NGOs rely on objective and publicly available statistics. Very often, however, the dissemination of official statistics is not aimed at the general public. As a result, they are neither easy to access nor easy to use.

In this lightning talk, I will present results from Datenguide (datengui.de), a research and development project into alternative ways of presenting official statistics, informed by data journalism and user-centered

@sjockers
sjockers / campfire.md
Last active August 29, 2017 09:25
Campfire Festival proposal

Was ist das für 1 Datenjournalismus?

Digitale Formate jenseits des klassischen Artikels

Das Web hat keine Zeilenbegrenzung und keinen Redaktionsschluss. Trotzdem pressen wir unsere Datenrecherchen viel zu oft ins Korsett von Artikeln und mehr oder weniger interaktiven Infografiken. Aber das muss nicht sein. Im Web können auch große Datenmengen durchsuch- und erfahrbar gemacht werden – und es ist einfach, Inhalte kontinuierlich zu aktualisieren. Das ermöglicht völlig neue journalistische Formate, z.B. explorative Visualisierungen oder interaktive Datenbanken, die immer aktuell sind.

Doch wie gestalten wir solche Formate zugänglich und interessant für das Publikum? Ausgehend von aktuellen Beispielen diskutieren wir Design-Strategien und Techniken für die digitale Veröffentlichung eurer Datenrecherchen.


Simon Jockers ist Webentwickler und Datenjournalist bei CORRECTIV. Er entwickelt interaktive Informationsgrafiken, Webanwendungen und hilft Reportern dabei, mit großen Datenmengen umzugehen. In

@sjockers
sjockers / ernte-teilen.csv
Created August 6, 2017 12:57
Place data from ernte-teilen.org (2017-08-06)
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 9 columns, instead of 6. in line 9.
id,name,city,address,latitude,longitude,type,ownerships__user_id,ownerships__name
575,Solawi Initiative Krefeld,Kreisfreie Stadt Krefeld,,51.34472,6.58611,Initiative,445,Michael Adams
29,Hofgemeinschaft Oldendorf,27729 Holste,Oldendorfer Landstr. 24,53.36017,8.8249661,Farm,35,Hofgemeinschaft Oldendorf
31,Depot Hüttenbusch,27726 Worpswede,Hüttenbuscher Str. 50a,53.2595454,8.9570583,Depot,35,Hofgemeinschaft Oldendorf
32,Depot Werschenrege,27721 Ritterhude,Große Loge 24,53.20638845,8.7272440838,Depot,35,Hofgemeinschaft Oldendorf
33,Depot Bremen-Nord,28757 Bremen,An der Aue 84,53.1742853,8.636488,Depot,35,Hofgemeinschaft Oldendorf
35,Depot Markt Beverstedt,Beverstedt,Enge Str. 1,53.4336198,8.8196037,Depot,35,Hofgemeinschaft Oldendorf
36,Depot Schwachhausen,Bremen,Freiligrathstr. 15,53.08360365,8.8651673878,Depot,35,Hofgemeinschaft Oldendorf
39,"Gemüsekooperative ""Rote Beete""",Taucha,An der Schmiede 4,51.3765197,12.5402322,Farm,38,Michael Götze
136,Food-Coop Norderstedt,Hamburg,Norderstedt Mitte,53.7082168,9.990
@sjockers
sjockers / bundestag-18-election-results.md
Last active June 26, 2017 15:49
Detailed election results for the 18th German Bundestag (2013)
@sjockers
sjockers / wikipedia-constituencies-scraper.js
Last active April 17, 2018 10:42
Scrape the 2013 Bundestag election results for individual constituencies from Wikipedia using artoo.js
// Scrape the 2013 Bundestag election results for individual constituencies from Wikipedia
// - using artoo.js v0.3.3.1 (http://medialab.github.io/artoo/)
// - starting point: https://de.wikipedia.org/wiki/Liste_der_Bundestagswahlkreise_2013
var result = []
var baseUrl = 'https://de.wikipedia.org'
var pages = artoo.scrape('.wikitable:nth-of-type(2) td:nth-of-type(2) a,\
.wikitable:nth-of-type(2) td:nth-of-type(6) a', function() {
return baseUrl + $(this).attr('href')
})
@sjockers
sjockers / claimReview.html
Last active November 14, 2016 15:42
Claim review meta data on correctiv.org, JSON-LD example
<!-- http://pending.schema.org/ClaimReview -->
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": ["Review", "ClaimReview"],
"datePublished": "2016-08-17T13:06:00+01:00",
"url": "https://correctiv.org/blog/ruhr/artikel/2016/08/17/debatte-um-beschaeftigtenzahlen-ruhrgebiet/",
"author": {
"@type": "Organization",
@sjockers
sjockers / gist:58c7e67bbb75bb664371
Last active December 15, 2016 11:53
Critical Mass Berlin, March 2015
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.