I am trying to track inventors' location over time using the patent data. I looked through the bulk files provided online and found that 'rawinventor.tsv' and 'location_inventor.tsv' files are relevant files.
But, I found that 'rawinventor.tsv' file does not cover location information for all inventors in the database (around 1M unique inventors are missing their locations). 'location_inventor.tsv' file covers most of inventors and location, but I find its impossible to map back to corresponding patent ID since it does not have the corresponding patent ID attached in the file.
Is there any crosswalk file available online that I can use to map 'location_inventor.tsv' file to corresponding patent IDs?
Thank you for your efforts and time in advance.