1,181
edits
Changes
Jump to navigation
Jump to search
→HistPatent Table
Application numbers 8 digits long (99/999999). The first two digits are a series code and the last six represent a serial code assigned by the USPTO. The histpatent table has over 3 million application numbers with 7 digits, since leading zeros were dropped.
patent=# SELECT COUNT(*) FROM histpatent WHERE applicationid > 9999999;
count
---------
4048050
(1 row)
patent=# SELECT COUNT(*) FROM histpatent WHERE applicationid <9999999;
count
---------
3028846
(1 row)
<section end="histpatent />
