It is possible to add to the list some information, like the country & the sector of the applicant. One can also via separate queries create other lists with a common data attribute so that tables can be joined. Also the SQL CASE statement allows some creativity on expanding tables. But the outp...

Hello misslord, there are a couple of issues that lead to your results. From a syntax point of view, your query is correct (no errors when you run it), but it does not give you the expected results. One has to keep in mind that when you join tables in SQL, the database simply makes a bigger and bigg...

Hello misslord, The published query works fine in PATSTAT Online and gives a list with applicant names and number of applications for those applicants listed. When making a "hitlist/ranking" with a ranking based on a number of patent applications per applicant, then it is not possible to h...

Hello UCBQ, Your approach needs some thinking over. Using triadic patents is a good approach to select patents for which the applicant considers there is a need for a wider protection. Further restricting it to families where the triadic family members have to be granted patents reduces the set cons...

Hello Xiaohan, from a syntax point of view, your sql is correct, but it generates 2.8 million rows. Basically 1 row for each patent. If you want to aggregate the number of forward citations per application filing year, then you have to remove the application data from the SELECT clause. You could th...

Hello Mengfanliu, There is no comprehensive good way to identify all transfers of ownership after a patent is granted. And there is even less information on "purchases" of patent(s). Reported events in INPADOC should normally have a code that has been flagged as an event category = 'R'. (S...

The HAN names are build on top of a PATSTAT release. This means that in the PATSTAT data, harmonisation always run a version behind and therefore some names might not be harmonised. (Or some names were not picked-up by the methodology.) With any harmonisation process or data, you might always expect...

Hello Misslord, Your query is only making a list of the patent publications, not a counting of number of patents. Here is a straightforward and simple adaptation of your query: SELECT pers.psn_name, count(distinct(p.appln_id)) patents FROM tls211_pat_publn p JOIN tls209_appln_ipc i ON p.appln_id = i...

Hello Eduardo, intermediate updates on the same data base are normally never done, and did not happen this time. PATSTAT online has 2 editions available: Spring 2022 and Autumn 2022. If you run : select * from tls201_appln where appln_id = 3878826 on Spring 2022 you will get docdb family id = 383703...

The EPO has launched a web page called "Unitary Patent information in patent knowledge". This page provides an overview on what information with regards the Unitary Patent will become available via the different EPO patent information data sets, tools and services. Take a look: http://epo....