SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Belle Plaine, IA') ORDER BY date ASC, patent, type |
Total of 3 patents found where: Residence is 'Belle Plaine, IA';
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 |
1904 | ||||||
U | 753,398 | March 1, 1904 | Cleat for Electric Wiring Knob - 2-piece with base cut at an angle |
HUNT, Emory C. |
Knob | 1/2 to Charles Snyder |
U | 753,399 | March 1, 1904 | Combination Bracket and Knob for Electric Conductors nail-knob with hole in the top and two side groove for tie-wire (see Western Electrician 4-29-1905) |
HUNT, Emory C. |
Knob | 1/2 to Charles Snyder |
U | 776,514 | December 6, 1904 | Cleat for Electric Wiring Knob - split |
HUNT, Emory C. |
Knob | 1/2 to C. W. E. Snyder |
Total of 0.00 seconds