SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type LEFT JOIN category ON category.patent = patent.patent AND category.type = patent.type WHERE (category.class = '24') AND (category.subclass = '129A') ORDER BY last_name ASC, first_name, date, patent, type |
Total of 1 patents found where: Class is '24'; Subclass is '129A';
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 |
NICHOLS, William H. | ||||||
U | 697,001 | April 8, 1902 | Insulator 2-piece reversible nail-knob “P. E. M. Co. knob” (made by the Porcelain Electric Mfg. Co.) formerly known as the “W. E. split knob”. When Thomas received exclusive right to make and market the knob, it was called Thomas “T. P. I. knob “. |
NICHOLS, William H. |
Knob | 1/2 to Elmer Larrabee |
Total of 0.00 seconds