Search found 3 matches
- Tue Apr 28, 2020 4:58 pm
- Forum: PATSTAT Product Line
- Topic: Patent count yearly per company
- Replies: 3
- Views: 1663
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...
- Mon Apr 27, 2020 5:41 pm
- Forum: PATSTAT Product Line
- Topic: Multiple companies
- Replies: 3
- Views: 5307
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....
- Mon Apr 27, 2020 12:15 pm
- Forum: PATSTAT Product Line
- Topic: Patent count yearly per company
- Replies: 3
- Views: 1663
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", COUN...