MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Is Highlight = 1 and Object Name = 110 sorted by Artist Display Name

View and edit SQL

Suggested facets: Department, Medium, Credit Line, Geography Type, Classification

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
36205 1974.268.11 1 1 42183 Asian Art 7 Dish 110 唐 鎏金葉形銀盤|Dish in the Shape of a Leaf China 51 Tang dynasty (618–907)                         late 7th–early 8th century 667 733 Silver with parcel gilding 7848 L. 5 3/4 in. (14.6 cm) Purchase, Arthur M. Sackler Gift, 1974                       Metalwork 177   Metropolitan Museum of Art, New York, NY 1
43390 1975.268.563 1 1 50342 Asian Art 7 Dish 110 色絵三壺文小皿|Dish with Three Jars Japan 46 Edo period (1615–1868)                         1680–90s 1680 1699 Porcelain with underglaze blue and overglaze polychrome enamels (Hizen ware, Nabeshima type) 8072 H. 1 5/8 in. (4.1 cm); Diam. 6 in. (15.2 cm) The Harry G. C. Packard Collection of Asian Art, Gift of Harry G. C. Packard, and Purchase, Fletcher, Rogers, Harris Brisbane Dick, and Louis V. Bell Funds, Joseph Pulitzer Bequest, and The Annenberg Fund Inc. Gift, 1975                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316713 59.69.1 1 1 451490 Islamic Art 9 Dish 110 Dish Depicting Two Birds among Flowering Plants                             ca. 1575–90 1550 1615 Stonepaste; polychrome painted under transparent glaze 44699 H. 2 3/8 in. Diam. of rim: 11 3/16 in. (28.4 cm) Gift of James J. Rorimer in appreciation of Maurice Dimand's curatorship, 1933–1959, 1959 Made in 1 Iznik 1484     Turkey 61             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
317023 65.109.2 1 1 451804 Islamic Art 9 Dish 110 Dish with Two Intertwined Dragons                             ca. 1640 1615 1665 Stonepaste; painted in blue under transparent glaze 46414 H. 2 3/4in. (7cm) Diam. 17 1/4in. (43.8cm) Harris Brisbane Dick Fund, 1965 Attributed to 20 Kirman 1482     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
317213 68.215.2 1 1 451995 Islamic Art 9 Dish 110 Brasero                             late 15th–early 16th century 1475 1525 Earthenware; molded, luster-painted on opaque white glaze 46882 2 1/16 x 19 5/16 in. (5.2 x 49.1 cm) Gift of Dr. and Mrs. Lewis Balamuth, 1968 Attributed to 20 Manises (Valencia) 1487     Spain 5             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
321275 1975.1.1039 1 1 459244 Robert Lehman Collection 16 Dish 110 Dish (piatto): Man Washing the Mouth of an Ass Italian, Deruta 2120                           ca. 1550–60 1547 1563 Maiolica (tin-glazed earthenware) 20530 Diam. 15 13/16 in. (40.2 cm) Robert Lehman Collection, 1975                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
331857 2008.278 1 1 478211 The Cloisters 17 Dish 110 Dish with Abraham and Melchizedek South German 189         Artist 2   Hans of Landshut German, Landshut, active late 15th century   Hans of Landshut 44770 German 10 1400 1550 1498 1498 1498 Free-blown glass with paint and metallic foils 50653 Overall: 14 1/2 x 1 5/8 in. (36.9 x 4.2 cm) The Cloisters Collection, 2008                       Glass-Miscellany 829   Metropolitan Museum of Art, New York, NY 1
321276 1975.1.1103 1 1 459245 Robert Lehman Collection 16 Dish 110 Armorial dish: Supper at the House of Simon the Pharisee           Artist 2 workshop of Maestro Giorgio Andreoli Italian (Gubbio), active first half of 16th century   Andreoli, Giorgio Maestro 8039 Italian 6 1500 1550 1528 1528 1528 Maiolica (tin-glazed earthenware) 20530 Diameter: 18 5/16 in. (46.5 cm.) Robert Lehman Collection, 1975                       Ceramics-Pottery 314   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 1042.656ms · Data license: CC0 · Data source: metmuseum/openaccess