MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Artist Role = 13 and Medium = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, 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, Dimensions

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
11068 11068 50.130.154a 0 1 12077 American Paintings and Sculpture 2 Drawing 23 Night (from Scrapbook)           Artist|Artist 13 After John Singer Sargent|Michelangelo Buonarroti American, Florence 1856–1925 London|Italian, Caprese 1475–1564 Rome   Sargent, John Singer|Michelangelo Buonarroti 1744 American|Italian 49 1856 |1475 1925 |1564 ca. 1872–74 1872 1874 Graphite on off-white wove paper 37 7 1/4 x 3 7/8 in. (18.4 x 9.8 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12077 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11146 11146 50.130.154f 0 1 12155 American Paintings and Sculpture 2 Drawing 23 The Nurture of Bacchus (from Scrapbook)           Artist|Artist 13 After John Singer Sargent|Nicolas Poussin American, Florence 1856–1925 London|French, Les Andelys 1594–1665 Rome   Sargent, John Singer|Poussin, Nicolas 1745 American|French 26 1856 |1594 1925 |1665 1874–80 1874 1880 Graphite on off-white wove paper 37 3 13/16 x 5 7/8 in. (9.7 x 14.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12155 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11157 11157 50.130.154g 0 1 12166 American Paintings and Sculpture 2 Drawing 23 The Plague of Ashod (from Scrapbook)           Artist|Artist 13 After John Singer Sargent|Nicolas Poussin American, Florence 1856–1925 London|French, Les Andelys 1594–1665 Rome   Sargent, John Singer|Poussin, Nicolas 1745 American|French 26 1856 |1594 1925 |1665 ca. 1874–80 1874 1880 Graphite on off-white wove paper 37 9 x 11 5/8 in. (22.9 x 29.5 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12166 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11178 11178 50.130.143z 0 1 12187 American Paintings and Sculpture 2 Drawing 23 Night           Artist|Artist 13 After John Singer Sargent|Michelangelo Buonarroti American, Florence 1856–1925 London|Italian, Caprese 1475–1564 Rome   Sargent, John Singer|Michelangelo Buonarroti 1744 American|Italian 49 1856 |1475 1925 |1564 1870 1870 1870 Graphite on off-white wove paper 37 10 3/4 x 15 1/4 in. (27.3 x 38.7 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12187 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11187 11187 50.130.143p 0 1 12196 American Paintings and Sculpture 2 Drawing 23 Pieta, Detail           Artist|Artist 13 After John Singer Sargent|Guido Reni American, Florence 1856–1925 London|Italian, Bologna 1575–1642 Bologna   Sargent, John Singer|Reni, Guido 1748 American|Italian 49 1856 |1575 1925 |1642 ca. 1873 1873 1873 Graphite on off-white wove paper 37 9 5/16 x 6 in. (23.7 x 15.2 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12196 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11190 11190 50.130.143l 0 1 12199 American Paintings and Sculpture 2 Drawing 23 The Triumph of Flora           Artist|Artist 13 After John Singer Sargent|Nicolas Poussin American, Florence 1856–1925 London|French, Les Andelys 1594–1665 Rome   Sargent, John Singer|Poussin, Nicolas 1745 American|French 26 1856 |1594 1925 |1665 ca. 1874–78 1874 1878 Graphite on off-white wove paper 37 3 3/4 x 5 7/8 in. (9.5 x 14.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12199 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11192 11192 50.130.143s recto 0 1 12201 American Paintings and Sculpture 2 Drawing 23 The Marriage of Saint Catherine           Artist|Artist 13 After John Singer Sargent|Hans Memling American, Florence 1856–1925 London|Netherlandish, Seligenstadt, active by 1465–died 1494 Bruges   Sargent, John Singer|Memling, Hans 1749 American|Netherlandish 52 1856 |1465 1925 |1494 ca. 1880 1877 1880 Graphite on off-white wove paper 37 10 1/4 x 13 13/16 in. (26 x 35.1 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12201 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11194 11194 50.130.143y 0 1 12203 American Paintings and Sculpture 2 Drawing 23 Theodoric the Goth, Tomb of Maximilian I, Innsbruck           Artist|Artist 13 After John Singer Sargent|Peter Vischer the Elder American, Florence 1856–1925 London|German, Nuremberg ca. 1460–1529 Nuremberg   Sargent, John Singer|Vischer, Peter, the Elder 1750 American|German 53 1856 |1460 1925 |1529 June 1, 1869 1869 1869 Graphite on off-white wove paper 37 11 1/4 x 7 5/8 in. (28.6 x 19.4 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12203 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11195 11195 50.130.143g 0 1 12204 American Paintings and Sculpture 2 Drawing 23 Adoration of the Shepherds           Artist|Artist 13 After John Singer Sargent|Jacopo Tintoretto (Jacopo Robusti) American, Florence 1856–1925 London|Italian, Venice 1518/19–1594 Venice   Sargent, John Singer|Tintoretto, Jacopo (Jacopo Robusti) 1742 American|Italian 49 1856 |1518 1925 |1594 ca. 1874–78 1874 1878 Graphite on off-white wove paper 37 5 15/16 x 3 3/4 in. (15.1 x 9.5 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12204 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11196 11196 50.130.154e recto 0 1 12205 American Paintings and Sculpture 2 Drawing 23 The Miracle of Saint Mark, Detail (from Scrapbook)           Artist|Artist 13 After John Singer Sargent|Jacopo Tintoretto (Jacopo Robusti) American, Florence 1856–1925 London|Italian, Venice 1518/19–1594 Venice   Sargent, John Singer|Tintoretto, Jacopo (Jacopo Robusti) 1742 American|Italian 49 1856 |1518 1925 |1594 ca. 1873 1873 1873 Graphite on off-white wove paper 37 6 15/16 x 4 in. (17.6 x 10.2 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12205 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11270 11270 50.130.143d recto 0 1 12279 American Paintings and Sculpture 2 Drawing 23 Paradise, Detail           Artist|Artist 13 After Jacopo Tintoretto (Jacopo Robusti)|John Singer Sargent Italian, Venice 1518/19–1594 Venice|American, Florence 1856–1925 London   Tintoretto, Jacopo (Jacopo Robusti)|Sargent, John Singer 1752 Italian|American 54 1518 |1856 1594 |1925 1874–78 1874 1878 Graphite on off-white wove paper 37 3 1/2 x 5 7/8 in. (8.9 x 14.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12279 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
14239 14239 50.130.146gg 0 1 15411 American Paintings and Sculpture 2 Drawing 23 Dawn (from "Splendid Mountain Watercolours" Sketchbook)           Artist|Artist 13 After John Singer Sargent|Michelangelo Buonarroti American, Florence 1856–1925 London|Italian, Caprese 1475–1564 Rome   Sargent, John Singer|Michelangelo Buonarroti 1744 American|Italian 49 1856 |1475 1925 |1564 1870 1870 1870 Graphite on off-white wove paper 37 10 7/8 x 16 in. (27.6 x 40.6 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/15411 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
14319 14319 50.130.143d verso 0 1 15502 American Paintings and Sculpture 2 Drawing 23 Paradise, Detail           Artist|Artist 13 After John Singer Sargent|Jacopo Tintoretto (Jacopo Robusti) American, Florence 1856–1925 London|Italian, Venice 1518/19–1594 Venice   Sargent, John Singer|Tintoretto, Jacopo (Jacopo Robusti) 1742 American|Italian 49 1856 |1518 1925 |1594 ca. 1874–78 1874 1878 Graphite on off-white wove paper 37 3 1/2 x 5 7/8 in. (8.9 x 14.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/15502 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
14320 14320 50.130.143n recto 0 1 15503 American Paintings and Sculpture 2 Drawing 23 Modern Amoretten, Detail           Artist|Artist 13 After John Singer Sargent|Hans Makart American, Florence 1856–1925 London|Austrian, Salzburg 1840–1884 Vienna   Sargent, John Singer|Makart, Hans 2319 American|Austrian 64 1856 |1840 1925 |1884 ca. 1869–70 1869 1870 Graphite on off-white wove paper 37 12 1/8 x 4 3/8 in. (30.8 x 11.1 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/15503 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
15325 15325 50.130.154gg verso 0 1 16599 American Paintings and Sculpture 2 Drawing 23 Nurture of Bacchus, Detail (from Scrapbook)           Artist|Artist 13 After John Singer Sargent|Nicolas Poussin American, Florence 1856–1925 London|French, Les Andelys 1594–1665 Rome   Sargent, John Singer|Poussin, Nicolas 1745 American|French 26 1856 |1594 1925 |1665 ca. 1874–80 1874 1880 Graphite on off-white wove paper 37 3 13/16 x 5 13/16 in. (9.7 x 14.8 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/16599 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 162.329ms · Data license: CC0 · Data source: metmuseum/openaccess