|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 = 'LYON') AND (first_name = 'Amos') ORDER BY assigned_to ASC, date, patent, type|
Total of 1 patents found where: Last Name is 'LYON'; First Name is 'Amos';
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||11,261||July 11, 1854||Improvement in Lightning Rods
Lightning rod made of sheets of copper to form ribbed or vanes along its length and attached to buildings with lignum vitea wood insulators
Total of 0.01 seconds