MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 3953

View and edit SQL

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, 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 Repository
239975 49.40.282 0 1 368061 Drawings and Prints 11 Print 731 Ophelia (Shakespeare, Hamlet, Act 4, Scene 7)           Artist|Engraver|Publisher|Subject 3953 After Sir John Everett Millais|James Stephenson|Henry Graves & Company|William Shakespeare British, Southampton 1829–1896 London|British, Manchester 1808–1886 London|London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Millais, John Everett, Sir|Stephenson, James|Graves, Henry & Company|Shakespeare, William 33233 British|British|British 178 1829 |1808 |1820 |1564 1896 |1886 |1899 |1616 March 1, 1866 1866 1866 Mezzotint, etching and stipple on chine collé; proof 38288 Image: 20 11/16 in. × 34 in. (52.5 × 86.3 cm) Plate: 25 7/16 × 37 1/16 in. (64.6 × 94.2 cm) Sheet: 27 3/8 x 39 3/16 in. (69.5 x 99.5 cm) Chine collé: 24 5/16 × 35 13/16 in. (61.7 × 90.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949                       Prints 13   Metropolitan Museum of Art, New York, NY 1
245415 69.582.5 0 1 373629 Drawings and Prints 11 Print 731 Macbeth           Artist|Engraver|Publisher|Subject 3953 After John Martin|Thomas Goff Lupton|Walter Benjamin Tiffin|William Shakespeare British, Haydon Bridge, Northumberland 1789–1854 Douglas, Isle of Man|British, London 1791–1873 London|British, 1795–1877|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Martin, John|Lupton, Thomas Goff|Tiffin, Walter Benjamin|Shakespeare, William 34495 British|British|British 178 1789 |1791 |1795 |1564 1854 |1873 |1877 |1616 1828 1828 1828 Mezzotint 29072 Image: 9 7/8 x 13 15/16 in. (25.1 x 35.4 cm) Plate: 12 3/4 x 16 in. (32.4 x 40.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1
245425 67.797.42 0 1 373639 Drawings and Prints 11 Print 731 Macbeth           Artist|Engraver|Publisher|Subject 3953 After John Martin|Thomas Goff Lupton|Walter Benjamin Tiffin|William Shakespeare British, Haydon Bridge, Northumberland 1789–1854 Douglas, Isle of Man|British, London 1791–1873 London|British, 1795–1877|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Martin, John|Lupton, Thomas Goff|Tiffin, Walter Benjamin|Shakespeare, William 34495 British|British|British 178 1789 |1791 |1795 |1564 1854 |1873 |1877 |1616 1828 1828 1828 Mezzotint; proof before letters 39438 Image: 9 7/8 x 13 15/16 in. (25.1 x 35.4 cm) Sheet: 12 5/8 x 15 7/8 in. (32.1 x 40.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1
266664 59.570.361 0 1 395662 Drawings and Prints 11 Print 731 The Weird Sisters (Shakespeare, MacBeth, Act 1, Scene 3)           Artist|Engraver|Publisher|Subject 3953 After Henry Fuseli|John Raphael Smith|John Raphael Smith|William Shakespeare Swiss, Zürich 1741–1825 London|British, baptized Derby 1751–1812 Doncaster|British, baptized Derby 1751–1812 Doncaster|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Fuseli, Henry|Smith, John Raphael|Smith, John Raphael|Shakespeare, William 39311 Swiss|British|British 754 1741 |1751 |1751 |1564 1825 |1812 |1812 |1616 March 10, 1785 1785 1785 Mezzotint 29072 sheet: 18 1/16 x 21 7/8 in. (45.8 x 55.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1
271203 24.63.1208 0 1 400337 Drawings and Prints 11 Print 731 Florizel and Perdita–"The Winter's Tale"         Art Journal 1738 Artist|Engraver|Publisher|Subject 3953 After Charles Robert Leslie|Lumb Stocks|Virtue & Co., Ltd.|William Shakespeare British, London 1794–1859 London|British, Lightcliffe, Yorkshire 1812–1892 London|London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Leslie, Charles Robert|Stocks, Lumb|Virtue & Co., Ltd.|Shakespeare, William 40293 British|British|British 178 1794 |1812 |1875 |1564 1859 |1892 |1910 |1616 January 1867 1867 1867 Etching and engraving 6712 sheet (trimmed to plate): 9 3/4 x 13 1/16 in. (24.8 x 33.2 cm) Gift of Georgiana W. Sargent, in memory of John Osborne Sargent, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
426185 42.119.547 0 1 707778 Drawings and Prints 11 Print 731 Picking of the Red and White Roses (Shakespeare, King Henry the Sixth, Part 1, Act 2, Scene 4)         Boydell's Shakespeare Gallery 204 Artist|Engraver|Publisher|Subject 3953 After Josiah Boydell|John Ogborne|John & Josiah Boydell|William Shakespeare British, Hawarden, Flintshire 1752–1817 Middlesex|British, Chelmsford, Essex 1755–1837 London|British, 1786–1804|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Boydell, Josiah|Ogborne, John|Boydell, John & Josiah|Shakespeare, William 54369   1752 |1755 |1786 |1564 1817 |1837 |1804 |1616 1795 1795 1795 Stipple engraving 37370 Plate: 19 9/16 × 25 in. (49.7 × 63.5 cm) Sheet: 21 7/8 × 27 15/16 in. (55.5 × 71 cm) Gertrude and Thomas Jefferson Mumford Collection, Gift of Dorothy Quick Mayer, 1942                       Prints 13   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 119.377ms · Data license: CC0 · Data source: metmuseum/openaccess