Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Connecting Preprints to Peer-reviewed Articles on Wikidata | Biopragmatics #46

Open
utterances-bot opened this issue Jan 3, 2023 · 1 comment
Open

Connecting Preprints to Peer-reviewed Articles on Wikidata | Biopragmatics #46

utterances-bot opened this issue Jan 3, 2023 · 1 comment

Comments

@utterances-bot
Copy link

Connecting Preprints to Peer-reviewed Articles on Wikidata | Biopragmatics

After the BioCypher preprint went up on the arXiv, I checked in on the missing co-author items list on the Scholia page that reflects my Wikidata entry. In addition to the several co-authors of the BioCypher manuscript that I don’t know personally, I was curious to see which other papers of mine did not have fully complete co-author annotations. This post has a few SPARQL queries that I used to look into this as well as a few ongoing questions I have about the relationship between distinct entries for preprints and published articles.

https://cthoyt.com/2023/01/02/wikidata-preprints.html
@egonw utterances
Copy link

egonw commented Jan 3, 2023

Try using this SPARQL and copy/paste the output at v2 QuickStatements (the first line should be "qid,P156", the header line:

SELECT ?qid ?P156
WHERE 
{
  VALUES ?author { wd:Q20895241 }
  ?preprint wdt:P31 wd:Q580922 ;
    wdt:P50 ?author ;
    rdfs:label ?preprintLabel .
  ?article wdt:P31 wd:Q13442814 ;
    wdt:P50 ?author ;
    rdfs:label ?label .
  OPTIONAL { ?preprint wdt:P577 ?preprintDate }
  OPTIONAL { ?article wdt:P577 ?articleDate }
  MINUS { ?preprint wdt:P156 ?followedBy }
  FILTER (LCASE(?preprintLabel) = LCASE(?label))
  FILTER (?preprint != ?article)
  FILTER (LANG(?preprintLabel) = "en")
  FILTER (LANG(?label) = "en")
  BIND (CONCAT(SUBSTR(str(?preprint),32),",") AS ?qid)
  BIND (SUBSTR(str(?preprint),32) AS ?P156)
}
ORDER BY DESC(?articleDate)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@egonw @utterances-bot