Wikidata:Database reports/items with P569 greater than P570
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: 2024-11-15 20:19, generally updated daily. The report is split into multiple tables up to 500,000 each (to prevent timeouts), and will work until there are more than 3.5 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 - 500000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 0 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | Abu Hurairah | Companion (Sahabi) of Muhammad (c.603–680) | 1744-01-01 | 0676-01-01 0679-01-01 |
1068 1065 |
| 2 | end | termination of something |
End of automatically generated list.
500000 - 1000000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 500000 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | Hermann Oberth | Austro-Hungarian-born German physicist and rocketry pioneer (1894-1989) | 2000-07-26 | 1989-12-28 | 11 |
| 2 | end | termination of something |
End of automatically generated list.
1000000 - 1500000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 1000000 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | Salem bin Laden | Saudi Arabian businessman (1946-1988) | 2001-09-11 | 1988-05-29 | 13 |
| 2 | end | termination of something |
End of automatically generated list.
1500000 - 2000000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 1500000 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | Võ Trường Toản | teacher (1795–1792) |
1795-01-01 | 1792-07-27 | 3 | ||
| 2 | end | termination of something | |||||
End of automatically generated list.
2000000 - 2500000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 2000000 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | end | termination of something |
End of automatically generated list.
2500000 - 3000000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 2500000 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | end | termination of something |
End of automatically generated list.
3000000 - 3500000
editThis 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) { { SELECT ?item ?bdate ?ddate { hint:Query hint:optimizer "None" . service bd:slice { ?item p:P570 ?pddate . bd:serviceParam bd:slice.offset 3000000 ; bd:slice.limit 500000 } ?item p:P569 ?pbdate . hint:Prior hint:rangeSafe true . ?pbdate ps:P569 ?bdate . hint:Prior hint:rangeSafe true . ?pddate ps:P570 ?ddate . FILTER(?bdate > ?ddate) ?pbdate psv:P569/wikibase:timePrecision ?bprec FILTER(?bprec >= 9) . ?pddate psv:P570/wikibase:timePrecision ?dprec FILTER(?dprec >= 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 | Muṭlaq ʻAbd al-Khāliq | Palestinian poet | 1910-01-01 1909-01-01 |
1356-01-01 | 554 553 |
| 2 | Manjak Pasha | Syrian poet | 1598-01-01 | 1080-01-01 | 518 |
| 3 | Mary Ajami | Syrian writer | 1888-01-01 | 1385-01-01 | 503 |
| 4 | حسين الحلافي | 1974-01-01 | 1905-01-01 | 69 | |
| 5 | end | termination of something |
End of automatically generated list.