SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Birmingham, AL') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Residence is 'Birmingham, AL';
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 | 724,329 | March 31, 1903 | Insulator Self-tying nail-knob with three flanges on top for tying wire around the knob and saw-toothed bottom edge to prevent the knob from turning. |
POLK, Robert H. |
Knob | |
1935 | ||||||
U | 2,016,470 | October 8, 1935 | Secondary Rack and the Process of Making Same Simple secondary rack construction to reduce cost. |
WHITE, Leonard H. |
Bracket/secondary Rack | Line Material Co. |
Total of 0.00 seconds