Search found 231 matches
- Mon Apr 06, 2020 8:10 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT GLOBAL - REGISTER difference
- Replies: 3
- Views: 1610
Re: PATSTAT GLOBAL - REGISTER difference
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 ...
- Mon Mar 30, 2020 10:28 pm
- Forum: PATSTAT Product Line
- Topic: Query Help for UK Patent Data
- Replies: 4
- Views: 4336
Re: Query Help for UK Patent Data
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...
- Wed Mar 25, 2020 7:40 pm
- Forum: PATSTAT Product Line
- Topic: Elapsed time until patent decision
- Replies: 4
- Views: 1029
Re: Elapsed time until patent decision
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...
- Mon Mar 23, 2020 12:56 pm
- Forum: PATSTAT Product Line
- Topic: Elapsed time until patent decision
- Replies: 4
- Views: 1029
Re: Elapsed time until patent decision
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...
- Fri Mar 20, 2020 10:52 am
- Forum: PATSTAT Product Line
- Topic: EPO patents' validation in Morocco Tunisia Moldova and Cambodia
- Replies: 1
- Views: 1216
Re: EPO patents' validation in Morocco Tunisia Moldova and Cambodia
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)
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)
- Fri Feb 28, 2020 4:35 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT Online Y02E SQL query
- Replies: 7
- Views: 984
Re: PATSTAT Online Y02E SQL query
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...
- Fri Feb 28, 2020 12:13 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT Online Y02E SQL query
- Replies: 7
- Views: 984
Re: PATSTAT Online Y02E SQL query
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...
- Fri Feb 28, 2020 10:05 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT Online Y02E SQL query
- Replies: 7
- Views: 984
Re: PATSTAT Online Y02E SQL query
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 ...
- Thu Feb 27, 2020 2:42 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT Online Y02E SQL query
- Replies: 7
- Views: 984
Re: PATSTAT Online Y02E SQL query
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...
- Thu Feb 27, 2020 9:46 am
- Forum: PATSTAT Product Line
- Topic: Accessing Data from PATSTAT Online
- Replies: 9
- Views: 1279
Re: Accessing Data from PATSTAT Online
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...