BigQuery Patent Data Enrichments

Get more out of BigQuery with specialized fields
Enriched patent data which provides accurate company names and legal status information is available as a paid table on BigQuery. This data will add new insights and confidence to your patent queries. This makes the Google Patents Public Datasets even more useful.  
 
Technical Support is available to subscribers of IFI’s Patent Data Enrichments on BigQuery. 
 
Data enrichments are available for the following authorities:
  • Canada (CA)
  • England (GB)
  • European Patent Register (EP)
  • France (FR)
  • Germany (DE)
  • Japan (JP)
  • Spain (ES)
  • United States (US)
Contact us for information on subscribing to IFI Patent Data Enrichments on BigQuery.

Data Enrichments on BigQuery Dataset

publication_number STRING NULLABLE Patent publication number (DOCDB compatible), eg: 'US-7650331-B1'
country_code STRING NULLABLE Country code, eg: 'US', 'EP', etc
legal_status STRING NULLABLE IFI Patent Status Indicator, eg: “Active”, “Pending”
adjusted_expiration INTEGER NULLABLE Adjusted expiration date contains a date calculated to reflect term adjustments made by the USPTO under 35 USC 154.  US only.
anticipated_expiration INTEGER NULLABLE Calculated according to the patenting authority and document kind and reflects the maximum life of the patent assuming maintenance fees are paid and term extensions are not in place.
term_extension STRING NULLABLE Present for US only. This field contains the number of days the term has been adjusted due to USPTO and FDA extensions and adjustments.
regulatory_extension BOOLEAN NULLABLE "Yes" when true. The field appears in US records when exploitation of a patent is delayed by regulatory review (e.g., FDA review) or in other patents when a Supplementary Protection Certificate (SPC) has been issued for a patent.
current_assignee STRING REPEATED The IFI standardized form of the current assignee, determined from reassignments from the patent authorities.
original_assignee STRING REPEATED The IFI standardized form of the applicant/assignee at the time the document was published.
legal_events RECORD REPEATED Legal status events, covering a variety of entries, procedural steps, and post-grant events.
legal_events.name STRING NULLABLE Description of the legal status code.
legal_events.code STRING NULLABLE 1-4 character code.
legal_events.country STRING NULLABLE Country is represented by a standard 2-character code.
legal_events.date INTEGER NULLABLE Date of public notification.
legal_events.attributes RECORD REPEATED  
legal_events.attributes.label STRING NULLABLE Description of the legal status code.
legal_events.attributes.value STRING NULLABLE Legal status event description.

Sample Record

 
publication_number US-8481910-B2
legal_status Expired - Lifetime
adjusted_expiration 0
anticipated_expiration 20160325
term_extension  
regulatory_extension FALSE
current_assignee Magna Electronics Inc
original_assignee Donnelly Corp
legal_events  
 
 
legal
events.name
legal
events.code
legal_
events.
country
legal_
events.date
legal_events.
attributes.label
legal_events.attributes.value
Assignment AS US 20130530 Owner name MAGNA MIRRORS OF AMERICA, INC., MICHIGAN
        Free format text CHANGE OF NAME;ASSIGNOR:MAGNA DONNELLY CORPORATION;REEL/FRAME:030515/0197
        Effective date 20080814
        Owner name MAGNA ELECTRONICS INC., MICHIGAN
        Free format text ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MAGNA MIRRORS OF AMERICA, INC.;REEL/FRAME:030515/0228
        Effective date 20130530
        Owner name MAGNA DONNELLY CORPORATION, MICHIGAN
        Free format text CHANGE OF NAME;ASSIGNOR:DONNELLY CORPORATION;REEL/FRAME:030515/0148
        Effective date 20030113
        Owner name DONNELLY CORPORATION, MICHIGAN
        Free format text ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:SCHOFIELD, KENNETH;LARSON, MARK L.;VADAS, KEITH J.;REEL/FRAME:030514/0950
        Effective date 19960322
Certificate of correction CC US 20131126    
Maintenance fee reminder mailed REMI US 20170217    
Lapse for failure to pay maintenance fees LAPS US 20170709