Search found 231 matches

by EPO / PATSTAT Support
Fri Jun 15, 2018 9:19 am
Forum: PATSTAT Product Line
Topic: Applications in B25J/Y10S but not B60W/B60K/B60L
Replies: 5
Views: 2209

Re: Applications in B25J/Y10S but not B60W/B60K/B60L

Hello Joachim, Your query seems fine to me as such. But I am not sure why you join with tls226 as well as 206 ? TLS226 is only useful for analysis where you need to have the "address data" more tagged in detail - for as far as such data is available.- Keep in mind that the query produces a very gene...
by EPO / PATSTAT Support
Tue Jun 12, 2018 9:30 am
Forum: PATSTAT Product Line
Topic: Master thesis patent data
Replies: 1
Views: 2343

Re: Master thesis patent data

Hello chrisparfitt, the PATSTAT data base should contain the data you are looking for, but you will need to extract it. There are no " ready to use" data sets according to your needs. Have a look at the PATSTAT webpage: http://www.epo.org/searching-for-patents/business/patstat.html#tab-1 ; you can o...
by EPO / PATSTAT Support
Fri Jun 08, 2018 4:09 pm
Forum: PATSTAT Product Line
Topic: vanishing applications across ediction
Replies: 1
Views: 1412

Re: vanishing applications across ediction

Hello Gainluca, the most "general rule" for these "disappearances" is the cleaning of the database and removal of duplicates, etc... If you look-up the PUBLICATIONS linked to those "disappeared" applications in the 2018an database, you will see that they are now linked to an application (with the sa...
by EPO / PATSTAT Support
Fri Jun 08, 2018 10:11 am
Forum: PATSTAT Product Line
Topic: Patent Publication Research
Replies: 2
Views: 1779

Re: Patent Publication Research

Hello Flavio, for sample queries, kindly seach previous forum posts, there are plenty examples. If you would write a query that results in a list that contains all your listed data attributes, then you will have plenty of duplicates at publication (citation) level. Such list can of course be used fo...
by EPO / PATSTAT Support
Tue May 29, 2018 10:23 am
Forum: PATSTAT Product Line
Topic: Spanish applicant 1st Publications by tech field
Replies: 3
Views: 1857

Re: Spanish applicant 1st Publications by tech field

Hello Jantonio, your query looks fine, apart from 1 small mistake; 'Y02E 10/7%' should have 2 spaces between the E and the 10. (But maybe double spaces are removed in forum posts by the spell check.) Just keep in mind that CPC (and IPC) codes need 4 digits and you have to replenish with blanks. (Man...
by EPO / PATSTAT Support
Tue May 29, 2018 9:58 am
Forum: PATSTAT Product Line
Topic: Applications in B25J/Y10S but not B60W/B60K/B60L
Replies: 5
Views: 2209

Re: Applications in B25J/Y10S but not B60W/B60K/B60L

Hello Joachim, your query does not do what I think you want it to do. Basically, what you intend to do is to exclude a subset from your applications that are defined by the first conditions "AND (LEFT(ipc_class_symbol, 4) = 'B25J' OR LEFT(cpc_class_symbol, 4) = 'B25J' OR LEFT(cpc_class_symbol, 4) = ...
by EPO / PATSTAT Support
Fri May 25, 2018 10:51 am
Forum: PATSTAT Product Line
Topic: publn_date, tls209, weight
Replies: 1
Views: 1615

Re: publn_date, tls209, weight

Dear Leo, 1) Yes. See the description of this attribute in the Data Catalog: “EARLIEST_PUBLN_DATE: Date of earliest publication of an application” 2) Yes, it is possible, and actually it is very likely. Usually there are more IPCs for a single application, so there are as many rows in table TLS209_A...
by EPO / PATSTAT Support
Tue May 22, 2018 2:06 pm
Forum: PATSTAT Product Line
Topic: search applicants' country of origin.
Replies: 1
Views: 1502

Re: search applicants' country of origin.

Hello mhollifi, Good idea but no; that information is not available in PATSTAT. The "country" information is in most cases the "place of business". I think it will be rather difficult to get those variables in a reliable common date set, unless you could match inventor data to US immigration/person/...
by EPO / PATSTAT Support
Thu May 17, 2018 2:41 pm
Forum: PATSTAT Product Line
Topic: Help with counting backward citation
Replies: 5
Views: 2826

Re: Help with counting backward citation

And EPO patent data does not have a concept of "first" or "main classfication".
Therefore you as a researcher will need to define the criteria for "main" classification.
(Weighing at subsclass level ?)
by EPO / PATSTAT Support
Wed May 16, 2018 11:19 am
Forum: PATSTAT Product Line
Topic: Impact of Legal Event
Replies: 2
Views: 4897

Re: Impact of Legal Event / INPADOC data

Hello Leo, somewhere in cyberspace, your question was not picked up. The event_impact indicator (also called influence indicator ) is a remainder inherited from an older grouping system that indicates whether the "impact" was positive or negative from the point of view of the applicant (or owner). H...