MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Medium = 22415

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Culture, Artist Role, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line, Country, 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
111688 48.174.73a–p, aa–pp, q 0 1 199956 European Sculpture and Decorative Arts 3 Chessmen and box-board 7967 Chessmen (32) and box-board German 27         Designer|Maker 4 Design attributed to Andreas Schluter, Danzig and the Court of Berlin|Friederich Donaleitis Konigsberg   Schluter Andreas|Donaleitis Friederich 10331   1675 1705 late 18th century 1785 1799 Silver, silver-gilt 22415 Height (each king): 3 in. (7.6 cm); Height (each pawn): 2 in. (5.1 cm); Overall (board): 3 3/4 × 17 1/8 × 17 1/8 in. (9.5 × 43.5 × 43.5 cm) Gift of Gustavus A. Pfeiffer, 1948                       Chess Sets 338   Metropolitan Museum of Art, New York, NY 1
113206 53.71.83a–p, aa–pp, r 0 0 201499 European Sculpture and Decorative Arts 3 Chessmen 7963 Chessmen (32) German 27                           second half 19th century 1850 1899 Silver, silver-gilt 22415 King: each, H. 3 3/4 in. (9.5 cm); Pawn: each, H. 2 1/4 in. (5.7 cm.); Only the tallest and shortest examples of chessmen measured for basic record. Gift of Gustavus A. Pfeiffer, 1953                       Chess Sets 338   Metropolitan Museum of Art, New York, NY 1
121805 00.19.63 0 0 211524 European Sculpture and Decorative Arts 3 Souvenir spoon 7049 Souvenir spoon British, Sheffield 2294         Maker 1   John Round & Son, Ltd. Sheffield and London   Round, John & Son, Ltd. 12284   1850 1950 1896–97 1896 1897 Silver, silver-gilt 22415 Length: 4 1/4 in. (10.8 cm) Gift of Sir William H. Redding, in memory of his wife, 1900                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
139678 2008.543.20 0 1 236594 European Sculpture and Decorative Arts 3 Pilgrim flask 9103 Pilgrim flask German, Leipzig 3260         Maker 1   I.P.S.     I.P.S. 12749       ca. 1680–1700 1675 1705 Silver, silver-gilt 22415 Overall (confirmed, wt. not confirmed): 17 5/8 x 9 7/16 x 5 5/8 in., 4.2lb. (44.8 x 24 x 14.3 cm, 1.89kg) Gift of Mrs. Charles Wrightsman, 2008                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
324629 17.190.361 1 1 464341 Medieval Art 6 Reliquary statuette 14707 Reliquary Statuette of Saint Christopher French 7                           ca. 1375–1425 1375 1425 Silver, silver-gilt 22415 Overall: 23 7/8 x 11 5/8 x 7 13/16 in. (60.6 x 29.5 x 19.8 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Toulouse 1363                   Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
324635 17.190.367a, b 0 0 464347 Medieval Art 6 Statuette 14 Standing Virgin and Child German 27                           19th century (second half of 15th century style) 1800 1899 Silver, silver-gilt 22415 Overall: 16 5/16 x 5 15/16 x 5 9/16 in. (41.4 x 15.1 x 14.1 cm) a only (V+C): 12 7/8 x 4 13/16 x 4 3/16 in. (32.7 x 12.3 x 10.7 cm) b only (base): 4 5/16 x 5 15/16 x 5 9/16 in. (11 x 15.1 x 14.1 cm) Gift of J. Pierpont Morgan, 1917                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
326165 1984.196 0 1 466113 Medieval Art 6 Flask 96 Flask with the Adoration of the Magi Byzantine 1134                           500s 500 599 Silver, silver-gilt 22415 Overall: 12 3/8 x 3 7/8 in. (31.5 x 9.9 cm) Purchase, Frederick C. Hewitt Fund, by exchange; Rogers Fund and Schimmel Foundation Inc. Gift; Gifts of J. Pierpont Morgan, Mr. and Mrs. Marc B. Rojtman, Mr. and Mrs. John D. Rockefeller Jr., Lucy W. Drexel and Anonymous, by exchange; Bequests of Mary Stillman Harkness, George Blumenthal, Gwynne M. Andrews and Michael Dreicer, by exchange; Theodore M. Davis Collection, Bequest of Theodore M. Davis, by exchange; Rogers Fund, by exchange; and The Cloisters Collection, by exchange, 1984                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
326301 1993.163 1 1 466251 Medieval Art 6 Cross 4297 Processional Cross Byzantine 1134                           ca. 1000–1050 995 1005 Silver, silver-gilt 22415 Overall: 23 7/16 x 16 15/16 x 7/8 in. (59.5 x 43 x 2.2 cm) Diameter of central medallion on back: 2 3/8 in. (6 cm) Diameter of central medallion on front: 2 5/16 in. (5.9 cm) width of arms: 5 3/16 in. (13.2 cm) diameter of Michael medallion: 1 3/4 in. (4.4 cm) diameter of John the Baptist medallion: 1 5/8 in. Rogers Fund, 1993                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
327134 32.100.218 0 1 467483 Medieval Art 6 Cruet 323 Cruet German 27                           1518 1518 1518 Silver, silver-gilt 22415 Overall: 6 9/16 x 3 1/16 x 2 11/16 in. (16.7 x 7.8 x 6.8 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931 Made in 1     probably Lübeck 717 Germany 16             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
327135 32.100.219 0 1 467484 Medieval Art 6 Cruet 323 Cruet German 27                           1518 1518 1518 Silver, silver-gilt 22415 Overall: 6 9/16 x 3 1/16 x 2 11/16 in. (16.7 x 7.8 x 6.8 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931 Made in 1 probably Lübeck 1976     Germany 16             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
327736 50.4 1 1 468346 The Cloisters 17 Chalice 202 The Antioch "Chalice" Byzantine 1134                           500–550 500 550 Silver, silver-gilt 22415 Overall: 7 11/16 x 7 1/16 x 6 in. (19.6 x 18 x 15.2 cm) foot: 2 15/16 in. (7.4 cm) The Cloisters Collection, 1950 Made in 1 Antioch or Kaper Koraon (?) 1998                   Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
330557 1986.3.1–.15 0 1 474390 Medieval Art 6 Liturgical objects 15011 The Attarouthi Treasure Byzantine 1134                           500–650 500 650 Silver, silver-gilt 22415   Purchase, Rogers Fund and Henry J. and Drue E. Heinz Foundation, Norbert Schimmel and Lila Acheson Wallace Gifts, 1986 Made in 1 Attarouthi 1931     Syria 69             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
389083 2014.200.2a, b 0 1 639661 American Decorative Arts 1 Wine pot 4458 Wine pot American 1         Maker 1   Dominick & Haff 1872–1928   Dominick & Haff 49663   1872 1872 1882 1882 1882 Silver, silver-gilt 22415 6 × 6 1/8 × 3 7/8 in., 14 oz. 19 dwt. (15.2 × 15.6 × 9.8 cm, 465.1g) Gift of Martha J. Fleischman, in memory of Michael K. Brown, 2014 Made in 1 New York 3     United States 3             Silver 2   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 446.399ms · Data license: CC0 · Data source: metmuseum/openaccess