|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN category ON category.patent = patent.patent AND category.type = patent.type WHERE (category.class = '24') AND (category.subclass = '115N') ORDER BY date ASC, patent, type|
Total of 2 patents found where: Class is '24'; Subclass is '115N';
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||806,769||December 12, 1905||Adjustable Support for Telegraph Line Wires
Split cylinder of wood insulator for spacing line wires with external spiral grooves for receiving spiral of wire to hold the halves together and attach to insulator on adjacent wires
|BELL, Jasper N.
|U||1,235,592||August 7, 1917||Device for Attaching Conductors to Insulators
Tie wire preformed in such a way to make attachment easier
||Tie Wire||Soc. H. Parra & Cie.|
Total of 0.00 seconds