An Introduction to the Patstat Database with Example Queries

How can we effectively utilize the Patstat patent database for economic and management studies in innovation?

The Patstat database provides a rich source of patent data that can enhance empirical research in innovation economics and management. However, its complexity often deters potential users, leading to underutilization of this valuable resource. By providing structured queries and clarifying how to navigate the data, we aim to improve accessibility and promote better data-driven insights into the technological landscape.

We created a comprehensive introduction to the Patstat database, focusing on 10 practical SQL queries to guide new users. We employed the April 2013 edition of the database, which contains over 74 million records from various patent offices, and we illustrated the queries using a sample of patent applications related to wind-turbine technologies filed in 2005. The structured queries aimed to cover critical tables while highlighting potential research applications.

Our introduction provides practical guidance on the use of the Patstat database, including how to structure queries for relevant data retrieval. Our query results indicated a sample of 2,125 distinct patent applications related to wind-turbine technology, identifying 957 priority applications amongst them. Furthermore, we emphasized the complexity of linking various tables within the database to produce meaningful analysis results, which can be particularly beneficial for researchers interested in patent dynamics and innovation schemas.

• The Patstat database April 2013 edition containing over 74 million records
• Sample focused on 2,125 patent applications related to wind-turbine technologies filed in 2005

• Users possess a general knowledge of Structured Query Language (SQL)
• The queries are designed to simplify data retrieval while accounting for the complexities of patent filing and classification systems