Page 1 of 1

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

Posted: Wed Dec 19, 2018 11:21 am
by EPO / PATSTAT Support
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 @ epo.org-

Autumn 2023: https://public.tableau.com/app/profile/ ... STATGlobal
Spring 2023: https://public.tableau.com/app/profile/ ... STATGlobal
Autumn 2022: https://public.tableau.com/app/profile/ ... 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.
Overview_legal_status_events_tls231_2023b.xlsx
(1.15 MiB) Downloaded 164 times
Overview_legal_status_events_tls231_2023a.xlsx
(1.14 MiB) Downloaded 278 times
Overview_legal_status_events_tls231_2022b.xlsx
(1.11 MiB) Downloaded 294 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.)