Hello Eduardo, they do have family members in your list of countries, but you don't see them in your result list because your criteria of "AND a.appln_filing_year BETWEEN 2000 AND 2015" will exclude the family members from the list that have filing dates outside that range. This is very of...

Hello Athimet, from a syntax point of view, your query is correct. From a logical & data aggregation point of view, there is room for improvement. There are duplicate records because of the combination of tables you have joined in the FROM clause in your query. You should in principle not join a...

Hello Khanhhienbi, The criteria of using one or the other IPC or CPC classification codes to define a certain technology sector or fields lies with the researcher. It is rather difficult to draw strict lines between the various fields simply based on the classification codes, and there are "gre...

Hello Simone, NUTS codes are constructed according to a hierarchical system based on the number of digits. For Italy you can retrieve all the NUTS codes via the query below: SELECT nuts ,nuts_level ,nuts_label FROM tls904_nuts where nuts like 'IT%' order by nuts NUTS_Italy.xlsx If you look at the (s...

Hello MrQuicky,
I can not help you with R,
but at this link you will find sample scripts for loading PATSTAT on a MySQL platform.

patstat-2019b-mysql-upload-scripts-8627 ... 590#p24590

Hello, your queries are correct. I assume that the reason for missing IPC codes is that those patents simply have not been classified, so nothing wrong with the data as such. The WIPO guide gives some information on the IPC history and when it entered into force. wipo_guide_ipc_2020.pdf I don't know...

Hello khanhhienbi, first a couple of observations: Patents that have been filed between '2016-01-01' and '2020-01-01' will mostly not be granted yet. It easily takes 3 to 4 years for a patent to become granted. So I have widened the scope, but you can easily adapt it to your needs. If you want to &q...

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