Wikidata:WikiProject Linked Data for Production/2020-October-12 Wikidata Working Hour

October 12, 2020 Wikidata Working Hour[edit]

Monday, October 12, 2020 at 8:00am PDT / 11:00am EDT / 15:00 UTC / 5:00pm CEST

Logistics[edit]

Join via Zoom: https://stanford.zoom.us/j/92827432271?pwd=QXgvV2dCcGltQlo2WjJzMTJtUnpPQT09
Password: 173219
Create a Wikimedia account if you don't already have one

Metrics[edit]

Login to the Event Dashboard with your Wikimedia account to keep track of your edits today

Resources[edit]

There is a query for Wikidata items for people with American citizenship and occupation writer who do not have a Goodreads identifier at: https://w.wiki/gxv

We can also modify the search to query for other identifiers or demographic groups if there's something specific you would like to work on.

Getting Started[edit]

Please go to the Google Sheet at https://docs.google.com/spreadsheets/d/1ghPS2jcIeCYWJgz7vZUmFh6J_XWUuFFaOgUb-L7kBiM/edit?usp=sharing and select a range of authors you would like to work on, and put your name in column C so we don't duplicate each other's work.

You can click on the Q number in Column A to see that writer's Wikidata item.

Search Goodreads for that name, and when you see a book by that writer click on their name. The number in the Goodreads URL preceding their name is their Goodreads identifier.

For example: In https://www.goodreads.com/author/show/67081.Klaus_Mann?from_search=true&from_srp=true Klaus Mann's Goodreads identifier is 67081

Verify you have the Wikidata item for the same writer (checking their Wikipedia page for the book you found them under in Goodreads can be a good way to do this) and add the identifier. This can be done by going to the bottom of the Identifiers block and clicking "add statement."

Then select "Goodreads author ID" in the left box, putting the Goodreads identifier number in the right, and clicking "Publish." You can then click on the number and make sure it goes to the right page in Goodreads if you like.

SPARQL Queries for generating lists[edit]

If you want to run your own query you can adapt this one:

The following query uses these:

Items: human (Q5)   , United States of America (Q30)   , writer (Q36180)

Properties: instance of (P31)  

, country of citizenship (P27)  

, occupation (P106)  

, Goodreads author ID (P2963)  

SELECT ?item ?itemLabel 
WHERE 
{
  ?item wdt:P31 wd:Q5. #instance of (P31) human (Q5)
  ?item wdt:P27 wd:Q30. #country of citizenship (P27) is United States (Q30) 
  ?item wdt:P106 wd:Q36180. #occupation (P106) is writer (Q36180)
  MINUS { ?item wdt:P2963 [] } .
  
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}