Hi,
I am student from TU-Munich. I need to look for number of patents published by german universities and extramural research institutes (Helmholtz, Fraunhofer, Max-Planck and Leibnitz) for last 5 years.
I cannot find the right tags to get the results.
Could someone help me with that? Thanks a lot!
Benjamin
Looking for University Patents in Germany
-
- Posts: 176
- Joined: Tue Oct 19, 2004 10:36 am
- Location: Vienna
Re: Looking for University Patents in Germany
Hello Benjamin,
here is a sample query that will help you to get started.
You will observe that, even by using the harmonised name (hrm_l2), there are applicants that should be further grouped in order to get a more coherent list.
If you want to create a similar list for specific applicants, you could use something like the query here below:
Even though only 4 names are used, the % wildcards will add many more potential names you want to include (or exclude) from your final list. You will need to do some clean-up work to improve the quality.
Geert BOEDT
PATSTAT customer support
EPO Vienna
here is a sample query that will help you to get started.
Code: Select all
select psn_name , count(tls201_appln.appln_id)
from tls206_person join tls207_pers_appln on tls206_person.person_id = tls207_pers_appln.person_id
join tls201_appln on tls207_pers_appln.appln_id = tls201_appln.appln_id
where applt_seq_nr > 0 --select only applicants
and person_ctry_code = 'DE' -- select only German applicants
and appln_filing_year between 2009 and 2014 -- limiting the years, keep in mind the 18 month delay on publications
and (psn_sector = 'UNIVERSITY' or psn_sector = 'GOV NON-PROFIT UNIVERSITY' or psn_sector = 'COMPANY UNIVERSITY')
group by psn_name
order by psn_name
If you want to create a similar list for specific applicants, you could use something like the query here below:
Code: Select all
select psn_name , count(tls201_appln.appln_id)
from tls206_person join tls207_pers_appln on tls206_person.person_id = tls207_pers_appln.person_id
join tls201_appln on tls207_pers_appln.appln_id = tls201_appln.appln_id
where applt_seq_nr > 0 --select only applicants
and person_ctry_code = 'DE' -- select only Germann applicants
and appln_filing_year between 2009 and 2014 -- limiting the years, keep in mind the 18 month delay on publications
and psn_name like 'helmotz%'
or psn_name like 'Fraunhofer%'
or psn_name like 'Max%Planck%'
or psn_name like 'Leibnitz%'
group by psn_name
order by psn_name
Geert BOEDT
PATSTAT customer support
EPO Vienna
Best regards,
Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna
Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna
-
- Posts: 140
- Joined: Wed Jul 08, 2009 5:51 pm
- Contact:
Re: Looking for University Patents in Germany
Especially for academic inventions you may want to look at inventors as well, even though you specifically wrote "published by".
________________________________________
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/