Mapping data completeness of PATSTAT Global and INPADOC data (TLS231)

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: 251
Joined: Thu Feb 22, 2007 5:33 pm

Mapping data completeness of PATSTAT Global and INPADOC data (TLS231)

Post by EPO / PATSTAT Support » Wed Dec 19, 2018 11:21 am

When doing advanced statistical analysis, it is important to understand the coverage and content of the data you are working with. PATSTAT Global contains data coming from all over the world. Quality, timeliness and completeness vary a great deal depending on your data selection approach.
Therefore the PATSTAT team has created a Tableau dashboard that maps the content and coverage of PATSTAT Global. The link below will lead you to the published dashboard without the need of you having to install special software.
If you have observations or suggestions for improvements, kindly let us know via -patstat @

Spring 2021: ... STATGlobal
Autumn 2020: ... STATGlobal
Spring 2020: ... STATGlobal
Autumn 2019: ... STATGlobal
Spring 2019: ... STATGlobal

The TLS231_INPADOC_LEGAL_EVENT table contains a whopping 330 million records covering legal status from 61 patent authorities using 3.927 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.
(1019.66 KiB) Downloaded 63 times
(1.03 MiB) Downloaded 23 times
(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.)
Last edited by EPO / PATSTAT Support on Fri Nov 13, 2020 3:27 pm, edited 1 time in total.
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply