User:MartinPoulter

From Wikidata
Jump to navigation Jump to search
Babel user information
en-GB-N This user has a native understanding of British English.
en-N This user has a native understanding of English.
Wikidata-rollbacker.svgThis user has rollback rights on Wikidata. (verify)
Wikipedia-logo-v2.svg This user has a page on English Wikipedia.
Commons-logo.svgThis user has a page on Wikimedia Commons.
Wikisource-logo.svgThis user has a page on Wikisource.
Users by language

My name: Martin (Q18002399) Poulter (Q7235572).

What I've created in mainspace

Training[edit]

Wikidata Queries[edit]

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.

Past work[edit]

From October 2016 to October 2019, I was employed as the Wikimedian In Residence at the University of Oxford, based at the Bodleian Libraries. This involved some paid editing to share data from and about GLAMs and research projects with Wikidata.

Properties[edit]

I proposed Electronic Enlightenment ID (P3429), ESTC citation number (P3939), dissertation submitted to (P4101), Atlas of Hillforts ID (P4102), EMLO location ID (P4672), Japan Search name ID (P6698), Dictionary of Irish Biography ID (P6829)

Puzzle games[edit]

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

Visualisations I use in presentations[edit]

For the definitive list see Wikidata:Tools/External_tools.

Contributing to Wikidata[edit]

Getting data out of Wikidata[edit]

Overviews of Wikidata[edit]

Wikidata partnerships[edit]

Other SPARQL[edit]

Me in Wikidata[edit]

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

Plomer book in Wikidata[edit]

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!

Connecting the Plomer book to the DNB[edit]

#defaultView:Graph
SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel
WITH { SELECT ?item1 WHERE {
VALUES ?item1 {wd:Q41092013 wd:Q7341875 wd:Q18917186 wd:Q19389637 wd:Q40901539 wd:Q36180 wd:Q19066456 wd:Q18877169 wd:Q998550 wd:Q182436 wd:Q15987216 wd:Q84}
} } AS %item1
WITH {SELECT (?item1 AS ?item2) WHERE {INCLUDE %item1} } AS %item2
WHERE {
  INCLUDE %item1.
  INCLUDE %item2.
?item1 ?prop ?item2.
?edge wikibase:directClaim ?prop ; a wikibase:Property
OPTIONAL {?item1 wdt:P18 ?image}
OPTIONAL {?item2 wdt:P18 ?image2}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Plomer book as a timeline[edit]

#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!