Wikidata:WikiProject Data cleaning/matched birth and death days
Tracking page for investigation of sets of items of humans with identical days of birth and days of death.
Adopt one of the reports below, and help sort out merges needed and/or birth and death dates put on the wrong item.
Process edit
The full set of items with instance of (P31) human (Q5) (N = 2,878,866) is too large to be can (just) be searched against itself using the new SPARQL beta service tinyurl.com/pn9xyye; this page presents the results of such searching within subsets defined by eg a particular country of citizenship (P27), occupation (P106), given name (P735) or place of birth (P19). Progress investigating such searches is tracked below.
To see a report of matched dates, copy one of the query links in one of the tables below, eg for humans with France as country of citizenship, and then when the page loads hit 'execute' to run the query. (You might also need to hit return a second time in the browser URL bar, to make the query appear).
The easiest way to deal with the resulting list of more than singly occurring dates seems to be to paste the date of birth into the URL for Reasonator's date search, eg
then find the two items with the appropriate death dates and open up the Reasonator pages to look at them.
Note that some of the matches will be pairs of items that genuinely ought to be merged; however some may be the result of an incorrect person having been given the wrong dates due to name confusion (sometimes from someone with a very similar name, but sometimes dates may have been wrongly copied even to a person with a very different name; such wrongful copying seems to be more common than genuine coincidental matches -- these appear to be very rare). So it's well worth looking at the two merge candidates in Reasonator -- just because the names and dates appear to match, it doesn't necessarily mean they should be merged, it might be that the right dates have been put on the wrong item.
| status | country | items | query | pairs | comment |
|---|---|---|---|---|---|
| United States of America (Q30) | 290,086 | query | 21 pairs (previously timed out) | ||
| Germany (Q183) | 193,193 | query | 6 pairs (was 24 pairs) / times out | ||
| France (Q142) | 124,079 | query | 9 pairs (was 71 pairs) | 13 cases investigated on frwiki + 3 valid pairs of same dates | |
| Done | United Kingdom (Q145) | 106,732 | query | 3 pairs (was 32 pairs) | |
| Italy (Q38) | 86,032 | query | 1 pair (was 13 pairs) | ||
| Done | Japan (Q17) | 61,743 | query | 1 pair (was 3 pairs) ) | |
| Sweden (Q34) | 49,871 | query | 4 pairs (was 28 pairs) | ||
| Done | Soviet Union (Q15180) | 43,429 | query | 1 pair (was 13 pairs) | 3 cases merged on ruwiki |
| Canada (Q16) | 41,485 | query | 2 pairs (was 12 pairs) | ||
| Done | Netherlands (Q55) | 35,463 | query | 0 pairs (was 17 pairs) | |
| Norway (Q20) | 35,201 | query | 2 pairs (was 54 pairs) | ||
| Brazil (Q155) | 34,547 | query | 5 pairs (was 10 pairs) | ||
| Done | Finland (Q33) | 33,608 | query | 0 pairs (was 2 pairs) | |
| Poland (Q36) | 32,770 | query | 1 pair (was 5 pairs) | ||
| Done | Russia (Q159) | 31,903 | query | 1 pair (was 5 pairs) | |
| Done | Australia (Q408) | 28,924 | query | 0 pairs | |
| Done | Spain (Q29) | 28,589 | query | 1 pair | |
| Austria (Q40) | 28,227 | query | 1 pair (was 4 pairs) | Franz Xaver von Paumgartten (Q1449791) / Franz Xaver von Paumgartten (Q16557594) need merging on it-wiki | |
| Done | India (Q668) | 22,039 | query | 0 pairs (was 2 pairs) | |
| Done | Switzerland (Q39) | 21,500 | query | 0 pairs (was 5 pairs) | |
| Done | Argentina (Q414) | 20,267 | query | 0 pairs (was 3 pairs) | |
| Belgium (Q31) | 20,239 | query | 3 pairs (was 17 pairs) | ||
| Done | Turkey (Q43) | 13,550 | query | 0 pairs | |
| Mexico (Q96) | 13,295 | query | 1 pair (was 2 pairs) | Ramón Ibarra Montejano (Q6099722) / Raúl Arellano (Q2134408) dates need to be checked against references | |
| Done | New Zealand (Q664) | 13,081 | query | 0 pairs (was 7 pairs) | |
| Done | Iran (Q794) | 12,964 | query | 0 pairs | |
| Done | Russian Empire (Q34266) | 10,866 | query | 1 pair (was 7 pairs) | |
| Denmark (Q35) | 10,246 | query | 2 pairs (was 3 pairs) | ||
| Done | Portugal (Q45) | 9503 | query | 0 pairs (was 1 pair) | |
| Done | Greece (Q41) | 9409 | query | 0 pairs (was 1 pair) | |
| Done | Hungary (Q28) | 9376 | query | 0 pairs (was 2 pairs) | |
| Done | South Korea (Q884) | 9025 | query | 0 pairs | |
| Done | Czech Republic (Q213) | 8660 | query | 0 pairs (was 2 pairs) |
More countries at query
More occupations at query .
By given name (P735) including variants edit
male edit
| status | name | items | query | pairs | comment |
|---|---|---|---|---|---|
| John (Q4925477) | 125,202 | query | 10 pairs (was 89 pairs) | ||
| Charles (Q2958359) | 44,828 | query | 3 pairs (was 38 pairs) | ||
| Joseph (Q471788) | 42,712 | query | 3 pairs (was 36 pairs) | ||
| William (Q14371254) | 38,440 | query | 1 pair (was 27 pairs) | ||
| Peter (Q2793400) | 36,674 | query | 2 pairs (was 26 pairs) | ||
| Georgius (Q5548460) (includes Jürgen (Q2670311)) | 36,550 | query | 1 pair (was 24 pairs) | ||
| François (Q1166840) | 35,415 | query | 2 pairs (was 39 pairs)) | ||
| Yakov (Q544124) / James (Q677191) | 35,415 | query | 1 pair (was 19 pairs) | ||
| Henry (Q1158477) | 30,997 | query | 1 pair (was 25 pairs) | ||
| Robert (Q4927937) | 27,089 | query | 1 pair (was 13 pairs) | ||
| Done | Thomas (Q16428906) | 25,124 | query | 0 pairs (was 12 pairs) | Thomas Cortsønn Wegner (Q12006062) / Thomas Cortsønn Wegner (Q12006669) merge needed on no-wiki |
| Done | Paul (Q4925623) | 22,916 | query | 0 pairs (was 12 pairs) | |
| Done | Andrew (Q18042461) | 22,737 | query | 0 pairs (was 8 pairs) | |
| Done | David (Q18057751) | 19,984 | query | 0 pairs (was 3 pairs) | |
| Michael (Q4927524) | 19,502 | query | 1 pair (was 5 pairs) | ||
| Done | Stephen (Q4927100) | 19,368 | query | 0 pairs (was 4 pairs) | |
| Done | Louis (Q2897866) | 19,210 | query | 0 pairs (was 9 pairs) | |
| Done | Alexander (Q923) | 16,904 | query | 0 pairs (was 8 pairs) | |
| Mark (Q13610143) | 16,556 | query | 2 pairs (was 5 pairs) | ||
| Richard (Q1249148) | 15,841 | query | 1 pair (was 3 pairs) | Ryszard Sielicki (Q19861711) / Ryszard Sielicki (Q9324943) merge needed on pl-wiki | |
| Frederick (Q3273004) | 15,283 | query | 2 pairs (was 18 pairs) | ||
| Done | Edward (Q278835) | 14,719 | query | 0 pairs (was 8 pairs ) | |
| Nicholas (Q42771) | 14,225 | query | 1 pairs (was 12 pairs ) | ||
| Albert (Q577011) | 9,412 | query | 1 pairs (was 6 pairs) | Alberto Cabero (Q4711962) / Alberto Cabero (Q5662851) merge needed on es-wiki | |
| Done | Martin (Q18002399) | 9,688 | query | 0 pairs (was 3 pairs) | |
| Done | Eric (Q15277251) | 8,938 | query | 0 pairs (was 9 pairs) | |
| Daniel (Q14516546) | 8,720 | query | 1 pair | Daniël Johannes Kooy (Q17351387) / Daniël Johannes Kooy (Q15874215) merge needed on nl-wiki | |
| Done | Philip (Q827311) | 8,705 | query | 0 pairs (was 3 pairs) | |
| Done | Vladimir (Q2253934) | 8,599 | query | 0 pairs (was 6 pairs) | |
| Done | Christian (Q18001597) | 7,786 | query | 0 pairs (was 3 pairs ) |
female edit
| status | name | items | query | pairs | comment |
|---|---|---|---|---|---|
| Mary (Q734578) | 14,965 | query | 1 pair (was 13 pairs) | ||
| Done | Anna (Q666578) | 10,659 | query | 0 pairs (was 6 pairs) | |
| Done | Katherine (Q108631) | 7,078 | query | 0 pairs (was 0 pairs) | |
| Done | Elisabeth (Q17524931) | 5,736 | query | 0 pairs (was 0 pairs) | |
| Done | Elena (Q1209486) | 5,049 | query | 0 pairs (was 2 pairs) | |
| Margaret (Q4963612) | 3,988 | query | 1 pair (was 4 pairs) | ||
| Done | Susanna (Q14936808) | 3,823 | query | 0 pairs (was 0 pairs) | |
| Done | Jane (Q1682564) | 3,173 | query | 0 pairs (was 1 pair) | |
| Done | Juliette (Q15639217) | 3,053 | query | 0 pairs (was 0 pairs) | |
| Done | Christina (Q1083457) | 3,052 | query | 0 pairs (was 1 pair) | |
| Done | Sarah (Q18201513) | 2,721 | query | 0 pairs (was 1 pair) | |
| Done | Barbara (Q153957) | 2,524 | query | 0 pairs (was 4 pairs) |
More names, including aliasing: tinyurl.com/p6xc6yv (male names only; not de-duplicated; just completes, in 97 secs). tinyurl.com/pv64gfg (female names) tinyurl.com/oze3lfz (unisex names)
More names (no aliasing) at query or see Wikidata:WikiProject Names
| status | place | items | query | pairs | comment |
|---|---|---|---|---|---|
| Done | Tokyo (Q1490) | 18925 | query | 0 pairs | |
| Done | Paris (Q90) | 15906 | query | 0 pairs (was 9 pairs) | |
| Done | Moscow (Q649) | 10968 | query | 0 pairs (was 5 pairs) | |
| Done | New York City (Q60) | 10335 | query | 0 pairs (was 2 pairs) |
More places of birth at query