|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 = '536') ORDER BY date ASC, patent, type|
Total of 6 patents found where: Class is '248'; Subclass is '536';
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||163,807||May 25, 1875||Improvement in Lightning Rod Standards
Lightning rod stand with three legs
|REYBURN, William S.
MARTIN, Frederick J.
|U||293,612||February 12, 1884||Lightning Diffuser
Lightning rod with special bracket to hold the rod away from the building
|WOOLLEY, Leonidas G.
|U||950,181||February 22, 1910||Lightning Rod Support
Lightning rod tripod support
|MAHER, Jeremiah J.
|U||995,638||June 20, 1911||Brace for Lightning Rod Tops
Lightning rod tripod to support rod with ball ornament
|SHINN, William C.
|U||1,140,582||May 25, 1915||Bracket for Lightning Rod Points
Support or bracket for lightning rod point made of flat copper that can be easily bent for installation
|DODD, Thomas W.
||Lightning Rod||Dodd & Struthers|
|U||1,513,931||November 4, 1924||Lightning Rod Point Support
Lighting rod with supporting feet for tiled roof peaks that fit over ridge tiles and under the tile edges
|REA, Ernest C.
Total of 0.01 seconds