Please use this identifier to cite or link to this item:
|Title:||SQL query to increase data accuracy and completeness in PATSTAT|
|Citation:||WORLD PATENT INFORMATION vol. 57 p. 1-7|
|Publisher:||PERGAMON PRESS LTD.|
|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.