In the PATSTAT, There is no search for citing patents. I want to search for citing patents of patent A. I tried to search for pat_publn_id by using the pat_publn_id of patent A as cited_pat_publn_id in tls212, but failed. Do you have a good way?
yours sincerely
LOU
how to find citing patent about a certain patent?
Re: how to find citing patent about a certain patent?
I have solved this problem. And If you need it, you can refer to it.
SELECT c.citn_origin, c.pat_citn_seq_nr , p2.publn_auth, p2.publn_nr, p2.publn_kind
FROM tls211_pat_publn p1
LEFT JOIN tls212_citation c ON p1.pat_publn_id = c.cited_pat_publn_id
JOIN tls211_pat_publn p2 ON c.pat_publn_id = p2.pat_publn_id -- citations
WHERE c.pat_citn_seq_nr > 0 -- retrieve only citations to publications
AND p1.publn_auth = 'US' -- for example
AND p1.publn_nr = '10049225'
AND p1.publn_kind = 'B2'
ORDER BY citn_origin
SELECT c.citn_origin, c.pat_citn_seq_nr , p2.publn_auth, p2.publn_nr, p2.publn_kind
FROM tls211_pat_publn p1
LEFT JOIN tls212_citation c ON p1.pat_publn_id = c.cited_pat_publn_id
JOIN tls211_pat_publn p2 ON c.pat_publn_id = p2.pat_publn_id -- citations
WHERE c.pat_citn_seq_nr > 0 -- retrieve only citations to publications
AND p1.publn_auth = 'US' -- for example
AND p1.publn_nr = '10049225'
AND p1.publn_kind = 'B2'
ORDER BY citn_origin