I am trying to retrieve global patent data by application authority (appln_auth, count per year) for India and several other Asian Patent Offices and for India I only receive data until the year 2015 and for Vietnam, Thailand, Indonesia I have even less entries. Could someone tell whether there is something wrong with my query or whether the data is simply not available? Or do I need to group by another date variable than appln_filing_year?
Code: Select all
SELECT DISTINCT appln_auth, appln_filing_year, count(*) total
FROM tls201_appln a JOIN tls209_appln_ipc t2 ON a.appln_id = t2.appln_id
WHERE appln_filing_year between 2000 and 2021
GROUP by appln_auth, appln_filing_year
ORDER by appln_auth, appln_filing_year, total asc