The query only looks at the forward citations for 1 single patent application.
Namely application US201314419139 filed on 2013-08-02. But this application belongs to a family containing 11 applications (today on 12-05-2022 !)
Code: Select all
SELECT * FROM tls201_appln
where docdb_family_id= 76606920 -- docdb_family_id for the US201314419139
And when you look at the results you will see 11 different patent applications.
Each of those applications can have different citations, but the total will be a selection of applications coming from 18 patent families.
The query below gives you a list of 34 citing publications that originate from those18 patent families.(Count the number of different docdb_family_id's in the second column.)
Code: Select all
SELECT distinct citing_app.appln_auth + citing_app.appln_nr as citing_application, citing_app.docdb_family_id,
citing.publn_auth+citing.publn_nr+citing.publn_kind as citing_publication, tls212_citation.pat_publn_id,
tls212_citation.citn_id,tls212_citation.citn_origin,tls212_citation.cited_pat_publn_id,tls212_citation.cited_appln_id,
tls212_citation.cited_npl_publn_id,citing.publn_date, cited.publn_auth+cited.publn_nr as cited_publication,
cited.publn_date, cited_app.docdb_family_id
FROM
tls201_appln citing_app join tls211_pat_publn citing on citing_app.appln_id = citing.appln_id
join tls212_citation on citing.pat_publn_id = tls212_citation.pat_publn_id
left join tls211_pat_publn cited on tls212_citation.cited_pat_publn_id = cited.pat_publn_id
join tls201_appln cited_app on cited.appln_id = cited_app.appln_id
where cited_app.docdb_family_id= 76606920
As a researcher, it is of course good that one understands what is behind this data, but the table tls228_docdb_fam_citn will give you all the "citations pairs at family level" without any further due. But if you really want to use the application authority of the citing and cited applications, then you will need to use the larger, detailed query above that establishes the link between the cited and citing applications via the tls212_citations table. (and not tls228_docdb_fam_citn that only has citing and cited patent families).