MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

24 rows where Culture = 41 and Department = 5

View and edit SQL

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

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
17440 04.3.51 0 0 21942 Arms and Armor 5 Basket-hilted sword 1329 Basket-Hilted Sword Scottish 41                           1730–50 1730 1750 Steel, gold, leather, wood, velvet 3513 L. 40 7/8 in. (103.8 cm); L. of blade 34 5/16 in. (87.2 cm); W. 6 in. (15.2 cm); Wt. 3 lb. 7 oz. (1559 g) Rogers Fund, 1904                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20251 46.105 0 1 24779 Arms and Armor 5 Snaphance flintlock pistol 2237 Snaphance Flintlock Pistol Made for Wilhelm, Duke of Kurland Scottish 41                           dated 1615 1615 1615 Steel, gold, silver, wood (brazilwood) 4316 L. 19 3/4 in. (50.2 cm); L. of barrel 12 1/2 in. (31.8 cm); Cal. .38 in. ( 9.7 mm); Wt. 2 lb. 5 oz. (1050 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1946                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
20428 1996.83 0 1 24961 Arms and Armor 5 Highland Targe 2311 Highland Targe Scottish 41                           1700–1750 1700 1750 Wood, leather, brass, horn, textile 4397 Diam. 19 3/4 in. (50.2 cm); Wt. 6 lb. 5 oz. (2870 g) Gift of Jeremy, Christopher, and Robert Douglass, in memory of their father, George A. Douglass, 1996                       Shields 39   Metropolitan Museum of Art, New York, NY 1
22326 14.25.730 0 0 27219 Arms and Armor 5 Shield 1361 Shield Scottish 41                           17th–18th century or later 1601 1900 Wood, leather, brass 144 Diam. 19 1/2 in. (49.5 cm); D. 3 1/2 in. (8.9 cm); Wt. 8 lb. 13 oz. (3997.3) Gift of William H. Riggs, 1913                       Shields 39   Metropolitan Museum of Art, New York, NY 1
22351 14.25.765 0 0 27244 Arms and Armor 5 Shield 1361 Shield Scottish 41                           17th–18th century or later 1601 1900 Wood, leather, brass, iron 4991 Diam. 17 1/8 in. (43.5 cm); D. 2 3/4 in. (7 cm); Wt. 5 lb. (2268 g) Gift of William H. Riggs, 1913                       Shields 39   Metropolitan Museum of Art, New York, NY 1
22536 14.25.1062 0 0 27441 Arms and Armor 5 Broadsword 1323 Broadsword Scottish 41                           18th century 1701 1800 Steel, shagreen 5070 L. 41 in. (104.1 cm); L. of blade 31 1/4 in. (89.5 cm); W. 5 1/4 in. (13.3 cm); D. 5 in. (12.7 cm); Wt. 3 lb. 2 oz. (1417.5 g) Gift of William H. Riggs, 1913                       Swords 29   Metropolitan Museum of Art, New York, NY 1
22601 54.46.6–7 0 0 27512 Arms and Armor 5 Pair of highland flintlock pistols 2753 Pair of Highland Flintlock Pistols Scottish 41                           late 17th century 1650 1700 Steel, silver 3508 L. of each 13 15/16 in. (35.4 cm); L. of each barrel 8 3/4 in. (22.2 cm); Cal. of each .58 in. (14.7 mm); Wt. of each 1 lb. 15 oz. (878.4 g) Bequest of Alan Rutherfurd Stuyvesant, 1954                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
22967 45.160.2 0 0 27943 Arms and Armor 5 Claymore 2755 Claymore Scottish 41                           16th century 1501 1600 Steel 658 L. 48 in. (121.9 cm); L. of blade 35 1/2 in. (90.1 cm); W. 12 1/2 in. (31.8 cm); Wt. 4 lb. 2 oz. (1871.1 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1945                       Swords 29   Metropolitan Museum of Art, New York, NY 1
22968 45.160.3a–d 0 0 27944 Arms and Armor 5 Dirk with sheath, knife and fork 2864 Dirk with Sheath, Knife and Fork Scottish 41                           1822 1822 1822 Steel, silver, leather, wood 5256 Dirk (a); L. with sheath 17 3/4 in. (45.1 cm); L. without sheath 17 3/8 in. (44.1 cm); L. of blade 13 in. (33 cm); W. 1 5/8 in. (4.15 cm); W. of blade 1 3/8 in. (3.5 cm); thickness of blade 3/16 in. (0.5 cm); Wt. 9 oz. (255.1 g); Wt. of sheath 3.7 oz. (104.9 g); knife (c); L. 7 3/8 in. (18.7 cm); Wt. 1 oz. (28.3 g); fork (d); L. 6 15/16 in. (17.6 cm); Wt. 1.2 oz. (34 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1945                       Daggers 33   Metropolitan Museum of Art, New York, NY 1
22970 45.160.5 0 0 27946 Arms and Armor 5 Powder flask 1532 Powder Flask Scottish 41                           1669 1669 1669 Horn, wood 4166 L. 8 1/2 in. (21.6 cm); D. 1 in. (2.5 cm); Wt. 2.6 oz. (73.7 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1945                       Firearms Accessories-Powder Horns 51   Metropolitan Museum of Art, New York, NY 1
22971 45.160.6-7 0 0 27947 Arms and Armor 5 Pair of flintlock pistols 1316 Pair of Flintlock Pistols Scottish 41                           1725 1700 1750 Steel, silver 3508 45.160.6; L. 20 3/8 in. (51.8 cm); L. of barrel 15 3/4 in. (40 cm); Cal. .64 in. (16.2 mm); Wt. 2 lb. 5 oz. (1048.9 g); 45.160.7; L. 20 3/8 in. (51.8 cm); L. of barrel 15 3/4 in. (40 cm); Cal. .65 in. (16.5 mm); Wt. 2 lb. 5 oz. (1048.9 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1945                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
22972 45.160.8a–d 0 0 27948 Arms and Armor 5 Dirk with sheath, knife, and fork 2866 Dirk with Sheath, Knife, and Fork Scottish 41                           1830–40 1830 1840 Steel, leather, wood, silver 5257 Dirk (a); L. with sheath 16 1/2 in. (41.9 cm); L. without sheath 16 1/8 in. (41 cm); L. of blade 11 3/8 in. (28.9 cm); W. 1 13/16 in. (4.6 cm); W. of blade 1 3/8 in. (3.5 cm); thickness of blade 3/16 in. (0.5 cm); Wt. 9 oz. (255.1 g); Wt. of sheath 3.2 oz. (90.7 g); knife (c); L. 6 5/8 in. (16.8 cm); Wt. 0.8 oz. (22.7 g); fork (d); L. 6 1/16 in. (15.4 cm); Wt. 0.7 oz. (19.8 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1945                       Daggers 33   Metropolitan Museum of Art, New York, NY 1
24559 37.186.7 0 0 29599 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Scottish 41                           1780 1780 1780 Steel, ram's horn, silver 5474 L. 11 7/8 in. (30.2 cm); L. of barrel 7 5/16 in. (18.6 cm); Cal. .63 in. (16 mm); Wt. 1 lb. 5 oz. (595.3 ) Gift of Mrs. D. H. Schmidt, in memory of Theodore Offerman, 1937                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
27131 32.75.98a–d 0 0 32287 Arms and Armor 5 Dirk with sheath, knife, and fork 2866 Dirk with Sheath, Knife, and Fork Scottish 41                           1880–81 1880 1881 Steel, silver, crystal, leather 6548 L. with sheath 16 1/2 in. (41.9 cm); L. without sheath 15 3/16 in. (38.6 cm); L. of blade 10 1/4 in. (26 cm); W. 1 15/16 in. (4.9 cm); W. of blade 1 3/8 in. (3.5 cm); thickness of blade 3/16 in. (0.5 cm); Wt. 12 oz. (340.2 g); Wt. of sheath 4.3 oz. (121.9 cm); knife (c); L. 5 11/16 in. (14.5 cm); W. 3/4 in. (1.9 cm); Wt. 1.2 oz. (34 g); fork (d); L. 4 15/16 in. (12.5 cm); W. 3/4 in. (1.9 cm); Wt. 0.9 oz. (25.5 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Daggers 33   Metropolitan Museum of Art, New York, NY 1
27216 31.46a, b 0 0 32372 Arms and Armor 5 Stocking knife with sheath (Sgian Dubh) 3428 Stocking Knife with Sheath Scottish 41                           19th century 1801 1900 Steel, silver, ebony, crystal 6573 L. with sheath 7 3/4 in. (19.7 cm); L. without sheath 7 3/16 in. (18.2 cm); L. of blade 3 7/8 in. (9.8 cm); W. 1 3/16 in. (3 cm); W. of blade 13/16 in. (2.1 cm); thickness of blade 1/16 in. (0.2 cm); Wt. 2 oz. (56.7 g); Wt. of sheath 3 oz. (85 g) Rogers Fund, 1931                       Knives 49   Metropolitan Museum of Art, New York, NY 1
27824 22.122.48 0 1 32997 Arms and Armor 5 Medal 148 Medal Showing Prince Charles and Prince Henry Scottish 41         Artist 2   Ottone Hamerani Italian, Rome 1694–1768   Hamerani Ottone 3089   1694 1768 1729 1729 1729 Bronze 23 Diam. 1 13/16 in. (4.6 cm); thickness 1/4 in. (0.6 cm); Wt. 1.8 oz. (51 g) Gift of Bashford Dean, 1922                       Miscellaneous-Coins and Medals 155   Metropolitan Museum of Art, New York, NY 1
28140 19.53.52 0 0 33317 Arms and Armor 5 Flintlock pistol 2301 Highland Flintlock Pistol Scottish 41                           ca. 1775 1750 1800 Steel, silver, iron 4295 L. 12 3/8 in. (31.4 cm); L. of barrel 7 13/16 in. (19.8 cm); Cal. .58 in. (14.7 mm); Wt. 1 lb. 8.7 oz. (700.2 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
28141 19.53.53 0 0 33318 Arms and Armor 5 Highland flintlock pistol 3545 Highland Flintlock Pistol Scottish 41                           18th century 1775 1775 Steel, silver, iron 4295 L. 12 1/8 in. (30.8 cm); L. of barrel 7/8 in. (19.4 cm); Cal. .61 in. (15.5 mm); Wt. 1 lb. 9 oz. (708.7 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
28142 19.53.54–.55 0 0 33319 Arms and Armor 5 Pair of flintlock pistols 1316 Pair of Flintlock Pistols Scottish 41                           1810 1810 1810 Steel, horn, silver, gold 6757 19.53.54; L. 9 13/16 in. (24.9 cm); L. of barrel 5 3/4 (14.6 cm); Cal. .47 in. (12 mm); Wt. 1 lb. 5 oz. (595.3 g); 19.53.55; L. 9 11/16 in. (24.6 cm); L. of barrel L. 5 3/4 in. (14.6 cm); Cal. .47 in. (12 mm); Wt. 1 lb. 5 oz. (595.3 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
28143 19.53.57 0 0 33320 Arms and Armor 5 Highland flintlock pistol 3545 Highland Flintlock Pistol Scottish 41                           ca. 1770 1745 1795 Brass 12 L. 8 3/16 in. (20.8 cm); L. of barrel 5 1/4 in. (13.3 cm); Cal. .52 in. (13.1 mm); Wt. 1 lb. 2 oz. (510.3 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
28144 19.53.58 0 0 33321 Arms and Armor 5 Highland flintlock pistol 3545 Highland Flintlock Pistol Scottish 41                           1725–50 1725 1750 Steel, silver 3508 L. 9 1/4 In. (23.5 cm); L. of barrel 6 in. (15.2 cm); Cal. .49 in. (12.3 mm); Wt. 1 lb. 5 oz. (595.3 g) Gift of Charles M. Schott Jr., 1917                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
28157 19.53.92 0 0 33336 Arms and Armor 5 Powder flask 1532 Powder Flask Scottish 41                           late 17th century 1650 1700 Wood, leather, steel 6764 H. 8 1/2 in. (21.6 cm); W. 9 1/4 in. (23.5 cm); D. 2 1/2 in. (6.4 cm); Wt. 15.5 oz. (439.4 g) Gift of Charles M. Schott Jr., 1917                       Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
28348 16.54.1–.2 0 0 33528 Arms and Armor 5 Pair of Flintlock Pistols 2388 Pair of Flintlock Pistols Scottish 41                           18th century 1701 1800 Steel, silver, brass 4297 L. of each 14 7/16 in. (36.7 cm); L. of each barrel 10 1/4 in. (26 cm); Cal. of each .66 in. (16.8 mm); Wt. of each 2 lb. 8 oz. (1134 g) Gift of Mrs. Elizabeth C. Blanchard in memory of her husband, J. Osgood Blanchard, 1916                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
28579 14.25.1407a, b 0 0 33768 Arms and Armor 5 Pair of miquelet pistols 3543 Pair of Miquelet Pistols Scottish 41                           1623 1623 1623 Brass 12 14.25.1407a; L. 18 in. (45.7 cm); L. of barrel 12 5/8 in. (32 cm); Cal. .49 in. (12.4 mm); Wt. 2 lb. 7 oz. (1105.6 g); 14.25.1407b; L. 18 in. (45.7 cm); L. of barrel 12 5/8 in. (32 cm); Cal. .49 in. (12.4 mm); Wt. 2 lb. 7 oz. (1105.6 g) Gift of William H. Riggs, 1913                       Firearms-Pistols-Miquelet 127   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 193.18ms · Data license: CC0 · Data source: metmuseum/openaccess