DrThneed

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

1. File of useful bits and pieces for OpenRefine, Listeriabot, Sparql and the like
2. How to use Mix'n'match to match items in a catalogue youtu.be/jE9ZvwYCNnQ
3. How to use QuickStatements to upload OpenRefine edits to Wikidata youtu.be/F5FbsUb6Nek
4. Workflow for adding NZ women bio to Wikipedia, inc Wikidata work
5. URL shortener https://meta.wikimedia.org/wiki/Special:UrlShortener
6. Video intro to author disambiguator tool and the slides
7. Academics in Wikidata for beginners

Slave trade/slave owner editing

Useful queries

Finding things

1. Find entry with specific LBS identifier https://w.wiki/X32
2. Ships (or other things) by name https://w.wiki/X37
3. Items named after or owned by a specific individual https://w.wiki/X3J or https://w.wiki/X6v with depicts
4. People with an LBS identifier with subject has role and show the people labels and the roles https://w.wiki/X2$
5. People in LBS with their occupations https://w.wiki/X3G
6. Checking the Historic England heritage list
7. Find specific English heritage identifier in Wikidata https://w.wiki/X3o
8. Find person who died between certain dates https://w.wiki/c2o

Progress

1. 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
2. People with occupation slave trader or slave holder, otherwise as above (ie no LBS identifier required) https://w.wiki/X3w
3. Same query for occupation slave and social classification slave https://w.wiki/X3q
4. People with occupation slave holder or slave trader [377 people on 26 June 2020] https://w.wiki/X35
5. Just people who are slave traders [306 on 26 June 2020] https://w.wiki/X36
6. 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
7. People with an LBS identifier and a Wikipedia page https://w.wiki/X3H
8. 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

1. https://w.wiki/gjs to show Big Things in New Zealand
2. https://w.wiki/5Ds to show citizenship of creator of photo pub in partic book
3. https://w.wiki/5Dt
4. https://w.wiki/aMB to show museums in NZ missing coordinate location
5. 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
en-N This user has a native understanding of English.
Users by language