MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

18 rows where Artist Alpha Sort = 15654

View and edit SQL

Suggested facets: Is Highlight, Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification, Rights and Reproduction

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
178940 1998.311.1 1 0 282515 Photographs 13 Photograph 997 [Waterfront Scene with Collaged Elements: Reclining Woman, Self-Portrait]           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1932–35 1932 1935 Gelatin silver print 14941 8.7 x 11.7 cm (3 7/16 x 4 5/8 in.) Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 1998                       Photographs 21 © Estate of David Smith / Licensed by VAGA, New York, NY Metropolitan Museum of Art, New York, NY 1
181624 1998.311.2 0 0 285288 Photographs 13 Negative 13046 [Waterfront Scene with Reclining Woman, Self-Portrait]           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1932–35 1932 1935 Film negative 26279 Image: 8.8 x 12.1 cm (3 7/16 x 4 3/4 in.) Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 1998                       Negatives 451 © Estate of David Smith / Licensed by VAGA, New York, NY Metropolitan Museum of Art, New York, NY 1
232561 1987.1021 0 0 360312 Drawings and Prints 11 Print 731 A Letter           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1952 1952 1952 Lithograph 14948   The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1987                       Prints 13   Metropolitan Museum of Art, New York, NY 1
257261 1986.1091 0 0 385943 Drawings and Prints 11 Block 262 Woodblock for Untitled (Pace 12)           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1940 1940 1940 Maple, formerly a kitchen cutting board 41518 block: 22 7/8 x 23 x 1 in. (58.1 x 58.4 x 2.5 cm) Gift of Dorothy Dehner, 1986                       Blocks 674   Metropolitan Museum of Art, New York, NY 1
333792 1972.127 1 0 480986 Modern and Contemporary Art 4 Sculpture 100 Becca           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1965 1965 1965 Stainless steel 14439 113 3/4 x 123 x 30 1/2 in. (312.4 x 77.5 cm) Bequest of Miss Adelaide Milton de Groot (1876-1967), by exchange, 1972                       Sculpture 12 Art © Estate of David Smith/Licensed by VAGA, New York, NY Metropolitan Museum of Art, New York, NY 1
334377 1978.410 0 0 481788 Modern and Contemporary Art 4 Drawing 23 Study for "Becca"           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1965 1965 1965 Black egg ink on paper and collage 51026 9 1/4 × 11 3/4 in. (23.5 × 29.8 cm) Purchase, Roy R. and Mary S. Neuberger Foundation Inc. Gift and Anonymous Gift, 1978                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
334450 1978.567.3 0 0 481865 Modern and Contemporary Art 4 Drawing 23 DS 32-12-57           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1957 1957 1957 Brush and egg ink on paper 51034 17 x 22 in. (43.2 x 55.9 cm) Anonymous Gift, 1978                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
335259 1983.438 0 0 482730 Modern and Contemporary Art 4 Painting 69 Seashell and Map           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1933 1933 1933 Oil on canvas 953 26 x 36 in. (66 x 91.4 cm) Purchase, Lila Acheson Wallace Gift, 1983                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
338772 1994.367 0 0 486402 Modern and Contemporary Art 4 Drawing 23 7 DS-3-17-63           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1963 1963 1963 Spray and stencilled enamel on paper 52173 16 3/8 x 11 3/4 in. (41.6 x 29.8 cm) Purchase, Arthur Hoppock Hearn Fund, by exchange, 1994                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
338773 1994.368 0 0 486403 Modern and Contemporary Art 4 Drawing 23 Study for Sculpture, Number 2           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1950 1950 1950 Brush and egg ink on paper 51034 20 x 26 in. (50.8 x 66 cm) Purchase, George A. Hearn Fund, by exchange, 1994                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
338774 1994.369a, b 0 0 486404 Modern and Contemporary Art 4 Drawing 23 Untitled (Aug. 23, 1951)           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1951 1951 1951 Tempera, brush and egg ink, and graphite on paper 52174 H. 17, W. 22 inches (43.2 x 55.9 cm.) Arthur Hoppock Hearn Fund, 1994                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
338781 1994.399 0 0 486411 Modern and Contemporary Art 4 Drawing 23 DS 1958           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1958 1958 1958 Spray and stencilled enamel on paper 52173 17 1/2 x 11 1/2 in. (44.5 x 29.2 cm) Gift of Candida and Rebecca Smith, 1994                       Drawings 9 Art © Estate of David Smith/Licensed by VAGA, New York, NY Metropolitan Museum of Art, New York, NY 1
338782 1994.400 0 0 486412 Modern and Contemporary Art 4 Drawing 23 DS 2/29/53           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1953 1953 1953 Ink on paper 760 30 x 42 1/2in. (76.2 x 108cm) Gift of Candida and Rebecca Smith, 1994                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
338783 1994.401 0 0 486413 Modern and Contemporary Art 4 Drawing 23 Untitled           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1953 1953 1953 Brush and egg ink on paper 51034 18 x 24in. (45.7 x 61cm) Gift of Candida and Rebecca Smith, 1994                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
340838 53.93 0 0 488759 Modern and Contemporary Art 4 Sculpture 100 Tanktotem II           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1952–53 1952 1953 Steel and bronze 52645 80 1/2 x 49 1/2 x 18 1/2in. (204.5 x 125.7 x 47cm) Fletcher Fund, 1953                       Sculpture 12 © Estate of David Smith/ VAGA, New York, NY Metropolitan Museum of Art, New York, NY 1
341990 2006.32.58 0 0 490223 Modern and Contemporary Art 4 Sculpture 100 Song of the Landscape           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1950 1950 1950 Iron and bronze, on wood base 52876 19 × 32 × 19 1/2 in. (48.3 × 81.3 × 49.5 cm) The Muriel Kallis Steinberg Newman Collection, Gift of Muriel Kallis Newman, 2006                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
343744 2003.38 0 0 492814 Modern and Contemporary Art 4 Drawing 23 Study for Banquet           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1950 1950 1950 Ink and gouache on paper 26311 12 1/2 x 18 7/8 in. (31.8 x 47.9 cm) Estate of Emily Genauer Gash, 2002                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
344050 2004.157.4 0 0 493605 Modern and Contemporary Art 4 Drawing 23 Untitled           Artist 2   David Smith American, Decatur, Indiana 1906–1965 Bennington, Vermont   Smith, David 15654 American 1 1906 1965 1953 1953 1953 Ink on paper 760 15 3/4 x 20 1/4 in. (40 x 51.4 cm) Bequest of Virginia C. Field, 2003                       Drawings 9   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 134.155ms · Data license: CC0 · Data source: metmuseum/openaccess