Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17421 | 17421 | 04.3.267–.269 | 0 | 0 | 21923 | Arms and Armor 5 | Half-armor (Composed) 1315 | Half-Armor (Composed) | German 27 | dated 1562 (helmet ca. 1560) | 1562 | 1562 | Steel, leather, copper alloy 3495 | Helmet (04.3.267a); H. 14 3/4 in. (37.5 cm); W. 9 1/8 in. (23.2 cm); D. 13 1/4 in. (33.7 cm); Wt. 11 lb. 3.1 oz. (5077.4 g); Wt. overall 44 lbs. (19.96 kg) | Rogers Fund, 1904 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/21923 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
17494 | 17494 | 04.3.270a–o | 0 | 1 | 21996 | Arms and Armor 5 | Half armor 1363 | Half Armor Probably Made for Don Gonzalo Fernández de Córdoba y Fernández de Córdoba, Duke of Sessa (1520/1524–1578) | Italian, Milan 120 | Armorer 98 | Attributed to | Lucio Piccinino | Italian, Milan, active ca. 1575–90 | Piccinino, Lucio 2697 | Italian 6 | 1550 | 1615 | ca. 1560 and later | 1535 | 1900 | Steel, gold 3497 | Wt. approx. 30 lb. 7 oz. (13.8 kg); Wt. of helmet approx. 7 lb. 11 oz. ( | Rogers Fund, 1904 | Milan 420 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/21996 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
17675 | 17675 | 14.25.714a–h, j | 0 | 1 | 22184 | Arms and Armor 5 | Armor 1320 | Armor of the Dukes of Alba | Italian, Milan 120 | Armorer 98 | Lucio Piccinino | Italian, Milan, active ca. 1575–90 | Piccinino, Lucio 2697 | Italian 6 | 1550 | 1615 | ca. 1575–85 | 1550 | 1610 | Steel, gold, silver 3516 | Wt. 25 lbs. 12 oz. (11.68 kg); Helmet (a) H. 12 in. (30.5 cm); W. 8 1/2 in. (21.6 cm); D. 11 1/2 in. (29.2 cm); Wt. 5 lbs. 1 oz. (2,296.31 g); Colletin (b) H. 7 in. (17.8 cm); W. 11 7/16 in. (29.1 cm); Wt. 2 lbs. 2 oz. (963.88 g); Breastplate (c) H. 18 1/8 in. (46.0 cm); W. 15 in. (38.1 cm); D. 7 7/8 in. (19.9 cm); Wt. 5 lbs. 4 oz (2,381.36 g); Backplate (d) H. 14 5/8 in. (37.2 cm); W. 14 5/8 in. (37.2 cm); Wt. 3 lbs. 3 oz. (1,445.83 g); Pauldron right (e) H. 10 1/2 in. (26.7 cm); W. 11 5/8 in. (29.5 cm); Wt. 2 lbs. 9 oz. (1,162.33 g); Pauldron left (f) H. 10 3/8 in. (26.4 cm); W. 11 in. (27.9 cm); Wt. 2 lbs. 12 oz. (1,247.38 g); Arm Defense right (g) L. 18 1/2 in. (46.9 cm); Wt. 2 lbs. 7 oz. (1,105.63 g); Arm Defense left (h) L. 18 1/4 in. (46.4 cm); Wt. 2 lbs. 6 oz. (1,077.28 g) | Gift of William H. Riggs, 1913 | Milan 420 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22184 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
17735 | 17735 | 14.25.666a–i | 0 | 0 | 22244 | Arms and Armor 5 | Half armor 1363 | Half Armor | French 7 | ca. 1660 and later | 1635 | 1900 | Steel, leather, textile 3492 | Wt. 47 lb. 14 oz. (21.72 kg); Wt. of helmet 5 lb. 7 oz. (2466 g) | Gift of William H. Riggs, 1913 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22244 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
17739 | 17739 | 14.25.679a–j | 0 | 1 | 22248 | Arms and Armor 5 | Composed half armor 1472 | Composed Half Armor | German 27 | ca. 1540 and later | 1515 | 1900 | Steel, copper alloy, leather 3630 | Wt. 58 lb. (26.31 kg); Wt. of helmet 4 lb. 3 oz. (1899.4 g) | Gift of William H. Riggs, 1913 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22248 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
17740 | 17740 | 14.25.682b–j | 0 | 0 | 22250 | Arms and Armor 5 | Half armor 1363 | Half Armor | Italian 36 | ca. 1570 | 1545 | 1595 | Steel, leather 3500 | Wt. 22 lb 11 oz. (10.29 kg) | Gift of William H. Riggs, 1913 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22250 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
17741 | 17741 | 14.25.684a–i | 0 | 1 | 22251 | Arms and Armor 5 | Half armor 1363 | Half Armor | German, Nuremberg 147 | Armorer 98 | Attributed to | Martin Schneider the Younger | German, Nuremberg, active ca. 1610–20 | Schneider the Younger, Martin 2717 | German 10 | 1610 | 1620 | 1610–20 | 1610 | 1620 | Steel 658 | Wt. 41 lb. 15 oz. (19.01 kg) | Gift of William H. Riggs, 1913 | Nuremberg 149 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22251 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
17749 | 17749 | 14.25.699a–g | 0 | 0 | 22260 | Arms and Armor 5 | Half armor 1363 | Half Armor | German 27 | ca. 1560 and later; restoration of decoration, 19th century | 1535 | 1900 | Steel, leather 3500 | Wt. 29 lb. 5 oz. (13.3 kg); Wt. of helmet 4 lb. 9 oz. (2069.5 g) | Gift of William H. Riggs, 1913 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22260 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
17751 | 17751 | 14.25.701 | 0 | 1 | 22262 | Arms and Armor 5 | Half armor 1363 | Half Armor | German 27 | ca. 1500 and 19th century | 1475 | 1900 | Steel, leather 3500 | Wt. approx. 44 lb. 10 oz. (20.25 kg); Wt. of helmet approx. 7 lb. 4 oz. (3300 g) | Gift of William H. Riggs, 1913 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22262 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
17758 | 17758 | 14.25.710a–f | 0 | 1 | 22269 | Arms and Armor 5 | Armor 1320 | Armor of Giovanni Battista Bourbon del Monte (1541–1614) | Italian, possibly Brescia 180 | ca. 1590 | 1565 | 1615 | Steel, gold, textile, leather 3635 | Wt. of helmet 4 lb. 12 oz. (2155 g) | Gift of William H. Riggs, 1913 | possibly Brescia 444 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22269 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
17759 | 17759 | 14.25.711a–d | 0 | 1 | 22270 | Arms and Armor 5 | Armor 1320 | Armor | Northern German, possibly Brunswick-Wölfenbüttel 181 | ca. 1560–65 | 1535 | 1590 | Steel, leather 3500 | Wt. 28 lb. 14 oz. (13.1 kg); helmet: Wt. 5 lb. 10 oz. (2551 g); breastplate: Wt.10 lb. 15oz. (4961 g) | Gift of William H. Riggs, 1913 | possibly Brunswick-Wölfenbüttel 445 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22270 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
17761 | 17761 | 14.25.713a–n | 0 | 1 | 22272 | Arms and Armor 5 | Half armor 1363 | Half Armor | probably Austrian, Innsbruck 182 | ca. 1560 and later | 1560 | 1900 | Steel, leather 3500 | Wt. 37 lb. 5 oz. (16.92 kg); Wt. of helmet 5 lb. 7 oz. (2466.4 g) | Gift of William H. Riggs, 1913 | probably Innsbruck 446 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22272 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
17764 | 17764 | 14.25.716b–f | 1 | 1 | 22275 | Arms and Armor 5 | Elements of a light-cavalry armor 1484 | Elements of a Light-Cavalry Armor | Italian, Milan 120 | ca. 1510 | 1485 | 1535 | Steel, gold, copper alloy 3533 | Wt. 19 lb. 13 oz. (8987 g) | Gift of William H. Riggs, 1913 | Milan 420 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22275 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
17768 | 17768 | 14.25.720 | 0 | 1 | 22279 | Arms and Armor 5 | Infantry armor 1486 | Infantry Armor | German, Nuremberg 147 | ca. 1600 | 1575 | 1625 | Steel, leather 3500 | H. 49 1/14 in. (125 cm) | Gift of William H. Riggs, 1913 | Nuremberg 149 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22279 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
17992 | 17992 | 14.100.120a–g | 0 | 1 | 22505 | Arms and Armor 5 | Armor (Dō-maru) 1589 | Armor (Dō-maru) | Japanese 35 | armor, ca. 1550; helmet, 18th century | 1525 | 1800 | Iron, leather, lacquer, silk, gilt copper 3688 | H. 35 1/2 in. (90.2 cm); Wt. of helmet 8 lb. 6 oz. (3799 g); Wt. of cuirass 23 lb. 9 oz. (10.7 kg) | Gift of Bashford Dean, 1914 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22505 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
18110 | 18110 | 16.154.3a–l | 0 | 1 | 22628 | Arms and Armor 5 | Half armor 1363 | Half Armor | Italian 36 | ca. 1600; cheekplates of helmet and part of left gauntlet thumb, probably 19th century | 1575 | 1900 | Steel, brass 323 | Wt. approx. 25 lb. 14 oz. (11.74 kg); Wt. of helmet 3 lb. 5 oz. (1502.5 g) | Rogers Fund, 1916 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22628 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
18111 | 18111 | 16.154.2a–l | 0 | 1 | 22629 | Arms and Armor 5 | Infantry armor 1486 | Infantry Armor | Italian 36 | Armorer 98 | Upper plate of the gorget, skirt lames, and cheek pieces made by | Daniel Tachaux | French, 1857–1928, active in France and America | in the Metropolitan Museum of Art, Armor Workshop | Tachaux, Daniel 2678 | 1857 | 1928 | dated 1571; upper plate of the gorget, skirt lames, and cheek pieces, 1917 | 1571 | 1917 | Steel, leather, brass 3756 | Wt. 33 lb. 11 oz. (15.28 kg) | Rogers Fund, 1916 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/22629 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
18492 | 18492 | 27.183.93 | 0 | 1 | 23014 | Arms and Armor 5 | Elements of a half armor 1788 | Elements of a Half Armor | German, Nuremberg 147 | 16th century and later | 1501 | 1900 | Steel 658 | Wt. 31 lb. 14 oz. (14.46 kg); Wt. of helmet 5 lb. 5 oz. (2409.7 g) | Gift of Prince Albrecht Radziwill, 1927 | Nuremberg 149 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/23014 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
18494 | 18494 | 27.206a–l | 0 | 1 | 23016 | Arms and Armor 5 | Foot-combat armor 1790 | Foot-Combat Armor of Prince-Elector Christian I of Saxony (reigned 1586–91) | German, Augsburg 126 | Armorer|Decorator 117 | Decoration attributed to | Anton Peffenhauser|Jörg Sorg the Younger | German, Augsburg, 1525–1603|German, Augsburg, ca. 1522–1603 | Peffenhauser, Anton|Sorg the Younger, Jörg 2778 | German|German 79 | 1525 |1500 | 1603 |1625 | 1591 | 1591 | 1591 | Steel, gold, leather, copper alloy 3645 | H. 38 11/16 in. (98.2 cm); Wt. 46 lb. 3 oz. (20.96 kg); helmet Wt. 11 lb. 9 oz. (5245 g) | Gift of Henry Walters, 1927 | Augsburg 424 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/23016 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
18568 | 18568 | 29.150.6 | 0 | 1 | 23090 | Arms and Armor 5 | Half armor 1363 | Half Armor | German, Augsburg 126 | Armorer 98 | Helmet and reinforcing pieces attributed to | Kolman Helmschmid | German, Augsburg 1471–1532 | Helmschmid, Kolman 2700 | German 10 | 1471 | 1532 | ca. 1510–20 and later | 1485 | 1545 | Steel 658 | as mounted, H. 37 in. (94 cm) | Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928 | Augsburg 424 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/23090 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
20287 | 20287 | 50.237.1a–e, h–i | 0 | 1 | 24816 | Arms and Armor 5 | Portions of a ceremonial armor 2250 | Portions of a Ceremonial Armor | French 7 | ca. 1575–80 | 1550 | 1605 | Steel, copper alloy, gold, leather, textile 4333 | Wt.. Overall 17 lb. 7 oz. (7910 g); Wt. of Helmet (a), 4 lbs. 13 oz. (2182.91 g); Wt. of Breastplate (b), 2 lbs. 14 oz. (1304.08 g); Wt. of Tassets (c-d), 2 lbs. 1 oz. (935.53 g); Wt. of Backplate (e), 3 lbs. 1 oz. (1389.13 g); Wt. of Arms (f-g), 2 lbs. 7 oz. (1105.63 g); Wt. of Gauntlets (h-i), 1 lb. (453.59 g) | Gift of Alan Rutherfurd Stuyvesant, 1950 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/24816 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
20412 | 20412 | 1991.4 | 0 | 1 | 24945 | Arms and Armor 5 | Elements of a light-cavalry armor 1484 | Elements of a Light-Cavalry Armor | Austrian, Innsbruck or Mühlau 214 | Armorer 98 | Christian Schreiner the Younger | Austrian, Mühlau, recorded 1499–1528 | Schreiner the Younger, Christian 2924 | Austrian 66 | 1499 | 1528 | ca. 1505–10 | 1480 | 1535 | Steel, leather 3500 | H. as mounted approximately 32 in. (81.28 cm); Wt. 21 lb. 7 oz. (9724 g) | Purchase, Mr. and Mrs. Arthur Ochs Sulzberger Gift, in honor of Helmut Nickel, 1991 | Innsbruck 433 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/24945 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
27045 | 27045 | 04.3.282 | 0 | 1 | 32198 | Arms and Armor 5 | Portions of an armor garniture 1474 | Portions of an Armor Garniture | German, Augsburg 126 | Etcher 104 | Jörg Sorg the Younger | German, Augsburg, ca. 1522–1603 | Sorg the Younger, Jörg 2971 | German 10 | 1500 | 1625 | ca. 1550–55, some etched decoration, 19th century | 1525 | 1900 | Steel, gold, leather, velvet 6521 | Rogers Fund, 1904 | Augsburg 424 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/32198 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
30259 | 30259 | 50.237.1a–e, h–i; 29.150.11g–h | 0 | 1 | 35824 | Arms and Armor 5 | Portions of a ceremonial armor 2250 | Portions of a Ceremonial Armor | French 7 | ca. 1575–80 | 1550 | 1605 | Steel, copper alloy, gold, leather, textile 4333 | Wt. 17 lb. 7 oz. (7910 g) | armor: Gift of Alan Rutherfurd Stuyvesant, 1950; mail sleeves: Bashford Dean Memorial Collection, Bequest of Bashford Dean, 1928 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/35824 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
30269 | 30269 | 14.100.120a, b | 0 | 1 | 35841 | Arms and Armor 5 | Helmet (Hoshi kabuto) 1572 | Helmet (Hoshi Kabuto) | Japanese 35 | 18th century | 1701 | 1800 | Iron, lacquer, gilt copper, leather, silk 3779 | Wt. 8 lb. 6 oz. (3799 g) | Gift of Bashford Dean, 1914 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/35841 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
30322 | 30322 | 29.156.67b–g, j–q | 0 | 1 | 35919 | Arms and Armor 5 | Portions of a jousting half armor 3872 | Portions of a Jousting Half Armor | German 27 | ca. 1500 and later | 1475 | 1900 | Steel, leather 3500 | Wt. 48 lb. 13 oz. (22.14 kg); mail sleeve (29.156.67o): L. 27 5/8 in. (70 cm); W. 13 in. (33 mm.); Diam. (outside) of links 13/32 in. (10.5 mm.); Diam. (inside) of links 5/16 in. (7.9 mm); Diam. (outside) of earlier solid links 7/16 in. (10.7 mm); Diam. (inside) of earlier solid links 1/4 in. (6.5 mm); Diam. (outside) of riveted links 13/32 in. (10.5 mm); Diam. (inside) of riveted links 9/32 in. (7.4 mm); mail sleeve (29.156.67p): L. 22 in. (56 cm); W. 13 in. (33 cm); Diam. (outside) of links 13/32 in. (10.7 mm); Diam. (inside) of links 9/32 in. (7.2 mm). | Bashford Dean Memorial Collection, Gift of Edward S. Harkness, 1929 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/35919 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
393325 | 393325 | 14.100.120c–g | 0 | 1 | 645797 | Arms and Armor 5 | Cuirass of a Dō-maru 1583 | Cuirass of a Dō-maru | Japanese 35 | ca. 1550 | 1525 | 1575 | Iron, leather, lacquer, silk, gilt copper 3688 | H. 35 1/2 in. (90.2 cm); W. 22 in. (55.9 cm); Wt. 23 lb. 9 oz. (10.7 kg) | Gift of Bashford Dean, 1914 | Armor for Man-1/2 Armor 40 | http://www.metmuseum.org/art/collection/search/645797 | 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");