MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

20 rows where Artist Nationality = 1 and Culture = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, 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 Metadata Date Repository
68899 68899 1974.243.3 0 0 81771 Costume Institute 8 Evening dress 5874 Evening dress American or European 48         Department Store 208 B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 early 1920s 1920 1925 silk 15101   Gift of Lucinda S. Day, 1974                           http://www.metmuseum.org/art/collection/search/81771 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
68991 68991 2000.480.15a, b 0 0 82004 Costume Institute 8 Shoes 5896 Shoes American or European 48         Designer|Department Store 205 for Walter Newberger|Wilkes Bashford American, founded 1966   Newberger Walter|Wilkes Bashford 5741 American 1 1966 9999 1980s 1980 1989 leather, fur 15628   Gift of William Lipton, 2000                           http://www.metmuseum.org/art/collection/search/82004 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
69282 69282 1993.287.2a–d 0 0 82605 Costume Institute 8 Suit 5876 Suit American or European 48         Department Store 208   Hickson Inc.     Hickson Inc. 5779 American 1     ca. 1918 1913 1923 wool 15104   Gift of Susan Myrick, Barbara M. Myers, Elizabeth M. Wissler, 1993                           http://www.metmuseum.org/art/collection/search/82605 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74538 74538 1991.54.1a, b 0 0 94948 Costume Institute 8 Gloves 1054 Gloves American or European 48         Department Store 208   Saks Fifth Avenue American, founded 1924   Saks Fifth Avenue 5336 American 1 1924 9999 1940s 1940 1949 suede, metal, plastic 16995   Gift of Rita McNamara Pleet, 1991                           http://www.metmuseum.org/art/collection/search/94948 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
76699 76699 1977.412.23 0 0 99045 Costume Institute 8 Shorts 5888 Shorts American or European 48         Department Store 208   Bonwit Teller & Co. American, founded 1907   Bonwit Teller & Co. 5998 American 1 1907 2050 1971 1971 1971 leather 15128   Gift of Glady Whitfield Solomon, 1977                           http://www.metmuseum.org/art/collection/search/99045 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
77175 77175 1979.231.2 0 0 100893 Costume Institute 8 Evening cape 5919 Evening cape American or European 48         Design House|Designer 198   Milgrim|Miss Sally Milgrim 1927–1990|American, born Austria, 1891–1994   Milgrim|Milgrim Sally Miss 6440 American 1 1927 |1891 1990 |1994 1940–45 1940 1945 rayon 15114   Gift of Mrs. Howard Ellis Cox, 1979                           http://www.metmuseum.org/art/collection/search/100893 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
77178 77178 1984.587.1a, b 0 0 100896 Costume Institute 8 Ensemble 5875 Ensemble American or European 48         Department Store 208   Saks Fifth Avenue American, founded 1924   Saks Fifth Avenue 5336 American 1 1924 9999 ca. 1942 1937 1947 cotton, metal, plastic 17403   Gift of Miriam Whitney Coletti, 1984                           http://www.metmuseum.org/art/collection/search/100896 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
77184 77184 1977.145.3a, b 0 0 100972 Costume Institute 8 Evening dress 5874 Evening dress American or European 48         Department Store 208   Bergdorf Goodman American, founded 1899   Bergdorf Goodman 5548 American 1 1899 9999 1950–55 1950 1955 silk 15101   Gift of Mrs. James W. Fosburgh, 1977                           http://www.metmuseum.org/art/collection/search/100972 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80599 80599 1974.243.11 0 0 108793 Costume Institute 8 Bathrobe 6237 Bathrobe American or European 48         Department Store 208   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1920s 1920 1929 silk 15101   Gift of Lucinda S. Day, 1974                           http://www.metmuseum.org/art/collection/search/108793 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80777 80777 C.I.39.24a–c 0 1 109013 Costume Institute 8 Lingerie 5944 Lingerie American or European 48         Department Store 208   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1881 1881 1881 cotton 3340   Gift of Miss Gertrude M. Oppenheimer, 1939                           http://www.metmuseum.org/art/collection/search/109013 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80840 80840 C.I.43.113.1 0 1 109103 Costume Institute 8 Nightgown 6104 Nightgown American or European 48         Department Store 208   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1894 1894 1894 [no medium available] 15100   Gift of Mrs. William Rosenfeld, 1943                           http://www.metmuseum.org/art/collection/search/109103 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80841 80841 C.I.43.113.11 0 1 109104 Costume Institute 8 Corset Cover 6068 Corset cover American or European 48         Department Store 208   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1894 1894 1894 [no medium available] 15100   Gift of Mrs. William Rosenfeld, 1943                           http://www.metmuseum.org/art/collection/search/109104 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80842 80842 C.I.43.113.8 0 1 109109 Costume Institute 8 Drawers 5924 Drawers American or European 48         Department Store 208   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1894 1894 1894 [no medium available] 15100   Gift of Mrs. William Rosenfeld, 1943                           http://www.metmuseum.org/art/collection/search/109109 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
82669 82669 C.I.43.56.2 0 0 114008 Costume Institute 8 Hat 1056 Hat American or European 48         Designer 5   Sally Victor American, 1905–1977   Victor, Sally 5907 American 1 1905 1977 1943 1943 1943 straw 15331   Gift of Mrs. Sally Victor, 1943                           http://www.metmuseum.org/art/collection/search/114008 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83921 83921 C.I.50.14.14a–d 0 0 116752 Costume Institute 8 Tricorne 6042 Tricorne American or European 48         Department Store 208   Bergdorf Goodman American, founded 1899   Bergdorf Goodman 5548 American 1 1899 9999 1700–1950 1700 1950 straw 15331   Gift of Miss Isabel Shults, 1950                           http://www.metmuseum.org/art/collection/search/116752 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83925 83925 C.I.50.83a–c 0 0 116762 Costume Institute 8 Hat 1056 Hat American or European 48         Designer 5   Mr. John, Inc. American, 1948–1970   Mr. John 5487 American 1 1948 1970 1950 1950 1950 [no medium avaiable] 18204   Gift of Mr. John, Inc., 1950                           http://www.metmuseum.org/art/collection/search/116762 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
84596 84596 1976.390.54a–i 0 0 118652 Costume Institute 8 Evening collar 6525 Evening collar American or European 48         Designer 5   Brooks Brothers American, founded 1818   Brooks Brothers 5646 American 1 1818 2058 1900–1925 1900 1925 linen 15098   Gift of Irma A. Bloomingdale, 1976                           http://www.metmuseum.org/art/collection/search/118652 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
84597 84597 1976.390.55a–y 0 0 118653 Costume Institute 8 Evening collar 6525 Evening collar American or European 48         Designer 5   Brooks Brothers American, founded 1818   Brooks Brothers 5646 American 1 1818 2058 1900–1925 1900 1925 linen 15098   Gift of Irma A. Bloomingdale, 1976                           http://www.metmuseum.org/art/collection/search/118653 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86097 86097 C.I.44.4.2a, b 0 0 121490 Costume Institute 8 Stockings 1158 Stockings American or European 48         Designer 5   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1700–1944 1700 1944 silk 15101   Gift of Mrs. Seller, 1944                           http://www.metmuseum.org/art/collection/search/121490 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86322 86322 1979.40.3 0 0 121796 Costume Institute 8 Cravat 6549 Cravat American or European 48         Designer 5   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1974 1974 1974 silk 15101   Gift of Stephen de Pietri, 1979                           http://www.metmuseum.org/art/collection/search/121796 4/23/2018 8:00:01 AM 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 1199.031ms · Data license: CC0 · Data source: metmuseum/openaccess