query-07d27731cf12cfb729ec8914375b661b

rq turtle/ttl

With open license portrait images ranked by how well-described they are in Wikidata

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:ImageGrid
SELECT ?person ?date_of_death ?age ?image
WHERE {
    ?person wdt:P509 wd:Q84263196 ; wdt:P31 wd:Q5 
    OPTIONAL { ?person wdt:P570 ?date_of_death }
    OPTIONAL { ?person wikibase:statements ?statements_count ; wikibase:sitelinks ?sitelinks_count ; wikibase:identifiers ?identifiers_count . BIND(?statements_count + ?sitelinks_count + ?identifiers_count AS ?rank)}
    OPTIONAL { ?person wdt:P569 ?dob ; wdt:P570 ?dod . BIND(YEAR(?dod)-YEAR(?dob) as ?age) }
    ?person wdt:P18 ?image .
  BIND(REPLACE(wikibase:decodeUri(CONCAT("File:", STRAFTER(STR(?image), "/wiki/Special:FilePath/"))), " ", "_") AS ?imageTitle)
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Categories";
                    wikibase:endpoint "commons.wikimedia.org";
                    mwapi:titles ?imageTitle.
    ?categoryTitle wikibase:apiOutput mwapi:category.
  }
  FILTER(?categoryTitle = "Category:CC-Zero"

Query found at