Hello Jens, Your best source for information on how the WIPO statistics are created is WIPO. It's rather difficult to replicate or reverse engineer a statistical method without knowing exactly how and what. If we would be looking at the EPO filings: "Direct applications" would be applicati...

Correct, it generally takes 18 months before filed applications are published. (Except for patents filed at the CN patent office.) Additionally, you selected granted patents; at the EPO it takes on average 3.5 years between the application and the grant; so that also gives a "drop" for the...

Pure SQL questions are a bit outside the scope of this forum, but here is one way to do it: SELECT concat (appln_filing_year, '-', DATEPART(QUARTER,[appln_filing_date])) as quarter, count(appln_id) FROM tls201_appln where appln_auth ='FI' and appln_filing_year between 2000 and 2010 group by concat (...

Normally somewhere in November, but there is no date set yet.
This can vary depending on the outcome of the test procedures, which is quite a lengthy and elaborate process.

PATSTAT can only provide you titles and abstracts. (no claims) There is no API service, but you can extract data (limited) via PATSTAT Online. Abstracts and titles will be in English, or in the original language when no English title is available. Here is an example query, but there are many differe...

Hello Humpherry, the short answer is: yes, it is wrong (not the SQL syntax as such) but because your query will double count all the family members depending on the number of family members. Have a look at the results from below query, you can see that there are 5 family members, they all have the s...

Hello Lionpat, Only using the application number will not work. The answer depends a bit on what you want to do and what you need it for. The appln_nr_epodoc attribute will be part of the data again in the next release. It might however still become obsolete in future releases. The obvious replaceme...

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