Thanks!!

Hi,

Thanks for helping out.

Actually, would you please show me a sample code for counting the family-family citations?

Thank you very much

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

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

Huge Thanks!

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

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