|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 = '248') AND (category.subclass = '72') ORDER BY date DESC, patent, type|
Total of 6 patents found where: Class is '248'; Subclass is '72';
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||2,386,129||October 2, 1945||Self-Attaching Wire Holder
Self-tying wireholder mounted on metal bracket
|MAACK, Walter Henry
|U||1,212,673||January 16, 1917||Insulator Supporting Bracket
Bracket, sheet metal U-shaped to fit over crossarm and threads made of a spring to secure insulator
|PEIRCE, JR., Charles L.
||Bracket||1/2 to Hubbard & Co.|
|U||1,030,574||June 25, 1912||Insulator Supporting Device
Bracket (metal) that slides along crossarm for insulator above and below crossarm
|ETTE, Charles G.
||Bracket||Ette Investment Co.|
|U||1,026,711||May 21, 1912||Sheet Metal Insulator Pin
Pin, metal composed of three flat strips
|SHOVER, Barton R.
|U||928,010||July 13, 1909||Cross Arm Fitting and Insulator Support
Steel bracket that fits and clamps around the crossarm, specimens manufactured by St. Louis Malleable Casting Co., St. Louis, MO
|WAY, Sylvester B.
|U||463,756||November 24, 1891||Wire Hanger
Wire hanger using two spool insulators in a bracket to secure the line wire
|JACOBS, Charles A.
Total of 0.01 seconds