MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Role = 2, Department = 6 and Object Name = 3917

View and edit SQL

Suggested facets: Title, Culture, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, 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
323616 06.161 0 1 462886 Medieval Art 6 Relief 3917 Nativity German 27         Artist 2   Alsatian Master     Alsatian Master 44639       16th century 1500 1599 Limewood 20866 35 3/8 x 28in. (89.9 x 71.1cm) Rogers Fund, 1906                       Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324068 12.130.1 0 1 463555 Medieval Art 6 Relief 3917 Baptism of Christ German 27         Artist 2 Workshop of Veit Stoss German, Hob am Neckar ca. 1445–1533 Nuremberg   Stoss, Veit 44648 German 10 1440 1533 ca. 1480–1490 1480 1490 Limewood with paint and gilding 49039 Overall: 48 x 40 x 3 in. (121.9 x 101.6 x 7.6 cm) Rogers Fund, 1912 Made in 1 Nuremberg 149     Germany 16             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324076 12.15 0 1 463570 Medieval Art 6 Relief 3917 Adoration of the Magi British 6         Artist 2   School of Nottingham     School of Nottingham 44641       15th century 1400 1499 Alabaster with paint and gilding 48954 Overall: 15 7/8 x 10 3/16 x 2 1/4 in. (40.3 x 25.9 x 5.7 cm) Rogers Fund, 1911 Made in 1 Nottingham 1849                   Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324206 16.32.158 0 1 463755 Medieval Art 6 Relief 3917 Nativity French 7         Artist 2 Circle of Antoine Le Moiturier French, ca. 1425–ca. 1497   Le Moiturier, Antoine 44654 French 2 1425 1497 ca. 1450 1445 1455 Limestone with later paint and gilding 49082 Overall: 17 3/4 x 25 7/8 x 7 1/4 in. (45.1 x 65.7 x 18.4 cm) Gift of J. Pierpont Morgan, 1916 Made in 1     Near Burgundy 631 France 9             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324243 16.32.213 0 1 463816 Medieval Art 6 Relief 3917 Meeting of Saints Joachim and Anne at the Golden Gate North German 1196         Artist 2   Benedikt Dreyer German, active Lübeck, ca. 1500–1525   Dreyer Benedikt 44659 German 10 1510 1530 ca. 1515–20 1515 1520 Oak with polychromy and gilding 49094 Overall: 23 x 19 1/4 x 4 7/8 in. (58.4 x 48.9 x 12.4 cm) Gift of J. Pierpont Morgan, 1916                       Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324251 16.32.221 0 1 463825 Medieval Art 6 Relief 3917 The Entombment South Netherlandish 5729         Artist 2   School of Antwerp     School of Antwerp 44660       early 16th century 1500 1550 Oak 32 Overall: 21 7/8 x 18 1/8 x 5 5/16 in. (55.6 x 46 x 13.5 cm) Gift of J. Pierpont Morgan, 1916 Made in 1 Antwerp 504     Flanders 515             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324871 17.190.736 0 1 464605 Medieval Art 6 Relief 3917 Scenes from the Life of Christ Spanish 13         Artist 2   Gil de Siloe Spanish, active 1475–1505 (?) Siloe, Gil de 44653 Spanish 76 1475 1505 15th–18th century 1400 1799 Walnut 50 Overall: 33 1/2 x 22 x 5 1/2 in. (85.1 x 55.9 x 14 cm) Gift of J. Pierpont Morgan, 1917 Made in 1     Castile-Burgos 656 Spain 5             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
326317 1993.516.2a, b 0 1 466267 Medieval Art 6 Relief 3917 Battle Scene North Italian 229         Artist 2   Embriachi Workshop     EMBRIACHI WORKSHOP 44651       15th century 1400 1499 Bone, (in modern painted wood frame) 49813 Overall: 3 9/16 x 1 15/16 x 1/4 in. (9.1 x 5 x 0.7 cm) Framed: 4 1/2 x 2 15/16 x 11/16 in. (11.4 x 7.4 x 1.7 cm) Gift of Robert L. Hermanos and Miriam H. Knapp in memory of their parents Mr. and Mrs. Maxime Levy Hermanos                       Ivories-Bone 817   Metropolitan Museum of Art, New York, NY 1
327117 32.100.148a, b 0 1 467466 Medieval Art 6 Relief 3917 Saint Margaret of Antioch British 6         Artist 2   British School     British School 44691       15th century 1400 1499 Alabaster with paint and gilding 48954 Overall (ab together): 22 5/16 x 5 1/16 x 2 1/16 in. (56.7 x 12.9 x 5.2 cm) a only: 16 3/8 x 5 1/16 x 1 15/16 in. (41.6 x 12.9 x 4.9 cm) b only: 5 15/16 x 4 7/8 x 2 1/16 in. (15.1 x 12.4 x 5.2 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
327661 48.154.1 0 1 468257 Medieval Art 6 Relief 3917 Holy Family South German 189         Artist 2   Niclaus Weckmann 1481–1528   WECKMANN NICLAUS 44699   1481 1528 ca. 1500 1500 1500 Limewood with traces of paint and gilding 50051 Overall: 31 7/8 x 19 11/16 x 7 3/4 in. (81 x 50 x 19.7 cm) Gift of Alastair Bradley Martin, 1948                       Sculpture-Wood 166   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 1055.146ms · Data license: CC0 · Data source: metmuseum/openaccess