|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (last_name = 'HARLOE') AND (first_name = 'Morton') ORDER BY date ASC, patent, type|
Total of 4 patents found where: Last Name is 'HARLOE'; First Name is 'Morton';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
|T / S||Patent||Date||Description||Patentee||Category||Assigned To|
|U||621,661||March 21, 1899||Insulator
Cleat - self-tying (pivot-mounted) (found on U-184)
BLOES, Wilton S.
|U||669,691||March 12, 1901||Insulator for Electric Wires
Two-piece self-tying insulator (found on U-184)
||Self-tying Miscellaneous||1/2 to Wilton S. Bloes|
|U||715,375||December 9, 1902||Insulator
CD 109.7, CD 206.5 & U-184 self-tying via three alternate projections
|U||807,459||December 19, 1905||Process of Forming Glass Articles
Threading process using fusible metal to form threads in glass before it melts
||Threads||1/3 to Harry P. Decker|
Total of 0.00 seconds