Search found 3 matches

by Rutgervtspijker
Tue Apr 28, 2020 4:58 pm
Forum: PATSTAT Product Line
Topic: Patent count yearly per company
Replies: 3
Views: 666

Re: Patent count yearly per company

Dear geert, Thank you for the reply. Yes I will illustrate an example for you e.g. spotify. Spotify receives an investment at time X then I would like to have the patent applications of spotify 5 years prior the investment and 5 years after. I will do this annually and for the patstat data just an t...
by Rutgervtspijker
Mon Apr 27, 2020 5:41 pm
Forum: PATSTAT Product Line
Topic: Multiple companies
Replies: 3
Views: 906

Re: Multiple companies

Hi, My question relates to the above question. I would need the same amount of data for around 3000 companies. However, by doing this manually it could be something like this, with one applicant at the time. SELECT psn_name , COUNT(distinct(case when year(appln_filing_date) = 2002 then tls201_appln....
by Rutgervtspijker
Mon Apr 27, 2020 12:15 pm
Forum: PATSTAT Product Line
Topic: Patent count yearly per company
Replies: 3
Views: 666

Patent count yearly per company

Hi all, I am currently writing a research paper on GVC and its influence on patenting (innovation) before and after investment. I found the following code on the forum: SELECT psn_name, COUNT(distinct(case when year(appln_filing_date) = 2002 then tls201_appln.appln_id end)) as "2002", COUNT(distinct...