Search found 97 matches

by EPO / PATSTAT Support
Wed Apr 25, 2018 10:35 am
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 6
Views: 2753

Re: PATSTAT - ORACLE loading scripts

Many thanks.
:)
by EPO / PATSTAT Support
Tue Apr 24, 2018 11:46 am
Forum: PATSTAT Product Line
Topic: Patents Application and Patents Granted per year (firm level)
Replies: 2
Views: 822

Re: Patents Application and Patents Granted per year (firm level)

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...
by EPO / PATSTAT Support
Mon Apr 23, 2018 1:50 pm
Forum: PATSTAT Product Line
Topic: Error message: Query Killed
Replies: 1
Views: 538

Re: Error message: Query Killed

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...
by EPO / PATSTAT Support
Thu Apr 12, 2018 11:55 am
Forum: PATSTAT Product Line
Topic: Upcoming PATSTAT 2018 spring release
Replies: 0
Views: 648

Upcoming PATSTAT 2018 spring release

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...
by EPO / PATSTAT Support
Fri Apr 06, 2018 3:47 pm
Forum: PATSTAT Product Line
Topic: East Germany inventors @ EPO
Replies: 4
Views: 1506

Re: East Germany inventors @ EPO

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...
by EPO / PATSTAT Support
Fri Apr 06, 2018 11:11 am
Forum: PATSTAT Product Line
Topic: NACE2 codes and IPC codes updation
Replies: 2
Views: 818

Re: NACE2 codes and IPC codes updation

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...
by EPO / PATSTAT Support
Thu Mar 29, 2018 4:15 pm
Forum: PATSTAT Product Line
Topic: East Germany inventors @ EPO
Replies: 4
Views: 1506

Re: East Germany inventors @ EPO

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
by EPO / PATSTAT Support
Thu Mar 22, 2018 8:58 am
Forum: PATSTAT Product Line
Topic: tls231_part01
Replies: 5
Views: 942

Re: tls231_part01

Hi Leo,

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

Martin
by EPO / PATSTAT Support
Wed Mar 21, 2018 2:47 pm
Forum: PATSTAT Product Line
Topic: Application authority of utility models & address information
Replies: 1
Views: 703

Re: Application authority of utility models & address information

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 ...