Wikidata:WikiProject Virtual Twins
Jump to navigation
Jump to search
Purpose
[edit]This project aims to improve items about Virtual Twins.
Virtual Twins, as seen by this project, are people who were born and died on the same day.
Actual twins are not in scope of this project.
Note: A similar list can be found here: Wikidata:Database_reports/identical_birth_and_death_dates
Numbers
[edit]
End of automatically generated list.
|
End of automatically generated list.
|
Sample queries
[edit]Virtual twins educated at the same institution
[edit]The following query uses these:
- Items: human (Q5)
, two people with the same date of birth and date of death (Q20978290) , twin (Q159979)
- Properties: different from (P1889) , instance of (P31) , educated at (P69) , date of birth (P569) , date of death (P570) , criterion used (P1013)
SELECT DISTINCT ?school ?schoolLabel ?item ?itemLabel ?item1 ?item1Label ?dob ?dod { ?item wdt:P1889 ?item1 ; wdt:P31 wd:Q5 ; p:P1889/pq:P1013 wd:Q20978290 ; wdt:P69 ?school ; wdt:P569 ?dob ; wdt:P570 ?dod . ?item1 wdt:P1889 ?item; wdt:P31 wd:Q5 ; p:P1889/pq:P1013 wd:Q20978290 ; wdt:P69 ?school ; wdt:P569 ?dob ; wdt:P570 ?dod . FILTER (?item != ?item1) FILTER NOT EXISTS { ?item wdt:P31 wd:Q159979 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?dob) LIMIT 4000
Number of virtual twins at a given milestone
[edit]# by Jura1, 2021-11-04
#title:Number of virtual twins (pair with the same dates of birth and death) in Wikidata at a given milestone, from [[d:Wikidata:WikiProject Virtual Twins]]
#defaultView:AreaChart
SELECT ?date ?cumulativecount
{
hint:Query hint:optimizer "None".
{ SELECT ?milestonep (COUNT(?item) as ?cumulativecount)
WHERE
{
{ SELECT ?item { {
?item p:P1889 [ pq:P1013 wd:Q20978290 ; ps:P1889 ?item2 ]
FILTER( xsd:integer(strafter(str(?item),"Q")) > xsd:integer(strafter(str(?item2),"Q")) )
} } }
BIND( xsd:integer( substr(str(?item), 33)) as ?qid)
wd:Q38074555 p:P1114 ?milestonep .
?milestonep ps:P1114 ?milestone .
FILTER( ?milestone > ?qid )
}
GROUP BY ?milestonep
}
?milestonep pq:P585 ?date
}
Participants
[edit]The participants listed below can be notified using the following template in discussions:{{Ping project|Virtual Twins}}