Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Department, Title, Culture, Artist Role, 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, Dimensions, Credit Line, Geography Type, City, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1912 | 1912 | 83.2.92 | 0 | 1 | 2077 | American Decorative Arts 1 | Medal 148 | Medal | 1776–83 | 1776 | 1883 | Gilt brass 105 | Diam. 3 in. (7.6 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/2077 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
4591 | 4591 | 83.2.315 | 0 | 1 | 4948 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | 1800–1883 | 1800 | 1883 | Bronze 23 | Diam. 1 1/4 in. (3.2 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4948 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
4592 | 4592 | 83.2.317 | 0 | 1 | 4949 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | François Augustin Caunois | French, 1787–1859 | Caunois, Françoi Augustin 674 | French 2 | 1787 | 1859 | 1824 | 1824 | 1824 | Bronze 23 | Diam. 1 7/8 in. (4.8 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4949 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4593 | 4593 | 83.2.318 | 0 | 1 | 4950 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | François Augustin Caunois | French, 1787–1859 | Caunois, Françoi Augustin 674 | French 2 | 1787 | 1859 | 1824 | 1824 | 1824 | Iron 13 | Diam. 1 3/4 in. (4.4 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4950 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4594 | 4594 | 83.2.310 | 0 | 1 | 4951 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1789 | 1789 | 1789 | Gilt bronze 30 | Diam. 1 5/8 in. (4.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4951 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4595 | 4595 | 83.2.311 | 0 | 1 | 4952 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1789 | 1789 | 1789 | Probably brass 919 | Diam. 1 5/8 in. (4.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4952 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4596 | 4596 | 83.2.314 | 0 | 1 | 4953 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1789 | 1789 | 1789 | Bronze 23 | Diam. 1 5/8 in. (4.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4953 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4597 | 4597 | 83.2.308 | 0 | 1 | 4954 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | Jacques Édouard Gatteaux | French, Paris 1788–1881 Paris | Gatteaux, Jacques Édouard 676 | French 2 | 1788 | 1881 | 1830 | 1830 | 1830 | Iron 13 | Diam. 1 7/8 in. (4.8 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4954 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4598 | 4598 | 83.2.316 | 0 | 1 | 4955 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Artist 2 | Probably | Pierre Antoine Montagny | Montagny, Pierre Antoine 677 | 9999 | 1790 | 1790 | 1790 | Bronze 23 | Diam. 2 1/16 in. (5.2 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4955 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
4599 | 4599 | 83.2.309 | 0 | 1 | 4956 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | Joseph Arnold Pingret | Belgian, Brussels 1798–1862 Paris | Pingret, Joseph Arnold 678 | Belgian 20 | 1798 | 1862 | 1830 | 1830 | 1830 | Gilt silver 920 | Diam. 1 1/16 in. (2.7 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/4956 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4652 | 4652 | 83.2.322 | 0 | 1 | 5009 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | 1834 (?) | 1834 | 1834 | Bronze 23 | Diam. 1 1/4 in. (3.2 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5009 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
4653 | 4653 | 83.2.323 | 0 | 1 | 5010 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | 1834 (?) | 1834 | 1834 | Silver 2 | Diam. 1 1/4 in. (3.2 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5010 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
4668 | 4668 | 83.2.423 | 0 | 1 | 5025 | American Decorative Arts 1 | Medal 148 | Medal Commemorating the Treaty of Commerce between France and the United States | Maker|Maker 6 | Bertrand Andrieu|Raymond Gayrard | French, 1761–1822|French, Rodez 1777–1858 Paris | Andrieu, Bertrand|Gayrard, Raymond 684 | French|French 21 | 1761 |1777 | 1822 |1858 | 1822 | 1822 | 1822 | Bronze 23 | Diam. 2 in. (5.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5025 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4675 | 4675 | 83.2.418 | 0 | 1 | 5032 | American Decorative Arts 1 | Medal 148 | Medal of Thaddeus Kosciuszko | Maker 1 | François Augustin Caunois | French, 1787–1859 | Caunois, Françoi Augustin 674 | French 2 | 1787 | 1859 | 1818 | 1818 | 1818 | Bronze 23 | Diam. 1 5/8 in. (4.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5032 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4681 | 4681 | 83.2.391 | 0 | 1 | 5038 | American Decorative Arts 1 | Medal 148 | Medal of John Paul Jones and the Serapis | Maker 1 | Augustin Dupré | French, Saint-Étienne 1748–1833 Armentières-en-Brie | Dupré, Augustin 688 | French 2 | 1748 | 1833 | 1779 | 1779 | 1779 | Copper 549 | Diam. 2 1/4 in. (5.7 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5038 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4682 | 4682 | 83.2.398 | 0 | 1 | 5039 | American Decorative Arts 1 | Medal 148 | Medal of General Daniel Morgan | Maker 1 | Augustin Dupré | French, Saint-Étienne 1748–1833 Armentières-en-Brie | Dupré, Augustin 688 | French 2 | 1748 | 1833 | 1770–1800 | 1770 | 1800 | Copper 549 | Diam. 2 3/16 in. (5.6 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5039 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4683 | 4683 | 83.2.422 | 0 | 1 | 5040 | American Decorative Arts 1 | Medal 148 | Medal Commemorating the Declaration of Independence | Maker 1 | Augustin Dupré | French, Saint-Étienne 1748–1833 Armentières-en-Brie | Dupré, Augustin 688 | French 2 | 1748 | 1833 | 1782 | 1782 | 1782 | Bronze 23 | Diam. 1 7/8 in. (4.8 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5040 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4684 | 4684 | 83.2.10 | 0 | 1 | 5041 | American Decorative Arts 1 | Medal 148 | Medal | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1770–1800 | 1770 | 1800 | Bronze 23 | Diam. 2 3/4 in. (7 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5041 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4685 | 4685 | 83.2.11 | 0 | 1 | 5042 | American Decorative Arts 1 | Medal 148 | Medal | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1770–1800 | 1770 | 1800 | Cast iron 61 | Diam. 2 3/4 in. (7 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5042 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4686 | 4686 | 83.2.12 | 0 | 1 | 5043 | American Decorative Arts 1 | Medal 148 | Medal | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1770–1800 | 1770 | 1800 | Silver 2 | Diam. 2 3/4 in. (7 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5043 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4687 | 4687 | 83.2.23 | 0 | 1 | 5044 | American Decorative Arts 1 | Medal 148 | Medal | Maker 1 | Pierre Simon Benj. Duvivier | 1728–1819 | Duvivier, Pierre Simon Benj. 675 | 1728 | 1819 | 1770–1800 | 1770 | 1800 | Bronze 23 | Diam. 1 3/4 in. (4.4 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5044 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4728 | 4728 | 83.2.319 | 0 | 1 | 5085 | American Decorative Arts 1 | Medal 148 | Medal of the Marquis de Lafayette | Maker 1 | Jacques Édouard Gatteaux | French, Paris 1788–1881 Paris | Gatteaux, Jacques Édouard 676 | French 2 | 1788 | 1881 | 1830 | 1830 | 1830 | Bronze 23 | Diam. 2 in. (5.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5085 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4729 | 4729 | 83.2.415 | 0 | 1 | 5086 | American Decorative Arts 1 | Medal 148 | Medal of the Constituency of Meaux in Honor of Its Deputy | Maker 1 | Jacques Édouard Gatteaux | French, Paris 1788–1881 Paris | Gatteaux, Jacques Édouard 676 | French 2 | 1788 | 1881 | 1830 | 1830 | 1830 | Iron 13 | Diam. 1 15/16 in. (4.9 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5086 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4730 | 4730 | 83.2.412 | 0 | 1 | 5087 | American Decorative Arts 1 | Medal 148 | Medal of Gates at Saratoga | Maker 1 | Nicolas Marie Gatteaux | French, Paris 1751–1832 Paris | Gatteaux, Nicolas Marie 693 | French 2 | 1751 | 1832 | 1777 | 1777 | 1777 | Bronze 23 | Diam. 2 3/16 in. (5.6 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5087 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4731 | 4731 | 83.2.413 | 0 | 1 | 5088 | American Decorative Arts 1 | Medal 148 | Medal of Gates at Saratoga | Maker 1 | Nicolas Marie Gatteaux | French, Paris 1751–1832 Paris | Gatteaux, Nicolas Marie 693 | French 2 | 1751 | 1832 | 1777 | 1777 | 1777 | Bronze 23 | Diam. 2 3/16 in. (5.6 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5088 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4735 | 4735 | 83.2.420 | 0 | 1 | 5092 | American Decorative Arts 1 | Medal 148 | Medal of Francis, Duke de Dampville | Maker 1 | Jean Hardy | 1647–1684 | Hardy, Jean 695 | 1647 | 1684 | 1658 | 1658 | 1658 | Bronze 23 | Diam. 2 in. (5.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5092 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
4759 | 4759 | 83.2.1 | 0 | 1 | 5116 | American Decorative Arts 1 | Medal 148 | Medal | Maker|Maker 6 | Emile Rogat|Maurice Valentin Borrel | French, Paris 1770–1850|French, Montataire 1804–1882 Chevilly | Rogat, Emile|Borrel, Maurice Valentin 703 | French 2 | 1770 |1804 | 1850 |1882 | 1834 | 1834 | 1834 | Bronze 23 | Diam. 2 in. (5.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5116 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
4763 | 4763 | 83.2.20 | 0 | 1 | 5120 | American Decorative Arts 1 | Medal 148 | George Washington | Maker 1 | F. Vivier | Vivier, F. 705 | 9999 | 1819 | 1819 | 1819 | Bronze 23 | Diam. 1 5/8 in. (4.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5120 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
4806 | 4806 | 83.2.83 | 0 | 1 | 5163 | American Decorative Arts 1 | Medal 148 | Medal | Maker 1 | Possibly after | Jean Martin Renaud | French, Sarreguemines 1746–1821 Paris | Renaud, Jean Martin 123 | French 2 | 1746 | 1821 | 1776–83 | 1776 | 1883 | Bronze 23 | Diam. 4 1/4 in. (10.8 cm) | Gift of William H. Huntington, 1883 | Probably made in 2 | France 9 | Metal 1 | http://www.metmuseum.org/art/collection/search/5163 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
15508 | 15508 | 2000.546 | 0 | 1 | 16796 | American Decorative Arts 1 | Medal 148 | Medal | French, probably 43 | ca. 1825 | 1822 | 1828 | Gold 1 | L. 1 3/4 in. (4.4 cm); Diam. 1 5/16 in. (3.3 cm) | Purchase, Susan and Jon Rotenstreich Gift, 2000 | Probably made in 2 | France 9 | Jewelry 10 | http://www.metmuseum.org/art/collection/search/16796 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
326609 | 326609 | 25.142.43 | 0 | 1 | 466615 | Medieval Art 6 | Medal 148 | Medal Louis XII, King of France (r. 1498–15155), and Anne of Brittany (1476–1514) | French 7 | ca. 1499 | 1499 | 1499 | Copper alloy 4107 | Overall: Diam. 4 3/8 x 5/8 in. (11.1 x 1.6 cm) | Gift of Ogden Mills, 1925 | Made in 1 | Lyon 312 | France 9 | Metalwork-Copper alloy 804 | http://www.metmuseum.org/art/collection/search/466615 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
327252 | 327252 | 35.77 | 0 | 1 | 467614 | Medieval Art 6 | Medal 148 | Medal Louis XII, King of France (r. 1498–15155), and Anne of Brittany (1476–1514) | French 7 | ca. 1499 | 1494 | 1504 | Copper alloy 4107 | Overall: diam. 4 1/2 x 5/8 in. (11.4 x 1.6 cm) | Gift of George and Florence Blumenthal, 1935 | Made in 1 | Lyon 312 | France 9 | Metalwork-Copper alloy|Medals and Plaquettes 815 | http://www.metmuseum.org/art/collection/search/467614 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
327944 | 327944 | 60.55.81 | 0 | 1 | 468568 | Medieval Art 6 | Medal 148 | Medal of Duke Philibert II of Savoy (1480–1504) and Margaret of Austria (1480–1530) | French 7 | early 16th century | 1500 | 1550 | Copper alloy 4107 | Overall: diam. 4 x 3/16 in. (diam. 10.2 x 0.5 cm) | Bequest of Rupert L. Joseph, 1960 | Made in 1 | Bourg-en-Bresse 2005 | France 9 | Metalwork-Copper alloy|Medals and Plaquettes 815 | http://www.metmuseum.org/art/collection/search/468568 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
328521 | 328521 | 1988.133 | 0 | 1 | 469911 | The Cloisters 17 | Medal 148 | MedalObverse: Equestrian Portrait of Emperor Constantine (r. 307–337)Reverse: Allegory of Salvation | French 7 | ca. 1402–13 (model); 16th century (cast) | 1400 | 1600 | Copper alloy 4107 | 3 11/16 × 3/16 in., 0.4 lb. (9.3 × 0.5 cm, 167.5g) | Gift of Mr. and Mrs. Alain Moatti, 1988 | Made in 1 | Paris 27 | France 9 | Metalwork-Copper alloy|Medals and Plaquettes 815 | http://www.metmuseum.org/art/collection/search/469911 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
434962 | 434962 | 2016.524 | 0 | 1 | 724689 | The Cloisters 17 | Medal 148 | Heraklius Approaching the Gates of Jerusalem with the True Cross | French 7 | ca. 1402–13 | 1402 | 1413 | Silver 2 | 4 1/8 × 3/16 in., 0.1 lb. (10.4 × 0.4 cm, 24g) inside rim: 3 13/16 × 3/16 in. (9.7 × 0.4 cm) | Purchase, The Cloisters Collection, Stephen K. Scher Gift and Susan G. and David Enders Tripp Gift, in honor of Timothy B. Husband, 2016 | Made in 1 | France 9 | Metalwork-Silver|Medals 1164 | http://www.metmuseum.org/art/collection/search/724689 | 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");