SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Pittsfield, MA') ORDER BY date ASC, patent, type |
Total of 8 patents found where: Residence is 'Pittsfield, MA';
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 |
1900 | ||||||
U | 664,301 | December 18, 1900 | Insulator M-2795, top is flattened cone with vertical flange & detachable spout |
STERLING, Richard H. |
Insulator | The Stanley Electric Mfg. Co. |
1903 | ||||||
U | 732,665 | June 30, 1903 | Insulating System for Electric Transmission Circuits Bracket to hold multiple insulators for high tension line |
UNDERWOOD, Alvah W. |
Bracket | |
1904 | ||||||
U | 751,459 | February 9, 1904 | Line Insulator Odd arrangement of two ribbed spools supporting a third ribbed spool to support the line wire |
CHESNEY, Cummings C. |
Miscellaneous | |
U | 761,760 | June 7, 1904 | Insulator Multipart lily shell design (M-3740) |
CHESNEY, Cummings C. |
Insulator | Stanley Electric Mfg. Co. |
U | 771,297 | October 4, 1904 | Insulator Oil reservoir for transformer insulator |
CHESNEY, Cummings C. |
Oil | Stanley Electric Mfg. Co. |
1906 | ||||||
U | 824,055 | June 19, 1906 | Insulator Crossover |
ACLY, Harry M. |
Crossover | Stanley Electric Mfg. Co. |
1924 | ||||||
U | 1,491,385 | April 22, 1924 | Insulator Wall or roof bushing to bring conductor into the building |
FACCILOI, Giuseppe |
Miscellaneous | General Electric Co. |
1959 | ||||||
U | 2,879,323 | March 24, 1959 | Electrical Insulating Cement Cement made from synthetic resin to bond metal to porcelain |
NICHOLS, Frank S. SMITH, JR., Sidney R. |
Cement | General Electric Co. |
Total of 0.01 seconds