|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 = '219.3') ORDER BY date ASC, patent, type|
Total of 5 patents found where: Class is '248'; Subclass is '219.3';
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||932,570||August 31, 1909||Supporting Pin for Insulators
Pin, metal mounted to side of pole
|PERRINE, Frederic A. C.
|U||1,184,336||May 23, 1916||Combination Wire Support for Electric Distribution
Pin bracket for poles
|FAY, John L.
||Bracket||W. N. Matthews & Brother Inc.|
|U||1,714,814||May 28, 1929||Pole Bracket
Steel bracket for pole top that supports insulator pin on side of pole
|PLIMPTON, Bentley A.
||Bracket||Locke Insulator Corp.|
|U||2,260,917||October 28, 1941||Insulator Pin
Steel pin with flanges to fit in top and bottom of hole drilled for larger wooden pins
||Pin||Line Material Co.|
|U||2,757,224||July 31, 1956||Transposition Bracket
|MILNE, Winford G.
RIDGERS, Frederick G.
|Transposition||N. Slater Co., LTD|
Total of 0.00 seconds