artefacts

108,463 rows sorted by thumbnail

✎ 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 ▼
356 356 1966.0250.015                         16                                              
357 357 1966.0250.016                         16                                              
367 367 1966.0259.002 Ski WOOD SKIS/ METAL BINDINGS/ LEATHER STRAPS SUPER DELUXE   Unknown Unknown     1947   after   2 Varnidhed natural wood ski with metal and leather binding.   A WINTER RECREATIONAL SPORT DEVICE   Non-motorized Ground Transportation Human powered Personal transportation equipment             wood;metal;skin 180 11.5 10            
369 369 1966.0260.002 Ski WOOD SKI/ METAL BINDINGS     Unknown Unknown             2 BROWN STAINED WOOD/ METALLIC BINDINGS   A WINTER RECREATIONAL SPORT DEVICE.   Non-motorized Ground Transportation Human powered Personal transportation equipment             wood;metal 202 9.7 8.3            
371 371 1966.0261.002 Snowshoe WOOD FRAME & CROSSBARS/ RAWHIDE LACING     Unknown Unknown             2 NATURAL WITH VARNISH? FINISH   A TYPE OF FOOTWEAR WHICH IS STRAPPED TO THE BOTTOM OF THE FEET ALLOWING THE WEARER TO TRAVERSE DEEP SNOW WITHOUT SINKING IN. THEY CAN BE USED EITHER FOR RECREATIONAL OR OCCUPATIONAL PURPOSES THE LATTER INVOLVING TRAPPERS & THE LIKE.   Non-motorized Ground Transportation Human powered Personal transportation equipment             wood;skin 107.5 29.7 7.7            
376 376 1966.0265.002 Cradle weighing METAL WITH SYNTHETIC PADDING ON ARMS     Unknown Unknown             2 METALLIC GREY WITH BLACK SYNTHETIC                         metal;synthetic 38.8 20 9.7            
391 391 1966.0280.001 Certificate WOOD/ GLASS/ INK/ PAINT/ PAPER/ WAX/ TWO PIECES OF PLAID MATERIAL/ CARDBOARD ROYAL CAPE BRETON AIR FORCE   Unknown Unknown     1960       1 FRAME OF CERTIFICATE HAS BLACK PAINT FINISH       Aviation Archives               paper->cardboard;composite->ink;resin->wax;wood;fibre;glass 39.6 29.5 3.3            
392 392 1966.0281.001 Tag identification PLASTIC/ PAPER/ METAL CHAIN     Unknown Canada             1 RECTANGULAR GREY PLASTIC CASING WITH MOVABLE CLEAR PLASTIC WINDOW & METAL BEAD CHAIN   TO IDENTIFY LUGGAGE   Aviation Services Baggage             synthetic->plastic;paper;metal 22 12.5              
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                                              
403 403 1966.0287.005   METAL                     5                           metal                  
404 404 1966.0288.001 Camera METAL/ GLASS/ LEATHER/ PLASTIC K-25B 43-271 Fairchild Aviation Corp. United States of America New york New york         3     TO PHOTOGRAPH OBJECTS FROM THE AIR   Photography Still cameras Specialized Aviation Miscellaneous         metal->;glass->;skin->leather;synthetic->plastic 28 21.5 17.7            
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                                              
410 410 1966.0292.001 Diary PAPER INK CARDBOARD STRING 22Z   Unknown Unknown     1961       3 DIARY IS BLUE CLOTH COVERED BOOK   .1 DIARY USED EXCLUSIVELY TO RECORD DAILY EVENTS & THOUGHTS CONCERNING PILOTING/ USED AS A PILOT'S JOURNAL   Aviation Archives Personal             paper->cardboard;composite->ink;fibre 32.8 20.5 2.6            
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              
413 413 1966.0293.001 Photograph collection CARDBOARD PAPER PHOTOGRAPHS CONSTRUCTION PAPER STAPLES INK BLUE SCREWS Canada from the Air   Royal Canadian Air Force       1927   circa   2 UNIDENTIFIABLE FINISH ON THE COVER OF THE ALBUM   A COLLECTION OF PHOTOGRAPHS OF CANADA TAKEN FROM THE AIR   Aviation Archives Miscellaneous             paper->cardboard;composite->ink;metal->steel 41.3 31.4 6.6            
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                                  
429 429 1966.0296.013 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
430 430 1966.0296.014 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
431 431 1966.0296.015 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
432 432 1966.0296.016 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
433 433 1966.0296.017 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
434 434 1966.0296.018 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
435 435 1966.0296.019 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
436 436 1966.0296.020 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
437 437 1966.0296.021 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
438 438 1966.0296.022 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
439 439 1966.0296.023 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
440 440 1966.0296.024 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
441 441 1966.0296.025 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
442 442 1966.0296.026 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
443 443 1966.0296.027 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
444 444 1966.0296.028 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
445 445 1966.0296.029 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
446 446 1966.0296.030 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
447 447 1966.0296.031 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
448 448 1966.0296.032 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
449 449 1966.0296.033 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
450 450 1966.0296.034 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
451 451 1966.0296.035 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
452 452 1966.0296.036 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
453 453 1966.0296.037 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
454 454 1966.0296.038 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
455 455 1966.0296.039 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
456 456 1966.0296.040 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
457 457 1966.0296.041 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
458 458 1966.0296.042 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
459 459 1966.0296.043 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
460 460 1966.0296.044 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
461 461 1966.0296.045 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
462 462 1966.0296.046 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
463 463 1966.0296.047 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
464 464 1966.0296.048 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
465 465 1966.0296.049 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
466 466 1966.0296.050 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
467 467 1966.0296.051 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
468 468 1966.0296.052 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
469 469 1966.0296.053 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
470 470 1966.0296.054 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
471 471 1966.0296.055 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
472 472 1966.0296.056 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
473 473 1966.0296.057 Card       Plane Facts Co. United States of America New york New york 1950 1960 circa   57         Aviation Miscellaneous                                  
485 485 1966.0306.002 Cable sample telephone COPPER CONDUCTOR POLYURETHANE INSULATION AND PROTECTIVE SHEATH     Canadian Northern Electric Co. Canada Qu√©bec Montr√©al 1960   circa   2 GREY OUTSIDE MANUFACTURED IN CANADA TO CONNECT MULTIPLE TELEPHONE/TELEGRAPH CIRCUITS BETWEEN TERMINATION POINTS; THAT IS SWITCHING MACHINE TO FLOOR OR BUILDINGS ETC. DEVELOPED ORIGINALLY TO REPLACE BUNDLES OF INDIVIDUAL WIRES Communications Telephony Transmission             metal->copper;synthetic->polyurethane 90 1.5              
498 498 1966.0318.002 Lamp bulb incandescent METAL BASE & FILAMENT/ GLASS BULB     Sylvania Unknown     1925   after   2 GOLD-COLOURED BASE WITH BLACK TIP/ FROSTED GLASS BULB   GENERAL LIGHTING   Lighting Technology Lamp bulbs               metal;glass 8.5 4.5              
500 500 1966.0319.002 Lamp bulb incandescent METAL BASE & FILAMENT/ GLASS BULB & STEM     LUMIART               2 CLEAR COLOURLESS GLASS BULB/ GOLD-COLOURED BASE WITH BLACK TIP   TO PROVIDE LIGHT   Lighting Technology Lamp bulbs               metal;glass 9.2 3.5              
502 502 1966.0320.002 Lamp bulb incandescent METAL BASE & FILAMENT/ GLASS BULB & STEM     Canadian General Electric               2 CLEAR COLOURLESS GLASS BULB/ GOLD-COLOURED BASE WITH BLACK TIP   TO PROVIDE LIGHT   Lighting Technology Lamp bulbs               metal;glass 10.5 3.5              
505 505 1966.0322.002 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
506 506 1966.0322.003 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
507 507 1966.0322.004 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
508 508 1966.0322.005 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
509 509 1966.0322.006 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
510 510 1966.0322.007 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
511 511 1966.0322.008 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
512 512 1966.0322.009 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
513 513 1966.0322.010 Lamp bulb incandescent GLASS BULB METAL BASE & FILAMENT/ CARTON & SUPPORT ARE CARDBOARD 63K   Unknown Unknown             10 CLEAR COLOURLESS GLASS BULB WHITE GLASS BEAD HOLDING LEAD-IN WIRES/ LEAD-IN WIRES REDDISH/ GOLD-COLOURED BASE GREENISH INSIDE   FOR USE AS AN INDICATOR LIGHT.   Lighting Technology Lamp bulbs               glass;metal 3.3 1.8              
517 517 1966.0326.001 Gun flare   4 Mk.1   Unknown Unknown             1 All black.       Aviation Aviation armament               metal->steel - possible;synthetic->bakelite - possible                  
518 518 1966.0327.001 Archival collection   Armament Notes     England     1923       11         Aviation Archives Personal                                
519 519 1966.0327.002                         11                                              
520 520 1966.0327.003                         11                                              
521 521 1966.0327.004                         11                                              
522 522 1966.0327.005                         11                                              
523 523 1966.0327.006                         11                                              
524 524 1966.0327.007                         11                                              
525 525 1966.0327.008                         11                                              
526 526 1966.0327.009                         11                                              
527 527 1966.0327.010                         11                                              

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
);