MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Medium = 3492

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Begin Date, Object End Date, Credit Line, Classification

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
17417 96.5.115a 0 1 21919 Arms and Armor 5 Close-helmet 1311 Close-Helmet for the Tournament on Foot German, probably Dresden 109                           ca. 1640–50 1615 1675 Steel, leather, textile 3492 H. 11 in. (27.9 cm); W. 8 in. (20.3 cm.); D. 13 in. (33 cm); Wt. 9 lb. 1 oz. (4105 g) John Stoneacre Ellis Collection, Gift of Mrs. Ellis and Augustus Van Horne Ellis, 1896   possibly Dresden 417                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
17493 04.3.266 0 1 21995 Arms and Armor 5 Armor for a youth 1362 Armor for a Youth possibly Italian 144                           ca. 1570–80 and later 1545 1900 Steel, leather, textile 3492 H. approx. 58 in. (147.3 cm); Wt. 18 lb. 3 oz. (8249.7 g) Rogers Fund, 1904                       Armor for Man 44   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
17754 14.25.704a–o 0 0 22265 Arms and Armor 5 Composed armor for a youth 1479 Composed Armor for a Youth Italian, German, French, and American 178         Armorer|Etcher 111 Some elements made by|Etched decoration on some elements by Raymond Bartel|Stanley J. Rowland Sr. French, died 1949|American, Shelburne Falls, Massachusettes 1891–1964 Greenwich, Connecticut   Bartel, Raymond|Rowland, Stanley J. Sr. 2720 French 2 1849 |1891 1949 |1964 ca. 1560 and later 1535 1950 Steel, leather, textile 3492 H. approx. 55 in. (139.7 cm); Wt. 17 lb. 8 oz. (7937.9 g); Wt. of helmet 3 lb. 9 oz. (1615.9 g) Gift of William H. Riggs, 1913   New York 3   New York 126               Armor for Man 44   Metropolitan Museum of Art, New York, NY 1
17838 14.25.911 0 1 22349 Arms and Armor 5 Duelling gauntlet 1520 Left-Hand Duelling Gauntlet Italian 36                           ca. 1550–75 1525 1600 Steel, leather, textile 3492 Wt. 1 lbs. 9 oz. (708.7 g) Gift of William H. Riggs, 1913                       Armor Parts-Gauntlets 30   Metropolitan Museum of Art, New York, NY 1
20801 04.3.243 0 1 25397 Arms and Armor 5 Close Helmet 2395 Close Helmet German 27                           ca. 1500 1475 1525 Steel, leather, textile 3492 H. 11 in. (27.9 cm); W. 10 3/8 in. (26.4 cm); D. 11 1/2 in. (29.2 cm); Wt. 5 lb. 1 oz. (2296.3 kg) Rogers Fund, 1904                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
21619 48.149.30 0 1 26448 Arms and Armor 5 Close-helmet 1311 Close-Helmet for the Tilt Austrian, Innsbruck 139                           ca. 1580–90 1555 1615 Steel, leather, textile 3492 H. 13 in. (33 cm); W. 9 3/8 in. (23.8 cm); D. 13 1/8 in. (33.3 cm); Wt. 7 lb. 5 oz. (3321 g) Bequest of George D. Pratt, 1935   Innsbruck 433                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
21677 14.25.628 0 1 26507 Arms and Armor 5 Burgonet 1351 Burgonet German, Nuremberg 147         Armorer 98 Attributed to Kunz Lochner German, Nuremberg, 1510–1567   Lochner, Kunz 2724 German 10 1510 1567 ca. 1540–50 1515 1575 Steel, leather, textile 3492 H. 12 1/2 in. (31.8 cm); W. 7 7/8 in. (20 cm); D. 12 1/4 in. (31.1 cm); Wt. 3 lb. 15 oz. (1786 g) Gift of William H. Riggs, 1913   Nuremberg 149                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
21688 14.25.548 0 1 26518 Arms and Armor 5 Close-helmet 1311 Close-Helmet for the Tournament German, probably Augsburg 164                           late 16th century 1550 1600 Steel, leather, textile 3492 H. 15 1/4 in. (38.7 cm); W. 10 1/4 in. (26 cm); D. 13 1/4 in. (33.7 cm); Wt. 10 lb. 6 oz. (4700 g) Gift of William H. Riggs, 1913   probably Augsburg 440                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
21802 1999.462 0 0 26637 Arms and Armor 5 Arm guard 2564 Arm Guard Indian or Persian 401                           18th–19th century 1701 1900 Steel, leather, textile 3492 L. 24 1/4 inches (54 cm) Gift of Eric Vaule, 1999                       Armor Parts 47   Metropolitan Museum of Art, New York, NY 1
22188 14.25.491 0 1 27080 Arms and Armor 5 Siege helmet 2508 Siege Helmet French 7                           17th–18th century 1601 1800 Steel, leather, textile 3492 H. 10 15/16 in. (27.8 cm); W. 10 1/8 in. (25.7 cm); D. 15 1/2 in. (39.4 cm); Wt. 15 lb. 14 oz. (7201 g) Gift of William H. Riggs, 1913                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
22189 14.25.492 0 1 27081 Arms and Armor 5 Siege helmet 2508 Siege Helmet probably French 203                           late 17th century 1650 1700 Steel, leather, textile 3492 H. 11 3/16 in. (28.4 cm); W. 9 in. (22.9 cm); D. 15 1/4 in. (38.7 cm); Wt. 11 lb. 5.6 oz. (5148.3 g) Gift of William H. Riggs, 1913                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
22211 14.25.531 0 1 27104 Arms and Armor 5 Burgonet 1351 Burgonet South German 189                           ca. 1560 1535 1585 Steel, leather, textile 3492 H. 9 1/4 in. (23.5 cm); W. 8 in. (20.3 cm); D. 13 5/8 in. (34.6 cm); Wt. 4 lb. 4 oz. (1928 g) Gift of William H. Riggs, 1913                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
29023 29.158.289 0 0 34227 Arms and Armor 5 Thigh defense (Cuisse) 3720 Thigh Defense (Cuisse) German 27                           ca. 1510 1485 1535 Steel, leather, textile 3492 H. 13 1/2 in. (34.3 cm) Bashford Dean Memorial Collection, Funds from various donors, 1929                       Armor Parts-Thigh and Leg Defense 115   Metropolitan Museum of Art, New York, NY 1
29664 27.183.86 0 1 34873 Arms and Armor 5 Elements of a horse armor 3767 Elements of a Horse Armor German 27                           16th century 1501 1600 Steel, leather, textile 3492   Gift of Prince Albrecht Radziwill, 1927                       Armor for Horse 65   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 129.703ms · Data license: CC0 · Data source: metmuseum/openaccess