Search found 440 matches
- Tue Mar 07, 2023 7:13 pm
- Forum: PATSTAT Product Line
- Topic: ADDING THE COUNT OF PATENTS
- Replies: 5
- Views: 1731
Re: ADDING THE COUNT OF PATENTS
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...
- Tue Mar 07, 2023 6:19 pm
- Forum: PATSTAT Product Line
- Topic: Aggregating patent data at regional level
- Replies: 1
- Views: 949
Re: Aggregating patent data at regional level
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...
- Wed Mar 01, 2023 3:58 pm
- Forum: PATSTAT Product Line
- Topic: ADDING THE COUNT OF PATENTS
- Replies: 5
- Views: 1731
Re: ADDING THE COUNT OF PATENTS
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...
- Wed Mar 01, 2023 12:59 pm
- Forum: PATSTAT Product Line
- Topic: Forward citations by country
- Replies: 1
- Views: 985
Re: Forward citations by country
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...
- Tue Feb 28, 2023 12:09 pm
- Forum: PATSTAT Product Line
- Topic: Count number of patent applications and citations per company
- Replies: 13
- Views: 9694
Re: Count number of patent applications and citations per company
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...
- Tue Feb 28, 2023 10:43 am
- Forum: PATSTAT Product Line
- Topic: Transfer of ownership
- Replies: 1
- Views: 2429
Re: Transfer of ownership
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...
- Mon Feb 27, 2023 1:47 pm
- Forum: PATSTAT Product Line
- Topic: Understanding and dealing with patent families
- Replies: 3
- Views: 2433
Re: Understanding and dealing with patent families
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...
- Mon Feb 27, 2023 11:56 am
- Forum: PATSTAT Product Line
- Topic: ADDING THE COUNT OF PATENTS
- Replies: 5
- Views: 1731
Re: ADDING THE COUNT OF PATENTS
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...
- Fri Feb 24, 2023 6:09 pm
- Forum: PATSTAT Product Line
- Topic: Inconsistent data
- Replies: 2
- Views: 4747
Re: Inconsistent data
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...
- Thu Feb 23, 2023 5:00 pm
- Forum: PATSTAT Product Line
- Topic: Where will you find information and data on the Unitary Patent ?
- Replies: 0
- Views: 8679
Where will you find information and data on the Unitary Patent ?
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....