query-f66f7e90ed11be1ff16607fcc9f6744a

rq turtle/ttl

Recently deceased SELECT ?item ?itemLabel ?itemDescription ?article_no ?cocLabel ?dob ?pobLabel ?dod ?podLabel ?pobuLabel WITH { SELECT ?item ?dod WHERE { ?item wdt:P31 wd:Q5; wdt:P570 ?dod.

BIND(NOW() - "1920-01-31"^^xsd:dateTime AS ?mintime)
BIND(?dod - "1920-01-01"^^xsd:dateTime AS ?dodtime)
FILTER(?dod > "2022-01-01"^^xsd:dateTime && ?dod < NOW())
FILTER(?dodtime > ?mintime)

} } AS %i WHERE { INCLUDE %i

OPTIONAL { ?article_no schema:about ?item; schema:isPartOf https://no.wikipedia.org/. } OPTIONAL { ?item wdt:P569 ?dob. } OPTIONAL { ?item wdt:P27 ?coc. } OPTIONAL { ?item wdt:P19 ?pob. } OPTIONAL { ?item wdt:P20 ?pod. } OPTIONAL { ?item wdt:P119 ?pobu. }

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } ORDER BY DESC(?dod)

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 bd: <http://www.bigdata.com/rdf#>
#Recently deceased
SELECT
  ?item ?itemLabel ?itemDescription ?article_no
  ?cocLabel ?dob ?pobLabel ?dod ?podLabel ?pobuLabel
WHERE {
   {
  SELECT ?item ?dod
  WHERE {
    ?item wdt:P31 wd:Q5;
      wdt:P570 ?dod.

    BIND(NOW() - "1920-01-31"^^xsd:date AS ?mintime)
    BIND(?dod - "1920-01-01"^^xsd:date AS ?dodtime)
    FILTER(?dod > "2022-01-01"^^xsd:date && ?dod < NOW())
    FILTER(?dodtime > ?mintime)
  }
}
  OPTIONAL {
    ?article_no schema:about ?item;
      schema:isPartOf <https://no.wikipedia.org/>.
  }
  OPTIONAL { ?item wdt:P569 ?dob. }
  OPTIONAL { ?item wdt:P27 ?coc. }
  OPTIONAL { ?item wdt:P19 ?pob. }
  OPTIONAL { ?item wdt:P20 ?pod. }
  OPTIONAL { ?item wdt:P119 ?pobu. }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?dod)

Query found at

• https://www.wikidata.org/wiki/User:Infrastruktur/Sandbox2