Fixing 'see applicant' issue in patstat TLS207

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Posts: 62
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy

Fixing 'see applicant' issue in patstat TLS207

Post by gianluca.tarasconi » Fri May 09, 2014 3:15 pm

dear all
in oct 2013 a big number of applications (140.700: all of them at EP application authority) instead of the correct reference to the inventor person_id TLS207 lists person id 96 whose name (see applicant) do not let us presume it is a valid entry...

In order to fix it for the great majority of the records (140.680 of them) who list only one inventor (the famous 'see applicant') I wrote this lines of code that should fix the issue in mysql.
are left out about 20 records that have also inventors other than 'see applicant' so a hand made correctin and check should be performed.

the code can be found here: ... tstat.html

hope it helps


Post Reply