MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 4235

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Prefix, Artist Display Bio, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, 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
248322 59.500.583(34) 0 0 376624 Drawings and Prints 11 Print 731 Time, St. John the Evangelist and Astolfo, from Orlando Furioso           Artist|Publisher|Artist|Author 4235 Published by|After|Written by Francesco Bartolozzi|G. Baskerville|Giovanni Battista Cipriani|Ludovico Ariosto Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|Italian, Reggio Emilia 1474–1533 Ferrara   Bartolozzi, Francesco|Baskerville, G.|Cipriani, Giovanni Battista|Ariosto, Ludovico 35205 Italian|British|Italian|Italian 2806 1728 |1750 |1727 |1474 1815 |1800 |1785 |1533 1773 1773 1773 Stipple engraving and etching; third state 39705 sheet: 9 3/16 x 5 13/16 in. (23.3 x 14.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
270244 32.35(74) 0 1 399370 Drawings and Prints 11 Print 731 The Beggar's Opera           Artist|Publisher|Artist|Author 4235 Design formerly attributed to|Illustrates William Hogarth|John Bowles|Anonymous, British, 18th century|John Gay British, London 1697–1764 London|British, 1701?–1779|British, Barnstaple, Devon 1685–1732   Hogarth, William|Bowles, John|Anonymous, British, 18th century|Gay, John 40140 British|British|British|British 177 1697 |1700 |1700 |1685 1764 |1766 |1800 |1732 1728 1728 1728 Etching and engraving; sixth state of six 43138 sheet: 9 13/16 x 10 13/16 in. (25 x 27.4 cm) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281620 2009.523.2 0 0 410917 Drawings and Prints 11 Album 1119 D'Après Nature, volume 2         D'Après Nature 1444 Artist|Publisher|Artist|Author 4235   Paul Gavarni [Chevalier]|Morizot|Pegard|Paul de Saint-Victor French, Paris 1804–1866 Paris|French   Gavarni, Paul|Morizot|Pegard|Saint-Victor, Paul de 41054 French|French|French|French 95 1804 1866 19th century 1815 1866 Volume 2 of an album with 40 lithographs; second state of two (Armelhault & Bocher), 4 volumes; wood engravings on cover pages of each volume 43587 Overall: 15 3/4 x 11 1/4 x 1/4 in. (40 x 28.5 x 0.6 cm) Gift of David P. Tunick, in honor of Colta Ives, 2009                       Albums 441   Metropolitan Museum of Art, New York, NY 1
281621 2009.523.3 0 0 410918 Drawings and Prints 11 Album 1119 D'Après Nature, volume 3         D'Après Nature 1444 Artist|Publisher|Artist|Author 4235   Paul Gavarni [Chevalier]|Morizot|Pegard|Edmond Texier French, Paris 1804–1866 Paris|French   Gavarni, Paul|Morizot|Pegard|Texier, Edmond 41055 French|French|French 103 1804 1866 19th century 1815 1866 Volume 3 of an album with 40 lithographs; second state of two (Armelhault & Bocher), 4 volumes; wood engravings on cover pages of each volume 43588 Overall: 15 3/4 x 11 5/16 x 1/4 in. (40 x 28.7 x 0.6 cm) Gift of David P. Tunick, in honor of Colta Ives, 2009                       Albums 441   Metropolitan Museum of Art, New York, NY 1
421824 51.501.6158(1) 0 1 698737 Drawings and Prints 11 Print, Ornament & Architecture, Fete 14014 Plate 3: The Marriage of Henry IV and Marie de Medici, from Caspar Barlaeus, "Medicea Hospes"           Artist|Publisher|Artist|Author 4235 After Claes Moeyaert|Joan and Cornelius Blaeu|Pieter Nolpe|Caspar Barlaeus Dutch, Amsterdam 1591–1655 Amsterdam|Dutch, 1613/1614–1652/1653|Dutch   Moeyaert, Claes|Blaeu, Joan and Cornelius|Nolpe|Barlaeus, Caspar 53715   1591 |1613 1655 |1614 1638 1638 1638 Etching 26137 Sheet (Trimmed): 11 15/16 × 15 3/8 in. (30.3 × 39 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints|Ornament & Architecture|Prints-Fete 752   Metropolitan Museum of Art, New York, NY 1
421996 51.501.5159 0 1 699764 Drawings and Prints 11 Print, Ornament & Architecture, Fete 14014 City magistrates taking leave of Marie de Medici before the town hall, from Caspar Barlaeus, "Medicea Hospes"           Artist|Publisher|Artist|Author 4235 After Jan Martszen de Jong|Joan and Cornelius Blaeu|Salomon Savery|Caspar Barlaeus Dutch, Haarlem 1609–1647 Haarlem|Dutch, 1594–1678|Dutch   Martszen de Jong, Jan|Blaeu, Joan and Cornelius|Savery, Salomon|Barlaeus, Caspar 53779   1609 |1594 1647 |1678 1638 1638 1638 Etching 26137 Sheet: 11 9/16 × 15 1/4 in. (29.4 × 38.8 cm) Plate: 11 1/8 × 15 1/16 in. (28.3 × 38.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints|Ornament & Architecture|Prints-Fete 752   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 318.801ms · Data license: CC0 · Data source: metmuseum/openaccess