MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where Object Name = 6225

View and edit SQL

Suggested facets: Is Public Domain, 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, Medium, 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
73011 C.I.46.87.8 0 1 91048 Costume Institute 8 Evening vest 6225 Evening vest European 12                           late 1840s 1840 1849 silk 15101   Gift of Mr. Lincoln Kirstein, 1946                           Metropolitan Museum of Art, New York, NY 1
73054 C.I.39.94.3 0 0 91091 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1910–16 1910 1916 [no medium available] 15100   Gift of Miss Alice Baldwin Beer, 1939                           Metropolitan Museum of Art, New York, NY 1
73060 1976.390.47 0 0 91098 Costume Institute 8 Evening vest 6225 Evening vest American or European 48                           1910–30 1910 1930 cotton 3340   Gift of Irma A. Bloomingdale, 1976                           Metropolitan Museum of Art, New York, NY 1
73061 1976.390.48 0 0 91099 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1910–30 1910 1930 cotton 3340   Gift of Irma A. Bloomingdale, 1976                           Metropolitan Museum of Art, New York, NY 1
73077 C.I.39.94.2 0 1 91116 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1880–85 1880 1885 silk, pearl 15684   Gift of Miss Alice Baldwin Beer, 1939                           Metropolitan Museum of Art, New York, NY 1
79082 C.I.X.66.4 0 0 105467 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1930s 1930 1939 silk, cotton 15149   Gift of Mr. Randolph Bullock, 1966                           Metropolitan Museum of Art, New York, NY 1
89867 2009.300.1186 0 0 155872 Costume Institute 8 Evening vest 6225 Evening vest French 7         Designer 5   Elsa Schiaparelli Italian, 1890–1973   Schiaparelli Elsa 5266 Italian 6 1890 1973 fall 1938 1938 1938 silk 15101   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
89885 2009.300.1201 0 0 155890 Costume Institute 8 Evening vest 6225 Evening vest French 7         Designer|Design House 202   Madame Marie Gerber|Callot Soeurs French|French, active 1895–1937   Gerber, Marie, Madame|Callot Soeurs 6901 French|French 21 1895 1937 ca. 1910 1908 1912 linen 15098   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
89886 2009.300.1202 0 0 155891 Costume Institute 8 Evening vest 6225 Evening vest French 7         Designer|Design House 202   Madame Marie Gerber|Callot Soeurs French|French, active 1895–1937   Gerber, Marie, Madame|Callot Soeurs 6901 French|French 21 1895 1937 ca. 1913 1910 1916 linen 15098   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
89887 2009.300.1203 0 0 155892 Costume Institute 8 Evening vest 6225 Evening vest probably French 203         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 ca. 1910 1908 1912 silk, linen, metal 17635   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
91591 2009.300.2746 0 1 157607 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1838 1838 1838 silk, cotton, wool, leather, glass 19533   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Thomas O. Callender, 1948                           Metropolitan Museum of Art, New York, NY 1
92991 2009.300.661 0 1 159217 Costume Institute 8 Evening vest 6225 Evening vest probably French 203                           1840–49 1840 1849 silk, cotton 15149   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the Pierrepont Family, 1941                           Metropolitan Museum of Art, New York, NY 1
93021 2009.300.689 0 1 159247 Costume Institute 8 Evening vest 6225 Evening vest probably French 203                           1855–60 1855 1860 silk 15101   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Merle Munn, 1949                           Metropolitan Museum of Art, New York, NY 1
93210 2009.300.859 0 1 159436 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1850–55 1850 1855 silk, cotton 15149   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Dorothy L. Tapscott and Gladys L. Campbell, 1962                           Metropolitan Museum of Art, New York, NY 1
93251 2009.300.896 0 1 159477 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1830–35 1830 1835 silk, cotton 15149   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Alvah E. Reed, 1966                           Metropolitan Museum of Art, New York, NY 1
93260 2009.300.904 0 1 159486 Costume Institute 8 Evening vest 6225 Evening vest American 1                           ca. 1830 1828 1832 silk, linen 15099   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Wismer H. Townsend, 1966                           Metropolitan Museum of Art, New York, NY 1
93296 2009.300.936 0 1 159522 Costume Institute 8 Evening vest 6225 Evening vest American 1                           1885–95 1885 1895 silk, cotton 15149   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of The Jason and Peggy Westerfield Collection, 1969                           Metropolitan Museum of Art, New York, NY 1
94293 2009.300.3959 0 0 168981 Costume Institute 8 Evening vest 6225 Evening vest French 7         Designer|Design House 202   Elsa Schiaparelli|House of Schiaparelli Italian, 1890–1973|French, founded 1928   Schiaparelli Elsa|Schiaparelli House of 5723 Italian|French 148 1890 |1928 1973 |9999 winter 1936–37 1936 1937 Silk, metallic 19804   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2012; Gift of Arturo and Paul Peralta-Ramos, 1954                           Metropolitan Museum of Art, New York, NY 1
98396 2009.300.8538 0 0 175896 Costume Institute 8 Evening vest 6225 Evening ves American or European 48                           1926–1959 1926 1959 cotton, silk 15395   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 124.925ms · Data license: CC0 · Data source: metmuseum/openaccess