Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Object Name, Title, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21910 | 21910 | 36.25.2148 | 0 | 1 | 26752 | Arms and Armor 5 | Miquelet gun 1919 | Miquelet Gun | Balkan 519 | 18th century | 1700 | 1799 | Wood, steel, brass, niello, silver, mother-of-pearl, coral, turquoise, sapphire, ruby 4844 | L. 62 3/4 in. (159.4 cm) | Bequest of George C. Stone, 1935 | Firearms-Guns-Miquelet 100 | http://www.metmuseum.org/art/collection/search/26752 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 23970 | 23970 | 43.82.5 | 0 | 0 | 29000 | Arms and Armor 5 | Miquelet gun 1919 | Miquelet Gun of Ali Pasha | Balkan 519 | late 18th–early 19th century | 1750 | 1850 | Steel, wood, silver, horn, brass, bone, mother-of-pearl, paste ivory, coral 5399 | L. 66 1/2 in. (168.9 cm) | Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943 | Firearms-Guns 52 | http://www.metmuseum.org/art/collection/search/29000 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 25349 | 25349 | 36.25.2205 | 0 | 0 | 30500 | Arms and Armor 5 | Miquelet gun 1919 | Miquelet Gun | Balkan 519 | 18th century | 1701 | 1800 | Wood, steel, silver, brass, mother-of-pearl 5741 | L. 48 1/2 in. (123.2 cm) | Bequest of George C. Stone, 1935 | Firearms-Guns-Miquelet 100 | http://www.metmuseum.org/art/collection/search/30500 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 25383 | 25383 | 36.25.2260 | 0 | 0 | 30535 | Arms and Armor 5 | Flintlock pistol 2301 | Flintlock Pistol | Balkan 519 | 18th century | 1701 | 1800 | Steel, silver, gold 3810 | L. 22 3/4 in. (57.8 cm); L. of barrel 12 in. (30.5 cm); Cal. .58 in (14.7 mm); Wt. 2 lb. 12.7 oz. (1267.2 g) | Bequest of George C. Stone, 1935 | Firearms-Pistols-Flintlock 41 | http://www.metmuseum.org/art/collection/search/30535 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 25385 | 25385 | 36.25.2262 | 0 | 0 | 30537 | Arms and Armor 5 | Flintlock pistol 2301 | Flintlock Pistol | Balkan 519 | 18th–19th century | 1701 | 1900 | Steel, silver, niello 4038 | L. 19 1/2 in. (49.5 cm); L. of barrel 12 1/2 in. (31.8 cm); Cal. .64 in (16.3 mm); Wt. 2 lb. 4.7 oz. (1040.4 g) | Bequest of George C. Stone, 1935 | Firearms-Pistols-Flintlock 41 | http://www.metmuseum.org/art/collection/search/30537 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 25393 | 25393 | 36.25.2270 | 0 | 0 | 30545 | Arms and Armor 5 | Flintlock pistol 2301 | Flintlock Pistol | Balkan 519 | 18th century | 1701 | 1800 | Steel, gold, silver, coral 5761 | L. 19 3/8 in. (49.2 cm); L. of barrel 12 3/4 in. (32.4 cm); Cal. .59 in (15 mm); Wt. 2 lb. 5.7 oz. (1068.8 g) | Bequest of George C. Stone, 1935 | Firearms-Pistols-Flintlock 41 | http://www.metmuseum.org/art/collection/search/30545 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 25455 | 25455 | 36.25.2166 | 0 | 0 | 30607 | Arms and Armor 5 | Miquelet gun 1919 | Miquelet Gun | Balkan 519 | 18th century | 1701 | 1800 | Wood, steel, mother-of-pearl, brass 5798 | L. 57.8 in. (146.7 cm) | Bequest of George C. Stone, 1935 | Firearms-Guns-Miquelet 100 | http://www.metmuseum.org/art/collection/search/30607 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 25661 | 25661 | 36.25.1832 | 0 | 0 | 30813 | Arms and Armor 5 | Axe 2349 | Axe | Balkan 519 | 17th century | 1601 | 1700 | Wood, steel, silver 3883 | Bequest of George C. Stone, 1935 | Shafted Weapons 35 | http://www.metmuseum.org/art/collection/search/30813 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
| 27138 | 27138 | 32.75.108 | 0 | 0 | 32294 | Arms and Armor 5 | Flintlock blunderbuss 2158 | Flintlock Blunderbuss | Balkan 519 | 18th century | 1701 | 1800 | Wood (walnut), steel, brass, silver foil, gilding 6551 | L. overall 29 3/4 in (75.6 cm).; L. of barrel 18 1/8 in (46 cm).; Cal. .65 in.(16.5 mm) flaring at muzzle to 1.26 (3.2 cm); Wt. 4 lbs (1814.4 g) | The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932 | Firearms-Guns-Flintlock 117 | http://www.metmuseum.org/art/collection/search/32294 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 27576 | 27576 | 26.35.4a, b | 0 | 1 | 32740 | Arms and Armor 5 | Dagger (Yatagan) with sheath 3467 | Dagger (Yatagan) with Sheath | Balkan 519 | 18th century | 1701 | 1800 | Steel, ivory, silver, carnelian, ruby 6684 | H. with sheath 17 1/4 in. (43.8 cm); H. without sheath 15 5/16 in. (38.9 cm); H. of blade 10 5/8 in. (27 cm); W. 2 9/16 in. (6.5 cm); D. 1 1/16 in. (2.7 cm); Wt. 11.4 oz. (323.2 g); Wt. of sheath 10.2 oz (289.2 g) | Bequest of Richard B. Seager, 1926 | Daggers 33 | http://www.metmuseum.org/art/collection/search/32740 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 28172 | 28172 | 19.53.116 | 0 | 0 | 33351 | Arms and Armor 5 | Powder horn and spanner 3555 | Powder Horn and Spanner | Balkan 519 | 17th–18th century | 1601 | 1800 | Horn, steel 6211 | L. 7 3/8 in. (18.7 cm); D. 1 3/4 in. (4.5 cm); Wt. 9.5 oz. (269.3 g) | Gift of Charles M. Schott Jr., 1917 | Firearms Accessories-Powder Horns 51 | http://www.metmuseum.org/art/collection/search/33351 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 28864 | 28864 | 29.158.636 | 0 | 0 | 34063 | Arms and Armor 5 | Sheath for a Balkan Dagger 3661 | Sheath for a Balkan Dagger | Balkan 519 | 19th century | 1800 | 1900 | Wood, bronze, brass 6934 | L. 17 1/2 in. (44.5 cm); W. 2 5/8 in. (6.7 cm); Wt. 6.7 oz. (189.9 g) | Bashford Dean Memorial Collection, Funds from various donors, 1929 | Daggers 33 | http://www.metmuseum.org/art/collection/search/34063 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
| 327247 | 327247 | 34.28 | 0 | 1 | 467609 | Medieval Art 6 | Flask with handles 14824 | Flask with Handles | Balkan 519 | 15th–16th century | 1400 | 1600 | Pewter 104 | Overall: 12 11/16 x 9 3/16 x 6 1/4 in. (32.2 x 23.3 x 15.8 cm) | Rogers Fund, 1934 | Metalwork-Pewter 19 | http://www.metmuseum.org/art/collection/search/467609 | 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");