|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 = 'GOSS') AND (first_name = 'Alonzo') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Last Name is 'GOSS'; First Name is 'Alonzo';
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||196,350||October 23, 1877||Improvement in Conductors for Lightning Rods
Lightning rod conductor shaped like a trough which is galvanized on outside and lined with Russia iron on the inside and running down from rod to just below the eave with lightning rod resting in the trough
||Lightning Rod Conductor|
Total of 0.01 seconds