MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Medium = 44481

View and edit SQL

Suggested facets: Is Highlight, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, 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
305701 12.115 0 1 435585 European Paintings 15 Painting 69 Portrait of a Man and His Wife (Lorenz Kraffter and Honesta Merz?)           Artist 2   Ulrich Apt the Elder German, Augsburg ca. 1460–1532 Augsburg   Apt, Ulrich, the Elder 43383 German 10 1460 1532 1512 1512 1512 Oil on linden 44481 13 x 24 7/8 in. (33 x 63.2 cm) Rogers Fund, 1912                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306108 11.15 0 1 436038 European Paintings 15 Painting 69 Judith with the Head of Holofernes           Artist 2   Lucas Cranach the Elder German, Kronach 1472–1553 Weimar   Cranach, Lucas, the Elder 3043 German 10 1472 1553 ca. 1530 1525 1535 Oil on linden 44481 35 1/4 x 24 3/8 in. (89.5 x 61.9 cm) Rogers Fund, 1911                       paintings: panel 774   Metropolitan Museum of Art, New York, NY 1
306109 57.22 0 1 436039 European Paintings 15 Painting 69 The Martyrdom of Saint Barbara           Artist 2   Lucas Cranach the Elder German, Kronach 1472–1553 Weimar   Cranach, Lucas, the Elder 3043 German 10 1472 1553 ca. 1510 1505 1515 Oil on linden 44481 Overall 60 3/8 x 54 1/4 in. (153.4 x 137.8 cm); painted surface 59 3/8 x 53 1/8 in. (150.8 x 134.9 cm) Rogers Fund, 1957                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306289 32.100.64 0 1 436243 European Paintings 15 Painting 69 Salvator Mundi           Artist 2   Albrecht Dürer German, Nuremberg 1471–1528 Nuremberg   Dürer, Albrecht 9043 German 10 1471 1528 ca. 1505 1500 1510 Oil on linden 44481 22 7/8 x 18 1/2in. (58.1 x 47cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306290 14.40.633 1 1 436244 European Paintings 15 Painting 69 Virgin and Child with Saint Anne           Artist 2   Albrecht Dürer German, Nuremberg 1471–1528 Nuremberg   Dürer, Albrecht 9043 German 10 1471 1528 probably 1519 1519 1519 Oil on linden 44481 23 5/8 x 19 5/8 in. (60 x 49.8 cm) Bequest of Benjamin Altman, 1913                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306292 49.7.27 0 1 436246 European Paintings 15 Painting 69 Portrait of an Italian Woman           Artist 2   German Painter active first third 16th century   German Painter 12004 German 10       1500 1599 Oil on linden 44481 17 3/4 x 13 3/4 in. (45.1 x 34.9 cm) The Jules Bache Collection, 1949                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306469 23.255 0 1 436480 European Paintings 15 Painting 69 Portrait of a Man           Artist 2   German (Nuremberg) Painter late 15th century   German (Nuremberg) Painter 43568 German 10     1491 1491 1491 Oil on linden 44481 18 3/4 x 13 in. (47.6 x 33 cm) Fletcher Fund, 1923                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306873 14.40.630 0 1 436942 European Paintings 15 Painting 69 Ulrich Fugger the Younger (1490–1525)           Artist 2   Hans Maler German, Ulm, born ca. 1480, died ca. 1526–29 Schwaz (?)   Maler, Hans 43695 German 10 1475 1529 1525 1525 1525 Oil on linden 44481 15 7/8 x 12 3/4 in. (40.3 x 32.4 cm) Bequest of Benjamin Altman, 1913                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307579 71.34 0 1 437759 European Paintings 15 Painting 69 Portrait of a Woman           Artist 2   Bernhard Strigel German, Memmingen 1460–1528 Memmingen   Strigel, Bernhard 43897 German 10 1460 1528 ca. 1510–15 1510 1515 Oil on linden 44481 15 1/8 x 10 1/2 in. (38.4 x 26.7 cm) Purchase, 1871                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
308004 2006.469 0 1 439081 European Paintings 15 Painting 69 Saint Maurice           Artist 2   Lucas Cranach the Elder and Workshop German, Kronach 1472–1553 Weimar   Cranach, Lucas, the Elder, and Workshop 43491 German 10 1472 1553 ca. 1520–25 1520 1525 Oil on linden 44481 54 x 15 1/2 in. (137.2 x 39.4 cm) Bequest of Eva F. Kollsman, 2005                       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 133.955ms · Data license: CC0 · Data source: metmuseum/openaccess