MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Classification = 131

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Culture, Period, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line

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
20166 42.50.16 1 1 24693 Arms and Armor 5 Shield 1361 Shield Italian, probably Bologna 344         Maker 1 Attributed to Girolamo da Treviso Italian, Treviso ca. 1498–1544 Boulogne-sur-Mer   Treviso, Girolamo da 2868 Italian 6 1498 1544 ca. 1535 1510 1560 Wood, linen, gesso, gold leaf, polychromy 4296 Diam. 24 5/8 in. (62.53 cm) Gift of Stephen V. Grancsay, 1942   probably Bologna 508                   Shell 131   Metropolitan Museum of Art, New York, NY 1
31915 1990.320 0 0 37539 Asian Art 7 Wine cup 3941   India (Rajasthan?) 1296                           18th century 1700 1799 Mother-of-pearl with metal supports 7431 H. 3 3/4 in. (9.5cm) Gift of Mr. and Mrs. Corwith Hamill, 1990                       Shell 131   Metropolitan Museum of Art, New York, NY 1
32481 1986.501.6 0 1 38131 Asian Art 7 Conch 4031   India (possibly West Bengal) or Bangladesh 1412 Pala period                         11th–12th century 1000 1199 Shell with silver additions 7567 H. 8 1/16 in. (20.5 cm); W. 3 3/4 in. (9.5 cm); D. 3 5/8 in. (9.2 cm) Gift of Evelyn Kossak, The Kronos Collections, 1986                       Shell 131   Metropolitan Museum of Art, New York, NY 1
35919 67.55.86 0 1 41892 Asian Art 7 Box 114   China 51 Qing dynasty (1644–1911)                           1644 1911 Tortoise shell 8514 H. 1 in. (2.5 cm); W. 2 1/8 in. (5.4 cm); L. 2 7/8 in. (7.3 cm) Bequest of Susan Dwight Bliss, 1966                       Shell 131   Metropolitan Museum of Art, New York, NY 1
36039 56.32.2a, b 0 1 42016 Asian Art 7 Box 114   China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                         18th century 1736 1795 Wood with mother-of-pearl, ivory, and glass  8530 H. 2 3/4 in. (7 cm); W. 2 in. (5.1 cm); D. 4 1/2 in. (11.4 cm) Anonymous Gift, in memory of Mrs. Nina Houser Peebles, 1956                       Shell 131   Metropolitan Museum of Art, New York, NY 1
36042 79.2.1379a, b 0 1 42019 Asian Art 7 Cup with cover 4351   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Tortoise shell 8514 H. 3 1/4 in. (8.3 cm); Diam. 3 3/8 in. (8.6 cm) Purchase by subscription, 1879                       Shell 131   Metropolitan Museum of Art, New York, NY 1
36043 79.2.1380 0 0 42020 Asian Art 7 Saucer 326   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Tortoise shell 8514 Diam. 4 1/4 in. (10.8 cm) Purchase by subscription, 1879                       Shell 131   Metropolitan Museum of Art, New York, NY 1
36044 79.2.1381a, b 0 1 42021 Asian Art 7 Cup with cover 4351   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Tortoise shell 8514 H. 3 1/4 in. (8.3 cm); Diam. 3 3/8 in. (8.6 cm) Purchase by subscription, 1879                       Shell 131   Metropolitan Museum of Art, New York, NY 1
36048 18.56.74 0 1 42025 Asian Art 7 Fragment 486   China 51 Shang dynasty (ca. 1600–1046 B.C.)                           -1600 -1046 Shell 2067 H. 1 1/2 in. (3.8 cm); W. 1 1/4 in. (3.2 cm) Rogers Fund, 1918                       Shell 131   Metropolitan Museum of Art, New York, NY 1
36072 50.145.325a, b 0 1 42050 Asian Art 7 Box 114   China 51 Qing dynasty (1644–1911)                         18th century 1700 1799 Tortoise shell 8514 H. 1 in. (2.5 cm); Diam. 2 13/16 in. (7.1 cm) Bequest of Mary Stillman Harkness, 1950                       Shell 131   Metropolitan Museum of Art, New York, NY 1
38422 1988.289.1a, b–.31a, b 0 1 44535 Asian Art 7 Clamshell gamepieces 4616   Japan 46 Edo period (1615–1868)                         18th century 1700 1800 Clam shells painted in gold and color 9133 Each approx.: H. 3/4 in. (1.9 cm); W. 3 in. (7.6 cm); D. 2 3/8 in. (6 cm) Gift of Yukikazu Iwasa, 1988                       Shell 131   Metropolitan Museum of Art, New York, NY 1
39619 X.224 0 0 45885 Asian Art 7 Spoon 78   Philippines 1601                           19th century 1800 1899 Mother-of-pearl 9157 W. 1 1/2 in. (3.8 cm); L. 3 3/4 in. (9.5 cm) Museum Accession                       Shell 131   Metropolitan Museum of Art, New York, NY 1
53537 56.32.1a, b 0 1 61856 Asian Art 7 Box 114   China 51 Qing dynasty (1644–1911), Qianlong period (1736–95)                         18th century 1736 1795 Wood with mother-of-pearl, ivory, and glass  8530 H. 2 3/4 in. (7 cm); W. 2 in. (5.1 cm); D. 4 1/2 in. (11.4 cm) Anonymous Gift, in memory of Mrs. Nina Houser Peebles, 1956                       Shell 131   Metropolitan Museum of Art, New York, NY 1
54690 79.2.1382 0 1 63075 Asian Art 7 Saucer 326   China 51 Qing dynasty (1644–1911)                         19th century 1800 1899 Tortoise shell 8514 Diam. 4 1/4 in. (10.8 cm) Purchase by subscription, 1879                       Shell 131   Metropolitan Museum of Art, New York, NY 1
63456 2006.313 0 1 73309 Asian Art 7 Plate 356   India (Gujarat) 1324 Mughal period (1526–1858)                         mid-16th–17th century 1550 1699 Mother-of-pearl with copper alloy base (underside) and rim frame 14443 H. 1 3/8 in. (3.5 cm); Diam. 8 1/16 in. (20.5 cm) Purchase, Seymour Fund, by exchange, 2006                       Shell 131   Metropolitan Museum of Art, New York, NY 1
204246 64.37.15 0 1 325674 Ancient Near Eastern Art 14 Fragment 486 Shell fragment Assyrian 5654 Neo-Assyrian                         ca. 9th–8th century B.C. -900 -700 Shell 2067 1.85 x 1.97 x 0.12 in. (4.7 x 5 x 0.3 cm) Rogers Fund, 1964           Mesopotamia 335 Nimrud (ancient Kalhu) 5         Shell 131   Metropolitan Museum of Art, New York, NY 1
446756 GK.412.1-20 0 0 747643 Arts of Africa, Oceania, and the Americas 10 Beads 3963 Effigy Cacao Beans Maya 4341                           ca. A.D. 800 600 900 Shell 2067 H. 9/16 × W. 3/8 × D. 1/4 in. (1.4 × 1 × 0.7 cm) Museo Regional de Antropología de Yucatán, Palacio Cantón, Secretaría de Cultura-INAH, Mérida (10-626558 0/136)         Mexico 1 Yucatan 748           Shell 131   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 135.581ms · Data license: CC0 · Data source: metmuseum/openaccess