Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2031 | 2031 | 1980.502.10 | 0 | 1 | 2206 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Manufacturer|Manufacturer 19 | Possibly by|Possibly by | Redford Crown Glass Works|Redwood Glass Company | 1831–1851|1828–1868 | Redford Crown Glass Works|Redwood Glass Company 152 | 1831 |1828 | 1831 |1868 | 1835–65 | 1835 | 1865 | Blown glass with applied decoration 112 | H. 3 3/4 in. (9.5 cm) | Gift of Henry G. Schiff, 1980 | Made in 1 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2206 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2510 | 2510 | 33.120.292 | 0 | 1 | 2704 | American Decorative Arts 1 | Cream pot 284 | Creamer | American 1 | Maker|Maker 6 | Possibly by|Possibly by | James Adam|John Adam | 1755–1798|1775–1848 | or | Adam, James|Adam, John 411 | 1755 |1775 | 1798 |1848 | 1770–1810 | 1770 | 1810 | Silver 2 | Overall: 6 x 4 7/8 in. (15.2 x 12.4 cm); 4 oz. 19 dwt. (153.8 g) Foot: 2 5/16 x 2 3/8 in. (5.9 x 6 cm) | Bequest of Alphonso T. Clearwater, 1933 | Possibly made in 5 | Alexandria 29 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2704 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
4978 | 4978 | 51.123.2 | 0 | 1 | 5342 | American Decorative Arts 1 | Cann 172 | Cann | American 1 | Maker|Maker 6 | Possibly by|Possibly by | George Hanners Sr.|George Hanners Jr. | ca. 1696–1740|1721–1760 | Hanners, George|Hanners, Jr. George 742 | 1693 |1721 | 1740 |1760 | ca. 1735 | 1730 | 1740 | Silver 2 | Overall: 5 5/16 x 5 5/16 in. (13.5 x 13.5 cm); 13 oz. 1 dwt. (406.4 g) Lip: Diam. 3 3/16 in. (8.1 cm) Foot: Diam. 3 3/16 in. (8.1 cm) | Gift of Robert Ogden Bishop, 1951 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/5342 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
5468 | 5468 | 33.120.313 | 0 | 1 | 5844 | American Decorative Arts 1 | Cream pot 284 | Creampot | American 1 | Maker|Maker 6 | Possibly by|Possibly by | Stephen Reeves|Samuel Richards Jr. | active ca. 1767–76|American, 1768–1827 | Reeves, Stephen|Richards, Samuel Jr. 821 | American 1 | 1764 |1768 | 1776 |1827 | 1775–1800 | 1775 | 1800 | Silver 2 | Overall: 6 x 5 in. (15.2 x 12.7 cm); 7 oz. (218.1 g) Foot: 2 5/16 x 2 5/16 in. (5.9 x 5.9 cm) | Bequest of Alphonso T. Clearwater, 1933 | Possibly made in|Possibly made in 3 | Philadelphia|New York 203 | United States|United States 8 | Silver 2 | http://www.metmuseum.org/art/collection/search/5844 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
6746 | 6746 | 46.40.2 | 0 | 1 | 7204 | American Decorative Arts 1 | Sauceboat 302 | Sauceboat | American 1 | Maker|Maker 6 | Possibly by|Possibly by | Paul Revere Jr.|Paul Revere Sr. | American, Boston, Massachusetts 1734–1818 Boston, Massachusetts|1702–1754 | Revere, Paul, Jr.|Revere, Paul Sr. 963 | American 1 | 1734 |1702 | 1818 |1754 | ca. 1765 | 1762 | 1765 | Silver 2 | 4 11/16 x 7 7/16 x 4 7/8 in. (11.9 x 18.9 x 12.4 cm); 14 oz. 10 dwt. (451.4 g) | Gift of Mr. and Mrs. Andrew Varick Stout, 1946 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7204 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
100794 | 100794 | 97.2.188 | 0 | 1 | 188212 | European Sculpture and Decorative Arts 3 | Spoon caddy 7016 | Caddy spoon | British, London or Chester 2332 | Maker|Maker 6 | Possibly by|Possibly by | Peter Bateman|Ann Bateman | active 1790–1815, died 1825|active 1791–1805, died before 1813 | Bateman Peter|Bateman Ann 8257 | 1725 |1713 | 1825 |1813 | 1802–3 or 1824–25 | 1802 | 1825 | Silver, parcel-gilt 20463 | Length: 3 3/4 in. (9.5 cm) | Gift of Mrs. Samuel P. Avery, 1897 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/188212 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
101696 | 101696 | 07.64.3 | 0 | 1 | 189214 | European Sculpture and Decorative Arts 3 | Salver 679 | Salver | Irish, Dublin 2300 | Maker|Maker 6 | Possibly by|Possibly by | William Homer|William Hamey | entered 1758, died 1773|ca. 1765–1812 | Homer William|Hamey William 8454 | 1673 |1765 | 1773 |1812 | ca. 1765 | 1760 | 1770 | Silver 2 | 1 1/16 × 6 7/8 in. (2.7 × 17.5 cm) | Rogers Fund, 1907 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/189214 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
105289 | 105289 | 14.102.497 | 0 | 1 | 193093 | European Sculpture and Decorative Arts 3 | Jug 293 | Jug | British, Staffordshire 2229 | Maker|Maker 6 | Possibly by|Possibly by | Tunstall|Horobin | or | Tunstall|Horobin 8969 | 1800 |1800 | 1900 |1900 | 19th century | 1800 | 1899 | Pottery 7419 | Height: 5 1/8 in. (13 cm) | Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/193093 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
105763 | 105763 | 17.190.626a, b | 0 | 1 | 193599 | European Sculpture and Decorative Arts 3 | Standing cup with cover 6797 | Standing cup with cover | Bohemian, Prague 353 | Maker|Maker 6 | Possibly by|Possibly by | Hans Wendel Pensel|Hans Prunner | active 1591–1602|active 1591–1617 | Pensel Hans Wendel|Prunner Hans 9074 | 1591 |1591 | 1602 |1617 | late 16th–early 17th century, with later additions | 1585 | 1615 | Silver gilt, coconut 20523 | Overall: 14 5/8 × 5 3/4 in. (37.1 × 14.6 cm) | Gift of J. Pierpont Morgan, 1917 | Metalwork-Silver In Combination 327 | http://www.metmuseum.org/art/collection/search/193599 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
109975 | 109975 | 38.50.41a, b | 0 | 1 | 198079 | European Sculpture and Decorative Arts 3 | Étui 6918 | Sealing wax case (étui) | French, Paris 114 | Maker|Maker 6 | Possibly by|Possibly by | Jean-François Mancel|Jean-François Méchin | master 1781; active 1806|master 1779; active 1793 | or | Mancel Jean-François|Méchin Jean-François 10033 | 1781 |1779 | 1806 |1793 | 1789–90 | 1789 | 1790 | Gold 1 | Length: 4 3/4 in. (12.1 cm) | Bequest of Kate Read Blacque, in memory of her husband, Valentine Alexander Blacque, 1937 | Metalwork-Gold and Platinum 326 | http://www.metmuseum.org/art/collection/search/198079 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
110429 | 110429 | 40.20.26 | 0 | 1 | 198607 | European Sculpture and Decorative Arts 3 | Cameo 482 | Young Hercules | Italian, possibly Verona 2941 | Maker|Maker 6 | Possibly by|Possibly by | Teresa Cappanini|Santa Cappanini | 1801–1826|born Verona 1803–1860 | or | Cappanini, Teresa|Cappanini Santa 10101 | 1801 |1803 | 1826 |1860 | probably second quarter 19th century | 1825 | 1850 | Sardonyx and gold 22169 | Overall: 1 3/16 x 11/16 x 7/8 in. (3 x 1.8 x 2.2 cm); visible cameo (confirmed): 27.2 x 15.1 mm | The Milton Weil Collection, 1940 | Lapidary Work-Gems 346 | http://www.metmuseum.org/art/collection/search/198607 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
110449 | 110449 | 40.20.46 | 0 | 1 | 198627 | European Sculpture and Decorative Arts 3 | Cameo 482 | Laureate head of Napoleon I of France | Italian, Rome 549 | Maker|Maker 6 | Possibly by|Possibly by | Pietro Pestrini|Clemente Pestrini | active first half of the 19th century|Italian, active first half of the 19th century | Pietro Pestrini|Pestrini Clemente 10108 | Italian 6 | 1800 |1800 | 1850 |1850 | ca. 1810 | 1805 | 1815 | Sardonyx and gold 22169 | Overall: 1 15/16 x 1 1/2 in. (4.9 x 3.8 cm); visible cameo (confirmed): 47 x 35.7 x 11 mm | The Milton Weil Collection, 1940 | Lapidary Work-Gems 346 | http://www.metmuseum.org/art/collection/search/198627 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
110639 | 110639 | 41.160.26 | 0 | 1 | 198839 | European Sculpture and Decorative Arts 3 | Strainer 571 | Strainer | British, London 222 | Maker|Maker 6 | Possibly by|Possibly by | I. A., London|John Albright | ca. 1737–1738|active 1718–20 or later | A. I.|Albright John 10160 | 1737 |1718 | 1738 |1720 | 1737–38 | 1737 | 1738 | Silver 2 | Overall: 1 1/8 × 6 3/4 in. (2.9 × 17.1 cm) | Bequest of W. Gedney Beatty, 1941 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/198839 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
112129 | 112129 | 48.187.439 | 0 | 1 | 200398 | European Sculpture and Decorative Arts 3 | Box 114 | Box | French, Paris 114 | Maker|Maker 6 | Possibly by|Possibly by | Jacques-François Varin (or Warin)|Jacques-Félix Viénot | master 1758, active 1790|master 1785, active 1806 | Varin Jacques- François|Viénot Jacques-Félix 10558 | 1758 |1785 | 1790 |1806 | 1788–89 | 1788 | 1789 | Gold 1 | Overall: 1 1/16 × 3 5/8 × 1 5/8 in. (2.7 × 9.2 × 4.1 cm) | Bequest of Catherine D. Wentworth, 1948 | Metalwork-Gold and Platinum 326 | http://www.metmuseum.org/art/collection/search/200398 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
112165 | 112165 | 48.187.475a, b | 0 | 1 | 200434 | European Sculpture and Decorative Arts 3 | Box 114 | Box | French, Paris 114 | Maker|Maker 6 | Possibly by|Possibly by | Jacques-François Varin (or Warin)|Jacques-Félix Viénot | master 1758, active 1790|master 1785, active 1806 | Varin Jacques- François|Viénot Jacques-Félix 10558 | 1758 |1785 | 1790 |1806 | 1787–88 | 1787 | 1788 | Gold 1 | 3/4 × 2 3/8 in. (1.9 × 6 cm) | Bequest of Catherine D. Wentworth, 1948 | Metalwork-Gold and Platinum 326 | http://www.metmuseum.org/art/collection/search/200434 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
113768 | 113768 | 58.7.99 | 0 | 1 | 202090 | European Sculpture and Decorative Arts 3 | Spoon 78 | Spoon | British, London 222 | Maker|Maker 6 | Possibly by|Possibly by | William Darker|Josiah Daniel | active 1718–33|British, active 1712 | Darker William|Daniel Josiah 10818 | British 7 | 1718 |1712 | 1733 |1712 | 1720–21 | 1720 | 1721 | Silver 2 | Length: 7 3/4 in. (19.7 cm) | Gift of George D. Widener and Mrs. Eleanor Widener Dixon, 1958 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/202090 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
115632 | 115632 | 64.164.119 | 0 | 1 | 204220 | European Sculpture and Decorative Arts 3 | Crèche figure 8210 | Standing sheep | Italian, Naples 427 | Maker|Maker 6 | Possibly by|Possibly by | Nicola Vassalo|Saverio Vassalo | Vassalo Nicola|Vassalo Saverio 11117 | 1725 |1725 | 1825 |1825 | second half 18th century | 1750 | 1799 | Polychromed terracotta body, lead ears and legs 22996 | H. 7 1/2 in. (19.1 cm.) | Gift of Loretta Hines Howard, 1964 | Crèche 361 | http://www.metmuseum.org/art/collection/search/204220 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
115634 | 115634 | 64.164.121 | 0 | 1 | 204222 | European Sculpture and Decorative Arts 3 | Crèche figure 8210 | Standing sheep | Italian, Naples 427 | Maker|Maker 6 | Possibly by|Possibly by | Nicola Vassalo|Saverio Vassalo | Vassalo Nicola|Vassalo Saverio 11117 | 1725 |1725 | 1825 |1825 | second half 18th century | 1750 | 1799 | Polychromed terracotta body, wooden ears, lead legs 22997 | H. 7 1/2 in. (19.1 cm.) | Gift of Loretta Hines Howard, 1964 | Crèche 361 | http://www.metmuseum.org/art/collection/search/204222 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
115642 | 115642 | 64.164.129 | 0 | 1 | 204230 | European Sculpture and Decorative Arts 3 | Crèche figure 8210 | Seated sheep | Italian, Naples 427 | Maker|Maker 6 | Possibly by|Possibly by | Nicola Vassalo|Saverio Vassalo | Vassalo Nicola|Vassalo Saverio 11117 | 1725 |1725 | 1825 |1825 | second half 18th century | 1750 | 1799 | Polychromed terracotta body, wooden ears 23000 | H. 4 13/16 in. (12.2 cm.) | Gift of Loretta Hines Howard, 1964 | Crèche 361 | http://www.metmuseum.org/art/collection/search/204230 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
116163 | 116163 | 68.138.1 | 0 | 1 | 204845 | European Sculpture and Decorative Arts 3 | Statuette 14 | A young boy | British 6 | Artist|Artist 13 | Possibly by|Possibly by | Sir Henry Cheere|John Cheere | British, London 1703–1781 London|British, London 1709–1787 London | CHEERE HENRY|Cheere, John 11211 | 1703 |1709 | 1781 |1787 | mid-18th century | 1730 | 1765 | Lead, marble 23093 | Overall: 24 × 12 × 10 in. (61 × 30.5 × 25.4 cm) | Rogers Fund, 1968 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/204845 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
118183 | 118183 | 1982.60.295 | 0 | 1 | 207175 | European Sculpture and Decorative Arts 3 | Figure 9 | Dancing Woman | German, Meissen 2269 | Modeler|Factory|Modeler 548 | Possibly by|Possibly by | Johann Joachim Kändler|Meissen Manufactory|Friedrich Elias Meyer | German, Fischbach 1706–1775 Meissen|German, 1710–present|1723/1724–1785 | Kändler, Johann Joachim|Meissen Manufactory|Meyer Friedrich Elias 11636 | German|German 79 | 1706 |1710 |1723 | 1775 |9999 |1785 | ca. 1748 | 1743 | 1753 | Hard-paste porcelain, gilt-bronze 23526 | Height: 11 3/4 in. (29.8 cm) | The Jack and Belle Linsky Collection, 1982 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/207175 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
121697 | 121697 | 30.135.177a | 0 | 1 | 211375 | European Sculpture and Decorative Arts 3 | Dorothy bag base 8724 | Dorothy bag base | German, Augsburg 126 | Maker|Maker 6 | Possibly by|Possibly by | Johann Christoph Eckart|Johann Karl Burger | master 1741, died 1766|master 1750, died 1795 | Eckart Johann Christoph|Burger Johann Karl 12266 | 1666 |1695 | 1766 |1795 | 1751–61 | 1751 | 1761 | Silver 2 | Overall: 10 × 7 1/2 in. (25.4 × 19.1 cm) | Gift of Mrs. Edward S. Harkness, 1930 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/211375 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
130776 | 130776 | 27.178 | 0 | 1 | 222101 | European Sculpture and Decorative Arts 3 | Furnishing textile 8862 | The Fortune Teller | British, Phippsbridge, near Merton, Surrey 3771 | Maker|Maker 6 | Possibly by|Possibly by | Nixon & Co.|John Collins | (John Nixon) | Nixon & Co.|Collins John 12398 | 1725 | 1825 | ca. 1765 | 1760 | 1770 | Cotton and linen 2229 | L. 36 1/2 x W. 35 inches 92.7 x 88.9 cm | Gift of Edwin S. Parker, 1927 | Textiles-Printed 239 | http://www.metmuseum.org/art/collection/search/222101 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
178816 | 178816 | 1994.261.27 | 0 | 0 | 282391 | Photographs 13 | Photograph 997 | [Anita Skolle, Child of Hanns and Lily Skolle, 13 East 14th Street, New York City] | Artist|Artist 13 | Possibly by|Possibly by | Walker Evans|Hanns Skolle | American, St. Louis, Missouri 1903–1975 New Haven, Connecticut|American, born Germany, 1903–1988 | Evans, Walker|Skolle, Hanns 15584 | American|American, born Germany 444 | 1903 |1903 | 1975 |1988 | April 1928 | 1928 | 1928 | Gelatin silver print 14941 | 6 x 2.9 cm (2 3/8 x 1 1/8 in. ) | Walker Evans Archive, 1994 | Photographs 21 | http://www.metmuseum.org/art/collection/search/282391 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
179488 | 179488 | 2005.100.607 | 0 | 1 | 283067 | Photographs 13 | Photograph 997 | The Fruit Sellers | Artist|Artist 13 | Possibly by|Possibly by | William Henry Fox Talbot|Calvert Richard Jones | British, Dorset 1800–1877 Lacock|British, Swansea, Wales 1802–1877 Bath, England | Talbot, William Henry Fox|Jones, Calvert Richard 15722 | British|British, Welsh 598 | 1800 |1802 | 1800 |1877 | ca. 1845 | 1843 | 1847 | Salted paper print from paper negative 26085 | 17.1 x 21.1 cm (6 3/4 x 8 5/16 in. ) | Gilman Collection, Purchase, Harriette and Noel Levine Gift, 2005 | Photographs 21 | http://www.metmuseum.org/art/collection/search/283067 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
180488 | 180488 | X.744 | 0 | 0 | 284095 | Photographs 13 | Photograph 997 | [Standing Girl] | Artist|Artist|Artist 53 | Possibly by|Possibly by | Unknown|Richard Harding Doe|William H. Doe | American|American, 1827–1884|American, active 1850s–60s | Unknown|Doe, Richard Harding|Doe, William H. 15865 | 1827 | 1884 | 1850s | 1850 | 1859 | daguerreotype 26349 | 5.2 x 4 cm (2 1/16 x 1 9/16 in. ) visible | Museum Accession | Photographs 21 | http://www.metmuseum.org/art/collection/search/284095 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
237253 | 237253 | 68.681.10 | 0 | 1 | 365220 | Drawings and Prints 11 | Print, Fete, Ornament & Architecture 13856 | Triumphal car from the marriage of Ferdinand de' Medici and Christine of Lorraine | Artist|Artist 13 | Possibly by|Possibly by | Cherubino Alberti (Zaccaria Mattia)|Orazio Scarabelli | Italian, Borgo Sansepolcro 1553–1615 Rome|Italian, active Florence, ca. 1589 | Alberti, Cherubino (Zaccaria Mattia)|Scarabelli, Orazio 32444 | Italian|Italian 93 | 1553 |1589 | 1615 |1589 | 1589 | 1589 | 1589 | Etching 26137 | Sheet (Trimmed): 6 in. × 8 13/16 in. (15.2 × 22.4 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968 | Prints|Prints-Fete|Ornament & Architecture 687 | http://www.metmuseum.org/art/collection/search/365220 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
349157 | 349157 | 2005.81a–g | 0 | 1 | 503908 | Musical Instruments 18 | Oboe 15393 | Oboe | German 27 | Manufacturer|Maker|Maker 56 | Possibly by|Possibly by | B. Schott fils|Johann Adam Heckel|August Jehring | German, active Mainz ca. 1817–ca. 1840|Adorf, Germany 1812–1877 Biebach, Germany|German, Adorf 1798–1837 Mainz | Schott B. fils|Heckel Johann Adam|Jehring August 48136 | German|German|German 80 | 1817 |1812 |1798 | 1840 |1877 |1837 | ca. 1830 | 1810 | 1850 | Boxwood, ivory, silver 54853 | L. 54.6 cm (21 1/2 in.) | Purchase, Robert Alonzo Lehman Bequest, 2005 | Germany 16 | Aerophone-Reed Vibrated-double reed 911 | http://www.metmuseum.org/art/collection/search/503908 | 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");