MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Medium = 3643

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, 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
17828 14.25.901a, b 0 1 22339 Arms and Armor 5 Pair of gauntlets 1317 Pair of Gauntlets from a Garniture of Armor of Philip II of Spain (reigned 1554–58) German, Augsburg 126         Etcher|Armorer 112   Ulrich Holzmann|Desiderius Helmschmid German, Augsburg, recorded 1535–62|German, Augsburg, 1513–1579   Holzmann, Ulrich|Helmschmid, Desiderius 2726 German|German 79 1535 |1513 1562 |1579 1546 1546 1546 Steel, leather, gold 3643 Gauntlet (a); H. 10 in. (25.5 cm); W. 4 3/4 in. (12 cm); D. 5 in. (12.7 cm); Wt. 1 lb. 1 oz. (475 g); gauntlet (b); H. 10 in. (25.5 cm); W. 4 3/4 in. (12 cm); D. 5 in. (12.7 cm); Wt. 16 oz. (439 g) Gift of William H. Riggs, 1913   Augsburg 424                   Armor Parts-Gauntlets 30   Metropolitan Museum of Art, New York, NY 1
19781 36.25.973a, b 0 1 24306 Arms and Armor 5 Dagger (Katar) and Sheath 2086 Dagger (Katar) and Sheath Indian, Mughal 312                           17th century 1601 1700 Steel, leather, gold 3643 L. 19 in. (48.26 cm) Bequest of George C. Stone, 1935                       Daggers 33   Metropolitan Museum of Art, New York, NY 1
21600 14.25.516 0 1 26429 Arms and Armor 5 Closed burgonet 2461 Closed Burgonet of "Savoyard" Type, Possibly Made for Théodore Agrippa d'Aubigné (1552–1630) Italian 36                           ca. 1600–1620 1575 1645 Steel, leather, gold 3643 H. 12 in. (30.5 cm); W. 10 in. (25.4 cm); D. 11 3/4 in. (29.8 cm); Wt. 9 lb. 11 oz. (4391 g) Gift of William H. Riggs, 1913                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
21603 14.25.560a–d 0 1 26432 Arms and Armor 5 Close-helmet 1311 Close-Helmet Italian, Milan or Brescia 268                           ca. 1515 1490 1540 Steel, leather, gold 3643 Bowl (a); H. 8 3/4 in. (22.2 cm); W. 7 7/8 in. (20 cm); D. 9 3/8 in. (23.8 cm); Wt. 3 lb. 11.4 oz. (1684 g); visor with bevor (b, c); H. 9 1/4 in. (23.5 cm); W. 8 3/4 in. (22.2 cm); D. 7 1/4 in. (18.4 cm); Wt. 2 lb. 4.6 oz. (1037.6 g); nape plates (d); H. 1 7/8 in. (4.8 cm); W. 8 1/2 in. (21.6 cm); D. 4 7/8 in. (12.4 cm); Wt. 4.8 oz. (136.1 g) Gift of William H. Riggs, 1913   Milan|Brescia 549                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
21695 14.25.518 0 1 26525 Arms and Armor 5 Closed burgonet 2461 Closed Burgonet French 7                           ca. 1630; bottom front and back collar lames, later restorations 1605 1655 Steel, leather, gold 3643 H. 16 1/4 in. (41.3 cm); W. 10 1/2 in. (26.67 cm); D. 15 3/4 in. (40 cm); Wt. 7 lb. (3177 g) Gift of William H. Riggs, 1913                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
22208 14.25.525 0 1 27101 Arms and Armor 5 Lobster-tail burgonet 2465 Lobster-Tail Burgonet North Italian 229                           ca. 1610 1585 1635 Steel, leather, gold 3643 H. 12 1/2 in. (31.8 cm); W. 11 in. (27.9 cm); D. 13 15/16 in. (35.4 cm); Wt. 3 lb. 12 oz. (1701 g) Gift of William H. Riggs, 1913                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
24564 37.188.1 0 0 29604 Arms and Armor 5 Miquelet lock 2865 Miquelet Lock Spanish 13         Lock maker 168   Gabriel de Algora Spanish, Madrid, documented 1733–died 1761   Algora, Gabriel de 2776 Spanish 76 1733 1761 1736 1736 1736 Steel, leather, gold 3643 L. 5 3/8 in. (13.7 cm); Wt. 14.7 oz. (416.7 g) Gift of Frank Schnittjer, 1937                       Firearms Parts 134   Metropolitan Museum of Art, New York, NY 1
24565 37.188.2 0 0 29605 Arms and Armor 5 Miquelet lock 2865 Miquelet Lock Spanish 13                           1800 1800 1800 Steel, leather, gold 3643 L. 6 in. (15.2 cm); Wt. 1 lb. 2.8 oz. (533 g) Gift of Frank Schnittjer, 1937   Madrid 467                   Firearms Parts 134   Metropolitan Museum of Art, New York, NY 1
27127 32.75.299a–c 0 1 32282 Arms and Armor 5 Sword with sheath 3409 Sword with Sheath Caucasian 64                           19th century 1801 1900 Steel, leather, gold 3643 H. with scabbard 39 7/8 in. (101.3 cm); H. without scabbard 37 5/8 in. (95.6 cm); W. 2 1/2 in. (6.4 cm); Wt. 1 lb. 10.6 oz. (754.1 g); Wt. of scabbard 7.9 oz. (224 g); Wt. of strap (c); 4.2 oz. (119.1 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Swords 29   Metropolitan Museum of Art, New York, NY 1
27561 26.145.85a, b 0 0 32725 Arms and Armor 5 Poignard with sheath 2345 Poignard with Sheath French 7                           1550–75 1550 1575 Steel, leather, gold 3643 L. with sheath 16 1/2 in. (41.9 cm); L. without sheath 15 7/8 in. (40.3 cm); L. of blade 11 1/8 in. (28.2 cm); W. 3 5/8 in. (9.2 cm); W. of blade 3/8 in. (1 cm); thickness of blade 3/8 in. (1 cm); Wt. 6 oz. (170.1 g); Wt. of sheath 1 oz. (28.3 g) Gift of Jean Jacques Reubell, in memory of his mother, Julia C. Coster, and of his wife, Adeline E. Post, both of New York City, 1926                       Daggers 33   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 119.853ms · Data license: CC0 · Data source: metmuseum/openaccess