SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (category = 'Can') ORDER BY last_name DESC, first_name, date, patent, type |
Total of 3 patents found where: Category is 'Can';
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 |
SPRATT, James | ||||||
U | 11,332 | July 18, 1854 | Improvement in Hermetical Sealing Metal can with rubber gasket (see reissue 1,593) |
SPRATT, James |
Can | |
NICHOLSON, Henry C. SPRATT, James | ||||||
U | 10,396 | January 3, 1854 | Improvement in Sealing Preserve Cans Pump to pull a vacuum on a can |
NICHOLSON, Henry C. SPRATT, James |
Can | |
GRIFFEN, John F. | ||||||
R | 1,593 | December 22, 1863 | Improvement in Sealing Fruit Can Metal can with rubber gasket (see 11,332) |
GRIFFEN, John F. |
Can | James Spratt |
Total of 0.02 seconds