Search found 18 matches

by Tim Grünebaum
Mon Nov 14, 2016 3:28 pm
Forum: PATSTAT Product Line
Topic: NACE Rev. 2 Classification of an Applicant
Replies: 4
Views: 2049

NACE Rev. 2 Classification of an Applicant

Hi all, I was wondering if one can retrieve an applicant's (=company) NACE industry code from Patstat. Of course we have table TLS229_APPLN_NACE2, but there we can "only" find the corresponding NACE classification of a specific patent and this not necessarily equals the company's industry code. So m...
by Tim Grünebaum
Wed Aug 31, 2016 3:02 pm
Forum: PATSTAT Product Line
Topic: How to retrieve applicant's address
Replies: 5
Views: 2227

Re: How to retrieve applicant's address

Hello Geert, thank you for your extensive answer. The problem is somehow different: When we look at the raw data (say at table TLS206_PERSON) we see that every applicant, no matter which sector and country code (also DE) provides an address, at least ZIP-Code and City. They are simply not displayed ...
by Tim Grünebaum
Wed Aug 31, 2016 10:49 am
Forum: PATSTAT Product Line
Topic: How to retrieve applicant's address
Replies: 5
Views: 2227

Re: How to retrieve applicant's address

Unfortunately the problem also occurs in the DVD version, I checked it.
I don't know why, but only the address column stays empty for every applicant, no matter if company or individual.
Maybe the name harmonization (hrm_l2) makes it impossible to identify one specific address.
by Tim Grünebaum
Tue Feb 16, 2016 12:32 pm
Forum: PATSTAT Product Line
Topic: Count Company's number of patent applications
Replies: 12
Views: 5227

Re: Count Company's number of patent applications

Hello Geert and Nico, thanks for those useful replies! I think it all comes down to the fact mentioned by Geert. It is nearly impossible to replicate the patent counts of a national patent office without knowing the exact procedure, code and database they used. However, this might not be as bad as I...
by Tim Grünebaum
Fri Feb 12, 2016 4:30 pm
Forum: PATSTAT Product Line
Topic: Count Company's number of patent applications
Replies: 12
Views: 5227

Re: Count Company's number of patent applications

Hi Nico, wow, what a quick response :) Here we go: PATSTAT DPMA hrm_l2 APPL_FILING_YEAR 2612 2202 ROBERT BOSCH 2006 2827 2509 ROBERT BOSCH 2007 3282 2645 ROBERT BOSCH 2008 3438 3213 ROBERT BOSCH 2009 3444 3477 ROBERT BOSCH 2010 3474 3602 ROBERT BOSCH 2011 4048 3972 ROBERT BOSCH 2012 4051 4144 ROBERT...
by Tim Grünebaum
Fri Feb 12, 2016 3:45 pm
Forum: PATSTAT Product Line
Topic: Count Company's number of patent applications
Replies: 12
Views: 5227

Re: Count Company's number of patent applications

Hello Nico, I have been thinking about your suggestions and the topic as a whole. However, the problem is not solved entirely. The DPMA said they are actually using DOCDB as their primary data source. This is interesting because there should not be any substantial differences between their data and ...
by Tim Grünebaum
Thu Oct 01, 2015 5:08 pm
Forum: PATSTAT Product Line
Topic: Count Company's number of patent applications
Replies: 12
Views: 5227

Re: Count Company's number of patent applications

Thank you very much, Nico! That was quite helpful and I also tried to build up my own code in combination with your suggestions. Now I am using this one: SELECT COUNT(*), TLS206_PERSON.hrm_l2, TLS201_APPLN.APPLN_FILING_YEAR, TLS206_PERSON.SECTOR FROM TLS201_APPLN LEFT JOIN TLS207_PERS_APPLN ON TLS20...
by Tim Grünebaum
Thu Aug 27, 2015 1:08 pm
Forum: PATSTAT Product Line
Topic: Count Company's number of patent applications
Replies: 12
Views: 5227

Re: Count Company's number of patent applications

Hi all, @ Nico: how exactly would we handle a "Count all applications by Firm X in Year Y" problem? I did not find an explicit guidline of such an undertaking, neither in the forum nor in manuals. I was wondering if anyone has done this before and if there is such thing as an "easy way" other than w...