MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

27 rows where Classification = 40

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
17421 04.3.267–.269 0 0 21923 Arms and Armor 5 Half-armor (Composed) 1315 Half-Armor (Composed) German 27                           dated 1562 (helmet ca. 1560) 1562 1562 Steel, leather, copper alloy 3495 Helmet (04.3.267a); H. 14 3/4 in. (37.5 cm); W. 9 1/8 in. (23.2 cm); D. 13 1/4 in. (33.7 cm); Wt. 11 lb. 3.1 oz. (5077.4 g); Wt. overall 44 lbs. (19.96 kg) Rogers Fund, 1904                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17494 04.3.270a–o 0 1 21996 Arms and Armor 5 Half armor 1363 Half Armor Probably Made for Don Gonzalo Fernández de Córdoba y Fernández de Córdoba, Duke of Sessa (1520/1524–1578) Italian, Milan 120         Armorer 98 Attributed to Lucio Piccinino Italian, Milan, active ca. 1575–90   Piccinino, Lucio 2697 Italian 6 1550 1615 ca. 1560 and later 1535 1900 Steel, gold 3497 Wt. approx. 30 lb. 7 oz. (13.8 kg); Wt. of helmet approx. 7 lb. 11 oz. ( Rogers Fund, 1904   Milan 420                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17675 14.25.714a–h, j 0 1 22184 Arms and Armor 5 Armor 1320 Armor of the Dukes of Alba Italian, Milan 120         Armorer 98   Lucio Piccinino Italian, Milan, active ca. 1575–90   Piccinino, Lucio 2697 Italian 6 1550 1615 ca. 1575–85 1550 1610 Steel, gold, silver 3516 Wt. 25 lbs. 12 oz. (11.68 kg); Helmet (a) H. 12 in. (30.5 cm); W. 8 1/2 in. (21.6 cm); D. 11 1/2 in. (29.2 cm); Wt. 5 lbs. 1 oz. (2,296.31 g); Colletin (b) H. 7 in. (17.8 cm); W. 11 7/16 in. (29.1 cm); Wt. 2 lbs. 2 oz. (963.88 g); Breastplate (c) H. 18 1/8 in. (46.0 cm); W. 15 in. (38.1 cm); D. 7 7/8 in. (19.9 cm); Wt. 5 lbs. 4 oz (2,381.36 g); Backplate (d) H. 14 5/8 in. (37.2 cm); W. 14 5/8 in. (37.2 cm); Wt. 3 lbs. 3 oz. (1,445.83 g); Pauldron right (e) H. 10 1/2 in. (26.7 cm); W. 11 5/8 in. (29.5 cm); Wt. 2 lbs. 9 oz. (1,162.33 g); Pauldron left (f) H. 10 3/8 in. (26.4 cm); W. 11 in. (27.9 cm); Wt. 2 lbs. 12 oz. (1,247.38 g); Arm Defense right (g) L. 18 1/2 in. (46.9 cm); Wt. 2 lbs. 7 oz. (1,105.63 g); Arm Defense left (h) L. 18 1/4 in. (46.4 cm); Wt. 2 lbs. 6 oz. (1,077.28 g) Gift of William H. Riggs, 1913   Milan 420                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17735 14.25.666a–i 0 0 22244 Arms and Armor 5 Half armor 1363 Half Armor French 7                           ca. 1660 and later 1635 1900 Steel, leather, textile 3492 Wt. 47 lb. 14 oz. (21.72 kg); Wt. of helmet 5 lb. 7 oz. (2466 g) Gift of William H. Riggs, 1913                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17739 14.25.679a–j 0 1 22248 Arms and Armor 5 Composed half armor 1472 Composed Half Armor German 27                           ca. 1540 and later 1515 1900 Steel, copper alloy, leather 3630 Wt. 58 lb. (26.31 kg); Wt. of helmet 4 lb. 3 oz. (1899.4 g) Gift of William H. Riggs, 1913                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17740 14.25.682b–j 0 0 22250 Arms and Armor 5 Half armor 1363 Half Armor Italian 36                           ca. 1570 1545 1595 Steel, leather 3500 Wt. 22 lb 11 oz. (10.29 kg) Gift of William H. Riggs, 1913                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17741 14.25.684a–i 0 1 22251 Arms and Armor 5 Half armor 1363 Half Armor German, Nuremberg 147         Armorer 98 Attributed to Martin Schneider the Younger German, Nuremberg, active ca. 1610–20   Schneider the Younger, Martin 2717 German 10 1610 1620 1610–20 1610 1620 Steel 658 Wt. 41 lb. 15 oz. (19.01 kg) Gift of William H. Riggs, 1913   Nuremberg 149                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17749 14.25.699a–g 0 0 22260 Arms and Armor 5 Half armor 1363 Half Armor German 27                           ca. 1560 and later; restoration of decoration, 19th century 1535 1900 Steel, leather 3500 Wt. 29 lb. 5 oz. (13.3 kg); Wt. of helmet 4 lb. 9 oz. (2069.5 g) Gift of William H. Riggs, 1913                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17751 14.25.701 0 1 22262 Arms and Armor 5 Half armor 1363 Half Armor German 27                           ca. 1500 and 19th century 1475 1900 Steel, leather 3500 Wt. approx. 44 lb. 10 oz. (20.25 kg); Wt. of helmet approx. 7 lb. 4 oz. (3300 g) Gift of William H. Riggs, 1913                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17758 14.25.710a–f 0 1 22269 Arms and Armor 5 Armor 1320 Armor of Giovanni Battista Bourbon del Monte (1541–1614) Italian, possibly Brescia 180                           ca. 1590 1565 1615 Steel, gold, textile, leather 3635 Wt. of helmet 4 lb. 12 oz. (2155 g) Gift of William H. Riggs, 1913   possibly Brescia 444                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17759 14.25.711a–d 0 1 22270 Arms and Armor 5 Armor 1320 Armor Northern German, possibly Brunswick-Wölfenbüttel 181                           ca. 1560–65 1535 1590 Steel, leather 3500 Wt. 28 lb. 14 oz. (13.1 kg); helmet: Wt. 5 lb. 10 oz. (2551 g); breastplate: Wt.10 lb. 15oz. (4961 g) Gift of William H. Riggs, 1913   possibly Brunswick-Wölfenbüttel 445                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17761 14.25.713a–n 0 1 22272 Arms and Armor 5 Half armor 1363 Half Armor probably Austrian, Innsbruck 182                           ca. 1560 and later 1560 1900 Steel, leather 3500 Wt. 37 lb. 5 oz. (16.92 kg); Wt. of helmet 5 lb. 7 oz. (2466.4 g) Gift of William H. Riggs, 1913   probably Innsbruck 446                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17764 14.25.716b–f 1 1 22275 Arms and Armor 5 Elements of a light-cavalry armor 1484 Elements of a Light-Cavalry Armor Italian, Milan 120                           ca. 1510 1485 1535 Steel, gold, copper alloy 3533 Wt. 19 lb. 13 oz. (8987 g) Gift of William H. Riggs, 1913   Milan 420                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17768 14.25.720 0 1 22279 Arms and Armor 5 Infantry armor 1486 Infantry Armor German, Nuremberg 147                           ca. 1600 1575 1625 Steel, leather 3500 H. 49 1/14 in. (125 cm) Gift of William H. Riggs, 1913   Nuremberg 149                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
17992 14.100.120a–g 0 1 22505 Arms and Armor 5 Armor (Dō-maru) 1589 Armor (Dō-maru) Japanese 35                           armor, ca. 1550; helmet, 18th century 1525 1800 Iron, leather, lacquer, silk, gilt copper 3688 H. 35 1/2 in. (90.2 cm); Wt. of helmet 8 lb. 6 oz. (3799 g); Wt. of cuirass 23 lb. 9 oz. (10.7 kg) Gift of Bashford Dean, 1914                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
18110 16.154.3a–l 0 1 22628 Arms and Armor 5 Half armor 1363 Half Armor Italian 36                           ca. 1600; cheekplates of helmet and part of left gauntlet thumb, probably 19th century 1575 1900 Steel, brass 323 Wt. approx. 25 lb. 14 oz. (11.74 kg); Wt. of helmet 3 lb. 5 oz. (1502.5 g) Rogers Fund, 1916                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
18111 16.154.2a–l 0 1 22629 Arms and Armor 5 Infantry armor 1486 Infantry Armor Italian 36         Armorer 98 Upper plate of the gorget, skirt lames, and cheek pieces made by Daniel Tachaux French, 1857–1928, active in France and America in the Metropolitan Museum of Art, Armor Workshop Tachaux, Daniel 2678   1857 1928 dated 1571; upper plate of the gorget, skirt lames, and cheek pieces, 1917 1571 1917 Steel, leather, brass 3756 Wt. 33 lb. 11 oz. (15.28 kg) Rogers Fund, 1916                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
18492 27.183.93 0 1 23014 Arms and Armor 5 Elements of a half armor 1788 Elements of a Half Armor German, Nuremberg 147                           16th century and later 1501 1900 Steel 658 Wt. 31 lb. 14 oz. (14.46 kg); Wt. of helmet 5 lb. 5 oz. (2409.7 g) Gift of Prince Albrecht Radziwill, 1927   Nuremberg 149                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
18494 27.206a–l 0 1 23016 Arms and Armor 5 Foot-combat armor 1790 Foot-Combat Armor of Prince-Elector Christian I of Saxony (reigned 1586–91) German, Augsburg 126         Armorer|Decorator 117 Decoration attributed to Anton Peffenhauser|Jörg Sorg the Younger German, Augsburg, 1525–1603|German, Augsburg, ca. 1522–1603   Peffenhauser, Anton|Sorg the Younger, Jörg 2778 German|German 79 1525 |1500 1603 |1625 1591 1591 1591 Steel, gold, leather, copper alloy 3645 H. 38 11/16 in. (98.2 cm); Wt. 46 lb. 3 oz. (20.96 kg); helmet Wt. 11 lb. 9 oz. (5245 g) Gift of Henry Walters, 1927   Augsburg 424                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
18568 29.150.6 0 1 23090 Arms and Armor 5 Half armor 1363 Half Armor German, Augsburg 126         Armorer 98 Helmet and reinforcing pieces attributed to Kolman Helmschmid German, Augsburg 1471–1532   Helmschmid, Kolman 2700 German 10 1471 1532 ca. 1510–20 and later 1485 1545 Steel 658 as mounted, H. 37 in. (94 cm) Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928   Augsburg 424                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
20287 50.237.1a–e, h–i 0 1 24816 Arms and Armor 5 Portions of a ceremonial armor 2250 Portions of a Ceremonial Armor French 7                           ca. 1575–80 1550 1605 Steel, copper alloy, gold, leather, textile 4333 Wt.. Overall 17 lb. 7 oz. (7910 g); Wt. of Helmet (a), 4 lbs. 13 oz. (2182.91 g); Wt. of Breastplate (b), 2 lbs. 14 oz. (1304.08 g); Wt. of Tassets (c-d), 2 lbs. 1 oz. (935.53 g); Wt. of Backplate (e), 3 lbs. 1 oz. (1389.13 g); Wt. of Arms (f-g), 2 lbs. 7 oz. (1105.63 g); Wt. of Gauntlets (h-i), 1 lb. (453.59 g) Gift of Alan Rutherfurd Stuyvesant, 1950                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
20412 1991.4 0 1 24945 Arms and Armor 5 Elements of a light-cavalry armor 1484 Elements of a Light-Cavalry Armor Austrian, Innsbruck or Mühlau 214         Armorer 98   Christian Schreiner the Younger Austrian, Mühlau, recorded 1499–1528   Schreiner the Younger, Christian 2924 Austrian 66 1499 1528 ca. 1505–10 1480 1535 Steel, leather 3500 H. as mounted approximately 32 in. (81.28 cm); Wt. 21 lb. 7 oz. (9724 g) Purchase, Mr. and Mrs. Arthur Ochs Sulzberger Gift, in honor of Helmut Nickel, 1991   Innsbruck 433                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
27045 04.3.282 0 1 32198 Arms and Armor 5 Portions of an armor garniture 1474 Portions of an Armor Garniture German, Augsburg 126         Etcher 104   Jörg Sorg the Younger German, Augsburg, ca. 1522–1603   Sorg the Younger, Jörg 2971 German 10 1500 1625 ca. 1550–55, some etched decoration, 19th century 1525 1900 Steel, gold, leather, velvet 6521   Rogers Fund, 1904   Augsburg 424                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
30259 50.237.1a–e, h–i; 29.150.11g–h 0 1 35824 Arms and Armor 5 Portions of a ceremonial armor 2250 Portions of a Ceremonial Armor French 7                           ca. 1575–80 1550 1605 Steel, copper alloy, gold, leather, textile 4333 Wt. 17 lb. 7 oz. (7910 g) armor: Gift of Alan Rutherfurd Stuyvesant, 1950; mail sleeves: Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
30269 14.100.120a, b 0 1 35841 Arms and Armor 5 Helmet (Hoshi kabuto) 1572 Helmet (Hoshi Kabuto) Japanese 35                           18th century 1701 1800 Iron, lacquer, gilt copper, leather, silk 3779 Wt. 8 lb. 6 oz. (3799 g) Gift of Bashford Dean, 1914                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
30322 29.156.67b–g, j–q 0 1 35919 Arms and Armor 5 Portions of a jousting half armor 3872 Portions of a Jousting Half Armor German 27                           ca. 1500 and later 1475 1900 Steel, leather 3500 Wt. 48 lb. 13 oz. (22.14 kg); mail sleeve (29.156.67o): L. 27 5/8 in. (70 cm); W. 13 in. (33 mm.); Diam. (outside) of links 13/32 in. (10.5 mm.); Diam. (inside) of links 5/16 in. (7.9 mm); Diam. (outside) of earlier solid links 7/16 in. (10.7 mm); Diam. (inside) of earlier solid links 1/4 in. (6.5 mm); Diam. (outside) of riveted links 13/32 in. (10.5 mm); Diam. (inside) of riveted links 9/32 in. (7.4 mm); mail sleeve (29.156.67p): L. 22 in. (56 cm); W. 13 in. (33 cm); Diam. (outside) of links 13/32 in. (10.7 mm); Diam. (inside) of links 9/32 in. (7.2 mm). Bashford Dean Memorial Collection, Gift of Edward S. Harkness, 1929                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
393325 14.100.120c–g 0 1 645797 Arms and Armor 5 Cuirass of a Dō-maru 1583 Cuirass of a Dō-maru Japanese 35                           ca. 1550 1525 1575 Iron, leather, lacquer, silk, gilt copper 3688 H. 35 1/2 in. (90.2 cm); W. 22 in. (55.9 cm); Wt. 23 lb. 9 oz. (10.7 kg) Gift of Bashford Dean, 1914                       Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 248.878ms · Data license: CC0 · Data source: metmuseum/openaccess