|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Cambridge, MA') ORDER BY description ASC, date, patent, type|
Total of 4 patents found where: Residence is 'Cambridge, MA';
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||1,892,798||January 3, 1933||Cable Rider
Cable support tray (specimens are not uncommon to find)
|ELMER, William B.
AVILA, Charles F.
|Miscellaneous||Charles B. Elmer|
|U||21,492||September 14, 1858||Improvement in Telegraph Insulators
Hook covered with rubber to insert into crossarm or pole (see 124,199)
|FARMER, Moses G.
BATCHELDER, John M.
|U||8,418||October 14, 1851||Improvement in Insulators for Telegraph Wires
Metal or cast iron insulator with cupped dry area at bottom. Glass poured in with a conductor supporting iron rod embedded in the glass, and the cupped is coated or lined with glass, porcelain, or enamel. The bottom skirt is slanted inward 45 degrees to p
|BATCHELDER, John M.
|U||482,913||September 20, 1892||Insulator
|BROOKS, Herbert H.
||Tree||1/2 to Augustus T. Clark|
Total of 0.00 seconds