Hi everyone,
Geert Boedt (EPO), Helene Dernis (OECD) and myself have written a 10-page introduction to the offline Patstat database. The article provides MySQL and SQL codes for several popular queries:
- How to identify patent applications by technology field
- How to identify PCT patent applications
- How to know whether a patent application is a priority filing
- How to compute the patent family size
- How to count patents by country of inventor/applicant
- How to identify patents resulting from international collaboration
- How to count citations
- How to know whether a patent was granted
- How to link Patstat with external databases
If you are new to Patstat, then it is a great starting point. If you are already familiar with Patstat, the article is a good way of validating your queries!
You can download the article free of charge:
http://www.gder.info/paper_An_introduct ... eries.html from my website.
The source code as well as a sample MS Access database for those of you who don’t have Patstat installed is available from Run My Code website.
The article is forthcoming in the Australian Economic Review:
de Rassenfosse, G., Dernis, H. & Boedt, G., 2014. "An introduction to the Patstat database with example queries". Australian Economic Review 47(3), 395-408.
Enjoy !
Gaetan
PS: You may also be interested in a previous related topic on the worldwide count of priority filings.
Introduction to patent indicators: sample code & test data.
-
- Posts: 176
- Joined: Tue Oct 19, 2004 10:36 am
- Location: Vienna