|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 = '337') AND (category.subclass = '211') ORDER BY date ASC, patent, type|
Total of 4 patents found where: Class is '337'; Subclass is '211';
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||547,591||October 8, 1895||Switch and Fuse Box
Fuse cut-out or holder for transformer with plug that acts like a switch.
|SMITH, Joseph Brodie
|U||595,585||December 14, 1897||Fuse Block
|SCHUTT, Duny A.
||Fuse Holder||The Peru Electric Mfg. Co.|
|U||1,222,952||April 17, 1917||Fuse Device
Fuse holder with plug insert to hold the fuse. (see reissue 14,844)
||Fuse Holder||1/2 to Edmund O. Schweitzer|
|R||14,416||December 25, 1917||Fuse Device
Reissue of patent 1,144,732 for fuse holder with knife insert. (see patent 1,144,732)
|SCHWEITZER, Edmund O.
Total of 0.01 seconds