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). This report is limited to about 100 items for performance reasons.

Last update: 2021-05-12 03:59, generally updated daily. The report is splitted into 3 tables up to 1'000'000 each (to prevent timeouts), and will work until there are less than 3 million items with date of death. After that just add a new section with updated offset. Ignore the end (Q12769393) element - it was added to bypass internal Listeria issue.


0 - 1000000[edit]

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

WDQS | PetScan | TABernacle | Find images Recent changes | Query: SELECT ?item ?bdate ?ddate (YEAR(?bdate) - YEAR(?ddate) AS ?delta) { hint:Query hint:optimizer "None" . { service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 0 ; bd:slice.limit 1000000 } ?pddate ps:P570 ?ddate . ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . FILTER(?bdate > ?ddate) ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 9) . ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9 && ?bprec <= ?dprec) . FILTER (!EXISTS{?pddate wikibase:rank wikibase:DeprecatedRank}) FILTER (!EXISTS{?pbdate wikibase:rank wikibase:DeprecatedRank}) ?item wdt:P31 wd:Q5 } UNION { BIND(wd:Q12769393 AS ?item) } # otherwise listeria fails with "No items to show" } ORDER BY DESC(?delta)
number Person description Birth Death Delta
1 Moritz Hochschild Bolivian businessman (1881-1965) 18813-01-01 1965-06-12
1965-01-01
16848
2 end termination of something
End of automatically generated list.

1000000 - 2000000[edit]

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

WDQS | PetScan | TABernacle | Find images Recent changes | Query: SELECT ?item ?bdate ?ddate (YEAR(?bdate) - YEAR(?ddate) AS ?delta) { hint:Query hint:optimizer "None" . { service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 1000000 ; bd:slice.limit 1000000 } ?pddate ps:P570 ?ddate . ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . FILTER(?bdate > ?ddate) ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 9) . ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9 && ?bprec <= ?dprec) . FILTER (!EXISTS{?pddate wikibase:rank wikibase:DeprecatedRank}) FILTER (!EXISTS{?pbdate wikibase:rank wikibase:DeprecatedRank}) ?item wdt:P31 wd:Q5 } UNION { BIND(wd:Q12769393 AS ?item) } # otherwise listeria fails with "No items to show" } ORDER BY DESC(?delta)
number Person description Birth Death Delta
1 Tránsito Amaguaña Ecuadorian indigenous activist 19009-09-10 2009-05-10 17000
2 end termination of something
End of automatically generated list.

2000000 - 3000000[edit]

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

WDQS | PetScan | TABernacle | Find images Recent changes | Query: SELECT ?item ?bdate ?ddate (YEAR(?bdate) - YEAR(?ddate) AS ?delta) { hint:Query hint:optimizer "None". { service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 2000000 ; bd:slice.limit 1000000 } ?pddate ps:P570 ?ddate . ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . FILTER(?bdate > ?ddate) ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 9) . ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9 && ?bprec <= ?dprec) . FILTER (!EXISTS{?pddate wikibase:rank wikibase:DeprecatedRank}) FILTER (!EXISTS{?pbdate wikibase:rank wikibase:DeprecatedRank}) ?item wdt:P31 wd:Q5 } UNION { BIND(wd:Q12769393 AS ?item) } # otherwise listeria fails with "No items to show" } ORDER BY DESC(?delta)
number Person description Birth Death Delta
1 Richard Duncan Radcliffe British antiquary (1843-1925) 1843-01-01 0925-01-01 918
2 Abraham of Cratia Syrian saint 0474-01-01 0366-01-01 108
3 Eva Kotchever Polish feminist writer 1981-01-01 1943-12-17
1943-01-01
38
4 Vicenta Laparra de la Cerda Spanish person (1931–1905) ♀ 1931-04-01 1905-01-29 26
5 Karl Heinrich Sohl businessperson (1883–1863) ♂ 1883-07-20 1863-10-18 20
6 Lha Tsün Tulku Lozang Tubten Gelek Rabgyé Person (1984–1967) 1984-01-01 1967-01-01 17
7 1981-01-01 1966-01-01 15
8 Henricus Scherer geographer, cartographer, and Jesuit (24–21) ♂ 0024-04-01 0021-11-01 3
9 end termination of something
End of automatically generated list.