Search found 216 matches

by EPO / PATSTAT Support
Wed May 20, 2020 2:00 pm
Forum: PATSTAT Product Line
Topic: % public vs private firms
Replies: 1
Views: 550

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: 482

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: 432

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: 771

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: 579

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: 840

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: 441

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 ...
by EPO / PATSTAT Support
Tue May 12, 2020 9:07 am
Forum: PATSTAT Product Line
Topic: Search codes for transnational cooperation patents
Replies: 3
Views: 680

Re: Search codes for transnational cooperation patents

Hello Faery, is your network applicant or inventor based (or both) ? Your query looks for Chinese inventors (or inventors/applicants) co-filing with non-Chinese applicants . I assume you want to build some kind of matrix, what is in the columns, rows and the intersections ? You also did not limit yo...
by EPO / PATSTAT Support
Thu May 07, 2020 4:28 pm
Forum: PATSTAT Product Line
Topic: appln_filing_date or earlist_appln_date
Replies: 3
Views: 500

Re: appln_filing_date or earlist_appln_date

Hello Darwin, I meant, you can use the fact that 1 application belonging to a family has been granted as a proxy for "success of the family". There is no such pre-aggregated attribute ready made in PATSTAT; this is something users can do themselves. Here is a short query that gives for a set of fami...
by EPO / PATSTAT Support
Thu May 07, 2020 12:39 pm
Forum: PATSTAT Product Line
Topic: appln_filing_date or earlist_appln_date
Replies: 3
Views: 500

Re: appln_filing_date or earlist_appln_date

Hello Darwin, most researchers will use the erliest priority date of a family as the "closest to when the invention happened". In PATSTAT we have the attribute "earliest_filing_date" (used in tandem with the earliest_filing_id) , which is however application and not family based. In principle, one c...