MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Medium = 19886

View and edit SQL

Suggested facets: Object Name, Title, Culture, Artist Role, Artist Prefix, 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, 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
93975 2009.300.4449 0 0 168663 Costume Institute 8 Hat 1056 Hat American 1         Designer 5   Sally Victor American, 1905–1977   Victor, Sally 5907 American 1 1905 1977 1933 1933 1933 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Sally Victor, Inc., 1944                           Metropolitan Museum of Art, New York, NY 1
94105 2009.300.4600a–c 0 0 168793 Costume Institute 8 Hat 1056 Hat American 1         Designer 5   Sally Victor American, 1905–1977   Victor, Sally 5907 American 1 1905 1977 ca. 1945 1943 1947 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Eleanor P. Whitaker, 1949                           Metropolitan Museum of Art, New York, NY 1
94277 2009.300.4760 0 0 168965 Costume Institute 8 Cape 5042 Cape Italian 36         Manufacturer|Designer 18 Textile manufactured by Luigi Bevilacqua|Maria Chiara Galotti Italian   Bevilacqua Luigi|Galotti Maria Chiara 7530 Italian 6     1951 1951 1951 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the Italian Government, 1954                           Metropolitan Museum of Art, New York, NY 1
94416 2009.300.4863a–c 0 0 169104 Costume Institute 8 Cocktail Hat 6080 Cocktail hat American 1         Designer|Maker 4   John P. John|John Frederics American, 1906–1993|American, 1929–1948   John John P.|John Frederics 7170 American|American 5 1906 |1929 1993 |1948 1948 1948 1948 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. R. A. Bernatschke, 1955                           Metropolitan Museum of Art, New York, NY 1
94528 2009.300.4994 0 0 169216 Costume Institute 8 Hat 1056 Hat American 1         Designer 5   May Wamelink Gorman     Gorman, May Wamelink 7548       ca. 1945 1943 1947 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Hollis K. Thayer, 1958                           Metropolitan Museum of Art, New York, NY 1
94646 2009.300.5118 0 0 169334 Costume Institute 8 Cowboy hat 6468 Cowboy hat American 1         Maker|Retailer 34   Kensington Hats, Inc.|Dave Jones     Kensington Hats, Inc.|Jones Dave 7562 American|American 5     ca. 1945 1943 1947 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Anonymous gift, 1960                           Metropolitan Museum of Art, New York, NY 1
96658 2009.300.6872 0 0 173890 Costume Institute 8 Cocktail belt 6736 Cocktail belt probably American 40                           1945–50 1945 1950 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Arturo and Paul Peralta-Ramos, 1955                           Metropolitan Museum of Art, New York, NY 1
96915 2009.300.7166 0 0 174294 Costume Institute 8 Evening skirt 6279 Evening skirt American 1         Designer|Designer 85 Textile by Dorothy Liebes|Bonnie Cashin American, Santa Rosa, California 1897–1972 New York|American, Oakland, California 1908–2000 New York   Liebes, Dorothy|Cashin, Bonnie 7804 American|American 5 1897 |1908 1972 |2000 ca. 1950 1948 1952 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Gypsy Rose Lee, 1961                           Metropolitan Museum of Art, New York, NY 1
96937 2009.300.7188a–c 0 0 174316 Costume Institute 8 Suit 5876 Suit American 1         Designer 5   Harry Berkowitz     Berkowitz Harry 7811       1945–49 1945 1949 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of A. C. Moss, 1961                           Metropolitan Museum of Art, New York, NY 1
97199 2009.300.7525a, b 0 0 174578 Costume Institute 8 Sweater set 6666 Sweater set Scottish 41         Designer 5 Attributed to Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 ca. 1948 1946 1950 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Edith d'Errecalde, 1967                           Metropolitan Museum of Art, New York, NY 1
97668 2009.300.8024 0 0 175049 Costume Institute 8 Evening skirt 6279 Evening skirt American 1         Designer|Designer 85 Textile by Dorothy Liebes|Bonnie Cashin American, Santa Rosa, California 1897–1972 New York|American, Oakland, California 1908–2000 New York   Liebes, Dorothy|Cashin, Bonnie 7804 American|American 5 1897 |1908 1972 |2000 1957 1957 1957 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Philip Sills, 1981                           Metropolitan Museum of Art, New York, NY 1
97926 2009.300.8296 0 0 175307 Costume Institute 8 Trousers 5475 Trousers French 7         Manufacturer 20   Jupiter     Jupiter 7927       1966–68 1966 1968 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of George Drew, 1988                           Metropolitan Museum of Art, New York, NY 1
97927 2009.300.8297 0 0 175308 Costume Institute 8 Trousers 5475 Trousers French 7         Manufacturer 20   Jupiter     Jupiter 7927       ca. 1967 1965 1969 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of George Drew, 1988                           Metropolitan Museum of Art, New York, NY 1
98013 2009.300.8389a, b 0 0 175394 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Designer 5 Possibly Rudi Gernreich American (born Austria), Vienna 1922–1985 Los Angeles, California   Gernreich, Rudi 5268 American, born Austria 27 1922 1985 ca. 1968 1966 1970 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the Boxer family in memory of Emily J. Boxer, 1994                           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 131.694ms · Data license: CC0 · Data source: metmuseum/openaccess