Learn About Patents Around the World

 
 
 
IN THIS SECTION
3 posts
Hebe
Last seen: 06/11/2021 - 07:18
Joined: 06/08/2021 - 22:55
ID in Pre-Grant Publications Data

Dear PatientsView team,

I want to ask about the id variable in pre-grant data. I try to join the "application" table with "CPC"/"rawlocation"/"location" tables with "id", but they do not match. An example of id in "application" is "0008dcaa-ccf9-11ea-ba95-121df0c29c1e". 

For "CPC" table, it seems that I can use "document number" to join. Howeverer, the only identifier in location table is id. 

What format is the "id" in Pre-grant Data in? And how can I join location table with applicatoin table? 

Thanks a lot!

Sun, 06/13/2021 - 09:31
Russ
Last seen: 12/06/2024 - 09:12
Joined: 11/14/2017 - 22:15
three way join

Hi Hebe,

I think you could join application and rawinventor and rawlocation.  It would be similar to https://patentsview.org/forum/7/topic/278#comment-330 where you might want to limit it to the first inventor depending on what you are trying to do.

Russ Allen

Tue, 06/15/2021 - 11:53
emelluso
Role: administrator
Last seen: 06/04/2024 - 13:23
Joined: 10/21/2020 - 10:51
Hello! To merge these tables…

Hello! To merge these tables, we recommend joining the rawlocation table with the rawinventor and rawassignee tables on the rawlocation_id field. This combined table can then be rejoined to the application table using the document_number field. We can provide more support with code snippets in Python or R if needed. 

Best,

The PatentsView Team