Title: SQL query to increase data accuracy and completeness in PATSTAT
Authors: PASIMENI FRANCESCO
Citation: WORLD PATENT INFORMATION vol. 57 p. 1-7
Publisher: PERGAMON PRESS LTD.
Publication Year: 2019
JRC N°: JRC112428
ISSN: 0172-2190 (online)
URI: http://publications.jrc.ec.europa.eu/repository/handle/JRC112428
DOI: 10.1016/j.wpi.2019.02.001
Type: Articles in periodicals and books
Abstract: PATSTAT is the worldwide patent statistical database created and maintained by the European Patent Office. Many methods and techniques have been developed to increase its accuracy and completeness. This paper contributes to this body of research. It proposes an allocation procedure which reduces by 44% the number of empty entries concerning the residence country of patentees, and, at the same time, it increases by 22% the accuracy of country code allocation. The procedure consists of a replicable SQL query to be run in PATSTAT. An application of this procedure illustrates that patent analyses based on raw data underestimate the role of China and Japan in the area of climate change mitigation technologies.
JRC Directorate:Energy, Transport and Climate

Files in This Item:
There are no files associated with this item.


Items in repository are protected by copyright, with all rights reserved, unless otherwise indicated.