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'
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'