MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 101 rows (hide)

Query parameters

rowidObject NumberIs HighlightIs Public DomainObject IDDepartmentObject NameTitleCulturePeriodDynastyReignPortfolioArtist RoleArtist PrefixArtist Display NameArtist Display BioArtist SuffixArtist Alpha SortArtist NationalityArtist Begin DateArtist End DateObject DateObject Begin DateObject End DateMediumDimensionsCredit LineGeography TypeCityStateCountyCountryRegionSubregionLocaleLocusExcavationRiverClassificationRights and ReproductionLink ResourceRepository
77552 24.166.8 0 1 102454 8 6101 Fob 27                           late 18th century 1750 1799 15118   Anonymous Gift, 1924                           1
77553 24.166.10 0 1 102455 8 6101 Fob 7                           18th century 1700 1799 15118   Anonymous Gift, 1924                           1
77554 24.166.11 0 1 102456 8 6101 Fob 7                           18th century 1700 1799 15100   Anonymous Gift, 1924                           1
77555 24.166.12 0 1 102457 8 6101 Fob 7                           18th century 1700 1799 6962   Anonymous Gift, 1924                           1
77556 24.166.18 0 1 102460 8 6101 Fob 7                           18th century 1700 1799 15100   Anonymous Gift, 1924                           1
77557 24.166.19 0 1 102461 8 6101 Fob 7                           18th century 1700 1799 15118   Anonymous Gift, 1924                           1
77558 24.166.23 0 1 102462 8 6101 Fob 7                           18th century 1700 1799 15696   Anonymous Gift, 1924                           1
77559 24.166.24 0 1 102463 8 6101 Fob 12                           late 18th century 1750 1799 17483   Anonymous Gift, 1924                           1
77560 24.166.27 0 1 102464 8 6101 Fob 36                           late 18th century 1750 1799 15696   Anonymous Gift, 1924                           1
77561 24.166.28 0 1 102465 8 6105 Garters 7                           early 19th century 1800 1850 15777   Anonymous Gift, 1924                           1
77562 24.166.26 0 1 102466 8 6101 Fob 12                           late 18th century 1750 1799 17484   Anonymous Gift, 1924                           1
77563 24.166.34 0 1 102467 8 6101 Fob 27                           ca. 1800 1795 1805 15192   Anonymous Gift, 1924                           1
85917 24.166.29 0 1 121188 8 6105 Garters 7                           early 19th century 1800 1850 15777   Anonymous Gift, 1924                           1
70565 C.I.X.37.33 0 1 84537 8 5877 Dress 6                           ca. 1780 1775 1785 15101   Anonymous Gift, 1933                           1
86924 C.I.38.104.2 0 0 123135 8 1281 Shawl 1                           1700–1938 1700 1938 15104   Anonymous Gift, 1938                           1
77494 43.156.10a–d 0 0 102372 8 6305 Christening ensemble 7                           1904 1904 1904 3340   Anonymous Gift, 1943                           1
77426 49.32.27 0 1 102266 8 5976 Parasol 7                           mid-19th century 1825 1875 17470   Anonymous Gift, 1948                           1
76376 49.32.5 0 0 98245 8 173 Cap 6                           19th century 1800 1899 15100   Anonymous Gift, 1949                           1
77750 49.32.18a, b 0 1 102710 8 5869 Cuffs 676                           mid-19th century 1825 1875 15100   Anonymous Gift, 1949                           1
77752 49.32.28 0 1 102712 8 1038 Collar 233                           early 19th century 1800 1850 3340   Anonymous Gift, 1949                           1
77753 49.32.29a, b 0 1 102713 8 6367 Undersleeves 6                           mid-19th century 1825 1875 15100   Anonymous Gift, 1949                           1
77086 C.I.X.56.5.1 0 0 100549 8 1062 Petticoat 1                           1915 1915 1915 15395   Anonymous Gift, 1956                           1
77087 C.I.X.56.5.2 0 0 100550 8 1062 Petticoat 1                           1915 1915 1915 15395   Anonymous Gift, 1956                           1
77088 C.I.X.57.2 0 1 100552 8 6347 Barbe 1                           mid-19th century 1825 1875 15100   Anonymous Gift, 1957                           1
86838 C.I.64.18a, b 0 0 122645 8 5887 Shirt 1                           1930s 1930 1939 15096   Anonymous Gift, 1964                           1
79087 C.I.X.68.1.1 0 0 105476 8 5960 Sunglasses 1                           1967 1967 1967 17669   Anonymous Gift, 1968                           1
79088 C.I.X.68.1.2 0 0 105477 8 557 Watch 1                           1967 1967 1967 15807   Anonymous Gift, 1968                           1
79089 C.I.X.68.1.3a, b 0 0 105478 8 5749 Slippers 1                           1967 1967 1967 15103   Anonymous Gift, 1968                           1
79090 C.I.X.68.1.4a, b 0 0 105479 8 1158 Stockings 1                           1967 1967 1967 15103   Anonymous Gift, 1968                           1
79091 C.I.X.68.1.5a, b 0 0 105480 8 1158 Stockings 1                           1967 1967 1967 15103   Anonymous Gift, 1968                           1
71391 1973.139 0 0 85962 8 5874 Evening dress 7         202   Cristobal Balenciaga|House of Balenciaga Spanish, Guetaria, San Sebastian 1895–1972 Javea|French, founded 1937   5299 143 1895-01-21|1937 1972-03-23|9999 1965 1965 1965 15101   Anonymous Gift, 1973                           1
80198 1973.226 0 1 107984 8 5877 Dress 40                           ca. 1836 1831 1841 15101   Anonymous Gift, 1973                           1
83636 1973.62.1 0 0 116142 8 6084 Pillbox hat 1         226   Bergdorf Goodman|Cristobal Balenciaga American, founded 1899|Spanish, Guetaria, San Sebastian 1895–1972 Javea   6677 186 1899 |1895-01-21 9999 |1972-03-23 ca. 1966 1961 1971 15737   Anonymous Gift, 1973                           1
83637 1973.62.2 0 0 116143 8 6084 Pillbox hat 1         205   Cristobal Balenciaga|Bergdorf Goodman Spanish, Guetaria, San Sebastian 1895–1972 Javea|American, founded 1899   6678 173 1895-01-21|1899 1972-03-23|9999 ca. 1966 1961 1971 15100   Anonymous Gift, 1973                           1
70425 1977.333.59a, b 0 0 84383 8 5875 Ensemble 1                           late 1960s–early 1970s 1965 1975 16218   Anonymous Gift, 1977                           1
86346 1979.39 0 0 121834 8 5902 Necktie 35                           fall/winter 1978–79 1978 1979 15101   Anonymous Gift, 1979                           1
76673 1980.127.1a, b 0 0 99005 8 6340 Sweat shirt 1                           1979 1979 1979 17321   Anonymous Gift, 1980                           1
74783 1981.303.3a, b 0 0 95311 8 6236 Cardigan sweater 7         209   House of Chanel French, founded 1913   5405 2 1913 2099 1974 1974 1974 15578   Anonymous Gift, 1981                           1
76615 1981.303.2 0 0 98778 8 237 Necklace 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1981 1981 1981 15192   Anonymous Gift, 1981                           1
78780 1981.258a–c 0 0 104874 8 5901 Jewelry set 777         5   Ilias Lalaounis Greek, Athens 1920–2013 Athens   6506 237 1920 2013 1976 1976 1976 17607   Anonymous Gift, 1981                           1
70514 1983.284.1a, b 0 0 84486 8 5874 Evening dress 7         5   Madame Grès (Alix Barton) French, Paris 1903–1993 Var region   5274 2 1903 1993 ca. 1965 1960 1970 15101   Anonymous Gift, 1983                           1
70515 1983.284.2 0 0 84487 8 5874 Evening dress 7         5   Madame Grès (Alix Barton) French, Paris 1903–1993 Var region   5274 2 1903 1993 ca. 1962 1957 1967 15101   Anonymous Gift, 1983                           1
75050 1983.52.2a, b 0 0 96150 8 5876 Suit 1         5   Geoffrey Beene American, Haynesville, Louisiana 1927–2004 New York   5306 1 1927-08-30 2004-09-28 1973 1973 1973 15104   Anonymous Gift, 1983                           1
75058 1983.52.1a, b 0 0 96161 8 5875 Ensemble 1         5   Geoffrey Beene American, Haynesville, Louisiana 1927–2004 New York   5306 1 1927-08-30 2004-09-28 1973 1973 1973 15104   Anonymous Gift, 1983                           1
75285 1983.288 0 0 96585 8 4973 Coat 1         5   Mainbocher American, 1890–1976   5498 1 1890 1976 ca. 1956 1951 1961 15104   Anonymous Gift, 1983                           1
75592 1983.284.6a–c 0 0 97044 8 5874 Evening dress 36         5   Valentino Italian, born 1932   5278 6 1932 2032 ca. 1970 1965 1975 15154   Anonymous Gift, 1983                           1
75593 1983.284.7a, b 0 0 97045 8 5879 Evening ensemble 36         5   Valentino Italian, born 1932   5278 6 1932 2032 ca. 1968 1963 1973 15101   Anonymous Gift, 1983                           1
75599 1983.52.4 0 0 97052 8 5877 Dress 36         202   Gianni Versace|Gianni Versace Italian, 1946–1997|Italian, founded 1978   5321 93 1946 |1978 1997 |9999 1979 1979 1979 15101   Anonymous Gift, 1983                           1
76111 1983.284.3a, b 0 0 97846 8 5879 Evening ensemble 36         5   Valentino Italian, born 1932   5278 6 1932 2032 ca. 1974 1969 1979 15101   Anonymous Gift, 1983                           1
76217 1983.284.4 0 0 98020 8 5874 Evening dress 36         249   Valentino|Boutique Valentino Italian, born 1932|Italian, founded 1969   6327 93 1932 |1969 2032 |9999 ca. 1968 1963 1973 15101   Anonymous Gift, 1983                           1
76218 1983.284.5a–c 0 0 98021 8 5879 Evening ensemble 36         5   Valentino Italian, born 1932   5278 6 1932 2032 ca. 1970 1965 1975 15101   Anonymous Gift, 1983                           1
76219 1983.284.8 0 0 98022 8 5874 Evening dress 36         5   Valentino Italian, born 1932   5278 6 1932 2032 ca. 1969 1964 1974 15181   Anonymous Gift, 1983                           1
81045 1983.52.5 0 0 109383 8 5953 Blouse 36         5   Gianni Versace Italian, 1946–1997   5387 6 1946 1997 1975 1975 1975 15101   Anonymous Gift, 1983                           1
86390 1983.282.2a–c 0 0 121915 8 2179 Belt 1         5   Barry Kieselstein-Cord American, born 1948   5510 1 1948 2048 1979 1979 1979 15127   Anonymous Gift, 1983                           1
86391 1983.282.4a–d 0 0 121917 8 2179 Belt 1         5   Barry Kieselstein-Cord American, born 1948   5510 1 1948 2048 1979 1979 1979 15127   Anonymous Gift, 1983                           1
81475 1984.65a–c 0 0 110098 8 5879 Evening ensemble 7         5   André Courrèges French, Pau 1923–2016 Neuilly-sur-Seine   5436 2 1923 2016-01-07 ca. 1970 1965 1975 17876   Anonymous Gift, 1984                           1
74578 1986.378 0 0 95064 8 5920 Evening coat 13         216   Cristobal Balenciaga|EISA|House of Balenciaga Spanish, Guetaria, San Sebastian 1895–1972 Javea|Spanish|French, founded 1937   5988 198 1895-01-21|1937 1972-03-23|9999 1963 1963 1963 15101   Anonymous Gift, 1986                           1
83978 1986.537.1 0 1 116866 8 1022 Purse 156                           16th century 1500 1599 18211   Anonymous Gift, 1986                           1
84053 1986.124.15 0 0 116999 8 1022 Purse 48                           1900–1925 1900 1925 15192   Anonymous Gift, 1986                           1
84248 1986.537.2 0 0 117311 8 6327 Chatelaine 12                           last third 19th century 1850 1899 17898   Anonymous Gift, 1986                           1
84838 1986.124.14 0 0 119059 8 1038 Collar 12                           late 19th century 1850 1899 15098   Anonymous Gift, 1986                           1
85417 1986.124.13a, b 0 0 120023 8 6268 Sleeves 12                           late 19th century 1850 1899 15098   Anonymous Gift, 1986                           1
85455 1986.124.17a, b 0 1 120061 8 6367 Undersleeves 48                           1840–59 1840 1859 15101   Anonymous Gift, 1986                           1
85567 1986.537.4a–c 0 1 120533 8 6542 Cockade fan 12                           late 18th–early 19th century 1750 1850 17898   Anonymous Gift, 1986                           1
87111 1986.124.1 0 0 124182 8 119 Bracelet 1         5   Kenneth Jay Lane American, Detroit, Michigan 1932–2017 New York   5360 1 1932 2017 late 1960s 1965 1969 6962   Anonymous Gift, 1986                           1
87137 1986.124.11 0 0 124210 8 119 Bracelet 48                           1950s 1950 1959 15219   Anonymous Gift, 1986                           1
87138 1986.124.2 0 0 124211 8 119 Bracelet 1                           ca. 1970 1965 1975 15192   Anonymous Gift, 1986                           1
87299 1986.124.9 0 0 124406 8 237 Necklace 1                           1965–75 1965 1975 6962   Anonymous Gift, 1986                           1
87314 1986.124.8 0 0 124438 8 6272 Choker 48                           1960–79 1960 1979 17215   Anonymous Gift, 1986                           1
87315 1986.124.7 0 0 124439 8 6272 Choker 48                           1950–69 1950 1969 15192   Anonymous Gift, 1986                           1
87358 1986.124.10 0 0 124488 8 238 Pin 48                           1950–69 1950 1969 15192   Anonymous Gift, 1986                           1
87359 1986.124.4 0 0 124489 8 238 Pin 48                           1900–1950 1900 1950 15345   Anonymous Gift, 1986                           1
87382 1986.124.3 0 0 124515 8 636 Ring 48                           1875–1925 1875 1925 15192   Anonymous Gift, 1986                           1
87383 1986.124.5 0 0 124516 8 636 Ring 1         5 Attributed to Hiro (Yahuhiro Wakabayashi) American, born Shanghai, 1930   6758 252 1930 2030 early 1970s 1970 1975 15345   Anonymous Gift, 1986                           1
87384 1986.124.6 0 0 124517 8 636 Ring 48                           1800–1950 1800 1950 6962   Anonymous Gift, 1986                           1
88252 1986.381a, b 0 0 129890 8 6017 Dressing gown 1         5   A. Sulka & Company French, 1893–2002   6089 2 1893 2002 1917–24 1917 1924 15101   Anonymous Gift, 1986                           1
86425 1987.49.1a, b 0 0 121957 8 5906 Socks 1                           1920s 1920 1929 15214   Anonymous Gift, 1987                           1
86426 1987.49.2a, b 0 0 121958 8 5906 Socks 1                           1945–55 1945 1955 18484   Anonymous Gift, 1987                           1
72387 1990.65 0 0 88948 8 5896 Shoes 1989                           late 19th century 1850 1899 16669   Anonymous Gift, 1990                           1
67932 1993.137.1 0 0 80670 8 5874 Evening dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
67933 1993.137.2 0 0 80671 8 5874 Evening dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
67934 1993.137.3 0 0 80672 8 5874 Evening dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
67935 1993.137.4 0 0 80673 8 5874 Evening dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
67936 1993.137.5a–c 0 0 80674 8 5933 Cocktail dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
67937 1993.137.6 0 0 80675 8 5874 Evening dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
67938 1993.137.7 0 0 80676 8 5920 Evening coat 1         202   Oscar de la Renta|Oscar de la Renta, Ltd. American (born Dominican Republic), Santo Domingo 1932–2014 Kent, Connecticut|American, founded 1965   5312 146 1932-07-22|1965 2014 |9999 1980s 1980 1980 15101   Anonymous Gift, 1993                           1
67939 1993.137.8a–c 0 0 80677 8 5879 Evening ensemble 1         202   Oscar de la Renta|Oscar de la Renta, Ltd. American (born Dominican Republic), Santo Domingo 1932–2014 Kent, Connecticut|American, founded 1965   5312 146 1932-07-22|1965 2014 |9999 1980s 1980 1989 15118   Anonymous Gift, 1993                           1
67940 1993.137.9 0 0 80678 8 5933 Cocktail dress 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 1980s 1980 1989 15101   Anonymous Gift, 1993                           1
73730 1993.59.1a–e 0 0 92208 8 5875 Ensemble 35         198   Matsuda|Mr. Yukio Kobayashi Japanese|Japanese   6137 72     1992 1992 1992 15101   Anonymous Gift, 1993                           1
74163 1993.59.2a–e 0 0 94276 8 5875 Ensemble 35         198   Matsuda|Mr. Yukio Kobayashi Japanese|Japanese   6137 72     1992 1992 1992 15101   Anonymous Gift, 1993                           1
74167 1993.224 0 0 94280 8 6099 Sundress 1         205   Anne Fogarty|Saks Fifth Avenue American, Pittsburgh, Pennsylvania 1919–1980 New York|American, founded 1924   6180 5 1919 |1924 1980 |9999 ca. 1953 1948 1958 3340   Anonymous Gift, 1993                           1
66522 1996.139a, b 0 0 79055 8 1056 Hat 1         5   Rudi Gernreich American (born Austria), Vienna 1922–1985 Los Angeles, California   5268 27 1922 1985 1958 1958 1958 15145   Anonymous Gift, 1996                           1
66672 1996.444 0 0 79245 8 413 Fan 48                           probably fourth quarter 19th century 1875 1899 15189   Anonymous Gift, 1996                           1
67050 1997.469.1a, b 0 0 79650 8 5876 Suit 7         202   Karl Lagerfeld|House of Chanel French, born Hamburg, 1938|French, founded 1913   5297 142 1938 |1913 2038 |2099 ca. 1991 1986 1996 15104   Anonymous Gift, 1997                           1
67051 1997.469.2a, b 0 0 79651 8 5874 Evening dress 7         202   Karl Lagerfeld|House of Chanel French, born Hamburg, 1938|French, founded 1913   5297 142 1938 |1913 2038 |2099 fall/winter 1988–89 1988 1989 15118   Anonymous Gift, 1997                           1
68892 2000.366.1a, b 0 1 81763 8 5933 Cocktail dress 1         5   Ceil Chapman American, born 1912   5619 1 1912 1912 1950s 1950 1959 15169   Anonymous Gift, 2000                           1
68893 2000.366.2 0 0 81764 8 5475 Trousers 36         209   Gucci Italian, founded 1921   5344 6 1921 2112 1970s 1970 1979 3340   Anonymous Gift, 2000                           1
68894 2000.366.3a, b 0 0 81765 8 1022 Purse 1         5   John Frederics American, 1929–1948   5538 1 1929 1948 ca. 1945 1940 1950 15745   Anonymous Gift, 2000                           1
72300 2003.73.2a–c 0 0 88361 8 5879 Evening ensemble 7         202   Yves Saint Laurent|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1961   5348 21 1936 |1961 2008 |9999 ca. 1977 1972 1982 15101   Anonymous Gift, 2003                           1
72324 2003.73.3 0 0 88681 8 5877 Dress 7         5   Azzedine Alaïa French (born Tunisia), Tunis 1935–2017 Paris   5376 2 1935 2017 ca. 1990 1985 1995 16648   Anonymous Gift, 2003                           1
72346 2003.73.1a, b 0 0 88814 8 5896 Shoes 7                           19th century 1800 1900 16654   Anonymous Gift, 2003                           1
Powered by Datasette · Query took 107.309ms · Data license: CC0 · Data source: metmuseum/openaccess