USPTO Patent Litigation Data

Revision as of 13:41, 21 September 2020 by Ed (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

USPTO Patent Litigation Data
Project logo 02.png
Project Information
Has title USPTO Patent Litigation Data
Has owner Ed Egan
Has start date May 2017
Has deadline date
Has keywords Patent, USPTO, Litigation, Data
Has project status Tabled
Dependent(s): Patent Design Main Page
Has sponsor McNair Center
Has project output Data
Copyright © 2019 All Rights Reserved.

Getting the data

The data is available from, which is linked directly from

The data comes in .dta (STATA) and .csv formats. We took the .csv files:	29751808	2016-12-29 07:44	3085347	2016-12-29 07:45	244399591	2016-12-29 07:46	7256777	2016-12-29 07:48	2453937	2016-12-29 07:48	286947372	2016-12-29 07:45 appears to contain the five other files!

The files are in E:\McNair\PatentData\Litigation\Raw Data

Quick Review

File Tops (5 lines)


1,0:79-cv-06704-JCP,1,Plaintiff,1,Burroghs Wellcome Co.
1,0:79-cv-06704-JCP,2,Defendant,2,Generix Drug Corp.
3,0:83-cv-06860-JAG,3,Plaintiff,3,Kenneth R. Cornwall
3,0:83-cv-06860-JAG,4,Defendant,4,"U. S. COnstruction Manufacturing, Inc."


14,0:92-cv-00398-MJP,40,Plaintiff ,1,"Joel Wyman Collins , Jr","Collins and Lacy; PO Box 12487; Columbia, SC 29211; 803-256-2660; Fax: 
14,0:92-cv-00398-MJP,41,Plaintiff ,2,"Joel Wyman Collins , Jr",(See above for address),LEAD ATTORNEY; ATTORNEY TO BE NOTICED


54973,01-Jan-1970,223949,"ASTRAZENECA AB et al v. SANDOZ, INC.",UNITED STATES DISTRICT COURT DISTRICT OF NEW JERSEY,Judge Joel A. Pisano,Magistrate Judge Tonianne J. Bongiovanni,35:271 Patent Infringement,Federal Question,,,,,,2009-01-14,2011-06-02,
427,0:00-cv-00019,1338,Banner Engineering v. Harris Instrument,UNITED STATES DISTRICT COURT DISTRICT OF MINNESOTA,,,,,,,,,,2000-01-04,2000-03-09,2000-03-02
428,0:00-cv-00058,1377,"Advanced UroScience, et al v. Inamed Corporation, et al",UNITED STATES DISTRICT COURT DISTRICT OF MINNESOTA,,,,,,,,,,2000-01-11,2000-11-30,2001-02-28
429,0:00-cv-00172-DWF-AJB,,Farnam Companies Inc v. Miller Manufacturing,U.S. District of Minnesota (DMN),Judge Donovan W. Frank,Chief Mag. Judge Arthur J. Boylan,35:271 Patent Infringement,Federal Question,,,0:98-cv-00040-DWF-AJB,"Dist of AZ, 99-01804",,,,


1,0:79-cv-06704-JCP,1,,2000-08-03,"COPY OF PAPER DOCKET SHEET (kw, Deputy Clerk) (Entered: 08/03/2000)",37,,
1,0:79-cv-06704-JCP,2,,1982-05-31,"CASE CLOSED. Case and Motions no longer referred to Magistrate. (kw, Deputy Clerk) (Entered: 08/03/2000)",,,
3,0:83-cv-06860-JAG,1,,2004-02-13,COPY OF PAPER DOCKET SHEET (Former Deputy Clerk) (Entered: 02/13/2004),123,,
3,0:83-cv-06860-JAG,2,,1992-03-01,Case closed (Former Deputy Clerk) (Entered: 03/05/1992),,,


"Davis v. Favelle Favco Cranes, et al",txsd,Texas Southern District Court,08/13/2001,1:2000-cv-00003,3,2000-01-03
Monsanto v. Sierks et al,ned,Nebraska District Court,07/10/2002,4:2002-cv-00105,4,2002-03-04
"Armament Sys & Proc v. Coast Cutlery Co Inc, et al",wied,Wisconsin Eastern District Court,03/03/2008,1:2000-cv-01273,4,2000-09-20
Tektronix Inc. v. Integraph Corporation,ord,Oregon District Court,09/04/1998,3:1998-cv-00599,7,1998-07-09

File specs

pacer_cases.csv: 74,954 records
 case_name  varchar(255),
 court_code  varchar(10), --txsd, ned
 court_name  varchar(255),
 date_closed  date, --mm/dd/yyyy
 case_number  varchar(100), --e.g., 1:2000-cv-00003
 pacer_id   int, --appears to be int
 date_filed  date --yyyy-mm-dd
documents.csv  5,186,345 records
 case_row_id  int,
 case_number  varchar(100), --e.g. 0:79-cv-06704-JCP
 doc_count  int, 
 attachment  varchar(255), --NULL when seen
 date_filed  date, --yyyy-mm-dd
 long_description  text, 
 doc_number  int,
 short_description  varchar(255) --NULL when seen
 upload_date  date --NULL when seen
cases.csv: 74,630 records
 case_row_id  int,
 case_number  varchar(100), 
 pacer_id  int,
 case_name  text,
 court_name  text,
 assigned_to  varchar(255), --Often NULL. Examples Judge Joel A. Pisano
 referred_to  varchar(255), --Often NULL. Examples Magistrate Judge Tonianne J. Bongiovanni
 case_cause  varchar(255), --Often NULL. Examples: 35:271 Patent Infringement, 35:145 Patent Infringement, etc.
 jurisdictional_basis  varchar(255), --Often NULL. Examples: Federal Question
 demand  varchar(100), --appears to be one of NULL, plaintiff, defendant, both
 jury_demand  varchar(100),
 lead_case  varchar(100), --appears to be case_number
 related_case  text, --appears to be a mix of things in semicolon seperated list
 settlement text, --appears always NULL
 date_filed  date, --yyyy-mm-dd
 date_closed  date, --yyyy-mm-dd
 date_last_filed  date --yyyy-mm-dd
names.csv  561,019 records
 case_row_id  int,
 case_number  varchar(100),
 party_row_count  int, 
 party_type  varchar(20), --Plaintiff or Defendant
 name_row_count  int,
 name  varchar(255)
attorney.csv: 1,223,419 records
 case_row_id  int,
 case_number  varchar(100),
 party_row_count  int,
 party_type   varchar(20),  --Plaintiff or Defendant
 attorney_row_count  int,
 name  varchar(255),
 contactinfo  varchar(255), --semicolon seperated value
 position  varchar(255) --semicolon seperated list e.g., LEAD ATTORNEY; ATTORNEY TO BE NOTICED

Obvious Issues

There are no codified patent numbers and outcomes

Some patent numbers can be found in documents.long_description but it seems that this is the docket headers and most patents will likely be in the documents themselves (which we don't have and would have to OCR).

We might be able to piece together outcomes from documents.long_description but this is going to be very hard. Clearly, this is one of Lex Machina's value added.