MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Object Name = 5967

View and edit SQL

Suggested facets: Title, Culture, Artist Role, Artist Nationality, Medium

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
67074 1997.478.17 0 0 79676 Costume Institute 8 Evening trousers 5967 Evening trousers French 7         Designer 5   Madame Grès (Alix Barton) French, Paris 1903–1993 Var region   Grès, Madame 5274 French 2 1903 1993 1965–87 1965 1987 silk 15101   Gift of Mrs. Ahmet Ertegün, 1997                           Metropolitan Museum of Art, New York, NY 1
72927 C.I.49.49.14 0 0 90946 Costume Institute 8 Evening trousers 5967 Evening trousers American 1                           early 20th century 1900 1925 wool 15104   Purchase, 1949                           Metropolitan Museum of Art, New York, NY 1
74584 1972.211.1a, b 0 0 95073 Costume Institute 8 Evening trousers 5967 Evening trousers French 7         Designer|Design House 202   Marc Bohan|House of Dior French, born 1926|French, founded 1947   Bohan, Marc|Dior, House of 5338 French|French 21 1926-08-22|1947 2026 |9999 fall/winter 1962–63 1962 1963 silk 15101   Gift of Mrs. Hans N. Zinsser, 1972                           Metropolitan Museum of Art, New York, NY 1
88279 C.I.64.67.5 0 0 129934 Costume Institute 8 Evening trousers 5967 Evening trousers American 1                           1955 1955 1955 wool, silk 15161   Gift of Mrs. Frederick H. Prince, Jr., 1964                           Metropolitan Museum of Art, New York, NY 1
96485 2009.300.6685 0 0 173692 Costume Institute 8 Evening trousers 5967 Evening trousers American 1         Designer 5   Carolyn Schnurer American, born New York, 1908–1998 Palm Beach, Florida   Schnurer Carolyn 5996   1908 1998 1951 1951 1951 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Carolyn Schnurer, 1951                           Metropolitan Museum of Art, New York, NY 1
96606 2009.300.6817 0 0 173830 Costume Institute 8 Evening trousers 5967 Evening trousers French 7         Designer|Design House 202 Attributed to|Attributed to Madame Marie Gerber|Callot Soeurs French|French, active 1895–1937   Gerber, Marie, Madame|Callot Soeurs 6901 French|French 21 1895 1937 1910 1910 1910 Silk, metallic 19804   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mercedes de Acosta, 1954                           Metropolitan Museum of Art, New York, NY 1
97514 2009.300.7863 0 0 174893 Costume Institute 8 Evening trousers 5967 Evening trousers Italian 36         Designer|Design House 202   Mariano Fortuny|Fortuny Spanish, Granada 1871–1949 Venice|Italian, founded 1906   Fortuny, Mariano|Fortuny 5357 Spanish|Italian 150 1871 |1906 1949 |2020 ca. 1930 1928 1932 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the estate of Mary Boocock Leavitt, 1974                           Metropolitan Museum of Art, New York, NY 1
97685 2009.300.8041 0 0 175066 Costume Institute 8 Evening trousers 5967 Evening trousers American 1         Designer 5   Halston American, Des Moines, Iowa 1932–1990 San Francisco, California   Halston 5263 American 1 1932 1990 ca. 1975 1973 1977 Silk  13944   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Carol Siris Roaman, 1983                           Metropolitan Museum of Art, New York, NY 1
98395 2009.300.8548 0 0 175894 Costume Institute 8 Evening trousers 5967 Evening trouser American or European 48                           1926–1959 1926 1959 wool, silk 15161   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 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 212.227ms · Data license: CC0 · Data source: metmuseum/openaccess