Mapping Inpadoc legal event data

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

Posts: 157
Joined: Thu Feb 22, 2007 5:33 pm

Mapping Inpadoc legal event data

Post by EPO / PATSTAT Support » Wed Dec 04, 2019 5:24 pm

The TLS231_INPADOC_LEGAL_EVENT table contains a whopping 280 million records covering legal status from 59 patent authorities using 3.712 different legal event codes.
Researchers need to have a good understanding of the meaning of those codes before using them. But equally important is to understand the coverage and the use of the codes. Many legal event codes have been used very sporadic on a small number of applications before disappearing into obscurity.
To shed some light on this topic, you can find here an excel sheet that maps for all event codes the number of patents for which the codes have been used grouped by the respective patent application year. This should give researchers a good first indication whether or not the codes they intend to use are useful for the set of patents they want to analyse.
Comments are welcomed.
(The excel sheet also includes the query used to extract the overview table. You can use the filters to select codes relevant for the application or event authority according to your needs.)
(922.36 KiB) Downloaded 12 times
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply