How to find lapse country/date beyond EP Authority
Posted: Wed Feb 06, 2019 12:28 am
Dear Geert, Johannes, and Martin:
First, many thanks for your online seminar 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
First, many thanks for your online seminar 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