MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Department = 5 and Medium = 16

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Credit Line, Classification

Department

  • Arms and Armor · 13
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
19482 36.25.22a–c 0 1 24006 Arms and Armor 5 Shirt and leg defenses of mail 2022 Shirt and Leg Defenses of Mail Iranian or Indian 297                           19th century 1801 1900 Iron, brass 16 36.25.22 b,c (mail chausses): L. of each 24 13/16 in. (64.0 cm); W. of each at top 15 11/16 in. (37.0 cm); Diam. of each cuff 8 5/16 in. (18.5 cm); Diam. (outside) of links 5/32 in. (4.2 mm). Bequest of George C. Stone, 1935                       Mail 63   Metropolitan Museum of Art, New York, NY 1
19739 36.25.526a, b 0 0 24264 Arms and Armor 5 Pair of stirrups 1406 Pair of Stirrups Japanese 35                           ca. 1615–1868 1590 1900 Iron, brass 16   Bequest of George C. Stone, 1935                       Equestrian Equipment-Stirrups 68   Metropolitan Museum of Art, New York, NY 1
19750 36.25.549 0 0 24275 Arms and Armor 5 Bit 1370 Bit Japanese 35                           19th century 1800 1899 Iron, brass 16 W. of mouthpiece 5 1/2 in. (14 cm); Wt. 1 lb. 0 oz. (454 g) Bequest of George C. Stone, 1935                       Equestrian Equipment-Bits 56   Metropolitan Museum of Art, New York, NY 1
20031 36.25.2949 0 0 24556 Arms and Armor 5 War fan (Uchiwa) 2171 War Fan (Uchiwa) Japanese 35                           ca. 1615–1868 1590 1900 Iron, brass 16   Bequest of George C. Stone, 1935                       Miscellaneous 64   Metropolitan Museum of Art, New York, NY 1
21502 46.122.53 0 1 26315 Arms and Armor 5 Sword guard (Tsuba) 1287 Sword Guard (Tsuba) Japanese 35                           17th century 1601 1700 Iron, brass 16 H. 3 in. (7.6 cm); W. 2 7/8 in. (7.3 cm) Funds from various donors, 1946                       Sword Furniture-Tsuba 32   Metropolitan Museum of Art, New York, NY 1
22036 36.25.1885 0 0 26882 Arms and Armor 5 Mace 1328 Mace Chinese 10                           18th century 1701 1800 Iron, brass 16 L. 16 1/4 in. (41.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
25029 36.25.2890 0 1 30180 Arms and Armor 5 Flail 2948 Flail Indian 67                           18th century 1701 1800 Iron, brass 16 H. 40 1/2 in. (102.9 cm); H. of handle 16 in. (40.6 cm); W. 1 in. (2.5); Wt. 1 lb. 15.7 oz. (898.7 g) Bequest of George C. Stone, 1935                       Miscellaneous 64   Metropolitan Museum of Art, New York, NY 1
25709 36.25.1887 0 0 30861 Arms and Armor 5 Mace 1328 Mace Chinese 10                           18th–19th century 1701 1900 Iron, brass 16 H. 21 1/2 in. (54.61 cm); W. 2 1/4 in. (5.7 cm); Wt. 2 lb. 9 oz. (1162.3 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
25750 36.25.1799 0 0 30902 Arms and Armor 5 Axe head 2416 Axe Head Persian 65                           late 17th century 1650 1700 Iron, brass 16 L. 5 1/4 in. (13.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
27478 26.145.1 0 0 32642 Arms and Armor 5 Dagger 337 Dagger Hispano-Moresque 1103                           14th century 1401 1500 Iron, brass 16 L. 15 1/2 in. (39.4 cm); L. of blade 9 1/2 in. (24.1 cm); W. 1 5/16 in. (3.3 cm); W. of blade 1 1/4 in. (3.2 cm); thickness of blade 5/16 in. (0.8 cm); Wt. 10 oz. (283.5 g) Gift of Jean Jacques Reubell, in memory of his mother, Julia C. Coster, and of his wife, Adeline E. Post, both of New York City, 1926                       Daggers 33   Metropolitan Museum of Art, New York, NY 1
28898 29.158.684 0 0 34097 Arms and Armor 5 Sword pommel 1652 Sword Pommel European 12                           13th–14th century 1201 1400 Iron, brass 16 Diam. 1 3/4 in. (4.5 cm); D. 1 1/8 in. (2.9 cm); Wt. 8.5 oz. (241 g) Bashford Dean Memorial Collection, Funds from various donors, 1929                       Swords-Accessories 74   Metropolitan Museum of Art, New York, NY 1
29621 27.183.2 0 1 34828 Arms and Armor 5 Face defense of mail 3716 Face Defense of Mail German 27                           15th century 1401 1500 Iron, brass 16 H. 15 in. (38.1 cm); W. 33 in. (83.8 cm); Wt. 2 lb. 13 oz. (1275.73 g). Gift of Prince Albrecht Radziwill, 1927                       Mail 63   Metropolitan Museum of Art, New York, NY 1
30161 2009.105 0 0 35662 Arms and Armor 5 Bullet mold 2745 Bullet Mold Himalayan, possibly Tibetan, Nepalese, or Bhutanese 1248                           17th–19th century 1601 1900 Iron, brass 16 L. 5 3/4 in. (14.5 cm); W. 2 3/4 in. (7 cm); Wt. 6.3 oz. (178.6 g) Purchase, Kenneth and Vivian Lam Gift, 2009                       Firearms Accessories 92   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 160.815ms · Data license: CC0 · Data source: metmuseum/openaccess