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 = 'BRITTAN') AND (first_name = 'N.') ORDER BY date ASC, patent, type |
Total of 3 patents found where: Last Name is 'BRITTAN'; First Name is 'N.';
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 |
1860 | ||||||
U | 30,560 | November 6, 1860 | Improvement in Lightning Rods Lightning rod made up of continuous strips or tubes of metal |
BRITTAN, N. |
Lightning Rod | |
1864 | ||||||
U | 43,565 | July 19, 1864 | Improvement in Lightning Conductors Lightning rod tips formed by spiralling flat metal strips (see reissue 2,601) |
BRITTAN, N. |
Lightning Rod Point | |
1867 | ||||||
R | 2,601 | May 14, 1867 | Improvement in Lightning Rods Lightning rod made of flat metal made tubular for the rods and points (see 43,565) |
BRITTAN, N. |
Lightning Rod |
Total of 0.00 seconds