|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (category = 'Under Crossarm') ORDER BY assigned_to DESC, date, patent, type|
Total of 2 patents found where: Category is 'Under Crossarm';
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||945,350||January 4, 1910||Insulator
Two part insulator fitted in the underside of the crossarm.
|TINSLEY, Addison B.
|U||955,661||April 19, 1910||Insulator
Under crossarm type (see 1,694,415)
|MOORE, William Enoch
Total of 0.00 seconds