MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 2567

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Prefix, 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
222958 1980.1104.1–.2 0 0 350528 Drawings and Prints 11 Book 97 The Genuine Works of James Gillray, Engraved by Himself. In Two Volumes.           Engraver|Publisher|Artist|Sitter 2567 Frontispiece mezzotint by|Frontispiece portrait of James Gillray|Thomas McLean|Charles Turner|James Gillray British, Chelsea 1756–1815 London|British, active London 1788-1885|British, Woodstock, Oxfordshire 1774–1857 London|British, Chelsea 1756–1815 London   Gillray, James|McLean, Thomas|Turner, Charles|Gillray, James 25094 British|British|British|British 177 1756 |1800 |1774 |1756 1815 |1899 |1857 |1815 [1830] 1830 1830 Illustrations: etching, aquatint, and engraving 35157 23 5/16 x 17 1/2 x 1 7/16 in. (59.2 x 44.5 x 3.7 cm) Gift of Paul F. Walter, 1980   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
303038 24.90.695 0 0 432876 Drawings and Prints 11 Print 731 Benjamin West, Esq-r., Historical Painter to His Majesty           Engraver|Publisher|Artist|Sitter 2567 After Caroline Watson|John & Josiah Boydell|Gilbert Stuart|Benjamin West British, London 1760/61–1814 London|British, 1786–1804|American, North Kingston, Rhode Island 1755–1828 Boston, Massachusetts|American, Swarthmore, Pennsylvania 1738–1820 London   Watson, Caroline|Boydell, John & Josiah|Stuart, Gilbert|West, Benjamin 43178 British 7 1760 |1786 |1755 |1738 1814 |1804 |1828 |1820 1786 1786 1786 Stipple engraving 37370 Plate: 8 9/16 × 6 1/4 in. (21.8 × 15.8 cm) Sheet: 13 7/16 × 10 3/8 in. (34.2 × 26.4 cm) Gift of Charles Allen Munn, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
426592 17.3.756-2421 0 1 708351 Drawings and Prints 11 Print 731 William Shakespeare         Wivell's Inquiry into the History of the Shakespeare Portraits 2799 Engraver|Publisher|Artist|Sitter 2567 After Charles Picart|Abraham Wivell I|Martin Droeshout the Younger|William Shakespeare British, active ca. 1780–1837|British, London 1786–1849 Birmingham|British, 1601–after 1639|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Picart, Charles|Wivell, Abraham I|Droeshout, Martin the Younger|Shakespeare, William 54456   1750 |1786 |1601 |1564 1850 |1849 |1650 |1616 1827 1827 1827 Etching and engraving on chine collé 42750 Chine collé: 10 1/16 × 6 7/8 in. (25.6 × 17.5 cm) Plate: 10 1/4 × 7 1/16 in. (26.1 × 17.9 cm) Sheet: 11 13/16 × 8 5/8 in. (30 × 21.9 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
433980 26.72.223(1) 0 0 720669 Drawings and Prints 11 Print Album book 27120 Portrait of John Crome         Norfolk Picturesque Scenery, Consisting of Thirty-One Etchings by the Late John Crome, founder of the Norwich Society of Artists, and Printed from the Plates as Left by Himself 2812 Engraver|Publisher|Artist|Sitter 2567 After Robert William Sievier|J. and W. Freeman|D. R. Murphy|John Crome British, London 1794–1865 London|British, 19th century|British, active 19th century|British, Norwich 1768–1821 Norwich   Sievier, Robert William|J. and W. Freeman|Murphy, D. R.|Crome, John 55280   1794 |1800 |1800 |1768 1865 |1900 |1900 |1821 1821 1821 1821 Stipple engraving on chine collé 60972 Plate: 12 13/16 × 9 9/16 in. (32.5 × 24.3 cm) Sheet: 19 1/2 × 13 9/16 in. (49.5 × 34.5 cm) Harris Brisbane Dick Fund, 1926                       Prints|Albums|Books 1124   Metropolitan Museum of Art, New York, NY 1
448849 67.630.103 0 0 751560 Drawings and Prints 11 Print 731 Queen Charlotte Raising the Genius of the Fine Arts           Engraver|Publisher|Artist|Sitter 2567 After Thomas Burke|William Wynne Ryland|Angelica Kauffmann|Charlotte, Queen of England Irish, Dublin 1749–1815 London|British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome|1744–1818   Burke, Thomas|Ryland, William Wynne|Kauffmann, Angelica|Charlotte, Queen 57376   1749 |1732 |1741 |1744 1815 |1783 |1807 |1818 1772 1772 1772 Mezzotint 29072 Sheet (trimmed close to image): 17 1/2 in. × 15 in. (44.5 × 38.1 cm) Bequest of Susan Dwight Bliss, 1966                       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 486.977ms · Data license: CC0 · Data source: metmuseum/openaccess