|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 = 'FRIEDLAENDER') AND (first_name = 'Eugene') ORDER BY assigned_to DESC, date, patent, type|
Total of 1 patents found where: Last Name is 'FRIEDLAENDER'; First Name is 'Eugene';
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,111,570||September 22, 1914||Insulator
Third rail insulator with bolt holes on top and bottom side and flange projecting out in the center of the side designed to carry the rail on top
Total of 0.01 seconds