Search found 5 matches
- Mon Jul 15, 2019 6:14 am
- Forum: PATSTAT Product Line
- Topic: how to extract patent applications with cross boarder collaboration
- Replies: 5
- Views: 3530
Re: how to extract patent applications with cross boarder collaboration
Hi Geert, I understand the following code is for all patents granted by the EPO. How can I modify the code to extract PCT applications with international collaborations? Appreciate your support. Thank you so much. SELECT tls201_appln.appln_id, tls201_appln.appln_nr_epodoc, invt_seq_nr,tls206_person....
- Thu Mar 14, 2019 10:13 am
- Forum: PATSTAT Product Line
- Topic: how to extract patent applications with cross boarder collaboration
- Replies: 5
- Views: 3530
Re: how to extract patent applications with cross boarder collaboration
Thank you so much for the clarification. Appreciate your help.
- Thu Mar 14, 2019 3:38 am
- Forum: PATSTAT Product Line
- Topic: how to extract patent applications with cross boarder collaboration
- Replies: 5
- Views: 3530
Re: how to extract patent applications with cross boarder collaboration
Dear Geert, Thank you very much for your reply. The first code is more relevant to me since I need to identify the country codes. I need a small clarification on the 1st code you have provides. You have specified the application authority as "EP". I assume this gives me all the patents gra...
- Wed Mar 13, 2019 10:15 am
- Forum: PATSTAT Product Line
- Topic: how to extract patent applications with cross boarder collaboration
- Replies: 5
- Views: 3530
how to extract patent applications with cross boarder collaboration
hi PATSTAT Team, I'm trying to create a dataset for bilateral patent collaborations. I have the following code but its captures patents collaborations within the same country. How can I modify this code to capture only those patent applications with innovators spread across different countries. SELE...
- Tue Mar 12, 2019 8:44 am
- Forum: PATSTAT Product Line
- Topic: Retrieving patents with inventors spread across multiple countries
- Replies: 3
- Views: 3836
Re: Retrieving patents with inventors spread across multiple countries
Hi PATSTAT Team, I'm totally new to PATSTAT and SQL language. I'm trying to create a dataset for bilateral patent flows. So I need the number of patents for each country pair. I have gone through Martin's code on retrieving patents spread across multiple countries. I'm only interested in patents wit...