Search found 229 matches

by EPO / PATSTAT Support
Tue Sep 22, 2020 2:03 pm
Forum: PATSTAT Product Line
Topic: ERROR 1014
Replies: 3
Views: 33

Re: ERROR 1014

Hello Al, That query should (and does) run without error message and gives you a list of 1.590 million rows. I assume it must have been a temporary hick-up - if this gave an error-. But this query creates for sure too much records to download in a result list or to extract in a separate database. Th...
by EPO / PATSTAT Support
Tue Sep 22, 2020 8:07 am
Forum: PATSTAT Product Line
Topic: ERROR 1014
Replies: 3
Views: 33

Re: ERROR 1014

Dear Al, PATSTAT Online has indeed a cut-off when the computational cost of a query becomes too high. Although the platform is MS SQL based, some functions or features might not work 100% because the parser pre-treats it before sending it to the server. Can you post the query so we can have a look a...
by EPO / PATSTAT Support
Mon Sep 14, 2020 10:49 am
Forum: PATSTAT Product Line
Topic: differentiate between assignee and inventor
Replies: 1
Views: 92

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

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

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

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

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

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

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

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 ...