WIPO Analytics

Using PostgreSQL with RStudio and DBI

Using DBI to connect to and query PostgreSQL databases

Women Inventors Data in R

Data on Women Inventors from the USPTO

Getting Started with PostgreSQL

Learn the basics of Postgres, what it is, how it works, and how to install it on macOS

Visualising Nobel API data in R

Follow along as we call data from the Nobel API, convert it from JSON and visualise it to gain insight about the gender distribution of Nobel Prize recipients

Querying PostgreSQL Tables

How to create and query a PostgreSQL database

Import Bulk PatentsView Data with R

Importing USPTO PatentsView Data Download Files with R.

PatentsView Bulk Data

Learn how to download bulk US patent data from PatentsView with R.


Learn to use the Elasticsearch with patent data.


Visualise patent data with flourish.

Using the Patentsview API in R

Learn how to use the USPTO Patentsview API in R.

More articles »

WIPO Analytics


If you see mistakes or want to suggest changes, please create an issue on the source repository.


Text and figures are licensed under Creative Commons Attribution CC BY 4.0. Source code is available at https://github.com/wipo-analytics, unless otherwise noted. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".