Forward and Backward Citations for Specific Companies

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

gabriel_franceschini
Posts: 1
Joined: Thu Nov 24, 2022 12:10 pm

Forward and Backward Citations for Specific Companies

Post by gabriel_franceschini » Fri Nov 25, 2022 1:51 pm

Dear all,

I was wondering if there is a way to retrieve information about backward and forward citations attached to a specific person (in this case companies).
Ill share an example of query Im using so far:

Code: Select all

SELECT DISTINCT TOP 5000 *
FROM (((( tls212_citation AS cit INNER JOIN tls211_pat_publn AS pub ON cit.pat_publn_id = pub.pat_publn_id )
INNER JOIN tls201_appln AS ap ON pub.appln_id = ap.appln_id )
INNER JOIN tls207_pers_appln AS pa ON ap.appln_id = pa.appln_id )
INNER JOIN tls206_person AS p ON pa.person_id = p.person_id )
WHERE person_name = 'Prussiani Engineering S.A.S. di Prussiani Mario Gi'
OR person_name = 'PRUSSIANI ENGINEERING S.A.S. DI PRUSSIANI MARIO GIORGIO & C.'
Im not sure what Im getting when obtaining cited_pat_publn_id or the other variables, forward or backwards? Are those the complete history and can I be to a certain extent sure those are all the data I need to extract?

Thank you in advance for your help


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

Re: Forward and Backward Citations for Specific Companies

Post by EPO / PATSTAT Support » Mon Nov 28, 2022 4:43 pm

Hello Gabriel,
there are quite some posts on forward and backward citations.
Have a look at this :
forward-and-backward-citation-7892
german-inventors-citing-u-s-patents-839 ... 178#p24178
spillover-evidence-in-forward-patent-ci ... 306#p39272

Forward and backward citations queries are basically the same.
If company A cites a patent from company B (backward) , then B is cited by A. (Forward)

If you want to know "who is citing who", then you have to aggregate the citation information (which is patent publication based) to the tls206_person table; as is done in the spillover-evidence forum post.
You also have to keep in mind that an application can have multiple applicants.
A patent filed by company A and B being cited by a patent filed by C and D results in a citation relation from A-C, A-D, B-C and B-D . (you can of course mitigate this by adapting your model).
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply