Search found 96 matches

by mkracker
Tue Jul 26, 2016 10:42 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - how to retrieve year & company
Replies: 1
Views: 1887

Re: Help with SQL query - how to retrieve year & company

Yes, this looks good. Nevertheless, here a slightly adapted version: SELECT tls201_appln.*, tls207_pers_appln.*, tls206_person.* FROM tls201_appln JOIN tls207_pers_appln ON tls207_pers_appln.appln_id = tls201_appln.appln_id JOIN tls206_person ON tls206_person.person_id = tls207_pers_appln.person_id ...
by mkracker
Tue Jul 26, 2016 10:13 am
Forum: PATSTAT Product Line
Topic: Help needed to find numerical data about patent applications
Replies: 1
Views: 718

Re: Help needed to find numerical data about patent applicat

Yes, this is doable with PATSTAT. A query would look like this: select DISTINCT a.* -- DISTINCT to remove duplicates if applications have -- more applicants from the requested country from tls201_appln a join tls207_pers_appln pa on a.appln_id = pa.appln_id join tls206_person p on pa.person_id = p.p...
by mkracker
Tue Jul 26, 2016 8:56 am
Forum: PATSTAT Product Line
Topic: Application numbers pre 2002?
Replies: 1
Views: 822

Re: Application numbers pre 2002?

There are several online tools at the EPO where you can retrieve EP applications: - Espacenet - European Patent Register In PISE (Patent Information Services for Experts): - Global Patent Index - European Full text Search - European Patent Bulletin Online - PATSTAT Online (http://www.epo.org/searchi...
by mkracker
Tue Jul 26, 2016 7:34 am
Forum: PATSTAT Product Line
Topic: Question in terms of IPC classification on Patstat
Replies: 1
Views: 738

Re: Question in terms of IPC classification on Patstat

Hi Torben, I suppose by "main IPC class" you mean the "most representative" of the IPC symbols. Of all the IPCs assigned, there should always be a "first" IPC (IPC_POSITION = 'F'). However, its meaning depends on the office: I know that for German publications (and I think also for USPTO) the "first...
by mkracker
Mon Jul 25, 2016 12:16 pm
Forum: PATSTAT Product Line
Topic: Identifying priority filings
Replies: 2
Views: 991

Re: Identifying priority filings

You mention several similar, but distinctive data items. Please let me explain each of them: EARLIEST_PAT_PUBLN_ID, EARLIEST_PUBLN_DATE, EARLIEST_PUBLN_YEAR in table TLS201_APPLN: An application can have multiple publication, like first A2, the A3, followed by B1 and finally B8. These attributes sim...
by mkracker
Fri Jul 22, 2016 10:18 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - Multi-part identifier
Replies: 3
Views: 2049

Re: Help with SQL query - Multi-part identifier

I assume that when you write "insert another row per assigned Patent-IPC " you mean that you want additional columns for each IPC symbol of an application. I can imagine that this is possible with SQL, but it would be quite tricky. Anyway,I would discourage you to do so, because that is not the way ...
by mkracker
Wed Jul 20, 2016 8:12 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - Multi-part identifier
Replies: 3
Views: 2049

Re: Help with SQL query - Multi-part identifier

Hi Moos, Bad news: I cannot comprehend your query. In fact, I never saw a query with 7 nested(!) subqueries and I cannot imagine that this is ever necessary. Good news: Your information need is quite typical and you can solve it in a much easier way. Instead of analysing your query I propose one whi...
by mkracker
Wed May 25, 2016 8:15 am
Forum: PATSTAT Product Line
Topic: Availability time-series patents and citations
Replies: 1
Views: 597

Re: Availability time-series patents and citations

Sorry to hear that a colleague of mine has given you the wrong answer. PATSTAT can answer your questions. Actually, it has been designed for exactly these types of information needs. Please note that PATSTAT is not a database which contains ready-made statistics, but provides the data structured in ...
by mkracker
Tue May 24, 2016 1:56 pm
Forum: PATSTAT Product Line
Topic: Make a Patstat query based on publication numbers
Replies: 2
Views: 715

Re: Make a Patstat query based on publication numbers

A simple way to do this is to concatenate the PUBLN_AUTH and the PUBLN_NR before doing the comparison. In T-SQL (MS SQL Server) this would look like this: select* from tls211_pat_publn where publn_auth + publn_nr = 'WO2014198277' Please note that you will not find publication US2016138562 in the cur...
by mkracker
Tue May 24, 2016 12:35 pm
Forum: PATSTAT Product Line
Topic: when will PATSTAT Online Spring 2016 edition be online?
Replies: 1
Views: 565

Re: when will PATSTAT Online Spring 2016 edition be online?

It is foreseen that we in the PATSTAT team receive a first version of PATSTAT Online which contains the 2016 Spring data next week for test. Usually 2-3 test cycles need to be done, so I aim at making this version available for the users end of June. You mentioned that you need to compare your analy...