Wikidata:WikiProject Virtual Twins

Purpose

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

Total
3265

End of automatically generated list.

Manually update chart

#	Property	Count	(%)	todo	list
style='text-align:right'	different from (P1889)	3259	100	0	Done
style='text-align:right'	instance of (P31)	3259	100	0	Done
style='text-align:right'	date of birth (P569)	3257	100	2	Done
style='text-align:right'	date of death (P570)	3255	100	4	Done
style='text-align:right'	sex or gender (P21)	3218	99	41	without
style='text-align:right'	given name (P735)	2716	83	543	without
style='text-align:right'	occupation (P106)	2585	79	674	without
style='text-align:right'	country of citizenship (P27)	2425	74	834	without
style='text-align:right'	place of birth (P19)	2354	72	905	without
style='text-align:right'	family name (P734)	1989	61	1270	without
style='text-align:right'	place of death (P20)	1948	60	1311	without
style='text-align:right'	languages spoken, written or signed (P1412)	1581	49	1678	without
style='text-align:right'	VIAF ID (P214)	1459	45	1800	without
style='text-align:right'	Freebase ID (P646)	905	28	2354	without
style='text-align:right'	name in native language (P1559)	883	27	2376	without
style='text-align:right'	educated at (P69)	860	26	2399	without
style='text-align:right'	image (P18)	730	22	2529	without
style='text-align:right'	award received (P166)	701	22	2558	without
style='text-align:right'	Prabook ID (P3368)	637	20	2622	without
style='text-align:right'	Commons category (P373)	593	18	2666	without
style='text-align:right'	place of burial (P119)	440	14	2819	without
style='text-align:right'	position held (P39)	434	13	2825	without
style='text-align:right'	employer (P108)	424	13	2835	without
style='text-align:right'	described by source (P1343)	400	12	2859	without
style='text-align:right'	member of political party (P102)	362	11	2897	without
style='text-align:right'	father (P22)	356	11	2903	without
style='text-align:right'	Deutsche Biographie (GND) ID (P7902)	335	10	2924	without
style='text-align:right'	sport (P641)	326	10	2933	without
style='text-align:right'	spouse (P26)	322	10	2937	without
style='text-align:right'	child (P40)	302	9	2957	without
style='text-align:right'	member of (P463)	262	8	2997	without
style='text-align:right'	copyright status as a creator (P7763)	257	8	3002	without
style='text-align:right'	field of work (P101)	257	8	3002	without
style='text-align:right'	Find a Grave memorial ID (P535)	253	8	3006	without
style='text-align:right'	mother (P25)	245	8	3014	without
style='text-align:right'	conflict (P607)	233	7	3026	without
style='text-align:right'	work location (P937)	225	7	3034	without
style='text-align:right'	birth name (P1477)	213	7	3046	without
style='text-align:right'	cause of death (P509)	205	6	3054	without
style='text-align:right'	native language (P103)	190	6	3069	without
style='text-align:right'	manner of death (P1196)	177	5	3082	without
style='text-align:right'	member of sports team (P54)	173	5	3086	without
style='text-align:right'	significant event (P793)	172	5	3087	without
style='text-align:right'	sibling (P3373)	171	5	3088	without
style='text-align:right'	military branch (P241)	161	5	3098	without
style='text-align:right'	military or police rank (P410)	153	5	3106	without

End of automatically generated list.

Sample queries

Virtual twins educated at the same institution

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
```

Try it!

Number of virtual twins at a given milestone

# 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
}

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

Participants

[+] Add yourself to the list

The participants listed below can be notified using the following template in discussions:
{{Ping project|Virtual Twins}}

List

User:Jura1/virtual twins