SQL query to increase data accuracy and completeness in PATSTAT

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.

PASIMENI Francesco; 

2019-03-12

PERGAMON PRESS LTD.

JRC112428

0172-2190 (online),   

https://publications.jrc.ec.europa.eu/repository/handle/JRC112428,   

10.1016/j.wpi.2019.02.001 (online),