MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Role = 2613

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Prefix, Artist Display Bio, Artist Nationality, Object Begin Date, Object End Date, Credit Line, Classification

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
223286 1991.1335.3 0 0 350862 Drawings and Prints 11 Print 731 The Fruits of Early Industry & Oeconomy           Engraver|Artist|Publisher|Publisher 2613 After William Ward|George Morland|Darling & Thompson|Thomas Simpson British, London 1766–1826 London|British, London 1763–1804 London|London|British, active London, ca. 1765–1801   Ward, William|Morland, George|Darling & Thompson|Simpson, Thomas 25343 British|British|British|British 177 1766 |1763 |1750 |1700 1826 |1804 |1800 |1850 March 25, 1794 1794 1794 Mezzotint, hand-colored 35216 Plate: 25 3/8 × 18 7/8 in. (64.5 × 48 cm) Sheet: 26 in. × 20 3/8 in. (66 × 51.7 cm) Gift of Dr. Bruce B. Grynbaum in Memory of his Parents Gertrude and Maurycy Grynbaum, 1991                       Prints 13   Metropolitan Museum of Art, New York, NY 1
223456 1978.551(1,2) 0 0 351034 Drawings and Prints 11 Book 97 Three Hundred French Portraits representing Personages of the Courts of Francis I, Henry II, and Frances II           Engraver|Artist|Publisher|Publisher 2613 After Lord Ronald Charles Sutherland Leveson Gower|François Clouet|Sampson Low, Marston, Low and Searle|Hachette et Cie. British, London 1845–1916 Kent (?)|French, Tours (?), active by 1536–died 1572 Paris|London|Paris   Gower, Ronald Charles Sutherland Leveson, Lord|Clouet, François|Low, Sampson, Marston, Low and Searle|Hachette et Cie. 25477 British|French|British|French 1747 1845 |1536 |1850 1916 |1572 |1950 1875 1875 1875     Harris Brisbane Dick Fund, 1978                       Books 442   Metropolitan Museum of Art, New York, NY 1
267259 32.35(188) 0 1 396300 Drawings and Prints 11 Print 731 Shrimps!           Engraver|Artist|Publisher|Publisher 2613 After|Published London by Francesco Bartolozzi|William Hogarth|Jane Hogarth|Richard Livesay Italian, Florence 1728–1815 Lisbon|British, London 1697–1764 London|British, 1709–1789|British, 1753–1823 Southsea   Bartolozzi, Francesco|Hogarth, William|Hogarth, Jane|Livesay, Richard 39447 Italian|British|British|British 1292 1728 |1697 |1709 |1753 1815 |1764 |1789 |1823 March 25, 1782 1782 1782 Stipple engraving 37370 sheet: 10 3/16 x 7 5/16 in. (25.8 x 18.5 cm) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
283111 49.40.182 0 0 412419 Drawings and Prints 11 Print 731 Yes!           Engraver|Artist|Publisher|Publisher 2613 After Samuel Cousins|Sir John Everett Millais|Thomas Agnew & Sons, Ltd.|Knoedler and Co. British, Exeter 1801–1887 London|British, Southampton 1829–1896 London|London , Washington DC Cousins, Samuel|Millais, John Everett, Sir|Agnew, Thomas & Sons, Ltd.|Knoedler and Co. 41132 British|British|French, British, American 3195 1801 |1829 |1846 1887 |1896 |1977 1878 1878 1878 Mixed method engraving; proof 43619 Image: 22 1/2 x 17 3/8 in. (57.1 x 44.1 cm) Plate: 27 3/4 × 22 in. (70.5 × 55.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949                       Prints 13   Metropolitan Museum of Art, New York, NY 1
283113 42.119.521 0 0 412421 Drawings and Prints 11 Print 731 Pomona           Engraver|Artist|Publisher|Publisher 2613 After Samuel Cousins|Sir John Everett Millais|The Fine Art Society, London|Arthur Tooth & Sons British, Exeter 1801–1887 London|British, Southampton 1829–1896 London|London   Cousins, Samuel|Millais, John Everett, Sir|Fine Art Society, London|Tooth, Arthur & Sons 41134 British|British|British|British 177 1801 |1829 |1850 |1850 1887 |1896 |2099 |1900 1882 1882 1882 Mixed method engraving 38289 Plate: 15 13/16 x 21 7/16 in. (40.2 x 54.5 cm) Gertrude and Thomas Jefferson Mumford Collection, Gift of Dorothy Quick Mayer, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
409416 62.602.201 0 0 670736 Drawings and Prints 11 Print 731 Astarte and Zadig, vide Voltaire's Book of Fate           Engraver|Artist|Publisher|Publisher 2613 After John Raphael Smith|Robert Home|John Raphael Smith|James Birchall British, baptized Derby 1751–1812 Doncaster|British, Hull 1752–1834 Cawnpore, India|British, baptized Derby 1751–1812 Doncaster|British, active 1781–94   Smith, John Raphael|Home, Robert|Smith, John Raphael|Birchall, James 51661 British|British|British|British 177 1751 |1752 |1751 |1781 1812 |1834 |1812 |1794 1782 1782 1782 Mezzotint; first state of two 36689 Sheet (trimmed within plate): 17 13/16 × 21 11/16 in. (45.2 × 55.1 cm) Rogers Fund, 1962                       Prints 13   Metropolitan Museum of Art, New York, NY 1
409430 14.1.26 0 0 670750 Drawings and Prints 11 Print 731 Girl and Boy Looking at Sheep (Girl and Boy Looking into a Shed)           Engraver|Artist|Publisher|Publisher 2613 After John Raphael Smith|George Morland|John Raphael Smith|Rudolph Ackermann, London British, baptized Derby 1751–1812 Doncaster|British, London 1763–1804 London|British, baptized Derby 1751–1812 Doncaster|active 1794–1829   Smith, John Raphael|Morland, George|Smith, John Raphael|Ackermann, Rudolph 51671 British|British|British|British 177 1751 |1763 |1751 |1764 1812 |1804 |1812 |1834 September 1, 1803 1803 1803 Mezzotint and aquatint, hand-colored 59435 Plate: 19 1/4 × 23 15/16 in. (48.9 × 60.8 cm) Sheet (trimmed on all sides, right corner cut off): 21 1/8 × 24 1/4 in. (53.7 × 61.6 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
409466 53.600.1846 0 0 670789 Drawings and Prints 11 Print 731 Rosamond and Queen Eleanor           Engraver|Artist|Publisher|Publisher 2613 After John Raphael Smith|Edward Penny|William Humphrey|John Raphael Smith British, baptized Derby 1751–1812 Doncaster|British, Knutsford, Cheshire 1714–1791 Chiswick|British, 1742?–before 1814|British, baptized Derby 1751–1812 Doncaster   Smith, John Raphael|Penny, Edward|Humphrey, William|Smith, John Raphael 51695 British|British|British|British 177 1751 |1714 |1740 |1751 1812 |1791 |1814 |1812 June 1, 1774 1774 1774 Mezzotint 29072 Sheet (trimmed within plate): 8 3/4 × 6 7/8 in. (22.3 × 17.5 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
409474 53.600.1837 0 0 670797 Drawings and Prints 11 Print 731 The Student           Engraver|Artist|Publisher|Publisher 2613 After John Raphael Smith|Sir Joshua Reynolds|John Raphael Smith|William Humphrey British, baptized Derby 1751–1812 Doncaster|British, Plympton 1723–1792 London|British, baptized Derby 1751–1812 Doncaster|British, 1742?–before 1814   Smith, John Raphael|Reynolds, Joshua, Sir|Smith, John Raphael|Humphrey, William 51700 British|British|British|British 177 1751 |1723 |1751 |1740 1812 |1792 |1812 |1814 October 1, 1777 1777 1777 Mezzotint; second state of four 41981 Sheet (trimmed to plate): 14 7/8 × 10 15/16 in. (37.8 × 27.8 cm) Harris Brisbane Dick Fund, 1953                       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 213.556ms · Data license: CC0 · Data source: metmuseum/openaccess