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...

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....

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", COUN...