I would like to replicate the results reported in the Patent Index 2020 - European patent applications file (https://www.epo.org/about-us/annual-rep ... stics.html) for the indicator 'Total applications - split by main countries' in relation to the total of patents applied between 2015 and 2021. My Query shows results that are representatively higher than the values disclosed by the EPO, possibly due to duplicate values or inadequate code.
Did a colleague try to do this data collection?
Thanks,
Fernando
Patent Index 2020 - European patent applications - Replication
-
- Posts: 2
- Joined: Sat Aug 07, 2021 7:54 pm
-
- Posts: 144
- Joined: Mon Dec 22, 2014 8:30 am
Re: Patent Index 2020 - European patent applications - Replication
Dear Fernando,
which EPO product(s) are you using? GPI? PATSTAT? ..
It would help us if you could share your query with us.
Thank you and best regards,
epal team
which EPO product(s) are you using? GPI? PATSTAT? ..
It would help us if you could share your query with us.
Thank you and best regards,
epal team
-
- Posts: 2
- Joined: Sat Aug 07, 2021 7:54 pm
Re: Patent Index 2020 - European patent applications - Replication
Dear EPO team,
I am using specifically PATSTAT EP register database.
I propose to get a list of all the data in the patent application. Are expected that the sum of individual lines matches the sum value by country corresponding to the total value posted on the spreadsheet by the EPO. So I will do the same for the sectors.
Thank you and best regards,
Fernando
I am using specifically PATSTAT EP register database.
I propose to get a list of all the data in the patent application. Are expected that the sum of individual lines matches the sum value by country corresponding to the total value posted on the spreadsheet by the EPO. So I will do the same for the sectors.
Thank you and best regards,
Fernando
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Patent Index 2020 - European patent applications - Replication
Dear Fernando,
using SQL in PATSTAT Register, there is indeed a risk for double counting when multiple tables are joined in a query. Each joined table might multiplicate the number of rows if no further restrictions are applied in the WHERE clause.
Generally spoken on using PATSTAT for "replicating" figures published by the EPO,have a look at this PATSTAT forum topic:
count-number-of-patent-applications-8372#p24162
So normally, the application figures published in the official EPO statistics will be about 10% higher then what you can find via PATSTAT Global or PATSTAT Register. Without seeing your query, it is not possible to provide more thoughts on the possible reason for the differences.
using SQL in PATSTAT Register, there is indeed a risk for double counting when multiple tables are joined in a query. Each joined table might multiplicate the number of rows if no further restrictions are applied in the WHERE clause.
Generally spoken on using PATSTAT for "replicating" figures published by the EPO,have a look at this PATSTAT forum topic:
count-number-of-patent-applications-8372#p24162
So normally, the application figures published in the official EPO statistics will be about 10% higher then what you can find via PATSTAT Global or PATSTAT Register. Without seeing your query, it is not possible to provide more thoughts on the possible reason for the differences.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org