MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Medium = 16701

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 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
72515 1989.333.11 0 0 90047 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer|Design House 202   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 fall/winter 1983–84 1983 1984 Silk, synthetic 16701   Gift of Anne H. Bass, 1989                           Metropolitan Museum of Art, New York, NY 1
93899 2009.300.4359 0 0 168587 Costume Institute 8 Toque 6086 Toque American 1         Designer 5   Mme. Poiret     Poiret Mme. 7497       1923 1923 1923 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Frank L. Babbott, Jr., 1941                           Metropolitan Museum of Art, New York, NY 1
93963 2009.300.4437 0 0 168651 Costume Institute 8 Hat 1056 Hat American 1         Designer 5   Sally Victor American, 1905–1977   Victor, Sally 5907 American 1 1905 1977 1943 1943 1943 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Sally Victor, Inc., 1944                           Metropolitan Museum of Art, New York, NY 1
94912 2009.300.5386 0 0 169600 Costume Institute 8 Hat 1056 Hat American 1         Designer 5   Sally Victor American, 1905–1977   Victor, Sally 5907 American 1 1905 1977 ca. 1958 1956 1960 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the artist, 1964                           Metropolitan Museum of Art, New York, NY 1
94966 2009.300.5439 0 0 169654 Costume Institute 8 Evening stole 5955 Evening stole American 1                           ca. 1935 1933 1937 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the estate of Mrs. Erne C. Culver, 1965                           Metropolitan Museum of Art, New York, NY 1
95674 2009.300.4852 0 0 170362 Costume Institute 8 Picture hat 6385 Picture hat American 1         Designer 5 Attributed to Sally Victor American, 1905–1977   Victor, Sally 5907 American 1 1905 1977 1955 1955 1955 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Sally Victor, 1955                           Metropolitan Museum of Art, New York, NY 1
96598 2009.300.6809 0 0 173821 Costume Institute 8 Hat 1056 Hat American 1         Designer 5   Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 1944 1944 1944 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Arturo and Paul Peralta-Ramos, 1954                           Metropolitan Museum of Art, New York, NY 1
97849 2009.300.8212 0 1 175230 Costume Institute 8 Evening coat 5920 Evening coat French 7         Designer 5   Paul Poiret French, Paris 1879–1944 Paris   Poiret, Paul 5563 French 2 1879 1944 1924 1924 1924 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mary Sefton Thomas, 1986                           Metropolitan Museum of Art, New York, NY 1
97903 2009.300.8266 0 0 175284 Costume Institute 8 Necktie 5902 Necktie American 1         Retailer 8   Hahne & Company American   Hahne & Company 6738 American 1     ca. 1970 1968 1972 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Martin Kamer, 1987                           Metropolitan Museum of Art, New York, NY 1
98046 2009.300.8431 0 0 175428 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 ca. 1960 1958 1962 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mr. and Mrs. Eugene Luntey in memory of Beverly Luntey, 2002                           Metropolitan Museum of Art, New York, NY 1
98047 2009.300.8432 0 0 175429 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 ca. 1960 1958 1962 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mr. and Mrs. Eugene Luntey in memory of Beverly Luntey, 2002                           Metropolitan Museum of Art, New York, NY 1
98135 2009.300.8477 0 0 175543 Costume Institute 8 Necktie 5902 Necktie American 1         Artist|Retailer 318   Robert Kushner|Atkinson's American, born Pasadena, California, 1949   Kushner, Robert|Atkinson's 7949 American 1 1949 2049 ca. 1975 1973 1977 Silk, synthetic 16701   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Anonymous gift, 2008                           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 141.343ms · Data license: CC0 · Data source: metmuseum/openaccess