| SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Charlotte, NC') ORDER BY date ASC, patent, type |
Total of 6 patents found where: Residence is 'Charlotte, NC';
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 |
| 1907 | ||||||
| U | 848,473 | March 26, 1907 | Insulating Clamp Clamp type for cable top of multi |
LEE, Thomas B. |
Clamp Type | |
U  |
855,253 | May 28, 1907 | Insulator Pin Pin with hollow cast iron cone and thimble |
LEE, JR., William States |
Pin | |
| 1908 | ||||||
| U | 892,822 | July 7, 1908 | Pole Top Cap Metal pole top cap with insulator support and lateral extension to support protector wire |
FRASER, James William |
Bracket | |
| 1915 | ||||||
| U | 1,140,603 | May 25, 1915 | Insulator Clamp Tie wire clamp for multipart insulator that clamps around the crown and hold the cable in the top groove |
LEE, William S. |
Tie Wire | |
| 1927 | ||||||
| D | 72,459 | April 12, 1927 | Design for a Bottle Design for Bottle (Big Boy) |
TAYLOR, Arch B. LONG, Cornelia Taylor SOHN, Archie C. |
HU | Taylor-Long Co. |
| 1929 | ||||||
| D | 78,667 | May 28, 1929 | Design for a Bottle Design for Bottle (Billy Boy) |
TAYLOR, Arch B. |
HU | |
Total of 0.00 seconds