Search found 227 matches

by EPO / PATSTAT Support
Mon Sep 14, 2020 10:49 am
Forum: PATSTAT Product Line
Topic: differentiate between assignee and inventor
Replies: 1
Views: 64

Re: differentiate between assignee and inventor

Hello, the short answer is YES; by setting correct applt_seq_nr and invt_seq_nr conditions. The term "assignee" is mainly used when talking about patent applications filed at the US patent office. At the EPO we rather use "applicant" in conjunction with patent application and "patent owner" or "prop...
by EPO / PATSTAT Support
Thu Sep 10, 2020 2:34 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online download and extraction limitations.
Replies: 0
Views: 150

PATSTAT Online download and extraction limitations.

Many users ask us about the "limitations" in PATSTAT Online. Although documented in the user manual , here is an overview: PatstatOnline_UserManual_v2.20.pdf The maximum length of an SQL query is 10 000 characters. PATSTAT subset download: Your result set must not contain more than 100 000 applicati...
by EPO / PATSTAT Support
Thu Sep 03, 2020 1:45 pm
Forum: PATSTAT Product Line
Topic: Help with SQL query - How to retrieve name of the patent's applicant(s)
Replies: 1
Views: 192

Re: Help with SQL query - How to retrieve name of the patent's applicant(s)

Hello Khanhhienbi, a couple of remarks on your query: the syntax is correct, but to include the applicant names, you need to link the applications in tls201_appln to the tls206_person table via tls207. If you only joined the tls209_appln_ipc table in order to limit your data set, then there is no ne...
by EPO / PATSTAT Support
Thu Sep 03, 2020 11:46 am
Forum: PATSTAT Product Line
Topic: Summer School on Data and Algorithms for Science, Technology & Innovation studies: 16-18 September 2020
Replies: 0
Views: 140

Summer School on Data and Algorithms for Science, Technology & Innovation studies: 16-18 September 2020

To all PATSTAT users, The fifth edition of the “Summer School on Data and Algorithms for Science, Technology & Innovation studies” will as planned take place between 16-18 September at KU Leuven (Belgium). Some of you participated last year, when the event (as well as the PATSTAT user day) took plac...
by EPO / PATSTAT Support
Tue Sep 01, 2020 10:50 am
Forum: PATSTAT Product Line
Topic: Search codes for transnational cooperation patents
Replies: 5
Views: 1158

Re: Search codes for transnational cooperation patents

Hello Faery, in depth citation network analysis, using citation networks requires advanced and sometimes complex data aggregation models. Researchers go through quite some different considerations as to what and how to do "the counts" in function of the research question. For example: limiting to ci...
by EPO / PATSTAT Support
Mon Aug 31, 2020 8:39 am
Forum: PATSTAT Product Line
Topic: PATSTAT Globa--tls207_pers_appln
Replies: 1
Views: 116

Re: PATSTAT Global--tls207_pers_appln

Hello Yekai, you can easily check the number of records for tls201 and tls207 with the following query: select count (appln_id) from tls207_pers_appln; select count (appln_id) from tls201_appln; They give respective 265 and 105 million records. It is however correct that not all applications have ap...
by EPO / PATSTAT Support
Wed Aug 19, 2020 4:01 pm
Forum: PATSTAT Product Line
Topic: Should we set a time window when computing generality or originality index?
Replies: 1
Views: 83

Re: Should we set a time window when computing generality or originality index?

Hello Darwin, your reasoning is correct that the purpose of the time frame is to avoid bias by the publications that have been "longer around". I have seen studies (Harhoff) that use 5 years, we used 3 years in our getting started paper. Getting started with Patstat_20140401.pdf The bigger your time...
by EPO / PATSTAT Support
Mon Aug 17, 2020 4:01 pm
Forum: PATSTAT Product Line
Topic: difference between CITED_PAT_PUBLN_ID and CITED_APPLN_ID
Replies: 2
Views: 187

Re: difference between CITED_PAT_PUBLN_ID and CITED_APPLN_ID

Citations can refer to an application, but mostly (99.5%) they refer to publications . So the cited_appln_id is not an alternative key to get to cited patent publication in the same record. It is simply another citation. For info: most of the references to applications originate from the applicants ...
by EPO / PATSTAT Support
Fri Aug 14, 2020 1:33 pm
Forum: European Patent Register and Register Alert
Topic: Change in URL format?
Replies: 5
Views: 181

Re: Change in URL format?

Dear Cameron, in principle, this URL change should not have happened at all because it broke many links coming from various applications. And when URL's change, we establish URL re-directs to avoid broken links. The problem seems to have originated from a change in the re-direct links and not the ap...
by EPO / PATSTAT Support
Fri Aug 14, 2020 1:18 pm
Forum: European Patent Register and Register Alert
Topic: Change in URL format?
Replies: 5
Views: 181

Re: Change in URL format?

Dear Cameron, thank you for pointing out the broken link(s). Yes we had seen it, and our team is looking into fixing the issue. The link from ESPACENET to Register should be working by now. The right-click link in the Register is not working - because it also used the broken link. Other users or app...