Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, 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, 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 | Metadata Date | Repository |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22539 | 22539 | 14.25.1066 | 0 | 0 | 27444 | Arms and Armor 5 | Cup-hilted rapier 1322 | Cup-Hilted Rapier | German, Solingen; hilt, possibly Spanish 615 | Bladesmith 100 | Blade inscribed by | Peter Tesche | German, Solingen, active mid-17th century | Tesche Peter 2780 | 1625 | 1675 | mid-17th century | 1651 | 1700 | Steel, wood, iron, leather 4831 | L. 44 1/2 in. (113 cm); L. of blade 40 1/4 in. (102.2 cm); W. 11 in. (27.9 cm); D. 5 1/4 in. (13.3 cm); Wt. 2 lb. 1 oz. (935.53 g) | Gift of William H. Riggs, 1913 | Solingen 533 | Swords 29 | http://www.metmuseum.org/art/collection/search/27444 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 17462 | 17462 | 04.3.162 | 0 | 1 | 21964 | Arms and Armor 5 | Wheellock gun 1340 | Wheellock gun | Italian, Brescia 125 | Barrelsmith 105 | Cominazzo workshop | Italian, Brescia, mid-17th century | Cominazzo workshop 2689 | Italian 6 | 1625 | 1675 | mid-17th century | 1625 | 1675 | Steel, wood (walnut) 3526 | L. 45 1/2 in. (115.6 cm); L. of barrel 32 3/4 in. (83.2 cm); Cal. .58 in. (14.7 mm); Wt. 9 lb. 6 oz. (4250 g) | Rogers Fund, 1904 | Brescia 423 | Firearms-Guns-Wheellock 50 | http://www.metmuseum.org/art/collection/search/21964 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 17629 | 17629 | 11.89.2 | 0 | 1 | 22135 | Arms and Armor 5 | Cup-hilted rapier 1322 | Cup-Hilted Rapier | Italian, Milan 120 | Sword maker 95 | Cup signed | Carlo Piccinino | Italian, Milan, active ca. 1650–75 | Piccinino, Carlo 2708 | Italian 6 | 1625 | 1700 | ca. 1650–75 | 1625 | 1700 | Steel, iron 3611 | L. 44 in. (111.8 cm); L. of blade 37 1/4 in. (94.6 cm); W. 12 1/16 in. (30.6 cm); Wt. 2 lb. 5 oz. (1048.9 g) | Gift of J. Pierpont Morgan, 1911 | Milan 420 | Swords 29 | http://www.metmuseum.org/art/collection/search/22135 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 19459 | 19459 | 36.25.1751a, b | 0 | 0 | 23983 | Arms and Armor 5 | Blade and mounting for a sword (Katana) 1284 | Blade and Mounting for a Sword (Katana) | Japanese 35 | Swordsmith 92 | Blade inscribed by | Tadahiro (second generation) | Japanese, active mid-17th century | Tadahiro (second generation) 2824 | Japanese 74 | 1625 | 1675 | blade, dated 1632; mounting, 19th century | 1632 | 1900 | Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), dark red copper (hiirodō) 4015 | L. 38 in. (96.5 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 | Saga Prefecture 104 | Swords 29 | http://www.metmuseum.org/art/collection/search/23983 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 17463 | 17463 | 04.3.163 | 0 | 1 | 21965 | Arms and Armor 5 | Wheellock rifle 1341 | Wheellock Rifle | Silesian, Cieszyn 129 | Gunsmith 96 | Johannes Hartel | Polish, Cieszyn (Silesian), active ca. 1650 | Hartel, Johannes 2690 | Polish, Cieszyn (Silesian) 78 | 1625 | 1675 | ca. 1650–60 | 1625 | 1685 | Steel, silver, wood (red beech), staghorn, mother of pearl 3527 | L. 42 3/4 in. (108.6 cm); Cal. 17/32 in. (13.5 mm); L. of barrel 30 7/8 in. (78.4 cm); L. of trigger 8 1 4/ in. (21 cm); Wt. 7 lb. 11 oz. (3500 g) | Rogers Fund, 1904 | Cieszyn 427 | Firearms-Guns-Wheellock 50 | http://www.metmuseum.org/art/collection/search/21965 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 17606 | 17606 | 09.210.2 | 0 | 1 | 22110 | Arms and Armor 5 | Basket-hilted sword 1329 | Basket-hilted Sword | hilt, British; blade, German 160 | Bladesmith 100 | Blade by | Johannes Wundes the Younger | Germany, Solingen, active mid-17th century | Wundes the Younger, Johannes 2705 | Germany 81 | 1625 | 1675 | blade dated 1662 | 1662 | 1662 | Steel, wood, silver 3496 | L. 39 7/8 in. (101.3 cm); L. of blade 34 1/4 in. (87 cm); W. 5 in. (12.7 cm); Wt. 2 lb. 6 oz. (1077 g) | Rogers Fund, 1909 | Swords 29 | http://www.metmuseum.org/art/collection/search/22110 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 18521 | 18521 | 28.100.4 | 0 | 0 | 23043 | Arms and Armor 5 | Rapier 1321 | Rapier | German 27 | Bladesmith 100 | Peter Tesche | German, Solingen, active mid-17th century | Tesche Peter 2780 | German/Solingen 90 | 1625 | 1675 | ca. 1600–10 | 1575 | 1635 | Steel, copper, wood 3861 | L. 43 1/2 in. (110.5 cm); L. of blade 37 in. (94 cm); Wt. 2 lb. 8 oz. (1134 g) | Gift of Prince Albrecht Radziwill, by exchange, 1928 | Swords 29 | http://www.metmuseum.org/art/collection/search/23043 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");