MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Artist Role = 286

View and edit SQL

Suggested facets: Object Name, Title, Culture, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
88456 2006.420.81a, b 0 0 131369 Costume Institute 8 Ensemble 5875 Ensemble French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807 French|French 21 1952 |1997 2052 |1997 fall/winter 2001–2 2001 2002 a) silk, synthetic; b) wool; silk, synthetic 18877   Gift of Thomas L. Kempner, 2006                           Metropolitan Museum of Art, New York, NY 1
88457 2006.420.82 0 0 131370 Costume Institute 8 Trousers 5475 Trousers French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807 French|French 21 1952 |1997 2052 |1997 ca. 1999 1994 2004 wool, silk, plastic 15456   Gift of Thomas L. Kempner, 2006                           Metropolitan Museum of Art, New York, NY 1
88458 2006.420.83a, b 0 0 131371 Costume Institute 8 Ensemble 5875 Ensemble French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807 French|French 21 1952 |1997 2052 |1997 spring/summer 2002 2002 2002 a, b) silk 16016   Gift of Thomas L. Kempner, 2006                           Metropolitan Museum of Art, New York, NY 1
88459 2006.420.84a–c 0 0 131372 Costume Institute 8 Coat 4973 "Evolution" French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807 French|French 21 1952 |1997 2052 |1997 fall/winter 2003–4 2003 2004 a) wool, silk; b) wool; c) leather 18878   Gift of Thomas L. Kempner, 2006                           Metropolitan Museum of Art, New York, NY 1
88461 2006.420.86a, b 0 0 131374 Costume Institute 8 Dress 5877 Dress French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807 French|French 21 1952 |1997 2052 |1997 spring/summer 2003 2003 2003 a,b) polyester 16636   Gift of Thomas L. Kempner, 2006                           Metropolitan Museum of Art, New York, NY 1
88473 2006.420.94a, b 0 0 131576 Costume Institute 8 Dress 5877 Dress Italian 36         Designer|Couture Line 286   Valentino|Valentino Italian, born 1932|Italian, born 1932   Valentino|Valentino 6808 Italian|Italian 93 1932 |1932 2032 |2032 spring/summer 2003 2003 2003 a) silk, metal; b) metallic 18884   Gift of Thomas L. Kempner, 2006                           Metropolitan Museum of Art, New York, NY 1
379848 2015.737.1a–g 0 0 626118 Costume Institute 8 Ensemble 5875 Ensemble French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807   1952 |1997 2052 |1997 fall/winter 2001–2 2001 2002 (a) silk, paper, metal; (b) rayon, cotton, metal; (c–g) metal, enamel 57774   Gift of Jean Paul Gaultier, 2015                           Metropolitan Museum of Art, New York, NY 1
405111 2015.737.3 0 0 661674 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer|Couture Line 286   Jean Paul Gaultier|Gaultier Paris French, born 1952|French, founded 1997   Gaultier Jean Paul|Gaultier Paris 6807   1952 |1997 2052 |1997 spring/summer 1997 1997 1997 silk 15101   Gift of Jean Paul Gaultier, 2015                           Metropolitan Museum of Art, New York, NY 1
423002 2016.185 0 0 701654 Costume Institute 8 Dress 5877 Dress Dutch 4         Designer|Couture Line 286   Iris Van Herpen|Iris Van Herpen Dutch, born 1984|Dutch, born 1984   Van Herpen, Iris|Van Herpen, Iris 53984   1984 |1984 9999 |9999 fall/winter 2012–13 2012 2013 PVC, silk, metal 60582   Gift of Iris van Herpen, in honor of Harold Koda, 2016                           Metropolitan Museum of Art, New York, NY 1
423146 2016.182 0 0 701898 Costume Institute 8 Hat 1056 Paphiopedilum Philippinense Orchid British 6         Designer|Couture Line 286   Philip Treacy|Philip Treacy British, born Ireland, 1966|British, born Ireland, 1966   Treacy Philip|Treacy Philip 53998   1966 |1966 2067 |2067 spring/summer 2000 2000 2000 silk, synthetic, straw, metal 60588   Gift of Philip Treacy and Isabella Blow, in honor of Harold Koda, 2016                           Metropolitan Museum of Art, New York, NY 1
423192 2016.14 0 0 701960 Costume Institute 8 Dress 5877 Dress Dutch 4         Designer|Couture Line 286   Iris Van Herpen|Iris Van Herpen Dutch, born 1984|Dutch, born 1984   Van Herpen, Iris|Van Herpen, Iris 53984   1984 |1984 9999 |9999 fall/winter 2013–14 2013 2014 silicone, cotton, metal, synthetic, glass 60591   Purchase, Friends of The Costume Institute Gifts, 2015                           Metropolitan Museum of Art, New York, NY 1
446721 2017.115 0 0 747597 Costume Institute 8 Jacket 4399 Jacket French 7         Designer|Couture Line 286   Martin Margiela|Maison Martin Margiela Belgian, born 1957|founded 1988   Margiela Martin|Margiela Maison Martin 5647   1957 |1988 2057 |2088 fall/winter 2008–9 2008 2009 leather, paper, synthetic 62448   Purchase, Friends of The Costume Institute Gifts, 2017                           Metropolitan Museum of Art, New York, NY 1
446722 2017.116a–c 0 0 747598 Costume Institute 8 Jacket 4399 Jacket French 7         Designer|Couture Line 286   Martin Margiela|Maison Martin Margiela Belgian, born 1957|founded 1988   Margiela Martin|Margiela Maison Martin 5647   1957 |1988 2057 |2088 spring/summer 2006 2006 2006 leather, synthetic, metal 17421   Purchase, Friends of The Costume Institute Gifts, 2017                           Metropolitan Museum of Art, New York, NY 1
450248 2017.739 0 0 754292 Costume Institute 8 Ensemble 5875 Ensemble French 7         Designer|Couture Line 286   John Galliano|Maison Martin Margiela British, born Gibraltar, 1960|founded 1988   Galliano John|Margiela Maison Martin 57464   1960 |1988 2060 |2088 spring/summer 2017 2017 2017 (a) wool, (b) cotton, silk, nylon, (c, d) leather 62857   Purchase, Maison Margiela Gift and Friends of The Costume Institute, 2017                           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 204.488ms · Data license: CC0 · Data source: metmuseum/openaccess