query-0e4666f4ab43658a4ed6607285fe5319

Dates showed with year precision

Use at

https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?person ?year
WHERE {
  ?person p:P569/psv:P569 [ wikibase:timePrecision "9"^^xsd:integer ; wikibase:timeValue ?time ] .
  BIND(YEAR(?time) AS ?year)
}
LIMIT 10

Query found at

https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?person"):::projected v1("?time") v3("?year"):::projected a2((" ")) a1((" ")) c2(["9^^xsd:integer"]):::literal a1 --"wikibase:timePrecision"--> c2 a1 --"wikibase:timeValue"--> v1 v2 --"p:P569"--> a2 a2 --"p:statement/value/P569"--> a1 bind0[/"year-from-dateTime(?time)"/] v1 --o bind0 bind0 --as--o v3