MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Classification = 122

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Culture, Artist Nationality, Object Begin Date, Object End Date, Medium, City

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
19421 33.164a–x 1 1 23944 Arms and Armor 5 Armor 1320 Armor of Emperor Ferdinand I (1503–1564) German, Nuremberg 147         Armorer 98   Kunz Lochner German, Nuremberg, 1510–1567   Lochner, Kunz 2724 German 10 1510 1567 dated 1549 1549 1549 Steel, brass, leather 3632 H. 67 in. (170.2 cm); Wt. 52 lb. 14 oz. (24 kg) Purchase, Rogers Fund and George D. Pratt Gift, 1933   Nuremberg 149                   Armor 122   Metropolitan Museum of Art, New York, NY 1
20133 38.143b–d 0 1 24660 Arms and Armor 5 Cuirass and tassets (torso and hip defense) 2212 Cuirass and Tassets (Torso and Hip Defense) German, Augsburg 126         Armorer|Decorator 117 Attributed to|Etching attributed to Kolman Helmschmid|Daniel Hopfer German, Augsburg 1471–1532|German, Kaufbeuren 1471–1536 Augsburg   Helmschmid, Kolman|Hopfer, Daniel 2857 German|German 79 1471 |1471 1532 |1536 ca. 1510–20 1485 1545 Steel, leather 3500 H. 41 1/2 in. (105.4 cm); Wt. 19 lb. 8 oz. (8845 g) Gift of Marshall Field, 1938   Augsburg 424                   Armor 122   Metropolitan Museum of Art, New York, NY 1
22913 46.121.1–2 0 1 27888 Arms and Armor 5 Pair of arm guards 2857 Pair of Arm Guards Indian 67                           18th—19th century 1701 1900 Steel, gold, velvet, textile, copper alloy 5233 L. 20 in. (50.8 cm) Gift of Francis Louis Slade, 1946                       Armor 122   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
29679 27.160.1–.8 0 1 34892 Arms and Armor 5 Elements of an armor garniture 2511 Elements of an Armor Garniture German, Augsburg 126                           1560 1560 1560 Steel, brass, leather 3632 H. of helmet (27.160.1) 10 1/2 in. (31.8 cm); face guard with umbril (27.160.2): 7 1/2 x 8 in. (19.1 x 20.3 cm); reinforcing buffe (27.160.3): 9 1/2 x 12 in. (24.1 x 30.5 cm); shoulder defense (27.160.4): 11 x 11 in. (27.9 x 27.9 cm); L. of each leg defense (27.160.5, .6) 28 in. (71.1 cm); L. of gauntlet (27.160.7) 9 1/2 in. (24.1 cm); Diam. of vamplate (27.160.8) 10 1/2 in. (31.8 cm) Gift of Archer M. Huntington, 1927   Augsburg 424                   Armor 122   Metropolitan Museum of Art, New York, NY 1
30316 2012.528.1a–s 0 0 35911 Arms and Armor 5 Armor (Yoroi) with storage box 3871 Armor (Yoroi) Japanese 35                           19th century 1801 1900 Iron, copper, gold, lacquer, silk, leather, textile 7227 H. as mounted 45 in. (114.3 cm); armor box 25 3/4 x 32 x 23 in. (66.9 x 83.2 x 58.4 cm) Gift of the Baber Family, in loving memory of Charles Chenault Baber, 2012                       Armor 122   Metropolitan Museum of Art, New York, NY 1
30336 36.25.25,.28,.351,.476,.583,.842,.2174... 0 1 35942 Arms and Armor 5 Armored cavalryman 3876 Armored Cavalryman Tibetan, and possibly Bhutanese and Nepalese 647                           18th–19th century 1701 1900 Steel, iron, gold, silver, copper alloy, brass, wood, leather, textile, bone, horn, silk, hair, turquoise, lead 7231 as mounted, H. approx. 55 in. (139.7 cm) 36.25.2ii, .25, .351, .476, .583a–d, h–k, .2174, .2461, .2505, .2557a, b: Bequest of George C. Stone, 1935; 1974.160.10: Bequest of Joseph V. McMullan, 1973; 1970.164.7a, b: Gift of Mrs. Faïe J. Joyce, 1970; 1997.214.6: Purchase, Rogers Fund and bequest of Stephen V. Grancsay, by exchange, 1997; 2006.269: Purchase, Arthur Ochs Sulzberger Gift, 2006                       Armor 122   Metropolitan Museum of Art, New York, NY 1
401473 14.25.686e, f 0 0 656379 Arms and Armor 5 Pair of mitten gauntlets 1544 Pair of Mitten Gauntlets German 27                           ca. 1600 1575 1625 Steel, leather 3500   Gift of William H. Riggs, 1913                       Armor 122   Metropolitan Museum of Art, New York, NY 1
401528 SL.1.2015.32.5 0 0 656461 Islamic Art 9 Dagger 337 Dagger in the Form of a Bird Holding a Leaf                             early 17th century 17 17 Steel 658 15 15/16 × 3 1/8 × 7/8 in. (40.5 × 8 × 2.2 cm) Collection of Bashir Mohamed                       Armor 122   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 141.771ms · Data license: CC0 · Data source: metmuseum/openaccess