Inventors and Applicants Country address

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: 1
Joined: Sun Nov 22, 2015 11:52 am

Inventors and Applicants Country address

Post by Niry » Sun Nov 22, 2015 12:15 pm


I would like to collect the following data:
1. Patent publications that their inventors address is GB.
2. Patent publications that their Applicants (individuals and companies) address is GB

What would be the appropriate table to use for that?
1. Does the tls206_person holds data for Inventors and applicants?
2. Does the tls206_person holds data for Individuals and companies as well?



Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: Inventors and Applicants Country address

Post by Geert Boedt » Tue Nov 24, 2015 11:01 am

Hello Niry,
You need to join the tls206_person table with the tls211_pat_publn table via the tls227_pers_publn table.
The tls206_person_table contains the details of the applicants as well as the inventors. You can select applicant and/or inventors by setting the attribute applt_seq_nr or invt_seq_nr > 0. Keep in mind that the PATSTAT database contains records from patent offices all over the world. So your criteria will retrieve applications from all over the world. Concrete : your selection criteria (all publication with a GB inventor/applicant) will give millions of publications. So I assume you want to add other selection criteria that will reduce the sample with oher criteria such as publication date or publication authority.
4 more things to keep in mind:
a) your result list will contain duplications at publication level because an application can have more then 1 applicant or 1 inventor. You can avoid this if you don't need the person name and person country in your final result and group the results.
b) your result will contain duplicates at APPLICATION level because 1 application can have multiple publication. Example the EP A1 (EP search report) and EP B (granted patent) of an EP application. You can avoid this by using the tls201_appln table instead of the tls211_pat_publn table.
c) address information is removed from PATSTAT on-line
d) person country information is not 100% available, you need to check the data coverage for the sample you have in mind.
Example query (2.7 million records):

SELECT [publn_auth]
FROM tls211_pat_publn
join tls227_pers_publn on tls211_pat_publn.pat_publn_id = tls227_pers_publn.pat_publn_id
join tls206_person on tls227_pers_publn.person_id = tls206_person.person_id
where person_ctry_code = 'GB' and invt_seq_nr > 0

Example query with application table, and limited to applications filed at the European patent office ("only "500.000 records):

SELECT tls201_appln.appln_id,appln_auth,appln_nr,appln_kind,appln_filing_date,person_name,person_address,person_ctry_code
FROM tls201_appln
join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
where person_ctry_code = 'GB' and appln_auth = 'ep'
group by tls201_appln.appln_id,appln_auth,appln_nr,appln_kind,appln_filing_date,person_name,person_address,person_ctry_code
order by tls201_appln.appln_id

You can find more sample queries in the self learning modules and publications at this link: ... nline.html

Best regards,
PATSTAT user support
patstat@epo. org
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna

Post Reply