|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (last_name = 'SHOOK') AND (first_name = 'Albert') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Last Name is 'SHOOK'; First Name is 'Albert';
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||186,503||January 23, 1877||Improvement in Lightning Rod Connector Clips
Coupling or connector clip composed of flat metal bent around the adjoining rod with external threads formed on the end so the rod can be screwed onto the clip
||Lightning Rod Coupling|
Total of 0.00 seconds