Skip to main content
 
 
 
IN THIS SECTION
4 posts
Federico
Last seen: 03/18/2021 - 09:38
Joined: 01/15/2020 - 09:10
Data dictionary does not seem updated

Hello!

I am trying to load the available files in mysql. I use the data dictionary as reference to create the tables.

I found these differences between the downloaded files and the dictionary:

- Table: patent_inventor - field not listed "location_id" varchar(??)

- Table: inventor_gender - dictionary reports more fields than the actual file (only 3 disamb_id_date in file)

hope it helps

ciao!

PVTeam
Role: moderator
Last seen: 05/06/2021 - 09:49
Joined: 10/17/2017 - 07:47
DATA DICTIONARY UPDATED

Hi Federico,

 

Thank you for bringing this to our attention. We have made edits to these two tables, as well as a few others, in the data dictionary. If you download the file again you should see the updated definitions. If you do not see any changes in the new file you may need to clear the file from your browsing history cache and download it again.

 

Best,

PVTeam

Federico
Last seen: 03/18/2021 - 09:38
Joined: 01/15/2020 - 09:10
THANK YOU FOR THE QUICK…

Thank you for the quick response.

Concerning these tables I have a further question.

I am not able to find some inventor IDs in the inventor_gender table. 

Example:

From patent_inventor table:

Patent ID   Inventor ID

7472816    6959851-1
7472816    6471670-2
7472816    5713911-2
7472816    7398908-6
7472816    5803902-5

The inventor 5713911-2 is listed in the inventor table ("John W." as name) but he is missing in inventor_gender. It was available in one of the previous release of the data (last year).  Same for many other inventors (other 2 in the example patent above).  

EDIT: with respect to the release in 2019, the inventor_gender table of June 2020 lists around -50% inventor IDs. Is that a partial table? or what am I doing wrong?

 

PVTeam
Role: moderator
Last seen: 05/06/2021 - 09:49
Joined: 10/17/2017 - 07:47
INVENTOR GENDER FIXES

Hi Federico,

Sorry for the delayed response. We have recently updated the inventor_gender table and added new data from the most recent updates. If you are still seeing any issues with the new data please let us know.

Best,

PVTeam