PATSTAT Subscription Question

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

Hevman77
Posts: 4
Joined: Thu Feb 04, 2016 8:16 pm

PATSTAT Subscription Question

Post by Hevman77 » Thu Feb 04, 2016 8:36 pm

I'm doing research on patent delay problems in countries like India and Brazil and want to know what PATSTAT subscription is the best for this type of study. The different options are confusing and any advice would be greatly appreciated.

-Kevin


Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: PATSTAT Subscription Question

Post by Geert Boedt » Wed Feb 10, 2016 10:55 am

Hello Kevin,

I fear that the data coverage of Indian patents in PATSTAT is not sufficient to carry out "delay analysis" for India.
This query shows that we do not have information on granted patents for India.

Code: Select all

SELECT appln_auth
      ,count(case when granted = 1 then appln_id end) as granted
	  ,count(case when granted = 0 then appln_id end)  as not_granted
	  ,count(appln_id) as total
FROM [patstat2015b].[dbo].[tls201_appln]
where appln_auth in ('IN','BR')
group by appln_auth
appln_auth granted not_granted total
BR - 2932 - 570561 - 599886
IN - 0 - 85686 - 85686

For Brazil we have some information on granted patents, but looking at the figures, I assume there are more granted patents then what we have indicated as "granted" in PATSTAT. Any study involving "patent granting procedures" would mean you need to have PATSTAT in combination with the EPO Worldwide Legal Status Database for PATSTAT. This database does not have any coverage for IN national applications. There is coverage for BR, but -again- you need to check if it contains the information and coverage useful for your study.
PATSTAT: http://www.epo.org/searching-for-patent ... tstat.html
Coverage:
http://www.epo.org/searching-for-patent ... eekly.html
If you would want to carry such study on applications filed at the EPO, then I would recommend to purchase the "European Patent Register for PATSTAT " database. This data base contains all (public) procedural and event data for European patents.
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


Hevman77
Posts: 4
Joined: Thu Feb 04, 2016 8:16 pm

Re: PATSTAT Subscription Question

Post by Hevman77 » Fri Feb 12, 2016 8:54 pm

Mr. Boedt,

Thank you very much for your reply. I was hoping you could recommend a training webinar that would describe how to run searches in PATSTAT similar to the one you ran as an example in your reply.

-Kevin


Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: PATSTAT Subscription Question

Post by Geert Boedt » Mon Feb 15, 2016 9:16 am

Hello Kevin,
there is a classroom training planned now in March (2016).
You can find it through this link; just search for "PATSTAT".
http://www.epo.org/learning-events/events/search.html
(At this moment: http://www.epo.org/learning-events/even ... l?id=13258)
We also had a webinar last week which will be published shortly. The webinar is more of an overview then a training module, but it is a good start.

Then there is also the self-learning module and he documentation you can find on our website.
Have a look at the "downloads" tab at this link:

http://www.epo.org/searching-for-patent ... tstat.html
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


Hevman77
Posts: 4
Joined: Thu Feb 04, 2016 8:16 pm

Re: PATSTAT Subscription Question

Post by Hevman77 » Tue Feb 16, 2016 2:56 am

Dear Mr. Boedt,

Can you advise how I would query on the basis of the date the patent was granted (versus filed or published)?

Thank you for your assistance,

-Kevin


Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: PATSTAT Subscription Question

Post by Geert Boedt » Tue Feb 16, 2016 9:43 am

Hello Kevin,
filed but un-published patents are not available to the public. Patent applications are (normally) published 18 months after the filing date, after which they become available to the public. Once the patent is granted, the "patent specification" containing the granted claims will be published. Generalised for EP patents: the A1 document is the publication (containing all the claims and the search report), the B1 document (containing only the claims that were granted) indicates that the patent is (was) granted.
The "date" of the EP B1 publication gives you the date when the patent was granted. Absence of the B1 publication can indicated that the patent is not (yet) granted. The time frame between filing and granting of the patent depends on the complexity of the invention.

However, different patent authorities (and grant procedures) use different publication codes to identify the granted patents. Therefore, to make it easier for PATSTAT users, we have pre-aggregated an attribute "grant" in the tls201_appln table that has the value "1" when the patent was granted or "0" when no publication is available that the patent was granted. You need to check the data coverage to see whether or not PATSTAT contains the information from the countries you want to include in your research.
Smalle example: assume you want to retrieve all patents filed in Sweden in 2005 that were granted.
This is the query:

Code: Select all

select * from tls201_appln
where appln_auth = 'SE'
and appln_filing_year = 2005
and granted = 1
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


Hevman77
Posts: 4
Joined: Thu Feb 04, 2016 8:16 pm

Re: PATSTAT Subscription Question

Post by Hevman77 » Wed Mar 23, 2016 6:02 pm

Mr. Boedt,

I wanted to ask you about searching for granted patents using the tsl211 table. A colleague of mine said there may be a way to arrive at grant date in an indirect manner using the publn_first_grant query. I have tried running some queries, specifically for Argentine patents, using this qualifier, but have not had much luck. Are you aware of this method for arriving at patent grant data? I appreciate your help.

Thanks,

Kevin Madigan


mkracker
Posts: 121
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: PATSTAT Subscription Question

Post by mkracker » Thu Mar 31, 2016 1:19 pm

Your colleague is right. For example see some publications with granting effect (publn_first_grant = 1) from Switzerland:

Code: Select all

select top 10 *
from tls211_pat_publn
where publn_first_grant = 1
and publn_auth = 'CH' --  just as an example
The publication date of publications with granting effect corresponds in almost all cases to the date of grant. In some jurisdictions there are exceptions. E.g. to my knowledge, utility models in Austria are published 2 month after the date of grant.

You checked with patents from Argentina. Unfortunately the EPO does not have any publications with granting effect from Argentina since 1995, so you won't find them in PATSTAT.
-------------------------------------------
Martin Kracker / EPO


Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: PATSTAT Subscription Question

Post by Geert Boedt » Mon Apr 04, 2016 11:38 am

Hello Kevin,
you also need to look at legal status data in the tls221_inpadoc_prs data to get a comprehensive overview of "granted" patents. PATSTAT is based on publications, for which the EPO has received the bibliographical data. INPADOC contains legal status information, provided to the EPO by the respective national patent offices.
Specific for Argentina, we do not have patent publications that indicate that a patent was granted (in fact, maybe there are no publications, you would need to check with the Argentinian patent offices to see whether the granting procedure involves a specific publication that proves the grant), but, we receive legal status information that a patent was granted. Remember that the attribute "granted" only takes into account the fact that EPO has received bibliographical data of a publication indicating a grant. It does NOT take into account inpadoc legal status data.

Have a look at this query:

Code: Select all

SELECT [appln_auth]
      ,[appln_nr]
      ,[appln_kind]
      ,[appln_filing_date]
      ,[appln_filing_year]
      ,[appln_nr_epodoc]
      ,[ipr_type]
      ,[internat_appln_id]
      ,[granted]
      ,tls221_inpadoc_prs.prs_code
	  ,tls221_inpadoc_prs.prs_gazette_date
  FROM tls201_appln join tls221_inpadoc_prs on tls201_appln.appln_id = tls221_inpadoc_prs.appln_id
  where prs_code = 'FG' and appln_auth = 'AR'
order by appln_filing_date desc
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


Post Reply