Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Culture, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19905 | 19905 | 36.25.1965a, b | 0 | 0 | 24430 | Arms and Armor 5 | Blade and mounting for a spear (Katakama-yari) 2126 | Blade and Mounting for a Spear (Katakama-yari) | Japanese 35 | Blade, late 18th century; mounting, late 18th century | 1750 | 1800 | Steel, wood (oak) 4171 | L. 32 5/8 in. (82.8 cm); L. of cutting edge 5 5/16 in. (13.5 cm) | Bequest of George C. Stone, 1935 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/24430 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 20313 | 20313 | 57.166.2a–e | 0 | 1 | 24842 | Arms and Armor 5 | Percussion revolver with case and accessories 2255 | Colt Model 1855 Pocket Percussion Revolver, Serial no. 4460, with Case and Accessories | American, Hartford, Connecticut 350 | Manufacturer 20 | Samuel Colt | American, Hartford, Connecticut 1814–1862 | Colt, Samuel 2891 | American 1 | 1814 | 1862 | 1855 | 1855 | 1855 | Steel, wood (oak) 4171 | L. 7 7/8 in. (19.99 cm); L. of barrel 3 1/2 in. (8.89 cm); Cal. .28 in. (7 mm); case 9 3/8 x 5 3/4 x 1 7/8 in. (23.8 x 14.61 x 4.75 cm); L. of spanner-screwdriver 3 1/4 in. (8.26 cm); greatest W. of spanner-screwdriver 1 3/8 in. (3.48 cm); L. of primer 4 5/8 in. (11.73 cm); greatest W. of primer 2 in. (5.08 cm); L. of bullet mould 4 3/8 in. (11.1 cm) | Gift of John E. Parsons, 1957 | Hartford 26 | Connecticut 118 | Firearms-Pistols-Revolvers 133 | http://www.metmuseum.org/art/collection/search/24842 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 21025 | 21025 | 08.261.3 | 0 | 1 | 25625 | Arms and Armor 5 | Halberd 1309 | Halberd | German 27 | 16th century | 1501 | 1600 | Steel, wood (oak) 4171 | L. 95 1/4 in. (242.3 cm); L. of head 22 3/4 in. (57.8 cm); W. 10 1/4 in. (26 cm); Wt. 4 lb. 8 oz. (2040 g) | Rogers Fund, 1908 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/25625 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 21235 | 21235 | 14.25.35 | 0 | 1 | 25854 | Arms and Armor 5 | Halberd 1309 | Halberd | Swiss, Fribourg 461 | ca. 1375–1400 | 1350 | 1425 | Steel, wood (oak) 4171 | L. 84 1/4 in. (213.9 cm); L. of head 17 3/4 in. (45 cm); W. 8 1/8 in. (20.6 cm); Wt. 5 lb. 5 oz. (2409.7 g) | Gift of William H. Riggs, 1913 | Fribourg 187 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/25854 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
| 21251 | 21251 | 14.25.51 | 0 | 1 | 25898 | Arms and Armor 5 | Halberd 1309 | Halberd | German 27 | late 15th century | 1450 | 1500 | Steel, wood (oak) 4171 | L. 81 3/8 in. (206.6 cm); L. of head 16 in. (40.6 cm); W. 8 3/4 in. (22.2 cm); Wt. 4 lbs. 12 oz. (2154.6 g) | Gift of William H. Riggs, 1913 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/25898 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 21880 | 21880 | 14.25.302 | 0 | 1 | 26720 | Arms and Armor 5 | Pollaxe 2356 | Pollaxe | French, Burgundy 517 | ca. 1450 | 1425 | 1475 | Steel, wood (oak) 4171 | L. 81 7/8 in. (208 cm); L. of head 12 1/2 in. (31.8 cm); W. 8 1/4 in. (21 cm); Wt. 5 lbs. 7 oz. (2466.4 g) | Gift of William H. Riggs, 1913 | Burgundy 211 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/26720 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
| 22174 | 22174 | 14.25.465 | 0 | 0 | 27066 | Arms and Armor 5 | War hammer 2352 | War Hammer | Italian 36 | 15th century | 1401 | 1500 | Steel, wood (oak) 4171 | L. 79 7/8 in. (202.9 cm); L. of head 8 1/2 in. (21.6 cm); W. 9 5/8 in. (24.5 cm); Wt. 7 lbs. 8 oz. (2608.2 g) | Gift of William H. Riggs, 1913 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/27066 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 22585 | 22585 | 52.208.8 | 0 | 1 | 27496 | Arms and Armor 5 | Halberd 1309 | Halberd | Swiss 54 | possibly mid–15th century | 1400 | 1500 | Steel, wood (oak) 4171 | L. 80 3/4 in. (205 cm); L. of head 14 1/8 in. (35.8 cm); W. 7 5/8 in. (19.4 cm); Wt. 5 lbs. 8 oz. (2490 g) | Gift of Alan Rutherfurd Stuyvesant, 1952 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/27496 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 22610 | 22610 | 54.46.17 | 0 | 1 | 27521 | Arms and Armor 5 | Halberd 1309 | Halberd | German 27 | early 16th century | 1500 | 1550 | Steel, wood (oak) 4171 | L. 89 1/4 in. (226.6 cm); L. of head 18 3/8 in. (46.6 cm); W. 9 1/2 in. (24.1 cm); Wt. 4 lbs. 13 oz. (2180 g) | Bequest of Alan Rutherfurd Stuyvesant, 1954 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/27521 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 22723 | 22723 | 49.120.11 | 0 | 1 | 27640 | Arms and Armor 5 | Halberd 1309 | Halberd | German 27 | 15th century | 1401 | 1500 | Steel, wood (oak) 4171 | L. 84 3/4 in. (215.2 cm); L. of head 16 in. (40.6 cm); W. 7 in. (17.8 cm); Wt. 5 lbs. 13 oz. (2640 g) | Gift of Mrs. Bashford Dean, in memory of Alexander McMillan Welch, 1949 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/27640 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 23982 | 23982 | 42.50.20 | 0 | 1 | 29012 | Arms and Armor 5 | Halberd 1309 | Halberd | Swiss 54 | ca. 1510–20 | 1485 | 1545 | Steel, wood (oak) 4171 | L. 75 in. (190.4 cm); L. of head 16 7/8 in. (42.8 cm); W. 10 3/8 in. (26.3 cm); Wt. 6 lbs. 1 oz. (2750 g) | Gift of Stephen V. Grancsay, 1942 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/29012 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 24570 | 24570 | 37.189.6 | 0 | 1 | 29610 | Arms and Armor 5 | Halberd 1309 | Halberd | German 27 | 17th century | 1601 | 1700 | Steel, wood (oak) 4171 | L. 88 1/2 in. (224.8 cm); L. of head 20 in. (50.8 cm); W. 10 1/2 in. (26.7 cm); Wt. 4 lbs. 15.7 oz. (2259.5 g) | Gift of Christian A. Zabriskie, 1937 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/29610 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 27196 | 27196 | 32.75.194 | 0 | 1 | 32352 | Arms and Armor 5 | Halberd 1309 | Halberd | German 27 | early 16th century | 1500 | 1550 | Steel, wood (oak) 4171 | L. 84 7/8 in. (215.5 cm); L. of head 17 3/8 in. (44.1 cm); W. 10 1/2 in. (26.6 cm); Wt. 5 lbs. 2 oz. (2320 g) | The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/32352 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 27609 | 27609 | 25.188.2 | 0 | 1 | 32775 | Arms and Armor 5 | Saber-Halberd 3477 | Saber-Halberd | German, Munich 128 | probably 19th century | 1775 | 1925 | Steel, wood (oak) 4171 | L. 8 ft. 10 1/4 in. (269.9 cm); L. of head 42 in. (106.7 cm); W. 7 7/8 in. (20 cm); Wt. 7 lbs. 8 oz. (3401.9 g) | Gift of George D. Pratt, 1925 | Munich 426 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/32775 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
| 28567 | 28567 | 14.25.1593 | 0 | 0 | 33756 | Arms and Armor 5 | Crossbow bolt 1943 | Crossbow Bolt | European 12 | 16th century | 1501 | 1600 | Steel, wood (oak) 4171 | Gift of William H. Riggs, 1913 | Archery Equipment 95 | http://www.metmuseum.org/art/collection/search/33756 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
| 28571 | 28571 | 14.25.1597 | 0 | 0 | 33760 | Arms and Armor 5 | Crossbow bolt 1943 | Crossbow Bolt with Chisel Head | European, possibly German 1174 | probably late 16th or early 17th century | 1525 | 1675 | Steel, wood (oak) 4171 | L. 17 1/4 in. (43.8 cm); W. head 1 13/16 in. (4.6 cm); Wt. 2.6 oz. (73 g) | Gift of William H. Riggs, 1913 | Archery Equipment 95 | http://www.metmuseum.org/art/collection/search/33760 | 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");