353
edits
Changes
Jump to navigation
Jump to search
→Assignees Table
'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
---------
