Getting Started with PATSTAT Register

TL;DR

This paper introduces the PATSTAT Register database and demonstrates how to access its key features using eight MySQL queries, aiding researchers and practitioners in patent data analysis.

Contribution

It provides a technical guide with practical queries for accessing and analyzing patent data in the PATSTAT Register database.

Findings

Eight MySQL queries covering key database aspects

Guidance tailored for researchers familiar with PATSTAT

Facilitates efficient patent data research and analysis

Abstract

This paper provides a technical introduction to the PATSTAT Register database, which contains bibliographical, procedural and legal status data on patent applications handled by the European Patent Office. It presents eight MySQL queries that cover some of the most relevant aspects of the database for research purposes. It targets academic researchers and practitioners who are familiar with the PATSTAT database and the MySQL language.