MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Artist Role = 895 and Artist Suffix = ", London"

View and edit SQL

Suggested facets: Is Public Domain, Artist Prefix, 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
237336 17.3.756–1726 0 0 365318 Drawings and Prints 11 Print 731 Lord Byron, as he appeared after his daily ride at Pisa and Genoa           Artist|Artist|Publisher 895 After|Published by Mrs. Leigh Hunt|Samuel Freeman|Henry Colburn British, 19th century|British, 1773/74–1857 London|British, died 1855 London , London Hunt, Leigh Mrs.|Freeman, Samuel|Colburn, Henry 32463 British|British|British 178 0019 |1773 |1755 0019 |1857 |1855 1828 1828 1828 Etching 26137 sheet: 9 15/16 x 8 1/8 in. (25.2 x 20.7 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248304 17.3.454 0 0 376606 Drawings and Prints 11 Print 731 The Whole Offspring of James and Mary Woodmason           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Charles Reuben Ryley|Robert Wilkinson Italian, Florence 1728–1815 Lisbon|British, London ca. 1752–1798 London|British, active 1760–1825 , London Bartolozzi, Francesco|Ryley, Charles Reuben|Wilkinson, Robert 35196 Italian|British|British 1105 1728 |1747 |1760 1815 |1798 |1825 January 1, 1798 1798 1798 Etching and engraving; second state of five 39698 image: 5 7/8 x 4 9/16 in. (15 x 11.6 cm) sheet: 11 5/16 x 8 11/16 in. (28.7 x 22.1 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248607 17.3.2963 0 0 376915 Drawings and Prints 11 Print 731 Three Graces Crowning a Bust of Raphael           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|Simon Watts Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|British, active London 1767–87 , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Watts, Simon 35297 Italian|Italian|British 1966 1728 |1727 |1767 1815 |1785 |1787 July 28, 1788 1788 1788 Etching and stipple engraving 37022 plate: 6 1/8 x 7 1/2 in. (15.5 x 19 cm) sheet: 6 15/16 x 8 7/16 in. (17.6 x 21.5 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248810 17.3.528 0 0 377221 Drawings and Prints 11 Print 731 The Madonna Weeping           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Carlo Dolci|John Boydell Italian, Florence 1728–1815 Lisbon|Italian, Florence 1616–1687 Florence|British, Shropshire 1720–1804 London , London Bartolozzi, Francesco|Dolci, Carlo|Boydell, John 35356 Italian|Italian|British 1966 1728 |1616 |1720 1815 |1687 |1804 1769 1769 1769 Etching and engraving; first state of two 32458 Sheet: 9 1/16 in. × 6 in. (23 × 15.3 cm) Plate: 6 1/2 × 4 5/8 in. (16.6 × 11.7 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248820 17.3.394 0 0 377231 Drawings and Prints 11 Print 731 Acis and Galathea           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|Francesco Bartolozzi Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|Italian, Florence 1728–1815 Lisbon , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Bartolozzi, Francesco 35364 Italian|Italian|Italian 145 1728 |1727 |1728 1815 |1785 |1815 March 1, 1787 1787 1787 Etching and engraving, printed in color; third state of three 39803 Plate: 8 15/16 × 12 11/16 in. (22.7 × 32.2 cm) Sheet: 9 11/16 × 13 3/8 in. (24.6 × 34 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248824 37.17.40 0 0 377235 Drawings and Prints 11 Print 731 Minerva and Mercury           Artist|Artist|Publisher 895 After|Published by Domenico Marchetti|Giovanni Battista Cipriani|Francesco Bartolozzi Italian, Rome ca. 1780–after 1844 Rome|Italian, Florence 1727–1785 Hammersmith (active London)|Italian, Florence 1728–1815 Lisbon , London Marchetti, Domenico|Cipriani, Giovanni Battista|Bartolozzi, Francesco 35368 Italian|Italian|Italian 145 1780 |1727 |1728 1844 |1785 |1815 March 1, 1787 1787 1787 Etching and aquatint, printed in brown ink; second state 39805 Sheet: 12 1/2 × 16 3/4 in. (31.8 × 42.5 cm) Plate: 10 1/4 × 10 5/8 in. (26 × 27 cm) Gift of Edward W. Root, Elihu Root Jr. and Mrs. Ulysses S. Grant III, 1937                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248826 17.3.449 0 0 377237 Drawings and Prints 11 Print 731 Three Nymphs Bathing           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|Francesco Bartolozzi Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|Italian, Florence 1728–1815 Lisbon , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Bartolozzi, Francesco 35364 Italian|Italian|Italian 145 1728 |1727 |1728 1815 |1785 |1815 March 1, 1787 1787 1787 Etching and engraving, printed in brown ink; second state of two 39807 Plate: 10 15/16 × 7 7/8 in. (27.8 × 20 cm) Sheet: 11 3/4 × 8 7/8 in. (29.8 × 22.5 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248836 17.3.453 0 0 377247 Drawings and Prints 11 Print 731 History           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|William Dickinson Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|British, 1746–1823 , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Dickinson, William 35373 Italian|Italian|British 1966 1728 |1727 |1746 1815 |1785 |1823 November 20, 1786 1786 1786 Etching and stipple engraving 37022 Sheet: 7 7/8 × 10 3/16 in. (20 × 25.9 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248841 17.3.3498 0 0 377252 Drawings and Prints 11 Print 731 Vigilance           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|Susannah Vivares Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|British, active 1781–1797 , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Vivares, Susannah 35329 Italian|Italian|British 1966 1728 |1727 |1781 1815 |1785 |1797 December 24, 1782 1782 1782 Etching and stipple engraving, printed in color; second state 39797 Sheet: 6 7/8 × 4 9/16 in. (17.5 × 11.6 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248845 48.187.753 0 0 377256 Drawings and Prints 11 Print 731 Venus Bathing           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|William Dickinson Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|British, 1746–1823 , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Dickinson, William 35373 Italian|Italian|British 1966 1728 |1727 |1746 1815 |1785 |1823 March 1, 1800 1800 1800 Etching and stipple engraving, printed in color; sixth state 39813 Plate: 14 × 10 3/8 in. (35.5 × 26.3 cm) Sheet: 14 11/16 × 11 1/8 in. (37.3 × 28.2 cm) Bequest of Catherine D. Wentworth, 1948                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248850 33.3.2 0 0 377261 Drawings and Prints 11 Print 731 Maternal Love           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|William Byrne Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|British, 1743–1805 , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Byrne, William 35380 Italian|Italian|British 1966 1728 |1727 |1743 1815 |1785 |1805 1784 1784 1784 Etching and stipple engraving 37022 Sheet: 5 13/16 × 7 1/16 in. (14.8 × 17.9 cm) (oval) Gift of Fräulein Sofie Krick, 1933                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259857 49.125.15 0 0 388574 Drawings and Prints 11 Print 731 The Battle of Bunker Hill (June 17, 1775)           Artist|Artist|Publisher 895 After|Published by John Trumbull|Johann Gotthard Muller|Antonio Cesare Poggi American, Lebanon, Connecticut 1756–1843 New York|German, Bernausen 1747–1830 Stuttgart|Italian, active London and Paris, 1769–?1836 , London Trumbull, John|Muller, Johann Gotthard|Poggi, Antonio Cesare 37589 American|German|Italian 2998 1756 |1747 |1769 1843 |1830 |1769 ca. 1798 1793 1803 Engraving; first state 30349 sheet: 23 3/8 x 34 5/8 in. (59.4 x 87.9 cm) Gift of Joseph Verner Reed, 1949                       Prints 13   Metropolitan Museum of Art, New York, NY 1
260021 59.533.36(a) 0 1 388738 Drawings and Prints 11 Print 731 A Sketch from Nature           Artist|Artist|Publisher 895 After Thomas Rowlandson|William Paulet Carey|John Raphael Smith British, London 1757–1827 London|Irish, Dublin 1759–1839 Birmingham|British, baptized Derby 1751–1812 Doncaster , London Rowlandson, Thomas|Carey, William Paulet|Smith, John Raphael 37642 British|British|British 178 1757 |1759 |1751 1827 |1839 |1812 January 24, 1784 1784 1784 Hand-colored etching and stipple, printed in brown ink 41924 Sheet: 12 1/8 in. × 16 in. (30.8 × 40.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
263900 59.533.1787 0 0 392846 Drawings and Prints 11 Print 731 An Italian Family           Artist|Artist|Publisher 895 After|Published by Thomas Rowlandson|Samuel Alken|Samuel Alken British, London 1757–1827 London|British, London 1756–1815|British, London 1756–1815 , London Rowlandson, Thomas|Alken, Samuel|Alken, Samuel 38472 British|British|British 178 1757 |1756 |1756 1827 |1815 |1815 December 1785 1785 1785 Hand-colored etching and aquatint 32179 Sheet: 14 3/8 x 18 1/4 in. (36.5 x 46.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
264386 47.41.3 0 0 393344 Drawings and Prints 11 Print 731 Portraits of Their Majesty's and the Royal Family Viewing the Exhibition of the Royal Academy 1788           Artist|Artist|Publisher 895 After|Published by Pietro Antonio Martini|Johann Heinrich Ramberg|Antonio Cesare Poggi Italian, Trescali 1738–1797 Parma|German, Hanover 1763–1840 Hanover|Italian, active London and Paris, 1769–?1836 , London Martini, Pietro Antonio|Ramberg, Johann Heinrich|Poggi, Antonio Cesare 38609 Italian|German|Italian 1541 1738 |1763 |1769 1797 |1840 |1769 March 6, 1789 1789 1789 Etching 26137 sheet: 15 1/2 x 20 1/2 in. (39.4 x 52.1 cm) Bequest of Mrs. Robert B. Noyes, 1947                       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 1491.215ms · Data license: CC0 · Data source: metmuseum/openaccess