|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 = 'GILL') AND (first_name = 'James G.') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Last Name is 'GILL'; First Name is 'James G.';
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||215,516||May 20, 1879||Improvement in Devices for Attaching Plungers to Glass Presses
Means of attaching a plunger to a glass press using a chuck. (This is known as the ""Gill Chuck"" and may have been used in insulator production, it is not known if Gill was employed by Hemingray at the time of this patent.)
|GILL, James G.
Total of 0.00 seconds