Hello Paulo, I assume you are using PATSTAT Online, which does not allow to make functions, procedures or dynamic SQL. Basically, what you are doing is de-normalising the (relational) data. Have a look at the query below; you can expand it to cover as many applicants or inventors you need (currently...

Hello Alexis, it is in principle impossible to reproduce the filing figures published by the EPO, using PATSTAT. The data is based on applications (including applications that have been withdrawn - witdrawels before publication are NOT in PATSTAT, and nowhere else for that matter, except in EPO stat...

A bit reworked, have a look and check. The list does not include cited NPL ! select distinct t1.appln_id,t1.appln_auth+t1.appln_nr+t1.appln_kind application, t1.appln_filing_date filing_date, t5.publn_auth+t5.publn_nr+t5.publn_kind citing_publication, t5.publn_date citing_publication_date, t10.publn...

Hello weiecon, CPC codes are in principle only available for those applications where a CPC code was assigned by any of the participating offices, or where there was a simply patent family member that already has a CPC code. Have a look at this coverage information: https://public.tableau.com/app/pr...

Hello khanhhienbi, there is a small error in your query, the last for 3 lines in your SELECT clause have a correct "heading/alias" for the columns (2020,2021,2022), but they all show the values for 2019. So the real values are not shown. Below is a correction. SELECT psn_name, person_ctry_...

This online seminar introduces PATSTAT Online and its beginners' interface, as well as demonstrating more advanced statistical analyses using the structured query language (SQL).The PATSTAT product line provides a unique basis for the advanced statistical analyses of patent data. Join us for this ex...

Hello Elisa, I changed a couple of small things in your query. And I removed (by making SQL lines as comments) a couple of the conditions which are not wrong, but not necessary neither. All information on opposition procedures in PATSTAT Register are linked to granted EP patent applications. So they...

Hello Zecon, patents that have been filed ARIPO have the WIPO ST.3 code AP. Using a condition such as appln_auth = 'AP' will retrieve patents filed at ARIPO. There aren't that many, see in espacenet: https://worldwide.espacenet.com/patent/search?q=ap%20%3D%20%22AP%22 EP patents can not designate ARI...

Hello Galskari, I think your question is rather for the USPTO to answer. All citation information the EPO receives comes from the USPTO, so they are authoritative on how and when APP citations (or IDS data) are becoming available to the public. On a personal note: I observed that patents listed in t...

The short version: those are events reported by the Brazilian patent office for the PCT when the PCT application enters the national phase. Long version: PCT applications (Wipo), can be filed at a number of PCT receiving offices (EP, CN, US, IB, ....). Once the PCT is published, the applicant can th...