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

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

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

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

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

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

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

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

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 ?)

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