353
edits
Changes
Jump to navigation
Jump to search
allpatent_clone=# SELECT COUNT(*) FROM assignees assigneeinfo WHERE country=' '; count ---------
(1 row)
→Assigneeinfo Table
<section end=citation />
===Assignees Assigneeinfo Table===
<section begin=assignee />
'Country' is missing.
2361543
allpatent_clone=# SELECT COUNT(*) FROM assignees assigneeinfo WHERE country='unknown';
count
-------
(1 row)
allpatent_clone=# SELECT COUNT(*) FROM assignees assigneeinfo WHERE country IN ('unknown',' ') AND state=' ';
count
---------
===HistPatent Table===
<section begin="histpatent" />The USPTO has provided bulk data contains negative patent numbers with a negative sign in front in the bulk data.
applicationid | pubno | patent | nber | uspc | uspc_sub | applicationdate | prioritydate | pubdate | displaydate | disptype | exp_dt | exp_dt_max | pta
8605804 | | -2962913 | 70 | 395 | 500 | 1996-02-23 | 1996-02-23 | | 1998-08-22 | ABN | | | 0
| | 1332054 | 63 | 112 | 153 | | | | 1920-02-24 | ISS | 1937-02-23 | | 0
Application numbers are 8 digits long (99/999999). The first two digits are a series code and the last six represent a serial code assigned by the USPTO. The histpatent table has over 3 million application numbers with 7 digits, since leading zeros were dropped. Leading zeros were also dropped for patent numbers. patent=# SELECT COUNT(*) FROM histpatent WHERE applicationid > 9999999; count --------- 4048050 (1 row) patent=# SELECT COUNT(*) FROM histpatent WHERE applicationid <9999999; count --------- 3028846 (1 row) <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" /> ===PatentId===<section begin="patentid" />The patentid table has many entries that do not consist of only integers. SELECT COUNT(*) FROM patentid WHERE patentid ~ '[A-Z]'; count ------- 775982 SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]'; count -------- 27294418<section end="patentid" />[[Category: Internal]][[Internal Classification: Data Tables| ]]
