Search found 232 matches

by EPO / PATSTAT Support
Fri Apr 06, 2018 3:47 pm
Forum: PATSTAT Product Line
Topic: East Germany inventors @ EPO
Replies: 4
Views: 4005

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: 2717

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: 4005

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: 3250

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: 1619

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 ...
by EPO / PATSTAT Support
Tue Mar 20, 2018 5:09 pm
Forum: PATSTAT Product Line
Topic: Query by “type” of applicant
Replies: 2
Views: 2373

Re: Query by “type” of applicant

Hello Telmo, in the tls206_person table you will find an attribute called PSN_SECTOR. This sector-isation approach is described in this document: https://circabc.europa.eu/sd/a/5b474c9c-3e8c-4070-82a4-1d0e234b3d58/COMPENDIUM%20PART%20II_Patent%20-%20WP_Sector%20allocation.pdf Your criteria can be ea...
by EPO / PATSTAT Support
Tue Mar 20, 2018 4:02 pm
Forum: PATSTAT Product Line
Topic: tls231_part01
Replies: 5
Views: 3250

Re: tls231_part01

Hello Leo,
we will look into that.
I don't think it is a problem with regards to the files, because all our users get the data from the platform, and we haven't heard anything on shifts of data.
But we will investigate it.
by EPO / PATSTAT Support
Mon Mar 05, 2018 5:30 pm
Forum: PATSTAT Product Line
Topic: Retrieving patents with inventors spread across multiple countries
Replies: 3
Views: 2688

Re: Retrieving patents with inventors spread across multiple countries

Hello Rooster25, although it might look like a simple question, doing such aggregation in PATSTAT Online is not straightforward, and the only possibility is to use a sub query that defines applications that have more then 2 inventors from different countries (not being blank neither). On a local ins...
by EPO / PATSTAT Support
Fri Feb 16, 2018 4:21 pm
Forum: PATSTAT Product Line
Topic: Import data from excel - PATSTAT 2017 Autumn
Replies: 2
Views: 2796

Re: Import data from excel - PATSTAT 2017 Autumn

Hello Pardeep, It depends a bit how your publication numbers are formatted. In pure SQL you could use the "IN" function in the WHERE clause. Something like this: select publn_auth, publn_nr, publn_nr_original,ipc_class_symbol from tls211_pat_publn join tls209_appln_ipc on tls211_pat_publn.appln_id =...
by EPO / PATSTAT Support
Mon Feb 12, 2018 9:18 am
Forum: PATSTAT Product Line
Topic: Update of TLS224_appln_cpc?
Replies: 1
Views: 2117

Re: Update of TLS224_appln_cpc?

Hello Jos, The Y02A codes (“Technologies for adaptation to climate change”) have been put on-line in Espacenet and were done in time to make it into the back file for production of the Spring 2018 vesion. It currently gathers 405.011 documents, split as follows: Y02A10/CCA: Adaptation at costal zone...