MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Classification = 42

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Culture, Artist Role, 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, Dimensions, 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
17424 04.3.291a–q, .292; etc. 0 1 21926 Arms and Armor 5 Jousting armor 1318 Jousting Armor German; restorations, French, Paris 113         Armorer 98 Helmet made by Daniel Tachaux French, 1857–1928, active in France and America   Tachaux, Daniel 2678 French 2 1857 1928 ca. 1500 and later 1475 1900 Steel, copper alloy, leather, textile, horn 3498 Helmet (a); Wt. 21.5 lb. (9752 g); breastplate (c); Wt. 23 lb. (10.4 kg); tassets (e, f); Wt. of each 6 lb. (2723 g); backplate (i); Wt. 5 lb. (2268 g); rondels (o, p); Wt. of each 5 lb. (2268 g); shield (q); Wt. 6 lb. (2723 g); Wt. overall 85.5 lb. (38.78 kg) Rogers Fund, 1904   Paris 27                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
18221 19.131.1a–r, t–w, .2a–f, l 0 1 22741 Arms and Armor 5 Armor garniture 1686 Armor Garniture, Probably of King Henry VIII of England (reigned 1509–47) British, Greenwich 162         Designer|Armorer 121 Design of the decoration attributed to|Made in the Hans Holbein the Younger|Royal Workshops at Greenwich German, Augsburg 1497/98–1543 London|British, Greenwich, 1511–1640s   Holbein, Hans, the Younger|Royal Workshops at Greenwich 2759 German|British 86 1497 |1511 1543 |1650 dated 1527 1527 1527 Steel, gold, leather, copper alloys 3800 H. 73 in. (185.4 cm); Wt. 62 lb. 12 oz. (28.45 kg) Purchase, William H. Riggs Gift and Rogers Fund, 1919   Greenwich 439                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
18353 23.261 0 1 22874 Arms and Armor 5 Armor for man and horse 1734 Armor for Man and Horse Presumably Made for Baron Pankraz von Freyberg (1508–1565) German, Landshut 173         Armorer 98   Wolfgang Grosschedel German, Landshut, active ca. 1517–62   Grosschedel, Wolfgang 2766 German 10 1517 1562 man's armor, ca. 1535–40; horse armor, dated 1554; saddle steels, later restorations 1510 1900 Steel; leather, copper alloy, textile 3818 Wt. of man's armor approx. 55 lb. 11 oz. (25.25 kg); Wt. of horse armor with saddle 65 lb. 7 oz. (29.69 kg) Fletcher Fund, 1923   Landshut 442                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
18837 32.75.248a–e, g–l 0 1 23360 Arms and Armor 5 Armor for man and horse 1734 Armor for Man and Horse Turkish 68                           ca. 1450–1550 1425 1575 Steel, leather 3500 Wt. of man's armor 31 lb. 2 oz. (14.12 kg); Wt. of horse armor 71 lb. 15 oz. (32.63 kg) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
19486 36.25.2a–qq 0 1 24010 Arms and Armor 5 Ceremonial armors for man (Dingjia) and horse 2026 Ceremonial Armors for Man (Dingjia) and Horse Chinese 10                           18th century 1701 1800 Steel, gold, silver, velvet, satin, iron, coral, malachite, turquoise, crystal, silk, cotton, brass, pearls, marten, feathers (kingfisher), paper, lacquer 4033 Helmet (a); H. including nape defense 19 in. (48.3 cm); H. excluding nape defense 11 1/2 in. (29.2 cm); W. 8 3/16 in. (20.8 cm); D. 9 3/4 in. (24.8 cm); Wt. 3 lbs. 11.8 oz. (1695.3 g); helmet lining (b); Wt. 2.8 oz. (79.4 g) Bequest of George C. Stone, 1935                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
20464 90.4.1, .2 0 0 24999 Arms and Armor 5 Miniature Italian-style armor for man and horse 1631 Miniature Italian-Style Armor for Man and Horse French 7         Armorer 98 Possibly made by Granger LeBlanc French, active ca. 1840–70   LeBlanc, Granger 2747   1815 1895 ca. 1860 1860 1860 Steel, brass, leather, bronze 4416 H. of armor for man as mounted approx. 11 3/4 in. (29.9 cm); horse armor as mounted approx.: 11 x 13 1/4 in. (27.9 x 33.7 cm) Gift of Henry G. Marquand, 1890                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
21751 29.150.9 0 1 26585 Arms and Armor 5 Composed armor for man and horse 2532 Composed Armor for Man and Horse European, Italy, Spain, Flanders and England 496         Armorer|Armorer 109 Left reinforcing elbow stamped with marks belonging to the|Shaffron stamped with marks attributed to Missaglia workshop|Ambrogio de Osma Italian, Milan, recorded 1430–1529|Italian, Brescia, documented 1446–75   Missaglia workshop|Osma, Ambrogio de 2988 Italian|Italian 93 1430 |1446 1529 |1475 ca. 1450–1525 and later 1425 1550 Steel, brass, leather, textile (velvet, wool), iron 4784 Wt. of armor for man 59 lb. 4 oz. (26.88 kg); Wt. of helmet 3 lb. 12 oz. (1697 g); 29.150.9v (mail shirt): H. 31 1/2 in. (80.0 cm); W. 45 11/16 in. (116.0 cm); W. of chest 24 in. (61.0 cm); Diam. (outside) of solid links 13/32 in. (10.2 mm); Diam. (inside) of solid links 9/32 in. (7.3 mm); Diam. (outside) of riveted links 3/8 in. (9.5 mm); Diam. (inside) of riveted links 9/32 in. (7.0 mm); Diam. (outside) of latten solid links 3/8 in. (9.1 mm); Diam. (inside) of latten solid links 1/4 in. (6.4 mm); Diam. (outside) of latten riveted links 3/8 in. (9.3 mm); Diam. (inside) of lattened riveted links 5/16 in. (7.8 mm); Diam. (outside) of collar links 11/32 in. (8.5 mm); Diam. (inside) of collar links 1/4 in. (6.2 mm). Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
22404 29.158.4a–bb, ee–oo, rr–ww 0 1 27302 Arms and Armor 5 Armor for man and horse with horse trappings 2697 Armor for Man and Horse with Horse Trappings German 27                           ca. 1515 and later 1490 1900 Steel, wood, leather, velvet, brass, feathers (peacock) 5022 Wt. of armor for man 61 lb. 11 oz. (28.05 kg); Wt. of armor for horse 63 lb. 13 oz. (29.00 kg); 29.158.4aa (shaffron); H. 27 in. (68.6 cm); W. 13 in. (33 cm); D. 15 in. (38.1 cm); Wt. 8 lb. 0.6 oz. (3645.7 g) Bashford Dean Memorial Collection, Funds from various donors, 1929                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30191 36.25.3a–v 0 1 35718 Arms and Armor 5 Armor with equestrian equipment 3820 Armor with Equestrian Equipment Chinese 10                           late 18th–19th century 1750 1900 Steel, copper, gold, silk, leather, hair 7201 Helmet (a); H. 10 3/4 in. (27.3 cm); W. 8 in. (20.3 cm); D. 10 1/4 in. (26 cm); Wt. 2 lbs. 7.2 oz. (1117 g) Bequest of George C. Stone, 1935                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30209 29.151.2a–s; 29.158.183–.184; 32.69a–q 0 1 35739 Arms and Armor 5 Armor for man and horse 1734 Armor for Man and Horse German, Nuremberg 147         Armorer 98   Kunz Lochner German, Nuremberg, 1510–1567   Lochner, Kunz 2724 German 10 1510 1567 dated 1548, with later restorations 1548 1900 Steel, leather, copper alloy, textile 3620 man's armor: Wt. approx. 56 lb. (25.4 kg); horse armor with saddle: Wt. 92 lb. (41.7 kg) man's armor: Bashford Dean Memorial Collection, Gift of Mrs. Bashford Dean, 1929; mail sleeves: Bashford Dean Memorial Collection, Funds from various donors, 1929; horse armor: Rogers Fund, 1932   Nuremberg 149                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30221 14.25.709a–p; 21.139.1a–x,.8,.12; 1984.356 0 1 35772 Arms and Armor 5 Armor for man and horse 1734 Armor for Man and Horse Italian, Milan and Brescia 1257                           man's armor, ca. 1570 and later; horse armor, ca. 1580–90 and later 1545 1900 Steel, leather, copper alloy, textile 3620 as mounted, H. of horse armor 75 1/2 in. (191.8 cm); L. of horse armor 90 in. (228.6 cm); W. of horse armor 30 in. (76.2 cm); Wt. of horse armor including saddle 93 lb. 1 oz. (42.2 kg); Wt. of man's armor approx. 37 lb. (16.78 kg) man's armor: Gift of William H. Riggs, 1913; horse armor, bit, rear plate of saddle: Fletcher Fund, 1921; part of a greave: Rogers Fund, 1984   Milan and Brescia 441                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30224 19.131.1a–r, t–w, .2a–c; 27.183.16 1 1 35775 Arms and Armor 5 Armor garniture 1686 Armor Garniture, Probably of King Henry VIII of England (reigned 1509–47) British, Greenwich 162         Designer|Armorer 121 Design of the decoration attributed to|Made at the Hans Holbein the Younger|Royal Workshops at Greenwich German, Augsburg 1497/98–1543 London|British, Greenwich, 1511–1640s   Holbein, Hans, the Younger|Royal Workshops at Greenwich 2759 German 10 1497 |1511 1543 |1650 dated 1527 1527 1527 Steel, gold, leather, copper alloys 3800 H. 73 in. (185.4 cm); Wt. 62 lb. 12 oz. (28.45 kg) Armor: Purchase, William H. Riggs Gift and Rogers Fund, 1919; mail brayette: Gift of Prince Albrecht Radziwill, 1927   Greenwich 439                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30234 14.25.1661b;29.150.5,.70,.80;29.156.66k... 0 1 35789 Arms and Armor 5 Composite armor 1814 Composite Armor Austrian, Innsbruck and Mühlau 1259         Armorer|Armorer|Armorer 177 Rondel by|Sallet by|Breastplate and backplate by Kaspar Riederer|Jörg Wagner|Hans Prunner Austrian, Innsbruck and Mühlau, active 1455–99|Austrian, Innsbruck, recorded 1485–92|Austrian, Innsbruck, recorded 1482–99   Riederer, Kaspar|Wagner, Jörg|Prunner, Hans 3135 Austrian|Austrian|Austrian 113 1455 |1485 |1482 1499 |1492 |1499 comprehensively ca. 1485–95 1460 1520 Steel 658   Rondel (14.25.1661b): Gift of William H. Riggs, 1913; sallet, backplate, breastplate (29.150.5a, .70, .80): Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928; couter (29.156.66k): Bashford Dean Memorial Collection, Gift of Edward S. Harkness, 1929; gauntlet (29.158.255b): Bashford Dean Memorial Collection, Funds from various donors, 1929   Innsbruck and Mühlau 696                   Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30237 29.150.9ff, gg 0 1 35792 Arms and Armor 5 Cantle plates 3843 Cantle Plates possibly Flemish or British 1260                           ca. 1475–1525 1475 1525 Steel 658 15 1/2 x 6 1/2 in. (39.4 x 16.5 cm); Wt. 2 lb. 4 oz. (1021 g) Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928                       Armor for Horse and Man 42   Metropolitan Museum of Art, New York, NY 1
30342 32.75.248,04.3.208,36.25.576,610,.1829... 0 1 35952 Arms and Armor 5 Armor for man and horse 1734 Armor for Man and Horse Syrian, Iranian, and Turkish 1268                           comprehensively ca. 1450–1550 1425 1575 Steel, leather 3500 Wt. of man's armor, 31 lb. 2 oz. (14.12 kg); L. of shaffron 22 5/8 in. (57.5 cm); Wt. of shaffron 3 lb. 12 oz. (1694 g); Wt. of horse armor, 71 lb. 15 oz. (32.63 kg) Armor for man and horse: The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932 Helmet: Rogers Fund, 1904 Shield, Ax, Saddle, Stirrups: Bequest of George C. Stone, 1935 Crinet: Rogers Fund, 1972                       Armor for Horse and Man 42   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 136.421ms · Data license: CC0 · Data source: metmuseum/openaccess