Thank you for your help! Yes, I am looking at how many patent families are cited per year by authority. I still have a question about the aggregated field. If I use your example query I get 12 families, but if I look at the column nb_citing_docdb_fam of this application it's 18 families. Where does ...

Hi together, I've tried to adapt the query from https://forums.epo.org/forward-and-backward-citation-7892 My goal was to get the number of forward citations (family level) per year + authority. Is this the right approach to do this? select a.earliest_publn_year, a.appln_auth, count(distinct a_cite.d...

Hi, I want to count all patent families from German inventors, specific CPC classes and years grouped in months. select DATEPART(month, earliest_publn_date) as month, year(earliest_publn_date) as year, count(distinct a.appln_id) as NumberOfPatentFamilies from tls201_appln a where a.appln_id in ( sel...