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?