My concern is the following: I'm looking for patents that involve a certain CPC class. I would now like to obtain via PATSTAT all patents (at the level of the DOCDB families) on which this technology class is present. I would also like to receive all participating patent applicants and their country code. In addition, I would like to retrieve all CPC classes that can be found on the patent with the CPC class I am looking for. I have used the following code, but do not get the desired result:
Code: Select all
SELECT tls225_docdb_fam_cpc.docdb_family_id, tls201_appln.docdb_family_size, tls201_appln.appln_id, tls201_appln.appln_filing_year, tls201_appln.appln_auth, tls201_appln.nb_applicants, tls201_appln.nb_inventors, tls206_person.person_id, tls206_person.person_name, tls206_person.person_ctry_code, tls225_docdb_fam_cpc.cpc_class_symbol
FROM tls201_appln
JOIN tls207_pers_appln ON tls201_appln.appln_id=tls207_pers_appln.appln_id
JOIN tls206_person ON tls207_pers_appln.person_id= tls206_person.person_id
JOIN tls225_docdb_fam_cpc ON tls201_appln.docdb_family_id=tls225_docdb_fam_cpc.docdb_family_id
WHERE tls201_appln.appln_filing_year>=2010
AND tls225_docdb_fam_cpc.docdb_family_id in (select distinct docdb_family_id from tls225_docdb_fam_cpc where cpc_class_symbol = 'H04W 4/046')
AND (applt_seq_nr>0)
order by tls225_docdb_fam_cpc.docdb_family_id, tls201_appln.appln_id, cpc_class_symbol, person_name
All the best,
Lennart