MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Classification = 191 and Is Highlight = 1 sorted by rowid descending

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type, City, Country

Is Highlight

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
316336 52.20.22 1 1 451102 Islamic Art 9 Fragment 486 Fragment                             mid-16th century 1525 1575 Silk, metal wrapped thread; lampas (kemha) 45007 Textile: H. 24 in (61 cm) W. 26 1/2 in (67.3 cm) Mount: H. 28 5/8 in (72.7 cm) W. 31 6/8 in (80.6 cm) D. 7/8 in (2.2 cm) Purchase, Joseph Pulitzer Bequest, 1952 Made in 1 probably Istanbul 431     Turkey 61             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
316329 52.20.15 1 1 451095 Islamic Art 9 Fragment 486 Fragment of a Kaftan Back                             mid-16th century 1525 1575 Silk, metal wrapped thread; taqueté (seraser) 45404 Textile: L. 52 in. (132.1 cm) W. 27 in. (68.6 cm) Mount: L. 58 3/16 in. (147.8 cm) W. 33 1/8 in. (84.1 cm) Purchase, Joseph Pulitzer Bequest, 1952 Attributed to 20 probably Istanbul 431     Turkey 61             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
316326 52.20.12 1 1 451092 Islamic Art 9 Panel 399 Safavid Courtiers Leading Georgian Captives                             mid-16th century 1525 1575 Silk, metal wrapped thread; lampas 45006 Textile: L. 47 1/2 in. (120.7 cm) W. 26 1/2 in. (67.3 cm) Mount: L. 53 in. (134.6 cm) W. 32 1/8 in. (81.6 cm) D. 1 in. (2.5 cm) Wt. 31 lbs. (14.1 kg) Purchase, Joseph Pulitzer Bequest, 1952 Attributed to 20       Iran 59             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
313475 29.22 1 1 448232 Islamic Art 9 Fragment 486 Textile Fragment                             14th century 1300 1399 Silk; lampas 45079 Textile: L. 40 3/16 in. (102 cm) W. 14 5/16 in. (36.3 cm) Mount: L. 45 1/4 in. (114.9 cm) W. 19 3/4 in. (50.2 cm) D. 1 in. (2.5 cm) Fletcher Fund, 1929 Probably made in 2       Spain 5             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
204775 1977.232 1 1 326230 Ancient Near Eastern Art 14 Textile 1143 Textile fragment: walking ram with a neckband and fluttering ribbons Sasanian 5655 Sasanian                         ca. 7th century A.D. 600 700 Wool, cotton 18531 21.8 x 10.5 cm Anonymous Gift, 1977           Egypt 391           Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
199396 2002.602.7 1 0 319033 Arts of Africa, Oceania, and the Americas 10 Blanket 1042 Woman's Wearing Blanket Osage 5489                           early 20th century 1875 1950 Wool and silk trade cloth, glass beads 28155 H. 60 x W. 67 in. (152.4 x 170.2 cm) Gift of Ralph T. Coe, 2002       Oklahoma 400 United States 3             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
198372 1995.109 1 1 317736 Arts of Africa, Oceania, and the Americas 10 Dress 5877 Woman's Dress Chuquibamba 5351                           14th–early 16th century 1300 1550 Camelid hair 26563 H. 51 1/2 x W. 60 1/2 in. (130.8 x 153.7 cm) Purchase, Pfeiffer Fund and Arthur M. Bullowa Bequest, 1995   Chuquibamba 1016     Peru 67             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
197582 1994.35.120 1 1 316945 Arts of Africa, Oceania, and the Americas 10 Border fragment 8811 Border Fragment Paracas 4365                           450–175 B.C. -450 -175 Cotton, camelid hair 26562 H. 6 3/4 x W. 41 3/8 in. (17.1 x 105.1cm) Bequest of Arthur M. Bullowa, 1993         Peru 67             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
196445 1987.394.706 1 1 315786 Arts of Africa, Oceania, and the Americas 10 Tunic 5662 Tunic Moche-Wari 4951                           7th–9th century 700 900 Camelid hair, cotton 26561 H. 34 1/4 x W. 58 in. (87 x 147.3 cm) Bequest of Jane Costello Goldberg, from the Collection of Arnold I. Goldberg, 1986         Peru 67             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
188996 29.146.23 1 1 307975 Arts of Africa, Oceania, and the Americas 10 Tunic 5662 Tunic with Confronting Mythical Serpents Nasca-Wari 4394                           800–850 800 850 Camelid hair 26563 H. 21 1/2 × W. 43 1/4 in. (54.6 × 109.9 cm) Gift of George D. Pratt, 1929         Peru 67             Textiles-Woven 191   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 1151.951ms · Data license: CC0 · Data source: metmuseum/openaccess