MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Medium = 19949

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, Object Begin 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
94315 2009.300.4783 0 0 169003 Costume Institute 8 Handkerchief 1048 Handkerchief American 1                           1930–39 1930 1939 Silk, sequins 19949   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
95050 2009.300.5523 0 0 169738 Costume Institute 8 Evening stole 5955 Evening stole British 6                           1900–1910 1900 1910 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Amelia Beard Hollenback, 1966                           Metropolitan Museum of Art, New York, NY 1
95729 2009.300.6142 0 0 170417 Costume Institute 8 Scarf 1153 Scarf American 1         Designer 5   Vera Neumann American, 1907–1993   Neumann Vera 7514 American 1 1907 1993 1953 1953 1953 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009                           Metropolitan Museum of Art, New York, NY 1
96323 2009.300.6485a, b 0 0 173505 Costume Institute 8 Ball gown 5911 Ball gown Austrian 184         Design House 209   Rudolph Hoffman & Company     Hoffman & Company Rudolph 7742       1900–1902 1900 1902 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Henry Beale Spelman and Mrs. John Taylor Arm in memory of their mother, Mrs. Henry Frothingham Noyes, 1942                           Metropolitan Museum of Art, New York, NY 1
96353 2009.300.6522a, b 0 0 173535 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Mme. Eta Hentz American, born Hungary   Hentz Eta 6902 American, born Hungary 261     fall/winter 1936–37 1936 1936 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Madame Eta of Ren-Eta, Inc., 1944                           Metropolitan Museum of Art, New York, NY 1
96355 2009.300.6524 0 0 173537 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Manufacturer 3   Mme. Eta Hentz|Ren-Eta Gowns, Inc. American, born Hungary   Hentz Eta|Ren-Eta Gowns, Inc. 7125 American, born Hungary|American 264     fall/winter 1938–39 1938 1938 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Madame Eta of Ren-Eta, Inc., 1944                           Metropolitan Museum of Art, New York, NY 1
96403 2009.300.6586a, b 0 0 173585 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Manufacturer 3   Mme. Eta Hentz|Ren-Eta Gowns, Inc. American, born Hungary   Hentz Eta|Ren-Eta Gowns, Inc. 7125 American, born Hungary|American 264     1946 1946 1946 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Madame Eta Hentz, 1949                           Metropolitan Museum of Art, New York, NY 1
96413 2009.300.6596 0 1 173595 Costume Institute 8 Evening cape 5919 Evening cape French 7         Department Store 208   Bon Marché French, founded ca. 1852   Bon Marche 5992 French 2 1852 9999 ca. 1895 1893 1897 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Josephine Thayer, 1949                           Metropolitan Museum of Art, New York, NY 1
96578 2009.300.6789 0 0 173796 Costume Institute 8 Evening skirt 6279 Evening skirt American 1         Designer 5   Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 1944 1944 1944 Silk, sequins 19949   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
97026 2009.300.7284 0 0 174405 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Mme. Eta Hentz American, born Hungary   Hentz Eta 6902 American, born Hungary 261     ca. 1945 1943 1947 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Eta Hentz, 1963                           Metropolitan Museum of Art, New York, NY 1
97122 2009.300.7419 0 0 174501 Costume Institute 8 Evening cape 5919 Evening cape American 1                           ca. 1935 1933 1937 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. George A. Bonaventure in memory of Mrs. James Steel, 1965                           Metropolitan Museum of Art, New York, NY 1
97126 2009.300.7423a–c 0 0 174505 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Retailer 8   Hattie Carnegie, Inc. American, 1918–1965   Carnegie, Inc., Hattie 5657 American 1 1918 1965 ca. 1960 1958 1962 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Frances Carpenter, 1965                           Metropolitan Museum of Art, New York, NY 1
97308 2009.300.7634 0 0 174687 Costume Institute 8 Cocktail dress 6005 Cocktail dress American 1         Designer 5   Norman Norell American, Noblesville, Indiana 1900–1972 New York   Norell, Norman 5471 American 1 1900 1972 1965 1965 1965 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lauren Bacall, 1967                           Metropolitan Museum of Art, New York, NY 1
97688 2009.300.8044 0 0 175069 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Manufacturer 3   Norman Norell|Traina-Norell American, Noblesville, Indiana 1900–1972 New York|American, founded 1941   Norell, Norman|Traina-Norell 5904 American|American 5 1900 |1941 1972 |1960 ca. 1953 1951 1955 Silk, sequins 19949   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Emmet Whitlock, 1983                           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 139.137ms · Data license: CC0 · Data source: metmuseum/openaccess