The patent families concepts.

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

EPO / PATSTAT Support
Posts: 259
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

The patent families concepts.

Post by EPO / PATSTAT Support » Thu Oct 07, 2021 3:35 pm

(Newbie) PATSTAT users often struggle to understand the concept of patent families.
Our colleagues at the patentdata team have produced this very explanatory video on patent families.
Both Simple and INPADOC (extended) patent families are pre-created in the PATSTAT data base and are available via the tls201_appln table. So there is no need for you to start scripting to create patent families when using PATSTAT. This video explains very well "how it is done".
https://e-courses.epo.org/mod/streaming ... hp?id=9604

Building on the same example as in the video: US5701965 (Human transporter).
All applications belong to exactly 1 DocDB and 1 INPADOC patent family. The application number for US5701965 is US25069394.

Retrieving all the DocDB patent families for this US application is done as below:

Code: Select all

SELECT US_patent.appln_auth+us_patent.appln_nr ,US_patent.appln_filing_date ,
docdb_family_patents.appln_auth + docdb_family_patents.appln_nr family_members, 
docdb_family_patents.appln_filing_date
FROM tls201_appln US_Patent
join tls201_appln docdb_family_patents
ON US_Patent.docdb_family_id  = docdb_family_patents.docdb_family_id
where US_patent.appln_auth = 'US' and US_patent.appln_nr = '25069394'
Retrieving all the INAPDOC patent families for this US application is done as below: (observe the rather big size of the INPADOC patent family !)

Code: Select all

SELECT US_patent.appln_auth+us_patent.appln_nr ,US_patent.appln_filing_date ,
INPADOC_family_patents.appln_auth + INPADOC_family_patents.appln_nr family_members, 
INPADOC_family_patents.appln_filing_date
FROM tls201_appln US_Patent
join tls201_appln INPADOC_family_patents
ON US_Patent.inpadoc_family_id  = INPADOC_family_patents.inpadoc_family_id
where US_patent.appln_auth = 'US' and US_patent.appln_nr = '25069394'
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply