Wikidata:Database reports/items with P569 greater than P570
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: 2024-04-19 14:02, 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 | Margaret Moseley | (died 1608) | 1901-08-11 | 1608-01-31 | 293 |
| 2 | Joseph Louis Gay-Lussac | French chemist and physicist (1778–1850) | 1999-12-06 | 1850-05-09 | 149 |
| 3 | 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 | 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 | Jacques Bertaux | French artist, active 1776 | 1745-01-01 1380-01-01 |
1230-01-01 | 515 150 |
| 2 | Carles Salvador i Gimeno | Spanish writer (1893-1955) | 2021-01-20 | 1955-07-07 | 66 |
| 3 | 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 | Elizabeth Peratrovich | activist (1911–1958) ♀ |
1911-01-01 0004-07-01 |
0001-12-01 | 1910 3 | ||
| 2 | Max Winkler | Film music industry pioneer, 1888-1965 | 1988-03-15 | 1965-10-05 | 23 | ||
| 3 | end | termination of something | |||||
End of automatically generated list.