MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

29 rows where Classification = 171

View and edit SQL

Suggested facets: Object Name, Title, Culture, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line

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
30185 2011.90 0 1 35705 Arms and Armor 5 Mezzotint 3817 George Wallis, The Late Celebrated Antiquary and Gunsmith of Hull British 6         Engraver 137 Engraved by John Raphael Smith British, baptized Derby 1751–1812 Doncaster after a painting by John Harrison Smith, John Raphael 3132 British 7 1751 1812 June 20, 1804 1804 1804 Mezzotint on white wove paper 7196 Sheet: 17 3/4 x 14 7/8 in. (45 x 37.7 cm); plate: 15 x 11 in. (38 x 28 cm) Purchase, Arthur Ochs Sulzberger Gift, 2011                       Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
394252 2014.434 0 1 647195 Arms and Armor 5 Hand-colored engraving 26696 Ludi equestres. Das Thurnieren (The Tournament) German 27         Artist 2   Martin Engelbrecht German, Augsburg 1684–1756 Augsburg   Engelbrecht, Martin 24138 German 10 1684 1756 ca. 1730 1705 1755 Paper, ink, polychromy 58698 9 1/2 x 15 3/16 in. (241 x 385 mm) Purchase, Kenneth and Vivian Lam Gift, 2014                       Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
431324 2016.245 0 1 716365 Arms and Armor 5 Etching and engraving 27099 Design for a Rapier Hilt and Scabbard Chape French 7         Artist 2   Pierre Woeiriot de Bouzey II French, Neufchâteau 1532–1599 Damblain   de Bouzey, Pierre Woeiriot II 37531   1532 1599 1555 1555 1555 Etching, engraving 29387 Diam. 7 1/2 in. (19.1 cm) Purchase, Gift of Andrew Solomon, 2016                       Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
431395 2016.403.19 0 1 716437 Arms and Armor 5 Engraving 2616 Plate Three from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   De Lacollombe French, Paris, active ca. 1702–ca. 1736   Lacollombe, De 2906   1702 1736 ca. 1730 1705 1755 Engraving 7208 sheet: 8 x 6 3/8 in. (20.3 x 16.2 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
431670 2016.311 0 1 716772 Arms and Armor 5 Engraving 2616 Plate Six from Nouveavx Desseins D’Arquebvseries French 7         Engraver 137 Signed by Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 dated 1749 1749 1749 Engraving 7208 sheet: 11 7/8 x 9 in. (30.16 x 22.86 cm); plate: 9 1/8 x 6 3/8 in. (23.17 x 16.19 cm) Purchase, Michael H. Pourfar Gift, 2016                       Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
431672 2016.312 0 1 716774 Arms and Armor 5 Engraving 2616 Plate Ten from Nouveavx Desseins D’Arquebvseries French 7         Engraver 137 Signed by Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 dated 1744 1744 1744 Engraving 7208 sheet: 11 7/8 x 9 1/8 in. (30.16 x 23.17 cm); plate: 8 1/2 x 6 3/8 in. (21.59 x 16.19 cm) Purchase, Michael H. Pourfar Gift, 2016                       Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
432662 2016.409 0 1 718296 Arms and Armor 5 Plate five from Nouveavx Desseins D'Arquebvseries 27110 Plate Five from Nouveavx Desseins D'Arquebvseries French, Paris 114         Artist 2   De Lacollombe French, Paris, active ca. 1702–ca. 1736   Lacollombe, De 2906   1702 1736 dated 1730 1730 1730 Engraving 7208 sheet: 11 1/2 x 9 in. (29.2 x 22.9 cm); plate: 9 3/8 x 6 5/8 in. (23.8 x 16.8 cm) Purchase, Marica F. Vilcek Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434532 2016.403.1 0 1 722401 Arms and Armor 5 Engraving 2616 Plate One (Title Page) from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver|Engraver 1425   Gilles Demarteau|De Lacollombe French, Liège 1722–1776 Paris|French, Paris, active ca. 1702–ca. 1736   Demarteau, Gilles|Lacollombe, De 55295   1722 |1702 1776 |1736 dated 1730 1730 1730 Engraving 7208 sheet: 11 1/2 x 9 in. (29.2 x 22.9 cm); plate: 9 3/8 x 6 5/8 in. (23.8 x 16.8 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016                       Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434536 2016.403.2 0 1 722405 Arms and Armor 5 Engraving 2616 Plate Two from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   De Lacollombe French, Paris, active ca. 1702–ca. 1736   Lacollombe, De 2906   1702 1736 dated 1730 1730 1730 Engraving 7208 sheet: 11 7/8 x 9 in. (30.2 x 22.9 cm); plate: 9 3/8 x 6 5/8 (23.8 x 16.8 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434537 2016.403.3 0 1 722406 Arms and Armor 5 Engraving 2616 Plate Four from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   De Lacollombe French, Paris, active ca. 1702–ca. 1736   Lacollombe, De 2906   1702 1736 ca. 1730 1705 1755 Engraving 7208 sheet: 11 3/4 x 9 1/8 in. (29.8 x 23.2 cm); plate: 9 1/4 x 6 5/8 in. (23.5 x 16.8 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434540 2016.403.4 0 1 722409 Arms and Armor 5 Engraving 2616 Plate Seven from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   De Lacollombe French, Paris, active ca. 1702–ca. 1736   Lacollombe, De 2906   1702 1736 ca. 1730 1705 1755 Engraving 7208 sheet: 12 x 9 in. (30.5 x 22.9 cm); plate: 9 3/8 x 6 3/8 in. (23.8 x 16.2 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434542 2016.403.5 0 1 722411 Arms and Armor 5 Engraving 2616 Plate Eight from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 dated 1743 1743 1743 Engraving 7208 sheet: 11 7/8 x 9 1/16 in. (30.2 x 23 cm); plate: 7 7/16 x 5 1/4 in. (18.9 x 13.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434545 2016.403.6 0 1 722414 Arms and Armor 5 Engraving 2616 Plate Nine from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 dated 1743 1743 1743 Engraving 7208 sheet: 11 3/4 x 9 1/8 in. (29.8 x 23.2 cm); plate: 7 1/4 x 5 1/4 in. (18.4 x 13.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434548 2016.403.7 0 1 722417 Arms and Armor 5 Engraving 2616 Plate Eleven from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 ca. 1749 1724 1774 Engraving 7208 sheet: 11 1/2 x 9 1/4 in. (29.2 x 23.5 cm); plate: 8 7/16 x 6 7/16 in. (21.4 x 16.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434551 2016.403.8 0 1 722420 Arms and Armor 5 Etching and engraving 27099 Design of a Flintlock, Side Plate, Butt Plate, and Trigger Guard, unnumbered plate from Nouveaux Desseins d'Arquebuserie Inventez et Gravez par Le Sr. Gillot French, Paris 114         Engraver 137   Claude Gillot French, Langres 1673–1722 Paris   Gillot, Claude 17909   1673 1722 ca. 1715 1690 1740 Etching, engraving 29387 Sheet: 9 5/8 x 6 9/16 in. (24.4 x 16.6 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434593 2016.403.9 0 1 722489 Arms and Armor 5 Engraving 2616 Plate One from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Publisher|Engraver 3909   Le Hollandois|Thuraine|C. Jacquinet French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Hollandois, Le|Thuraine|Jacquinet, C. 55308   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 x 5 in. (17.8 x 12.7 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434599 2016.403.10 0 1 722495 Arms and Armor 5 Engraving 2616 Plate Two from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Publisher|Engraver 3909   Le Hollandois|Thuraine|C. Jacquinet French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Hollandois, Le|Thuraine|Jacquinet, C. 55308   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 7/8 x 5 3/4 in. (20 x 14.6 cm); plate: 7 7/16 x 5 5/16 in. (18.9 x 13.5 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434601 2016.403.11 0 1 722497 Arms and Armor 5 Engraving 2616 Plate Three from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Engraver|Publisher|Publisher 4735   C. Jacquinet|Le Hollandois|Thuraine French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Jacquinet, C.|Hollandois, Le|Thuraine 55310   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 x 5 1/8 in. (17.8 x 13 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434603 2016.403.12 0 1 722499 Arms and Armor 5 Engraving 2616 Plate Five from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Engraver|Publisher 5519   Le Hollandois|C. Jacquinet|Thuraine French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Hollandois, Le|Jacquinet, C.|Thuraine 55311   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 1/4 x 5 1/4 in. (18.4 x 13.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434604 2016.403.13 0 1 722500 Arms and Armor 5 Engraving 2616 Plate Six from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Publisher|Engraver 3909   Thuraine|Le Hollandois|C. Jacquinet French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Thuraine|Hollandois, Le|Jacquinet, C. 30304   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 1/16 x 5 3/8 in. (17.9 x 13.7 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434606 2016.403.14 0 1 722502 Arms and Armor 5 Engraving 2616 Plate Seven from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Publisher|Engraver 3909   Thuraine|Le Hollandois|C. Jacquinet French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Thuraine|Hollandois, Le|Jacquinet, C. 30304   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 1/2 x 5 1/2 in. (19.1 x 14 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434607 2016.403.15 0 1 722503 Arms and Armor 5 Engraving 2616 Plate Eight from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Publisher|Engraver 3909   Le Hollandois|Thuraine|C. Jacquinet French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Hollandois, Le|Thuraine|Jacquinet, C. 55308   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 1/16 x 5 1/8 in. (17.9 x 13 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434609 2016.403.16 0 1 722505 Arms and Armor 5 Engraving 2616 Plate Nine from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Publisher|Engraver 3909   Le Hollandois|Thuraine|C. Jacquinet French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Hollandois, Le|Thuraine|Jacquinet, C. 55308   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 1/8 x 5 in. (18.1 x 5 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434610 2016.403.17 0 1 722506 Arms and Armor 5 Engraving 2616 Plate Ten from Plusieurs Models des plus nouuelles manieres qui sont en usage en l'Art de Arquebuzerie French, Paris 114         Publisher|Engraver|Publisher 5519   Le Hollandois|C. Jacquinet|Thuraine French, Paris, active mid-17th century|French, Paris, active mid-17th century|French, Paris, active mid-17th century   Hollandois, Le|Jacquinet, C.|Thuraine 55311   1625 |1625 |1625 1675 |1675 |1675 ca. 1660 1635 1685 Engraving 7208 sheet: 7 x 5 1/16 in. (17.8 x 12.8 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434612 2016.403.18 0 1 722508 Arms and Armor 5 Engraving 2616 Plate Nine from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 dated 1743 1743 1743 Engraving 7208 sheet: 8 1/2 x 6 5/8 in. (21.6 x 16.8 cm); plate: 7 1/4 x 5 1/4 in. (18.4 x 13.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434613 2016.403.20 0 1 722509 Arms and Armor 5 Engraving 2616 Plate Eleven from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 ca. 1749 1724 1774 Engraving 7208 sheet: 9 x 7 in. (22.9 x 17.8 cm); plate: 8 7/16 x 6 7/16 in. (21.4 x 16.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
434614 2016.403.21 0 1 722510 Arms and Armor 5 Engraving 2616 Plate Eight from Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver 137   Gilles Demarteau French, Liège 1722–1776 Paris   Demarteau, Gilles 3114   1722 1776 dated 1743 1743 1743 Engraving 7208 sheet: 8 5/8 x 6 7/8 (21.9 x 17.5 cm); plate: 7 7/16 x 5 1/4 in. (18.9 x 13.3 cm) Purchase, Arthur Ochs Sulzberger Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
436711 2013.905,.906;2016.311,.312,.403.1–.7,.409 0 1 726774 Arms and Armor 5 Engravings 3759 Nouveavx Desseins D'Arquebvseries French, Paris 114         Engraver|Engraver 1425   Gilles Demarteau|De Lacollombe French, Liège 1722–1776 Paris|French, Paris, active ca. 1702–ca. 1736   Demarteau, Gilles|Lacollombe, De 55295   1722 |1702 1776 |1736 ca. 1705–49 1680 1774 Engravings 29296 plate 1 (2016.403.1): sheet: 11 1/2 x 9 in. (29.2 x 22.9 cm); plate: 9 3/8 x 6 5/8 in. (23.8 x 16.8 cm); plate 2 (2016.403.2): sheet: 11 7/8 x 9 in. (30.2 x 22.9 cm); plate: 9 3/8 x 6 5/8 (23.8 x 16.8 cm); plate 3 (2013.906): 10 1/2 x 7 1/2 in. (26.7 x 19.1 cm); plate 4 (2016.403.3): sheet: 11 3/4 x 9 1/8 in. (29.8 x 23.2 cm); plate: 9 1/4 x 6 5/8 in. (23.5 x 16.8 cm); plate 5 (2016.409): sheet: 11 1/2 x 9 in. (29.2 x 22.9 cm); plate: 9 3/8 x 6 5/8 in. (23.8 x 16.8 cm); plate 6 (2016.311): sheet: 11 7/8 x 9 in. (30.16 x 22.86 cm); plate: 9 1/8 x 6 3/8 in. (23.17 x 16.19 cm); plate 7 (2016.403.4): sheet: 12 x 9 in. (30.5 x 22.9 cm); plate: 9 3/8 x 6 3/8 in. (23.8 x 16.2 cm); plate 8 (2016.403.5): sheet: 11 7/8 x 9 1/16 in. (30.2 x 23 cm); plate: 7 7/16 x 5 1/4 in. (18.9 x 13.3 cm); plate 9 (2016.403.5): sheet: 11 3/4 x 9 1/8 in. (29.8 x 23.2 cm); plate: 7 1/4 x 5 1/4 in. (18.4 x 13.3 cm); plate 10 (2016.312): sheet: 11 7/8 x 9 1/8 in. (30.16 x 23.17 cm); plate: 8 1/2 x 6 3/8 in. (21.59 x 16.19 cm); plate 11 (2016.403.7): sheet: 11 1/2 x 9 1/4 in. (29.2 x 23.5 cm); plate: 8 7/16 x 6 7/16 in. (21.4 x 16.3 cm); plate 12 (2013.905): 7 1/2 x 9 3/8 in. (19 x 23.8 cm) 2013.905, .906: Purchase, Bequest of Stephen V. Grancsay, Rogers Fund, Helmut Nickel Gift, and funds from various donors, by exchange, 2013; 2016.311, .312: Purchase, Michael H. Pourfar Gift, 2016; 2016.403.1–.7: Purchase, Arthur Ochs Sulzberger Gift, 2016; 2016.409: Purchase, Marica F. Vilcek Gift, 2016   Paris 27                   Works on Paper-Engravings 171   Metropolitan Museum of Art, New York, NY 1
442432 2016.697 0 1 739608 Arms and Armor 5 Engraving 2616 Design for a Sword-belt, Knife, and Stylus French 7         Artist 2   Pierre Woeiriot de Bouzey II French, Neufchâteau 1532–1599 Damblain   de Bouzey, Pierre Woeiriot II 37531   1532 1599 ca. 1555 1530 1580 Engraving 7208 7 3/16 x 9 3/4 in. (18.3 x 24.7 cm) Purchase, Kenneth and Vivian Lam Gift, 2016                       Works on Paper-Engravings 171   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 141.386ms · Data license: CC0 · Data source: metmuseum/openaccess