MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Portfolio = 222

View and edit SQL

Suggested facets: 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
213960 1983.1216.34 0 0 341379 Drawings and Prints 11 Print 731 Title page to 'La Gerusalemme Liberata' by Torquato Tasso; Tasso's portrait in a cartouche at top flanked by putti two columns support a tablet with the text, below which a view of the port of Geona         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving and pen and ink 33033 Sheet: 9 3/8 × 6 5/16 in. (23.8 × 16 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213962 1983.1216.35 0 0 341381 Drawings and Prints 11 Print 731 Argantes and Tancred preparing for combat amidst soldiers on horses, with tents and a castle in the background from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet: 6 15/16 × 4 15/16 in. (17.7 × 12.5 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213963 1983.1216.36 0 0 341382 Drawings and Prints 11 Print 731 Erminia and a shepherd face each other at lower right with three putti behind, in the distance a woman looks down from a castle watching two soldiers fighting from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet (Trimmed): 7 1/16 in. × 5 in. (17.9 × 12.7 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213964 1983.1216.37 0 0 341383 Drawings and Prints 11 Print 731 Foraging party returning with the armour of Rinaldo; soldiers gather around and present the armour to a seated man in a tent, in the background soldiers, horses, tents outside a walled city from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet (Trimmed): 2 15/16 × 4 7/8 in. (7.4 × 12.4 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213965 1983.1216.38 0 0 341384 Drawings and Prints 11 Print 731 Soldiers gather around a seated Godfrey to recount their liberation from Armida by Rinaldo, to his left, Peter the Heremit tells the future deeds of Rinaldo from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13   Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet (Trimmed): 6 15/16 × 4 15/16 in. (17.6 × 12.5 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213967 1983.1216.39 0 0 341386 Drawings and Prints 11 Print 731 Clorinda dying in the arms of Tancred, two horses to their right and a battle scene behind from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet (Trimmed): 6 15/16 × 5 1/16 in. (17.6 × 12.9 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213968 1983.1216.40 0 0 341387 Drawings and Prints 11 Print 731 Rinaldo in the arms of Armida who holds up a mirror, behind them, a colloseum, in the foreground at lower right, two kneeling soldiers from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet (Trimmed): 6 7/8 × 4 13/16 in. (17.4 × 12.2 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213969 1983.1216.41 0 0 341388 Drawings and Prints 11 Print 731 An Egyptian Soudan seated atop a throne calls his generals to arms from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet (Trimmed): 6 3/4 × 4 13/16 in. (17.2 × 12.3 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213971 1983.1216.42 0 0 341390 Drawings and Prints 11 Print 731 Erminia nursing Tancred's wounds, two horses behind with a battle scene in the background from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13 After Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet: 6 7/8 × 4 7/8 in. (17.4 × 12.4 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       Prints 13   Metropolitan Museum of Art, New York, NY 1
213972 1983.1216.43 0 0 341391 Drawings and Prints 11 Print 731 A Saracen surrendering his sword to Godefrey, amidst a battle scene from 'La Gerusalemme Liberata' by Torquato Tasso         'La Gerusalemme Liberata' 222 Artist|Artist 13   Agostino Carracci|Bernardo Castello Italian, Bologna 1557–1602 Parma|Italian, Genoa (?) 1557–1629 Genoa   Carracci, Agostino|Castello, Bernardo 19941 Italian|Italian 93 1557 |1557 1602 |1629 1590 1590 1590 Engraving 7208 Sheet: 6 15/16 × 4 13/16 in. (17.6 × 12.3 cm) Bequest of Robert L. and Bertina Suida Manning, in memory of William E. Suida, 1983                       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 121.999ms · Data license: CC0 · Data source: metmuseum/openaccess