USPTO Patent Litigation Data - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:46Z

Ed at 17:34, 21 September 2020

2020-09-21T17:34:22Z

Ed at 17:20, 20 September 2020

2020-09-20T17:20:18Z

Ed at 17:12, 20 September 2020

2020-09-20T17:12:30Z

MichelleH at 15:28, 31 October 2017

2017-10-31T15:28:32Z

Ed at 23:01, 30 May 2017

2017-05-30T23:01:36Z

Ed at 22:53, 30 May 2017

2017-05-30T22:53:55Z

Ed: Created page with "{{McNair Projects |Has title=USPTO Patent Litigation Data |Has owner=Ed Egan, |Has start date=May 2017 |Has keywords=Patent, USPTO, Litigation, Data |Has project status=Active }}"

2017-05-30T22:09:29Z

Created page with "{{McNair Projects |Has title=USPTO Patent Litigation Data |Has owner=Ed Egan, |Has start date=May 2017 |Has keywords=Patent, USPTO, Litigation, Data |Has project status=Active }}"

New page

{{McNair Projects
|Has title=USPTO Patent Litigation Data
|Has owner=Ed Egan,
|Has start date=May 2017
|Has keywords=Patent, USPTO, Litigation, Data
|Has project status=Active
}}

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=McNair Center
 |Has title=USPTO Patent Litigation Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=USPTO Patent Litigation Data

@@ Line 22: / Line 22: @@
 The files are in E:\McNair\PatentData\Litigation\Raw Data
 ===File Tops (5 lines)===
@@ Line 122: / Line 124: @@
    contactinfo  varchar(255), --semicolon seperated value
    position  varchar(255) --semicolon seperated list e.g., LEAD ATTORNEY; ATTORNEY TO BE NOTICED

← Older revision		Revision as of 22:53, 30 May 2017
Line 6:		Line 6:
	\|Has project status=Active		\|Has project status=Active
	}}		}}
		+
		+	==Getting the data==
		+
		+	The data is available from https://bulkdata.uspto.gov/data2/patent/litigation/2015/, which is linked directly from https://bulkdata.uspto.gov/
		+
		+	The data comes in .dta (STATA) and .csv formats. We took the .csv files:
		+	attorneys.csv.zip 29751808 2016-12-29 07:44
		+	cases.csv.zip 3085347 2016-12-29 07:45
		+	documents.csv.zip 244399591 2016-12-29 07:46
		+	names.csv.zip 7256777 2016-12-29 07:48
		+	pacer_cases.csv.zip 2453937 2016-12-29 07:48
		+	csv.zip 286947372 2016-12-29 07:45
		+
		+	csv.zip appears to contain the five other files!
		+
		+	The files are in E:\McNair\PatentData\Litigation\Raw Data
		+
		+	===File Tops (5 lines)===
		+
		+	names.csv
		+	case_row_id,case_number,party_row_count,party_type,name_row_count,name
		+	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."
		+	...
		+
		+	attorneys.csv
		+	case_row_id,case_number,party_row_count,party_type,attorney_row_count,name,contactinfo,position
		+	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:
		+	803-771-4484; Email: jcollins@collinsandlacy.com",LEAD ATTORNEY; ATTORNEY TO BE NOTICED
		+	14,0:92-cv-00398-MJP,41,Plaintiff ,2,"Joel Wyman Collins , Jr",(See above for address),LEAD ATTORNEY; ATTORNEY TO BE NOTICED
		+	...
		+
		+	cases.csv
		+	case_row_id,case_number,pacer_id,case_name,court_name,assigned_to,referred_to,case_cause,jurisdictional_basis,demand,jury_demand,lead_case,related_case,settlement,date_filed,date_closed,date_last_filed
		+	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",,,,
		+	...
		+
		+	documents.csv
		+	case_row_id,case_number,doc_count,attachment,date_filed,long_description,doc_number,short_description,upload_date
		+	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),,,
		+	...
		+
		+	pacer_cases.csv
		+	case_name,court_code,court_name,date_closed,case_number,pacer_id,date_filed
		+	"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

@@ Line 4: / Line 4: @@
 |Has start date=May 2017
 |Has keywords=Patent, USPTO, Litigation, Data
-|Has project status=Active
+|Has project status=Tabled
 }}
 ==Getting the data==