Using DBI to connect to and query PostgreSQL databases
Data on Women Inventors from the USPTO
Learn the basics of Postgres, what it is, how it works, and how to install it on macOS
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
How to create and query a PostgreSQL database
Importing USPTO PatentsView Data Download Files with R.
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.
Learn how to use the USPTO Patentsview API in R.
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 ...".
