SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Medford, MA') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Residence is 'Medford, 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 |
1885 | ||||||
U | 316,469 | April 28, 1885 | Electric Wire Insulator Insulators and supporting rail |
LOCKE, Joseph BOWKER, William |
Insulator | Themselves and Robert Williams |
1888 | ||||||
U | 386,925 | July 31, 1888 | Electrical Non-Conductor Non-conducting composition material composed of mica and glue used to coat cheese cloth and made in thin sheets, which are then coated with shellac to repel moisture |
LEE, Charles Tennant WAITE, Charles N. |
Composition | 1/2 to The Gould & Watson Co. |
Total of 0.00 seconds