Can find some company applicant names from 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

jsuch
Posts: 1
Joined: Sat Jan 05, 2019 6:04 am

Can find some company applicant names from TLS206_PERSON

Post by jsuch » Sat Jan 05, 2019 6:14 am

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


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

Re: Can find some company applicant names from TLS206_PERSON

Post by EPO / PATSTAT Support » Mon Jan 07, 2019 11:57 am

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:

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'
Geert BOEDT
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply