I am using PATSTAT Online and I am interested in the number of citations received by Finnish patents (national office) 5 years after the grant date. I wrote a query for that and I have couple of questions
1) The following query seems to work but I would like to double check with you if it is correct.
Code: Select all
SELECT t1.appln_id, COUNT(distinct t4.pat_publn_id) AS fcitation
FROM tls201_appln t1
INNER JOIN
tls211_pat_publn t2
ON t1.appln_id = t2.appln_id
LEFT JOIN
(SELECT appln_id, publn_date
FROM tls211_pat_publn
WHERE publn_first_grant = 'Y' ) t3
ON t1.appln_id = t3.appln_id
INNER JOIN
tls212_citation t4 ON t2.pat_publn_id = t4.cited_pat_publn_id
INNER JOIN tls211_pat_publn t5
ON t5.pat_publn_id = t4.pat_publn_id
WHERE
t1.appln_auth = 'FI' AND
year(t3.publn_date) >= 1975
AND year(t3.publn_date)+5 >= year(t5.publn_date)
GROUP BY t1.appln_id
ORDER BY fcitation DESC
3) Is there any information on the reliability of the citations coverage per country? Which country would be more complete? Is the citations coverage for European Patents or PCT better?
Thank you.
Alexis