MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Role = 5045

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Nationality, Dimensions

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
394461 1994.220(3.8) 0 0 647440 Drawings and Prints 11 Print 731 Saint Andrew and an Bishop in Adoration before the Virgin and the Christ Child, bound in Monuments des Arts du Dessin, volume 3, plate 159           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Parmigianino (Girolamo Francesco Maria Mazzola)|Giuseppe Mazzuoli|Jules Dagneau|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|Italian, Parma 1503–1540 Casalmaggiore|Italian, Siena 1644–1725 Siena|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Parmigianino (Girolamo Francesco Maria Mazzola)|MAZZUOLI GIUSEPPE|Dagneau, Jules|Denon, Dominique Vivant Baron 50258 French|French|Italian|Italian|French 384 1760 |1700 |1503 |1644 |1747 1838 |1800 |1540 |1725 |1825 1829 1829 1829 Lithograph 14948 Sheet: 20 15/16 × 13 7/16 in. (53.2 × 34.2 cm) 20 7/8 x 14 3/16 x 1 15/16 in. (53 x 36 x 5 cm) Transferred from the Library, 1994                       Books 442   Metropolitan Museum of Art, New York, NY 1
394907 1994.220(3.31) 0 0 647935 Drawings and Prints 11 Print 731 First interview between Jacob and Rachel, bound in Monuments des Arts du Dessin, volume 3, plate 182           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Ludovico Carracci|Bartolommeo Ramenghi|Louis Hersent|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|Italian, Bologna 1555–1619 Bologna|Italian, 1484–1542|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Carracci, Ludovico|Ramenghi, Bartolommeo|Hersent, Louis|Denon, Dominique Vivant Baron 50326 French|French|Italian|Italian|French|French 1111 1760 |1700 |1555 |1484 |1747 1838 |1800 |1619 |1542 |1825 1829 1829 1829 Lithograph 14948 Sheet: 20 15/16 × 13 7/16 in. (53.2 × 34.2 cm) 20 7/8 x 14 3/16 x 1 15/16 in. (53 x 36 x 5 cm) Transferred from the Library, 1994                       Books 442   Metropolitan Museum of Art, New York, NY 1
394915 1994.220(3.34) 0 0 647943 Drawings and Prints 11 Print 731 Jesus Christ between two saints, bound in Monuments des Arts du Dessin, volume 3, plate 185           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Ludovico Carracci|Jules Dagneau|Giorgio Vasari|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|Italian, Bologna 1555–1619 Bologna|Italian, Arezzo 1511–1574 Florence|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Carracci, Ludovico|Dagneau, Jules|Vasari, Giorgio|Denon, Dominique Vivant Baron 50328 French|French|Italian|Italian|French 384 1760 |1700 |1555 |1511 |1747 1838 |1800 |1619 |1574 |1825 1829 1829 1829 Lithograph 14948 Sheet: 20 15/16 × 13 7/16 in. (53.2 × 34.2 cm) 20 7/8 x 14 3/16 x 1 15/16 in. (53 x 36 x 5 cm) Transferred from the Library, 1994                       Books 442   Metropolitan Museum of Art, New York, NY 1
395719 1994.220(3.81) 0 1 648818 Drawings and Prints 11 Print 731 Prometheus chained, two pendentives and an egyptian Saint Marie, bound in Monuments des Arts du Dessin, volume 3, plate 234           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Jules Dagneau|Jusepe de Ribera (called Lo Spagnoletto)|Alonso Cano|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|Spanish, Játiva 1591–1652 Naples|Spanish, Granada 1601–1667 Granada|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Dagneau, Jules|Ribera, Jusepe de (called Lo Spagnoletto)|Cano, Alonso|Denon, Dominique Vivant Baron 50432 French|French|Spanish|Spanish|French 3676 1760 |1700 |1591 |1601 |1747 1838 |1800 |1652 |1667 |1825 1829 1829 1829 Lithograph 14948 Sheet: 20 15/16 × 13 7/16 in. (53.2 × 34.2 cm) 20 7/8 x 14 3/16 x 1 15/16 in. (53 x 36 x 5 cm) Transferred from the Library, 1994                       Books 442   Metropolitan Museum of Art, New York, NY 1
396469 1994.220(4.22) 0 0 649971 Drawings and Prints 11 Book 97 A rustic interior and a young Tobias giving sight back to his father, bound in Monuments des Arts du Dessin, volume 4, plate 261           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Adriaen van Ostade|Rembrandt (Rembrandt van Rijn)|Guillaume Henri Franquinet|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|Dutch, Haarlem 1610–1685 Haarlem|Dutch, Leiden 1606–1669 Amsterdam|Flemish, 1785–1854|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Ostade, Adriaen van|Rembrandt (Rembrandt van Rijn)|Franquinet, Guillaume Henri|Denon, Dominique Vivant Baron 50517 French|French|Dutch|Dutch|Flemish|French 3687 1760 |1700 |1610 |1606 |1785 |1747 1838 |1800 |1685 |1669 |1854 |1825 1829 1829 1829 Lithograph 14948 Sheet: 21 in. × 13 1/2 in. (53.3 × 34.3 cm) 20 7/8 x 14 3/16 in. (53 x 36 cm) Transferred from the Library, 1994                       Books 442   Metropolitan Museum of Art, New York, NY 1
396482 1994.220(4.29) 0 0 649984 Drawings and Prints 11 Book 97 A Virgin seated on clouds and a man picking fleas off a dog, bound in Monuments des Arts du Dessin, volume 4, plate 268           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Louis Hersent|Gerard Dow|Dosso Dossi (Giovanni de Lutero)|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|Italian, Tramuschio ca. 1486–1541/42 Ferrara|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Hersent, Louis|Dow, Gerard|Dossi, Dosso (Giovanni de Lutero)|Denon, Dominique Vivant Baron 50524 French|French|French|Italian|French 332 1760 |1700 |1486 |1747 1838 |1800 |1542 |1825 1829 1829 1829 Lithograph 14948 Sheet: 21 in. × 13 1/2 in. (53.3 × 34.3 cm) 20 7/8 x 14 3/16 in. (53 x 36 cm) Transferred from the Library, 1994                       Books 442   Metropolitan Museum of Art, New York, NY 1
396576 1994.220(4.54) 0 0 650079 Drawings and Prints 11 Book 97 A portrait of Moliere and a scene from the comedy The Learned Ladies, bound in Monuments des Arts du Dessin, volume 4, plate 293           Author|Publisher|Artist|Artist|Artist|Editor 5045 Written by|Published by|After|After|Edited by Amaury Duval|Brunet|Sébastien Bourdon|Jules Dagneau|Noël Coypel|baron Dominique Vivant Denon French, 1760–1838|French, active 18th century|French, Montpellier 1616–1671 Paris|French, Paris 1628–1707 Paris|French, Givry 1747–1825 Paris , Paris Duval, Amaury|Brunet|Bourdon, Sébastien|Dagneau, Jules|Coypel, Noël|Denon, Dominique Vivant Baron 50546 French|French|French|French|French 106 1760 |1700 |1616 |1628 |1747 1838 |1800 |1671 |1707 |1825 1829 1829 1829 Lithograph 14948 Sheet: 21 in. × 13 1/2 in. (53.3 × 34.3 cm) 20 7/8 x 14 3/16 in. (53 x 36 cm) Transferred from the Library, 1994                       Books 442   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 126.617ms · Data license: CC0 · Data source: metmuseum/openaccess