MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Medium = 15483

View and edit SQL

Suggested facets: Object Name, Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Artist Begin Date (date), Artist End Date (date)

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
68041 1993.345.5a, b 0 0 80802 Costume Institute 8 Suit 5876 Suit Italian 36         Designer|Couture Line|Design House 203   Gianni Versace|Versace Couture|Gianni Versace Italian, 1946–1997|Italian, founded 1992|Italian, founded 1978   Versace Gianni|Versace|Gianni Versace 5309 Italian|Italian|Italian 145 1946 |1992 |1978 1997 |9999 |9999 fall/winter 1991–92 1991 1992 silk, rayon 15483   Gift of Anne H. Bass, 1993                           Metropolitan Museum of Art, New York, NY 1
68938 1986.517.6 0 0 81815 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer 5   Madeleine Vionnet French, Chilleurs-aux-Bois 1876–1975 Paris   Vionnet, Madeleine 5705 French 2 1876 1975 fall/winter 1937–38 1937 1938 silk, rayon 15483   Gift of Betty Furness, 1986                           Metropolitan Museum of Art, New York, NY 1
69370 2001.393.16 0 0 82716 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Geoffrey Beene American, Haynesville, Louisiana 1927–2004 New York   Beene, Geoffrey 5306 American 1 1927-08-30 2004-09-28 fall/winter 1975–76 1975 1976 silk, rayon 15483   Gift of Geoffrey Beene, 2001                           Metropolitan Museum of Art, New York, NY 1
69567 1982.280 0 0 83128 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Gilbert Adrian American, Naugatuck, Connecticut 1903–1959 Hollywood, California   Adrian, Gilbert 5267 American 1 1903 1959 1945 1945 1945 silk, rayon 15483   Gift of Maria Zondek, 1982                           Metropolitan Museum of Art, New York, NY 1
70754 1982.158.11 0 0 84794 Costume Institute 8 Evening cape 5919 Evening cape American 1         Designer 5   Valentina American, born Russia, 1899–1989   Valentina 5269 American 1 1899 1989 late 1930s 1935 1939 silk, rayon 15483   The Jacqueline Loewe Fowler Costume Collection, Gift of Jacqueline Loewe Fowler, 1982                           Metropolitan Museum of Art, New York, NY 1
70921 2002.326.22 0 0 85032 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Gilbert Adrian American, Naugatuck, Connecticut 1903–1959 Hollywood, California   Adrian, Gilbert 5267 American 1 1903 1959 ca. 1944 1939 1949 silk, rayon 15483   Gift of Jones Apparel Group, USA, 2002                           Metropolitan Museum of Art, New York, NY 1
73986 2003.256.8 0 0 93639 Costume Institute 8 Evening dress 5874 Evening dress Japanese 35         Designer 5   Hanae Mori Japanese, born 1926   Mori Hanae 5276 Japanese 74 1926 2026 ca. 1968 1963 1973 silk, rayon 15483   Gift of Laura Johnson, 2003                           Metropolitan Museum of Art, New York, NY 1
75595 1986.195.3a–c 0 0 97048 Costume Institute 8 Evening ensemble 5879 Evening ensemble Italian 36         Designer 5   Valentino Italian, born 1932   Valentino 5278 Italian 6 1932 2032 1982 1982 1982 silk, rayon 15483   Gift of Diana Vreeland, 1986                           Metropolitan Museum of Art, New York, NY 1
75756 1984.607.6a–c 0 0 97251 Costume Institute 8 Evening ensemble 5879 Evening ensemble Japanese 35         Designer 5   Hanae Mori Japanese, born 1926   Mori Hanae 5276 Japanese 74 1926 2026 1965–67 1965 1967 silk, rayon 15483   Gift of Diana Vreeland, 1984                           Metropolitan Museum of Art, New York, NY 1
85018 C.I.47.19 0 0 119304 Costume Institute 8 Scarf 1153 Scarf American 1         Designer 5   Brooke Cadwallader     Cadwallader, Brooke 6694       1947 1947 1947 silk, rayon 15483   Gift of Mr. and Mrs. Brooke M. Cadwallader, 1947                           Metropolitan Museum of Art, New York, NY 1
89565 2009.248a–d 0 0 153115 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer 5   Madeleine Vionnet French, Chilleurs-aux-Bois 1876–1975 Paris   Vionnet, Madeleine 5705 French 2 1876 1975 1929 1929 1929 silk, rayon 15483   Purchase, Friends of The Costume Institute Gifts, 2009                           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 108.034ms · Data license: CC0 · Data source: metmuseum/openaccess