Search found 6 matches
- Sat Jun 24, 2017 12:06 am
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 4458
Re: Searching for help concerning PATSTAT query
Hi, I have another question concerning my search query. First search query: SELECT DISTINCT a.* FROM tls201_appln a JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id JOIN tls206_person p on pa.person_id = p.person_id WHERE appln_auth = 'EP' AND a.appln_id < 900000000 -- exclude artificial applic...
- Fri Jun 09, 2017 7:48 pm
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 4458
Re: Searching for help concerning PATSTAT query
Thanks for your help. I adjusted the query to the following code: SELECT DISTINCT * FROM tls201_appln a JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id JOIN tls206_person p on pa.person_id = p.person_id WHERE a.appln_id < 900000000 -- exclude artificial applications (see PATSTAT Data Catalog f...
- Fri Jun 09, 2017 9:48 am
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 4458
Re: Searching for help concerning PATSTAT query
Thanks for your reply! I have another question: With the query above I only get the EP applications filed by the German company "Siemens". SELECT DISTINCT a.* FROM tls201_appln a JOIN tls207_pers_appln pa on a.appln_id = pa.appln_id JOIN tls206_person p on pa.person_id = p.person_id WHERE ...
- Wed Jun 07, 2017 5:16 pm
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 4458
Searching for help concerning PATSTAT query
Hello everyone, concerning my recent research project I need the following data: the number of patents applied concerning a specific company in a specific year. For example: Company: Siemens Year: 2013 Therefore I found this query which works great. SELECT DISTINCT a.* FROM tls201_appln a JOIN tls20...
- Fri May 05, 2017 1:16 pm
- Forum: Search tips
- Topic: Number of patents applied/granted
- Replies: 0
- Views: 1480
Number of patents applied/granted
Hi, concerning my recent research project I need the following data: the number of patents applied concerning a specific company in a specific year. Example for Advanced search of Espacenet: Application number: 2010 Applicants: "Robert Bosch GmbH" To promote the understanding of my questio...
- Thu May 04, 2017 5:34 pm
- Forum: PATSTAT Product Line
- Topic: Number of patents applied/granted
- Replies: 1
- Views: 1541
Number of patents applied/granted
Hi, concerning my recent research project I need the following data: the number of patents granted/applied concerning a specific company in a specific year. For example: Company: Robert Bosch GmbH Year: 2010 To promote the understanding of my question this link may help: https://www.epo.org/about-us...