Search found 5 matches

by Djay
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....
by Djay
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.
by Djay
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...
by Djay
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...
by Djay
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...