1,181
edits
Changes
Jump to navigation
Jump to search
no edit summary
'Country' is missing.
allpatent_clone=# SELECT COUNT(*) FROM assignees assigneeinfo WHERE country=' ';
count
---------
Leonie M. Brinkema | EDVa | 2
<section end="lexjudge" />
===PatentId===
<section begin ="patentid" />
The patentid table has many entries that do not consist of only integers.
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[A-Z]';
count
-------
775982
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]';
count
--------
27294418
<section end="patentid" />
