Page 1 of 1

Can find some company applicant names from TLS206_PERSON

Posted: Sat Jan 05, 2019 6:14 am
by jsuch
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

Re: Can find some company applicant names from TLS206_PERSON

Posted: Mon Jan 07, 2019 11:57 am
by EPO / PATSTAT Support
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