MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 4489

View and edit SQL

Suggested facets: Is Public Domain, Artist Prefix, Medium

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
259153 1986.1180.1368 0 1 387851 Drawings and Prints 11 Print 731 The bust of Plato, in a niche           Subject|Artist|Artist 4489 After Plato|Lucas Vorsterman I|Peter Paul Rubens Greek, ca. 427 B.C.E–347 B.C.E.|Flemish, Zaltbommel 1595–1675 Antwerp|Flemish, Siegen 1577–1640 Antwerp   Plato|Vosterman, Lucas I|Rubens, Peter Paul 37428 Flemish|Flemish 376 -0427 |1595 |1577 -0347 |1675 |1640 ca. 1620 1615 1625 Etching and engraving; only state 33351 Plate: 5 5/16 × 3 11/16 in. (13.5 × 9.4 cm) Sheet (Trimmed): 5 1/2 × 3 7/8 in. (14 × 9.9 cm) Bequest of Grace M. Pugh, 1985                       Prints 13   Metropolitan Museum of Art, New York, NY 1
287573 32.35(241) 0 1 416887 Drawings and Prints 11 Print 731 The Complicated R_____n           Subject|Artist|Artist 4489 Refers to|after|Probably etched by Jonathan Richardson Sr.|William Hogarth|Richard Livesay British, London 1667–1745 London|British, London 1697–1764 London|British, 1753–1823 Southsea   Richardson, Jonathan, Sr.|Hogarth, William|Livesay, Richard 41509 British|British|British 178 1667 |1697 |1753 1745 |1764 |1823 1794 (?) 1794 1794 Etching 26137 Sheet: 8 1/16 x 5 7/8 in. (20.4 x 14.9 cm) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
380641 53.600.686 0 0 627134 Drawings and Prints 11 Print 731 Bearded Man Wearing a Hat           Subject|Artist|Artist 4489 Associated with|After Thomas Jenkins|Guercino (Giovanni Francesco Barbieri)|Giovanni Ottaviani British, Sidbury (?), Devon 1722–1799 Yarmouth|Italian, Cento 1591–1666 Bologna|Italian, Rome 1735–ca. 1808   Jenkins, Thomas|Guercino (Giovanni Francesco Barbieri)|Ottaviani, Giovanni 48919 Italian|Italian 93 1722 |1591 |1735 1799 |1666 |1808 1764 1764 1764 Etching, printed in brown ink 32679 Sheet: 6 13/16 × 7 1/4 in. (17.3 × 18.4 cm) Mount: 9 5/16 × 10 1/2 in. (23.7 × 26.7 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
452333 62.600.343 0 0 760081 Drawings and Prints 11 Print 731 The coronation of Pope Pius VI (February 22, 1775)           Subject|Artist|Artist 4489 After Pope Pius VI|Giacomo Beys|Antonio Poggioli Italian, Cesena 1717–1799 Valence|Italian, active 1801–04|Italian, active Rome, 1796–1801   Pius VI Pope|Beys, Giacomo|Poggioli, Antonio 57651   1717 |1704 |1700 1799 |1804 |1801 1801 1801 1801 Engraving 7208 Plate: 14 11/16 × 19 in. (37.3 × 48.3 cm) Sheet: 15 9/16 × 19 1/2 in. (39.5 × 49.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1962                       Prints 13   Metropolitan Museum of Art, New York, NY 1
454235 69.651.6 0 0 764622 Drawings and Prints 11 Print 731 Portrait of Voltaire, seated at a desk at left and gesturing towards a priest standing at right with his arms folded           Subject|Artist|Artist 4489   François-Marie Arouet|Guiseppe Lante|Pietro Locatelli French, Paris 1694–1778 Paris|Italian, born Belluno, 1726|Italian, active 18th century   Arouet, François-Marie|Lante, Guiseppe|Locatelli, Pietro 57958   1694 |1726 |1700 1778 |1826 |1800 ca. 1746–62 1741 1767 Etching 26137 Plate: 19 5/16 × 12 1/2 in. (49.1 × 31.7 cm) Sheet: 22 13/16 × 17 5/16 in. (58 × 43.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969                       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 117.326ms · Data license: CC0 · Data source: metmuseum/openaccess