Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Department, Object Name, Title, Culture, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Medium, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66433 | 66433 | 1996.118.1 | 0 | 0 | 78958 | Costume Institute 8 | Maillot 5878 | Maillot | American 1 | Designer|Manufacturer 3 | Textile manufactured by | Rudi Gernreich|Westwood Knitting Mills | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Westwood Knitting Mills 5265 | American, born Austria|American 138 | 1922 | 1985 | ca. 1955 | 1950 | 1960 | wool 15104 | Purchase, Irene Lewisohn Bequest, 1996 | http://www.metmuseum.org/art/collection/search/78958 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
66592 | 66592 | 1996.253 | 0 | 0 | 79156 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | 1967–68 | 1967 | 1968 | wool 15104 | Gift of Christina Graybard, 1996 | http://www.metmuseum.org/art/collection/search/79156 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
66818 | 66818 | 1997.43 | 0 | 0 | 79403 | Costume Institute 8 | Maillot 5878 | Maillot | American 1 | Designer|Manufacturer 3 | Textile manufactured by | Rudi Gernreich|Westwood Knitting Mills | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Westwood Knitting Mills 5265 | American, born Austria|American 138 | 1922 | 1985 | 1955–60 | 1955 | 1960 | wool 15104 | Gift of Donna Schachter Sinanian, 1997 | http://www.metmuseum.org/art/collection/search/79403 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
66828 | 66828 | 1996.254a–c | 0 | 0 | 79416 | Costume Institute 8 | Ensemble 5875 | Ensemble | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | 1963–67 | 1963 | 1967 | synthetics 15103 | Gift of Joy Craft, 1996 | http://www.metmuseum.org/art/collection/search/79416 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
68538 | 68538 | 1999.57.1 | 0 | 0 | 81366 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | late 1960s | 1965 | 1969 | acrylic 15557 | Gift of Richard Martin, 1999 | http://www.metmuseum.org/art/collection/search/81366 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
70135 | 70135 | C.I.68.20.3a, b | 0 | 0 | 83987 | Costume Institute 8 | Bikini 5880 | Bikini | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | 1967 | 1967 | 1967 | wool, plastic 15276 | Gift of Rudi Gernreich, 1968 | http://www.metmuseum.org/art/collection/search/83987 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
71828 | 71828 | 1990.243 | 0 | 0 | 86515 | Costume Institute 8 | Bathing suit 5913 | Bathing suit | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | early 1960s | 1960 | 1965 | wool 15104 | Gift of Fay E. Lee, 1990 | http://www.metmuseum.org/art/collection/search/86515 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
73334 | 73334 | 1992.404.1 | 0 | 0 | 91776 | Costume Institute 8 | Bathing trunks 5892 | Bathing trunks | American 1 | Designer|Manufacturer 3 | for | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | early 1960s | 1960 | 1965 | wool 15104 | Gift of Robert Leader, 1992 | http://www.metmuseum.org/art/collection/search/91776 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
91752 | 91752 | 2009.300.2910 | 0 | 0 | 157789 | Costume Institute 8 | Brassiere 5909 | Brassiere | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Exquisite Form | American (born Austria), Vienna 1922–1985 Los Angeles, California | Gernreich, Rudi|Exquisite Form 7207 | American, born Austria 27 | 1922 | 1985 | ca. 1967 | 1965 | 1969 | synthetic 15169 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the estate of Marye E. Murphy, 1972 | http://www.metmuseum.org/art/collection/search/157789 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
91777 | 91777 | 2009.300.2933a–c | 0 | 0 | 157814 | Costume Institute 8 | Beachwear 5881 | Beachwear | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Westwood Knitting Mills | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Westwood Knitting Mills 5265 | American, born Austria|American 138 | 1922 | 1985 | ca. 1965 | 1963 | 1967 | wool 15104 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998 | http://www.metmuseum.org/art/collection/search/157814 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97197 | 97197 | 2009.300.7523 | 0 | 0 | 174576 | Costume Institute 8 | Bathing suit 5913 | Bathing suit | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Westwood Knitting Mills | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Westwood Knitting Mills 5265 | American, born Austria|American 138 | 1922 | 1985 | ca. 1964 | 1962 | 1966 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Susan Beachler, 1967 | http://www.metmuseum.org/art/collection/search/174576 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97868 | 97868 | 2009.300.8231 | 0 | 0 | 175249 | Costume Institute 8 | Evening dress 5874 | Evening dress | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | ca. 1967 | 1965 | 1969 | Wool 20270 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Ruth Ford, 1986 | http://www.metmuseum.org/art/collection/search/175249 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97869 | 97869 | 2009.300.8232a, b | 0 | 0 | 175250 | Costume Institute 8 | Ensemble 5875 | Ensemble | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | ca. 1968 | 1966 | 1970 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Ruth Ford, 1986 | http://www.metmuseum.org/art/collection/search/175250 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97870 | 97870 | 2009.300.8233a, b | 0 | 0 | 175251 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | ca. 1967 | 1965 | 1969 | Wool 20270 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Ruth Ford, 1986 | http://www.metmuseum.org/art/collection/search/175251 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
98012 | 98012 | 2009.300.8388a–c | 0 | 0 | 175393 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | ca. 1968 | 1966 | 1970 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the Boxer family in memory of Emily J. Boxer, 1994 | http://www.metmuseum.org/art/collection/search/175393 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
98037 | 98037 | 2009.300.8421a, b | 0 | 0 | 175418 | Costume Institute 8 | Bathing suit 5913 | Bathing suit | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | ca. 1964 | 1962 | 1966 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998 | http://www.metmuseum.org/art/collection/search/175418 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
98038 | 98038 | 2009.300.8423 | 0 | 0 | 175419 | Costume Institute 8 | Bathing suit 5913 | Bathing suit | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Westwood Knitting Mills | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Westwood Knitting Mills 5265 | American, born Austria|American 138 | 1922 | 1985 | ca. 1965 | 1963 | 1967 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998 | http://www.metmuseum.org/art/collection/search/175419 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
98441 | 98441 | 2009.300.8422 | 0 | 0 | 180671 | Costume Institute 8 | Bathing suit 5913 | Bathing suit | American 1 | Designer|Manufacturer 3 | Rudi Gernreich|Harmon Knitwear | American (born Austria), Vienna 1922–1985 Los Angeles, California|American | Gernreich, Rudi|Harmon Knitwear 5323 | American, born Austria|American 138 | 1922 | 1985 | ca. 1965 | 1960 | 1970 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998 | http://www.metmuseum.org/art/collection/search/180671 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
337520 | 337520 | 1988.31.14 | 0 | 0 | 485093 | Modern and Contemporary Art 4 | Decanter 123 | Decanter | Designer|Manufacturer 3 | Tapio Wirkkala|Iittala Lasitehdas Oy | Finnish, Hanko 1915–1985 Esbo | Wirkkala, Tapio|IITTALA 45892 | Finnish|Finnish 3428 | 1915 | 1985 | ca. 1955 | 1955 | 1955 | Glass 31 | H. 9-3/4, W. 6, Diam. (of body) approx. 4-1/2 inches (24.8 x 15.2 x 11.4 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1988 | Glass 3 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/485093 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
337521 | 337521 | 1988.31.15 | 0 | 0 | 485094 | Modern and Contemporary Art 4 | Glass 6806 | Glass | Designer|Manufacturer 3 | Tapio Wirkkala|Iittala Lasitehdas Oy | Finnish, Hanko 1915–1985 Esbo | Wirkkala, Tapio|IITTALA 45892 | Finnish|Finnish 3428 | 1915 | 1985 | 1950s | 1950 | 1959 | Glass 31 | H. 2-3/4, Diam. 3 inches (7 x 7.6 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1988 | Glass 3 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/485094 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
337523 | 337523 | 1988.31.17 | 0 | 0 | 485096 | Modern and Contemporary Art 4 | Glass 6806 | Glass | Designer|Manufacturer 3 | Tapio Wirkkala|Iittala Lasitehdas Oy | Finnish, Hanko 1915–1985 Esbo | Wirkkala, Tapio|IITTALA 45892 | Finnish|Finnish 3428 | 1915 | 1985 | 1950s | 1950 | 1959 | Glass 31 | H. 3-1/2, D. 3 inches (8.9 x 7.6 cm.) | Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1988 | Glass 3 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/485096 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
339898 | 339898 | 30.134.1 | 0 | 0 | 487677 | Modern and Contemporary Art 4 | Fruit bowl 465 | Fruit bowl | Austrian (Vienna) 6162 | Designer|Manufacturer 3 | Marianne Rath|J. & L. Lobmeyr, Vienna, Austria | Austrian, Vienna 1904–1985 Vienna | Rath, Marianne|Lobmeyr, J. & L. 46552 | Austrian|Austrian 96 | 1904 | 1985 | ca. 1929 | 1924 | 1934 | Glass 31 | H. 6, L. 14-7/8, W. 9-3/4 in. (15.2 x 37.8 x 24.8 cm.) | Purchase, Edward C. Moore Jr. Gift, 1929 | Glass 3 | http://www.metmuseum.org/art/collection/search/487677 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
340976 | 340976 | 56.31.1 | 0 | 0 | 488924 | Modern and Contemporary Art 4 | Vase 7 | "Kanttarelli" Vase (Model No. 3280) | Designer|Manufacturer 3 | Tapio Wirkkala|Iittala Lasitehdas Oy | Finnish, Hanko 1915–1985 Esbo | Wirkkala, Tapio|IITTALA 45892 | Finnish|Finnish 3428 | 1915 | 1985 | designed 1947, manufactured ca. 1950 | 1950 | 1950 | Glass 31 | H. 7-1/2 x W. 6-3/4 in. (19.1 x 17.1 cm.) | Gift of Aarne Simonen, Minister of Commerce and Industry of Finland, 1956 | Glass 3 | http://www.metmuseum.org/art/collection/search/488924 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
339456 | 339456 | 1998.537.20a-d | 0 | 0 | 487111 | Modern and Contemporary Art 4 | Coffee maker 15255 | Coffee maker | Designer|Manufacturer 3 | Lurelle Guild|Aluminum Company of America, Wear-Ever Aluminum Company Inc. Division (New Kensington, PA) | American, New York, New York 1898–1985 Darien, Connecticut | Guild, Lurelle|WEAR-EVER ALUMINUM 46389 | American 1 | 1898 | 1985 | 1934 | 1934 | 1934 | Aluminum, composition 52395 | 7 7/8 × 9 5/8 × 3 7/8 in. (20 × 24.4 × 9.8 cm) | John C. Waddell Collection, Gift of John C. Waddell, 1998 | Metalwork 177 | http://www.metmuseum.org/art/collection/search/487111 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
339479 | 339479 | 1998.537.19a-c | 0 | 0 | 487134 | Modern and Contemporary Art 4 | Cocktail shaker 15263 | Cocktail shaker | Designer|Manufacturer 3 | Lurelle Guild|International Silver Company, Wallace Silver Plate Company Division (Meriden, Connecticut) | American, New York, New York 1898–1985 Darien, Connecticut | Guild, Lurelle|WALLACE SILVER CO 46407 | American 1 | 1898 | 1985 | ca. 1934 | 1934 | 1934 | Metal, enamel, lacquered wood 52410 | H. 15-3/4, Diam. 3-5/8 in. (40 x 9.2 cm.) | John C. Waddell Collection, Gift of John C. Waddell, 1998 | Metalwork 177 | http://www.metmuseum.org/art/collection/search/487134 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
342149 | 342149 | 2000.600.9 | 0 | 0 | 490787 | Modern and Contemporary Art 4 | Bowl 106 | Stratford Compote | Designer|Manufacturer 3 | Lurelle Guild|Aluminum Company of America, Kensington Inc. Division, New Kensington, Pennsylvania | American, New York, New York 1898–1985 Darien, Connecticut | Guild, Lurelle|Aluminum Company of America, Kensington Inc. Division, New Kensi 47106 | American|American 5 | 1898 | 1985 | ca. 1934 | 1929 | 1939 | Aluminum, glass 52948 | H. 5-1/2, D. 13-3/4 in. (14 x 34.9 cm) | John C. Waddell Collection, Gift of John C. Waddell, 2000 | Metalwork 177 | http://www.metmuseum.org/art/collection/search/490787 | 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");