artefacts

108,463 rows sorted by ArtifactFinish

✎ 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
355 355 1966.0250.014                         16                                              
356 356 1966.0250.015                         16                                              
357 357 1966.0250.016                         16                                              
390 390 1966.0279.001 Token METAL Aeroplane Aviation West 1910   Unknown Canada     1910   circa   1     TOKEN COMMEMORATES THE 'AEROPLANE AVIATION WEST' SHOW IN MONTREAL HELD JUNE 25-JULY 4 1910   Aviation Commemorative Memorabilia             metal 22 12.5         http://source.techno-science.ca/artifacts-artefacts/images/1966.0279.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0279.001.aa.cs.thumb.png  
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                                              
400 400 1966.0287.002 Filter METAL/ GLASS   EA7126 (LENS)                 5         Photography Still cameras Specialized Aviation Miscellaneous   Exploration and Survey Photogrammetry Photographic equipment metal;glass             http://source.techno-science.ca/artifacts-artefacts/images/1966.0287.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0287.002.aa.cs.thumb.png  
401 401 1966.0287.003   CLOTH/ DESICCANT                     5                           fibre             http://source.techno-science.ca/artifacts-artefacts/images/1966.0287.003.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0287.003.aa.cs.thumb.png  
402 402 1966.0287.004   PLASTIC                     5                           synthetic->plastic             http://source.techno-science.ca/artifacts-artefacts/images/1966.0287.004.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0287.004.aa.cs.thumb.png  
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                                              
407 407 1966.0289.001 Nameplate METAL     RATIER P. CONSTRUCTEUR France   Montrouge 1909   after   1     IDENTIFIED THE COMPANY THAT BUILT THE AIRCRAFT PART.   Aviation Miscellaneous               metal 7.5 4         http://source.techno-science.ca/artifacts-artefacts/images/1966.0289.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0289.001.aa.cs.thumb.png  
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                                  
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                                  
514 514 1966.0323.001 Gun machine STEEL BROWNING M3 AIRCRAFT BASIC 1C3136 Canadian Arsenals Ltd.               1     AUTOMATIC GUN DELIVERING CONTINUOUS FIRE   Aviation Aviation armament               metal->steel 124 8.5 12.5       http://source.techno-science.ca/artifacts-artefacts/images/1966.0323.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0323.001.aa.cs.thumb.png  
515 515 1966.0324.001 Gun machine STEEL BROWNING M3 AIRCRAFT BASIC 1L4741 Canadian Arsenals Ltd.               1     AUTOMATIC GUN DELIVERING CONTINUOUS FIRE   Aviation Aviation armament               metal->steel 124 8.5 12.5       http://source.techno-science.ca/artifacts-artefacts/images/1966.0324.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0324.001.aa.cs.thumb.png  
516 516 1966.0325.001 Gun machine STEEL BROWNING M3 AIRCRAFT BASIC 1C2682 Canadian Arsenals Ltd.               1     AUTOMATIC GUN DELIVERING CONTINUOUS FIRE   Aviation Aviation armament               metal->steel 124 8.5 12.5       http://source.techno-science.ca/artifacts-artefacts/images/1966.0325.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0325.001.aa.cs.thumb.png  
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                                              
528 528 1966.0327.011                         11                                              
530 530 1966.0329.001 Notebook PAPER/ INK     MACKAY J.C.       1863 1864 between   2     COMPILATION OF MATHEMATICAL EXERCISES TO BE REVIEWED BY INSTRUCTOR & COMPLETED BY STUDENTS. TYPE SAMPLE Mathematics Archives Miscellaneous             paper->;composite->ink                  
531 531 1966.0329.002 Notebook PAPER/ INK     MACKAY J.C.       1863 1864 between   2     COMPILATION OF MATHEMATICAL EXERCISES TO BE REVIEWED BY INSTRUCTOR & COMPLETED BY STUDENTS. TYPE SAMPLE Mathematics Archives Miscellaneous             paper->;composite->ink                  
544 544 1966.0338.005         Unknown Unknown                                                            
554 554 1966.0344.002 Bowl ALL METAL     MELOTTE Belgium   Remicourt         3         Agriculture Dairying Non-industrial processing             metal                  
555 555 1966.0344.003   ALL METAL     MELOTTE Belgium   Remicourt         3         Agriculture Dairying Non-industrial processing             metal                  
557 557 1966.0346.001 Patent   HAYLEY CONCRETE MIXER 117392 Government of Canada Patent Office Canada Ontario Ottawa 1909     PATENT NO. 117392 2   TYPE SAMPLE GRANTS EXCLUSIVE RIGHT PRIVILEGE & FREEDOM TO MAKE USE & SELL THE PATENTED ITEM OR IMPROVEMENT IN CANADA FOR 18 YEARS TO THE PATENT HOLDER (1909)   Industrial Technology Archives               paper;fibre             http://source.techno-science.ca/artifacts-artefacts/images/1966.0346.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0346.001.aa.cs.thumb.png  
558 558 1966.0346.002                         2                                              
559 559 1966.0347.001 Certificate     420 CANADA GRAND TRUNK TELEGRAPH CO. Canada Ontario Toronto 1855       1   SHARE CERTIFICATE FOR EARLY CANADIAN TELEGRAPH CO.     Communications Archives               paper                  
560 560 1966.0348.001 Archival collection       ST. LAWRENCE & SAGUENAY LINE Canada     1877 1886 between   3   TYPE SAMPLES     Marine Transportation Archives               paper                  
561 561 1966.0348.002 Pass boarding       OTTAWA RIVER NAVIGATION CO. Canada Ontario Ottawa         3                                              
562 562 1966.0348.003 Ticket       INTERNATIONAL STEAMSHIP CO.               3                                              
563 563 1966.0349.001 Drawing   SPRING BALANCE FOR ENGINES W-Z 950 GRAND TRUNK RAILWAY MECHANICAL DEPT. Canada     1871       1         Railway Transportation Archives Operations               35 28.3              
671 671 1966.0438.001 Vacuum tube GLASS/ METAL/ SYNTHETIC 35T K3 EITEL MCCULLOUGH INC. United States of America California San bruno         1         Vacuum Tubes Transmitting Triode             glass;metal;synthetic 13.7 4.5         http://source.techno-science.ca/artifacts-artefacts/images/1966.0438.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0438.001.aa.cs.thumb.png  

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