Querying utility models in France
Posted: Mon May 22, 2017 5:52 pm
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
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