Search found 94 matches

by mkracker
Tue Jul 26, 2016 8:56 am
Forum: PATSTAT Product Line
Topic: Application numbers pre 2002?
Replies: 1
Views: 798

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: 712

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: 956

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: 1553

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: 1553

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: 577

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: 675

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: 538

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...
by mkracker
Fri May 20, 2016 8:56 pm
Forum: PATSTAT Product Line
Topic: Same PATSAT version & query, different values?
Replies: 1
Views: 840

Re: Same PATSAT version & query, different values?

Hi Alfonso, I suppose you are using PATSTAT Online, so we are all working on the same data. I tried to reproduce your example of Y02E 10/1 Geothermal energy, because there you gave specific numbers: I used this query for the 2015 Autumn Edition: SELECT DISTINCT t.earliest_filing_year, t.nb_citing_do...
by mkracker
Wed May 11, 2016 3:33 pm
Forum: PATSTAT Product Line
Topic: Updated SQL Self Study Course for PATSTAT
Replies: 0
Views: 655

Updated SQL Self Study Course for PATSTAT

If you are a beginner or not so familiar with SQL, I want to point you to the PATSTAT SQL Self Study Course which has been updated recently. Starting from zero, it presents the most frequently used concepts of SQL. All examples are based on PATSTAT and can be directly copied&pasted into PATSTAT Onli...