Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Medium
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66552 | 66552 | 06.990 | 0 | 0 | 79098 | Costume Institute 8 | Headdress 3952 | Headdress | Swiss 54 | 1700–1906 | 1700 | 1906 | silver 3219 | Gift of Mrs. Ridgley Hunt in memory of William Cruger Pell, 1906 | http://www.metmuseum.org/art/collection/search/79098 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
68551 | 68551 | 1999.479a, b | 0 | 0 | 81379 | Costume Institute 8 | Shoes 5896 | Shoes | Swiss 54 | Designer 5 | Bally of Switzerland | Swiss, founded 1810 | Bally of Switzerland 5694 | Swiss 61 | 1810 | 9999 | ca. 1935 | 1930 | 1940 | silk, leather 15154 | Gift of Ursula G. Korzenik, 1999 | http://www.metmuseum.org/art/collection/search/81379 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
69949 | 69949 | 2002.199.2a, b | 0 | 0 | 83772 | Costume Institute 8 | Shoes 5896 | Shoes | Swiss 54 | Designer 5 | Walter Steiger | French, born Geneva, 1942 | Steiger Walter 5853 | 1942 | 2042 | mid-1980s | 1983 | 1986 | leather, silk, synthetic 16065 | Gift of Muriel Kallis Newman, 2002 | http://www.metmuseum.org/art/collection/search/83772 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
69953 | 69953 | 2002.199.6a, b | 0 | 0 | 83776 | Costume Institute 8 | Pumps 5885 | Pumps | Swiss 54 | Designer 5 | Walter Steiger | French, born Geneva, 1942 | Steiger Walter 5853 | 1942 | 2042 | 1983–89 | 1983 | 1989 | silk 15101 | Gift of Muriel Kallis Newman, 2002 | http://www.metmuseum.org/art/collection/search/83776 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
69963 | 69963 | 2002.199.17a, b | 0 | 0 | 83786 | Costume Institute 8 | Pumps 5885 | Pumps | Swiss 54 | Designer 5 | Walter Steiger | French, born Geneva, 1942 | Steiger Walter 5853 | 1942 | 2042 | early 1980s | 1980 | 1985 | silk 15101 | Gift of Muriel Kallis Newman, 2002 | http://www.metmuseum.org/art/collection/search/83786 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
69978 | 69978 | 2002.199.13a, b | 0 | 0 | 83801 | Costume Institute 8 | Shoes 5896 | Shoes | Swiss 54 | Designer 5 | Walter Steiger | French, born Geneva, 1942 | Steiger Walter 5853 | 1942 | 2042 | 1980–81 | 1980 | 1981 | leather 15128 | Gift of Muriel Kallis Newman, 2002 | http://www.metmuseum.org/art/collection/search/83801 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
70939 | 70939 | C.I.50.81.1a–m | 0 | 0 | 85071 | Costume Institute 8 | Ensemble 5875 | Ensemble | Swiss 54 | early 20th century | 1900 | 1925 | cotton, silk 15395 | Gift of Mary Alice Dykman Dean, 1950 | http://www.metmuseum.org/art/collection/search/85071 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
72395 | 72395 | C.I.40.175.2 | 0 | 1 | 89017 | Costume Institute 8 | Shoes 5896 | Shoes | Swiss 54 | 18th century | 1700 | 1799 | leather 15128 | Gift of Mrs. DeWitt Clinton Cohen, 1940 | http://www.metmuseum.org/art/collection/search/89017 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
72403 | 72403 | 1981.175a, b | 0 | 1 | 89136 | Costume Institute 8 | Stockings 1158 | Stockings | Swiss 54 | ca. 1860 | 1855 | 1865 | cotton 3340 | Gift of Anonymous, 1981 | http://www.metmuseum.org/art/collection/search/89136 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
72459 | 72459 | C.I.44.80.8a–m | 0 | 0 | 89671 | Costume Institute 8 | Ensemble 5875 | Ensemble | Swiss 54 | 1700–1944 | 1700 | 1944 | (a) linen (b) wool (d, g) cotton (i, j) silk (k, l) leather 16690 | Gift of The J. L. Hudson Company, 1944 | http://www.metmuseum.org/art/collection/search/89671 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
72539 | 72539 | 21.136.4 | 0 | 1 | 90104 | Costume Institute 8 | Waistcoat 1202 | Waistcoat | Swiss 54 | 18th century | 1700 | 1799 | linen 15098 | Gift of Miss Margaret Taylor Johnstone, 1921 | http://www.metmuseum.org/art/collection/search/90104 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
72622 | 72622 | C.I.45.68.128a–j | 0 | 0 | 90320 | Costume Institute 8 | Jewelry Set 5901 | Jewelry set | Swiss 54 | 1850–99 | 1850 | 1899 | [no medium available] 15100 | Gift of Art Worker's Club, 1945 | http://www.metmuseum.org/art/collection/search/90320 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
73283 | 73283 | C.I.69.37.8 | 0 | 0 | 91717 | Costume Institute 8 | Turtleneck sweater 6233 | Turtleneck sweater | Swiss 54 | ca. 1958 | 1953 | 1963 | cotton 3340 | Gift of Mr. and Mrs. Burton Tremaine, 1969 | http://www.metmuseum.org/art/collection/search/91717 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
73284 | 73284 | C.I.69.37.9 | 0 | 0 | 91718 | Costume Institute 8 | Turtleneck sweater 6233 | Turtleneck sweater | Swiss 54 | ca. 1958 | 1953 | 1963 | cotton 3340 | Gift of Mr. and Mrs. Burton Tremaine, 1969 | http://www.metmuseum.org/art/collection/search/91718 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
74186 | 74186 | 2003.410a–d | 0 | 0 | 94335 | Costume Institute 8 | Ensemble 5875 | Ensemble | Swiss 54 | Design House|Designer|Designer 211 | Amok|Sandra Kuratle|Bally of Switzerland | Swiss, founded 1996|Swiss, born 1966|Swiss, founded 1810 | for|(Shoes) | Amok|Kuratle Sandra|Bally of Switzerland 6183 | Swiss|Swiss|Swiss 217 | 1996 |1966 |1810 | 9999 |2066 |9999 | fall/winter 2003–4 | 2003 | 2004 | a,b) cotton; c,d) leather, rubber, cotton 16944 | Gift of Amok by Sandra Kuratle, 2003 | http://www.metmuseum.org/art/collection/search/94335 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
74550 | 74550 | 1991.63.34 | 0 | 0 | 94971 | Costume Institute 8 | Watch 557 | Watch | Swiss 54 | 1970–89 | 1970 | 1989 | leather, metal, glass 16942 | Gift of Mr. Jean-François Daigre, 1991 | http://www.metmuseum.org/art/collection/search/94971 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
74761 | 74761 | C.I.69.37.10 | 0 | 0 | 95282 | Costume Institute 8 | Turtleneck sweater 6233 | Turtleneck sweater | Swiss 54 | ca. 1958 | 1953 | 1963 | cotton 3340 | Gift of Mr. and Mrs. Burton Tremaine, 1969 | http://www.metmuseum.org/art/collection/search/95282 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
76544 | 76544 | 2004.28a, b | 0 | 1 | 98556 | Costume Institute 8 | Necklace 237 | Necklace | Swiss 54 | Designer 5 | Jean Dunand | French (born Switzerland), Lancy 1877–1942 Paris | Dunand, Jean 6378 | French, born Switzerland 231 | 1877 | 1942 | ca. 1927 | 1922 | 1932 | (a,b) metal, lacquer 17285 | Purchase, Friends of The Costume Institute Gifts, 2004 | http://www.metmuseum.org/art/collection/search/98556 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
78551 | 78551 | 1987.353.7 | 0 | 0 | 104500 | Costume Institute 8 | Bib 6319 | Bib | Swiss 54 | 1960 | 1960 | 1960 | cotton, silk, linen (?) 17546 | Gift of Mrs. Wesley Wright, Jr., 1987 | http://www.metmuseum.org/art/collection/search/104500 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
78802 | 78802 | 1986.332 | 0 | 0 | 104896 | Costume Institute 8 | Watch 557 | Watch | Swiss 54 | 1940s | 1940 | 1949 | gold, diamonds, rubies 17623 | Gift of Polaire Weissman, 1986 | http://www.metmuseum.org/art/collection/search/104896 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
81807 | 81807 | 1980.444.4 | 0 | 1 | 112621 | Costume Institute 8 | Cap 173 | Cap | Swiss 54 | 1700–1725 | 1700 | 1725 | silk, cotton, metal 16197 | Purchase, Irene Lewisohn Bequest, 1980 | http://www.metmuseum.org/art/collection/search/112621 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
82477 | 82477 | 1989.375.9 | 0 | 0 | 113724 | Costume Institute 8 | Watch 557 | Watch | Swiss 54 | Manufacturer 20 | Swatch | Swiss, founded 1983 | Swatch 6623 | Swiss 61 | 1983 | 9999 | ca. 1983 | 1980 | 1985 | plastic 15143 | Gift of Gregory R. Reynolds, 1989 | http://www.metmuseum.org/art/collection/search/113724 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
83288 | 83288 | 1973.242a, b | 0 | 0 | 115568 | Costume Institute 8 | Shoes 5896 | Shoes | Swiss 54 | 1959 | 1959 | 1959 | alligator skin 15223 | Gift of Ferris Megarity, 1973 | http://www.metmuseum.org/art/collection/search/115568 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
83375 | 83375 | 1979.579.1a, b | 0 | 0 | 115678 | Costume Institute 8 | Oxfords 6210 | Oxfords | Swiss 54 | Designer 5 | Bally of Switzerland | Swiss, founded 1810 | Bally of Switzerland 5694 | Swiss 61 | 1810 | 9999 | ca. 1969 | 1964 | 1974 | leather 15128 | Gift of David Toser, 1979 | http://www.metmuseum.org/art/collection/search/115678 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
83519 | 83519 | C.I.69.37.16a, b | 0 | 0 | 115878 | Costume Institute 8 | Ski boots 6448 | Ski boots | Swiss 54 | 1950–69 | 1950 | 1969 | leather, metal, plastic 15529 | Gift of Mr. and Mrs. Burton Tremaine, 1969 | http://www.metmuseum.org/art/collection/search/115878 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
86320 | 86320 | 1978.582.172 | 0 | 0 | 121793 | Costume Institute 8 | Cane 170 | Cane | Swiss 54 | 1950s | 1950 | 1959 | wood, metal 16714 | Gift of Marvin B. Patterson (Mrs. Jefferson Patterson), 1978 | http://www.metmuseum.org/art/collection/search/121793 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
87451 | 87451 | C.I.39.61.7 | 0 | 1 | 124828 | Costume Institute 8 | Head Protector 6273 | Head protector | Swiss 54 | late 18th century | 1775 | 1799 | silk 15101 | Gift of Mrs. DeWitt Clinton Cohen, 1939 | http://www.metmuseum.org/art/collection/search/124828 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
87849 | 87849 | C.I.41.110.33a–c | 0 | 0 | 127428 | Costume Institute 8 | Ensemble 5875 | Ensemble | Swiss 54 | 1800–1941 | 1800 | 1941 | cotton 3340 | Gift of Mrs. Van S. Merle-Smith, 1941 | http://www.metmuseum.org/art/collection/search/127428 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
90104 | 90104 | 2009.300.1399 | 0 | 0 | 156109 | Costume Institute 8 | Wedding Headdress 6356 | Wedding headdress | Swiss 54 | 1885–1900 | 1885 | 1900 | silk, cotton, metal, paper, straw 19247 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Brooklyn Museum Collection, 1924 | http://www.metmuseum.org/art/collection/search/156109 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
90523 | 90523 | 2009.300.1776 | 0 | 1 | 156528 | Costume Institute 8 | Hat 1056 | Hat | Swiss 54 | first quarter 19th century | 1800 | 1825 | straw, wool, cotton 19346 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Pratt Institute, 1943 | http://www.metmuseum.org/art/collection/search/156528 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
91093 | 91093 | 2009.300.2299 | 0 | 1 | 157108 | Costume Institute 8 | Cap 173 | Cap | Swiss 54 | second quarter 19th century | 1826 | 1850 | cotton, silk 15395 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Brooklyn Museum Collection, 1924 | http://www.metmuseum.org/art/collection/search/157108 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
91289 | 91289 | 2009.300.2475 | 0 | 1 | 157304 | Costume Institute 8 | Bodice 5970 | Bodice | Swiss 54 | third quarter 19th century | 1851 | 1875 | silk, metal, cotton 17005 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Edwin A. Neugass, 1959 | http://www.metmuseum.org/art/collection/search/157304 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
91498 | 91498 | 2009.300.2662 | 0 | 0 | 157514 | Costume Institute 8 | Hat 1056 | Hat | Swiss 54 | first quarter 20th century | 1900 | 1925 | straw, wool, cotton 19346 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Brooklyn Museum Collection | http://www.metmuseum.org/art/collection/search/157514 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
91503 | 91503 | 2009.300.2667 | 0 | 1 | 157519 | Costume Institute 8 | Handkerchief 1048 | Handkerchief | Swiss 54 | third quarter 19th century | 1851 | 1875 | cotton 3340 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Carll H. de Silver, 1909 | http://www.metmuseum.org/art/collection/search/157519 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
94617 | 94617 | 2009.300.5083 | 0 | 0 | 169305 | Costume Institute 8 | Brisé fan 6285 | Brisé fan | Swiss 54 | fourth quarter 19th century | 1876 | 1899 | Wood, silk, metal 19843 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of H. Dunscombe Colt, 1960 | http://www.metmuseum.org/art/collection/search/169305 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
95503 | 95503 | 2009.300.5998a, b | 0 | 0 | 170191 | Costume Institute 8 | Evening shoes 5884 | Evening shoes | Swiss 54 | Manufacturer 20 | Bally of Switzerland | Swiss, founded 1810 | Bally of Switzerland 5694 | Swiss 61 | 1810 | 9999 | ca. 1963 | 1961 | 1965 | Leather, rhinestones 20109 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986 | http://www.metmuseum.org/art/collection/search/170191 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
95530 | 95530 | 2009.300.6026a, b | 0 | 0 | 170218 | Costume Institute 8 | Evening shoes 5884 | Evening shoes | Swiss 54 | Retailer 8 | McCreedy and Schreiber | McCreedy and Schreiber 7671 | ca. 1960 | 1958 | 1962 | Leather 732 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of George Drew, 1988 | http://www.metmuseum.org/art/collection/search/170218 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
96104 | 96104 | 2009.300.6238 | 0 | 0 | 173286 | Costume Institute 8 | Headdress 3952 | Headdress | Swiss 54 | 1890–1910 | 1890 | 1910 | Silk, metal 14029 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Brooklyn Museum Collection, 1920 | http://www.metmuseum.org/art/collection/search/173286 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
96132 | 96132 | 2009.300.6267 | 0 | 0 | 173314 | Costume Institute 8 | Hat 1056 | Hat | Swiss 54 | 1850–99 | 1851 | 1899 | Straw 182 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; A. Augustus Healy Fund, 1926 | http://www.metmuseum.org/art/collection/search/173314 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
96372 | 96372 | 2009.300.6547 | 0 | 1 | 173554 | Costume Institute 8 | Undershirt 5979 | Undershirt | Swiss 54 | ca. 1895 | 1893 | 1897 | Cotton, silk 2163 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Henry Oren in memory of her mother, 1945 | http://www.metmuseum.org/art/collection/search/173554 | 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");