MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Prefix = "Workshop of" and Medium = 953

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, 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
305943 305943 43.23 0 1 435861 European Paintings 15 Painting 69 Saint Catherine of Alexandria           Artist 2 Workshop of Bernardo Cavallino Italian, Naples 1616–1656 Naples   Cavallino, Bernardo 36189 Italian 6 1616 1656   1636 1654 Oil on canvas 953 50 1/4 x 40 1/4 in. (127.6 x 102.2 cm) Rogers Fund, 1943                       Paintings 11   http://www.metmuseum.org/art/collection/search/435861 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306284 306284 95.21 0 1 436238 European Paintings 15 Painting 69 Benjamin Franklin (1706–1790)           Artist 2 Workshop of Joseph Siffred Duplessis French, Carpentras 1725–1802 Versailles   Duplessis, Joseph Siffred 190 French 2 1725 1802   1745 1802 Oil on canvas 953 Oval, 27 5/8 x 22 1/4 in. (70.2 x 56.5 cm) Gift of George A. Lucas, 1895                       Paintings 11   http://www.metmuseum.org/art/collection/search/436238 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306562 306562 61.101.8 0 1 436577 European Paintings 15 Painting 69 Saint Andrew           Artist 2 Workshop of El Greco Spanish, ca. 1610   Greco El 43590 Greek 237 1540 1614 ca. 1610 1605 1615 Oil on canvas 953 43 1/4 x 25 1/4 in. (109.9 x 64.1 cm) Bequest of Stephen C. Clark, 1960                       Paintings 11   http://www.metmuseum.org/art/collection/search/436577 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306809 306809 39.65.9 0 1 436874 European Paintings 15 Painting 69 Barbara Villiers (1640–1709), Duchess of Cleveland           Artist 2 Workshop of Sir Peter Lely British, after 1670   Lely, Peter, Sir 43674 Dutch, British 2132 1618 1680   1670 1727 Oil on canvas 953 89 x 54 in. (226.1 x 137.2 cm) Bequest of Jacob Ruppert, 1939                       Paintings 11   http://www.metmuseum.org/art/collection/search/436874 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307341 307341 06.1241 0 1 437454 European Paintings 15 Painting 69 Mrs. George Baldwin (Jane Maltass, 1763–1839)           Artist 2 Workshop of Sir Joshua Reynolds British, Plympton 1723–1792 London   Reynolds, Joshua, Sir 19829 British 7 1723 1792 1782 or later 1782 1792 Oil on canvas 953 36 1/8 x 29 1/8 in. (91.8 x 74 cm) Gift of William T. Blodgett and his sister Eleanor Blodgett, in memory of their father, William T. Blodgett, one of the founders of the Museum, 1906                       Paintings 11   http://www.metmuseum.org/art/collection/search/437454 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307644 307644 32.100.85 0 1 437830 European Paintings 15 Painting 69 Doge Andrea Gritti (1455–1538)           Artist 2 Workshop of Titian Italian, Pieve di Cadore ca. 1485/90?–1576 Venice   Titian 43908 Italian 6 1485 1576   1508 1576 Oil on canvas 953 40 1/4 x 31 3/4 in. (102.2 x 80.6 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Paintings 11   http://www.metmuseum.org/art/collection/search/437830 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307686 307686 89.15.18 0 1 437872 European Paintings 15 Painting 69 Mariana of Austria (1634–1696), Queen of Spain           Artist 2 Workshop of Velázquez Spanish, Seville 1599–1660 Madrid   Velázquez 43925 Spanish 76 1599 1660   1619 1660 Oil on canvas 953 32 1/4 x 39 1/2 in. (81.9 x 100.3 cm) Marquand Collection, Gift of Henry G. Marquand, 1889                       Paintings 11   http://www.metmuseum.org/art/collection/search/437872 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307689 307689 89.15.29 0 1 437875 European Paintings 15 Painting 69 Portrait of a Man           Artist 2 Workshop of Velázquez Spanish, Seville 1599–1660 Madrid   Velázquez 43925 Spanish 76 1599 1660 ca. 1650 1645 1655 Oil on canvas 953 27 1/4 x 22 1/4 in. (69.2 x 56.5 cm) Marquand Collection, Gift of Henry G. Marquand, 1889                       Paintings 11   http://www.metmuseum.org/art/collection/search/437875 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307772 307772 65.220.2 0 1 437972 European Paintings 15 Painting 69 The Crucifixion           Artist 2 Workshop of Francisco de Zurbarán Spanish, Fuente de Cantos 1598–1664 Madrid   Zurbarán, Francisco de 43951 Spanish 76 1598 1664   1618 1664 Oil on canvas 953 Arched top, 112 x 75 7/8 in. (284.5 x 192.7 cm) Gift of George R. Hann, 1965                       Paintings 11   http://www.metmuseum.org/art/collection/search/437972 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 1091.213ms · Data license: CC0 · Data source: metmuseum/openaccess