everypolitician-scrapers / germany-bundestag-sparql

Contributors tmtmtmtm

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling...  -----> Ruby app detected -----> Compiling Ruby -----> Using Ruby version: ruby-2.3.3 -----> Installing dependencies using bundler 1.15.2  Running: bundle install --without development:test --path vendor/bundle --binstubs vendor/bundle/bin -j4 --deployment  Fetching gem metadata from https://rubygems.org/.........  Fetching version metadata from https://rubygems.org/..  Fetching dependency metadata from https://rubygems.org/.  Fetching https://github.com/everypolitician/everypolitician-ruby.git  Fetching https://github.com/openc/sqlite_magic.git  Fetching https://github.com/openaustralia/scraperwiki-ruby.git  Fetching https://github.com/everypolitician/wikisnakker.git  Fetching https://github.com/everypolitician/wikidata-fetcher.git  Fetching rake 12.1.0  Fetching activesupport-inflector 0.1.0  Fetching ast 2.3.0  Installing ast 2.3.0  Installing activesupport-inflector 0.1.0  Using bundler 1.15.2  Installing rake 12.1.0  Fetching coderay 1.1.2  Fetching colorize 0.8.1  Installing colorize 0.8.1  Fetching diskcached 1.1.3  Installing coderay 1.1.2  Fetching unf_ext 0.0.7.4  Fetching require_all 1.4.0  Installing unf_ext 0.0.7.4 with native extensions  Installing diskcached 1.1.3  Fetching excon 0.59.0  Installing excon 0.59.0  Installing require_all 1.4.0  Fetching multipart-post 2.0.0  Installing multipart-post 2.0.0  Fetching hashie 3.5.6  Installing hashie 3.5.6  Fetching httpclient 2.8.3  Fetching i18n 0.8.6  Installing httpclient 2.8.3  Installing i18n 0.8.6  Fetching json 2.1.0  Fetching method_source 0.8.2  Installing method_source 0.8.2  Installing json 2.1.0 with native extensions  Fetching mime-types-data 3.2016.0521  Installing mime-types-data 3.2016.0521  Fetching mini_portile2 2.3.0  Installing mini_portile2 2.3.0  Fetching netrc 0.11.0  Installing netrc 0.11.0  Fetching open-uri-cached 0.0.5  Installing open-uri-cached 0.0.5  Fetching parallel 1.12.0  Installing parallel 1.12.0  Fetching powerpack 0.1.1  Installing powerpack 0.1.1  Fetching ruby-progressbar 1.8.3  Installing ruby-progressbar 1.8.3  Fetching unicode-display_width 1.3.0  Installing unicode-display_width 1.3.0  Fetching sqlite3 1.3.13  Installing sqlite3 1.3.13 with native extensions  Fetching yajl-ruby 1.3.0  Installing yajl-ruby 1.3.0 with native extensions  Fetching parser 2.4.0.0  Installing parser 2.4.0.0  Fetching rainbow 2.2.2  Installing rainbow 2.2.2 with native extensions  Fetching everypolitician-popolo 0.8.0  Installing everypolitician-popolo 0.8.0  Fetching faraday 0.13.1  Installing faraday 0.13.1  Fetching pry 0.11.0  Installing pry 0.11.0  Fetching mime-types 3.1  Installing mime-types 3.1  Fetching nokogiri 1.8.1  Installing nokogiri 1.8.1 with native extensions  Fetching unf 0.1.4  Installing unf 0.1.4  Using sqlite_magic 0.0.6 from https://github.com/openc/sqlite_magic.git (at master@4df975e)  Using wikisnakker 0.9.1 from https://github.com/everypolitician/wikisnakker.git (at master@72dbb8b)  Using everypolitician 0.20.0 from https://github.com/everypolitician/everypolitician-ruby.git (at master@20582b1)  Fetching faraday_middleware 0.12.2  Fetching rubocop 0.50.0  Fetching domain_name 0.5.20170404  Installing faraday_middleware 0.12.2  Installing domain_name 0.5.20170404  Using scraperwiki 3.0.1 from https://github.com/openaustralia/scraperwiki-ruby.git (at morph_defaults@fc50176)  Fetching wikidata-client 0.0.10  Installing rubocop 0.50.0  Fetching http-cookie 1.0.3  Installing http-cookie 1.0.3  Fetching faraday-cookie_jar 0.0.6  Installing faraday-cookie_jar 0.0.6  Fetching rest-client 2.0.2  Installing wikidata-client 0.0.10  Installing rest-client 2.0.2  Fetching mediawiki_api 0.7.1  Installing mediawiki_api 0.7.1  Using wikidata-fetcher 0.21.0 from https://github.com/everypolitician/wikidata-fetcher.git (at master@9657b9b)  Bundle complete! 14 Gemfile dependencies, 47 gems now installed.  Gems in the groups development and test were not installed.  Bundled gems are installed into ./vendor/bundle.  Bundle completed (33.04s)  Cleaning up the bundler cache. -----> Detecting rake tasks   -----> Discovering process types  Procfile declares types -> scraper Injecting scraper and running... scraper.rb:16:in `rescue in sparql': Wikidata query SELECT DISTINCT ?item ?itemLabel ?start_date ?end_date ?constituency ?constituencyLabel ?party ?partyLabel WHERE { (RuntimeError) ?item p:P39 ?statement. ?statement ps:P39 wd:Q1939555; pq:P2937 wd:Q30579723 . OPTIONAL { ?statement pq:P580 ?start_date. } OPTIONAL { ?statement pq:P582 ?end_date. } OPTIONAL { ?statement pq:P768 ?constituency. } OPTIONAL { ?statement pq:P4100 ?party. } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } failed: SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed from scraper.rb:13:in `sparql' from scraper.rb:35:in `<main>'

Data

Downloaded 1533 times by everypolitician

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (135 KB) Use the API

rows 10 / 744

id name start_date end_date constituency constituency_id party party_id
Q40998214
Erhard Grundl
2017-10-24
Straubing
Q1008644
Green Party fraction
Q1007353
Q33309067
Sebastian Münzenmaier
2017-10-24
Mainz (electoral district)
Q1008388
AfD Bundestag fraction
Q42575708
Q15783644
Antje Lezius
2017-10-24
Kreuznach
Q1008328
CDU/CSU Bundestag fraction
Q1023134
Q16318408
Armin-Paulus Hampel
2017-10-24
Hameln-Pyrmont – Holzminden
Q1008252
AfD Bundestag fraction
Q42575708
Q110576
Veronika Bellmann
2017-10-24
Mittelsachsen
Q1008418
CDU/CSU Bundestag fraction
Q1023134
Q1080321
Christian Hirte
2017-10-24
constituency for the Bundestag election Eisenach – Wartburgkreis – Unstrut-Hainich-Kreis
Q1008120
CDU/CSU Bundestag fraction
Q1023134
Q1739640
Kersten Steinke
2017-10-24
Eichsfeld – Nordhausen – Unstrut-Hainich-Kreis I
Q1008122
Bundestag fraction Die Linke
Q1826856
Q40998541
Susanne Ferschl
2017-10-24
Ostallgäu
Q1008506
Bundestag fraction Die Linke
Q1826856
Q15813116
Sabine Poschmann
2017-10-24
Dortmund II
Q1008092
SPD Bundestag fraction
Q2207512
Q15813788
Ingrid Pahlmann
2019-08-01
CDU/CSU Bundestag fraction
Q1023134

Statistics

Average successful run time: 1 minute

Total run time: 1 day

Total cpu time used: 42 minutes

Total disk space used: 160 KB

History

  • Auto ran revision 818ac07b and failed .
    nothing changed in the database
  • Auto ran revision 818ac07b and failed .
    nothing changed in the database
  • Auto ran revision 818ac07b and failed .
    nothing changed in the database
  • Auto ran revision 818ac07b and failed .
    nothing changed in the database
  • Auto ran revision 818ac07b and failed .
    nothing changed in the database
  • ...
  • Created on morph.io

Show complete history