|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 = 'ROSS') AND (first_name = 'George') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Last Name is 'ROSS'; First Name is 'George';
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||1,230,521||June 19, 1917||Bracket
Tree insulator similar to the Cutter CD 1038 except with diagonal slot to secure wire, two holes for nails and two holes for tying to tree limbs
Total of 0.00 seconds