Search found 8 matches
- Tue Nov 16, 2021 5:49 am
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3325
Re: count forward citations
Thanks!!
- Mon Nov 15, 2021 1:36 pm
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3325
Re: count forward citations
Hi,
Thanks for helping out.
Actually, would you please show me a sample code for counting the family-family citations?
Thanks for helping out.
Actually, would you please show me a sample code for counting the family-family citations?
- Fri Nov 12, 2021 2:25 am
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3325
Re: count forward citations
Thank you very much
- Thu Nov 11, 2021 11:19 am
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3325
count forward citations
hi, I am trying to the count total number of forward citations of US patents that have certain IPC code. Then I group the result by publication year. Here is my code: select count (distinct(a212.pat_publn_id)) as number , year(a211.publn_date) AS date from patstat2021a.dbo.tls201_appln a1 join patst...
- Tue Oct 09, 2018 12:51 am
- Forum: PATSTAT Product Line
- Topic: Count Patent based on Assignee Country
- Replies: 1
- Views: 1912
Count Patent based on Assignee Country
Daer PATSTAT Support, I em experiencing difficulty when I try to perform counting patents based on Assignee Country. For example, when I tried to find all the patent issued by the Japanese Patent Office to Japanese companies in 2005, I used the following code: select a1.appln_id, tls206_person.perso...
- Mon Aug 06, 2018 8:23 pm
- Forum: PATSTAT Product Line
- Topic: Need Help with International Patents
- Replies: 2
- Views: 2555
Re: Need Help with International Patents
Huge Thanks!
- Thu Jul 05, 2018 7:42 pm
- Forum: PATSTAT Product Line
- Topic: IPC Classification
- Replies: 1
- Views: 5726
IPC Classification
Hi Dear All, I am trying to obtain all the patents under a certain IPC classification with certain criteria. It always returns with 32 million results, which I believe is the total number of patents in the world. Anyway, I did some test searching and will post some of my code (pretty simple). Would ...
- Tue Jul 03, 2018 5:32 am
- Forum: PATSTAT Product Line
- Topic: Need Help with International Patents
- Replies: 2
- Views: 2555
Need Help with International Patents
Hi, I am conducting research on international patents, and trying to find the same patent but different grant date and publication date in different receiving offices. A situation could be like this, for example : Apple registered a patent under USPTO, but Apple later want the patent to be protected...