Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Title, Culture, 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, Classification, Artist End Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66564 | 66564 | 1996.217.2 | 0 | 0 | 79115 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Pierre Balmain|House of Balmain | French, St. Jean de Maurienne 1914–1982 Paris|French, founded 1945 | Balmain, Pierre|Balmain House of 5318 | French|French 21 | 1914 |1945 | 1982 |9999 | ca. 1960 | 1955 | 1965 | silk 15101 | Gift of Joan Lipton, 1996 | http://www.metmuseum.org/art/collection/search/79115 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
66582 | 66582 | 1996.237.1 | 0 | 0 | 79146 | Costume Institute 8 | Raincoat 5903 | Raincoat | British 6 | Designer 5 | Paul Smith | British, born 1946 | Smith Paul 5320 | British 7 | 1946 | 2046 | ca. 1991 | 1986 | 1996 | synthetics 15103 | Gift of Brooks Adams and Lisa Liebmann, 1996 | http://www.metmuseum.org/art/collection/search/79146 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
66977 | 66977 | 1997.193.3a, b | 0 | 0 | 79574 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer 5 | André Courrèges | French, Pau 1923–2016 Neuilly-sur-Seine | Courrèges, André 5436 | French 2 | 1923 | 2016-01-07 | ca. 1967 | 1962 | 1972 | vinyl, leather 15283 | Polaire Weissman Fund, 1997 | http://www.metmuseum.org/art/collection/search/79574 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
70095 | 70095 | 1982.40.1 | 0 | 0 | 83941 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Designer|Manufacturer 3 | Bonnie Cashin|Adler and Adler | American, Oakland, California 1908–2000 New York|American | Cashin, Bonnie|Adler and Adler 5874 | American|American 5 | 1908 | 2000 | 1951 | 1951 | 1951 | cotton 3340 | Gift of Bonnie Cashin, 1982 | http://www.metmuseum.org/art/collection/search/83941 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
70189 | 70189 | C.I.58.49.17 | 0 | 0 | 84045 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Designer 5 | Claire McCardell | American, 1905–1958 | McCardell Claire 5437 | American 1 | 1905 | 1958 | 1948 | 1948 | 1948 | cotton, metal 15378 | Gift of Irving Drought Harris, in memory of Claire McCardell Harris, 1958 | http://www.metmuseum.org/art/collection/search/84045 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
70208 | 70208 | 1977.362.33a–e | 0 | 0 | 84068 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Designer|Design House 202 | Anne Klein|Anne Klein and Company | American, Brooklyn, New York 1923–1974 New York|American, founded 1965 | Klein, Anne|Klein Anne and Company 5516 | American|American 5 | 1923 |1965 | 1974 |9999 | fall/winter 1971–72 | 1971 | 1972 | cotton, leather, wool d) leather e) wool 16160 | Gift of M.N. Rubinstein, 1977 | http://www.metmuseum.org/art/collection/search/84068 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
70952 | 70952 | 2002.300.4 | 0 | 0 | 85180 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Design House|Designer 198 | Yves Saint Laurent, Paris|Yves Saint Laurent | French, founded 1961|French (born Algeria) Oran 1936–2008 Paris | Saint Laurent Yves, Paris|Saint Laurent Yves 5549 | French|French 21 | 1961 |1936 | 9999 |2008 | 1960s | 1960 | 1969 | silk 15101 | Gift of Mrs. Anne E. de la Renta, 2002 | http://www.metmuseum.org/art/collection/search/85180 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
72267 | 72267 | C.I.41.86.30 | 0 | 0 | 88255 | Asian Art 7 | Raincoat 5903 | Japanese 35 | 1800–1941 | 1800 | 1941 | rice straw 16626 | Length: 42 in. (106.7 cm) | Gift of Mr. George R. Dyer, 1941 | Outerwear-Menswear 251 | http://www.metmuseum.org/art/collection/search/88255 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
72268 | 72268 | 1979.418.2 | 0 | 0 | 88256 | Arts of Africa, Oceania, and the Americas 10 | Raincoat 5903 | Raincoat | Philippine 655 | ca. 1902 | 1897 | 1907 | coconut fiber 16627 | Length (about): 46 in. (116.8 cm) | Gift of Mr. and Mrs. Edwin F. Celette, 1979 | Outerwear 246 | http://www.metmuseum.org/art/collection/search/88256 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
72269 | 72269 | 1981.183a, b | 0 | 0 | 88257 | Asian Art 7 | Raincoat 5903 | Chinese 10 | early 20th century | 1900 | 1950 | coconut fiber 16627 | Length (a): 27 in. (68.6 cm) Length (b): 23 1/2 in. (59.7 cm) | Gift of David Saperstein, 1981 | Outerwear 246 | http://www.metmuseum.org/art/collection/search/88257 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
73632 | 73632 | 1982.276.2 | 0 | 0 | 92108 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Department Store 208 | Bergdorf Goodman | American, founded 1899 | Bergdorf Goodman 5548 | American 1 | 1899 | 9999 | 1972 | 1972 | 1972 | cotton 3340 | Gift of Edward Villiotti, 1982 | http://www.metmuseum.org/art/collection/search/92108 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
73694 | 73694 | 1985.375.5 | 0 | 0 | 92171 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Designer|Secondary Line|Design House 216 | Ralph Lauren|Polo Ralph Lauren|Ralph Lauren | American, born 1939|American, founded 1968|American, founded 1967 | Lauren Ralph|Polo Ralph Lauren|Lauren Ralph 6128 | American|American|American 101 | 1939 |1968 |1967 | 2039 |1968 |9999 | spring/summer 1979 | 1979 | 1979 | polyurethane, cotton, metal 16798 | Gift of Barbara and Gregory Reynolds, 1985 | http://www.metmuseum.org/art/collection/search/92171 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74246 | 74246 | 1994.96.2 | 0 | 0 | 94562 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Hubert de Givenchy|House of Givenchy | French, Beauvais 1927–2018 Paris|French, founded 1952 | Givenchy, Hubert de|Givenchy House of 5358 | French|French 21 | 1927 |1952 | 2018 |9999 | early 1990s | 1990 | 1990 | silk 15101 | Gift of Mrs. William McCormick Blair, Jr., 1994 | http://www.metmuseum.org/art/collection/search/94562 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74588 | 74588 | 1973.17.2 | 0 | 0 | 95077 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Cristobal Balenciaga|House of Balenciaga | Spanish, Guetaria, San Sebastian 1895–1972 Javea|French, founded 1937 | Balenciaga, Cristobal|Balenciaga House of 5299 | Spanish|French 143 | 1895-01-21|1937 | 1972-03-23|9999 | 1968 | 1968 | 1968 | wool 15104 | Gift of Mrs. Nathan Cummings, 1973 | http://www.metmuseum.org/art/collection/search/95077 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74595 | 74595 | 1973.57.2a, b | 0 | 0 | 95085 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Cristobal Balenciaga|House of Balenciaga | Spanish, Guetaria, San Sebastian 1895–1972 Javea|French, founded 1937 | Balenciaga, Cristobal|Balenciaga House of 5299 | Spanish|French 143 | 1895-01-21|1937 | 1972-03-23|9999 | ca. 1968 | 1963 | 1973 | wool 15104 | Gift of Mollie Parnis Livingston, 1973 | http://www.metmuseum.org/art/collection/search/95085 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74820 | 74820 | 1981.249.1a–c | 0 | 0 | 95405 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Cristobal Balenciaga|House of Balenciaga | Spanish, Guetaria, San Sebastian 1895–1972 Javea|French, founded 1937 | Balenciaga, Cristobal|Balenciaga House of 5299 | Spanish|French 143 | 1895-01-21|1937 | 1972-03-23|9999 | ca. 1967 | 1962 | 1968 | cotton 3340 | Gift of Countess Edward Bismarck, 1981 | http://www.metmuseum.org/art/collection/search/95405 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74871 | 74871 | 1975.53.5 | 0 | 0 | 95461 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Cristobal Balenciaga|House of Balenciaga | Spanish, Guetaria, San Sebastian 1895–1972 Javea|French, founded 1937 | Balenciaga, Cristobal|Balenciaga House of 5299 | Spanish|French 143 | 1895-01-21|1937 | 1972-03-23|9999 | fall/winter 1963–64 | 1963 | 1964 | [no medium available] 15100 | Gift of Mrs. Lyn Revson, 1975 | http://www.metmuseum.org/art/collection/search/95461 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
75027 | 75027 | C.I.50.21.2a–c | 0 | 0 | 96121 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Design House 202 | Pierre Balmain|House of Balmain | French, St. Jean de Maurienne 1914–1982 Paris|French, founded 1945 | Balmain, Pierre|Balmain House of 5318 | French|French 21 | 1914 |1945 | 1982 |9999 | 1949 | 1949 | 1949 | teca estron 17065 | Gift of A. M Tenney Associates, Inc. and Tennessee Eastman Corporation, 1950 | http://www.metmuseum.org/art/collection/search/96121 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
75360 | 75360 | 1979.468a–c | 0 | 0 | 96694 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Designer 5 | Claire McCardell | American, 1905–1958 | McCardell Claire 5437 | American 1 | 1905 | 1958 | ca. 1956 | 1951 | 1961 | cotton, plastic 15534 | Gift of Mrs. Lee Evans, 1979 | http://www.metmuseum.org/art/collection/search/96694 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
75677 | 75677 | 1979.324.16 | 0 | 0 | 97140 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer 5 | Sonia Rykiel | French, Neuilly 1930–2016 Paris | Rykiel Sonia 5569 | French 2 | 1930 | 2016 | 1975–76 | 1975 | 1976 | cotton, vinyl (probably) 17167 | Gift of Lauren Bacall, 1979 | http://www.metmuseum.org/art/collection/search/97140 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
76649 | 76649 | 1976.118.5a, b | 0 | 0 | 98950 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | 1967 | 1967 | 1967 | cotton, synthetics 15162 | Gift of Mary Sykes Cahan, 1976 | http://www.metmuseum.org/art/collection/search/98950 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
77264 | 77264 | 2004.226 | 0 | 0 | 101442 | Asian Art 7 | Raincoat 5903 | Chinese 10 | 20th century | 1900 | 2000 | coconut 17429 | Length at CB: 20 x 25 in. (50.8 x 63.5 cm) | Gift of Christopher Phillips, 2004 | Main dress-Childrenswear 250 | http://www.metmuseum.org/art/collection/search/101442 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
79363 | 79363 | 1976.318.14a–c | 0 | 0 | 106467 | Costume Institute 8 | Raincoat 5903 | Raincoat | British 6 | Department Store 208 | Wanamaker's | American | Wanamaker's 5994 | American 1 | ca. 1905 | 1900 | 1910 | silk, cotton 15149 | Purchase, Vincente Minetti Gift, 1976 | http://www.metmuseum.org/art/collection/search/106467 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
79534 | 79534 | C.I.50.102.9 | 0 | 0 | 106787 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | 1914–20 | 1914 | 1920 | silk 15101 | Gift of Lee Carter Morse and Matthew Flesh Morse, 1950 | http://www.metmuseum.org/art/collection/search/106787 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
80381 | 80381 | 1982.276.7 | 0 | 0 | 108356 | Costume Institute 8 | Raincoat 5903 | Raincoat | Italian 36 | Designer 5 | Walter Albini | Italian, 1941–1983 | Albini Walter 6550 | Italian 6 | 1941 | 1983 | 1975 | 1975 | 1975 | cotton 3340 | Gift of Edward Villiotti, 1982 | http://www.metmuseum.org/art/collection/search/108356 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
87634 | 87634 | 1986.123 | 0 | 1 | 126431 | Asian Art 7 | Raincoat 5903 | Japanese 35 | late Edo Period | 1790–1800 | 1790 | 1800 | linen, silk, organic glaze 18635 | Length at CB: 50 in. (127 cm) | Gift of Joseph Brotherton, 1986 | Outerwear 246 | http://www.metmuseum.org/art/collection/search/126431 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
87652 | 87652 | C.I.37.53.2 | 0 | 0 | 126594 | American Decorative Arts 1 | Raincoat 5903 | Raincoat | Mexican 11 | early 20th century | 1900 | 1937 | grass 18639 | Length: 43 in. (109.2 cm) Width (top): 53 in. (134.6 cm) | Gift of Irene Lewisohn, 1937 | Outerwear 246 | http://www.metmuseum.org/art/collection/search/126594 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
89692 | 89692 | 2009.300.1028a–d | 0 | 0 | 155697 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Secondary Line|Design House 216 | Yves Saint Laurent|Yves Saint Laurent Rive Gauche|Yves Saint Laurent, Paris | French (born Algeria) Oran 1936–2008 Paris|French, founded 1966|French, founded 1961 | Saint Laurent Yves|Saint Laurent Rive Gauche Yves|Saint Laurent Yves, Paris 5445 | French|French|French 103 | 1936 |1966 |1961 | 2008 |9999 |9999 | ca. 1970 | 1968 | 1972 | cotton 3340 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Youseff Rizkallah, 1986 | http://www.metmuseum.org/art/collection/search/155697 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
90865 | 90865 | 2009.300.2086 | 0 | 0 | 156872 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | Designer 5 | Bonnie Cashin | American, Oakland, California 1908–2000 New York | Cashin, Bonnie 5876 | American 1 | 1908 | 2000 | 1961 | 1961 | 1961 | synthetic 15169 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Bonnie Cashin, 1966 | http://www.metmuseum.org/art/collection/search/156872 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
91192 | 91192 | 2009.300.2387 | 0 | 0 | 157207 | Costume Institute 8 | Raincoat 5903 | Raincoat | American 1 | 1894–98 | 1894 | 1898 | wool 15104 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. J. Pulaski, 1953 | http://www.metmuseum.org/art/collection/search/157207 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||||
93591 | 93591 | 2012.491a–d | 0 | 0 | 168279 | Costume Institute 8 | Raincoat 5903 | Raincoat | Italian 36 | Designer|Design House 202 | Miuccia Prada|Prada | Italian, born 1949|Italian, founded 1913 | Prada Miuccia|Prada 6025 | Italian|Italian 93 | 1949 |1913 | 2049 |9999 | fall/winter 2002–3 | 2002 | 2003 | synthetic, silk, leather, metal 19788 | Gift of Sharon and Richard Hurowitz, 2012 | http://www.metmuseum.org/art/collection/search/168279 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
96800 | 96800 | 2009.300.7043 | 0 | 0 | 174178 | Costume Institute 8 | Raincoat 5903 | "Storm Coat" | American 1 | Designer 5 | Bonnie Cashin | American, Oakland, California 1908–2000 New York | Cashin, Bonnie 5876 | American 1 | 1908 | 2000 | 1952 | 1952 | 1952 | Cotton, wool 16400 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Bonnie Cashin, 1958 | http://www.metmuseum.org/art/collection/search/174178 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97678 | 97678 | 2009.300.8034 | 0 | 0 | 175059 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Secondary Line|Design House 216 | Yves Saint Laurent|Yves Saint Laurent Rive Gauche|Yves Saint Laurent, Paris | French (born Algeria) Oran 1936–2008 Paris|French, founded 1966|French, founded 1961 | Saint Laurent Yves|Saint Laurent Rive Gauche Yves|Saint Laurent Yves, Paris 5445 | French|French|French 103 | 1936 |1966 |1961 | 2008 |9999 |9999 | ca. 1973 | 1972 | 1975 | Cotton, rubber, metal 20368 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1982 | http://www.metmuseum.org/art/collection/search/175059 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97709 | 97709 | 2009.300.8065a–c | 0 | 0 | 175090 | Costume Institute 8 | Raincoat 5903 | Raincoat | French 7 | Designer|Secondary Line|Design House 216 | Yves Saint Laurent|Yves Saint Laurent Rive Gauche|Yves Saint Laurent, Paris | French (born Algeria) Oran 1936–2008 Paris|French, founded 1966|French, founded 1961 | Saint Laurent Yves|Saint Laurent Rive Gauche Yves|Saint Laurent Yves, Paris 5445 | French|French|French 103 | 1936 |1966 |1961 | 2008 |9999 |9999 | ca. 1972 | 1972 | 1974 | Cotton 2154 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1983 | http://www.metmuseum.org/art/collection/search/175090 | 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");