Learn About Patents Around the World

 
 
 
IN THIS SECTION
2 posts
krm5041
Last seen: 03/14/2018 - 09:58
Joined: 03/13/2018 - 21:57
Raw Data Download - Location, At Issue

Is there any way to access the raw data that includes the inventor and assignee location crosswalks for each patent at issue? The current raw location crosswalk data includes (possibly) multiple location ID's for each inventor and assignee and there is no way to discern which location ID applies to which inventor/assignee ID for a given patent.

Fri, 04/27/2018 - 10:42
PVTeam
Role: moderator
Last seen: 03/15/2024 - 15:25
Joined: 10/17/2017 - 10:47
RE: RAW DATA DOWNLOAD - LOCATION, AT ISSUE

Hello,

Unfortunately, there is not a pre-made crosswalk table, instead you will have to join three files (rawassignee, rawlocation, and location) to create it. Start by joining the rawassignee file to the rawlocation table using the rawassignee "rawlocation_id” column and the rawlocation "id" column. You will then need to join the rawlocation table to the location table using the rawlocation "location_id” column and the location "id" column. You could either do this in MySQL (if you have a database created) or in the programming language of your choice (e.g. Python or R).

 

Here is an example of how the syntax would look using MySQL:

select rawassignee.*, location.* from

join rawlocation to rawassignee using rawlocation.id = rawassignee.rawlocation_id and

join location to rawlocation using location.id = rawlocation.location_id

 

Thanks,

PVTeam