query-9777e40f34e2049e025c60d169810e1b

rq turtle/ttl

Propertiesinstance of (P31)facet of (P1269)PM20 folder ID (P4293)PM20 geo code (P8483)number of works accessible online (P5592)series ordinal (P1545)

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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?geo ?geoLabel ?geoCode ?folderCount ?docCount
where {
  {
    select ?geo (count(*) as ?folderCount) (sum(?folderDocCount) as ?docCount)
    where {
      ?item wdt:P31 wd:Q91257459 ;
            wdt:P1269 ?geo .
      # document counts
      optional {
        ?item p:P4293 ?statement2 .
        ?statement2 pq:P5592 ?folderDocCount .
        filter(isLiteral(?folderDocCount))
      }
    }
    group by ?geo
  }
  optional {
    ?geo p:P8483 ?statement3 .
    ?statement3 ps:P8483 ?geoCode ;
                pq:P1545 ?sortCode .
  }

  service wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
}
order by ?sortCode

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_20th_Century_Press_Archives/Use_cases