* "The 4-5 digit reel number refers to the microfilm reel number of the assignment entry in physical USPTO records; similarly the 1-4 digit frame number refers to the location of the assignment entry on the reel number in physical USPTO records. Thus, each assignment recorded with the USPTO has a unique reel number and frame number combination. While both reel number and frame number are sequential, there are missing values in the sequence because each only specifies the first page of the assignment records and records may have multiple pages." from https://www.uspto.gov/sites/default/files/documents/USPTO_Patents_Assignment_Dataset_WP.pdf, pg12, footnote 38
----
<nowiki>
patent=# select count(*) from ptoproperty_patent as p, june_2017_zipcode_hotfix as a where p.reelno = a.reelno and p.frameno = a.frameno;
count
---------
6107417
(1 row)
patent=# select count(distinct concat(p.frameno, p.reelno)) from ptoproperty_patent as p, june_2017_zipcode_hotfix as a
where p.reelno = a.reelno and p.frameno = a.frameno;
count
---------
2507745
(1 row)</nowiki>
== Related Pages ==