Hello Pevj, when I read your post, I assume you are using a data base extraction created from PATSTAT Online. If this is the case, then your observations might be due to way the sample of the extracted data is created. The extraction tool allows you to include cited, citing and also different family...

Hi Pedro, IPC class level “S” is old, and should not be used anymore. I assume these codes will be cleaned out with time, so you can simply disregard them. Differences between what you find in PATSTAT and the printed document can be due to several reasons, but the main reasons are : re-classificatio...

Hello Leo, your query has a couple of syntax errors, but in general, I don't see the meaning of using the appln_nr_epodoc the way it is done in your query. The attribute appln_nr_epodoc has no relation to the country of inventor or applicants. The country code in appln_nr_epodoc will normally be the...

Can you illustrate this with and couple of examples and the query you used to link the families with its cited families ? That would allow us to have a closer look at your observation. Separate from the above, we do not have citations for all patent authorities. Have a look at the citations coverage...

Hello Renee, PCT applications follow the normal 18 month delay between application and publication, similar to what a direct EP application would show. Therefore, with the increasing trend of EP applications being preceded by an earlier PCT, looking at PCT's will give researchers a "pre-view&qu...

Hello Maria_Mercedes, indeed a lot of questions. It will be rather difficult to work with PATSTAT (Online) without any sql knowledge. On the PATSTAT website, you can find some self training material and sample queries to get started. Here is the link: http://www.epo.org/searching-for-patents/busines...

Hello Simon, the model of the PATSTAT Legal data base has indeed changed a little bit; some of the attributes have been renamed. This is an adapted query based on the one you used: SELECT appln_auth+appln_nr+' '+appln_kind ap_number, appln_filing_date, event_seq_nr, event_code, event_publn_date, fee...

Hello Simon, the main challenge with your request is the definition of "a company that holds patents ". The bibliographical data in PATSTAT (and most other patent data bases) is referring to the "applicants", at the moment the respective patent document is published. "Holdin...

Hello Carmen, 2 short observations, you used different time frames, and you should do a count(distinct(tls201.appln.appln_id)) Something like this: SELECT COUNT(distinct(a.appln_id)) FROM tls201_appln a join tls209_appln_ipc aipc on a.appln_id = aipc.appln_id join tls207_pers_appln pa on a.appln_id ...

Hello Erkul, here is a sample query that will work in PATSTAT Online which gives you the number of patent publications according to the first publication year per NUTS-3 classification. (patents can have multiple publication instances for the same application, so ONLY the first one will be taken int...