MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Medium = 15293

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin 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
67010 1997.247.2a, b 0 0 79610 Costume Institute 8 Evening suit 5883 Evening suit Italian 36         Design House|Designer 198   Giorgio Armani|Giorgio Armani Italian, founded 1974|Italian, born 1934   Armani|Armani Giorgio 5285 Italian|Italian 93 1974 |1934-07-11 9999 |2034 fall/winter 1991–92 1991 1992 silk, glass, plastic 15293   Gift of Giorgio Armani, 1997                           Metropolitan Museum of Art, New York, NY 1
75813 1977.110.4a–c 0 0 97340 Costume Institute 8 Cocktail Ensemble 5952 Cocktail ensemble French 7         Designer|Design House 202   Hubert de Givenchy|House of Givenchy French, Beauvais 1927–2018 Paris|French, founded 1952   Givenchy, Hubert de|Givenchy House of 5358 French|French 21 1927 |1952 2018 |9999 1965 1965 1965 silk, glass, plastic 15293   Gift of Hubert de Givenchy, in memory of Mme. Jacques Bousquet, 1977                           Metropolitan Museum of Art, New York, NY 1
75952 1978.385.1 0 0 97573 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Retailer 51   Norman Norell|Evelyn Byrnes American, Noblesville, Indiana 1900–1972 New York|American, founded 1956   Norell, Norman|Byrnes, Evelyn 6358 American|American 5 1900 |1956 1972 |2056 1963 1963 1963 silk, glass, plastic 15293   Gift of Josephine E. Glassheim in memory of parents Nathan and Mary Glassheim, 1978                           Metropolitan Museum of Art, New York, NY 1
76037 1979.435.34a, b 0 0 97704 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer 5   Madame Grès (Alix Barton) French, Paris 1903–1993 Var region   Grès, Madame 5274 French 2 1903 1993 1962–67 1962 1967 silk, glass, plastic 15293   Gift of Diana Vreeland, 1979                           Metropolitan Museum of Art, New York, NY 1
76051 1981.66.1a, b 0 0 97733 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   James Galanos American, Philadelphia, Pennsylvania, 1924–2016 West Hollywood, California   Galanos, James 5452 American 1 1924 2016 ca. 1970 1965 1975 silk, glass, plastic 15293   Gift of Pincess Doria Di Centola, 1981                           Metropolitan Museum of Art, New York, NY 1
76197 1987.427a, b 0 0 97997 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   Zandra Rhodes British, born 1940   Rhodes Zandra 5479 British 7 1940 2040 1986 1986 1986 silk, glass, plastic 15293   Gift of Miles Chapman, 1987                           Metropolitan Museum of Art, New York, NY 1
78962 1977.157.5 0 0 105209 Costume Institute 8 Evening dress 5874 Evening dress Italian 36         Designer 5   Mila Schön Italian, born Yugoslavia, 1916–2008 Alessandria   Schön Mila 5526 Italian 6 1916 2008 1963–64 1963 1964 silk, glass, plastic 15293   Gift of Lee Radziwil, 1977                           Metropolitan Museum of Art, New York, NY 1
78972 1977.157.3 0 0 105224 Costume Institute 8 Evening dress 5874 Evening dress Italian 36         Designer 5   Mila Schön Italian, born Yugoslavia, 1916–2008 Alessandria   Schön Mila 5526 Italian 6 1916 2008 1965–69 1965 1969 silk, glass, plastic 15293   Gift of Lee Radziwil, 1977                           Metropolitan Museum of Art, New York, NY 1
81303 1980.176 0 0 109788 Costume Institute 8 Fancy dress costume 5897 Fancy dress costume American 1         Designer|Designer 85 Textile designed by Léon Bakst|Raoul Dufy Russian, Grodno 1866–1924 Paris|French, Le Havre 1877–1953 Forcalquier   Bakst, Léon|Dufy, Raoul 6569 Russian|French 59 1866 |1877 1924 |1953 1919 1919 1919 silk, glass, plastic 15293   Gift of Flora M. Irving, 1980                           Metropolitan Museum of Art, New York, NY 1
81443 1977.303.3a–c 0 1 110064 Costume Institute 8 Evening ensemble 5879 Evening ensemble French 7         Designer 5   Jacques Doucet French, Paris 1853–1929 Paris   Doucet, Jacques 5483 French 2 1853 1929 ca. 1925 1920 1930 silk, glass, plastic 15293   Gift of David Toser, 1977                           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 225.257ms · Data license: CC0 · Data source: metmuseum/openaccess