query-0ea6b06d27c740737faa839ad35ae7cf

rq turtle/ttl

TODO

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?s ?desc ?dob ?dobvalue WHERE {
  ?s wdt:P31 wd:Q5.                           # must be human
  ?s  p:P569/psv:P569 [wikibase:timePrecision ?precision; wikibase:timeValue ?birth] .
  ?s  p:P569/ps:P569 ?dobvalue .
  bind(if(?precision=11,?birth,if(?precision=10,concat(month(?birth)," ",year(?birth)),if(?precision<9,concat(STR(?birth),' precision=',STR(?precision)),year(?birth)))) as ?dob)                
  ?s wdt:P19 ?place.                         # must have a place of birth
  ?place (wdt:P131*/wdt:P706*) wd:Q5705.     # place of birth must be located within or on Catelonia
  MINUS { ?s wdt:P570 _:b5. }                # must be alive - no date of death
  ?s rdfs:label ?desc.                       # must have a label ...
  FILTER((LANG(?desc)) = "ca")               # label must be in Catalan
  ?article schema:about ?s.                  # must have a sitelink
  ?article schema:inLanguage "ca".           # sitelink must be (by inference) to the Catalan wikipedia
  FILTER((?birth > "1898-01-01"^^xsd:dat) && (?birth < "1918-01-01"^^xsd:dat)|| ?precision<9 )
}
 GROUP BY ?s ?desc ?dob ?dobvalue            # right now the group by serves no purpose whatsoever - there are to aggregates in the select
ORDER BY ?dobvalue
# LIMIT 100                                    # obvs, only give me 100 results

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2019/02