Search found 2 matches

by Edwardsj
Mon May 18, 2020 6:10 pm
Forum: PATSTAT Product Line
Topic: [Help] Querying the number of patents with Chinese inventor as the first inventor
Replies: 1
Views: 1289

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

Hi, I developed the following query to extract the annual number of nanotech patents whose first inventor is Chinese. 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_app...
by Edwardsj
Fri Jul 13, 2018 5:55 pm
Forum: PATSTAT Product Line
Topic: PATSTAT and Espacenet consistency
Replies: 1
Views: 1917

PATSTAT and Espacenet consistency

Hi, Previously I used the Advanced Search service on Espacenet and the search page only has "Publication Date." When I started to use PATSTAT online, I wonder how should I select the proper 'date' to get a similar output as the Espacenet results? For example, if my Espacenet query is DB=EP...