Search found 11 matches

by Rachie
Sun Dec 02, 2018 6:50 pm
Forum: PATSTAT Product Line
Topic: Support for automation
Replies: 2
Views: 3891

Support for automation

For me, retrieving the full patstat dataset is quite a chore. Once I found the download page (this took me fully 30 minutes), there is no easy way to download everything. Clicking on each link in a web browser is both tedious and unreliable. The server only seems to support five or so simultaneous d...
by Rachie
Wed Oct 25, 2017 7:34 pm
Forum: PATSTAT Product Line
Topic: Searching by US patent number
Replies: 2
Views: 2450

Re: Searching by US patent number

Just what I needed, thanks!
by Rachie
Wed Oct 25, 2017 6:36 am
Forum: PATSTAT Product Line
Topic: Searching by US patent number
Replies: 2
Views: 2450

Searching by US patent number

I'm trying to figure out how to determine a docdb_family_id for patents, given a US patent ID or application ID. What fields correlate to patent IDs or application IDs? I can't quite figure it out from the documentation. As an example, how would I locate this patent in the database? https://patents....
by Rachie
Sat Nov 26, 2016 4:37 am
Forum: PATSTAT Product Line
Topic: PATSTAT autumn 2016 checksums
Replies: 1
Views: 1564

PATSTAT autumn 2016 checksums

Given how some users have had trouble with corrupt data when copying over the USB drive, it's extremely important to include checksums on the data. These are not listed anywhere I can find, so I created my own. There's no way for me to know if my files are completely valid, but it should at least il...
by Rachie
Wed Mar 16, 2016 10:59 pm
Forum: PATSTAT Product Line
Topic: Inventor sequence number pre-2005
Replies: 1
Views: 1641

Inventor sequence number pre-2005

The data catalogue contains a couple notes about how inventor sequence numbers are inaccurate from 1971-2005: OECD patents database for US data post 1976-01-01 up to and including November 15th 2005 for Published Grants. This data does not contain sequence numbers, so they are allocated within PATST...
by Rachie
Wed Dec 23, 2015 7:34 pm
Forum: PATSTAT Product Line
Topic: Tool for import PATSTAT into MySQL
Replies: 1
Views: 2739

Re: Tool for import PATSTAT into MySQL

Wonderful! Thanks so much, Simone.
by Rachie
Wed Dec 23, 2015 7:28 pm
Forum: PATSTAT Product Line
Topic: Amended 2015b tables
Replies: 2
Views: 2606

Re: Amended 2015b tables

Got it, thanks!
by Rachie
Tue Dec 22, 2015 7:45 pm
Forum: PATSTAT Product Line
Topic: Amended 2015b tables
Replies: 2
Views: 2606

Amended 2015b tables

I saw a blog post about how amended tables for the 2015b version of patstat have been released, but I haven't been able to find any official information about this. I never got an email from patstat, nor is it listed anywhere I can find online. Where can I find the FTP links to download the new data?
by Rachie
Sun Dec 06, 2015 6:15 pm
Forum: PATSTAT Product Line
Topic: load PATSTAT to Postgresql
Replies: 4
Views: 3386

Re: load PATSTAT to Postgresql

I saw, but it's not quite the same as having some shell scripts to load and check everything. Ideally, the two would be combined. I'm wondering if anyone would like to work on this with me.
by Rachie
Wed Dec 02, 2015 3:52 am
Forum: PATSTAT Product Line
Topic: Non-zero applicant and inventor sequence number
Replies: 1
Views: 1744

Non-zero applicant and inventor sequence number

What does it mean when both the applicant sequence number and the inventor sequence number are greater than zero in the tls207_pers_appln table? I understand a zero in the applicant column indicates an inventor, and a zero in the inventor column indicates an applicant, but there's nothing in the doc...