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-05-12 07:34, 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 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) { { 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 | end | termination of something |
End of automatically generated list.
500000 - 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) { { 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 | end | termination of something |
End of automatically generated list.
1000000 - 1500000 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) { { 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 | Jesse Pomeroy | American murderer | 1859-11-29 | 1256-10-06 | 603 |
| 2 | end | termination of something |
End of automatically generated list.
1500000 - 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) { { 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 | end | termination of something |
End of automatically generated list.
2000000 - 2500000 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) { { 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 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) { { 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 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) { { 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 | end | termination of something |
End of automatically generated list.