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