Dig That Lick database reconciliation log

[Sbebastien]

For me to keep track of progress on reconciling Dig That Lick

[SCN-MNG]

Currently, @Sbebastien is more than halfway through reconciling DTL1000 (the main Dig That Lick database). Once he finishes reconciliation, a convert_rdf.py script can convert the three resulting csv into one Turtle file.

[SCN-MNG]

After we make sure that the workflow is functional, we will finalize documentation for Dig that Lick and submit a pull request to main.

[Sbebastien]

Bobby Lewis has 3 potential matches in Wikidata: Q888607, Q4935287, Q888609, all three are musicians, but I am leaning towards it being Q888607 as this Wikidata says this Bobby Lewis plays trumpet and the bobby lewis in the dig that lick database also seems to play trumpet and flugelhorn

[Sbebastien]

Two David Buchbinders exist: https://www.wikidata.org/wiki/Q50436291, https://www.wikidata.org/wiki/Q89944149, neither of them are musicians in Wikidata

[fujinaga]

What's the record for David Buchbinders in DLT?

[Sbebastien]

In dig that lick he is on the album Odessa/Havana, and I found him in discos: https://www.discogs.com/artist/915743-David-Buchbinder, as he has the same album in his releases

[Sbebastien]

Ayman Fanous has one Wikidata entry: https://www.wikidata.org/wiki/Q114270581, but he is listed as a researcher, I think these are two separate people, the one we want does not exist in Wikidata

[Sbebastien]

Florencia Gonzalez probably has no match in Wikidata, there is a Florencia Eva Gonzalez in Wikidata with not much information on the page: https://www.wikidata.org/wiki/Q110037814

[Sbebastien]

Tom Dempsey is most likely https://www.wikidata.org/wiki/Q66709154

[Sbebastien]

These people have names in Wikidata but none of them are correct:
Dennis Warren
Mark Weinstein
Mitch Marcus
Steven Kroon
Nolan Welsh
Garry Lee

[fujinaga]

Can you document why you think they are incorrect?

[Sbebastien]

Dennis Warren: wikidata has https://www.wikidata.org/wiki/Q102133215, who is a mathematician

Mark Weinstein: Wikidata has https://www.wikidata.org/wiki/Q112403605, who has no information, but a birthdate of 1962, which seems late as from reading this bio https://jazzfluteweinstein.com/bio/ it says that Mark Weinstein wrote and recorded an album in 1967

Mitch Marcus: in Wikidata, the only Mitch Marcus (Q43911279) is not a musician

Steven Kroon: in Wikidata there is Q92021663 who is a researcher

Nolan Welsh: there is no Nolan Welsh in Wikidata who is a musician, open refine just brought up a Welsh artist named Gavin Nolan

Garry Lee: https://www.wikidata.org/wiki/Q5524170<-- closest I could find in Wikidata, but it is a country band, and we want a jazz musician

[Sbebastien]

George Johnson in the dig that lick database Is part of The Wolverines, and I found him to be this guy: https://www.discogs.com/artist/1001660-George-Johnson-3?srsltid=AfmBOooOvWiRyLL7z3woso5jgzPz70tMiESowiTnC_605Rtq5N9nNrYt,

But there is another George Johnson not part of The Wolverines who also plays saxophone: https://www.discogs.com/artist/2673329-George-Johnson-9?redirected=true, and this one is the one in Wikidata that gets matched

[Sbebastien]

Going through the solo performers, will mark down the people that are not completely correct

[Sbebastien]

ooh yes I think you are right

[Sbebastien]

For Howie Smith, I found two people in Wikidata and I think they are the same person, https://www.wikidata.org/wiki/Q99675435, and https://www.wikidata.org/wiki/Q15485544

[Sbebastien]

Joe Thomas is : https://www.wikidata.org/wiki/Q1645859, there are many other Joe Thomas musicians in Wikidata, but In dig that lick Joe Thomas is part of the group Jimmie Lunceford and his Orchestra, and this: https://www.discogs.com/artist/321625-Joe-Thomas-3?redirected=true, is the same Joe Thomas, so by checking the birth and death dates In Wikidata I confirmed it is him.

[Sbebastien]

Junie (E. C.) Cobb doesn't get to matched to anyone in open refine, but he is Junie Cobb: https://www.wikidata.org/wiki/Q1713510

[Sbebastien]

Can't find the right Pete Clark in wikidata, he is supposed to be part of Chick Webb and his Orchestra, the pete clarks in wikidata are a painter, https://www.wikidata.org/wiki/Q21463352, and a mathematician https://www.wikidata.org/wiki/Q102258565, and this guy https://www.wikidata.org/wiki/Q75989201.

[fujinaga]

@Sbebastien Are you almost done with reconciling? All I want is just a list of things you cannot reconcile. I don't really want you spend a lot of time reconciling. As I said in lab meeting, your primary task is to develop the workflow. We can hire someone else to do the reconciling later. If you cannot reconcile quickly (less than a minute per item), leave them as literals.

[Sbebastien]

Okay i understand for the ones that aren't automatically correctly reconciled Ill just mark them down but I wont go further to try and find them as that takes more time

[Sbebastien]

For the column possible performer names:
List of people that openrefine did not automatically match because either no one had high enough confidence, or there are multiple people that come up
I add more detail about who it probably should be if it was easy for me to tell

Elmer “skippy” williams: probably just elmer williams https://www.wikidata.org/wiki/Q51052670
Milton Fletcher
Bob Burnett
Harvey Boone: probably the jazz clarinettist from wikidata that comes up https://www.wikidata.org/wiki/Q66087807
Dave Richards: didn’t match because multiple musicians in wikidata
Ed hudson: probably new because none of the wikidata people that came up in openrefine are musicians
Gene Johnson: multiple people come up from wikidata
Henry hicks: probably new because none of the wikidata people that came up in openrefine are musicians
Irving mouse: is probably this guy: https://www.wikidata.org/wiki/Q1951043
Jack ferrier: probably new because none of the wikidata people that came up in openrefine are musicians
Jay brower: probably new because none of the wikidata people that came up in openrefine are musicians
Joe Thomas: multiple musicians appear from wikidata
John youngman: probably new because none of the wikidata people that came up in openrefine are musicians
Mike young
Milton fletcher: probably new because none of the wikidata people that came up in openrefine are musicians
Money: probably new because none of the wikidata people that came up in openrefine are musicians
Pete brown: probably https://www.wikidata.org/wiki/Q2073237, but other musicians came up
Richard torres: probably new because none of the wikidata people that came up in openrefine are musicians
Robeson
Russell smith
Tito puente: probably is : https://www.wikidata.org/wiki/Q317122
William johnson
Alfie evans: probably new because none of the wikidata people that came up in openrefine are musicians
Alfred bell: probably new because none of the wikidata people that came up in openrefine are musicians
Earl(e) warren: spelled earl warren in dig that lick but is probably Earle warren https://www.wikidata.org/wiki/Q1277478
Easy mo bee
Gene jefferson: probably is https://www.wikidata.org/wiki/Q76884570
George oldham: probably new because none of the wikidata people that came up in openrefine are musicians
James king: didnt match because multiple musicians appear from wikidata
John walsh: probably new because none of the wikidata people that came up in openrefine are musicians
Ray reed: probably new because none of the wikidata people that came up in openrefine are musicians

[fujinaga]

Great list! Tito Puente is correct.

[Sbebastien]

For the column Solo Performer Name:
List of people that openrefine did not automatically match because either no one had high enough confidence, or there are multiple people that come up
I add more detail about who it probably should be if it was easy for me to tell
In openRefine I also flagged them and marked them all as new item

Aleksander Gajic: probably new because none of the wikidata people that came up in openrefine are musicians
Arville Harris: could be Q11852967
Bobby Bruce: probably new because none of the wikidata people that came up in openrefine are musicians
Bobby Lewis: probably is Q888607
Bobby Sands: probably new because none of the wikidata people that came up in openrefine are musicians
Chuck Carter: probably new because none of the wikidata people that came up in openrefine are musicians
Colin Dawson: is probably Q28860577
Dave Klein: must be new guy, the ones in wikidata are wrong
Dave Young: probably new guy, the ones in wikidata are wrong
David Stump: probably new because none of the wikidata people that came up in openrefine are musicians
Don Landis: probably new because none of the wikidata people that came up in openrefine are musicians
Earle Warren: good, had to change his name
Eli Asher: probably new because none of the wikidata people that came up in openrefine are musicians
Florencia Gonzalez: probably new because none of the wikidata people that came up in openrefine are musicians
Garry Lee: probably new because none of the wikidata people that came up in openrefine are musicians
George Johnson: the correct George Johnson does not exist in wikidata
Harold Alexander: probably new because none of the wikidata people that came up in openrefine are musicians
Howie Smith: multiple musicians come up in wikidata
Jared Sims: probably new because none of the wikidata people that came up in openrefine are musicians
Jerry Elliot: probably new because none of the wikidata people that came up in openrefine are musicians
Jesse Davis: multiple musicians come up in wikidata
Jim Reider: probably new because none of the wikidata people that came up in openrefine are musicians
Joe Ellis: probably new because none of the wikidata people that came up in openrefine are musicians
Joe Thomas: multiple musicians come up in wikidata
Junie (E. C.) Cobb: nothing comes up in wikidata, but it could be Junie Cobb who does have an entry in wikidata (Q1713510)
Ken Shroyer: probably new because none of the wikidata people that came up in openrefine are musicians
Kenny Faulk: probably new because none of the wikidata people that came up in openrefine are musicians
Louis Stockwell: probably new because none of the wikidata people that came up in openrefine are musicians
Mark McGowan
Mark Weinstein
Melvin Butler
Michael Bard
Paul Austerlitz: probably is (Q131779276)
Pete Clark: probably new because none of the wikidata people that came up in openrefine are musicians
Raymond Williams:
Robeson
Sean Corby: probably new because none of the wikidata people that came up in openrefine are musicians
Shorty McConnell
Tom Morris
Tony Owens: probably new because none of the wikidata people that came up in openrefine are musicians
Wendell Stewart: probably new because none of the wikidata people that came up in openrefine are musicians