Search found 132 matches

by Geert Boedt
Mon Feb 12, 2018 5:06 pm
Forum: PATSTAT Product Line
Topic: Gender dictionaries and PATSTAT
Replies: 0
Views: 1428

Gender dictionaries and PATSTAT

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...
by Geert Boedt
Mon Jan 15, 2018 3:52 pm
Forum: PATSTAT Product Line
Topic: Counting backward citations and data coverage
Replies: 2
Views: 3030

Re: Counting backward citations and data coverage

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 ...
by Geert Boedt
Mon Dec 18, 2017 10:17 am
Forum: PATSTAT Product Line
Topic: Count number of patent applications per company
Replies: 11
Views: 6156

Re: Count number of patent applications per company

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...
by Geert Boedt
Fri Dec 15, 2017 6:21 pm
Forum: PATSTAT Product Line
Topic: Count number of patent applications per company
Replies: 11
Views: 6156

Re: Count number of patent applications per company

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...
by Geert Boedt
Thu Nov 30, 2017 3:51 pm
Forum: PATSTAT Product Line
Topic: Exclude specific company name
Replies: 1
Views: 2049

Re: Exclude specific company name

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...
by Geert Boedt
Mon Nov 27, 2017 11:40 am
Forum: PATSTAT Product Line
Topic: Count number of patent applications per company
Replies: 11
Views: 6156

Re: Count number of patent applications per company

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_PUBLN table. Research...
by Geert Boedt
Thu Nov 23, 2017 7:14 pm
Forum: PATSTAT Product Line
Topic: Getting IPC codes of citing patents
Replies: 3
Views: 1796

Re: Getting IPC codes of citing patents

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....
by Geert Boedt
Thu Nov 23, 2017 6:33 pm
Forum: PATSTAT Product Line
Topic: Count number of patent applications per company
Replies: 11
Views: 6156

Re: Count number of patent applications per company

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 approach (ther...
by Geert Boedt
Wed Nov 22, 2017 5:07 pm
Forum: PATSTAT Product Line
Topic: Count number of patent applications per company
Replies: 11
Views: 6156

Re: Count number of patent applications per company

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 consider: would...
by Geert Boedt
Thu Nov 02, 2017 5:13 pm
Forum: PATSTAT Product Line
Topic: Getting IPC codes of citing patents
Replies: 3
Views: 1796

Re: Getting IPC codes of citing patents

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 occurrence) A local ins...