MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

18 rows where Artist Nationality = 1 and Department = 10

View and edit SQL

Suggested facets: 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, Dimensions, Credit Line, Country, Classification

Artist Nationality

  • American · 18
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
190584 69.270.1 0 0 309634 Arts of Africa, Oceania, and the Americas 10 Drawing 23 "Man Skiing with Dogs" Inuit 1991         Artist 2   George A. Ahgupach American, 1911–2001   Ahgupach, George A. 16946 American 1 1911 2001 ca. 1930 1920 1940 Parchment, ink, blood serum, carbon 26699 H x W: 4 15/16 x 6 15/16 in. (12.6 x 17.7 cm) Gift of Mrs. Robert E. Rose, 1969       Alaska 386 United States 3             Paper-Drawings 515   Metropolitan Museum of Art, New York, NY 1
200076 2012.531.1 0 0 320940 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Nyakandaiy Julie Kapeku with a chiwimba, Zambia           Artist 2   Phyllis Galembo American, born 1952   Galembo, Phyllis 17272 American 1 1952 2052 2007 2007 2007 Chromogenic Print 28376 H. 20 x W. 20 in. (50.8 x 50.8 cm) Gift of the artist, 2012         Zambia 184             Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
200077 2012.531.2 0 0 320941 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Chief Nosa Isekhure, the isekhure of Benin, Benin City, Nigeria           Artist 2   Phyllis Galembo American, born 1952   Galembo, Phyllis 17272 American 1 1952 2052 1994 1994 1994 Chromogenic Print 28376 H. 20 x W. 20 in. (50.8 x 50.8 cm) Gift of the artist, 2012         Nigeria 83             Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
200078 2012.531.3 0 0 320942 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Oba Oladokun Oyewusi, the time of Ede, Osun State, Nigeria           Artist|Artist 13   Phyllis Galembo|Steven Kasher Gallery American, born 1952   Galembo, Phyllis|Kasher Gallery, Steven 17273 American 1 1952 2052 1994 1994 1994 Chromogenic Print 28376 H. 20 x W. 20 in. (50.8 x 50.8 cm) Gift of the artist, 2012         Nigeria 83             Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
200079 2012.531.4 0 0 320943 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Priest of Oluorogbo, Ife, Nigeria           Artist 2   Phyllis Galembo American, born 1952   Galembo, Phyllis 17272 American 1 1952 2052 1989 1989 1989 Chromogenic Print 28376 H. 20 x W. 20 in. (50.8 x 50.8 cm) Gift of the artist, 2012         Nigeria 83             Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
200080 2012.531.5 0 0 320944 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Nana Saforo Okoampah, Koforidua, Ghana           Artist 2   Phyllis Galembo American, born 1952   Galembo, Phyllis 17272 American 1 1952 2052 2010 2010 2010 Chromogenic Print 28376 H. 20 x W. 20 in. (50.8 x 50.8 cm) Gift of the artist, 2012         Ghana 89             Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
200081 2012.531.6 0 0 320945 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Okao Aiwerioghene, Benin City, Nigeria           Artist 2   Phyllis Galembo American, born 1952   Galembo, Phyllis 17272 American 1 1952 2052 1991 1991 1991 Chromogenic Print 28376 H. 20 x W. 20 in. (50.8 x 50.8 cm) Gift of the artist, 2012         Nigeria 83             Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
200150 Armory-Museums-01 0 0 321081 Arts of Africa, Oceania, and the Americas 10   Untitled [Filipino, Easter Island, Indonesian, and Congolese sculptures in front of an unidentied painting by Morton Schamberg(?)]           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 ca. 1917 1912 1922 Gelatin silver print 14941 H. x W.: 9 7/15 x 7 5/8 in. (24 x 19.3 cm) Framed: 15 3/4 x 11 15/16 in. (40 x 30.4 cm) The Lane Collection, Museum of Fine Arts, Boston                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200151 Armory-1915-10 0 0 321082 Arts of Africa, Oceania, and the Americas 10   African Negro Wood Sculpture Portfolio           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 1918 1918 1918 Portfolio of 20 photographs 28392 Closed: H. x W.: 16 3/16 x 13 5/16 in. (41.12 x 33.81 cm) Open: H. x W.: 16 3/16 x 25 11/16 in. (41.12 x 65.25 cm) James J. Ross, New York                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200152 Armory-1915-11 0 0 321083 Arts of Africa, Oceania, and the Americas 10   [John Quinn Album of African Art]           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 1919 1919 1919 Portfolio of 27 photographs 28393 Open: H. x W.: 16 5/16 x 26 x 2 in. (41.5 x 66 x 5.1 cm) The Lane Collection, Museum of Fine Arts, Boston                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200154 Armory-1915-01 0 0 321085 Arts of Africa, Oceania, and the Americas 10   Marius de Zayas           Artist 2   Alfred Stieglitz American, Hoboken, New Jersey 1864–1946 New York   Stieglitz, Alfred 13735 American 1 1864 1946 1915 1915 1915 Platinum print 26063 Sheet: H. x W.: 12 1/8 x 7 3/4 in. (30.8 x 19.69 cm) Framed: H. x W. x D.: 23 x 17 x 1-1/2 in. Image courtesy of the Board of Trustees, National Gallery of Art, Washington, D.C., Alfred Stieglitz Collection.                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200155 Armory-1914-11 0 0 321086 Arts of Africa, Oceania, and the Americas 10   Georgia O'Keeffe           Artist 2   Alfred Stieglitz American, Hoboken, New Jersey 1864–1946 New York   Stieglitz, Alfred 13735 American 1 1864 1946 1918–1919 1918 1919 Palladium print 26088 Framed: H. x W.: 24 x 18 x 1 in. (60.96 x 45.72 x 2.54 cm) Sheet size: H. x W.: 9 1/2 x 7 5/8 in. (24.13 x 19.37 cm) Actual image size: H. x W.: 4 7/16 x 3 1/2 in. (11.27 x 8.89 cm) Collection John and Lisa Pritzker                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200169 Armory-Blondiau-05 0 0 321146 Arts of Africa, Oceania, and the Americas 10 Painting 69 Negro Masks           Artist 2   Malvin Gray Johnson 1896–1934   Johnson, Malvin Gray 17287 American 1 1896 1934 1932 1932 1932 Oil on canvas 953 H. x W.: 20 x 18 in. (50.8 x 45.72 cm) With frame: 21 1/4 x 19 3/8 Collection of the Hampton University Museum, Hampton, Virginia                       (not assigned) 210   Metropolitan Museum of Art, New York, NY 1
200170 Armory-Museums-03 0 0 321147 Arts of Africa, Oceania, and the Americas 10   Installation view of Whitney Studio Club exhibition "Recent Paintings by Pablo Picasso and Negro Sculpture"           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 1923 1923 1923 Gelatin silver print 14941 Sheet and image: 7 1/2 x 9 3/8 in. (19.1 x 23.8 cm) Framed: 14 15/16 x 12 in. (37.94 x 30.48 cm) Whitney Museum of American Art, New York, Gift of Gertrude Vanderbilt Whitney                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200171 Armory-Museums-04 0 0 321148 Arts of Africa, Oceania, and the Americas 10   Installation view of Whitney Studio Club exhibition "Recent Paintings by Pablo Picasso and Negro Sculpture"           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 1923 1923 1923 Gelatin silver print 14941 Sheet and Image: H. x W.: 7 3/8 x 9 3/16 in. (18.7 x 23.3 cm) Mount: 14 7/8 x 12 in. (37.8 x 30.5 cm) Whitney Museum of American Art, New York, Gift of Gertrude Vanderbilt Whitney                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200172 Armory-Museums-05 0 0 321149 Arts of Africa, Oceania, and the Americas 10   Installation view of Whitney Studio Club exhibition "Recent Paintings by Pablo Picasso and Negro Sculpture"           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 1923 1923 1923 Gelatin silver print 14941 Sheet and Image: H. x W.: 7 3/8 x 9 3/16 in. (18.7 x 23.3 cm) Whitney Museum of American Art, New York, Gift of Gertrude Vanderbilt Whitney                       Paper 341   Metropolitan Museum of Art, New York, NY 1
200207 Armory-Whitney-Arensberg 0 0 321316 Arts of Africa, Oceania, and the Americas 10   Interior of Arensberg apartment, 33 West Sixty-Seventh Street, New York           Artist 2   Charles Sheeler American, Philadelphia, Pennsylvania 1883–1965 Dobbs Ferry, New York   Sheeler, Charles 13894 American 1 1883 1965 1919 1919 1919 Casein silver print 28411 Framed: H. x W.: 14 x 18 in. (35.56 x 45.72 cm) Whitney Museum of American Art                       Paper-Photographs 581   Metropolitan Museum of Art, New York, NY 1
399258 SL.7.2015.37.1a, b 0 0 653667 Arts of Africa, Oceania, and the Americas 10 Mixed media 13068 Gifts for Trading Land with White People Confederated Salish and Kootenai Nation 6910         Artist 2   Jaune Quick-to-See Smith American, born St. Ignatius, Montana, 1940   Smith, Jaune Quick-to-See 47436 American 1 1940 2040 1992 1992 1992 Oil and mixed media 58853 Length: 14 ft. 2 in. (431.8 cm) Width: 60 in. (152.4 cm) Chrysler Museum of Art, Norfolk, Virginia (93.2)       Montana 502 United States 3             Miscellaneous|Paintings 1058   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 1785.662ms · Data license: CC0 · Data source: metmuseum/openaccess