Over the last few weeks I've been doing something very similar. I was able
to figure out a process that works using OpenRefine. It works by searching
the VIAF API first, limiting results to anything that is a corporate name
and has an LC source authority. OpenRefine then extracts the LCCN and puts
that through the LCNAF API that OCLC has to get the name. I had to use
VIAF for the initial name search because for some reason the LCNAF API
doesn't really handle corporate names as search terms very well, but works
with the LCCN just fine (there is the possibility that I'm just doing
something wrong, and if that's the case, anyone on the list can feel free
to correct me). In the end, you get the LC name authority that corresponds
to your search term and a link to the authority on the LC Authorities
Anyway, The process is fairly simple to run (just prepare an Excel
spreadsheet and paste JSON commands into OpenRefine). The only reservation
is that I don't think it will run all 40,000 of your names at once. I've
been using it to run 300-400 names at a time. That said, I'd be happy to
share what I did with you if you'd like to try it out. I have some
instructions written up in a Word doc, and the JSON script is in a text
file, so just email me off list and I can send them to you.
Metadata Projects Librarian
University of Michigan
[log in to unmask]
On Fri, Sep 26, 2014 at 7:03 PM, Karen Hanson <[log in to unmask]>
> I found the WorldCat Identities API useful for an institution name
> disambiguation project that I worked on a few years ago, though my goal
> wasn't to confirm whether names mapped to LCNAF. The API response includes
> a LCCN, and you can set it to fuzzy or exact matching, but you would need
> to write a script to pass each term in and process the results:
> I also can't speak to whether all LC Name Authorities are represented, so
> there may be a chance of some false negatives.
> OCLC has another API, but not sure if it covers corporate names:
> I suspect there are others on the list that know more about the inner
> workings of these APIs if this might be an option for you... :)
> -----Original Message-----
> From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of
> Ethan Gruber
> Sent: Friday, September 26, 2014 3:54 PM
> To: [log in to unmask]
> Subject: Re: [CODE4LIB] Reconciling corporate names?
> I would check with the developers of SNAC (
> http://socialarchive.iath.virginia.edu/), as they've spent a lot of time
> developing named entity recognition scripts for personal and corporate
> names. They might have something you can reuse.
> On Fri, Sep 26, 2014 at 3:47 PM, Galligan, Patrick <[log in to unmask]
> > I'm looking to reconcile about 40,000 corporate names against LCNAF to
> > see whether they are authorized strings or not, but I'm drawing a
> > blank about how to get it done.
> > I've used http://freeyourmetadata.org/ for reconciling subject
> > headings before, but I can't get it to work for LCNAF. Has anyone had
> > any experience in a project like this? I'd love to hear some ideas for
> > automatically dealing with a large data set like this that we did not
> > create and do not know how the names were created.
> > Thanks!
> > -Patrick Galligan