|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 = '174') AND (category.subclass = '190') ORDER BY date ASC, patent, type|
Total of 9 patents found where: Class is '174'; Subclass is '190';
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||822,642||June 5, 1906||Wood Strain Insulator
Wood strain insulator with metal caps on the ends
|WHITE, Thomas C.
|U||829,416||August 28, 1906||Third Rail Insulator
Third rail insulator with 2-part metal cap to secure the rail.
|MCGILL, John J.
||Third Rail||1/2 to Frank J. Guernsey|
|U||887,996||May 19, 1908||Combined Insulator and Lamp Hanger
Hanger for lamp
|BURGE, James M.
|U||904,069||November 17, 1908||Insulator
Strain insulator to electrically disconnect the circuit. (see reissue 13,526)
|KEMPTON, Williard H.
||Strain||The Johns-Pratt Co.|
|U||947,885||February 1, 1910||Insulator
Suspension insulator and clamp support system
|CONE, William S.
|U||1,236,668||August 14, 1917||Insulator Clamping Device
Clamp for crown of large insulator
|BROWN, James M.
||Clamp||Westinghouse Electric & Mfg. Co.|
|U||1,333,640||March 16, 1920||Electric Insulator
Suspension with bolted on metal cap (Italy)
|U||1,574,964||March 2, 1926||Insulation Equipment
Special insulator design for bus bar and equipment support (see 1,274,555 and 1,663,007)
|GETTS, Frank E.
||Insulator||Electrical Engineers Equipment Co.|
|U||1,602,873||October 12, 1926||Support for Electrical Fixtures
Bus bar support for top of insulator
|ANSINGH, Herman K.
||Bus Bar||Westinghouse Electric & Mfg. Co.|
Total of 0.01 seconds