Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
Sign upOn /missing subpage for awards aspect, add papers with author name strings matching those of awardees #844
Milestone
Comments
Daniel-Mietchen
added this to To do
in 3. Improving integration with WikiCite curation workflows, e.g. around missing data
via automation
Oct 7, 2019
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
Here is a draft query for that: SELECT
(COUNT(?work) AS ?count)
?author_name
(CONCAT(
'https://tools.wmflabs.org/author-disambiguator/?doit=Look+for+author&name=',
ENCODE_FOR_URI(?author_name)) AS ?author_resolver_url)
WHERE {
{
SELECT DISTINCT ?author_name {
?recipient p:P166 ?award_statement .
?award_statement ps:P166 wd:Q63208574 .
?recipient skos:altLabel | rdfs:label ?author_name_ .
# The SELECT-DISTINCT-BIND trick here is due to Stanislav Kralin
# https://stackoverflow.com/questions/53933564
BIND (STR(?author_name_) AS ?author_name)
}
}
OPTIONAL { ?work wdt:P2093 ?author_name . }
}
GROUP BY ?author_name
ORDER BY DESC(?count) It works fine for Fellow of the African Academy of Sciences (Q63208574) as in the example but times out for things like Nobel Prize in Physiology or Medicine (Q80061), so would need some further refinement. |
This comment has been minimized.
This comment has been minimized.
I added a LIMIT, and the query now works fine for complex things like Nobel Prizes as well: SELECT
(COUNT(?work) AS ?count)
?author_name
(CONCAT(
'https://tools.wmflabs.org/author-disambiguator/?doit=Look+for+author&name=',
ENCODE_FOR_URI(?author_name)) AS ?author_resolver_url)
WHERE {
{
SELECT DISTINCT ?author_name {
?recipient p:P166 ?award_statement .
?award_statement ps:P166 wd:Q80061 .
?recipient skos:altLabel | rdfs:label ?author_name_ .
# The SELECT-DISTINCT-BIND trick here is due to Stanislav Kralin
# https://stackoverflow.com/questions/53933564
BIND (STR(?author_name_) AS ?author_name)
}
LIMIT 2000
}
OPTIONAL { ?work wdt:P2093 ?author_name . }
}
GROUP BY ?author_name
ORDER BY DESC(?count) |
Daniel-Mietchen
moved this from To do
to In progress
in 3. Improving integration with WikiCite curation workflows, e.g. around missing data
Nov 29, 2019
This comment has been minimized.
This comment has been minimized.
Now with filtering for counts > 0: SELECT
(COUNT(?work) AS ?count)
?author_name
(CONCAT(
'https://tools.wmflabs.org/author-disambiguator/?doit=Look+for+author&name=',
ENCODE_FOR_URI(?author_name)) AS ?author_resolver_url)
WHERE {
{
SELECT DISTINCT ?author_name {
?recipient p:P166 ?award_statement .
?award_statement ps:P166 wd:Q80061 .
?recipient skos:altLabel | rdfs:label ?author_name_ .
# The SELECT-DISTINCT-BIND trick here is due to Stanislav Kralin
# https://stackoverflow.com/questions/53933564
BIND (STR(?author_name_) AS ?author_name)
}
LIMIT 2000
}
OPTIONAL { ?work wdt:P2093 ?author_name . }
}
GROUP BY ?author_name
HAVING (?count > 0)
ORDER BY DESC(?count) |
3. Improving integration with WikiCite curation workflows, e.g. around missing data
automation
moved this from In progress
to Done
Dec 8, 2019
Daniel-Mietchen
added a commit
that referenced
this issue
Dec 8, 2019
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Daniel-Mietchen commentedOct 7, 2019
similar to the one we have on a /missing page for authors