|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 = '153G') ORDER BY date ASC, patent, type|
Total of 8 patents found where: Class is '174'; Subclass is '153G';
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||476,964||June 14, 1892||Insulating Tube for Electric Conductors
Wall tube Patent was owned by Pass & Seymour.
|SEYMOUR, Albert P.
|U||607,315||July 12, 1898||Insulator
Wall tube of two split pieces [Scientific American 8-6-1898]
|WINGARD, Charles L.
||Wall Tube||1/2 to Luella Wingard|
|U||684,909||October 22, 1901||Insulating Bushing
|COLE, John A.
|U||773,733||November 1, 1904||Insulator
Wall tube with ribs and metal clip
|GREENE, Leon W.
|U||830,501||September 11, 1906||Protecting Bushing for Electric Circuit Wires
Bushing with screw threads
|GOEHST, John H.
||Bushing||Federal Electric Co.|
|U||1,056,392||March 18, 1913||Insulator
|BARR, Carl A.
KOREN, Jerome H.
|U||1,080,257||December 2, 1913||Insulator
Wall tube with metal clip
|U||1,099,374||June 9, 1914||Insulator
Block in crossarm
||Block||2/3 to Rafferty, 1/3 to Wells|
Total of 0.01 seconds