Help with large downloads on PATSTAT online
Posted: Fri Sep 20, 2019 6:08 pm
Hi team,
I would like to do a large download where I get all application IDs for patents filed by UK entities and their associated CPC codes over 2000-2019 (using earliest filing year for the time interval). The issue is that PATSTAT online only allows you to export 700,000 rows at a time to excel. Even when I restrict the interval to one year (e.g. 2000-2001) there are more than 700,000 rows. Does anyone have any advice on how to do batch downloads? For example, how do I tell PATSTAT to download the first 350,000 rows and then download the bottom 350,000 rows? I've seen example code for this on sql help forums but am struggling to apply it to PATSTAT online. Any advice on how to do this would be appreciated. I also don't mind advice on other ways to handle very large downloads & how to get around the 700,000 row limit.
Thank you!
I would like to do a large download where I get all application IDs for patents filed by UK entities and their associated CPC codes over 2000-2019 (using earliest filing year for the time interval). The issue is that PATSTAT online only allows you to export 700,000 rows at a time to excel. Even when I restrict the interval to one year (e.g. 2000-2001) there are more than 700,000 rows. Does anyone have any advice on how to do batch downloads? For example, how do I tell PATSTAT to download the first 350,000 rows and then download the bottom 350,000 rows? I've seen example code for this on sql help forums but am struggling to apply it to PATSTAT online. Any advice on how to do this would be appreciated. I also don't mind advice on other ways to handle very large downloads & how to get around the 700,000 row limit.
Thank you!