Search found 2 matches

by khanhhienbi
Mon Nov 09, 2020 12:24 pm
Forum: PATSTAT Product Line
Topic: Help with SQL query - How to count the number of patent applications of a specific company
Replies: 1
Views: 95

Help with SQL query - How to count the number of patent applications of a specific company

Hi everyone, I am currently working with PATSTAT Spring 2020 edition. I am currently looking at the number of total granted patents of a specific company from 2000 to 2019. I also would like to add the results as a column next to my existing table if possible: SELECT t1.appln_id, t1.appln_auth, t1.a...
by khanhhienbi
Thu Sep 03, 2020 11:16 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - How to retrieve name of the patent's applicant(s)
Replies: 1
Views: 551

Help with SQL query - How to retrieve name of the patent's applicant(s)

Hi everyone, I am currently working with PATSTAT Spring 2020 edition. My aim is to retrieve all the name of the patent's applicant(s) for a limited number of UK biotech companies from 2016 to 2020. Please find the codes I've written below. Here is a brief description of the methodology I used: Use t...