MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Role = 1741

View and edit SQL

Suggested facets: Object Name, 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
218039 66.543.7 0 0 345540 Drawings and Prints 11 Book 97 Drunken Barnaby's Four Journeys to the North of England           Artist|Author|Printer|Publisher 1741   J. W. Harding|Richard Brathwaite|Savage and Easingwood|John Harding British, active late 18th–early 19th century|British, 1588–1673|London|London   Harding, J. W.|Brathwaite, Richard|Savage and Easingwood|Harding, John 21596 British|British|British|British 177 1780 |1588 |1750 |1800 1810 |1673 |1850 |1900 1805 1805 1805 Illustrations: etching 28943 8 x 5 in. (20.3 x 12.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
220593 40.33 0 0 348128 Drawings and Prints 11 Book 97 Cathechismus. That is to say a shorte instruction into Christian Religion           Artist|Author|Printer|Publisher 1741   Hans Holbein the Younger|Thomas Cranmer|Nicholas Hyll|Gwalter Lynne German, Augsburg 1497/98–1543 London|British, 1489–1556|London|London   Holbein, Hans, the Younger|Cranmer, Thomas|Hyll, Nicholas|Lynne, Gwalter 23367 German|British|British 785 1497 |1489 |1500 |1500 1543 |1556 |1600 |1600 1548 1548 1548 Illustrations: woodcut 33876 6 x 3 3/4 x 1 3/8 in. (15.2 x 9.6 x 3.5 cm) Harris Brisbane Dick Fund, 1940   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
226374 48.2 0 0 353984 Drawings and Prints 11 Book 97 (Rudolf Meyer's Todten-dants. Ergäntzet und herausgegeben von C. Meyern, Malern in Zürich, im Jahre 1650) Sterbensspiegel, das ist sonnenklare Vorstellung menschlicher Nichtigkeit durch alle Ständ' und Geschlechter           Artist|Author|Printer|Publisher 1741   Conrad Meyer|Rudolf Meyer|Johann Jacob Bodmer|Conrad Meyer Swiss, Zürich 1618–1689 Zürich|Swiss, Zurich 1605–1638 Zurich|Swiss|Swiss, Zürich 1618–1689 Zürich   Meyer, Conrad|Meyer, Rudolf|Bodmer, Johann Jacob|Meyer, Conrad 27621 Swiss|Swiss|Swiss|Swiss 998 1618 |1605 |1618 1689 |1638 |1689 1650 1650 1650 Etchings 28944 Overall: 7 3/4 x 6 5/16 x 11/16 in. (19.7 x 16 x 1.8 cm) Harris Brisbane Dick Fund, 1948                       Books 442   Metropolitan Museum of Art, New York, NY 1
245424 67.797.3 0 0 373638 Drawings and Prints 11 Print 731 Satan Viewing the Ascent to Heaven (Paradise Lost of Milton, Book 3, line 501)           Artist|Author|Printer|Publisher 1741   John Martin|John Milton|Chatfield & Company|Septimus Prowett British, Haydon Bridge, Northumberland 1789–1854 Douglas, Isle of Man|British, London 1608–1674 London|London|London   Martin, John|Milton, John|Chatfield & Company|Prowett, Septimus 34503 British|British|British|American 881 1789 |1608 |1820 |1800 1854 |1674 |1830 |1850 1825 1825 1825 Mezzotint with touches of drypoint; proof 39437 Plate: 14 x 10 1/8 in. (35.6 x 25.7 cm) Sheet: 21 5/16 x 15 1/8 in. (54.2 x 38.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Prints 13   Metropolitan Museum of Art, New York, NY 1
301115 2013.195 0 0 430894 Drawings and Prints 11 Book 97 Día Mambí           Artist|Author|Printer|Publisher 1741   Rolando Estévez Jordán|Sergio Garcia Zamora|Ediciones Vígía|Ediciones Vígía Cuban, born Matanzas, 1953|Cuban, born Esperanza, 1986   Jordán, Rolando Estévez|Zamora, Sergio Garcia|Ediciones Vígía|Ediciones Vígía 42978 Cuban|Cuban 3334 1953 |1986 9999 2011 2011 2011 Mimeograph with hand-coloring and collage 44284 Figure: 16 5/16 × 10 1/4 in. (41.5 × 26 cm) Text (unfolded): 45 11/16 × 5 3/16 in. (116 × 13.2 cm) Gift of Nadine M. Orenstein, 2013                       Books 442   Metropolitan Museum of Art, New York, NY 1
406990 2014.667 0 0 664667 Drawings and Prints 11 Book Print 13897 ABC: A Nonsense Alphabet in Pictures           Artist|Author|Printer|Publisher 1741   Conrad Felixmüller|Londa Felixmüller|Zielinski|F. Emil Boden German, Dresden 1897–1977 Berlin|German|Dresden   Felixmüller, Conrad|Felixmüller, Londa|Zielinski|F. Emil Boden 51342 German|German 79 1897 1977 1925 1925 1925 Woodcut title page printed in red and blue and fifteen hand-colored woodcuts 59246 Sheet: 11 × 13 3/4 in. (28 × 35 cm) Purchase, Joseph F. McCrindle, Max G. Wildnauer and Mary Oenslager Funds, 2014                       Books|Prints 448 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
429755 34.39 0 0 713155 Drawings and Prints 11 Print Book Book 27092 Copy as published of 'Picture Book' with 32 lithographic illustrations by Jean Charlot and text by Paul Claudel (John Becker, New York 1933)           Artist|Author|Printer|Publisher 1741   Jean Charlot|Paul Claudel|Kistler (Lynton R. and/or Will A.)|John Becker French, Paris 1898–1979 Honolulu, Hawaii|French, 1868–1955|American, active 1922–75|American, New York   Charlot, Jean|Claudel, Paul|Kistler|Becker, John 54833   1898 |1868 |1922 1979 |1955 |1975 1933 1933 1933 Colour lithographs on zinc 61154 Overall: 11 7/16 × 8 3/4 × 13/16 in. (29 × 22.3 × 2 cm) The Harris Brisbane Dick Fund, 1933                       Prints 13 © 2018 Artists Rights Society (ARS), New York 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 132.523ms · Data license: CC0 · Data source: metmuseum/openaccess