query-8f1398be234f6b055f41c39b7195228e

rq turtle/ttl

. You can check whether an item has an image on Wikidata using the commented-out line. PetScanThe query above, in English, is more or less saying "select every person who has recieved a Honda Sports Award or a kind of Honda Sports Award, who was educated at a school that is a higher education institution or some kind of higher education institution." It's not simple to filter on Wikipedia pages having images from within the Wikidata query service (I'm not entirely sure if it's possible); however you should be able to do that with , appear multiple times in the list because they have multiple higher education institutions. (Q6377194)Kathy Butler Note that some people, such as If you have your spreadsheet in the form of Wikipedia article titles the following modification might be useful, to have it output Wikipedia article titles instead of labels:

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 schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?person ?articleTitle ?school ?schoolLabel WHERE {
  ?person wdt:P166/wdt:P31 wd:Q5892712.
  ?person wdt:P69 ?school.
  ?school wdt:P31/wdt:P279* wd:Q38723.
  ?sitelink schema:about ?person.
  ?sitelink schema:isPartOf <https://en.wikipedia.org/>.
  ?sitelink schema:name ?articleTitle.
  # uncomment the line below to restrict to those without an image in Wikidata
  # MINUS {?person wdt:P18 []}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/07