|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 = 'DE RIGHT') AND (first_name = 'Elon J.') ORDER BY assigned_to DESC, date, patent, type|
Total of 1 patents found where: Last Name is 'DE RIGHT'; First Name is 'Elon 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|
|(marketed by the Shull Boltless Clamp Corp.)|
|U||1,257,135||February 19, 1918||Guying-Pole
Cast iron member with three lugs for threadhing through guy cable on either side of the guy strain insulator which eliminates the need for clamps and is easier to install.
|SHULL, Frederick G.
DE RIGHT, Elon J.
|Guy Strain||(marketed by the Shull Boltless Clamp Corp.)|
Total of 0.00 seconds