MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 13 and Department = 17 sorted by Reign

View and edit SQL

Suggested facets: Object Name, Culture, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Country, Classification

Department

  • The Cloisters · 6

Artist Role

  • Artist|Artist · 6
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
328451 1979.186 0 1 469841 The Cloisters 17 Roundel 760 Roundel with Architecture (from a series of The Septem Artes Mechanicae) German 27         Artist|Artist 13 After|Based on a composition by Monogrammist SZ|Jörg Breu the Elder German, active 16th century|German, Augsburg 1480–1537 Augsburg   Monogrammist SZ|Breu, Jörg, the Elder 44714 German|German 79 1500 |1480 1600 |1537 after 1563 1563 1599 Colorless glass, silver stain and vitreous paint 50202 Overall: 8 3/4 x 5/16 in. (22.2 x 0.8 cm) The Cloisters Collection, 1979 Made in 1     Augsburg 759 Germany 16             Glass-Painted 315   Metropolitan Museum of Art, New York, NY 1
328594 1998.215.1 0 1 469986 The Cloisters 17 Stained glass panel 665 Man of Sorrows German 27         Artist|Artist 13   Circle of Peter Hemmel von Andlau (Strassburger Werkstattgemeinschaft)|Lautenbach Master active Southern and Central Germany, ca. 1470–1500|German, active late 15th century   Hemmel von Andlau, Peter Circle of|Lautenbach Master 44727 German 10 1470 1500 ca. 1480 1480 1480 Pot-metal glass and vitreous paint 49110 19 1/2 x 16 3/8 in. (49.5 x 41.6 cm) The Cloisters Collection, 1998 Made in 1 Strasbourg 481   Upper Rhineland 644 Germany (present-day France) 616             Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
328619 1998.215.2 0 1 470136 The Cloisters 17 Stained glass panel 665 The Mater Dolorosa South German 189         Artist|Artist 13   Circle of Peter Hemmel von Andlau (Strassburger Werkstattgemeinschaft)|Lautenbach Master active Southern and Central Germany, ca. 1470–1500|German, active late 15th century   Hemmel von Andlau, Peter Circle of|Lautenbach Master 44727 German 10 1470 1500 ca. 1480 1480 1480 Pot-metal glass and colorless glass, silver stain, and vitreous paint 50270 19 5/8 x 16 3/8 in. (49.8 x 41.6 cm) The Cloisters Collection, 1998 Made in 1     Swabia 610 Germany 16             Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
332158 2009.281 0 1 478774 The Cloisters 17 Roundel 760 Roundel with Christ Healing the Blind Man German 27         Artist|Artist 13 After Hirschvogel Workshop|Sebald Beham German, Nuremberg 1500–1550 Frankfurt   Hirschvogel Workshop|Beham, Sebald 8734 German 10 1500 1550 1517–27 1517 1527 Colorless and pot-metal glass with vitreous paint 21090 Overall: 12 1/16 x 1/4 in. (30.7 x 0.6 cm) The Cloisters Collection, 2009 Made in 1 Nuremberg 149     Germany 16             Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
332324 2010.22.1 0 1 478972 The Cloisters 17 Panel 399 Gathering Manna German 27         Artist|Artist 13 Workshop of|Based on a design by Friedrich Brunner|Jan Pollack German|Polish (?), active Bavaria, ca. 1479–died 1519   Brunner Friedrich|Pollack, Jan 44772 German|Polish (?) 3412 1479 1519 1497–99 1497 1499 Pot-metal glass, vitreous paint, and silver stain 50206 Overall: 19 3/4 x 20 7/8 in. (50.2 x 53 cm) Purchase, The Cloisters Collection and Gift of The Hearst Foundation, by exchange, 2010                       Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
332341 2010.22.2 0 1 478997 The Cloisters 17 Panel 399 Storing up Manna German 27         Artist|Artist 13 Workshop of|Based on a design by Friedrich Brunner|Jan Pollack German|Polish (?), active Bavaria, ca. 1479–died 1519   Brunner Friedrich|Pollack, Jan 44772 German|Polish (?) 3412 1479 1519 1497–99 1497 1499 Pot-metal glass, vitreous paint, and silver stain 50206 Overall: 19 3/4 x 20 7/8 in. (50.2 x 53 cm) Purchase, The Cloisters Collection and Gift of The Hearst Foundation, by exchange, 2010                       Glass-Stained 147   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 383.321ms · Data license: CC0 · Data source: metmuseum/openaccess