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: 367
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 all the patents included in 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 @

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

The TLS231_INPADOC_LEGAL_EVENT table currently contains a whopping 360 million records covering legal status from 61 patent authorities using 3.368 different legal event codes.
Researchers need to have a good understanding on 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.
(1.11 MiB) Downloaded 49 times
(1.03 MiB) Downloaded 88 times
(1.01 MiB) Downloaded 117 times
(1.03 MiB) Downloaded 264 times
(1019.66 KiB) Downloaded 327 times
(The excel sheet also includes the query used to extract the overview table. You can use the excel filters to narrow down and select event codes, event_category_code, event authority or any other relevant data item according to your needs.)
Last edited by EPO / PATSTAT Support on Thu Oct 28, 2021 5:25 pm, edited 2 times in total.
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply