MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Nationality = 959

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Object Date, 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
213358 2000.218 0 1 340754 Drawings and Prints 11 Drawing 23 Studies of Four Englishmen, after James Gillray           Artist|Sitter|Sitter|Sitter 997 Portrait of|Portrait of|Portrait of Eugène Delacroix|Charles James Fox|The Right Honorable Edmund Burke|Francis Rawdon Hastings, 1st Marquess of Hastings and 2nd Earl of Moira French, Charenton-Saint-Maurice 1798–1863 Paris|British, 1749–1806|British, born Ireland, Dublin 1729–1797 Beaconsfield|British, 1754–1826   Delacroix, Eugène|Fox, Charles James|Burke, Edmund The Right Honorable|Hastings, 1st Marquess of Hastings and 2nd Earl of Moira Francis Rawdon 19752 French|British|British|British 959 1798 |1749 |1729 |1754 1863 |1806 |1797 |1826 ca. 1817–25 1812 1830 Brush and brown ink on tracing paper, laid down 32819 sheet: 10 1/2 x 6 3/4 in. (26.7 x 17.1 cm) Gift of Eric G. Carlson, in honor of Karen B. Cohen, 2000                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
218428 66.656.1 0 0 345933 Drawings and Prints 11 Book 97 Examples of San Bernardino           Subject of book|Editor|Illustrator|Publisher 1809   Saint Bernard of Clairvaux|Ada Harrison|Robert Sargent Austin|Gerald Howe French, 1090/91–1153|British, active early 20th century|British, Leicester 1895–1973 Staithe, Norfolk|London   Bernard of Clairvaux, Saint|Harrison, Ada|Austin, Robert Sargent|Howe, Gerald 21831 French|British|British|British 959 1090 |1900 |1895 |1880 1153 |1950 |1973 |1950 1926 1926 1926 Illustrations: reproductions of drawings 29127 9 7/16 x 6 1/8 in. (24 x 15.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
223041 29.58.19-.24 0 0 350611 Drawings and Prints 11 Book Ornament and architecture 13817 Ornaments in the Modern French & Chinese Taste Consisting of Various designs for Mantles & Chimney Pieces           Designer|Publisher|Engraver|Engraver 2113   P. Glazier|John Bowles|J. Couse|Henry Roberts French, active London mid 18th century|British, 1701?–1779|British, active ca. 1750|British, before 1710–after 1790   Glazier, P.|Bowles, John|Couse, J.|Roberts, Henry 25150 French|British|British|British 959 1740 |1700 |1700 |1710 1780 |1766 |1800 |1790 1740–49 1740 1749 Illustrations: engraving, etching 34157 13 9/16 x 9 7/16 x 1/16 in. (34.5 x 24 x 0.2 cm) Harris Brisbane Dick Fund, 1929   London 14                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
227138 66.540.24 0 0 354753 Drawings and Prints 11 Book 97 The Luck of the Bean-Rows, A Fairy Tale Translated From the French           Author|Illustrator|Publisher|Printer 1121   Charles Nodier|Claud Lovat Fraser|Daniel O'Connor|The Westminster Press French, 1780–1844|British, London 1890–1921 Sandgate, Kent|London|London   Nodier, Charles|Fraser, Claud Lovat|O'Connor, Daniel|Westminster Press 28102 French|British|British|British 959 1780 |1890 |1890 |1900 1844 |1921 |1950 |1950 [1921] 1921 1921 Illustrations: pen lithography 35758 10 x 6 1/4 in. (25.4 x 15.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966                       Books 442   Metropolitan Museum of Art, New York, NY 1
231595 1977.595.58 0 0 359334 Drawings and Prints 11 Book ; Ornament and Architecture 13814 A Treatise of Architecture           Author|Engraver|Publisher|Translator 3672   Sébastien Leclerc I|John Sturt|Richard Ware|Ephraim Chambers French, Metz 1637–1714 Paris|British, London 1658–1730 London|London|British, Kendal, Westmorland ca. 1680–1740 Islington   Leclerc, Sébastien, I|Sturt, John|Ware, Richard|Chambers, Ephraim 30929 French|British|British|British 959 1637 |1658 |1700 |1680 1714 |1730 |1750 |1740 1732 1732 1732 Illustrations: etching and engraving 29021 8 1/16 × 5 × 1 5/16 in. (20.5 × 12.7 × 3.3 cm) Gift of Harvey Smith, 1977                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
234193 52.519.113(1) 0 0 361947 Drawings and Prints 11 Book ; Ornament and Architecture 13814 A Treatise on Architecture with Remarks and Observations.           Author|Publisher|Engraver|Translator 3785   Sébastien Leclerc I|Richard Ware|John Sturt|Ephraim Chambers French, Metz 1637–1714 Paris|London|British, London 1658–1730 London|British, Kendal, Westmorland ca. 1680–1740 Islington   Leclerc, Sébastien, I|Ware, Richard|Sturt, John|Chambers, Ephraim 31688 French|British|British|British 959 1637 |1700 |1658 |1680 1714 |1750 |1730 |1740 1732 1732 1732 Letterpress (no illustrations) 36071 8 × 5 1/16 × 11/16 in. (20.3 × 12.8 × 1.8 cm) Rogers Fund, 1952                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
259482 24.90.1212 0 0 388181 Drawings and Prints 11 Print 731 View of New York, Governors Island, the River etc. from Long Island           Artist|Artist|Publisher|Artist 1172 After|After|Published by|Engraved by Pierre Charles Canot|Captain Thomas Howdell, of the Royal Artillery|A. Hamilton, Jr.|Anonymous, British, 18th century French, Paris 1710–1777 Kentish Town, London (active England)|British, 18th century|London   Canot, Pierre Charles|Howdell, Thomas Captain|Hamilton, A. Jr.|Anonymous, British, 18th century 37489 French|British|British|British 959 1710 |1700 |1750 |1700 1777 |1800 |1800 |1800 November 1, 1776 1776 1776 Engraving 7208 sheet: 4 3/4 x 7 3/8 in. (12 x 18.7 cm) inlaid Bequest of Charles Allen Munn, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
270039 32.35(77) 0 1 399164 Drawings and Prints 11 Print 731 Gulliver Presented to the Queen of Babilary, Frontispiece to "The Travels of Mr. John Gulliver"           Author|Author|Artist|Engraver 4603 Illustrates|Illustrates|After Pierre Francois Guyot Desfontaine|John Lockman|William Hogarth|Gerard Vandergucht French, Rouen 1685–1745 Paris|British, 1698–1741 London|British, London 1697–1764 London|British, London 1696–1776 London   Desfontaine, Pierre Francois Guyot|Lockman, John|Hogarth, William|Vandergucht, Gerard 40079 French|British|British|British 959 1685 |1698 |1697 |1696 1745 |1741 |1764 |1776 February 1730 1730 1730 Etching and engraving 6712 sheet: 5 1/2 x 2 13/16 in. (13.9 x 7.1 cm) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
400035 59.600.257 0 1 654658 Drawings and Prints 11 Print 731 The Fallacy of Hope           Artist|Artist|Publisher|Sitter|Printer 5062 Attributed to|Attributed to Thomas Landseer|Count Alfred Guillaume Gabriel D'Orsay|Joseph Hogarth|Joseph Mallord William Turner|Hullmandel and Walton British, London 1795–1880 London|French, 1801–1852|London|British, London 1775–1851 London   Landseer, Thomas|D' Orsay, Alfred Guillaume Gabriel|Hogarth, Joseph|Turner, Joseph Mallord William|Hullmandel and Walton 50907 French|British|British|British 959 1795 |1801 |1800 |1775 |1789 1880 |1852 |1900 |1851 |1850 January 1, 1851 1851 1851 Lithograph on chine collé 31088 Chine: 12 7/8 × 8 13/16 in. (32.7 × 22.4 cm) Sheet: 21 13/16 × 14 15/16 in. (55.4 × 38 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
413435 42.74.2(4) 0 0 681969 Drawings and Prints 11 Book; Ornament and Architecture ; periodical 13876 The Repository of Arts, Literature, Commerce, Manufactures, Fashions, and Politics, 1st series, vol. 4           Artist|Artist|Publisher|Engraver 1328 After|After baron François Gérard|William-Samuel Howitt|Rudolph Ackermann, London|Anthony Cardon French, Rome 1770–1837 Paris|British, ca. 1756/57–1822/23 London|active 1794–1829|British, Brussels 1772–1813 London   Gérard, François, baron|Howitt, William-Samuel|Ackermann, Rudolph|Cardon, Anthony 52089 French|British|British|British 959 1770 |1756 |1764 |1772 1837 |1823 |1834 |1813 July–December 1810 1810 1810 Illustrations: Hand-colored etching, engraving, stipple, woodcut and textile samples 59722 9 7/16 in. × 6 in. × 1 3/4 in. (24 × 15.3 × 4.5 cm) Harris Brisbane Dick Fund, 1942                       Books|Ornament & Architecture|Periodicals 696   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 146.704ms · Data license: CC0 · Data source: metmuseum/openaccess