How can i download the table from patstat results

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

waka
Posts: 8
Joined: Wed Nov 10, 2021 5:00 pm

How can i download the table from patstat results

Post by waka » Mon May 23, 2022 2:44 pm

Good afternoon, how can I download a table with 100000 results?


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: How can i download the table from patstat results

Post by EPO / PATSTAT Support » Tue May 24, 2022 2:26 pm

Hello Waka,

In principle, you can not do such.
The downloads are limited in size (and dependant whether you have a subscription or the free trial)
see : patstat-online-download-and-extraction-limitations-9515

What you could do is split the download in multiple tables, at least if it is a reasonable amount.
Doing it for batches of queries will get your user_id blocked from the service.

Alternative: download a subset as ms ACCESS and then create the table in MS ACCESS. Subsets up to 100.000 applications can be created. But you have to be a bit modest in the amount of tables you select to stay under the 2 GB MS ACCESS size limits.

On the other hand, researchers seldom need such large datasets to conduct analysis.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply