Patent Data Issues - Revision history

SONIAZHANG: /* Assigneeinfo Table */

2017-03-01T21:53:47Z

Assigneeinfo Table

2017-03-01T21:53:14Z

Assignees Table

2017-03-01T21:18:14Z

Assignees Table

2016-09-02T21:50:59Z

2016-07-28T19:55:44Z

PatentId

2016-07-28T15:59:13Z

2016-07-28T15:58:34Z

PatentId

2016-07-28T15:58:17Z

PatentId

2016-07-28T15:57:20Z

2016-07-21T19:04:36Z

HistPatent Table

@@ Line 90: / Line 90: @@
 <section begin=assignee />
 'Country' is missing.
 allpatent_clone=# SELECT COUNT(*) FROM assigneeinfo WHERE country = '';
   count

@@ Line 87: / Line 87: @@
 <section end=citation />
-===Assignees Table===
+===Assigneeinfo Table===
 <section begin=assignee />
 'Country' is missing.
   allpatent_clone=# SELECT COUNT(*) FROM assigneeinfo WHERE country='unknown';

@@ Line 91: / Line 91: @@
 'Country' is missing.
-  allpatent_clone=# SELECT COUNT(*) FROM assigneeinfo WHERE country=' ';
+  allpatent_clone=# SELECT COUNT(*) FROM assigneeinfo WHERE country='unknown';
   count
   -------
@@ Line 104: / Line 97: @@
   (1 row)
-  allpatent_clone=# SELECT COUNT(*) FROM assignees WHERE country IN ('unknown',' ') AND state=' ';
+  allpatent_clone=# SELECT COUNT(*) FROM assigneeinfo WHERE country IN ('unknown',' ') AND state=' ';
    count
   ---------

← Older revision		Revision as of 21:50, 2 September 2016
Line 200:		Line 200:
	27294418		27294418
	<section end="patentid" />		<section end="patentid" />
		+	[[Category: Internal]]
		+	[[Internal Classification: Data Tables\| ]]

← Older revision		Revision as of 19:55, 28 July 2016
Line 194:		Line 194:
	-------		-------
	775982		775982
−

	SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]';		SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]';

@@ Line 187: / Line 187: @@
 ===PatentId===
-<section begin= "patentid" />
+<section begin="patentid" />
 The patentid table has many entries that do not consist of only integers.
@@ Line 200: / Line 200: @@
   --------
   27294418
-<section end= "patentid" />
+<section end="patentid" />

← Older revision		Revision as of 19:04, 21 July 2016
Line 164:		Line 164:

	<section end="histpatent />		<section end="histpatent />
		+
		+	===LexJudge===
		+	<section begin="lexjudge" />
		+	There are duplicate entries for certain judges that may be dropped once data on patent litigation has been added.
		+
		+	name \| court \| count
		+	-----------------------------+-------+-------
		+	Malcolm Jones Howard \| EDNC \| 2
		+	Richard Leroy Williams \| EDVa \| 2
		+	Peter Jo Messitte \| DMd \| 2
		+	Andre Maurice Davis \| DMd \| 2
		+	Paula Xinis \| DMd \| 2
		+	Mary Hannah Lauck \| EDVa \| 2
		+	Julie E. Carnes \| NDGa \| 2
		+	Claude M. Hilton \| EDVa \| 2
		+	William D. Quarles Jr. \| DMd \| 2
		+	James C. Dever III \| EDNC \| 2
		+	Catherine C. Blake \| DMd \| 2
		+	Gerald Bruce Lee \| EDVa \| 2
		+	Leonie M. Brinkema \| EDVa \| 2
		+	<section end="lexjudge" />