MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where "Artist Begin Date" is on date -4709-11-28 and Culture = 27

View and edit SQL

Suggested facets: Department, Object Name, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, City, Classification

Artist Begin Date (date)

  • -4709-11-28 · 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
18561 29.150.4b–t 0 1 23083 Arms and Armor 5 Armor 1320 Armor German 27         Etcher 104 Etched decoration on poleyns (knee defeneses) attributed to Heilig Jörg German, active ca. 1490–1505   Jörg, Heilig 2790 German 10 1465 1530 ca. 1500 and later 1475 1900 Steel, leather 3500 H. 71 in. (180.3 cm); Wt. 39 lb. 2 oz. (17.75 kg) Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928                       Armor for Man 44   Metropolitan Museum of Art, New York, NY 1
110780 41.190.451 0 1 198990 European Sculpture and Decorative Arts 3 Panel 399 St. George standing behind kneeling donor, Jorig Baumgartner, and his family (one of a pair) German 27         Artist 2 Painted by Hans Wertinger German, Landschut ca. 1465–1533 Landshut   Wertinger, Hans 10180 German 10 1465 1533 1528 1528 1528 Stained glass 1008 Overall: 30 × 22 1/2 in. (76.2 × 57.2 cm) Bequest of George Blumenthal, 1941                       Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
120953 41.190.452 0 1 210190 European Sculpture and Decorative Arts 3 Panel 399 St. John the Baptist standing behind donor, Hanns Baumgartner, and his family (one of a pair) German 27         Artist 2 Painted by Hans Wertinger German, Landschut ca. 1465–1533 Landshut   Wertinger, Hans 10180 German 10 1465 1533 1528 1528 1528 Stained glass 1008 Overall: 30 × 22 1/2 in. (76.2 × 57.2 cm) Bequest of George Blumenthal, 1941                       Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
328517 1987.217 0 1 469907 The Cloisters 17 Statuette 14 Standing Bishop German 27         Artist 2   Hans von Reutlingen German, Aachen, 1465–1547 or Workshop von Reutlingen, Hans 44722 German 10 1465 1547 ca. 1510 1505 1515 Silver and silver gilt 263 Overall (without pin): 4 1/16 x 1 7/16 x 1 3/16 in. (10.3 x 3.6 x 3 cm) with pin: 5 1/4in. (13.3cm) Purchase, Desmond Gerald Fitzgerald Charitable Fund Gift, 1987 Made in 1 Aachen 454     Germany 16             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
328540 1991.9 0 1 469930 The Cloisters 17 Statuette 14 Standing Female Saint German 27         Artist 2   Hans von Reutlingen German, Aachen, 1465–1547 or Workshop von Reutlingen, Hans 44722 German 10 1465 1547 ca. 1510 1505 1515 Silver and silver gilt 263 Overall: 3 3/4 x 1 5/16 x 1 1/4in. (9.5 x 3.4 x 3.1cm) The Cloisters Collection, 1991 Made in 1 Aachen 454     Germany 16             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
329468 53.21 0 1 471455 The Cloisters 17 Triptych 6914 The Burg Weiler Altar Triptych (Altarpiece with the Virgin and Child and Saints) German 27         Artist 2   Master of the Burg Weiler Altarpiece German, Middle Rhineland, ca. 1470   Master of the Burg Weiler Altarpiece 44738 German 10 1465 1475 ca. 1470 1470 1470 Oil on wood, gold ground 44562 central panel: 68 1/2 x 60 in. (174 x 152.4 cm); each wing; 68 1/2 x 26 in. (174 x 66 cm) The Cloisters Collection, 1953 Made in 1 Baden-Württemberg (Nordwürttemberg) 2078   Middle Rhineland 690 Germany 16             Paintings-Panels 812   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 1367.686ms · Data license: CC0 · Data source: metmuseum/openaccess