MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Is Highlight = 1 and Medium = 156

View and edit SQL

Suggested facets: Department, Object Name, Artist Nationality, Object Date, Object Begin Date, Object End Date, Credit Line

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
10756 59.166 1 1 11737 American Paintings and Sculpture 2 Painting 69 Still Life with Cake           Artist 2   Raphaelle Peale 1774–1825   Peale, Raphaelle 1666   1774 1825 1818 1818 1818 Oil on wood 156 10 3/4 x 15 1/4 in. (27.3 x 38.7 cm) Maria DeWitt Jesup Fund, 1959                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
305751 08.183.1 1 1 435641 European Paintings 15 Painting 69 Madonna and Child           Artist 2   Giovanni Bellini Italian, Venice, active by 1459–died 1516 Venice   Bellini, Giovanni 43405 Italian 6 1459 1516 late 1480s 1487 1489 Oil on wood 156 35 x 28 in. (88.9 x 71.1 cm) Rogers Fund, 1908                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
305785 26.90 1 1 435683 European Paintings 15 Painting 69 Island of the Dead           Artist 2   Arnold Böcklin Swiss, Basel 1827–1901 San Domenico, Italy   Böcklin, Arnold 43424 Swiss 61 1827 1901 1880 1880 1880 Oil on wood 156 29 x 48 in. (73.7 x 121.9 cm) Reisinger Fund, 1926                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
305892 29.100.16 1 1 435802 European Paintings 15 Painting 69 Portrait of a Young Man           Artist 2   Bronzino (Agnolo di Cosimo di Mariano) Italian, Monticelli 1503–1572 Florence   Bronzino (Agnolo di Cosimo di Mariano) 21312 Italian 6 1503 1572 1530s 1530 1539 Oil on wood 156 37 5/8 x 29 1/2 in. (95.6 x 74.9 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
305899 19.164 1 1 435809 European Paintings 15 Painting 69 The Harvesters           Artist 2   Pieter Bruegel the Elder Netherlandish, Breda (?) ca. 1525–1569 Brussels   Bruegel, Pieter, the Elder 19211 Netherlandish 179 1525 1569 1565 1565 1565 Oil on wood 156 Overall, including added strips at top, bottom, and right, 46 7/8 x 63 3/4 in. (119 x 162 cm); original painted surface 45 7/8 x 62 7/8 in. (116.5 x 159.5 cm) Rogers Fund, 1919                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
305975 49.7.19 1 1 435896 European Paintings 15 Painting 69 Portrait of a Carthusian           Artist 2   Petrus Christus Netherlandish, Baarle-Hertog (Baerle-Duc), active by 1444–died 1475/76 Bruges   Christus, Petrus 43472 Netherlandish 179 1444 1476 1446 1446 1446 Oil on wood 156 Overall 11 1/2 x 8 1/2 in. (29.2 x 21.6 cm); painted surface 11 1/2 x 7 3/8 in. (29.2 x 18.7 cm) The Jules Bache Collection, 1949                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306168 49.7.21 1 1 436101 European Paintings 15 Painting 69 The Rest on the Flight into Egypt           Artist 2   Gerard David Netherlandish, Oudewater ca. 1455–1523 Bruges   David, Gerard 36585 Netherlandish 179 1455 1523 ca. 1512–15 1512 1515 Oil on wood 156 20 x 17 in. (50.8 x 43.2 cm) The Jules Bache Collection, 1949                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306975 14.40.626–27 1 1 437056 European Paintings 15 Painting 69 Tommaso di Folco Portinari (1428–1501); Maria Portinari (Maria Maddalena Baroncelli, born 1456)           Artist 2   Hans Memling Netherlandish, Seligenstadt, active by 1465–died 1494 Bruges   Memling, Hans 43742 Netherlandish 179 1465 1494 ca. 1470 1465 1475 Oil on wood 156 (.626, Tommaso) overall 17 3/8 x 13 1/4 in. (44.1 x 33.7 cm), painted surface 16 5/8 x 12 1/2 in. (42.2 x 31.8 cm); (.627, Maria) overall 17 3/8 x 13 3/8 in. (44.1 x 34 cm); painted surface 16 5/8 x 12 5/8 in. (42.2 x 32.1 cm) Bequest of Benjamin Altman, 1913                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307162 36.14a–c 1 1 437261 European Paintings 15 Painting, triptych 14081 The Penitence of Saint Jerome           Artist 2   Joachim Patinir Netherlandish, Dinant or Bouvignes, active by 1515–died 1524 Antwerp   Patinir, Joachim 43810 Netherlandish 179 1515 1524 ca. 1512–15 1512 1515 Oil on wood 156 Shaped top: central panel, overall, with engaged frame, 46 1/4 x 32 in. (117.5 x 81.3 cm); each wing, overall, with engaged frame, 47 1/2 x 14 in. (120.7 x 35.6 cm) Fletcher Fund, 1936                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307372 32.100.43 1 1 437487 European Paintings 15 Painting 69 Francesco d'Este (born about 1429, died after July 20, 1486)           Artist 2   Rogier van der Weyden Netherlandish, Tournai ca. 1399–1464 Brussels   Rogier van der Weyden 43845 Netherlandish 179 1399 1464 ca. 1460 1455 1465 Oil on wood 156 Overall 12 1/2 x 8 3/4 in. (31.8 x 22.2 cm): painted surface, each side 11 3/4 x 8 in. (29.8 x 20.3 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307414 1981.238 1 1 437532 European Paintings 15 Painting 69 Rubens, His Wife Helena Fourment (1614–1673), and Their Son Frans (1633–1678)           Artist 2   Peter Paul Rubens Flemish, Siegen 1577–1640 Antwerp   Rubens, Peter Paul 9798 Flemish 87 1577 1640 ca. 1635 1630 1640 Oil on wood 156 80 1/4 x 62 1/4 in. (203.8 x 158.1 cm) Gift of Mr. and Mrs. Charles Wrightsman, in honor of Sir John Pope-Hennessy, 1981                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307470 22.75 1 1 437609 European Paintings 15 Painting 69 The Holy Family with the Young Saint John the Baptist           Artist 2   Andrea del Sarto (Andrea d'Agnolo) Italian, Florence 1486–1530 Florence   Sarto, Andrea del (Andrea d'Agnolo) 17671 Italian 6 1486 1530 ca. 1528 1523 1533 Oil on wood 156 53 1/2 x 39 5/8 in. (135.9 x 100.6 cm) Maria DeWitt Jesup Fund, 1922                       Paintings 11   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 179.291ms · Data license: CC0 · Data source: metmuseum/openaccess