Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, 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, Credit Line, Geography Type, City, Country, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2257 | 2257 | 40.133.1a, b | 0 | 1 | 2441 | American Decorative Arts 1 | Punch bowl 298 | Covered Punch Bowl | Chinese, for Swedish market 29 | 1745–55 | 1745 | 1755 | Porcelain 109 | H. with cover 12 1/2 (31.8 cm); Diam. 16 in. (40.6 cm) | Purchase, Joseph Pulitzer Bequest, 1940 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2441 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
2258 | 2258 | 46.140.481a, b | 0 | 1 | 2442 | American Decorative Arts 1 | Punch bowl 298 | Covered Punch Bowl | American 1 | Maker 1 | Probably | Hobbs, Brockunier and Company | 1863–1891 | Hobbs, Brockunier and Company 162 | 1863 | 1891 | ca. 1885–87 | 1882 | 1887 | Blown glass 168 | H. 15 in. (38.1 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Wheeling 69 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2442 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
2259 | 2259 | 46.140.482a, b | 0 | 1 | 2443 | American Decorative Arts 1 | Punch bowl 298 | Covered Punch Bowl | American 1 | Maker 1 | Probably | Hobbs, Brockunier and Company | 1863–1891 | Hobbs, Brockunier and Company 162 | 1863 | 1891 | ca. 1885–87 | 1882 | 1887 | Blown glass 168 | H. 14 5/8 in. (37.1 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Wheeling 69 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2443 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
6351 | 6351 | 31.102 | 0 | 1 | 6792 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | Chinese 10 | 1800–1805 | 1800 | 1805 | Porcelain 109 | H. 9 1/8 in. (23.2 cm); Diam. 22 in. (55.9 cm) | The Sylmaris Collection, Gift of George Coe Graves, 1931 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6792 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
6353 | 6353 | 35.112 | 0 | 1 | 6794 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | Chinese, for American market 16 | ca. 1790 | 1787 | 1790 | Porcelain 109 | H. 6 1/4 in. (15.9 cm); Diam. 15 1/2 in. (39.4 cm) | Bequest of Edith Pryor, 1935 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6794 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
6354 | 6354 | 39.18.5 | 0 | 1 | 6795 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | Chinese 10 | 1770–1800 | 1770 | 1800 | Porcelain 109 | H. 6 3/4 in. (17.1 cm) | Gift of R. Thornton Wilson, 1939 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6795 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
6356 | 6356 | 63.50 | 0 | 1 | 6797 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | Chinese 10 | 1785–1800 | 1785 | 1800 | Porcelain 109 | H. 6 in. (15.2 cm); Diam. 14 1/2 in. (36.8 cm) | Gift of David Wagstaff, Jr., 1963 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6797 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
6357 | 6357 | 1973.167 | 0 | 1 | 6798 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | Chinese, for American market 16 | 1785–1800 | 1785 | 1800 | Porcelain 109 | H. 5 13/16 in. (14.8 cm); Diam. 14 in. (35.6 cm) | Bequest of Elizabeth V. Loudon and Gift of Dana S. Lamb, John C. Dreier, Theodore Dreier, Mrs. Garrett R. Stearly and Mrs. Peter V. D. Voorhees, 1973 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6798 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
6358 | 6358 | 1984.449 | 0 | 1 | 6799 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | Chinese, for American market 16 | ca. 1786–90 | 1783 | 1790 | Porcelain 109 | Diam. 16 in. (40.6 cm) | Gift of Lucille S. Pfeffer, 1984 | Made in 1 | China 13 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6799 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
6359 | 6359 | 46.140.88 | 0 | 0 | 6800 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | American 1 | Maker 1 | Bakewell, Pears and Company | 1836–1882 | Bakewell, Pears and Company 140 | 1836 | 1882 | 1850–70 | 1850 | 1870 | Pressed glass 5 | H. 8 7/8 in. (22.5 cm); Diam. 10 1/4 in. (26 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/6800 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
6360 | 6360 | 1970.17a, b | 0 | 1 | 6801 | American Decorative Arts 1 | Punch bowl 298 | Punch bowl | American 1 | Maker 1 | Attirbuted to | C. Dorflinger and Sons | American, White Mills, Pennsylviania, 1881–1921 | Dorflinger and Sons Christian 185 | 1881 | 1921 | 1890–1905 | 1890 | 1905 | Blown and cut glass 219 | 14 3/4 x 14 1/8 in. (37.5 x 35.9 cm) | Funds from various donors, 1970 | Made in 1 | White Mills 73 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/6801 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
6362 | 6362 | 67.262.5 | 0 | 0 | 6803 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | American 1 | Maker 1 | T. G. Hawkes and Company | Hawkes and Company T. G. 161 | 9999 | ca. 1905 | 1902 | 1905 | Molded blown glass 1113 | H. 6 3/4 in. (17.1 cm); Diam. 14 1/8 in. (35.9 cm) | Gift of John C. Cattus, 1967 | Made in 1 | Corning 68 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/6803 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
6363 | 6363 | 46.140.473 | 0 | 1 | 6804 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | American 1 | Maker 1 | Probably | Hobbs, Brockunier and Company | 1863–1891 | Hobbs, Brockunier and Company 162 | 1863 | 1891 | 1870–1900 | 1870 | 1900 | Blown glass 168 | H. 6 9/16 in. (13.7 cm); Diam. 13 3/8 in. (34 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Wheeling 69 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/6804 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
105188 | 105188 | 14.58.229 | 0 | 1 | 192896 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | British 6 | late 18th century | 1785 | 1799 | Glass 31 | Overall: 7 7/8 × 7 1/4 in. (20 × 18.4 cm) | Bequest of John L. Cadwalader, 1914 | Glass 3 | http://www.metmuseum.org/art/collection/search/192896 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
109404 | 109404 | 33.133 | 0 | 1 | 197456 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for British market 2786 | 1744 | 1744 | 1744 | Hard-paste porcelain 572 | Overall: 5 1/4 × 11 1/4 in. (13.3 × 28.6 cm) | Gift of Mrs. J. Insley Blair, 1933 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/197456 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
110400 | 110400 | 40.15.4 | 0 | 1 | 198578 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, possibly for British market 2596 | third quarter 18th century | 1750 | 1775 | Hard-paste porcelain 572 | Overall: 4 1/4 × 10 3/8 in. (10.8 × 26.4 cm) | Gift of R. Thornton Wilson, 1940 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/198578 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
111447 | 111447 | 46.33.6 | 0 | 1 | 199702 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | British, London 222 | Maker 1 | John East | active 1697–1734 | East John 10282 | 1697 | 1734 | 1705–6 | 1705 | 1706 | Silver 2 | Overall: 6 1/2 × 11 in. (16.5 × 27.9 cm) | Gift of Frederic Ashton de Peyster, 1946 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/199702 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
112727 | 112727 | 51.86.24 | 0 | 1 | 201013 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for European market 104 | 1750–75 | 1750 | 1775 | Hard-paste porcelain 572 | Overall: 9 1/2 × 21 3/4 in. (24.1 × 55.2 cm) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201013 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
112728 | 112728 | 51.86.25 | 0 | 1 | 201014 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, possibly for British market 2596 | 1785–1800 | 1785 | 1800 | Hard-paste porcelain 572 | Overall (wt. confirmed): 8 5/8 × 21 3/4 in., 29 lb. (21.9 × 55.2 cm, 13.2 kg) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201014 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
112729 | 112729 | 51.86.26 | 0 | 1 | 201015 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for Continental market 2109 | 1750–75 | 1750 | 1775 | Hard-paste porcelain 572 | Overall: 9 5/8 × 21 1/8 in. (24.4 × 53.7 cm) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201015 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113047 | 113047 | 51.86.413 | 0 | 1 | 201334 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for British market 2786 | ca. 1760 | 1755 | 1765 | Hard-paste porcelain 572 | Overall (wt. confirmed): 6 1/2 × 16 3/16 in., 9 lb. (16.5 × 41.1 cm, 4.1 kg) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201334 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113048 | 113048 | 51.86.414 | 0 | 1 | 201335 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for British or Continental market 3130 | 1785–1800 | 1785 | 1800 | Hard-paste porcelain 572 | Diameter: 11 1/2 in. (29.2 cm) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201335 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113562 | 113562 | 55.170 | 0 | 1 | 201871 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for Scottish market 3124 | late 18th century | 1785 | 1799 | Hard-paste porcelain 572 | Overall: 5 7/8 × 14 3/8 in. (14.9 × 36.5 cm) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1955 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201871 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113791 | 113791 | 58.52 | 0 | 1 | 202113 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for European market 104 | ca. 1782–85 | 1777 | 1790 | Hard-paste porcelain 572 | Overall: 5 15/16 × 14 1/4 in. (15.1 × 36.2 cm) | Helena Woolworth McCann Collection, Purchase, Winfield Foundation Gift, 1958 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/202113 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
114099 | 114099 | 60.111.7 | 0 | 1 | 202475 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for British market 2786 | ca. 1780 | 1775 | 1785 | Hard-paste porcelain 572 | Overall: 4 1/2 × 10 1/4 in. (11.4 × 26 cm) | Gift of Elizabeth Hazard and Marion H. McVitty, in memory of their mother, Mrs. Lauriston H. Hazard, 1960 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/202475 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
114100 | 114100 | 60.111.8 | 0 | 1 | 202476 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for Swedish market 29 | ca. 1790 | 1785 | 1795 | Hard-paste porcelain 572 | Overall: 3 7/8 × 9 in. (9.8 × 22.9 cm) | Gift of Elizabeth Hazard and Marion H. McVitty, in memory of their mother, Mrs. Lauriston H. Hazard, 1960 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/202476 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
114420 | 114420 | 63.53.134 | 0 | 1 | 202843 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Miniature punch bowl (part of a set) | British, London 222 | Maker 1 | David Clayton | British, active 1689 | Clayton David 10985 | British 7 | 1659 | 1719 | late 17th–early 18th century | 1685 | 1715 | Silver 2 | 5/8 × 1 3/4 in. (1.6 × 4.4 cm) | The Joseph M. and Aimee Loeb May Collection, 1963 | Metalwork-Silver-Miniature 360 | http://www.metmuseum.org/art/collection/search/202843 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
115924 | 115924 | 65.199.10 | 0 | 1 | 204579 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | British, London 222 | Maker 1 | Probably by | William Eddon | Eddon William 11160 | 1650 | 1750 | 1702 | 1702 | 1702 | Pewter 104 | Overall (with handles): 8 1/16 × 12 in. (20.5 × 30.5 cm) | Gift of Elizabeth B. Howe, in memory of her husband, Leroy Kent Howe, 1965 | Metalwork-Pewter 19 | http://www.metmuseum.org/art/collection/search/204579 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
116202 | 116202 | 68.141.68 | 0 | 1 | 204886 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | British, London 222 | Maker 1 | E. G., London | active 1669–81 | G. E. 11220 | 1669 | 1681 | 1680–81 | 1680 | 1681 | Silver 2 | Diameter: 12 in. (30.5 cm) | Gift of Irwin Untermyer, 1968 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/204886 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
116515 | 116515 | 1970.212.3 | 0 | 1 | 205230 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, for British market 2786 | ca. 1745–50 | 1740 | 1755 | Hard-paste porcelain 572 | Overall: 6 11/16 × 15 3/8 in. (17 × 39.1 cm) | Bequest of Alice Bradford Woolsey, 1970 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/205230 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116707 | 116707 | 1971.274 | 0 | 1 | 205448 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl (jatte à punch) | French, Sèvres 2212 | Factory|Decorator 330 | Probably decorated by | Sèvres Manufactory|Etienne Evans | French, 1740–present|active 1752–1807 | Sèvres Manufactory|EVANS ETIENNE 8655 | French 2 | 1740 |1752 | 9999 |1807 | 1772 | 1772 | 1772 | Soft-paste porcelain 2061 | 5 1/8 × 13 1/4 in. (13 × 33.7 cm) | Rogers Fund, 1971 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/205448 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117873 | 117873 | 1979.496 | 0 | 1 | 206810 | European Sculpture and Decorative Arts 3 | Punch bowl 298 | Punch bowl | Chinese, probably for British market 2595 | 1775–1880 | 1775 | 1880 | Hard-paste porcelain 572 | Overall: 6 9/16 × 16 in. (16.7 × 40.6 cm) | Gift of Louise Crane, in memory of her mother, Mrs. W. Murray Crane, 1979 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/206810 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
338404 | 338404 | 1992.247.1 | 0 | 0 | 486021 | Modern and Contemporary Art 4 | Punch bowl 298 | Punch bowl | Designer 5 | Michael Lacktman | American, born 1938 | Lacktman, Michael 46129 | American 1 | 1938 | 2038 | 1963 | 1963 | 1963 | Silver and wood 22363 | H. 7-1/2, D. 16-1/8 inches (19.1 x 41 cm.) | Gift of Daniel Morris and Denis Gallion, 1992 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/486021 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
6352 | 6352 | 35.14 | 0 | 1 | 6793 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | British 6 | 1730–50 | 1730 | 1750 | Tin-enameled earthenware 193 | H. 6 1/2 in. (16.5 cm); Diam. 12 in. (30.5 cm) | Rogers Fund, 1935 | Made in 1 | Bristol 2 | Bristol 2 | Bristol 2 | England 4 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6793 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
6355 | 6355 | 39.152.1 | 0 | 1 | 6796 | American Decorative Arts 1 | Punch bowl 298 | Punch Bowl | British 6 | 1800–1810 | 1800 | 1810 | Earthenware, transfer-printed 119 | H. 6 1/4 in. (15.9 cm); Diam. 14 in. (35.6 cm) | Gift of Mrs. J. Insley Blair, 1939 | Probably made in 2 | Liverpool 61 | Merseyside 11 | Merseyside 11 | England 4 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/6796 | 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");