Search found 130 matches
- Mon Feb 12, 2018 5:06 pm
- Forum: PATSTAT Product Line
- Topic: Gender dictionaries and PATSTAT
- Replies: 0
- Views: 2272
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...
- Mon Jan 15, 2018 3:52 pm
- Forum: PATSTAT Product Line
- Topic: Counting backward citations and data coverage
- Replies: 2
- Views: 5410
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 ...
- Mon Dec 18, 2017 10:17 am
- Forum: PATSTAT Product Line
- Topic: Count number of patent applications per company
- Replies: 11
- Views: 8913
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...
- Fri Dec 15, 2017 6:21 pm
- Forum: PATSTAT Product Line
- Topic: Count number of patent applications per company
- Replies: 11
- Views: 8913
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...
- Thu Nov 30, 2017 3:51 pm
- Forum: PATSTAT Product Line
- Topic: Exclude specific company name
- Replies: 1
- Views: 2689
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...
- Mon Nov 27, 2017 11:40 am
- Forum: PATSTAT Product Line
- Topic: Count number of patent applications per company
- Replies: 11
- Views: 8913
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_P...
- Thu Nov 23, 2017 7:14 pm
- Forum: PATSTAT Product Line
- Topic: Getting IPC codes of citing patents
- Replies: 3
- Views: 2665
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....
- Thu Nov 23, 2017 6:33 pm
- Forum: PATSTAT Product Line
- Topic: Count number of patent applications per company
- Replies: 11
- Views: 8913
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 appr...
- Wed Nov 22, 2017 5:07 pm
- Forum: PATSTAT Product Line
- Topic: Count number of patent applications per company
- Replies: 11
- Views: 8913
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 consi...
- Thu Nov 02, 2017 5:13 pm
- Forum: PATSTAT Product Line
- Topic: Getting IPC codes of citing patents
- Replies: 3
- Views: 2665
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 occ...