In 2015, I wrote a blog post on the USPTO’s Patent Trial and Appeal Board—The USPTO’s PTAB is very busy—and why it matters. PTAB data is available to our subscribers in the IFI CLAIMS Direct patent database's legal status data field. PTAB data is now publicly available on Google Patents Public Datasets on BigQuery as the uspto_ptab dataset. The USPTO has provided this dataset and describes it this way:
"USPTO Patent Trial and Appeal Board (PTAB) API Data contains data from the PTAB E2E (end-to-end) system making public America Invents Action (AIA) Trials information and documents available."
Using BigQuery to access PTAB data is very convenient and free (excluding small processing fees).
USPTO PTAB Dataset
For example, I can retrieve data on specific PTAB cases using this SQL Query:
SELECT PatentOwnerName, PatentNumber, PetitionerPartyName, TrialNumber, ProsecutionStatus
FROM `patents-public-data.uspto_ptab.trials`
WHERE TrialNumber IN ("IPR2017-01047", "IPR2017-00548", "IPR2015-01856", "IPR2016-01820",
"IPR2013-00027", "IPR2015-00079", "IPR2014-00153", "IPR2017-01582",
"IPR2017-00200", "IPR2017-00319")
The result is:
| PatentOwnerName | PatentNumber | PetitionerPartyName | TrialNumber | ProsecutionStatus |
| Lee | 8489837 | SK hynix Inc. | IPR2017-00548 | Instituted |
| Lee | 8544078 | McAfee, Inc. | IPR2015-01856 | FWD Entered |
| Lee | 6885055 | Samsung Electronics Co., Ltd. | IPR2017-01047 | Terminated-Denied |
| Lee et al | 6989123 | Guangdong Alison Hi-Tech Co., Ltd. | IPR2016-01820 | Terminated-Denied |
| Afluo, LLC | 5995091 | Adobe Systems Incorporated | IPR2014-00153 | FWD Entered |
| Yang et al | 8603514 | Dr. Reddy’s Laboratories, Inc. | IPR2017-01582 | PO Response Filed |
| Yang et al | 8603514 | Mylan Technologies, Inc. | IPR2017-00200 | Terminated-Adverse Judgment |
| LeBoeuf et al | 8923941 | Apple Inc. | IPR2017-00319 | Instituted |
| Lee & Hayes PLLC | 5862511 | DENSO CORPORATION | IPR2013-00027 | Terminated-Denied |
| Rockstar Consortium US LP | 5838551 | Google Inc. | IPR2015-00079 | Terminated-Denied |
It’s very simple. However, there is a problem. If you try and search the patents by the names in the “PatentOwnerName” column, you will see that in some cases, inventor names are listed making it inconvenient to find the corporate owner of the patent. In the case of “Afluo LLC” and “Rockstar Consortium US LP”, these are not the original filers of the patents.
IFI Data Enrichments
With the launch of Google Public Patent Datasets on BigQuery, IFI CLAIMS released its Data Enrichments Dataset as a private table. It can be accessed through a subscription. IFI describes the table as follows:Enriched patent data from IFI CLAIMS is available as a paid table on BigQuery. IFI’s Data Enrichments provide accurate company names and legal status information.
This data will add new insights and confidence to your patent queries.
IFI Technical Support is available to subscribers of IFI’s Patent Data Enrichments on BigQuery.
IFI Data Enrichments are available for the following authorities: US, EP, Germany, France, Canada, UK and Spain.
For information on subscribing to IFI Patent Data Enrichments on BigQuery, contact us as info@ificlaims.com.
With PTAB, IFI’s Standardized Original Assignee name and Current Assignee Name fields are particularly important. The SQL statement below joins the PTAB and IFI’s Data Enrichment datasets. A special “match” table is used to resolve the different patent number formats.
SELECT IFI.publication_number AS IFI_pn,
IFI.original_assignee AS IFI_original_assignee,
IFI.current_assignee AS IFI_current_assignee,
ptab.PatentOwnerName AS PatentOwner,
ptab.PetitionerPartyName AS Petitioner,
ptab.TrialNumber AS Trial,
ptab.ProsecutionStatus AS Status
FROM `patents-public-data.uspto_ptab.trials` AS ptab
JOIN `patents-public-data.uspto_ptab.match` AS ptab_match
ON ptab.ApplicationNumber = ptab_match.ApplicationNumber
JOIN `patents-public-data.patents.publications` AS PUBLIC
ON ptab_match.application_number = PUBLIC.application_number
JOIN `civil-dolphin-136720.IFIDataEnrichments.IFIDataEnrichments` AS IFI
ON IFI.publication_number = PUBLIC.publication_number
WHERE TrialNumber IN ("IPR2017-01047", "IPR2017-00548", "IPR2015-01856",
"IPR2016-01820", "IPR2013-00027", "IPR2015-00079",
"IPR2014-00153", "IPR2017-01582", "IPR2017-00200",
"IPR2017-00319")
The result is:
| IFI_pn | IFI_original_assignee | IFI_current_assignee | PatentOwner | Petitioner | Trial | Status |
|---|---|---|---|---|---|---|
| US-5995091-A | Learn2 com Inc | AFLUO LLC | Afluo, LLC | Adobe Systems Incorporated | IPR2014-00153 | FWD Entered |
| US-2007226788-A1 | Cap Co Ltd | Lee | McAfee, Inc. | IPR2015-01856 | FWD Entered | |
| US-8544078-B2 | Cap Co Ltd | Cap Co Ltd | Lee | McAfee, Inc. | IPR2015-01856 | FWD Entered |
| US-8489837-B1 | Netlist Inc | Netlist Inc | Lee | SK hynix Inc. | IPR2017-00548 | Instituted |
| US-8923941-B2 | Valencell Inc | Valencell Inc | LeBoeuf et al | Apple Inc. | IPR2017-00319 | Instituted |
| US-2014171755-A1 | Valencell Inc | Valencell Inc | LeBoeuf et al | Apple Inc. | IPR2017-00319 | Instituted |
| US-8603514-B2 | MonoSol Rx LLC | MonoSol Rx LLC | Yang et al | Dr. Reddy’s Laboratories, Inc. | IPR2017-01582 | PO Response Filed |
| US-8603514-B2 | MonoSol Rx LLC | MonoSol Rx LLC | Yang et al | Mylan Technologies, Inc. | IPR2017-00200 | Terminated-Adverse Judgment |
| US-2008044454-A1 | MonoSol Rx LLC | MonoSol Rx LLC | Yang et al | Dr. Reddy’s Laboratories, Inc. | IPR2017-01582 | PO Response Filed |
| US-2008044454-A1 | MonoSol Rx LLC | MonoSol Rx LLC | Yang et al | Mylan Technologies, Inc. | IPR2017-00200 | Terminated-Adverse Judgment |
| US-6885055-B2 | KAIST IP US LLC | Lee | Samsung Electronics Co., Ltd. | IPR2017-01047 | Terminated-Denied | |
| US-2004150029-A1 | KAIST IP US LLC | Lee | Samsung Electronics Co., Ltd. | IPR2017-01047 | Terminated-Denied | |
| US-2005167891-A1 | Aspen Aerogels Inc | Aspen Aerogels Inc | Lee et al | Guangdong Alison Hi-Tech Co., Ltd. | IPR2016-01820 | Terminated-Denied |
| US-6989123-B2 | Aspen Aerogels Inc | Aspen Aerogels Inc | Lee et al | Guangdong Alison Hi-Tech Co., Ltd. | IPR2016-01820 | Terminated-Denied |
| US-5838551-A | Nortel Networks Ltd | RPX Clearinghouse LLC | Rockstar Consortium US LP | Google Inc. | IPR2015-00079 | Terminated-Denied |
| US-5862511-A | Magellan DIS Inc | BEACON NAVIGATION GmbH | Lee & Hayes PLLC | DENSO CORPORATION | IPR2013-00027 | Terminated-Denied |
| Rockwell Collins Inc | ||||||
| Meritor Light Vehicle Systems Inc |
Now, it is clear who the original patent owner was and who the current owner is.
IFI Legal Status
In addition to standardized assignee/applicant names, IFI’s Data Enrichments table provides a useful legal status indicator and calculated expiration date (for granted patents).
The query below pulls the legal status indicator and calculated expiration date and combines it with the public patents data table to show title (in all available languages).
SELECT IFI.publication_number AS IFI_pn,
IFI.legal_status AS IFI_legal_status,
IFI.anticipated_expiration AS IFI_anticipated_expiration, ttl.text
FROM `patents-public-data.patents.publications` AS Patents, UNNEST(title_localized) AS ttl
JOIN `civil-dolphin-136720.IFIDataEnrichments.IFIDataEnrichments` AS IFI
ON IFI.publication_number = Patents.publication_number
WHERE Patents.publication_number IN ("US-2014170753-A1",
"US-2015020223-A1",
"US-8795965-B2",
"EP-2489275-A1",
"EP-2325332-B1",
"CA-2973750-A1")
The result is:
| IFI_pn | IFI_legal_ status |
IFI_anticipated_ expiration |
text |
|---|---|---|---|
| US-8795965-B2 | Active | 20331212 | CRISPR-Cas component systems, methods and compositions for sequence manipulation |
| EP-2325332-B1 | Revoked | 20260825 | Use of CRISPR associated genes (CAS) |
| EP-2325332-B1 | Revoked | 20260825 | Verwendung der CRISPR assoziierten Gene (CAS) |
| EP-2325332-B1 | Revoked | 20260825 | Utilisation de genes associes à CRISPR (CAS) |
| US-2014170753-A1 | Granted | Crispr-cas systems and methods for altering expression of gene products | |
| CA-2973750-A1 | Pending | Procede de modification precise d’une plante via expression genique transitoire | |
| CA-2973750-A1 | Pending | A method for precise modification of plant via transient gene expression | |
| US-2015020223-A1 | Abandoned | Delivery, engineering and optimization of systems, methods and compositions for sequence manipulation and therapeutic applications | |
| EP-2489275-A1 | Granted | CRISPR Mutanten Phage | |
| EP-2489275-A1 | Granted | Phage mutants CRISPR | |
| EP-2489275-A1 | Granted | CRISPR escape phage mutants |
Expiration dates are only available for granted patents. For information on pricing for the IFI Data Enrichments dataset on BigQuery, please contact us at info@ificlaims.com.
