Wikidata:Database reports/items with P569 greater than P570

From Wikidata
Jump to navigation Jump to search

Items with instance of (P31) human (Q5) and date of birth (P569) > date of death (P570).

Last update: 2020-01-22 08:51, generally updated daily.


This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | YASGUI | TABernacle | Find images Recent changes | Query: SELECT ?item ?delta WITH { SELECT DISTINCT ?item ?bdate ?ddate WHERE { ?item wdt:P569 ?bdate; wdt:P570 ?ddate; wdt:P31 wd:Q5 . FILTER(YEAR(?bdate) > YEAR(?ddate)) . } } AS %subquery WHERE { INCLUDE %subquery . BIND(YEAR(?bdate) - YEAR(?ddate) AS ?delta) . MINUS { ?item p:P569/psv:P569/wikibase:timePrecision ?bprec . FILTER(?bprec < 9) } MINUS { ?item p:P570/psv:P570/wikibase:timePrecision ?dprec . FILTER(?dprec < 9) } MINUS { ?item wdt:P793 wd:Q21560280 } MINUS { ?item wdt:P793 wd:Q22004151 } } ORDER BY DESC(?delta)
number Person description Birth Death Delta
1 János Aczél Hungarian-Canadian mathematician 1924-12-26 2020-01-01 401
2 Henry Uys cyclist 1983-01-30 1905-06-27 78
3 Ephrem Tewelde cyclist 1977-11-27 1905-06-25 72
End of automatically generated list.