User:Charles Matthews/Cambridge Wikidata Workshop 20 October 2018

Training links for Wikidata:ContentMine/Cambridge Wikidata Workshop, 20 October 2018

ORCIDs and TopicMatcher edit

#People with ORCID ID, occupation researcher, given name, no family name or sex 
SELECT DISTINCT ?item ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
             wdt:P106 wd:Q1650915;
             wdt:P496 [ ];
             wdt:P735 [ ].
       MINUS {?item wdt:P21 [ ]}.
       MINUS {?item wdt:P734 [ ]}
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
Try it!

Talk edit

Focus list and MEDRS session edit

#Focus list items, no license, PMCID
SELECT ?item ?itemLabel 
WHERE {?item wdt:P31 wd:Q13442814;
             wdt:P5008 wd:Q55439927;
             wdt:P932 ?pmcid.
      MINUS {?item wdt:P275 [ ]}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
      }
Try it!
#Focus list items, no license, no PMCID, having DOI
SELECT ?item ?itemLabel ?doi
WHERE {?item wdt:P31 wd:Q13442814;
             wdt:P5008 wd:Q55439927;
             wdt:P356 ?doi.
      MINUS {?item wdt:P932 [ ]}.
      MINUS {?item wdt:P275 [ ]}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
      }
Try it!
#Focus list items, no license, no PMCID, no DOI
SELECT ?item ?itemLabel ?date
WHERE {?item wdt:P31 wd:Q13442814;
             wdt:P5008 wd:Q55439927;
             wdt:P577 ?date. 
      MINUS {?item wdt:P356 [ ]}.
      MINUS {?item wdt:P932 [ ]}.
      MINUS {?item wdt:P275 [ ]}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
      }
Try it!
#Journals with CC-by license
SELECT ?item ?itemLabel
WHERE {?item wdt:P31 wd:Q5633421;
             wdt:P275 wd:Q6905323.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
      }
Try it!