Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line, Geography Type, City, Country
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
355 | 355 | 33.120.119 | 0 | 1 | 406 | American Decorative Arts 1 | Beaker 58 | Beaker | American 1 | Maker 1 | Probably | Joseph Russell | 1702–1780 | Russell, Joseph 102 | 1702 | 1780 | ca. 1730 | 1727 | 1730 | Silver 2 | Overall: H. 4 1/2 in. (11.4 cm); 6 oz. 8 dwt. (199.4 g) Lip: Diam. 4 1/16 in. (10.3 cm) Base: Diam. 3 5/16 in. (8.4 cm) | Bequest of Alphonso T. Clearwater, 1933 | Possibly made in|Possibly made in 3 | Barnstable|Bristol 44 | United States|United States 8 | Silver 2 | http://www.metmuseum.org/art/collection/search/406 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
983 | 983 | 33.120.200 | 0 | 1 | 1060 | American Decorative Arts 1 | Butter Tester 144 | Butter Tester | American 1 | Maker 1 | Probably | Thomas Hamersley | 1727–1781 | Hamersley, Thomas 212 | 1727 | 1781 | ca. 1750 | 1747 | 1750 | Silver 2 | L. 6 in. (15.2 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/1060 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
1230 | 1230 | 41.130.1 | 0 | 1 | 1327 | American Decorative Arts 1 | Candlestick 163 | Candlestick | British 6 | Maker 1 | Probably | Samuel Siervent | active from 1755 | Siervent, Samuel 239 | 1755 | 1760 | 1762–63 | 1762 | 1763 | Silver 2 | H. 11 1/4 in. (28.6 cm) | Gift of Mrs. Alice Richards Sorbo and Guy Richards, 1941 | Made in 1 | London 14 | England 4 | Silver 2 | http://www.metmuseum.org/art/collection/search/1327 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
1231 | 1231 | 41.130.2 | 0 | 1 | 1328 | American Decorative Arts 1 | Candlestick 163 | Candlestick | British 6 | Maker 1 | Probably | Samuel Siervent | active from 1755 | Siervent, Samuel 239 | 1755 | 1760 | 1762–63 | 1762 | 1763 | Silver 2 | H. 11 1/4 in. (28.6 cm) | Gift of Mrs. Alice Richards Sorbo and Guy Richards, 1941 | Made in 1 | London 14 | England 4 | Silver 2 | http://www.metmuseum.org/art/collection/search/1328 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
2153 | 2153 | 33.120.139a, b | 0 | 1 | 2334 | American Decorative Arts 1 | Box 114 | Box | American 1 | Maker 1 | Probably | Elias Pelletreau | 1726–1810 | Pelletreau, Elias 371 | 1726 | 1810 | 1753–76 | 1753 | 1776 | Silver 2 | Overall: 1 11/16 x 3 9/16 in. (4.3 x 9 cm); 5 oz. 15 dwt. (179.1 g) Body: 3 oz. 12 dwt. (111.4 g) Cover: 2 oz. 4 dwt. (67.7 g) | Bequest of Alphonso T. Clearwater, 1933 | Probably made in 2 | Southampton 128 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2334 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
4324 | 4324 | 33.120.248 | 0 | 1 | 4663 | American Decorative Arts 1 | Ladle 556 | Ladle | American 1 | Maker 1 | Probably | William Hollingshead | ca. 1723–1808 | Hollingshead, William 635 | 1723 | 1808 | 1755–75 | 1755 | 1775 | Silver 2 | 14 3/4 x 3 7/8 in. (37.5 x 9.8 cm); 6 oz. 7 dwt. (197.6 g) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/4663 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
5178 | 5178 | 33.120.143a, b | 0 | 1 | 5545 | American Decorative Arts 1 | Box 114 | Patch Box | American 1 | Maker 1 | Probably | John Windover | active ca. 1694–1726/27 | Windover, John 777 | 1691 | 1727 | ca. 1694–1726/27 | 1685 | 1735 | Silver 2 | Overall: 1/2 x 2 3/4 x 3/4 in. (1.3 x 7 x 1.9 cm); 1 oz. 7 dwt. (41.9 g) Body: 15 dwt. (23 g) Cover: 12 dwt. (18.9 g) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/5545 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
6264 | 6264 | 33.120.327 | 0 | 1 | 6662 | American Decorative Arts 1 | Porringer 297 | Porringer | American 1 | Maker 1 | Probably | Benjamin Brenton | 1710–1766 | Brenton, Benjamin 902 | 1710 | 1766 | 1730–47 | 1730 | 1747 | Silver 2 | Overall: 2 x 8 1/8 in. (5.1 x 20.6 cm); 8 oz. 19 dwt. (277.6 g) Lip: Diam. 5 1/2 in. (14 cm) Body: Diam. 5 1/2 in. (14 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Newport 81 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/6662 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
6496 | 6496 | 33.120.492 | 0 | 1 | 6953 | American Decorative Arts 1 | Salt Shovel 767 | Salt Shovel | American 1 | Maker 1 | Probably | Nehemiah Norcross | 1765–1804 | Norcross, Nehemiah 952 | 1765 | 1804 | 1770–1800 | 1770 | 1800 | Silver 2 | L. 4 in. (10.2 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/6953 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
6497 | 6497 | 33.120.493 | 0 | 1 | 6954 | American Decorative Arts 1 | Salt Shovel 767 | Salt Shovel | American 1 | Maker 1 | Probably | Nehemiah Norcross | 1765–1804 | Norcross, Nehemiah 952 | 1765 | 1804 | 1770–1800 | 1770 | 1800 | Silver 2 | L. 4 in. (10.2 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/6954 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7093 | 7093 | 33.120.145 | 0 | 1 | 7566 | American Decorative Arts 1 | Box 114 | Snuffbox | American 1 | Maker 1 | Probably | John Targee | American, ca. 1774–1850 | Targee, John 982 | American 1 | 1769 | 1850 | ca. 1815 | 1812 | 1815 | Silver 2 | 5/8 x 3 1/4 x 2 1/8 in. (1.6 x 8.3 x 5.4 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7566 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
7283 | 7283 | 33.120.425 | 0 | 1 | 7762 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | Loring Bailey | 1740–1814 | Bailey, Loring 992 | 1740 | 1814 | 1770–1800 | 1770 | 1800 | Silver 2 | L. 8 3/4 in. (22.2 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7762 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7287 | 7287 | 33.120.409 | 0 | 1 | 7766 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | Benjamin Brenton | 1710–1766 | Brenton, Benjamin 902 | 1710 | 1766 | 1750–70 | 1750 | 1770 | Silver 2 | L. 4 3/4 in. (12.1 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Newport 81 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7766 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7295 | 7295 | 33.71.2 | 0 | 1 | 7775 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | William Cowell Jr. | 1713–1761 | Cowell, Jr. William 996 | 1713 | 1761 | 1740–50 | 1740 | 1750 | Silver 2 | L. 7 3/4 in. (19.7 cm) | Bequest of Margaret N. Breck Stone, in memory of the Hall-Mansfield families of New Haven, Connecticut, 1932 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7775 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7312 | 7312 | 33.120.429 | 0 | 1 | 7792 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | Thomas Kinney | 1786–1824 | Kinney, Thomas 1005 | 1786 | 1824 | ca. 1810 | 1807 | 1810 | Silver 2 | L. 9 3/8 in. (23.8 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Norwich 5 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7792 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7314 | 7314 | 33.120.480 | 0 | 1 | 7794 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | Matthias Lemaire | active ca. 1781–1797 | Lemaire, Matthias 1006 | 1778 | 1797 | 1790–1800 | 1790 | 1800 | Silver 2 | L. 5 1/8 in. (13 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7794 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7358 | 7358 | 33.120.428 | 0 | 1 | 7843 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | Van Voorhis & Schanck | active ca. 1791–93 | Van Voorhis & Schanck 1020 | 1788 | 1793 | ca. 1791 | 1788 | 1791 | Silver 2 | L. 9 in. (22.9 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7843 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7359 | 7359 | 33.120.437 | 0 | 1 | 7844 | American Decorative Arts 1 | Spoon 78 | Spoon | American 1 | Maker 1 | Probably | Van Voorhis & Schanck | active ca. 1791–93 | Van Voorhis & Schanck 1020 | 1788 | 1793 | ca. 1791 | 1788 | 1791 | Silver 2 | L. 9 in. (22.9 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7844 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7416 | 7416 | 40.125 | 0 | 1 | 7903 | American Decorative Arts 1 | Buckle 132 | Stock Buckle | American 1 | Maker 1 | Probably | Otto Parisien | ca. 1725–1811 | Parisien, Otto 752 | 1725 | 1811 | 1765–85 | 1765 | 1785 | Silver 2 | 2 x 1 7/16 in. (5.1 x 3.7 cm) | Rogers Fund, 1940 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7903 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7511 | 7511 | 46.61 | 0 | 1 | 7999 | American Decorative Arts 1 | Sugar Box 868 | Sugar Box | American 1 | Retailer|Maker 11 | Probably | Daniel Greenough|John Coney | 1685/86–1746|1655/56–1722 | Greenough, Daniel|Coney, John 1038 | 1685 |1655 | 1746 |1722 | ca. 1710 | 1705 | 1715 | Silver 2 | 5 3/16 x 7 9/16 x 6 7/16 in. (13.2 x 19.2 x 16.4 cm); 22 oz. (685 g) | Rogers Fund, 1946 | Made in 1 | New Castle 259 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7999 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7524 | 7524 | 24.109.51 | 0 | 1 | 8012 | American Decorative Arts 1 | Tongs 429 | Sugar Tongs | American 1 | Maker 1 | Probably | Benjamin Lemar (Lamar) | active ca. 1775–1785 | Lemar, (Lamar) Benjamin 1045 | 1772 | 1785 | 1775–85 | 1775 | 1785 | Silver 2 | L. 6 1/4 in. (15.9 cm) | Bequest of Charles Allen Munn, 1924 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8012 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7610 | 7610 | 42.133 | 0 | 0 | 8110 | American Decorative Arts 1 | Spoon 78 | Table Spoon | American 1 | Maker 1 | Probably | Garrett Eoff | 1779–1845 | Eoff, Garrett 343 | 1779 | 1845 | 1810–20 | 1810 | 1820 | Silver 2 | L. 8 7/8 in. (22.5 cm) | Gift of Mrs. DeLancey Ward, 1942 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8110 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7616 | 7616 | 47.79 | 0 | 1 | 8116 | American Decorative Arts 1 | Spoon 78 | Table Spoon | American 1 | Maker 1 | Probably | Henry Pratt | 1709–1749 | Pratt, Henry 1061 | 1709 | 1749 | ca. 1725 | 1722 | 1725 | Silver 2 | L. 8 1/4 in. (21 cm) | Gift of Angelica Livingston, 1947 | Made in 1 | Philadelphia 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8116 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7707 | 7707 | 32.75.73 | 0 | 1 | 8210 | American Decorative Arts 1 | Tankard 888 | Tankard | American 1 | Maker 1 | Probably | John Le Roux | baptized 1695 | Le Roux, John 1090 | 1695 | 1740 | ca. 1725 | 1720 | 1730 | Silver 2 | 7 1/8 × 8 3/8 in., 1100g (18.1 × 21.3 cm, 35.366 oz.) Lip diameter: 4 5/8 in. (11.7 cm) Diam. of base: 5 5/8 in. (14.3 cm) | The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932 | Possibly made in|Possibly made in 3 | New York|Albany 139 | United States|United States 8 | Silver 2 | http://www.metmuseum.org/art/collection/search/8210 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7708 | 7708 | 33.120.505 | 0 | 1 | 8211 | American Decorative Arts 1 | Tankard 888 | Tankard | American 1 | Maker 1 | Probably | Thomas Milner or Miller | ca. 1682–1745 | Milner, or Miller Thomas 1091 | 1682 | 1745 | 1735–45 | 1735 | 1745 | Silver 2 | Overall: 8 1/4 x 6 7/8 in. (21 x 17.5 cm); 25 oz. 5 dwt. (785.2 g) Base: Diam. 5 in. (12.7 cm) Lip: Diam. 4 1/16 in. (10.3 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8211 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7910 | 7910 | 33.120.462 | 0 | 1 | 8434 | American Decorative Arts 1 | Spoon 78 | Tea Spoon | American 1 | Maker 1 | Probably | Nicholas Burdock | active ca. 1797 | Burdock, Nicholas 1122 | 1747 | 1847 | 1800–1830 | 1800 | 1830 | Silver 2 | L. 5 1/2 in. (14 cm) | Bequest of Alphonso T. Clearwater, 1933 | Silver 2 | http://www.metmuseum.org/art/collection/search/8434 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
7922 | 7922 | 33.120.463 | 0 | 1 | 8446 | American Decorative Arts 1 | Spoon 78 | Tea Spoon | American 1 | Maker 1 | Probably | Samuel Parmelee | 1737–1803 | Parmelee, Samuel 1129 | 1737 | 1803 | 1770–1800 | 1770 | 1800 | Silver 2 | L. 5 3/8 in. (13.7 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Guilford 113 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8446 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
8106 | 8106 | 33.120.597 | 0 | 1 | 8735 | American Decorative Arts 1 | Tongs 429 | Tongs | American 1 | Maker 1 | Probably | Paul Revere, III | 1760–1813 | Revere, III Paul 1011 | 1760 | 1813 | ca. 1810 | 1807 | 1810 | Silver 2 | L. 5 3/4 in. (14.6 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8735 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
8107 | 8107 | 33.120.598 | 0 | 1 | 8736 | American Decorative Arts 1 | Tongs 429 | Tongs | American 1 | Maker 1 | Probably | Paul Revere, III | 1760–1813 | Revere, III Paul 1011 | 1760 | 1813 | ca. 1810 | 1807 | 1810 | Silver 2 | L. 5 5/8 in. (14.3 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8736 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
8108 | 8108 | 33.120.599 | 0 | 1 | 8737 | American Decorative Arts 1 | Tongs 429 | Tongs | American 1 | Maker 1 | Probably | Paul Revere, III | 1760–1813 | Revere, III Paul 1011 | 1760 | 1813 | ca. 1810 | 1807 | 1810 | Silver 2 | L. 6 3/4 in. (17.1 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/8737 | 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");