Open main menu

MartinPoulter

Joined 24 November 2012

TrainingEdit

Wikidata QueriesEdit

I am learning about SPARQL and the Query Service so I can make interesting visualisations for research and education. A sub-page lists my example queries.

PropertiesEdit

Puzzle gamesEdit

I've contributed some games to Wikidata:Everything is connected.

Visualisations I use in presentationsEdit

Contributing to WikidataEdit

Getting data out of WikidataEdit

Overviews of WikidataEdit

Wikidata partnershipsEdit

Other SPARQLEdit

Me in WikidataEdit

I've done about 230,000 edits through User:QuickStatementsBot.

Plomer book in WikidataEdit

SELECT ?personLabel (YEAR(?floruit) AS ?year) ?link WHERE {
?bio wdt:P1433/wdt:P629? wd:Q40901539. # biography in the book
?person wdt:P1343 ?bio.       # person subject of the biography
?person wdt:P937 wd:Q34217.   # person worked in Oxford
?person wdt:P1317 ?floruit.   # year when person was active
?link schema:about ?bio.      # link to transcribed biography
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ?year

Try it!

Plomer book as a timelineEdit

#defaultView:Timeline{"hide": "?floruit"}
SELECT ?personLabel ?floruit (year(?floruit) as ?year) WHERE {
?bio wdt:P1433/wdt:P629? wd:Q40901539. # biography in the book
?person wdt:P1343 ?bio.       # person subject of the biography
?person wdt:P937 wd:Q34217.   # person worked in Oxford
?person wdt:P1317 ?floruit.   # year when person was active
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ?year

Try it!