MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Role = 1057

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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
206927 66.546.5 0 0 334271 Drawings and Prints 11 Album 1119 Eight Illustrations to Shakespeare's Tempest           Artist|Engraver|Subject 1057 Engraved and printed by Walter Crane|Dallastype Press|William Shakespeare British, Liverpool 1845–1915 Horsham|London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Crane, Walter|Dallastype Press|Shakespeare, William 17487 British|British 9 1845 |1850 |1564 1915 |1950 |1616 1893 1893 1893 Printed facsimiles of pen drawings 29191 Book: 14 15/16 x 11 15/16 x 1 1/8 in. (38 x 30.3 x 2.8cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966                       Albums|Prints 462   Metropolitan Museum of Art, New York, NY 1
400785 47.30.46 0 1 655600 Drawings and Prints 11 Print 731 A Midsummer Night's Dream (Shakespeare, Act 4, Scene 1)           Artist|Engraver|Subject 1057 After Sir Edwin Henry Landseer|Samuel Cousins|William Shakespeare British, London 1802–1873 London|British, Exeter 1801–1887 London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Landseer, Edwin Henry, Sir|Cousins, Samuel|Shakespeare, William 50938 British|British 9 1802 |1801 |1564 1873 |1887 |1616 November , 1857 1857 1857 Mixed method engraving with mezzotint, on chine collé; second state of three 58969 Plate: 25 11/16 × 37 5/16 in. (65.2 × 94.7 cm) Sheet: 28 7/16 × 38 7/16 in. (72.2 × 97.7 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   Metropolitan Museum of Art, New York, NY 1
412745 53.600.297 0 0 680699 Drawings and Prints 11 Print 731 A Scene in Cymbeline (Shakespeare, Act 3, Scene 4)           Artist|Engraver|Subject 1057 After|Engraved and published by Edward Penny|James Walker|William Shakespeare British, Knutsford, Cheshire 1714–1791 Chiswick|British, 1758/60–1822/25|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Penny, Edward|Walker, James|Shakespeare, William 52006 British|British 9 1714 |1758 |1564 1791 |1825 |1616 January 10, 1783 1783 1783 Mezzotint 29072 Sheet (trimmed to plate): 19 3/4 × 21 9/16 in. (50.1 × 54.8 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434632 17.3.1197 0 0 722568 Drawings and Prints 11 Print 731 The Muses Crowning a Bust of Pope           Artist|Engraver|Subject 1057 After Angelica Kauffmann|Peltro William Tomkins|Alexander Pope Swiss, Chur 1741–1807 Rome|British, London 1759–1840 London|1849–1924   Kauffmann, Angelica|Tomkins, Peltro William|Pope, Alexander 55315   1741 |1759 |1849 1807 |1840 |1924 1783 1783 1783 Stipple engraving, printed in dark brown ink 61521 Image (oval): 4 in. × 5 1/16 in. (10.2 × 12.9 cm) Plate: 6 1/16 × 7 1/2 in. (15.4 × 19.1 cm) Sheet: 7 1/8 × 8 3/4 in. (18.1 × 22.2 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442492 41.91.153 0 1 739715 Drawings and Prints 11 Print 731 Lady Macbeth, Macbeth and the Murder of Duncan (Shakespeare, Macbeth, Act II, Scene II)           Artist|Engraver|Subject 1057 After Henry Corbould|Charles Rolls|William Shakespeare British, London 1787–1844 Robertsbridge, East Sussex|British, 1800–1857|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Corbould, Henry|Rolls, Charles|Shakespeare, William 56476   1787 |1800 |1564 1844 |1857 |1616 1825–40 1825 1840 Etching and engraving 6712 Sheet: 3 7/16 × 2 9/16 in. (8.8 × 6.5 cm) Gift of Harriet McDonald, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442493 41.91.154 0 1 739716 Drawings and Prints 11 Print 731 A Lover's Complaint           Artist|Engraver|Subject 1057 After|Related poem once attributed to Henry Corbould|Frederick Bacon|William Shakespeare British, London 1787–1844 Robertsbridge, East Sussex|British, London 1803–1887 California|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Corbould, Henry|Bacon, Frederick|Shakespeare, William 56477   1787 |1803 |1564 1844 |1887 |1616 1825–40 1825 1840 Etching and engraving 6712 Sheet: 3 7/16 × 2 9/16 in. (8.8 × 6.5 cm) Gift of Harriet McDonald, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442497 41.91.158 0 1 739720 Drawings and Prints 11 Print 731 Cleopatra, Eros, Antony, Charmian and Iras (Shakespeare, Antony and Cleopatra, Act 3, Scene 9)           Artist|Engraver|Subject 1057 After Henry Corbould|Charles Rolls|William Shakespeare British, London 1787–1844 Robertsbridge, East Sussex|British, 1800–1857|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Corbould, Henry|Rolls, Charles|Shakespeare, William 56476   1787 |1800 |1564 1844 |1857 |1616 1825–40 1825 1840 Etching and engraving 6712 Sheet: 3 7/16 × 2 9/16 in. (8.8 × 6.5 cm) Gift of Harriet McDonald, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442504 41.91.165 0 1 739727 Drawings and Prints 11 Print 731 Suffolk and Margaret (Shakespeare, King Henry VI, Part I, Act 5, Scene 3)           Artist|Engraver|Subject 1057 After John Massey Wright|Charles Heath, the elder|William Shakespeare British, London 1777–1866|British, London 1785–1848 London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Wright, John Massey|Heath, Charles the elder|Shakespeare, William 56484   1777 |1785 |1564 1866 |1848 |1616 1825–40 1825 1840 Etching and engraving 6712 Sheet: 3 7/16 × 2 9/16 in. (8.8 × 6.5 cm) Gift of Harriet McDonald, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442507 41.91.168 0 1 739730 Drawings and Prints 11 Print 731 The Duke of Clarence Asleep in the Tower, as Brackenbury Leaves (Shakespeare, Richard III, Act 1, Scene 4)           Artist|Engraver|Subject 1057 After Henry Corbould|Charles Rolls|William Shakespeare British, London 1787–1844 Robertsbridge, East Sussex|British, 1800–1857|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Corbould, Henry|Rolls, Charles|Shakespeare, William 56476   1787 |1800 |1564 1844 |1857 |1616 1825–40 1825 1840 Etching and engraving 6712 Sheet: 3 7/16 × 2 9/16 in. (8.8 × 6.5 cm) Gift of Harriet McDonald, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442509 41.91.170 0 1 739732 Drawings and Prints 11 Print 731 Queen Margaret and Suffolk (Shakespeare, Henry VI, Part II, Act 3, Scene 2)           Artist|Engraver|Subject 1057 After John Massey Wright|Charles Heath, the elder|William Shakespeare British, London 1777–1866|British, London 1785–1848 London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Wright, John Massey|Heath, Charles the elder|Shakespeare, William 56484   1777 |1785 |1564 1866 |1848 |1616 1825–40 1825 1840 Etching and engraving 6712 Sheet: 3 7/16 × 2 9/16 in. (8.8 × 6.5 cm) Gift of Harriet McDonald, 1941                       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 124.477ms · Data license: CC0 · Data source: metmuseum/openaccess