Search found 227 matches

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

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

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

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

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

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: 5
Views: 1538

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

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

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...
by EPO / PATSTAT Support
Wed May 06, 2020 3:25 pm
Forum: PATSTAT Product Line
Topic: PATSTAT 2020a Spring edition ready for download.
Replies: 0
Views: 828

PATSTAT 2020a Spring edition ready for download.

Dear PATSTAT subscriber, The 2020 Spring edition has been tested, found sound, and is now ready for download. Do not hesitate to contact us via patstat @ epo.org in case you encounter any problems when uploading the new data files. Questions regarding shipping, subscription, pricing or invoicing can...
by EPO / PATSTAT Support
Mon May 04, 2020 10:58 am
Forum: PATSTAT Product Line
Topic: Non-patent-literature, encoding error?
Replies: 2
Views: 562

Re: Non-patent-literature, encoding error?

Hello Elisa, the data is correct; that NPL document has been cited in the Chinese search report, and no translation is currently available. (In fact, there are 2 CN NPLs cited.) With the query below you retrieve from PATSTAT all the citations from the CN application that cites that NPL. There are 3 ...