Skip to main content
 
 
 
IN THIS SECTION
2 posts
Hebe
Last seen: 06/11/2021 - 04:18
Joined: 06/08/2021 - 19: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!

Russ
Last seen: 06/13/2021 - 06:30
Joined: 11/14/2017 - 19: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