Missing person information in [dbo].[tls206_person]?

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

AWFB
Posts: 12
Joined: Mon Oct 22, 2018 6:56 pm

Missing person information in [dbo].[tls206_person]?

Post by AWFB » Thu Oct 21, 2021 11:00 pm

Hi,

I seem to be coming across a lot of applications where the person (applicant/inventor) information is missing - yet this information is available on Espacenet.

For instance: appln_id=488502563 lists 1 applicant (56713290) and 1 inventor (56701905). Neither of them are in [patstat2021a].[dbo].[tls206_person].

Another one is appln_id=473750619, which lists 1 applicant (56713774) and 3 inventors (57815283, 57840535, 57879469). But again, they all seem to be missing.

Am I doing something stupid?


EPO / PATSTAT Support
Posts: 424
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Missing person information in [dbo].[tls206_person]?

Post by EPO / PATSTAT Support » Fri Oct 22, 2021 7:48 am

Hello AWFB,
you probably just made a mistake in your query. (Maybe the JOINS if you do not find any persons at all)
Try the query below and you will find exactly the same as in Espacenet.

Code: Select all

SELECT a.[appln_id]
      ,a.[appln_auth]
      ,a.[appln_nr]
      ,a.[appln_kind]
      ,a.[appln_filing_date]
	  ,applt_seq_nr, invt_seq_nr
	  ,PA.person_id
	  ,p.person_name
	  ,p.person_address
	  ,p.person_ctry_code
FROM tls201_appln  a
  join tls207_pers_appln PA on PA.appln_id = a.appln_id
  join tls206_person p on pa.person_id= p.person_id
where a.appln_id = 488502563
order by invt_seq_nr, applt_seq_nr
https://worldwide.espacenet.com/publica ... 73A1&KC=A1

PATSTAT results:
result.xlsx
(10.81 KiB) Downloaded 71 times
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


AWFB
Posts: 12
Joined: Mon Oct 22, 2018 6:56 pm

Re: Missing person information in [dbo].[tls206_person]?

Post by AWFB » Fri Oct 22, 2021 8:46 pm

Hm, curiously that returns zero results.


EPO / PATSTAT Support
Posts: 424
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Missing person information in [dbo].[tls206_person]?

Post by EPO / PATSTAT Support » Tue Nov 02, 2021 3:39 pm

I assume you are using a corrupt data set, or maybe a PATSTAT extraction where that data was not included due to the download criteria.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply