Changes

Jump to navigation Jump to search
<section end=citation />
===Assignees Assigneeinfo Table===
<section begin=assignee />
'Country' is missing.
allpatent_clone=# SELECT COUNT(*) FROM 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
---------
27294418
<section end="patentid" />
[[Category: Internal]]
[[Internal Classification: Data Tables| ]]

Navigation menu