Wikidata:Database reports/items with P569 greater than P570

< Wikidata:Database reports

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-12-20 23:09, 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

Manually update list

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	David Kandelaki	Georgian Sovet diplomat and politician (1895-1938)	1956-10-30	1938-07-29	18
2	Charles Van Loo-Smet	Belgian photographer	1909-06-15	1904-02-26	5
3	end	termination of something

End of automatically generated list.

500000 - 1000000

Manually update list

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

Manually update list

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

Manually update list

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

Manually update list

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	Peter de Salis	(1675-1749)	1898-01-01	1749-01-01	149
2	Arnošt Josiáš Fournier	13.3.1809-28.8.1878	1879-01-01	1878-01-01 1878-08-28	1
3	end	termination of something

End of automatically generated list.

2500000 - 3000000

Manually update list

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

Manually update list

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.

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Database_reports/items_with_P569_greater_than_P570&oldid=2289964982"