===Assignees Table===
'Country' is missing.
allpatent_clone=# SELECT COUNT(*) FROM assignees WHERE country='';
count
---------
2361543
(1 row)
allpatent_clone=# SELECT COUNT(*) FROM assignees WHERE country='unknown';
count
-------
3918
(1 row)
allpatent_clone=# SELECT COUNT(*) FROM assignees WHERE country IN ('unknown','') AND state='';
count
---------
1851353
(1 row)
==References==