Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104085 | 104085 | 11.60.84 | 0 | 1 | 191678 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a service) | British, Derby 2295 | Factory 328 | Crown Derby | British, 1750–present | Crown Derby 8168 | 1750 | 9999 | ca. 1810–30 | 1805 | 1835 | Bone china 21081 | Bequest of Mrs. Maria P. James, 1911 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/191678 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
104088 | 104088 | 11.60.87 | 0 | 1 | 191681 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a dinner service) | British, Derby 2295 | Factory 328 | Crown Derby | British, 1750–present | Crown Derby 8168 | 1750 | 9999 | ca. 1810–30 | 1805 | 1835 | Bone china 21081 | Bequest of Mrs. Maria P. James, 1911 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/191681 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
112068 | 112068 | 48.187.367 | 0 | 1 | 200337 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of two of graduated size) | French, Paris 114 | Maker 1 | Edme-Pierre Balzac | 1705–ca. 1786, master 1739, recorded 1781 | Balzac Edme-Pierre 9744 | 1705 | 1786 | 1771–72 | 1771 | 1772 | Silver 2 | Overall: 1 1/16 × 12 3/4 in. (2.7 × 32.4 cm) | Bequest of Catherine D. Wentworth, 1948 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/200337 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
112069 | 112069 | 48.187.368 | 0 | 1 | 200338 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of two of graduated size) | French, Paris 114 | Maker 1 | Edme-Pierre Balzac | 1705–ca. 1786, master 1739, recorded 1781 | Balzac Edme-Pierre 9744 | 1705 | 1786 | 1771–72 | 1771 | 1772 | Silver 2 | Overall: 1 × 11 13/16 in. (2.5 × 30 cm) | Bequest of Catherine D. Wentworth, 1948 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/200338 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
112776 | 112776 | 51.86.87 | 0 | 1 | 201062 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, possibly for Continental market 3119 | 1750–70 | 1750 | 1770 | Hard-paste porcelain 572 | Diameter: 9 in. (22.9 cm) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201062 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
112777 | 112777 | 51.86.88 | 0 | 1 | 201063 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, possibly for Continental market 3119 | 1750–70 | 1750 | 1770 | Hard-paste porcelain 572 | Diameter: 8 7/8 in. (22.5 cm) | Helena Woolworth McCann Collection, Gift of Winfield Foundation, 1951 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/201063 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113160 | 113160 | 52.206.1 | 0 | 1 | 201450 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a set of six) | British, Staffordshire 2229 | Artist 2 | John Turner | active 1762–86 | Turner John 8584 | 1762 | 1786 | ca. 1790 | 1785 | 1795 | Earthenware 21 | Diameter: 7 15/16 in. (20.2 cm) | Gift of Mrs. Bernice Chrysler Garbisch, 1952 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/201450 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
114087 | 114087 | 60.78.1 | 0 | 1 | 202463 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, for British market 2786 | Artist 2 | Decoration after a design by | Pieter Boel | 1622–1674 | BOEL PIETER 10933 | 1622 | 1674 | ca. 1740 | 1735 | 1745 | Hard-paste porcelain 572 | Overall: 1 1/2 × 11 in. (3.8 × 27.9 cm) | Helena Woolworth McCann Collection, Purchase, Winfield Foundation Gift, 1960 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/202463 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
114088 | 114088 | 60.78.2 | 0 | 1 | 202464 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, for British market 2786 | Artist 2 | After a design by | Pieter Boel | 1622–1674 | BOEL PIETER 10933 | 1622 | 1674 | ca. 1740 | 1735 | 1745 | Hard-paste porcelain 572 | Overall: 1 1/2 × 11 in. (3.8 × 27.9 cm) | Helena Woolworth McCann Collection, Purchase, Winfield Foundation Gift, 1960 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/202464 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
114233 | 114233 | 62.125.2 | 0 | 1 | 202639 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a pair) | Chinese, for British or Scottish market 3197 | mid-18th century | 1730 | 1765 | Hard-paste porcelain 572 | Overall: 1 × 9 1/16 in. (2.5 × 23 cm) | Helena Woolworth McCann Collection, Purchase, Winfield Foundation Gift, 1962 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/202639 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116476 | 116476 | 1970.96.1 | 0 | 1 | 205189 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, for German market 3125 | ca. 1750–55 | 1745 | 1760 | Hard-paste porcelain 572 | Diameter: 9 in. (22.9 cm) | Helena Woolworth McCann Collection, Purchase, Winfield Foundation Gift, 1970 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/205189 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116477 | 116477 | 1970.96.2 | 0 | 1 | 205190 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, for German market 3125 | ca. 1750–55 | 1745 | 1760 | Hard-paste porcelain 572 | Diameter: 9 in. (22.9 cm) | Helena Woolworth McCann Collection, Purchase, Winfield Foundation Gift, 1979 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/205190 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116525 | 116525 | 1970.220.2 | 0 | 1 | 205240 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, for Russian market 3186 | ca. 1780–90 | 1775 | 1795 | Hard-paste porcelain 572 | Diameter: 9 5/8 in. (24.4 cm) | The Lucile and Robert H. Gries Charity Fund, 1970 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/205240 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116526 | 116526 | 1970.220.3 | 0 | 1 | 205241 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | Chinese, for Russian market 3186 | ca. 1780–90 | 1775 | 1795 | Hard-paste porcelain 572 | Diameter: 7 1/2 in. (19.1 cm) | The Lucile and Robert H. Gries Charity Fund, 1970 | Ceramics-Porcelain-Export 308 | http://www.metmuseum.org/art/collection/search/205241 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116632 | 116632 | 1971.180.154 | 0 | 0 | 205358 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of five) | French 7 | 19th century | 1800 | 1899 | Lead-glazed earthenware 20492 | Height: 3/4 in. (1.9 cm); Diameter: 8 1/16 in. (20.5 cm) | Bequest of Flora E. Whiting, 1971 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/205358 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116633 | 116633 | 1971.180.155 | 0 | 0 | 205359 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of five) | French 7 | 19th century | 1800 | 1899 | Lead-glazed earthenware 20492 | Height: 3/4 in. (1.9 cm); Diameter: 8 1/4 in. (21 cm) | Bequest of Flora E. Whiting, 1971 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/205359 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116634 | 116634 | 1971.180.156 | 0 | 0 | 205360 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of five) | French 7 | 19th century | 1800 | 1899 | Lead-glazed earthenware 20492 | Height: 11/16 in. (1.7 cm); Diameter: 8 3/16 in. (20.8 cm) | Bequest of Flora E. Whiting, 1971 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/205360 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116635 | 116635 | 1971.180.157 | 0 | 0 | 205361 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of five) | French 7 | 19th century | 1800 | 1899 | Lead-glazed earthenware 20492 | Height: 11/16 in. (1.7 cm); Diameter: 8 3/16 in. (20.8 cm) | Bequest of Flora E. Whiting, 1971 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/205361 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
116636 | 116636 | 1971.180.158 | 0 | 0 | 205362 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of a set of five) | French 7 | 19th century | 1800 | 1899 | Lead-glazed earthenware 20492 | Height: 3/4 in. (1.9 cm); Diameter: 8 3/16 in. (20.8 cm) | Bequest of Flora E. Whiting, 1971 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/205362 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
117296 | 117296 | 1974.356.680 | 0 | 1 | 206180 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a traveling set) | French, Strasbourg 258 | Maker|Maker 6 | Probably by|Probably by | Joachim-Frédéric Kirstein I|Johann Friedrich Krug | master in 1729 | (master in 1739) | Kirstein I Joachim-Frédéric|KRUG JOHANN FRIEDRICH 10585 | 1729 |1700 | 1729 |1800 | ca. 1750 | 1745 | 1755 | Silver 2 | Diameter: 9 7/8 in. (25.1 cm) | The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/206180 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117445 | 117445 | 1975.434.1 | 0 | 1 | 206346 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | German, Meissen 2269 | Decorator|Manufactory|Artist 496 | Decorated in the manner of|After a print by | Franz Ferdinand Mayer|Meissen Manufactory|Gottfried Bernhard Göz | German, 1710–present|1708–1771 | Mayer Franz Ferdinand|Meissen Manufactory|Göz Gottfried Bernhard 11502 | German 10 | 1700 |1710 |1708 | 1800 |9999 |1771 | ca. 1760 | 1755 | 1765 | Hard-paste porcelain 572 | Diameter: 8 7/8 in. (22.5 cm) | Gift of Mr. and Mrs. Henry H. Arnhold, in memory of Mrs. Lisa Arnhold, 1975 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/206346 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117446 | 117446 | 1975.434.2 | 0 | 1 | 206347 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | German, Meissen 2269 | Decorator|Manufactory|Artist 496 | Decorated in the manner of|After a print by | Franz Ferdinand Mayer|Meissen Manufactory|Gottfried Bernhard Göz | German, 1710–present|1708–1771 | Mayer Franz Ferdinand|Meissen Manufactory|Göz Gottfried Bernhard 11502 | German 10 | 1700 |1710 |1708 | 1800 |9999 |1771 | ca. 1760 | 1755 | 1765 | Hard-paste porcelain 572 | Diameter: 8 7/8 in. (22.5 cm) | Gift of Mr. and Mrs. Henry H. Arnhold, in memory of Mrs. Lisa Arnhold, 1975 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/206347 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117525 | 117525 | 1976.155.40 | 0 | 1 | 206436 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | German, Augsburg 126 | Maker 1 | Gottlieb Menzel | 1676–1757, master 1709 | Menzel Gottlieb 11481 | 1676 | 1757 | 1730 | 1730 | 1730 | Silver gilt 9203 | Diameter (confirmed): 9 3/4 in., 23.658oz. (24.8 cm, 670.7g) | Gift of Mr. and Mrs. Charles Wrightsman, 1976 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/206436 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
117526 | 117526 | 1976.155.41 | 0 | 1 | 206437 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (one of two) | German, Augsburg 126 | Maker 1 | Gottlieb Menzel | 1676–1757, master 1709 | Menzel Gottlieb 11481 | 1676 | 1757 | 1730 | 1730 | 1730 | Silver gilt 9203 | Diameter (confirmed): 9 3/4 in., 23.32oz. (24.8 cm, 661.1g) | Gift of Mr. and Mrs. Charles Wrightsman, 1976 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/206437 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
119555 | 119555 | L.1970.72.1 | 0 | 0 | 208607 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate from a table service owned by Chancellor Robert R. Livingston of New York | French, Paris 114 | Maker 1 | Jacques-Nicolas Roettiers | 1736–1788, master 1765, retired 1777 | Roettiers Jacques-Nicolas 9899 | 1736 | 1788 | 1775–76 | 1775 | 1776 | Silver 2 | Overall: 26.826oz. (760.5g) | Lent by the Rector, Wardens, and Vestry of St. Paul's and Trinity Parish, Tivoli, New York | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/208607 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
120981 | 120981 | 52.206.2 | 0 | 1 | 210222 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a set of six) | British, Staffordshire 2229 | Maker 1 | John Turner | active 1762–86 | Turner John 8584 | 1762 | 1786 | ca. 1790 | 1785 | 1795 | Earthenware 21 | Diameter: 7 7/8 in. (20 cm) | Gift of Mrs. Bernice Chrysler Garbisch, 1952 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/210222 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
120982 | 120982 | 52.206.3 | 0 | 1 | 210223 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a set of six) | British, Staffordshire 2229 | Maker 1 | John Turner | active 1762–86 | Turner John 8584 | 1762 | 1786 | ca. 1790 | 1785 | 1795 | Earthenware 21 | Diameter: 7 13/16 in. (19.8 cm) | Gift of Mrs. Bernice Chrysler Garbisch, 1952 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/210223 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
120983 | 120983 | 52.206.4 | 0 | 1 | 210224 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a set of six) | British, Staffordshire 2229 | Maker 1 | John Turner | active 1762–86 | Turner John 8584 | 1762 | 1786 | ca. 1790 | 1785 | 1795 | Earthenware 21 | Diameter: 7 15/16 in. (20.2 cm) | Gift of Mrs. Bernice Chrysler Garbisch, 1952 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/210224 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
120984 | 120984 | 52.206.5 | 0 | 1 | 210225 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a set of six) | British, Staffordshire 2229 | Maker 1 | John Turner | active 1762–86 | Turner John 8584 | 1762 | 1786 | ca. 1790 | 1785 | 1795 | Earthenware 21 | Diameter: 7 15/16 in. (20.2 cm) | Gift of Mrs. Bernice Chrysler Garbisch, 1952 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/210225 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
120985 | 120985 | 52.206.6 | 0 | 1 | 210226 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate (part of a set of six) | British, Staffordshire 2229 | Maker 1 | John Turner | active 1762–86 | Turner John 8584 | 1762 | 1786 | ca. 1790 | 1785 | 1795 | Earthenware 21 | Diameter: 7 7/8 in. (20 cm) | Gift of Mrs. Bernice Chrysler Garbisch, 1952 | Ceramics-Pottery 314 | http://www.metmuseum.org/art/collection/search/210226 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
139984 | 139984 | L.1970.72.2 | 0 | 0 | 237722 | European Sculpture and Decorative Arts 3 | Plate 7443 | Plate from a table service owned by Chancellor Robert R. Livingston of New York | French, Paris 114 | Maker 1 | Jacques-Nicolas Roettiers | 1736–1788, master 1765, retired 1777 | Roettiers Jacques-Nicolas 9899 | 1736 | 1788 | 1775–76 | 1775 | 1776 | Silver 2 | Overall: 25.979oz. (736.5g) | Lent by the Rector, Wardens, and Vestry of St. Paul's and Trinity Parish, Tivoli, New York | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/237722 | 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");