Search found 2 matches
- 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: 1290
[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...
- Fri Jul 13, 2018 5:55 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT and Espacenet consistency
- Replies: 1
- Views: 1921
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...