<section end=citation />
===Assignees Assigneeinfo Table===
<section begin=assignee />
'Country' is missing.
allpatent_clone=# SELECT COUNT(*) FROM assignees assigneeinfo WHERE country=' '; count ---------
2361543
(1 row)
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
---------
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| ]]