Pre-Grant Data Download Dictionary

The pre-grant publications data includes all publications released by the USPTO for download from 2001 through the most recent data update.

pg_granted_pgpubs_crosswalk	Table mapping patent application's to their corresponding granted patent numbers
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20100273145	all	bigint(16)
patent_id	patent number	9134302	all	varchar(20)
application_id	application number	8479995	all	varchar(16)
current_pgpub_id_flag	Flag indicating whether this row contains the most recent pgpub_id for a given application (TRUE = This pgpub_id refers to the most recent publication of this application; FALSE = This application has been re-published or corrected in a more recent publication)	TRUE	all	boolean
current_patent_id_flag	Flag indicating whether this row contains the most recent patent_id for a given application (TRUE = This patent_id refers to the most recent patent granted to this application; FALSE = This patent has been withdrawn and re-issued under a more recent patent_id)	FALSE	all	boolean

pg_applicant_not_disambiguated	US party and applicant information as it appears in the source XML files
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20200075150	all	bigint(16)
applicant_sequence	order in which the party/applicant appears in the source XML file; sequence for this table begins at {1}.	3	all	int(11)
applicant_authority	The type of interest the applicant has in the intellectual property rights of a patent or application. May be equal to inventor, legal-representative, party-of-interest, obligated-assignee, assignee, or null.	legal-representative	2005-present	varchar(30)
raw_applicant_name_first	first name of the party/applicant, if an individual	Janet	all	varchar(256)
raw_applicant_name_last	last name of the party/applicant, if an individual	McCallister	all	varchar(256)
raw_applicant_organization	organization of the party/applicant, if applicable	FUJIFILM Corporation	all	varchar(256)
applicant_type	type of the party/applicant	applicant	all	varchar(64)
applicant_designation	designation of the party/applicant	us-only	all	varchar(32)
rawlocation_id	parties' unique location id	0000c51a-0d76-11eb-a344-121df0c29c1e	all	varchar(128)

pg_assignee_disambiguated	Disambiguated assignee data. Methodology description can be found here
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20080163497	all	bigint(16)
assignee_sequence	order in which assignee appears in patent file; sequence for this table begins at {1}.	1	all	int(11)
assignee_id	unique assignee ID generated by the disambiguation algorithm	000009fd-0268-46a4-b493-c8e5f7672331	all	varchar(64)
disambig_assignee_individual_name_first	first name, if assignee is individual	Douglas Norman	all	varchar(256)
disambig_assignee_individual_name_last	last name, if assignee is individual	Hartz	all	varchar(256)
disambig_assignee_organization	organization name if assignee is organization	BIC-Violex SA	all	varchar(256)
assignee_type	assignee type (1- Unassigned, 2 - US Company or Corporation, 3 - Foreign Company or Corporation, 4 - US Individual, 5 - Foreign Individual, 6 - US Federal Government, 7 - Foreign Government, 8 - US County Government, 9 - US State Government. Note: A "1" appearing before any of these codes signifies part interest)	4	2002 and after	int(11)
location_id	assignee's location. If the assignee's sequence number is 1, then his/her location is the "location" of the related patent	78b9e85a-3bc6-11eb-a3cd-121df0c29c1e	all	varchar(128)

pg_assignee_not_disambiguated	Raw assignee information as it appears in the source XML files
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20080163497	all	bigint(16)
assignee_sequence	order in which assignee appears in patent file; sequence for this table begins at {1}.	1	all	int(11)
assignee_id	unique assignee ID generated by the disambiguation algorithm	000009fd-0268-46a4-b493-c8e5f7672331	all	varchar(64)
raw_assignee_individual_name_first	first name, if assignee is individual	Douglas Norman	all	varchar(256)
raw_assignee_individual_name_last	last name, if assignee is individual	Hartz	all	varchar(256)
raw_assignee_organization	organization name if assignee is organization	BIC-Violex SA	all	varchar(256)
assignee_type	assignee type (1- Unassigned, 2 - US Company or Corporation, 3 - Foreign Company or Corporation, 4 - US Individual, 5 - Foreign Individual, 6 - US Federal Government, 7 - Foreign Government, 8 - US County Government, 9 - US State Government. Note: A "1" appearing before any of these codes signifies part interest)	4	2002 and after	int(11)
rawlocation_id	assignee's location. If the assignee's sequence number is 1, then his/her location is the "location" of the related patent	78b9e85a-3bc6-11eb-a3cd-121df0c29c1e	all	varchar(128)

pg_brf_sum_text_{year}	Text of application summary for a given year
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20050011018	all	bigint(16)
summary_text	text of the summary itself	The present disclosure is directed ..	all	mediumtext

pg_claims_{year}	Full text of application claims, including dependency and sequence
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20050010988	all	bigint(16)
claim_sequence	order in which claims appear in patent file; sequence for this table begins at {1}.	2	all	int(11)
claim_text	claim text	2 . A garment according to claim 1 , wherein: …	all	mediumtext
dependent	sequence number of claim this is dependent on. NULL if independent	claim 1	all	varchar(512)
claim_number	contains claim number of claim formatted as 0-prefixed 5 digit number	00002	all	varchar(128)

pg_cpc_at_issue	CPC classification at the time the application was submitted
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20170047568	all	bigint(16)
cpc_sequence	order in which the CPC classifications occur in the raw XML file; sequence for this table begins at {1}.	14	all except 2005	int(11)
cpc_version_indicator	date corresponding to the version under which the classification was made	2013-01-01	all	date
cpc_section	CPC section (A = Human Necessities, B = Performing Operations; Transporting, C = Chemistry; Metallurgy, D = Textiles; Paper, E = Fixed Constructions, F = Mechanical Engineering; Lighting; Heating; Weapons; Blasting Engines or Pumps, G = Physics, H = Electricity, Y = General Tagging of New Technological Developments)	B	all except 2005	varchar(16)
cpc_class	CPC section id plus CPC class value	B65	all	varchar(16)
cpc_subclass	CPC group id: https://www.uspto.gov/web/patents/classification/cpc/html/cpc.html	B65H	all	varchar(16)
cpc_group	CPC subgroup id: https://www.uspto.gov/web/patents/classification/cpc/html/cpc.html	B65H35/06	all	varchar(16)
cpc_type	Category of CPC classification "Inventional" or "Additional"	Inventional	all	varchar(16)
cpc_action_date	Date corresponding to the approval of the CPC classification	2017-02-16	all	date

pg_cpc_current	Current CPC classification of the application
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20190113923	all	bigint(16)
cpc_sequence	order in which the CPC classifications occur in the raw XML file; sequence for this table begins at 0.	27	all	int(11)
cpc_version_indicator	date corresponding to the version under which the classification was made	2013-01-01	all	date
cpc_section	CPC section (A = Human Necessities, B = Performing Operations; Transporting, C = Chemistry; Metallurgy, D = Textiles; Paper, E = Fixed Constructions, F = Mechanical Engineering; Lighting; Heating; Weapons; Blasting Engines or Pumps, G = Physics, H = Electricity, Y = General Tagging of New Technological Developments)	Y	all	varchar(16)
cpc_class	CPC section id plus CPC class value	Y02	all	varchar(16)
cpc_subclass	CPC group id: https://www.uspto.gov/web/patents/classification/cpc/html/cpc.html	Y02T	all	varchar(16)
cpc_group	CPC subgroup id: https://www.uspto.gov/web/patents/classification/cpc/html/cpc.html	Y02T10/7291	all	varchar(16)
cpc_type	Category of CPC classification "Inventional" or "Additional"	additional	all	varchar(16)

pg_cpc_title	CPC group classification at issue of the patent
Data Element Name	Definition	Example	Years Present	Type
cpc_subclass	CPC group id	A01B	all	varchar(20)
cpc_subclass_title	description of CPC group	SOIL WORKING IN AGRICULTURE OR FORESTRY;	all	varchar(512)
cpc_group	CPC subgroup id	A01B1/00	all	varchar(20)
cpc_group_title	description of CPC subgroup	Hand tools	all	mediumtext
cpc_class	CPC subsection id	A01	all	varchar(20)
cpc_class_title	description of CPC subsection	AGRICULTURE; FORESTRY; ANIMAL HUSBANDRY; HUNTING; TRAPPING; FISHING	all	varchar(512)

pg_detail_desc_text_{year}	Text of detailed description of application for a given year
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20080000006	all	bigint(16)
description_text	full text of the detailed description	This view also illustrates optional shoulder…	all	longtext
description_length	length of the text field	72825	all	bigint(16)

pg_draw_desc_text_{year}	Text of description of the application's drawings
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20150007372	all	bigint(16)
draw_desc_sequence	order in which drawing descriptions appear in application file, often the same as the figure id; sequence for this table begins at {1}.	15	all	int(11)
draw_desc_text	text of the drawing descriptions	FIG. 22 is a simplified enlarged view…	all	mediumtext

pg_foreign_priority	Information about an earlier patent filing in a foreign country which gives the claim priority
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20110296671	all	bigint(16)
priority_claim_sequence	order in which priority claims appear in publication; sequence for this table begins at {1}	1	all	int(11)
priority_claim_kind	type of priority claim (international, national, regional)	national	2005 and after	varchar(20)
foreign_application_id	foreign patent application number	93114223	all	varchar(256)
filing_date	date on which the foreign document was filed	2004-05-20	2002 and after	date
foreign_country_filed	country in which the foreign document was filed	TW	all	varchar(256)

pg_gov_interest	Mapping of patent numbers to raw government interest text
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20100273145	all	bigint(16)
gi_statement	raw government interest text	The invention herein described was made in the course of work under a grant or award from the U.S. Army.	all	mediumtext

pg_gov_interest_contracts	Mapping of Federal contract award numbers to patent numbers
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	patent number	3931132	all	varchar(20)
contract_award_number	federal contract award number	83-568 73	all	varchar(255)

pg_gov_interest_org	Federal agencies with government interests in patents
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	patent number	8636942	all	varchar(255)
gi_organization_id	unique organization id	1	all	int(11)
fedagency_name	name of Federal department, agency, bureau, etc.	Department of Veterans Affairs	all	varchar(255)
level_one	position of the focal agency in a hierarchical set of relationships with the parent agency (e.g., DHHS) at level_one and child agencies at lower levels (e.g., NIH at level_two and NIDA at level_three). government_organization.name is equal to one and only one of the values in level_one, level_two, and level_three	Department of Veterans Affairs	all	varchar(255)
level_two	position of the focal agency in a hierarchical set of relationships with the parent agency (e.g., DHHS) at level_one and child agencies at lower levels (e.g., NIH at level_two and NIDA at level_three). government_organization.name is equal to one and only one of the values in level_one, level_two, and level_three	U.S. Census Bureau	all	varchar(255)
level_three	position of the focal agency in a hierarchical set of relationships with the parent agency (e.g., DHHS) at level_one and child agencies at lower levels (e.g., NIH at level_two and NIDA at level_three). government_organization.name is equal to one and only one of the values in level_one, level_two, and level_three	Advanced Technology Program	all	varchar(255)

pg_inventor_disambiguated	Disambiguated inventor data. Methodology description can be found here
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20150287775	all	bigint(16)
inventor_sequence	order in which the inventor appears in patent file; sequence for this table begins at {0}.	2	all	int(11)
inventor_id	unique inventor id generated by the disambiguation algorithm	fl:n_ln:benichou-1	all	varchar(64)
disambig_inventor_name_first	first name of the inventor	Shigeharu	all	varchar(256)
disambig_inventor_name_last	last name of the inventor	Yamagami	all	varchar(256)
gender_code	inventor attributed gender (F = female, M = male, U = no gender attributed)	U	all	varchar(1)
location_id	inventor's location. If the inventor's sequence number is 0, then his/her location is the "location" of the related patent	00000249-bdce-11ea-8a73-121df0c29c1e	all	varchar(128)

pg_inventor_not_disambiguated	Raw inventor information as it appears in the source XML files
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20150287775	all	bigint(16)
inventor_sequence	order in which the inventor appears in patent file; sequence for this table begins at {0}.	2	all	int(11)
inventor_id	unique inventor id generated by the disambiguation algorithm	fl:n_ln:benichou-1	all	varchar(64)
raw_inventor_name_first	first name of the inventor	Shigeharu	all	varchar(256)
raw_inventor_name_last	last name of the inventor	Yamagami	all	varchar(256)
deceased_flag	flag determining whether the inventor is deceased or not	FALSE	all	boolean
rawlocation_id	inventor's location. If the inventor's sequence number is 0, then his/her location is the "location" of the related patent	00000249-bdce-11ea-8a73-121df0c29c1e	all	varchar(128)

pg_ipc_at_issue	International Patent Classification
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	patent number	20080166814	all except 2005	varchar(20)
ipc_sequence	order in which IPC class appears in patent file; sequence for this table begins at {1}.	2	all except 2005	int(11)
classification_level	IPC classification level (A = advanced level)	A	2006 and after	varchar(256)
section	IPC section (A = Human Necessities, B = Performing Operations; Transporting, C = Chemistry; Metallurgy, D = Textiles; Paper, E = Fixed Constructions, F = Mechanical Engineering; Lighting; Heating; Weapons; Blasting, G = Physics, H = Electricity)	G	all except 2005	varchar(256)
ipc_class	IPC class	01	all except 2005	varchar(256)
subclass	IPC subclass	N	all except 2005	varchar(256)
main_group	IPC group	33	all except 2005	varchar(256)
subgroup	IPC subgroup	00	all except 2005	varchar(256)
classification_value	IPC classification value ( I = invention information; N = non-invention information)	I	2006 and after	varchar(256)
classification_status	IPC classification status ( B = Basic or Original)	B	2006 and after	varchar(256)
classification_data_source	IPC classification data source ( H = Human - Generated; M = Machine - Generated; G = Generated via Software)	H	all except 2005	varchar(256)
action_date	issue date of the patent grant	2008-07-10	2006 and after	date
ipc_version_indicator	IPC version indicator	2006-01-01	2006 and after	date

pg_location_disambiguated	Disambiguated location data for inventors, assignees, and applicants
Data Element Name	Definition	Example	Years Present	Type
location_id	unique location id generated by the disambiguation algorithm	0009wn7out97	all	varchar(128)
disambig_city	city associated with a location_id	Stewart	all	varchar(128)
disambig_state	state associated with a location_id	MN	all	varchar(20)
disambig_country	country associated with a location_id	US	all	varchar(16)
latitude	latitude for location_id	44.7247	all	float
longitude	longitude for location_id	-94.4858	all	float
county	county associated with location_id	Mcleod	all	varchar(60)
state_fips	state FIPS code associated with a location_id	27	all	varchar(2)
county_fips	county FIPS code associated with a location_id	85	all	varchar(6)

pg_location_not_disambiguated	Raw location information as it appears in the source XML files
Data Element Name	Definition	Example	Years Present	Type
rawlocation_id	unique id	000035ewn5fb3oerojqwcw4hg	all	varchar(128)
location_id	unique location id generated by the disambiguation algorithm	q6d41gon4fey	all	varchar(128)
raw_city	city associated with a location_id	Colorado Springs	all	varchar(128)
raw_state	state associated with a location_id	CO	all	varchar(20)
raw_country	country associated with a location_id	US	all	varchar(10)

pg_pct_data	PCT or regional filing data
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20080163436	all	varchar(20)
published_or_filed_date	date published or filed	2005-11-21	all	date
pct_371_date	PCT Section 371(c)(1)(2)(4)date, date when pct application was filed	2007-07-16	all	date
pct_102_date	35 U.S.C. § 102(e) date for pct applications	2015-08-11	2001 and after	date
filed_country	country filed in	WO	2002 and after	varchar(256)
application_kind	kind of application (numerical for filed, alphabetical for published)	00	2002 and after	varchar(20)
pct_doc_number	pct document number	PCT/EP2005/056103	all	varchar(128)
pct_doc_type	whether the document has been published or just filed	pct_application	2002 and after	varchar(20)

pg_persistent_assignee	Disambiguated Assignee ID across data updates
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20060263593	all	bigint(16)
disamb_assignee_id_xxxxxxxx	the disambiguated assignee ids associated with the raw assignee on a given pgpub document with the given sequence during the data updates matching the date stamps in the field names. Data on this table goes back to the 20201229 update.	000009fd-0268-46a4-b493-c8e5f7672331	all	varchar(64)
assignee_sequence	order in which assignee appears in application file; sequence for this table begins at {1}.	2	all	int(11)

pg_persistent_inventor	Disambiguated Inventor ID across data updates
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20060263593	all	bigint(16)
disamb_inventor_id_xxxxxxxx	the disambiguated inventor ids associated with the raw inventor on a given pgpub document with the given sequence during the data updates matching the date stamps in the field names. Data on this table goes back to the 20210330 update.	fl:n_ln:benichou-1	all	varchar(64)
inventor_sequence	order in which inventor appears in application file; sequence for this table begins at {0}.	3	all	int(11)

pg_published_application	Data concerning pre-granted patent applications
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20100071101	all	bigint(16)
application_id	unique application identifying number	12283848	all	varchar(16)
filing_date	date of application filing	2008-09-15	all	date
patent_type	category of application ('utility' or 'plant')	plant	all	varchar(20)
filing_type	type of publication filing	us-republication-corrected	all	varchar(128)
published_date	date of publication	2014-07-31	all	date
wipo_kind	kind code of publication: https://www.uspto.gov/learning-and-resources/support-centers/electronic-business-center/kind-codes-included-uspto-patent	A9	all	varchar(8)
series_code	unique application identifying number	12	all	int(11)
application_title	title of application	Japanese maple plant named 'King's Blood'	all	mediumtext
rule_47_flag	flag for inventor who was unable to be contacted at filing of application	FALSE	all	varchar(8)
filename	name of XML file from which the data was parsed	ipa100318.xml	all	varchar(16)

pg_rel_app_text	Description of related patent applications
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20200053967	all	bigint(16)
rel_app_text	text of the description of the related application in question	This application claims the benefit …	all	mediumtext

pg_published_application_abstract	Data concerning abstracts of pre-granted patent applications
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20100071101	all	bigint(16)
application_abstract	abstract of application	A new and distinct cultivar of Japanese …	all	mediumtext

pg_us_rel_doc	US Related Documents for patent applications
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	patent number	9683848	2005 and after	varchar(20)
related_doc_type	defines the type of documentation	continuation-in-part	2005 and after	varchar(64)
related_doc_kind	kind of document (text)	parent document	2005 and after	varchar(64)
related_doc_number	related document number	13336060	2005 and after	varchar(64)
published_country	country where related document was published	US	2005 and after	varchar(20)
related_doc_published_date	publication date of the related document	12/23/2011	2005 and after	date
related_doc_sequence	order in which the related document appears in patent file; sequence for this table begins at {1}.	36	2005 and after	int(11)

pg_uspc_at_issue	USPTO patent classification at patent issue date
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	20060263593	all (incomplete for 2002-2004)	bigint(16)
uspc_sequence	order in which uspc class appears in patent file; sequence for this table begins at {1}.	7	all (incomplete for 2002-2004)	int(11)
uspc_mainclass_id	uspc mainclass at issue	313	all (incomplete for 2002-2004)	varchar(16)
uspc_mainclass_title	description of uspc mainclass	PRESSES	all (incomplete for 2002-2004)	varchar(256)
uspc_subclass_id	uspc subclass at issue	313/116000	all (incomplete for 2002-2004)	varchar(16)
uspc_subclass_title	description of uspc subclass	BINDING264	all (incomplete for 2002-2004)	varchar(512)

pg_wipo_technology	WIPO technology classification of the patent
Data Element Name	Definition	Example	Years Present	Type
pgpub_id	document number	3930271	all	varchar(20)
wipo_field_sequence	order in which WIPO technology field appears on patent; sequence for this table begins at {0}.	0	all	bigint(20)
wipo_field_id	WIPO technology field id as derived from crosswalk http://www.wipo.int/export/sites/www/ipstats/en/statistics/patents/xls/ipc_technology.xls	33	all	double
wipo_sector_title	WIPO technology sector title	Electrical engineering	all	varchar(60)
wipo_field_title	WIPO technology field title	Electrical machinery, apparatus, energy	all	varchar(255)

Pre-Grant Data Download Dictionary

Contact Us

Terms of Use