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 = 'ALSBERG') AND (first_name = 'Julius') ORDER BY date ASC, patent, type |
Total of 5 patents found where: Last Name is 'ALSBERG'; First Name is 'Julius';
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 |
1911 | ||||||
U | 1,006,040 | October 17, 1911 | Insulator Suspension using multiple parts connected with a cable |
ALSBERG, Julius |
Suspension | |
U | 1,006,041 | October 17, 1911 | Insulator Suspension using multiple parts connected with a cable |
ALSBERG, Julius |
Suspension | |
U | 1,006,042 | October 17, 1911 | Insulator Suspension using multiple parts connected with a cable |
ALSBERG, Julius |
Suspension | |
1912 | ||||||
U | 1,015,224 | January 16, 1912 | Insulator Suspension insulator of insulating rope, hoods, and arcing rods. [This looks very close to the handful of glass suspension insulators found in 2002 in northern CA by Paul Greaves and Mike Spadafora. The glass was most probably made by Hemingray. No markings were found.] |
ALSBERG, Julius |
Suspension | |
U | 1,038,473 | September 10, 1912 | Insulator Suspension insulator of insulating rope and hoods |
ALSBERG, Julius |
Suspension |
Total of 0.01 seconds