MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Medium = 15716

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End 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
68778 1980.96 0 1 81625 Costume Institute 8 Evening cape 5919 Evening cape Italian 36         Designer 5   Maria Gallenga Italian, Rome 1880–1944 Umbria   Gallenga Maria 5541 Italian 6 1880 1944 early 1920s 1920 1925 silk, glass, metallic thread 15716   Gift of Leafie Freda, 1980                           Metropolitan Museum of Art, New York, NY 1
68781 1977.292.2a, b 0 0 81630 Costume Institute 8 Ball gown 5911 Ball gown French 7         Designer|Design House 202   Charles Frederick Worth|House of Worth French (born England), Bourne 1825–1895 Paris|French, 1858–1956   Worth, Charles Frederick|Worth, House of 5618 French|French 21 1825 |1858 1895 |1956 ca. 1887 1882 1892 silk, glass, metallic thread 15716   Gift of Agnes de Mille, 1977                           Metropolitan Museum of Art, New York, NY 1
69284 49.3.28a, b 0 0 82607 Costume Institute 8 Ball gown 5911 Ball gown French 7         Design House|Designer 198   House of Worth|Charles Frederick Worth French, 1858–1956|French (born England), Bourne 1825–1895 Paris   Worth, House of|Worth, Charles Frederick 5708 French|French 21 1858 |1825 1956 |1895 ca. 1887 1882 1892 silk, glass, metallic thread 15716   Gift of Orme Wilson and R. Thornton Wilson, in memory of their mother, Mrs. Caroline Schermerhorn Astor Wilson, 1949                           Metropolitan Museum of Art, New York, NY 1
74359 1979.344.10a, b 0 1 94706 Costume Institute 8 Robe de Style 5992 Robe de Style French 7         Design House|Designer 198   House of Lanvin|Jeanne Lanvin French, founded 1889|French, 1867–1946   Lanvin, House of|Lanvin, Jeanne 5835 French|French 21 1889 |1867 9999 |1946 1922 1922 1922 silk, glass, metallic thread 15716   Gift of Mrs. Anthony Wilson, 1979                           Metropolitan Museum of Art, New York, NY 1
74748 C.I.65.33.2a, b 0 0 95266 Costume Institute 8 Evening ensemble 5879 Evening ensemble French 7         Design House|Designer|Designer 211 (b)|(a) House of Dior|Yves Saint Laurent|Marc Bohan French, founded 1947|French (born Algeria) Oran 1936–2008 Paris|French, born 1926   Dior, House of|Saint Laurent Yves|Bohan, Marc 6240 French|French|French 103 1947 |1936 |1926-08-22 9999 |2008 |2026 fall/winter 1961–1962 1961 1962 silk, glass, metallic thread 15716   Gift of Mrs. Henry Rogers Benjamin, 1965                           Metropolitan Museum of Art, New York, NY 1
76782 1977.210.17 0 0 99681 Costume Institute 8 Evening dress 5874 Evening dress probably French 203                           1927–28 1927 1928 silk, glass, metallic thread 15716   Gift of Mrs. John A. van Beuren and Mrs. Samuel M. V. Hamilton, 1977                           Metropolitan Museum of Art, New York, NY 1
79444 C.I.50.40.5a, b 0 0 106608 Costume Institute 8 Evening dress 5874 Evening dress American 1                           1902–3 1902 1903 silk, glass, metallic thread 15716   Gift of Estate of Annie-May Hegeman, 1950                           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 133.135ms · Data license: CC0 · Data source: metmuseum/openaccess