MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist Begin Date" is on date -4708-01-02 and Department = 5 sorted by Artist Nationality

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City

Department

  • Arms and Armor · 9

Artist Begin Date (date)

  • -4708-01-02 · 9
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
20423 1993.234 0 1 24956 Arms and Armor 5 Design for a saddle plate 2307 Design for the Pommel Plate of a Saddle from a Garniture of Alessandro Farnese (1545–1592) Italian, Parma 384         Designer 5   Andrea Casalini Italian, Parma, died 1597   Casalini, Andrea 2929 Italian 6 1500 1597 ca. 1575–80 1575 1580 Pen and brown ink, with color washes, on paper 4393 19 1/2 x 16 3/8 in. (49.5 x 39.2 cm) Purchase, Fletcher Fund and Gift of William H. Riggs, by exchange, 1993   Parma 527                   Works on Paper-Drawings 129   Metropolitan Museum of Art, New York, NY 1
20822 04.3.288 0 1 25419 Arms and Armor 5 Pommel plate 2367 Pommel Plate German, Augsburg 126         Etcher 104 Attributed to Jörg Sorg the Younger German, Augsburg, ca. 1522–1603   Sorg the Younger, Jörg 2971 German 10 1500 1625 ca. 1550 1525 1575 Steel, gold 3497 9 x 6 in. (22.9 x 15.2 cm), wt. 7 oz. (185 g) Rogers Fund, 1904   Augsburg 424   Bavaria 130               Equestrian Equipment-Saddles 54   Metropolitan Museum of Art, New York, NY 1
27044 04.3.280 0 0 32197 Arms and Armor 5 Portions of an armor garniture 1474 Portions of an Armor Garniture German, Augsburg 126         Etcher 104   Jörg Sorg the Younger German, Augsburg, ca. 1522–1603   Sorg the Younger, Jörg 2971 German 10 1500 1625 ca. 1550–55, some etched decoration, 19th century 1525 1900 Steel, gold, leather, velvet 6521   Rogers Fund, 1904   Augsburg 424                   Armor 122   Metropolitan Museum of Art, New York, NY 1
27045 04.3.282 0 1 32198 Arms and Armor 5 Portions of an armor garniture 1474 Portions of an Armor Garniture German, Augsburg 126         Etcher 104   Jörg Sorg the Younger German, Augsburg, ca. 1522–1603   Sorg the Younger, Jörg 2971 German 10 1500 1625 ca. 1550–55, some etched decoration, 19th century 1525 1900 Steel, gold, leather, velvet 6521   Rogers Fund, 1904   Augsburg 424                   Armor for Man-1/2 Armor 40   Metropolitan Museum of Art, New York, NY 1
27674 23.58 0 0 32844 Arms and Armor 5 Reinforce for the left elbow 3494 Reinforce for the Left Elbow German, Augsburg 126         Etcher 104   Jörg Sorg the Younger German, Augsburg, ca. 1522–1603   Sorg the Younger, Jörg 2971 German 10 1500 1625 ca. 1550–55, some etched decoration, possibly 19th century 1525 1900 Steel, gold 3497 L. 11 1/2 in. (29.21 cm); W. 8 1/2 in. (21.59 cm) Anonymous Gift, in memory of Cornelius Stevenson, 1923   Augsburg 424                   Armor Parts-Elbow Plates 90   Metropolitan Museum of Art, New York, NY 1
30197 04.3.280, .282; 23.58; 26.234.3 0 1 35727 Arms and Armor 5 Portions of an armor garniture 1474 Portions of an Armor Garniture German, Augsburg 126         Etcher 104   Jörg Sorg the Younger German, Augsburg, ca. 1522–1603   Sorg the Younger, Jörg 2971 German 10 1500 1625 ca. 1550–55, some etched decoration, 19th century 1525 1900 Steel, gold, leather, velvet 6521   04.3.280, .282: Rogers Fund, 1904; 23.58: Anonymous Gift, in memory of Cornelius Stevenson, 1923; 26.234.3: Gift of George D. Pratt, 1926   Augsburg 424                   Armor for Man 44   Metropolitan Museum of Art, New York, NY 1
19844 36.25.1694a, b 0 0 24369 Arms and Armor 5 Blade and mounting for a slung sword (Tachi) 1305 Blade and Mounting for a Slung Sword (Tachi) Japanese 35         Swordsmith 92 Blade inscribed by Kiyomitsu Japanese, active in Osafune, Bizen province, early 16th century   Kiyomitsu 2835 Japanese 74 1500 1550 blade dated 1533; mounting, 19th century 1533 1900 Steel, wood, lacquer, leather, copper-gold alloy (shakudō), gold, iron copper 4143 L. 38 5/16 in. (97.3 cm); L. of cutting edge 26 5/16 in. (66.9 cm); D. of curvature 11/16 in. (1.8 cm) Bequest of George C. Stone, 1935       Okayama Prefecture 98               Swords 29   Metropolitan Museum of Art, New York, NY 1
19907 36.25.1967a, b 0 0 24432 Arms and Armor 5 Mounted spear with sheath 2127 Mounted Spear with Sheath Japanese 35         Swordsmith 92 Blade inscribed by Kané Japanese, Seki school, active early 16th century   Kané 2842 Japanese 74 1500 1550 blade, early 16th century; mounting, 18th century 1500 1800 Steel, wood, lacquer, silver 4173   Bequest of George C. Stone, 1935                       Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
17779 14.25.808 0 0 22290 Arms and Armor 5 Reinforcing breastplate for the tilt 1490 Reinforcing Breastplate for the Tilt Austrian 184         Armorer 98   Michael Witz the Younger German, Innsbruck, active from ca. 1525, last recorded 1588   Witz the Younger Michael 2723 German (Innsbruck) 82 1500 1588 ca. 1520 1495 1545 Steel 658 H. 15 1/2 in. (39.4 cm); W. 13 1/2 in. (34.3 cm); D. 6 1/4 in. (15.9 cm); Wt. 4 lb. 2.3 oz (1879.6 g) Gift of William H. Riggs, 1913   Innsbruck 433                   Armor Parts-Breastplates 62   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 3513.936ms · Data license: CC0 · Data source: metmuseum/openaccess