MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Medium = 20270

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, 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
96498 2009.300.6698a, b 0 0 173705 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Bonnie Cashin American, Oakland, California 1908–2000 New York   Cashin, Bonnie 5876 American 1 1908 2000 1938 1938 1938 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Bonnie Cashin, 1951                           Metropolitan Museum of Art, New York, NY 1
96605 2009.300.6816 0 0 173829 Costume Institute 8 Ski mask 6603 Ski mask Peruvian 74         Retailer 8 Probably Pinata Party, Inc.     Pinata Party, Inc. 7162       ca. 1960 1958 1962 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Frank L. Babbott Fund, 1954                           Metropolitan Museum of Art, New York, NY 1
96803 2009.300.7046 0 0 174181 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Bonnie Cashin American, Oakland, California 1908–2000 New York   Cashin, Bonnie 5876 American 1 1908 2000 1940 1940 1940 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Bonnie Cashin, 1958                           Metropolitan Museum of Art, New York, NY 1
96854 2009.300.7097a, b 0 0 174233 Costume Institute 8 Suit 5876 Suit American 1         Retailer|Designer 222   Saks Fifth Avenue|Sophie Gimbel American, founded 1924|American, Houston, Texas 1898–1981 New York   Saks Fifth Avenue|Gimbel, Sophie 7798 American|American 5 1924 |1898 9999 |1981 ca. 1957 1955 1959 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Sophie Gimbel, 1960                           Metropolitan Museum of Art, New York, NY 1
97495 2009.300.7843 0 0 174874 Costume Institute 8 Dress 5877 Dress French 7         Designer|Design House 202   Christian Dior|House of Dior French, Granville 1905–1957 Montecatini|French, founded 1947   Dior, Christian|Dior, House of 5325 French|French 21 1905 |1947 1957 |9999 ca. 1956 1954 1958 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Virginia Rice, 1973                           Metropolitan Museum of Art, New York, NY 1
97588 2009.300.7944a, b 0 0 174968 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Norman Norell American, Noblesville, Indiana 1900–1972 New York   Norell, Norman 5471 American 1 1900 1972 fall/winter 1971–72 1971 1971 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mildred Custin, 1977                           Metropolitan Museum of Art, New York, NY 1
97735 2009.300.8091 0 0 175116 Costume Institute 8 Dress 5877 "Mekong" American 1         Designer 5   Elizabeth Hawes American, Ridgewood, New Jersey 1903–1971 New York   Hawes, Elizabeth 5720 American 1 1903 1971 1938 1938 1938 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the estate of Elinor S. Gimbel, 1984                           Metropolitan Museum of Art, New York, NY 1
97860 2009.300.8223a, b 0 0 175241 Costume Institute 8 Trousers 5475 Trousers French 7         Designer|Designer 85   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   Saint Laurent Yves|Saint Laurent Yves, Paris 5348 French|French 21 1936 |1961 2008 |9999 ca. 1967 1965 1969 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lauren Bacall, 1986                           Metropolitan Museum of Art, New York, NY 1
97868 2009.300.8231 0 0 175249 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Manufacturer 3   Rudi Gernreich|Harmon Knitwear American (born Austria), Vienna 1922–1985 Los Angeles, California|American   Gernreich, Rudi|Harmon Knitwear 5323 American, born Austria|American 138 1922 1985 ca. 1967 1965 1969 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Ruth Ford, 1986                           Metropolitan Museum of Art, New York, NY 1
97870 2009.300.8233a, b 0 0 175251 Costume Institute 8 Dress 5877 Dress American 1         Designer|Manufacturer 3   Rudi Gernreich|Harmon Knitwear American (born Austria), Vienna 1922–1985 Los Angeles, California|American   Gernreich, Rudi|Harmon Knitwear 5323 American, born Austria|American 138 1922 1985 ca. 1967 1965 1969 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Ruth Ford, 1986                           Metropolitan Museum of Art, New York, NY 1
98243 2009.300.6976 0 0 175698 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Claire McCardell American, 1905–1958   McCardell Claire 5437 American 1 1905 1958 1945 1945 1945 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire McCardell, 1956                           Metropolitan Museum of Art, New York, NY 1
98271 2009.300.7264a, b 0 0 175758 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer|Maker|Designer 325 Textile by Bonnie Cashin|Eunice Cashin|Pola Stout American, Oakland, California 1908–2000 New York|American|Austrian, born Stry, Poland, 1902–1984 Stamford, Connecticut   Cashin, Bonnie|Cashin, Eunice|Stout, Pola 7964 American|American|Austrian 285 1908 |1902 2000 |1984 1949 1949 1949 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Bonnie Cashin, 1963                           Metropolitan Museum of Art, New York, NY 1
98386 2009.300.8410 0 0 175874 Costume Institute 8 Skirt 1152 Skirt American 1         Designer 5   Valentina American, born Russia, 1899–1989   Valentina 5269 American 1 1899 1989 ca. 1932 1930 1934 Wool  20270   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Igor Kamlukin, 1996                           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 123.723ms · Data license: CC0 · Data source: metmuseum/openaccess