An Introduction to the Patstat Database with Example Queries

20 Pages Posted: 2 Apr 2014

See all articles by Gaétan de Rassenfosse

Gaétan de Rassenfosse

École Polytechnique Fédérale de Lausanne

Hélène Dernis

Organization for Economic Co-Operation and Development (OECD)

Geert Boedt

European Patent Office

Multiple version iconThere are 2 versions of this paper

Date Written: April 1, 2014

Abstract

This paper provides an introduction to the Patstat patent database. It offers guided examples of ten popular queries that are relevant for research purposes and that cover the most important data tables. It is targeted at academic researchers and practitioners willing to learn the basics of the database.

Keywords: patent, Patstat, MySQL

JEL Classification: O30

Suggested Citation

de Rassenfosse, Gaétan and Dernis, Hélène and Boedt, Geert, An Introduction to the Patstat Database with Example Queries (April 1, 2014). Available at SSRN: https://ssrn.com/abstract=2418745 or http://dx.doi.org/10.2139/ssrn.2418745

Gaétan De Rassenfosse (Contact Author)

École Polytechnique Fédérale de Lausanne ( email )

Station 5
Odyssea 1.04
1015 Lausanne, CH-1015
Switzerland

Hélène Dernis

Organization for Economic Co-Operation and Development (OECD) ( email )

2 rue Andre Pascal
Paris Cedex 16, 75775
France

Geert Boedt

European Patent Office ( email )

Bob-van- Benthem-Platz 1
Munich, DE 80538
Germany

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
611
Abstract Views
1,999
Rank
69,312
PlumX Metrics