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

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

Hello Eduardo, Case C should never occur. With other words, the query as below should always give 0 records. SELECT * FROM tls231_inpadoc_legal_event where appln_id not in (select appln_id from tls201_appln) Case A (joining tls201_appln with tls231_inpadoc_legal_event) gives you 2.449.901 records or...

Hello Simon, India is indeed a white spot on the map of patent data -at least for the EPO-, because the Indian patent office(s) does not provide EPO with the data. I assume that WIPO does receive the Indian data if they have direct filings in the WIPO IP Statistics Data Center data. (PCT application...

Hello Sina, we expect the 2023 release to become available by 12/05. A quick glance at the coverage document for the 2023a release shows 22-02-2023 as latest data for EP-A1 publications. So I assume that for most major patent offices that regular deliver data to the EPO, publications for 2022 should...