|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 = '403') AND (category.subclass = '217') ORDER BY date ASC, patent, type|
Total of 3 patents found where: Class is '403'; Subclass is '217';
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||185,272||December 12, 1876||Improvement in Couplings for Applying Weather Vane Pointers to Lightning Rods, &c.
Coupling to attach weather vane to the lightning rod
|WESTON, James H.
|U||786,691||April 4, 1905||Strain
Electrose strain (Brown p. 69)
|U||804,630||November 14, 1905||Support for Pole Crossarms
Metal bracket to attach a wooden crossarm to the pole and to prevent the crossarm from moving up or down from horizontal and eliminate the need to mortise the pole.
|SHORT, Edward C.
Total of 0.00 seconds