SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Fort Wayne, IN') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Residence is 'Fort Wayne, IN';
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 |
1903 | ||||||
U | 736,049 | August 11, 1903 | Electric Fuse Box Fuse cutout |
WOOD, James J. |
Fuse Holder | |
1925 | ||||||
U | 1,528,580 | March 3, 1925 | Insulator Pin Unique hollow steel pin with bottom halves that widen when the insulator is screwed down on the pin thus gripping the hole in the crossarm and securing the pin and allowing a tap wire to run from the line conductor down through the center of the pin |
STAUB, Arthur J. |
Pin |
Total of 0.00 seconds