Hi Seb,
The downward trend of German granted applications in your result in the last years is clearly visible, but I still think the data is fine. You must be aware that it takes years (in some cases more years than you would expect) for an application to get granted. So for a young application chances are good that it is not yet granted, but will be granted in the future - or not at all. All these not-yet-granted applications lead to this typical downward trend in the last years.
To see the "loose" correlation between filing year and grant year (= publication year of the granting publication), you may try this query:
Code: Select all
select year(appln_filing_date), year(publn_date), count(*)
from tls201_appln a
join tls211_pat_publn p on a.appln_id = p.appln_id
where a.appln_auth = 'DE'
and a.appln_kind in ('A')
and a.granted = 1
and p.publn_first_grant = 1 -- indicates the granting publication
and year(publn_date) between 1995 and 2015 -- some sensible restriction
group by year(appln_filing_date), year(publn_date)
order by year(appln_filing_date), year(publn_date)
When you load the result into Excel and create a pivot table, you get this matrix, showing how many applications of a certain year have been granted in a certain year. For the sake of readability, I removed outliners. The numbers in the yellow line are exactly the numbers of your table.

- pivotTable3.PNG (202.26 KiB) Viewed 989 times
In Germany this delay effect is intensified, because examination does not take place automatically. The applicant must specifically request an examination, and he can wait up to 7 years to do so. Some other offices, e. g. Japan, have a similar policy for deferred examination.
There could be additional effects, like changes in the German procedures, but I am not aware of these.
It would be good to verify the numbers with original German data. I tried this with DEPATISnet, but did not succeed - which is likely my fault.
Probably somebody with better insight into German grant numbers could add to this post?