|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Pekin, IN') ORDER BY assigned_to DESC, date, patent, type|
Total of 1 patents found where: Residence is 'Pekin, IN';
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|
|Leander G. Davis and Milton Hottel|
|U||793,313||June 27, 1905||Insulator
Split insulator to hold wire in the center hole and split bracket to hold insulator above crossarm to prevent line wire from dropping if insulator breaks
|MOSS, Bertie B.
||Miscellaneous||Leander G. Davis and Milton Hottel|
Total of 0.01 seconds