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 |
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.