[Help] Querying the number of patents with Chinese inventor as the first inventor

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.
Post Reply

Edwardsj
Posts: 2
Joined: Fri Jul 13, 2018 5:39 pm

[Help] Querying the number of patents with Chinese inventor as the first inventor

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. Image 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: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: [Help] Querying the number of patents with Chinese inventor as the first inventor

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.
Publications_per_applicant_country.xlsx
(974.47 KiB) Downloaded 180 times
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


Post Reply