Application authority of utility models & address information
Posted: Mon Feb 12, 2018 3:55 pm
Hi,
I would like to retrieve information on German applicants of utility models. After trying different, queries I have reached the conclusion that utility model applications are submitted to the national authorities, rather than to the EPO. For example, the query below (with appln_auth = 'EP') does not return data. However, the following one (with appln_auth = 'DE') does. Is this right?
Moreover, I see that the applicants' address information is not available in the query above. Is it that the address of utility model applicants is not saved in PATSTAT?
Note: I am using the raw data of Spring 2017.
Thank you very much in advance and best regards,
Carmen
I would like to retrieve information on German applicants of utility models. After trying different, queries I have reached the conclusion that utility model applications are submitted to the national authorities, rather than to the EPO. For example, the query below (with appln_auth = 'EP') does not return data. However, the following one (with appln_auth = 'DE') does. Is this right?
Code: Select all
SELECT distinct(p.person_name), p.person_id, p.person_address
FROM tls201_appln a join tls209_appln_ipc aipc on a.appln_id = aipc.appln_id
join tls207_pers_appln pa on a.appln_id = pa.appln_id
join tls206_person p on p.person_id = pa.person_id
WHERE
pa.applt_seq_nr > 0 -- consider only applicants
AND a.ipr_type = 'UM' -- utility model
AND a.granted = 1
AND a.appln_filing_year between 2005 and 2015
AND p.person_ctry_code = 'DE'
AND a.appln_auth = 'EP'
ORDER BY p.person_name
Code: Select all
SELECT distinct(p.person_name), p.person_id, p.person_address
FROM tls201_appln a join tls209_appln_ipc aipc on a.appln_id = aipc.appln_id
join tls207_pers_appln pa on a.appln_id = pa.appln_id
join tls206_person p on p.person_id = pa.person_id
WHERE
pa.applt_seq_nr > 0 -- consider only applicants
AND a.ipr_type = 'UM' -- utility model
AND a.granted = 1
AND a.appln_filing_year between 2005 and 2015
AND p.person_ctry_code = 'DE'
AND a.appln_auth = 'DE'
ORDER BY p.person_name
Note: I am using the raw data of Spring 2017.
Thank you very much in advance and best regards,
Carmen