artefacts

108,463 rows sorted by material

✎ 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
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                                  
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                                              
544 544 1966.0338.005         Unknown Unknown                                                            
558 558 1966.0346.002                         2                                              
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              
676 676 1966.0442.002 Cap                       2         Vacuum Tubes Vacuum tube accessories                                  
696 696 1966.0462.002                         2                                              
706 706 1966.0469.002 Poster                       2                                              
723 723 1966.0486.002 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
724 724 1966.0486.003 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
725 725 1966.0486.004 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
726 726 1966.0486.005 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
727 727 1966.0486.006 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
728 728 1966.0486.007 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
729 729 1966.0486.008 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
730 730 1966.0486.009 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
731 731 1966.0486.010 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
732 732 1966.0486.011 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
733 733 1966.0486.012 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
734 734 1966.0486.013 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
735 735 1966.0486.014 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
736 736 1966.0486.015 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
737 737 1966.0486.016 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
738 738 1966.0486.017 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
739 739 1966.0486.018 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
740 740 1966.0486.019 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
741 741 1966.0486.020 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
742 742 1966.0486.021 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
743 743 1966.0486.022 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
744 744 1966.0486.023 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
745 745 1966.0486.024 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
746 746 1966.0486.025 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
747 747 1966.0486.026 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
748 748 1966.0486.027 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
749 749 1966.0486.028 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
750 750 1966.0486.029 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
751 751 1966.0486.030 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
752 752 1966.0486.031 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
753 753 1966.0486.032 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
754 754 1966.0486.033 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
755 755 1966.0486.034 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
756 756 1966.0486.035 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
757 757 1966.0486.036 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
758 758 1966.0486.037 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                
759 759 1966.0486.038 Photograph       Unknown Unknown     1920   between   97     Collection made up to form a slide show to provide an introduction to astronomy.   Astronomy Archives Photographs                                

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