Skip to content

Latest commit

 

History

History
12 lines (8 loc) · 749 Bytes

README.md

File metadata and controls

12 lines (8 loc) · 749 Bytes

Global Patent Count

Quick code to process a CSV download of per-country monthly patent filings, downloaded from Google’s BigQuery service, and plot the resulting time series.

Manifest

  • global_patent_counts.r -- Processes, aggregates, and plots the patent data. Expects a file monthly_country_patents.csv in a data/ subdirectory.
  • patent_monthly_count.sql -- Contains the SQL query to be run in Google’s BigQuery console against the patent publications database. The result should be downloaded in CSV format and placed in the data/ subdirectory.

Note that running the SQL query requires an appropriate login and set of credentials for Google’s BigQuery service.

Output graph will be saved to the output/ subdirectory.