Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
-
Edwardsj
- Posts: 2
- Joined: Fri Jul 13, 2018 5:39 pm
Post
by Edwardsj » Mon May 18, 2020 6:10 pm
Hi, I developed the following query to extract the annual number of nanotech patents whose first inventor is Chinese.
Code: Select all
SELECT count(*)
FROM
(SELECT t207.person_id,
t207.appln_id
FROM tls207_pers_appln AS t207
WHERE (t207.appln_id IN
(SELECT t201temp.appln_id
FROM
(SELECT t201.appln_id
FROM tls201_appln AS t201
WHERE t201.earliest_publn_year = 20xx) AS t201temp
JOIN tls202_appln_title AS t202
ON t201temp.appln_id = t202.appln_id
JOIN tls203_appln_abstr AS t203
ON t201temp.appln_id = t203.appln_id
WHERE (t202.appln_title LIKE '%nano%'
OR t203.appln_abstract LIKE '%nano%'))
AND t207.invt_seq_nr = 1)) AS author
JOIN tls206_person AS t206
ON author.person_id = t206.person_id
WHERE t206.person_ctry_code IN ('CN') /* Replaced with 'US', 'JP', 'KR', etc. */
We ran the query for different countries as well. However, when we compare the results, we found a weird drop in Chinese inventors since 2010.
It seems like the number is systematically lower, given that patent applications across the globe share a similar growth.
Can anyone help me explain this weird result?
Thank you in advance!
-
EPO / PATSTAT Support
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
-
Contact:
Post
by EPO / PATSTAT Support » Tue May 19, 2020 12:48 pm
Hello Edwardsj,
the answer is straightforward,
from 2010 onwards, we do not receive applicant country codes for applications filed in China.
There is not much we can do about this, you might simply exclude applications filed in China from your data (at least the utility models), and maybe only take into account those applications filed in China that have an EP, US or WO family member. Another option is to simply assume that all first filings in China are made by a Chinese applicant.
I have attached an excel sheet that illustrates the missing person country data, and included the query to make the table.
Also have a look at this forum post which gives an overview of all attributes/coverage/completeness in PATSTAT.
mapping-data-completeness-of-patstat-gl ... 984#p22441
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org