Reconciling Patstat and AMADEUS patent information

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

dvencappa
Posts: 4
Joined: Tue Mar 30, 2021 6:20 am

Reconciling Patstat and AMADEUS patent information

Post by dvencappa » Wed Apr 14, 2021 5:56 am

Hello Patstat experts,

I am currently working on matching company names in Patstat to company names in a financial database - Financial Analysis Made Easy (FAME). FAME is provided by Bureau van Djik, which also supplies other financial databases such as AMADEUS and ORBIS. More recent versions of Amadeus (and Orbis) now have a patent module which records the following information (I provide an example of one such patent number in brackets).

I was looking for the equivalent Patents publication/ application number in Patstat but could not quite figure out which are the corresponding fields I ought to be looking in Patstat to enable a smooth match between the company names in Patstat and those in FAME (via Amadeus). In essence, what I am trying to do is to match the application number (once I understand which one I should be using) from Patstat to that in the patents module in Amadeus and from this I would get a company name and identifier which I can then directly match to the FAME database. Any suggestions would be helpful. The below are the fields recorded in the patents module section of Amadeus. I am trying to understand what the equivalent fields would be in Patstat which I can use to match these.

Thank you in advance

Patents Publication Identifier ( FR3037820(B1) )
Patents Application Number ( FR20150001306 20150624 )
Patents also published as ( FR3037820(A1) )


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

Re: Reconciling Patstat and AMADEUS patent information

Post by EPO / PATSTAT Support » Thu Apr 15, 2021 1:35 pm

Hello Dvencappa,
any of the 3 numbers formats are available in PATSTAT.
But you have to match it to the correct attributes in PATSTAT. For application numbers, the data should be available in the tls201_appln table. For publication numbers, you should look in the tls211_pat_publn table.

Code: Select all

SELECT pat_publn_id
      ,publn_auth
      ,publn_nr
      ,publn_nr_original
      ,publn_kind
      ,appln_auth
	  ,appln_nr
	  ,appln_kind
	  ,appln_filing_date
	  ,appln_nr_epodoc
  FROM tls211_pat_publn join tls201_appln 
  on tls211_pat_publn.appln_id = tls201_appln.appln_id
  where (publn_auth = 'FR' and publn_nr = '3037820' and publn_kind = 'B1')
 or (appln_nr_epodoc = 'FR20150001306' and appln_filing_date = '2015-06-24')
 or (publn_auth = 'FR' and publn_nr = '3037820' and publn_kind = 'A1')
an alternative sollution is use the CONCAT function. Something like this:

Code: Select all

SELECT pat_publn_id
      ,publn_auth
      ,publn_nr
      ,publn_nr_original
      ,publn_kind
      ,appln_auth
	  ,appln_nr
	  ,appln_kind
	  ,appln_filing_date
	  ,appln_nr_epodoc
	  ,(concat (publn_auth, publn_nr , '(',  publn_kind, ')' ))
  FROM tls211_pat_publn join tls201_appln 
  on tls211_pat_publn.appln_id = tls201_appln.appln_id
  where (concat (publn_auth, publn_nr , '(',  publn_kind, ')' ))= 'FR3037820(A1)'
Kindly keep in mind that the EPO has no control on how BVD uses or adapts the numbers in their data bases. It might be worth checking if BVD provides the appln_id or publn_id which would provide an unambiguous direct link to any of the PATSTAT releases without the need for matching publication or application numbers, country codes and dates.
The names of the applicants and inventors are also available in PATSTAT via the tls206_person table.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


dvencappa
Posts: 4
Joined: Tue Mar 30, 2021 6:20 am

Re: Reconciling Patstat and AMADEUS patent information

Post by dvencappa » Fri Apr 16, 2021 7:46 am

Thank you for this insight. The suggestion of concatenation of specific columns from Patstat appears to be what I am after and your description is very helpful in that regard.

Regards,
Dev


Post Reply