1,181
edits
Changes
Jump to navigation
Jump to search
→HistPatent Table
8605804 | | -2962913 | 70 | 395 | 500 | 1996-02-23 | 1996-02-23 | | 1998-08-22 | ABN | | | 0
| | 1332054 | 63 | 112 | 153 | | | | 1920-02-24 | ISS | 1937-02-23 | | 0
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 />
