MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Role = 3 and Is Highlight = 1

View and edit SQL

Suggested facets: Is Public Domain, Department, Artist Nationality, Object Begin Date, 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
68137 1998.431.1a–e 1 0 80911 Costume Institute 8 Ensemble 5875 Ensemble German 27         Designer|Manufacturer 3   James Rosenquist|Hugo Boss American, Grand Forks, North Dakota 1933–2017 New York|German, founded 1923   Rosenquist, James|Hugo Boss 5645 American|German 53 1933 |1923 2017 |9999 spring/summer 1998 1998 1998 (a, b) DuPont Tyvek®; (c) metal; (d, e) paper 15509   Gift of Hugo Boss, 1998                           Metropolitan Museum of Art, New York, NY 1
68311 C.I.58.49.4a, b 1 0 81115 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Manufacturer 3   Claire McCardell|Townley Frocks American, 1905–1958|American, founded 1929   McCardell Claire|Townley 5280 American|American 5 1905 |1929 1958 1950 1950 1950 silk 15101   Gift of Irving Drought Harris, in memory of Claire McCardell Harris, 1958                           Metropolitan Museum of Art, New York, NY 1
68332 C.I.66.14.2 1 1 81136 Costume Institute 8 Waistcoat 1202 Waistcoat British 6         Designer|Manufacturer 3 Textile by|Textile by Anna Maria Garthwaite|Peter Lekeux British, 1690–1763|British, 1716–1768   Garthwaite, Anna Maria|Lekeux Peter 5664 British|British 9 1690 |1716 1763 |1768 1747 1747 1747 silk, wool, metallic 15561   Purchase, Irene Lewisohn Bequest, 1966                           Metropolitan Museum of Art, New York, NY 1
334142 1976.414.3a-ggg 1 0 481545 Modern and Contemporary Art 4 Mural 15093 "History of Navigation" Mural           Designer|Manufacturer 3   Jean Dupas|Jacques-Charles Champigneulle French, Bourdeaux 1882–1964 Paris|French, 1907–1955   Dupas, Jean|Champigneulle, Jacques-Charles 44947 French|French 21 1882 |1907 1964 |1955 1934 1934 1934 Glass, paint, gold, silver, palladium leaf 50978 Overall: 245 x 348-3/4 inches (622.3 x 885.8 cm.) Gift of Dr. and Mrs. Irwin R. Berman, 1976                       Glass 3   Metropolitan Museum of Art, New York, NY 1
338621 1993.303a-f 1 0 486247 Modern and Contemporary Art 4 Plant stand 711 Plant stand           Designer|Manufacturer 3   Otto Prutscher|Beissbarth & Hoffmann Austrian, Vienna 1880–1949 Vienna|Mannheim-Rheinau, Germany   Prutscher, Otto|Beissbarth & Hoffmann 46174 Austrian|German 111 1880 1949 1903 1903 1903 Wood, metal, paint 52124 36 1/2 x 15 3/4 in. (92.7 x 40 cm) Purchase, Lila Acheson Wallace Gift, 1993                       Furniture 4   Metropolitan Museum of Art, New York, NY 1
338999 1995.440a-c 1 0 486636 Modern and Contemporary Art 4 Inkwell 528 Inkwell           Designer|Manufacturer 3   Eva Zeisel|Schramberg Majolica Factory American, Budapest 1906–2011 New City, New York|Schramberg, Germany   Zeisel, Eva|Schramberg Majolica Factory 46265 American|German 53 1906 2011 1929–30 1929 1930 Glazed earthenware 9554 3 3/8 x 9 x 9 3/8 in. (8.6 x 22.9 x 23.8 cm) Gift of the artist, 1995                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
342128 1999.27.1a-c-5 1 0 490759 Modern and Contemporary Art 4 Prototype tea service 15316 Prototype tea service           Designer|Manufacturer 3   Eliel Saarinen|International Silver Company, Wilcox Silver Plate Company Division (Meriden, Connecticut) American (born Finland), Rantasalmi 1873–1950 Bloomfield Hills, Michigan   Saarinen, Eliel|WILCOX SILVER 47074 American 1 1873 1950 ca. 1933–35 1933 1935 Electroplated nickel silver, brass, and Bakelite 52939 Tea Urn, 1a-c: H. 14-1/2, D. 11 in. (36.8 x 19.7 cm) Tray, 2: H. 5/8 Diam. 17-5/8 in. (44.5 cm) Creamer, 3: H. 3, W. 6, D. 3-7/8 in. (7.6 x 15.2 x 9.8 cm) Sugar Bowl, 4a,b: H. 6-3/4, W. 6, D. 3-7/8 in. (17.1 x 15.2 x 9.8 cm) Large Tray, 5: H. 1/2 Diam. 20-3/8 in. (51.4 cm) Purchase, Mr. and Mrs. Ronald Saarinen Swanson and John C. Waddell Gifts, and Gift of Susan Dwight Bliss, by exchange, 1999                       Metalwork 177   Metropolitan Museum of Art, New York, NY 1
342243 2000.600.15 1 0 490893 Modern and Contemporary Art 4 Electric clock 15092 Electric clock           Designer|Manufacturer 3   Gilbert Rohde|The Herman Miller Furniture Company, Zeeland, MI American, New York 1894–1944 New York   Rohde, Gilbert|Miller, Herman Inc. 44944 American|American 5 1894 1944 ca. 1933 1933 1933 Chrome-plated metal, glass 52928 12 1/8 x 12 1/2 x 3 1/2 in. (30.8 x 31.8 x 8.9 cm) John C. Waddell Collection, Gift of John C. Waddell, 2000                       Horology 316 © Herman Miller Inc. Metropolitan Museum of Art, New York, NY 1
342986 2000.278.1-.9 1 0 491720 Modern and Contemporary Art 4 Tea service 8226 Tea service           Designer|Manufacturer 3   Josef Hoffmann|Wiener Werkstätte Austrian, Pirnitz 1870–1956 Vienna   Hoffmann, Josef|Wiener Werkstätte 32450 Austrian 66 1870 1956 ca. 1910 1910 1910 Silver, amethyst, carnelian, and ebony 53093 Various dimensions Cynthia Hazen Polsky and Leon B. Polsky Fund, 2000                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
343684 2003.12a, b 1 0 492747 Modern and Contemporary Art 4 Chair 197 "Capitello" Chair           Designer|Manufacturer 3   Studio 65|Gufram Italian|Italian, founded 1952   Studio 65|Gufram 47359 Italian|Italian 93 1952 2052 1971 1971 1971 Polyurethane foam, latex rubber containing paint 53370 26 1/2 x 40 x 44 1/2 in. (67.3 x 101.6 x 113 cm) Purchase, Friends of Twentieth Century Decorative Arts Gifts, by exchange, 2003                       Furniture 4 © Gufram s.r.l. 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 1286.605ms · Data license: CC0 · Data source: metmuseum/openaccess