Many thanks.

Hello Julia, a count can be fairly easily done with a query similar to the one below. SELECT psn_name, count(distinct((case when appln_filing_year < 1995 then tls201_appln.appln_id end))) as "<1995", count(distinct((case when appln_filing_year = 1995 then tls201_appln.appln_id end))) as "1995", coun...

Hello Pardeep, from a computational point of view, using wildcards alongside words in title and abstract is a nightmare for the back end servers. When a query takes too much time to execute, then it is automatically aborted. That is what is happening here. Searching for '%rhamnolipid% takes longer t...

Many thanks

Dear PATSTAT user, we would like to inform you that we are currently uploading the new PATSTAT 2018 spring release. If everything goes as planned, you should receive next week an e-mail informing you on the effective date the PATSTAT raw data files will be available on the download platform. The lin...

Or a financial one... I looked at all EP applications that had a DD priority that was filed before the German reunification (1990) This was the query I used: SELECT distinct app.[appln_id] ,app.[appln_auth] ,app.[appln_nr] ,app.[appln_kind] ,app.[appln_filing_date] ,app.[appln_nr_original] ,prior.[a...

Hello Pardeep, The IPC/NACE concordance table is based on the work carried out for Eurostat in 2014. Here is the link to the background paper: 2014-10-16-Final IPC_NACE2_2014.pdf Every PATSTAT release will include an update of new patent applications according to the existing concordance table. In t...

Hello Gianluca,
Interesting question.
But a proof could be to check for EP applications (filed between 1979 - 1990) that have a DD priority, but no DD inventors/applicants. And then compare applicant/inventors countries.
Just an idea.
Geert

Hi Leo,

To cleanly close this thread: I have sent you by PM a link to download the requested file.

Martin

Hello Carmen, It is important to remember that not all patent authorities have a "utility model" IP protection regime. EPO for one does not grant utility models, so your first query will not give any results because ipr_type=UM will not return an hits where a.appln_auth=EP. The second query is fine ...