0

How can I retrieve the meta-information of all patents filed by a given assignee?

I am mostly interested in title, inventor list, and year of filing, for patents filed to the USPTO. The meta-information should be in some machine-readable format (i.e., querying Google Patents like https://patents.google.com/?assignee=Adobe+Systems+Inc&oq=assignee:(Adobe+Systems+Inc) isn't helpful for my use case as the output isn't machine-friendly).


I have crossposted the question at:

  • Please have a look around, there are plenty questions about patent apis, maybe one of those helps already (consider making this a duplicate or compiling a self-answer if it's no duplicate). – DonQuiKong Jul 8 '18 at 10:35
  • 1
    @DonQuiKong ok I self-answered – Franck Dernoncourt Jul 8 '18 at 19:56
2

You can use the Google Patents Public Datasets (mirror), which can be accessed through Google BigQuery.

For example, this query (its execution is free of charge):

#legacySQL
SELECT publication_number, assignee_harmonized.name, filing_date, country_code  
FROM [patents-public-data.patents.publications]
-- WHERE UPPER(assignee_harmonized.name) LIKE 'ADOBE%'
WHERE UPPER(assignee_harmonized.name) = 'ADOBE SYSTEMS INC'
ORDER BY filing_date DESC 
LIMIT 20000;

returns:

enter image description here

To retrieve the inventor names, you can run:

#legacySQL
SELECT publication_number, inventor_harmonized.name, filing_date
FROM [patents-public-data.patents.publications] 
WHERE publication_number IN (
  SELECT publication_number FROM [patents-public-data.patents.publications] 
  -- WHERE UPPER(assignee_harmonized.name) LIKE 'ADOBE%'
  WHERE UPPER(assignee_harmonized.name) = 'ADOBE SYSTEMS INC'
)
AND country_code = 'US'
ORDER BY filing_date DESC;

Schema description: https://bigquery.cloud.google.com/table/patents-public-data:patents.publications?tab=schema:

enter image description here

I have used the legacy SQL, but the preferred query syntax for BigQuery is standard SQL. See Migrating to Standard SQL if you want to convert the queries to Standard SQL.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.