How to find lapse country/date beyond EP Authority

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

wpark
Posts: 2
Joined: Tue Feb 05, 2019 11:57 pm

How to find lapse country/date beyond EP Authority

Post by wpark » Wed Feb 06, 2019 12:28 am

Dear Geert, Johannes, and Martin:

First, many thanks for your webinar this morning!

I write because I am interested in the time and country of lapse of the patent applications in my sample. However, I only retrieved lapsed patents associated with the EPO as the application authority. Is there a table or attribute that can provide information on lapses outside of the EP authority? Perhaps I missed it in the Data Catalogue.

Here is the set of commands I used:
SELECT a.appln_id, appln_auth, appln_filing_year, lapse_country, year(lapse_date)
FROM tls201_appln a
JOIN tls207_pers_appln p on a.appln_id = p.appln_id
JOIN tls206_person t on p.person_id = t.person_id
JOIN tls231_inpadoc_legal_event l on a.appln_id = l.appln_id
WHERE lapse_country!=''

and earliest_filing_year>1979 AND earliest_filing_year<2010
and appln_kind='A'
and ipr_type='PI'
and granted='Y'
and invt_seq_nr>0
and (psn_sector='COMPANY' or psn_sector='UNIVERSITY' or psn_sector='GOV NON-PROFIT')
and (person_ctry_code='DE' or person_ctry_code='FR' or person_ctry_code='GB' or person_ctry_code='JP' or person_ctry_code='US')

This generated 6,788 rows, all of which only yielded EP as the application authority.

Now when I remove the link to the tls231_inpadoc_legal_event table and associated variables of interest (please see bold), I retrieve 16,009 rows. And they show patents associated with various other application authorities, like KR, DE, MX, CA, US, and EP. Thus, it seems that my commands linking to the tls231 table only retrieves lapsed applications associated with EP. So, is there a way to find out when the rest of the applications in my sample lapsed (and in which countries)? If I remove the lapse_country!='' criterion, then yes, I do retrieve applications in other authorities, but then the lapse year is all 9999.

Please advise,
Walter


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

How to find lapse country/date beyond EP Authority

Post by EPO / PATSTAT Support » Wed Feb 06, 2019 11:57 am

Hello Walter,
we are happy that you found the PATSTAT seminar useful.
The lapse_country and year(lapse_date) attributes are specifically linked to (granted) EP applications and are not used for any other patents filed at other patent offices.
If you want to get a list of patens that have lapsed covering multiple patent offices you have 2 options:
a) you can check for each of the patent offices which legal event codes are used that would indicate a possible "lapse"
b) if you can accept a "broader" definition of lapse, then you could use the newly introduced categorisation of legal event codes. This approach is modelled on the WIPO ST.27 standard.
inpadoc_classification_scheme_v1.0_en.pdf
(207.04 KiB) Downloaded 5 times
By using the condition " event_category_code = 'H' " you should cover all the legal events across all patent offices which reflect an " IP RIGHT CESSATION ". Using this approach will equally include the EP applications for which national phase applications have lapsed.
A reviewed query could look like:

Code: Select all

SELECT distinct a.appln_id, appln_auth, appln_filing_year, l.event_code,lapse_country, year(lapse_date) lapse,
event_category_code, event_category_title, year(event_publn_date) evt_pub_yr
 FROM tls201_appln a
 JOIN tls207_pers_appln p on a.appln_id = p.appln_id
 JOIN tls206_person t on p.person_id = t.person_id
JOIN tls231_inpadoc_legal_event l on a.appln_id = l.appln_id 
JOIN tls803_legal_event_code on l.event_auth = tls803_legal_event_code.event_auth and l.event_code = tls803_legal_event_code.event_code
 WHERE --lapse_country!='' and
 earliest_filing_year>1979 AND earliest_filing_year<2010
 and appln_kind='A'
 and ipr_type='PI'
 and granted='Y'
 and invt_seq_nr>0
 and psn_sector in ('COMPANY','UNIVERSITY','GOV NON-PROFIT')
 and person_ctry_code in ('DE','FR','GB','JP','US')
 and event_category_code = 'H'
 order by appln_filing_year desc,  appln_id
I added the year of publication of the event to have some kind of date when the event took place.

If you want to have a detailed look at which legal event codes are covered by using the "event_category_code = 'H' " clause, you could run the query below. Based on that list (containg about 400 codes), you have enough information for possible fine tuning your query by explicitly removing further codes that do not fit your purpose.

Code: Select all

SELECT distinct l.event_auth,l.event_code,tls803_legal_event_code.event_category_code, l.event_descr, 
tls803_legal_event_code.event_category_title
FROM tls231_inpadoc_legal_event l 
JOIN tls803_legal_event_code on l.event_auth = tls803_legal_event_code.event_auth 
	and l.event_code = tls803_legal_event_code.event_code
WHERE  event_category_code = 'H'
order by l.event_auth, l.event_code
Another list I find very useful is this excel sheet that illustrates to which extend certain legal event codes are (still) used; basically a coverage of INPADOC data. The SQL on how to make the list is in the document as well.
inpadoc_classification_scheme_v1.0_en.pdf
(207.04 KiB) Downloaded 5 times
I hope this helps.
Geert BOEDT
Attachments
INPADOC_legal_events_overview.xlsx
(764.82 KiB) Downloaded 3 times
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


wpark
Posts: 2
Joined: Tue Feb 05, 2019 11:57 pm

Re: How to find lapse country/date beyond EP Authority

Post by wpark » Fri Feb 08, 2019 4:22 am

Many thanks Geert for your guidance and documentation. You provided the information and coding I was looking for.

All the best,
Walter


Post Reply