Make a Patstat query based on publication numbers
Posted: Tue May 24, 2016 7:50 am
Hi,
Imagine that I have a list of many publication numbers:
US2016138562, WO2014198277, WO2014198277, …
Now I want to investigate these in Patstat - is there an easy way of entering these into a Patstat query?
The problem is that the publication number in the tls211_pat_publn is divided into publn_auth and publn. My ‘solution’ so far has been to go to espacenet and retrieve application numbers:
US201615007680, WO2014DK50164, WO2014DK50164, …
And then find the applications via:
tls201_appln.appln_nr_epodoc in ('US201615007680' , 'WO2014DK50164' , 'WO2014DK50164')
Is there a better/smarter way of doing this?
I hope that you can help
Thanks,
Carsten
Imagine that I have a list of many publication numbers:
US2016138562, WO2014198277, WO2014198277, …
Now I want to investigate these in Patstat - is there an easy way of entering these into a Patstat query?
The problem is that the publication number in the tls211_pat_publn is divided into publn_auth and publn. My ‘solution’ so far has been to go to espacenet and retrieve application numbers:
US201615007680, WO2014DK50164, WO2014DK50164, …
And then find the applications via:
tls201_appln.appln_nr_epodoc in ('US201615007680' , 'WO2014DK50164' , 'WO2014DK50164')
Is there a better/smarter way of doing this?
I hope that you can help
Thanks,
Carsten