353
edits
Changes
Jump to navigation
Jump to search
allpatent_clone=# SELECT COUNT(*) FROM assigneeinfo WHERE country=' '; count ---------
(1 row)
→Assigneeinfo Table
<section end=citation />
===Assignees Assigneeinfo Table===
<section begin=assignee />
'Country' is missing.
2361543
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
---------
===PatentId===
<section begin= "patentid" />
The patentid table has many entries that do not consist of only integers.
-------
775982
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]';
--------
27294418
<section end= "patentid" />[[Category: Internal]][[Internal Classification: Data Tables| ]]
