Skip to main content
 
 
 
IN THIS SECTION
2 posts
Sanjana
Last seen: 07/07/2021 - 07:58
Joined: 06/28/2021 - 04:28
Disambiguated Inventor & Assignee merge

Hello,

I was trying to use the disambiguated inventor.tsv & assignee.tsv. However the I could not match the id in both files to any of the other id variables. The closest I got was by matching the id variables in inventor.tsv and rawinventor.tsv, but it matched only 217435 entries.

How could I use inventor.tsv & assignee.tsv with the other datasets?

 

Thank you,

Sanjana

 

emelluso
Role: administrator
Last seen: 07/15/2021 - 20:06
Joined: 10/21/2020 - 07:51
Hello Sanjana,  If I…

Hello Sanjana, 

If I understand correctly, you are trying to link the disambiguated ids from various tables ie. assignee and inventor. If so, then the solution is to use the crosswalk tables (ie. patent_assignee, patent_inventor, etc.)
Linking raw inventor data and disambiguated inventor data requires using the persistent_inventor_disambig table as a crosswalk. 

Let us know if we can help further!

Best,

PVTeam