Search found 232 matches

by EPO / PATSTAT Support
Wed Jun 03, 2020 12:09 pm
Forum: PATSTAT Product Line
Topic: Forward citations and coverage
Replies: 2
Views: 824

Re: Forward citations and coverage

Hello Alexis, On 1) your query looks fine. When I do such counts, I would take just the first 2 applications, and manually check if the forward citations are effectively counted as you want them. On 2) coverage of the citation information is documented in the REFI publication which you can find at t...
by EPO / PATSTAT Support
Tue Jun 02, 2020 12:28 pm
Forum: PATSTAT Product Line
Topic: Problem: CPC-classes, applicants & DOCDB families
Replies: 9
Views: 1102

Re: Problem: CPC-classes, applicants & DOCDB families

Hello Lennart, there is a small typo in your query; CPC codes need to have 8 characters before the / . This means that one has to add "spaces" to make it 8 characters. See query below, I also used the STRING_AGG function and a GROUP BY to reduce the number of rows, and de_duplicate the CPC codes. Bu...
by EPO / PATSTAT Support
Mon May 25, 2020 9:12 am
Forum: PATSTAT Product Line
Topic: the first application of each DOCDB_FAMILY_ID
Replies: 1
Views: 578

Re: the first application of each DOCDB_FAMILY_ID

Hello Darwin, For the majority of the DocDB families, the "earliest_appln_id" will refer to one and the same application for all family members. In the complete PATSTAT database (2020a) there are 185.919 out of 76.458.745 (0.2%) DocDB families that have more then 1 "earliest_appln_id" in the family....
by EPO / PATSTAT Support
Wed May 20, 2020 2:00 pm
Forum: PATSTAT Product Line
Topic: % public vs private firms
Replies: 1
Views: 685

Re: % public vs private firms

Hello Thanos, PATSTAT does not contain information on whether a company is public or private. The PSN_SECTOR allows you the sort already companies from other applicants. You could probably make some kind of analysis on legal entity extensions in the applicant name that indicate whether that company ...
by EPO / PATSTAT Support
Tue May 19, 2020 12:48 pm
Forum: PATSTAT Product Line
Topic: [Help] Querying the number of patents with Chinese inventor as the first inventor
Replies: 1
Views: 626

Re: [Help] Querying the number of patents with Chinese inventor as the first inventor

Hello Edwardsj, the answer is straightforward, from 2010 onwards, we do not receive applicant country codes for applications filed in China. There is not much we can do about this, you might simply exclude applications filed in China from your data (at least the utility models), and maybe only take ...
by EPO / PATSTAT Support
Thu May 14, 2020 12:43 pm
Forum: PATSTAT Product Line
Topic: a country's innovation ability per year by using the number of successfully patent applications (at family level)
Replies: 1
Views: 578

Re: a country's innovation ability per year by using the number of successfully patent applications (at family level)

Hello Darwin, there are plenty of scientific and policy publications that touch on the topic of measuring innovation through patent analytics. One of the main sources is the OECD: https://www.oecd.org/site/innovationstrategy/measuringinnovationanewperspective-onlineversion.htm OECD has developed var...
by EPO / PATSTAT Support
Wed May 13, 2020 4:32 pm
Forum: PATSTAT Product Line
Topic: Help with SQL query - how to retrieve year & company!!
Replies: 1
Views: 1027

Re: Help with SQL query - how to retrieve year & company!!

Your query is correct. Here is a small adaptation that will explicitly look for applicants and exclude inventors. SELECT psn_name, person_ctry_code , applt_seq_nr , tls201_appln.* FROM tls201_appln JOIN tls207_pers_appln ON tls207_pers_appln.appln_id = tls201_appln.appln_id JOIN tls206_person ON tls...
by EPO / PATSTAT Support
Wed May 13, 2020 4:21 pm
Forum: PATSTAT Product Line
Topic: Patents with at least one inventor from Brussels
Replies: 1
Views: 817

Re: Patents with at least one inventor from Brussels

Hello , the easiest approach would be to use the NUTS codes available in the tls904_nuts table and linkable to the tls206_person table. The first step is to define "Brussels"; the wider "provincial level" the region or the capital. The query below gives you an overview of all Belgian NUTS codes. Onc...
by EPO / PATSTAT Support
Wed May 13, 2020 8:13 am
Forum: PATSTAT Product Line
Topic: PATSTAT Online 2020a is now available.
Replies: 4
Views: 1404

PATSTAT Online 2020a is now available.

The spread of the coronavirus has led to many restrictions and has it made nearly impossible for colleagues and friends to physically meet. Video conferencing, virtual team meetings, home-working and e-conferencing have become the norm and it is hard to believe that it ever will be business as usual...
by EPO / PATSTAT Support
Tue May 12, 2020 9:45 am
Forum: PATSTAT Product Line
Topic: primary assignee
Replies: 1
Views: 625

Re: primary assignee

Hello Darwin, PATSTAT does not have an indicator that can quantify the contribution of an assignee to an invention. As far as I am aware: On applicant/assignee/inventor: the term "assignee" is only used for applications filed at the USPTO. (Is there a legal definition of "primary assignee" ?) Other ...