|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'University Heights, OH') ORDER BY patent ASC, type|
Total of 1 patents found where: Residence is 'University Heights, OH';
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||3,288,918||November 29, 1966||Apparatus for Securing Lines to Supports
Preformed tie wire and line reinforcement of ribbon helix made of resilient material that may be uncoiled to make the tie but spring back to preformed shape
|SCHLEIN, Seymour N.
||Tie Wire||The Fanner Mfg. Co.|
Total of 0.00 seconds