Hello Mark, PATSTAT Global is a data base containing bibliographical data from many (+/- 100) different patent offices, going as far back in time as possible. Basically; any bibliographical data provided to the EPO is available in PATSTAT Global. The EPO data is complete, as is the case for some of ...

Hello Luca, your request is not so easy to answer because it means looking at a data sample from different angles: applicants, harmonised names, family picture (authorities where family members were filed), filing date, ipc_codes. Trying to aggregate this all into some kind of 1 single table is rath...

Hello Tim, it is a bit more complicated. In fact, it is always rather complicated to replicate statistics published by patent offices because the approach (or interpretation of the description) and the used data might be different. Without reading the whole DPMA report I would ask the following ques...

Hello Tim, for the granted EP applications, it is fairly straightforward. Take the filing date and the date of grant (publication of the B1 document). For the EP "pending & non granted" applications it is more difficult. One can of course say that if no B1 is published, the patent is "pending" or th...

Hello,
I refer to this previous forum post for more information:
validation-state-8851
We anticipate that correct validation information will be available in the 2020b release. (end of the this year)

Hello, Thank you for the information. I have used the paper titled "An Introduction to the Patstat Database with Example Queries", retrieved from https://onlinelibrary.wiley.com/doi/full/10.1111/1467-8462.12073 No, the weighing in this code is not a sollution for missing person country codes. Rathe...

Hello, This is in continuation to my earlier query. There are a lot of patent applications where the inventor country is not found. I saw the following code in the PATSTAT manual. Will the problem of not finding inventor country be solved using fractional count? SELECT d.person_ctry_code, SUM(tot_i...

Hello, Thank you for your prompt response and help. If I use - WHERE left (b.cpc_class_symbol, 10) = 'Y02E 10/7' AND c.invt_seq_nr > 0 , will it allow me to select all the patent applications tagged with Y02E10/70-766 under the Y02E tag for wind energy? Also, can you please explain the function of ...

Hello Aroh, there is a small SQL syntax error in your query. A wildcard % comes allways in combination with LIKE. And the number of digits before the / is exaclty eight. So: b.cpc_class_symbol like 'Y02E 10/7%' will work. There are 2 spaces beteen the E and the 10. Instead of a wildcard, you could a...

Hello Lucas, your question is not really PATSTAT related and outside the scope of this forum. This publication gives you a good general introduction on patents. European_patents_and_the_grant_procedure_2016_en_6.7.pdf In an nutshell -and very much generalised-: Companies apply for patents in those c...