tmtmtmtm

# Update 'position held' statements for Members of the Parliament of Ghana 
# to point at the correct constituency items, after merging
#
# wd sparql migrate-merged-constituencies.rq | jq -r '.[] | "\(.ps) P768 \(.old) \(.new)"' | wd update-qualifier --batch --summary "Update constituencies qualifiers after merges"

SELECT DISTINCT ?ps ?id ?old ?new WHERE {
  ?id p:P39 ?ps .
  ?ps ps:P39 wd:Q61659845 ; pq:P768 ?old .
  ?old owl:sameAs ?new .
}

tmtmtmtm

tmtmtmtm

# wd sparql elected_in_Malawi-General-Election.rq | jq -r '.[] | "\(.ps) P2715 Q15206416 Q61732445"' | wd update-qualifier --batch --summary "Switch elected in from Malawian general election to the legislative election"
SELECT ?ps ?item ?itemLabel WHERE {
  ?item p:P39 ?ps .
  ?ps ps:P39 wd:Q21295990 ; pq:P2715 wd:Q15206416.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

tmtmtmtm

Step 1: Set up the Report

• Report page = https://www.wikidata.org/wiki/Wikidata:WikiProject_every_politician/Azerbaijan/data/Assembly/6th

Setting this up first lets us see what information is already in Wikidata, and makes it easy to see progress.

This is mostly a cut'n'paste job from the report for the previous term, with the P2937 (legislative term) qualifier changed.

tmtmtmtm

# Generated via: http://tinyurl.com/ydetfb96
Q50772223	P39	Q50772223-42D92740-6741-4BD5-91A1-45271EFE8D06	P2937	Q48799610
Q50847261	P39	Q50847261-3D888B95-42D6-4C99-8B56-4087BDB8E1C6	P2937	Q48799610
Q50847271	P39	Q50847271-9778831E-B673-45A6-84BF-246BDDF6F0F4	P2937	Q48799610
Q50875173	P39	Q50875173-AEF7EF37-5399-4F35-8A0B-337970B320B5	P2937	Q48799610
Q50875679	P39	Q50875679-72015D3D-A2F3-473A-83B1-11AA8CCC97F2	P2937	Q48799610
Q50984576	P39	Q50984576-1CC736EB-FB5D-46C4-BCD2-CEC4C743E35B	P2937	Q48799610
Q51026222	P39	Q51026222-4091F57E-933A-45FB-9848-8347EB4E56E0	P2937	Q48799610
Q51027227	P39	Q51027227-3394C5B0-7153-4E2A-82FB-8DD75B415F2C	P2937	Q48799610
Q51027386	P39	Q51027386-CD5BAD68-096D-4527-A999-099034AC2C99	P2937	Q48799610

tmtmtmtm

#!/bin/env ruby
# frozen_string_literal: true

# Produce QuickStatements for creating missing constituency items, 
# and adding 'instance of' to existing ones (most of which are missing it)

require 'pry'
require 'scraped'
require 'wikidata_ids_decorator'

tmtmtmtm

Last week we got a new Wikidata property for "Northern Ireland Assembly ID"

My goal this morning was to add that for all members, current and historic.

Step 1: Get the IDs

The Northern Ireland Assembly has a useful API that can give us all this data, so I knocked up a quick script to get them all: https://github.com/everypolitician-scrapers/ni-assembly-members/blob/master/scraper.rb

I've written hundreds of scrapers like this, and can cobble something like this together from previous versions really quickly. The only part that took any time was splitting out the prefixes and suffixes from people's names, but even that was based on a previous scraper

tmtmtmtm

#!/bin/env ruby

# Find everyone who has a P39 with a party of the "USR" disambiguation page
# and change it to the "Save Romania Union" item.

require 'csv'
require 'rest-client'

WIKIDATA_SPARQL_URL = 'https://query.wikidata.org/sparql'

tmtmtmtm

#!/bin/env ruby
# frozen_string_literal: true

require 'csv'
require 'pry'
require 'rest-client'

#---------------------------------------------------------------------------
# Find all members of the 37th Eduskunta with no P4100 (parliamentary group)
# and add one from 

tmtmtmtm

#!/bin/env ruby

require 'csv'
require 'rest-client'

WIKIDATA_SPARQL_URL = 'https://query.wikidata.org/sparql'

def sparql(query)
  result = RestClient.get WIKIDATA_SPARQL_URL, accept: 'text/csv', params: { query: query }
  CSV.parse(result.body, headers: true, header_converters: :symbol)