artefacts

108,463 rows sorted by GeneralDescription

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid artifactNumber ObjectName GeneralDescription ▼ model SerialNumber Manufacturer ManuCountry ManuProvince ManuCity BeginDate EndDate date_qualifier patent NumberOfComponents ArtifactFinish ContextCanada ContextFunction ContextTechnical group1 category1 subcategory1 group2 category2 subcategory2 group3 category3 subcategory3 material Length Width Height Thickness Weight Diameter image thumbnail
39 39 1966.0049.002 Holder film     0354-LENS                 4                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0049.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0049.002.aa.cs.thumb.png  
40 40 1966.0049.003 Holder film                       4                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0049.003.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0049.003.aa.cs.thumb.png  
41 41 1966.0049.004 Sight camera                       4                                              
49 49 1966.0053.002 Holder roll film     US3894R-LENS                 2 BLACK WRINKLE FINISH PAINT/ LACQUERED WOOD/ BROWN LEATHER/ PLATED METAL PARTS       Photography Still cameras Specialized Exploration and Survey Photogrammetry Photographic equipment         31.2 27.5 16.5       http://source.techno-science.ca/artifacts-artefacts/images/1966.0053.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0053.002.aa.cs.thumb.png  
52 52 1966.0055.002 Holder roll film     41-1624                 2                             36.5 38 18.8            
65 65 1966.0062.002 Tongue                       2                                              
78 78 1966.0072.001 Propeller   HAMILTON STANDARD 15454 Hamilton Standard Propeller Div. United Aircraft Corp. United States of America Connecticut East hartford         1         Aviation Aircraft parts                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0072.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0072.001.aa.cs.thumb.png  
81 81 1966.0075.001 Propeller     82941                 1         Aviation Aircraft parts                                  
90 90 1966.0085.001 Propeller   FALCON N9195 Falcon United States of America New york Jamestown         1     Aircraft propulsion   Aviation Aircraft parts                                  
91 91 1966.0086.001 Engine airplane   LIBERTY 12A 2001B Lincoln Motor Co. United States of America Michigan Detroit 1918       1         Aviation Motive power                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0086.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0086.001.aa.cs.thumb.png  
93 93 1966.0088.001 Engine airplane   WRIGHT R3350   Curtiss-Wright Corp. United States of America New jersey Wood-ridge         1         Aviation Motive power                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0088.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0088.001.aa.cs.thumb.png  
94 94 1966.0091.001 Engine airplane   Pratt & Whitney R985-AN-14B Wasp Junior 1623C United Aircraft Corp. Pratt & Whitney Aircraft Div. United States of America Connecticut East hartford         1         Aviation Motive power                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0091.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0091.001.aa.cs.thumb.png  
95 95 1966.0092.001 Engine airplane   CURTISS-WRIGHT R3350-32W W-572965 Curtiss-Wright Corp. United States of America New jersey Wood-ridge         1         Aviation Motive power                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0092.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0092.001.aa.cs.thumb.png  
106 106 1966.0101.002 Note       Unknown Unknown             2                                              
130 130 1966.0113.002 Lock breech     973M                 2         Aviation Aviation armament                                  
145 145 1966.0126.001 Landing gear model   CHANCE VOUGHT F4U-1 CORSAIR   Unknown England     1966   before   1 OUTSIDE COVER TOP DARK GREY UNDERSIDE LIGHT BLUE/ LANDING GEAR CHROME COLOURED/ TIRE BLACK HUB CHROME/ INSIDE OF WING LIGHT GREEN   TO DISPLAY RETRACTION OF LANDING GEAR FOR FLIGHT   Aviation Models                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0126.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0126.001.aa.cs.thumb.png  
146 146 1966.0127.001 Landing gear model   BOEING 247   Unknown England     1967   before   1 OUTSIDE OF WING LIGHT GREY/ LANDING GEAR CHROME COLOURED/ TIRE BLACK HUB CHROME/ INSIDE OF WING LIGHT GREEN   TO DISPLAY RETRACTION OF LANDING GEAR FOR FLIGHT   Aviation Models                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0127.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0127.001.aa.cs.thumb.png  
147 147 1966.0128.001 Landing gear model   DOUGLAS DC-3   Unknown England     1966   before   1 OUTSIDE COVER GREY/ LANDING GEAR CHROME & GREY/ TIRE BLACK HUB CHROME/ INSIDE OF WING LIGHT GREEN   TO DISPLAY RETRACTION OF LANDING GEAR FOR FLIGHT   Aviation Models                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0128.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0128.001.aa.cs.thumb.png  
162 162 1966.0150.002 Photograph       Unknown Canada Ontario Toronto 1916       2         Aviation Archives Corporate                                
171 171 1966.0157.002                         8                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.002.aa.cs.thumb.png  
172 172 1966.0157.003                         8                                              
173 173 1966.0157.004                         8                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.004.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.004.aa.cs.thumb.png  
174 174 1966.0157.005                         8                                              
175 175 1966.0157.006                         8                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.006.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.006.aa.cs.thumb.png  
176 176 1966.0157.007                         8                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.007.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.007.aa.cs.thumb.png  
177 177 1966.0157.008                         8                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.008.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0157.008.aa.cs.thumb.png  
182 182 1966.0162.002 Compass bearing     333                 2         Marine Transportation Navigation instruments & equipment                             http://source.techno-science.ca/artifacts-artefacts/images/1966.0162.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0162.002.aa.cs.thumb.png  
187 187 1966.0166.002 Porthole cover       Unknown Unknown             3         Marine Transportation Vessel parts                                  
188 188 1966.0166.003 Porthole cover       Unknown Unknown             3         Marine Transportation Vessel parts                                  
202 202 1966.0178.002                         4                                              
203 203 1966.0178.003                         4                                              
204 204 1966.0178.004                         4                                              
209 209 1966.0184.001 Washer wringer   32/ DELCO (MOTOR) 4010/ 1655? (MO Easy Washing Machine Co. Ltd. Canada Ontario Toronto         2         Domestic Technology Laundry Washing               64.5 59 122.2       http://source.techno-science.ca/artifacts-artefacts/images/1966.0184.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0184.001.aa.cs.thumb.png  
210 210 1966.0184.002 Lid       Easy Washing Machine Co. Ltd. Canada Ontario Toronto         2         Domestic Technology Laundry Washing                 49.5 8            
220 220 1966.0195.002 Cord electrical     7178/42 Unknown Unknown           BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 12.5         3.5 cm      
221 221 1966.0195.003 Tube battery       Unknown Unknown           BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 9.7         3.0 cm      
222 222 1966.0195.004 Tube battery       Unknown Unknown           BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 9.7         3.0 cm      
223 223 1966.0195.005 Case sextant       Unknown Unknown           BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 28 20.4 24.5            
225 225 1966.0196.002 Cord electrical       Kelvin & Hughes Ltd. England     1938   after BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 12.5         3.5 cm      
226 226 1966.0196.003 Tube battery       Kelvin & Hughes Ltd. England     1938   after BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 9.7         3.0 cm      
227 227 1966.0196.004 Tube battery       Kelvin & Hughes Ltd. England     1938   after BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 9.7         3.0 cm      
228 228 1966.0196.005 Case sextant       Kelvin & Hughes Ltd. England     1938   after BRITISH PATENTS 480112 490621 & OTHERS PENDING 5         Aviation Aircraft instruments                 28.3 20 25.5            
250 250 1966.0202.001 Airplane model   AVRO CANADA CF-105 ARROW           1953   circa   1     WIND TUNNEL MODEL USED IN STABILITY & DIRECTIONAL CONTROL TESTS   Aviation Models   Aviation Research           67 45.5 16       http://source.techno-science.ca/artifacts-artefacts/images/1966.0202.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0202.001.aa.cs.thumb.png  
300 300 1966.0229.001 Print               1966   circa   9         Aviation Commemorative Art               30.3 35.5         http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.001.aa.cs.thumb.png  
301 301 1966.0229.002 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.002.aa.cs.thumb.png  
302 302 1966.0229.003 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.003.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.003.aa.cs.thumb.png  
303 303 1966.0229.004 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.004.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.004.aa.cs.thumb.png  
304 304 1966.0229.005 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.005.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.005.aa.cs.thumb.png  
305 305 1966.0229.006 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.006.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.006.aa.cs.thumb.png  
306 306 1966.0229.007 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.007.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.007.aa.cs.thumb.png  
307 307 1966.0229.008 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.008.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.008.aa.cs.thumb.png  
308 308 1966.0229.009 Print               1966   circa   9         Aviation Commemorative Art                           http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.009.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0229.009.aa.cs.thumb.png  
312 312 1966.0235.001 Log book   Pilot's Flying Log Book     Unknown     1915 1917 between   1     LOG BOOK OF D.A. NELLES   Aviation Archives Personal               18.3 11.5              
313 313 1966.0236.001 Button uniform   RAF   JENNENS & CO. LTD. England   London         8         Aviation Clothing Accessories                 2.3 1.6            
314 314 1966.0236.002 Button uniform   RAF   JENNENS & CO. LTD. England   London         8         Aviation Clothing Accessories                 2.3 1.6       http://source.techno-science.ca/artifacts-artefacts/images/1966.0236.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0236.001.aa.cs.thumb.png  
315 315 1966.0236.003 Button uniform   RAF                   8         Aviation Clothing Accessories                 2.3 1.6            
316 316 1966.0236.004 Button uniform   RAF   JENNENS & CO. LTD. England   London         8         Aviation Clothing Accessories                 2 1.7            
317 317 1966.0236.005 Button uniform   RAF                   8         Aviation Clothing Accessories                 2 1.7            
318 318 1966.0236.006 Badge uniform cap       Unknown Unknown             8         Aviation Clothing Accessories               5 6.1 1.7            
319 319 1966.0236.007 Badge uniform       Unknown Unknown             8         Aviation Clothing Accessories               1.5 5.7 1.1            
320 320 1966.0236.008 Badge uniform       Unknown Unknown             8         Aviation Clothing Accessories               3.9 11              
327 327 1966.0242.002                         6                                              
328 328 1966.0242.003                         6                                              
329 329 1966.0242.004                         6                                              
330 330 1966.0242.005                         6                                              
331 331 1966.0242.006                         6                                              
343 343 1966.0250.002                         16                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0250.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0250.002.aa.cs.thumb.png  
344 344 1966.0250.003                         16                                              
345 345 1966.0250.004                         16                                         http://source.techno-science.ca/artifacts-artefacts/images/1966.0250.004.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0250.004.aa.cs.thumb.png  
346 346 1966.0250.005                         16                                              
347 347 1966.0250.006                         16                                              
348 348 1966.0250.007                         16                                              
349 349 1966.0250.008                         16                                              
350 350 1966.0250.009                         16                                              
351 351 1966.0250.010                         16                                              
352 352 1966.0250.011                         16                                              
353 353 1966.0250.012                         16                                              
354 354 1966.0250.013                         16                                              
355 355 1966.0250.014                         16                                              
356 356 1966.0250.015                         16                                              
357 357 1966.0250.016                         16                                              
395 395 1966.0285.001 Gun flare     K 1686 Kilgore United States of America Ohio Westerville       1712382 USA 1 Nickel plated barrel & handle; dark brown knurled grip panels.       Aviation Aviation armament               metal->steel - possible;synthetic->bakelite - possible                  
397 397 1966.0286.002 Hood lens     REF.14AA/1106 A.M.               3         Photography Still cameras Specialized Aviation Miscellaneous                            
398 398 1966.0286.003 Case storage-carrying                       3                                              
405 405 1966.0288.002 Cord     EM4599 (LENS) Fairchild Aviation Corp. United States of America New york New york         3         Photography Still cameras Specialized Aviation Miscellaneous                            
406 406 1966.0288.003                         3                                              
411 411 1966.0292.002 Newspaper       Unknown Unknown             3         Aviation Archives Personal               58.8 43              
412 412 1966.0292.003 Periodical       Unknown Unknown             3         Aviation Archives Personal               33.2 27.5              
414 414 1966.0293.002 Document   Lecture notes/Canada From the Air Photographed by the RCAF                   2                                              
418 418 1966.0296.002 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
419 419 1966.0296.003 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
420 420 1966.0296.004 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
421 421 1966.0296.005 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
422 422 1966.0296.006 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
423 423 1966.0296.007 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
424 424 1966.0296.008 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
425 425 1966.0296.009 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
426 426 1966.0296.010 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
427 427 1966.0296.011 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
428 428 1966.0296.012 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [artefacts] (
   [artifactNumber] TEXT,
   [ObjectName] TEXT,
   [GeneralDescription] TEXT,
   [model] TEXT,
   [SerialNumber] TEXT,
   [Manufacturer] TEXT,
   [ManuCountry] TEXT,
   [ManuProvince] TEXT,
   [ManuCity] TEXT,
   [BeginDate] TEXT,
   [EndDate] TEXT,
   [date_qualifier] TEXT,
   [patent] TEXT,
   [NumberOfComponents] TEXT,
   [ArtifactFinish] TEXT,
   [ContextCanada] TEXT,
   [ContextFunction] TEXT,
   [ContextTechnical] TEXT,
   [group1] TEXT,
   [category1] TEXT,
   [subcategory1] TEXT,
   [group2] TEXT,
   [category2] TEXT,
   [subcategory2] TEXT,
   [group3] TEXT,
   [category3] TEXT,
   [subcategory3] TEXT,
   [material] TEXT,
   [Length] TEXT,
   [Width] TEXT,
   [Height] TEXT,
   [Thickness] TEXT,
   [Weight] TEXT,
   [Diameter] TEXT,
   [image] TEXT,
   [thumbnail] TEXT,
   [] TEXT
);