About Bulk Download Database Tables
PatentsView offers publicly accessible patent and trademark 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: 74.2 MiB, tsv: 407.8 MiB |
Information on the applications for granted patent | 7,624,970 | raw | March 08, 2021 |
| assignee zip: 18.3 MiB, tsv: 38.2 MiB |
Disambiguated assignee data for granted patents and pre-granted applications | 522,220 | disamb | March 08, 2021 |
| botanic zip: 605.9 KiB, tsv: 1.2 MiB |
Botanic information for plant patents | 17,248 | raw | March 08, 2021 |
| brf_sum_text | Brief summary text | raw | ||
| claim | Full text of patent claims, including dependency and sequence | raw | ||
| cpc_current zip: 1.1 GiB, tsv: 3.2 GiB |
Current CPC classification data for all patents (applied retrospectively to all patents) | 42,698,187 | raw (from separate classification files) | March 08, 2021 |
| cpc_group zip: 21.5 KiB, tsv: 67.7 KiB |
Lookup table of current CPC groups | 672 | raw (from separate classification files) | March 08, 2021 |
| cpc_subgroup zip: 5.4 MiB, tsv: 60.5 MiB |
Lookup table of current CPC subgroups | 258,827 | raw (from separate classification files) | March 08, 2021 |
| cpc_subsection zip: 3.2 KiB, tsv: 7.9 KiB |
Lookup table of current CPC subsections | 136 | raw (from separate classification files) | March 08, 2021 |
| detail_desc_text | Detailed patent description text | raw | ||
| draw_desc_text | Drawing description text | raw | ||
| foreign_priority zip: 108.1 MiB, tsv: 291.5 MiB |
Foreign priority data | 3,545,545 | raw | March 08, 2021 |
| figures zip: 163.3 MiB, tsv: 289.5 MiB |
Number of figures and sheets | 7,095,762 | raw | March 08, 2021 |
| foreigncitation zip: 909.6 MiB, tsv: 2.6 GiB |
Citations made to foreign patents by US patents | 31,073,818 | raw | March 08, 2021 |
| government_interest zip: 4.8 MiB, tsv: 34.0 MiB |
Raw government interest statements on all patents (where available) | 153,424 | raw | March 08, 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 | March 08, 2021 |
| inventor zip: 43.2 MiB, tsv: 197.5 MiB |
Disambiguated inventor data for granted patents and pre-granted applications | 4,310,831 | disamb | April 14, 2021 |
| ipcr zip: 441.0 MiB, tsv: 1.7 GiB |
International Patent Classification data for all patents (as of publication date) |
17,852,153 |
raw | March 08, 2021 |
| lawyer zip: 5.6 MiB, tsv: 12.1 MiB |
Disambiguated lawyer data | 176,136 | disamb | March 08, 2021 |
| location zip: 8.5 MiB, tsv: 46.8 MiB |
Disambiguated location data, including latitude and longitude for granted patents and pre-granted applications | 532,373 | disamb | March 08, 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 | March 08, 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) | March 08, 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) | March 08, 2021 |
| nber_category zip: 208.0 B, tsv: 92.0 B | Lookup table for NBER categories | 6 | raw (from separate classification files) | March 08, 2021 |
| nber_subcategory zip: 611.0 B, tsv: 906.0 B |
Lookup table for NBER subcategories | 37 | raw (from separate classification files) | March 08, 2021 |
| non_inventor_applicant zip: 235.2 MiB, tsv: 500.9 MiB |
Non-inventor applicant information | 4,450,582 | raw | March 08, 2021 |
| otherreference zip: 2.8 GiB, tsv: 7.5 GiB |
Non-patent citations mentioned in patents (e.g. articles, papers, etc.) | 44,676,475 | raw | March 08, 2021 |
| patent zip: 1.5 GiB, tsv: 5.6 GiB |
Data on granted patents | 7,627,229 | raw | March 08, 2021 |
| patent_assignee zip: 140.2 MiB, tsv: 586.4 MiB |
Metadata table for many-to-many relationships | 6,980,559 | disamb (linking table) | March 08, 2021 |
| patent_contractawardnumber zip: 1.4 MiB, tsv: 4.4 MiB |
Contract or award numbers parsed from the government interest statements on all patents (where available) | 183,562 | processed | March 08, 2021 |
| patent_govintorg zip: 622.5 KiB, tsv: 2.3 MiB |
Metadata table with patent-to-organization relationships linked to the government_organization table | 186,382 | processed | March 08, 2021 |
| patent_inventor zip: 326.5 MiB, tsv: 1.2 GiB |
Metadata table for many-to-many relationships | 18,562,495 | disamb (linking table) | March 08, 2021 |
| patent_lawyer zip: 121.5 MiB, tsv: 407.6 MiB |
Metadata table for many-to-many relationships | 8,651,291 | disamb (linking table) | March 08, 2021 |
| pct_data zip: 54.8 MiB, tsv: 155.4 MiB |
PCT data | 1,560,186 | raw | March 08, 2021 |
| persistent_assignee_disambig zip: 912.7 MiB, tsv: 1.6 GiB |
Persistent Assignee Disambiguation | 6,883,162 | raw | March 08, 2021 |
| persistent_inventor_disambig zip: 684.6 MiB, tsv: 3.0 GiB |
Persistent Inventor Disambiguation | 18,273,330 | raw | March 08, 2021 |
| rawassignee zip: 503.9 MiB, tsv: 972.3 MiB |
Raw assignee information as it appears in the source text and XML files | 6,980,559 | raw | March 08, 2021 |
| rawexaminer zip: 339.2 MiB, tsv: 729.3 MiB |
Raw examiner information | 10,324,224 | raw | March 08, 2021 |
| rawinventor zip: 1.0 GiB, tsv: 2.1 GiB |
Raw inventor information as it appears in the source text and XML files | 18,562,495 | raw | March 08, 2021 |
| rawgender zip: 42.7 MiB, tsv: 188.4 MiB |
Gender assignment on disambiguated inventor data, performed 12-29-2020. Methods Report |
4,305,415 |
raw | April 14, 2020 |
| rawlawyer zip: 450.6 MiB, tsv: 912.7 MiB |
Raw lawyer information as it appears in the source text and XML files | 8,651,296 | raw | March 08, 2021 |
| rawlocation zip: 1003.0 MiB, tsv: 3.01 GiB |
Raw location data for inventors and assignees, as it appears in xml and text source files | 30,016,844 | raw | April 01, 2021 |
| rel_app_text zip: 211.9 MiB, tsv: 932.7 MiB |
Related applications text | 2,003,039 | raw | April 12, 2021 |
| subclass zip: 599.4 KiB, tsv: 2.6 MiB |
Lookup table of original USPC subclasses (as of patent publication date) | 272,530 | raw | March 08, 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) | March 08, 2021 |
| us_term_of_grant zip: 90.5 MiB, tsv: 213.5 MiB |
U.S. term of grant data | 3,741,909 | raw | March 08, 2021 |
| usapplicationcitation zip: 1.8 GiB, tsv: 5.4 GiB |
Citations made to US patent applications by US patents | 45,631,322 | raw | March 08, 2021 |
| uspatentcitation zip: 4.3 GiB, tsv: 11.0 GiB |
Citations made to US granted patents by US patents | 115,170,634 | raw | March 08, 2021 |
| uspc zip: 490.4 MiB, tsv: 963.3 MiB |
USPC classification data for all patents | 18,056,075 | raw | March 08, 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) | March 08, 2021 |
| usreldoc zip: 382.4 MiB, tsv: 1.1 GiB |
U.S. related documents (post-2005 patents only) | 11,453,519 | raw | March 08, 2021 |
| wipo zip: 26.2 MiB, tsv: 161.2 MiB |
WIPO technology fields for all patents | 10,103,071 | raw (from separate classification files) | March 08, 2021 |
| wipo_field zip: 1.5 KiB, tsv: 3.7 KiB500 bytes |
Lookup table of WIPO technology fields | 70 | raw (from separate classification files) | March 08, 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 or any of the disambiguation results.
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.