query-ae52bf21f3342775dbe864f9b92c8536
What do you mean by “nature of the affiliation”? For Harvard University I can offer: 14:37, 16 December 2016 (UTC) Andy's edits; Talk to Andy); Pigsonthewing (Andy Mabbett people without an ORCID iD, per organisation? living: Thank you. Nature of the affiliation == "employer" and/ or "alma mater". Also, could we have a similar query, for MisterSynergy@15:00, 16 December 2016 (UTC)) talk (MisterSynergy, which might be useful for non-academic organizations. I’ll write another query for the other request. —(P749)parent organization (for employer). If necessary, I could start to look for a more descriptive output, but technically you can already distinguish the nature with this query. I also added wdt:P108 (for alma mater) or wdt:P69 which is either ?pOkay I understand, and extended the query above by a parameter The other one:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?organization ?organizationLabel ?organizationDescription ?p WHERE {
?item (p:P69|p:P108) [ (ps:P69|ps:P108) ?organization ] .
?organization (wdt:P361|wdt:P749)* wd:Q13371 .
?item ?p ?organization .
?item wdt:P31 wd:Q5 .
MINUS { ?item wdt:P496 ?dummy0 . }
MINUS { ?item wdt:P570 ?dummy1 . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}