Search found 3 matches
- Mon May 09, 2022 9:53 am
- Forum: PATSTAT Product Line
- Topic: Count citations per application authority
- Replies: 3
- Views: 1125
Re: Count citations per application authority
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 ...
- Tue May 03, 2022 2:34 pm
- Forum: PATSTAT Product Line
- Topic: Count citations per application authority
- Replies: 3
- Views: 1125
Count citations per application authority
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...
- Wed May 15, 2019 2:24 pm
- Forum: PATSTAT Product Line
- Topic: Best way to count DOCDB_FAMILY_ID
- Replies: 1
- Views: 2949
Best way to count DOCDB_FAMILY_ID
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...