Hello Val, there is a small logical mistake in your query. The tls215_citn_categ should be joined via 2 attributes in order to link the correct citation category to the citations: t6.pat_publn_id = t12.pat_publn_id and t6.citn_id = t12.citn_id So observe that the join is NOT via t6.cited_pat_publn_i...

Dear Eduardo, That is a whole lot of questions in one go, so let me tackle them one by one. On question 1) In PATSTAT, we have pre-calculated the weighted technology shares for the each application based on the classification picture of each individual patent. Not on the position. This allows for mo...

Hello Tim, I would say that your question touches on 2 different but related issues. a) how is it possible that patent applications having a filing year < 2010 were not in PATSTAT2015 b) and the person_id's from those applications do not appear neither in the PATSTAT2015-but suddenly appear in a lat...

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