Dear Carlos if you want to select all patents coming via PCT route from any country just add in your selection criteria APPLN_AUTH = 'WO' SELECT * FROM TLS201_APPLN AS APP INNER JOIN TLS202_APPLN_TITLE AS TIT ON (APP.APPLN_ID = TIT.APPLN_ID) INNER JOIN TLS203_APPLN_ABSTR ABS ON (APP.APPLN_ID = ABS.A...

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.

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....

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

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

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...

HI,

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

http://rawpatentdata.blogspot.com/2017/ ... ks-in.html

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

interesting

thanks

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...