The PATSTAT team sometimes receives questions with regards to gender identification of inventors and applicants. Classical research topic that need gender profiling are often based on a need expressed by policy makers for hard evidence that stimulation programs to inspire girls and women to study an...

Hello Esther, that's a lot of questions in one post. I will tackle them one by one: 1) the coverage of citations in PATSTAT is dependant on what data the EPO receives from the respective national patent offices that carry out the searches. Additionally to the above, the EPO carries out searches for ...

It seems that the SQL parser has a problem with this code, but it is correct (at least it runs in MSSQL). I suggest to export the results and make the totals in excel. That will be much easier then trying to find a solution for the final total row. SELECT docdb_family_id, nb_citing_docdb_fam FROM tl...

Hello Tom, the list of the patents with their respective forward citations is a variation on the above query: select publn_auth+publn_nr+publn_kind, docdb_family_id ,publn_date, psn_name, publn_first_grant, psn_name, nb_citing_docdb_fam from tls206_person join tls207_pers_appln on tls206_person.pers...

Hello Newby, when you make use of the standardised name (PSN attribute) in combination with wild cards, it is a good approach to do a quick sanity check to see whether your wildcard does not include (or exclude) too many results. In your case you could simply run the following query to get a list of...

Hello Derek, On 1. Granted applications can easily be identified via the attribute "granted" in the tls201 table. If your analysis is based on the year in which a patent was granted (5 year before the deal) then you should use the attribute "PUBLN_FIRST_GRANT" in the TLS211_PAT_P...

Hello Amleto, See SQL query below. I have limited the set by only taking citing documents published in 2015. Otherwise you will get millions of records (Cartesian product of all citing publications with all cited publications with all IPC codes from the citing publication ...) SELECT distinct CITED....

Hello Tom, it will not be so easy to do this in 1 batch for 260 companies due to the fact that PATSTAT contains data from nearly 100 patent offices and multiple "variations" on applicant names for big companies. (Even in the PSN harmonised name attribute.) My suggestion for a possible appr...

Hello Tom Kat, In principle, such query could be made. Maybe you can give a concrete example with a couple of companies so that it becomes more tangible ? Also what kind of data you would like to have in the output ? Just a name of the acquirer with the "before and after" number ? To consi...

Are you using PATSTAT Online, or do you have a local installation ? This kind of "output" where data has to be de-normalised is rather difficult to obtain from a 1 go SQL query. Unless you don't mind having multiple "rows" for 1 citing application. (one for each possible data occ...