Data retrieval of the patent references possible ?.

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

alexsunny123
Posts: 1
Joined: Thu Jul 01, 2021 9:05 am

Data retrieval of the patent references possible ?.

Post by alexsunny123 » Thu Jul 01, 2021 9:06 am

Hello,

I am new to patent research and I could use some help. I am researching about a half a dozen patents, and I need help creating a code to find the patents that each of them reference. I need the publication date, filing date, and priority date of each patent that is referenced from the original patent. I would then like to search for each of the resulting patents using the same method and record the third tier of patents that are referenced.

Also, what would be the best method to extract the data and put it in Microsoft Excel? Is all of this possible using this service? If not, is there a way to complete my research using a more effective method than just searching through each patent individually?

thanks
alexsunny


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Data retrieval of the patent references possible ?.

Post by EPO / PATSTAT Support » Mon Jul 05, 2021 8:14 am

Hello alexsunny,
yes, it can be done in PATSTAT, but if you only need to do this for "half a dozen" of patent applications, it might be easier and quicker to do this via ESPACENET and the CCD (Common Citation Document) platform.
https://www.fiveipoffices.org/activitie ... /ccd_index .
Getting acquainted with PATSTAT and SQL can be rather challenging.
CCD allows for "1 level" lookup and easy export into an excel sheet. You have then the possibility from within that excel sheet directly open the "cited" documents and repeat the process.
(There is a small hick-up: the link in the excel sheet goes to what we call the "old espacenet", so you might be thrown of guard on the different layout, but the functionality is the same and you can also export that "second level" citation.) Priority data is not in the exported data; filing date is.
If your patents include US patents (or cited US patents), you also might exclude the citations given by the applicants to keep the numbers reasonable (and the results more relevant). This yo can do via the filter on the CitnOrigin column H in the exported excel sheet.

And what is also important is the size of the search reports of those "half a dozen of patents". If many documents are cited (by the family), and they in turn cited many other patents (or NPL), then the numbers can get very high anyway. You will need to try it out with your selection.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


alok.tripathi
Posts: 1
Joined: Mon Jun 05, 2023 9:03 am

Is it possible to get data of citations from CCD ?

Post by alok.tripathi » Mon Jun 05, 2023 9:11 am

Using python script and making api call, Is it possible to get citation data from common citation document ?
As there are some tokens being used in header of GET request.


wargroup
Posts: 1
Joined: Wed Oct 25, 2023 4:16 am

Re: Data retrieval of the patent references possible ?.

Post by wargroup » Wed Oct 25, 2023 4:18 am

I think it's completely possible. To make the numbers realistic (and the findings more applicable), you may also take the citations that the applicants provided into consideration. By using the filter on the CitnOrigin column H in the exported Excel file, you can do this.


salmawisoky85
Posts: 1
Joined: Tue Nov 14, 2023 5:23 am

Re: Data retrieval of the patent references possible ?.

Post by salmawisoky85 » Tue Nov 14, 2023 6:00 am

To find the patents referenced by the original patents, you can use the patent databases and APIs provided by patent offices like the United States Patent and Trademark Office (USPTO) or the European Patent Office (EPO). These databases allow you to search for patents based on various criteria, including patent numbers, keywords, and citation information.


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Data retrieval of the patent references possible ?.

Post by EPO / PATSTAT Support » Wed Nov 22, 2023 3:09 pm

PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply