|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 = '313') AND (category.subclass = '335') ORDER BY date ASC, patent, type|
Total of 2 patents found where: Class is '313'; Subclass is '335';
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||280,324||June 26, 1883||Combined Insulator and Lightning arrester
Combined insulator and lightning arrestor
|NOBLE, John E.
||Lightning Arrestor||1/6 to Charles J. Leming|
|U||2,392,342||January 8, 1946||Combined Spark Gap and Insulator
CD 186, CD 186.1, CD 186.2; Transparent glass insulator with spark gap within the insulator for signal circuits
|STEINMAYER, Alwin G.
||Spark Gap||Line Material Co.|
Total of 0.00 seconds