artefacts

108,463 rows sorted by Width

✎ 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
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  
324 324 1966.0240.001 Stamp postage PAPER APOLLO 11 MOON LANDING   Unknown United States of America     1969   circa   1 MULTICOLOURED MOON ASTRONAUT & LANDER ON MAUVE GROUND.       Space Technology Commemorative Stamps & coins             paper             http://source.techno-science.ca/artifacts-artefacts/images/1966.0240.001.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0240.001.aa.cs.thumb.png  
326 326 1966.0242.001 Photograph collection PAPER PRINT PHOTOGRAPHS/ STORED IN 3 WOOD STORAGE CASES DAVENPORT COLLECTION   Davenport Locomotive Works United States of America Iowa Davenport         6         Railway Transportation Archives Motive power             paper;wood                  
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                                              
336 336 1966.0246.002 Manual Paper.     Kanehara Shuppan Co. Ltd. Japan   Tokyo         2         Medical Technology Medical equipment Machines & apparatus             paper             http://source.techno-science.ca/artifacts-artefacts/images/1966.0246.002.aa.cs.png http://source.techno-science.ca/artifacts-artefacts/images/1966.0246.002.aa.cs.thumb.png  
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                                              
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                  
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                                              
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                                  
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                                              

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