Using PATSTAT Autumn 2016 edition. When we search TLS206_PERSON for an applicant we are not finding any results. A manual search of Espacenet returns patents for the applicant name. If we use the application number and then look up the associated person_name/psn_name/doc_std_name, we find the inventor name from Espacenet but not the applicant name listed in the Espace search
eg CN20091109748,
Espacenet search shows Inventor(s): XINGUO LI + (LI XINGUO)
Applicant(s): SHENZHEN STATE MICRO TECHNOLOG + (SHENZHEN STATE MICRO TECHNOLOGY CO., LTD)
Our search of patstat returns for CN20091109748, finds just LI XINGUO in person_name/psn_name/doc_std_name and does not find SHENZHEN STATE MICRO TECHNOLOG/SHENZHEN STATE MICRO TECHNOLOGY CO., LTD
Can find some company applicant names from TLS206_PERSON
-
- Posts: 426
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Can find some company applicant names from TLS206_PERSON
Hello jsuch,
without your SQL query, it is not possible to see what could be wrong on your query.
In principle, data available in ESPACENET should be available in PATSTAT, with the exception of data that was added to DOCDB after the data was extracted for the PATSTAT production cycle. (mostly data added during the last 6 months maximal.)
Here is the SQL that will retrieve applicant and inventor names for the respective publications:
Geert BOEDT
without your SQL query, it is not possible to see what could be wrong on your query.
In principle, data available in ESPACENET should be available in PATSTAT, with the exception of data that was added to DOCDB after the data was extracted for the PATSTAT production cycle. (mostly data added during the last 6 months maximal.)
Here is the SQL that will retrieve applicant and inventor names for the respective publications:
Code: Select all
SELECT [pat_publn_id]
,[publn_auth]
,[publn_nr]
,[publn_nr_original]
,[publn_kind]
,[publn_date]
,[publn_lg]
,[publn_first_grant]
,[publn_claims]
,tls207_pers_appln.*
,tls206_person. psn_name
,tls206_person.doc_std_name
,tls206_person.person_name
FROM[tls211_pat_publn]
join tls207_pers_appln on tls211_pat_publn.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
where publn_auth = 'CN' and publn_nr = '101710859'
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org