Looking for University Patents in Germany

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

benny2009
Posts: 1
Joined: Mon Nov 30, 2015 1:22 pm

Looking for University Patents in Germany

Post by benny2009 » Mon Nov 30, 2015 1:31 pm

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


Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: Looking for University Patents in Germany

Post by Geert Boedt » Thu Jan 14, 2016 3:50 pm

Hello Benjamin,
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
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:

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
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
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: Looking for University Patents in Germany

Post by nico.rasters » Sat Jan 16, 2016 12:44 pm

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/


Post Reply