This page includes assignee data from the USPTO(https://patentsview.org/download/data-download-tables). I have merged data from‘g_assignee_not_disambiguated’,‘g_location_not_disambiguated’, and‘g_location_disambiguated’.
Below is a link to a folder that includes all assignee data for patents granted from January 1976 through December 2023. This folder includes nine different zip files. For ease of download and ease of importing, files are divided by patent number. File“assignee_non_utility.tsv.zip” includes all non-utility patents. File“assignee_5m.tsv.zip” includes all patents issued beginning January 1976 through patent number 5,000,000. File“assignee_6m.tsv.zip” includes all patents between patent number 5,000,001 and patent number 6,000,000. Etc, etc.
Each file contains the following columns:
Variable
Description
patnum
Patent number
assignee_id
USPTO assignee identification
organization
Assignee
city
City of assignee
state
State of assignee
country
Country of assignee
disambig_city
City of assignee(from disambiguated file)
disambig_state
State of assignee(from disambiguated file)
disambig_country
Country of assignee(from disambiguated file)
latitude
Geographic coordinate
longitude
Geographic coordinate
county
County of assignee
state_fips
State FIPS code
county_fips
County FIPS code
type
Organization type
location_id
USPTO location identification
If you have any issues downloading the data, find any problems with the data, or have suggestions for how to make the data better/more user friendly, please let me know: mwoeppel@iu.edu.