Learn About Patents Around the World

 
 
 
IN THIS SECTION
4 posts
Sanjana
Last seen: 09/05/2023 - 05:28
Joined: 06/28/2021 - 07: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

 

Wed, 07/07/2021 - 10:31
emelluso
Role: administrator
Last seen: 06/04/2024 - 13:23
Joined: 10/21/2020 - 10: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 disambiguated inventor data across data updates requires using the persistent_inventor_disambig table as a crosswalk. 

Let us know if we can help further!

Best,

PVTeam

Thu, 09/09/2021 - 08:26
Sanjana
Last seen: 09/05/2023 - 05:28
Joined: 06/28/2021 - 07:28
Updated persistent_inventor_disambig

Dear PVTeam,

Thank you for your informative response.

Unfortunately the persistent_inventor_disambig provides a crosswalk only until the release of disamb_inventor_id_20200929. I do understand that "With the data update release in Mar 2021 (data through Dec 29, 2020), the inventor ID values are persistent." However, this is much after the available date. I also tried matching the ids available in persistent_inventor_disambig to id in inventor.tsv but could not find any match. 

Could you guide me on how to use the crosswalk with the updated data?

Thank you.

Sanjana

Tue, 09/21/2021 - 16:54
PVTeam
Role: moderator
Last seen: 11/29/2024 - 15:02
Joined: 10/17/2017 - 10:47
Hello Sanjana, can you…

Hello Sanjana, can you please email us the code you are working with and we can follow-up with you individually from there? contact@patentsview.org.