Search found 216 matches

by EPO / PATSTAT Support
Mon Mar 30, 2020 10:28 pm
Forum: PATSTAT Product Line
Topic: Query Help for UK Patent Data
Replies: 4
Views: 4047

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...
by EPO / PATSTAT Support
Wed Mar 25, 2020 7:40 pm
Forum: PATSTAT Product Line
Topic: Elapsed time until patent decision
Replies: 4
Views: 854

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...
by EPO / PATSTAT Support
Mon Mar 23, 2020 12:56 pm
Forum: PATSTAT Product Line
Topic: Elapsed time until patent decision
Replies: 4
Views: 854

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...
by EPO / PATSTAT Support
Fri Mar 20, 2020 10:52 am
Forum: PATSTAT Product Line
Topic: EPO patents' validation in Morocco Tunisia Moldova and Cambodia
Replies: 1
Views: 984

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)
by EPO / PATSTAT Support
Fri Feb 28, 2020 4:35 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online Y02E SQL query
Replies: 7
Views: 761

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...
by EPO / PATSTAT Support
Fri Feb 28, 2020 12:13 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online Y02E SQL query
Replies: 7
Views: 761

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...
by EPO / PATSTAT Support
Fri Feb 28, 2020 10:05 am
Forum: PATSTAT Product Line
Topic: PATSTAT Online Y02E SQL query
Replies: 7
Views: 761

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 ...
by EPO / PATSTAT Support
Thu Feb 27, 2020 2:42 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online Y02E SQL query
Replies: 7
Views: 761

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...
by EPO / PATSTAT Support
Thu Feb 27, 2020 9:46 am
Forum: PATSTAT Product Line
Topic: Accessing Data from PATSTAT Online
Replies: 9
Views: 813

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...
by EPO / PATSTAT Support
Wed Feb 26, 2020 5:45 pm
Forum: PATSTAT Product Line
Topic: Accessing Data from PATSTAT Online
Replies: 9
Views: 813

Re: Accessing Data from PATSTAT Online

Hello Lucas, all existing application id's are available in TLS201_appln. Your query does not yield any results because SE20170050339 and CA20173027619 are not having any citations. In fact, for Sweden and Canada, the EPO does not have (receive) citation information. REFI Statistics July_2019.pdf So...