Forward and backward citation for a number of Patents
Posted: Thu Jan 28, 2016 1:07 pm
Hello,
i'm using the online version of Patstat (autumn 2015).
I want to count the number of forward and backward citations of a previous defined list of patents. Therefor I searched this forum for a solution, but didn't find something.
To get the number of foward citation, I think I could use this query:
SELECT DISTINCT tls201_appln.appln_id, nb_citing_docdb_fam
From tls201_appln
WHERE tls201_appln.appln_id in (LIST OF PATENTS)
The only problem is, that i want to constrain the period of forward citation on max 5 years.
I didn't know a solution for the backward citations. This is a first attempt of mine:
SELECT Distinct tls201_appln.appln_id, count (distinct tls212_citation.cited_pat_publn_id)
From tls201_appln
JOIN tls211_pat_publn on tls201_appln.appln_id = tls211_pat_publn.appln_id
JOIN tls212_citation on tls211_pat_publn.pat_publn_id = tls212_citation.pat_publn_id
WHERE tls201_appln.appln_id in (LIST OF PATENTS)
Group by tls201_appln.appln_id
order by tls201_appln.appln_id
Can I use these querys to get the number of forward and backward citations?
i'm using the online version of Patstat (autumn 2015).
I want to count the number of forward and backward citations of a previous defined list of patents. Therefor I searched this forum for a solution, but didn't find something.
To get the number of foward citation, I think I could use this query:
SELECT DISTINCT tls201_appln.appln_id, nb_citing_docdb_fam
From tls201_appln
WHERE tls201_appln.appln_id in (LIST OF PATENTS)
The only problem is, that i want to constrain the period of forward citation on max 5 years.
I didn't know a solution for the backward citations. This is a first attempt of mine:
SELECT Distinct tls201_appln.appln_id, count (distinct tls212_citation.cited_pat_publn_id)
From tls201_appln
JOIN tls211_pat_publn on tls201_appln.appln_id = tls211_pat_publn.appln_id
JOIN tls212_citation on tls211_pat_publn.pat_publn_id = tls212_citation.pat_publn_id
WHERE tls201_appln.appln_id in (LIST OF PATENTS)
Group by tls201_appln.appln_id
order by tls201_appln.appln_id
Can I use these querys to get the number of forward and backward citations?