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?
Missing person information in [dbo].[tls206_person]?
-
- Posts: 426
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Missing person information in [dbo].[tls206_person]?
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.
https://worldwide.espacenet.com/publica ... 73A1&KC=A1
PATSTAT results:
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
PATSTAT results:
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org
Re: Missing person information in [dbo].[tls206_person]?
Hm, curiously that returns zero results.
-
- Posts: 426
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Missing person information in [dbo].[tls206_person]?
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
EPO - Vienna
patstat @ epo.org