|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 = 'STAUB') AND (first_name = 'Arthur J.') ORDER BY description ASC, date, patent, type|
Total of 1 patents found where: Last Name is 'STAUB'; First Name is 'Arthur J.';
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||1,528,580||March 3, 1925||Insulator Pin
Unique hollow steel pin with bottom halves that widen when the insulator is screwed down on the pin thus gripping the hole in the crossarm and securing the pin and allowing a tap wire to run from the line conductor down through the center of the pin
|STAUB, Arthur J.
Total of 0.01 seconds