Skip to main content
 
 
 
IN THIS SECTION

Data Download Tables

About Bulk Download Database Tables

PatentsView offers publicly accessible patent research data sets with detailed documentation. PatentsView database tables can be bulk downloaded as individual files in a tab- delimited format for programmers and researchers who prefer to work with the data in their native environments.

Table Name Description # of Rows Origin Data Last Updated
pregrant applications (PGPubs) Information on the published applications (PGPubs)   raw & disamb  
application
zip: 76.6 MiB, tsv: 417.9 MiB
Information on the applications for granted patent 7,811,937 raw October 8, 2021
assignee
zip: 18.5 MiB, tsv: 38.7 MiB
Disambiguated assignee data for granted patents and pre-granted applications 530,932 disamb October 8, 2021
botanic
zip: 624.5 KiB, tsv: 1.2 MiB
Botanic information for plant patents 17,756 raw October 8, 2021
brf_sum_text Brief summary text   raw  
claim Full text of patent claims, including dependency and sequence   raw  
cpc_current
zip: 1.5 GiB, tsv: 4.0 GiB
Current CPC classification data for all patents (applied retrospectively to all patents) 44,759,564 raw (from separate classification files) October 8, 2021
cpc_group
zip: 21.5 KiB, tsv: 67.8 KiB
Lookup table of current CPC groups 672 raw (from separate classification files) August 11, 2021
cpc_subgroup
zip: 5.4 MiB, tsv: 61.1 MiB
Lookup table of current CPC subgroups 260,874 raw (from separate classification files) August 11, 2021
cpc_subsection
zip: 3.2 KiB, tsv: 7.9 KiB
Lookup table of current CPC subsections 136 raw (from separate classification files) August 11, 2021
detail_desc_text Detailed patent description text   raw  
draw_desc_text Drawing description text   raw  
foreign_priority
zip: 124.9 MiB, tsv: 298.6 MiB
Foreign priority data 3,627,790 raw October 8, 2021
figures
zip: 167.5 MiB, tsv: 297.1 MiB
Number of figures and sheets 7,277,551 raw October 8, 2021
foreigncitation
zip: 1.1 GiB, tsv: 2.7 GiB
Citations made to foreign patents by US patents 32,416,755 raw October 8, 2021
government_interest
zip: 4.9 MiB, tsv: 35.0 MiB
Raw government interest statements on all patents (where available) 157,250 raw October 8, 2021
government_organization
zip: 5.9 KiB, tsv: 34.1 KiB
Organization names and related agency hierarchy parsed from the government interest statements on all patents (where available) 297 processed August 11, 2021
inventor
zip: 44.2 MiB, tsv: 203.1 MiB
Disambiguated inventor data for granted patents and pre-granted applications 4,441,241 disamb October 8, 2021
ipcr
zip: 616.5 MiB, tsv: 1.8 GiB
International Patent Classification data for all patents (as of publication date)

18,742,586

raw October 8, 2021
lawyer
zip: 5.9 MiB, tsv: 12.8 MiB
Disambiguated lawyer data 184,336 disamb October 8, 2021
location
zip: 5.2 MiB, tsv: 19.3 MiB
Disambiguated location data, including latitude and longitude for granted patents and pre-granted applications 242,927 disamb October 8, 2021
mainclass
zip: 2.4 KiB, tsv: 7.1 KiB
Lookup table of original USPC main classes (as of patent publication date) 1,239 raw August 11, 2021
mainclass_current
zip: 7.5 KiB, tsv: 21.5 KiB
Lookup table of current USPC main technology classes (applied retrospectively to all patents) 510 raw (from separate classification files) August 11, 2021
nber zip: 115.3 MiB, tsv: 228.9 MiB NBER classification data for all patents up to May 2015 5,105,937 raw (from separate classification files) August 11, 2021
nber_category zip: 222.0 B, tsv: 113.0 B Lookup table for NBER categories 7 raw (from separate classification files) August 11, 2021
nber_subcategory
zip: 625.0 B, tsv: 928.0 B
Lookup table for NBER subcategories 38 raw (from separate classification files) August 11, 2021
non_inventor_applicant
zip: 246.3 MiB, tsv: 525.1 MiB
Non-inventor applicant information 4,654,078 raw October 8, 2021
otherreference
zip: 3.8 GiB, tsv: 7.9 GiB
Non-patent citations mentioned in patents (e.g. articles, papers, etc.) 46,746,523 raw October 8, 2021
patent
zip: 1.5 GiB, tsv: 5.7 GiB
Data on granted patents 7,814,196 raw October 8, 2021
patent_assignee
zip: 143.0 MiB, tsv: 601.8 MiB
Metadata table for many-to-many relationships 7,162,272 disamb (linking table) October 8, 2021
patent_contractawardnumber
zip: 1.4 MiB, tsv: 4.6 MiB
Contract or award numbers parsed from the government interest statements on all patents (where available) 189,739 processed October 8, 2021
patent_govintorg
zip: 641.9 KiB, tsv: 2.4 MiB
Metadata table with patent-to-organization relationships linked to the government_organization table 192,430 processed October 8, 2021
patent_inventor
zip: 251.4 MiB, tsv: 1.2 GiB
Metadata table for many-to-many relationships 19,111,181 disamb (linking table) October 8, 2021
patent_lawyer
zip: 122.1 MiB, tsv: 383.3 MiB
Metadata table for many-to-many relationships 8,900,746 disamb (linking table) October 8, 2021
pct_data
zip: 57.2 MiB, tsv: 162.3 MiB
PCT data 1,628,760 raw October 8, 2021
persistent_assignee_disambig
zip: 1.1 GiB, tsv: 2.0 GiB

Persistent Assignee Disambiguation
Updated to include missing values in the disamb_assignee_id_20201229 column field.

7,121,431 raw October 8, 2021
persistent_inventor_disambig
zip: 536.2 MiB, tsv: 2.8 GiB
Persistent Inventor Disambiguation 18,273,330 raw October 8, 2021
rawassignee
zip: 515.5 MiB, tsv: 997.2 MiB
Raw assignee information as it appears in the source text and XML files 7,162,272 raw October 8, 2021
rawexaminer
zip: 347.0 MiB, tsv: 745.5 MiB
Raw examiner information 10,548,816 raw October 8, 2021
rawinventor
zip: 1.1 GiB, tsv: 2.2 GiB
Raw inventor information as it appears in the source text and XML files 19,111,181 raw October 8, 2021
rawgender
zip: 42.7 MiB, tsv: 188.4 MiB
Gender assignment on disambiguated inventor data through March 30, 2021. Methods Report

4,305,415

raw April 14, 2020
rawlawyer
zip: 461.9 MiB, tsv: 934.7 MiB
Raw lawyer information as it appears in the source text and XML files 8,861,121 raw October 8, 2021
rawlocation
zip: 1.0 GiB, tsv: 3.0 GiB
Raw location data for inventors and assignees, as it appears in xml and text source files 30,950,739 raw October 8, 2021
rel_app_text
zip: 219.1 MiB, tsv: 938.5 MiB
Related applications text 2,076,786 raw October 8, 2021
subclass
zip: 599.4 KiB, tsv: 2.6 MiB
Lookup table of original USPC subclasses (as of patent publication date) 272,541 raw October 8, 2021
subclass_current
zip: 2.1 MiB, tsv: 7.3 MiB
Lookup table of current USPC subclasses (applied retrospectively to all patents) 168,048 raw (from separate classification files) August 11, 2021
us_term_of_grant
zip: 93.4 MiB, tsv: 220.8 MiB
U.S. term of grant data 3,862,834 raw October 8, 2021
usapplicationcitation
zip: 2.0 GiB, tsv: 5.8 GiB
Citations made to US patent applications by US patents 48,925,191 raw October 8, 2021
uspatentcitation
zip: 4.4 GiB, tsv: 11.4 GiB
Citations made to US granted patents by US patents 119,174,918 raw October 8, 2021
uspc
zip: 490.5 MiB, tsv: 963.6 MiB
USPC classification data for all patents 18,061,361 raw October 8, 2021
uspc_current
zip: 619.0 MiB, tsv: 1.2 GiB
Current USPC classification data for all patents up to May 2015 22,852,958 raw (from separate classification files) August 11, 2021
usreldoc
zip: 400.4 MiB, tsv: 1.2 GiB
U.S. related documents (post-2005 patents only) 11,989,788 raw October 8, 2021
wipo
zip: 29.4 MiB, tsv: 166.8 MiB
WIPO technology fields for all patents 10,437,469 raw (from separate classification files) October 8, 2021
wipo_field
zip: 1.5 KiB, tsv: 3.7 KiB500 bytes
Lookup table of WIPO technology fields 70 raw (from separate classification files) August 11, 2021

The PatentsView database is created from the U.S. Patent and Trademark Office (USPTO) public bulk data releases available at https://developer.uspto.gov/data. These data releases provide information on published patent applications (since 2001) and granted patents (since 1976). The PatentsView database for patents is available for download upon request, MySQL dump. The PatentsView database for  published applications contains pre-grant publications (PGPub) of patent applications (see MPEP § 1120) and is available in the top row of data in the table above. At this time, the published applications database does not contain the earliest years (2001-2005) of data.

For more information, visit the Methods and Sources section of the website.

This work was created through a government contract funded by the Office of Chief Economist in the US Patent and Trademark Office. Users are free to use, share, or adapt the material for any purpose, subject to the standards of the Creative Commons Attribution 4.0 International License.

Attribution should be given to PatentsView (www.patentsview.org) for use, distribution, or derivative works.