Search found 25 matches

by gianluca.tarasconi
Wed Nov 06, 2019 1:16 pm
Forum: PATSTAT Product Line
Topic: PATSTAT 2019b MySQL upload scripts
Replies: 0
Views: 2190

PATSTAT 2019b MySQL upload scripts

at the link

https://rawpatentdata.blogspot.com/2019 ... ripts.html

I made available my new scripts for MySQL to upload PATSTAT 2019b data.

My scripts have been updated to remove MyIsam as default engine and to make them fully compatible with MySQL 8.0.
by gianluca.tarasconi
Mon Jul 08, 2019 3:38 pm
Forum: PATSTAT Product Line
Topic: patentsview-PATSTAT concordance
Replies: 1
Views: 1614

patentsview-PATSTAT concordance

dear all at link: https://rawpatentdata.blogspot.com/2019/07/patstat-patentsview-concordance-update.html I made available a table of concordance between patent_id (Patentsview main key) and appln_id (from PATSTAT) Overlapping of the two datasets is not perfect but most of applications can be linked....
by gianluca.tarasconi
Mon May 20, 2019 7:15 am
Forum: PATSTAT Product Line
Topic: PATSTAT 2019a MySQL upload scripts
Replies: 0
Views: 2571

PATSTAT 2019a MySQL upload scripts

dear all

I put @ url

https://rawpatentdata.blogspot.com/2019 ... ripts.html

MySQL scripts for uploading 2019a PATSTAT data

hope you find them useful

GT
by gianluca.tarasconi
Wed Oct 17, 2018 4:38 pm
Forum: PATSTAT Product Line
Topic: PATSTAT autumn 2018 MySQL upload scripts
Replies: 1
Views: 1894

PATSTAT autumn 2018 MySQL upload scripts

dear all

for those who might need it I put in my blog at page

http://rawpatentdata.blogspot.com/2018/ ... ripts.html

an updated set of scripts to upload last version of PATSTAT

enjoy!!!

GL
by gianluca.tarasconi
Fri Jun 08, 2018 11:37 am
Forum: PATSTAT Product Line
Topic: vanishing applications across ediction
Replies: 1
Views: 1412

vanishing applications across ediction

Dear all I ran a comparison across edictions 2018a and 2016b (query attached) and I found a number of applications in the older version cannot be found in the new one most occurring case, above 1000 app for year are Australian D, but also other offices, for example 'KR' 'A' 2005 1956 'KR' 'A' 2006 2...
by gianluca.tarasconi
Fri Jun 08, 2018 11:32 am
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 2545

Re: Only 30% person_address available?

HI,

yes; if you need a coverage by patent office I made some stats here

http://rawpatentdata.blogspot.com/2017/ ... ks-in.html
by gianluca.tarasconi
Fri Apr 20, 2018 4:35 pm
Forum: PATSTAT Product Line
Topic: PATSTAT 2018a §MySQL upload scripts
Replies: 1
Views: 1608

PATSTAT 2018a §MySQL upload scripts

dear PATSTAT users

at link below is possible to download a batch of scripts for MySQL that will allow you to upload new PATSTAT edition spring 2018.

http://rawpatentdata.blogspot.it/2018/0 ... ripts.html

Best

GT
by gianluca.tarasconi
Fri Apr 06, 2018 4:04 pm
Forum: PATSTAT Product Line
Topic: East Germany inventors @ EPO
Replies: 4
Views: 3987

Re: East Germany inventors @ EPO

interesting

thanks
by gianluca.tarasconi
Thu Apr 05, 2018 3:16 pm
Forum: PATSTAT Product Line
Topic: Patentsview PATSTAT concordance
Replies: 0
Views: 1647

Patentsview PATSTAT concordance

For any user willing to compelment PATSTAT uspto data with Patentsview (www.patentsview.org) I made available in my blog at https://rawpatentdata.blogspot.it/2018/04/patentsview-patstat-concordance.html a table of concordance between patent_id (Patentsview main key) and appln_id (from PATSTAT) and s...
by gianluca.tarasconi
Thu Mar 29, 2018 6:18 pm
Forum: PATSTAT Product Line
Topic: East Germany inventors @ EPO
Replies: 4
Views: 3987

Re: East Germany inventors @ EPO

Actually what I did was to investigate the families with first filing @ DD and at least one EPO patent; it seems only 476 of them exist...(checking all families with at least one DD would probably get filing from west Germany extended to DDR) so it's likely to be a political issue...