Dear community,
I am retrieving the number of utility models filled in France between 1992 and 2016 with the following query:
SELECT COUNT(appln_id), appln_filing_year
FROM tls201_appln a
WHERE
appln_kind = 'U' -- only utility models
AND appln_auth = 'FR' -- only in France
AND appln_id < 900000000 -- exclude artificial applications
AND appln_filing_year>1991
AND appln_filing_year<2017
GROUP BY appln_filing_year
ORDER BY appln_filing_year
However, it does not return any data because France seems not to identify utility models (called "certificate of utility" in France) with the kind-code "U". My guess is that they are categorizing utility models as patents.
My question is: Could somebody shed some light on how to query utility models in France?
Thank you so much in advance and best regards,
Carmen
Querying utility models in France
Re: Querying utility models in France
Dear Carmen,
Your approach comes close. Unfortunately it does not work for France, because for FR there is no distinction in the type of application APPLN_KIND between patents and utility models. However, utility models can be identified by the kind of publications that are published. In the “Kind code concordance list” (http://www.epo.org/searching-for-patent ... gular.html ) you will find the short description of all publication kinds.
All this has already been taken into account in the attribute IPR_TYPE (type of the intellectual property right). As usual, see the Data Catalog for details.
So IPR_TYPE = ‘UM’ should give you the desired result.
Best regards,
Martin / EPO
Your approach comes close. Unfortunately it does not work for France, because for FR there is no distinction in the type of application APPLN_KIND between patents and utility models. However, utility models can be identified by the kind of publications that are published. In the “Kind code concordance list” (http://www.epo.org/searching-for-patent ... gular.html ) you will find the short description of all publication kinds.
All this has already been taken into account in the attribute IPR_TYPE (type of the intellectual property right). As usual, see the Data Catalog for details.
So IPR_TYPE = ‘UM’ should give you the desired result.
Best regards,
Martin / EPO
-------------------------------------------
Martin Kracker / EPO
Martin Kracker / EPO
-
- Posts: 8
- Joined: Mon May 22, 2017 5:36 pm
Re: Querying utility models in France
Thank you very much for your answer! Problem solved!