Inventors & Applicants - how to distiguish?

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

knikonor
Posts: 19
Joined: Fri Nov 01, 2013 1:50 pm

Inventors & Applicants - how to distiguish?

Post by knikonor » Sun Dec 22, 2013 6:06 pm

Dear All,

I've met one more problem: how to lookup separately for inventors (who on my point of view
can be only real persons, not legal) and applicants - who can be both.

When I am trying to find person_name - everything is mixed there. Am I right?
How to make a query like in Espacenet where they are placed in different columns?

Regards and thanks beforehand,
Kirill.


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: Inventors & Applicants - how to distiguish?

Post by nico.rasters » Sun Dec 22, 2013 9:32 pm

In tls207_pers_appln there are two variables: applt_seq_nr and invt_seq_nr.
If applt_seq_nr > 0 the corresponding person_id is is an applicant.
If invt_seq_nr > 0 the corresponding person_id is is an inventor.
If applt_seq_nr > 0 and invt_seq_nr > 0 the corresponding person_id is is an applicant and an inventor (less than 10% of the records I would reckon).
________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


Post Reply