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

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

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

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 . Queries that take more then 1 hour or that have a heavy computational exec...

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

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

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

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

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

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