|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 = 'CALTRIDER') AND (first_name = 'Samuel P.') ORDER BY type ASC, date, patent|
Total of 1 patents found where: Last Name is 'CALTRIDER'; First Name is 'Samuel P.';
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||2,712,567||July 5, 1955||Electric Fence Insulator
Electric fence insulator with bottom groove to fit around the iron post, bolt to secure to the iron post, and side groove to clip and secure the conductor wire.
|CALTRIDER, Samuel P.
Total of 0.00 seconds