DrThneed
Joined 11 February 2019
Interested in women in science, New Zealand, history. Currently doing a project on slave holders and slave traders. Member of Wikidata:WikiProject_New_Zealand
Useful tools
- File of useful bits and pieces for OpenRefine, Listeriabot, Sparql and the like
- How to use Mix'n'match to match items in a catalogue youtu.be/jE9ZvwYCNnQ
- How to use QuickStatements to upload OpenRefine edits to Wikidata youtu.be/F5FbsUb6Nek
- Workflow for adding NZ women bio to Wikipedia, inc Wikidata work
- URL shortener https://meta.wikimedia.org/wiki/Special:UrlShortener
- Video intro to author disambiguator tool and the slides
- Academics in Wikidata for beginners
Slave trade/slave owner editing
- Useful queries
Finding things
- Find entry with specific LBS identifier https://w.wiki/X32
- Ships (or other things) by name https://w.wiki/X37
- Items named after or owned by a specific individual https://w.wiki/X3J or https://w.wiki/X6v with depicts
- People with an LBS identifier with subject has role and show the people labels and the roles https://w.wiki/X2$
- People in LBS with their occupations https://w.wiki/X3G
- Checking the Historic England heritage list
- Find specific English heritage identifier in Wikidata https://w.wiki/X3o
- Find person who died between certain dates https://w.wiki/c2o
Progress
- People with an LBS identifier (any length) or occupation slave trader or slave holder, show things which are depicts/commemorates/named after/owned by/commissioned by, and show as map [277 results as at 26 June 2020] https://w.wiki/X33 as images https://w.wiki/X6w
- People with occupation slave trader or slave holder, otherwise as above (ie no LBS identifier required) https://w.wiki/X3w
- Same query for occupation slave and social classification slave https://w.wiki/X3q
- People with occupation slave holder or slave trader [377 people on 26 June 2020] https://w.wiki/X35
- Just people who are slave traders [306 on 26 June 2020] https://w.wiki/X36
- Count MPs who are slave traders or kids of slave traders, or have LBS identifier (not filtered for length). [Result 872 as at 26 June 2020] https://w.wiki/X34
- People with an LBS identifier and a Wikipedia page https://w.wiki/X3H
- Physical legacies (but not using phys leg id) of slave traders & slave owners, showing owned by, maintained by, operated by https://w.wiki/dTw
Link to Property talk page for LBS property Items with property 1009 on 26 June 2020 https://www.wikidata.org/wiki/Property_talk:P3023
Political stuff
Query for candidates in 2020 NZ general election, showing electoral district qualifier of candidacy statement
Other QueriesItalic text
- https://w.wiki/gjs to show Big Things in New Zealand
- https://w.wiki/5Ds to show citizenship of creator of photo pub in partic book
- https://w.wiki/5Dt
- https://w.wiki/aMB to show museums in NZ missing coordinate location
- https://w.wiki/ki6 doctoral theses from institution (in this case Uni Otago)
note to self: if you didn't want the creator column but wanted to know the country, you could use a property path ... they're quite powerful:
SELECT ?item ?itemLabel ?country ?countryLabel WHERE { ?item wdt:P31 wd:Q125191. ?item wdt:P1433 wd:Q64666052 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } ?item wdt:P170/wdt:P27 ?country . # means get the P27 value for the P170 value }
![]() | This user loves OpenRefine. |
Babel user information |
---|
Users by language |