MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Object Name = 6290

View and edit SQL

Suggested facets: Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Medium, 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
74923 1973.138.1 0 0 96001 Costume Institute 8 Dress  6290 Dress American 1         Designer|Design House 202   Bill Blass|Maurice Rentner American, Fort Wayne, Indiana 1922–2002 New Preston, Connecticut|American, born Poland, 1889–1958   Blass, Bill|Rentner Maurice 6163 American|American, born Poland 215 1922-08-22|1889 2002-06-12|1958 1968 1968 1968 cotton 3340   Gift of Mrs. Mary Sykes Cahan, 1973                           Metropolitan Museum of Art, New York, NY 1
74931 1979.324.20a, b 0 0 96009 Costume Institute 8 Dress  6290 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 1974–75 1974 1975 wool, leather 15207   Gift of Lauren Bacall, 1979                           Metropolitan Museum of Art, New York, NY 1
74944 C.I.50.21.7a, b 0 0 96022 Costume Institute 8 Dress  6290 Dress French 7         Designer 5   Jean Dessès French (born Egypt), Alexandria 1904–1970 Athens   Desses, Jean 5633 French, born Egypt 167 1904 1970 1949 1949 1949 teca estron 17065   Gift of A. M Tenney Associates, Inc. and Tennessee Eastman Corporation, 1950                           Metropolitan Museum of Art, New York, NY 1
74963 1974.136.7a, b 0 0 96047 Costume Institute 8 Dress  6290 Dress French 7         Designer 5   André Courrèges French, Pau 1923–2016 Neuilly-sur-Seine   Courrèges, André 5436 French 2 1923 2016-01-07 1964 1964 1964 wool 15104   Gift of Kimberly Knitwear Inc., 1974                           Metropolitan Museum of Art, New York, NY 1
74970 1983.209.6a, b 0 0 96055 Costume Institute 8 Dress  6290 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 ca. 1975 1970 1980 wool 15104   Gift of Geoffrey Beene, 1983                           Metropolitan Museum of Art, New York, NY 1
74994 1976.166.2 0 0 96084 Costume Institute 8 Dress  6290 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 ca. 1967 1962 1972 wool 15104   Gift of Beth Levine, 1976                           Metropolitan Museum of Art, New York, NY 1
75003 1978.124.2a, b 0 0 96096 Costume Institute 8 Dress  6290 Dress French 7         Designer 5   Pierre Cardin French, born San Biagio di Callalta, Italy, 1922   Cardin, Pierre 5275 French, born Italy 139 1922-07-02 2022 1956–57 1956 1957 silk 15101   Gift of Dr. Simone F. Sternberg, 1978                           Metropolitan Museum of Art, New York, NY 1
75097 1976.256.1a, b 0 0 96203 Costume Institute 8 Dress  6290 Dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1962 1962 1962 wool 15104   Gift of Lee Siegel Blaufarb, 1976                           Metropolitan Museum of Art, New York, NY 1
76014 C.I.69.38.6a–c 0 0 97680 Costume Institute 8 Dress  6290 Dress French 7         Designer 5   Madame Grès (Alix Barton) French, Paris 1903–1993 Var region   Grès, Madame 5274 French 2 1903 1993 fall/winter 1969–70 1969 1970 wool, leather 15207   Gift of Mrs. Charles B. Wrightsman, 1969                           Metropolitan Museum of Art, New York, NY 1
76751 C.I.44.8.2 0 0 99595 Costume Institute 8 Dress  6290 Dress French 7         Designer 5   Edward Molyneux French (born England), London 1891–1974 Monte Carlo   Molyneux, Edward 5663 French, born England 170 1891 1974 1926 1926 1926 silk 15101   Gift of Mr. Lee Simonson, 1944                           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 242.335ms · Data license: CC0 · Data source: metmuseum/openaccess