Wikidata talk:Database reports/identical birth and death dates/1

Formatting

@Jura1: It occurs to me that if you put  <br /> tags before each of the fields for one of the pair, and after each of the fields for the other of the pair, then you could put the names, genders, nationalities, and professions each next to each other, without the two being confused. I'll try editing the template, and see how it looks. Jheald (talk) 21:36, 16 September 2015 (UTC)

Actually, enough with the background colour it works well enough even without the vertical offsetting. Jheald (talk) 21:44, 16 September 2015 (UTC)

No, having seen it without, I'm going to put the offsets back again. I think they help. But see what you think. Jheald (talk) 21:49, 16 September 2015 (UTC)

It would also be nice if the template could suppress items which are redirects. Presumably it should be possible to extract that fact? Jheald (talk) 22:30, 16 September 2015 (UTC)

I started using Template:Tr peoplelist 11 in preview, but I'm not sure if it's a good idea to display it permanently. --- Jura 04:03, 17 September 2015 (UTC)

I removed the linebreaks, it was just too hard on my eyes. --- Jura 11:31, 18 September 2015 (UTC)

@Jura1: Okay :-)

BTW, is there a template, eg {{IsRedirect|Q12345}}, that can be used to determine whether an item is a redirect or not? It would be nice to add a column with a marker if either of the items was a redirect. Jheald (talk) 12:02, 18 September 2015 (UTC)

I don't know, but when the bot works, it removes redirects regularly (every 6 hours?). Once we are past the initial cleanup, it might not be that much of an issue.

Is there a way to always display a label (preferably in Roman script)? --- Jura 12:05, 18 September 2015 (UTC)

• It would be good to re-write the template in LUA. Currently it hits the "too many items accessed"-limit too quickly.
  --- Jura 07:14, 15 April 2016 (UTC)

John Ledward

Per the talkpage on EN, this has been fixed. Incorrect dates on this individual, per source. Lugnuts (talk) 18:55, 21 December 2015 (UTC)

Interesting question from the mailing list

Here is a question by Andrew Gray from the mailing list: "I'm curious to know how many cases we have where two people share both a name and a birthdate *but are confirmed to be different people*.". I suppose the answer depends whether one is looking at the real world or at the Wikidata-universe. Here is a sample of two persons with the same date of birth and name: "Ludwig Bauer" [1] and [2], at least in Wikidata. Obviously, two items for the same person with different labels or two persons who share the dates of one person are more likely. The list is limited to persons who already died, so it's just the tip of the iceberg. Maybe @Gymel, Jheald, Ivan A. Krestinin, Silverfish, Matěj Suchánek, Hsarrazin: want to add something.
--- Jura 07:14, 15 April 2016 (UTC)

Laboramus came up with a query and identified Sanjay Gupta (Q644401) and Sanjay Gupta (Q510034), both with the same name and date of birth on Wikidata.
--- Jura 09:56, 23 April 2016 (UTC)

that's an interesting question :)

I guess in countries with a lot of identical names, this must be more current than in countries where there are a lot of names and a lot of first names :)

I guess, on wikidata, sources will have to be thouroughly checked to see if they are really identical, or someone confused 2 persons (which is very easy). --Hsarrazin (talk) 15:29, 9 May 2016 (UTC)

Query to add deprecated Jan 1 dates to false positives

• Properties used: different from (P1889)   , date of death (P570)   , date of birth (P569)   

SELECT *
WITH
{
  select ?title (IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  {
    service wikibase:mwapi {
     bd:serviceParam wikibase:endpoint "www.wikidata.org" .
     bd:serviceParam wikibase:api "Generator" .
     bd:serviceParam mwapi:generator "links" .
     bd:serviceParam mwapi:titles "Wikidata:Database reports/identical birth and death dates/1" .
     bd:serviceParam mwapi:gplnamespace 0 .
     ?title wikibase:apiOutput mwapi:title. 
    }
  }
} as %includes
WITH
{
  select (IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  {
    service wikibase:mwapi {
     bd:serviceParam wikibase:endpoint "www.wikidata.org" .
     bd:serviceParam wikibase:api "Generator" .
     bd:serviceParam mwapi:generator "links" .
     bd:serviceParam mwapi:titles "Wikidata:Database reports/identical birth and death dates/False positives" .
     bd:serviceParam mwapi:gplnamespace 0 .
     ?title wikibase:apiOutput mwapi:title. 
    }
  }
} as %exclude
WHERE
{
  INCLUDE %includes 
  MINUS { INCLUDE %exclude }
  ?item p:P570 [ wikibase:rank wikibase:DeprecatedRank; psv:P570 [ wikibase:timeValue ?a; wikibase:timePrecision 11 ]] .
  ?item2 p:P570 [ wikibase:rank wikibase:DeprecatedRank; psv:P570 [ wikibase:timeValue ?a; wikibase:timePrecision 11 ]] .  
  ?item p:P569 [ wikibase:rank wikibase:DeprecatedRank; psv:P569 [ wikibase:timeValue ?a2; wikibase:timePrecision 11 ]] .
  ?item2 p:P569 [ wikibase:rank wikibase:DeprecatedRank; psv:P569 [ wikibase:timeValue ?a2; wikibase:timePrecision 11 ]] .
  FILTER NOT EXISTS { ?item wdt:P1889 ?item2 }
  FILTER( str(?item) < str(?item2)  )
  BIND(CONCAT("* [[",?title,"]] - [[", strafter(str(?item2),"y/"),"]]") as ?line)  
}

Try it! To update Wikidata:Database_reports/identical_birth_and_death_dates/False_positives#pairs_with_deprecated_January_1_date,

the above was useful (BTW, I doesn't list only January 1 dates). --- Jura 14:26, 30 January 2022 (UTC)

January 1 as date

There is now a summary at Help:Dates#January_1_as_date.

Identified and/or fixed series of items:

• Dutch academics (several properties)
• Property:P2332
• Property:P1979
• Property:P5491
• photographers
• Massachusetts politicians

For some the dates in the reference were problematic, for others the import(s) went wrong.

The advantage of that is that it helps double-check dates.

Some false positives are listed at Wikidata:Database_reports/identical_birth_and_death_dates/False_positives#pairs_with_deprecated_January_1_date. --- Jura 13:16, 3 February 2022 (UTC)

• As new items are created with deprecated January 1 dates, I'd exclude them from this report directly.--- Jura 10:20, 11 February 2022 (UTC)

0 entries!

On the update of 22:32, 4 February 2022.

Last time seems to have been on 15:36, 15 March 2016.

This is partially due to updates of Krbot being more frequent, with more up-to-date data.--- Jura 12:31, 5 February 2022 (UTC)