IFI Data on Google BigQuery Untangles the PTAB

  • Added
  • Author:
by Larry Cady

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


 
Edited