From Wikidata
Jump to navigation Jump to search

Interested in women in science, New Zealand, history. Currently doing a project on slave holders and slave traders. Member of Wikidata:WikiProject_New_Zealand and Wikidata:WikiProject_Performing_arts and Wikidata:WikiProject_Early_Modern_England_and_Wales

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
  3. How to use QuickStatements to upload OpenRefine edits to Wikidata
  4. Workflow for adding NZ women bio to Wikipedia, inc Wikidata work
  5. URL shortener
  6. Video intro to author disambiguator tool and the slides
  7. Academics in Wikidata for beginners

Performing arts stuff

  1. instance of theatres in New Zealand (21 as of Jan 2021)
  2. instance of music venue in New Zealand (2 as of Jan 2021)
  3. instance of event venue in New Zealand (109 as of Jan 2021)
  4. Tabernacle for event venues in New Zealand - basic info (location, website etc)
  5. awards in New Zealand

Slave trade/slave owner editing

Useful queries

Finding things

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


  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] as images
  2. People with occupation slave trader or slave holder, otherwise as above (ie no LBS identifier required)
  3. Same query for occupation slave and social classification slave
  4. People with occupation slave holder or slave trader [377 people on 26 June 2020]
  5. Just people who are slave traders [306 on 26 June 2020]
  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]
  7. People with an LBS identifier and a Wikipedia page
  8. Physical legacies (but not using phys leg id) of slave traders & slave owners, showing owned by, maintained by, operated by

Link to Property talk page for LBS property Items with property 1009 on 26 June 2020

Political stuff Query for candidates in 2020 NZ general election, showing electoral district qualifier of candidacy statement

Other QueriesItalic text

  1. to show Big Things in New Zealand
  2. to show citizenship of creator of photo pub in partic book
  4. to show museums in NZ missing coordinate location
  5. doctoral theses from institution (in this case Uni Otago)
  6. Royal Society Fellows without Wikipedia pages
  7. above with gender so can look for women fellows with no page
  8. New Zealand scholarly articles with no description

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
OpenRefine favicon (2018-present).svgThis user loves OpenRefine.
Babel user information
en-N This user has a native understanding of English.
Users by language